function buildQuery()
{
// check if query is set
if (empty($this->query)) {
$this->error = ' NO QUERY SET ';
$this->rQuery = false;
}
// check the mysql object
if (!is_a($this->mysqlOBJ, 'mysql')) {
$this->error = ' NO MYSQL OBJECT SET ';
$this->rQuery = false;
}
// check the numbers of pages
$objDb = new db();
//echo $this->query ;
//echo "<br>";
$this->result = $objDb->ExecuteQuery($this->query);
$this->totalRows = mysql_num_rows($this->result);
if ($this->result !== false) {
//$this->totalRows=$this->mysqlOBJ->num_rows;
$this->totalPages = ceil($this->totalRows / $this->maxpage);
} else {
$this->error = ' ERROR EXECUTING QUERY ';
$this->rQuery = false;
}
//echo "<br>";
//echo $this->totalPages ;
if ($this->totalRows <= $this->maxpage) {
$this->rQuery = $this->query;
} else {
$this->cPage = $this->cPage <= $this->totalPages ? $this->cPage : '1';
$limit = " LIMIT " . ($this->cPage - 1) * $this->maxpage . "," . $this->maxpage;
$this->rQuery = $this->query . $limit;
}
}
function get_admin_user_country()
{
$obj_Db = new db();
$sql = "select * from job_main_country";
$result = $obj_Db->ExecuteQuery($sql);
$numrows = mysql_num_rows($result);
if ($numrows > 0) {
$countrylist = "<option value = '0'>Country</option>";
while ($countryobj = mysql_fetch_object($result)) {
$countrylist .= "<option value = '" . $countryobj->country_id . "'>" . $countryobj->country_name . "</option>";
}
}
return $countrylist;
}
<?php
session_start();
if (!isset($_SESSION["user_id"])) {
header("location: ../index.php");
exit;
}
require_once "../../classes/db_class.php";
require_once "../../includes/functions.php";
$objDb = new db();
$sqlplan = "select * from job_rec_payment_plans where plan_id='" . $_GET["pid"] . "'";
$resultplan = $objDb->ExecuteQuery($sqlplan);
$rsplan = mysql_fetch_object($resultplan);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Recruit Young</title>
<link rel="stylesheet" type="text/css" href="../../styles/job.css">
<link rel="stylesheet" type="text/css" href="../styles/job_admin.css">
<script src="../javascript/menubar.js" language="javascript"></script>
<script src="../javascript/admin.js" language="javascript"></script>
<script src="../../javascript/job.js" language="javascript"></script>
<script language="javascript">
function displayRate(id)
$qks_8_2 = ""; $qks_9_1 = ""; $qks_9_2 = ""; $qks_10_1 = ""; $qks_10_2 = ""; $qks_10_3 = ""; $qks_11_1 = ""; $qks_11_2 = ""; $preference_emp_1_1 = ""; //$preference_emp_1_2 = ""; $preference_emp_1_3 = "Namibia"; $preference_emp_2 = ""; $preference_emp_3 = ""; $confirm_mail = ""; $sqlJob = "select * from job_ad where ad_id=" . $_GET['ad_id']; $resultJob = $objDb->ExecuteQuery($sqlJob); $rsJob = mysql_fetch_object($resultJob); $confirm_mail = $rsJob->send_mail_another; //new add ons $fieldofstudy = $rsJob->filter_fieldofstudy; $typeofqualification = $rsJob->filter_typeofqualification; $levelofqualification = $rsJob->filter_levelofqualification; $countryofstudy = $rsJob->filter_countryofstudy; $typeofbursary = $rsJob->filter_typeofbursary; $prefinstitution = $rsJob->filter_prefinstitution; $advancementlevel = $rsJob->filter_advancementlevel; $accepted = $rsJob->filter_accepted; $passrate = $rsJob->filter_passrate; $prefinstitution = $rsJob->filter_prefinstitution; $parentincome = $rsJob->filter_parentincome; $equity_status = $rsJob->filter_equity_status;
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<?php
require_once "../../classes/db_class.php";
$objDb = new db();
$sqlactive = "select * from job_jobseeker where seeker_status=1";
$resultactive = $objDb->ExecuteQuery($sqlactive);
$noactive = mysql_num_rows($resultactive);
$sqlinactive = "select * from job_jobseeker where seeker_status=0";
$resultinactive = $objDb->ExecuteQuery($sqlinactive);
$inactive = mysql_num_rows($resultinactive);
$sqlall = "select * from job_jobseeker ";
$resultall = $objDb->ExecuteQuery($sqlall);
$noall = mysql_num_rows($resultall);
?>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Recruit Young</title>
<link rel="stylesheet" type="text/css" href="../styles/job_admin.css">
<script src="../javascript/menubar.js" language="javascript"></script>
</head>
<body onload="MM_preloadImages('../images/login1.gif','../images/job_search1.gif','../images/upload_cv1.gif','../images/employers1.gif','../images/features1.gif')">
<table width="990" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><?php
include "top.php";
?>
</td>
</tr>
<tr>
header("location: ../index.php");
exit;
}
require_once "../../classes/db_class.php";
require_once "../../includes/functions.php";
$objDb = new db();
$rowCount = "";
$rows = "";
$cols = "";
$option = "";
$resultcol = "";
$resulrow = "";
$sql1 = "select field_value from job_grade_level where field_row = 0";
$sql2 = "select field_value from job_grade_level where field_column = 0";
$sql = "select field_value from job_grade_level";
$res = $objDb->ExecuteQuery($sql);
$rowCount = mysql_num_rows($res);
$res1 = $objDb->ExecuteQuery($sql1);
$cols = mysql_num_rows($res1);
$res2 = $objDb->ExecuteQuery($sql2);
$rows = mysql_num_rows($res2);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Recruit Young</title>
<link rel="stylesheet" type="text/css" href="../../styles/job.css">
<link rel="stylesheet" type="text/css" href="../styles/job_admin.css">
<script src="../javascript/menubar.js" language="javascript"></script>
<?php
session_start();
if (!isset($_SESSION["user_id"])) {
header("location: ../index.php");
exit;
}
require_once "../../classes/pagination.php";
require_once "../../includes/functions.php";
require_once "includes/functions.php";
$objDb = new db();
$sqlLanguage = "select * from job_language";
$resultLang = $objDb->ExecuteQuery($sqlLanguage);
$rowCount = mysql_num_rows($resultLang);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Recruit Young</title>
<link rel="stylesheet" type="text/css" href="../../styles/job.css">
<link rel="stylesheet" type="text/css" href="../styles/job_admin.css">
<script src="../javascript/menubar.js" language="javascript"></script>
<script src="../javascript/admin.js" language="javascript"></script>
<script language="javascript">
function remove_single_language(id)
{
<?php
session_start();
if (!isset($_SESSION["user_id"])) {
header("location: ../index.php");
exit;
}
require_once "../../classes/db_class.php";
require_once "../../includes/functions.php";
$objDb = new db();
$rowCount = 0;
$cat = "";
$cat1 = "";
$option = "";
$sqlTutorial = "select * from job_vtutorials order by vt_name";
$resultTutorial = $objDb->ExecuteQuery($sqlTutorial);
//$rsadvert=mysql_fetch_object($resultadvert);
$rowCount = mysql_num_rows($resultTutorial);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Recruit Young</title>
<link rel="stylesheet" type="text/css" href="../../styles/job.css">
<link rel="stylesheet" type="text/css" href="../styles/job_admin.css">
<script src="../javascript/menubar.js" language="javascript"></script>
<script src="../javascript/admin.js" language="javascript"></script>
<script src="../../javascript/job.js" language="javascript"></script>
if (!isset($_SESSION["user_id"])) {
header("location: ../index.php");
exit;
}
require_once "../../classes/db_class.php";
$objDb = new db();
$arrFunctions = array("Post unlimited number of job ads", "System shortlisting", "System regret function", "Client talent database creation", "Full access to immediately available jobseekers.", "Client logo display", "Intercompany advertisement");
$arrFunctionField = array("unlimited_job_ads", "system_shortlisting", "regret_function", "client_talent", "full_access_jobseekers", "client_logo", "intercompany_ad");
$plan_type = "";
if ($_SESSION["status"] == "1") {
$plan_type = "emp";
} else {
$plan_type = "rec";
}
$sqlPlan = "select * from job_rec_payment_plans where plan_status=1 and type='" . $plan_type . "' order by plan_id";
$resultPlan = $objDb->ExecuteQuery($sqlPlan);
for ($i = 1; $i <= mysql_num_rows($resultPlan); $i++) {
$rsPlan = "rsPlan" . $i;
${$rsPlan} = mysql_fetch_object($resultPlan);
}
function getMark($status)
{
if ($status == 0) {
return '<img src="../../images/wrong_mark.gif">';
} else {
return '<img src="../../images/right_mark.gif">';
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
$urlPage = "";
if (isset($_GET['urlPage'])) {
$urlPage = $_GET['urlPage'];
}
$url = "";
if (isset($_GET["url"])) {
if ($_GET["url"] != "employers_list.php") {
$url .= "../utility/";
}
$url .= $_GET["url"];
}
require_once "../../classes/db_class.php";
require_once "../../includes/functions.php";
$objDb = new db();
$sqlRec = "select * from job_recruiter where rec_id=" . $_GET['rec_id'];
$resultRec = $objDb->ExecuteQuery($sqlRec);
$rsRec = mysql_fetch_object($resultRec);
$arrHeared = explode(",", $rsRec->rec_heared);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Recruit Young</title>
<link rel="stylesheet" type="text/css" href="../../styles/job.css">
<link rel="stylesheet" type="text/css" href="../styles/job_admin.css">
<script src="../javascript/menubar.js" language="javascript"></script>
<script src="../javascript/admin.js" language="javascript"></script>
<script language="javascript">
function goBack(url)
<?php
session_start();
require_once "../classes/db_class.php";
$obj_Db = new db();
$sqluser = "******" . addslashes($_POST['user_name']) . "' and `user_password`='" . addslashes($_POST['user_password']) . "' and `user_status`=1";
$resultuser = $obj_Db->ExecuteQuery($sqluser);
$num = mysql_num_rows($resultuser);
if ($num == 1) {
$rsuser = mysql_fetch_object($resultuser);
$_SESSION["user_id"] = $rsuser->user_id;
$_SESSION["user_name"] = $rsuser->user_name;
header("location:admin_home.php");
} else {
header("location:index.php?id=fail");
}
<?php
session_start();
if (!isset($_SESSION["user_id"])) {
header("location: ../index.php");
exit;
}
require_once "../../classes/db_class.php";
require_once "../../includes/functions.php";
$objDb = new db();
$sqlVat = "select * from job_vat where vat_id=1";
$resultVat = $objDb->ExecuteQuery($sqlVat);
$rsVat = mysql_fetch_object($resultVat);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Recruit Young</title>
<link rel="stylesheet" type="text/css" href="../../styles/job.css">
<link rel="stylesheet" type="text/css" href="../styles/job_admin.css">
<script src="../javascript/menubar.js" language="javascript"></script>
<script src="../javascript/admin.js" language="javascript"></script>
<script src="../../javascript/job.js" language="javascript"></script>
<script language="javascript">
function editVat()
{
if (isset($_GET["link"]) && $_GET["link"] == "new") {
if ($array["pay_status"] == "2") {
$array["received_date"] = date("Y-m-d");
} else {
if ($array["pay_status"] == "4") {
$array["bounce_date"] = date("Y-m-d");
}
}
$objDb->UpdateData("job_rec_payments", $array, "pay_id", $_POST['chk'][$i]);
} else {
if (isset($_GET["link"]) && $_GET["link"] == "rec") {
if ($array["pay_status"] == "1") {
$objDb->UpdateData("job_rec_payments", $array, "pay_id", $_POST['chk'][$i]);
$array["pay_date"] = date("Y-m-d");
$sqlInvoice = "select * from job_rec_invoices i,job_rec_payments p where i.invoice_id=p.invoice_id and p.pay_id=" . $_POST['chk'][$i];
$resultInvoice = $objDb->ExecuteQuery($sqlInvoice);
$rsInvoice = mysql_fetch_object($resultInvoice);
//for recruiter
$sqlRec = "select * from job_recruiter where rec_id=" . $rsInvoice->rec_id;
$resultRec = $objDb->ExecuteQuery($sqlRec);
$rsRec = mysql_fetch_object($resultRec);
//end of recruiter
//for cheque
$sqlCheque = "select * from job_rec_payments where pay_id=" . $_POST['chk'][$i];
$resultCheque = $objDb->ExecuteQuery($sqlCheque);
$rsCheque = mysql_fetch_object($resultCheque);
//end of cheque detail
//for payment
$cnt = mysql_num_rows($resultInvoice);
$paid = 0;
if ($cnt > 0) {
function showId($row, $col)
{
$objDb = new db();
mysql_select_db("test");
$sql = "SELECT g_id \r\n\t\tFROM job_grade_level \r\n\t\tWHERE field_row = " . $row . " \r\n\t\tAND field_column=" . $col;
$res1 = $objDb->ExecuteQuery($sql);
$nums = mysql_num_rows($res1);
$rs = mysql_fetch_object($res1);
$aa = $rs->g_id;
//exit;
if ($nums > 0) {
return $aa;
} else {
return 0;
}
}
<?php
session_start();
if (!isset($_SESSION["user_id"])) {
header("location: ../index.php");
exit;
}
require_once "../../classes/db_class.php";
$objDb = new db();
$sqlTag = "select * from job_tagline";
$resultTag = $objDb->ExecuteQuery($sqlTag);
$rsTag = mysql_fetch_object($resultTag);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Recruit Young</title>
<link rel="stylesheet" type="text/css" href="../../styles/job.css">
<link rel="stylesheet" type="text/css" href="../styles/job_admin.css">
</head>
<body onLoad="MM_preloadImages('images/home1.gif','images/job_seekers1.gif','images/employers_admin1.gif','images/utility1.gif','images/signout1.gif')">
<table width="990" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><?php
include "includes/top.php";
?>
</td>
</tr>
<tr>
$rec_hidename = $_POST["rec_hidename"];
}
if (isset($_POST["rec_hideaddress"])) {
$rec_hideaddress = $_POST["rec_hideaddress"];
}
if (isset($_POST["rec_hideemail"])) {
$rec_hideemail = $_POST["rec_hideemail"];
}
if (isset($_POST["rec_hidename"])) {
$rec_hidecity = $_POST["rec_hidename"];
}
if (isset($_POST["rec_hidetelno"])) {
$rec_hidetelno = $_POST["rec_hidetelno"];
}
$sqlRec = "select * from job_recruiter where rec_id=" . $rec_id;
$resultRec = $objDb->ExecuteQuery($sqlRec);
$rsRec = mysql_fetch_object($resultRec);
$getOldPassword = $rsRec->rec_password;
$rec_vat_regno = $rsRec->rec_vat_regno;
} else {
$sqlRec = "select * from job_recruiter where rec_id=" . $rec_id;
$resultRec = $objDb->ExecuteQuery($sqlRec);
$rsRec = mysql_fetch_object($resultRec);
$rec_name = $rsRec->rec_name;
$comp_name = $rsRec->comp_name;
$comp_type = $rsRec->comp_type;
$company_desc = $rsRec->company_desc;
// Newely added
$rec_address = $rsRec->rec_address;
$rec_postalcode = $rsRec->rec_postalcode;
$rec_city = $rsRec->rec_city;
if (isset($_POST["level"])) {
foreach ($_POST["level"] as $key => $value) {
$array4[$key] = $value;
}
}
//print_r($array3); exit;
//echo($array4[1][0]); exit;
//echo($array2[0][2]); exit;
//echo($array3[2][1]); exit;
//$array["status"] =1;
//echo(sizeof($array4));exit;
$col_head = sizeof($array2[0]);
$row_size = sizeof($array3);
$col_size = sizeof($array4);
for ($i = 1; $i <= $col_head; $i++) {
$res1 = $objDb->ExecuteQuery("UPDATE job_grade_level SET field_value = '" . $array2[0][$i] . "' WHERE field_row = 0 AND field_column = " . $i);
}
for ($i = 1; $i <= $row_size; $i++) {
for ($j = 1; $j <= $col_head; $j++) {
//echo ("UPDATE job_grade_level SET field_value = '".$array3[$i][$j]."' WHERE field_row = ". $i ." AND field_column = ".$j);
$res1 = $objDb->ExecuteQuery("UPDATE job_grade_level SET field_value = '" . $array3[$i][$j] . "' WHERE field_row = " . $i . " AND field_column = " . $j);
}
}
for ($i = 1; $i <= $col_size; $i++) {
$res1 = $objDb->ExecuteQuery("UPDATE job_grade_level SET field_value = '" . $array4[$i][0] . "' WHERE field_row = " . $i . " AND field_column = 0");
$j++;
}
if (isset($_GET['addrowcol'])) {
header("location:gradelevel_add.php");
} else {
header("location:gradelevel_add.php?msg=edit");
<?php
session_start();
if (!isset($_SESSION["user_id"])) {
header("location: ../index.php");
exit;
}
require_once "../../classes/db_class.php";
$objDb = new db();
$sqlLetter = "select * from job_cover_letters where letter_id='" . $_GET["letter_id"] . "'";
$resultLetter = $objDb->ExecuteQuery($sqlLetter);
$rsLetter = mysql_fetch_object($resultLetter);
$rowCount = mysql_num_rows($resultLetter);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Recruit Young</title>
<link rel="stylesheet" type="text/css" href="../../styles/job.css">
<link rel="stylesheet" type="text/css" href="../styles/job_admin.css">
<script src="../javascript/menubar.js" language="javascript"></script>
<script src="../javascript/admin.js" language="javascript"></script>
<script src="../../javascript/job.js" language="javascript"></script>
<script language="javascript">
function editLetter(letter_id)
{
<?php
session_start();
require_once "../../classes/db_class.php";
require_once "../../includes/functions.php";
?>
<?php
$objDb = new db();
$sqlInvoice = "select * from job_rec_invoices where invoice_id=" . $_GET['invoice_id'];
$resultInvoice = $objDb->ExecuteQuery($sqlInvoice);
$rsInvoice = mysql_fetch_object($resultInvoice);
//for recruiter
$sqlRec = "select * from job_recruiter where rec_id=" . $rsInvoice->rec_id;
$resultRec = $objDb->ExecuteQuery($sqlRec);
$rsRec = mysql_fetch_object($resultRec);
//end of recruiter
//for plan
$sqlPlan = "select * from job_rec_payment_plans where plan_id=" . $_GET["plan"];
$resultPlan = $objDb->ExecuteQuery($sqlPlan);
$rsPlan = mysql_fetch_object($resultPlan);
//end ofor plan
//for previous plan
$plan_name = "";
$sqlLastInvoice = "select * from job_rec_invoices i where i.invoice_type=1 and i.rec_id='" . $rsRec->rec_id . "' and (select count(*) from job_rec_payments where invoice_id=i.invoice_id)>0 order by i.invoice_id desc";
$resultLastInvoice = $objDb->ExecuteQuery($sqlLastInvoice);
$cntPlan = mysql_num_rows($resultLastInvoice);
if ($rsLastInvoice = mysql_fetch_object($resultLastInvoice)) {
$plan_name = $rsLastInvoice->plan_name;
} else {
$type_plan = " subscribed";
<?php
session_start();
if (!isset($_SESSION["user_id"])) {
header("location: ../index.php");
exit;
}
require_once "../../classes/db_class.php";
include "../../includes/thumbnail_generator.php";
$objDb = new db();
$array = array();
$_SESSION["post"] = $_POST;
$sqlEmail = "select * from job_recruiter where rec_email='" . $_POST['rec_email'] . "'";
$resultEmail = $objDb->ExecuteQuery($sqlEmail);
if (mysql_num_rows($resultEmail) > 0) {
header("location:new_recruiter.php?msg=error");
}
$array["rec_reg_date"] = date("Y-m-d");
if (isset($_POST["rec_name"])) {
$array["rec_name"] = $_POST["rec_name"];
}
if (isset($_POST["comp_name"])) {
$array["comp_name"] = $_POST["comp_name"];
}
if (isset($_POST["comp_type"])) {
$array["comp_type"] = trim($_POST["comp_type"]);
//1 - employer and 2 - recruiter
}
if (isset($_POST["company_desc"])) {
$array["company_desc"] = $_POST["company_desc"];
}
function sendMailseekerrate($seekerid, $recid)
{
$objDb = new db();
$sqlJob = "select seeker_name,seeker_surname,seeker_email from job_jobseeker where seeker_id='" . $seekerid . "'";
$resultJob = $objDb->ExecuteQuery($sqlJob);
$rsJob = mysql_fetch_object($resultJob);
//print_r($rsJob);
$sqlComp = "select rec_email,rec_name,comp_name from job_recruiter where rec_id='" . $recid . "'";
$resultComp = $objDb->ExecuteQuery($sqlComp);
$rsComp = mysql_fetch_object($resultComp);
//print_r($row);
$adminemail = getFieldValue('job_user', 'user_email', 'user_id', 1);
$str = '<style type="text/css" type="text/css">
.sectionheading
{
font-family: Arial, Helvetica, sans-serif;
font-size:20px;
font-weight:normal;
color: #329900;
text-decoration: none;
}
.table_alternate_row_noboder
{
font-family:Arial, Helvetica, sans-serif;
font-size:12px;
background-color:#E6E6E6;
color: #333333;
text-decoration:none;
}
.subhead_gray_small
{
font-family: Arial, Helvetica, sans-serif;
font-size:13px;
font-weight:bold;
color: #333333;
text-decoration:none;
}
.normal
{
font-family: Arial, Helvetica, sans-serif;
font-size: 13px;
font-style:normal;
color: #000000;
text-decoration:none;
}
</style>
<table width="100%" cellpadding="6" cellspacing="0" class="normal">
<tr>
<td colspan="3"><a href="#Logo"><img alt="Image Not Found" src="images/logonew.png""></a></td>
</tr>
<tr>
<td class="sectionheading" colspan="3"> ' . $rsComp->comp_name . ' Company has Rated on your Resume</td>
</tr>
<tr>
<td> Company Name: <span class="subhead_gray_small">' . $rsComp->comp_name . '</span><br>
</td>
<td> Recruiters Name: <span class="subhead_gray_small">' . $rsComp->rec_name . '</span><br>
</td>
<td> View Date: <span class="subhead_gray_small">' . date('d-m-Y') . '</span><br>
</td>
</tr>
<tr>
<td colspan="3" class="sectionheading"> </td>
</tr>';
$str .= '</table>';
$from = "NamRecruit <*****@*****.**>";
$subject = "Dear" . $rsJob->seeker_name . "a new company rated on your resume";
$headers = "From: {$from}\nContent-Type: text/html; charset=iso-8859-1";
@mail(trim($from), $subject, $str, $headers);
}
require_once "../../includes/functions.php";
require_once "../../classes/pagination.php";
$objDb = new db();
$rowCount = 0;
$sqlPaid = "select * from job_rec_payments where paid_by='Cheque' and pay_status=1 order by pay_id desc";
$cPage = "";
$cPage = isset($_REQUEST['cPage']) ? $_REQUEST['cPage'] : '1';
$baseURL = $_SERVER['PHP_SELF'];
$j = 0;
if (isset($_REQUEST['cPage'])) {
$page = $_REQUEST['cPage'];
$j = ($page - 1) * 10;
}
$pagination = new gsdPagination($sqlPaid, $cPage, '20', $baseURL);
$sqlPaid = $pagination->rQuery;
$resultPaid = $objDb->ExecuteQuery($sqlPaid);
$rowCount = mysql_num_rows($resultPaid);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Recruit Young</title>
<link rel="stylesheet" type="text/css" href="../../styles/job.css">
<link rel="stylesheet" type="text/css" href="../styles/job_admin.css">
<script src="../javascript/menubar.js" language="javascript"></script>
<script src="../javascript/admin.js" language="javascript"></script>
<script src="../../javascript/job.js" language="javascript"></script>
<script language="javascript" type="text/javascript">
function viewDetails(location)
<?php
session_start();
if (!isset($_SESSION["user_id"])) {
header("location: ../index.php");
exit;
}
require_once "../../classes/db_class.php";
require_once "includes/functions.php";
$objDb = new db();
$data = array();
if (isset($_GET["id"]) && $_GET["id"] != "" && $_GET["id"] != 1) {
$sqlLanguage = "select * from job_language where id = " . $_GET["id"] . "";
$resultLang = $objDb->ExecuteQuery($sqlLanguage);
$rowCount = mysql_num_rows($resultLang);
if ($rowCount == 1) {
$rsLang = mysql_fetch_object($resultLang);
delete_directory("../../langues/" . $rsLang->language_name . "/");
$sql = "ALTER TABLE `language` DROP `" . $rsLang->language_shortname . "`";
$result = $objDb->ExecuteQuery($sql);
$objDb->DeleteData("job_language", "id", $_GET["id"]);
}
}
header("location:index.php");
}
$urlPage = "";
if (isset($_GET['urlPage'])) {
$urlPage = $_GET['urlPage'];
}
$url = "";
if (isset($_GET["url"])) {
$url .= $_GET["url"];
}
require_once "../../classes/db_class.php";
require_once "../../classes/pagination.php";
require_once "../../includes/functions.php";
$objDb = new db();
$sqlBook = "select * from job_bookmark_emp where seeker_id='" . $_GET["seeker_id"] . "'";
$sqltemp = "select * from job_jobseeker where seeker_id='" . $_GET["seeker_id"] . "'";
$resulttemp = $objDb->ExecuteQuery($sqltemp);
$rstemp = mysql_fetch_object($resulttemp);
$cPage = "";
$cPage = isset($_REQUEST['cPage']) ? $_REQUEST['cPage'] : '1';
$baseURL = $_SERVER['PHP_SELF'];
$j = 0;
if (isset($_REQUEST['cPage'])) {
$page = $_REQUEST['cPage'];
$j = ($page - 1) * 10;
}
$pagination = new gsdPagination($sqlBook, $cPage, '20', $baseURL);
$sqlBook = $pagination->rQuery;
$resultBook = $objDb->ExecuteQuery($sqlBook);
$rowCount = mysql_num_rows($resultBook);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
header("location: ../index.php");
exit;
}
$urlPage = "";
if (isset($_GET['urlPage'])) {
$urlPage = $_GET['urlPage'];
}
$url = "";
if (isset($_GET["url"])) {
$url = $_GET["url"];
}
require_once "../../classes/db_class.php";
require_once "../../includes/functions.php";
$objDb = new db();
$sqlInvoice = "select * from job_rec_invoices where invoice_id = " . $_GET['invoice_id'];
$resultInvoice = $objDb->ExecuteQuery($sqlInvoice);
$rsInvoice = mysql_fetch_object($resultInvoice);
$pp = 0;
$nameplan = "";
if ($rsInvoice->invoice_type == 2) {
$pp = $rsInvoice->shortlist_rate_per_position * $rsInvoice->shortlisted_jobseekers;
$nameplan = "Shortlisted Jobseekers";
} else {
$pp = $rsInvoice->rate;
$nameplan = $rsInvoice->plan_name;
}
$paid = 0;
$sqlTotalPay = "select sum(pay_amount) as pay_sum from job_rec_payments where pay_status=1 and invoice_id=" . $_GET['invoice_id'];
$resultTotalPay = $objDb->ExecuteQuery($sqlTotalPay);
if ($rsTotalPay = mysql_fetch_object($resultTotalPay)) {
$paid = $rsTotalPay->pay_sum;
header("location: ../index.php");
exit;
}
require_once "../../classes/db_class.php";
require_once "../../includes/functions.php";
$urlPage = "";
if (isset($_GET['urlPage'])) {
$urlPage = $_GET['urlPage'];
}
$url = "";
if (isset($_GET["url"])) {
$url = $_GET["url"];
}
$objDb = new db();
$sqlPay = "select * from job_rec_payments where pay_id = " . $_GET['pay_id'];
$resultPay = $objDb->ExecuteQuery($sqlPay);
$rsPay = mysql_fetch_object($resultPay);
if ($rsPay->pay_status == 0) {
$chkstatus = "Pending";
} else {
if ($rsPay->pay_status == 1) {
$chkstatus = "Received";
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Recruit Young</title>
<?php
require_once "../../classes/db_class.php";
$result = 'NO';
if (isset($_REQUEST['newlangvar_name']) && !empty($_REQUEST['newlangvar_name']) && $_REQUEST['newlangvar_name'] != ' ' && $_REQUEST['selectedpageid'] != '') {
$obj_Db = new db();
$varname = $_REQUEST['newlangvar_name'];
$string = strtoupper(trim($varname));
$string = preg_replace("/\\s+/", "_", $string);
if (!strpos("+", $string)) {
$pattern = array("/^[\\s+]/", "/[\\s+]\$/", "/\\s/");
$replace = array("", "", " ");
$string = preg_replace($pattern, $replace, $string);
}
if ($_REQUEST['selectedpageid'] == 1) {
$sql = "select * from language WHERE name = '" . $string . "'";
} else {
$sql = "select * from language WHERE name = '" . $string . "' and page_id IN(1," . $_REQUEST['selectedpageid'] . ")";
}
$result = $obj_Db->ExecuteQuery($sql);
$numrows = mysql_num_rows($result);
if ($numrows == 0) {
$result = "YES";
} else {
$result = "NO";
}
}
echo json_encode(array('result' => $result));
?>
function add_language_page_name($data)
{
$obj_Db = new db();
$lang_sql = "select * from job_language";
$lang_result = $obj_Db->ExecuteQuery($lang_sql);
$lang_numrows = mysql_num_rows($lang_result);
if ($lang_numrows > 0) {
while ($rowsobj = mysql_fetch_object($lang_result)) {
$handle = @fopen("../../langues/" . $rowsobj->language_name . "/PAGE_" . $data['name'] . "_" . $rowsobj->language_shortname . ".php", 'w+');
@fwrite($handle, "<?php \n");
fclose($handle);
}
$obj_Db = new db();
if ($obj_Db->InsertData('job_language_page', $data)) {
return TRUE;
} else {
return FALSE;
}
}
}
session_start();
if (!isset($_SESSION["user_id"])) {
header("location: ../index.php");
exit;
}
require_once "../../classes/db_class.php";
include "../../includes/thumbnail_generator.php";
$objDb = new db();
$array = array();
//print_r($_POST); exit; // 2010-01-05
if (isset($_POST["voucher_code"]) and $_POST["voucher_code"] != "") {
$vid = "";
$voucherCode = trim($_POST["voucher_code"]);
$sqladvert = "select * from job_voucher_code where voucher_code = '" . $voucherCode . "'";
$resultadvert = $objDb->ExecuteQuery($sqladvert);
$rowCount = mysql_num_rows($resultadvert);
if (isset($_GET['action']) && $_GET['action'] == 'edit') {
//$sqladvert = "select * from job_voucher_code where voucher_code = '". $voucherCode ."' and code_id = ".$_REQUEST["code_id"];
$actn = "edit";
$vid = "&vid=" . $_REQUEST["code_id"];
if ($rowCount > 1) {
echo "<script>location.href=\"code_add.php?action={$actn}&msg=Exist" . $vid . "\";</script>";
exit;
}
} else {
if ($rowCount > 0) {
echo "<script>location.href=\"code_add.php?msg=Exist\";</script>";
exit;
}
}
$cnt = -1;
$cntPlan = -1;
if (isset($_POST["rec_uid"])) {
$rec_uid = $_POST["rec_uid"];
}
if (isset($_POST["rec_email"])) {
$rec_email = $_POST["rec_email"];
}
$objDb = new db();
$arrFunctions = array("Post unlimited number of job ads", "System shortlisting", "System regret function", "Client talent database creation", "Full access to immediately available jobseekers.", "Client logo display", "Intercompany advertisement");
$arrFunctionField = array("unlimited_job_ads", "system_shortlisting", "regret_function", "client_talent", "full_access_jobseekers", "client_logo", "intercompany_ad");
//if($activated_before == 1)
//$sqlPlan = "select * from job_rec_payment_plans where plan_status=1 and rate>0 order by plan_id";
//else
$sqlPlan = "select * from job_rec_payment_plans where plan_status=1 order by plan_id";
$resultPlan = $objDb->ExecuteQuery($sqlPlan);
for ($i = 1; $i <= mysql_num_rows($resultPlan); $i++) {
$rsPlan = "rsPlan" . $i;
${$rsPlan} = mysql_fetch_object($resultPlan);
}
function getMarkAdmin($status)
{
if ($status == 0) {
return '<img src="../../images/wrong_mark.gif">';
} else {
return '<img src="../../images/right_mark.gif">';
}
}
//for recruiter
if (isset($_GET["uid"]) || isset($_GET["remail"])) {
$sqlRec = "select * from job_recruiter where ";
