[Small Release] 5017 PHP Status Checker (LOTF)

irritantgassie · 06/10/2010, 16:06

THIS IS FOR LOTF!!
I Tested It And It Works!!

Code:

<?php
require ("connect.php");

$res = mysql_query("SELECT count(*) FROM accounts;");
$val = mysql_fetch_array($res);
echo "<div style='top'><font color='white'>Accounts Created: ".$val[0]."</div>";

$res = mysql_query("SELECT count(*) FROM characters;");
$val = mysql_fetch_array($res);
echo "<div style='top'><font color='white'>Characters Created: ".$val[0]."</div>";

$ip = "Your Server Ip";
$port = "9958"; //keep this what it is!!
if (! $sock = @fsockopen($ip, $port, $num, $error, 5))
echo "<body bgcolor='black'><font color='white'>Server: </font><B><FONT COLOR=red>Offline</b></FONT>";
else{
echo "<body bgcolor='black'><font color='white'>Server: </font><B><FONT COLOR=lime>Online</b></FONT>";
fclose($sock);
}

$res = mysql_query("SELECT count(*) FROM accounts WHERE online=1;");
$val = mysql_fetch_array($res);
echo "<div style='top'><font color='white'>Total Players Online: ".$val[0]."</div>";
?>

Then make a connect.php

Code:

<?php

$error = "<body bgcolor='black'><font color='white'>Problem connecting to database, Please try again later.</font>";

$connect = mysql_connect("localhost", "root", "password") or die($error);
mysql_select_db("coproj") or die($error);

?>

Then you should see this:

MonstersAbroad · 07/08/2010, 21:53

Think yourl find nobody is gonna use this code.

~~copz1337~~ · 07/09/2010, 01:23

Preview please.

irritantgassie · 07/09/2010, 20:07

Quote:

Originally Posted by copz1337

Preview please.

Ok
#Added preview!

kasene · 07/12/2010, 02:18

messy code....

irritantgassie · 07/12/2010, 12:04

Quote:

Originally Posted by kasene

messy code....

Why messy, its just a PHP Code that works, try something else and it doesnt work so goodluck if you know it better then this code!

JobvdH · 06/18/2011, 12:51

Hmm nice work..

~~pro4never~~ · 06/18/2011, 22:43

Quote:

Originally Posted by JobvdH

Hmm nice work..

Nice like 10 month necro..

[I]Inquisitor · 11/20/2011, 17:55

Good job works !

~~BaussHacker~~ · 11/21/2011, 14:44

Quote:

Originally Posted by pro4never

Nice like 10 month necro..

It's his own account.

Korvacs · 11/21/2011, 15:54

This is a bad way of doing it anyway =/

JobvdH · 12/01/2011, 14:52

Uhh... irritantgassie ain't really my accounts. My brother owns it..