Esempio n. 1
0
 /**
  *
  * @return tpl_upgrade
  */
 public static function getinstance()
 {
     if (!DataEngine::_tpl_defined(get_class())) {
         DataEngine::_set_tpl(get_class(), new self());
     }
     return DataEngine::tpl(get_class());
 }
Esempio n. 2
0
function sql($query)
{
    if (DEBUG_PLAIN) {
        return FB::log($query);
    }
    if (SCRIPT_IN) {
        return DataEngine::sql($query);
    }
    $sql = str_replace('SQL_PREFIX_', SQL_PREFIX_, $query);
    $result = mysql_query($sql) or sqlerror($query);
}
Esempio n. 3
0
 public function Get_Menu()
 {
     $root_url = ROOT_URL;
     $Joueur = $_SESSION['_login'];
     $sqlreq = 'SELECT `ID` FROM `SQL_PREFIX_modules_commandes` WHERE (`DateLivraison` IS NULL) AND `LoginV` = \'' . $Joueur . '\'';
     $mysql_result = DataEngine::sql($sqlreq);
     if (mysql_num_rows($mysql_result) > 0) {
         $bouton = '%BTN_URL%modules_red.png';
         $menu = array('%ADDONS_URL%commerce/commandes_list.php', $bouton, 155, 'DataEngine::CheckPerms("ZZZ_COMMERCE_INDEX")');
         $submenu = array(array('%ADDONS_URL%commerce/commandes_list.php', $bouton, 155, 'DataEngine::CheckPerms("ZZZ_COMMERCE_INDEX")'));
     } else {
         $bouton = '%BTN_URL%modules.png';
         $menu = array('%ADDONS_URL%commerce/index.php', $bouton, 155, 'DataEngine::CheckPerms("ZZZ_COMMERCE_INDEX")');
         $submenu = array(array('%ADDONS_URL%commerce/index.php', $bouton, 155, 'DataEngine::CheckPerms("ZZZ_COMMERCE_INDEX")'));
     }
     return array('insertafter' => 'addon', 'id' => 'commerce', 'onlysub' => true, 'menu' => $submenu);
     // 					"onlysub" => "key", // hmm...
 }
Esempio n. 4
0
    /**
     *
     * @return string html header
     */
    public static function Get_Header()
    {
        $obj = DataEngine::tpl('');
        if ($obj->page_title == "") {
            $title = "EU2: Data Engine v{$obj->version}";
        } else {
            $title = $obj->page_title;
        }
        if ($obj->css_file != '') {
            $nocache = filemtime(ROOT_PATH . $obj->css_file);
            $css = <<<EOF
\t\t<link rel="stylesheet" type="text/css" href="%ROOT_URL%{$obj->css_file}?{$nocache}" media="screen" />
EOF;
        } else {
            $css = '';
        }
        if (DE_DEMO) {
            $stats = addons::getinstance()->Get_Addons('demo')->lng('stats');
        }
        $doctype = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">';
        $doctype = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">';
        $doctype = '<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">';
        $doctype = '<html xmlns="http://www.w3.org/1999/html" lang="' . LNG_CODE . '" xml:lang="' . LNG_CODE . '">';
        return <<<EOF
{$doctype}
<head>
<title>{$title}</title>
{$css}
\t<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
\t<link rel="shortcut icon" href="%BTN_URL%eude.png">
</head>
<body>
{$stats}
<script type="text/javascript" src="%INCLUDE_URL%prototype.js?1.6.1"></script>
<script type="text/javascript" src="%LNG_URL%eude.local.js?{$obj->version}"></script>
<script type="text/javascript" src="%INCLUDE_URL%Script.js?{$obj->version}"></script>
<img src="%ROOT_URL%cron.php" />
<div id="curseur" class="infobulle"></div>
<!--<div id="debug" style="z-index:8; position:fixed; visibility:visible; background-color: #C0C0C0;white-space:nowrap; top:50px; left:5px"></div>-->
%NEW_MESSAGE_ENTRY%
EOF;
    }
Esempio n. 5
0
function initimg($Nbx, $Nby, $taillex, $tailley)
{
    global $colormap, $image, $debug_cl;
    $map = map::getinstance();
    $image = imagecreate($Nbx * $taillex, $Nby * $tailley);
    $background_color = imagecolorallocate($image, 0, 0, 0);
    $blanc = imagecolorallocate($image, 254, 254, 254);
    $rouge = imagecolorallocate($image, 85, 0, 64);
    imagefilledrectangle($image, 0, 0, $Nbx * $taillex, $Nby * $tailley, $background_color);
    // Tableau des couleurs...
    $colormap = DataEngine::config('MapColors');
    $colormap = $colormap[$map->itineraire ? 0 : $map->sc + 1];
    if ($map->itineraire) {
        $map->load_prefs('1;0;0;0;' . $map->sc . ';' . $map->taille . ';0;0;0');
    }
    foreach ($colormap as $k => $c) {
        $R = hexdec(p_substr($c, 1, 2));
        $V = hexdec(p_substr($c, 3, 2));
        $B = hexdec(p_substr($c, 5, 2));
        $colormap[$k] = imagecolorallocate($image, $R, $V, $B);
    }
    $colormap[-1] = $debug_cl = $blanc;
    $colormap[-2] = $rouge;
    // Centre de communication...
    $comlevel = ownuniverse::getinstance()->get_comlevel();
    if (is_array($comlevel)) {
        foreach ($comlevel as $k => $planet) {
            list($CoordsY, $CoordsX) = map::ss2xy($planet['ss']);
            $level = $planet['level'];
            if ($level > 0) {
                ImageFilledEllipse($image, 1 + ($CoordsY - 1) * $taillex + round($taillex / 2) + 1, 1 + ($CoordsX - 1) * $tailley + round($tailley / 2) + 1, $level * 20 * $taillex, $level * 20 * $tailley, $colormap["0"]);
            }
        }
    }
    return $image;
}
<?php

//The included Includes/DataEngine.php contains
//functions to help easily embed the charts and connect to a database.
include "Includes/DataEngine.php";
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text-html; charset=utf-8"/>
<script type="text/javascript" src="../../JSC/jquery-latest.min.js"></script>
<script type="text/javascript" src="../../JSC/JSCharting.js"></script>
<?php 
$de = new DataEngine();
$de->addParameter(new DateTime('2013-03-01'));
$de->addParameter(new DateTime('2013-05-01'));
$de->sqlStatement = 'SELECT TransDate, HighPrice AS MSFT FROM MSFT WHERE TransDate >= ? AND TransDate <= ? ORDER BY TransDate';
$series = $de->getSeries();
?>


		<title>JSCharting  Navigator Axis Markers DB Chart</title>
		  <style type="text/css">/*CSS*/</style>
	</head>
	<body>
	<div id="cc" style="width: 840px; height: 400px;"></div>
	
<script type="text/javascript">
/*
Query a Database using PHP to get a single series using date ranges.
Learn how to:
Esempio n. 7
0
        $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();
Esempio n. 8
0
echo $datas['Paiement'] & UP_CHOIX ? 'checked ' : '';
?>
/></td><td>Vous acceptez un paiement dans une sélection de ressources ci-dessous:
<?php 
for ($i = 0; $i < sizeof($cnhMineraisName); $i++) {
    echo '<br /><input class="color_row0" type="checkbox" name="Paiement_' . ($i + 3) . '" ' . ($datas['Paiement'] & pow(2, $i + 3) ? 'checked ' : '') . '/> <img src=' . IMAGES_URL . $cnhMineraisName[$i] . '.png /> ' . $cnhMineraisName[$i];
}
?>
    </td></tr>
    </table></td>
  </tr>
  <tr class="color_row0">
    <td>Sur quelle(s) planète(s) vous appartenant<br /> acceptez-vous les paiements en ressources?</td>
    <td>
<?php 
$mysql_result = DataEngine::sql('SELECT planet0, coord0, planet1, coord1, planet2, coord2, planet3, coord3, planet4, coord4 FROM SQL_PREFIX_ownuniverse WHERE `UTILISATEUR`=\'' . $Joueur . '\'') or die(mysql_error());
$i = 0;
if ($ownplanetes = mysql_fetch_array($mysql_result)) {
    for ($i = 0; $ownplanetes['planet' . $i] != '' && $i < 5; $i++) {
        if ($i > 0) {
            echo '<br />';
        }
        echo '<input class="color_row0" type="checkbox" name="Planete_' . $i . '" ' . ($datas['Planetes'] & pow(2, $i) ? 'checked ' : '') . '/> ' . $ownplanetes['planet' . $i] . ' aux coordonnées ' . $ownplanetes['coord' . $i];
    }
}
if ($i == 0) {
    echo "<font color=red><b>Vous n'avez pas saisi vos informations dans la partie Ma fiche => Production, veuillez le faire à la page <a href=\"" . ROOT_URL . "ownuniverse.php\" target=\"_blank\">Production</a>.</b></font>";
}
?>
    </td>
  </tr>
Esempio n. 9
0
}
if ($validsession !== true && IS_IMG) {
    header("Content-Type: image/png");
    header("Cache-Control: no-cache, must-revalidate");
    // HTTP/1.1
    header("Expires: Mon, 16 Jul 2008 04:21:44 GMT");
    // HTTP/1.0 Date dans le passé
    require_once CLASS_PATH . 'map.class.php';
    $Taille = 180;
    $image = imagecreate($Taille, 20);
    $background_color = imagecolorallocate($image, 0, 0, 0);
    imagefilledrectangle($image, 0, 0, $Taille, $Taille, $background_color);
    $debug_cl = imagecolorallocate($image, 254, 254, 254);
    map::map_debug($lng['session_lost']);
    imagepng($image);
    imagedestroy($image);
    exit;
}
// $validsession
if ($validsession === true && $_SESSION['_Perm'] < AXX_VALIDATING) {
    $query = 'INSERT INTO `SQL_PREFIX_Log` (`DATE`,`log`,`IP`) VALUES(NOW(),"login,needvalidation:' . $_SESSION['_login'] . '",\'' . $_SESSION['_IP'] . '\')';
    $_SESSION['_login'] = '';
    DataEngine::sql($query);
    output::_DoOutput('<a href="' . DataEngine::config_key('config', 'ForumLink') . '"><p style="color:red">' . $lng['no_axx'] . '</p></a>');
}
if ($validsession !== true) {
    require_once TEMPLATE_PATH . 'login.tpl.php';
    $tpl = tpl_login::getinstance();
    $tpl->page_title = $lng['login_page_title'];
    $tpl->DoOutput($login_msg);
}
Esempio n. 10
0
require_once './fonction.php';
// les cinq planètes
$Planete1 = 1;
$Planete2 = 2;
$Planete3 = 3;
$Planete4 = 4;
$Planete5 = 5;
$Pla1 = false;
$Pla2 = false;
$Pla3 = false;
$Pla4 = false;
$Pla5 = false;
//Check si activé
$coordvalid = false;
if (!addons::getinstance()->Get_Addons('triangulation')->CheckPerms()) {
    DataEngine::NoPermsAndDie();
}
// Si les coordonnées de deux centre de communications avec deux mesure de distance correspondante sont rentrée dans le tableau alors $coordvalid = true;
if (isset($_POST['sys1']) && isset($_POST['sys2']) && isset($_POST['dist11']) && isset($_POST['dist21']) || isset($_POST['sys1']) && isset($_POST['sys3']) && isset($_POST['dist11']) && isset($_POST['dist31']) || isset($_POST['sys3']) && isset($_POST['sys2']) && isset($_POST['dist31']) && isset($_POST['dist21'])) {
    $_SESSION['coord_syst1'] = gpc_esc($_POST['sys1']);
    $_SESSION['coord_syst2'] = gpc_esc($_POST['sys2']);
    $_SESSION['coord_syst3'] = gpc_esc($_POST['sys3']);
    $_SESSION['ccdistance11'] = gpc_esc($_POST['dist11']);
    $_SESSION['ccdistance21'] = gpc_esc($_POST['dist21']);
    $_SESSION['ccdistance31'] = gpc_esc($_POST['dist31']);
    $coordvalid = true;
    // Faire des calculs que s'il y a une entrée
    $Pla1 = $_SESSION['coord_syst1'] != "" && $_SESSION['coord_syst2'] != "" && $_SESSION['ccdistance11'] != "" && $_SESSION['ccdistance21'] != "" || $_SESSION['coord_syst1'] != "" && $_SESSION['coord_syst3'] != "" && $_SESSION['ccdistance11'] != "" && $_SESSION['ccdistance31'] != "" || $_SESSION['coord_syst3'] != "" && $_SESSION['coord_syst2'] != "" && $_SESSION['ccdistance31'] != "" && $_SESSION['ccdistance21'] != "";
    $dist11 = $_SESSION['ccdistance11'];
    $dist21 = $_SESSION['ccdistance21'];
    $dist31 = $_SESSION['ccdistance31'];
Esempio n. 11
0
    </table>
      </td>
  </tr>
</table>
<p align="center">
<?php 
if ($datas_id > 0) {
    ?>
<input class="color_row0" type="submit" name="submit" id="submit" value="Sauver">
<input class="color_row0" type="submit" name="submit" id="submit" value="Sauver et retour">
<?php 
}
?>
<input class="color_row0" type="submit" name="submit" id="submit" value="Sauver sous nouveau">
<?php 
if (DataEngine::CheckPerms('ZZZ_COMMERCE_TPL_DELETE')) {
    ?>
<input class="color_row0" type="submit" name="submit" id="submit" value="SUPPRIMER">
<?php 
}
?>
<input class="color_row0" type="reset" name="Reset" id="Reset" value="Réinitialiser">
</p>
</form>
<br />
<center><a href='template_list.php'>Retourner à la liste des templates de module...</a></center>

<!-- FIN CODE LIBRE -->
</BODY></HTML>

Esempio n. 12
0
<?php

//The included Includes/DataEngine.php contains
//functions to help easily embed the charts and connect to a database.
include "Includes/DataEngine.php";
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text-html; charset=utf-8"/>
<script type="text/javascript" src="../../JSC/jquery-latest.min.js"></script>
<script type="text/javascript" src="../../JSC/JSCharting.js"></script>
<?php 
$de = new DataEngine();
$de->sqlStatement = 'SELECT Code,Sales FROM Locations';
$arrayData = $de->getArrayData();
?>


		<title>JSCharting  Map Thematic Sales DB Chart</title>
		  <style type="text/css">/*CSS*/</style>
	</head>
	<body>
	<div id="cc" style="width: 740px; height: 480px">
    </div>
	
<script type="text/javascript">
/*
Query a MySQL Database using PHP to get thematic map data.
Learn how to:
Esempio n. 13
0
function formatarr(&$value, $key)
{
    global $lng;
    $value = sprintf($lng['listing_playerrow'], $key, DataEngine::format_number($value, true));
    return true;
}
Esempio n. 14
0
    for ($i = 0; $i < $nb_planet; $i++) {
        $tpl->Planet_Header($cleandata[$i]);
        if (isset($cleandata[$i]['percent_' . $keys[0]])) {
            $tpl->Add_PercentRow($cleandata[$i], $lng['row_concentration'], 'percent_', 'row0');
        }
        $tpl->Add_RessRow($cleandata[$i], $lng['row_prod/h'], '', 'row1');
        $tpl->Add_Current_Ress($cleandata[$i]);
    }
    $tpl->RowHeader();
    $tpl->Add_RessRow($total_all, $lng['row_Total'], '', 'row0');
    if ($ownuniverse->get_race() != '') {
        $tpl->Add_PercentRow(DataEngine::a_race_ressources($ownuniverse->get_race()), $lng['row_race_needed'], '', 'row1');
    }
    //------------------------------------------------------------------------------
    $BatimentsName = DataEngine::a_batiments();
    $tpl->SetheaderBatiments();
    foreach ($BatimentsName as $k => $name) {
        $tpl->AddToRow($name, $k);
    }
    $tpl->PushRow();
    foreach ($cleandata as $k => $planet) {
        $id = $k % 2;
        $tpl->AddToRow($id, 'class');
        $tpl->AddToRow($planet['Name'], 'Name');
        foreach ($BatimentsName as $k => $name) {
            $tpl->AddToRow(DataEngine::format_number($planet[$k]), $k);
        }
        $tpl->PushRow();
    }
}
$tpl->DoOutput();
Esempio n. 15
0
if (isset($_POST['pwd']) && !($_SESSION['_login'] == 'test' && DE_DEMO)) {
    $query = 'UPDATE `SQL_PREFIX_Users` SET `Password`=md5(\'' . sqlesc($_POST['pwd'], false) . '\') WHERE `Login`=\'' . $_SESSION['_login'] . '\'';
    DataEngine::sql($query);
}
$mysql_result = DataEngine::sql('Select m.`Joueur`, m.`Points`, m.`Economie`, m.`Commerce`, m.`Recherche`, m.`Combat`, m.`Construction`, m.`Navigation`, m.`Race`, m.`ship`, m.`Titre`, m.`GameGrade`, m.`pts_architecte`, m.`pts_mineur`, m.`pts_science`, m.`pts_commercant`, m.`pts_amiral`, m.`pts_guerrier`, g.`Grade` from `SQL_PREFIX_Membres` m, `SQL_PREFIX_Grade` g WHERE m.`Joueur`=\'' . $_SESSION['_login'] . '\' AND (m.`Grade`=g.`GradeId`)');
$ligne = mysql_fetch_assoc($mysql_result);
require_once TEMPLATE_PATH . 'mafiche.tpl.php';
$tpl = tpl_mafiche::getinstance();
$tpl->page_title = $lng['page_title'];
$tpl->header($ligne);
$tpl->add_row($lng['POINTS'], 'Points', $ligne['Points']);
$tpl->add_row($lng['pts_architecte'], 'pts_architecte', $ligne['pts_architecte']);
$tpl->add_row($lng['pts_mineur'], 'pts_mineur', $ligne['pts_mineur']);
$tpl->add_row($lng['pts_science'], 'pts_science', $ligne['pts_science']);
$tpl->add_row($lng['pts_commercant'], 'pts_commercant', $ligne['pts_commercant']);
$tpl->add_row($lng['pts_amiral'], 'pts_amiral', $ligne['pts_amiral']);
$tpl->add_row($lng['pts_guerrier'], 'pts_guerrier', $ligne['pts_guerrier']);
$tpl->add_row($lng['Commerce'], 'Commerce', $ligne['Commerce']);
$tpl->add_row($lng['Recherche'], 'Recherche', $ligne['Recherche']);
$tpl->add_row($lng['Combat'], 'Combat', $ligne['Combat']);
$tpl->add_row($lng['Construction'], 'Construction', $ligne['Construction']);
$tpl->add_row($lng['Economie'], 'Economie', $ligne['Economie']);
$tpl->add_row($lng['Navigation'], 'Navigation', $ligne['Navigation']);
$tpl->add_row($lng['Race'], '', $ligne['Race']);
//$tpl->add_row_select($lng['Race'], '', $tabrace, $ligne['Race']);
$tpl->add_row_select($lng['lastship'], 'ship', DataEngine::a_shiplist(), $ligne['ship']);
$tpl->add_row($lng['Titre'], '', $ligne['Titre']);
$tpl->add_row($lng['grade_ingame'], '', $ligne['GameGrade']);
$tpl->add_row($lng['grade_eude'], '', $ligne['Grade']);
$tpl->footer();
$tpl->doOutput();
Esempio n. 16
0
            $modifier = '&nbsp;(<font color="' . ($basket->vendors[$modid][$j]['Modifier'] > 0 ? "#ff0000" : "#00ff00") . '">' . $basket->vendors[$modid][$j]['Modifier'] . '%</font>)';
        } else {
            $modifier = '';
        }
        // 'modvendor_'.$modid.'_'.$j
        echo $basket->vendors[$modid][$j]['Login'] . $modifier . '</td><td valign=middle>' . $basket->StringPaiements($basket->vendors[$modid][$j]['Paiement'], '', '<br>') . '</td></tr>';
    }
    echo "\n";
}
echo '<tr class="text_center color_row0" valign=top><td>TOTAL</td><td align=center>' . $basket->total . ' article' . ($basket->total > 1 ? 's' : '') . '<br>' . $basket->nbtotal . ' module' . ($basket->nbtotal > 1 ? 's' : '') . '</td><td><table border=0 width=100% cellpadding=0 cellspacing=0>';
foreach ($cnhMineraisName as $value) {
    if ($basket->totalitems[$value] > 0) {
        echo '<tr class="text_center color_row0"><td><img src=' . IMAGES_URL . $value . '.png >&nbsp;' . $value . '</td><td>&nbsp;</td><td align=right>' . DataEngine::format_number($basket->totalitems[$value]) . '</td><td colspan=2>&nbsp;</td></tr>';
    }
}
echo '<tr class="text_center color_row0"><td colspan=3><hr size=1></td></tr><tr class="text_center color_row0" STYLE="font-weight:bold;"><td><img src="images/ressources.png" />&nbsp;TOTAL</td><td>&nbsp;</td><td align=right>' . DataEngine::format_number($basket->totalress) . "</td></tr>";
echo "</table></td><td colspan=2>&nbsp;</td></tr>\n";
?>
<tr class="text_center color_row0"><td colspan=5 align=right><?php 
echo $defaultbutton;
?>
</td></tr>
</table></form>


<!-- FIN CODE LIBRE -->
</BODY></HTML>

<?php 
require_once TEMPLATE_PATH . 'sample.tpl.php';
$tpl = tpl_sample::getinstance();
Esempio n. 17
0
    $iv = $message->{'iv'};
    $decrypted = trim(mcrypt_decrypt(MCRYPT_RIJNDAEL_128, substr(sha1($user_row['cb_key']), 0, 32), base64_decode($encrypted), MCRYPT_MODE_CBC, base64_decode($iv)), "..");
    $order = json_decode($decrypted, true);
    if ($order['transactionType'] == 'TEST') {
        $user_sql = "UPDATE 202_users_pref\n                     SET cb_verified=1\n                     WHERE user_id='" . $mysql['user_id'] . "'";
        $user_results = $db->query($user_sql);
    } else {
        if ($order['transactionType'] == 'SALE') {
            $mysql['click_id'] = $db->real_escape_string($order['trackingCodes'][0]);
            $mysql['click_payout'] = $db->real_escape_string($order['totalAccountAmount']);
            $cpa_sql = "SELECT 202_cpa_trackers.tracker_id_public, 202_trackers.click_cpa FROM 202_cpa_trackers LEFT JOIN 202_trackers USING (tracker_id_public) WHERE click_id = '" . $mysql['click_id'] . "'";
            $cpa_result = $db->query($cpa_sql);
            $cpa_row = $cpa_result->fetch_assoc();
            $mysql['click_cpa'] = $db->real_escape_string($cpa_row['click_cpa']);
            if ($mysql['click_cpa']) {
                $sql_set = "click_cpc='" . $mysql['click_cpa'] . "', click_lead='1', click_filtered='0', click_payout='" . $mysql['click_payout'] . "'";
            } else {
                $sql_set = "click_lead='1', click_filtered='0', click_payout='" . $mysql['click_payout'] . "'";
            }
            $click_sql = "\n            UPDATE\n                202_clicks \n            SET\n                " . $sql_set . "\n            WHERE\n                click_id='" . $mysql['click_id'] . "'    \n        ";
            $db->query($click_sql);
            $click_sql = "\n            UPDATE\n                202_clicks_spy \n            SET\n                " . $sql_set . "\n            WHERE\n                click_id='" . $mysql['click_id'] . "'    \n        ";
            $db->query($click_sql);
            //set dirty hour
            $de = new DataEngine();
            $data = $de->setDirtyHour($mysql['click_id']);
        }
    }
} else {
    die("Missing Mcrypt!");
}
Esempio n. 18
0
                    echo '<tr class="color_row0"><td><img src=' . IMAGES_URL . $value . '.png>&nbsp;' . $value . '</td><td>&nbsp;</td><td align=right>' . DataEngine::format_number($vlist[$oldi]['Ress'][$value]) . '</td></tr>';
                }
            }
            echo '<tr class="color_row0"><td colspan=3><hr size=1></td></tr><tr class="color_row0" STYLE="font-weight:bold;"><td><img src="images/ressources.png" />&nbsp;TOTAL</td><td>&nbsp;</td><td align=right>' . DataEngine::format_number($vlist[$oldi]['RessTotal']) . '</td></tr>';
            echo "</table></td>";
        }
        echo "</tr>\n";
    }
    // Total général
    echo '<tr class="text_center color_row0" valign=top><td>TOTAL GENERAL</td><td align=center>' . $nvendor . ' vendeur' . ($nvendor > 1 ? 's' : '') . '<br>' . $basket->total . ' article' . ($basket->total > 1 ? 's' : '') . '<br>' . $basket->nbtotal . ' module' . ($basket->nbtotal > 1 ? 's' : '') . '</td><td><table border=0 width=100% cellpadding=0 cellspacing=0>';
    foreach ($cnhMineraisName as $value) {
        if ($vlist['RessourcesNB'][$value] > 0) {
            echo '<tr class="color_row0"><td><img src=' . IMAGES_URL . $value . '.png>&nbsp;' . $value . '</td><td>&nbsp;</td><td align=right>' . DataEngine::format_number($vlist['RessourcesNB'][$value]) . '</td><td colspan=2>&nbsp;</td></tr>';
        }
    }
    echo '<tr><td colspan=3><hr size=1></td></tr><tr class="color_row0" STYLE="font-weight:bold;"><td><img src="images/ressources.png" />&nbsp;TOTAL</td><td>&nbsp;</td><td align=right>' . DataEngine::format_number($vlist['RessourcesNBTotal']) . '</td></tr>';
    echo "</table></td></tr>\n";
    ?>
<tr class="text_center color_row0"><td colspan=3 align=right><?php 
    echo $defaultbutton;
    ?>
</td></tr>
</table></form>
<?php 
}
?>

<!-- FIN CODE LIBRE -->
</BODY></HTML>

<?php 
Esempio n. 19
0
 public function FillVendors()
 {
     for ($i = 0; $i < sizeof($this->items); $i++) {
         $modid = $this->items[$i]['ID'];
         $mysql_result = DataEngine::sql('
     SELECT u.`Login`, c.`Paiement`, u.`Modifier` FROM `SQL_PREFIX_Modules_Users_Config` c
     LEFT JOIN `SQL_PREFIX_Modules_Users` u ON c.`Login` = u.`Login`
     WHERE `CommerceType` <= 1 AND `Module_ID` = \'' . $modid . '\' ORDER BY u.`Login`;
   ') or die(mysql_error());
         $this->vendors[$modid][0]['Paiement'] = 0;
         $j = 1;
         while ($ligne = mysql_fetch_array($mysql_result)) {
             $this->vendors[$modid][$j]['Login'] = $ligne['Login'];
             $this->vendors[$modid][$j]['Paiement'] = $ligne['Paiement'];
             $this->vendors[$modid][$j]['Modifier'] = $ligne['Modifier'];
             $j++;
         }
         $this->vendors[$modid][0]['Total'] = $j - 1;
     }
 }
 /**
  * Ajout d'un joueur
  * @param string $user Nom du joueur
  * @param md5 $pass pass en md5
  * @param integer $axx niveau d'accès souhaité
  * @param integer $points nombre de points
  * @param integer $grade id du grade dans l'empire
  */
 public static function NewUser($user, $md5pass, $axx = AXX_VALIDATING, $points = 0, $grade = 3)
 {
     DataEngine::sql('INSERT INTO `SQL_PREFIX_Users` VALUES(\'' . $user . '\',\'' . $md5pass . '\',' . $axx . ')');
     DataEngine::sql('INSERT INTO `SQL_PREFIX_Membres` (`Joueur`,`Points`,`Date`,`Grade`) ' . 'VALUES(\'' . sqlesc($user) . '\',\'' . $points . '\',now(),' . $grade . ')');
     addons::getinstance()->NewUser($user);
 }
Esempio n. 21
0
<?php

//The included Includes/DataEngine.php contains
//functions to help easily embed the charts and connect to a database.
include "Includes/DataEngine.php";
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text-html; charset=utf-8"/>
<script type="text/javascript" src="../../JSC/jquery-latest.min.js"></script>
<script type="text/javascript" src="../../JSC/JSCharting.js"></script>
<?php 
$de = new DataEngine();
$de->sqlStatement = 'SELECT * FROM Employees';
$de->dataFields = 'name=name,yAxis=salary';
$series = $de->getSeries();
?>


		<title>JSCharting  Step Line DB Chart</title>
		  <style type="text/css">/*CSS*/</style>
	</head>
	<body>
	<div id="cc" style="width: 640px; height: 400px">
</div>
	
<script type="text/javascript">
/*
Query a MySQL Database using PHP to get a data series.
Learn how to:
Esempio n. 22
0
<?php

// Partie standard d'EU2de
require_once '../../init.php';
require_once INCLUDE_PATH . 'Script.php';
require_once TEMPLATE_PATH . 'sample.tpl.php';
$tpl = tpl_sample::getinstance();
// Déclaration variables
$Joueur = $_SESSION['_login'];
require_once 'cnh_fonctions.php';
Init_Addon();
if (!DataEngine::CheckPerms('ZZZ_COMMERCE_INDEX')) {
    output::Boink(ROOT_URL . 'index.php');
}
// DEBUT CODE LIBRE
// FIN CODE LIBRE
?>

<HTML>
<HEAD>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</HEAD>
<BODY>

<!-- DEBUT CODE LIBRE -->

<?php 
if (isset($_GET['sousmenu'])) {
    //    cnhToolbar(3, "menu_", 128, $_GET['sousmenu']);
    cnhTB(1, "menu_", 128, $_GET['sousmenu']);
} elseif (empty($Joueur)) {
Esempio n. 23
0
 $tpl->AddToRow($stype[$ligne['TYPE']], 'type');
 $tpl->AddToRow($coords, 'coords');
 if ($ligne['EMPIRE']) {
     $shw_emp = wordwrap($ligne['EMPIRE'], 20, '<br/>', true);
     $tpl->AddToRow($ligne['USER'] ? $ligne['USER'] . '<br/>' . $shw_emp : $shw_emp, 'player');
 } else {
     $tpl->AddToRow($ligne['USER'] ? $ligne['USER'] : '******', 'player');
 }
 $tpl->AddToRow($ligne['INFOS'] ? $ligne['INFOS'] : '-', 'infos');
 $tpl->AddToRow($ligne['NOTE'], 'notes');
 $tpl->AddToRow($ligne['water'], 'water');
 $tpl->AddToRow($ligne['batiments'], 'batiments');
 if (!isset($ligne['troop'])) {
     $ligne['troop'] = -1;
 }
 $tpl->AddToRow(DataEngine::format_number($ligne['troop'], true), 'troop');
 if (isset($ligne['troop_date'])) {
     $tpl->AddToRow(bulle(sprintf($lng['search_troopdate'], date($lng['search_date_long_format']), $ligne['troop_date'])), 'troop_date');
 } else {
     $tpl->AddToRow('', 'troop_date');
 }
 $tmp = sprintf($lng['search_userdate'], $ligne['UTILISATEUR'], date($lng['search_date_long_format'], $ligne['udate']));
 $tpl->AddToRow(bulle($tmp), 'userdate');
 $tpl->AddToRow(date($lng['search_date_short_format'], $ligne['udate']), 'udate');
 if (Members::CheckPerms('CARTOGRAPHIE_DELETE')) {
     $tpl->AddToRow($cmdinput, 'cmd_delete');
     $tpl->AddToRow('delete', 'cmd');
     $tpl->AddToRow(bulle($lng['search_bulle_cmd_delete']), 'bulle');
 } else {
     $tpl->AddToRow('', 'cmd_delete');
 }
Esempio n. 24
0
if ($cur >= count($sqls)) {
    error('Incorrect $cur');
}
sql($sqls[$cur]);
if (file_put_contents($lockfile, $cur + 1) === false) {
    error('I/O Error .lock ' . $cur);
}
$xml = str_replace('%msg%', 'Installation de la base de donnée en cours', $xml);
$xml = str_replace('%haserror%', '0', $xml);
if ($cur + 1 >= count($sqls)) {
    $xml = str_replace('%done%', '1', $xml);
} else {
    $xml = str_replace('%done%', '0', $xml);
}
if (INSTALLED) {
    DataEngine::sql_log();
}
die($xml);
function sql($sql)
{
    $sql = str_replace('%%username%%', mysql_real_escape_string(gpc_esc($_POST['username'])), $sql);
    $sql = str_replace('%%password%%', mysql_real_escape_string(gpc_esc($_POST['password'])), $sql);
    $empire = gpc_esc($_POST['empire']);
    $sql = str_replace('%%empirename%%', mysql_real_escape_string($empire), $sql);
    $sql = str_replace('%%empirenamelen%%', p_strlen($empire), $sql);
    $board = gpc_esc($_POST['board']);
    $sql = str_replace('%%boardname%%', mysql_real_escape_string($board), $sql);
    $sql = str_replace('%%boardnamelen%%', p_strlen($board), $sql);
    $sql = str_replace('SQL_PREFIX_', SQL_PREFIX_, $sql);
    FB::log($sql);
    if (!DEBUG_PLAIN) {
Esempio n. 25
0
//The included Includes/DataEngine.php contains
//functions to help easily embed the charts and connect to a database.
include "Includes/DataEngine.php";
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text-html; charset=utf-8"/>
<script type="text/javascript" src="../../JSC/jquery-latest.min.js"></script>
<script type="text/javascript" src="../../JSC/JSCharting.js"></script>
<?php 
$startDate = new DateTime('2014-10-1');
$endDate = new DateTime('2014-10-31 23:59:59');
$title = 'Sales From ' . date_format($startDate, 'm/d/Y') . ' to ' . date_format($endDate, 'm/d/Y') . ',  Total : %sum';
$de = new DataEngine();
$de->addParameter($startDate);
$de->addParameter($endDate);
$de->sqlStatement = 'SELECT OrderDate AS Month, SUM(Total) AS Sales FROM Orders
WHERE OrderDate >=? And OrderDate <=?
    GROUP BY DAY(OrderDate)
    ORDER BY DAY(OrderDate);';
$de->dataFields = 'xAxis=Month,yAxis=Sales';
//default setting
$de->dateGrouping = "Month";
$series = $de->getSeries();
?>


		<title>JSCharting  Month DB Chart</title>
		  <style type="text/css">/*CSS*/</style>
 public function CheckPerms()
 {
     return DataEngine::CheckPerms('STATS_COMBAT');
 }
Esempio n. 27
0
    if ($Grade['Rattachement'] == 0) {
        $levels[0][$id] = $Grade['GradeId'];
    }
}
$lid = 0;
do {
    $level = $levels[$lid];
    foreach ($Grades as $id => $Grade) {
        if (array_search($Grade['Rattachement'], $level) !== false) {
            $levels[$lid + 1][$id] = $Grade['GradeId'];
        }
    }
    $lid++;
} while ($lid < count($levels));
$players = array();
$mysql_result = DataEngine::sql('SELECT `Joueur`, `Grade`, `Points`, `Economie`, `Commerce`, `Recherche`, `Combat`, `Construction`, `Navigation` from `SQL_PREFIX_Membres` ORDER BY `Grade`, `Joueur` ASC');
while ($ligne = mysql_fetch_assoc($mysql_result)) {
    $players[$ligne['Grade']][] = $ligne;
}
$tpl->header();
foreach ($levels as $levelkey => $level) {
    $tpl->level_header();
    foreach ($level as $GradeKey => $GradeId) {
        $tpl->level_grade($Grades[$GradeKey]['Grade']);
    }
    $tpl->level_grade_sep();
    foreach ($level as $GradeKey => $GradeId) {
        if (!isset($players[$GradeId])) {
            $tpl->level_players_empty();
            continue;
        }
Esempio n. 28
0
            echo "<br /><center><b>Données non reconnues.</b></center><br /><br />";
        }
    }
}
if ($bcontinue) {
    ?>
<form name="form1" method="post" action="">
<table border="1" align="center" cellpadding="3" cellspacing="0" width=80%>
  <tr class="color_row0">
    <td>Pour importer des données, il vous suffit de sélectionner une page du jeu (CTRL-A), de la copier entièrement (CTRL-C) puis de la coller dans le champs à droite (CTRL-V).<br />
    <br />
    Vous pouvez importer:
    <ul>
    <li><b>Liste des modules</b> que vous pouvez fabriquer (<i>Bâtiment -> Chantier Naval -> Modules</i>).</li>
<?php 
    if (DataEngine::CheckPerms('ZZZ_COMMERCE_TPL_INSERT')) {
        ?>
    <li><b>Template de module</b> (<i>Bâtiment -> Chantier Naval -> Modules -> Click sur Module concerné</i>).</li>
<?php 
    }
    ?>
    </ul></td>
    <td>
      Données à interpréter: <textarea class="color_row0" name="RawData" cols="45" rows="5" wrap="virtual" id="RawData"></textarea><br />
      <input class="color_row0" type="checkbox" name="ReplaceAll" id="ReplaceAll" /> Avant cette importation, remise à zéro de la liste des modules que vous pouvez fabriquer.
    </td>
  </tr>
</table>
<br />
<center><input class="color_row0" type="submit" name="submit" id="submit" value="Interpréter"></center>
</form>
 public function __construct()
 {
     $this->reset();
     $this->lng = language::getinstance()->GetLngBlock('cartographie');
     $this->lngmain = language::getinstance()->GetLngBlock('dataengine');
     $this->allys = DataEngine::config('EmpireAllys');
     $this->wars = DataEngine::config('EmpireEnnemy');
     if (!is_array($this->allys) && $this->allys != '') {
         $this->allys = array($this->allys);
     }
     if (!is_array($this->wars) && $this->wars != '') {
         $this->wars = array($this->wars);
     }
     if (!is_array($this->allys) && $this->allys == '') {
         $this->allys = array();
     }
     if (!is_array($this->wars) && $this->wars == '') {
         $this->wars = array();
     }
     if (is_array($this->allys)) {
         $this->allys = parser::getinstance()->cleaning_array($this->allys);
     }
     if (is_array($this->wars)) {
         $this->wars = parser::getinstance()->cleaning_array($this->wars);
     }
     $this->detelespooler = array();
 }
Esempio n. 30
0
    public function init_map($custom = '')
    {
        // init ici
        global $vortex_a, $CurrSS, $CurrSS_a;
        $this->Parcours();
        // variables
        $vortex_a = array();
        $CurrSS = 0;
        $CurrSS_a = array();
        /// RÉCUPÉRATION DES VORTEX (POSOUT) ///
        if ($this->vortex) {
            $sql = 'SELECT `ID`, `POSIN`, `POSOUT` from `SQL_PREFIX_Coordonnee` where `Type`=1';
            $mysql_result = DataEngine::sql($sql);
            while ($line = mysql_fetch_assoc($mysql_result)) {
                $vortex_a[$line['POSOUT']][$line['ID']]['POSIN'] = $line['POSOUT'];
                $vortex_a[$line['POSOUT']][$line['ID']]['POSOUT'] = $line['POSIN'];
                $vortex_a[$line['POSOUT']][$line['ID']]['TYPE'] = 1;
            }
            mysql_free_result($mysql_result);
        }
        /// TRAITEMENT DES CORPS CÉLESTES ///
        /// filtre spécial...
        $if = array();
        if (!$this->ennemis && !$this->allys && $this->joueur) {
            $if[] = 'IF(c.`TYPE` in (3,5), 0, c.`TYPE`) as TYPE';
        }
        if (!$this->ennemis && $this->allys) {
            $if[] = 'IF(c.`TYPE`=5, 0, c.`TYPE`) as TYPE';
        }
        if ($this->ennemis && !$this->allys) {
            $if[] = 'IF(c.`TYPE`=3, 0, c.`TYPE`) as TYPE';
        }
        /// filtre in type:
        $in = array();
        if ($this->joueur) {
            $in[] = 0;
        }
        if ($this->vortex) {
            $in[] = 1;
        }
        if ($this->planete) {
            $in[] = 2;
        }
        if ($this->allys || $this->joueur) {
            $in[] = 3;
        }
        if ($this->asteroide) {
            $in[] = 4;
        }
        if ($this->pnj) {
            $in[] = 6;
        }
        if ($this->ennemis || $this->joueur) {
            $in[] = 5;
        }
        if (count($in) > 0 && count($in) < 7) {
            $in = 'AND ( `TYPE` IN (' . implode(',', $in) . ')';
        } else {
            $in = '';
        }
        /// filtre au cas par cas:
        $cas = array();
        if (!$this->joueur) {
            $cas[] = '(`Type`=0 AND m.`Joueur`=\'' . $_SESSION['_login'] . '\')';
        }
        if ($this->joueur) {
            $if[] = 'IFNULL(g.`Grade`,\'\') as Grade';
            $if[] = 'IFNULL(m.`Joueur`,\'\') as Joueur';
        }
        // compilation des filtres
        if (count($if) > 0) {
            $if = ', ' . trim(implode(', ', $if));
        } else {
            $if = '';
        }
        if (count($cas) > 0) {
            if ($in != '') {
                $where = $in . ' OR ' . implode(' OR ', $cas) . ' ) ';
            } else {
                $where = ' AND ' . implode(' OR ', $cas) . ' ';
            }
        } else {
            if ($in != '') {
                $where = $in . ' ) ';
            }
        }
        if ($custom == '') {
            $custom = '1 ';
        }
        $where = 'WHERE ' . $custom . $where;
        $where = $where . ' ORDER BY `POSIN` ASC';
        $sql = <<<sql
SELECT c.`ID`, c.`TYPE`, c.`POSIN`, c.`POSOUT`, j.`USER`, j.`INFOS`, j.`EMPIRE`
    {$if} FROM `SQL_PREFIX_Coordonnee` c
left outer join `SQL_PREFIX_Coordonnee_Joueurs` j on (c.id=j.jid)
left outer join `SQL_PREFIX_Membres` m on (j.`USER`=m.`Joueur`)
left outer join `SQL_PREFIX_Grade` g on (m.`Grade`=g.`GradeId`)
    {$where}
sql;
        $mysql_result = DataEngine::sql($sql);
        return $mysql_result;
    }