if i started use lgkeiz database then
and
Code:
[CENTER][B]Warning[/B]: mssql_query() [[URL="http://forum.ragezone.com/function.mssql-query"]function.mssql-query[/URL]]: message: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16) in [B]C:\AppServ\www\top.php[/B] on line [B]53[/B]
[B]Warning[/B]: mssql_query() [[URL="http://forum.ragezone.com/function.mssql-query"]function.mssql-query[/URL]]: Query failed in [B]C:\AppServ\www\top.php[/B] on line [B]53[/B]
[B]Warning[/B]: mssql_fetch_row(): supplied argument is not a valid MS SQL-result resource in [B]C:\AppServ\www\top.php[/B] on line [B]54[/B]
Top 100 Player List [B]Bil[/B] [B]Name[/B] [B]Level[/B] [B]ClanName[/B] [B]Exp[/B] [B]Bounty[/B] [B]TotalKilss[/B] [B]TotalDeath[/B] [B]PlayTime[/B]
[B]Warning[/B]: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in [B]C:\AppServ\www\top.php[/B] on line [B]78[/B]
[/CENTER]
[CENTER]
[/CENTER]
Code:
<?php include "Config.php";?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="style.css" rel="stylesheet" type="text/css" />
<title><?=$servername?></title>
<style type="text/css">
<!--
.style1 {
color: #FFFFFF;
font-weight: bold;
}
.style53 {color: #CEAA7B;
font-size: 13px;
font-weight: bold;
}
.style10 {color: #FFFFFF}
.style11 {color: #FF0000}
.bottom {font-family: Verdana, Tahoma, Arial, sans-serif; font-size: 10px; color: #FEFEFE;}
-->
</style>
</head>
<body>
<div id="container">
<div id="header"></div>
<div id="menu">
<ul>
<li><a href="features.php">Features</a></li>
<li> <div align="center"><a href="index.php">Home</a></div></li>
<li> <div align="center"><a href="login.php">Login</a></div></li>
<li><a href="register.php">Register</a></li>
<li><a href="takepics.php">Screenhots</a></li>
<li><a href="top.php">Top</a></li>
<li><a href="links.php">Download</a></li>
<li><a href="forum.php">Forum</a></li>
<li><a href="video.php">Videos</a></li>
<li><a href="changepass.php">Pass Change</a></li>
</ul>
<h1>Top Players</h1>
<h2>Server Info</h2>
</div>
<div id="main"><br />
<div id="content">
<div id="left">
<div align="center"><?php include "Config.php";
?>
<link rel="stylesheet" type="text/css" href="style.css">
<?php
$query = mssql_query("SELECT TOP 9999 * FROM Character order by XP desc");
$result= mssql_fetch_row($query);
?>
<style type="text/css">
<!--
.style28 {font-size: 10px}
.style29 {color: #FFFFFF; font-weight: bold; font-size: 10px; }
-->
</style>
<table width="442" border="1">
<tr >
<th colspan="8" scope="row"><span class="style28">Top 100 Player List </span></th>
</tr>
<tr>
<th width="19" scope="row"><span class="style28"><strong>Bil</strong></span></th>
<td width="36"><span class="style28"><strong>Name</strong></span></td>
<td width="32"><span class="style28"><strong>Level</strong></span></td>
<td width="63"><span class="style28"><strong>ClanName</strong></span></td>
<td width="24"><span class="style28"><strong>Exp</strong></span></td>
<td width="42"><span class="style28"><strong>Bounty</strong></span></td>
<td width="61"><span class="style28"><strong>TotalKilss</strong></span></td>
<td width="54"><span class="style28"><strong>TotalDeath</strong></span></td>
<td width="54"><span class="style28"><strong>PlayTime</strong></span></td>
<?php
for($i='';$i < mssql_num_rows($query);++$i)
{
$row = mssql_fetch_row($query);
$rank = $i+1;
?> <tr>
<th scope="row"><span class="style28"><strong><?php echo "$rank";?></strong></span></th>
<td><span class="style28"><strong><?php echo "$row[1]" ;?></strong></span></td>
<td><span class="style28"><strong><?php echo "$row[3]";?></strong></span></td>
<td><span class="style29"><?php echo "$row[8]";?></span></td>
<td><span class="style29"><?php echo "$row[9]";?></span></td>
<td><span class="style29"><?php echo "$row[10]";?></span></td>
<td><span class="style29"><?php echo "$row[31]";?></span></td>
<td><span class="style29"><?php echo "$row[32]";?></span></td>
<td><span class="style29"><?php echo "$row[33]";?></span></td>
</tr>
<?php }?>
</table></div>
<p align="center"> </p>
<p> </p>
<p> </p>
</div>
<div id="right">
<div align="left">
<p class="style53">Server Status :
<?php
echo "<br><B></B> ";
$fp = @fsockopen($srvip, $srvport, $errno, $errstr, 1);
if (!$fp) {
echo "<font style='color: #FF3300'><B>Offline</B></font></br>";
} else {
echo "<font style='color: #009933'><B>Online</B></font></br>";
fclose($fp);
}
?>
</p>
<p class="style53">
<?php
$query = mssql_query("SELECT * FROM Accounts");
$num_rows = mssql_num_rows($query);
echo "Total Accounts: ".$num_rows."<br>";
?>
</p>
<p class="style53">Total Character:<strong>
<?php
$query = mssql_query("SELECT * FROM Character");
$num_rows = mssql_num_rows($query);
echo "$num_rows"; ?>
</strong></p>
<p class="style53">Server Exp :<font face="arial" size="2">
<?=$serverexp?>
</font></p>
<p class="style53">Server Bounty: <font face="arial">
<?=$serverbp?>
</font></p>
</div>
</div>
<div class="clear">
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</div>
</div>
</div>
<div id="footer">
<br /><br />
<ul>
<li></li>
</ul>
<div align="center" class="style1">EstoniaGunZ</div>
</div>
</div>
</body>
</html>
<script language="JavaScript" type="text/javascript">
<!-- Zone Counter
var h = "<a href=\"http://counter.zone.ee/stats.php3?rid=951W755E\" TARGET=\"_blank\">" +
"<img src=\"http://counter.zone.ee/count.php3?cid=951W755E&ref="+top.document.referrer+"\" BORDER=\"0\" ALT=\"Zone Counter\"><" +
"/a>";
document.write(h);
// -->
</script>
<noscript>
<a href="http://counter.zone.ee/stats.php3?rid=951W755E&ref=" TARGET="_blank">
<img src="http://counter.zone.ee/count.php3?cid=951W755E&ref=" BORDER="0" ALT="Zone Counter">
</a>
</noscript>
Code:
<p class="style53">Total Character:<strong>
<?php
$query = mssql_query("SELECT * FROM Character");
$num_rows = mssql_num_rows($query);
echo "$num_rows"; ?>
Code:
Total Character:
Warning: mssql_query() [function.mssql-query]: message: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16) in C:\AppServ\www\changepass.php on line 195
Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\changepass.php on line 195
Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\changepass.php on line 196
