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 ";