05.05.2012, 01:26
(
Последний раз редактировалось SanAndreasVille; 05.05.2012 в 11:46.
)
Hi i have in my mysql user data a save with logging when a player spawned its set to 1 wenn it disconnect set it 0
logged = 1
logged = 0
how can i check on the onplayerconnect from the user logged = 1 when logged = 1 i want to kick the player
how can i make this?
here is my onplayer connect: now i want a logged check
in the db
in the disconnect
/code edited
logged = 1
logged = 0
how can i check on the onplayerconnect from the user logged = 1 when logged = 1 i want to kick the player
how can i make this?
here is my onplayer connect: now i want a logged check
in the db
Код:
logged INT(5)NOT NULL
Код:
public OnPlayerDisconnect(playerid,reason) { if(GetPVarInt(playerid, "Logged") == 1) { format(Query, sizeof(Query), "UPDATE `playerinfo` SET `logged` = '0' WHERE `user` = '%s'", ); mysql_query(Query); }
Код:
public OnPlayerConnect(playerid) { bancheck(playerid); GetPlayerIp(playerid, PIP, 18); format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s' LIMIT 1", escpname(playerid), PIP); mysql_query(Query); mysql_store_result(); if(mysql_num_rows() != 0) { new PIP2[18]; mysql_fetch_field_row(PIP2, "IP"); if(!strcmp(PIP, PIP2, true) && strlen(PIP2) != 0) { SetPVarInt(playerid, "Logged", 1); SendClientMessage(playerid, 0x009600AA, "Auto Logged in!"); if(mysql_fetch_row(line)) { new data[3][55]; new data2[5]; sscanf(line, "p<|>s[50]s[300]dddds[50]ds[100]", data[0], largestring, data2[0], data2[1], data2[2], data2[3], data[2], data2[4], estring); stringempty(estring); stringempty(largestring); SetPVarInt(playerid, "Kills", data2[0]); SetPVarInt(playerid, "Logged", 1); SetPVarInt(playerid, "Deaths", data2[1]); SetPlayerScore(playerid, data2[2]); GivePlayerMoney(playerid, data2[3]); SetPVarInt(playerid, "AdminLevel", data2[4]); mysql_free_result(); } } else { SendClientMessage(playerid, 0x009600AA, "This account is registered, please login"); ShowPlayerDialog(playerid, 15000, DIALOG_STYLE_INPUT , "Login", "This account is registered, please login", "OK", "Cancel"); } } else { ShowPlayerDialog(playerid, 14600, DIALOG_STYLE_INPUT , "Register", "This account is not registered, please register!", "OK", "Cancel"); SendClientMessage(playerid, 0x009600AA, "This account is not registered, please register!"); } mysql_free_result(); return 1; }