public static function ipVisitedToday($ip) { $db = getConnexionDB(); $requete = "SELECT COUNT(*) as COMPTE FROM visiteur WHERE IP = '" . $ip . "' AND DATE(visiteur.DATE) = CURDATE()"; $stmt = $db->prepare($requete); $res = executePDOSQPWithDebug($stmt); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); if ($ligne["COMPTE"] > 0) { return true; } else { return false; } }
public function get_data_from_db($id) { $db = getConnexionDB(); $requete = "SELECT * FROM news WHERE ID_NEWS = " . $id; foreach ($db->query($requete, PDO::FETCH_ASSOC) as $ligne) { $this->ID_NEWS = DatabaseManager::CastForOut($ligne['ID_NEWS']); $this->DATE_NEWS = DatabaseManager::CastForOut($ligne['DATE_NEWS']); $this->TITRE = DatabaseManager::CastForOut($ligne['TITRE']); $this->TEXTE = DatabaseManager::CastForOut($ligne['TEXTE']); } }
public function get_data_from_db($id) { $db = getConnexionDB(); $requete = "SELECT * FROM user WHERE id = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); foreach ($ligne as $key => $value) { $this->{$key} = $value; } }
public function get_data_from_db($id) { $db = getConnexionDB(); $requete = "SELECT * FROM metier WHERE ID = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); $this->ID = $ligne['ID']; $this->NOM = $ligne['NOM']; $this->EV = $ligne['EV']; $this->EA = $ligne['EA']; $this->AT = $ligne['AT']; $this->PRD = $ligne['PRD']; $this->FOMIN = $ligne['FOMIN']; $this->FOMAX = $ligne['FOMAX']; $this->ADMIN = $ligne['ADMIN']; $this->ADMAX = $ligne['ADMAX']; $this->INTMIN = $ligne['INTMIN']; $this->INTMAX = $ligne['INTMAX']; $this->CHAMIN = $ligne['CHAMIN']; $this->CHAMAX = $ligne['CHAMAX']; $this->COUMIN = $ligne['COUMIN']; $this->COUMAX = $ligne['COUMAX']; $this->RESTRICTION = $ligne['RESTRICTION']; $this->BONUS = $ligne['BONUS']; $this->PRMAX = $ligne['PRMAX']; $db = getConnexionDB(); $requete = "SELECT ID_COMPETENCE FROM lien_metier_competence_native WHERE ID_METIER = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); while ($ligne = $stmt->fetch(PDO::FETCH_ASSOC)) { $competence = new Competence($ligne["ID_COMPETENCE"]); $this->COMPETENCESLIEES[] = $competence; } $requete = "SELECT ID_COMPETENCE FROM lien_metier_competence_choix WHERE ID_METIER = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); while ($ligne = $stmt->fetch(PDO::FETCH_ASSOC)) { $competence = new Competence($ligne["ID_COMPETENCE"]); $this->COMPETENCESACHOISIR[] = $competence; } }
public function get_data_from_db($id) { $db = getConnexionDB(); $requete = "SELECT * FROM arme WHERE ID = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); $this->ID = $ligne['ID']; $this->NOM = $ligne['NOM']; $this->NOM_COURT = $ligne['NOM_COURT']; $this->PRIX = $ligne['PRIX']; $this->PI = $ligne['PI']; $this->RUP = $ligne['RUP']; $this->AT = $ligne['AT']; $this->PRD = $ligne['PRD']; $this->COU = $ligne['COU']; $this->INT = $ligne['INT']; $this->CHA = $ligne['CHA']; $this->AD = $ligne['AD']; $this->FOR = $ligne['FOR']; $this->SPECIAL = $ligne['SPECIAL']; $this->JET = $ligne['JET']; $this->qualite = $ligne['qualite']; $this->type = $ligne['type']; $this->deuxmains = $ligne['deuxmains']; $this->debase = $ligne['debase']; }
public function get_data_from_db($id) { $db = getConnexionDB(); $requete = "SELECT * FROM dieu WHERE ID_DIEU = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); $this->ID_DIEU = $ligne['ID_DIEU']; $this->NOM = $ligne['NOM']; $this->DESCRIPTION = $ligne['DESCRIPTION']; $this->PALADIN = $ligne['PALADIN']; $this->PRETRE = $ligne['PRETRE']; }
public function determineCompetences() { if ($this->METIER != "" && $this->ORIGINE != "") { $this->COMPETENCESLIEES = fusionneCompetencesSansDoublons($this->METIER->COMPETENCESLIEES, $this->ORIGINE->COMPETENCESLIEES); } if (empty($this->ID)) { return; } $db = getConnexionDB(); $requete = "SELECT * FROM lien_aventurier_competence WHERE ID_AVENTURIER = " . $this->ID; $stmt = $db->prepare($requete); $stmt->execute(); $this->COMPETENCESCHOISIES = array(); while ($ligne = $stmt->fetch(PDO::FETCH_ASSOC)) { $comp = new Competence(); $this->COMPETENCESCHOISIES[] = $comp; } $this->competences = fusionneCompetencesSansDoublons($this->COMPETENCESCHOISIES, $this->COMPETENCESLIEES); }
public function get_data_from_db($id) { $db = getConnexionDB(); $requete = "SELECT * FROM equipement WHERE ID = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); $this->ID = $ligne['ID']; $this->NOM = $ligne['NOM']; $this->SPECIAL = $ligne['SPECIAL']; $this->PO = $ligne['PO']; $this->PA = $ligne['PA']; $this->PC = $ligne['PC']; $this->COU = $ligne['COU']; $this->INT = $ligne['INT']; $this->CHA = $ligne['CHA']; $this->AD = $ligne['AD']; $this->FO = $ligne['FO']; $this->munition = $ligne['munition']; $this->debase = $ligne['debase']; $this->type = $ligne['type']; $this->AT = $ligne['AT']; $this->PRD = $ligne['PRD']; }
public function get_data_from_db($id) { $db = getConnexionDB(); $requete = "SELECT * FROM magie WHERE ID_MAGIE = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); $this->ID_MAGIE = $ligne['ID_MAGIE']; $this->NOM = $ligne['NOM']; $this->disponible = $ligne['disponible']; }
public function get_data_from_db($id) { $db = getConnexionDB(); $requete = "SELECT * FROM origine WHERE ID = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); $this->ID = $ligne['ID']; $this->NOM = $ligne['NOM']; $this->EV = $ligne['EV']; $this->AT = $ligne['AT']; $this->PRD = $ligne['PRD']; $this->FOMIN = $ligne['FOMIN']; $this->FOMAX = $ligne['FOMAX']; $this->ADMIN = $ligne['ADMIN']; $this->ADMAX = $ligne['ADMAX']; $this->INTMIN = $ligne['INTMIN']; $this->INTMAX = $ligne['INTMAX']; $this->CHAMIN = $ligne['CHAMIN']; $this->CHAMAX = $ligne['CHAMAX']; $this->COUMIN = $ligne['COUMIN']; $this->COUMAX = $ligne['COUMAX']; $this->RESTRICTION = $ligne['RESTRICTION']; $this->BONUS = $ligne['BONUS']; $this->MAGIE = $ligne['MAGIE']; $this->PRMAX = $ligne['PRMAX']; $this->BOUCLIER = $ligne['BOUCLIER']; $this->JET = $ligne['JET']; $this->MALADIE = $ligne['MALADIE']; $this->PETITE_TAILLE = $ligne['PETITE_TAILLE']; $this->PR_MAX = $ligne['PR_MAX']; $this->COMPETENCESLIEES = array(); $this->COMPETENCESACHOISIR = array(); $requete = "SELECT ID_COMPETENCE FROM lien_origine_competence_native WHERE ID_ORIGINE = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); while ($ligne = $stmt->fetch(PDO::FETCH_ASSOC)) { $competence = new Competence($ligne["ID_COMPETENCE"]); $this->COMPETENCESLIEES[] = $competence; } $requete = "SELECT ID_COMPETENCE FROM lien_origine_competence_choix WHERE ID_ORIGINE = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); while ($ligne = $stmt->fetch(PDO::FETCH_ASSOC)) { $competence = new Competence($ligne["ID_COMPETENCE"]); $this->COMPETENCESACHOISIR[] = $competence; } }
public function get_data_from_db($id) { $db = getConnexionDB(); $requete = "SELECT * FROM protection WHERE ID = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); $this->ID = $ligne['ID']; $this->NOM = $ligne['NOM']; $this->NOM_COURT = $ligne['NOM_COURT']; $this->PR = $ligne['PR']; $this->RUP = $ligne['RUP']; $this->COU = $ligne['COU']; $this->INT = $ligne['INT']; $this->CHA = $ligne['CHA']; $this->AD = $ligne['AD']; $this->FOR = $ligne['FOR']; $this->SPECIAL = $ligne['SPECIAL']; $this->AT = $ligne['AT']; $this->PRD = $ligne['PRD']; $this->PRIX = $ligne['PRIX']; $this->QUALITE = $ligne['QUALITE']; $this->TYPE = $ligne['TYPE']; $this->debase = $ligne['debase']; }
public function get_data_from_db($id) { $db = getConnexionDB(); $requete = "SELECT * FROM dieu WHERE DIEU_ID = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); $this->loadFromArray($ligne); }
public function get_data_from_db($id) { $db = getConnexionDB(); $requete = "SELECT * FROM competence WHERE ID = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); $this->ID = $ligne['ID']; $this->NOM = $ligne['NOM']; $this->PR = $ligne['PR']; $this->AT = $ligne['AT']; $this->PRD = $ligne['PRD']; $this->COU = $ligne['COU']; $this->CHA = $ligne['CHA']; $this->INT = $ligne['INT']; $this->FO = $ligne['FO']; $this->AD = $ligne['AD']; $this->SPECIAL = $ligne['SPECIAL']; $this->REQUIS = $ligne['REQUIS']; }
public function get_data_from_db($id) { $db = getConnexionDB(); $requete = "SELECT * FROM mob WHERE id_mob = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); $this->id_mob = $ligne['id_mob']; $this->type_mob = $ligne['type_mob']; $this->nom = $ligne['nom']; $this->at = $ligne['at']; $this->prd = $ligne['prd']; $this->ev = $ligne['ev']; $this->pr = $ligne['pr']; $this->pi = $ligne['pi']; $this->type_arme = $ligne['type_arme']; $this->cou = $ligne['cou']; $this->rm = $ligne['rm']; $this->xp = $ligne['xp']; $this->note = $ligne['note']; $this->niv_min = $ligne['niv_min']; $this->niv_max = $ligne['niv_max']; $this->po = $ligne['po']; $this->humanoide = $ligne['humanoide']; }