<td width="36" height="36" rowspan="2" align="center" valign="middle"> <img src="emblema.php?data=' . $char['guild_id'] . '" alt="."> </td> <td> <font color="#FFFFFF" size="3"><b>' . htmlformat($char['name']) . '<b></font> </td> <td width="150" align="right" valign="middle"> <font size="3" color="#FFFFFF"><b>' . $count . '<b></font> </td> </tr> <tr> <td> <font color="#FFC300"><b>' . ($char['gname'] == '' ? '-- no Guild --' : htmlformat($char['gname'])) . '</b></font> </td> <td align="right"> <font color="#FFC300"><b>' . playtime($char['playtime']) . '</b> </font> </td> </tr> </table> </td> </tr> <tr> <td align="center" valign="middle"> <table width="580" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="110" height="130" align="center" valign="middle"> <img src="./images/class/' . $char['sex'] . '/' . $char['class'] . '.gif"><br> <font size="2" color="#4169E1"><b>' . $jobs[$char['class']] . '</b></font><br> <font color="#FF0000">' . $char['max_hp'] . '</font> / <font color="#0000FF">' . $char['max_sp'] . '</font><br> <a href="profile.php?cid=' . $char['char_id'] . '" target="_blank"><img src="./images/viewprofile.png" border="0"></a> </td>
<th align="left" style="padding:3px;"><span style="font-size:15px; font-weight:bold;"><?php
echo $playerLadder->name;
?>
</span></th>
<th align="right" style="width:100px; padding:3px;"><span style="font-size:15px; font-weight:bold;"><?php
echo $count;
?>
</span></th>
</tr>
<tr>
<th align="left" style="padding:3px;"><?php
echo $playerLadder->gname;
?>
</th>
<th align="right" style="width:100px; padding:3px;"><font color="#FFC300"><?php
echo playtime($playerLadder->playtime);
?>
</font></th>
</tr>
<tr>
<td colspan="3">
<table width="100%" cellpadding="0" cellspacing="0" border="0" style="margin-bottom:0;">
<tr>
<td align="center" style="padding:0;" style="width:100px;">
<?php
if ($job = $this->jobClassText($playerLadder->class)) {
?>
<?php
echo htmlspecialchars($job);
?>
<?php
$total = 0;
while ($char = $mysql->fetcharray($result)) {
echo '
<tr>
<td align="center" width=30><img src="' . $char['sex'] . '.gif"></td>
<td align="left">
' . htmlformat($char['name']) . '
';
if ($char['gname'] != '') {
echo '<br>
<span title="Ver Profile de Guild" style="color:#0000FF; cursor:pointer" onMouseOver="this.style.color=#0000FF" onMouseOut="this.style.color=#0000FF" onClick="return LINK_ajax(\'guildprofile.php?guild_id=' . $char['guild_id'] . '\',\'main_div\');">
<font color="Navy"><b>[' . htmlformat($char['gname']) . ']</b></font>
</span>
';
}
echo '
</td>
<td align="center"><img src="./imgwm/' . $char['class'] . '.gif"><br>' . $jobs[$char['class']] . '</td>
<td align="center">' . $char['base_level'] . '/' . $char['job_level'] . '</td>
<td align="right">' . playtime($char['playtime']) . '</td>
</tr>
';
$total += $char['playtime'];
}
echo '
<tr>
<td align="center" class="head" colspan="5">Tiempo total de Juego : <b>' . playtime($total) . '</b></td>
</tr>
</table>
';
closetable();
<tr>
<td align="center" colspan="9"> </td>
</tr>
<?php
// Consulta de Membresias
$result = $mysql->query("\r\n\t\tSELECT\r\n\t\t\t`members`.`member_id`, `members`.`nombre`, `members`.`email`, SUM(`char`.`playtime`) AS `Time`\r\n\t\tFROM\r\n\t\t\t`members` LEFT JOIN `login` ON `login`.`member_id` = `members`.`member_id` LEFT JOIN `char` ON `char`.`account_id` = `login`.`account_id`\r\n\t\tWHERE\r\n\t\t\t`members`.`ref_email` = '{$email}' AND `login`.`level` = 0 AND `login`.`state` = 0 AND `members`.`member_id` <> '{$member_id}'\r\n\t\tGROUP BY\r\n\t\t\t`members`.`member_id`\r\n\t\tORDER BY\r\n\t\t\t`Time` DESC\r\n\t", $CONFIG['DBMain']);
while ($data = $mysql->fetcharray($result)) {
echo '
<tr>
<td align="left"><b>' . $data['member_id'] . '</b></td>
<td align="center"> </td>
<td align="left">' . htmlformat($data['nombre']) . '</td>
<td align="center"> </td>
<td align="left">' . htmlformat($data['email']) . '</td>
<td align="center"> </td>
<td align="right"><b>' . playtime($data['Time']) . '</b></td>
<td align="center"> </td>
<td align="center">
';
if ($data['Time'] >= 1728000) {
echo '
<form id="id' . $data['member_id'] . '" onsubmit="return POST_ajax(\'refered.php\',\'main_div\',\'id' . $data['member_id'] . '\');">
<input type="hidden" name="member_id" value="' . $data['member_id'] . '">
<input type="hidden" name="opt" value="1">
<input type="submit" value="Cobrar">
</form>
';
} else {
echo '...';
}
echo '
<td align="right" class="head">Play Time</td>
</tr>
<?php
if ($who) {
while ($char = $mysql->fetcharray($who)) {
echo '
<tr>
<td align="center" width=30><img src="' . $char['sex'] . '.gif"></td>
<td align="left">
' . htmlformat($char['name']) . '
';
if ($char['gname'] != '') {
echo '<br>
<span title="Ver Profile de Guild" style="color:#0000FF; cursor:pointer" onMouseOver="this.style.color=#0000FF" onMouseOut="this.style.color=#0000FF" onClick="return LINK_ajax(\'guildprofile.php?guild_id=' . $char['guild_id'] . '\',\'main_div\');">
<font color="Navy"><b>[' . htmlformat($char['gname']) . ']</b></font>
</span>
';
}
echo '
</td>
<td align="center"><img src="./imgwm/' . $char['class'] . '.gif"><br>' . $jobs[$char['class']] . '</td>
<td align="center">' . $char['base_level'] . '/' . $char['job_level'] . '</td>
<td align="right">' . playtime($char['playtime']) . '</td>
</tr>
';
}
}
echo '
</table>
';
closetable();
