Raised This Month: $51 Target: $400
 12% 

Advertisements - MySQL Updated 2/5/09


Post New Thread Reply   
 
Thread Tools Display Modes
Rads
AlliedModders Donor
Join Date: Feb 2008
Location: Achievement what
Old 10-05-2010 , 16:41   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #401

Quote:
Originally Posted by michcio View Post
hey I've just setup the sql ads on my server. But when I write the command:

Code:
sm_adsmysql_interval "10"
I need to reload the ads for the interval to change... then if I shut down my server and take it up again the intervall gets 45 again :S...how do I do so it gets saved?

put sm_adsmysql_interval "10" in to ur sourcemod.cfg bud that way it will loadup if you need to restart / shut down ur server
__________________
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
4UHost.UK - Global Hosting.
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Rads is offline
michcio
Junior Member
Join Date: Aug 2010
Old 10-05-2010 , 17:19   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #402

Quote:
Originally Posted by Rads View Post
put sm_adsmysql_interval "10" in to ur sourcemod.cfg bud that way it will loadup if you need to restart / shut down ur server
Works great thanks!
michcio is offline
cooltruck
Member
Join Date: Oct 2010
Old 10-08-2010 , 01:50   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #403

How can I disable ads for admins? Some admins which I have a group/non group admins. Because I use a package and like to include the ability to disable ads.
cooltruck is offline
bouncer
Veteran Member
Join Date: Apr 2009
Old 10-09-2010 , 23:23   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #404

Administrator as user and password don't work, whats the user and pass??
__________________


bouncer is offline
Rads
AlliedModders Donor
Join Date: Feb 2008
Location: Achievement what
Old 10-10-2010 , 00:23   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #405

Quote:
Originally Posted by bouncer View Post
Administrator as user and password don't work, whats the user and pass??
have you loged in there be for with that info .?
__________________
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
4UHost.UK - Global Hosting.
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Last edited by Rads; 10-10-2010 at 00:36.
Rads is offline
cooltruck
Member
Join Date: Oct 2010
Old 10-12-2010 , 18:53   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #406

Anyone know how to disable in-game ads for a group admin?
cooltruck is offline
Spinner0205
Junior Member
Join Date: Feb 2010
Old 11-08-2010 , 17:43   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #407

I have installed the web server files okay, imported the mysql database and installed the addon. Except when I go to the ads page on my server, I get a mysql access denied error. I have the mysql user attached with full permissions to the mysql database for the ads, yet it gives Access denied. Also, I have all of the information typed correctly into the config.php file. Is there another setting I am missing?
Spinner0205 is offline
matrixmark
Senior Member
Join Date: Jun 2010
Old 11-08-2010 , 18:02   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #408

If your website is not hosted on your (game)server then you might need to allow remote mysql connnections in your webhosting cpanel.

basically you just add your gameservers ip to the webhosting cpanel remote mysql allow list.
matrixmark is offline
Svpernaut
Junior Member
Join Date: Apr 2007
Old 11-10-2010 , 22:23   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #409

I get this error

Code:
L 11/10/2010 - 20:11:35: SourceMod error session started
L 11/10/2010 - 20:11:35: Info (map "aim_ag_texture2") (file "errors_20101110.log")
L 11/10/2010 - 20:11:35: [sm_adsmysql.smx] Database failure: Could not find database conf "admintools"
L 11/10/2010 - 20:11:46: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 11/10/2010 - 20:11:46: [SM] Displaying call stack trace for plugin "sm_adsmysql.smx":
L 11/10/2010 - 20:11:46: [SM]   [0]  Line 124, /home/groups/alliedmodders/forums/files/2/4/5/7/3/38158.attach::SetupAds()
Svpernaut is offline
Svpernaut
Junior Member
Join Date: Apr 2007
Old 11-10-2010 , 22:59   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #410

NVM fixed it
Svpernaut is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:30.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode