function checkToken($Pseudo, $tokens)
{
$BD = new BD('user');
$user = $BD->select('pseudo', $Pseudo);
if ($tokens == $user->token) {
return true;
} else {
return false;
}
}
function recupEffectueTrajet($idt)
{
$BD = new BD('effectue');
$res1 = $BD->selectMult("idtrajet", $idt);
$BD->setUsedTable('user');
foreach ($res1 as $tuple) {
$donnees[] = $BD->select("iduser", $tuple->iduser);
}
return $donnees;
}
function activation($Mail, $Tokens)
{
$BD = new BD("user");
$user = $BD->select("mail", $Mail);
if ($user->tokens == $Tokens) {
$BD->update("banni", 0, "iduser", $user->iduser);
$BD->update("tokens", 0, "iduser", $user->iduser);
return "ok";
} else {
return "Validation impossible ...";
}
}
function recupTrajetReserv($id)
{
$BD = new BD('effectue');
$res = $BD->selectMult("iduser", $id);
$BD->setUsedTable('trajet');
foreach ($res as $tuple) {
if ($tuple->idtrajet) {
$result[] = $BD->select("idtrajet", $tuple->idtrajet);
}
}
return $result;
}
function recupJeuInscrit($iduser)
{
$BD = new BD('joueur');
$listeJoueur = $BD->selectMult('iduser', $iduser);
$listeJeux = array();
$BD->setUsedTable('section');
foreach ($listeJoueur as $joueur) {
if (!empty($joueur)) {
$listeJeux[] = $BD->select('idjeux', $joueur->idjeux);
}
}
return $listeJeux;
}
function changepass($Mail, $Tokens, $Pass)
{
$BD = new BD("user");
$user = $BD->select("mail", $Mail);
if ($user->tokens == $Tokens) {
$Pass2 = sha1($Pass);
$BD->update("mdp", $Pass2, "iduser", $user->iduser);
$BD->update("tokens", NULL, "iduser", $user->iduser);
return "ok";
} else {
return "Changement impossible ...";
}
}
-->
<object type="text/html" data="http://www.youtube.com/embed/d4JnshyKOOQ?border=0&playerapiid=ytplayer&version=3&modestbranding=0&rel=0&showinfo=0&controls=0&iv_load_policy=3&autoplay=0&loop=1">
</object>
<!-- <iframe src="http://www.youtube.com/embed/d4JnshyKOOQ?enablejsapi=1&playerapiid=ytplayer&version=3&modestbranding=1&autoplay=1&loop=1&border=0&showinfo=0&rel=0&controls=0&enablejsapi=1&iv_load_policy=3" ></iframe> -->
<?php
} elseif (!isset($_GET['jeu'])) {
?>
<img src="<?php
echo Config::$path['images'] . 'bg2.jpg';
?>
" alt="default">
<?php
} else {
$jeu = $BD->select('idjeux', $_GET['jeu']);
?>
<img src="<?php
echo $jeu->image;
?>
" alt="default">
<?php
}
?>
<img src="<?php
if (!isset($_GET['jeu'])) {
echo Config::$path['images'] . 'bg2.jpg';
} else {
$jeu = $BD->select('idjeux', $_GET['jeu']);
echo $jeu->image;
/**
* Function start_page()
*
* Construit le header en html
* @param string $titre Le nom de la page
*/
function start_page($titre, $nummenu)
{
?>
<!doctype html>
<html lang="fr">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0"/>
<title>Share2go : <?php
echo $titre;
?>
</title>
<link rel="stylesheet" href='/S2go/dev/webroot/css/style.css'/>
<link href="http://51.255.41.18/S2go/dev/webroot/img/favicon.ico" type="image/x-icon" rel="icon"/>
<link href="http://51.255.41.18/S2go/dev/webroot/img/favicon.ico" type="image/x-icon" rel="shortcut icon"/>
</head>
<body>
<div id="main">
<?php
if ($nummenu == 1) {
?>
<div class="menu">
<div class="menu-logo">
<a class="menu-logo-link" href="index.php"></a>
</div>
<div class="js-menu-btn"></div>
<nav class="menu-navigation">
<ul class="navigation-ul">
<li class="menu-list">
<a class="menu-link <?php
if ($titre == "Home") {
echo 'current';
}
?>
" href="index.php">Home</a>
</li>
<li class="menu-list"><a class="menu-link <?php
if ($titre == "Profil") {
echo 'current';
}
?>
" href="profil.php">Profil</a></li>
<li class="menu-list">
<a class="menu-link <?php
if ($titre == "Messagerie") {
echo 'current';
}
?>
" href="messagerie.php">Messages
<!-- <span class="link-notif"><i class="link-notif-i">3</i></span> -->
<?php
if ($_SESSION['lu'] == false && isset($_SESSION['nbnewmess']) && $_SESSION['nbnewmess'] != 0) {
echo "<span class='link-notif'><i class='link-notif-i'>" . $_SESSION['nbnewmess'] . "</i></span>";
}
?>
<!-- Marche pas ! Pour afficher les bonnes notifs -->
</a>
</li>
<li class="menu-list"><a
class="menu-link <?php
if ($titre == "Proposer un trajet" || $titre == "Enregistrer un vehicule") {
echo 'current';
}
?>
" href="proposer.php">Nouveau trajet</a></li>
</ul>
</nav>
<div class="menu-user right">
<?php
$BD = new BD('user');
$user = $BD->select('iduser', $_SESSION['id']);
?>
<span class="user-avatar left"><img src="<?php
echo IMG . '/' . $user->avatar;
?>
" alt="avatar"></span>
<a class="menu-link right logout0" href="../Controller/logout.php">Se déconnecter</a>
<div class="logout1"><a href="../Controller/logout.php"></a></div>
</div>
</div><!-- // menu -->
<?php
}
if ($nummenu == 2) {
?>
<div class="menu">
<div class="menu-logo">
<a class="menu-logo-link" href="index.php"></a>
</div>
<div class="menu-user right">
<a class="btn2 blue2 right" href="./login.php">Se connecter</a>
</div>
</div><!-- // menu -->
<?php
}
if ($nummenu == 3) {
?>
<div class="menu">
<div class="menu-logo">
<a class="menu-logo-link" href="index.php"></a>
</div>
<div class="menu-user right">
<a class="btn2 red3 right" href="../Controller/inscription.php">Inscription</a>
</div>
</div><!-- // menu -->
<?php
}
}
<?php
require_once "../class/BD.class.php";
require_once "../class/Consultas.php";
$respuesta = "";
$parametros = array();
$campos = array();
$estado = "error";
$cont = 0;
try {
$bd = new BD();
$res = $bd->select(Consultas::LIST_USUARIOS, $parametros);
if ($bd->myException->getEstado() == 0) {
while ($rs = $res->fetch()) {
$cont++;
$estado = "ok";
$campos[] = array("nro" => $cont, "id_persona" => $rs["id_persona"], "nombre" => $rs["pers_nombrecompleto"], "email" => $rs["pers_email"], "telefono" => $rs["pers_telefono"], "celular" => $rs["pers_celular"], "rut" => $rs["pers_rut"], "usuario" => $rs["usua_nombre_usuario"]);
}
}
} catch (Exception $e) {
$estado = "error";
$mensaje = $e->getMessage();
}
$bd = NULL;
header("Cache-Control: no-cache, must-revalidate");
// HTTP/1.1
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT");
// Fecha en el pasado
header("Content-type: application/json");
$campos = json_encode($campos);
echo $campos;
<?php
session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../../app/Config.class.php';
require_once '../../app/Bd.class.php';
extract($_GET);
// recupération de l'item
$BD = new BD('item');
$item = $BD->select('idiitem', $iditem);
// ajout de l'item
$BD->setUsedTable('equipement');
$BD->addItem($_SESSION['iduser'], $item->idiitem);
//retrait de l'or
$BD->setUsedTable('user');
$_SESSION['money'] -= $item->prix;
$BD->update('money', $_SESSION['money'], 'iduser', $_SESSION['iduser']);
echo json_encode($_SESSION['money']);
<?php
session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../../app/Config.class.php';
require_once '../../app/Bd.class.php';
extract($_GET);
// recupération du vaisseau
$BD = new BD('spaceship');
$spaceship = $BD->select('idspaceship', $idship);
// ajout du vaisseau
$BD->setUsedTable('vaisseau');
$BD->addVaisseau($spaceship->nom, $spaceship->desc, $spaceship->pv, $spaceship->attaque, $spaceship->defense, $spaceship->xp, $spaceship->nextlevel, $spaceship->type, $spaceship->image, $_SESSION['iduser']);
//retrait de l'or
$BD->setUsedTable('user');
$_SESSION['money'] -= $spaceship->prix;
$BD->update('money', $_SESSION['money'], 'iduser', $_SESSION['iduser']);
// vaisseau définit comme vaisseau courant
$BD->setUsedTable('vaisseau');
$idvaisseau = $BD->select('iduser', $_SESSION['iduser']);
$BD->setUsedTable('user');
$BD->update('idvaisseau', $idvaisseau->idvaisseau, 'iduser', $_SESSION['iduser']);
echo json_encode($_SESSION['money']);
<?php
session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../../app/Config.class.php';
require_once '../../app/Bd.class.php';
extract($_GET);
$levelUp = false;
// on donne l'or recue en récompense
$BD = new BD('user');
$user = $BD->select('iduser', $_SESSION['iduser']);
$BD->update('points', $user->points + $points, 'iduser', $_SESSION['iduser']);
//on définit le vaisseau utilisé comme vaisseau courant
$BD->update('idvaisseau', $idvaisseau, 'iduser', $_SESSION['iduser']);
$_SESSION['money'] += $money;
$BD->update('money', $_SESSION['money'], 'iduser', $_SESSION['iduser']);
// on ajoute la mission à la liste des missions effectuées
$BD->setUsedTable('effectue');
// on test si la mission n'a pas déja été effectuée ?
$nbFois = $BD->count2('iduser', $_SESSION['iduser'], 'idmission', $idmission);
if ($nbFois == 0) {
$BD->addEffectue($_SESSION['iduser'], $idmission);
}
// on met à jour l'xp du vaisseau
$BD->setUsedTable('vaisseau');
$vaisseau = $BD->select('idvaisseau', $idvaisseau);
$BD->update('xp', $vaisseau->xp + $xp, 'idvaisseau', $idvaisseau);
$vaisseau = $BD->select('idvaisseau', $idvaisseau);
// on verifie si le vaisseau à level up, si oui on augment ses stats de +5 atk, +2def, +20pv
$newXp = $vaisseau->xp - $vaisseau->nextlevel;
function recupUser($iduser)
{
$BD = new BD('user');
$res = $BD->select("iduser", $iduser);
return $res;
}
<!doctype html>
<html lang="fr">
<head>
<meta charset="utf-8">
</head>
<body>
<?php
require_once "../../Core/utils.php";
echo "<h1>Test Class bd </h1></br>";
echo "<h2>Test Constructeur </h2></br>";
$BD = new BD("user");
echo "Objet crée sur la table : " . $BD->getUsedTable();
/* Test Fonction Select */
echo "<h2>Test Fonction Select </h2></br>";
$donnes = $BD->select("iduser", 1);
print_r($donnes);
echo "</br>";
/* Test Fonction Select */
echo "<h2>Test Fonction SelectAll </h2></br>";
$donnees = $BD->selectAll();
foreach ($donnees as $value) {
print_r($value);
echo "</br>";
echo "{$value->nom}";
echo "</br>";
}
/* Test Fonction addUser */
$BD->addUser("Jean", "test", 20, "homme", "testpass", 0750, "*****@*****.**");
echo "<h2>Test Fonction addUser </h2></br>";
$donnees = $BD->selectAll();
foreach ($donnees as $value) {
<?php
session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../../../app/Config.class.php';
require_once '../../../app/Bd.class.php';
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
$BD = new BD('equipement');
$listeEquipement = $BD->selectMult('iduser', $_SESSION['iduser']);
$BD->setUsedTable('item');
$listeMyNom = array();
foreach ($listeEquipement as $equipement) {
if ($equipement) {
$Item = $BD->select('idiitem', $equipement->iditem);
$listeMyNom[] = $Item->nom;
}
}
echo json_encode($listeMyNom);
<?php
session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../../../app/Config.class.php';
require_once '../../../app/Bd.class.php';
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
$BD = new BD('user');
$profil = $BD->select('iduser', $_SESSION['iduser']);
echo json_encode($profil);
function recupTrajet($id)
{
$BD = new BD('trajet');
$res = $BD->select("idtrajet", $id);
return $res;
}
function nbPlace($idvehicule)
{
$BD = new BD('vehicule');
$res = $BD->select('idvehicule', $idvehicule);
return $res->nbplace;
}
<?php
if (isset($_SESSION['login'])) {
header('Location : index.php');
exit;
}
require_once Config::$path['model'] . 'login.php';
if (isset($_POST['login'])) {
$BD = new BD('user');
if ($BD->isInDb("pseudo", $_POST['pseudo']) && (($User = $BD->select("pseudo", $_POST['pseudo'])) && $User->pass == sha1($_POST['password'])) && $User->rang != 0) {
$BD->update("online", 1, "pseudo", $_POST['pseudo']);
$iduser = $BD->select("pseudo", $_POST['pseudo']);
$_SESSION['rang'] = $iduser->rang;
$_SESSION['iduser'] = $iduser->iduser;
$_SESSION['avatar'] = $iduser->avatar;
$_SESSION['pseudo'] = htmlentities($_POST['pseudo']);
$_SESSION['login'] = '******';
$_SESSION['msg'][0] = 'success';
$_SESSION['msg'][1] = "Vous êtes connecté !";
header('Location: index.php');
} else {
echo "<div class='error'>Echec de connexion !!! </div>";
}
}
require_once Config::$path['views'] . 'login.php';
<?php
session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../../../app/Config.class.php';
require_once '../../../app/Bd.class.php';
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
extract($_GET);
$BD = new BD('user');
$user = $BD->select('iduser', $_SESSION['iduser']);
$BD->setUsedTable('vaisseau');
$return = $BD->select('idvaisseau', $user->idvaisseau);
echo json_encode($return);
<?php
session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../Config.class.php';
require_once '../../../app/Bd.class.php';
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
extract($_GET);
$BD = new BD('user');
if ($BD->isInDb('pseudo', $pseudo)) {
$user = $BD->select('pseudo', $pseudo);
if ($user->passwd == sha1($password)) {
$BD->setUsedTable('connecté');
if (!$BD->isInDb('iduser', $user->iduser)) {
$BD->addCo($user->iduser);
$_SESSION['pseudo'] = $pseudo;
$_SESSION['iduser'] = $user->iduser;
$energy = $user->energie / $user->maxenergie * 100;
$_SESSION['energie'] = $energy;
$_SESSION['money'] = $user->money;
$_SESSION['avatar'] = $user->avatar;
$_SESSION['rang'] = $user->rang;
$error = "Ok";
} else {
$error = "Vous etes déja connecté !";
}
} else {
$error = "Mot de passe incorecte !";
function recupTrajet($idtrajet)
{
$BD = new BD("trajet");
return $BD->select("idtrajet", $idtrajet);
}
$estado = "error";
$mensaje = $bd->myException->getMensaje();
}
} catch (MyException $e) {
$bd->rollBack();
$estado = "error";
$mensaje = $e->getMensaje();
}
$bd = NULL;
$respuesta[] = array("estado" => $estado, "mensaje" => $mensaje);
}
if ($accion == "cargar") {
$bd = new BD();
try {
$parametros = array($id_persona);
$res = $bd->select(Consultas::CARGAR_USUARIOS, $parametros);
if ($bd->myException->getEstado() == 0) {
while ($rs = $res->fetch()) {
//print_r($rs);
$estado = "ok";
$campos = array("id_persona" => $rs["id_persona"], "nombre" => $rs["pers_nombres"], "email" => $rs["pers_email"], "paterno" => $rs["pers_paterno"], "materno" => $rs["pers_materno"], "usuario" => $rs["usua_nombre_usuario"]);
}
}
} catch (MyException $e) {
$estado = "error";
$mensaje = $e->getMessage();
}
$bd = NULL;
$respuesta[] = array("estado" => $estado, "mensaje" => $mensaje, "campos" => $campos);
}
if ($accion == "update") {
function recupVehicule($idvehicule)
{
$BD = new BD('vehicule');
return $BD->select("idvehicule", $idvehicule);
}
require_once '../Class/BD.class.php';
if (isset($_REQUEST["txtUser"])) {
$user = $_REQUEST["txtUser"];
} else {
$user = "";
}
if (isset($_REQUEST["accion"])) {
$accion = $_REQUEST["accion"];
} else {
$accion = "";
}
if ($accion == "validaUsuario") {
try {
$bd = new BD();
$sql = "select usua_nombre_usuario from ca_usuarios where usua_nombre_usuario='" . $user . "'";
$parametros = array();
$res = $bd->select($sql, $parametros);
if ($bd->myException->getEstado() == 0) {
if ($rs = $res->fetch()) {
echo "false";
} else {
echo "true";
}
} else {
echo "error";
}
} catch (Exception $exc) {
echo "error";
}
}
function recupEvent($idevent)
{
$BD = new BD('event');
return $BD->select('idevent', $idevent);
}
<?php
session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../../../app/Config.class.php';
require_once '../../../app/Bd.class.php';
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
extract($_GET);
$BD = new BD('ennemi');
$listeEnnemi = $BD->selectMult('idmission', $idmission);
$BD->setUsedTable('IA');
$listeMyEnnemi = array();
foreach ($listeEnnemi as $ennemi) {
if ($ennemi) {
$ennemi = $BD->select('idIA', $ennemi->idIA);
$listeMyEnnemi[] = $ennemi;
}
}
echo json_encode($listeMyEnnemi);
}
/*
* Recup des messages
*/
if ($_GET['action'] == 'recup') {
extract($_GET);
$lastid = floor($lastid);
$BD = new BD('tchat');
$donnees = $BD->recupTchat($lastid);
$d['result'] = "";
$d['lastid'] = $lastid;
foreach ($donnees as $message) {
if (!empty($message)) {
$d['result'] .= '<p><strong>' . $message->auteur . '</strong>(' . date("H:i:s", $message->timestamp) . '): ' . htmlentities(utf8_decode($message->message)) . '</p>';
$d['lastid'] = $message->id;
}
}
$BD->setUsedTable('user');
$user = $BD->select("iduser", $_SESSION['iduser']);
if ($user->lastactivity != null && $user->lastactivity + 5 * 60 < time()) {
$d['result'] = "Vous avez été déconnecté pour inactivité...Envoyer un message pour se re-connecter !";
$d['offline'] = true;
} else {
$d['offline'] = false;
}
$d['erreur'] = 'ok';
}
} else {
$d['erreur'] = "Erreur pas d'action à effectuer !";
}
echo json_encode($d);
