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);