[TF2 Stats] With Web Ranking and Item Logger [v9.1.0] - Page 54

**DarthNinja** · 05-31-2010 , 06:33 Re: [TF2 Stats] With Web Ranking and Item Logger [v6.4/6.7.0]

Quote:

Originally Posted by McDean

hello, ive got the server plugin all working, but my website stats page doesnt seem to be working, getting line errors when i go to map and player rankings
www.thebohage.com/tf2stats
also getting a DB Query failed, i had to use my domain as my site doesnt have an ip, any ideas where i may of went wrong?

Quote:

Access denied for user 'nobody'@'localhost' (using password: NO)

That being plastered all over the place might be a clue.
Update your config.

McDean · *Last edited by McDean; 05-31-2010 at 06:43.*

Quote:

Originally Posted by DarthNinja

That being plastered all over the place might be a clue.
Update your config.

sorry was playing around with database, have a look now

database.cfg

"tf2stats"
{
"driver" "mysql"
"host" "www.thebohage.com"
"database" "mcamden_stats"
"user" "mcamden_user"
"pass" "user"
//"timeout" "0"
//"port" ""
}

**DarthNinja** · 05-31-2010 , 07:02 Re: [TF2 Stats] With Web Ranking and Item Logger [v6.4/6.7.0]

@McDean
Your site's IP address (assuming it doesn't change) is 66.225.231.10 .
Your problem is caused by the database being empty, which in turn is caused by the plugin not communicating with the webserver.
This can be caused by one or more of the following:

Incorrect plugin config
Access restrictions placed on the mysql user the plugin is using.

Double check your TF2 server's config, if it's ok, check your msql user permissions, make sure you're game server's ip is allowed, or use a wildcard.

This may be helpful

McDean · *Last edited by McDean; 05-31-2010 at 07:24.*

Quote:

Originally Posted by DarthNinja

@McDean
Your site's IP address (assuming it doesn't change) is 66.225.231.10 .
Your problem is caused by the database being empty, which in turn is caused by the plugin not communicating with the webserver.
This can be caused by one or more of the following:

Incorrect plugin config
Access restrictions placed on the mysql user the plugin is using.

Double check your TF2 server's config, if it's ok, check your msql user permissions, make sure you're game server's ip is allowed, or use a wildcard.

This may be helpful

yeah i followed that guide when i installed it all.
mysql user is set to "ALL PRIVILEGES"
put in IP now, do u need to have the port?
plugin config is just the database one isnt it?

btw, im on a shared hosting, does that affect it?

**DarthNinja** · 05-31-2010 , 08:53 Re: [TF2 Stats] With Web Ranking and Item Logger [v6.4/6.7.0]

Quote:

Originally Posted by McDean

yeah i followed that guide when i installed it all.
mysql user is set to "ALL PRIVILEGES"

put in IP now, do u need to have the port?
Not unless your server is configured to use a non-default port.

plugin config is just the database one isnt it?
Yes, database.cfg.

btw, im on a shared hosting, does that affect it?
You'd need to explain what you mean by that.

What I was talking about by permissions is this:

You need to allow remote access to the database if it is denied by default, ether by entering your TF2 server's ip or a wildcard.
If you can't figure out how to setup mysql access yourself, I suggest you contact your hosting company's tech support.
They will be able to help you better then we can, since they know a great deal more about your server then we do.

McDean · *Last edited by McDean; 05-31-2010 at 10:50.*

im on shared hosting, so others use the ip i think, this is what it says in cpanel

"Shared Ip Address 66.225.231.10"

Ive got remote MySQL to %

Quote:

"tf2stats"
{
"driver" "mysql"
"host" "66.225.231.10"
"database" "mcamden_stats"
"user" "mcamden_user"
"pass" "user"
//"timeout" "0"
//"port" "21"
}

Quote:

$mysql_server = "localhost";
$mysql_user = "mcamden_user";
$mysql_password = "user";
$mysql_database = "mcamden_stats";

I got 2 database's, does that matter? one that all the site stuff is on. the other one says size: 0.00MB

**DarthNinja** · 05-31-2010 , 13:38 Re: [TF2 Stats] With Web Ranking and Item Logger [v6.4/6.7.0]

Both the plugin and the site have to be pointed to the same database.

McDean · 05-31-2010 , 23:27 Re: [TF2 Stats] With Web Ranking and Item Logger [v6.4/6.7.0]

Quote:

Originally Posted by DarthNinja

Both the plugin and the site have to be pointed to the same database.

hmmm this doesnt like me, yeah sorry meant like my site site stuff, not the stat site stuff

SatlaN · 06-02-2010 , 03:45 Re: [TF2 Stats] With Web Ranking and Item Logger [v6.4/6.7.0]

What does the file "player_mini_stats.php" doing? and how can i use it?

I would like if you will ad an options search to the site:
1 - player name
2 - steam id

and sort option by:
1 - points
2 - headshots
3 - backstabs
4 - custom

McDean · 06-02-2010 , 04:34 Re: [TF2 Stats] With Web Ranking and Item Logger [v6.4/6.7.0]

got it all working, thanks for your help