AlliedModders - Advanced Bans SQL

AlliedModders (https://forums.alliedmods.net/index.php)

- Off-Topic (https://forums.alliedmods.net/forumdisplay.php?f=15)

- - Advanced Bans SQL (https://forums.alliedmods.net/showthread.php?t=172241)

Advanced Bans SQL

For me to install the advanced bans sql , which have to create tables? He will take on the configuration sql.cfg?

Re: Advanced Bans SQL

What the table and what db i create?

Re: Advanced Bans SQL

It creates the table(s) for you. You should really read this (and post there).

Re: Advanced Bans SQL

Hello everyone.
I tried to use this ban system.
I encountered with the problem when using sql mode:

PHP 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);",\
        TABLE_NAME, KEY_NAME, KEY_STEAMID, KEY_BANLENGTH, KEY_UNBANTIME, KEY_REASON, KEY_ADMIN_NAME, KEY_ADMIN_STEAMID
        );
    //server_print(query);
    SQL_ThreadQuery(g_sql_tuple, "QueryCreateTable", query);
}

PHP Code:


		
			
new query[128];

is not enought to make sql create request, and server throughts "Query failed." message.
It is more meaningful to have

PHP Code:


		
			
new query[512];

Thanks

Re: Advanced Bans SQL

I have the error: Query Failed. The db, user, etc, is correct!

Re: Advanced Bans SQL

Without more information, that error can mean anything - from a corrupt table to a bug in the plugin. But like I said before, you should post it in the plugin's thread.