WordPress, Shopify ir PHPFusion programuotojų bendruomenė

Parašė ToOSe· 2008 Kov. 6 17:03:16

nju wa gawua as ta scripta bet jis man neweikia, paziurekit patys http://l2server.xz.lt/status.php

wa scriptas gal pakoreguot ka reikia nzn gal pakoreguokit kas galit

<?php

print'<table width="150">';

$server = "77.79.35.32";

$portg = "7777";

$portl = "9014";

$timeout = "5";

define('mySQL_hostname', '77.79.35.32'); //database IP

define('mySQL_database', 'l2jdb'); //database name

define('mySQL_username', 'root'); //database user

define('mySQL_password', ''); //database password



if ($server and $port and $timeout) {

$game = @fsockopen("$server", $portg, $errno, $errstr, $timeout);

$login = @fsockopen("$server", $portl, $errno, $errstr, $timeout);

}

print'<tr><td align="center"><strong>Server Status</strong></td></tr>';

if($login) { print'<tr><td>Login:</td><td><font color="#00FF00"><strong> Online</strong></font><br><br></td></tr>'; }

else { print'<tr><td>Login:</td><td><font color="#FF0000"><strong> Offline</strong></font><br><br></td></tr>'; }

if($game) { print'<tr><td>Game:</td><td><font color="#00FF00"><strong> Online</strong></font></td></tr>'; }

else { print'<tr><td>Game:</td><td"><font color="#FF0000"><strong> Offline</strong></td></tr>'; }

print'</table>';



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

?>

Redagavo MAnjack· 2008 Kov. 6 18:03:49