include './admin/config.php'; include './admin/db_connection.php'; $id = $_GET['id']; $_SESSION['job'] = $_REQUEST['jobref']; $_SESSION['qty'] = $_REQUEST['quantity']; $user_id = $_SESSION['sohorepro_userid']; $id_user = $_SESSION['sohorepro_companyid']; $company_id = company_id($user_id); $editAddress = editAddressServices($id); $user_manager = CheckManager($user_id); $state_all = StateAll(); if ($_REQUEST['edit_address'] == '1') { extract($_POST); $sql = "UPDATE sohorepro_address_service SET comp_id = '". $company_id ."',
<?php include "./admin/config.php"; $_SESSION['job'] = $_REQUEST['jobref']; $_SESSION['qty'] = $_REQUEST['quantity']; $user_id = $_SESSION['sohorepro_userid']; $company_id = company_id($user_id); $state_all = StateAll(); if ($_REQUEST['new_address'] == '1') { extract($_POST); $sql = "INSERT INTO sohorepro_address_service SET comp_id = '". $company_id ."', company_name = '". $comp ."', address_1 = '". $add1 ."', address_2 = '". $add2 . "', address_3 = '". $add3 . "', city = '". $city ."', state = '". $state."', zip = '". $zip ."', zip_ext = '" . $zipext."', phone = '". $phone ."', extension = '". $ext ."', attention_to = '". $attention."' "; $sql_result = mysql_query($sql); if ($sql_result) { $result = "success"; } else { $result = "failure"; } } ?>
function company_count() { return Query::table(Base::table('posts'))->where('company', '=', company_id())->where('status', '=', 'published')->count(); }
<?php include './admin/config.php'; include './admin/db_connection.php'; $id = $_GET['id']; $_SESSION['job'] = $_REQUEST['jobref']; $_SESSION['qty'] = $_REQUEST['quantity']; $user_id = $_SESSION['sohorepro_userid']; $id_user = $_SESSION['sohorepro_companyid']; $company_id = company_id($user_id); $editAddress = editAddressServices($id); $user_manager = CheckManager($user_id); $state_all = StateAll(); if ($_REQUEST['edit_address'] == '1') { extract($_POST); $sql = "UPDATE sohorepro_address_service SET comp_id = '". $company_id ."', company_name = '". $comp ."', address_1 = '". $add1 ."', address_2 = '". $add2 . "', address_3 = '". $add3 . "', city = '". $city ."', state = '". $state."', zip = '". $zip ."', zip_ext = '" . $zipext."', phone = '". $phone ."', extension = '". $ext ."', attention_to = '". $attention."' WHERE id = '".$id."' "; $sql_result = mysql_query($sql); if(($user_manager == '1') && ($editAddress[0]['type'] == '1')) {