Пример #1
0
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;
}
Пример #2
0
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;
}
Пример #3
0
$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');
Пример #4
0
			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;">';
Пример #5
0
$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>';
Пример #6
0
				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');
        }
Пример #7
0
<?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);
Пример #8
0
        $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);
}
Пример #9
0
<?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;
Пример #10
0
    $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>&lt; Back</b>');
Пример #11
0
<?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) . ')');
Пример #12
0
$PHP_OUTPUT .= '<p>&nbsp;</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>&nbsp;</p>';
$PHP_OUTPUT .= '<p>';
$PHP_OUTPUT .= create_link(create_container('skeleton.php', 'log_console.php'), '<b>&lt; Back</b>');
$PHP_OUTPUT .= '</p>';
Пример #13
0
    $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');
    }
}
Пример #14
0
}
$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>';
Пример #15
0
    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);
}
Пример #16
0
         $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>&nbsp;</td>';
     }
     $PHP_OUTPUT .= '<td><input type="checkbox" name="account_id[]" value="' . $new_acc->getAccountID() . '"></td>';
     $PHP_OUTPUT .= '</tr>';
Пример #17
0
<?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) . ')');
Пример #18
0
}
$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 .= '&nbsp;&nbsp;';
$PHP_OUTPUT .= create_submit('Skip >>');
Пример #19
0
		<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) {
Пример #20
0
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>&nbsp;&nbsp;&nbsp;';
    }
    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 '&nbsp;&nbsp;&nbsp;<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&nbsp;Info:<br /><small>(AIM/ICQ)&nbsp;&nbsp;</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) . '] &lt;' . $postee . '&gt; ' . $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;
Пример #22
0
    //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!';
    }
}
Пример #23
0
<?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);
Пример #24
0
<?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');
Пример #25
0
            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 />';
Пример #26
0
 //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()');
Пример #28
0
        // 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);
Пример #30
0
        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);