public static function ListerBase()
{
$db = getConnexionDB();
$requete = "SELECT * FROM arme where debase = 1 order by nom asc";
$tableau = array();
$stmt = $db->prepare($requete);
$stmt->execute();
while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) {
$temp = new arme($rs['ID'], $rs['NOM'], $rs['NOM_COURT'], $rs['PRIX'], $rs['PI'], $rs['RUP'], $rs['AT'], $rs['PRD'], $rs['COU'], $rs['INT'], $rs['CHA'], $rs['AD'], $rs['FOR'], $rs['SPECIAL'], $rs['JET'], $rs['qualite'], $rs['type'], $rs['deuxmains'], $rs['debase']);
$ajouter = true;
foreach ($tableau as $arme) {
if (Arme::ArmesEgales($arme, $temp)) {
$ajouter = false;
}
}
if ($ajouter) {
$tableau[] = $temp;
}
}
return $tableau;
}
public static function ListerOfficiel()
{
$db = DatabaseManager::getDb();
$requete = "SELECT * FROM " . PREFIX_DB . "arme where arme_officiel = 1 order by arme_PRIX asc, arme_NOM asc";
$tableau = array();
$stmt = $db->prepare($requete);
$stmt->execute();
while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) {
$temp = new arme($rs);
$ajouter = true;
foreach ($tableau as $arme) {
if (Arme::ArmesEgales($arme, $temp)) {
$ajouter = false;
}
}
if ($ajouter) {
$tableau[] = $temp;
}
}
return $tableau;
}
