[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

[HydraHumza]

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

[norton2]

Error:

Код HTML:

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

Line:

Код HTML:

new unbantimestamp = mysql_fetch_row_format();

[HydraHumza]

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?

[norton2]

Код HTML:

error 035: argument type mismatch (argument 1)

Line:

Код HTML:

mysql_free_result();

[HydraHumza]

Quote:

Originally Posted by norton2 Код HTML: error 035: argument type mismatch (argument 1) Line: Код HTML: mysql_free_result();

remove this and check