?>
<tr <?php
if ($result % 2 == 0) {
?>
class="split" <?php
}
?>
>
<td class="checkbox">
<?php
echo get_boxlistkey("id[]", $row['id'], $row['uid'], $_USER->id);
?>
</td>
<td width="100"><?php
echo get_talent_name($row['job_talent']);
?>
</td>
<td class="title"><?php
echo get_job_name($row['jobpost']);
?>
</td>
<td width="80"><?php
echo $row['user'];
?>
</td>
<td width="120"><?php
echo $row['department'];
?>
</td>
<td width="100"><?php
if (isset($id)) {
$reponse = mysql_query("SELECT COUNT(*) AS nombre FROM `character_spell` WHERE `guid`='{$id}'") or die(mysql_error());
$donnees = mysql_fetch_array($reponse);
$test = Securite::bdd($donnees['nombre']);
if ($test == 0) {
echo "<p>Il n'y a aucun personnage qui a ce nom ou cet ID !!!</p>";
echo "<p><a href=\"javascript:history.go(-1)\">Retour</a></p>";
} else {
echo "<p class=\"title\">Les talents du personnage</p><br />";
echo "<table class=\"lined\" style=\"width: 550px;\">\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<th>" . Securite::bdd($lang_char['talent_id']) . "</th>\n\t\t\t\t\t\t\t\t\t<th align=left>" . Securite::bdd($lang_char['talent_name']) . "</th>\n\t\t\t\t\t\t\t\t</tr>";
if ($GMP) {
$talent_sum = gmp_init(0);
}
while ($talent = mysql_fetch_row($result)) {
if (get_talent_value(Securite::bdd($talent[0]))) {
echo "<tr><td>" . Securite::bdd($talent[0]) . "</td><td align=left>" . get_talent_name(Securite::bdd($talent[0])) . "</td>";
echo "</tr>";
}
}
echo "</table>";
echo "<p><a href=\"javascript:history.go(-1)\">Retour</a></p>";
}
} else {
echo "<p>Erreur !!!</p>";
echo "<p><a href=\"javascript:history.go(-1)\">Retour</a></p>";
}
}
break;
case "skills":
//compétence
mysql_connect($characters[1]['host'], $characters[1]['user'], $characters[1]['password']) or die(mysql_error());
$wheresql .= " AND department='" . $department . "'";
}
if ($jobpost = getGP('jobpost', 'P')) {
$wheresql .= " AND jobpost='" . $jobpost . "'";
}
$vuidtype = getGP('vuidtype', 'P');
if (!is_superadmin() && $vuidtype == '') {
$wheresql .= " AND uid = {$_USER->id}";
}
if ($vuidtype != '') {
if ($vuidtype == '-1') {
$wheresql .= get_subordinate($_USER->id, 'uid');
} else {
$wheresql .= " and uid='" . $vuidtype . "'";
}
}
$sql = "SELECT * FROM " . DB_TABLEPRE . "job_hire WHERE 1 {$wheresql} ORDER BY id desc";
$result = $db->query($sql);
while ($row = $db->fetch_array($result)) {
$archive = array("" . get_talent_name($row['job_talent']) . "", "" . get_job_name($row['jobpost']) . "", "" . $row['user'] . "", "" . $row[department] . "", "" . str_replace("-", ".", $row[hiredate]) . "", "" . get_postname($row['job']) . "", "" . $row[content] . "", "" . get_realname($row['uid']) . "", "" . str_replace("-", ".", $row[date]) . "");
$content[] = $archive;
}
$excel = new ExcelWriter($outputFileName);
if ($excel == false) {
echo $excel->error;
}
foreach ($content as $v) {
$excel->writeLine($v);
}
$excel->sendfile($outputFileName);
}
