Select one or more from mysql db
#4

Is this what you're looking for?

PHP код:
public OnPlayerConnect(playerid)
{
    new 
query[200]; 
    
mysql_format(Databasequerysizeof query"SELECT * FROM `users` WHERE `IP` = '%e'"PlayerIP[playerid]);  
    
mysql_tquery(Databasequery"MultiAccountCheck""i"playerid);     
    return 
1;
}
forward MultiAccountCheck(playerid); 
public 
MultiAccountCheck(playerid

    new 
string[256];  
    for(new 
icache_num_rows(); i++)
    { 
        if(
cache_num_rows() >= 2)
        {
            
TogglePlayerSpectating(playeridtrue);
            
Dialog_Close(playerid);
            
format(stringsizeof(string), "{FFFFFF}You already have {AA3333}%d accounts{FFFFFF} registred on our database with the actual IP: {AA3333}(%s)"cache_num_rows()-1PlayerIP[playerid]);
            
// KickEx(playerid);
            
Dialog_Show(playeridMULTIACCOUNT_KICKDIALOG_STYLE_MSGBOX"Multi-account detected"string"OK"""); 
        }
    }
    return 
1

This is a snippet from my actual gamemode.
Reply


Messages In This Thread
Select one or more from mysql db - by ShadowMortar - 28.10.2018, 18:54
Re: Select one or more from mysql db - by v1k1nG - 28.10.2018, 18:55
Re: Select one or more from mysql db - by ShadowMortar - 28.10.2018, 19:14
Re: Select one or more from mysql db - by TheToretto - 28.10.2018, 19:28
Re: Select one or more from mysql db - by ShadowMortar - 28.10.2018, 20:58

Forum Jump:


Users browsing this thread: 3 Guest(s)