PDA

View Full Version : help IF YOU CAN !!!


dennis89
12-20-2007, 03:13 PM
HOW CAN I PLACE IN MY SITE THE SERVER STATUS? you know that stats like online-ofline and ( top20,top pk,top pvp....etc) post if you know !!!

sebyyy
12-20-2007, 06:01 PM
hm...i dont know but use the link enter your server IP and port (gameserver and login) press enter and the site will generate a script for the status :) add that script on your webpage
good luck ;)
LINK : blackout-gaming.net/status/
sry because i didnt post with http:/ but i am not allowed to post links i need 10 psots :P

sebyyy
12-20-2007, 08:22 PM
<?php
//first you need to define db info
define('mySQL_hostname', '127.0.0.1'); //database IP
define('mySQL_database', 'Database'); //database name
define('mySQL_username', 'User'); //database user
define('mySQL_password', 'Pass'); //database password

//connects to mysql
$db_link = mysql_pconnect( mySQL_hostname, mySQL_username, mySQL_password )
or die( 'Error connecting to mysql<br><br>'.mysql_error() );

//connects to Database
$db_select = mysql_select_db( mySQL_database, $db_link )
or die( 'Error connecting to Database<br><br>'.mysql_error() );

//selects desired table
$chars=mysql_query("SELECT * FROM characters");

//tells how much rows are there (will come helpfull with while loops)
$rows =mysql_numrows($characters);

$i=0;
$x=0;

//while $i is smaller than number of rows repeat the code
while ($i < $rows) {
$online=mysql_result($chars,$i,"online"); //looks into characters table, under column online(if player is online its "0" else "1"), at row $i
if ($online == 1) { $x++; } // if column online at row $i is "1", increase $x
$i++; //increase $i
}
print 'Online players:<em>'.$x.'<em>'; //prints out the $x number of players online
?>

edit this and add it :) this is for online players

DooMFeaR
01-02-2008, 06:08 AM
You must find a way to make a .php file who include mysql stats...