hola queria pedir ayuda sobre un modulo, el cual es Usuarios VIP.
uso files darksteam 1.0m
quiziera saber porque no me cuenta los VIP la suguinte Query
<style type="text/css">
table.themain a { color: orange; }
table.themain a:hover { color: white; }
table.themain td {font-family: arial; font-size: 12px; padding: 1px 2px 1px 2px; height: 22px;
line-height:22px; color: white;}
table.themain th {font-family: arial; font-size: 12px; background-color: #29251C; font-weight:
bold; color: #FFE3AD; padding: 1px 2px 1px 2px;}
table.themain tr {background-color: #0B0A08; color: #FFE3AD;}
table.themain tr.odd {background-color: #29251C; color: #FFE3AD;}
a.thsort:link, a.thsort:visited {color:white; font-weight:bold; text-decoration:none;}
a.thsort:hover {color:orange; text-decoration:underline;}
</style>
<div align="center"><font size="3">List of VIP Users</font></div>
<table class="themain" width="95%" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<th width="33%" class="iR_stats">Cuentas</th>
<th width="34%" class="iR_stats">VIP finaliza</th>
<th width="33%" class="iR_stats">Estado</th>
</tr>
<?php
$cas = date("Y-m-d H:i:s",strtotime(now));
$query = mssql_query("select Date,AccountID,TypeT_VIPListb_info where Type > 0 and Date >
'$cas'");
$count1=0;
$odd = FALSE;
while($row = mssql_fetch_assoc($query))
{
$date = $row['Date'];
$account = $row['AccountID'];
$onlinestat = mssql_query("select memb___id,ConnectStat from MEMB_STAT where
memb___id='$account'");
$online = mssql_fetch_array($onlinestat);
if($online['ConnectStat'] == 0)
$status = '<font color="red">Offline</font>';
elseif($online['ConnectStat'] == 1)
$status = '<font color="green">Online</font>';
else
$status = 'Unknown';
if($odd)
echo '<tr class="odd">';
else
echo '<tr>';
$odd = !$odd;
?>
<td class='trhover' align='center'><?php echo $account; ?></td>
<td class='trhover' align='center'><?php echo date("d.m.Y H:i:s",strtotime($date)); ?></td>
<td class='trhover' align='center'><?php echo $status; ?></td>
</tr>
<?
}
?>
</table>