- Joined
- Apr 20, 2008
- Messages
- 123
- Reaction score
- 0
I get this error in my site o.o
"Server StatsUnknown column 'sitelogged' in 'where clause'"
To view the content, you need to sign in or register
Run the SQLs. o-o.
I get this error in my site o.o
"Server StatsUnknown column 'sitelogged' in 'where clause'"
To view the content, you need to sign in or register
<td align="left" valign="top" class="left_line"> </td>
<td align="left" valign="top"><strong>Server Stats<strong><?php
$result = mysql_query("SELECT * FROM accounts");// Account section
$num_rows = mysql_num_rows($result);
$result2 = mysql_query("SELECT * FROM characters");// Character section
$num_rowsc = mysql_num_rows($result2);
$result15 = mysql_query("SELECT * FROM guilds");// Character section
$num_rowsg = mysql_num_rows($result15);
$result4 = mysql_query("SELECT * FROM accounts where banned = 1");// Account section
$num_rowsb = mysql_num_rows($result4);
$result5 = mysql_query("SELECT * FROM accounts where loggedin = 2");// Account section
$num_rowsl = mysql_num_rows($result5);
echo "<br><br>
<b>".getOnline()."</b> WebUsers Online<br />
<b>".$num_rows1."</b> Users Playing<br><br>
<b>".$num_rows."</b> Accounts<br>
<b>".$num_rowsc."</b> Characters<br>
<b>".$num_rowsg."</b> Guilds<br><br>
<b>".$num_rowsb."</b> Banned Hackers<br>
";
?>
<br>
<?php
echo $logserv_name;
$fp = @fsockopen($serverip, $loginport, $errno, $errstr, 1);
if (!$fp) {
echo $offline;
} else {
echo $online;
}
@fclose($fp);
?></td>