WebBased Detailed player stats

[MassAsster]

verify you can connect with this

es-gamers.com/chiveme   if you make a connection with it, then you have everything correct

[MjrEyesWater]

 

 

es-gamers.com/chiveme   if you make a connection with it, then you have everything correct

sorry, what do you mean do i put that as server?

 

If the answer was Yes then this is what i get:

 

http://cosmicbunny.uphero.com/

[MassAsster]

It's a php driven database connection tool -  basically if you are able to use that (filling it out and pushing connect), and connect to your database, then you have all the information correct (username,address,port,password etc) -  if it errors out, you have something incorrect.

[MjrEyesWater]

could it be the server host?  I host with Vilayer?

[Achmed]

No you need webspace

[Achmed]

How would I go about editing it so players longest alive show only players who have logged in in the last 7 days? Currently the longest alive are all players who don't play no more

[MjrEyesWater]

 

 

No you need webspace 

I have webspace  but its not working

[Achmed]

If "http://cosmicbunny.uphero.com/" is your website where your trying to host it the problem is you have the link to your database incorrect. It should be the same IP that you use for your game server and not es-gamers.com/chiveme

[Michael_notfromCCG]

Nice. I have actually been working on something similar for my un-named community.

 

Example - http://mtcaldwell.co.uk/newCCG.php

 

Features:

• Live Killboard
• Top Hero
• Top Bandit
• Wealthiest player*

Still a big work in progress, as I never knew any HTML, CSS, PHP or Javascript before I started, now I am using it all :D

 

*Quite a smart query works this out. (obviously specific to our servers, due to currency). But it looks at how much money you have on you at the moment, how much you have in the bank and calculates the value of all your stored gold and briefcases. Does this and works how who is the richest on the server. (Broken just now, so won't load. I accidentally broke it when trying to do some optimizing to make the query responsible work quicker). This query could be adapted to servers that use the standard currency, assuming you have playerID attached to objects.

 

I'd be happy to exchange notes.

[MassAsster]

How would I go about editing it so players longest alive show only players who have logged in in the last 7 days? Currently the longest alive are all players who don't play no more

 

BEST way to go about that, is clear your player data of anyone who's not logged in in XX amount of days -

you can however add a filter by date and say > or < XX days

http://www.databasejournal.com/features/mssql/article.php/2209321/Working-with-SQL-Server-DateTime-Variables-Part-Three---Searching-for-Particular-Date-Values-and-Ranges.htm

[MjrEyesWater]

If "http://cosmicbunny.uphero.com/" is your website where your trying to host it the problem is you have the link to your database incorrect. It should be the same IP that you use for your game server and not es-gamers.com/chiveme

 

 

No it was linked to my sever (or at least the right details)  but MassAsster suggested try linking to es-gamers.com/chiveme.

 

This is it linked back to my server : http://cosmicbunny.uphero.com/

[Achmed]

BEST way to go about that, is clear your player data of anyone who's not logged in in XX amount of days -

you can however add a filter by date and say > or < XX days

http://www.databasejournal.com/features/mssql/article.php/2209321/Working-with-SQL-Server-DateTime-Variables-Part-Three---Searching-for-Particular-Date-Values-and-Ranges.htm

we already clear players who have not logged in for 56 days and are alive still. Don't want to set it to 7 days as people have holidays etc but might have to chance it to 28 days etc

[MatthewK]

I'm assuming this only shows stats for the current life of the player, and not a combined "over all lives" stats. Because I have killed loads of bandits , but it shows me as zero at the moment, i did die a last night though and haven't been bandit hunting today.  

 

Thank you for sharing the script: http://www.unit487.gamingdeluxe.net/

 

Would a combined kill / zed / headshot type option be people? i.e all lives stats combined.. 

[MassAsster]

I'm assuming this only shows stats for the current life of the player, and not a combined "over all lives" stats. Because I have killed loads of bandits , but it shows me as zero at the moment, i did die a last night though and haven't been bandit hunting today.  

 

Thank you for sharing the script: http://www.unit487.gamingdeluxe.net/

 

Would a combined kill / zed / headshot type option be people? i.e all lives stats combined.. 

 

yes it's only counting the character you have alive at the moment.

It would be possible, removing the alive query and grouping by id - It was designed as current life for the sole reason of allowing new players the chance to show up the leader board (lets face it , you can't out do a person who has been playing a month longer than you as a new player if your looking at all alive/dead stats in totality)

[MatthewK]

yes it's only counting the character you have alive at the moment.

It would be possible, removing the alive query and grouping by id - It was designed as current life for the sole reason of allowing new players the chance to show up the leader board (lets face it , you can't out do a person who has been playing a month longer than you as a new player if your looking at all alive/dead stats in totality)

 

So true. I will keep it as is then. Right, better get back online and sort my own rank out :p

[Tommy Sunshine]

Hey MrjEyesWater,

 

Did you ever get this resolved? I'm hosting an epoch server with vilayer and having the same issue.

 

http://thesunshinecrew.com/dayzstats/

 

$db_name ="epoch";

$table_name ="player_data";

$server = "198.27.83.215:2603";

$dbusername = "notreallymyusername";

$dbpassword = "notreallymypw";

 

//domain information

$domain = "thesunshinecrew.com/dayzstats";

[MassAsster]

I think for some reason it's the way Vilayer is setup - I can't really explain it -

I had to re-tool the DRS php for another person and it's kind of a pain in the ass because they don't seem to use standard ports...

 

I'm going to just flat out say that this doesn't support Vilayer and their jacked up hosting, because having to re-write the entire code to work with them is just not worth it.  :(

[Achmed]

my bad... i use knightmares lol

[prue420]

Hey guys sorry but i cant find any detailed information on how to set this up on my website i am very new to this. I set up private hive tools but i don't no where to put the download for the player stats or it working on my website any help would be great ill even throw someone a few buck if you want to just connect in teamviewer and show me ty.

[HollowAddiction]

i get this 

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

connection info is correct, and db is set to allow queries

 

any idea?

[HollowAddiction]

Thanks, i altered the code a bit to suit my needs

 

but here is mine http://craftdoge.com/topplayers/

[Mordeth]

Overwatch stats

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

This link does not work anymore. I am looking for a good overwatch stat tracker script. Can anyone repost this?

Thanks

[MassAsster]

This link does not work anymore. I am looking for a good overwatch stat tracker script. Can anyone repost this?

Thanks

stats.zip

[Dyno1986]

Hey does anyone have this working and live? I would love to see it in action

 

EDIT:

 

I should also mention that I am running OverPoch

 

I have uploaded it to my web host (Hosted apart from the game server) and I get this error

 

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

 

I have all the right information in the Config file

<?

//set up the names of the database and table
$db_name ="cherno";
$table_name ="survivor";
$server ="67.118.114.98:3306";
$dbusername ="*******";
$dbpassword ="*******";

//domain information
$domain = "eswarfare.com/stats_cherno";

?>

and have even tried adding the PHP after the first <? and still isn't working.

 

and help would be much appreciated 

[Jun_msk]