$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();
}
