[SyNiK4L]

Originally Posted by Laplace Someone of the team should review and approve this plugin. This is one of the rare plugins which is well documented, maintained and work fine without errors for a lot of weeks now on our servers. Best Regards Laplace

i agree completely...i tried 2 other ads plugins before this one...and both crashed my server alot. This plugin has not crashed it once....not to mention i was able to implement the web interface into my website using iframes and it worked perfectly. And like u said very well documented. had no problems at all installing this

[Mathmos]

hi

i have a problem.
when i open http://www.gts-fun.de/adsql/ then i get an error.

PHP Code:

Warning:  mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'DB_SERVER' (1) in /www/htdocs/w00cd849/gts/adsql/include/database.php on line 20
Unknown MySQL server host 'DB_SERVER' (1) 


My config.php:

PHP Code:

<?php
/* new line below starting in AdsQL 1.7.7:    */


define("DB_SERVER", "localhost");
define("DB_USER", "xxx");
define("DB_PASS", "xxx");
define("DB_NAME", "xxx");

define("EMAIL_FROM_NAME", "AdsQL");
define("EMAIL_FROM_ADDR", "[email protected]");
define("EMAIL_WELCOME", false);

define("COMMUNITYNAME", "Penguins With Nerf Guns");

// What are your Admins called?
define("ADMIN", "Admins");

/* new line below starting in AdsQL 1.7.7    */
define("HAVE_ADSQL_CONFIG", true); 

?>

i have test it with

PHP Code:

define("DB_SERVER", "localhost"); 


PHP Code:

define("DB_SERVER", "gts-fun.de"); 


[Rizla]

try putting in your db ip

[Mathmos]

same error =(

[Rizla]

does your sql accept remote connections?

if you have cpanel its easy. if not, google it. you need to allow your server ip to connect to your database.

[Cadav0r]

Hello,

Good job for this plugin.

Any chance to see option to enable/disable a ads (I use the same ads but not always so I want to disable it and renable when I want)

And why not a validity date for ads... For exemple to notice people about an event game (like only zombie maps or something like that) so the ads will be auto disable after the specified date

[cozmicshredder]

I really want to be able to use this could you please fix it?

Warning: mysql_connect() [function.mysql-connect]: php_network_getaddresses: getaddrinfo failed: No such host is known. in E:\xampp\htdocs\cozworldvb1\adsql\include\database.php on line 39

Warning: mysql_connect() [function.mysql-connect]: [2002] php_network_getaddresses: getaddrinfo failed: No such host is kn (trying to connect via tcp://DB_SERVER:3306) in E:\xampp\htdocs\cozworldvb1\adsql\include\database.php on line 39

Warning: mysql_connect() [function.mysql-connect]: php_network_getaddresses: getaddrinfo failed: No such host is known. in E:\xampp\htdocs\cozworldvb1\adsql\include\database.php on line 39
php_network_getaddresses: getaddrinfo failed: No such host is known.

[cozmicshredder]

I was looking at database.php on line 39 was wondering now if this script requires magic_quotes_gpc on? Can anyone confirm this? I am using Xampp for my website hosting and I run a lot of other scripts just seems whoever wrote this script it is either older coding or I need to enable something else...

Thanks!

[Rizla]

well i recently turned of magic quotes, shouldn't be needed if the data is being escaped properly.

+ my ads all seem ok

[PharaohsPaw]

Originally Posted by cozmicshredder I really want to be able to use this could you please fix it? [code]Warning: mysql_connect() [function.mysql-connect]: php_network_getaddresses: getaddrinfo failed: No such host is known. in E:\xampp\htdocs\cozworldvb1\adsql\include\dat abase.php on line 39

You need to configure a database hostname that can be resolved. If whatever DNS servers (and/or hosts file(s)) the webserver running your web interface is using cannot resolve (look up) the hostname you have configured, this will happen.

Make sure you have the right hostname specified, fix what you have specified, or fix your DNS or hosts file records. It is not a software problem.

If all else fails, yes, you should be able to specify the host by its numeric IP. But its really better to use a hostname if you can so you don't have to fix the config if/when your webserver host changes ip's later.