$sort_key = array('type', 'user', 'empire', 'infos', 'note', 'udate', 'water', 'batiments', 'troop'); if ($Recherche['Troop'] > 0) { $sort = 'ORDER BY j.`Troop_date` DESC'; } else { $sort = 'ORDER BY c.`udate` DESC'; } foreach ($sort_key as $v) { if (isset($_GET['sort']) && in_array($_GET['sort'][$v], $invert_sort)) { $sort = 'ORDER BY ' . $v . ' ' . $_GET['sort'][$v] . ' '; } else { if (isset($_GET['sort'][$v])) { $_GET['sort'][$v] = ''; } } $newvalue = array('sort' => array($v => $invert_sort[$_GET['sort'][$v]])); $tpl->AddToRow(Get_string($newvalue), 'sort_' . $v); } $tpl->PushRow(); $sql = <<<sql SELECT udate, c.`ID`, c.`TYPE`, c.`POSIN`, c.`POSOUT`, c.`COORDET`, c.`COORDETOUT`, j.`USER`, j.`EMPIRE`, j.`INFOS`, c.`NOTE`, p.`water`, \tj.`batiments`, j.`troop`, j.`troop_date`, c.`UTILISATEUR`, p.`pID`, p.`Titane`, p.`Cuivre`, p.`Fer`, p.`Aluminium`, p.`Mercure`, p.`Silicium`, p.`Uranium`, p.`Krypton`, \tp.`Azote`, p.`Hydrogene` from `SQL_PREFIX_Coordonnee` c left outer join `SQL_PREFIX_Coordonnee_Joueurs` j on (c.`ID`=j.`jID`) left outer join `SQL_PREFIX_Coordonnee_Planetes` p on (c.`ID`=p.`pID`) {$where}{$sort}{$limit} sql; $mysql_result = DataEngine::sql($sql); $lngmain = language::getinstance()->GetLngBlock('dataengine'); $a_Ress = DataEngine::a_ressources(); $stype = $lngmain['types']['string']; $i = 0; $cmdinput = '<input class="color_row%%rowA%%" type="checkbox" value="1" id="item[%%id%%][%%cmd%%]" name="item[%%id%%][%%cmd%%]" %%bulle%%/>';
$Order = ' ORDER BY `Date` DESC'; } } else { $TriModif = '0'; } $where = ''; if ($_GET['Joueur'] != '') { $where = ' AND m.`Joueur`=\'' . sqlesc($_GET['Joueur']) . '\''; } $axx = array(); foreach (Members::s_perms() as $k => $v) { if ($k == AXX_DISABLED) { continue; } if (Members::CurrentPerms() > $k || Members::CurrentPerms() == AXX_ROOTADMIN) { $axx[$k] = $v; } } require_once TEMPLATE_PATH . 'editmembres.tpl.php'; $tpl = tpl_editmembres::getinstance(); $mysql_result = DataEngine::sql('SELECT m.`Joueur`, m.`Points`, m.`Date`, m.`Economie`, m.`Commerce`, m.`Recherche`, m.`Combat`, m.`Construction`, m.`Navigation`, m.`Grade`, m.`Race`, m.`ship`, u.`Permission` from `SQL_PREFIX_Membres` m, `SQL_PREFIX_Users` u WHERE (m.`Joueur`=u.`Login`)' . $where . $Order); if (mysql_num_rows($mysql_result) == 0) { output::Boink('Membres.php'); } $tpl->header(Get_string(), $TriMembre, $triPermission, $TriPoints, $TriRace, $TriShip, $TriModif); $i = 0; while ($ligne = mysql_fetch_assoc($mysql_result)) { $tpl->row($i++, $ligne, $Grades, $tabrace, $axx); } $tpl->footer(); $tpl->DoOutput();
public function DoOutput($login_msg = '', $register = false) { if (DataEngine::config_key('config', 'closed')) { $closedhtml = <<<ch \t<tr class="text_center color_header"> \t\t<td colspan="3">{$this->lng['currently_closed']}</td> \t</tr> ch; $register = false; } else { $closedhtml = ''; } $action = $register ? $this->BASE_FILE : '?' . Get_string(); $btn_text = $register ? $this->lng['register'] : $this->lng['signin']; $out = <<<BASE <CENTER> <form name="LOG" method="post" action="{$action}"> \t<table class="table_nospacing color_bg"> \t<tr class="text_center color_bigheader"> \t\t<!-- Ne pas modifier --> \t\t<td colspan="3">Empire Universe 2: Data Engine ({$this->version})<br/><br/></td> \t\t<!-- Ne pas modifier /--> \t</tr> {$closedhtml} \t<tr class="color_row0"> \t\t<td>{$this->lng['player']} :</td> \t\t<td><input class="color_row0" tabindex=1 type="text" value="" name="login" /></td> \t\t<td rowspan=2 style='valign=center'><input class="color_row0" type="submit" value="{$btn_text}" /></td> \t</tr> \t<tr class="color_row0"> \t\t<td>{$this->lng['password']} :</td> \t\t<td><input class="color_row0" tabindex=2 type="password" value="" name="mdp" /></td> \t</tr> BASE; if (DE_DEMO) { $out .= addons::getinstance()->Get_Addons('demo')->lng('login'); } if (!$register && DataEngine::config_key('config', 'CanRegister') && !DataEngine::config_key('config', 'closed')) { $out .= <<<LOGIN \t<tr class="color_row0 text_center"> \t\t<td colspan=3><a href='%ROOT_URL%register.php'>{$this->lng['newaccount']}</a></td> \t</tr> LOGIN; } elseif ($register) { $out .= <<<REGISTER \t<tr> \t\t<td colspan=3 align=center>{$this->lng['newaccount_warn']}<br/> \t\t\t<input class="color_row0" type="button" value="{$this->lng['allreadyhaveone']}" Onclick="location.href='./logout.php'" /></td> \t</tr> REGISTER; } if ($login_msg) { $out .= <<<MSG \t<tr> \t\t<td colspan=3 id='titreTDtableau'><font color=red>{$login_msg}</font></td> \t</tr> MSG; } $out .= <<<FOOTER {$login_msg} \t</table> </form> </CENTER> <!-- Ne pas modifier --> <div style="position:absolute; bottom:5px; right:5px"> <address> - Site officiel & support du <a href="https://code.google.com/p/eude/" target="_top" title="Site officiel">Data Engine</a><br/> - <a href="https://code.google.com/p/eude/downloads/list" target="_top" title="Téléchargement">Téléchargement</a> </address> </div> <!-- Ne pas modifier /--> </body></html> FOOTER; $this->PushOutput($out); parent::DoOutput(false); // false false ? menu header }
public function GetPagination($current, $max) { $result = ''; if ($current > 2) { $result .= '<a href="' . $this->BASE_FILE . '?' . Get_string(array('page' => 1)) . '"><img src="%IMAGES_URL%Btn-Debut.png"/></a>'; } if ($current > 1) { $result .= '<a href="' . $this->BASE_FILE . '?' . Get_string(array('page' => $current - 1)) . '"><img src="%IMAGES_URL%Btn-Precedent.png"/></a>'; } $result .= $current . ' / ' . $max; if ($current < $max) { $result .= '<a href="' . $this->BASE_FILE . '?' . Get_string(array('page' => $current + 1)) . '"><img src="%IMAGES_URL%Btn-Suivant.png"/></a>'; } if ($current < $max - 1) { $result .= '<a href="' . $this->BASE_FILE . '?' . Get_string(array('page' => $max)) . '"><img src="%IMAGES_URL%Btn-Fin.png"/></a>'; } return $result; }
* @license Creative Commons 3.0 BY-SA ( http://creativecommons.org/licenses/by-sa/3.0/deed.fr ) * **/ require_once './init.php'; require_once INCLUDE_PATH . 'Script.php'; Members::CheckPermsOrDie('MEMBRES_STATS'); require_once TEMPLATE_PATH . 'stats.tpl.php'; $tpl = tpl_stats::getinstance(); $invert_sort = array('' => 'DESC', 'DESC' => 'ASC', 'ASC' => 'DESC'); if (isset($_GET['act']) && $_GET['act'] == 'pts') { $tpl->SetheaderPoints(); $sort_key = array('Points', 'pts_architecte', 'pts_mineur', 'pts_commercant', 'pts_science', 'pts_amiral', 'pts_guerrier'); $sort = '`Points` DESC'; foreach ($sort_key as $v) { $newvalue = array('sort' => array($v => $invert_sort[$_GET['sort'][$v]])); $tpl->AddToRow(Get_string($newvalue), $v); if (isset($_GET['sort']) && $_GET['sort'][$v]) { $sort = $v . ' ' . $_GET['sort'][$v]; } } $tpl->PushRow(true); $sql = 'SELECT `Joueur`, `Points`, `pts_architecte`, `pts_mineur`, `pts_commercant`, `pts_science`, `pts_amiral`, `pts_guerrier` FROM `SQL_PREFIX_Membres` ORDER BY ' . $sort; $mysql_result = DataEngine::sql($sql); $cols = array('Points', 'pts_architecte', 'pts_mineur', 'pts_commercant', 'pts_science', 'pts_amiral', 'pts_guerrier'); while ($line = mysql_fetch_assoc($mysql_result)) { $tpl->AddToRow($line['Joueur'], -2); foreach ($cols as $key) { $tpl->AddToRow($line[$key], $key); } $tpl->PushRow(); }