general stastistics of hlstats
 

Hello ,
I created a motd.php page to my web site and I would want to add the general stastistics of hlstats.
you know how to make script for ?


http://gatetogames.net/images/Home/hlstats_to_motd2.PNG

Re: general stastistics of hlstats
 

You will need to use a server-side language such as PHP to communicate with the HLStatsX MySQL database. If you're not sure how to do this, I recommend you look for a tutorial on running SQL queries against MySQL using PHP.

However, I can tell you the SQL queries you want to use are:

For player count:
SELECT count(*) FROM hlstats_Players WHERE hideranking = 0

For kill count:
SELECT SUM(kills) FROM hlstats_Servers

Re: general stastistics of hlstats
 

Hi thx for reply

to my motd.php I have tested this but don't work

<?php
include_once './sgtls.com_stats/pages/game.php';


?>

and now i add this

<div id="button"><a href=""<?php echo $total_players?>" class="menu">Players: <b>$query = "
SELECT
count(*)
FROM
hlstats_Players</b></div>

<div id="button"><a href=""<?php echo $total_kills;?>" class="menu">Kills: </a></div>

Re: general stastistics of hlstats
 

hi any help please
I want just add two button
for
total players:xxx
kills:xxx

https://sgtls.com/images/motd/hlstats_to_motd2.PNG

any help would be appreciated i'm bad at php