[MAUGHOLD]

QUESTION: The plugin creates the table when it connects to the database for the first time correct ?

After I restart my server, it says its running, but then about 3 minutes later, it says it cannot connect to the database and the plugin is no longer running and has failed.

[Exolent[jNr]]

Originally Posted by MAUGHOLD QUESTION: The plugin creates the table when it connects to the database for the first time correct ?

It executes "CREATE TABLE IF NOT EXISTS..." query each map start.

[eruffini]

Originally Posted by MAUGHOLD QUESTION: The plugin creates the table when it connects to the database for the first time correct ? After I restart my server, it says its running, but then about 3 minutes later, it says it cannot connect to the database and the plugin is no longer running and has failed.

There's more than one plugin - I remember testing/compiling 3 different ones that Exolent posted until I found the one that works.

Do you need me to put it on a fileserver for you? The one I have works flawlessly.

Also, Exolent - I could write a short tutorial explaining how to enable the "TIMESTAMP" function in a MySQL table, if you would like. It's what I use.

[MAUGHOLD]

Originally Posted by eruffini There's more than one plugin - I remember testing/compiling 3 different ones that Exolent posted until I found the one that works. Do you need me to put it on a fileserver for you? The one I have works flawlessly. Also, Exolent - I could write a short tutorial explaining how to enable the "TIMESTAMP" function in a MySQL table, if you would like. It's what I use.

I have tried three different versions so far, and none of them are able to connect to the database.

I have tried Exolent's version, the threaded version and ToxedVirus's versions.

I have checked and rechecked all variables for installing this plugin at least 10 times on both the game server and my web host.

I have also tried using the web hosting account that nfoservers.com gives their customers, and it won't connect to that Mysql database either.

With so many posts by other people having trouble getting it to connect to their Mysql databases, it has to be the plugin.

I won't waste any more of my time on it.

In the future, I think that all subsequent versions or revisions of any plugins, should be linked to the original authors post, so that people don't have to waste their time reading 62 pages just to troubleshoot a bugged plugin.

Eruffini, I would be interested in using beyond compare just to see what the difference in code is compared with all the other versions. You can email it to me at webmaster(at)xtroop(d0t)net
thanks.

[eruffini]

Originally Posted by MAUGHOLD I have tried three different versions so far, and none of them are able to connect to the database. I have tried Exolent's version, the threaded version and ToxedVirus's versions. I have checked and rechecked all variables for installing this plugin at least 10 times on both the game server and my web host. I have also tried using the web hosting account that nfoservers.com gives their customers, and it won't connect to that Mysql database either. With so many posts by other people having trouble getting it to connect to their Mysql databases, it has to be the plugin. I won't waste any more of my time on it. In the future, I think that all subsequent versions or revisions of any plugins, should be linked to the original authors post, so that people don't have to waste their time reading 62 pages just to troubleshoot a bugged plugin. Eruffini, I would be interested in using beyond compare just to see what the difference in code is compared with all the other versions. You can email it to me at webmaster(at)xtroop(d0t)net thanks.

Email'ed to you, but honestly.. it is here in the forum post somewhere. I know because I downloaded it here. I would look for it, but I have to run to work right now so I will have to look for it later on today.

Let me know how that works out for you. If it doesn't work, I am not sure what you are doing wrong but I might be able to help.

[musicbg91]

I've try anything but it doesn't works with the ban commands!I mean i do this:

amx_addbanlimit "d" "10080"

and this:

amx_addbanlimit "a" "0"

but it doesnt work,and it says in the console

[AdvancedBans] Target has not authorized with the server! Unable to ban!

[Exolent[jNr]]

Originally Posted by musicbg91 but it doesnt work,and it says in the console

Do you have Non-Steam players in your server?

[MAUGHOLD]

Originally Posted by WaPu hi! Got the same error, and here is the solution: 1. Load the advanced_bans_sql.sma (source code) 2. Open it with an Editor (e.g. Notepad++) 3. Change Line 389 to: new query[512]; 4. Save, compile, enjoy! The Problem is, that the var query has original only the size of 128, but this is to short for the sql-query! 512 is enough (if not, make it higher!) Problem could be on 4 other places: Line 1041 Line 1201 Line 1273 Line 1372 bb WaPu

Exolent, why don't you add this to you're original version of this plugin ?

[neverminde]

I cant find solution for my problem
I have irc chat-logging ( with steamid of speakers)
When i see when somebody spam at my server and leave, i am joining and write this

amx_addban PLAYER STEAM_0:0:1157909354 0 SPAM

But I see this

Invalid SteamID!
Correct format: STEAM_0:X:XXXXXXX

I think it happens, because that busters have cracked steam .

[xPaw]

Originally Posted by neverminde I cant find solution for my problem I have irc chat-logging ( with steamid of speakers) When i see when somebody spam at my server and leave, i am joining and write this amx_addban PLAYER STEAM_0:0:1157909354 0 SPAM But I see this Invalid SteamID! Correct format: STEAM_0:X:XXXXXXX I think it happens, because that busters have cracked steam .

Because are you non-steamer. Such steamids do not exist.