[Help] Online time module

total4o

Active Member
Joined
Jul 23, 2009
Messages
214
Reaction score
25
Трябва ми модул за Online Time за Eva Web 2.0 в стария ми сайт имах, но когато се опитах да го сложа не тръгва, излизат ми доста грешки.
 
пробвай с тоя ако не стане драсни да го нагласим :)

Code:
<table id="mutable" class="maintable" width="440" border="1" bordercolor="red" cellpadding="0" cellspacing="1" >                
<center><tr>
<td width="10" align=left><font color=orange><center><b>&nbsp;&nbsp;#&nbsp;&nbsp;</b></center></font></td>
<td width="80" align=left><font color=red><b>&nbsp;&nbsp;Character&nbsp;&nbsp;</b></font></td>
<td width="200" align=left><font color=green><center><b>&nbsp;&nbsp;Player Online Time&nbsp;&nbsp;</b></center></font></td>
<td width="30" align=left><font color=orange><center><b>&nbsp;&nbsp;Status&nbsp;&nbsp;</b></center></font></td>
</tr></center>';
$total = mssql_num_rows(mssql_query("SELECT * FROM Memb_stat where memb___id like '%%'"));


$lines = '10';
if(!isset($_GET['pages']))
{
$limit='0';
$pagesa='1';
}
else
{
$page = (int)$_GET['pages'];

$pages = $page - 1;
$pagesa =$page;
$limit = $lines * $pages;
}

   
$total = ceil($total/$lines);
$query = mssql_query("Select Top $lines memb___id,TotalTime,ConnectStat From MEMB_STAT where memb___id not in (Select TOP $limit memb___id from MEMB_STAT order by TotalTime desc) Order By TotalTime desc");
for($i=0;$i < mssql_num_rows($query);++$i)
{
$row = mssql_fetch_row($query);
if($row[2]==1){ $stat="<span class='online'><img src=./images/online.gif width=60 height=15></span>"; }elseif($row[2]==0){ $stat="<span class='offline'><img src=./images/offline.gif width=60 height=15></span>";}
$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,ctlcode,adminlevel From Character where Name='$accchar[0]'";
$resultchar = mssql_query($querychar);
$charr = mssql_fetch_row($resultchar);

$mins = $row[1];
$hours = floor($mins/60);
$days = floor($hours/24);
$hours = $hours % 24;
$mins = $row[1] % 60;
$charr= htmlspecialchars(addslashes($accchar[0]));

if ($charr[1] == 0) { $class = "Dark Wizard"; }
if ($charr[1] == 1) { $class = "Soul Master"; }
if ($charr[1] == 16) { $class = "Dark Knight"; }
if ($charr[1] == 17) { $class = "Blade Knight"; }
if ($charr[1] == 32) { $class = "Elf"; }
if ($charr[1] == 33) { $class = "Muse Elf"; }
if ($charr[1] == 48) { $class = "Magic Gladiator"; }

$rank = $i+1+$limit;
echo "<center><tr>
<td align=left><font size=1 color=#fffffff><b><center>$rank.</center></b></font></td>

<td align=left><font size=2 color=#94681c><b><center>$charr</a></center></b></td>
<td align=left><font size=2 color=#94681c><b><center>$days Days, $hours Hours, $mins Minutes</center></b></td>
<td align=left><font size=1 color=#999999><b><center>$stat</a></center></b></td>
</center></tr>
";

}
echo "</table><br />";
 if($total >0){
 echo '<center><font color=white>';
 if(($pagesa-1) > 0)echo '<a href="index.php?op=time&rank=time&pages='.($page-1).'"><b>&lt;&lt;Previous</b></a> ';
 echo '<b>[Page '.$pagesa.' of total '.$total.']</b>';
 if(($pagesa+1) <= $total)echo ' <a href="index.php?op=time&rank=time&pages='.($pagesa+1).'"><b>Next&gt;&gt;</b></a>';
 echo '</font></center><br>';}
?>
</center>