Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- new ip[16];
- new hour, minuite, second;
- new day, month, year;
- getdate(year, month, day);
- gettime(hour, minuite, second);
- GetPlayerIp(playerid, ip, 16);
- if(PlayerInfo[playerid][pEnter] == 15)
- {
- mysql_format(MySQL, mquery, 128, "SELECT * FROM "TABLE_CONNECTS" WHERE `Name` = '%s'", GetName(playerid));
- new Cache:result = mysql_query(MySQL, mquery, true);
- if(cache_num_rows() >= 15)
- {
- mysql_format(MySQL, mquery, 128, "DELETE FROM "TABLE_CONNECTS" WHERE `ID` = '0' AND `Name` = '%s' LIMIT 1", GetName(playerid));
- mysql_tquery(MySQL, mquery, "", "");
- for(new i = 0; i < cache_num_rows(); i++)
- {
- mysql_format(MySQL, mquery, 128, "UPDATE "TABLE_CONNECTS" SET `ID` = '%i' WHERE `ID` = '%i' AND `Name` = '%s' LIMIT 1",i,i+1, GetName(playerid));
- mysql_tquery(MySQL, mquery, "", "");
- }
- }
- cache_delete(result);
- }
- 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);
- mysql_tquery(MySQL, mquery, "", "");
- if(PlayerInfo[playerid][pEnter] != 15) PlayerInfo[playerid][pEnter]++;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement