| Ajouter une Annonce |
Ressources à Vendre |
";
display($page);
}else if ($action == "sav") {
$metalvendre = $_POST['metalvendre'];
$cristalvendre = $_POST['cristalvendre'];
$deutvendre = $_POST['deutvendre'];
$metalsouhait = $_POST['metalsouhait'];
$cristalsouhait = $_POST['cristalsouhait'];
$deutsouhait = $_POST['deutsouhait'];
$username = $user['username'];
$galaxie = $user['galaxy'];
$systeme = $user['system'];
$planete = $user['planet'];
doquery("INSERT INTO {{table}} SET
user='{$username}',
galaxie='{$galaxie}',
systeme='{$systeme}',
planete='{$planete}',
metala='{$metalvendre}',
cristala='{$cristalvendre}',
deuta='{$deutvendre}',
metals='{$metalsouhait}',
cristals='{$cristalsouhait}',
deuts='{$deutsouhait}'" , "annonce");
}else if ($action == "del") {
doquery("DELETE FROM {{table}} WHERE `id` = " . intval($_GET['id']) . ";","annonce");
message("Annonce supprimée");
}else if($action == "get") {
//Récupération annonce
$annonce = doquery("SELECT * FROM {{table}} WHERE `id` = '".intval($_GET['id'])."' ", "annonce", true);
//Gestion ressources planète de l'annonceur
$QryPlanet = "SELECT * FROM {{table}} ";
$QryPlanet .= " WHERE galaxy = '".$annonce['galaxie']."' AND system = '". $annonce['systeme'] ."' AND planet = '". $annonce['planete'] ."' AND planettype = '1' ";
$planetsAnnonceur = doquery($QryPlanet, 'planets', true);
$planetsAnnonceur['metal'] = $planetsAnnonceur['metal'] - $annonce["metala"] + $annonce["metals"];
$planetsAnnonceur['crystal'] = $planetsAnnonceur['crystal'] - $annonce["cristala"] + $annonce["cristals"];
$planetsAnnonceur['deuterium'] = $planetsAnnonceur['deuterium'] - $annonce["deuta"] + $annonce["deuts"];
$queryUpdate = "UPDATE {{table}} SET ";
$queryUpdate .= " metal = '".$planetsAnnonceur['metal']."' AND crystal = '".$planetsAnnonceur['crystal']."' AND deuterium = '".$planetsAnnonceur['deuterium']."' ";
$queryUpdate .= " WHERE galaxy = '". $annonce['galaxie'] ."' AND system = '". $annonce['systeme'] ."' AND planet = '". $annonce['planete'] ."' AND planettype = '1' ";
$planete = doquery($queryUpdate, "planets");
//Gestion ressources planète de l'acheteur
$planetrow['metal'] = $planetrow['metal'] - $annonce["metala"] + $annonce["metals"];
$planetrow['crystal'] = $planetrow['crystal'] - $annonce["cristala"] + $annonce["cristals"];
$planetrow['deuterium'] = $planetrow['deuterium'] - $annonce["deuta"] + $annonce["deuts"];
$queryUpdate = "UPDATE {{table}} SET ";
$queryUpdate .= " metal = '".$planetrow['metal']."' AND crystal = '".$planetrow['crystal']."' AND deuterium = '".$planetrow['deuterium']."' ";
$queryUpdate .= " WHERE galaxy = '". $planetrow['galaxy'] ."' and system = '". $planetrow['system'] ."' AND planet = '". $planetrow['planet'] ."' AND planettype = '".$planetrow['planettype']."' ";
$planete = doquery($queryUpdate, "planets");
//suppression de l'annonce
doquery("DELETE FROM {{table}} WHERE `id` = " . intval($_GET['id']) . ";","annonce");
}
}
//Page principale
$annonce = doquery("SELECT * FROM {{table}} ORDER BY `id` DESC ", "annonce");
$page2 = "
| Petites Annonces |
| Infos de livraison | Ressources à vendre | Ressources souhaitées | Action |
|---|
| Vendeur | Galaxie | Système | Métal | Cristal | Deuterium | Métal | Cristal | Deuterium | Action |
|---|
";
while ($b = mysql_fetch_array($annonce)) {
$page2 .= '| ';
$page2 .= $b["user"] ;
$page2 .= ' | ';
$page2 .= $b["galaxie"];
$page2 .= ' | ';
$page2 .= $b["systeme"];
$page2 .= ' | ';
$page2 .= $b["metala"];
$page2 .= ' | ';
$page2 .= $b["cristala"];
$page2 .= ' | ';
$page2 .= $b["deuta"];
$page2 .= ' | ';
$page2 .= $b["metals"];
$page2 .= ' | ';
$page2 .= $b["cristals"];
$page2 .= ' | ';
$page2 .= $b["deuts"];
$page2 .= ' | ';
if ($b["user"] == $user["username"]) {
$page2 .= "Supprimer";
}else{
$page2 .= "Prendre";
}
$page2 .= " |
|---|
";
}
$page2 .= "
| Ajouter une Annonce |
|---|
";
display($page2);
// Créer par Tom1991 Copyright 2008
// Merci au site Spacon pour m'avoir donner l'inspiration
?>