Monthly Target: $400 Donations: $18
 4% 

Advanced Bans SQL


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
kramesa
Veteran Member
Join Date: Feb 2011
Location: Brazil
Old 11-17-2011 , 17:23   Advanced Bans SQL
Reply With Quote #1

For me to install the advanced bans sql , which have to create tables? He will take on the configuration sql.cfg?
__________________
kramesa is offline
Sn!ff3r
Veteran Member
Join Date: Aug 2007
Location: Poland
Old 11-17-2011 , 19:30   Re: Advanced Bans SQL
Reply With Quote #2

Yes.
__________________
Join US - custom Zombie Server - Custom Addons:



Sn!ff3r is offline
Send a message via Skype™ to Sn!ff3r
kramesa
Veteran Member
Join Date: Feb 2011
Location: Brazil
Old 11-18-2011 , 16:04   Re: Advanced Bans SQL
Reply With Quote #3

What the table and what db i create?
__________________
kramesa is offline
8088
Veteran Member
Join Date: Jan 2008
Old 11-18-2011 , 18:40   Re: Advanced Bans SQL
Reply With Quote #4

It creates the table(s) for you. You should really read this (and post there).
__________________
steamID converter with OpenSearch browser plugin
8088 is offline
MM3
Zero Posts
Join Date: Dec 2011
Old 12-04-2011 , 08:05   Re: Advanced Bans SQL
Reply With Quote #5

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(querysizeof(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_NAMEKEY_NAMEKEY_STEAMIDKEY_BANLENGTHKEY_UNBANTIMEKEY_REASONKEY_ADMIN_NAMEKEY_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

Last edited by MM3; 12-04-2011 at 08:07.
MM3 is offline
kramesa
Veteran Member
Join Date: Feb 2011
Location: Brazil
Old 01-12-2012 , 20:45   Re: Advanced Bans SQL
Reply With Quote #6

I have the error: Query Failed. The db, user, etc, is correct!
__________________
kramesa is offline
8088
Veteran Member
Join Date: Jan 2008
Old 01-12-2012 , 21:03   Re: Advanced Bans SQL
Reply With Quote #7

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.
__________________
steamID converter with OpenSearch browser plugin
8088 is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:25.


Powered by vBulletin®
Copyright ©2000 - 2015, vBulletin Solutions, Inc.
Theme made by Freecode