Raised This Month: $81 Target: $400
 20% 

general stastistics of hlstats


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
SGCatlantis
Member
Join Date: Oct 2012
Location: France
Old 01-20-2016 , 14:57   general stastistics of hlstats
Reply With Quote #1

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 ?



Last edited by SGCatlantis; 08-24-2023 at 06:19.
SGCatlantis is offline
Pricetx
Junior Member
Join Date: Jan 2013
Old 01-29-2016 , 20:43   Re: general stastistics of hlstats
Reply With Quote #2

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
Pricetx is offline
SGCatlantis
Member
Join Date: Oct 2012
Location: France
Old 02-01-2016 , 17:59   Re: general stastistics of hlstats
Reply With Quote #3

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>
SGCatlantis is offline
SGCatlantis
Member
Join Date: Oct 2012
Location: France
Old 08-24-2023 , 06:18   Re: general stastistics of hlstats
Reply With Quote #4

hi any help please
I want just add two button
for
total playersxx
killsxx



any help would be appreciated i'm bad at php
SGCatlantis is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 15:21.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode