function afficherListeGriefs($id_troll, $id_troll_impacte = "")
{
global $db_vue_rm;
echo "<table class='list' width='100%'>";
echo "<tr class='titre-tableau'>";
echo "<td>Le grieffeur</td>";
echo "<td>Date</td>";
echo "<td>Type</td>";
echo "<td>Description</td>";
echo "<td>Troll Impacté</td>";
echo "</tr>";
if ($id_troll_impacte != "") {
$lesGriefs = selectDbGriefs("", "", "", $id_troll_impacte);
} else {
$lesGriefs = selectDbGriefs($id_troll);
}
$nbGriefs = count($lesGriefs);
for ($i = 1; $i <= $nbGriefs; $i++) {
$res = $lesGriefs[$i];
// Troll vengeur, peut-être améliorer pour pas faire
// de req sql pour chaque ligne...
$lesTrolls = selectDbTrolls($res[tk_id]);
$troll_tk = $lesTrolls[1];
$lesTrolls = selectDbTrolls($res[troll_impacte]);
$troll_impacte = $lesTrolls[1];
if (iscontroladministrateur()) {
$lien = "href='engine_view.php?troll={$res['tk_id']}&troll_type_action=grief&troll_action={$res['grief_id']}'";
}
echo "<tr class=\"item-impair\" onmouseover=\"this.className='item-mouseover'\"";
echo "onmouseout=\"this.className='item-impair'\">";
echo "<td><a {$lien}>{$troll_tk['nom_troll']} ({$res['tk_id']})</a></td>";
echo "<td><a {$lien}>{$res['date_grief']}</a></td>";
echo "<td><a {$lien}>{$res['type']}</a></td>";
echo "<td><a {$lien}>{$res['description']}</a></td>";
echo "<td><a {$lien}>{$troll_impacte['nom_troll']} ({$troll_impacte['id_troll']})</a></td>";
echo "</tr>";
}
echo "</table>";
}
function selectDbTrolls($id = "", $sort = "", $id_baronnie = "", $id_distinction = "")
{
global $db_vue_rm;
$sql = "SELECT id_troll, nom_troll, nom_guilde, id_guilde, statut_guilde, ";
$sql .= " is_wanted_troll, is_tk_troll, is_venge_troll, is_admin_troll, ";
$sql .= " x_troll, y_troll, z_troll, UNIX_TIMESTAMP(date_troll) as date_troll, statut_troll, race_troll,";
$sql .= " nom_image_troll, is_seen_troll, pass_troll, groupe_rm_troll,";
$sql .= " id_distinction, nom_distinction, nom_image_distinction, niveau_troll, ";
$sql .= " nom_image_titre_distinction,equipement_troll,date_last_refresh_manual_troll, date_last_visit_troll, is_pnj_troll, ";
$sql .= " date_inscription_troll,\temail_troll ,\tblason_troll ,\tintangible_troll ,\tnb_mouches_troll ,\tnb_kills_troll ,";
$sql .= "\tnb_morts_troll,\tnum_rang_troll,\tnom_rang_troll,\tdistinction_troll,\tequipement2_troll, ";
$sql .= "\tid_diplomate_troll, historique_troll, maj_groupe_spec_troll ";
$sql .= " FROM trolls, guildes, distinctions";
if ($id_baronnie != "") {
$sql .= ", baronnies";
}
if ($sort == "filter_tk" || $sort == "filter_grief") {
$sql .= " , tk_griefs";
}
$sql .= " WHERE id_guilde = guilde_troll";
$sql .= " AND id_distinction_troll = id_distinction";
if ($id_distinction != "") {
$sql .= " AND id_distinction_troll = {$id_distinction}";
}
if ($id_baronnie != "") {
$sql .= " AND id_baronnie_troll = {$id_baronnie}";
}
if ($sort == "neutre" || $sort == "tk" || $sort == "ennemie" || $sort == "amie" || $sort == "alliee") {
$sql .= " AND (statut_troll = '{$sort}' OR statut_guilde = '{$sort}')";
}
if ($sort == "date_last_visit") {
$sql .= " AND ( date_last_visit_troll not like '0000-00-00 00:00:00' ";
$sql .= " OR id_guilde = " . ID_GUILDE . " )";
}
if ($sort == "diplo_conseil") {
$sql .= " AND (groupe_rm_troll = 'conseil' OR groupe_rm_troll = 'diplomate')";
}
if (is_numeric($id)) {
$sql .= " AND id_troll = {$id}";
}
if (is_numeric($sort)) {
$sql .= " AND id_guilde = {$sort}";
} elseif ($sort == "filter_grief") {
$sql .= " AND id_troll = tk_griefs.tk_id";
} elseif ($sort == "filter_tk") {
$sql .= " AND is_tk_troll like 'oui'";
} elseif ($sort == "filter_guilde_ennemie_and_tk") {
$sql .= " AND ( statut_guilde like 'ennemie'";
$sql .= " OR statut_guilde like 'tk')";
} elseif ($sort == "filter_wanted") {
$sql .= " AND is_wanted_troll like 'oui'";
} elseif ($sort == "filter_wanted_not_venge") {
$sql .= " AND is_wanted_troll like 'oui'";
$sql .= " AND is_venge_troll like 'non'";
} elseif ($sort == "filter_venge") {
$sql .= " AND is_venge_troll like 'oui'";
} elseif ($sort == "filter_wanted_without_grief") {
$sql .= " AND is_wanted_troll like 'oui'";
} elseif ($sort == "filter_tk_or_wanted_with_statut_neutre") {
$sql .= " AND (is_wanted_troll = 'oui' OR is_tk_troll = 'oui') ";
$sql .= " AND (statut_troll = 'neutre'";
$sql .= " OR statut_troll = '' )";
$sql .= " AND statut_guilde = 'neutre'";
} elseif ($sort == "filter_statut_tk_or_wanted_without_istk_or_iswanted") {
$sql .= " AND (is_wanted_troll like 'non' AND is_tk_troll like 'non') ";
$sql .= " AND (statut_troll = 'tk' OR statut_troll = 'ennemie') ";
} elseif ($sort == "avatar_to_bollock") {
$sql .= " AND id_guilde = " . ID_GUILDE;
# $sql .= " AND id_distinction != 20 ";
# $sql .= " AND id_distinction != 22 ";
} elseif ($sort == "trombinoscope") {
$sql .= " AND id_guilde = " . ID_GUILDE;
$sql .= " ORDER by num_rang_troll DESC, nom_troll ";
}
if ($sort == "date_last_visit") {
$sql .= " ORDER BY date_last_visit_troll DESC, is_pnj_troll,nom_troll";
} elseif ($sort != "trombinoscope") {
$sql .= " GROUP by id_troll, nom_troll, nom_guilde, id_guilde, statut_guilde,";
$sql .= " is_wanted_troll, is_tk_troll, is_venge_troll,is_admin_troll,";
$sql .= " x_troll, y_troll, z_troll, date_troll, statut_troll, groupe_rm_troll,is_seen_troll, ";
$sql .= " date_inscription_troll,\temail_troll ,\tblason_troll ,\tintangible_troll ,\tnb_mouches_troll ,\tnb_kills_troll ,";
$sql .= "\tnb_morts_troll,\tnum_rang_troll,\tnom_rang_troll,\tdistinction_troll,\tequipement2_troll ";
$sql .= " ORDER by nom_troll";
}
if (!($result = mysql_query($sql, $db_vue_rm))) {
echo mysql_error();
echo "<br>chaine sql = {$sql}<br>";
} else {
$i = 1;
while ($trolls = mysql_fetch_assoc($result)) {
if ($sort == "filter_wanted_without_grief") {
$lesGriefs = selectDbGriefs($trolls[id_troll]);
$nbGriefs = count($lesGriefs);
if ($nbGriefs > 0) {
continue;
}
}
$lesTrolls[$i]['id_troll'] = $trolls['id_troll'];
$lesTrolls[$i]['nom_troll'] = $trolls['nom_troll'];
$lesTrolls[$i]['nom_image_troll'] = $trolls['nom_image_troll'];
$lesTrolls[$i]['id_guilde'] = $trolls['id_guilde'];
$lesTrolls[$i]['nom_guilde'] = $trolls['nom_guilde'];
$lesTrolls[$i]['statut_guilde'] = $trolls['statut_guilde'];
$lesTrolls[$i]['is_tk_troll'] = $trolls['is_tk_troll'];
$lesTrolls[$i]['is_wanted_troll'] = $trolls['is_wanted_troll'];
$lesTrolls[$i]['is_venge_troll'] = $trolls['is_venge_troll'];
$lesTrolls[$i]['is_admin_troll'] = $trolls['is_admin_troll'];
$lesTrolls[$i]['statut_troll'] = $trolls['statut_troll'];
$lesTrolls[$i]['x_troll'] = $trolls['x_troll'];
$lesTrolls[$i]['y_troll'] = $trolls['y_troll'];
$lesTrolls[$i]['z_troll'] = $trolls['z_troll'];
$lesTrolls[$i]['date_troll'] = $trolls['date_troll'];
$lesTrolls[$i]['race_troll'] = $trolls['race_troll'];
$lesTrolls[$i]['niveau_troll'] = $trolls['niveau_troll'];
$lesTrolls[$i]['is_seen_troll'] = $trolls['is_seen_troll'];
$lesTrolls[$i]['is_pnj_troll'] = $trolls['is_pnj_troll'];
$lesTrolls[$i]['groupe_rm_troll'] = $trolls['groupe_rm_troll'];
// accédé uniquement par l'administrateur pour le changement de mot de passe
$lesTrolls[$i]['pass_troll'] = $trolls['pass_troll'];
$lesTrolls[$i]['id_distinction'] = $trolls['id_distinction'];
$lesTrolls[$i]['nom_distinction'] = $trolls['nom_distinction'];
$lesTrolls[$i]['nom_image_distinction'] = $trolls['nom_image_distinction'];
$lesTrolls[$i]['nom_image_titre_distinction'] = $trolls['nom_image_titre_distinction'];
$lesTrolls[$i]['equipement_troll'] = $trolls['equipement_troll'];
$lesTrolls[$i]['date_last_visit_troll'] = $trolls['date_last_visit_troll'];
$lesTrolls[$i]['date_inscription_troll'] = $trolls['date_inscription_troll'];
$lesTrolls[$i]['email_troll'] = $trolls['email_troll'];
$lesTrolls[$i]['blason_troll'] = $trolls['blason_troll'];
$lesTrolls[$i]['intangible_troll'] = $trolls['intangible_troll'];
$lesTrolls[$i]['nb_mouches_troll'] = $trolls['nb_mouches_troll'];
$lesTrolls[$i]['nb_kills_troll'] = $trolls['nb_kills_troll'];
$lesTrolls[$i]['nb_morts_troll'] = $trolls['nb_morts_troll'];
$lesTrolls[$i]['num_rang_troll'] = $trolls['num_rang_troll'];
$lesTrolls[$i]['nom_rang_troll'] = $trolls['nom_rang_troll'];
$lesTrolls[$i]['distinction_troll'] = $trolls['distinction_troll'];
$lesTrolls[$i]['equipement2_troll'] = $trolls['equipement2_troll'];
$lesTrolls[$i]['id_diplomate_troll'] = $trolls['id_diplomate_troll'];
$lesTrolls[$i]['maj_groupe_spec_troll'] = $trolls['maj_groupe_spec_troll'];
$lesTrolls[$i]['historique_troll'] = stripslashes($trolls['historique_troll']);
$i++;
//echo $i."<br>";
if ($i > 400) {
die("<font color=red>Erreur Nbr Troll > 400 ! \n\t\t\t\t\t\tCopié/collé ce que vous voyez et postez dans le topic vue2d</font>");
}
}
}
return $lesTrolls;
}
function afficheInfosWanted($id_troll, $nom_troll, $race_troll, $niveau_troll, $x_troll, $y_troll, $z_troll, $date_troll)
{
$lesGriefs = selectDbGriefs($id_troll);
$nbGriefs = count($lesGriefs);
$text .= "<center><h3><font color=red>{$nom_troll} N° {$id_troll}</font><font color=white> {$race_troll} ({$niveau_troll})</font></h3>";
$text .= "<font color=white>Position : X={$x_troll}, Y={$y_troll}, Z={$z_troll} ({$date_troll})</font><br>";
$text .= afficherLien("troll", "fiche", $id_troll, $x_troll, $y_troll, $z_troll, "[RG]", false);
$text .= afficherLien("troll", "mh_evenements", $id_troll, $x_troll, $y_troll, $z_troll, "[MH]", false);
$text .= afficherLien("troll", "vue2d", $id_troll, $x_troll, $y_troll, $z_troll, "[Vue2d]", false);
$text .= afficherLien("troll", "gps", $id_troll, $x_troll, $y_troll, $z_troll, "[GPS]", false);
$text .= "</center><br>";
$text .= "<center><b><font color=red>Liste des Griefs</font></b></center><font color=white>";
for ($i = 1; $i <= $nbGriefs; $i++) {
$res = $lesGriefs[$i];
$lesTrolls = selectDbTrolls($res[troll_impacte]);
$troll_impacte = $lesTrolls[1];
$text .= "{$res['type']} : le {$res['date_grief']}";
$text .= " sur " . htmlentities($troll_impacte[nom_troll]) . " ({$troll_impacte['id_troll']}) : <br>";
$text .= htmlentities(trim($res[description])) . "<br>";
}
$lesVengeances = selectDbVengeances($id_troll);
$nbVengeances = count($lesVengeances);
$text .= "</font><center><b><font color=green>Liste des Châtiements</font></b></center><font color=white>";
for ($i = 1; $i <= $nbVengeances; $i++) {
$res = $lesVengeances[$i];
$lesTrolls = selectDbTrolls($res[troll_vengeur]);
$troll_vengeur = $lesTrolls[1];
$text .= "Le {$res['date_vengeance']}";
$text .= " par {$troll_vengeur['nom_troll']} ({$troll_vengeur['id_troll']}) : <br>";
$text .= htmlentities(trim($res[description])) . "<br>";
}
$text .= "</font>";
$text = str_replace("\r\n", "<br>", $text);
$text = addslashes($text);
echo " onmouseover=\"return overlib('<font color=red> <b>Cliquez là où vous êtes !</b></font> <br>{$text}');\" ";
echo " onclick=\"return overlib('{$text}', STICKY, CAPTION, 'Informations',CLOSECLICK, EXCLUSIVE);\" ";
echo " onmouseout=\"return nd();\"";
}
