[Guide]Show server stats on your website

[xMrPwN]

{translation from my same guide in greek section}

Ok, I don't know if this guide has been posted before but I'll make it very detailed

Let's Start

 

Supposing that we go to our web's files and we make a folder "/config" and inside we create a file "stats.php"

inside it we put the following:

<?php

   $db_user = "USER"; 
   $db_pass = "PSW"; 
   $db_name = "DATABASE"; 
   $db_serv = "HOST(ip)"; 

   $res = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]"); 
   $resdb = mysql_select_db ( "$db_name",$res ); 

   return $res; 

?>

we fill them according to our database

the infos of how to connect to the database will be in this file(all infos are secure with this form)

--------------------------------------------------------------------------------------------

afterwards, the page we want to show the infos must have on it's top:

<?php include "config/stats.php" ?>

and these:

<?php

mysql_connect($db_serv,$db_user,$db_pass) or die(mysql_error());

mysql_select_db($db_name) or die(mysql_error());

 

afterwards we write what we want from the file, to load from the database

here are some examples for:

//Total Accounts
$query = ("SELECT * FROM accounts WHERE accesslevel>=0");

$result = mysql_query($query) or die(mysql_error());

$acc2=mysql_numrows($result);

//GMs Online
$query = ("SELECT * FROM characters WHERE accesslevel=200 and online=1");

$result = mysql_query($query) or die(mysql_error());

$GM=mysql_numrows($result);

//Online Players
$query = ("SELECT * FROM characters WHERE accesslevel<=0 and online=1");

$result = mysql_query($query) or die(mysql_error());

$online=mysql_numrows($result);

//Total Characters
$query = ("SELECT * FROM characters WHERE accesslevel>=0");

$result = mysql_query($query) or die(mysql_error());

$char2=mysql_numrows($result);

//Total clans
$get_config_data="SELECT clan_id FROM clan_data";

$query = ("SELECT clan_id FROM clan_data WHERE clan_id>0");

$result = mysql_query($query) or die(mysql_error());

$clan2=mysql_numrows($result);

last lines of each code, for example: "$clan2=mysql_numrows($result);" clan2 will the name in wich everything will be written on the file, we can modify it if we want to

then we conclude connect code with:

mysql_close();

mysql_connect($db_serv,$db_user,$db_pass) or die (mysql_error());

mysql_select_db($db_name) or die(mysql_error());
?>

 

and after everything is written, to show the info, about total characters for example, on the site we write:

Total Characters: <?php print ("$char2"); ?>

(//Total characters(the script) must be in the same page in wich Total Characters: will be shown, if it's not, we simply add this on that page:

<?php include "ToFilePouTaExeis.php" ?>

 

I hope i've been helpful :)

 

PS: whoever can please take my karma back to 0 ;p

[TheiPodKid]

omg... Everyone who downloads a Lineage2 website there is a Online/Offline status already...

[paulik]

tnx for share it again :)

but use search before u post smt this think is shared 123123 times

 

[xMrPwN]

omg... Everyone who downloads a Lineage2 website there is a Online/Offline status already...

im refering to ppl who don't use that ready stuff but have the experience to create sth themselves and need a short guide to help them ;]

[l2death]

i have a problem plz help me.:S add me mjpzzz024@hotmail.com tnx

[tz3]

haha that are the scripts from mine website :

http://www.maxcheaters.com/forum/index.php?topic=115992.0