Advertisement
Guest User

Untitled

a guest
Mar 26th, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 1.43 KB | None | 0 0
  1. IRCCMD:oaka(botid, channel[], user[], host[], params[]) {
  2.     if (IRC_IsOp(botid, channel, user)) {
  3.         if(isnull(params)) return IRC_GroupSay(gGroupID,channel,"57FORMAT: /oaka [Player Name / IP]");
  4.         new Query[300];
  5.         format(Query,sizeof Query,"SELECT `IP` FROM `OIP` WHERE `NAME` = '%s' OR `IP` = '%s' LIMIT 1",params,params);
  6.         new DBResult:Result = db_query(offline, Query);
  7.         if(db_num_rows(Result)) {
  8.             new ip[32];
  9.             db_get_field_assoc(Result,"IP", ip, 32);
  10.             db_free_result(Result);
  11.             format(Query,sizeof Query,"SELECT `NAME` FROM `OIP` WHERE `IP` = '%s' LIMIT 20",ip);
  12.             Result = db_query(offline, Query);
  13.             if(rows > 0)
  14.             {
  15.                 new name2[26], string[128], Handlersvemylife[ ( 20 * 26 ) + 26 + 50];
  16.                 format(string, sizeof string,"69[OFFLINE AKA] » %s's AKA is:57",params);
  17.                 strcat(Handlersvemylife, string);
  18.                 for(new i = 0; i < rows; i++)
  19.                 {
  20.                     db_get_field_assoc(Result,"NAME", name2, sizeof name2);
  21.                     db_next_row(Result);
  22.                     format(string, sizeof string,"%s,",name2);
  23.                     strcat(Handlersvemylife, string);
  24.                 }
  25.                 IRC_GroupSay(gGroupID, channel, Handlersvemylife);
  26.             }
  27.         }
  28.         else IRC_GroupSay(gGroupID, channel, "57This name/ip isn't inserted on the database!");
  29.         db_free_result(Result);
  30.     } else return IRC_GroupSay(gGroupID,channel, "57ERROR: You are must be channel operator to use this command");
  31. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement