WebBased Detailed player stats

[MassAsster]

Great Job. I run this on our site and folks like to try to climb the list. Is their a way to set it only to poll live players? Also any chance on getting a category for those with the lowest humanity?

 

you can do lowest humanity, but it would be kind of out of line with the table setup i have going, you would have to do your own tables so it didn't look all jacked up, but it's a matter of flipping the humanity search from DESC to ASC (lowest to highest )

 

yes, you can list only live players if you wanted

 

in the userlist.php

$query = "SELECT COUNT(PlayerUID), PlayerName, PlayerUID FROM Player_DATA GROUP BY PlayerUID ORDER BY PlayerName ASC";

change to

$query = "SELECT COUNT(PlayerUID), PlayerName, PlayerUID FROM Player_DATA WHERE Alive = 1 GROUP BY PlayerUID ORDER BY PlayerName ASC";

[MassAsster]

Currently, I don't have a website to port the stats data to from my server, but I really like this idea. It gives players real time data on what they have accomplished in the game. Could I query my server's database and post these stats on a forum? It's not as good as real time, but still it gives the players some fairly current feedback on those stat categories.

 

BTW, are there any cheap web hosts out there now? I don't need an elaborate website. Just something simple with a few pages and possibly a forum.

 

Thanks!

 

http://www.inmotionhosting.com/business-hosting

 

- you could, simply use your database SQL tab and run the searches manually , but live is much less of a pain in the rear to maintain

[Snakeyes]

Yep, live is definitely the way to go. Once it's set up it should be hassle free.

[psychosis]

Lost connection to MySQL server at 'reading initial communication packet', system error: 111

 

 

Who can help with that?....

[MassAsster]

http://forums.mysql.com/read.php?52,152265,241105#msg-241105

[NoxSicarius]

Awesome tool. Will be using it when I get my server edits finished and released for public use. Love all these PHP tools people are making.

[MrGrimm]

Looks awesome....willing to share ? :)

[NoZ]

Can you please help me set this up, I run an overwatch server so im not quite sure how to edit the php for it to work. Please add me on skype: jhark89.

 

http://hellsplaygrounddayz.com

[MassAsster]

Can you please help me set this up, I run an overwatch server so im not quite sure how to edit the php for it to work. Please add me on skype: jhark89.

 

http://hellsplaygrounddayz.com

 

 

Overwatch stats

http://s000.tinyupload.com/index.php?file_id=97905227226858790807

[Triage]

I'm trying to edit the banner. I did so but I cannot seem to have both height and width in this line 

echo "<TABLE BORDER=0><th background='images/logo.png' height=210> <center><h3> $title </h3><TR><TD align=center>";

When I add "width=700>" it just displays it as text . Please help

 

 

Here is my player stats

 

http://mohawkinteractive.vilayer.me/stats/

[Triage]

Never mind, I got it to work by doing this. 

echo "<TABLE BORDER=0><th background='images/logo.png' width=700 height=210> <center><h3> $title </h3><TR><TD align=center>";

[MassAsster]

looks like your on the right track!

[MjrEyesWater]

Ok real noob question:

 

I've access to the FTP 

I've changed all the info in the config file

 

How to i add this to my website?

 

Can't connect to MySQL server on '109.236.89.182' (4)

 

many thanks

 

MJR

 

http://www.cosmicbunny.webspace.virginmedia.com/page10.html (this is what i get on my site)

[MassAsster]

this is PHP , not HTML,  you would simply upload the files to the server via FTP - 

http://support.hostgator.com/articles/ftp/how-to-use-ftp-via-windows-explorer

[MjrEyesWater]

 

this is PHP , not HTML,  you would simply upload the files to the server via FTP - 

http://support.hostg...indows-explorer

 

Thanks,  But I've also tried just uploading via FTP (filezilla) and this was the result I have now:

 

http://cosmicbunny.uphero.com/

 

 

I'm really stumped, everything seems to be right..........

 

I used these setting in the config:

 

<?

 

//set up the names of the database and table

$db_name ="epoch";

$table_name ="player_data";

$server = "109.236.89.182:2302";

$dbusername = "REMOVED";

$dbpassword = "REMOVED";

 

//domain information

$domain = "cosmicbunny.uphero.com/";

 

?>

[Oshydaka]

Try to remove :2302 on the config file (line with $server)

[MjrEyesWater]

 

 

Try to remove :2302 on the config file (line with $server)

 

Just tried removing the port and this is the error i get:

 

 

Lost connection to MySQL server at 'reading initial communication packet', system error: 111

 

So I put it back in :-)

 

Thanks for the idea but that didn't work

[MassAsster]

shouldn't be 2302 - should , by default, be 3306

[MjrEyesWater]

just tried it with 3306 and still getting the same error,  my sql ip is 109.236.89.182:2302

[Gravvy]

The mysql port can be host specific. Some hosts will use 3306 while others will use a different port.

[MjrEyesWater]

Im still desperate to get this working for my server lol

[MassAsster]

What's in your hiveext.ini ? for the database connection

[MjrEyesWater]

copied and pasted directly from my hiveext.ini 

 

 

;Hostname or IP of the server to connect to

Host = 109.236.89.182

;Port to connect to. The default is the default listening port of a server of the selected Type

;Instead of specifying Port, you can specify Socket and set Value to the socket name

Port = 2303

[MassAsster]

http://109.236.89.182:2303

5.5.25a1v#G|]:Hÿ÷€=9G8!=PXIGfNmysql_native_password!ÿ„#08S01Got packets out of order

yeah, that's the right ip/port

now you just have to figure out your user/pass  (remember capital letters matter)

 

you have been posting 109.236.89.182:2302 <----  incorrect 

2303

[MjrEyesWater]

http://cosmicbunny.uphero.com/

 

Triple checked user name and password and the port is 2303 but as you can see from the link still getting the error