/** * Someone changed his nick */ function user_nick($fp, $rdata) { if (preg_match('/^:(.*)!(.*)@(.*)\\sNICK\\s:(.*)\\s$/i', $rdata, $msg)) { $nick = $msg[1]; $user = $msg[2]; $host = $msg[3]; $new_nick = $msg[4]; echo_r('[NICK] ' . $nick . ' -> ' . $new_nick); // database object $db = new SmrMySqlDatabase(); $db2 = new SmrMySqlDatabase(); $channel_list = array(); // 'sign off' all active old_nicks (multiple channels) $db->query('SELECT * FROM irc_seen WHERE nick = ' . $db->escapeString($nick) . ' AND signed_off = 0'); while ($db->nextRecord()) { $seen_id = $db->getInt('seen_id'); // remember channels where this nick was active array_push($channel_list, $db->getField('channel')); $db2->query('UPDATE irc_seen SET signed_off = ' . time() . ' WHERE seen_id = ' . $seen_id); } // now sign in the new_nick in every channel foreach ($channel_list as $channel) { // 'sign in' the new nick $db->query('SELECT * FROM irc_seen WHERE nick = ' . $db->escapeString($new_nick) . ' AND channel = ' . $db->escapeString($channel)); if ($db->nextRecord()) { // exiting nick? $seen_id = $db->getField('seen_id'); $db->query('UPDATE irc_seen SET ' . 'signed_on = ' . time() . ', ' . 'signed_off = 0, ' . 'user = '******', ' . 'host = ' . $db->escapeString($host) . ', ' . 'registered = NULL ' . 'WHERE seen_id = ' . $seen_id); } else { // new nick? $db->query('INSERT INTO irc_seen (nick, user, host, channel, signed_on) VALUES(' . $db->escapeString($new_nick) . ', ' . $db->escapeString($user) . ', ' . $db->escapeString($host) . ', ' . $db->escapeString($channel) . ', ' . time() . ')'); } } unset($channel_list); return true; } return false; }
<?php // new db object $db = new SmrMySqlDatabase(); $loginNews = array(); $db->query('SELECT * FROM game_news ORDER BY time DESC LIMIT 2'); while ($db->nextRecord()) { $loginNews[] = array('Message' => $db->getField('message'), 'AdminName' => $db->getField('admin_name'), 'Time' => date(DEFAULT_DATE_DATE_SHORT, $db->getField('time')), 'Recent' => TIME - $db->getField('time') < 24 * 3600); } if (count($loginNews) > 0) { $template->assign('LoginNews', $loginNews); } $db->query('SELECT count(*) AS active_sessions FROM active_session WHERE account_id!=0 AND last_accessed > ' . $db->escapeNumber(TIME - SmrSession::TIME_BEFORE_EXPIRY)); $db->nextRecord(); $template->assign('ActiveSessions', $db->getField('active_sessions')); $gameNews = array(); $db->query('SELECT * FROM news ORDER BY time DESC LIMIT 4'); while ($db->nextRecord()) { $overrideGameID = $db->getInt('game_id'); $gameNews[] = array('Date' => date(DEFAULT_DATE_DATE_SHORT, $db->getField('time')), 'Time' => date(DEFAULT_DATE_TIME_SHORT, $db->getField('time')), 'Message' => bbifyMessage($db->getField('news_message'))); } unset($overrideGameID); if (count($gameNews) > 0) { $template->assign('GameNews', $gameNews); } include_once 'story.php'; $template->display('login_new.inc');
<?php require_once '../htdocs/config.inc'; require_once LIB . 'Default/SmrMySqlDatabase.class.inc'; require_once LIB . 'Default/Globals.class.inc'; require_once LIB . 'Default/SmrPort.class.inc'; $db = new SmrMySqlDatabase(); $db->query('SELECT account_id,sector_id,game_id FROM player_visited_port'); while ($db->nextRecord()) { SmrPort::getCachedPort($db->getInt('game_id'), $db->getInt('sector_id'), $db->getInt('account_id'))->addCachePort($db->getInt('account_id')); SmrPort::clearCache(); }
$PHP_OUTPUT .= '<p> </p>'; $PHP_OUTPUT .= '<p>'; while ($db->nextRecord()) { if ($anon_id != $db->getField('anon_id')) { // if this is not the first entry we have to close previous list if ($anon_id > 0) { $PHP_OUTPUT .= '</ul>'; } // set current anon_id $anon_id = $db->getInt('anon_id'); // start topic for it $PHP_OUTPUT .= 'Account #' . $anon_id; $PHP_OUTPUT .= '<ul>'; } $curr_account =& SmrAccount::getAccount($db->getInt('account_id')); $transaction_id = $db->getInt('transaction_id'); $db2->query('SELECT * FROM anon_bank_transactions WHERE account_id = ' . $db2->escapeNumber($curr_account->getAccountID()) . ' AND anon_id = ' . $db2->escapeNumber($anon_id) . ' AND transaction_id = ' . $db2->escapeNumber($transaction_id)); if ($db2->nextRecord()) { $text = strtolower($db2->getField('transaction')) . ' ' . number_format($db2->getInt('amount')) . ' credits'; } $PHP_OUTPUT .= '<li>' . $curr_account->getLogin() . ' ' . $text . '</li>'; } $PHP_OUTPUT .= '</ul>'; $PHP_OUTPUT .= '</p>'; $PHP_OUTPUT .= '<p> </p>'; $PHP_OUTPUT .= '<p>'; $PHP_OUTPUT .= create_link(create_container('skeleton.php', 'log_console.php'), '<b>< Back</b>'); $PHP_OUTPUT .= '</p>';
while ($db2->nextRecord()) { $votedFor[$db2->getField('vote_id')] = $db2->getField('option_id'); } $voting = array(); while ($db->nextRecord()) { $voteID = $db->getField('vote_id'); $voting[$voteID]['ID'] = $voteID; $container = array(); $container['body'] = 'game_play.php'; $container['url'] = 'vote_processing.php'; $container['vote_id'] = $voteID; $voting[$voteID]['HREF'] = SmrSession::getNewHREF($container); $voting[$voteID]['Question'] = $db->getField('question'); $voting[$voteID]['TimeRemaining'] = format_time($db->getField('end') - TIME, true); $voting[$voteID]['Options'] = array(); $db2->query('SELECT option_id,text,count(account_id) FROM voting_options LEFT OUTER JOIN voting_results USING(vote_id,option_id) WHERE vote_id = ' . $db->escapeNumber($db->getInt('vote_id')) . ' GROUP BY option_id'); while ($db2->nextRecord()) { $voting[$voteID]['Options'][$db2->getField('option_id')]['ID'] = $db2->getField('option_id'); $voting[$voteID]['Options'][$db2->getField('option_id')]['Text'] = $db2->getField('text'); $voting[$voteID]['Options'][$db2->getField('option_id')]['Chosen'] = isset($votedFor[$db->getField('vote_id')]) && $votedFor[$voteID] == $db2->getField('option_id'); $voting[$voteID]['Options'][$db2->getField('option_id')]['Votes'] = $db2->getField('count(account_id)'); } } $template->assign('Voting', $voting); } // *************************************** // ** Donation Link // *************************************** $template->assign('DonateLink', SmrSession::getNewHREF(create_container('skeleton.php', 'donation.php'))); // *************************************** // ** Announcements View
$commentsContainer['body'] = 'feature_request_comments.php'; $db2 = new SmrMySqlDatabase(); $featureRequests = array(); while ($db->nextRecord()) { $featureRequestID = $db->getInt('feature_request_id'); $featureRequests[$featureRequestID] = array('RequestID' => $featureRequestID, 'Message' => $db->getField('text'), 'Votes' => array('FAVOURITE' => $db->getInt('fav'), 'YES' => $db->getInt('yes'), 'NO' => $db->getInt('no')), 'VotedFor' => isset($featureVotes[$featureRequestID]) ? $featureVotes[$featureRequestID] : false); if ($featureModerator) { $featureRequests[$featureRequestID]['RequestAccount'] =& SmrAccount::getAccount($db->getInt('poster_id')); } if ($var['Status'] == 'Opened') { $db2->query('SELECT COUNT(*), vote_type FROM account_votes_for_feature WHERE feature_request_id=' . $db2->escapeNumber($featureRequestID) . ' GROUP BY vote_type'); while ($db2->nextRecord()) { $featureRequests[$featureRequestID]['Votes'][$db2->getField('vote_type')] = $db2->getInt('COUNT(*)'); } } $db2->query('SELECT COUNT(*) FROM feature_request_comments WHERE feature_request_id=' . $db2->escapeNumber($featureRequestID)); while ($db2->nextRecord()) { $featureRequests[$featureRequestID]['Comments'] = $db2->getInt('COUNT(*)'); } $commentsContainer['RequestID'] = $featureRequestID; $featureRequests[$featureRequestID]['CommentsHREF'] = SmrSession::getNewHREF($commentsContainer); } $template->assignByRef('FeatureRequests', $featureRequests); } $template->assign('FeatureRequestFormHREF', SmrSession::getNewHREF(create_container('feature_request_processing.php', ''))); function getFeaturesCount($status, $onlyCurrent = false)
WHERE ' . $db->escapeNumber(TIME) . ' < end_time AND game_id = ' . $db->escapeNumber($player->getGameID()) . ' AND race_id_1 = ' . $db->escapeNumber($player->getRaceID())); if ($db->getNumRows() > 0) { $db2 = new SmrMySqlDatabase(); while ($db->nextRecord()) { $otherRaceID = $db->getField('race_id_2'); $container = create_container('council_vote_processing.php', '', array('race_id' => $otherRaceID)); // get 'yes' votes $db2->query('SELECT count(*) FROM player_votes_pact WHERE game_id = ' . $db2->escapeNumber($player->getGameID()) . ' AND race_id_1 = ' . $db2->escapeNumber($player->getRaceID()) . ' AND race_id_2 = ' . $db2->escapeNumber($otherRaceID) . ' AND vote = \'YES\''); $db2->nextRecord(); $yesVotes = $db2->getInt('count(*)'); // get 'no' votes $db2->query('SELECT count(*) FROM player_votes_pact WHERE game_id = ' . $db2->escapeNumber($player->getGameID()) . ' AND race_id_1 = ' . $db2->escapeNumber($player->getRaceID()) . ' AND race_id_2 = ' . $db2->escapeNumber($otherRaceID) . ' AND vote = \'NO\''); $db2->nextRecord(); $noVotes = $db2->getInt('count(*)'); $db2->query('SELECT vote FROM player_votes_pact WHERE account_id = ' . $db->escapeNumber($player->getAccountID()) . ' AND game_id = ' . $db->escapeNumber($player->getGameID()) . ' AND race_id_1 = ' . $db->escapeNumber($player->getRaceID()) . ' AND race_id_2 = ' . $db->escapeNumber($otherRaceID)); $votedFor = ''; if ($db2->nextRecord()) {
function channel_msg_op_list($fp, $rdata, $account, $player) { if (preg_match('/^:(.*)!(.*)@(.*)\\sPRIVMSG\\s(.*)\\s:!op list\\s$/i', $rdata, $msg)) { $nick = $msg[1]; $user = $msg[2]; $host = $msg[3]; $channel = $msg[4]; echo_r('[OP_LIST] by ' . $nick . ' in ' . $channel); // get the op info from db $db = new SmrMySqlDatabase(); $db->query('SELECT 1 FROM alliance_has_op WHERE alliance_id = ' . $player->getAllianceID() . ' AND game_id = ' . $player->getGameID()); if (!$db->nextRecord()) { fputs($fp, 'PRIVMSG ' . $channel . ' :' . $nick . ', your leader has not scheduled an OP.' . EOL); return true; } $yes = array(); $no = array(); $maybe = array(); $db->query('SELECT account_id, response FROM alliance_has_op_response WHERE alliance_id = ' . $player->getAllianceID() . ' AND game_id = ' . $player->getGameID()); while ($db->nextRecord()) { $respondingPlayer = SmrPlayer::getPlayer($db->getInt('account_id'), $player->getGameID()); if (!$player->sameAlliance($respondingPlayer)) { continue; } switch ($db->getField('response')) { case 'YES': $yes[] = $respondingPlayer; break; case 'NO': $no[] = $respondingPlayer; break; case 'MAYBE': $maybe[] = $respondingPlayer; break; } } if (count($yes) + count($no) + count($maybe) == 0) { fputs($fp, 'PRIVMSG ' . $channel . ' :Noone has signed up for the upcoming OP.' . EOL); return true; } if (count($yes) > 0) { fputs($fp, 'PRIVMSG ' . $channel . ' :YES (' . count($yes) . '):' . EOL); foreach ($yes as $attendee) { fputs($fp, 'PRIVMSG ' . $channel . ' : * ' . $attendee->getPlayerName() . EOL); } } if (count($no) > 0) { fputs($fp, 'PRIVMSG ' . $channel . ' :NO (' . count($no) . '):' . EOL); foreach ($no as $attendee) { fputs($fp, 'PRIVMSG ' . $channel . ' : * ' . $attendee->getPlayerName() . EOL); } } if (count($maybe) > 0) { fputs($fp, 'PRIVMSG ' . $channel . ' :MAYBE (' . count($maybe) . '):' . EOL); foreach ($maybe as $attendee) { fputs($fp, 'PRIVMSG ' . $channel . ' : * ' . $attendee->getPlayerName() . EOL); } } return true; } return false; }
} if ($action == 'Yes') { // get game id $game_id = $var['game_id']; if ($save) { $db->query('SELECT * FROM alliance WHERE game_id = ' . $db->escapeNumber($game_id)); while ($db->nextRecord()) { $id = $db->getInt('alliance_id'); //we need info for forces //populate alliance list $db2->query('SELECT * FROM player WHERE alliance_id = ' . $db2->escapeNumber($id) . ' AND game_id = ' . $db2->escapeNumber($game_id)); $list = array(0); while ($db2->nextRecord()) { $list[] = $db2->getInt('account_id'); } $db2->query('SELECT sum(mines) as sum_m, sum(combat_drones) as cds, sum(scout_drones) as sds FROM sector_has_forces WHERE owner_id IN (' . $db2->escapeArray($list) . ') AND game_id = ' . $db2->escapeNumber($game_id)); if ($db2->nextRecord()) { $mines = $db2->getInt('sum_m'); $cds = $db2->getInt('cds'); $sds = $db2->getInt('sds'); } else { $mines = 0; $cds = 0; $sds = 0; } // get info we want $name = $db->getField('alliance_name');
AND thread_id=' . $db2->escapeNumber($threadID) . ' AND time>' . $db2->escapeNumber($db->getInt('sendtime')) . ' LIMIT 1'); $threads[$i]['Unread'] = $db2->getNumRows() == 0; if ($db->getInt('sender_id') > 0) { $db2->query('SELECT player.player_name as player_name, alliance_thread.sender_id as sender_id FROM player JOIN alliance_thread ON alliance_thread.game_id = player.game_id AND player.account_id=alliance_thread.sender_id WHERE player.game_id=' . $db2->escapeNumber($player->getGameID()) . ' AND alliance_thread.alliance_id=' . $db2->escapeNumber($alliance->getAllianceID()) . ' AND alliance_thread.thread_id=' . $db2->escapeNumber($threadID) . ' AND alliance_thread.reply_id=1 LIMIT 1 '); if ($db2->nextRecord()) { $sender_id = $db2->getInt('sender_id'); $author =& SmrPlayer::getPlayer($sender_id, $player->getGameID()); $playerName = $author->getLinkedDisplayName(false); } else { $playerName = 'Unknown'; } } else { $sender_id = $db->getInt('sender_id'); if ($sender_id == 0) { $playerName = 'Planet Reporter'; } if ($sender_id == -1) { $playerName = 'Bank Reporter'; } if ($sender_id == -2) { $playerName = 'Forces Reporter';
$db->query('SELECT location_name, location_type_id FROM location JOIN location_type USING(location_type_id) WHERE location_type_id > ' . $db->escapeNumber(UNDERGROUND) . ' AND location_type_id < ' . $db->escapeNumber(FED) . ' AND game_id = ' . $db->escapeNumber($var['game_id']) . ' ORDER BY location_type_id'); $races = array(); while ($db->nextRecord()) { // get the name for this race // HACK! cut ' Headquarters' from location name! $race_name = substr(stripslashes($db->getField('location_name')), 0, -13); $curr_race_id = $db->getField('location_type_id') - 101; if (in_array($curr_race_id, $only)) { continue; } $only[] = $curr_race_id; // get number of traders in game $db2->query('SELECT count(*) as number_of_race FROM player WHERE race_id = ' . $db2->escapeNumber($curr_race_id) . ' AND game_id = ' . $db2->escapeNumber($var['game_id'])); $db2->nextRecord(); $races[$curr_race_id]['ID'] = $curr_race_id; $races[$curr_race_id]['Name'] = $race_name; $races[$curr_race_id]['NumberOfPlayers'] = $db2->getInt('number_of_race'); $races[$curr_race_id]['Selected'] = false; } if (count($races) > 1) { do { $raceKey = array_rand($races); } while ($races[$raceKey]['ID'] == RACE_ALSKANT); $races[$raceKey]['Selected'] = true; } $template->assign('Races', $races);
<?php $template->assign('PageTopic', 'Voting'); $db->query('SELECT * FROM voting ORDER BY end DESC'); if ($db->getNumRows() > 0) { $db2 = new SmrMySqlDatabase(); $votedFor = array(); $db2->query('SELECT * FROM voting_results WHERE account_id = ' . $db2->escapeNumber($account->getAccountID())); while ($db2->nextRecord()) { $votedFor[$db2->getInt('vote_id')] = $db2->getInt('option_id'); } $voting = array(); while ($db->nextRecord()) { $voteID = $db->getField('vote_id'); $voting[$voteID]['ID'] = $voteID; $container = create_container('vote.php', 'vote_processing.php'); $container['vote_id'] = $voteID; $voting[$voteID]['HREF'] = SmrSession::getNewHREF($container); $voting[$voteID]['Question'] = $db->getField('question'); if ($db->getField('end') > TIME) { $voting[$voteID]['TimeRemaining'] = format_time($db->getField('end') - TIME, true); } $voting[$voteID]['Options'] = array(); $db2->query('SELECT option_id,text,count(account_id) FROM voting_options LEFT OUTER JOIN voting_results USING(vote_id,option_id) WHERE vote_id = ' . $db2->escapeNumber($db->getInt('vote_id')) . ' GROUP BY option_id'); while ($db2->nextRecord()) { $voting[$voteID]['Options'][$db2->getInt('option_id')]['ID'] = $db2->getInt('option_id'); $voting[$voteID]['Options'][$db2->getInt('option_id')]['Text'] = $db2->getField('text'); $voting[$voteID]['Options'][$db2->getInt('option_id')]['Chosen'] = isset($votedFor[$db->getField('vote_id')]) && $votedFor[$voteID] == $db2->getInt('option_id'); $voting[$voteID]['Options'][$db2->getInt('option_id')]['Votes'] = $db2->getInt('count(account_id)'); } }
<?php if (!isset($var['CheckType']) || $var['CheckType'] == 'Validate') { // is account validated? if (!$account->isValidated()) { forward(create_container('skeleton.php', 'validate.php')); } else { $var['CheckType'] = 'Announcements'; } } $db = new SmrMySqlDatabase(); if ($var['CheckType'] == 'Announcements') { $db->query('SELECT 1 FROM account JOIN announcement ON last_login < time WHERE account_id = ' . $db->escapeNumber(SmrSession::$account_id) . ' LIMIT 1'); // do we have announcements? if ($db->nextRecord()) { forward(create_container('skeleton.php', 'announcements.php')); } else { $var['CheckType'] = 'Updates'; } } if ($var['CheckType'] == 'Updates') { $db->query('SELECT last_login FROM account JOIN version ON last_login < went_live WHERE account_id = ' . $db->escapeNumber(SmrSession::$account_id) . ' LIMIT 1'); // do we have updates? if ($db->nextRecord()) { forward(create_container('skeleton.php', 'changelog_view.php', array('Since' => $db->getInt('last_login')))); } } forward(create_container('logged_in.php'));
if (isset($_REQUEST['loginType'])) { require_once LIB . 'Login/SocialLogin.class.inc'; $socialLogin = new SocialLogin($_REQUEST['loginType']); if (!$socialLogin->isValid()) { $msg = 'Error validating login.'; header('Location: ' . URL . '/login.php?msg=' . rawurlencode(htmlspecialchars($msg, ENT_QUOTES))); exit; } $loginType = $socialLogin->getLoginType(); $authKey = $socialLogin->getUserID(); $db->query('SELECT account_id,old_account_id FROM account JOIN account_auth USING(account_id) WHERE login_type = ' . $db->escapeString($loginType) . ' AND auth_key = ' . $db->escapeString($authKey) . ' LIMIT 1'); if ($db->nextRecord()) { // register session SmrSession::$account_id = $db->getInt('account_id'); SmrSession::$old_account_id = $db->getInt('old_account_id'); } else { if ($socialLogin->getEmail() != null) { $db->query('SELECT account_id,old_account_id FROM account ' . 'WHERE email = ' . $db->escapeString($socialLogin->getEmail()) . ' LIMIT 1'); } if ($socialLogin->getEmail() != null && $db->nextRecord()) { //Email already has an account so let's link. $account =& SmrAccount::getAccount($db->getField('account_id')); $account->addAuthMethod($socialLogin->getLoginType(), $socialLogin->getUserID()); $account->setValidated(true); SmrSession::$account_id = $db->getField('account_id'); SmrSession::$old_account_id = $db->getField('old_account_id'); } else { session_start(); //Pass the data in a standard session as we don't want to initialise a normal one.
if ($db->getNumRows()) { $PHP_OUTPUT .= '<br /><h2>Your accounts</h2><br />'; $PHP_OUTPUT .= '<div align=center>'; $PHP_OUTPUT .= '<table class="standard inset" ><tr><th>ID</th><th>Password</th><th>Last Transaction</th><th>Balance</th><th>Option</th></tr>'; $container = create_container('skeleton.php', 'bank_anon.php'); $db2 = new SmrMySqlDatabase(); while ($db->nextRecord()) { $PHP_OUTPUT .= '<tr><td class="shrink center">'; $PHP_OUTPUT .= $db->getInt('anon_id'); $PHP_OUTPUT .= '</td><td>'; $PHP_OUTPUT .= $db->getField('password'); $PHP_OUTPUT .= '</td><td class="shrink noWrap">'; $db2->query('SELECT MAX(time) FROM anon_bank_transactions WHERE game_id=' . $db2->escapeNumber($player->getGameID()) . ' AND anon_id=' . $db2->escapeNumber($db->getInt('anon_id')) . ' LIMIT 1'); if ($db2->nextRecord() && $db2->getInt('MAX(time)')) { $PHP_OUTPUT .= date(DATE_FULL_SHORT, $db2->getInt('MAX(time)')); } else { $PHP_OUTPUT .= 'No transactions'; } $PHP_OUTPUT .= '</td><td class="right shrink">'; $PHP_OUTPUT .= $db->getInt('amount'); $PHP_OUTPUT .= '</td><td class="button">'; $container['AccountNumber'] = $db->getInt('anon_id'); $container['Password'] = $db->getField('password'); $PHP_OUTPUT .= create_button($container, 'Access Account'); $PHP_OUTPUT .= '</td></tr>'; } $PHP_OUTPUT .= '</table></div><br /><br />'; } $container = create_container('skeleton.php', 'bank_anon.php');
<?php require_once '../htdocs/config.inc'; require_once LIB . 'Default/Globals.class.inc'; require_once get_file_loc('ChessGame.class.inc'); SmrSession::$game_id = 44; $db = new SmrMySqlDatabase(); $db->query('DELETE FROM player_hof WHERE type LIKE \'Chess%\''); $db->query('SELECT chess_game_id FROM chess_game'); while ($db->nextRecord()) { $chessGameID = $db->getInt('chess_game_id'); $game =& ChessGame::getChessGame($chessGameID); echo 'Running game ' . $chessGameID . ' for white id "' . $game->getWhiteID() . '", black id "' . $game->getBlackID() . '", winner "' . $game->getWinner() . '"' . EOL; echoChessMoves($game); $game->rerunGame(true); echo 'Finished game ' . $chessGameID . ' for white id "' . $game->getWhiteID() . '", black id "' . $game->getBlackID() . '", winner "' . $game->getWinner() . '"' . EOL; echoChessMoves($game); } function echoChessMoves($game) { echo 'Moves: ' . EOL; $moves = $game->getMoves(); foreach ($moves as $move) { echo $move . EOL; } echo EOL; }
$PHP_OUTPUT .= create_echo_form($container); $PHP_OUTPUT .= '<td align="center">'; $PHP_OUTPUT .= create_submit('Reset'); $PHP_OUTPUT .= '</td>'; $PHP_OUTPUT .= '</form>'; if (empty($other)) { $other = 'N/A'; } $PHP_OUTPUT .= '<td align="right" valign="top" width="10%" class="bold">Other Info :<br /><small>(AIM/ICQ) </small></td><td colspan="2">' . $other . '</td>'; $PHP_OUTPUT .= '</tr>'; $container['task'] = 'delete_comment'; $PHP_OUTPUT .= create_echo_form($container); $PHP_OUTPUT .= '<input type="hidden" name="task" value="delete_comment">'; $PHP_OUTPUT .= '<tr><td> </td><td colspan="3"><u>Comments</u></td></tr>'; $db->query('SELECT * FROM album_has_comments WHERE album_id = ' . $db->escapeNumber($account_id)); while ($db->nextRecord()) { $comment_id = $db->getInt('comment_id'); $time = $db->getInt('time'); $postee = get_album_nick($db->getInt('post_id')); $msg = stripslashes($db->getField('msg')); $PHP_OUTPUT .= '<tr><td align="center"><input type="checkbox" name="comment_ids[]" value="' . $comment_id . '"></td><td colspan="3"><span style="font-size:85%;">[' . date('Y/n/j g:i A', $time) . '] <' . $postee . '> ' . $msg . '</span></td></tr>'; } $PHP_OUTPUT .= '<tr><td align="center">'; $PHP_OUTPUT .= create_submit('Delete'); $PHP_OUTPUT .= '</td>'; $PHP_OUTPUT .= '<td colspan="3"> </td></tr>'; $PHP_OUTPUT .= '</form>'; $PHP_OUTPUT .= '</table>'; }