[EvolDay]

I have a request, could someone make a php page that you can view all the bans on a website for the sql version of this? Maybe even add bans through it too.

[rumbeto]

Look some pages back. There is posted a php page.

[Spicy]

Hi, I'm having some troubles with the SQL version I have tried the newer version of the plugin, but I keep getting a bad load I don't know why.

Here is the list of plugins and modules on the server:

] meta list
Currently running plugins:
[ 1] AMX Mod X, v1.8.1.3746, Aug 16 2008, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 2] Engine, v1.8.1.3746, Aug 16 2008, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 3] MySQL, v1.8.1.3746, Aug 16 2008, by AMX Mod X Dev Team, see http://www.amxmodx.org/
3 plugins
] amx_plugins
----- Currently loaded plugins -----
name version author file status
Advanced Bans 0.8 Exolent advanced_bans.a running
Advanced Bans 0.8 Exolent advanced_bans_s error
Admin Base 1.8.1.3746 AMXX Dev Team admin.amxx running
Admin Commands 1.8.1.3746 AMXX Dev Team admincmd.amxx running
Admin Help 1.8.1.3746 AMXX Dev Team adminhelp.amxx running
Slots Reservation 1.8.1.3746 AMXX Dev Team adminslots.amxx running
Multi-Lingual Sys 1.8.1.746 AMXX Dev Team multilingual.am running
Menus Front-End 1.8.1.3746 AMXX Dev Team menufront.amxx running
Commands Menu 1.8.1.3746 AMXX Dev Team cmdmenu.amxx running
Players Menu 1.8.1.3746 AMXX Dev Team plmenu.amxx running
10 plugins, 9 running
----- Entries 1 - 10 of 23 -----
----- Use 'amx_plugins 11' for more -----
EatSleepRace died
Scoring will not start until both teams have players
Scoring will not start until both teams have players
EatSleepRac is joining the Terrorist force
Scoring will not start until both teams have players
] amx_plugins 21
----- Currently loaded plugins -----
name version author file status
TimeLeft 1.8.1.3746 AMXX Dev Team timeleft.amxx running
Pause Plugins 1.8.1.3746 AMXX Dev Team pausecfg.amxx running
Stats Configurati 1.8.1.3746 AMXX Dev Team statscfg.amxx running
3 plugins, 3 running
----- Entries 21 - 23 of 23 -----
----- Use 'am_plugins 1' for begin -----

] amx_modules
Currently loaded modules:
name version author status
Engine 1.8.1.3746 AMX Mod X Dev Team running
RegEx 1.8.1.3746 AMX Mod X Dev Team running
MySQL 1.8.1.3746 AMX Mod X Dev Team running
3 modules

Anybody have an idea on what I'm doing wrong here?

[CyberMaN]

I've gone through the whole topic and taken the latest plugin that was tested by alexinno on page #40 posts #393, #394, but I still get these errors:

L 08/01/2009 - 13:04:55: [AMXX] Plugin ("advanced_bans_sql.amxx") is setting itself as failed.
L 08/01/2009 - 13:04:55: [AMXX] Plugin says: Could not connect to database.
L 08/01/2009 - 13:04:55: [AMXX] Displaying debug trace (plugin "advanced_bans_sql.amxx")
L 08/01/2009 - 13:04:55: [AMXX] Run time error 1: forced exit
L 08/01/2009 - 13:04:55: [AMXX] [0] 42994.attach::QueryCreateTable (line 430)


I can connect normally with the credentials specified in sql.cfg.

advanced_bans_sql.amxx is at the top of the plugins file, and sql.cfg looks like this:

amx_sql_host "localhost"
amx_sql_user "****"
amx_sql_pass "****"
amx_sql_db "csbans"
//amx_sql_table "admins"
amx_sql_type "mysql"

Any brainstorming?

Regards,

James.

[mplayerexe]

What is the cvar to change if u want to ban by ip or Steamid ?

[Grozz]

plugin detects if your argument is ip or steamid by using regex, no cvar needed afaik

[CyberMaN]

bump

[alexinno]

Originally Posted by CyberMaN I've gone through the whole topic and taken the latest plugin that was tested by alexinno on page #40 posts #393, #394, but I still get these errors: L 08/01/2009 - 13:04:55: [AMXX] Plugin ("advanced_bans_sql.amxx") is setting itself as failed. L 08/01/2009 - 13:04:55: [AMXX] Plugin says: Could not connect to database. L 08/01/2009 - 13:04:55: [AMXX] Displaying debug trace (plugin "advanced_bans_sql.amxx") L 08/01/2009 - 13:04:55: [AMXX] Run time error 1: forced exit L 08/01/2009 - 13:04:55: [AMXX] [0] 42994.attach::QueryCreateTable (line 430)

is your cstrike server and mysql server on the same PC ?
linux or windows ?
did you tried "127.0.0.1" instead of "localhost" ?

[CyberMaN]

Server and mysql are on the same pc, it's linux Ubuntu, and I tried both of those options. I can also connect perfectly using those credentials, so they are tested.

Thanks for your reply.

Regards,

James.

[alexinno]

Originally Posted by CyberMaN Server and mysql are on the same pc, it's linux Ubuntu, and I tried both of those options. I can also connect perfectly using those credentials, so they are tested. Thanks for your reply. Regards, James.

no problem
it's recommended using your server IP address instead of its name so use "127.0.0.1" instead of "localhost"

it's working now ? or the only plugin that it's not working (connecting to database) is advanced bans ?
maybe you could try to see if you get the same error with admin_sql.amxx instead of admin.amxx that way you'll know if your problem is with this plugin or your database/mysql server