config.php Page
PHP Code:
<?php
$mssqlcon = "Your Computer Name\SQLEXPRESS";
$mssqluser = "sa";
$mssqlpass = "Your mssql password";
$sv_ip = "xxx.xxx.xxx.xx";
?>
rank.php Page
PHP Code:
<?php
include "./config.php";
?>
<table width="100%" border="0" cellpadding="1" cellspacing="1">
<tr>
<td height="23" colspan="6" background="sub.jpg"><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td><center><?php
$link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
$db = @mssql_select_db('ACCOUNT_DBF') or die ("Accout table is missing!");
$b = '';
$mail = '';
$query = mssql_query('SELECT * FROM [ACCOUNT_TBL]');
echo 'Total Accounts: ' . mssql_num_rows($query);
?></center></td>
<td><center><?php
$link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
$db = @mssql_select_db('CHARACTER_01_DBF') or die ("Accout table is missing!");
$b = '';
$mail = '';
$query = mssql_query('SELECT * FROM [CHARACTER_TBL]');
echo 'Total Characters: ' . mssql_num_rows($query);
?></center></td>
</tr>
</table>
<div align="center" class="style66">TOP 20 </div></td>
</tr>
<tr>
<td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9">
<div align="left" class="style72">No.</div> </td>
<td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9">
<div align="left" class="style72">Name</div> </td>
<td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Level</div></td>
<td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Class</div></td>
<td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Penya</div></td>
<td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Location</div></td>
</tr>
<?
$link = mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") ;
$db = mssql_select_db("CHARACTER_01_DBF");
// Job Funtion
function quetrabajo($job){
if ($job == '0'){
echo "Vagrant";
}
if ($job == '1'){
echo "Mercenary";
}
if ($job == '2'){
echo "Acrobat";
}
if ($job == '3'){
echo "Assist";
}
if ($job == '4'){
echo "Magician";
}
if ($job == '5'){
echo "Puppeter";
}
if ($job == '6'){
echo "Knight";
}
if ($job == '7'){
echo "Blade";
}
if ($job == '8'){
echo "Jester";
}
if ($job == '9'){
echo "Ranger";
}
if ($job == '10'){
echo "Ringmaster";
}
if ($job == '11'){
echo "billposter";
}
if ($job == '12'){
echo "Psykeeper";
}
if ($job == '13'){
echo "Elementor";
}
if ($job == '14'){
echo "Gatekeeper";
}
if ($job == '15'){
echo "Doppler";
}
if ($job == '16'){
echo "M-Knight";
}
if ($job == '17'){
echo "M-Blade";
}
if ($job == '18'){
echo "M-Jester";
}
if ($job == '19'){
echo "M-Ranger";
}
if ($job == '20'){
echo "M-Ringmaster";
}
if ($job == '21'){
echo "M-Billposter";
}
if ($job == '22'){
echo "M-Psykeeper";
}
if ($job == '23'){
echo "M-Elementor";
}
if ($job == '24'){
echo "H-Knight";
}
if ($job == '25'){
echo "H-Blade";
}
if ($job == '26'){
echo "H-Jester";
}
if ($job == '27'){
echo "H-Ranger";
}
if ($job == '28'){
echo "H-Ringmaster";
}
if ($job == '29'){
echo "H-Billposter";
}
if ($job == '30'){
echo "H-Psykeeper";
}
if ($job == '31'){
echo "H-Elementor";
}
}
// Location Funtion
function location($loca){
if ($loca == '1'){
echo "Madrigal";
}
if ($loca == '2'){
echo "Azria";
}
if ($loca == '200'){
echo "Mars Mine Dungeon";
}
if ($loca == '201'){
echo "Dekane Mines";
}
if ($loca == '203'){
echo "Volcano Entrance";
}
if ($loca == '202'){
echo "Guild War Map";
}
if ($loca == '204'){
echo "Ivillis Dungeon";
}
if ($loca == '205'){
echo "Ivillis Dungeon (Boss)";
}
if ($loca == '208'){
echo "Arena";
}
if ($loca == '21'){
echo "Forsaken B1";
}
if ($loca == '22'){
echo "Forsaken B2";
}
if ($loca == '23'){
echo "Forsaken B3";
}
if ($loca == '24'){
echo "Forsaken B4";
}
if ($loca == '25'){
echo "Forsaken B5";
}
if ($loca == '121'){
echo "OMINOUS";
}
if ($loca == '209'){
echo "Mini Room";
}
if ($loca == '3'){
echo "Coral Island";
}
}
$resTop = mssql_query("SELECT TOP 20 P.m_szName, P.m_nLevel, P.m_nJob, P.m_dwGold, P.dwWorldID FROM CHARACTER_01_DBF.dbo.CHARACTER_TBL P ORDER BY P.m_nLevel DESC, P.m_nExp1 DESC ");
$ctr = 1;
while ($row3 = mssql_fetch_array($resTop)){
$chNm = $row3["m_szName"];
$chLv = $row3["m_nLevel"];
$chCls = $row3["m_nJob"];
$chSc= $row3["m_dwGold"];
$chmap = $row3["dwWorldID"];
?>
<tr>
<td bgcolor="#FFFFFF" class="submit"><span class="style68">
<?=$ctr++;?>
</span></td>
<td bgcolor="#FFFFFF" class="submit"><span class="style68">
<?=$chNm;?>
</span></td>
<td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
<?=$chLv;?>
</span></div></td>
<td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
<?=quetrabajo($chCls);?>
</span></div></td>
<td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
<?=$chSc;?>
</span></div></td>
<td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
<?=location($chmap);?>
</span></div></td>
</tr>
<?
}
?>
<tr>
<td colspan="6" background="bg_tile.gif" bgcolor="#666666"> </td>
</tr>
</table>
Originally Posted by Looky
