[Cyb3rH4Xter]

To all guys that need's better hosts, check this: www.speed-stats.de
It's made for psychostats but can be used for gg_stats to cause it's sql database ALLOWS OUTER CONNECTIONS!

[creeperdank]

I use PsychoStats 3.1 on my web hosting why wouldn't this work.
I just need to know ex how to set up the cron to copy the gungame.stats to the web hosting.

Operating system Linux
MySQL version 4.1.22-standard-log
PHP version 5.2.5

[Cyb3rH4Xter]

Originally Posted by creeperdank I use PsychoStats 3.1 on my web hosting why wouldn't this work. I just need to know ex how to set up the cron to copy the gungame.stats to the web hosting. Operating system Linux MySQL version 4.1.22-standard-log PHP version 5.2.5

Are you hosting on your own computer?

[moonboi03]

this is the error i see in the log file

L 05/12/2009 - 00:01:24: [gungame_sql.amxx] Could not connect to database. Error #1130: Host '66.225.198.130' is not allowed to connect to this MySQL server

[Cyb3rH4Xter]

Originally Posted by moonboi03 this is the error i see in the log file L 05/12/2009 - 00:01:24: [gungame_sql.amxx] Could not connect to database. Error #1130: Host '66.225.198.130' is not allowed to connect to this MySQL server

cPanel blocks all connections tries from all ips not listed in the part of the cPanel wheer you can add allowed IPs, that are allowed to connect to the mySql.

As i said to the other guy, if you don't have a static IP, or have a webhost that allows outer connections, you need to host your own mysql or find a better host that allows outer connections, like speed-stats.de.

[creeperdank]

No I'm using www.webhostingbuzz.com

[moonboi03]

K i added the ip to allow it access to the MySQL database and this is the error i get now.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/peppermi/public_html/ggwins.php on line 47

this is the line its talking about

else $query = mysql_query('SELECT * FROM gg_stats WHERE `' . $field . '` = \'' . $value . '\';',$db);

[Cyb3rH4Xter]

Originally Posted by moonboi03 K i added the ip to allow it access to the MySQL database and this is the error i get now. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/peppermi/public_html/ggwins.php on line 47 this is the line its talking about if(!mysql_num_rows($query)) return false;

And how its going for the gungame_sql, could you please show me the latest log?

[moonboi03]

here is the latest log. It has alot of crap in it but if you read throught it you will see the gungame_sql.amxx error message.

[gungame_sql.amxx] Could not connect to database. Error #1130: Host '66.225.198.130' is not allowed to connect to this MySQL server

yes i did add 66.225.198.13 to the cpanel allowed ip list.

when i visit the page it gives me this error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/peppermi/public_html/ggwins.php on line 47

when i check line 47 in the the ggwins.php file this is what it says

else $query = mysql_query('SELECT * FROM gg_stats WHERE `' . $field . '` = \'' . $value . '\';',$db);

[YamiKaitou]

Originally Posted by moonboi03 [gungame_sql.amxx] Could not connect to database. Error #1130: Host '66.225.198.130' is not allowed to connect to this MySQL server yes i did add 66.225.198.13 to the cpanel allowed ip list.

Readd the user. I have had the same issue before in the past where I solved it by recreating the user

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/peppermi/public_html/ggwins.php on line 47 when i check line 47 in the the ggwins.php file this is what it says else $query = mysql_query('SELECT * FROM gg_stats WHERE `' . $field . '` = \'' . $value . '\';',$db);

Run the query yourself and see if you get an error back or some results.

Also, for readability sake, I find this much easier to read (yes it does work, I use this format all the time in my scripts)

PHP Code:

else $query = mysql_query("SELECT * FROM gg_stats WHERE `$field` = '$value'",$db);