function show()
{
global $USER, $LNG, $reslist;
$db = Database::get();
$sql = "SELECT elementID, level, userID, username\n\t\tFROM %%USERS%%\n\t\tINNER JOIN %%RECORDS%% ON userID = id\n\t\tWHERE universe = :universe;";
$recordResult = $db->select($sql, array(':universe' => Universe::current()));
$defenseList = array_fill_keys($reslist['defense'], array());
$fleetList = array_fill_keys($reslist['fleet'], array());
$researchList = array_fill_keys($reslist['tech'], array());
$buildList = array_fill_keys($reslist['build'], array());
foreach ($recordResult as $recordRow) {
if (in_array($recordRow['elementID'], $reslist['defense'])) {
$defenseList[$recordRow['elementID']][] = $recordRow;
} elseif (in_array($recordRow['elementID'], $reslist['fleet'])) {
$fleetList[$recordRow['elementID']][] = $recordRow;
} elseif (in_array($recordRow['elementID'], $reslist['tech'])) {
$researchList[$recordRow['elementID']][] = $recordRow;
} elseif (in_array($recordRow['elementID'], $reslist['build'])) {
$buildList[$recordRow['elementID']][] = $recordRow;
}
}
require_once 'includes/classes/Cronjob.class.php';
$this->assign(array('defenseList' => $defenseList, 'fleetList' => $fleetList, 'researchList' => $researchList, 'buildList' => $buildList, 'update' => _date($LNG['php_tdformat'], Cronjob::getLastExecutionTime('statistic'), $USER['timezone'])));
$this->display('page.records.default.tpl');
}
public function CreateUTF8Banner($data)
{
global $LNG;
$image = imagecreatefromjpeg($this->source);
$date = _date($LNG['php_dateformat'], TIMESTAMP);
$Font = $data['ttf_file'];
if (!file_exists($Font)) {
$this->BannerError('TTF Font missing!');
}
// Colors
$color = imagecolorallocate($image, 255, 255, 225);
$shadow = imagecolorallocate($image, 33, 33, 33);
$total = $data['wons'] + $data['loos'] + $data['draws'];
$quote = $total != 0 ? $data['wons'] / $total * 100 : 0;
// Username
imagettftext($image, 20, 0, 20, 31, $shadow, $Font, $data['username']);
imagettftext($image, 20, 0, 20, 30, $color, $Font, $data['username']);
imagettftext($image, 16, 0, 250, 31, $shadow, $Font, $data['game_name']);
imagettftext($image, 16, 0, 250, 30, $color, $Font, $data['game_name']);
imagettftext($image, 11, 0, 20, 60, $shadow, $Font, $LNG['ub_rank'] . ': ' . $data['total_rank']);
imagettftext($image, 11, 0, 20, 59, $color, $Font, $LNG['ub_rank'] . ': ' . $data['total_rank']);
imagettftext($image, 11, 0, 20, 81, $shadow, $Font, $LNG['ub_points'] . ': ' . html_entity_decode(shortly_number($data['total_points'])));
imagettftext($image, 11, 0, 20, 80, $color, $Font, $LNG['ub_points'] . ': ' . html_entity_decode(shortly_number($data['total_points'])));
imagettftext($image, 11, 0, 250, 60, $shadow, $Font, $LNG['ub_fights'] . ': ' . html_entity_decode(shortly_number($total, 0)));
imagettftext($image, 11, 0, 250, 59, $color, $Font, $LNG['ub_fights'] . ': ' . html_entity_decode(shortly_number($total, 0)));
imagettftext($image, 11, 0, 250, 81, $shadow, $Font, $LNG['ub_quote'] . ': ' . html_entity_decode(shortly_number($quote, 2)) . '%');
imagettftext($image, 11, 0, 250, 80, $color, $Font, $LNG['ub_quote'] . ': ' . html_entity_decode(shortly_number($quote, 2)) . '%');
if (!isset($_GET['debug'])) {
HTTP::sendHeader('Content-type', 'image/jpg');
}
ImageJPEG($image);
imagedestroy($image);
}
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 show()
{
global $CONF, $LNG, $PLANET, $USER, $db, $resource, $UNI;
$code = isset($_GET['code']) ? $_GET['code'] : null;
$quer = $GLOBALS['DATABASE']->query("SELECT *FROM `uni1_allopass_log` where `code` = '" . $code . "' ;");
if ($GLOBALS['DATABASE']->numRows($quer) < 1) {
$this->printMessage("We are proceeding the payment, do not quit this page. <br> you wil be redirected in 5 seconds", true, array('game.php?page=allo&code=' . $code . '', 5));
die;
}
$query = $GLOBALS['DATABASE']->query("SELECT transac, date, orderid, reference_paid, credits FROM `uni1_allopass_log` where `code` = '" . $code . "' ;");
$query = $GLOBALS['DATABASE']->fetch_array($query);
$INFO1 = $GLOBALS['DATABASE']->uniquequery("SELECT * FROM `uni1_users` WHERE `id` = " . $USER['id'] . ";");
if ($INFO1['lp_points'] == 0) {
$text = 0;
}
if ($INFO1['lp_points'] > 0) {
$text = 0;
}
if ($INFO1['lp_points'] >= 125) {
$text = 5;
}
if ($INFO1['lp_points'] >= 625) {
$text = 10;
}
if ($INFO1['lp_points'] >= 2500) {
$text = 15;
}
if ($INFO1['lp_points'] >= 7000) {
$text = 20;
}
$this->tplObj->assign_vars(array('transac' => $query['transac'], 'code' => $code, 'date' => str_replace(' ', ' ', _date($LNG['php_tdformat'], $query['date']), $USER['timezone']), 'orderid' => $query['orderid'], 'total' => $query['reference_paid'], 'credits' => pretty_number($query['credits'] + $query['credits'] / 100 * $text)));
$this->display('page.allo.order.tpl');
}
function show()
{
global $LNG, $USER;
$LNG->includeData(array('FLEET'));
$this->setWindow('popup');
$db = Database::get();
$RID = HTTP::_GP('raport', '');
$sql = "SELECT raport,attacker,defender FROM %%RW%% WHERE rid = :reportID;";
$reportData = $db->selectSingle($sql, array(':reportID' => $RID));
if (empty($reportData)) {
$this->printMessage($LNG['sys_raport_not_found']);
}
// empty is BC for pre r2484
$isAttacker = empty($reportData['attacker']) || in_array($USER['id'], explode(",", $reportData['attacker']));
$isDefender = empty($reportData['defender']) || in_array($USER['id'], explode(",", $reportData['defender']));
if (empty($reportData) || !$isAttacker && !$isDefender) {
$this->printMessage($LNG['sys_raport_not_found']);
}
$combatReport = unserialize($reportData['raport']);
if ($isAttacker && !$isDefender && $combatReport['result'] == 'r' && count($combatReport['rounds']) <= 2) {
$this->printMessage($LNG['sys_raport_lost_contact']);
}
$combatReport['time'] = _date($LNG['php_tdformat'], $combatReport['time'], $USER['timezone']);
$combatReport = $this->BCWrapperPreRev2321($combatReport);
$this->assign(array('Raport' => $combatReport, 'pageTitle' => $LNG['sys_mess_attack_report']));
$this->display('shared.mission.raport.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 view()
{
global $THEME, $LNG, $USER;
$MessCategory = HTTP::_GP('messcat', 100);
$page = HTTP::_GP('site', 1);
$this->initTemplate();
$this->setWindow('ajax');
$MessageList = array();
$MesagesID = array();
if ($MessCategory == 999) {
$MessageCount = $GLOBALS['DATABASE']->getFirstCell("SELECT COUNT(*) FROM " . MESSAGES . " WHERE message_sender = " . $USER['id'] . " AND message_type != 50;");
$maxPage = max(1, ceil($MessageCount / MESSAGES_PER_PAGE));
$page = max(1, min($page, $maxPage));
$MessageResult = $GLOBALS['DATABASE']->query("SELECT message_id, message_time, CONCAT(username, ' [',galaxy, ':', system, ':', planet,']') as message_from, message_subject, message_sender, message_type, message_unread, message_text FROM " . MESSAGES . " INNER JOIN " . USERS . " ON id = message_owner WHERE message_sender = " . $USER['id'] . " AND message_type != 50 ORDER BY message_time DESC LIMIT " . ($page - 1) * MESSAGES_PER_PAGE . ", " . MESSAGES_PER_PAGE . ";");
} else {
$MessageCount = $GLOBALS['DATABASE']->getFirstCell("SELECT COUNT(*) FROM " . MESSAGES . " WHERE message_owner = " . $USER['id'] . ($MessCategory != 100 ? " AND message_type = " . $MessCategory : "") . ";");
$maxPage = max(1, ceil($MessageCount / MESSAGES_PER_PAGE));
$page = max(1, min($page, $maxPage));
$MessageResult = $GLOBALS['DATABASE']->query("SELECT message_id, message_time, message_from, message_subject, message_sender, message_type, message_unread, message_text FROM " . MESSAGES . " WHERE message_owner = " . $USER['id'] . ($MessCategory != 100 ? " AND message_type = " . $MessCategory : "") . " ORDER BY message_time DESC LIMIT " . ($page - 1) * MESSAGES_PER_PAGE . ", " . MESSAGES_PER_PAGE . ";");
}
while ($MessageRow = $GLOBALS['DATABASE']->fetch_array($MessageResult)) {
$MesagesID[] = $MessageRow['message_id'];
$MessageList[] = array('id' => $MessageRow['message_id'], 'time' => _date($LNG['php_tdformat'], $MessageRow['message_time'], $USER['timezone']), 'from' => $MessageRow['message_from'], 'subject' => $MessageRow['message_subject'], 'sender' => $MessageRow['message_sender'], 'type' => $MessageRow['message_type'], 'unread' => $MessageRow['message_unread'], 'text' => $MessageRow['message_text']);
}
if (!empty($MesagesID) && $MessCategory != 999) {
$GLOBALS['DATABASE']->query("UPDATE " . MESSAGES . " SET message_unread = 0 WHERE message_id IN (" . implode(',', $MesagesID) . ") AND message_owner = " . $USER['id'] . ";");
}
$GLOBALS['DATABASE']->free_result($MessageResult);
$this->tplObj->assign_vars(array('MessID' => $MessCategory, 'MessageCount' => $MessageCount, 'MessageList' => $MessageList, 'page' => $page, 'maxPage' => $maxPage));
$this->display('page.messages.view.tpl');
}
function ShowNewsPage()
{
global $LNG, $USER;
if ($_GET['action'] == 'send') {
$edit_id = HTTP::_GP('id', 0);
$title = $GLOBALS['DATABASE']->sql_escape(HTTP::_GP('title', '', true));
$text = $GLOBALS['DATABASE']->sql_escape(HTTP::_GP('text', '', true));
$query = $_GET['mode'] == 2 ? "INSERT INTO " . NEWS . " (`id` ,`user` ,`date` ,`title` ,`text`) VALUES ( NULL , '" . $USER['username'] . "', '" . TIMESTAMP . "', '" . $title . "', '" . $text . "');" : "UPDATE " . NEWS . " SET `title` = '" . $title . "', `text` = '" . $text . "', `date` = '" . TIMESTAMP . "' WHERE `id` = '" . $edit_id . "' LIMIT 1;";
$GLOBALS['DATABASE']->query($query);
} elseif ($_GET['action'] == 'delete' && isset($_GET['id'])) {
$GLOBALS['DATABASE']->query("DELETE FROM " . NEWS . " WHERE `id` = '" . HTTP::_GP('id', 0) . "';");
}
$query = $GLOBALS['DATABASE']->query("SELECT * FROM " . NEWS . " ORDER BY id ASC");
while ($u = $GLOBALS['DATABASE']->fetch_array($query)) {
$NewsList[] = array('id' => $u['id'], 'title' => $u['title'], 'date' => _date($LNG['php_tdformat'], $u['date'], $USER['timezone']), 'user' => $u['user'], 'confirm' => sprintf($LNG['nws_confirm'], $u['title']));
}
$template = new template();
if ($_GET['action'] == 'edit' && isset($_GET['id'])) {
$News = $GLOBALS['DATABASE']->getFirstRow("SELECT id, title, text FROM " . NEWS . " WHERE id = '" . $GLOBALS['DATABASE']->sql_escape($_GET['id']) . "';");
$template->assign_vars(array('mode' => 1, 'nws_head' => sprintf($LNG['nws_head_edit'], $News['title']), 'news_id' => $News['id'], 'news_title' => $News['title'], 'news_text' => $News['text']));
} elseif ($_GET['action'] == 'create') {
$template->assign_vars(array('mode' => 2, 'nws_head' => $LNG['nws_head_create']));
}
$template->assign_vars(array('NewsList' => $NewsList, 'button_submit' => $LNG['button_submit'], 'nws_total' => sprintf($LNG['nws_total'], count($NewsList)), 'nws_news' => $LNG['nws_news'], 'nws_id' => $LNG['nws_id'], 'nws_title' => $LNG['nws_title'], 'nws_date' => $LNG['nws_date'], 'nws_from' => $LNG['nws_from'], 'nws_del' => $LNG['nws_del'], 'nws_create' => $LNG['nws_create'], 'nws_content' => $LNG['nws_content']));
$template->show('NewsPage.tpl');
}
function run()
{
global $LNG;
$config = Config::get(ROOT_UNI);
if ($config->mail_active == 1) {
/** @var $langObjects Language[] */
$langObjects = array();
require 'includes/classes/Mail.class.php';
$sql = 'SELECT `id`, `username`, `lang`, `email`, `onlinetime`, `timezone`, `universe`
FROM %%USERS%% WHERE `inactive_mail` = 0 AND `onlinetime` < :time;';
$inactiveUsers = Database::get()->select($sql, array(':time' => TIMESTAMP - $config->del_user_sendmail * 24 * 60 * 60));
foreach ($inactiveUsers as $user) {
if (!isset($langObjects[$user['lang']])) {
$langObjects[$user['lang']] = new Language($user['lang']);
$langObjects[$user['lang']]->includeData(array('L18N', 'INGAME', 'PUBLIC', 'CUSTOM'));
}
$userConfig = Config::get($user['universe']);
$LNG = $langObjects[$user['lang']];
$MailSubject = sprintf($LNG['spec_mail_inactive_title'], $userConfig->game_name . ' - ' . $userConfig->uni_name);
$MailRAW = $LNG->getTemplate('email_inactive');
$MailContent = str_replace(array('{USERNAME}', '{GAMENAME}', '{LASTDATE}', '{HTTPPATH}'), array($user['username'], $userConfig->game_name . ' - ' . $userConfig->uni_name, _date($LNG['php_tdformat'], $user['onlinetime'], $user['timezone']), HTTP_PATH), $MailRAW);
Mail::send($user['email'], $user['username'], $MailSubject, $MailContent);
$sql = 'UPDATE %%USERS%% SET `inactive_mail` = 1 WHERE `id` = :userId;';
Database::get()->update($sql, array(':userId' => $user['id']));
}
}
}
function show()
{
global $USER, $LNG;
$order = HTTP::_GP('order', 'units');
$sort = HTTP::_GP('sort', 'desc');
$sort = strtoupper($sort) === "DESC" ? "DESC" : "ASC";
switch ($order) {
case 'date':
$key = '%%TOPKB%%.time ' . $sort;
break;
case 'units':
default:
$key = '%%TOPKB%%.units ' . $sort;
break;
}
$db = Database::get();
$sql = "SELECT *, (\n\t\t\tSELECT DISTINCT\n\t\t\tIF(%%TOPKB_USERS%%.username = '', GROUP_CONCAT(%%USERS%%.username SEPARATOR ' & '), GROUP_CONCAT(%%TOPKB_USERS%%.username SEPARATOR ' & '))\n\t\t\tFROM %%TOPKB_USERS%%\n\t\t\tLEFT JOIN %%USERS%% ON uid = %%USERS%%.id\n\t\t\tWHERE %%TOPKB_USERS%%.rid = %%TOPKB%%.rid AND role = 1\n\t\t) as attacker,\n\t\t(\n\t\t\tSELECT DISTINCT\n\t\t\tIF(%%TOPKB_USERS%%.username = '', GROUP_CONCAT(%%USERS%%.username SEPARATOR ' & '), GROUP_CONCAT(%%TOPKB_USERS%%.username SEPARATOR ' & '))\n\t\t\tFROM %%TOPKB_USERS%% INNER JOIN %%USERS%% ON uid = id\n\t\t\tWHERE %%TOPKB_USERS%%.rid = %%TOPKB%%.`rid` AND `role` = 2\n\t\t) as defender\n\t\tFROM %%TOPKB%% WHERE universe = :universe ORDER BY " . $key . " LIMIT 100;";
$top = $db->select($sql, array(':universe' => Universe::current()));
$TopKBList = array();
foreach ($top as $data) {
$TopKBList[] = array('result' => $data['result'], 'date' => _date($LNG['php_tdformat'], $data['time'], $USER['timezone']), 'time' => TIMESTAMP - $data['time'], 'units' => $data['units'], 'rid' => $data['rid'], 'attacker' => $data['attacker'], 'defender' => $data['defender']);
}
$this->assign(array('TopKBList' => $TopKBList, 'sort' => $sort, 'order' => $order));
$this->display('page.battleHall.default.tpl');
}
function show()
{
global $LNG;
$referralID = HTTP::_GP('ref', 0);
if (!empty($referralID)) {
$this->redirectTo('promo.php?referralID=' . $referralID);
}
$universeSelect = array();
$uniAllConfig = Config::getAll('universe');
foreach ($uniAllConfig as $uniID => $uniConfig) {
$universeSelect[$uniID] = $uniConfig['uni_name'] . ($uniConfig['game_disable'] == 0 ? t('uni_closed') : '');
}
$Code = HTTP::_GP('code', 0);
$loginCode = false;
if (isset($LNG['login_error_' . $Code])) {
$loginCode = $LNG['login_error_' . $Code];
}
$referralUniversum = 0;
$referralUserID = 0;
if (Config::get('ref_active')) {
$referralUserID = HTTP::_GP('ref', 0);
if (!empty($referralUserID)) {
$referralUniversum = $GLOBALS['DATABASE']->getFirstRow("SELECT universe FROM " . USERS . " WHERE id = " . $referralUserID . ";");
if (!isset($referralUniversum)) {
$referralUniversum = 0;
$referralUserID = 0;
}
}
}
$newsResult = $GLOBALS['DATABASE']->query("SELECT id, date, title, text, user, catID FROM " . NEWS . " ORDER BY id DESC;");
$newsList = array();
while ($newsRow = $GLOBALS['DATABASE']->fetchArray($newsResult)) {
$newsList[] = array('id' => $newsRow['id'], 'title' => $newsRow['title'], 'from' => t('news_from', _date(t('php_tdformat'), $newsRow['date']), $newsRow['user']), 'text' => substr($newsRow['text'], 0, 160) . "...", 'date' => _date($LNG['php_tdformat'], $newsRow['date'], $newsRow['user']), 'image' => 'images/' . $newsRow['catID'] . '.jpg');
}
$topicsResult = $GLOBALS['DATABASE']->query("SELECT tid, title, last_post, topic_firstpost, title_seo FROM forum_topics WHERE tdelete_time = '0' ORDER BY last_post DESC LIMIT 5;");
$topicsList = array();
while ($topicsRow = $GLOBALS['DATABASE']->fetchArray($topicsResult)) {
$topicsList[] = array('id' => $topicsRow['tid'], 'title' => $topicsRow['title'], 'topic_firstpost' => $topicsRow['topic_firstpost'], 'title_seo' => $topicsRow['title_seo'], 'date' => _date($LNG['php_tdformat'], $topicsRow['last_post'], 1));
}
$uniResult = $GLOBALS['DATABASE']->query("SELECT users_amount, 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)) {
$users_amount = $uniRow['users_amount'];
$active = $uniRow['users_amount'] - $uniRow['inactive'];
}
$uniInfo = $GLOBALS['DATABASE']->query("SELECT users_amount, 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.register_time > " . (TIMESTAMP - 30 * 24 * 60 * 60) . "\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 ($uniRaw = $GLOBALS['DATABASE']->fetch_array($uniInfo)) {
$users_amount = $uniRaw['users_amount'];
$new_member = $uniRaw['inactive'];
}
$uniHof = $GLOBALS['DATABASE']->query("SELECT COUNT(rid) as inactive\n\tFROM " . TOPKB . " WHERE time > " . (TIMESTAMP - 24 * 60 * 60) . "\n\tORDER BY units DESC LIMIT 100;");
while ($uniHaf = $GLOBALS['DATABASE']->fetch_array($uniHof)) {
$total_hof = $uniHaf['inactive'];
}
$this->assign(array('referralUserID' => $referralUserID, 'referralUniversum' => $referralUniversum, 'universeSelect' => $universeSelect, 'topicsList' => $topicsList, 'code' => $loginCode, 'descHeader' => t('loginWelcome', Config::get('game_name')), 'descText' => t('loginServerDesc', Config::get('game_name')), 'newsList' => $newsList, 'users_amount' => $users_amount, 'active' => $active, 'new_member' => $new_member, 'total_hof' => $total_hof, 'loginInfo' => t('loginInfo', '<a href="index.php?page=rules">' . t('menu_rules') . '</a>')));
$this->render('page.index.default.tpl');
}
function show()
{
$newsResult = $GLOBALS['DATABASE']->query("SELECT date, title, text, user FROM " . NEWS . " ORDER BY id DESC;");
$newsList = array();
while ($newsRow = $GLOBALS['DATABASE']->fetchArray($newsResult)) {
$newsList[] = array('title' => $newsRow['title'], 'from' => t('news_from', _date(t('php_tdformat'), $newsRow['date']), $newsRow['user']), 'text' => makebr($newsRow['text']));
}
$this->assign(array('newsList' => $newsList));
$this->render('page.news.default.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');
}
public function show()
{
global $USER, $LNG, $CONF;
if ($USER['urlaubs_modus'] == 1) {
$this->tplObj->assign_vars(array('vacationUntil' => _date($LNG['php_tdformat'], $USER['urlaubs_until'], $USER['timezone']), 'delete' => $USER['db_deaktjava'], 'canVacationDisbaled' => $USER['urlaubs_until'] < TIMESTAMP));
$this->display('page.settings.vacation.tpl');
} else {
$this->tplObj->assign_vars(array('Selectors' => array('timezones' => get_timezone_selector(), 'Sort' => array(0 => $LNG['op_sort_normal'], 1 => $LNG['op_sort_koords'], 2 => $LNG['op_sort_abc']), 'SortUpDown' => array(0 => $LNG['op_sort_up'], 1 => $LNG['op_sort_down']), 'Skins' => Theme::getAvalibleSkins(), 'lang' => $LNG->getAllowedLangs(false)), 'adminProtection' => $USER['authattack'], 'fblink' => $USER['fblink'], 'sirena' => $USER['alarm_volume'], 'userAuthlevel' => $USER['authlevel'], 'changeNickTime' => $USER['uctime'] + USERNAME_CHANGETIME - TIMESTAMP, 'username' => $USER['username'], 'email' => $USER['email'], 'permaEmail' => $USER['email_2'], 'userLang' => $USER['lang'], 'theme' => substr($USER['dpath'], 13, -1), 'planetSort' => $USER['planet_sort'], 'planetOrder' => $USER['planet_sort_order'], 'spycount' => $USER['spio_anz'], 'fleetActions' => $USER['settings_fleetactions'], 'timezone' => $USER['timezone'], 'delete' => $USER['db_deaktjava'], 'queueMessages' => $USER['hof'], 'galaxySpy' => $USER['settings_esp'], 'galaxyBuddyList' => $USER['settings_bud'], 'galaxyMissle' => $USER['settings_mis'], 'galaxyMessage' => $USER['settings_wri'], 'blockPM' => $USER['settings_blockPM'], 'userid' => $USER['id'], 'ref_active' => Config::get('ref_active')));
$this->display('page.settings.default.tpl');
}
}
function historique()
{
global $USER, $PLANET, $LNG, $UNI, $CONF, $resource, $pricelist;
$messageList = '';
$messageRaw = $GLOBALS['DATABASE']->query("SELECT * \n\t\tFROM uni1_reward_log WHERE rewardUserId = " . $USER['id'] . " AND rewardTime > " . (TIMESTAMP - 15 * 24 * 60 * 60) . " \n\t\tORDER BY rewardTime DESC\n\t\t;");
while ($messageRow = $GLOBALS['DATABASE']->fetch_array($messageRaw)) {
$messageList[$messageRow['rewardIdLog']] = array('date' => str_replace(' ', ' ', _date($LNG['php_tdformat'], $messageRow['rewardTime']), $USER['timezone']), 'rewardPrice' => $messageRow['rewardPrice'], 'rewardIdLog' => $messageRow['rewardIdLog'], 'rewardCode' => $this->redeemCode($messageRow['rewardIdLog']));
}
$this->tplObj->assign_vars(array('messageList' => $messageList));
$this->display("page.reward2.historique.tpl");
}
function show()
{
global $LNG;
$sql = "SELECT date, title, text, user FROM %%NEWS%% ORDER BY id DESC;";
$newsResult = Database::get()->select($sql);
$newsList = array();
foreach ($newsResult as $newsRow) {
$newsList[] = array('title' => $newsRow['title'], 'from' => sprintf($LNG['news_from'], _date($LNG['php_tdformat'], $newsRow['date']), $newsRow['user']), 'text' => makebr($newsRow['text']));
}
$this->assign(array('newsList' => $newsList));
$this->display('page.news.default.tpl');
}
/**
* Latest tag block
*/
public static function news($options = array(), $module = null)
{
$limit = $options['item_page'] ? intval($options['item_page']) : 10;
$modelLink = Pi::model('link', 'tag');
$select = $modelLink->select()->order(array('time DESC'))->group('term')->limit($limit);
$rowset = $modelLink->selectWith($select);
$tags = array();
foreach ($rowset as $row) {
$tags[] = array('time' => _date($row['time']), 'link' => Pi::service('tag')->render($row['term']));
}
return array('tags' => $tags);
}
function show()
{
global $LNG, $USER;
$notesResult = $GLOBALS['DATABASE']->query("SELECT * FROM " . NOTES . " WHERE owner = " . $USER['id'] . " ORDER BY priority DESC, time DESC;");
$notesList = array();
while ($notesRow = $GLOBALS['DATABASE']->fetch_array($notesResult)) {
$notesList[$notesRow['id']] = array('time' => _date($LNG['php_tdformat'], $notesRow['time'], $USER['timezone']), 'title' => $notesRow['title'], 'size' => strlen($notesRow['text']), 'priority' => $notesRow['priority']);
}
$GLOBALS['DATABASE']->free_result($notesResult);
$this->tplObj->assign_vars(array('notesList' => $notesList));
$this->display('page.notes.default.tpl');
}
function show()
{
global $LNG, $USER;
$db = Database::get();
$sql = "SELECT * FROM %%NOTES%% WHERE owner = :userID ORDER BY priority DESC, time DESC;";
$notesResult = $db->select($sql, array(':userID' => $USER['id']));
$notesList = array();
foreach ($notesResult as $notesRow) {
$notesList[$notesRow['id']] = array('time' => _date($LNG['php_tdformat'], $notesRow['time'], $USER['timezone']), 'title' => $notesRow['title'], 'size' => strlen($notesRow['text']), 'priority' => $notesRow['priority']);
}
$this->assign(array('notesList' => $notesList));
$this->display('page.notes.default.tpl');
}
/**
* {@inheritDoc}
* @see Pi\Service\I18n
*/
protected function normalizeDateTime($value)
{
if (is_numeric($value)) {
$value = (int) $value;
}
if ($value && is_int($value)) {
$result = _date($value);
} elseif (!$value) {
$result = '';
} else {
$result = $value ? parent::normalizeDateTime($value) : 0;
}
return $result;
}
function show()
{
global $LNG;
$db = Database::get();
$sql = "SELECT *, (\n\t\t\tSELECT DISTINCT\n\t\t\tIF(%%TOPKB_USERS%%.username = '', GROUP_CONCAT(%%USERS%%.username SEPARATOR ' & '), GROUP_CONCAT(%%TOPKB_USERS%%.username SEPARATOR ' & '))\n\t\t\tFROM %%TOPKB_USERS%%\n\t\t\tLEFT JOIN %%USERS%% ON uid = %%USERS%%.id\n\t\t\tWHERE %%TOPKB_USERS%%.`rid` = %%TOPKB%%.`rid` AND `role` = 1\n\t\t) as `attacker`,\n\t\t(\n\t\t\tSELECT DISTINCT\n\t\t\tIF(%%TOPKB_USERS%%.username = '', GROUP_CONCAT(%%USERS%%.username SEPARATOR ' & '), GROUP_CONCAT(%%TOPKB_USERS%%.username SEPARATOR ' & '))\n\t\t\tFROM %%TOPKB_USERS%% INNER JOIN %%USERS%% ON uid = id\n\t\t\tWHERE %%TOPKB_USERS%%.`rid` = %%TOPKB%%.`rid` AND `role` = 2\n\t\t) as `defender`\n\t\tFROM %%TOPKB%% WHERE `universe` = :universe ORDER BY units DESC LIMIT 100;";
$hallRaw = $db->select($sql, array(':universe' => Universe::current()));
$hallList = array();
foreach ($hallRaw as $hallRow) {
$hallList[] = array('result' => $hallRow['result'], 'time' => _date($LNG['php_tdformat'], $hallRow['time']), 'units' => $hallRow['units'], 'rid' => $hallRow['rid'], 'attacker' => $hallRow['attacker'], 'defender' => $hallRow['defender']);
}
$universeSelect = $this->getUniverseSelector();
$this->assign(array('universeSelect' => $universeSelect, 'hallList' => $hallList));
$this->display('page.battleHall.default.tpl');
}
function ShowMesreportPage()
{
global $LNG;
$info = $GLOBALS['DATABASE']->query("SELECT u.compID, u.message, u.from, u.type, u.report, u.reportBy, u.time, u.finished \n\t\t\t\t\t\t\t\t\t\tFROM uni1_complaints as u\n\t\t\t\t\t\t\t\t\t\tORDER BY u.finished ASC LIMIT 50\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t;");
$PUSERS = array();
while ($Data = $GLOBALS['DATABASE']->fetch_array($info)) {
$PUSERS[$Data['username']] = array();
$Data['time'] = _date($LNG['php_tdformat'], $Data['time']);
$PUSERS[$Data['username']][$Data['id']] = $Data;
}
$template = new template();
$template->assign_vars(array('multiGroups' => $PUSERS));
$template->show('mesreport.tpl');
}
function show()
{
global $USER, $PLANET, $LNG, $UNI, $CONF, $resource, $pricelist;
if ($USER['authlevel'] < 3) {
$this->printMessage("your dont have enough permissions!", true, array('game.php?page=Overview', 2));
die;
}
$messageRaw = $GLOBALS['DATABASE']->query("SELECT u.username, us.username as senderName, m.* \n\t\tFROM uni1_messages_copy 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 = '1' AND message_sender != '1' AND message_universe = '1'\n\t\tORDER BY message_time DESC, message_id DESC\n\t\t;");
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'], 'time' => str_replace(' ', ' ', _date($LNG['php_tdformat'], $messageRow['message_time']), $USER['timezone']));
}
$this->tplObj->assign_vars(array('messageList' => $messageList));
$this->display('page.messagelist.tpl');
}
function ShowPremiumPage()
{
global $LNG;
// premium users
$Query = $GLOBALS['DATABASE']->query("SELECT id, username, premium_reward_extraction, premium_reward_storing, premium_reward_speed, premium_reward_stage, premium_reward_bonus, premium_reward_expedition, premium_reward_experience, premium_reward_bank, premium_reward_days FROM " . USERS . " WHERE `universe` = '1' AND premium_reward_days > '" . TIMESTAMP . "' ORDER BY premium_reward_days ASC;");
$PUSERS = array();
while ($Data = $GLOBALS['DATABASE']->fetch_array($Query)) {
$PUSERS[$Data['username']] = array();
$Data['premium_reward_days'] = _date($LNG['php_tdformat'], $Data['premium_reward_days']);
$PUSERS[$Data['username']][$Data['id']] = $Data;
}
$template = new template();
$template->assign_vars(array('multiGroups' => $PUSERS));
$template->show('premium.tpl');
}
function show()
{
$hallRaw = $GLOBALS['DATABASE']->query("SELECT *, (\n\t\t\tSELECT DISTINCT\n\t\t\tIF(" . TOPKB_USERS . ".username = '', GROUP_CONCAT(" . USERS . ".username SEPARATOR ' & '), GROUP_CONCAT(" . TOPKB_USERS . ".username SEPARATOR ' & '))\n\t\t\tFROM " . TOPKB_USERS . "\n\t\t\tLEFT JOIN " . USERS . " ON uid = " . USERS . ".id\n\t\t\tWHERE " . TOPKB_USERS . ".`rid` = " . TOPKB . ".`rid` AND `role` = 1\n\t\t) as `attacker`,\n\t\t(\n\t\t\tSELECT DISTINCT\n\t\t\tIF(" . TOPKB_USERS . ".username = '', GROUP_CONCAT(" . USERS . ".username SEPARATOR ' & '), GROUP_CONCAT(" . TOPKB_USERS . ".username SEPARATOR ' & '))\n\t\t\tFROM " . TOPKB_USERS . " INNER JOIN " . USERS . " ON uid = id\n\t\t\tWHERE " . TOPKB_USERS . ".`rid` = " . TOPKB . ".`rid` AND `role` = 2\n\t\t) as `defender` \n\t\tFROM " . TOPKB . " WHERE `universe` = '" . $GLOBALS['UNI'] . "' ORDER BY units DESC LIMIT 100;");
$hallList = array();
while ($hallRow = $GLOBALS['DATABASE']->fetch_array($hallRaw)) {
$hallList[] = array('result' => $hallRow['result'], 'time' => _date(t('php_tdformat'), $hallRow['time']), 'units' => $hallRow['units'], 'rid' => $hallRow['rid'], 'attacker' => $hallRow['attacker'], 'defender' => $hallRow['defender']);
}
$GLOBALS['DATABASE']->free_result($hallRaw);
$universeSelect = array();
$uniAllConfig = Config::getAll('universe');
foreach ($uniAllConfig as $uniID => $uniConfig) {
$universeSelect[$uniID] = $uniConfig['uni_name'];
}
$this->assign(array('universeSelect' => $universeSelect, 'hallList' => $hallList));
$this->render('page.battleHall.default.tpl');
}
function show()
{
global $LNG, $USER;
$newsResult = $GLOBALS['DATABASE']->query("SELECT id, date, title, text, catID FROM uni1_jobs WHERE is_active = '1' ORDER BY id DESC LIMIT 6;");
$newsList = array();
while ($newsRow = $GLOBALS['DATABASE']->fetchArray($newsResult)) {
$newsList[] = array('id' => $newsRow['id'], 'title' => $newsRow['title'], 'text' => substr($newsRow['text'], 0, 160) . "...", 'date' => _date($LNG['php_tdformat'], $newsRow['date'], $USER), 'image' => 'images/jobs/' . $newsRow['catID'] . '.png');
}
$topicsResult = $GLOBALS['DATABASE']->query("SELECT tid, title, last_post, topic_firstpost, title_seo FROM forum_topics WHERE tdelete_time = '0' ORDER BY last_post DESC LIMIT 5;");
$topicsList = array();
while ($topicsRow = $GLOBALS['DATABASE']->fetchArray($topicsResult)) {
$topicsList[] = array('id' => $topicsRow['tid'], 'title' => $topicsRow['title'], 'topic_firstpost' => $topicsRow['topic_firstpost'], 'title_seo' => $topicsRow['title_seo'], 'date' => _date($LNG['php_tdformat'], $topicsRow['last_post'], 1));
}
$this->assign(array('newsList' => $newsList, 'topicsList' => $topicsList, 'notif' => 'Jobs', 'info' => 'Here will be listed all open applications to become a staff member'));
$this->render('page.jobs.default.tpl');
}
function show()
{
global $USER, $PLANET, $LNG, $UNI;
$page = HTTP::_GP('side', 1);
$banCount = $GLOBALS['DATABASE']->getFirstCell("SELECT COUNT(*) FROM " . BANNED . " WHERE universe = " . $UNI . " ORDER BY time DESC;");
$maxPage = ceil($banCount / BANNED_USERS_PER_PAGE);
$page = max(1, min($page, $maxPage));
$banResult = $GLOBALS['DATABASE']->query("SELECT * FROM " . BANNED . " WHERE universe = " . $UNI . " ORDER BY time DESC LIMIT " . ($page - 1) * BANNED_USERS_PER_PAGE . ", " . BANNED_USERS_PER_PAGE . ";");
$banList = array();
while ($banRow = $GLOBALS['DATABASE']->fetch_array($banResult)) {
$banList[] = array('player' => $banRow['who'], 'theme' => $banRow['theme'], 'from' => _date($LNG['php_tdformat'], $banRow['time'], $USER['timezone']), 'to' => _date($LNG['php_tdformat'], $banRow['longer'], $USER['timezone']), 'admin' => $banRow['author'], 'mail' => $banRow['email'], 'info' => sprintf($LNG['bn_writemail'], $banRow['author']));
}
$GLOBALS['DATABASE']->free_result($banResult);
$this->tplObj->assign_vars(array('banList' => $banList, 'banCount' => $banCount, 'page' => $page, 'maxPage' => $maxPage));
$this->display('page.banList.default.tpl');
}
function show()
{
global $LNG;
$newsResult = $GLOBALS['DATABASE']->query("SELECT id, date, title, text, user FROM " . NEWS . " ORDER BY id DESC LIMIT 5;");
$newsList = array();
while ($newsRow = $GLOBALS['DATABASE']->fetchArray($newsResult)) {
$newsList[] = array('id' => $newsRow['id'], 'title' => $newsRow['title'], 'from' => t('news_from', _date(t('php_tdformat'), $newsRow['date']), $newsRow['user']), 'text' => makebr($newsRow['text']), 'date' => _date($LNG['php_tdformat'], $newsRow['date'], $newsRow['user']));
}
$topicsResult = $GLOBALS['DATABASE']->query("SELECT tid, title, last_post, topic_firstpost, title_seo FROM forum_topics WHERE tdelete_time = '0' ORDER BY last_post DESC LIMIT 5;");
$topicsList = array();
while ($topicsRow = $GLOBALS['DATABASE']->fetchArray($topicsResult)) {
$topicsList[] = array('id' => $topicsRow['tid'], 'title' => $topicsRow['title'], 'topic_firstpost' => $topicsRow['topic_firstpost'], 'title_seo' => $topicsRow['title_seo'], 'date' => _date($LNG['php_tdformat'], $topicsRow['last_post'], 1));
}
$this->assign(array('newsList' => $newsList, 'topicsList' => $topicsList));
$this->render('page.about.default.tpl');
}
function show()
{
global $LNG;
$newsResult = $GLOBALS['DATABASE']->query("SELECT id, date, title, text, user, catID FROM " . NEWS . " ORDER BY id DESC;");
$newsList = array();
while ($newsRow = $GLOBALS['DATABASE']->fetchArray($newsResult)) {
$newsList[] = array('id' => $newsRow['id'], 'title' => $newsRow['title'], 'from' => t('news_from', _date(t('php_tdformat'), $newsRow['date']), $newsRow['user']), 'text' => substr($newsRow['text'], 0, 160) . "...", 'date' => _date($LNG['php_tdformat'], $newsRow['date'], $newsRow['user']), 'image' => 'images/' . $newsRow['catID'] . '.jpg');
}
$topicsResult = $GLOBALS['DATABASE']->query("SELECT tid, title, last_post, topic_firstpost, title_seo FROM forum_topics WHERE tdelete_time = '0' ORDER BY last_post DESC LIMIT 5;");
$topicsList = array();
while ($topicsRow = $GLOBALS['DATABASE']->fetchArray($topicsResult)) {
$topicsList[] = array('id' => $topicsRow['tid'], 'title' => $topicsRow['title'], 'topic_firstpost' => $topicsRow['topic_firstpost'], 'title_seo' => $topicsRow['title_seo'], 'date' => _date($LNG['php_tdformat'], $topicsRow['last_post'], 1));
}
$this->assign(array('newsList' => $newsList, 'topicsList' => $topicsList, 'rules' => $LNG->getTemplate('rules')));
$this->render('page.rules.default.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` = '" . $_SESSION['adminuni'] . "';");
}
$query = $GLOBALS['DATABASE']->query("SELECT * FROM " . USERS_VALID . " WHERE `universe` = '" . $_SESSION['adminuni'] . "' 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' => $_SESSION['adminuni']));
$template->show('ActivePage.tpl');
}
