Advanced Bans (Real Time) by Exolent - Page 128

xxxperts · 11-19-2013 , 22:46 Re: Advanced Bans (Real Time) by Exolent

if i want to get the name of admin & player name who get ban than how..to get.it..plz help i am begineer

fuegox · 11-22-2013 , 19:38 Re: Advanced Bans (Real Time) by Exolent

Hello I need Help with this Advanced bans. Since I'm getting an error and dunno how to fix it.
The problem is that when u put in my server amx_banlist , automatic the server kick u for Reliable channel overflow

My friend told me that in theory, as he can remind in this plugin was a "cvar" to specify the amount of bans that appears in amx_banlist, and set up a limit for each page to show.

So what's the cvar, and where can i add it to put a limit of 10 bans per page? Because I didnt find yet and always that i put amx_banlist kicks me..

Please ;)

ZASTRELIS · *Last edited by ZASTRELIS; 12-08-2013 at 05:28.*

I've got a problem with starting this script.

Code:

L 12/08/2013 - 18:03:30: [AMXX] Plugin ("advanced_bans.amxx") is setting itself as failed.
L 12/08/2013 - 18:03:30: [AMXX] Plugin says: Could not connect to database.
L 12/08/2013 - 18:03:30: [AMXX] Displaying debug trace (plugin "advanced_bans.amxx")
L 12/08/2013 - 18:03:30: [AMXX] Run time error 1: forced exit 
L 12/08/2013 - 18:03:30: [AMXX] [0] advanced_bans.sma::QueryCreateTable (line 404)

Added exec sql.cfg in amxx.cfg, sql.cfg has been edited, admin.sma was recompiled.
Mysql server's works properly, admin.amxx have been connected and updated his table.

Advanced Bans is not works properly!

Code:

#if defined USING_SQL
PrepareTable()
{
    new query[128];
    
    formatex(query, sizeof(query) - 1, "CREATE TABLE IF NOT EXISTS `%s` ( `%s` VARCHAR(32) NOT NULL, `%s` VARCHAR(35) NOT NULL, `%s` INT(10) NOT NULL, `%s` VARCHAR(32) NOT NULL, `%s` VARCHAR(128) NOT NULL, `%s` VARCHAR(64) NOT NULL, `%s` VARCHAR(35) NOT NULL ) COMMENT = 'Advanced Bans';", TABLE_NAME, KEY_NAME, KEY_STEAMID, KEY_BANLENGTH, KEY_UNBANTIME, KEY_REASON, KEY_ADMIN_NAME, KEY_ADMIN_STEAMID );
    
    SQL_ThreadQuery(g_sql_tuple, "QueryCreateTable", query);
}

public QueryCreateTable(failstate, Handle:query, error[], errcode, data[], datasize, Float:queuetime)
{
    if( failstate == TQUERY_CONNECT_FAILED )
    {
        set_fail_state("Could not connect to database.");
    }
    else if( failstate == TQUERY_QUERY_FAILED )
    {
        set_fail_state("Query failed.");
    }
    else if( errcode )
    {
        log_amx("Error on query: %s", error);
    }
    else
    {
        LoadBans();
    }
}
#endif

ZASTRELIS · 12-14-2013 , 04:30 Re: Advanced Bans (Real Time) by Exolent

Hey! Somebody?!

GordonFreeman (RU) · *Last edited by GordonFreeman (RU); 12-15-2013 at 00:55.*

What does this mean Could not connect to database. ?
Recheck your MySQL connection details.

al3amri · 12-17-2013 , 11:20 Re: Advanced Bans (Real Time) by Exolent

Quote:

Originally Posted by xxxperts

if i want to get the name of admin & player name who get ban than how..to get.it..plz help i am begineer

type amx_banlist in console

ZASTRELIS · 12-25-2013 , 02:14 Re: Advanced Bans (Real Time) by Exolent

Quote:

Originally Posted by ZASTRELIS

I've got a problem with starting this script.

Code:

L 12/08/2013 - 18:03:30: [AMXX] Plugin ("advanced_bans.amxx") is setting itself as failed.
L 12/08/2013 - 18:03:30: [AMXX] Plugin says: Could not connect to database.
L 12/08/2013 - 18:03:30: [AMXX] Displaying debug trace (plugin "advanced_bans.amxx")
L 12/08/2013 - 18:03:30: [AMXX] Run time error 1: forced exit 
L 12/08/2013 - 18:03:30: [AMXX] [0] advanced_bans.sma::QueryCreateTable (line 404)

Added exec sql.cfg in amxx.cfg, sql.cfg has been edited, admin.sma was recompiled.
Mysql server's works properly, admin.amxx have been connected and updated his table.

Advanced Bans is not works properly!

Code:

#if defined USING_SQL
PrepareTable()
{
    new query[128];
    
    formatex(query, sizeof(query) - 1, "CREATE TABLE IF NOT EXISTS `%s` ( `%s` VARCHAR(32) NOT NULL, `%s` VARCHAR(35) NOT NULL, `%s` INT(10) NOT NULL, `%s` VARCHAR(32) NOT NULL, `%s` VARCHAR(128) NOT NULL, `%s` VARCHAR(64) NOT NULL, `%s` VARCHAR(35) NOT NULL ) COMMENT = 'Advanced Bans';", TABLE_NAME, KEY_NAME, KEY_STEAMID, KEY_BANLENGTH, KEY_UNBANTIME, KEY_REASON, KEY_ADMIN_NAME, KEY_ADMIN_STEAMID );
    
    SQL_ThreadQuery(g_sql_tuple, "QueryCreateTable", query);
}

public QueryCreateTable(failstate, Handle:query, error[], errcode, data[], datasize, Float:queuetime)
{
    if( failstate == TQUERY_CONNECT_FAILED )
    {
        set_fail_state("Could not connect to database.");
    }
    else if( failstate == TQUERY_QUERY_FAILED )
    {
        set_fail_state("Query failed.");
    }
    else if( errcode )
    {
        log_amx("Error on query: %s", error);
    }
    else
    {
        LoadBans();
    }
}
#endif

Who know why it's not work? :\

ZASTRELIS · *Last edited by ZASTRELIS; 12-25-2013 at 02:19.*

Quote:

Originally Posted by ZASTRELIS

I've got a problem with starting this script.

Code:

L 12/08/2013 - 18:03:30: [AMXX] Plugin ("advanced_bans.amxx") is setting itself as failed.
L 12/08/2013 - 18:03:30: [AMXX] Plugin says: Could not connect to database.
L 12/08/2013 - 18:03:30: [AMXX] Displaying debug trace (plugin "advanced_bans.amxx")
L 12/08/2013 - 18:03:30: [AMXX] Run time error 1: forced exit 
L 12/08/2013 - 18:03:30: [AMXX] [0] advanced_bans.sma::QueryCreateTable (line 404)

Added exec sql.cfg in amxx.cfg, sql.cfg has been edited, admin.sma was recompiled.
Mysql server's works properly, admin.amxx have been connected and updated his table.

Advanced Bans is not works properly!

Code:

#if defined USING_SQL
PrepareTable()
{
    new query[128];
    
    formatex(query, sizeof(query) - 1, "CREATE TABLE IF NOT EXISTS `%s` ( `%s` VARCHAR(32) NOT NULL, `%s` VARCHAR(35) NOT NULL, `%s` INT(10) NOT NULL, `%s` VARCHAR(32) NOT NULL, `%s` VARCHAR(128) NOT NULL, `%s` VARCHAR(64) NOT NULL, `%s` VARCHAR(35) NOT NULL ) COMMENT = 'Advanced Bans';", TABLE_NAME, KEY_NAME, KEY_STEAMID, KEY_BANLENGTH, KEY_UNBANTIME, KEY_REASON, KEY_ADMIN_NAME, KEY_ADMIN_STEAMID );
    
    SQL_ThreadQuery(g_sql_tuple, "QueryCreateTable", query);
}

public QueryCreateTable(failstate, Handle:query, error[], errcode, data[], datasize, Float:queuetime)
{
    if( failstate == TQUERY_CONNECT_FAILED )
    {
        set_fail_state("Could not connect to database.");
    }
    else if( failstate == TQUERY_QUERY_FAILED )
    {
        set_fail_state("Query failed.");
    }
    else if( errcode )
    {
        log_amx("Error on query: %s", error);
    }
    else
    {
        LoadBans();
    }
}
#endif

Quote:

Originally Posted by GordonFreeman (RU)

What does this mean Could not connect to database. ?
Recheck your MySQL connection details.

Read post.

Look this script, maybe it isn't version for DB?)

Critfame · 12-25-2013 , 08:33 Re: Advanced Bans (Real Time) by Exolent

Quote:

Originally Posted by Exolent[jNr]

Advanced Bans (Real Time)
by Exolent

I would love to make a Bulgarian translation if I have your permission

ZASTRELIS · *Last edited by ZASTRELIS; 12-27-2013 at 07:21.*

It's original bugged script. Tested with:

Code:

mysql  Ver 14.14 Distrib 5.5.34, for debian-linux-gnu (x86_64) using readline 6.2

It's can't connect to mysql server