function update_language_variable($post_data) { if (!isset($post_data['variableid'])) { return false; } $obj_Db = new db(); $lang_sql = "select language_shortname , language_name from job_language"; $lang_result = $obj_Db->ExecuteQuery($lang_sql); $lang_numrows = mysql_num_rows($lang_result); $lang_var_sql = "select name from language where id =" . $post_data['variableid']; $lang_var_result = $obj_Db->ExecuteQuery($lang_var_sql); $lang_var_numrows = mysql_num_rows($lang_var_result); $variablename = ""; if ($lang_var_numrows > 0) { $languagevarrow = mysql_fetch_object($lang_var_result); $variablename = $languagevarrow->name; } if ($lang_numrows > 0) { while ($languagevar = mysql_fetch_object($lang_result)) { $lang_page_sql = "select name from job_language_page where id=" . $post_data['langpageid']; $lang_page_result = mysql_query($lang_page_sql); $lang_page_data = mysql_fetch_object($lang_page_result); $data[$languagevar->language_shortname] = $post_data[$languagevar->language_shortname]; $filename = "../../langues/" . $languagevar->language_name . "/PAGE_" . $lang_page_data->name . "_" . $languagevar->language_shortname . ".php"; update_language_variable_in_lang_file($filename, $variablename, $post_data[$languagevar->language_shortname]); } } $obj_Db->ExecuteQuery("SET NAMES utf8"); $data['page_id'] = $post_data['langpageid']; if ($obj_Db->UpdateData('language', $data, 'id', $post_data['variableid'])) { return TRUE; } else { return FALSE; } }
if (isset($_GET["type"]) && $_GET["type"] == "rec") { if (isset($_POST["rate"])) { $array["rate"] = $_POST["rate"]; } if (isset($_POST["positions"])) { $array["positions"] = $_POST["positions"]; } $array["type"] = "rec"; } else { if (isset($_POST["subscription"])) { if ($_POST["subscription"] == "paid") { if (isset($_POST["rate"])) { $array["rate"] = $_POST["rate"]; } if (isset($_POST["positions"])) { $array["positions"] = $_POST["positions"]; } } else { $array["positions"] = 0; $array["rate"] = 0; } } $array["type"] = "emp"; } if (isset($_POST["rate_per_position"])) { $array["rate_per_job"] = $_POST["rate_per_position"]; } $objDb->UpdateData("job_rec_payment_plans", $array, "plan_id", $_GET["pid"]); header("location:plan_list.php?msg=edit"); ?>
$array["rec_status"] = 0; $_SESSION["status"] = 0; } else { if ($_POST["comp_type"] == "1") { $array["rec_status"] = 1; $_SESSION["status"] = 1; $email = "NamRecruit <*****@*****.**>"; $emailto = $array['rec_email']; $subject = "Registration Successful with NamRecruit."; $msg = "Dear, " . $_POST["rec_name"] . "<br><br>"; $msg .= "Thank you for registering with NamRecruit. <br><br>"; $msg .= "Use following information to login namrecruit.com.<br>"; $msg .= "Username : "******"rec_email"]; $msg .= "<br>Password : "******"rec_password"]; $msg .= "<br><br>Regards, <br>NamRecruit."; mail($emailto, $subject, $msg, "From: {$email}\nContent-Type: text/html; charset=iso-8859-1"); } } $array["rec_IP"] = $_SERVER['REMOTE_ADDR']; $objDb->InsertData("job_recruiter", $array); $rec_id = mysql_insert_id(); $arr_update['rec_uid'] = "JR-" . ($rec_id + 1000); $objDb->UpdateData("job_recruiter", $arr_update, "rec_id", $rec_id); /*$_SESSION["rec_plan"] = 0; $_SESSION["ses_rec_id"] = mysql_insert_id(); $_SESSION["rec_name"] = $array['rec_name']; */ header("location:rec_register_success.php?rec_id=" . $rec_id); ?>
require_once "../../includes/functions.php"; $objDb = new db(); for ($i = 0; $i < count($_POST["chk"]); $i++) { $array = array(); $status = "st_" . $_POST['chk'][$i]; if ($_POST[$status] != "") { $array["pay_status"] = $_POST[$status]; 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];
<?php session_start(); if (!isset($_SESSION["user_id"])) { header("location: ../index.php"); exit; } require_once "../../classes/db_class.php"; $objDb = new db(); $array = array(); $array['vat'] = $_POST['vat']; $array['vat_status'] = $_POST['vat_status']; $objDb->UpdateData("job_vat", $array, "vat_id", "1"); echo "<script language='javascript'>location.href='change_vat_success.php';</script>";
<?php session_start(); if (!isset($_SESSION["user_id"])) { header("location: ../index.php"); exit; } require_once "../../classes/db_class.php"; $objDb = new db(); $array = array(); if (isset($_POST["title"])) { $array["title"] = $_POST["title"]; } if (isset($_POST["msg"])) { $array["msg"] = addslashes($_POST["msg"]); } $objDb->UpdateData("job_cover_letters", $array, "letter_id", $_GET["letter_id"]); header("location:letter_list.php?msg=edit"); ?>
require_once "../../classes/db_class.php"; $objDb = new db(); $array = array(); $array["c_id"] = $_POST["seeker_recruiter"]; print_r($_POST); exit; if (isset($_POST["vt_name"])) { $array["vt_name"] = $_POST["vt_name"]; } $array["vt_status"] = 1; $target_path = ""; $target_path = "../../tutorials/"; $base_name = ""; if ($_FILES["videotutorial"]["name"] != "") { $base_name = basename($_FILES["videotutorial"]["name"]); //$base_name_arr = explode(".",$base_name); //$base_ext = end($base_name_arr); // $base_name = $_POST['banner_image'] . "_" . $_POST['rec_phone'] . "." . $base_ext; $target_path = $target_path . $base_name; if (move_uploaded_file($_FILES["videotutorial"]["tmp_name"], $target_path)) { if ($_FILES["videotutorial"]["name"] != "") { $array["vt_path"] = $base_name; } unlink("../../tutorials/" . $_POST["old_tutorial"] . ""); } } //$array["status"] =1; $objDb->UpdateData("job_vtutorials", $array, "vt_id", $_GET["vtid"]); header("location:tutorial_list.php?msg=edit"); ?>
<?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(); if (isset($_POST["tagline"]) and $_POST["tagline"] != "") { $array["tagline"] = str_replace("'", "’", $_POST["tagline"]); } else { $array["tagline"] = $_POST["tagline1"]; } $objDb->UpdateData("job_tagline", $array, "tagline_id", 1); header("location:change_tagline.php?msg=add"); ?>
$array["comp_logo"] = ""; } else { $comp_logo = $_POST["hid_comp_logo"]; $array["comp_logo"] = $comp_logo; } } } if (isset($_POST["rec_hidename"])) { $array["rec_hidename"] = $_POST["rec_hidename"]; } if (isset($_POST["rec_hideaddress"])) { $array["rec_hideaddress"] = $_POST["rec_hideaddress"]; } if (isset($_POST["rec_hideemail"])) { $array["rec_hideemail"] = $_POST["rec_hideemail"]; } if (isset($_POST["rec_hidecity"])) { $array["rec_hidecity"] = $_POST["rec_hidecity"]; } if (isset($_POST["rec_hidetelno"])) { $array["rec_hidetelno"] = $_POST["rec_hidetelno"]; } if (isset($_POST["rec_password"]) && $_POST["rec_password"] != "") { $array["rec_password"] = $_POST["rec_password"]; } $array["rec_IP"] = $_SERVER['REMOTE_ADDR']; $objDb->UpdateData("job_recruiter", $array, "rec_id", $_POST['rec_id']); header("location:rec_profile.php?msg=updated&rec_id=" . $_POST["rec_id"]); ?>
if ($_FILES["banner_image"]["name"] != "") { $base_name = basename($_FILES["banner_image"]["name"]); //$base_name_arr = explode(".",$base_name); //$base_ext = end($base_name_arr); // $base_name = $_POST['banner_image'] . "_" . $_POST['rec_phone'] . "." . $base_ext; $target_path = $target_path . $base_name; $imgInfo = getimagesize($target_path); //echo $imgInfo[0]." ".$imgInfo[1];exit; if ($imgInfo[0] > 520 || $imgInfo[1] > 80) { $title = $_POST['title']; $url = $_POST['url']; $aid = $_GET["aid"]; echo '<body onload="document.frm1.submit()"> <form name="frm1" action="banner_edit.php?msg=err&aid=' . $aid . '" method="post"> <input type="hidden" name="banner_title" value="' . $title . '" > <input type="hidden" name="banner_url" value="' . $url . '" > </form> </body>'; exit; } if (move_uploaded_file($_FILES["banner_image"]["tmp_name"], $target_path)) { if ($_FILES["banner_image"]["name"] != "") { $array["banner_image"] = $base_name; } } } //print_r($array);exit; $objDb->UpdateData("job_banner", $array, "banner_id", $_GET["aid"]); header("location:banner_list.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(); $array = array(); $array['user_password'] = $_POST['newp']; $objDb->UpdateData("job_user", $array, "user_id", "1"); echo "<script language='javascript'>location.href='change_success.php';</script>";
$rsplanid_next = mysql_fetch_object($resultplanid_next); $current_plan_id_next = $rsplanid_next->plan_id; $next_add = $rsplanid_next->additional_job; //end of next plan if ($rs_sq->number_job > 0 && $rsplanid_next->number_job > 0) { //echo "ll"; //echo $rs_sq->remaining_job; //if($rs_sq->rate<=$rsplanid_next->rate) //{ $cntjob_post = getCount("select * from job_ad where invoice_id=" . $in_id . " and rec_id='" . $rs_sq->rec_id . "'"); $res_cnt_additional_job = $objDb->ExecuteQuery("select sum(additional_job) as add_job from job_rec_invoices where invoice_id>" . $in_id . " and rec_id='" . $rs_sq->rec_id . "' and invoice_type=5 and invoice_status=1"); $rs_cnt = mysql_fetch_object($res_cnt_additional_job); $cnt_additional_job = $rs_cnt->add_job; if ($rs_sq->additional_job > $rs_sq->number_job + $rs_sq->additional_job - $cntjob_post) { $arr_remain["additional_job"] = $next_add + ($rs_sq->number_job + $rs_sq->additional_job - $cntjob_post); $objDb->UpdateData("job_rec_invoices", $arr_remain, "invoice_id", $_GET["Iid"]); } else { $arr_remain["additional_job"] = $next_add + $rs_sq->additional_job; $objDb->UpdateData("job_rec_invoices", $arr_remain, "invoice_id", $_GET["Iid"]); } /*$jj=$rs_sq->number_job+$rs_sq->remaining_job+$cnt_additional_job;//echo $jj; if($cntjob_post>=$jj){ $post_job=-1; } else { $post_job=$jj-$cntjob_post;} if($post_job==$jj) { //echo "kk"; $arr_remain["remaining_job"]=$rs_sq->additional_job+$rs_sq->remaining_job+$cnt_additional_job; $objDb->UpdateData("job_rec_invoices",$arr_remain,"invoice_id",$_GET["Iid"]); } else if($post_job==($rs_sq->number_job-$rs_sq->additional_job)) {
$objDb->InsertData("job_options", $array); GenerateXML(); if (isset($_GET["cat_id"]) && $_GET["cat_id"] != "") { header("location:option_add.php?cat_id=" . $_GET["cat_id"] . "&msg=add&action=" . $_GET["action"]); } else { header("location:option_add.php?msg=add&action=" . $_GET["action"]); } } else { if (isset($_GET["action"]) && $_GET["action"] == "edit") { if (isset($_POST["category_id"])) { $array["category_id"] = $_POST["category_id"]; } if (isset($_POST["option_name"])) { $array["option_name"] = $_POST["option_name"]; } $objDb->UpdateData("job_options", $array, "option_id", $_GET["oid"]); GenerateXML(); if (isset($_GET["cat_id"]) && $_GET["cat_id"] != "") { header("location:option_add.php?cat_id=" . $_GET["cat_id"] . "&msg=edit&action=add"); } else { header("location:option_add.php?msg=edit&action=add"); } } else { if (isset($_GET["action"]) && $_GET["action"] == "delete") { $objDb->DeleteData("job_options", "option_id", $_GET["oid"]); GenerateXML(); if (isset($_GET["cat_id"]) && $_GET["cat_id"] != "") { header("location:option_add.php?cat_id=" . $_GET["cat_id"] . "&msg=delete&action=add"); } else { header("location:option_add.php?msg=delete&action=add"); }
require_once "../../classes/db_class.php"; require_once "../../includes/functions1.php"; $objDb = new db(); $sqlRec = "select * from job_rec_invoices i,job_recruiter r where i.invoice_id=" . $_GET["Iid"] . " and r.rec_id=i.rec_id"; $resultRec = $objDb->ExecuteQuery($sqlRec); $rsRec = mysql_fetch_object($resultRec); if ($rsRec->invoice_type == 1) { require_once "includes/accnt_function.php"; } else { if ($rsRec->invoice_type == 5) { require_once "includes/accnt_upgraded.php"; } } $array["pay_status"] = 1; $array["pay_date"] = date("Y-m-d"); $objDb->UpdateData("job_rec_payments", $array, "pay_id", $_GET["pid"]); $array1["invoice_status"] = 1; $objDb->UpdateData("job_rec_invoices", $array1, "invoice_id", $_GET["Iid"]); //echo $msg."--".$rsRec->rec_status;exit; //for comp type $sqlComp = "select * from job_rec_payment_plans p,job_rec_invoices i where i.plan_name=p.plan_name and i.invoice_id=" . $_GET["Iid"]; $resultComp = $objDb->ExecuteQuery($sqlComp); $rsComp = mysql_fetch_object($resultComp); if ($rsRec->rec_status == 0 && $rsComp->type == "rec") { $emailto = $rsRec->rec_email; $subject = "Login information of namrecruit.com"; $msg = "Dear " . $rsRec->rec_name . ",<br><br>"; $msg .= "Thank you for registering with NamRecruit. <br><br>"; $msg .= "Use following information to login namrecruit.com.<br>"; $msg .= "Username : "******"<br>Password : " . $rsRec->rec_password;
<?php session_start(); if (!isset($_SESSION["user_id"])) { header("location: ../index.php"); exit; } require_once "../../classes/db_class.php"; $objDb = new db(); if (isset($_POST["user_name"])) { $array["user_name"] = $_POST["user_name"]; } if (isset($_POST["user_first_name"])) { $array["user_first_name"] = $_POST["user_first_name"]; } if (isset($_POST["user_last_name"])) { $array["user_last_name"] = $_POST["user_last_name"]; } if (isset($_POST["user_email"])) { $array["user_email"] = $_POST["user_email"]; } if (isset($_POST["user_phone"])) { $array["user_phone"] = $_POST["user_phone"]; } if (isset($_POST["user_copyright"])) { $array["user_copyright"] = $_POST["user_copyright"]; } $objDb->UpdateData("job_user", $array, "user_id", $_GET["uid"]); header("location:home.php"); ?>
<?php session_start(); if (!isset($_SESSION["user_id"])) { header("location: ../index.php"); exit; } require_once "../../classes/db_class.php"; $objDb = new db(); $array = array(); if (isset($_POST["title"])) { $array["title"] = $_POST["title"]; } if (isset($_POST["url"])) { $array["url"] = $_POST["url"]; } if (isset($_POST["desc1"])) { $array["desc1"] = $_POST["desc1"]; } $objDb->UpdateData("job_top_sites", $array, "site_id", $_GET["aid"]); header("location:advert_list.php?msg=edit"); ?>
$array["telephone"] = $_POST["telephone"]; } if (isset($_POST["street_address"])) { $array["street_address"] = $_POST["street_address"]; } if (isset($_POST["location"])) { $array["location"] = $_POST["location"]; } if (isset($_POST["desc_partnership"])) { $array["desc_partnership"] = $_POST["desc_partnership"]; } $target_path = ""; $target_path = "../../upload_logo/"; $base_name = ""; if ($_FILES["logo"]["name"] != "") { $base_name = basename($_FILES["logo"]["name"]); //$base_name_arr = explode(".",$base_name); //$base_ext = end($base_name_arr); // $base_name = $_POST['banner_image'] . "_" . $_POST['rec_phone'] . "." . $base_ext; $target_path = $target_path . $base_name; if (move_uploaded_file($_FILES["logo"]["tmp_name"], $target_path)) { if ($_FILES["logo"]["name"] != "") { $array["logo"] = $base_name; } } } //$array["status"] =1; $objDb->UpdateData("job_partner", $array, "partner_id", $_GET["pid"]); header("location:partner_list.php?msg=edit"); ?>
function recruiter_preview($comp_logo) { $objDb = new db(); $sqltemp = "truncate table job_recruiter_temp"; $resulttemp = $objDb->ExecuteQuery($sqltemp); $array = array(); if (isset($_POST["rec_name"])) { $array["rec_name"] = $_POST["rec_name"]; $array["comp_name"] = $_POST["comp_name"]; $array["comp_type"] = $_POST["comp_type"]; //1 - employer and 2 - recruiter $array["company_desc"] = $_POST["company_desc"]; $array["rec_address"] = $_POST["rec_address"]; $array["rec_postalcode"] = $_POST["rec_postalcode"]; if ($_POST["rec_city"] == "--- Other ---") { $array["rec_city"] = $_POST["other_rec_city"]; } else { $array["rec_city"] = $_POST["rec_city"]; } //$array["rec_state"] = $_POST["rec_state"]; //$array["rec_country"] = $_POST["rec_country"]; $array["business_street"] = $_POST["business_street"]; $array["business_street_num"] = $_POST["business_street_num"]; $array["business_suburb"] = $_POST["business_suburb"]; $array["business_city"] = $_POST["business_city"]; $array["business_country"] = $_POST["business_country"]; $array["postal_po_box"] = $_POST["postal_po_box"]; $array["postal_private_bag"] = $_POST["postal_private_bag"]; $array["postal_post_code"] = $_POST["postal_post_code"]; $array["postal_city"] = $_POST["postal_city"]; $array["postal_country"] = $_POST["postal_country"]; if (isset($_POST["postal_region"]) and $_POST["postal_region"] == 16) { $array["postal_region"] = $_POST["other_region"]; } else { if (isset($_POST["postal_region"])) { $array["postal_region"] = $_POST["postal_region"]; } else { $array["postal_region"] = $_POST["postal_region1"]; } } $array["rec_phone"] = $_POST["rec_phone"]; $array["rec_mobile"] = $_POST["rec_mobile"]; $array["rec_fax"] = $_POST["rec_fax"]; $array["rec_email"] = $_POST["rec_email"]; $array["rec_web"] = $_POST["rec_web"]; if (isset($_POST["chkLogo"])) { $array["comp_logo"] = ""; } else { $array["comp_logo"] = $comp_logo; } if (isset($_POST["rec_hidename"])) { $array["rec_hidename"] = $_POST["rec_hidename"]; } if (isset($_POST["rec_hideaddress"])) { $array["rec_hideaddress"] = $_POST["rec_hideaddress"]; } if (isset($_POST["rec_hideemail"])) { $array["rec_hideemail"] = $_POST["rec_hideemail"]; } if (isset($_POST["rec_hidecity"])) { $array["rec_hidecity"] = $_POST["rec_hidecity"]; } if (isset($_POST["rec_hidetelno"])) { $array["rec_hidetelno"] = $_POST["rec_hidetelno"]; } if (isset($_POST["rec_password"])) { $array["rec_password"] = $_POST["rec_password"]; } //Where did you hear about NamRecruit? $heared = ""; if (isset($_POST["email"])) { $heared .= $_POST["email"] . ","; } if (isset($_POST["google"])) { $heared .= $_POST["google"] . ","; } if (isset($_POST["anothersearchengine"])) { $heared .= $_POST["anothersearchengine"] . ","; } if (isset($_POST["friend"])) { $heared .= $_POST["friend"] . ","; } if (isset($_POST["tv"])) { $heared .= $_POST["tv"] . ","; } if (isset($_POST["radio"])) { $heared .= $_POST["radio"] . ","; } if (isset($_POST["newspaper"])) { $heared .= $_POST["newspaper"] . ","; } if (isset($_POST["magazine"])) { $heared .= $_POST["magazine"] . ","; } if (isset($_POST["banner"])) { $heared .= $_POST["banner"] . ","; } if (isset($_POST["other"])) { $heared .= $_POST["other"] . ","; } if (strlen($heared) > 0) { $heared = substr($heared, 0, strlen($heared) - 1); } $array["rec_heared"] = $heared; if (isset($_POST["rec_terms"])) { $array["rec_terms"] = $_POST["rec_terms"]; } $array["rec_status"] = 1; $array["rec_IP"] = $_SERVER['REMOTE_ADDR']; $objDb->InsertData("job_recruiter_temp", $array); $arr_update['rec_uid'] = "JR-" . (mysql_insert_id() + 1000); $objDb->UpdateData("job_recruiter_temp", $arr_update, "rec_id", mysql_insert_id()); echo "<script language='javavscript' type='text/javascript'>window.open('recruiter_preview.php','RegistrationPreview','width=700,height=650,menubar=no,status=yes,location=yes,toolbar=no,scrollbars=yes');</script>"; } }
} if (isset($_POST["opt"]) and $_POST["opt"] == 1) { if (isset($_POST["rec_id"]) and $_POST["rec_id"] != "") { foreach ($_POST['rec_id'] as $cid) { $recTxt .= trim($cid) . ","; } //$array["rec_id"] = substr( $recTxt , 0 , - (strlen( $recTxt - 1)) ) ; $array["rec_id"] = rtrim($recTxt, ','); } } else { if (isset($_POST["opt"]) and $_POST["opt"] == 0) { $array["rec_id"] = "all"; } } //echo ($array["rec_id"]); exit; if (isset($_GET['action']) && $_GET['action'] == 'add') { $array["status"] = 1; $objDb->InsertData("job_voucher_code", $array); $vid = mysql_insert_id(); $msg = "&msg=add&vid=" . $vid; } if (isset($_GET['action']) && $_GET['action'] == 'edit') { if (isset($_POST['code_id']) && $_POST['code_id'] != "") { $vid = $_POST['code_id']; $objDb->UpdateData("job_voucher_code", $array, "code_id", $vid); $msg = "&msg=edit&vid=" . $vid; } } header("location:code_add.php?action=edit" . $msg); ?>
$postExpired = 0; } $post_job = 0; //echo $current_plan_id; //echo $in_id; if ($current_plan_id != "") { //echo "ll"; $sq = "select * from job_rec_invoices where invoice_id=" . $in_id; $resultsq = $objDb->ExecuteQuery($sq); $rs_sq = mysql_fetch_object($resultsq); //for extra jobs $sql_extra = "select * from job_rec_invoices where invoice_id=" . $_GET["Iid"]; $result_extra = $objDb->ExecuteQuery($sql_extra); $rs_extra = mysql_fetch_object($result_extra); $arr_remain["additional_job"] = $rs_sq->additional_job + $rs_extra->additional_job; $objDb->UpdateData("job_rec_invoices", $arr_remain, "invoice_id", $in_id); //print_r($arr_remain);exit; /* $resultplanid_next = $objDb->ExecuteQuery($sqlplanid_next); $rsplanid_next = mysql_fetch_object($resultplanid_next); $current_plan_id_next=$rsplanid_next->plan_id; //end of extra job //for next plan $sqlplanid_next="select * from job_rec_payment_plans p,job_rec_invoices i where p.plan_name=i.plan_name and invoice_id=".$_GET["Iid"]; $resultplanid_next = $objDb->ExecuteQuery($sqlplanid_next); $rsplanid_next = mysql_fetch_object($resultplanid_next); $current_plan_id_next=$rsplanid_next->plan_id;