- Joined
- May 18, 2008
- Messages
- 1,943
- Reaction score
- 446
реших да споделя за хората които ползват сезон 4 и нагоре 1 не чак толкова трудно но на мен лично ми харесва и реших да го споделя с форума
Screen:
PHP:
<?php
require 'config.php';
$query = 'Select memb___id, ConnectTM, ConnectTm, OnlineHours From MEMB_STAT where Connectstat=1 order by ConnectTM desc';
$result = mssql_query( $query );
echo '<center><TABLE border=0 cellPadding=2 cellSpacing=2>
<table id="mutable" class="alt5" height=10 border="1" bordercolor="#555555" cellpadding="0" cellspacing="0" >
<tr>
<td align=left width=5><font color=#FFFFFF><center>ID</center></font></td>
<td align=left width=100><font color=#FFFFFF><center>Character</center></font></td>
<td align=left width=130><font color=#FFFFFF><center>Game in time</center></font></td>
<td align=left width=30><font color=#FFFFFF><center>Level</center></font></td>
<td align=left width=20><font color=#FFFFFF><center>Resets</center></font></td>
<td align=left width=40><font color=#FFFFFF><center>Class</center></font></td>
<td align=left width=90><font color=red><center>Master Level</center></font></td>
<td align=left width=90><font color=gold><center>Total Online</center></font></td>
</tr></center>';
$waw = mssql_query("SELECT count(*) From MEMB_STAT where Connectstat=1");
$xex = mssql_result($waw, 0, 0);
$color = 'darkblue';
for($i=0;$i < $xex;++$i)
{
$row = mssql_fetch_row($result);
$querychar = "Select GameIDC From AccountCharacter where Id='$row[0]'";
$resultchar = mssql_query( $querychar );
$accchar = mssql_fetch_row($resultchar);
$querychar = "Select Name,Class,MapNumber,clevel,resets,SCFMasterlevel,ctlcode From Character where Name='$accchar[0]'";
$resultchar = mssql_query( $querychar );
$charr = mssql_fetch_row($resultchar);
$rank = $i+1;
//Class
if ($charr['1'] == 0) { $charr[1] = "DW"; }
if ($charr['1'] == 2) { $charr[1] = "GrM"; }
if ($charr['1'] == 1) { $charr[1] = "SM"; }
if ($charr['1'] == 16) { $charr[1] = "DK"; }
if ($charr['1'] == 18) { $charr[1] = "BM"; }
if ($charr['1'] == 17) { $charr[1] = "BK"; }
if ($charr['1'] == 32) { $charr[1] = "Elf"; }
if ($charr['1'] == 34) { $charr[1] = "HE"; }
if ($charr['1'] == 33) { $charr[1] = "ME"; }
if ($charr['1'] == 48) { $charr[1] = "MG"; }
if ($charr['1'] == 50) { $charr[1] = "DM"; }
if ($charr['1'] == 64) { $charr[1] = "DL"; }
if ($charr['1'] == 66) { $charr[1] = "LE"; }
if ($charr['1'] == 80) { $charr[1] = "Sum"; }
if ($charr['1'] == 81) { $charr[1] = "BlS"; }
if ($charr['1'] == 82) { $charr[1] = "DiM"; }
// Credits By KR373N
echo "<center><tr>
<td align=left <font size=1 color=#FFFFFF><b><center>$rank</center></b></font></td>
<td align=left <font color=#FFFFFF><b><center>$accchar[0]</center></b></td>
<td align=left <font color=#FFFFFF><center>$row[2]</center></td>
<td align=left <font color=#FFFFFF><b><center>$charr[3]</center></b></td>
<td align=left <font color=#FFFFFF><b><center>[$charr[4]]</center></b></td>
<td align=left <font color=#FFFFFF><b><center>$charr[1]</center></b></td>
<td align=left <font color=red><b><center>$charr[5] Level</center></b></td>
<td align=left <font color=gold><b><center>$row[3] Hours</center></b></td>
</center></tr>
";
}
// DarksTeam
?>
</table>
Last edited: