BAN [+REP] - Printable Version

BAN [+REP] - 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: BAN [+REP] (/showthread.php?tid=560718)

BAN [+REP] - norton2 - 30.01.2015

Receive a error!

Код HTML:

error 017: undefined symbol "mysql_fetch_int"

Код HTML:

new banquery[180], ip[16];
	GetPlayerIp(playerid, ip, 16);
	format(banquery, sizeof(banquery), "SELECT unban_time FROM `bans` WHERE ip = '%s'", ip);
    mysql_query(banquery);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        new unbantimestamp = mysql_fetch_int();
        if(unbantimestamp > gettime())
        {
            KickWithMessage(playerid, COLOR_LIGHTRED2, "You're banned from this server.");
        }
    }

Use MYSQL R34

Re: BAN [+REP] - HydraHumza - 30.01.2015

Quote:

Originally Posted by norton2

Receive a error!

Код HTML:

error 017: undefined symbol "mysql_fetch_int"

Код HTML:

new banquery[180], ip[16];
	GetPlayerIp(playerid, ip, 16);
	format(banquery, sizeof(banquery), "SELECT unban_time FROM `bans` WHERE ip = '%s'", ip);
    mysql_query(banquery);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        new unbantimestamp = mysql_fetch_int();
        if(unbantimestamp > gettime())
        {
            KickWithMessage(playerid, COLOR_LIGHTRED2, "You're banned from this server.");
        }
    }

Use MYSQL R34

Код HTML:

new banquery[180], ip[16];
	GetPlayerIp(playerid, ip, 16);
	format(banquery, sizeof(banquery), "SELECT unban_time FROM `bans` WHERE ip = '%s'", ip);
    mysql_query(banquery);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        new unbantimestamp = mysql_fetch_row_format();
        if(unbantimestamp > gettime())
        {
            KickWithMessage(playerid, COLOR_LIGHTRED2, "You're banned from this server.");
        }
    }

Try this

Re: BAN [+REP] - norton2 - 30.01.2015

Error:

Код HTML:

(2202) : warning 202: number of arguments does not match definition

Line:

Код HTML:

new unbantimestamp = mysql_fetch_row_format();

Re: BAN [+REP] - HydraHumza - 30.01.2015

PHP код:



new banquery[180], ip[16];

    GetPlayerIp(playerid, ip, 16);

    format(banquery, sizeof(banquery), "SELECT unban_time FROM `bans` WHERE ip = '%s'", ip);

    mysql_query(banquery);

    mysql_store_result();

    if(mysql_num_rows() != 0)

    {

        if(mysql_fetch_row_format(banquery)

        {


            KickWithMessage(playerid, COLOR_LIGHTRED2, "You're banned from this server.");

        }

    }  

    mysql_free_result();

    return 1;

}

try this?

Re: BAN [+REP] - norton2 - 30.01.2015

Код HTML:

error 035: argument type mismatch (argument 1)

Line:

Код HTML:

mysql_free_result();

Re: BAN [+REP] - HydraHumza - 30.01.2015

Quote:

Originally Posted by norton2

Код HTML:

error 035: argument type mismatch (argument 1)

Line:

Код HTML:

mysql_free_result();

remove this and check