Problem with mysql ban loading
#1

Hello i have problem with mysql ban checking i tried some code from this forum but still didnt work and my mysql connect work but checking not btw sorry for my english

PHP код:
public OnPlayerConnect(playerid)
{
    new 
query[256];
    
format(query,sizeof(query),"SELECT * FROM Bans WHERE PlayerName='%s' or IP='%s'",Name(playerid),IP);
    
mysql_query(handle,query);
    if(
cache_num_rows() > 0)
    {
        
        
cache_get_value_name_int(0"Time"time);
        
cache_get_value_name(0"Admin"admin);
        
cache_get_value_name(0"PlayerName"pname);
        
cache_get_value_name(0"Reason"string1);
        
printf("%d %s %s %s",time,admin,pname,string1);
        new 
string[50], str[50], str1[100], str2[100];
        
format(stringsizeof(string),"By Admin: %s"admin);
        
format(strsizeof(str),"banned account: %s"pname);
        
format(str1sizeof(str1),"reason: %s"string1);
        
format(str1sizeof(str2),"when: %d timestamp"time);
        
SendClientMessage(playeridADMIN_COLOR,"you are banned");
        
SendClientMessage(playeridADMIN_COLORstr);
        
SendClientMessage(playeridADMIN_COLORstring);
        
SendClientMessage(playeridADMIN_COLORstr1);
        
SendClientMessage(playeridADMIN_COLORstr2);
        
KickPlayer(playerid);
    } 
Reply
#2

okay sorry i know where is problem thank you for reading
Reply
#3

Are you using ban system with R40+ mysql plugin? (https://github.com/pBlueG/SA-MP-MySQL/releases)
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)