Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. mysql_format(MySQL, mquery, 128, "SELECT * FROM "TABLE_CONNECTS" WHERE `Name` = '%s'", GetName(playerid));
  2. new Cache:result = mysql_query(MySQL, mquery, true);
  3.  
  4. mysql_format(MySQL, mquery, 128, "DELETE FROM "TABLE_CONNECTS" WHERE `ID` = '0' LIMIT 1");
  5. mysql_tquery(MySQL, mquery, "", "");
  6.  
  7. for(new i = 0; i < cache_num_rows(); i++)
  8. {
  9. mysql_format(MySQL,mquery,128,"UPDATE `ID` = '%i' WHERE `ID` = '%i' LIMIT 1",i,i+1);
  10. mysql tquery(MySQL,mquery, "","");
  11. }
  12.  
  13. cache_delete(result);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement