[Help] MuResetChars2004

can get any easy script that display resets?

PHP:
<table width=550>                
<tr>
	<td align=center>ID</td>
	<td align=center>Name</td>
	<td align=center>Resets</td>
	<td align=center>Levels</td>
</tr>

<?php
$query = mssql_query("Select Top 20 Name,cLevel,Reset from Character order by Reset desc, cLevel desc");
for($i=0;$i < mssql_num_rows($query);++$i)
{
$row = mssql_fetch_row($query);
$rank = $i+1;
echo"
		<tr>
		<td align=center>$rank</td>
		<td align=center>$row[0]</td>
		<td align=center>$row[2]</td>
		<td align=center>$row[1]</td>	
		</tr>
";
}
?>
</table>
 
PHP:
<table width=550>                
<tr>
	<td align=center>ID</td>
	<td align=center>Name</td>
	<td align=center>Resets</td>
	<td align=center>Levels</td>
</tr>

<?php
$query = mssql_query("Select Top 20 Name,cLevel,Reset from Character order by Reset desc, cLevel desc");
for($i=0;$i < mssql_num_rows($query);++$i)
{
$row = mssql_fetch_row($query);
$rank = $i+1;
echo"
		<tr>
		<td align=center>$rank</td>
		<td align=center>$row[0]</td>
		<td align=center>$row[2]</td>
		<td align=center>$row[1]</td>	
		</tr>
";
}
?>
</table>

Warning: mssql_query(): message: Login failed for user 'WS2003-MYG9HVX2\IUSR_WS2003-MYG9HVX2'. (severity 14) in C:\playMu\simple.php on line 10

Warning: mssql_query(): Unable to connect to server: (null) in C:\playMu\simple.php on line 10

Warning: mssql_query(): A link to the server could not be established in C:\playMu\simple.php on line 10

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\playMu\simple.php on line 11
ID Name Resets Levels
 
lol man, you need a config.php file ...
make a config.php file and there write
PHP:
<?
$host = "IP";
$database = "MuOnline";
$user = "sa";
$password = "SQL PASS";

$connect = mssql_connect($host,$user,$password);
$db = mssql_select_db($database,$connect);
if(!$db) die("<center>Connection with SQL Server failed!</center>");

?>
then go to the ranking and on the top line write
PHP:
<? require("config.php"); ?>
 
Last edited: