[SauceHelmet07]

Originally Posted by PharaohsPaw what i mean about database configuration not correct -- make sure you have specified the correct info in the "admintools" section of databases.cfg. correct username and password, correct db name, correct hostname, etc. Are you successfully using any other sourcemod plugins on your server(s) that utilize a mysql database?

The info in the databases.cfg matches what's put in the config.php for the web panel (which is working wonderfully btw), except for localhost which was changed to my domain and the game servers IP was granted access to the mysql db.

And yes, my game servers are utilizing several other plugins that require a mysql db (such as sourcebans), thus I'm pretty perplexed as to why this isn't working.

Databases.cfg examples:

"sourcebans"
{
"driver" "mysql"
"host" "mysite.com"
"database" "sourcebans"
"user" "sourcebans"
"pass" "********"
//"timeout" "0"
"port" "3306"
}

"adsql"
{
"driver" "mysql"
"host" "mysite.com"
"database" "adsql"
"user" "adsql"
"pass" "********"
//"timeout" "0"
"port" "3306"
}

Any ideas?

[PharaohsPaw]

looks like you have the wrong name for the database config section. The instructions tell you it needs to be named admintools, not adsql.

[PharaohsPaw]

i would have rather named it adsql, trust me, but I wanted to make it easy for existing users of the old broken plugin to switch to mine.

[PharaohsPaw]

Originally Posted by SauceHelmet07 Databases.cfg examples: "adsql" <------------------------- SHOULD BE "admintools" { "driver" "mysql" "host" "mysite.com" "database" "adsql" "user" "adsql" "pass" "********" //"timeout" "0" "port" "3306" } Any ideas?

[PharaohsPaw]

code snip from the plugin source code:

        // The databases.cfg section we read our config from --
        // I could change this but we want to make it easy for
        // existing users of the sm_adsmysql plugin to switch:

        SQL_TConnect(DBConnect, "admintools")

}

[PharaohsPaw]

will add a section to the FAQ/troubleshooting post about database errors and configuration problems

[SauceHelmet07]

doh! That did the trick, no more errors. Do I have to type sm_reloadads every time I make changes to the ads or will they update on map change? Thanks for the help.

[PharaohsPaw]

good, glad to hear it. Ads will be reloaded on every map change. If you want to reload them sooner use one of the reloadads facilities (menu, command, etc.)

[SauceHelmet07]

hmm, for some reason the ads won't appear in-game.

The plugin is loaded:
"AdsQL Advertisements System" (1.7.2) by PharaohsPaw, <eVa>Dog & DJ Tsunami

I have a few ads set for testing that go to the server ID: http://i.imgur.com/RrV3d.png

I also added another that went to All.

I defined
adsql_interval 30
in the sourcemod.cfg

No idea what the issue could be... what am I overlooking?

[PharaohsPaw]

give me a few minutes I am going to check that I did not 'break' something in the ads display timers when a non-default adsql_interval is set.

based on that ad definition you gave the image of, the ad *SHOULD* work on any counterstrike source server using a server id of "bob".

PharaohsPaw