[Gachl]

I'm getting the following error on startup:

L 06/23/2009 - 12:46:33: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 06/23/2009 - 12:46:33: [SM] Displaying call stack trace for plugin "sm_adsmysql.smx":
L 06/23/2009 - 12:46:33: [SM]   [0]  Line 516, /home/groups/alliedmodders/forums/files/2/4/5/7/3/38158.attach::Admin_ReloadAds()

Still, the addon connects to the database and gets all ads correctly.

[sm_adsmysql.smx] AdsMYSQL - Connected Successfully to Database

This error isn't preventing the server to run correctly, but still, it shows up, and I want to keep my logs error-clean.
Suggestions?

[colwulf]

Hey Strom,
For some reason i went to add a additional advert but the system will not let me it just refreshed the screen with no update to it... is this a known issue and if so how do i fix...

http://the-enforcers.net/adverts/

[strontiumdog]

@Colwulf: Oh...I've seen that happen. If there has been an ad, but it was later deleted, it confuses the ordering sometimes.

To fix it, click the little green arrows and move the top ads down or if that doesn't help, go into the database itself, and fix the numbering.

@Gachl: Very strange. It's connecting OK, but the plugin can't talk to the DB? I would check your settings. It sounds like it's connecting to a database but not able to find the tables.

[DontWannaName]

So the images and everything works fine but for some reason its not letting me change the order of the ads. It refreshes the page but nothing its moved, it goes to process data php.

[Gachl]

Originally Posted by strontiumdog @Gachl: Very strange. It's connecting OK, but the plugin can't talk to the DB? I would check your settings. It sounds like it's connecting to a database but not able to find the tables.

nono, the plugin works fine, it fetches all ads from the database and adds them to the cycle and displays everything, it's just that theres an annoying error message..

[Evaldas]

I have a question about non Latin characters. Is there a way to use „Ą Č Ę Ė Į Š Ų Ž“ in game? Or… should I convert database to utf8_bin?

[Crypt1cMayh3m]

There is a bug in the ads_edit.php file which does not allow setting an advertisement to be Counterstrike:Source only.

Line 87:

<tr><td>CounterStrike Source</td><td><input type="radio" name="editgame" value="tf" <?php if ($addetails['game'] == "cstrike") echo "CHECKED"; ?>></td></tr>

This needs to be changed to:

<tr><td>CounterStrike Source</td><td><input type="radio" name="editgame" value="cstrike" <?php if ($addetails['game'] == "cstrike") echo "CHECKED"; ?>></td></tr>

[VoGon]

Nice catch, changed mine to cstrike too.

[Crypt1cMayh3m]

This plugin is awesome. It will make managing our servers so much easier. The only issue I have is that our admins do not have access to the sm_reloadads command. Is this because they are set up as part of admin groups and do not have the reserved slot flag at the user level?

[Gmbrdilos]

It would be really awesome if this was integrated with this http://forums.alliedmods.net/showthread.php?t=60174