Jump to content
MassAsster

WebBased Detailed player stats

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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/

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.. 

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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";

Share this post


Link to post
Share on other sites

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.  :(

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

  • Advertisement
  • Supporters
  • Discord

×
×
  • Create New...