Beispiel #1
0
    ?>
																																								
<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 
Beispiel #2
0
         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());
Beispiel #3
0
        $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);
}