Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2018
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  1. new ip[16];
  2. new hour, minuite, second;
  3. new day, month, year;
  4. getdate(year, month, day);
  5. gettime(hour, minuite, second);
  6. GetPlayerIp(playerid, ip, 16);
  7.  
  8. if(PlayerInfo[playerid][pEnter] == 15)
  9. {
  10. mysql_format(MySQL, mquery, 128, "SELECT * FROM "TABLE_CONNECTS" WHERE `Name` = '%s'", GetName(playerid));
  11. new Cache:result = mysql_query(MySQL, mquery, true);
  12.  
  13. if(cache_num_rows() >= 15)
  14. {
  15. mysql_format(MySQL, mquery, 128, "DELETE FROM "TABLE_CONNECTS" WHERE `ID` = '0' AND `Name` = '%s' LIMIT 1", GetName(playerid));
  16. mysql_tquery(MySQL, mquery, "", "");
  17.  
  18. for(new i = 0; i < cache_num_rows(); i++)
  19. {
  20. mysql_format(MySQL, mquery, 128, "UPDATE "TABLE_CONNECTS" SET `ID` = '%i' WHERE `ID` = '%i' AND `Name` = '%s' LIMIT 1",i,i+1, GetName(playerid));
  21. mysql_tquery(MySQL, mquery, "", "");
  22. }
  23. }
  24. cache_delete(result);
  25. }
  26.  
  27. mysql_format(MySQL, mquery, sizeof(mquery), "INSERT INTO "TABLE_CONNECTS" (ID, Name, IP, Date, Time) VALUES ('%i', '%e', '%e', '%d.%d.%d', '%02d:%02d:%02d')", PlayerInfo[playerid][pEnter], GetName(playerid), ip, day, month, year, hour, minuite, second);
  28. mysql_tquery(MySQL, mquery, "", "");
  29.  
  30. if(PlayerInfo[playerid][pEnter] != 15) PlayerInfo[playerid][pEnter]++;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement