Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2017
464
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 0.67 KB | None | 0 0
  1. COMMAND:updateraport(playerid, params[])
  2. {
  3.         if(PlayerInfo[playerid][pAdmin] || PlayerInfo[playerid][pSupport])
  4.         {
  5.             new string[MAXO_TEXT];
  6.             mysql_tquery(connectionHandle, "SELECT `id` FROM `players` WHERE `Member` > 0", "InsereazaDateRaport");
  7.         }
  8.         return 1;
  9. }
  10.  
  11. function InsereazaDateRaport()
  12. {
  13.     new rows = cache_num_rows();
  14.     for(new i; i < rows; i++)
  15.     {
  16.         new
  17.             string[MAXO_TEXT], idptfactiune;
  18.         cache_get_row(i, 0, idptfactiune, .max_len = 10);
  19.         format(string, sizeof(string), "INSERT INTO ActivityReport (PlayerSQLID) VALUES (%d)", idptfactiune);
  20.         mysql_tquery(connectionHandle, string, "NoReturnThread", "d", UPDATE_THREAD_ID1);
  21.     }
  22.     return 1;
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement