function displayScouts(&$db, &$messageBox, &$player, $read, $group) { if ($group) { //here we group new messages $query = 'SELECT alignment, player_id, sender_id, player_name AS sender, count( message_id ) AS number, min( send_time ) as first, max( send_time) as last, msg_read FROM message JOIN player ON player.account_id = message.sender_id AND message.game_id = player.game_id WHERE message.account_id = ' . $db->escapeNumber($player->getAccountID()) . ' AND player.game_id = ' . $db->escapeNumber($player->getGameID()) . ' AND message_type_id = ' . $db->escapeNumber(MSG_SCOUT) . ' AND receiver_delete = ' . $db->escapeBoolean(false) . ' AND msg_read = ' . $db->escapeBoolean($read) . ' GROUP BY sender_id, msg_read ORDER BY send_time DESC'; $db->query($query); while ($db->nextRecord()) { //display grouped stuff (allow for deletion) $playerName = get_alignment_text($db->getField('alignment'), stripslashes($db->getField('sender')) . ' (' . $db->getField('player_id') . ')'); $message = 'Your forces have spotted ' . $playerName . ' passing your forces ' . $db->getField('number') . ' times.'; displayGrouped($messageBox, $playerName, $db->getField('player_id'), $db->getField('sender_id'), $message, $db->getField('first'), $db->getField('last'), $db->getField('msg_read') == 'FALSE'); } } else { //not enough to group, display separately $query = 'SELECT message_id, account_id, sender_id, message_text, send_time, msg_read FROM message WHERE account_id = ' . $db->escapeNumber($player->getAccountID()) . ' AND game_id = ' . $db->escapeNumber($player->getGameID()) . ' AND message_type_id = ' . $db->escapeNumber(MSG_SCOUT) . ' AND receiver_delete = ' . $db->escapeBoolean(false) . ' AND msg_read = ' . $db->escapeBoolean($read) . ' ORDER BY send_time DESC'; $db->query($query); while ($db->nextRecord()) { displayMessage($messageBox, $db->getField('message_id'), $db->getField('account_id'), $db->getField('sender_id'), stripslashes($db->getField('message_text')), $db->getField('send_time'), $db->getField('msg_read'), MSG_SCOUT); } } }
$PHP_OUTPUT .= '<input type="number" class="center" name="minValue" size="3" value="' . $minValue . '">'; $PHP_OUTPUT .= '</td><td>-</td><td>'; $PHP_OUTPUT .= '<input type="number" class="center" name="maxValue" size="3" value="' . $maxValue . '">'; $PHP_OUTPUT .= '</td><td>'; $PHP_OUTPUT .= $form['submit']; $PHP_OUTPUT .= '</td></tr></table></form>'; $PHP_OUTPUT .= '<table class="standard inset"><tr><th>#</th><th>Date</th><th>Trader</th><th>Withdrawal</th><th> Deposit </th></tr>'; $container = create_container('skeleton.php', 'trader_search_result.php'); while ($db->nextRecord()) { $PHP_OUTPUT .= '<tr><td class="shrink center">'; $PHP_OUTPUT .= $db->getInt('transaction_id'); $PHP_OUTPUT .= '</td><td class="shrink center noWrap">'; $PHP_OUTPUT .= date(DATE_FULL_SHORT_SPLIT, $db->getInt('time')); $PHP_OUTPUT .= '</td><td>'; $container['player_id'] = $db->getInt('player_id'); $PHP_OUTPUT .= create_link($container, get_alignment_text($db->getInt('alignment'), $db->getField('player_name'))); $PHP_OUTPUT .= '</td><td class="shrink right">'; if ($db->getField('transaction') == 'Payment') { $PHP_OUTPUT .= number_format($db->getInt('amount')); } else { $PHP_OUTPUT .= ' '; } $PHP_OUTPUT .= '</td><td class="shrink right">'; if ($db->getField('transaction') == 'Deposit') { $PHP_OUTPUT .= number_format($db->getInt('amount')); } else { $PHP_OUTPUT .= ' '; } $PHP_OUTPUT .= '</td></tr>'; } $PHP_OUTPUT .= '<tr>';