SELECT not work. - Printable Version

SELECT not work. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SELECT not work. (/showthread.php?tid=595645)

SELECT not work. - norton2 - 05.12.2015

The function below does not work!
To OnPlayerConnect:

Код HTML:

mysql_format(MySQLCon, query, sizeof(query), "SELECT * FROM bans WHERE IP = '%s' AND `Player` = '%e'", playerIP, GetName(playerid));
    mysql_query(MySQLCon, query);
    if(cache_num_rows())
    {
        SetTimerEx("KickPublic", 50, false, "i", playerid);
        return 1;
    }

The player is named and IP in "bans" table and but still may enter.

Re: SELECT not work. - prineside - 05.12.2015

1. Add printf( query ) and check if your query is correct
2. Make sure you have "public KickPublic()" somewhere. If is not defined anywhere, it will ignored silently.

I guess you should simply add this somewhere:

PHP код:



forward KickPublic( playerid );
public KickPublic( playerid ) {
    Kick( playerid );
}

Re: SELECT not work. - PaulDinam - 06.12.2015

pawn Код:

mysql_format(MySQLCon, query, sizeof(query), "SELECT * FROM bans WHERE IP = '%s' AND `Player` = '%e'", playerIP, GetName(playerid));
new Cache:result = mysql_query(MySQLCon, query);
if(cache_num_rows() > 0)
{
    SetTimerEx("KickPublic", 50, false, "i", playerid);
    return 1;
}
cache_delete(result);

pawn Код:

mysql_format(MySQLCon, query, sizeof(query), "SELECT * FROM bans WHERE IP = '%s' AND `Player` = '%e'", playerIP, GetName(playerid));
mysql_tquery(MySQLCon, query, "OnBanCheck", "i", playerid);


forward OnBanCheck(playerid);
public OnBanCheck(playerid)
{
    if(cache_num_rows() > 0)
    {
        SetTimerEx("KickPublic", 50, false, "i", playerid);
        return 1;
    }
    return 1;
}

Re: SELECT not work. - norton2 - 06.12.2015

Quote:

Originally Posted by PaulDinam

pawn Код:

mysql_format(MySQLCon, query, sizeof(query), "SELECT * FROM bans WHERE IP = '%s' AND `Player` = '%e'", playerIP, GetName(playerid));
new Cache:result = mysql_query(MySQLCon, query);
if(cache_num_rows() > 0)
{
    SetTimerEx("KickPublic", 50, false, "i", playerid);
    return 1;
}
cache_delete(result);

pawn Код:

mysql_format(MySQLCon, query, sizeof(query), "SELECT * FROM bans WHERE IP = '%s' AND `Player` = '%e'", playerIP, GetName(playerid));
mysql_tquery(MySQLCon, query, "OnBanCheck", "i", playerid);


forward OnBanCheck(playerid);
public OnBanCheck(playerid)
{
    if(cache_num_rows() > 0)
    {
        SetTimerEx("KickPublic", 50, false, "i", playerid);
        return 1;
    }
    return 1;
}

Thank you very much, +1 REP.