[ben4uka]

Код:

	if(mysql_num_rows() > 0)
	{
 		SendClientMessage(playerid, red, " • ~ _ ~ SAMP-IL Stunts ~ _ ~ •");
	    SendClientMessage(playerid, yellow, "You are banned from this server.");

	    format(query, 1024, "SELECT `BannedBy` FROM `users` WHERE `Nick` = '%s'", GetName(playerid));
	    mysql_query(query);
     	new string2[256], string3[256];
   		new buffer[60];
    	mysql_fetch_field_row(buffer,  "BannedBy");
    	format(string3,256,"%s",buffer);
    	new buffer2[60];
    	mysql_fetch_field_row(buffer2,  "BannedBy");
    	format(string2,256,"%s",buffer2);
    	format(string, 256, "Admin Name: %s. Reason: %s", buffer, buffer2);
    	SendClientMessage(playerid, red, string);
    	SendClientMessage(playerid, red, " • ~ _ ~ SAMP-IL Stunts ~ _ ~ •");
    	Kick(playerid);
	}

if banned = 1 it isn't giving me kick..

help?

[MadeMan]

Show more code.

[ben4uka]

full code:

Код:

	format(query, 1024, "SELECT `Banned` FROM `users` WHERE `Nick` = '%s' OR `Ip` = '%s'", GetName(playerid), GetIPAddress(playerid));
    mysql_query(query);

	if(mysql_num_rows() > 0)
	{
 		SendClientMessage(playerid, red, " • ~ _ ~ SAMP-IL Stunts ~ _ ~ •");
	    SendClientMessage(playerid, yellow, "You are banned from this server.");

	    format(query, 1024, "SELECT `BannedBy` FROM `users` WHERE `Nick` = '%s'", GetName(playerid));
	    mysql_query(query);
     	new string2[256], string3[256];
   		new buffer[60];
    	mysql_fetch_field_row(buffer,  "BannedBy");
    	format(string3,256,"%s",buffer);
    	new buffer2[60];
    	mysql_fetch_field_row(buffer2,  "BannedBy");
    	format(string2,256,"%s",buffer2);
    	format(string, 256, "Admin Name: %s. Reason: %s", buffer, buffer2);
    	SendClientMessage(playerid, red, string);
    	SendClientMessage(playerid, red, " • ~ _ ~ SAMP-IL Stunts ~ _ ~ •");
    	Kick(playerid);
	}

[MadeMan]

Add mysql_store_result and mysql_free_result

pawn Код:

format(query, 1024, "SELECT `Banned` FROM `users` WHERE `Nick` = '%s' OR `Ip` = '%s'", GetName(playerid), GetIPAddress(playerid));
    mysql_query(query);
    mysql_store_result();

    if(mysql_num_rows() > 0)
    {
        SendClientMessage(playerid, red, " • ~ _ ~ SAMP-IL Stunts ~ _ ~ •");
        SendClientMessage(playerid, yellow, "You are banned from this server.");

        mysql_free_result();
        format(query, 1024, "SELECT `BannedBy` FROM `users` WHERE `Nick` = '%s'", GetName(playerid));
        mysql_query(query);
        mysql_store_result();
        new string2[256], string3[256];
        new buffer[60];
        mysql_fetch_field_row(buffer,  "BannedBy");
        format(string3,256,"%s",buffer);
        new buffer2[60];
        mysql_fetch_field_row(buffer2,  "BannedBy");
        format(string2,256,"%s",buffer2);
        format(string, 256, "Admin Name: %s. Reason: %s", buffer, buffer2);
        SendClientMessage(playerid, red, string);
        SendClientMessage(playerid, red, " • ~ _ ~ SAMP-IL Stunts ~ _ ~ •");
        Kick(playerid);
        mysql_free_result();
    }

[ben4uka]

working, but now if banned = 0 it's still kicking me.

[MadeMan]

Change this

pawn Код:

if(mysql_num_rows() > 0)

to

pawn Код:

if(mysql_fetch_int() == 1)

[ben4uka]

thanks but alredy done with this xD