Mysql Login Check
#1

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
Код:
logged INT(5)NOT NULL
in the disconnect

Код:
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;
}
/code edited
Reply
#2

Why do you want to kick them for having logged value 1 when they connect, when you set it to 0, when they disconnect? The point i am failing to establish.
Reply
#3

no i have 2 servers and 1 mysql database with the same script
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)