PHP BD::setUsedTable Examples

Example #1

File: proposer.php Project: sebspas/Share2Go

function inscritTrajet($Date, $VilleDep, $VilleArr, $HeureDep, $Prix, $NbrPlace, $nonfumeur, $musique, $valise, $bavar, $com, $idauteur, $idvehicule)
{
    $BD = new BD('trajet');
    $BD->addTrajet($Date, $VilleDep, $VilleArr, $HeureDep, $Prix, $NbrPlace, $nonfumeur, $musique, $valise, $bavar, $com, $idauteur, $idvehicule);
    $BD->setUsedTable('user');
    $BD->inc("nbtrajet", "iduser", $idauteur);
}

Example #2

File: profil.php Project: sebspas/Share2Go

function deletetrajet($idtrajet, $iduser)
{
    $BD = new BD('trajet');
    $BD->delete("idtrajet", $idtrajet);
    $BD->setUsedTable('user');
    $BD->decr("nbtrajet", "iduser", $iduser);
}

Example #3

File: reservation.php Project: sebspas/Share2Go

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

Example #4

File: section.php Project: sebspas/AFK-WEB

function recupUser($idevent)
{
    $BD = new BD('participant');
    $listeUser = array();
    $listeIdUser = $BD->selectMult('idevent', $idevent);
    $BD->setUsedTable('user');
    foreach ($listeIdUser as $user) {
        if (!empty($user)) {
            $listeUser[] = $BD->select('iduser', $user->iduser);
        }
    }
    return $listeUser;
}

Example #5

File: profil.php Project: sebspas/AFK-WEB

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

Example #6

File: load-combat-ennemi.php Project: sebspas/Aurora

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

Example #7

File: load-current-ship.php Project: sebspas/Aurora

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

Example #8

File: achat-market-ship.php Project: sebspas/Aurora

<?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']);

Example #9

File: login.php Project: sebspas/Aurora

<?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 !";

Example #10

File: recompense_mission.php Project: sebspas/Aurora

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;
// si il a level up on le précise au js et on met à jour ses stats
if ($newXp >= 0) {
    $levelUp = true;

Example #11

File: pagination.php Project: sebspas/AFK-WEB

<?php

ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../../app/Config.class.php';
require_once '../../app/Bd.class.php';
$d = array();
$BD = new BD('news');
$d['news'] = $BD->countAll();
$BD->setUsedTable('event');
$d['events'] = $BD->countAll();
echo json_encode($d);

Example #12

File: admin.php Project: sebspas/AFK-WEB

function deleteEvent($idevent)
{
    $BD = new BD('participant');
    $BD->delete('idevent', $idevent);
    $BD->setUsedTable('event');
    $BD->delete('idevent', $idevent);
}

Example #13

File: bd_class_test.php Project: sebspas/Share2Go

    echo "{$value->nom}";
    echo "</br>";
}
/* Test delete */
$BD->delete("nom", "Jeanne");
echo "<h2>Test Fonction DELETE </h2></br>";
$donnees = $BD->selectAll();
foreach ($donnees as $value) {
    print_r($value);
    echo "</br>";
    echo "{$value->nom}";
    echo "</br>";
}
echo "<h2>Test Changement de table </h2></br>";
echo "Objet crée sur la table : " . $BD->getUsedTable() . "</br>";
$BD->setUsedTable("trajet");
echo "Objet modifier sur la table : " . $BD->getUsedTable() . "</br>";
/* Test Fonction addTrajet */
$BD->addTrajet("Boulogne", "Bois", date("H:i:s"), date("H:i:s"), 50, 2, "Fiat Punto", 1);
echo "<h2>Test Fonction addTrajet </h2></br>";
$donnees = $BD->selectAll();
foreach ($donnees as $value) {
    print_r($value);
    echo "</br>";
    echo "{$value->nom}";
    echo "</br>";
}
/* Test delete */
$BD->setUsedTable("user");
$ID = $BD->select("iduser", 1)->iduser;
$BD->setUsedTable("trajet");

Example #14

File: load-nom-items.php Project: sebspas/Aurora

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

Example #15

File: achat-market-item.php Project: sebspas/Aurora

<?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']);

Example #16

File: tchat.php Project: sebspas/AFK-WEB

    }
    /*
     *   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);