<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();