07-05-2013, 12:55 PM
|
#1
|
|
• الانـتـسـاب » Sep 2012
|
• رقـم العـضـويـة » 105332
|
• المشـــاركـات » 319
|
• الـدولـة »
|
• الـهـوايـة » Hex,PHP,C#,SQL
|
• اسـم الـسـيـرفـر » No Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 43
|
|
|
Add Unique ranking to your site
Hello Silkroad4arab
Full code php By Yui
كود:
<?
$host = "PC-\SQLEXPRESS";
$user = "sa";
$pass = "your password";
$db = "SRO_VT_SHARD";
$show = "50";
$sConn = odbc_connect("Driver={SQL Server};Server={".$host."}; Database={".$db."}", "".$user."", "".$pass."") or die("<center><b style=\"border:1px dashed #FF0000;\">".str_replace("[Microsoft][ODBC SQL Server Driver][SQL Server]", "", odbc_errormsg())."</b></center>");
$sorgu = odbc_exec($sConn,"SELECT top 50 * FROM UniqueRanking ORDER BY Score DESC");
echo '<table border=1>
<tr>
<th><font color="#FF0000">Char Name</font></th>
<th><font color="#008000">Score</font></th>
<th><font color="#008000">ivy</font></th>
<th><font color="#008000">Uruchi</font></th>
<th><font color="#008000">Isyutaru</font></th>
<th><font color="#008000">Tiger</font> </th>
<th><font color="#008000">Demon </font></th>
<th><font color="#008000">Cerberus</font></th>
<th><font color="#008000">Lord</font></th>
<th><font color="#00FF00">Medusa</font></th>
<th><font color="#00FF00">Roc</font></th>
<th><font color="#00FF00">Yuno</font></th>
</tr>';
while($row = odbc_fetch_array($sorgu))
{
echo '
<tr>
<td>'.$row['CharName'].'</td>
<td>'.$row['Score'].'</td>
<td>'.$row['MOB_AM_IVY'].'</td>
<td>'.$row['MOB_OA_URUCHI'].'</td>
<td>'.$row['MOB_KK_ISYUTARU'].'</td>
<td>'.$row['MOB_CH_TIGERWOMAN'].'</td>
<td>'.$row['MOB_EU_KERBEROS'].'</td>
<td>'.$row['MOB_RM_TAHOMET'].'</td>
<td>'.$row['MOB_TK_BONELORD'].'</td>
<td>'.$row['MOB_TQ_WHITESNAKE'].'</td>
<td>'.$row['MOB_RM_ROC'].'</td>
<td>'.$row['MOB_JUPITER_YUNO'].'</td>
</tr>
';
}
echo '</table>';
?>
|
|
|