function ShowTeamspeakPage() { global $LNG; $config = Config::get(Universe::getEmulated()); if ($_POST) { $config_before = array('ts_timeout' => $config->ts_timeout, 'ts_modon' => $config->ts_modon, 'ts_server' => $config->ts_server, 'ts_tcpport' => $config->ts_tcpport, 'ts_udpport' => $config->ts_udpport, 'ts_version' => $config->ts_version, 'ts_login' => $config->ts_login, 'ts_password' => $config->ts_password, 'ts_cron_interval' => $config->ts_cron_interval); $ts_modon = isset($_POST['ts_on']) && $_POST['ts_on'] == 'on' ? 1 : 0; $ts_server = HTTP::_GP('ts_ip', ''); $ts_tcpport = HTTP::_GP('ts_tcp', 0); $ts_udpport = HTTP::_GP('ts_udp', 0); $ts_timeout = HTTP::_GP('ts_to', 0); $ts_version = HTTP::_GP('ts_v', 0); $ts_login = HTTP::_GP('ts_login', ''); $ts_password = HTTP::_GP('ts_password', '', true); $ts_cron_interval = HTTP::_GP('ts_cron', 0); $config_after = array('ts_timeout' => $ts_timeout, 'ts_modon' => $ts_modon, 'ts_server' => $ts_server, 'ts_tcpport' => $ts_tcpport, 'ts_udpport' => $ts_udpport, 'ts_version' => $ts_version, 'ts_login' => $ts_login, 'ts_password' => $ts_password, 'ts_cron_interval' => $ts_cron_interval); foreach ($config_after as $key => $value) { $config->{$key} = $value; } $config->save(); $sql = "UPDATE %%CRONJOBS%%\n\t\tSET isActive = :isActive, `lock` = NULL, nextTime = 0\n\t\tWHERE name = 'teamspeak';"; Database::get()->update($sql, array(':isActive' => $ts_modon)); $LOG = new Log(3); $LOG->target = 4; $LOG->old = $config_before; $LOG->new = $config_after; $LOG->save(); } $template = new template(); $template->assign_vars(array('se_save_parameters' => $LNG['se_save_parameters'], 'ts_tcpport' => $LNG['ts_tcpport'], 'ts_serverip' => $LNG['ts_serverip'], 'ts_version' => $LNG['ts_version'], 'ts_active' => $LNG['ts_active'], 'ts_settings' => $LNG['ts_settings'], 'ts_udpport' => $LNG['ts_udpport'], 'ts_timeout' => $LNG['ts_timeout'], 'ts_server_query' => $LNG['ts_server_query'], 'ts_sq_login' => $LNG['ts_login'], 'ts_sq_pass' => $LNG['ts_pass'], 'ts_lng_cron' => $LNG['ts_cron'], 'ts_to' => $config->ts_timeout, 'ts_on' => $config->ts_modon, 'ts_ip' => $config->ts_server, 'ts_tcp' => $config->ts_tcpport, 'ts_udp' => $config->ts_udpport, 'ts_v' => $config->ts_version, 'ts_login' => $config->ts_login, 'ts_password' => $config->ts_password, 'ts_cron' => $config->ts_cron_interval)); $template->show('TeamspeakPage.tpl'); }
function send() { global $USER, $LNG; $ticketID = HTTP::_GP('id', 0); $message = HTTP::_GP('message', '', true); $change = HTTP::_GP('change_status', 0); $ticketDetail = $GLOBALS['DATABASE']->getFirstRow("SELECT ownerID, subject, status FROM " . TICKETS . " WHERE ticketID = " . $ticketID . ";"); $status = $change ? $ticketDetail['status'] <= 1 ? 2 : 1 : 1; if (!$change && empty($message)) { HTTP::redirectTo('admin.php?page=support&mode=view&id=' . $ticketID); } $subject = "RE: " . $ticketDetail['subject']; if ($change && $status == 1) { $this->ticketObj->createAnswer($ticketID, $USER['id'], $USER['username'], $subject, $LNG['ti_admin_open'], $status); } if (!empty($message)) { $this->ticketObj->createAnswer($ticketID, $USER['id'], $USER['username'], $subject, $message, $status); } if ($change && $status == 2) { $this->ticketObj->createAnswer($ticketID, $USER['id'], $USER['username'], $subject, $LNG['ti_admin_close'], $status); } $subject = sprintf($LNG['sp_answer_message_title'], $ticketID); $text = sprintf($LNG['sp_answer_message'], $ticketID); PlayerUtil::sendMessage($ticketDetail['ownerID'], $USER['id'], $USER['username'], 4, $subject, $text, TIMESTAMP, NULL, 1, Universe::getEmulated()); HTTP::redirectTo('admin.php?page=support'); }
/** * 2Moons * Copyright (C) 2012 Jan Kröpke * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. * * @package 2Moons * @author Jan Kröpke <*****@*****.**> * @copyright 2012 Jan Kröpke <*****@*****.**> * @license http://www.gnu.org/licenses/gpl.html GNU GPLv3 License * @version 1.7.2 (2013-03-18) * @info $Id$ * @link http://2moons.cc/ */ function ShowMenuPage() { global $USER; $template = new template(); $template->assign_vars(array('supportticks' => $GLOBALS['DATABASE']->getFirstCell("SELECT COUNT(*) FROM " . TICKETS . " WHERE universe = " . Universe::getEmulated() . " AND status = 0;"))); $template->show('ShowMenuPage.tpl'); }
function ShowFlyingFleetPage() { global $LNG; $id = HTTP::_GP('id', 0); if (!empty($id)) { $lock = HTTP::_GP('lock', 0); $GLOBALS['DATABASE']->query("UPDATE " . FLEETS . " SET `fleet_busy` = '" . $lock . "' WHERE `fleet_id` = '" . $id . "' AND `fleet_universe` = '" . Universe::getEmulated() . "';"); $SQL = $lock == 0 ? "NULL" : "'ADM_LOCK'"; $GLOBALS['DATABASE']->query("UPDATE " . FLEETS_EVENT . " SET `lock` = " . $SQL . " WHERE `fleetID` = " . $id . ";"); } $orderBy = "fleet_id"; $fleetResult = $GLOBALS['DATABASE']->query("SELECT \n\tfleet.*,\n\tevent.`lock`,\n\tCOUNT(event.fleetID) as error,\n\tpstart.name as startPlanetName,\n\tptarget.name as targetPlanetName,\n\tustart.username as startUserName,\n\tutarget.username as targetUserName,\n\tacs.name as acsName\n\tFROM " . FLEETS . " fleet\n\tLEFT JOIN " . FLEETS_EVENT . " event ON fleetID = fleet_id\n\tLEFT JOIN " . PLANETS . " pstart ON pstart.id = fleet_start_id\n\tLEFT JOIN " . PLANETS . " ptarget ON ptarget.id = fleet_end_id\n\tLEFT JOIN " . USERS . " ustart ON ustart.id = fleet_owner\n\tLEFT JOIN " . USERS . " utarget ON utarget.id = fleet_target_owner\n\tLEFT JOIN " . AKS . " acs ON acs.id = fleet_group\n\tWHERE fleet_universe = " . Universe::getEmulated() . "\n\tGROUP BY event.fleetID\n\tORDER BY " . $orderBy . ";"); $FleetList = array(); while ($fleetRow = $GLOBALS['DATABASE']->fetch_array($fleetResult)) { $shipList = array(); $shipArray = array_filter(explode(';', $fleetRow['fleet_array'])); foreach ($shipArray as $ship) { $shipDetail = explode(',', $ship); $shipList[$shipDetail[0]] = $shipDetail[1]; } $FleetList[] = array('fleetID' => $fleetRow['fleet_id'], 'lock' => !empty($fleetRow['lock']), 'count' => $fleetRow['fleet_amount'], 'error' => !$fleetRow['error'], 'ships' => $shipList, 'state' => $fleetRow['fleet_mess'], 'starttime' => _date($LNG['php_tdformat'], $fleetRow['start_time'], $USER['timezone']), 'arrivaltime' => _date($LNG['php_tdformat'], $fleetRow['fleet_start_time'], $USER['timezone']), 'stayhour' => round(($fleetRow['fleet_end_stay'] - $fleetRow['fleet_start_time']) / 3600), 'staytime' => $fleetRow['fleet_start_time'] !== $fleetRow['fleet_end_stay'] ? _date($LNG['php_tdformat'], $fleetRow['fleet_end_stay'], $USER['timezone']) : 0, 'endtime' => _date($LNG['php_tdformat'], $fleetRow['fleet_end_time'], $USER['timezone']), 'missionID' => $fleetRow['fleet_mission'], 'acsID' => $fleetRow['fleet_group'], 'acsName' => $fleetRow['acsName'], 'startUserID' => $fleetRow['fleet_owner'], 'startUserName' => $fleetRow['startUserName'], 'startPlanetID' => $fleetRow['fleet_start_id'], 'startPlanetName' => $fleetRow['startPlanetName'], 'startPlanetGalaxy' => $fleetRow['fleet_start_galaxy'], 'startPlanetSystem' => $fleetRow['fleet_start_system'], 'startPlanetPlanet' => $fleetRow['fleet_start_planet'], 'startPlanetType' => $fleetRow['fleet_start_type'], 'targetUserID' => $fleetRow['fleet_target_owner'], 'targetUserName' => $fleetRow['targetUserName'], 'targetPlanetID' => $fleetRow['fleet_end_id'], 'targetPlanetName' => $fleetRow['targetPlanetName'], 'targetPlanetGalaxy' => $fleetRow['fleet_end_galaxy'], 'targetPlanetSystem' => $fleetRow['fleet_end_system'], 'targetPlanetPlanet' => $fleetRow['fleet_end_planet'], 'targetPlanetType' => $fleetRow['fleet_end_type'], 'resource' => array(901 => $fleetRow['fleet_resource_metal'], 902 => $fleetRow['fleet_resource_crystal'], 903 => $fleetRow['fleet_resource_deuterium'], 921 => $fleetRow['fleet_resource_darkmatter'])); } $GLOBALS['DATABASE']->free_result($fleetResult); $template = new template(); $template->assign_vars(array('FleetList' => $FleetList)); $template->show('FlyingFleetPage.tpl'); }
function ShowDisclamerPage() { global $LNG; $config = Config::get(Universe::getEmulated()); if (!empty($_POST)) { $config_before = array('disclamerAddress' => $config->disclamerAddress, 'disclamerPhone' => $config->disclamerPhone, 'disclamerMail' => $config->disclamerMail, 'disclamerNotice' => $config->disclamerNotice); $disclaimerAddress = HTTP::_GP('disclaimerAddress', '', true); $disclaimerPhone = HTTP::_GP('disclaimerPhone', '', true); $disclaimerMail = HTTP::_GP('disclaimerMail', '', true); $disclaimerNotice = HTTP::_GP('disclaimerNotice', '', true); $config_after = array('disclamerAddress' => $disclaimerAddress, 'disclamerPhone' => $disclaimerPhone, 'disclamerMail' => $disclaimerMail, 'disclamerNotice' => $disclaimerNotice); foreach ($config_after as $key => $value) { $config->{$key} = $value; } $config->save(); $LOG = new Log(3); $LOG->target = 5; $LOG->old = $config_before; $LOG->new = $config_after; $LOG->save(); } $template = new template(); $template->loadscript('../base/jquery.autosize-min.js'); $template->execscript('$(\'textarea\').autosize();'); $template->assign_vars(array('disclaimerAddress' => $config->disclamerAddress, 'disclaimerPhone' => $config->disclamerPhone, 'disclaimerMail' => $config->disclamerMail, 'disclaimerNotice' => $config->disclamerNotice, 'se_server_parameters' => $LNG['mu_disclaimer'], 'se_save_parameters' => $LNG['se_save_parameters'], 'se_disclaimerAddress' => $LNG['se_disclaimerAddress'], 'se_disclaimerPhone' => $LNG['se_disclaimerPhone'], 'se_disclaimerMail' => $LNG['se_disclaimerMail'], 'se_disclaimerNotice' => $LNG['se_disclaimerNotice'])); $template->show('DisclamerConfigBody.tpl'); }
function ShowChatConfigPage() { global $LNG; $config = Config::get(Universe::getEmulated()); if (!empty($_POST)) { $config_before = array('chat_closed' => $config->chat_closed, 'chat_allowchan' => $config->chat_allowchan, 'chat_allowmes' => $config->chat_allowmes, 'chat_allowdelmes' => $config->chat_allowdelmes, 'chat_logmessage' => $config->chat_logmessage, 'chat_nickchange' => $config->chat_nickchange, 'chat_botname' => $config->chat_botname, 'chat_channelname' => $config->chat_channelname); $chat_allowchan = isset($_POST['chat_allowchan']) && $_POST['chat_allowchan'] == 'on' ? 1 : 0; $chat_allowmes = isset($_POST['chat_allowmes']) && $_POST['chat_allowmes'] == 'on' ? 1 : 0; $chat_allowdelmes = isset($_POST['chat_allowdelmes']) && $_POST['chat_allowdelmes'] == 'on' ? 1 : 0; $chat_logmessage = isset($_POST['chat_logmessage']) && $_POST['chat_logmessage'] == 'on' ? 1 : 0; $chat_nickchange = isset($_POST['chat_nickchange']) && $_POST['chat_nickchange'] == 'on' ? 1 : 0; $chat_closed = isset($_POST['chat_closed']) && $_POST['chat_closed'] == 'on' ? 1 : 0; $chat_channelname = HTTP::_GP('chat_channelname', '', true); $chat_botname = HTTP::_GP('chat_botname', '', true); $config_after = array('chat_closed' => $chat_closed, 'chat_allowchan' => $chat_allowchan, 'chat_allowmes' => $chat_allowmes, 'chat_allowdelmes' => $chat_allowdelmes, 'chat_logmessage' => $chat_logmessage, 'chat_nickchange' => $chat_nickchange, 'chat_botname' => $chat_botname, 'chat_channelname' => $chat_channelname); foreach ($config_after as $key => $value) { $config->{$key} = $value; } $config->save(); $LOG = new Log(3); $LOG->target = 3; $LOG->old = $config_before; $LOG->new = $config_after; $LOG->save(); } $template = new template(); $template->assign_vars(array('chat_closed' => $config->chat_closed, 'chat_allowchan' => $config->chat_allowchan, 'chat_allowmes' => $config->chat_allowmes, 'chat_logmessage' => $config->chat_logmessage, 'chat_nickchange' => $config->chat_nickchange, 'chat_botname' => $config->chat_botname, 'chat_channelname' => $config->chat_channelname, 'se_server_parameters' => $LNG['se_server_parameters'], 'se_save_parameters' => $LNG['se_save_parameters'], 'ch_closed' => $LNG['ch_closed'], 'ch_allowchan' => $LNG['ch_allowchan'], 'ch_allowmes' => $LNG['ch_allowmes'], 'ch_allowdelmes' => $LNG['ch_allowdelmes'], 'ch_logmessage' => $LNG['ch_logmessage'], 'ch_nickchange' => $LNG['ch_nickchange'], 'ch_botname' => $LNG['ch_botname'], 'ch_channelname' => $LNG['ch_channelname'])); $template->show('ChatConfigBody.tpl'); }
function ShowMultiIPPage() { global $LNG; switch ($_GET['action']) { case 'known': $GLOBALS['DATABASE']->query("INSERT INTO " . MULTI . " SET userID = " . (int) $_GET['id'] . ";"); HTTP::redirectTo("admin.php?page=multiips"); break; case 'unknown': $GLOBALS['DATABASE']->query("DELETE FROM " . MULTI . " WHERE userID = " . (int) $_GET['id'] . ";"); HTTP::redirectTo("admin.php?page=multiips"); break; } $Query = $GLOBALS['DATABASE']->query("SELECT id, username, email, register_time, onlinetime, user_lastip, IFNULL(multiID, 0) as isKnown FROM " . USERS . " LEFT JOIN " . MULTI . " ON userID = id WHERE `universe` = '" . Universe::getEmulated() . "' AND user_lastip IN (SELECT user_lastip FROM " . USERS . " WHERE `universe` = '" . Universe::getEmulated() . "' GROUP BY user_lastip HAVING COUNT(*)>1) ORDER BY user_lastip, id ASC;"); $IPs = array(); while ($Data = $GLOBALS['DATABASE']->fetch_array($Query)) { if (!isset($IPs[$Data['user_lastip']])) { $IPs[$Data['user_lastip']] = array(); } $Data['register_time'] = _date($LNG['php_tdformat'], $Data['register_time']); $Data['onlinetime'] = _date($LNG['php_tdformat'], $Data['onlinetime']); $IPs[$Data['user_lastip']][$Data['id']] = $Data; } $template = new template(); $template->assign_vars(array('multiGroups' => $IPs)); $template->show('MultiIPs.tpl'); }
function ShowSendMessagesPage() { global $USER, $LNG; $ACTION = HTTP::_GP('action', ''); if ($ACTION == 'send') { switch ($USER['authlevel']) { case AUTH_MOD: $class = 'mod'; break; case AUTH_OPS: $class = 'ops'; break; case AUTH_ADM: $class = 'admin'; break; default: $class = ''; break; } $Subject = HTTP::_GP('subject', '', true); $Message = HTTP::_GP('text', '', true); $Mode = HTTP::_GP('mode', 0); $Lang = HTTP::_GP('lang', ''); if (!empty($Message) && !empty($Subject)) { require 'includes/classes/BBCode.class.php'; if ($Mode == 0 || $Mode == 2) { $From = '<span class="' . $class . '">' . $LNG['user_level'][$USER['authlevel']] . ' ' . $USER['username'] . '</span>'; $pmSubject = '<span class="' . $class . '">' . $Subject . '</span>'; $pmMessage = '<span class="' . $class . '">' . BBCode::parse($Message) . '</span>'; $USERS = $GLOBALS['DATABASE']->query("SELECT `id`, `username` FROM " . USERS . " WHERE `universe` = '" . Universe::getEmulated() . "'" . (!empty($Lang) ? " AND `lang` = '" . $GLOBALS['DATABASE']->sql_escape($Lang) . "'" : "") . ";"); while ($UserData = $GLOBALS['DATABASE']->fetch_array($USERS)) { $sendMessage = str_replace('{USERNAME}', $UserData['username'], $pmMessage); PlayerUtil::sendMessage($UserData['id'], $USER['id'], $From, 50, $pmSubject, $sendMessage, TIMESTAMP, NULL, 1, Universe::getEmulated()); } } if ($Mode == 1 || $Mode == 2) { require 'includes/classes/Mail.class.php'; $userList = array(); $USERS = $GLOBALS['DATABASE']->query("SELECT `email`, `username` FROM " . USERS . " WHERE `universe` = '" . Universe::getEmulated() . "'" . (!empty($Lang) ? " AND `lang` = '" . $GLOBALS['DATABASE']->sql_escape($Lang) . "'" : "") . ";"); while ($UserData = $GLOBALS['DATABASE']->fetch_array($USERS)) { $userList[$UserData['email']] = array('username' => $UserData['username'], 'body' => BBCode::parse(str_replace('{USERNAME}', $UserData['username'], $Message))); } Mail::multiSend($userList, strip_tags($Subject)); } exit($LNG['ma_message_sended']); } else { exit($LNG['ma_subject_needed']); } } $sendModes = $LNG['ma_modes']; if (Config::get()->mail_active == 0) { unset($sendModes[1]); unset($sendModes[2]); } $template = new template(); $template->assign_vars(array('langSelector' => array_merge(array('' => $LNG['ma_all']), $LNG->getAllowedLangs(false)), 'modes' => $sendModes)); $template->show('SendMessagesPage.tpl'); }
function ShowMessageListPage() { global $LNG; $page = HTTP::_GP('side', 1); $type = HTTP::_GP('type', 100); $sender = HTTP::_GP('sender', '', UTF8_SUPPORT); $receiver = HTTP::_GP('receiver', '', UTF8_SUPPORT); $dateStart = HTTP::_GP('dateStart', array()); $dateEnd = HTTP::_GP('dateEnd', array()); $perSide = 50; $messageList = array(); $userWhereSQL = ''; $dateWhereSQL = ''; $countJoinSQL = ''; $categories = $LNG['mg_type']; unset($categories[999]); $dateStart = array_filter($dateStart, 'is_numeric'); $dateEnd = array_filter($dateEnd, 'is_numeric'); $useDateStart = count($dateStart) == 3; $useDateEnd = count($dateEnd) == 3; if ($useDateStart && $useDateEnd) { $dateWhereSQL = ' AND message_time BETWEEN ' . mktime(0, 0, 0, (int) $dateStart['month'], (int) $dateStart['day'], (int) $dateStart['year']) . ' AND ' . mktime(23, 59, 59, (int) $dateEnd['month'], (int) $dateEnd['day'], (int) $dateEnd['year']); } elseif ($useDateStart) { $dateWhereSQL = ' AND message_time > ' . mktime(0, 0, 0, (int) $dateStart['month'], (int) $dateStart['day'], (int) $dateStart['year']); } elseif ($useDateStart) { $dateWhereSQL = ' AND message_time < ' . mktime(23, 59, 59, (int) $dateEnd['month'], (int) $dateEnd['day'], (int) $dateEnd['year']); } if (!empty($sender)) { $countJoinSQL .= ' LEFT JOIN ' . USERS . ' as us ON message_sender = us.id'; $userWhereSQL .= ' AND us.username = "******"'; } if (!empty($receiver)) { $countJoinSQL .= ' LEFT JOIN ' . USERS . ' as u ON message_owner = u.id'; $userWhereSQL .= ' AND u.username = "******"'; } if ($type != 100) { $MessageCount = $GLOBALS['DATABASE']->getFirstCell("SELECT COUNT(*) FROM " . MESSAGES . $countJoinSQL . " WHERE message_type = " . $type . " AND message_universe = " . Universe::getEmulated() . $dateWhereSQL . $userWhereSQL . ";"); } else { $MessageCount = $GLOBALS['DATABASE']->getFirstCell("SELECT COUNT(*) FROM " . MESSAGES . $countJoinSQL . " WHERE message_universe = " . Universe::getEmulated() . $dateWhereSQL . $userWhereSQL . ";"); } $maxPage = max(1, ceil($MessageCount / $perSide)); $page = max(1, min($page, $maxPage)); $sqlLimit = ($page - 1) * $perSide . ", " . ($perSide - 1); if ($type == 100) { $messageRaw = $GLOBALS['DATABASE']->query("SELECT u.username, us.username as senderName, m.* \n\t\tFROM " . MESSAGES . " as m \n\t\tLEFT JOIN " . USERS . " as u ON m.message_owner = u.id \n\t\tLEFT JOIN " . USERS . " as us ON m.message_sender = us.id\n\t\tWHERE m.message_universe = " . Universe::getEmulated() . "\n\t\t" . $dateWhereSQL . "\n\t\t" . $userWhereSQL . "\n\t\tORDER BY message_time DESC, message_id DESC\n\t\tLIMIT " . $sqlLimit . ";"); } else { $messageRaw = $GLOBALS['DATABASE']->query("SELECT u.username, us.username as senderName, m.* \n\t\tFROM " . MESSAGES . " as m\n\t\tLEFT JOIN " . USERS . " as u ON m.message_owner = u.id\n\t\tLEFT JOIN " . USERS . " as us ON m.message_sender = us.id\n\t\tWHERE m.message_type = " . $type . " AND message_universe = " . Universe::getEmulated() . "\n\t\t" . $dateWhereSQL . "\n\t\t" . $userWhereSQL . "\n\t\tORDER BY message_time DESC, message_id DESC\n\t\tLIMIT " . $sqlLimit . ";"); } while ($messageRow = $GLOBALS['DATABASE']->fetch_array($messageRaw)) { $messageList[$messageRow['message_id']] = array('sender' => empty($messageRow['senderName']) ? $messageRow['message_from'] : $messageRow['senderName'] . ' (ID: ' . $messageRow['message_sender'] . ')', 'receiver' => $messageRow['username'] . ' (ID: ' . $messageRow['message_owner'] . ')', 'subject' => $messageRow['message_subject'], 'text' => $messageRow['message_text'], 'type' => $messageRow['message_type'], 'time' => str_replace(' ', ' ', _date($LNG['php_tdformat'], $messageRow['message_time']), $USER['timezone'])); } $template = new template(); $template->assign_vars(array('categories' => $categories, 'maxPage' => $maxPage, 'page' => $page, 'messageList' => $messageList, 'type' => $type, 'dateStart' => $dateStart, 'dateEnd' => $dateEnd, 'sender' => $sender, 'receiver' => $receiver)); $template->show('MessageList.tpl'); }
/** * 2Moons * Copyright (C) 2012 Jan Kröpke * * For the full copyright and license information, please view the LICENSE * * @package 2Moons * @author Jan Kröpke <*****@*****.**> * @copyright 2012 Jan Kröpke <*****@*****.**> * @licence MIT * @version 1.7.2 (2013-03-18) * @info $Id$ * @link http://2moons.cc/ */ function ShowTopnavPage() { global $LNG, $USER; $template = new template(); $universeSelect = array(); foreach (Universe::availableUniverses() as $uniId) { $config = Config::get($uniId); $universeSelect[$uniId] = sprintf('%s (ID: %d)', $config->uni_name, $uniId); } ksort($universeSelect); $template->assign_vars(array('ad_authlevel_title' => $LNG['ad_authlevel_title'], 're_reset_universe' => $LNG['re_reset_universe'], 'mu_universe' => $LNG['mu_universe'], 'mu_moderation_page' => $LNG['mu_moderation_page'], 'adm_cp_title' => $LNG['adm_cp_title'], 'adm_cp_index' => $LNG['adm_cp_index'], 'adm_cp_logout' => $LNG['adm_cp_logout'], 'sid' => session_id(), 'id' => $USER['id'], 'authlevel' => $USER['authlevel'], 'AvailableUnis' => $universeSelect, 'UNI' => Universe::getEmulated())); $template->show('ShowTopnavPage.tpl'); }
function ShowGiveaway() { global $LNG, $resource, $reslist; $template = new template(); $action = HTTP::_GP('action', ''); if ($action == 'send') { $planet = HTTP::_GP('planet', 0); $moon = HTTP::_GP('moon', 0); $mainplanet = HTTP::_GP('mainplanet', 0); $no_inactive = HTTP::_GP('no_inactive', 0); if (!$planet && !$moon) { $template->message($LNG['ga_selectplanettype']); exit; } $planetIN = array(); if ($planet) { $planetIN[] = "'1'"; } if ($moon) { $planetIN[] = "'3'"; } $data = array(); $DataIDs = array_merge($reslist['resstype'][1], $reslist['resstype'][3], $reslist['build'], $reslist['tech'], $reslist['fleet'], $reslist['defense'], $reslist['officier']); $logOld = array(); $logNew = array(); foreach ($DataIDs as $ID) { $amount = max(0, round(HTTP::_GP('element_' . $ID, 0.0))); $data[] = $resource[$ID] . " = " . $resource[$ID] . " + " . $amount; $logOld[$ID] = 0; $logNew[$ID] = $amount; } $SQL = "UPDATE " . PLANETS . " p INNER JOIN " . USERS . " u ON p.id_owner = u.id"; if ($mainplanet == true) { $SQL .= " AND p.id = u.id_planet"; } if ($no_inactive == true) { $SQL .= " AND u.onlinetime > " . (TIMESTAMP - INACTIVE); } $SQL .= " SET " . implode(', ', $data) . " WHERE p.universe = " . Universe::getEmulated() . " AND p.planet_type IN (" . implode(',', $planetIN) . ")"; $GLOBALS['DATABASE']->query($SQL); $LOG = new Log(4); $LOG->target = 0; $LOG->old = $logOld; $LOG->new = $logNew; $LOG->save(); $template->message($LNG['ga_success']); exit; } $template->assign_vars(array('reslist' => $reslist)); $template->show("giveaway.tpl"); }
function ShowActivePage() { global $LNG, $USER; $id = HTTP::_GP('id', 0); if ($_GET['action'] == 'delete' && !empty($id)) { $GLOBALS['DATABASE']->query("DELETE FROM " . USERS_VALID . " WHERE `validationID` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"); } $query = $GLOBALS['DATABASE']->query("SELECT * FROM " . USERS_VALID . " WHERE `universe` = '" . Universe::getEmulated() . "' ORDER BY validationID ASC"); $Users = array(); while ($User = $GLOBALS['DATABASE']->fetch_array($query)) { $Users[] = array('id' => $User['validationID'], 'name' => $User['userName'], 'date' => _date($LNG['php_tdformat'], $User['date'], $USER['timezone']), 'email' => $User['email'], 'ip' => $User['ip'], 'password' => $User['password'], 'validationKey' => $User['validationKey']); } $template = new template(); $template->assign_vars(array('Users' => $Users, 'uni' => Universe::getEmulated())); $template->show('ActivePage.tpl'); }
function ShowFacebookPage() { global $LNG; $config = Config::get(Universe::getEmulated()); if ($_POST) { $fb_on = isset($_POST['fb_on']) && $_POST['fb_on'] == 'on' && !empty($_POST['fb_skey']) && !empty($_POST['fb_apikey']) ? 1 : 0; $fb_apikey = HTTP::_GP('fb_apikey', ''); $fb_skey = HTTP::_GP('fb_skey', ''); foreach (array('fb_on' => $fb_on, 'fb_apikey' => $fb_apikey, 'fb_skey' => $fb_skey) as $key => $value) { $config->{$key} = $value; } $config->save(); } $template = new template(); $template->assign_vars(array('se_save_parameters' => $LNG['se_save_parameters'], 'fb_info' => $LNG['fb_info'], 'fb_secrectkey' => $LNG['fb_secrectkey'], 'fb_api_key' => $LNG['fb_api_key'], 'fb_active' => $LNG['fb_active'], 'fb_settings' => $LNG['fb_settings'], 'fb_on' => $config->fb_on, 'fb_apikey' => $config->fb_apikey, 'fb_skey' => $config->fb_skey, 'fb_curl' => function_exists('curl_init') ? 1 : 0, 'fb_curl_info' => function_exists('curl_init') ? $LNG['fb_curl_yes'] : $LNG['fb_curl_no'])); $template->show('FacebookPage.tpl'); }
function ShowConfigBasicPage() { global $LNG; $config = Config::get(Universe::getEmulated()); if (!empty($_POST)) { $config_before = array('ttf_file' => $config->ttf_file, 'game_name' => $config->game_name, 'mail_active' => $config->mail_active, 'mail_use' => $config->mail_use, 'smail_path' => $config->smail_path, 'smtp_host' => $config->smtp_host, 'smtp_port' => $config->smtp_port, 'smtp_user' => $config->smtp_user, 'smtp_pass' => $config->smtp_pass, 'smtp_ssl' => $config->smtp_ssl, 'smtp_sendmail' => $config->smtp_sendmail, 'ga_active' => $config->ga_active, 'ga_key' => $config->ga_key, 'capaktiv' => $config->capaktiv, 'cappublic' => $config->cappublic, 'capprivate' => $config->capprivate, 'del_oldstuff' => $config->del_oldstuff, 'del_user_manually' => $config->del_user_manually, 'del_user_automatic' => $config->del_user_automatic, 'del_user_sendmail' => $config->del_user_sendmail, 'sendmail_inactive' => $config->sendmail_inactive, 'timezone' => $config->timezone, 'dst' => $config->dst, 'close_reason' => $config->close_reason); $capaktiv = isset($_POST['capaktiv']) && $_POST['capaktiv'] == 'on' ? 1 : 0; $ga_active = isset($_POST['ga_active']) && $_POST['ga_active'] == 'on' ? 1 : 0; $sendmail_inactive = isset($_POST['sendmail_inactive']) && $_POST['sendmail_inactive'] == 'on' ? 1 : 0; $mail_active = isset($_POST['mail_active']) && $_POST['mail_active'] == 'on' ? 1 : 0; $ttf_file = HTTP::_GP('ttf_file', ''); $close_reason = HTTP::_GP('close_reason', '', true); $game_name = HTTP::_GP('game_name', '', true); $capprivate = HTTP::_GP('capprivate', ''); $cappublic = HTTP::_GP('cappublic', ''); $ga_key = HTTP::_GP('ga_key', '', true); $mail_use = HTTP::_GP('mail_use', 0); $smail_path = HTTP::_GP('smail_path', ''); $smtp_host = HTTP::_GP('smtp_host', '', true); $smtp_port = HTTP::_GP('smtp_port', 0); $smtp_user = HTTP::_GP('smtp_user', '', true); $smtp_sendmail = HTTP::_GP('smtp_sendmail', '', true); $smtp_pass = HTTP::_GP('smtp_pass', '', true); $smtp_ssl = HTTP::_GP('smtp_ssl', ''); $del_oldstuff = HTTP::_GP('del_oldstuff', 0); $del_user_manually = HTTP::_GP('del_user_manually', 0); $del_user_automatic = HTTP::_GP('del_user_automatic', 0); $del_user_sendmail = HTTP::_GP('del_user_sendmail', 0); $timezone = HTTP::_GP('timezone', ''); $dst = HTTP::_GP('dst', 0); $config_after = array('ttf_file' => $ttf_file, 'game_name' => $game_name, 'mail_active' => $mail_active, 'mail_use' => $mail_use, 'smail_path' => $smail_path, 'smtp_host' => $smtp_host, 'smtp_port' => $smtp_port, 'smtp_user' => $smtp_user, 'smtp_pass' => $smtp_pass, 'smtp_ssl' => $smtp_ssl, 'smtp_sendmail' => $smtp_sendmail, 'ga_active' => $ga_active, 'ga_key' => $ga_key, 'capaktiv' => $capaktiv, 'cappublic' => $cappublic, 'capprivate' => $capprivate, 'del_oldstuff' => $del_oldstuff, 'del_user_manually' => $del_user_manually, 'del_user_automatic' => $del_user_automatic, 'del_user_sendmail' => $del_user_sendmail, 'sendmail_inactive' => $sendmail_inactive, 'timezone' => $timezone, 'dst' => $dst, 'close_reason' => $close_reason); foreach ($config_after as $key => $value) { $config->{$key} = $value; } $config->save(); $LOG = new Log(3); $LOG->target = 0; $LOG->old = $config_before; $LOG->new = $config_after; $LOG->save(); } $TimeZones = get_timezone_selector(); $template = new template(); $template->assign_vars(array('del_oldstuff' => $config->del_oldstuff, 'del_user_manually' => $config->del_user_manually, 'del_user_automatic' => $config->del_user_automatic, 'del_user_sendmail' => $config->del_user_sendmail, 'sendmail_inactive' => $config->sendmail_inactive, 'ttf_file' => $config->ttf_file, 'game_name' => $config->game_name, 'mail_active' => $config->mail_active, 'mail_use' => $config->mail_use, 'smail_path' => $config->smail_path, 'smtp_host' => $config->smtp_host, 'smtp_port' => $config->smtp_port, 'smtp_user' => $config->smtp_user, 'smtp_pass' => $config->smtp_pass, 'smtp_sendmail' => $config->smtp_sendmail, 'smtp_ssl' => $config->smtp_ssl, 'capprivate' => $config->capprivate, 'cappublic' => $config->cappublic, 'capaktiv' => $config->capaktiv, 'ga_active' => $config->ga_active, 'ga_key' => $config->ga_key, 'timezone' => $config->timezone, 'dst' => $config->dst, 'Selector' => array('timezone' => $TimeZones, 'mail' => $LNG['se_mail_sel'], 'encry' => array('' => $LNG['se_smtp_ssl_1'], 'ssl' => $LNG['se_smtp_ssl_2'], 'tls' => $LNG['se_smtp_ssl_3'])))); $template->show('ConfigBasicBody.tpl'); }
function ShowModulePage() { global $LNG; $config = Config::get(Universe::getEmulated()); $module = explode(';', $config->moduls); if ($_GET['mode']) { $module[HTTP::_GP('id', 0)] = $_GET['mode'] == 'aktiv' ? 1 : 0; $config->moduls = implode(";", $module); $config->save(); } $IDs = range(0, MODULE_AMOUNT - 1); foreach ($IDs as $ID => $Name) { $Modules[$ID] = array('name' => $LNG['modul'][$ID], 'state' => isset($module[$ID]) ? $module[$ID] : 1); } asort($Modules); $template = new template(); $template->assign_vars(array('Modules' => $Modules, 'mod_module' => $LNG['mod_module'], 'mod_info' => $LNG['mod_info'], 'mod_active' => $LNG['mod_active'], 'mod_deactive' => $LNG['mod_deactive'], 'mod_change_active' => $LNG['mod_change_active'], 'mod_change_deactive' => $LNG['mod_change_deactive'])); $template->show('ModulePage.tpl'); }
function ShowAutoCompletePage() { $searchText = HTTP::_GP('term', '', UTF8_SUPPORT); $searchList = array(); if (empty($searchText) || $searchText === '#') { echo json_encode(array()); exit; } if (substr($searchText, 0, 1) === '#') { $where = 'id = ' . (int) substr($searchText, 1); $orderBy = ' ORDER BY id ASC'; } else { $where = "username LIKE '%" . $GLOBALS['DATABASE']->escape($searchText, true) . "%'"; $orderBy = " ORDER BY (IF(username = '******'DATABASE']->sql_escape($searchText, true) . "', 1, 0) + IF(username LIKE '" . $GLOBALS['DATABASE']->sql_escape($searchText, true) . "%', 1, 0)) DESC, username"; } $userRaw = $GLOBALS['DATABASE']->query("SELECT id, username FROM " . USERS . " WHERE universe = " . Universe::getEmulated() . " AND " . $where . $orderBy . " LIMIT 20"); while ($userRow = $GLOBALS['DATABASE']->fetch_array($userRaw)) { $searchList[] = array('label' => $userRow['username'] . ' (ID:' . $userRow['id'] . ')', 'value' => $userRow['username']); } echo json_encode($searchList); exit; }
function ShowStatsPage() { global $LNG; $config = Config::get(Universe::getEmulated()); if ($_POST) { $config_before = array('stat_settings' => $config->stat_settings, 'stat' => $config->stat, 'stat_level' => $config->stat_level); $stat_settings = HTTP::_GP('stat_settings', 0); $stat = HTTP::_GP('stat', 0); $stat_level = HTTP::_GP('stat_level', 0); $config_after = array('stat_settings' => $stat_settings, 'stat' => $stat, 'stat_level' => $stat_level); foreach ($config_after as $key => $value) { $config->{$key} = $value; } $config->save(); $LOG = new Log(3); $LOG->target = 2; $LOG->old = $config_before; $LOG->new = $config_after; $LOG->save(); } $template = new template(); $template->assign_vars(array('stat_level' => $config->stat_level, 'stat' => $config->stat, 'stat_settings' => $config->stat_settings, 'cs_access_lvl' => $LNG['cs_access_lvl'], 'cs_points_to_zero' => $LNG['cs_points_to_zero'], 'cs_point_per_resources_used' => $LNG['cs_point_per_resources_used'], 'cs_title' => $LNG['cs_title'], 'cs_resources' => $LNG['cs_resources'], 'cs_save_changes' => $LNG['cs_save_changes'], 'Selector' => array(1 => $LNG['cs_yes'], 2 => $LNG['cs_no_view'], 0 => $LNG['cs_no']))); $template->show('StatsPage.tpl'); }
function ShowCreatorPage() { global $LNG, $USER; $template = new template(); switch ($_GET['mode']) { case 'user': $LNG->includeData(array('PUBLIC')); if ($_POST) { $UserName = HTTP::_GP('name', '', UTF8_SUPPORT); $UserPass = HTTP::_GP('password', ''); $UserPass2 = HTTP::_GP('password2', ''); $UserMail = HTTP::_GP('email', ''); $UserMail2 = HTTP::_GP('email2', ''); $UserAuth = HTTP::_GP('authlevel', 0); $Galaxy = HTTP::_GP('galaxy', 0); $System = HTTP::_GP('system', 0); $Planet = HTTP::_GP('planet', 0); $Language = HTTP::_GP('lang', ''); $ExistsUser = $GLOBALS['DATABASE']->getFirstCell("SELECT (SELECT COUNT(*) FROM " . USERS . " WHERE universe = " . Universe::getEmulated() . " AND username = '******'DATABASE']->sql_escape($UserName) . "') + (SELECT COUNT(*) FROM " . USERS_VALID . " WHERE universe = " . Universe::getEmulated() . " AND username = '******'DATABASE']->sql_escape($UserName) . "')"); $ExistsMails = $GLOBALS['DATABASE']->getFirstCell("SELECT (SELECT COUNT(*) FROM " . USERS . " WHERE universe = " . Universe::getEmulated() . " AND (email = '" . $GLOBALS['DATABASE']->sql_escape($UserMail) . "' OR email_2 = '" . $GLOBALS['DATABASE']->sql_escape($UserMail) . "')) + (SELECT COUNT(*) FROM " . USERS_VALID . " WHERE universe = " . Universe::getEmulated() . " AND email = '" . $GLOBALS['DATABASE']->sql_escape($UserMail) . "')"); $errors = ""; $config = Config::get(Universe::getEmulated()); if (!PlayerUtil::isMailValid($UserMail)) { $errors .= $LNG['invalid_mail_adress']; } if (empty($UserName)) { $errors .= $LNG['empty_user_field']; } if (strlen($UserPass) < 6) { $errors .= $LNG['password_lenght_error']; } if ($UserPass != $UserPass2) { $errors .= $LNG['different_passwords']; } if ($UserMail != $UserMail2) { $errors .= $LNG['different_mails']; } if (!PlayerUtil::isNameValid($UserName)) { $errors .= $LNG['user_field_specialchar']; } if ($ExistsUser != 0) { $errors .= $LNG['user_already_exists']; } if ($ExistsMails != 0) { $errors .= $LNG['mail_already_exists']; } if (!PlayerUtil::isPositionFree(Universe::getEmulated(), $Galaxy, $System, $Planet)) { $errors .= $LNG['planet_already_exists']; } if ($Galaxy > $config->max_galaxy || $System > $config->max_system || $Planet > $config->max_planets) { $errors .= $LNG['po_complete_all2']; } if (!empty($errors)) { $template->message($errors, '?page=create&mode=user', 10, true); exit; } $Language = array_key_exists($Language, $LNG->getAllowedLangs(false)) ? $Language : $config->lang; PlayerUtil::createPlayer(Universe::getEmulated(), $UserName, PlayerUtil::cryptPassword($UserPass), $UserMail, $Language, $Galaxy, $System, $Planet, $LNG['fcm_planet'], $UserAuth); $template->message($LNG['new_user_success'], '?page=create&mode=user', 5, true); exit; } $AUTH = array(); $AUTH[AUTH_USR] = $LNG['user_level'][AUTH_USR]; if ($USER['authlevel'] >= AUTH_OPS) { $AUTH[AUTH_OPS] = $LNG['user_level'][AUTH_OPS]; } if ($USER['authlevel'] >= AUTH_MOD) { $AUTH[AUTH_MOD] = $LNG['user_level'][AUTH_MOD]; } if ($USER['authlevel'] >= AUTH_ADM) { $AUTH[AUTH_ADM] = $LNG['user_level'][AUTH_ADM]; } $template->assign_vars(array('admin_auth' => $USER['authlevel'], 'new_add_user' => $LNG['new_add_user'], 'new_creator_refresh' => $LNG['new_creator_refresh'], 'new_creator_go_back' => $LNG['new_creator_go_back'], 'universe' => $LNG['mu_universe'], 'user_reg' => $LNG['user_reg'], 'pass_reg' => $LNG['pass_reg'], 'pass2_reg' => $LNG['pass2_reg'], 'email_reg' => $LNG['email_reg'], 'email2_reg' => $LNG['email2_reg'], 'new_coord' => $LNG['new_coord'], 'new_range' => $LNG['new_range'], 'lang_reg' => $LNG['lang_reg'], 'new_title' => $LNG['new_title'], 'Selector' => array('auth' => $AUTH, 'lang' => $LNG->getAllowedLangs(false)))); $template->show('CreatePageUser.tpl'); break; case 'moon': if ($_POST) { $PlanetID = HTTP::_GP('add_moon', 0); $MoonName = HTTP::_GP('name', '', UTF8_SUPPORT); $Diameter = HTTP::_GP('diameter', 0); $MoonPlanet = $GLOBALS['DATABASE']->getFirstRow("SELECT temp_max, temp_min, id_luna, galaxy, system, planet, planet_type, destruyed, id_owner FROM " . PLANETS . " WHERE id = '" . $PlanetID . "' AND universe = '" . Universe::getEmulated() . "' AND planet_type = '1' AND destruyed = '0';"); if (!isset($MoonPlanet)) { $template->message($LNG['mo_planet_doesnt_exist'], '?page=create&mode=moon', 3, true); exit; } $moonId = PlayerUtil::createMoon(Universe::getEmulated(), $MoonPlanet['galaxy'], $MoonPlanet['system'], $MoonPlanet['planet'], $MoonPlanet['id_owner'], 20, $_POST['diameter_check'] == 'on' ? NULL : $Diameter, $MoonName); if ($moonId !== false) { $template->message($LNG['mo_moon_added'], '?page=create&mode=moon', 3, true); } else { $template->message($LNG['mo_moon_unavaible'], '?page=create&mode=moon', 3, true); } exit; } $template->assign_vars(array('admin_auth' => $USER['authlevel'], 'universum' => $LNG['mu_universe'], 'po_add_moon' => $LNG['po_add_moon'], 'input_id_planet' => $LNG['input_id_planet'], 'mo_moon_name' => $LNG['mo_moon_name'], 'mo_diameter' => $LNG['mo_diameter'], 'mo_temperature' => $LNG['mo_temperature'], 'mo_fields_avaibles' => $LNG['mo_fields_avaibles'], 'button_add' => $LNG['button_add'], 'new_creator_refresh' => $LNG['new_creator_refresh'], 'mo_moon' => $LNG['fcm_moon'], 'new_creator_go_back' => $LNG['new_creator_go_back'])); $template->show('CreatePageMoon.tpl'); break; case 'planet': if ($_POST) { $id = HTTP::_GP('id', 0); $Galaxy = HTTP::_GP('galaxy', 0); $System = HTTP::_GP('system', 0); $Planet = HTTP::_GP('planet', 0); $name = HTTP::_GP('name', '', UTF8_SUPPORT); $field_max = HTTP::_GP('field_max', 0); $config = Config::get(Universe::getEmulated()); if ($Galaxy > $config->max_galaxy || $System > $config->max_system || $Planet > $config->max_planets) { $template->message($LNG['po_complete_all2'], '?page=create&mode=planet', 3, true); exit; } $ISUser = $GLOBALS['DATABASE']->getFirstRow("SELECT id, authlevel FROM " . USERS . " WHERE id = '" . $id . "' AND universe = '" . Universe::getEmulated() . "';"); if (!PlayerUtil::checkPosition(Universe::getEmulated(), $Galaxy, $System, $Planet) || !isset($ISUser)) { $template->message($LNG['po_complete_all'], '?page=create&mode=planet', 3, true); exit; } $planetId = PlayerUtil::createPlanet($Galaxy, $System, $Planet, Universe::getEmulated(), $id, NULL, false, $ISUser['authlevel']); $SQL = "UPDATE " . PLANETS . " SET "; if ($_POST['diameter_check'] != 'on' || $field_max > 0) { $SQL .= "field_max = '" . $field_max . "' "; } if (!empty($name)) { $SQL .= ", name = '" . $GLOBALS['DATABASE']->sql_escape($name) . "' "; } $SQL .= "WHERE "; $SQL .= "id = '" . $planetId . "'"; $GLOBALS['DATABASE']->query($SQL); $template->message($LNG['po_complete_succes'], '?page=create&mode=planet', 3, true); exit; } $template->assign_vars(array('admin_auth' => $USER['authlevel'], 'po_add_planet' => $LNG['po_add_planet'], 'po_galaxy' => $LNG['po_galaxy'], 'po_system' => $LNG['po_system'], 'po_planet' => $LNG['po_planet'], 'input_id_user' => $LNG['input_id_user'], 'new_creator_coor' => $LNG['new_creator_coor'], 'po_name_planet' => $LNG['po_name_planet'], 'po_fields_max' => $LNG['po_fields_max'], 'button_add' => $LNG['button_add'], 'po_colony' => $LNG['fcp_colony'], 'new_creator_refresh' => $LNG['new_creator_refresh'], 'new_creator_go_back' => $LNG['new_creator_go_back'])); $template->show('CreatePagePlanet.tpl'); break; default: $template->assign_vars(array('new_creator_title_u' => $LNG['new_creator_title_u'], 'new_creator_title_p' => $LNG['new_creator_title_p'], 'new_creator_title_l' => $LNG['new_creator_title_l'], 'new_creator_title' => $LNG['new_creator_title'])); $template->show('CreatePage.tpl'); break; } }
function ShowBanPage() { global $LNG, $USER; $ORDER = $_GET['order'] == 'id' ? "id" : "username"; if ($_GET['view'] == 'bana') { $WHEREBANA = "AND `bana` = '1'"; } $UserList = $GLOBALS['DATABASE']->query("SELECT `username`, `id`, `bana` FROM " . USERS . " WHERE `id` != 1 AND `authlevel` <= '" . $USER['authlevel'] . "' AND `universe` = '" . Universe::getEmulated() . "' " . $WHEREBANA . " ORDER BY " . $ORDER . " ASC;"); $UserSelect = array('List' => '', 'ListBan' => ''); $Users = 0; while ($a = $GLOBALS['DATABASE']->fetch_array($UserList)) { $UserSelect['List'] .= '<option value="' . $a['username'] . '">' . $a['username'] . ' (ID: ' . $a['id'] . ')' . ($a['bana'] == '1' ? $LNG['bo_characters_suus'] : '') . '</option>'; $Users++; } $GLOBALS['DATABASE']->free_result($UserList); $ORDER2 = $_GET['order2'] == 'id' ? "id" : "username"; $Banneds = 0; $UserListBan = $GLOBALS['DATABASE']->query("SELECT `username`, `id` FROM " . USERS . " WHERE `bana` = '1' AND `universe` = '" . Universe::getEmulated() . "' ORDER BY " . $ORDER2 . " ASC;"); while ($b = $GLOBALS['DATABASE']->fetch_array($UserListBan)) { $UserSelect['ListBan'] .= '<option value="' . $b['username'] . '">' . $b['username'] . ' (ID: ' . $b['id'] . ')</option>'; $Banneds++; } $GLOBALS['DATABASE']->free_result($UserListBan); $template = new template(); $template->loadscript('filterlist.js'); $Name = HTTP::_GP('ban_name', '', true); $BANUSER = $GLOBALS['DATABASE']->getFirstRow("SELECT b.theme, b.longer, u.id, u.urlaubs_modus, u.banaday FROM " . USERS . " as u LEFT JOIN " . BANNED . " as b ON u.`username` = b.`who` WHERE u.`username` = '" . $GLOBALS['DATABASE']->sql_escape($Name) . "' AND u.`universe` = '" . Universe::getEmulated() . "';"); if (isset($_POST['panel'])) { if ($BANUSER['banaday'] <= TIMESTAMP) { $title = $LNG['bo_bbb_title_1']; $changedate = $LNG['bo_bbb_title_2']; $changedate_advert = ''; $reas = ''; $timesus = ''; } else { $title = $LNG['bo_bbb_title_3']; $changedate = $LNG['bo_bbb_title_6']; $changedate_advert = '<td class="c" width="18px"><img src="./styles/resource/images/admin/i.gif" class="tooltip" data-tooltip-content="' . $LNG['bo_bbb_title_4'] . '"></td>'; $reas = $BANUSER['theme']; $timesus = "<tr>\n\t\t\t\t\t<th>" . $LNG['bo_bbb_title_5'] . "</th>\n\t\t\t\t\t<th height=25 colspan=2>" . date($LNG['php_tdformat'], $BANUSER['longer']) . "</th>\n\t\t\t\t</tr>"; } $vacation = $BANUSER['urlaubs_modus'] == 1 ? true : false; $template->assign_vars(array('name' => $Name, 'bantitle' => $title, 'changedate' => $changedate, 'reas' => $reas, 'changedate_advert' => $changedate_advert, 'timesus' => $timesus, 'vacation' => $vacation)); } elseif (isset($_POST['bannow']) && $BANUSER['id'] != 1) { $Name = HTTP::_GP('ban_name', '', true); $reas = HTTP::_GP('why', '', true); $days = HTTP::_GP('days', 0); $hour = HTTP::_GP('hour', 0); $mins = HTTP::_GP('mins', 0); $secs = HTTP::_GP('secs', 0); $admin = $USER['username']; $mail = $USER['email']; $BanTime = $days * 86400 + $hour * 3600 + $mins * 60 + $secs; if ($BANUSER['longer'] > TIMESTAMP) { $BanTime += $BANUSER['longer'] - TIMESTAMP; } if (isset($_POST['permanent'])) { $BannedUntil = 2147483647; } else { $BannedUntil = $BanTime + TIMESTAMP < TIMESTAMP ? TIMESTAMP : TIMESTAMP + $BanTime; } if ($BANUSER['banaday'] > TIMESTAMP) { $SQL = "UPDATE " . BANNED . " SET "; $SQL .= "`who` = '" . $Name . "', "; $SQL .= "`theme` = '" . $reas . "', "; $SQL .= "`time` = '" . TIMESTAMP . "', "; $SQL .= "`longer` = '" . $BannedUntil . "', "; $SQL .= "`author` = '" . $admin . "', "; $SQL .= "`email` = '" . $mail . "' "; $SQL .= "WHERE `who2` = '" . $Name . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); } else { $SQL = "INSERT INTO " . BANNED . " SET "; $SQL .= "`who` = '" . $Name . "', "; $SQL .= "`theme` = '" . $reas . "', "; $SQL .= "`time` = '" . TIMESTAMP . "', "; $SQL .= "`longer` = '" . $BannedUntil . "', "; $SQL .= "`author` = '" . $admin . "', "; $SQL .= "`universe` = '" . Universe::getEmulated() . "', "; $SQL .= "`email` = '" . $mail . "';"; $GLOBALS['DATABASE']->query($SQL); } $SQL = "UPDATE " . USERS . " SET "; $SQL .= "`bana` = '1', "; $SQL .= "`banaday` = '" . $BannedUntil . "', "; $SQL .= isset($_POST['vacat']) ? "`urlaubs_modus` = '1'" : "`urlaubs_modus` = '0'"; $SQL .= "WHERE "; $SQL .= "`username` = '" . $Name . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); $template->message($LNG['bo_the_player'] . $Name . $LNG['bo_banned'], '?page=bans'); exit; } elseif (isset($_POST['unban_name'])) { $Name = HTTP::_GP('unban_name', '', true); $GLOBALS['DATABASE']->query("UPDATE " . USERS . " SET bana = '0', banaday = '0' WHERE username = '******'DATABASE']->sql_escape($Name) . "' AND `universe` = '" . Universe::getEmulated() . "';"); #DELETE FROM ".BANNED." WHERE who = '".$GLOBALS['DATABASE']->sql_escape($Name)."' AND `universe` = '".Universe::getEmulated()."'; $template->message($LNG['bo_the_player2'] . $Name . $LNG['bo_unbanned'], '?page=bans'); exit; } $template->assign_vars(array('UserSelect' => $UserSelect, 'usercount' => $Users, 'bancount' => $Banneds)); $template->show('BanPage.tpl'); }
function ShowAccountDataPage() { global $USER, $reslist, $resource, $LNG; $template = new template(); $id_u = HTTP::_GP('id_u', 0); if (!empty($id_u)) { $OnlyQueryLogin = $GLOBALS['DATABASE']->getFirstRow("SELECT `id`, `authlevel` FROM " . USERS . " WHERE `id` = '" . $id_u . "' AND `universe` = '" . Universe::getEmulated() . "';"); if (!isset($OnlyQueryLogin)) { $template->message($LNG['ac_username_doesnt'], '?page=accoutdata'); } else { foreach (array_merge($reslist['officier'], $reslist['tech']) as $ID) { $SpecifyItemsUQ .= "u.`" . $resource[$ID] . "`,"; } // COMIENZA SAQUEO DE DATOS DE LA TABLA DE USUARIOS $SpecifyItemsU = "u.id,u.username,u.email,u.email_2,u.authlevel,u.id_planet,u.galaxy,u.system,u.planet,u.user_lastip,u.ip_at_reg,u.darkmatter,u.register_time,u.onlinetime,u.urlaubs_modus,u.\n\t\t\t urlaubs_until,u.ally_id,a.ally_name," . $SpecifyItemsUQ . "\n\t\t\t u.ally_register_time,u.ally_rank_id,u.bana,u.banaday"; $UserQuery = $GLOBALS['DATABASE']->getFirstRow("SELECT " . $SpecifyItemsU . " FROM " . USERS . " as u LEFT JOIN " . ALLIANCE . " a ON a.id = u.ally_id WHERE u.`id` = '" . $id_u . "';"); $reg_time = _date($LNG['php_tdformat'], $UserQuery['register_time'], $USER['timezone']); $onlinetime = _date($LNG['php_tdformat'], $UserQuery['onlinetime'], $USER['timezone']); $id = $UserQuery['id']; $nombre = $UserQuery['username']; $email_1 = $UserQuery['email']; $email_2 = $UserQuery['email_2']; $ip = $UserQuery['ip_at_reg']; $ip2 = $UserQuery['user_lastip']; $id_p = $UserQuery['id_planet']; $g = $UserQuery['galaxy']; $s = $UserQuery['system']; $p = $UserQuery['planet']; $info = $UserQuery['user_ua']; $alianza = $UserQuery['ally_name']; $nivel = $LNG['rank'][$UserQuery['authlevel']]; $vacas = $LNG['one_is_yes'][$UserQuery['urlaubs_modus']]; $suspen = $LNG['one_is_yes'][$UserQuery['bana']]; $mo = "<a title=\"" . pretty_number($UserQuery['darkmatter']) . "\">" . shortly_number($UserQuery['darkmatter']) . "</a>"; foreach ($reslist['officier'] as $ID) { $officier[] = $ID; } foreach ($reslist['tech'] as $ID) { $techno[] = $ID; } $techoffi = ""; for ($i = 0; $i < max(count($reslist['officier']), count($reslist['tech'])); $i++) { $techoffi .= isset($techno[$i]) ? "<tr><td>" . $LNG['tech'][$techno[$i]] . ": <font color=aqua>" . $UserQuery[$resource[$techno[$i]]] . "</font></td>" : "<tr><td> </td>"; $techoffi .= isset($officier[$i]) ? "<td>" . $LNG['tech'][$officier[$i]] . ": <font color=aqua>" . $UserQuery[$resource[$officier[$i]]] . "</font></td></tr>" : "<td> </td></tr>"; } if ($UserQuery['bana'] != 0) { $mas = '<a ref="#" onclick="$(\'#banned\').slideToggle();return false"> ' . $LNG['ac_more'] . '</a>'; $BannedQuery = $GLOBALS['DATABASE']->getFirstRow("SELECT theme,time,longer,author FROM " . BANNED . " WHERE `who` = '" . $UserQuery['username'] . "';"); $sus_longer = _date($LNG['php_tdformat'], $BannedQuery['longer'], $USER['timezone']); $sus_time = _date($LNG['php_tdformat'], $BannedQuery['time'], $USER['timezone']); $sus_reason = $BannedQuery['theme']; $sus_author = $BannedQuery['author']; } // COMIENZA EL SAQUEO DE DATOS DE LA TABLA DE PUNTAJE $SpecifyItemsS = "tech_count,defs_count,fleet_count,build_count,build_points,tech_points,defs_points,fleet_points,tech_rank,build_rank,defs_rank,fleet_rank,total_points,\n\t\t\tstat_type"; $StatQuery = $GLOBALS['DATABASE']->getFirstRow("SELECT " . $SpecifyItemsS . " FROM " . STATPOINTS . " WHERE `id_owner` = '" . $id_u . "' AND `stat_type` = '1';"); $count_tecno = pretty_number($StatQuery['tech_count']); $count_def = pretty_number($StatQuery['defs_count']); $count_fleet = pretty_number($StatQuery['fleet_count']); $count_builds = pretty_number($StatQuery['build_count']); $point_builds = pretty_number($StatQuery['build_points']); $point_tecno = pretty_number($StatQuery['tech_points']); $point_def = pretty_number($StatQuery['defs_points']); $point_fleet = pretty_number($StatQuery['fleet_points']); $ranking_tecno = $StatQuery['tech_rank']; $ranking_builds = $StatQuery['build_rank']; $ranking_def = $StatQuery['defs_rank']; $ranking_fleet = $StatQuery['fleet_rank']; $total_points = pretty_number($StatQuery['total_points']); // COMIENZA EL SAQUEO DE DATOS DE LA ALIANZA $AliID = $UserQuery['ally_id']; if ($alianza == 0 && $AliID == 0) { $alianza = $LNG['ac_no_ally']; $AllianceHave = "<span class=\"no_moon\"><img src=\"./styles/resource/images/admin/arrowright.png\" width=\"16\" height=\"10\"/> \n\t\t\t\t\t\t\t" . $LNG['ac_alliance'] . " " . $LNG['ac_no_alliance'] . "</span>"; } elseif ($alianza != NULL && $AliID != 0) { include_once 'includes/classes/BBCode.class.php'; $AllianceHave = '<a href="#" onclick="$(\'#alianza\').slideToggle();return false" class="link"> <img src="./styles/resource/images/admin/arrowright.png" width="16" height="10"> ' . $LNG['ac_alliance'] . '</a>'; $SpecifyItemsA = "ally_owner,id,ally_tag,ally_name,ally_web,ally_description,ally_text,ally_request,ally_image,ally_members,ally_register_time"; $AllianceQuery = $GLOBALS['DATABASE']->getFirstRow("SELECT " . $SpecifyItemsA . " FROM " . ALLIANCE . " WHERE `ally_name` = '" . $alianza . "';"); $alianza = $alianza; $id_ali = " (" . $LNG['ac_ali_idid'] . " " . $AliID . ")"; $id_aliz = $AllianceQuery['id']; $tag = $AllianceQuery['ally_tag']; $ali_nom = $AllianceQuery['ally_name']; $ali_cant = $AllianceQuery['ally_members']; $ally_register_time = _date($LNG['php_tdformat'], $AllianceQuery['ally_register_time'], $USER['timezone']); $ali_lider = $AllianceQuery['ally_owner']; $ali_web = $AllianceQuery['ally_web'] != NULL ? "<a href=" . $AllianceQuery['ally_web'] . " target=_blank>" . $AllianceQuery['ally_web'] . "</a>" : $LNG['ac_no_web']; if ($AllianceQuery['ally_description'] != NULL) { $ali_ext2 = BBCode::parse($AllianceQuery['ally_description']); $ali_ext = "<a href=\"#\" rel=\"toggle[externo]\">" . $LNG['ac_view_text_ext'] . "</a>"; } else { $ali_ext = $LNG['ac_no_text_ext']; } if ($AllianceQuery['ally_text'] != NULL) { $ali_int2 = BBCode::parse($AllianceQuery['ally_text']); $ali_int = "<a href=\"#\" rel=\"toggle[interno]\">" . $LNG['ac_view_text_int'] . "</a>"; } else { $ali_int = $LNG['ac_no_text_int']; } if ($AllianceQuery['ally_request'] != NULL) { $ali_sol2 = BBCode::parse($AllianceQuery['ally_request']); $ali_sol = "<a href=\"#\" rel=\"toggle[solicitud]\">" . $LNG['ac_view_text_sol'] . "</a>"; } else { $ali_sol = $LNG['ac_no_text_sol']; } if ($AllianceQuery['ally_image'] != NULL) { $ali_logo2 = $AllianceQuery['ally_image']; $ali_logo = "<a href=\"#\" rel=\"toggle[imagen]\">" . $LNG['ac_view_image2'] . "</a>"; } else { $ali_logo = $LNG['ac_no_img']; } $SearchLeader = $GLOBALS['DATABASE']->getFirstRow("SELECT `username` FROM " . USERS . " WHERE `id` = '" . $ali_lider . "';"); $ali_lider = $SearchLeader['username']; $StatQueryAlly = $GLOBALS['DATABASE']->getFirstRow("SELECT " . $SpecifyItemsS . " FROM " . STATPOINTS . " WHERE `id_owner` = '" . $ali_lider . "' AND `stat_type` = '2';"); $count_tecno_ali = pretty_number($StatQueryAlly['tech_count']); $count_def_ali = pretty_number($StatQueryAlly['defs_count']); $count_fleet_ali = pretty_number($StatQueryAlly['fleet_count']); $count_builds_ali = pretty_number($StatQueryAlly['build_count']); $point_builds_ali = pretty_number($StatQueryAlly['build_points']); $point_tecno_ali = pretty_number($StatQueryAlly['tech_points']); $point_def_ali = pretty_number($StatQueryAlly['defs_points']); $point_fleet_ali = pretty_number($StatQueryAlly['fleet_points']); $ranking_tecno_ali = pretty_number($StatQueryAlly['tech_rank']); $ranking_builds_ali = pretty_number($StatQueryAlly['build_rank']); $ranking_def_ali = pretty_number($StatQueryAlly['defs_rank']); $ranking_fleet_ali = pretty_number($StatQueryAlly['fleet_rank']); $total_points_ali = pretty_number($StatQueryAlly['total_points']); } foreach (array_merge($reslist['fleet'], $reslist['build'], $reslist['defense']) as $ID) { $SpecifyItemsPQ .= "`" . $resource[$ID] . "`,"; $RES[$resource[$ID]] = "<tr><td width=\"150\">" . $LNG['tech'][$ID] . "</td>"; } $names = "<tr><th class=\"center\" width=\"150\"> </th>"; // COMIENZA EL SAQUEO DE DATOS DE LOS PLANETAS $SpecifyItemsP = "planet_type,id,name,galaxy,system,planet,destruyed,diameter,field_current,field_max,temp_min,temp_max,metal,crystal,deuterium,energy," . $SpecifyItemsPQ . "energy_used"; $PlanetsQuery = $GLOBALS['DATABASE']->query("SELECT " . $SpecifyItemsP . " FROM " . PLANETS . " WHERE `id_owner` = '" . $id_u . "';"); while ($PlanetsWhile = $GLOBALS['DATABASE']->fetch_array($PlanetsQuery)) { if ($PlanetsWhile['planet_type'] == 3) { $Planettt = $PlanetsWhile['name'] . " (" . $LNG['ac_moon'] . ")<br><font color=aqua>[" . $PlanetsWhile['galaxy'] . ":" . $PlanetsWhile['system'] . ":" . $PlanetsWhile['planet'] . "]</font>"; $MoonZ = 0; $Moons = $PlanetsWhile['name'] . " (" . $LNG['ac_moon'] . ")<br><font color=aqua>[" . $PlanetsWhile['galaxy'] . ":" . $PlanetsWhile['system'] . ":" . $PlanetsWhile['planet'] . "]</font>"; $MoonZ++; } else { $Planettt = $PlanetsWhile['name'] . "<br><font color=aqua>[" . $PlanetsWhile['galaxy'] . ":" . $PlanetsWhile['system'] . ":" . $PlanetsWhile['planet'] . "]</font>"; } if ($PlanetsWhile["destruyed"] == 0) { $planets_moons .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $Planettt . "</td>\n\t\t\t\t\t\t<td>" . $PlanetsWhile['id'] . "</td>\n\t\t\t\t\t\t<td>" . pretty_number($PlanetsWhile['diameter']) . "</td>\n\t\t\t\t\t\t<td>" . pretty_number($PlanetsWhile['field_current']) . " / " . pretty_number(CalculateMaxPlanetFields($PlanetsWhile)) . " (" . pretty_number($PlanetsWhile['field_current']) . " / " . pretty_number($PlanetsWhile['field_max']) . ")</td>\n\t\t\t\t\t\t<td>" . pretty_number($PlanetsWhile['temp_min']) . " / " . pretty_number($PlanetsWhile['temp_max']) . "</td>" . (allowedTo('ShowQuickEditorPage') ? "<td><a href=\"javascript:openEdit('" . $PlanetsWhile['id'] . "', 'planet');\" border=\"0\"><img src=\"./styles/resource/images/admin/GO.png\" title=" . $LNG['se_search_edit'] . "></a></td>" : "") . "</tr>"; $SumOfEnergy = $PlanetsWhile['energy'] + $PlanetsWhile['energy_used']; if ($SumOfEnergy < 0) { $Color = "<font color=#FF6600>" . shortly_number($SumOfEnergy) . "</font>"; } elseif ($SumOfEnergy > 0) { $Color = "<font color=lime>" . shortly_number($SumOfEnergy) . "</font>"; } else { $Color = shortly_number($SumOfEnergy); } $resources .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $Planettt . "</td>\n\t\t\t\t\t\t<td><a title=\"" . pretty_number($PlanetsWhile['metal']) . "\">" . shortly_number($PlanetsWhile['metal']) . "</a></td>\n\t\t\t\t\t\t<td><a title=\"" . pretty_number($PlanetsWhile['crystal']) . "\">" . shortly_number($PlanetsWhile['crystal']) . "</a></td>\n\t\t\t\t\t\t<td><a title=\"" . pretty_number($PlanetsWhile['deuterium']) . "\">" . shortly_number($PlanetsWhile['deuterium']) . "</a></td>\n\t\t\t\t\t\t<td><a title=\"" . pretty_number($SumOfEnergy) . "\">" . $Color . "</a>/<a title=\"" . pretty_number($PlanetsWhile['energy']) . "\">" . shortly_number($PlanetsWhile['energy']) . "</a></td>\n\t\t\t\t\t</tr>"; $names .= "<th class=\"center\" width=\"60\">" . $Planettt . "</th>"; foreach (array_merge($reslist['fleet'], $reslist['build'], $reslist['defense']) as $ID) { $RES[$resource[$ID]] .= "<td width=\"60\"><a title=\"" . pretty_number($PlanetsWhile[$resource[$ID]]) . "\">" . shortly_number($PlanetsWhile[$resource[$ID]]) . "</a></td>"; } $MoonHave = $MoonZ != 0 ? '<a href="#" onclick="$(\'#especiales\').slideToggle();return false" class="link"><img src="./styles/resource/images/admin/arrowright.png" width="16" height="10"/> ' . $LNG['moon_build'] . "</a>" : "<span class=\"no_moon\"><img src=\"./styles/resource/images/admin/arrowright.png\" width=\"16\" height=\"10\"/>" . $LNG['moon_build'] . " " . $LNG['ac_moons_no'] . "</span>"; } $DestruyeD = 0; if ($PlanetsWhile["destruyed"] > 0) { $destroyed .= "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td>" . $PlanetsWhile['name'] . "</td>\n\t\t\t\t\t\t\t<td>" . $PlanetsWhile['id'] . "</td>\n\t\t\t\t\t\t\t<td>[" . $PlanetsWhile['galaxy'] . ":" . $PlanetsWhile['system'] . ":" . $PlanetsWhile['planet'] . "]</td>\n\t\t\t\t\t\t\t<td>" . date("d-m-Y H:i:s", $PlanetsWhile['destruyed']) . "</td>\n\t\t\t\t\t\t</tr>"; $DestruyeD++; } } $names .= "</tr>"; foreach (array_merge($reslist['fleet'], $reslist['build'], $reslist['defense']) as $ID) { $RES[$resource[$ID]] .= "</tr>"; } foreach ($reslist['build'] as $ID) { $build .= $RES[$resource[$ID]]; } foreach ($reslist['fleet'] as $ID) { $fleet .= $RES[$resource[$ID]]; } foreach ($reslist['defense'] as $ID) { $defense .= $RES[$resource[$ID]]; } $template->assign_vars(array('DestruyeD' => $DestruyeD, 'destroyed' => $destroyed, 'resources' => $resources, 'mo' => $mo, 'names' => $names, 'build' => $build, 'fleet' => $fleet, 'defense' => $defense, 'planets_moons' => $planets_moons, 'ali_lider' => $ali_lider, 'AllianceHave' => $AllianceHave, 'point_tecno' => $point_tecno, 'count_tecno' => $count_tecno, 'ranking_tecno' => $ranking_tecno, 'defenses_title' => $defenses_title, 'point_def' => $point_def, 'count_def' => $count_def, 'ranking_def' => $ranking_def, 'point_fleet' => $point_fleet, 'count_fleet' => $count_fleet, 'ranking_fleet' => $ranking_fleet, 'point_builds' => $point_builds, 'count_builds' => $count_builds, 'ranking_builds' => $ranking_builds, 'total_points' => $total_points, 'point_tecno_ali' => $point_tecno_ali, 'count_tecno_ali' => $count_tecno_ali, 'ranking_tecno_ali' => $ranking_tecno_ali, 'point_def_ali' => $point_def_ali, 'count_def_ali' => $count_def_ali, 'ranking_def_ali' => $ranking_def_ali, 'point_fleet_ali' => $point_fleet_ali, 'count_fleet_ali' => $count_fleet_ali, 'ranking_fleet_ali' => $ranking_fleet_ali, 'point_builds_ali' => $point_builds_ali, 'count_builds_ali' => $count_builds_ali, 'ranking_builds_ali' => $ranking_builds_ali, 'total_points_ali' => $total_points_ali, 'input_id' => $input_id, 'id_aliz' => $id_aliz, 'tag' => $tag, 'ali_nom' => $ali_nom, 'ali_ext' => $ali_ext, 'ali_ext' => $ali_ext2, 'ali_int' => $ali_int, 'ali_int' => $ali_int2, 'ali_sol2' => $ali_sol2, 'ali_sol' => $ali_sol, 'ali_logo' => $ali_logo, 'ali_logo2' => $ali_logo2, 'ali_web' => $ali_web, 'ally_register_time' => $ally_register_time, 'ali_cant' => $ali_cant, 'alianza' => $alianza, 'input_id' => $input_id, 'id' => $id, 'nombre' => $nombre, 'nivel' => $nivel, 'vacas' => $vacas, 'suspen' => $suspen, 'mas' => $mas, 'id_ali' => $id_ali, 'ip' => $ip, 'ip2' => $ip2, 'ipcheck' => true, 'reg_time' => $reg_time, 'onlinetime' => $onlinetime, 'id_p' => $id_p, 'g' => $g, 's' => $s, 'p' => $p, 'info' => $info, 'email_1' => $email_1, 'email_2' => $email_2, 'sus_time' => $sus_time, 'sus_longer' => $sus_longer, 'sus_reason' => $sus_reason, 'sus_author' => $sus_author, 'techoffi' => $techoffi, 'canedit' => allowedTo('ShowQuickEditorPage'), 'buildings_title' => $LNG['buildings_title'], 'buildings_title' => $LNG['buildings_title'], 'researchs_title ' => $LNG['researchs_title'], 'ships_title' => $LNG['ships_title'], 'defenses_title' => $LNG['defenses_title'], 'ac_recent_destroyed_planets' => $LNG['ac_recent_destroyed_planets'], 'ac_isnodestruyed' => $LNG['ac_isnodestruyed'], 'ac_note_k' => $LNG['ac_note_k'], 'ac_leyend' => $LNG['ac_leyend'], 'ac_account_data' => $LNG['ac_account_data'], 'ac_name' => $LNG['ac_name'], 'ac_mail' => $LNG['ac_mail'], 'ac_perm_mail' => $LNG['ac_perm_mail'], 'ac_auth_level' => $LNG['ac_auth_level'], 'ac_on_vacation' => $LNG['ac_on_vacation'], 'ac_banned' => $LNG['ac_banned'], 'ac_alliance' => $LNG['ac_alliance'], 'ac_reg_ip' => $LNG['ac_reg_ip'], 'ac_last_ip' => $LNG['ac_last_ip'], 'ac_checkip_title' => $LNG['ac_checkip_title'], 'ac_register_time' => $LNG['ac_register_time'], 'ac_act_time' => $LNG['ac_act_time'], 'ac_home_planet_id' => $LNG['ac_home_planet_id'], 'ac_home_planet_coord' => $LNG['ac_home_planet_coord'], 'ac_user_system' => $LNG['ac_user_system'], 'ac_ranking' => $LNG['ac_ranking'], 'ac_see_ranking' => $LNG['ac_see_ranking'], 'ac_user_ranking' => $LNG['ac_user_ranking'], 'ac_points_count' => $LNG['ac_points_count'], 'ac_ranking' => $LNG['ac_ranking'], 'ac_total_points' => $LNG['ac_total_points'], 'ac_suspended_title' => $LNG['ac_suspended_title'], 'ac_suspended_time' => $LNG['ac_suspended_time'], 'ac_suspended_longer' => $LNG['ac_suspended_longer'], 'ac_suspended_reason' => $LNG['ac_suspended_reason'], 'ac_suspended_autor' => $LNG['ac_suspended_autor'], 'ac_info_ally' => $LNG['ac_info_ally'], 'ac_leader' => $LNG['ac_leader'], 'ac_tag' => $LNG['ac_tag'], 'ac_name_ali' => $LNG['ac_name_ali'], 'ac_ext_text ' => $LNG['ac_ext_text'], 'ac_int_text' => $LNG['ac_int_text'], 'ac_sol_text' => $LNG['ac_sol_text'], 'ac_image' => $LNG['ac_image'], 'ac_ally_web' => $LNG['ac_ally_web'], 'ac_total_members' => $LNG['ac_total_members'], 'ac_ranking' => $LNG['ac_ranking'], 'ac_see_ranking' => $LNG['ac_see_ranking'], 'ac_view_image' => $LNG['ac_view_image'], 'ac_urlnow' => $LNG['ac_urlnow'], 'ac_ally_ranking' => $LNG['ac_ally_ranking'], 'ac_points_count' => $LNG['ac_points_count'], 'ac_ranking' => $LNG['ac_ranking'], 'ac_total_points' => $LNG['ac_total_points'], 'ac_id_names_coords' => $LNG['ac_id_names_coords'], 'ac_name' => $LNG['ac_name'], 'ac_diameter' => $LNG['ac_diameter'], 'ac_fields' => $LNG['ac_fields'], 'ac_temperature' => $LNG['ac_temperature'], 'se_search_edit' => $LNG['se_search_edit'], 'resources_title' => $LNG['resources_title'], 'ac_name' => $LNG['ac_name'], 'Metal' => $LNG['tech'][901], 'Crystal' => $LNG['tech'][902], 'Deuterium' => $LNG['tech'][903], 'Energy' => $LNG['tech'][911], 'Darkmatter' => $LNG['tech'][921], 'buildings_title' => $LNG['buildings_title'], 'ships_title' => $LNG['ships_title'], 'defenses_title' => $LNG['defenses_title'], 'ac_officier_research' => $LNG['ac_officier_research'], 'researchs_title' => $LNG['researchs_title'], 'officiers_title' => $LNG['officiers_title'], 'ac_name' => $LNG['ac_name'], 'input_id' => $LNG['input_id'], 'ac_coords' => $LNG['ac_coords'], 'ac_time_destruyed' => $LNG['ac_time_destruyed'])); $template->show('AccountDataPageDetail.tpl'); } exit; } $Userlist = ""; $UserWhileLogin = $GLOBALS['DATABASE']->query("SELECT `id`, `username`, `authlevel` FROM " . USERS . " WHERE `authlevel` <= '" . $USER['authlevel'] . "' AND `universe` = '" . Universe::getEmulated() . "' ORDER BY `username` ASC;"); while ($UserList = $GLOBALS['DATABASE']->fetch_array($UserWhileLogin)) { $Userlist .= "<option value=\"" . $UserList['id'] . "\">" . $UserList['username'] . " (" . $LNG['rank'][$UserList['authlevel']] . ")</option>"; } $template->loadscript('filterlist.js'); $template->assign_vars(array('Userlist' => $Userlist, 'ac_enter_user_id' => $LNG['ac_enter_user_id'], 'bo_select_title' => $LNG['bo_select_title'], 'button_filter' => $LNG['button_filter'], 'button_deselect' => $LNG['button_deselect'], 'ac_select_id_num' => $LNG['ac_select_id_num'], 'button_submit' => $LNG['button_submit'])); $template->show('AccountDataPageIntro.tpl'); }
function ShowRightsPage() { global $LNG, $USER; $mode = HTTP::_GP('mode', ''); switch ($mode) { case 'rights': $template = new template(); $template->loadscript('filterlist.js'); if ($_POST) { $id = HTTP::_GP('id_1', 0); if ($USER['id'] != ROOT_USER && $id == ROOT_USER) { $template->message($LNG['ad_authlevel_error_3'], '?page=rights&mode=rights&sid=' . session_id()); exit; } if (!isset($_POST['rights'])) { $_POST['rights'] = array(); } if ($_POST['action'] == 'send') { $GLOBALS['DATABASE']->query("UPDATE " . USERS . " SET `rights` = '" . serialize(array_map('intval', $_POST['rights'])) . "' WHERE `id` = '" . $id . "';"); } $Rights = $GLOBALS['DATABASE']->getFirstRow("SELECT rights FROM " . USERS . " WHERE `id` = '" . $id . "';"); if (($Rights['rights'] = unserialize($Rights['rights'])) === false) { $Rights['rights'] = array(); } $Files = array_map('prepare', array_diff(scandir('includes/pages/adm/'), array('.', '..', '.svn', 'index.html', '.htaccess', 'ShowIndexPage.php', 'ShowOverviewPage.php', 'ShowMenuPage.php', 'ShowTopnavPage.php'))); $template->assign_vars(array('Files' => $Files, 'Rights' => $Rights['rights'], 'id' => $id, 'yesorno' => $LNG['one_is_yes'], 'ad_authlevel_title' => $LNG['ad_authlevel_title'], 'button_submit' => $LNG['button_submit'], 'sid' => session_id())); $template->show('ModerrationRightsPostPage.tpl'); exit; } if ($_GET['get'] == 'adm') { $WHEREUSERS = "AND `authlevel` = '" . AUTH_ADM . "'"; } elseif ($_GET['get'] == 'ope') { $WHEREUSERS = "AND `authlevel` = '" . AUTH_OPS . "'"; } elseif ($_GET['get'] == 'mod') { $WHEREUSERS = "AND `authlevel` = '" . AUTH_MOD . "'"; } elseif ($_GET['get'] == 'pla') { $WHEREUSERS = "AND `authlevel` = '" . AUTH_USR . "'"; } $QueryUsers = $GLOBALS['DATABASE']->query("SELECT `id`, `username`, `authlevel` FROM " . USERS . " WHERE `universe` = '" . Universe::getEmulated() . "'" . $WHEREUSERS . ";"); $UserList = ""; while ($List = $GLOBALS['DATABASE']->fetch_array($QueryUsers)) { $UserList .= '<option value="' . $List['id'] . '">' . $List['username'] . ' (' . $LNG['rank'][$List['authlevel']] . ')</option>'; } $template->assign_vars(array('Selector' => array(0 => $LNG['rank'][0], 1 => $LNG['rank'][1], 2 => $LNG['rank'][2], 3 => $LNG['rank'][3]), 'UserList' => $UserList, 'ad_authlevel_title' => $LNG['ad_authlevel_title'], 'bo_select_title' => $LNG['bo_select_title'], 'button_submit' => $LNG['button_submit'], 'button_deselect' => $LNG['button_deselect'], 'button_filter' => $LNG['button_filter'], 'ad_authlevel_insert_id' => $LNG['ad_authlevel_insert_id'], 'ad_authlevel_auth' => $LNG['ad_authlevel_auth'], 'ad_authlevel_aa' => $LNG['ad_authlevel_aa'], 'ad_authlevel_oo' => $LNG['ad_authlevel_oo'], 'ad_authlevel_mm' => $LNG['ad_authlevel_mm'], 'ad_authlevel_jj' => $LNG['ad_authlevel_jj'], 'ad_authlevel_tt' => $LNG['ad_authlevel_tt'], 'sid' => session_id())); $template->show('ModerrationRightsPage.tpl'); break; case 'users': $template = new template(); $template->loadscript('filterlist.js'); if ($_POST) { $id = HTTP::_GP('id_1', 0); $authlevel = HTTP::_GP('authlevel', 0); if ($id == 0) { $id = HTTP::_GP('id_2', 0); } if ($USER['id'] != ROOT_USER && $id == ROOT_USER) { $template->message($LNG['ad_authlevel_error_3'], '?page=rights&mode=users&sid=' . session_id()); exit; } $GLOBALS['DATABASE']->multi_query("UPDATE " . USERS . " SET `authlevel` = '" . HTTP::_GP('authlevel', 0) . "' WHERE `id` = '" . $id . "';"); $template->message($LNG['ad_authlevel_succes'], '?page=rights&mode=users&sid=' . session_id()); exit; } if ($_GET['get'] == 'adm') { $WHEREUSERS = "AND `authlevel` = '" . AUTH_ADM . "'"; } elseif ($_GET['get'] == 'ope') { $WHEREUSERS = "AND `authlevel` = '" . AUTH_OPS . "'"; } elseif ($_GET['get'] == 'mod') { $WHEREUSERS = "AND `authlevel` = '" . AUTH_MOD . "'"; } elseif ($_GET['get'] == 'pla') { $WHEREUSERS = "AND `authlevel` = '" . AUTH_USR . "'"; } $QueryUsers = $GLOBALS['DATABASE']->query("SELECT `id`, `username`, `authlevel` FROM " . USERS . " WHERE `universe` = '" . Universe::getEmulated() . "'" . $WHEREUSERS . ";"); $UserList = ""; while ($List = $GLOBALS['DATABASE']->fetch_array($QueryUsers)) { $UserList .= '<option value="' . $List['id'] . '">' . $List['username'] . ' (' . $LNG['rank'][$List['authlevel']] . ')</option>'; } $template->assign_vars(array('Selector' => array(0 => $LNG['rank'][0], 1 => $LNG['rank'][1], 2 => $LNG['rank'][2], 3 => $LNG['rank'][3]), 'UserList' => $UserList, 'ad_authlevel_title' => $LNG['ad_authlevel_title'], 'bo_select_title' => $LNG['bo_select_title'], 'button_submit' => $LNG['button_submit'], 'button_deselect' => $LNG['button_deselect'], 'button_filter' => $LNG['button_filter'], 'ad_authlevel_insert_id' => $LNG['ad_authlevel_insert_id'], 'ad_authlevel_auth' => $LNG['ad_authlevel_auth'], 'ad_authlevel_aa' => $LNG['ad_authlevel_aa'], 'ad_authlevel_oo' => $LNG['ad_authlevel_oo'], 'ad_authlevel_mm' => $LNG['ad_authlevel_mm'], 'ad_authlevel_jj' => $LNG['ad_authlevel_jj'], 'ad_authlevel_tt' => $LNG['ad_authlevel_tt'], 'sid' => session_id())); $template->show('ModerrationUsersPage.tpl'); break; } }
function ShowQuickEditorPage() { global $USER, $LNG, $reslist, $resource; $action = HTTP::_GP('action', ''); $edit = HTTP::_GP('edit', ''); $id = HTTP::_GP('id', 0); switch ($edit) { case 'planet': $DataIDs = array_merge($reslist['fleet'], $reslist['build'], $reslist['defense']); $SpecifyItemsPQ = ""; foreach ($DataIDs as $ID) { $SpecifyItemsPQ .= "`" . $resource[$ID] . "`,"; } $PlanetData = $GLOBALS['DATABASE']->getFirstRow("SELECT " . $SpecifyItemsPQ . " `name`, `id_owner`, `planet_type`, `galaxy`, `system`, `planet`, `destruyed`, `diameter`, `field_current`, `field_max`, `temp_min`, `temp_max`, `metal`, `crystal`, `deuterium` FROM " . PLANETS . " WHERE `id` = '" . $id . "';"); if ($action == 'send') { $SQL = "UPDATE " . PLANETS . " SET "; $Fields = $PlanetData['field_current']; foreach ($DataIDs as $ID) { $level = min(max(0, round(HTTP::_GP($resource[$ID], 0.0))), in_array($ID, $reslist['build']) ? 255 : 1.8446744073709552E+19); if (in_array($ID, $reslist['allow'][$PlanetData['planet_type']])) { $Fields += $level - $PlanetData[$resource[$ID]]; } $SQL .= "`" . $resource[$ID] . "` = " . $level . ", "; } $SQL .= "`metal` = " . max(0, round(HTTP::_GP('metal', 0.0))) . ", "; $SQL .= "`crystal` = " . max(0, round(HTTP::_GP('crystal', 0.0))) . ", "; $SQL .= "`deuterium` = " . max(0, round(HTTP::_GP('deuterium', 0.0))) . ", "; $SQL .= "`field_current` = '" . $Fields . "', "; $SQL .= "`field_max` = '" . HTTP::_GP('field_max', 0) . "', "; $SQL .= "`name` = '" . $GLOBALS['DATABASE']->sql_escape(HTTP::_GP('name', '', UTF8_SUPPORT)) . "', "; $SQL .= "`eco_hash` = '' "; $SQL .= "WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); $old = array(); $new = array(); foreach (array_merge($DataIDs, $reslist['resstype'][1]) as $IDs) { $old[$IDs] = $PlanetData[$resource[$IDs]]; $new[$IDs] = max(0, round(HTTP::_GP($resource[$IDs], 0.0))); } $old['field_max'] = $PlanetData['field_max']; $new['field_max'] = HTTP::_GP('field_max', 0); $LOG = new Log(2); $LOG->target = $id; $LOG->old = $old; $LOG->new = $new; $LOG->save(); exit(sprintf($LNG['qe_edit_planet_sucess'], $PlanetData['name'], $PlanetData['galaxy'], $PlanetData['system'], $PlanetData['planet'])); } $UserInfo = $GLOBALS['DATABASE']->getFirstRow("SELECT `username` FROM " . USERS . " WHERE `id` = '" . $PlanetData['id_owner'] . "' AND `universe` = '" . Universe::getEmulated() . "';"); $build = $defense = $fleet = array(); foreach ($reslist['allow'][$PlanetData['planet_type']] as $ID) { $build[] = array('type' => $resource[$ID], 'name' => $LNG['tech'][$ID], 'count' => pretty_number($PlanetData[$resource[$ID]]), 'input' => $PlanetData[$resource[$ID]]); } foreach ($reslist['fleet'] as $ID) { $fleet[] = array('type' => $resource[$ID], 'name' => $LNG['tech'][$ID], 'count' => pretty_number($PlanetData[$resource[$ID]]), 'input' => $PlanetData[$resource[$ID]]); } foreach ($reslist['defense'] as $ID) { $defense[] = array('type' => $resource[$ID], 'name' => $LNG['tech'][$ID], 'count' => pretty_number($PlanetData[$resource[$ID]]), 'input' => $PlanetData[$resource[$ID]]); } $template = new template(); $template->assign_vars(array('build' => $build, 'fleet' => $fleet, 'defense' => $defense, 'id' => $id, 'ownerid' => $PlanetData['id_owner'], 'ownername' => $UserInfo['username'], 'name' => $PlanetData['name'], 'galaxy' => $PlanetData['galaxy'], 'system' => $PlanetData['system'], 'planet' => $PlanetData['planet'], 'field_min' => $PlanetData['field_current'], 'field_max' => $PlanetData['field_max'], 'temp_min' => $PlanetData['temp_min'], 'temp_max' => $PlanetData['temp_max'], 'metal' => floatToString($PlanetData['metal']), 'crystal' => floatToString($PlanetData['crystal']), 'deuterium' => floatToString($PlanetData['deuterium']), 'metal_c' => pretty_number($PlanetData['metal']), 'crystal_c' => pretty_number($PlanetData['crystal']), 'deuterium_c' => pretty_number($PlanetData['deuterium']))); $template->show('QuickEditorPlanet.tpl'); break; case 'player': $DataIDs = array_merge($reslist['tech'], $reslist['officier']); $SpecifyItemsPQ = ""; foreach ($DataIDs as $ID) { $SpecifyItemsPQ .= "`" . $resource[$ID] . "`,"; } $UserData = $GLOBALS['DATABASE']->getFirstRow("SELECT " . $SpecifyItemsPQ . " `username`, `authlevel`, `galaxy`, `system`, `planet`, `id_planet`, `darkmatter`, `authattack`, `authlevel` FROM " . USERS . " WHERE `id` = '" . $id . "';"); $ChangePW = $USER['id'] == ROOT_USER || $id != ROOT_USER && $USER['authlevel'] > $UserData['authlevel']; if ($action == 'send') { $SQL = "UPDATE " . USERS . " SET "; foreach ($DataIDs as $ID) { $SQL .= "`" . $resource[$ID] . "` = " . min(abs(HTTP::_GP($resource[$ID], 0)), 255) . ", "; } $SQL .= "`darkmatter` = '" . max(HTTP::_GP('darkmatter', 0), 0) . "', "; if (!empty($_POST['password']) && $ChangePW) { $SQL .= "`password` = '" . PlayerUtil::cryptPassword(HTTP::_GP('password', '', true)) . "', "; } $SQL .= "`username` = '" . $GLOBALS['DATABASE']->sql_escape(HTTP::_GP('name', '', UTF8_SUPPORT)) . "', "; $SQL .= "`authattack` = '" . ($UserData['authlevel'] != AUTH_USR && HTTP::_GP('authattack', '') == 'on' ? $UserData['authlevel'] : 0) . "' "; $SQL .= "WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); $old = array(); $new = array(); $multi = HTTP::_GP('multi', 0); foreach ($DataIDs as $IDs) { $old[$IDs] = $UserData[$resource[$IDs]]; $new[$IDs] = abs(HTTP::_GP($resource[$IDs], 0)); } $old[921] = $UserData[$resource[921]]; $new[921] = abs(HTTP::_GP($resource[921], 0)); $old['username'] = $UserData['username']; $new['username'] = $GLOBALS['DATABASE']->sql_escape(HTTP::_GP('name', '', UTF8_SUPPORT)); $old['authattack'] = $UserData['authattack']; $new['authattack'] = $UserData['authlevel'] != AUTH_USR && HTTP::_GP('authattack', '') == 'on' ? $UserData['authlevel'] : 0; $old['multi'] = $GLOBALS['DATABASE']->getFirstCell("SELECT COUNT(*) FROM " . MULTI . " WHERE userID = " . $id . ";"); $new['authattack'] = $multi; if ($old['multi'] != $multi) { if ($multi == 0) { $GLOBALS['DATABASE']->query("DELETE FROM " . MULTI . " WHERE userID = " . (int) $id . ";"); } elseif ($multi == 1) { $GLOBALS['DATABASE']->query("INSERT INTO " . MULTI . " SET userID = " . (int) $id . ";"); } } $LOG = new Log(1); $LOG->target = $id; $LOG->old = $old; $LOG->new = $new; $LOG->save(); exit(sprintf($LNG['qe_edit_player_sucess'], $UserData['username'], $id)); } $PlanetInfo = $GLOBALS['DATABASE']->getFirstRow("SELECT `name` FROM " . PLANETS . " WHERE `id` = '" . $UserData['id_planet'] . "' AND `universe` = '" . Universe::getEmulated() . "';"); $tech = array(); $officier = array(); foreach ($reslist['tech'] as $ID) { $tech[] = array('type' => $resource[$ID], 'name' => $LNG['tech'][$ID], 'count' => pretty_number($UserData[$resource[$ID]]), 'input' => $UserData[$resource[$ID]]); } foreach ($reslist['officier'] as $ID) { $officier[] = array('type' => $resource[$ID], 'name' => $LNG['tech'][$ID], 'count' => pretty_number($UserData[$resource[$ID]]), 'input' => $UserData[$resource[$ID]]); } $template = new template(); $template->assign_vars(array('tech' => $tech, 'officier' => $officier, 'id' => $id, 'planetid' => $UserData['id_planet'], 'planetname' => $PlanetInfo['name'], 'name' => $UserData['username'], 'galaxy' => $UserData['galaxy'], 'system' => $UserData['system'], 'planet' => $UserData['planet'], 'authlevel' => $UserData['authlevel'], 'authattack' => $UserData['authattack'], 'multi' => $GLOBALS['DATABASE']->getFirstCell("SELECT COUNT(*) FROM " . MULTI . " WHERE userID = " . $id . ";"), 'ChangePW' => $ChangePW, 'darkmatter' => floatToString($UserData['darkmatter']), 'darkmatter_c' => pretty_number($UserData['darkmatter']))); $template->show('QuickEditorUser.tpl'); break; } }
function ShowAccountEditorPage() { global $LNG, $reslist, $resource; $template = new template(); switch ($_GET['edit']) { case 'resources': $id = HTTP::_GP('id', 0); $id_dark = HTTP::_GP('id_dark', 0); $metal = max(0, round(HTTP::_GP('metal', 0.0))); $cristal = max(0, round(HTTP::_GP('cristal', 0.0))); $deut = max(0, round(HTTP::_GP('deut', 0.0))); $dark = HTTP::_GP('dark', 0); if ($_POST) { if (!empty($id)) { $before = $GLOBALS['DATABASE']->getFirstRow("SELECT `metal`,`crystal`,`deuterium`,`universe` FROM " . PLANETS . " WHERE `id` = '" . $id . "';"); } if (!empty($id_dark)) { $before_dm = $GLOBALS['DATABASE']->getFirstRow("SELECT `darkmatter` FROM " . USERS . " WHERE `id` = '" . $id_dark . "';"); } if ($_POST['add']) { if (!empty($id)) { $SQL = "UPDATE " . PLANETS . " SET "; $SQL .= "`metal` = `metal` + '" . $metal . "', "; $SQL .= "`crystal` = `crystal` + '" . $cristal . "', "; $SQL .= "`deuterium` = `deuterium` + '" . $deut . "' "; $SQL .= "WHERE "; $SQL .= "`id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); $after = array('metal' => $before['metal'] + $metal, 'crystal' => $before['crystal'] + $cristal, 'deuterium' => $before['deuterium'] + $deut); } if (!empty($id_dark)) { $SQL = "UPDATE " . USERS . " SET "; $SQL .= "`darkmatter` = `darkmatter` + '" . $dark . "' "; $SQL .= "WHERE "; $SQL .= "`id` = '" . $id_dark . "' AND `universe` = '" . Universe::getEmulated() . "' "; $GLOBALS['DATABASE']->query($SQL); $after_dm = array('darkmatter' => $before_dm['darkmatter'] + $dark); } } elseif ($_POST['delete']) { if (!empty($id)) { $SQL = "UPDATE " . PLANETS . " SET "; $SQL .= "`metal` = `metal` - '" . $metal . "', "; $SQL .= "`crystal` = `crystal` - '" . $cristal . "', "; $SQL .= "`deuterium` = `deuterium` - '" . $deut . "' "; $SQL .= "WHERE "; $SQL .= "`id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); $after = array('metal' => $before['metal'] - $metal, 'crystal' => $before['crystal'] - $cristal, 'deuterium' => $before['deuterium'] - $deut); } if (!empty($id_dark)) { $SQL = "UPDATE " . USERS . " SET "; $SQL .= "`darkmatter` = `darkmatter` - '" . $dark . "' "; $SQL .= "WHERE "; $SQL .= "`id` = '" . $id_dark . "';"; $GLOBALS['DATABASE']->query($SQL); $after_dm = array('darkmatter' => $before_dm['darkmatter'] - $dark); } } if (!empty($id)) { $LOG = new Log(2); $LOG->target = $id; $LOG->universe = $before_dm['universe']; $LOG->old = $before; $LOG->new = $after; $LOG->save(); } if (!empty($id_dark)) { $LOG = new Log(1); $LOG->target = $id_dark; $LOG->universe = $before_dm['universe']; $LOG->old = $before_dm; $LOG->new = $after_dm; $LOG->save(); } if ($_POST['add']) { $template->message($LNG['ad_add_res_sucess'], '?page=accounteditor&edit=resources'); } else { if ($_POST['delete']) { $template->message($LNG['ad_delete_res_sucess'], '?page=accounteditor&edit=resources'); } } exit; } $template->show('AccountEditorPageResources.tpl'); break; case 'ships': if ($_POST) { $before1 = $GLOBALS['DATABASE']->getFirstRow("SELECT * FROM " . PLANETS . " WHERE `id` = '" . HTTP::_GP('id', 0) . "';"); $before = array(); $after = array(); foreach ($reslist['fleet'] as $ID) { $before[$ID] = $before1[$resource[$ID]]; } if ($_POST['add']) { $SQL = "UPDATE " . PLANETS . " SET "; $SQL .= "`eco_hash` = '', "; foreach ($reslist['fleet'] as $ID) { $QryUpdate[] = "`" . $resource[$ID] . "` = `" . $resource[$ID] . "` + '" . max(0, round(HTTP::_GP($resource[$ID], 0.0))) . "'"; $after[$ID] = $before[$ID] + max(0, round(HTTP::_GP($resource[$ID], 0.0))); } $SQL .= implode(", ", $QryUpdate); $SQL .= "WHERE "; $SQL .= "`id` = '" . HTTP::_GP('id', 0) . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); } elseif ($_POST['delete']) { $SQL = "UPDATE " . PLANETS . " SET "; $SQL .= "`eco_hash` = '', "; foreach ($reslist['fleet'] as $ID) { $QryUpdate[] = "`" . $resource[$ID] . "` = `" . $resource[$ID] . "` - '" . max(0, round(HTTP::_GP($resource[$ID], 0.0))) . "'"; $after[$ID] = max($before[$ID] - max(0, round(HTTP::_GP($resource[$ID], 0.0))), 0); } $SQL .= implode(", ", $QryUpdate); $SQL .= "WHERE "; $SQL .= "`id` = '" . HTTP::_GP('id', 0) . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); } $LOG = new Log(2); $LOG->target = HTTP::_GP('id', 0); $LOG->universe = $before1['universe']; $LOG->old = $before; $LOG->new = $after; $LOG->save(); if ($_POST['add']) { $template->message($LNG['ad_add_ships_sucess'], '?page=accounteditor&edit=ships'); } else { if ($_POST['delete']) { $template->message($LNG['ad_delete_ships_sucess'], '?page=accounteditor&edit=ships'); } } exit; } $parse['ships'] = ""; foreach ($reslist['fleet'] as $ID) { $INPUT[$ID] = array('type' => $resource[$ID]); } $template->assign_vars(array('inputlist' => $INPUT)); $template->show('AccountEditorPageShips.tpl'); break; case 'defenses': if ($_POST) { $before1 = $GLOBALS['DATABASE']->getFirstRow("SELECT * FROM " . PLANETS . " WHERE `id` = '" . HTTP::_GP('id', 0) . "';"); $before = array(); $after = array(); foreach ($reslist['defense'] as $ID) { $before[$ID] = $before1[$resource[$ID]]; } if ($_POST['add']) { $SQL = "UPDATE " . PLANETS . " SET "; foreach ($reslist['defense'] as $ID) { $QryUpdate[] = "`" . $resource[$ID] . "` = `" . $resource[$ID] . "` + '" . max(0, round(HTTP::_GP($resource[$ID], 0.0))) . "'"; $after[$ID] = $before[$ID] + max(0, round(HTTP::_GP($resource[$ID], 0.0))); } $SQL .= implode(", ", $QryUpdate); $SQL .= "WHERE "; $SQL .= "`id` = '" . HTTP::_GP('id', 0) . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); } elseif ($_POST['delete']) { $SQL = "UPDATE " . PLANETS . " SET "; foreach ($reslist['defense'] as $ID) { $QryUpdate[] = "`" . $resource[$ID] . "` = `" . $resource[$ID] . "` - '" . max(0, round(HTTP::_GP($resource[$ID], 0.0))) . "'"; $after[$ID] = max($before[$ID] - max(0, round(HTTP::_GP($resource[$ID], 0.0))), 0); } $SQL .= implode(", ", $QryUpdate); $SQL .= "WHERE "; $SQL .= "`id` = '" . HTTP::_GP('id', 0) . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); $Name = $LNG['log_nomoree']; } $LOG = new Log(2); $LOG->target = HTTP::_GP('id', 0); $LOG->universe = $before1['universe']; $LOG->old = $before; $LOG->new = $after; $LOG->save(); if ($_POST['add']) { $template->message($LNG['ad_add_defenses_success'], '?page=accounteditor&edit=defenses'); } else { if ($_POST['delete']) { $template->message($LNG['ad_delete_defenses_success'], '?page=accounteditor&edit=defenses'); } } exit; } foreach ($reslist['defense'] as $ID) { $INPUT[$ID] = array('type' => $resource[$ID]); } $template->assign_vars(array('inputlist' => $INPUT)); $template->show('AccountEditorPageDefenses.tpl'); break; break; case 'buildings': if ($_POST) { $PlanetData = $GLOBALS['DATABASE']->getFirstRow("SELECT * FROM " . PLANETS . " WHERE `id` = '" . HTTP::_GP('id', 0) . "';"); if (!isset($PlanetData)) { $template->message($LNG['ad_add_not_exist'], '?page=accounteditor&edit=buildings'); } $before = array(); $after = array(); foreach ($reslist['allow'][$PlanetData['planet_type']] as $ID) { $before[$ID] = $PlanetData[$resource[$ID]]; } if ($_POST['add']) { $Fields = 0; $SQL = "UPDATE " . PLANETS . " SET "; $SQL .= "`eco_hash` = '', "; foreach ($reslist['allow'][$PlanetData['planet_type']] as $ID) { $Count = max(0, round(HTTP::_GP($resource[$ID], 0.0))); $QryUpdate[] = "`" . $resource[$ID] . "` = `" . $resource[$ID] . "` + '" . $Count . "'"; $after[$ID] = $before[$ID] + $Count; $Fields += $Count; } $SQL .= implode(", ", $QryUpdate); $SQL .= ", `field_current` = `field_current` + '" . $Fields . "'"; $SQL .= "WHERE "; $SQL .= "`id` = '" . HTTP::_GP('id', 0) . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); } elseif ($_POST['delete']) { $Fields = 0; $QryUpdate = array(); $SQL = "UPDATE " . PLANETS . " SET "; $SQL .= "`eco_hash` = '', "; foreach ($reslist['allow'][$PlanetData['planet_type']] as $ID) { $Count = max(0, round(HTTP::_GP($resource[$ID], 0.0))); $QryUpdate[] = "`" . $resource[$ID] . "` = `" . $resource[$ID] . "` - '" . $Count . "'"; $after[$ID] = max($before[$ID] - $Count, 0); $Fields += $Count; } $SQL .= implode(", ", $QryUpdate); $SQL .= ", `field_current` = `field_current` - '" . $Fields . "'"; $SQL .= "WHERE "; $SQL .= "`id` = '" . HTTP::_GP('id', 0) . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); } $LOG = new Log(2); $LOG->target = HTTP::_GP('id', 0); $LOG->universe = Universe::getEmulated(); $LOG->old = $before; $LOG->new = $after; $LOG->save(); if ($_POST['add']) { $template->message($LNG['ad_add_build_success'], '?page=accounteditor&edit=buildings'); } else { if ($_POST['delete']) { $template->message($LNG['ad_delete_build_success'], '?page=accounteditor&edit=buildings'); } } exit; } foreach ($reslist['build'] as $ID) { $INPUT[$ID] = array('type' => $resource[$ID]); } $template->assign_vars(array('inputlist' => $INPUT)); $template->show('AccountEditorPageBuilds.tpl'); break; case 'researchs': if ($_POST) { $before1 = $GLOBALS['DATABASE']->getFirstRow("SELECT * FROM " . USERS . " WHERE `id` = '" . HTTP::_GP('id', 0) . "';"); $before = array(); $after = array(); foreach ($reslist['tech'] as $ID) { $before[$ID] = $before1[$resource[$ID]]; } if ($_POST['add']) { $SQL = "UPDATE " . USERS . " SET "; foreach ($reslist['tech'] as $ID) { $QryUpdate[] = "`" . $resource[$ID] . "` = `" . $resource[$ID] . "` + '" . max(0, round(HTTP::_GP($resource[$ID], 0.0))) . "'"; $after[$ID] = $before[$ID] + max(0, round(HTTP::_GP($resource[$ID], 0.0))); } $SQL .= implode(", ", $QryUpdate); $SQL .= "WHERE "; $SQL .= "`id` = '" . HTTP::_GP('id', 0) . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); } elseif ($_POST['delete']) { $SQL = "UPDATE " . USERS . " SET "; foreach ($reslist['tech'] as $ID) { $QryUpdate[] = "`" . $resource[$ID] . "` = `" . $resource[$ID] . "` - '" . max(0, round(HTTP::_GP($resource[$ID], 0.0))) . "'"; $after[$ID] = max($before[$ID] - max(0, round(HTTP::_GP($resource[$ID], 0.0))), 0); } $SQL .= implode(", ", $QryUpdate); $SQL .= "WHERE "; $SQL .= "`id` = '" . HTTP::_GP('id', 0) . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); } $LOG = new Log(1); $LOG->target = HTTP::_GP('id', 0); $LOG->universe = $before1['universe']; $LOG->old = $before; $LOG->new = $after; $LOG->save(); if ($_POST['add']) { $template->message($LNG['ad_add_tech_success'], '?page=accounteditor&edit=researchs'); } else { if ($_POST['delete']) { $template->message($LNG['ad_delete_tech_success'], '?page=accounteditor&edit=researchs'); } } exit; } foreach ($reslist['tech'] as $ID) { $INPUT[$ID] = array('type' => $resource[$ID]); } $template->assign_vars(array('inputlist' => $INPUT)); $template->show('AccountEditorPageResearch.tpl'); break; case 'personal': if ($_POST) { $id = HTTP::_GP('id', 0); $username = HTTP::_GP('username', '', UTF8_SUPPORT); $password = HTTP::_GP('password', '', true); $email = HTTP::_GP('email', ''); $email_2 = HTTP::_GP('email_2', ''); $vacation = HTTP::_GP('vacation', ''); $before = $GLOBALS['DATABASE']->getFirstRow("SELECT `username`,`email`,`email_2`,`password`,`urlaubs_modus`,`urlaubs_until` FROM " . USERS . " WHERE `id` = '" . HTTP::_GP('id', 0) . "';"); $after = array(); $PersonalQuery = "UPDATE " . USERS . " SET "; if (!empty($username) && $id != ROOT_USER) { $PersonalQuery .= "`username` = '" . $GLOBALS['DATABASE']->sql_escape($username) . "', "; $after['username'] = $username; } if (!empty($email) && $id != ROOT_USER) { $PersonalQuery .= "`email` = '" . $GLOBALS['DATABASE']->sql_escape($email) . "', "; $after['email'] = $email; } if (!empty($email_2) && $id != ROOT_USER) { $PersonalQuery .= "`email_2` = '" . $GLOBALS['DATABASE']->sql_escape($email_2) . "', "; $after['email_2'] = $email_2; } if (!empty($password) && $id != ROOT_USER) { $PersonalQuery .= "`password` = '" . $GLOBALS['DATABASE']->sql_escape(cryptPassword($password)) . "', "; $after['password'] = cryptPassword($password) != $before['password'] ? 'CHANGED' : ''; } $before['password'] = ''; $Answer = 0; $TimeAns = 0; if ($vacation == 'yes') { $Answer = 1; $after['urlaubs_modus'] = 1; $TimeAns = TIMESTAMP + $_POST['d'] * 86400 + $_POST['h'] * 3600 + $_POST['m'] * 60 + $_POST['s']; $after['urlaubs_until'] = $TimeAns; } $PersonalQuery .= "`urlaubs_modus` = '" . $Answer . "', `urlaubs_until` = '" . $TimeAns . "' "; $PersonalQuery .= "WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "'"; $GLOBALS['DATABASE']->query($PersonalQuery); $LOG = new Log(1); $LOG->target = $id; $LOG->universe = $before['universe']; $LOG->old = $before; $LOG->new = $after; $LOG->save(); $template->message($LNG['ad_personal_succes'], '?page=accounteditor&edit=personal'); exit; } $template->assign_vars(array('Selector' => array('' => $LNG['select_option'], 'yes' => $LNG['one_is_yes'][1], 'no' => $LNG['one_is_yes'][0]))); $template->show('AccountEditorPagePersonal.tpl'); break; case 'officiers': if ($_POST) { $before1 = $GLOBALS['DATABASE']->getFirstRow("SELECT * FROM " . USERS . " WHERE `id` = '" . HTTP::_GP('id', 0) . "';"); $before = array(); $after = array(); foreach ($reslist['officier'] as $ID) { $before[$ID] = $before1[$resource[$ID]]; } if ($_POST['add']) { $SQL = "UPDATE " . USERS . " SET "; foreach ($reslist['officier'] as $ID) { $QryUpdate[] = "`" . $resource[$ID] . "` = `" . $resource[$ID] . "` + '" . max(0, round(HTTP::_GP($resource[$ID], 0.0))) . "'"; $after[$ID] = $before[$ID] + max(0, round(HTTP::_GP($resource[$ID], 0.0))); } $SQL .= implode(", ", $QryUpdate); $SQL .= "WHERE "; $SQL .= "`id` = '" . HTTP::_GP('id', 0) . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); } elseif ($_POST['delete']) { $SQL = "UPDATE " . USERS . " SET "; foreach ($reslist['officier'] as $ID) { $QryUpdate[] = "`" . $resource[$ID] . "` = `" . $resource[$ID] . "` - '" . max(0, round(HTTP::_GP($resource[$ID], 0.0))) . "'"; $after[$ID] = max($before[$ID] - max(0, round(HTTP::_GP($resource[$ID], 0.0))), 0); } $SQL .= implode(", ", $QryUpdate); $SQL .= "WHERE "; $SQL .= "`id` = '" . HTTP::_GP('id', 0) . "' AND `universe` = '" . Universe::getEmulated() . "';"; $GLOBALS['DATABASE']->query($SQL); } $LOG = new Log(1); $LOG->target = HTTP::_GP('id', 0); $LOG->universe = $before1['universe']; $LOG->old = $before; $LOG->new = $after; $LOG->save(); if ($_POST['add']) { $template->message($LNG['ad_add_offi_success'], '?page=accounteditor&edit=officiers'); } else { if ($_POST['delete']) { $template->message($LNG['ad_delete_offi_success'], '?page=accounteditor&edit=officiers'); } } exit; } foreach ($reslist['officier'] as $ID) { $INPUT[$ID] = array('type' => $resource[$ID]); } $template->assign_vars(array('inputlist' => $INPUT)); $template->show('AccountEditorPageOfficiers.tpl'); break; case 'planets': if ($_POST) { $id = HTTP::_GP('id', 0); $name = HTTP::_GP('name', '', UTF8_SUPPORT); $diameter = HTTP::_GP('diameter', 0); $fields = HTTP::_GP('fields', 0); $buildings = HTTP::_GP('0_buildings', ''); $ships = HTTP::_GP('0_ships', ''); $defenses = HTTP::_GP('0_defenses', ''); $c_hangar = HTTP::_GP('0_c_hangar', ''); $c_buildings = HTTP::_GP('0_c_buildings', ''); $change_pos = HTTP::_GP('change_position', ''); $galaxy = HTTP::_GP('g', 0); $system = HTTP::_GP('s', 0); $planet = HTTP::_GP('p', 0); if (!empty($name)) { $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET `name` = '" . $GLOBALS['DATABASE']->sql_escape($name) . "' WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"); } if ($buildings == 'on') { foreach ($reslist['build'] as $ID) { $BUILD[] = "`" . $resource[$ID] . "` = '0'"; } $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET " . implode(', ', $BUILD) . " WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"); } if ($ships == 'on') { foreach ($reslist['fleet'] as $ID) { $SHIPS[] = "`" . $resource[$ID] . "` = '0'"; } $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET " . implode(', ', $SHIPS) . " WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"); } if ($defenses == 'on') { foreach ($reslist['defense'] as $ID) { $DEFS[] = "`" . $resource[$ID] . "` = '0'"; } $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET " . implode(', ', $DEFS) . " WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"); } if ($c_hangar == 'on') { $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET `b_hangar` = '0', `b_hangar_plus` = '0', `b_hangar_id` = '' WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"); } if ($c_buildings == 'on') { $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET `b_building` = '0', `b_building_id` = '' WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"); } if (!empty($diameter)) { $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET `diameter` = '" . $diameter . "' WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"); } if (!empty($fields)) { $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET `field_max` = '" . $fields . "' WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"); } if ($change_pos == 'on' && $galaxy > 0 && $system > 0 && $planet > 0 && $galaxy <= Config::get(Universe::getEmulated())->max_galaxy && $system <= Config::get(Universe::getEmulated())->max_system && $planet <= Config::get(Universe::getEmulated())->max_planets) { $P = $GLOBALS['DATABASE']->getFirstRow("SELECT galaxy,system,planet,planet_type FROM " . PLANETS . " WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"); if ($P['planet_type'] == '1') { if (PlayerUtil::checkPosition(Universe::getEmulated(), $galaxy, $system, $planet, $P['planet_type'])) { $template->message($LNG['ad_pla_error_planets3'], '?page=accounteditor&edit=planets'); exit; } $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET `galaxy` = '" . $galaxy . "', `system` = '" . $system . "', `planet` = '" . $planet . "' WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"); } else { if (PlayerUtil::checkPosition(Universe::getEmulated(), $galaxy, $system, $planet, $P['planet_type'])) { $template->message($LNG['ad_pla_error_planets5'], '?page=accounteditor&edit=planets'); exit; } $Target = $GLOBALS['DATABASE']->getFirstRow("SELECT id_luna FROM " . PLANETS . " WHERE `galaxy` = '" . $galaxy . "' AND `system` = '" . $system . "' AND `planet` = '" . $planet . "' AND `planet_type` = '1';"); if ($Target['id_luna'] != '0') { $template->message($LNG['ad_pla_error_planets4'], '?page=accounteditor&edit=planets'); exit; } $GLOBALS['DATABASE']->multi_query("UPDATE " . PLANETS . " SET `id_luna` = '0' WHERE `galaxy` = '" . $P['galaxy'] . "' AND `system` = '" . $P['system'] . "' AND `planet` = '" . $P['planet'] . "' AND `planet_type` = '1';UPDATE " . PLANETS . " SET `id_luna` = '" . $id . "' WHERE `galaxy` = '" . $galaxy . "' AND `system` = '" . $system . "' AND `planet` = '" . $planet . "' AND planet_type = '1';UPDATE " . PLANETS . " SET `galaxy` = '" . $galaxy . "', `system` = '" . $system . "', `planet` = '" . $planet . "' WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "';"); $QMOON2 = $GLOBALS['DATABASE']->getFirstRow("SELECT id_owner FROM " . PLANETS . " WHERE `galaxy` = '" . $galaxy . "' AND `system` = '" . $system . "' AND `planet` = '" . $planet . "';"); $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET `galaxy` = '" . $galaxy . "', `system` = '" . $system . "', `planet` = '" . $planet . "', `id_owner` = '" . $QMOON2['id_owner'] . "' WHERE `id` = '" . $id . "' AND `universe` = '" . Universe::getEmulated() . "' AND `planet_type` = '3';"); } } $template->message($LNG['ad_pla_succes'], '?page=accounteditor&edit=planets'); exit; } $template->show('AccountEditorPagePlanets.tpl'); break; case 'alliances': if ($_POST) { $id = HTTP::_GP('id', 0); $name = HTTP::_GP('name', '', UTF8_SUPPORT); $changeleader = HTTP::_GP('changeleader', 0); $tag = HTTP::_GP('tag', '', UTF8_SUPPORT); $externo = HTTP::_GP('externo', '', true); $interno = HTTP::_GP('interno', '', true); $solicitud = HTTP::_GP('solicitud', '', true); $delete = HTTP::_GP('delete', ''); $delete_u = HTTP::_GP('delete_u', ''); $QueryF = $GLOBALS['DATABASE']->getFirstRow("SELECT * FROM " . ALLIANCE . " WHERE `id` = '" . $id . "' AND `ally_universe` = '" . Universe::getEmulated() . "';"); if (!empty($name)) { $GLOBALS['DATABASE']->query("UPDATE " . ALLIANCE . " SET `ally_name` = '" . $name . "' WHERE `id` = '" . $id . "' AND `ally_universe` = '" . Universe::getEmulated() . "';"); } if (!empty($tag)) { $GLOBALS['DATABASE']->query("UPDATE " . ALLIANCE . " SET `ally_tag` = '" . $tag . "' WHERE `id` = '" . $id . "' AND `ally_universe` = '" . Universe::getEmulated() . "';"); } $QueryF2 = $GLOBALS['DATABASE']->getFirstRow("SELECT ally_id FROM " . USERS . " WHERE `id` = '" . $changeleader . "';"); $GLOBALS['DATABASE']->multi_query("UPDATE " . ALLIANCE . " SET `ally_owner` = '" . $changeleader . "' WHERE `id` = '" . $id . "' AND `ally_universe` = '" . Universe::getEmulated() . "';UPDATE " . USERS . " SET `ally_rank_id` = '0' WHERE `id` = '" . $changeleader . "';"); if (!empty($externo)) { $GLOBALS['DATABASE']->query("UPDATE " . ALLIANCE . " SET `ally_description` = '" . $externo . "' WHERE `id` = '" . $id . "' AND `ally_universe` = '" . Universe::getEmulated() . "';"); } if (!empty($interno)) { $GLOBALS['DATABASE']->query("UPDATE " . ALLIANCE . " SET `ally_text` = '" . $interno . "' WHERE `id` = '" . $id . "' AND `ally_universe` = '" . Universe::getEmulated() . "';"); } if (!empty($solicitud)) { $GLOBALS['DATABASE']->query("UPDATE " . ALLIANCE . " SET `ally_request` = '" . $solicitud . "' WHERE `id` = '" . $id . "' AND `ally_universe` = '" . Universe::getEmulated() . "';"); } if ($delete == 'on') { $GLOBALS['DATABASE']->multi_query("DELETE FROM " . ALLIANCE . " WHERE `id` = '" . $id . "' AND `ally_universe` = '" . Universe::getEmulated() . "';UPDATE " . USERS . " SET `ally_id` = '0', `ally_rank_id` = '0', `ally_register_time` = '0' WHERE `ally_id` = '" . $id . "';"); } if (!empty($delete_u)) { $GLOBALS['DATABASE']->multi_query("UPDATE " . ALLIANCE . " SET `ally_members` = ally_members - 1 WHERE `id` = '" . $id . "' AND `ally_universe` = '" . Universe::getEmulated() . "';UPDATE " . USERS . " SET `ally_id` = '0', `ally_rank_id` = '0', `ally_register_time` = '0' WHERE `id` = '" . $delete_u . "' AND `ally_id` = '" . $id . "';"); } $template->message($LNG['ad_ally_succes'], '?page=accounteditor&edit=alliances'); exit; } $template->show('AccountEditorPageAlliance.tpl'); break; default: $template->show('AccountEditorPageMenu.tpl'); break; } }
function ShowConfigUniPage() { global $LNG; $config = Config::get(Universe::getEmulated()); if (!empty($_POST)) { $config_before = array('noobprotectiontime' => $config->noobprotectiontime, 'noobprotectionmulti' => $config->noobprotectionmulti, 'noobprotection' => $config->noobprotection, 'Defs_Cdr' => $config->Defs_Cdr, 'Fleet_Cdr' => $config->Fleet_Cdr, 'game_disable' => $config->game_disable, 'close_reason' => $config->close_reason, 'OverviewNewsFrame' => $config->OverviewNewsFrame, 'reg_closed' => $config->reg_closed, 'OverviewNewsText' => $config->OverviewNewsText, 'uni_name' => $config->uni_name, 'forum_url' => $config->forum_url, 'game_speed' => $config->game_speed, 'fleet_speed' => $config->fleet_speed, 'resource_multiplier' => $config->resource_multiplier, 'halt_speed' => $config->halt_speed, 'energySpeed' => $config->energySpeed, 'initial_fields' => $config->initial_fields, 'metal_basic_income' => $config->metal_basic_income, 'crystal_basic_income' => $config->crystal_basic_income, 'deuterium_basic_income' => $config->deuterium_basic_income, 'debug' => $config->debug, 'adm_attack' => $config->adm_attack, 'lang' => $config->lang, 'min_build_time' => $config->min_build_time, 'user_valid' => $config->user_valid, 'trade_charge' => $config->trade_charge, 'trade_allowed_ships' => $config->trade_allowed_ships, 'game_name' => $config->game_name, 'capaktiv' => $config->capaktiv, 'capprivate' => $config->capprivate, 'cappublic' => $config->cappublic, 'max_galaxy' => $config->max_galaxy, 'max_system' => $config->max_system, 'max_planets' => $config->max_planets, 'min_player_planets' => $config->min_player_planets, 'planets_tech' => $config->planets_tech, 'planets_officier' => $config->planets_officier, 'planets_per_tech' => $config->planets_per_tech, 'planet_factor' => $config->planet_factor, 'max_elements_build' => $config->max_elements_build, 'max_elements_tech' => $config->max_elements_tech, 'max_elements_ships' => $config->max_elements_ships, 'max_overflow' => $config->max_overflow, 'moon_factor' => $config->moon_factor, 'moon_chance' => $config->moon_chance, 'darkmatter_cost_trader' => $config->darkmatter_cost_trader, 'factor_university' => $config->factor_university, 'max_fleets_per_acs' => $config->max_fleets_per_acs, 'vmode_min_time' => $config->vmode_min_time, 'gate_wait_time' => $config->gate_wait_time, 'metal_start' => $config->metal_start, 'crystal_start' => $config->crystal_start, 'deuterium_start' => $config->deuterium_start, 'darkmatter_start' => $config->darkmatter_start, 'debris_moon' => $config->debris_moon, 'deuterium_cost_galaxy' => $config->deuterium_cost_galaxy, 'ref_active' => $config->ref_active, 'ref_bonus' => $config->ref_bonus, 'ref_minpoints' => $config->ref_minpoints, 'ref_max_referals' => $config->ref_max_referals, 'silo_factor' => $config->silo_factor, 'max_dm_missions' => $config->max_dm_missions, 'alliance_create_min_points' => $config->alliance_create_min_points, 'max_fleet_per_build' => $config->max_fleet_per_build); $game_disable = isset($_POST['closed']) && $_POST['closed'] == 'on' ? 1 : 0; $noobprotection = isset($_POST['noobprotection']) && $_POST['noobprotection'] == 'on' ? 1 : 0; $debug = isset($_POST['debug']) && $_POST['debug'] == 'on' ? 1 : 0; $adm_attack = isset($_POST['adm_attack']) && $_POST['adm_attack'] == 'on' ? 1 : 0; $OverviewNewsFrame = isset($_POST['newsframe']) && $_POST['newsframe'] == 'on' ? 1 : 0; $reg_closed = isset($_POST['reg_closed']) && $_POST['reg_closed'] == 'on' ? 1 : 0; $user_valid = isset($_POST['user_valid']) && $_POST['user_valid'] == 'on' ? 1 : 0; $debris_moon = isset($_POST['debris_moon']) && $_POST['debris_moon'] == 'on' ? 1 : 0; $ref_active = isset($_POST['ref_active']) && $_POST['ref_active'] == 'on' ? 1 : 0; $OverviewNewsText = $_POST['NewsText']; $close_reason = HTTP::_GP('close_reason', '', true); $uni_name = HTTP::_GP('uni_name', '', true); $forum_url = HTTP::_GP('forum_url', '', true); $game_speed = 2500 * HTTP::_GP('game_speed', 0.0); $fleet_speed = 2500 * HTTP::_GP('fleet_speed', 0.0); $resource_multiplier = HTTP::_GP('resource_multiplier', 0.0); $halt_speed = HTTP::_GP('halt_speed', 0.0); $energySpeed = HTTP::_GP('energySpeed', 0.0); $initial_fields = HTTP::_GP('initial_fields', 0); $metal_basic_income = HTTP::_GP('metal_basic_income', 0); $crystal_basic_income = HTTP::_GP('crystal_basic_income', 0); $deuterium_basic_income = HTTP::_GP('deuterium_basic_income', 0); $lang = HTTP::_GP('lang', ''); $Defs_Cdr = HTTP::_GP('Defs_Cdr', 0); $Fleet_Cdr = HTTP::_GP('Fleet_Cdr', 0); $noobprotectiontime = HTTP::_GP('noobprotectiontime', 0); $noobprotectionmulti = HTTP::_GP('noobprotectionmulti', 0); $min_build_time = HTTP::_GP('min_build_time', 0); $trade_allowed_ships = HTTP::_GP('trade_allowed_ships', ''); $trade_charge = HTTP::_GP('trade_charge', 0.0); $max_galaxy = HTTP::_GP('max_galaxy', 0); $max_system = HTTP::_GP('max_system', 0); $max_planets = HTTP::_GP('max_planets', 0); $min_player_planets = HTTP::_GP('min_player_planets', 0); $planets_tech = HTTP::_GP('planets_tech', 0); $planets_officier = HTTP::_GP('planets_officier', 0); $planets_per_tech = HTTP::_GP('planets_per_tech', 0.0); $planet_factor = HTTP::_GP('planet_factor', 0.0); $max_elements_build = HTTP::_GP('max_elements_build', 0); $max_elements_tech = HTTP::_GP('max_elements_tech', 0); $max_elements_ships = HTTP::_GP('max_elements_ships', 0); $max_overflow = HTTP::_GP('max_overflow', 0); $moon_factor = HTTP::_GP('moon_factor', 0.0); $moon_chance = HTTP::_GP('moon_chance', 0); $darkmatter_cost_trader = HTTP::_GP('darkmatter_cost_trader', 0); $factor_university = HTTP::_GP('factor_university', 0); $max_fleets_per_acs = HTTP::_GP('max_fleets_per_acs', 0); $vmode_min_time = HTTP::_GP('vmode_min_time', 0); $gate_wait_time = HTTP::_GP('gate_wait_time', 0); $metal_start = HTTP::_GP('metal_start', 0); $crystal_start = HTTP::_GP('crystal_start', 0); $deuterium_start = HTTP::_GP('deuterium_start', 0); $darkmatter_start = HTTP::_GP('darkmatter_start', 0); $deuterium_cost_galaxy = HTTP::_GP('deuterium_cost_galaxy', 0); $max_fleet_per_build = max(0, round(HTTP::_GP('max_fleet_per_build', 0.0))); $ref_bonus = HTTP::_GP('ref_bonus', 0); $ref_minpoints = HTTP::_GP('ref_minpoints', 0); $silo_factor = HTTP::_GP('silo_factor', 0); $ref_max_referals = HTTP::_GP('ref_max_referals', 0); $max_dm_missions = HTTP::_GP('max_dm_missions', 1); $alliance_create_min_points = HTTP::_GP('alliance_create_min_points', 0); $config_after = array('noobprotectiontime' => $noobprotectiontime, 'noobprotectionmulti' => $noobprotectionmulti, 'noobprotection' => $noobprotection, 'Defs_Cdr' => $Defs_Cdr, 'Fleet_Cdr' => $Fleet_Cdr, 'game_disable' => $game_disable, 'close_reason' => $close_reason, 'OverviewNewsFrame' => $OverviewNewsFrame, 'reg_closed' => $reg_closed, 'OverviewNewsText' => $OverviewNewsText, 'uni_name' => $uni_name, 'forum_url' => $forum_url, 'game_speed' => $game_speed, 'fleet_speed' => $fleet_speed, 'resource_multiplier' => $resource_multiplier, 'halt_speed' => $halt_speed, 'energySpeed' => $energySpeed, 'initial_fields' => $initial_fields, 'metal_basic_income' => $metal_basic_income, 'crystal_basic_income' => $crystal_basic_income, 'deuterium_basic_income' => $deuterium_basic_income, 'debug' => $debug, 'adm_attack' => $adm_attack, 'lang' => $lang, 'min_build_time' => $min_build_time, 'user_valid' => $user_valid, 'trade_charge' => $trade_charge, 'trade_allowed_ships' => $trade_allowed_ships, 'max_galaxy' => $max_galaxy, 'max_system' => $max_system, 'max_planets' => $max_planets, 'min_player_planets' => $min_player_planets, 'planets_tech' => $planets_tech, 'planets_officier' => $planets_officier, 'planets_per_tech' => $planets_per_tech, 'planet_factor' => $planet_factor, 'max_elements_build' => $max_elements_build, 'max_elements_tech' => $max_elements_tech, 'max_elements_ships' => $max_elements_ships, 'max_overflow' => $max_overflow, 'moon_factor' => $moon_factor, 'moon_chance' => $moon_chance, 'darkmatter_cost_trader' => $darkmatter_cost_trader, 'factor_university' => $factor_university, 'max_fleets_per_acs' => $max_fleets_per_acs, 'vmode_min_time' => $vmode_min_time, 'gate_wait_time' => $gate_wait_time, 'metal_start' => $metal_start, 'crystal_start' => $crystal_start, 'deuterium_start' => $deuterium_start, 'darkmatter_start' => $darkmatter_start, 'debris_moon' => $debris_moon, 'deuterium_cost_galaxy' => $deuterium_cost_galaxy, 'ref_active' => $ref_active, 'ref_bonus' => $ref_bonus, 'ref_minpoints' => $ref_minpoints, 'ref_max_referals' => $ref_max_referals, 'silo_factor' => $silo_factor, 'max_dm_missions' => $max_dm_missions, 'alliance_create_min_points' => $alliance_create_min_points, 'max_fleet_per_build' => $max_fleet_per_build); foreach ($config_after as $key => $value) { $config->{$key} = $value; } $config->save(); $LOG = new Log(3); $LOG->target = 1; $LOG->old = $config_before; $LOG->new = $config_after; $LOG->save(); if ($config->adm_attack == 0) { $GLOBALS['DATABASE']->query("UPDATE " . USERS . " SET `authattack` = '0' WHERE `universe` = '" . Universe::getEmulated() . "';"); } } $template = new template(); $template->loadscript('../base/jquery.autosize-min.js'); $template->execscript('$(\'textarea\').autosize();'); $template->assign_vars(array('se_server_parameters' => $LNG['se_server_parameters'], 'se_game_name' => $LNG['se_game_name'], 'se_uni_name' => $LNG['se_uni_name'], 'se_cookie_advert' => $LNG['se_cookie_advert'], 'se_lang' => $LNG['se_lang'], 'se_general_speed' => $LNG['se_general_speed'], 'se_fleet_speed' => $LNG['se_fleet_speed'], 'se_energy_speed' => $LNG['se_energy_speed'], 'se_halt_speed' => $LNG['se_halt_speed'], 'se_normal_speed' => $LNG['se_normal_speed'], 'se_normal_speed_fleet' => $LNG['se_normal_speed_fleet'], 'se_resources_producion_speed' => $LNG['se_resources_producion_speed'], 'se_normal_speed_resoruces' => $LNG['se_normal_speed_resoruces'], 'se_normal_speed_halt' => $LNG['se_normal_speed_halt'], 'se_forum_link' => $LNG['se_forum_link'], 'se_server_op_close' => $LNG['se_server_op_close'], 'se_server_status_message' => $LNG['se_server_status_message'], 'se_server_planet_parameters' => $LNG['se_server_planet_parameters'], 'se_initial_fields' => $LNG['se_initial_fields'], 'se_metal_production' => $LNG['se_metal_production'], 'se_admin_protection' => $LNG['se_admin_protection'], 'se_crystal_production' => $LNG['se_crystal_production'], 'se_deuterium_production' => $LNG['se_deuterium_production'], 'se_several_parameters' => $LNG['se_several_parameters'], 'se_min_build_time' => $LNG['se_min_build_time'], 'se_reg_closed' => $LNG['se_reg_closed'], 'se_verfiy_mail' => $LNG['se_verfiy_mail'], 'se_min_build_time_info' => $LNG['se_min_build_time_info'], 'se_verfiy_mail_info' => $LNG['se_verfiy_mail_info'], 'se_fields' => $LNG['se_fields'], 'se_per_hour' => $LNG['se_per_hour'], 'se_debug_mode' => $LNG['se_debug_mode'], 'se_title_admins_protection' => $LNG['se_title_admins_protection'], 'se_debug_message' => $LNG['se_debug_message'], 'se_ships_cdr_message' => $LNG['se_ships_cdr_message'], 'se_def_cdr_message' => $LNG['se_def_cdr_message'], 'se_ships_cdr' => $LNG['se_ships_cdr'], 'se_def_cdr' => $LNG['se_def_cdr'], 'se_noob_protect' => $LNG['se_noob_protect'], 'se_noob_protect3' => $LNG['se_noob_protect3'], 'se_noob_protect2' => $LNG['se_noob_protect2'], 'se_noob_protect_e2' => $LNG['se_noob_protect_e2'], 'se_noob_protect_e3' => $LNG['se_noob_protect_e3'], 'se_trader_head' => $LNG['se_trader_head'], 'se_trader_ships' => $LNG['se_trader_ships'], 'se_trader_charge' => $LNG['se_trader_charge'], 'se_news_head' => $LNG['se_news_head'], 'se_news_active' => $LNG['se_news_active'], 'se_news_info' => $LNG['se_news_info'], 'se_news' => $LNG['se_news'], 'se_news_limit' => $LNG['se_news_limit'], 'se_recaptcha_head' => $LNG['se_recaptcha_head'], 'se_recaptcha_active' => $LNG['se_recaptcha_active'], 'se_recaptcha_desc' => $LNG['se_recaptcha_desc'], 'se_recaptcha_public' => $LNG['se_recaptcha_public'], 'se_recaptcha_private' => $LNG['se_recaptcha_private'], 'se_smtp' => $LNG['se_smtp'], 'se_mail_active' => $LNG['se_mail_active'], 'se_mail_use' => $LNG['se_mail_use'], 'se_smail_path' => $LNG['se_smail_path'], 'se_smtp_info' => $LNG['se_smtp_info'], 'se_smtp_host' => $LNG['se_smtp_host'], 'se_smtp_host_info' => $LNG['se_smtp_host_info'], 'se_smtp_ssl' => $LNG['se_smtp_ssl'], 'se_smtp_ssl_info' => $LNG['se_smtp_ssl_info'], 'se_smtp_port' => $LNG['se_smtp_port'], 'se_smtp_port_info' => $LNG['se_smtp_port_info'], 'se_smtp_user' => $LNG['se_smtp_user'], 'se_smtp_pass' => $LNG['se_smtp_pass'], 'se_smtp_sendmail' => $LNG['se_smtp_sendmail'], 'se_smtp_sendmail_info' => $LNG['se_smtp_sendmail_info'], 'se_google' => $LNG['se_google'], 'se_google_active' => $LNG['se_google_active'], 'se_google_info' => $LNG['se_google_info'], 'se_google_key' => $LNG['se_google_key'], 'se_google_key_info' => $LNG['se_google_key_info'], 'se_save_parameters' => $LNG['se_save_parameters'], 'se_max_galaxy' => $LNG['se_max_galaxy'], 'se_max_galaxy_info' => $LNG['se_max_galaxy_info'], 'se_max_system' => $LNG['se_max_system'], 'se_max_system_info' => $LNG['se_max_system_info'], 'se_max_planets' => $LNG['se_max_planets'], 'se_max_planets_info' => $LNG['se_max_planets_info'], 'se_min_player_planets' => $LNG['se_min_player_planets'], 'se_max_player_planets_info' => $LNG['se_max_player_planets_info'], 'se_max_player_planets' => $LNG['se_max_player_planets'], 'se_min_player_planets_info' => $LNG['se_min_player_planets_info'], 'se_planet_factor' => $LNG['se_planet_factor'], 'se_planet_factor_info' => $LNG['se_planet_factor_info'], 'se_max_elements_build' => $LNG['se_max_elements_build'], 'se_max_elements_build_info' => $LNG['se_max_elements_build_info'], 'se_max_elements_tech' => $LNG['se_max_elements_tech'], 'se_max_elements_tech_info' => $LNG['se_max_elements_tech_info'], 'se_max_elements_ships' => $LNG['se_max_elements_ships'], 'se_max_elements_ships_info' => $LNG['se_max_elements_ships_info'], 'se_max_fleet_per_build' => $LNG['se_max_fleet_per_build'], 'se_max_fleet_per_build_info' => $LNG['se_max_fleet_per_build_info'], 'se_max_overflow' => $LNG['se_max_overflow'], 'se_max_overflow_info' => $LNG['se_max_overflow_info'], 'se_moon_factor' => $LNG['se_moon_factor'], 'se_moon_factor_info' => $LNG['se_moon_factor_info'], 'se_moon_chance' => $LNG['se_moon_chance'], 'se_moon_chance_info' => $LNG['se_moon_chance_info'], 'se_darkmatter_cost_trader' => $LNG['se_darkmatter_cost_trader'], 'se_darkmatter_cost_trader_info' => $LNG['se_darkmatter_cost_trader_info'], 'se_factor_university' => $LNG['se_factor_university'], 'se_factor_university_info' => $LNG['se_factor_university_info'], 'se_max_fleets_per_acs' => $LNG['se_max_fleets_per_acs'], 'se_max_fleets_per_acs_info' => $LNG['se_max_fleets_per_acs_info'], 'se_vmode_min_time' => $LNG['se_vmode_min_time'], 'se_vmode_min_time_info' => $LNG['se_vmode_min_time_info'], 'se_gate_wait_time' => $LNG['se_gate_wait_time'], 'se_gate_wait_time_info' => $LNG['se_gate_wait_time_info'], 'se_metal_start' => $LNG['se_metal_start'], 'se_metal_start_info' => $LNG['se_metal_start_info'], 'se_crystal_start' => $LNG['se_crystal_start'], 'se_crystal_start_info' => $LNG['se_crystal_start_info'], 'se_deuterium_start' => $LNG['se_deuterium_start'], 'se_deuterium_start_info' => $LNG['se_deuterium_start_info'], 'se_darkmatter_start' => $LNG['se_darkmatter_start'], 'se_darkmatter_start_info' => $LNG['se_darkmatter_start_info'], 'se_debris_moon' => $LNG['se_debris_moon'], 'se_debris_moon_info' => $LNG['se_debris_moon_info'], 'se_deuterium_cost_galaxy' => $LNG['se_deuterium_cost_galaxy'], 'se_deuterium_cost_galaxy_info' => $LNG['se_deuterium_cost_galaxy_info'], 'se_buildlist' => $LNG['se_buildlist'], 'Deuterium' => $LNG['tech'][903], 'Darkmatter' => $LNG['tech'][921], 'se_ref' => $LNG['se_ref'], 'se_ref_active' => $LNG['se_ref_active'], 'se_ref_active_info' => $LNG['se_ref_active_info'], 'se_ref_max_referals' => $LNG['se_ref_max_referals'], 'se_ref_max_referals_info' => $LNG['se_ref_max_referals_info'], 'se_ref_bonus' => $LNG['se_ref_bonus'], 'se_ref_bonus_info' => $LNG['se_ref_bonus_info'], 'se_ref_minpoints' => $LNG['se_ref_minpoints'], 'se_ref_minpoints_info' => $LNG['se_ref_minpoints_info'], 'se_silo_factor' => $LNG['se_silo_factor'], 'se_silo_factor_info' => $LNG['se_silo_factor_info'], 'se_max_dm_missions' => $LNG['se_max_dm_missions'], 'se_alliance_create_min_points' => $LNG['se_alliance_create_min_points'], 'game_name' => $config->game_name, 'uni_name' => $config->uni_name, 'game_speed' => $config->game_speed / 2500, 'fleet_speed' => $config->fleet_speed / 2500, 'resource_multiplier' => $config->resource_multiplier, 'halt_speed' => $config->halt_speed, 'energySpeed' => $config->energySpeed, 'forum_url' => $config->forum_url, 'initial_fields' => $config->initial_fields, 'metal_basic_income' => $config->metal_basic_income, 'crystal_basic_income' => $config->crystal_basic_income, 'deuterium_basic_income' => $config->deuterium_basic_income, 'game_disable' => $config->game_disable, 'close_reason' => $config->close_reason, 'debug' => $config->debug, 'adm_attack' => $config->adm_attack, 'defenses' => $config->Defs_Cdr, 'shiips' => $config->Fleet_Cdr, 'noobprot' => $config->noobprotection, 'noobprot2' => $config->noobprotectiontime, 'noobprot3' => $config->noobprotectionmulti, 'mail_active' => $config->mail_active, 'mail_use' => $config->mail_use, 'smail_path' => $config->smail_path, 'smtp_host' => $config->smtp_host, 'smtp_port' => $config->smtp_port, 'smtp_user' => $config->smtp_user, 'smtp_pass' => $config->smtp_pass, 'smtp_sendmail' => $config->smtp_sendmail, 'smtp_ssl' => $config->smtp_ssl, 'user_valid' => $config->user_valid, 'newsframe' => $config->OverviewNewsFrame, 'reg_closed' => $config->reg_closed, 'NewsTextVal' => $config->OverviewNewsText, 'capprivate' => $config->capprivate, 'cappublic' => $config->cappublic, 'capaktiv' => $config->capaktiv, 'min_build_time' => $config->min_build_time, 'trade_allowed_ships' => $config->trade_allowed_ships, 'trade_charge' => $config->trade_charge, 'Selector' => array('langs' => $LNG->getAllowedLangs(false), 'mail' => $LNG['se_mail_sel'], 'encry' => array('' => $LNG['se_smtp_ssl_1'], 'ssl' => $LNG['se_smtp_ssl_2'], 'tls' => $LNG['se_smtp_ssl_3'])), 'lang' => $config->lang, 'max_galaxy' => $config->max_galaxy, 'max_system' => $config->max_system, 'max_planets' => $config->max_planets, 'min_player_planets' => $config->min_player_planets, 'planets_tech' => $config->planets_tech, 'planets_officier' => $config->planets_officier, 'planets_per_tech' => $config->planets_per_tech, 'planet_factor' => $config->planet_factor, 'max_elements_build' => $config->max_elements_build, 'max_elements_tech' => $config->max_elements_tech, 'max_elements_ships' => $config->max_elements_ships, 'max_fleet_per_build' => $config->max_fleet_per_build, 'max_overflow' => $config->max_overflow, 'moon_factor' => $config->moon_factor, 'moon_chance' => $config->moon_chance, 'darkmatter_cost_trader' => $config->darkmatter_cost_trader, 'factor_university' => $config->factor_university, 'max_fleets_per_acs' => $config->max_fleets_per_acs, 'vmode_min_time' => $config->vmode_min_time, 'gate_wait_time' => $config->gate_wait_time, 'metal_start' => $config->metal_start, 'crystal_start' => $config->crystal_start, 'deuterium_start' => $config->deuterium_start, 'darkmatter_start' => $config->darkmatter_start, 'debris_moon' => $config->debris_moon, 'deuterium_cost_galaxy' => $config->deuterium_cost_galaxy, 'ref_active' => $config->ref_active, 'ref_bonus' => $config->ref_bonus, 'ref_minpoints' => $config->ref_minpoints, 'ref_max_referals' => $config->ref_max_referals, 'silo_factor' => $config->silo_factor, 'max_dm_missions' => $config->max_dm_missions, 'alliance_create_min_points' => $config->alliance_create_min_points)); $template->show('ConfigBodyUni.tpl'); }
function ShowSearchPage() { global $LNG, $USER; if ($_GET['delete'] == 'user') { PlayerUtil::deletePlayer((int) $_GET['user']); message($LNG['se_delete_succes_p'], '?page=search&search=users&minimize=on', 2); } elseif ($_GET['delete'] == 'planet') { PlayerUtil::deletePlanet((int) $_GET['planet']); message($LNG['se_delete_succes_p'], '?page=search&search=planet&minimize=on', 2); } $SearchFile = HTTP::_GP('search', ''); $SearchFor = HTTP::_GP('search_in', ''); $SearchMethod = HTTP::_GP('fuki', ''); $SearchKey = HTTP::_GP('key_user', '', UTF8_SUPPORT); $Page = HTTP::_GP('side', 0); $Order = HTTP::_GP('key_order', ''); $OrderBY = HTTP::_GP('key_acc', ''); $limit = HTTP::_GP('limit', 25); $Selector = array('list' => array('users' => $LNG['se_users'], 'planet' => $LNG['se_planets'], 'moon' => $LNG['se_moons'], 'alliance' => $LNG['se_allys'], 'vacation' => $LNG['se_vacations'], 'banned' => $LNG['se_suspended'], 'admin' => $LNG['se_authlevels'], 'inactives' => $LNG['se_inactives'], 'online' => $LNG['online_users'], 'p_connect' => $LNG['se_planets_act']), 'search' => array('name' => $LNG['se_input_name'], 'id' => $LNG['input_id']), 'filter' => array('normal' => $LNG['se_type_all'], 'exacto' => $LNG['se_type_exact'], 'last' => $LNG['se_type_last'], 'first' => $LNG['se_type_first']), 'order' => array('ASC' => $LNG['se_input_asc'], 'DESC' => $LNG['se_input_desc']), 'limit' => array('1' => '1', '5' => '5', '10' => '10', '15' => '15', '20' => '20', '25' => '25', '50' => '50', '100' => '100', '200' => '200', '500' => '500')); $template = new template(); if (HTTP::_GP('minimize', '') == 'on') { $Minimize = "&minimize=on"; $template->assign_vars(array('minimize' => 'checked = "checked"', 'diisplaay' => 'style="display:none;"')); } switch ($SearchMethod) { case 'exacto': $SpecifyWhere = "= '" . $GLOBALS['DATABASE']->sql_escape($SearchKey) . "'"; break; case 'last': $SpecifyWhere = "LIKE '" . $GLOBALS['DATABASE']->sql_escape($SearchKey, true) . "%'"; break; case 'first': $SpecifyWhere = "LIKE '%" . $GLOBALS['DATABASE']->sql_escape($SearchKey, true) . "'"; break; default: $SpecifyWhere = "LIKE '%" . $GLOBALS['DATABASE']->sql_escape($SearchKey, true) . "%'"; break; } if (!empty($SearchFile)) { $ArrayUsers = array("users", "vacation", "admin", "inactives", "online"); $ArrayPlanets = array("planet", "moon", "p_connect"); $ArrayBanned = array("banned"); $ArrayAlliance = array("alliance"); if (in_array($SearchFile, $ArrayUsers)) { $Table = "users"; $NameLang = $LNG['se_search_users']; $SpecifyItems = "id,username,email_2,onlinetime,register_time,user_lastip,authlevel,bana,urlaubs_modus"; $SName = $LNG['se_input_userss']; $SpecialSpecify = ""; if ($SearchFile == "vacation") { $SpecialSpecify = "AND urlaubs_modus = '1'"; $SName = $LNG['se_input_vacatii']; } if ($SearchFile == "online") { $SpecialSpecify = "AND onlinetime >= '" . (TIMESTAMP - 15 * 60) . "'"; $SName = $LNG['se_input_connect']; } if ($SearchFile == "inactives") { $SpecialSpecify = "AND onlinetime < '" . (TIMESTAMP - 60 * 60 * 24 * 7) . "'"; $SName = $LNG['se_input_inact']; } if ($SearchFile == "admin") { $SpecialSpecify = "AND authlevel <= '" . $USER['authlevel'] . "' AND authlevel > '0'"; $SName = $LNG['se_input_admm']; } $SpecialSpecify .= " AND universe = '" . Universe::getEmulated() . "'"; $SearchFor == "name" ? $WhereItem = "WHERE username" : ($WhereItem = "WHERE id"); $ArrayOSec = array("id", "username", "email_2", "onlinetime", "register_time", "user_lastip", "authlevel", "bana", "urlaubs_modus"); $Array0SecCount = count($ArrayOSec); for ($OrderNum = 0; $OrderNum < $Array0SecCount; $OrderNum++) { $OrderBYParse[$ArrayOSec[$OrderNum]] = $LNG['se_search_users'][$OrderNum]; } } elseif (in_array($SearchFile, $ArrayPlanets)) { $Table = "planets p"; $TableUsers = "2"; $NameLang = $LNG['se_search_planets']; $SpecifyItems = "p.id,p.name,CONCAT(u.username, ' (ID: ', p.id_owner, ')'),p.last_update,p.galaxy,p.system,p.planet,p.id_luna"; if ($SearchFile == "planet") { $SpecialSpecify = "AND planet_type = '1'"; $SName = $LNG['se_input_planett']; } elseif ($SearchFile == "moon") { $SpecialSpecify = "AND planet_type = '3'"; $SName = $LNG['se_input_moonn']; } elseif ($SearchFile == "p_connect") { $SpecialSpecify = "AND last_update >= " . (TIMESTAMP - 60 * 60) . ""; $SName = $LNG['se_input_act_pla']; } $SpecialSpecify .= " AND p.universe = " . Universe::getEmulated(); $WhereItem = "LEFT JOIN " . USERS . " u ON u.id = p.id_owner "; if ($SearchFor == "name") { $WhereItem .= "WHERE p.name"; } else { $WhereItem .= "WHERE p.id"; } $ArrayOSec = array("id", "name", "id_owner", "id_luna", "last_update", "galaxy", "system", "planet"); $Array0SecCount = count($ArrayOSec); for ($OrderNum = 0; $OrderNum < $Array0SecCount; $OrderNum++) { $OrderBYParse[$ArrayOSec[$OrderNum]] = $LNG['se_search_planets'][$OrderNum]; } } elseif (in_array($SearchFile, $ArrayBanned)) { $Table = "banned"; $NameLang = $LNG['se_search_banned']; $SpecifyItems = "id,who,time,longer,theme,author"; $SName = $LNG['se_input_susss']; $SpecialSpecify = " AND universe = '" . Universe::getEmulated() . "'"; $SearchFor == "name" ? $WhereItem = "WHERE who" : ($WhereItem = "WHERE id"); $ArrayOSec = array("id", "who", "time", "longer", "theme", "author"); $Array0SecCount = count($ArrayOSec); for ($OrderNum = 0; $OrderNum < $Array0SecCount; $OrderNum++) { $OrderBYParse[$ArrayOSec[$OrderNum]] = $LNG['se_search_banned'][$OrderNum]; } } elseif (in_array($SearchFile, $ArrayAlliance)) { $Table = "alliance"; $NameLang = $LNG['se_search_alliance']; $SpecifyItems = "id,ally_name,ally_tag,ally_owner,ally_register_time,ally_members"; $SName = $LNG['se_input_allyy']; $SpecialSpecify = " AND ally_universe = '" . Universe::getEmulated() . "'"; $SearchFor == "name" ? $WhereItem = "WHERE ally_name" : ($WhereItem = "WHERE id"); $ArrayOSec = array("id", "ally_name", "ally_tag", "ally_owner", "ally_register_time", "ally_members"); $Array0SecCount = count($ArrayOSec); for ($OrderNum = 0; $OrderNum < $Array0SecCount; $OrderNum++) { $OrderBYParse[$ArrayOSec[$OrderNum]] = $LNG['se_search_alliance'][$OrderNum]; } } $RESULT = MyCrazyLittleSearch($SpecifyItems, $WhereItem, $SpecifyWhere, $SpecialSpecify, $Order, $OrderBY, $limit, $Table, $Page, $NameLang, $ArrayOSec, $Minimize, $SName, $SearchFile); } $template->assign_vars(array('Selector' => $Selector, 'limit' => $limit, 'search' => $SearchKey, 'SearchFile' => $SearchFile, 'SearchFor' => $SearchFor, 'SearchMethod' => $SearchMethod, 'Order' => $Order, 'OrderBY' => $OrderBY, 'OrderBYParse' => $OrderBYParse, 'se_search' => $LNG['se_search'], 'se_limit' => $LNG['se_limit'], 'se_asc_desc' => $LNG['se_asc_desc'], 'se_filter_title' => $LNG['se_filter_title'], 'se_search_in' => $LNG['se_search_in'], 'se_type_typee' => $LNG['se_type_typee'], 'se_intro' => $LNG['se_intro'], 'se_search_title' => $LNG['se_search_title'], 'se_contrac' => $LNG['se_contrac'], 'se_search_order' => $LNG['se_search_order'], 'ac_minimize_maximize' => $LNG['ac_minimize_maximize'], 'LIST' => $RESULT['LIST'], 'PAGES' => $RESULT['PAGES'])); $template->show('SearchPage.tpl'); }
function ShowUniversePage() { global $LNG, $USER; $template = new template(); $action = HTTP::_GP('action', ''); $universe = HTTP::_GP('uniID', 0); switch ($action) { case 'open': $config = Config::get($universe); $config->game_disable = 1; $config->save(); break; case 'closed': $config = Config::get($universe); $config->game_disable = 0; $config->save(); break; case 'delete': if (!empty($universe) && $universe != ROOT_UNI && $universe != Universe::current()) { $GLOBALS['DATABASE']->query("DELETE FROM " . ALLIANCE . ", " . ALLIANCE_RANK . ", " . ALLIANCE_REQUEST . " \n\t\t\t\tUSING " . ALLIANCE . " \n\t\t\t\tLEFT JOIN " . ALLIANCE_RANK . " ON " . ALLIANCE . ".id = " . ALLIANCE_RANK . ".allianceID\n\t\t\t\tLEFT JOIN " . ALLIANCE_REQUEST . " ON " . ALLIANCE . ".id = " . ALLIANCE_REQUEST . " .allianceID\n\t\t\t\tWHERE ally_universe = " . $universe . ";"); $GLOBALS['DATABASE']->query("DELETE FROM " . BANNED . " WHERE universe = " . $universe . ";"); $GLOBALS['DATABASE']->query("DELETE FROM " . BUDDY . ", " . BUDDY_REQUEST . "\n\t\t\t\tUSING " . BUDDY . "\n\t\t\t\tLEFT JOIN " . BUDDY_REQUEST . " ON " . BUDDY . ".id = " . BUDDY_REQUEST . ".id\n\t\t\t\tWHERE " . BUDDY . ".universe = " . $universe . ";"); $GLOBALS['DATABASE']->query("DELETE FROM " . CONFIG . " WHERE uni = " . $universe . ";"); $GLOBALS['DATABASE']->query("DELETE FROM " . DIPLO . " WHERE universe = " . $universe . ";"); $GLOBALS['DATABASE']->query("DELETE FROM " . FLEETS . ", " . FLEETS_EVENT . ", " . AKS . ", " . LOG_FLEETS . "\n\t\t\t\tUSING " . FLEETS . "\n\t\t\t\tLEFT JOIN " . FLEETS_EVENT . " ON " . FLEETS . ".fleet_id = " . FLEETS_EVENT . ".fleetID\n\t\t\t\tLEFT JOIN " . AKS . " ON " . FLEETS . ".fleet_group = " . AKS . ".id\n\t\t\t\tLEFT JOIN " . LOG_FLEETS . " ON " . FLEETS . ".fleet_id = " . LOG_FLEETS . ".fleet_id\n\t\t\t\tWHERE " . FLEETS . ".fleet_universe = " . $universe . ";"); $GLOBALS['DATABASE']->query("DELETE FROM " . MESSAGES . " WHERE message_universe = " . $universe . ";"); $GLOBALS['DATABASE']->query("DELETE FROM " . NOTES . " WHERE universe = " . $universe . ";"); $GLOBALS['DATABASE']->query("DELETE FROM " . PLANETS . " WHERE universe = " . $universe . ";"); $GLOBALS['DATABASE']->query("DELETE FROM " . STATPOINTS . " WHERE universe = " . $universe . ";"); $GLOBALS['DATABASE']->query("DELETE FROM " . TICKETS . ", " . TICKETS_ANSWER . "\n\t\t\t\tUSING " . TICKETS . "\n\t\t\t\tLEFT JOIN " . TICKETS_ANSWER . " ON " . TICKETS . ".ticketID = " . TICKETS_ANSWER . ".ticketID\n\t\t\t\tWHERE universe = " . $universe . ";"); $GLOBALS['DATABASE']->query("DELETE FROM " . TOPKB . " WHERE universe = " . $universe . ";"); $GLOBALS['DATABASE']->query("DELETE FROM " . USERS . ", " . USERS_ACS . ", " . USERS_AUTH . ", " . TOPKB_USERS . ", " . SESSION . ", " . SHORTCUTS . ", " . RECORDS . "\n\t\t\t\tUSING " . USERS . "\n\t\t\t\tLEFT JOIN " . USERS_ACS . " ON " . USERS . ".id = " . USERS_ACS . ".userID\n\t\t\t\tLEFT JOIN " . USERS_AUTH . " ON " . USERS . ".id = " . USERS_AUTH . ".id\n\t\t\t\tLEFT JOIN " . TOPKB_USERS . " ON " . USERS . ".id = " . TOPKB_USERS . ".uid\n\t\t\t\tLEFT JOIN " . SESSION . " ON " . USERS . ".id = " . SESSION . ".userID\n\t\t\t\tLEFT JOIN " . SHORTCUTS . " ON " . USERS . ".id = " . SHORTCUTS . ".ownerID\n\t\t\t\tLEFT JOIN " . RECORDS . " ON " . USERS . ".id = " . RECORDS . ".userID\n\t\t\t\tLEFT JOIN " . LOSTPASSWORD . " ON " . USERS . ".id = " . LOSTPASSWORD . ".userID\n\t\t\t\tWHERE " . USERS . ".universe = " . $universe . ";"); $GLOBALS['DATABASE']->query("DELETE FROM " . USERS_VALID . " WHERE universe = " . $universe . ";"); if (Universe::getEmulated() == $universe) { Universe::setEmulated(Universe::current()); } if (count(Universe::availableUniverses()) == 2) { // Hack The Session setcookie(session_name(), session_id(), SESSION_LIFETIME, HTTP_BASE, NULL, HTTPS, true); HTTP::redirectTo("../admin.php?reload=r"); } } break; case 'create': $universeCount = count(Universe::availableUniverses()); // Check Multiuniverse Support $ch = curl_init(); if ($universeCount == 1) { curl_setopt($ch, CURLOPT_URL, PROTOCOL . HTTP_HOST . HTTP_BASE . "uni" . ROOT_UNI . "/"); } else { curl_setopt($ch, CURLOPT_URL, PROTOCOL . HTTP_HOST . HTTP_BASE); } curl_setopt($ch, CURLOPT_HTTPGET, true); curl_setopt($ch, CURLOPT_AUTOREFERER, true); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, false); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_USERAGENT, "Mozilla/5.0 (compatible; 2Moons/" . Config::get()->VERSION . "; +http://2moons.cc)"); curl_setopt($ch, CURLOPT_HTTPHEADER, array("Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8", "Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.3", "Accept-Language: de-DE,de;q=0.8,en-US;q=0.6,en;q=0.4")); curl_exec($ch); $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE); curl_close($ch); if ($httpCode != 302) { $template = new template(); $template->message(str_replace(array('{NGINX-CODE}'), array('rewrite /(.*)/?uni[0-9]+/?(.*) /$1/$2 break;'), $LNG->getTemplate('createUniverseInfo')) . '<a href="javascript:window.history.back();"><button>' . $LNG['uvs_back'] . '</button></a>' . '<a href="javascript:window.location.reload();"><button>' . $LNG['uvs_reload'] . '</button></a>'); exit; } $config = Config::get(); $configSQL = array(); foreach (Config::getGlobalConfigKeys() as $basicConfigKey) { $configSQL[] = '`' . $basicConfigKey . '` = "' . $config->{$basicConfigKey} . '"'; } $configSQL[] = '`uni_name` = "' . $LNG['fcm_universe'] . ' ' . ($universeCount + 1) . '"'; $configSQL[] = '`close_reason` = ""'; $configSQL[] = '`OverviewNewsText` = "' . $GLOBALS['DATABASE']->escape($config->OverviewNewsText) . '"'; $GLOBALS['DATABASE']->query("INSERT INTO " . CONFIG . " SET " . implode(', ', $configSQL) . ";"); $newUniverse = $GLOBALS['DATABASE']->GetInsertID(); Config::reload(); list($userID, $planetID) = PlayerUtil::createPlayer($newUniverse, $USER['username'], '', $USER['email'], $USER['lang'], 1, 1, 1, NULL, AUTH_ADM); $GLOBALS['DATABASE']->query("UPDATE " . USERS . " SET password = '******'password'] . "' WHERE id = " . $userID . ";"); if ($universeCount === 1) { // Hack The Session setcookie(session_name(), session_id(), SESSION_LIFETIME, HTTP_ROOT . 'uni' . $USER['universe'] . '/', NULL, HTTPS, true); HTTP::redirectTo("uni" . $USER['universe'] . "/admin.php?reload=r"); } break; } $uniList = array(); $uniResult = $GLOBALS['DATABASE']->query("SELECT uni, users_amount, game_disable, energySpeed, halt_speed, resource_multiplier, fleet_speed, game_speed, uni_name, COUNT(DISTINCT inac.id) as inactive, COUNT(planet.id) as planet\n\tFROM " . CONFIG . " conf\n\tLEFT JOIN " . USERS . " as inac ON uni = inac.universe AND inac.onlinetime < " . (TIMESTAMP - INACTIVE) . "\n\tLEFT JOIN " . PLANETS . " as planet ON uni = planet.universe\n\tGROUP BY conf.uni, inac.universe, planet.universe\n\tORDER BY uni ASC;"); while ($uniRow = $GLOBALS['DATABASE']->fetch_array($uniResult)) { $uniList[$uniRow['uni']] = $uniRow; } $template->assign_vars(array('uniList' => $uniList, 'SID' => session_id())); $template->show('UniversePage.tpl'); }
function __construct($mode) { $this->data['mode'] = $mode; $this->data['admin'] = Session::load()->userId; $this->data['uni'] = Universe::getEmulated(); }
function ShowResetPage() { global $LNG, $reslist, $resource; $template = new template(); $config = Config::get(ROOT_UNI); if ($_POST) { foreach ($reslist['build'] as $ID) { $dbcol['build'][$ID] = "`" . $resource[$ID] . "` = '0'"; } foreach ($reslist['tech'] as $ID) { $dbcol['tech'][$ID] = "`" . $resource[$ID] . "` = '0'"; } foreach ($reslist['fleet'] as $ID) { $dbcol['fleet'][$ID] = "`" . $resource[$ID] . "` = '0'"; } foreach ($reslist['defense'] as $ID) { $dbcol['defense'][$ID] = "`" . $resource[$ID] . "` = '0'"; } foreach ($reslist['officier'] as $ID) { $dbcol['officier'][$ID] = "`" . $resource[$ID] . "` = '0'"; } foreach ($reslist['resstype'][1] as $ID) { if (isset($config->{$resource[$ID] . '_start'})) { $dbcol['resource_planet_start'][$ID] = "`" . $resource[$ID] . "` = " . $config->{$resource[$ID] . '_start'}; } } foreach ($reslist['resstype'][3] as $ID) { if (isset($config->{$resource[$ID] . '_start'})) { $dbcol['resource_user_start'][$ID] = "`" . $resource[$ID] . "` = " . $config->{$resource[$ID] . '_start'}; } } // Players and Planets if ($_POST['players'] == 'on') { $ID = $GLOBALS['DATABASE']->getFirstCell("SELECT `id_owner` FROM " . PLANETS . " WHERE `universe` = " . Universe::getEmulated() . " AND `galaxy` = '1' AND `system` = '1' AND `planet` = '1';"); $GLOBALS['DATABASE']->multi_query("DELETE FROM " . USERS . " WHERE `universe` = " . Universe::getEmulated() . " AND `id` != '" . $ID . "';DELETE FROM " . PLANETS . " WHERE `universe` = " . Universe::getEmulated() . " AND `id_owner` != '" . $ID . "';"); } if ($_POST['planets'] == 'on') { $GLOBALS['DATABASE']->multi_query("DELETE FROM " . PLANETS . " WHERE `universe` = " . Universe::getEmulated() . " AND `id` NOT IN (SELECT id_planet FROM " . USERS . " WHERE `universe` = " . Universe::getEmulated() . ");UPDATE " . PLANETS . " SET `id_luna` = '0' WHERE `universe` = " . Universe::getEmulated() . ";"); } if ($_POST['moons'] == 'on') { $GLOBALS['DATABASE']->multi_query("DELETE FROM " . PLANETS . " WHERE `planet_type` = '3' AND `universe` = " . Universe::getEmulated() . ";UPDATE " . PLANETS . " SET `id_luna` = '0' WHERE `universe` = " . Universe::getEmulated() . ";"); } // HANGARES Y DEFENSAS if ($_POST['defenses'] == 'on') { $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET " . implode(", ", $dbcol['defense']) . " WHERE `universe` = " . Universe::getEmulated() . ";"); } if ($_POST['ships'] == 'on') { $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET " . implode(", ", $dbcol['fleet']) . " WHERE `universe` = " . Universe::getEmulated() . ";"); } if ($_POST['h_d'] == 'on') { $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET `b_hangar` = '0', `b_hangar_id` = '' WHERE `universe` = " . Universe::getEmulated() . ";"); } // EDIFICIOS if ($_POST['edif_p'] == 'on') { $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET " . implode(", ", $dbcol['build']) . ", `field_current` = '0' WHERE `planet_type` = '1' AND `universe` = " . Universe::getEmulated() . ";"); } if ($_POST['edif_l'] == 'on') { $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET " . implode(", ", $dbcol['build']) . ", `field_current` = '0' WHERE `planet_type` = '3' AND `universe` = " . Universe::getEmulated() . ";"); } if ($_POST['edif'] == 'on') { $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET `b_building` = '0', `b_building_id` = '' WHERE `universe` = " . Universe::getEmulated() . ";"); } // INVESTIGACIONES Y OFICIALES if ($_POST['inves'] == 'on') { $GLOBALS['DATABASE']->query("UPDATE " . USERS . " SET " . implode(", ", $dbcol['tech']) . " WHERE `universe` = " . Universe::getEmulated() . ";"); } if ($_POST['ofis'] == 'on') { $GLOBALS['DATABASE']->query("UPDATE " . USERS . " SET " . implode(", ", $dbcol['officier']) . " WHERE `universe` = " . Universe::getEmulated() . ";"); } if ($_POST['inves_c'] == 'on') { $GLOBALS['DATABASE']->query("UPDATE " . USERS . " SET `b_tech_planet` = '0', `b_tech` = '0', `b_tech_id` = '0', `b_tech_queue` = '' WHERE `universe` = " . Universe::getEmulated() . ";"); } // RECURSOS if ($_POST['dark'] == 'on') { $GLOBALS['DATABASE']->query("UPDATE " . USERS . " SET " . implode(", ", $dbcol['resource_user_start']) . " WHERE `universe` = " . Universe::getEmulated() . ";"); } if ($_POST['resources'] == 'on') { $GLOBALS['DATABASE']->query("UPDATE " . PLANETS . " SET " . implode(", ", $dbcol['resource_planet_start']) . " WHERE `universe` = " . Universe::getEmulated() . ";"); } // GENERAL if ($_POST['notes'] == 'on') { $GLOBALS['DATABASE']->query("DELETE FROM " . NOTES . " WHERE `universe` = " . Universe::getEmulated() . ";"); } if ($_POST['rw'] == 'on') { $GLOBALS['DATABASE']->query("DELETE FROM " . TOPKB . " WHERE `universe` = " . Universe::getEmulated() . ";"); } if ($_POST['friends'] == 'on') { $GLOBALS['DATABASE']->query("DELETE FROM " . BUDDY . " WHERE `universe` = " . Universe::getEmulated() . ";"); } if ($_POST['alliances'] == 'on') { $GLOBALS['DATABASE']->multi_query("DELETE FROM " . ALLIANCE . " WHERE `ally_universe` = '" . Universe::getEmulated() . "';UPDATE " . USERS . " SET `ally_id` = '0', `ally_register_time` = '0', `ally_rank_id` = '0' WHERE `universe` = " . Universe::getEmulated() . ";"); } if ($_POST['fleets'] == 'on') { $GLOBALS['DATABASE']->query("DELETE FROM " . FLEETS . " WHERE `fleet_universe` = '" . Universe::getEmulated() . "';"); } if ($_POST['banneds'] == 'on') { $GLOBALS['DATABASE']->multi_query("DELETE FROM " . BANNED . " WHERE `universe` = " . Universe::getEmulated() . ";UPDATE " . USERS . " SET `bana` = '0', `banaday` = '0' WHERE `universe` = " . Universe::getEmulated() . ";"); } if ($_POST['messages'] == 'on') { $GLOBALS['DATABASE']->multi_query("DELETE FROM " . MESSAGES . " WHERE `message_universe` = '" . Universe::getEmulated() . "';"); } if ($_POST['statpoints'] == 'on') { $GLOBALS['DATABASE']->query("DELETE FROM " . STATPOINTS . " WHERE `universe` = " . Universe::getEmulated() . ";"); } $template->message($LNG['re_reset_excess'], '?page=reset&sid=' . session_id(), 3); exit; } $template->assign_vars(array('button_submit' => $LNG['button_submit'], 're_reset_universe_confirmation' => $LNG['re_reset_universe_confirmation'], 're_reset_all' => $LNG['re_reset_all'], 're_reset_all' => $LNG['re_reset_all'], 're_defenses_and_ships' => $LNG['re_defenses_and_ships'], 're_reset_buldings' => $LNG['re_reset_buldings'], 're_buildings_lu' => $LNG['re_buildings_lu'], 're_buildings_pl' => $LNG['re_buildings_pl'], 're_buldings' => $LNG['re_buldings'], 're_reset_hangar' => $LNG['re_reset_hangar'], 're_ships' => $LNG['re_ships'], 're_defenses' => $LNG['re_defenses'], 're_resources_met_cry' => $LNG['re_resources_met_cry'], 're_resources_dark' => $LNG['re_resources_dark'], 're_resources' => $LNG['re_resources'], 're_reset_invest' => $LNG['re_reset_invest'], 're_investigations' => $LNG['re_investigations'], 're_ofici' => $LNG['re_ofici'], 're_inve_ofis' => $LNG['re_inve_ofis'], 're_reset_statpoints' => $LNG['re_reset_statpoints'], 're_reset_messages' => $LNG['re_reset_messages'], 're_reset_banned' => $LNG['re_reset_banned'], 're_reset_errors' => $LNG['re_reset_errors'], 're_reset_fleets' => $LNG['re_reset_fleets'], 're_reset_allys' => $LNG['re_reset_allys'], 're_reset_buddies' => $LNG['re_reset_buddies'], 're_reset_rw' => $LNG['re_reset_rw'], 're_reset_notes' => $LNG['re_reset_notes'], 're_reset_moons' => $LNG['re_reset_moons'], 're_reset_planets' => $LNG['re_reset_planets'], 're_reset_player' => $LNG['re_reset_player'], 're_player_and_planets' => $LNG['re_player_and_planets'], 're_general' => $LNG['re_general'])); $template->show('ResetPage.tpl'); }