--- careers.php 2001/03/19 10:47:46 1.10
+++ careers.php 2002/04/11 12:56:40 1.17
@@ -1,20 +1,33 @@
upload_dir = "/data/erec";
+
+ //ini_restore("include_path"); // no work?
+ ini_set("include_path",$old_inc);
+} else {
+ require("Smarty.class.php");
+}
+
require("conn.inc");
$smarty = new Smarty;
$smarty->assign( array ( Title=>"Pliva d.d." ) );
-$section=str_replace(".php","",basename($PHP_SELF));
-$smarty->assign("section",$section);
+include("section.inc");
include("common.inc");
-$title="CAREERS";
-if ($menu_item) $title.=" : $menu_item";
-$lpic="careers"; $lext=".jpg";
-$mpic="careers.gif";
$main_file="./html/Careers-";
if (file_exists($main_file.$part.".htm")) {
$main_file.=$part.".htm";
@@ -23,6 +36,9 @@
if ($part == "Mail" && !check_required()) $part="ApplicationForm";
+ $sql="select num,title,job_code,department,open_position_locations.location as location,description,edu_req,qual_req,open_position_locations.email as sendto
+ from open_positions,open_position_locations
+ where open_positions.location_id=open_position_locations.id and $visible_is_true";
if ($part == "ApplicationForm") {
$sth = $dbh->prepare("select iso,name from countries order by name");
$sth->execute();
@@ -32,14 +48,18 @@
$smarty->assign("countries",$countries);
if ($position) {
- $sth = $dbh->prepare("select num,title,job_code,department,location from open_positions where visible is true and num=$position");
+ $sql.=" and num=$position";
+ $sth = $dbh->prepare($sql);
$sth->execute();
if ($row=$sth->fetchrow_hash()) {
+ include("rot13.inc");
+ $row[sendto]=rot13($row[sendto]);
$smarty->assign("position",$row);
}
}
} elseif ($part == "OpenPositions") {
- $sth = $dbh->prepare("select num,title,job_code,department,location,description,edu_req,qual_req from open_positions where visible is true and expiration >= date('now') order by num asc");
+ $sql.=" and expiration >= date('now') order by num asc";
+ $sth = $dbh->prepare($sql);
$sth->execute();
while ($row=$sth->fetchrow_hash()) {
$positions[]=$row;
@@ -68,20 +88,26 @@
";
$smarty->assign("mail","You sent following e-mail: