[strontiumdog]

Originally Posted by Sgt-Mess Can you use this to relay only certain messages of advertisements with the MySql to all your servers, and at the same time still use the single server version. I only as this because I think it would be a great feature, because some servers might have adverts for things other servers on your database might not need. Like things from css, that wouldn't be on for say a team fortress 2 server.

I don't know about using it at the same time as the single server version - there's no reason why it shouldn't work.

As for this version - you can set it so, say, all the TF2 servers, have one type of ad (e.g. a sign up for a competition in TF2) and then none of the other games (such as CSS) see it.

I'm currently working on a version for my own community that targets individual servers...

[SuperShadow]

Originally Posted by strontiumdog I'm currently working on a version for my own community that targets individual servers...

Now you'll have to release it when it's done or suffer a similar hounding...

Thanks for this and the next version Strontiumdog!

[colwulf]

SWEET YOU GOTR MY PM... DUDE YOUR AWSOME!!!! that is all i can say also love your site...... what you have done with it is sweet!!!

[colwulf]

ok i appologise i am getting a error when running the plugin... see below..

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

when i attempt to recompile i get the follwoing

//// sm_adsmysql.sp
//  internal error

Press enter to exit..

i am running sm 1.1.0 and mm 1.7

[Icettiflow]

SD - Can this be integrated into the login for the mute/silence/gag list that you released as you have on your site?

[strontiumdog]

@Colwulf: It's not getting connected to the database. Check passwords/users/database names.....

[strontiumdog]

Originally Posted by Icettiflow SD - Can this be integrated into the login for the mute/silence/gag list that you released as you have on your site?

Yup.
Now you're gonna turn round and ask me to do this, aren't you?


They both use the same admin system, so if you know your PHP and MySQL, it's an easy merge...

[DontWannaName]

This is like a start to an online all in one sourcemod administration platform that can let you configure SM and addons on more than 1 server without having to edit the same file 4 times on ftp.

[flubber]

Thanks for the plugin, will save us quite some times. Just wondering is there a way to customize ads frequency, like every 30 seconds, or something like that?

[strontiumdog]

Use the cvar:

sm_adsmysql_interval "30"