Server Stats page for XpKiller's 'BF3 Chat, GUID, Stats and Mapstats Logger'

[ImportBot]

Originally Posted by GR101*:

 

First of all, excellent work you are doing here.

 

Could I suggest future additional functionality?

 

Top 25 Countries page.

Top 10 expandable player stats for each country, same information as on 'Top 25 Players' page but for each country.

 

Banned Players page.

Read a local server ban list. (I tend to ban players using PB Webtool and not GGC, if GGC is under DDoS attack like recently, then the website would not be available for banning players).

 

Various pages.

Check player stats at http://battlelog.battlefield.com also for reporting players to EA.

[ImportBot]

Originally Posted by ty_ger07*:

 

First of all, excellent work you are doing here.

 

Could I suggest future additional functionality?

 

Top 25 Countries page.

Top 10 expandable player stats for each country, same information as on 'Top 25 Players' page but for each country.

Yes, good idea.

 

Banned Players page.

Read a local server ban list. (I tend to ban players using PB Webtool and not GGC, if GGC is under DDoS attack like recently, then the website would not be available for banning players).

This is not possible unless you store the ban list in a SQL database using a different PRoCon plugin. The page can't access the banlist.txt file for the server.

 

If you do not ban players directly via GGC-Stream, it is best to just leave the GGC-Stream information empty so all the GGC-Stream content in the stats page is not displayed.

 

I have requested from GGC-Stream that they allow me to use the API which will check for global GGC-Stream bans instead of just manual bans, but I am still waiting for their approval. They are concerned that the GUIDs processed by the page could be intercepted and are thus concerned about the privacy of players associated with those GUIDs.

 

Various pages.

Check player stats at http://battlelog.battlefield.com also for reporting players to EA.

The page already has a link to bf3stats.com, but I suppose battlelog stats and reporting players could be added.

[ImportBot]

Originally Posted by ty_ger07*:

 

Big update! Link in first post.

 

Changes:

- Player names in dog tags list are clickable

- More external links added to player stats page

- Link to XpKiller's plugin added at bottom of page

- Page compute time added to bottom of page

- Player world distribution map added to country stats page

- Top 10 players for each country added to country stats page

[ImportBot]

Originally Posted by ty_ger07*:

 

Check this out!

https://www.google.com/search_aq=f&s...roid_oOo+stats

 

I did a Google search for oOo_ANdroid_oOo stats. My stats page was the first result. Apparently my search engine optimization was well executed.

[ImportBot]

Originally Posted by GR101*:

 

Again, Excellent work.

 

I like the additional player links and particular the "Top 10 players for each country added to country stats page" I think that works extremely well. Thanks.

[ImportBot]

Originally Posted by GR101*:

 

I have found a small error with player Dogtags or at least I think so?

 

My player "Players GR101 has killed with Melee:" and "Players who have killed GR101 with Melee:" look correct, the error is with my "victim" stats page and it doesn't show me as his killer because he doesn't have any Melee kills himself.

 

I think the page should display the "killer" under "Dogtags" section even if he has no victims.

[ImportBot]

Originally Posted by GR101*:

 

Another suggestion?

 

How about "Top 5 players per weapon type" page, expandable top 5 players per weapon type, example Dogtags, Light Machine Gun Stats, Sniper Rifle Stats, Projectile Explosive Stats etc.....

[ImportBot]

Originally Posted by ty_ger07*:

 

I have found a small error with player Dogtags or at least I think so?

 

My player "Players GR101 has killed with Melee:" and "Players who have killed GR101 with Melee:" look correct, the error is with my "victim" stats page and it doesn't show me as his killer because he doesn't have any Melee kills himself.

 

I think the page should display the "killer" under "Dogtags" section even if he has no victims.

New version is posted in the first post.

 

Changes:

- Dog tag stats are visible even if player has not collected any dog tags

- Borders added around HTML 5 blocks for visual enhancement

[ImportBot]

Originally Posted by ty_ger07*:

 

How about "Top 5 players per weapon type" page, expandable top 5 players per weapon type, example Dogtags, Light Machine Gun Stats, Sniper Rifle Stats, Projectile Explosive Stats etc.....

I will plan to incorporate such a feature.

[ImportBot]

Originally Posted by Athlon*:

 

Great work ty_ger07!

 

Sorry to go off topic - Are you the same ty_ger07 who did BF2 modding & AIX2 stuff?

[ImportBot]

Originally Posted by ty_ger07*:

 

Are you the same ty_ger07 who did BF2 modding & AIX2 stuff?

No...

 

I didn't know that there was more than one ty_ger07 in this world. Apparently there is.

[ImportBot]

Originally Posted by Athlon*:

 

No...

 

I didn't know that there was more than one ty_ger07 in this world. Apparently there is.

His name may not be exactly the same, but damn close!

[ImportBot]

Originally Posted by ty_ger07*:

 

Update posted in first post.

 

Changes:

- Minor code improvements for error-control.

- Banned players page re-worked and now much faster.

[ImportBot]

Originally Posted by Athlon*:

 

His stats plugin is working nicely. All messages show when we are in game.

 

I just can't get your page to connect. Here is the code I've put in:

 

Code:

<_php
// DATABASE INFORMATION
$db['host']		='87.xxx.xxx.xxx'; // database host
$db['uname']	='xxxhiddenxxx'; // database user name
$db['pass']		='xxxhiddenxxx'; // database password
$db['name']		='procon'; // database name

// DATABASE TABLE SUFFIX
$table_suffix	=''; // if you use a table suffix, enter it there

// DATABASE SERVER ID
$server_ID		='1'; // default server ID is 1.  If using more than one server in the same database without table suffixes, you can select a server other than the first one.

// GGC-STREAM INFORMATION
$serverId		= ''; // server ID
$key			= ''; // API Key

// SERVER NAME
$server_name	= '=WH= Warhawks Clan 32 Slot Server'; // server name to display

// CLAN NAME
$clan_name		= '=WH= Warhawks'; // your gaming clan or organization name

Of course I've hidden stuff with x's. I've triple checked and they are all correct however.

 

It just will not connect and populate the page. Here is the address of the page:

 

http://www.warhawksclan.com/player_stats.php

 

There must be something I must do on the computer running our Procon Master? Both Procon & Mysql run 24/7 on that box. Our web site is not on that box.

[ImportBot]

Originally Posted by ty_ger07*:

 

I don't know how to make the website connect to your box. I assume you have to look at your firewall settings or open ports.

[ImportBot]

Originally Posted by leibhold*:

 

test for SQL open on your box where SQL live

 

telnet 87.xxx.xxx.xxx 3306

 

You should get some garbage on the screen - hitting enter or waiting should get a diconnected after a while or more garbage.

 

Thats assuming you can do that from the webserver.

 

IF not create a simpe test page test.php

 

Put this in it.

<_php>

$link = mysql_connect('IP ADDRESS','dbuser','dbpassword');

if (!$link) { die('Could not connect to MySQL: ' . mysql_error());

} echo 'Connection OK'; mysql_close($link);

_>

 

Edit IPADDRESS dbuser and dbpassword to suit

 

If that doesnt come back with ok then you have issues with firewall, sql access etc.

 

check www.phogue.net/forumvb/showth...ighlight=mysql*

 

Oh also try http://www.yougetsignal.com/tools/open-ports/

to see if port 3306 is open on your host box for sql.

[ImportBot]

Originally Posted by Athlon*:

 

Thank you for your help! It looks like 3306 is closed. (I used yougetsignal).

 

I'll get the member who lives with that box to open the port and I'll go from there.

 

I'll report back here in case someone else reads this down the line. Great info here!

[ImportBot]

Originally Posted by Athlon*:

 

test for SQL open on your box where SQL live

 

telnet 87.xxx.xxx.xxx 3306

 

You should get some garbage on the screen - hitting enter or waiting should get a diconnected after a while or more garbage.

 

Thats assuming you can do that from the webserver.

 

IF not create a simpe test page test.php

 

Put this in it.

<_php>

$link = mysql_connect('IP ADDRESS','dbuser','dbpassword');

if (!$link) { die('Could not connect to MySQL: ' . mysql_error());

} echo 'Connection OK'; mysql_close($link);

_>

 

Edit IPADDRESS dbuser and dbpassword to suit

 

If that doesnt come back with ok then you have issues with firewall, sql access etc.

 

check www.phogue.net/forumvb/showth...ighlight=mysql*

 

Oh also try http://www.yougetsignal.com/tools/open-ports/

to see if port 3306 is open on your host box for sql.

Here's what I've been able to do so far.

 

1) Using 'yougetsignal.com' to test, I finally got the port to show open!

2) Trying Putty, it disconnects immediately when telneting in.

3) Your code yields:

Code:

Could not connect to MySQL: Can't connect to MySQL server on '87.xxx.xxx.xxx' (4)

I know it's set up correctly, because it's working just fine on our server. I'm going to keep poking around to see what could be blocking it now.

[ImportBot]

Originally Posted by Athlon*:

 

I've been trying all day to get our box to allow your code to work.

 

<_php>

$link = mysql_connect('IP ADDRESS','dbuser','dbpassword');

if (!$link) { die('Could not connect to MySQL: ' . mysql_error());

} echo 'Connection OK'; mysql_close($link);

_>

 

(I put our ip, username & pw in there - and did the same thing with the full web page.)

 

I've been all over the 'net with Google and have tried entering many different settings in the command box.

 

The only progress I made today was to unblock the port. There must be a setting I'm missing. I even tried turning off the firewall and it made no difference, but of course the port is already open.

 

Is there a setting to allow warhawksclan.com to read the db?

[ImportBot]

Originally Posted by leibhold*:

 

1)Using 'yougetsignal.com' to test, I finally got the port to show open!

Good start.

 

2) Trying Putty, it disconnects immediately when telneting in.

Cant use putty really - need to use telnet

How to enable

http://www.itdoescompute.com/2009/10...t-in-windows-7

 

Putty isnt a good test because you dont see what happens.

 

 

3) Your code yields:

Could not connect to MySQL: Can't connect to MySQL server on '87.xxx.xxx.xxx' (4)

 

Kind of suggests that is cant get to the sql. This is a really basic test. It also assumes that you are using the standard 3306 sql port - can you confirm this - by checking the settings on the host ?

 

If you want - pm the IP and I can test from here.

[ImportBot]

Originally Posted by Athlon*:

 

1)Using 'yougetsignal.com' to test, I finally got the port to show open!

Good start.

 

2) Trying Putty, it disconnects immediately when telneting in.

Cant use putty really - need to use telnet

How to enable

http://www.itdoescompute.com/2009/10...t-in-windows-7

 

Putty isnt a good test because you dont see what happens.

 

 

3) Your code yields:

Could not connect to MySQL: Can't connect to MySQL server on '87.xxx.xxx.xxx' (4)

 

Kind of suggests that is cant get to the sql. This is a really basic test. It also assumes that you are using the standard 3306 sql port - can you confirm this - by checking the settings on the host ?

 

If you want - pm the IP and I can test from here.

3306 is it. and it's what I have in the plugin in Procon - which is working great.

 

PM on it's way.

 

Thanks man.

[ImportBot]

Originally Posted by leibhold*:

 

Ok the issue is with your webserver NOT the SQL

I can connect ok to SQL and I get a "Connection OK" in webpage on my web server for the test page.

 

Suggests that your webserver is blocking traffic on port 3306.

Check with your hoster to see why.

[ImportBot]

Originally Posted by Athlon*:

 

Ok the issue is with your webserver NOT the SQL

I can connect ok to SQL and I get a "Connection OK" in webpage on my web server for the test page.

 

Suggests that your webserver is blocking traffic on port 3306.

Check with your hoster to see why.

Thanks.

 

It's a computer owned by one of our members just for this purpose. 3306 is open according to that test web site.

 

You think it's blocking traffic from our Web site? Strange it's working for you.

[ImportBot]

Originally Posted by leibhold*:

 

The website is being blocked either by

 

1. The computer which houses the sql - this would have to be a block on the firewall for your web server address

2. The webserver is blocking incomming sql traffic or traffic from the sql host.

 

As I can get to the SQL, then the SQL server should be fine - very unusual for a host to block one IP address (eg your webserver)

 

I would look at the webserver setup myself, is it hosted with commerical ?

 

Ok so the web site is comercial with dfghosting - You have to check with them if sql is allowed though the firewall there.

[ImportBot]

Originally Posted by XpKiller*:

 

you can define allowed hosts in the mysql server too.

[ImportBot]

Originally Posted by Athlon*:

 

The website is being blocked either by

 

1. The computer which houses the sql - this would have to be a block on the firewall for your web server address

2. The webserver is blocking incomming sql traffic or traffic from the sql host.

 

As I can get to the SQL, then the SQL server should be fine - very unusual for a host to block one IP address (eg your webserver)

 

I would look at the webserver setup myself, is it hosted with commerical ?

 

Ok so the web site is comercial with dfghosting - You have to check with them if sql is allowed though the firewall there.

I'll check w/them - never thought of that! Thanks. I know those guys over there.

 

 

you can define allowed hosts in the mysql server too.

Did that - He can get to it, I can't. It must be DFG. I'll let you know.

[ImportBot]

Originally Posted by Athlon*:

 

Got it going. DFG does not allow as you said. I never would have thought of that. I just figured I made a mistake somewhere and could not see it. Thank you for your help!

 

I'm hosting the pages (we have two servers) on the 'back' of another web site I own which is not w/DFG. I'm linking to them from our clan site seamlessly.

 

Now all I have to do is customize them to the look and feel of our site.

 

32 Slot Server Player Stats

18 Slot Server Player Stats

[ImportBot]

Originally Posted by GR101*:

 

Sorry, back again with other suggestions / refinements?

 

1. Configurable footer section on each page to display Game Tracker server banner. (Not visible if blank).

 

2. Join Server button or URL, link back to server Battlelog page, displayed on each page and located under the main banner. (Not visible if blank).

 

3. In-built multi server menu system. (Not visible if you have 1 server).

 

Thanks for all the excellent work you are doing here.

[ImportBot]

Originally Posted by ty_ger07*:

 

Those are cool ideas, but I am busy with other things and this will be put on the back-burner.

[ImportBot]

Originally Posted by Bl1ndy*:

 

http://bl1ndy.branspace.com/player_stats.php

 

Why do all my player status messages say Unknown?