function channel_join($fp, $rdata) { if (preg_match('/^:(.*)!(.*)@(.*)\\sJOIN\\s:(.*)\\s$/i', $rdata, $msg)) { $nick = $msg[1]; $user = $msg[2]; $host = $msg[3]; $channel = $msg[4]; echo_r('[JOIN] ' . $nick . '!' . $user . '@' . $host . ' joined ' . $channel); // if ($nick == 'MrSpock' && $user == 'mrspock') // fputs($fp, 'PRIVMSG ' . $channel . ' :The creator! The God! He\'s among us! Praise him!' . EOL); if ($nick == 'Holti' && $user == 'Holti') { fputs($fp, 'PRIVMSG ' . $channel . ' :' . chr(1) . 'ACTION hands ' . $nick . ' a ' . chr(3) . '4@' . chr(3) . '3' . chr(2) . '}' . chr(2) . '-,`--' . chr(1) . EOL); } if ($nick == 'kiNky' && $user == 'cicika') { fputs($fp, 'PRIVMSG ' . $channel . ' :' . chr(1) . 'ACTION hands ' . $nick . ' a ' . chr(3) . '4@' . chr(3) . '3' . chr(2) . '}' . chr(2) . '-,`--' . chr(1) . EOL); } if ($nick == 'River' && $user == 'Serenity') { fputs($fp, 'PRIVMSG ' . $channel . ' :' . chr(1) . 'ACTION hands ' . $nick . ' a ' . chr(3) . '8@' . chr(3) . '3' . chr(2) . '}' . chr(2) . '-,`--' . chr(1) . EOL); } $db = new SmrMySqlDatabase(); // check if we have seen this user before $db->query('SELECT * FROM irc_seen WHERE nick = ' . $db->escapeString($nick) . ' AND channel = ' . $db->escapeString($channel)); if ($db->nextRecord()) { // exiting nick? $seen_id = $db->getField('seen_id'); $seen_count = $db->getField('seen_count'); $seen_by = $db->getField('seen_by'); if ($seen_count > 1) { fputs($fp, 'PRIVMSG ' . $channel . ' :Welcome back ' . $nick . '. While being away ' . $seen_count . ' players were looking for you, the last one being ' . $seen_by . EOL); } elseif ($seen_count > 0) { fputs($fp, 'PRIVMSG ' . $channel . ' :Welcome back ' . $nick . '. While being away ' . $seen_by . ' was looking for you.' . EOL); } $db->query('UPDATE irc_seen SET signed_on = ' . $db->escapeNumber(time()) . ', signed_off = 0, user = '******', host = ' . $db->escapeString($host) . ', seen_count = 0, seen_by = NULL, registered = NULL WHERE seen_id = ' . $db->escapeNumber($seen_id)); } else { // new nick? $db->query('INSERT INTO irc_seen (nick, user, host, channel, signed_on) VALUES(' . $db->escapeString($nick) . ', ' . $db->escapeString($user) . ', ' . $db->escapeString($host) . ', ' . $db->escapeString($channel) . ', ' . time() . ')'); } // check if player joined alliance chat channel_op_notification($fp, $rdata, $nick, $channel); return true; } return false; }
function channel_msg_seedlist_add($fp, $rdata, $account, $player) { if (preg_match('/^:(.*)!(.*)@(.*)\\sPRIVMSG\\s(.*)\\s:!seedlist add (.*)\\s$/i', $rdata, $msg)) { $nick = $msg[1]; $user = $msg[2]; $host = $msg[3]; $channel = $msg[4]; $sectors = explode(' ', $msg[5]); echo_r('[SEEDLIST_ADD] by ' . $nick . ' in ' . $channel); // check if $nick is leader if (!$player->isAllianceLeader(true)) { fputs($fp, 'PRIVMSG ' . $channel . ' :' . $nick . ', only the leader of the alliance manages the seedlist.' . EOL); return true; } foreach ($sectors as $sector) { // see if the sector is numeric if (!is_numeric($sector)) { fputs($fp, 'PRIVMSG ' . $channel . ' :The sectors all need to be numeric. Example: !seedlist add 1537' . EOL); return true; } } $db = new SmrMySqlDatabase(); foreach ($sectors as $sector) { // check if the sector is a part of the game $db->query('SELECT sector_id FROM sector WHERE game_id = ' . $player->getGameID() . ' AND sector_id = ' . $db->escapeNumber($sector)); if (!$db->nextRecord()) { fputs($fp, 'PRIVMSG ' . $channel . ' :The sector ' . $sector . ' does not exist in current game.' . EOL); continue; } // check if the given sector is already part of the seed list $db->query('SELECT sector_id FROM alliance_has_seedlist WHERE alliance_id = ' . $player->getAllianceID() . ' AND game_id = ' . $player->getGameID() . ' AND sector_id = ' . $db->escapeNumber($sector)); if ($db->nextRecord()) { // fputs($fp, 'PRIVMSG ' . $channel . ' :The sector ' . $sector . ' is already in the seedlist.' . EOL); continue; } // add sector to db $db->query('INSERT INTO alliance_has_seedlist (alliance_id, game_id, sector_id) VALUES (' . $player->getAllianceID() . ', ' . $player->getGameID() . ', ' . $db->escapeNumber($sector) . ')'); // fputs($fp, 'PRIVMSG ' . $channel . ' :The sector ' . $sector . ' has been added.' . EOL); } fputs($fp, 'PRIVMSG ' . $channel . ' :The sectors have been added.' . EOL); return true; } return false; }
$container['type'] = 'alliance'; $PHP_OUTPUT .= create_echo_form($container); //count of messages $count = 0; //array for mb so we dont duplicate $mb_msgs = array(); while ($db->nextRecord()) { //search every message on webboards for each word first $id = $db->getField('id'); $word = $db->getField('keyword'); $db2->query('SELECT * FROM alliance_thread WHERE sender_id != 0 AND text LIKE ' . $db2->escapeString('%' . $word . '%') . ' ORDER BY time DESC'); while ($db2->nextRecord()) { //assume we arent skipping $skip = 'no'; $bad = $db2->getField('text'); $db3->query('SELECT * FROM mb_keywords WHERE assoc = ' . $db3->escapeNumber($id) . ' AND type = \'ignore\' AND `use` = 1'); while ($db3->nextRecord()) { $word2 = $db3->getField('keyword'); $db4->query('SELECT ' . $db->escapeString($bad) . ' LIKE ' . $db4->escapeString('%' . $word2 . '%')); $db4->nextRecord(); if ($db4->getField(0)) { $skip = 'yes'; } } if ($skip == 'yes') { continue; } //get info $game_id = $db2->getField('game_id'); $alliance_id = $db2->getField('alliance_id'); $thread_id = $db2->getField('thread_id');
WHERE account_id = 1 AND game_id = ' . $db->escapeNumber($var['game_id'])); if ($db->nextRecord()) { $PHP_OUTPUT .= '<option value="0">[please select]</option>'; // get all accounts $db->query('SELECT account_id, login FROM account ORDER BY login'); while ($db->nextRecord()) { // get current account id and login $curr_account_id = $db->getInt('account_id'); $curr_login = $db->getField('login'); // check if this guy is already in $db2->query('SELECT player_name FROM player WHERE account_id = ' . $db2->escapeNumber($curr_account_id) . ' AND game_id = ' . $db2->escapeNumber($var['game_id'])); if (!$db2->nextRecord()) { $PHP_OUTPUT .= '<option value="' . $curr_account_id . '">' . $curr_login . '</option>'; } } } else { $PHP_OUTPUT .= '<option value="1">MrSpock</option>'; $player_name = 'MrSpock'; $readonly = ' readonly'; } $PHP_OUTPUT .= '</select><br /><br /><br />'; $PHP_OUTPUT .= 'Player Name:<br /><br />'; $PHP_OUTPUT .= '<input type="text" name="player_name" value="' . $player_name . '" id="InputFields" style="padding-left:10px;"' . $readonly . '><br /><br /><br />'; $PHP_OUTPUT .= 'Player Race:<br /><br />'; $PHP_OUTPUT .= '<select name="race_id" id="InputFields" style="padding-left:10px;">';
$PHP_OUTPUT .= '<p>Here are the rankings of the races by their experience</p>'; $PHP_OUTPUT .= '<table class="standard" width="95%">'; $PHP_OUTPUT .= '<tr>'; $PHP_OUTPUT .= '<th>Rank</th>'; $PHP_OUTPUT .= '<th>Race</th>'; $PHP_OUTPUT .= '<th>Total Experience</th>'; $PHP_OUTPUT .= '<th>Average Experience</th>'; $PHP_OUTPUT .= '<th>Total Traders</th>'; $PHP_OUTPUT .= '</tr>'; $rank = 0; $db2 = new SmrMySqlDatabase(); $db->query('SELECT race_id, race_name, SUM(experience) as experience_sum, COUNT(*) as members FROM player JOIN race USING(race_id) WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' GROUP BY race_id ORDER BY experience_sum DESC'); while ($db->nextRecord()) { $rank++; $race_id = $db->getInt('race_id'); $db2->query('SELECT * FROM player WHERE race_id = ' . $db2->escapeNumber($race_id) . ' AND game_id = ' . $db2->escapeNumber($player->getGameID()) . ' AND out_of_game = \'TRUE\''); if ($player->getRaceID() == $race_id) { $style = ' class="bold"'; } elseif ($db2->nextRecord()) { $style = ' class="red"'; } else { $style = ''; } // if ($db2->nextRecord()) $style .= $PHP_OUTPUT .= '<tr>'; $PHP_OUTPUT .= '<td align="center"' . $style . '>' . $rank . '</td>'; $PHP_OUTPUT .= '<td align="center"' . $style . '>' . $db->getField('race_name') . '</td>'; $PHP_OUTPUT .= '<td align="center"' . $style . '>' . $db->getInt('experience_sum') . '</td>'; $PHP_OUTPUT .= '<td align="center"' . $style . '>' . round($db->getInt('experience_sum') / $db->getInt('members')) . '</td>'; $PHP_OUTPUT .= '<td align="center"' . $style . '>' . $db->getInt('members') . '</td>'; $PHP_OUTPUT .= '</tr>';
LIMIT 1'); if ($db->getNumRows() || $player->isOnCouncil()) { $db->query('SELECT * FROM message_type ORDER BY message_type_id'); } else { $db->query('SELECT * FROM message_type WHERE message_type_id != ' . $db->escapeNumber(MSG_POLITICAL) . ' ORDER BY message_type_id'); } $messageBoxes = array(); while ($db->nextRecord()) { $message_type_id = $db->getField('message_type_id'); $messageBox['Name'] = $db->getField('message_type_name'); // do we have unread msges in that folder? $db2->query('SELECT 1 FROM message WHERE account_id = ' . $db2->escapeNumber($player->getAccountID()) . ' AND game_id = ' . $db2->escapeNumber($player->getGameID()) . ' AND message_type_id = ' . $db2->escapeNumber($message_type_id) . ' AND msg_read = ' . $db2->escapeBoolean(false) . ' AND receiver_delete = ' . $db2->escapeBoolean(false) . ' LIMIT 1'); $messageBox['HasUnread'] = $db2->getNumRows() != 0; $messageBox['MessageCount'] = 0; // get number of msges $db2->query('SELECT count(message_id) as message_count FROM message WHERE account_id = ' . $db2->escapeNumber($player->getAccountID()) . ' AND game_id = ' . $db2->escapeNumber($player->getGameID()) . ' AND message_type_id = ' . $db2->escapeNumber($message_type_id) . ' AND receiver_delete = ' . $db2->escapeBoolean(false)); if ($db2->nextRecord()) { $messageBox['MessageCount'] = $db2->getField('message_count'); }
<?php $template->assign('PageTopic', 'Log Console'); $loggedAccounts = array(); $db->query('SELECT account_id as account_id, login, count(*) as number_of_entries FROM account_has_logs JOIN account USING(account_id) GROUP BY account_id'); if ($db->getNumRows()) { $db2 = new SmrMySqlDatabase(); while ($db->nextRecord()) { $accountID = $db->getInt('account_id'); $loggedAccounts[$accountID] = array('AccountID' => $accountID, 'Login' => $db->getField('login'), 'TotalEntries' => $db->getInt('number_of_entries'), 'Checked' => is_array($var['account_ids']) && in_array($accountID, $var['account_ids']), 'Notes' => ''); $db2->query('SELECT notes FROM log_has_notes WHERE account_id = ' . $db2->escapeNumber($accountID)); if ($db2->nextRecord()) { $loggedAccounts[$accountID]['Notes'] = nl2br($db2->getField('notes')); } } // put hidden fields in for log type to have all fields selected on next page. $logTypes = array(); $db->query('SELECT log_type_id FROM log_type'); while ($db->nextRecord()) { $logTypes[] = $db->getInt('log_type_id'); } $template->assignByRef('LogTypes', $logTypes); $template->assign('LogConsoleFormHREF', SmrSession::getNewHREF(create_container('skeleton.php', 'log_console_detail.php'))); $template->assign('AnonAccessHRE', SmrSession::getNewHREF(create_container('skeleton.php', 'log_anonymous_account.php'))); } $template->assignByRef('LoggedAccounts', $loggedAccounts);
$container['account_id'] = $album_id; forward($container); exit; } $db = new SmrMySqlDatabase(); if (!isset($_GET['comment']) || empty($_GET['comment'])) { create_error_offline('Please enter a comment.'); } else { $comment = $_GET['comment']; } // get current time $curr_time = TIME; $comment = word_filter($comment); $account->sendMessageToBox(BOX_ALBUM_COMMENTS, $comment); // check if we have comments for this album already $db->lockTable('album_has_comments'); $db->query('SELECT MAX(comment_id) FROM album_has_comments WHERE album_id = ' . $db->escapeNumber($album_id)); if ($db->nextRecord()) { $comment_id = $db->getField('MAX(comment_id)') + 1; } else { $comment_id = 1; } $db->query('INSERT INTO album_has_comments (album_id, comment_id, time, post_id, msg) VALUES (' . $db->escapeNumber($album_id) . ', ' . $db->escapeNumber($comment_id) . ', ' . $db->escapeNumber($curr_time) . ', ' . $db->escapeNumber($account->getAccountID()) . ', ' . $db->escapeString($comment) . ')'); $db->unlock(); header('Location: ' . URL . '/album/?' . get_album_nick($album_id)); exit; } catch (Exception $e) { handleException($e); }
<?php $container = array(); $container['url'] = 'skeleton.php'; $container['body'] = 'message_blacklist.php'; if (!isset($_REQUEST['PlayerName']) && !isset($var['account_id'])) { $container['error'] = 1; forward($container); exit; } if (isset($var['account_id'])) { $blacklisted_id = $var['account_id']; } else { $player_name = mysql_real_escape_string($_REQUEST['PlayerName']); $db = new SmrMySqlDatabase(); $db->query('SELECT account_id FROM player WHERE player_name=' . $db->escapeString($player_name) . ' AND game_id=' . $db->escapeNumber($player->getGameID()) . ' LIMIT 1'); if (!$db->nextRecord()) { $container['error'] = 1; forward($container); exit; } $blacklisted_id = $db->getField('account_id'); } $db->query('SELECT account_id FROM message_blacklist WHERE account_id=' . $db->escapeNumber($player->getAccountID()) . ' AND blacklisted_id=' . $db->escapeNumber($blacklisted_id) . ' AND game_id=' . $db->escapeNumber($player->getGameID()) . ' LIMIT 1'); if ($db->nextRecord()) { $container['error'] = 2; forward($container); exit; } $db->query('INSERT INTO message_blacklist (game_id,account_id,blacklisted_id) VALUES (' . $db->escapeNumber($player->getGameID()) . ',' . $db->escapeNumber($player->getAccountID()) . ',' . $db->escapeNumber($blacklisted_id) . ')'); $container['error'] = 3;
$container['item'] = 'sector_id'; $PHP_OUTPUT .= create_link($container, '<th style="cursor:hand;">Sector</th>'); $PHP_OUTPUT .= '<th>Message</th>'; $PHP_OUTPUT .= '</tr>'; $db->query('SELECT * FROM account_has_logs WHERE account_id IN (' . $account_list . ') AND log_type_id IN (' . $db->escapeArray($log_type_id_list) . ') ORDER BY ' . $var['item'] . ' ' . $var['order']); while ($db->nextRecord()) { $account_id = $db->getInt('account_id'); $microtime = $db->getMicrotime('microtime'); $message = stripslashes($db->getField('message')); $log_type_id = $db->getInt('log_type_id'); $sector_id = $db->getInt('sector_id'); // generate style string $style = ' style="color:' . $colors[$account_id] . ';"'; $PHP_OUTPUT .= '<tr>'; $PHP_OUTPUT .= '<td' . $style . '>' . date(DATE_FULL_SHORT, microtimeSec($microtime)) . ' ' . microtimeMSec($microtime) . 'us</td>'; $db2->query('SELECT * FROM log_type WHERE log_type_id = ' . $db2->escapeNumber($log_type_id)); if ($db2->nextRecord()) { $PHP_OUTPUT .= '<td align="center"' . $style . '>' . $db2->getField('log_type_entry') . '</td>'; } else { $PHP_OUTPUT .= '<td align="center"' . $style . '>unknown</td>'; } $PHP_OUTPUT .= '<td align="center"' . $style . '>' . $sector_id . '</td>'; $PHP_OUTPUT .= '<td' . $style . '>' . $message . '</td>'; $PHP_OUTPUT .= '</tr>'; } $PHP_OUTPUT .= '</table>'; } $PHP_OUTPUT .= '<p>'; $container = create_container('skeleton.php', 'log_console.php'); $container['account_ids'] = $account_ids; $PHP_OUTPUT .= create_link($container, '<b>< Back</b>');
<?php /* http://www.smrealms.de/sms/response.php?message_id=%message_id%&message=%message%&from=%from%&ref=%ref% %message_id% Message ID of text that is being responded to %message% text of response %from% cell number of responder %ref% reference */ include '../config.inc'; include LIB . 'Default/SmrMySqlDatabase.class.inc'; include ENGINE . '/Default/smr.inc'; // database object $db = new SmrMySqlDatabase(); // get input $message_id = (int) $_GET['message_id']; $message = $_GET['message']; $from = $_GET['from']; // add dlr to database $db->query('INSERT INTO account_sms_response ' . '(message_id, message, from) ' . 'VALUES (' . $db->escapeNumber($message_id) . ', ' . $db->escapeString($message) . ', ' . $db->escapeString($from) . ')');
$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>';
$PHP_OUTPUT .= '<big>Here are the updates that have gone live since your last visit, enjoy!</big><br/><br/>'; } $db2 = new SmrMySqlDatabase(); $db->query('SELECT * FROM version WHERE went_live > ' . (isset($var['Since']) ? $db->escapeNumber($var['Since']) : '0') . ' ORDER BY version_id DESC'); while ($db->nextRecord()) { $version_id = $db->getInt('version_id'); $version = $db->getInt('major_version') . '.' . $db->getInt('minor_version') . '.' . $db->getInt('patch_level'); $went_live = $db->getInt('went_live'); // get human readable format for date if ($went_live > 0) { $went_live = date(DATE_FULL_SHORT, $went_live); } else { $went_live = 'never'; } $PHP_OUTPUT .= '<b><small>' . $version . ' (' . $went_live . '):</small></b>'; $PHP_OUTPUT .= '<ul>'; $db2->query('SELECT * FROM changelog WHERE version_id = ' . $db2->escapeNumber($version_id) . ' ORDER BY changelog_id'); while ($db2->nextRecord()) { $PHP_OUTPUT .= '<li>' . $db2->getField('change_title') . '<br /><small>' . $db2->getField('change_message') . '</small></li>'; } $PHP_OUTPUT .= '</ul><br />'; if (isset($var['Since'])) { $PHP_OUTPUT .= create_button(create_container('logged_in.php'), 'Continue'); } }
} $db->query('SELECT * FROM account WHERE account_id >= ' . $db->escapeNumber($start) . ' AND account_id <= ' . $db->escapeNumber($end) . ' ORDER BY account_id'); $PHP_OUTPUT .= create_table(); $PHP_OUTPUT .= '<tr>'; $PHP_OUTPUT .= '<th align=center>Account_id</th>'; $PHP_OUTPUT .= '<th align=center>Login</th>'; $PHP_OUTPUT .= '<th align=center>eMail</th>'; $PHP_OUTPUT .= '<th align=center>Last IP</th>'; $PHP_OUTPUT .= '<th align=center>Exception</th>'; $PHP_OUTPUT .= '</tr>'; while ($db->nextRecord()) { $acc_id = $db->getField('account_id'); $PHP_OUTPUT .= '<tr>'; $PHP_OUTPUT .= '<td align=center>' . $acc_id . '</td>'; $PHP_OUTPUT .= '<td align=center>' . $db->getField('login') . '</td>'; $PHP_OUTPUT .= '<td align=center>' . $db->getField('email') . '</td>'; $db2->query('SELECT * FROM account_has_ip WHERE account_id = ' . $db2->escapeNumber($acc_id) . ' ORDER BY time DESC LIMIT 1'); if ($db2->nextRecord()) { $PHP_OUTPUT .= '<td align=center>' . $db2->getField('ip') . '</td>'; } else { $PHP_OUTPUT .= '<td align=center>No Last IP</td>'; } $db2->query('SELECT * FROM account_exceptions WHERE account_id = ' . $db2->escapeNumber($acc_id)); if ($db2->nextRecord()) { $PHP_OUTPUT .= '<td align=center>' . $db2->getField('reason') . '</td>'; } else { $PHP_OUTPUT .= '<td align=center>No Exception</td>'; } $PHP_OUTPUT .= '</tr>'; } $PHP_OUTPUT .= '</table>';
try { $account =& SmrAccount::createAccount($login, $password, $email, $first_name, $last_name, $address, $city, $postal_code, $country_code, $icq, $timez, $referral); } catch (Exception $e) { $msg = 'Invalid referral id!'; header('Location: ' . URL . '/error.php?msg=' . rawurlencode(htmlspecialchars($msg, ENT_QUOTES))); exit; } $account->increaseSmrRewardCredits(2 * CREDITS_PER_DOLLAR); // Give $2 worth of "reward" credits for joining. if ($socialLogin) { $account->addAuthMethod($_SESSION['socialLogin']->getLoginType(), $_SESSION['socialLogin']->getUserID()); $account->setValidated(true); session_destroy(); } // register session SmrSession::$account_id = $account->getAccountID(); // save ip $account->updateIP(); // send email with validation code to user mail($email, 'New Space Merchant Realms User', 'Your validation code is: ' . $account->getValidationCode() . EOL . 'The Space Merchant Realms server is on the web at ' . URL . '/' . EOL . 'Please verify within the next 7 days or your account will be automatically deleted.', 'From: support@smrealms.de'); // remember when we sent validation code $db->query('INSERT INTO notification (notification_type, account_id, time) ' . 'VALUES(\'validation_code\', ' . $db->escapeNumber(SmrSession::$account_id) . ', ' . $db->escapeNumber(TIME) . ')'); // insert into the account stats table $db->query('INSERT INTO account_has_stats (account_id, HoF_name) VALUES(' . $db->escapeNumber(SmrSession::$account_id) . ', ' . $db->escape_string($account->getLogin()) . ')'); $container = create_container('login_processing2.php'); $container['login'] = $login; $container['password'] = $password; forwardURL($container); } catch (Exception $e) { handleException($e); }
$ip_numbers[] = $db_ip; $account_numbers[] = $acc_id; } } foreach ($ip_numbers as $something) { $amount += 1; } reset($ip_numbers); array_multisort($ip_numbers, $account_numbers); $i = 0; while ($i < $amount) { $account_wanted = array_shift($account_numbers); $ip_wanted = array_shift($ip_numbers); $new_acc =& SmrAccount::getAccount($account_wanted); $last_acc =& SmrAccount::getAccount($last_acc_id); $db2->query('SELECT * FROM account_is_closed WHERE account_id = ' . $db2->escapeNumber($acc_id)); if ($db2->getNumRows() && $db_ip != $last_ip) { continue; } $PHP_OUTPUT .= '<tr>'; $PHP_OUTPUT .= '<td align=center>' . $new_acc->getLogin() . ' (' . $new_acc->getAccountID() . ')</td>'; $PHP_OUTPUT .= '<td align=center>' . $ip_wanted . '</td>'; if ($ip_wanted == $last_ip && !$db2->nextRecord()) { $PHP_OUTPUT .= '<td align=center><span class="red">MATCH w/ ' . $last_acc->getLogin() . '</span></td>'; } elseif ($ip_wanted == $last_ip) { $PHP_OUTPUT .= '<td align=center><span class="red">(Already disabled) MATCH w/ ' . $last_acc->getLogin() . '</span></td>'; } else { $PHP_OUTPUT .= '<td align=center> </td>'; } $PHP_OUTPUT .= '<td><input type="checkbox" name="account_id[]" value="' . $new_acc->getAccountID() . '"></td>'; $PHP_OUTPUT .= '</tr>';
<?php /* http://www.smrealms.de/sms/dlr.php?message_id=%message_id%&send=%send%&receive=%receive%&status=%status%&ref=%ref%&to=%to% %message_id% Message ID of outgoing text from gateway %send% sending time as timestamp %receive% receiving time as timestamp %status% sending result %ref% reference (can be given when sending) %to% where text was being send to */ include '../config.inc'; include LIB . 'Default/SmrMySqlDatabase.class.inc'; include ENGINE . '/Default/smr.inc'; // database object $db = new SmrMySqlDatabase(); // get input $message_id = (int) $_GET['message_id']; $send_time = (int) $_GET['send']; $receive_time = (int) $_GET['receive']; $status = $_GET['status']; // add dlr to database $db->query('INSERT INTO account_sms_dlr ' . '(message_id, send_time, receive_time, status) ' . 'VALUES (' . $db->escapeNumber($message_id) . ', ' . $db->escapeNumber($send_time) . ', ' . $db->escapeNumber($receive_time) . ', ' . $db->escapeString($status) . ')');
} $PHP_OUTPUT .= '</tr>'; $db2 = new SmrMySqlDatabase(); // iterate over all ship shops $db->query('SELECT location_type_id, location_name FROM location_type WHERE location_type_id > 500 AND location_type_id < 600 ORDER BY location_name'); while ($db->nextRecord()) { $location_name = $db->getField('location_name'); $location_type_id = $db->getField('location_type_id'); // get all ships that are sold here $db2->query('SELECT * FROM location_type JOIN location_sells_ships USING(location_type_id) JOIN ship_type USING(ship_type_id) WHERE location_type_id = ' . $db2->escapeNumber($location_type_id)); $PHP_OUTPUT .= '<tr>'; $PHP_OUTPUT .= '<td align="right"><b style="font-size:80%;">' . $location_name . '</b><br />'; while ($db2->nextRecord()) { $PHP_OUTPUT .= '<span style="font-size:65%;">' . $db2->getField('ship_name') . '</span><br />'; } $PHP_OUTPUT .= '</td>'; foreach ($galaxies as $galaxy_id => $galaxy_name) { $PHP_OUTPUT .= '<td align="center"><input type="number" name="id[' . $location_type_id . '][' . $galaxy_id . ']" size="3" id="InputFields" value="0" class="center"></td>'; } $PHP_OUTPUT .= '</tr>'; } $PHP_OUTPUT .= '</table></p>'; $PHP_OUTPUT .= create_submit('Next >>'); $PHP_OUTPUT .= ' '; $PHP_OUTPUT .= create_submit('Skip >>');
<th align=center>Closed?</th> </tr>'; while ($db->nextRecord()) { $id = $db->getField('account_id'); $time = $db->getField('time'); $ip = $db->getField('ip'); list($fi, $se, $th, $fo, $crap) = preg_split('/[.\\s,]/', $ip, 5); $ip = $fi . '.' . $se . '.' . $th . '.' . $fo; $host = gethostbyaddr($ip); if ($host == $ip) { $host = 'unknown'; } if ($id == $last_id && $ip == $last_ip) { continue; } $db2->query('SELECT * FROM account_is_closed JOIN closing_reason USING(reason_id) WHERE reason = \'Tagged for deletion\' AND account_id = ' . $db2->escapeNumber($id)); if ($db2->nextRecord()) { continue; } $db2->query('SELECT * FROM account WHERE account_id = ' . $db2->escapeNumber($id)); $db2->nextRecord(); $login = $db2->getField('login'); $db2->query('SELECT * FROM player WHERE account_id = ' . $db2->escapeNumber($id)); $names = array(); while ($db2->nextRecord()) { $names[] = stripslashes($db2->getField('player_name')); } $PHP_OUTPUT .= '<tr><td>' . $id . '</td><td>' . $login . '</td><td>' . date(DATE_FULL_SHORT, $time) . '</td>'; $PHP_OUTPUT .= '<td>' . $ip . '</td><td>' . $host . '</td><td>'; $a = 1; foreach ($names as $echoed) {
function album_entry($album_id) { // database object $db = new SmrMySqlDatabase(); // list of all first letter nicks create_link_list(); if (SmrSession::$account_id != 0 && $album_id != SmrSession::$account_id) { $db->query('UPDATE album SET page_views = page_views + 1 WHERE account_id = ' . $db->escapeNumber($album_id) . ' AND approved = \'YES\''); } $db->query('SELECT * FROM album WHERE account_id = ' . $db->escapeNumber($album_id) . ' AND approved = \'YES\''); if ($db->nextRecord()) { $location = stripslashes($db->getField('location')); $email = stripslashes($db->getField('email')); $website = stripslashes($db->getField('website')); $day = $db->getField('day'); $month = $db->getField('month'); $year = $db->getField('year'); $other = nl2br(stripslashes($db->getField('other'))); $page_views = $db->getField('page_views'); $disabled = $db->getField('disabled') == 'TRUE'; } else { echo '<h1>Error</h1>'; echo 'This user doesn\'t have an entry in our album!'; return; } // get this user's nick $nick = get_album_nick($album_id); echo '<table border="0" align="center" cellpadding="5" cellspacing="0">'; echo '<tr>'; echo '<td style="text-align: center;" colspan="2">'; echo '<div style="margin-left: auto; margin-right: auto; width: 50%">'; echo '<table style="width: 100%">'; echo '<tr>'; $db->query('SELECT hof_name FROM album JOIN account USING(account_id) WHERE hof_name < ' . $db->escapeString($nick) . ' AND approved = \'YES\' ORDER BY hof_name DESC LIMIT 1'); echo '<td style="text-align: center; width: 30%" valign="middle">'; if ($db->nextRecord()) { $priv_nick = $db->getField('hof_name'); echo '<a href="' . URL . '/album/?' . urlencode($priv_nick) . '"><img src="' . URL . '/images/album/rew.jpg" alt="' . $priv_nick . '" border="0"></a> '; } echo '</td>'; echo '<td style="text-align: center;" valign="middle"><span style="font-size:150%;">' . $nick . '</span><br /><span style="font-size:75%;">Views: ' . $page_views . '</span></td>'; $db->query('SELECT hof_name FROM album JOIN account USING(account_id) WHERE hof_name > ' . $db->escapeString($nick) . ' AND approved = \'YES\' ORDER BY hof_name LIMIT 1'); echo '<td style="text-align: center; width: 30%" valign="middle">'; if ($db->nextRecord()) { $next_nick = $db->getField('hof_name'); echo ' <a href="' . URL . '/album/?' . urlencode($next_nick) . '"><img src="' . URL . '/images/album/fwd.jpg" alt="' . $next_nick . '" border="0"></a>'; } echo '</td>'; echo '</tr>'; echo '</table>'; echo '</div>'; echo '</td>'; echo '</tr>'; echo '<tr>'; echo '<td colspan="2" align="center" valign="middle">'; if ($disabled == false) { echo '<img src="' . URL . '/upload/' . $album_id . '">'; } else { echo '<img src="' . URL . '/images/album/disabled.jpg">'; } echo '</td>'; echo '</tr>'; if (empty($location)) { $location = 'N/A'; } echo '<tr>'; echo '<td align="right" width="10%" style="font-weight:bold;">Location:</td><td>' . $location . '</td>'; echo '</tr>'; if (empty($email)) { $email = 'N/A'; } echo '<tr>'; echo '<td align="right" width="10%" style="font-weight:bold;">eMail:</td><td>' . $email . '</td>'; echo '</tr>'; if (empty($website)) { $website = 'N/A'; } else { $website = '<a href="' . $website . '" target="_new">' . $website . '</a>'; } echo '<tr>'; echo '<td align="right" width="10%" style="font-weight:bold;">Website:</td><td>' . $website . '</td>'; echo '</tr>'; echo '<tr>'; if (!empty($day) && !empty($month) && !empty($year)) { $birthdate = $month . ' / ' . $day . ' / ' . $year; } if (empty($birthdate) && !empty($year)) { $birthdate = 'Year ' . $year; } if (empty($birthdate)) { $birthdate = 'N/A'; } echo '<td align="right" width="10%" style="font-weight:bold;">Birthdate:</td><td>' . $birthdate . '</td>'; echo '</tr>'; if (empty($other)) { $other = 'N/A'; } echo '<tr>'; echo '<td align="right" valign="top" width="10%" style="font-weight:bold;">Other Info:<br /><small>(AIM/ICQ) </small></td><td>' . $other . '</td>'; echo '</tr>'; echo '<tr>'; echo '<td colspan="2">'; echo '<u>Comments</u><br /><br />'; $db->query('SELECT * FROM album_has_comments WHERE album_id = ' . $db->escapeNumber($album_id)); while ($db->nextRecord()) { $time = $db->getField('time'); $postee = get_album_nick($db->getField('post_id')); $msg = stripslashes($db->getField('msg')); echo '<span style="font-size:85%;">[' . date(defined('DATE_FULL_SHORT') ? DATE_FULL_SHORT : DEFAULT_DATE_FULL_SHORT, $time) . '] <' . $postee . '> ' . $msg . '</span><br />'; } if (SmrSession::$account_id > 0) { echo '<form action="' . URL . '/album/album_comment.php">'; echo '<input type="hidden" name="album_id" value="' . $album_id . '">'; echo '<table>'; echo '<tr>'; echo '<td style="color:green; font-size:70%;">Nick:<br /><input type="text" size="10" name="nick" value="' . htmlspecialchars(get_album_nick(SmrSession::$account_id)) . '" id="InputFields" readonly></td>'; echo '<td style="color:green; font-size:70%;">Comment:<br /><input type="text" size="50" name="comment" id="InputFields"></td>'; echo '<td style="color:green; font-size:70%;"><br /><input type="submit" value="Send" id="InputFields"></td>'; $db->query('SELECT * FROM account_has_permission WHERE account_id = ' . $db->escapeNumber(SmrSession::$account_id) . ' AND permission_id = ' . $db->escapeNumber(PERMISSION_MODERATE_PHOTO_ALBUM)); if ($db->nextRecord()) { echo '<td style="color:green; font-size:70%;"><br /><input type="submit" name="action" value="Moderate" id="InputFields"></td>'; } echo '</tr>'; echo '</table>'; echo '</form>'; } else { echo '<p>Please <a href="' . URL . '/login.php?return_page=' . URL . '/album/?' . urlencode($nick) . '"><u>login</u></a> if you want comment on this picture!</p>'; } echo '</td>'; echo '</tr>'; echo '</table>'; }
if (!empty($newsletterHtml)) { $mail->MsgHTML($newsletterHtml); if (!empty($newsletterText)) { $mail->AltBody = $newsletterText; } } else { $mail->Body = $newsletterText; } // attach footer // $mail->Body .= EOL.EOL.'Thank you,'.EOL.' SMR Support Team'.EOL.EOL.'Note: You receive this e-mail because you are registered with Space Merchant Realms. If you prefer not to get any further notices please respond and we will disable your account.'; } if ($_REQUEST['to_email'] == '*') { // counter $i = 1; $total = 0; $db->query('SELECT account_id, email, first_name, last_name FROM newsletter_accounts WHERE account_id >= ' . $db->escapeNumber($i) . ' ORDER BY account_id'); while ($db->nextRecord()) { // get account data $account_id = $db->getField('account_id'); $to_email = $db->getField('email'); $to_name = $db->getField('first_name') . ' ' . $db->getField('last_name'); // debug output echo $account_id . '. Preparing mail for ' . $to_name . ' <' . $to_email . '>... '; // set a bounce address we can process later $mail->From = 'bounce_' . $account_id . '@smrealms.de'; $mail->AddAddress($to_email, $to_name); if (!$mail->Send()) { echo 'error.' . EOL . $mail->ErrorInfo; $mail->SmtpClose(); ob_flush(); exit;
//db object $db2 = new SmrMySqlDatabase(); //split the name $acc = $_REQUEST['anon_account']; $game = $_REQUEST['game_id']; //get account info $db->query('SELECT * FROM anon_bank_transactions WHERE anon_id = ' . $db->escapeNumber($acc) . ' AND game_id = ' . $db->escapeNumber($game) . ' ORDER BY transaction_id'); if ($db->getNumRows() > 0) { $template->assign('PageTopic', 'Anonymous Account ' . $acc); $PHP_OUTPUT .= create_table(); $PHP_OUTPUT .= '<tr><th align=center>Player Name</th><th align=center>Type</th><th align=center>Amount</th></tr>'; while ($db->nextRecord()) { $db2->query('SELECT * FROM player WHERE account_id = ' . $db2->escapeNumber($db->getInt('account_id'))); $db2->nextRecord(); $PHP_OUTPUT .= '<tr><td align=center>'; $PHP_OUTPUT .= $db2->getField('player_name'); $PHP_OUTPUT .= '</td><td align=center>'; $PHP_OUTPUT .= $db->getField('transaction'); $PHP_OUTPUT .= '</td><td align=center>'; $PHP_OUTPUT .= $db->getField('amount'); $PHP_OUTPUT .= '</td></tr>'; } $PHP_OUTPUT .= '</table>'; } else { $PHP_OUTPUT .= 'Account ' . $acc . ' in game ' . $game . ' does NOT exist!'; } }
<?php $container = array(); $container['url'] = 'skeleton.php'; $container['body'] = 'message_blacklist.php'; if (!isset($_REQUEST['entry_ids']) || !is_array($_REQUEST['entry_ids'])) { $container['error'] = 4; forward($container); exit; } foreach ($_REQUEST['entry_ids'] as $entry_id) { if (!is_numeric($entry_id)) { $container['error'] = 5; forward($container); exit; } else { $entry_ids[] = $entry_id; } } $db = new SmrMySqlDatabase(); $db->query('DELETE FROM message_blacklist WHERE account_id=' . $db->escapeNumber($player->getAccountID()) . ' AND entry_id IN (' . $db->escapeArray($entry_ids) . ')'); forward($container);
<?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');
break; case 3: $PHP_OUTPUT .= '<span class="yellow">' . $_REQUEST['PlayerName'] . '</span> has been added to your blacklist.'; break; case 4: $PHP_OUTPUT .= '<span class="red bold">ERROR: </span>No entries selected for deletion.'; break; default: $PHP_OUTPUT .= '<span class="red bold">ERROR: </span>Unknown error event.'; break; } $PHP_OUTPUT .= '<br /><br />'; } $PHP_OUTPUT .= '<h2>Blacklisted Players</h2><br />'; $db = new SmrMySqlDatabase(); $db->query('SELECT p.player_name, p.game_id, b.entry_id FROM player p JOIN message_blacklist b ON p.account_id = b.blacklisted_id AND b.game_id = p.game_id WHERE b.account_id=' . $db->escapeNumber($player->getAccountID()) . ' ORDER BY p.game_id, p.player_name'); if ($db->getNumRows()) { $container = array(); $container['url'] = 'message_blacklist_del.php'; $form = create_form($container, 'Remove Selected'); $PHP_OUTPUT .= $form['form']; $PHP_OUTPUT .= '<table class="standard"><tr><th>Option</th><th>Name</th><th>Game ID</th>'; while ($db->nextRecord()) { $row = $db->getRow(); $PHP_OUTPUT .= '<tr>'; $PHP_OUTPUT .= '<td class="center shrink"><input type="checkbox" name="entry_ids[]" value="' . $row['entry_id'] . '"></td>'; $PHP_OUTPUT .= '<td>' . $row['player_name'] . '</td>'; $PHP_OUTPUT .= '<td>' . $row['game_id'] . '</td>'; $PHP_OUTPUT .= '</tr>'; } $PHP_OUTPUT .= '</table><br />';
//split it into individual IDs $accountIDs = explode('-', $associatedAccs); //make sure this is good data. if ($accountIDs[0] != MULTI_CHECKING_COOKIE_VERSION) { continue; } //how many are they linked to? $rows = sizeof($accountIDs); $echoMainAcc = TRUE; $currTabAccId = $db->getField('account_id'); //if this account was listed with another we can skip it. if (isset($used[$currTabAccId])) { continue; } if ($rows > 1) { $db2->query('SELECT account_id, login FROM account WHERE account_id =' . $db2->escapeNumber($currTabAccId) . ($skipUnusedAccs ? ' AND last_login > ' . $db2->escapeNumber(TIME - 86400 * 30) : '') . ' LIMIT 1'); if ($db2->nextRecord()) { $currTabAccLogin = $db2->getField('login'); } else { continue; } if (!$skipClosedAccs) { $db2->query('SELECT * FROM account_is_closed WHERE account_id = ' . $db2->escapeNumber($currTabAccId)); if ($db2->nextRecord()) { if ($db2->getField('reason_id') != 5) { $PHP_OUTPUT .= 'Closed: ' . $db2->getField('suspicion') . '.<br />'; } else { continue; } } } else {
} $PHP_OUTPUT .= '</select>'; $PHP_OUTPUT .= '</td>'; } //$alliance_vs[] = $curr_alliance_id; } $PHP_OUTPUT .= '<td width=10% valign="top">None</td>'; $PHP_OUTPUT .= '</tr>'; //$db->query('SELECT * FROM alliance WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY alliance_kills DESC, alliance_name LIMIT 5'); foreach ($alliance_vs as $key => $id) { $PHP_OUTPUT .= '<tr>'; // get current alliance $curr_id = $id; if ($id > 0) { $curr_alliance =& SmrAlliance::getAlliance($id, $player->getGameID()); $db2->query('SELECT 1 FROM player WHERE alliance_id = ' . $db2->escapeNumber($curr_id) . ' AND game_id = ' . $db2->escapeNumber($player->getGameID()) . ' LIMIT 1'); $out = $db2->nextRecord(); $PHP_OUTPUT .= '<td width=10% valign="top"'; if ($player->getAllianceID() == $curr_alliance->getAllianceID()) { $PHP_OUTPUT .= ' class="bold"'; } if ($out) { $PHP_OUTPUT .= ' class="red"'; } $PHP_OUTPUT .= '>'; $container1 = array(); $container1['url'] = 'skeleton.php'; $container1['body'] = 'rankings_alliance_vs_alliance.php'; $container1['alliance_id'] = $curr_alliance->getAllianceID(); $PHP_OUTPUT .= create_link($container1, $curr_alliance->getAllianceName()); //$PHP_OUTPUT.=('.$db->escapeString($curr_alliance->getAllianceName()');
// save session (incase we forward) SmrSession::update(); if ($disabled['Reason'] == 'Invalid eMail') { header('Location: ' . URL . '/email.php'); exit; } else { header('Location: ' . URL . '/disabled.php'); exit; } } // ********************************* // * // * a u t o n e w b i e t u r n // * // ********************************* $db->query('SELECT * FROM active_session ' . 'WHERE last_accessed > ' . $db->escapeNumber(TIME - TIME_BEFORE_NEWBIE_TIME)); if ($db->getNumRows() == 0) { $db->query('UPDATE player SET newbie_turns = 1 WHERE newbie_turns = 0 AND land_on_planet = \'FALSE\''); } // ****************************************** // * // * r e m o v e e x p i r e d s t u f f // * // ****************************************** $db->query('DELETE FROM player_has_ticker WHERE expires <= ' . $db->escapeNumber(TIME)); $db->query('DELETE FROM cpl_tag WHERE expires <= ' . $db->escapeNumber(TIME) . ' AND expires > 0'); // save ip $account->updateIP(); //now we set a cookie that we can use for mult checking
foreach ($id as $location_type_id => $temp_array) { foreach ($temp_array as $galaxy_id => $amount) { $count = 0; // get one sector where we put it $db->query('SELECT * FROM sector WHERE game_id = ' . $db->escapeNumber($var['game_id']) . ' AND galaxy_id = ' . $db->escapeNumber($galaxy_id) . ' ORDER BY rand()'); while ($count < $amount && $db->nextRecord()) { $sector_id = $db->getField('sector_id'); // does this sector already have a ship yard? $db2->query('SELECT * FROM location WHERE game_id = ' . $db->escapeNumber($var['game_id']) . ' AND sector_id = ' . $db->escapeNumber($sector_id)); if ($db2->getNumRows() > 0) { continue; } // ok we did $count locations so far $count++; // now putting the location in $db2->query('INSERT INTO location (game_id, sector_id, location_type_id) VALUES (' . $db2->escapeNumber($var['game_id']) . ', ' . $db2->escapeNumber($sector_id) . ', ' . $db2->escapeNumber($location_type_id) . ')'); } } } $container = array(); $container['url'] = 'skeleton.php'; $container['body'] = 'universe_create_hardware.php'; $container['game_id'] = $var['game_id']; forward($container);
if ($db->getField('alliance_id_1') == $player->getAllianceID()) { $allied[] = $db->getField('alliance_id_2'); } else { $allied[] = $db->getField('alliance_id_1'); } } //populate alliance list $db->query('SELECT account_id FROM player JOIN sector_has_forces ON sector_has_forces.game_id = player.game_id AND sector_has_forces.owner_id = player.account_id WHERE sector_has_forces.sector_id = ' . $db->escapeNumber($player->getSectorID()) . ' AND alliance_id IN (' . $db->escapeArray($allied) . ') AND player.game_id = ' . $db->escapeNumber($player->getGameID())); $time = TIME; $db2 = new SmrMySqlDatabase(); while ($db->nextRecord()) { $time += 2; $db2->query('UPDATE sector_has_forces SET refresh_at=' . $db2->escapeNumber($time) . ', refresher=' . $db2->escapeNumber($player->getAccountID()) . ' WHERE game_id = ' . $db2->escapeNumber($player->getGameID()) . ' AND sector_id = ' . $db2->escapeNumber($player->getSectorID()) . ' AND owner_id=' . $db2->escapeNumber($db->getInt('account_id')) . ' LIMIT 1'); } } else { $db->query('UPDATE sector_has_forces SET refresh_at=' . $db->escapeNumber(TIME + 2) . ', refresher=' . $db->escapeNumber($player->getAccountID()) . ' WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' AND sector_id = ' . $db->escapeNumber($player->getSectorID()) . ' AND owner_id=' . $db->escapeNumber($db->getInt('account_id')) . ' LIMIT 1'); } $message = '[Force Check]'; //this notifies the CS to look for info. $container = create_container('skeleton.php', 'current_sector.php'); $container['msg'] = $message; forward($container);