public static function LastNews()
{
$db = DatabaseManager::getDb();
$requete = "SELECT * FROM news order by date_news DESC";
$tableau = array();
foreach ($db->query($requete) as $row) {
$tableau[] = new News($row['ID_NEWS'], $row['DATE_NEWS'], $row['TITRE'], $row['TEXTE']);
}
return $tableau;
}
public static function ListerPourPaladin()
{
$db = DatabaseManager::getDb();
$requete = "SELECT * FROM " . PREFIX_DB . "dieu where DIEU_PALADIN = 1";
$tableau = array();
$stmt = $db->prepare($requete);
$stmt->execute();
while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) {
$tableau[] = new dieu($rs);
}
return $tableau;
}
<?php
include __DIR__ . "/config/config.php";
include __DIR__ . "/model/autoloader.class.php";
$db = DatabaseManager::getDb();
$requete = "select * \n from " . PREFIX_DB . "lien_aventurier_arme\n join " . PREFIX_DB . "arme on " . PREFIX_DB . "arme.ARME_ID = " . PREFIX_DB . "lien_aventurier_arme.ID_ARME LIMIT 10, 9999";
$stmt = $db->prepare($requete);
$stmt->execute();
while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) {
$arme = new Arme($rs);
$arme->ARME_AVENTURIER_ID = $rs["ID_AVENTURIER"];
$arme->ajouter();
}
public function determineCompetences()
{
if ($this->METIER != "" && $this->ORIGINE != "") {
if ($this->METIER->ID == 99) {
$this->COMPETENCESLIEES = $this->METIER->COMPETENCESLIEES;
} else {
$this->COMPETENCESLIEES = fusionneCompetencesSansDoublons($this->METIER->COMPETENCESLIEES, $this->ORIGINE->COMPETENCESLIEES);
}
}
if (empty($this->ID)) {
return;
}
$db = DatabaseManager::getDb();
$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 loadFromDB($id)
{
$db = DatabaseManager::getDb();
$requete = "SELECT * FROM " . PREFIX_DB . "magie WHERE MAGIE_ID = " . $id;
$stmt = $db->prepare($requete);
$stmt->execute();
$ligne = $stmt->fetch(PDO::FETCH_ASSOC);
$this->LoadFromArray($ligne);
}
function getConnexionDB()
{
return DatabaseManager::getDb();
}
public function loadFromDB($id)
{
$db = DatabaseManager::getDb();
$requete = "SELECT * FROM metier WHERE METIER_ID = " . $id;
$stmt = $db->prepare($requete);
$stmt->execute();
$ligne = $stmt->fetch(PDO::FETCH_ASSOC);
$this->METIER_ID = $ligne['METIER_ID'];
$this->METIER_NOM = $ligne['METIER_NOM'];
$this->METIER_EV = $ligne['METIER_EV'];
$this->METIER_EA = $ligne['METIER_EA'];
$this->METIER_AT = $ligne['METIER_AT'];
$this->METIER_PRD = $ligne['METIER_PRD'];
$this->METIER_FOMIN = $ligne['METIER_FOMIN'];
$this->METIER_FOMAX = $ligne['METIER_FOMAX'];
$this->METIER_ADMIN = $ligne['METIER_ADMIN'];
$this->METIER_ADMAX = $ligne['METIER_ADMAX'];
$this->METIER_INTMIN = $ligne['METIER_INTMIN'];
$this->METIER_INTMAX = $ligne['METIER_INTMAX'];
$this->METIER_CHAMIN = $ligne['METIER_CHAMIN'];
$this->METIER_CHAMAX = $ligne['METIER_CHAMAX'];
$this->METIER_COUMIN = $ligne['METIER_COUMIN'];
$this->METIER_COUMAX = $ligne['METIER_COUMAX'];
$this->METIER_RESTRICTION = $ligne['METIER_RESTRICTION'];
$this->METIER_BONUS = $ligne['METIER_BONUS'];
$this->METIER_PRMAX = $ligne['METIER_PRMAX'];
$db = DatabaseManager::getDb();
$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->METIER_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->METIER_COMPETENCESACHOISIR[] = $competence;
}
}
public function get_data_from_db($id)
{
$db = DatabaseManager::getDb();
$requete = "SELECT * FROM " . PREFIX_DB . "arme WHERE ARME_ID = " . $id;
$stmt = $db->prepare($requete);
$stmt->execute();
$ligne = $stmt->fetch(PDO::FETCH_ASSOC);
$this->loadFromArray($ligne);
}
