echo '</th>'; $container['category'] = 'combat_drones'; echo '<th>'; print_header_link($container, 'Combat Drones'); echo '</th>'; $container['category'] = 'scout_drones'; echo '<th>'; print_header_link($container, 'Scout Drones'); echo '</th>'; $container['category'] = 'mines'; echo '<th>'; print_header_link($container, 'Mines'); echo '</th>'; $container['category'] = 'expire_time'; echo '<th>'; print_header_link($container, 'Expire time'); echo '</th>'; echo '</tr>'; while ($db->next_record()) { echo '<tr><td>'; echo stripslashes($db->f('player_name')); echo '</td><td class="shrink nowrap">'; echo $db->f('sector') . ' (' . $db->f('galaxy_name'); echo ')</td><td class="shrink center">'; echo $db->f('combat_drones'); echo '</td><td class="shrink center">'; echo $db->f('scout_drones'); echo '</td><td class="shrink center">'; echo $db->f('mines'); echo '</td><td class="shrink nowrap">'; echo date('n/j/Y g:i:s A', $db->f('expire_time'));
$container['sequence'] = 'DESC'; } // do we have any alliances? if ($db->nf() > 0) { echo '<table cellspacing="0" cellpadding="0" class="standard inset"><tr><th>'; $container['order'] = 'alliance_name'; print_header_link($container, 'Alliance Name'); echo '</th><th class="shrink">'; $container['order'] = 'alliance_xp'; print_header_link($container, 'Total Experience'); echo '</th><th class="shrink">'; $container['order'] = 'alliance_avg'; print_header_link($container, 'Average Experience'); echo '</th><th class="shrink">'; $container['order'] = 'alliance_member_count'; print_header_link($container, 'Members'); echo '</th>'; echo '</tr>'; while ($db->next_record()) { if ($db->f('alliance_id') != $player->alliance_id) { $container['body'] = 'alliance_roster.php'; } else { $container['body'] = 'alliance_mod.php'; } $container['alliance_id'] = $db->f('alliance_id'); echo '<tr><td>'; print_link($container, stripslashes($db->f('alliance_name'))); echo '</td>'; echo '<td class="right">' . $db->f('alliance_xp') . '</td>'; echo '<td class="right">' . $db->f('alliance_avg') . '</td>'; echo '<td class="right">' . $db->f('alliance_member_count') . '</td></tr>';