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