ype_id = $aRow['id'];
$car_type_name = $aRow['name'];
$show_title = $aRow['show_title'];
$count1 = 0;
$count2 = 0;
//echo "SELECT GROUP_CONCAT(id ) as id FROM `make` WHERE `cartype`='$car_type_id' or `cartype1`='$car_type_id' or `cartype2`='$car_type_id'"."
";
$query = $this->db->query("SELECT GROUP_CONCAT(id ) as id FROM `make` WHERE `cartype`='$car_type_id' or `cartype1`='$car_type_id' or `cartype2`='$car_type_id' or `cartype3`='$car_type_id'");
if ($query->num_rows() > 0) {
$result2 = $query->row_array();
$makeid = trim($result2["id"], ",");
// $makeid = trim($result2["id"],",");
if ($makeid != "") {
if($used_cars==0){
$cartypecount = "select count(*) count from listings inner join clients on listings.client_id=clients.client_id where $where
and publish_ocd='1' and emirate='$emirate' and listings.client_id in
(select client_id from `clients` where emirate like '%$emirate%')
and ( car_make in ( SELECT id FROM `make` WHERE `cartype`='$car_type_id' or `cartype1`='$car_type_id' or `cartype2`='$car_type_id' or `cartype3`='$car_type_id' ) or (car_type=$car_type_id) ) ";
}
else
{
$cartypecount = "select count(*) count from usedcar_listings inner join clients on usedcar_listings.client_id=clients.client_id where $where
and publish_ocd='1' and usedcar_listings.used_cars='$used_cars' and emirate='$emirate' and usedcar_listings.client_id in
(select client_id from `clients` where emirate like '%$emirate%')
and ( car_make in ( SELECT id FROM `make` WHERE `cartype`='$car_type_id' or `cartype1`='$car_type_id' or `cartype2`='$car_type_id' or `cartype3`='$car_type_id' ) or (car_type=$car_type_id) ) ";
}
//echo $cartypecount."
";
$query1 = $this->db->query($cartypecount);
if ($query1->num_rows > 0) {
$result3 = $query1->row_array();
$count2 = $result3["count"];
}
} else {
if($used_cars==0){
$cartypecount = "select count(*) count from listings inner join clients on listings.client_id=clients.client_id where $where
and publish_ocd='1' and emirate='$emirate' and listings.client_id in
(select client_id from `clients` where emirate like '%$emirate%') and (car_type=$car_type_id) ";
}
else
{
$cartypecount = "select count(*) count from usedcar_listings inner join clients on usedcar_listings.client_id=clients.client_id where $where
and publish_ocd='1' and usedcar_listings.used_cars='$used_cars' and emirate='$emirate' and usedcar_listings.client_id in
(select client_id from `clients` where emirate like '%$emirate%') and (car_type=$car_type_id) ";
}
$query1 = $this->db->query($cartypecount);
if ($query1->num_rows > 0) {
$result3 = $query1->row_array();
$count2 = $result3["count"];
}
}
}
$count = $count1 + $count2;
if ($count > 0)
$list[$count][$car_type_name] = $car_type_id . "-*" . $count . "-*" . $show_title;
}
krsort($list);
$data = [];
foreach ($list as $res => $key) {
foreach ($key as $keyarray => $dat) {
$data[$keyarray] = $dat;
}
}
} catch (Exception $e) {
$data = [];
}
$this->memcached_library->add($key_cache, $data, 86400);
$this->set_memcachekeys($key_cache);
return $data;
} else {
return $get_cartypes_srch_2;
}
}
function get_car_spec_list_search($where_all = 1,$usedcar = 0,$emirate="Dubai"){
$key_cache = 'get_car_spec_list2345453@' .$where_all.$usedcar.$emirate;
$get_client_detail = $this->memcached_library->get($key_cache);
if (!$get_client_detail && !is_numeric($get_client_detail)) {
$returnCarSpecs = [];
$statement = "SELECT cs.car_spec_id specId, cs.car_spec_name specName, count(ul.id) listingCount
FROM ";
if($usedcar == 0){
$statement .= "`listings` ul ";
}else{
$statement .= "`usedcar_listings` ul ";
}
$where_all= str_ireplace("usedcar_listings","ul",$where_all);
$where_all= str_ireplace("listings","ul",$where_all);
//added by nikhil to fix clients to cl as per above logic
$where_all = str_replace("clients.airport_meetgreet", "cl.airport_meetgreet", $where_all);
// Old SQL commented
// $statement .= " JOIN car_specs cs on cs.car_spec_id = ul.`car_spec_id` JOIN clients cl on cl.client_id=ul.client_id
// WHERE $where_all and cl.emirate='$emirate' and ul.delete_status = 0 and ul.publish_ocd = 1 GROUP by cs.car_spec_id ORDER BY
// CASE WHEN cs.car_spec_name = 'GCC Specs' THEN 0 ELSE 1 END, cs.car_spec_name ASC " ;
// Convert final where condition into query binding style for prevent the SQL Injection
$where_final = $where_all ." and cl.emirate='$emirate' and ul.delete_status = 0 and ul.publish_ocd = 1 ";
list($safe_conditions, $bind_array) = bind_where_condition($where_final);
// Update the query with safe conditions
$statement .= " JOIN car_specs cs on cs.car_spec_id = ul.`car_spec_id` JOIN clients cl on cl.client_id=ul.client_id
WHERE $safe_conditions GROUP by cs.car_spec_id ORDER BY
CASE WHEN cs.car_spec_name = 'GCC Specs' THEN 0 ELSE 1 END, cs.car_spec_name ASC ";
// Run with with safe parmetrized query
$query = $this->db->query($statement, $bind_array);
$result = $query->result_array();
if(!empty($result)){
foreach($result as $record){
$returnCarSpecsTemp = [];
$returnCarSpecsTemp['specId'] = $record['specId'];
$returnCarSpecsTemp['specName'] = str_replace("Specs", "", $record['specName']);
$returnCarSpecsTemp['listingCount'] = $record['listingCount'];
array_push($returnCarSpecs, $returnCarSpecsTemp);
}
}
$this->memcached_library->add($key_cache, $returnCarSpecs, 86400);
$this->set_memcachekeys($key_cache);
return $returnCarSpecs;
}
else
{
return $get_client_detail;
}
}
function get_cartypes_srcharabic_2($where, $emirate)
{
$sql = "select car_type , count(*) count from listings inner join clients on listings.client_id=clients.client_id where $where and publish_ocd='1' and emirate='$emirate' group by car_type";
$result = mysql_query($sql);
while ($aRow = mysql_fetch_array($result)) {
$car_type = $aRow['car_type'];
$cartype = $this->get_name($car_type, "car_types", "name_arabic,show_title");
$list[$cartype["name_arabic"]] = $car_type . "-*" . $aRow['count'] . "-*" . $cartype['show_title'];
}
return $list;
}
function get_cartypesid($where)
{
$sql = "select id from car_types where $where";
$result = mysql_query($sql);
while ($aRow = mysql_fetch_array($result)) {
$ids[] = $aRow['id'];
}
return $ids;
}
function get_carmakeid($where)
{
$sql = "select id from models where $where";
$result = mysql_query($sql);
while ($aRow = mysql_fetch_array($result)) {
$ids[] = $aRow['id'];
}
return $ids;
}
function get_caroptionid($where)
{
$sql = "select id from pickup_policy where $where";
$result = mysql_query($sql);
while ($aRow = mysql_fetch_array($result)) {
$ids[] = $aRow['id'];
}
return $ids;
}
function get_carcompany($where)
{
$sql = "select client_id , count(*) count from listings where $where and publish_ocd='1' group by client_id";
$result = mysql_query($sql);
while ($aRow = mysql_fetch_array($result)) {
$client_id = $aRow['client_id'];
$client = $this->get_company($client_id, "clients", "company_name");
$list[$client["company_name"]] = $client_id . "-" . $aRow['count'];
}
return $list;
}
function get_search_usedcar_carcompany($where, $emirate)
{
$key_cache = 'get_search_usedcar_carcompany1@' . $where . '@' . $emirate;
$get_search_carcompany = $this->memcached_library->get($key_cache);
if (!$get_search_carcompany && !is_numeric($get_search_carcompany)) {
$sql = "select usedcar_listings.client_id , count(*) count from usedcar_listings INNER JOIN clients ON usedcar_listings.client_id=clients.client_id where $where and clients.emirate='$emirate' and publish_ocd='1' group by usedcar_listings.client_id";
$result = mysql_query($sql) or die(mysql_error());
while ($aRow = mysql_fetch_array($result)) {
$client_id = $aRow['client_id'];
$client = $this->get_company($client_id, "clients", "company_name");
$list[$client["company_name"]] = $client_id . "-" . $aRow['count'];
}
$this->memcached_library->add($key_cache, $list, 86400);
$this->set_memcachekeys($key_cache);
return $list;
} else {
return $get_search_carcompany;
}
}
function get_search_carcompany($where, $emirate,$used_cars=0)
{
$key_cache = 'get_search_carcompany3@' . $where . '@' . $emirate.$used_cars;
$get_search_carcompany = $this->memcached_library->get($key_cache);
if (!$get_search_carcompany && !is_numeric($get_search_carcompany)) {
if($used_cars==0){
$sql = "select listings.client_id , count(*) count from listings INNER JOIN clients ON listings.client_id=clients.client_id where $where and clients.emirate='$emirate' and publish_ocd='1' group by listings.client_id";
}
else {
$sql = "select usedcar_listings.client_id , count(*) count from usedcar_listings INNER JOIN clients ON usedcar_listings.client_id=clients.client_id where $where and clients.emirate='$emirate' and (usedcar_listings.used_cars='1' OR usedcar_listings.used_cars='2') and publish_ocd='1' group by usedcar_listings.client_id";
}
$result = mysql_query($sql) or die(mysql_error());
while ($aRow = mysql_fetch_array($result)) {
$client_id = $aRow['client_id'];
$client = $this->get_company($client_id, "clients", "company_name");
$list[$client["company_name"]] = $client_id . "-" . $aRow['count'];
}
$this->memcached_library->add($key_cache, $list, 86400);
$this->set_memcachekeys($key_cache);
return $list;
} else {
return $get_search_carcompany;
}
}
function get_client_more_rental($client) {
$sql = "select more_rentals from clients where client_id = '$client'";
$result = mysql_query($sql) or die(mysql_error());
while ($aRow = mysql_fetch_array($result)) {
$more_rentals = $aRow['more_rentals'];
}
return $more_rentals;
}
function get_search_carcompany_arabic($where, $emirate)
{
$sql = "select listings.client_id , count(*) count from listings INNER JOIN clients ON listings.client_id=clients.client_id where $where and clients.emirate='$emirate' and publish_ocd='1' group by listings.client_id";
$result = mysql_query($sql) or die(mysql_error());
while ($aRow = mysql_fetch_array($result)) {
$client_id = $aRow['client_id'];
$client = $this->get_company($client_id, "clients", "company_name_arabic");
$list[$client["company_name_arabic"]] = $client_id . "-" . $aRow['count'];
}
return $list;
}
function get_carcompanyid($where)
{
$sql = "select id from clients where $where";
$result = mysql_query($sql);
$rows = mysql_fetch_assoc($result);
return $rows;
}
function get_all_usedcar_clients($where = null)
{
if($where != null) {
$sql = $this->db->query("SELECT `client_id`,`company_name`,`limit_number`,`emirate` FROM `clients` WHERE more_rentals = 5 $where");
} else {
$sql = $this->db->query("SELECT `client_id`,`company_name`,`limit_number`,`emirate` FROM `clients` WHERE more_rentals = 5");
}
$rows = [];
$results = $sql->result();
$k = 0;
if ($results) {
foreach ($results as $res) {
$rows[$k]['client_id'] = $res->client_id;
$rows[$k]['company_name'] = $res->company_name;
$rows[$k]['emirate'] = $res->emirate;
$sql8=mysql_query("select * from usedcar_listings where client_id='$res->client_id' and publish_ocd='1' and delete_status='0'") or die(mysql_error());
$rows[$k]['total_listings']=mysql_num_rows($sql8);
$rows[$k]['total_client_listing']=$res->limit_number;
$k++;
}
}
return $rows;
}
function get_all_clients()
{
$sql = $this->db->query("SELECT `client_id`,`company_name` FROM `clients` ");
$rows = [];
$results = $sql->result();
$k = 0;
if ($results) {
foreach ($results as $res) {
$rows[$k]['client_id'] = $res->client_id;
$rows[$k]['company_name'] = $res->company_name;
$k++;
}
}
return $rows;
}
function get_all_clients_display()
{
$sql = $this->db->query("SELECT `client_id`,`company_name` FROM `clients` ");
$rows = [];
$results = $sql->result();
$k = 0;
if ($results) {
foreach ($results as $res) {
// $rows[$k]['client_id'] =$res->client_id;
$rows[$res->client_id] = $res->company_name;
$k++;
}
}
return $rows;
}
function getbuggy_carscount($where)
{
$key_cache = 'getbuggy_carscount@' . $where;
//$this->memcached_library->delete($key_cache);
$getbuggy_carscount = $this->memcached_library->get($key_cache);
if (!$getbuggy_carscount && !is_numeric($getbuggy_carscount)) {
$sql = "select count(*) count from buggy_listing inner join clients on buggy_listing.client_id=clients.client_id where $where and car_type = '32' and publish_ocd='1'";
$result = mysql_query($sql);
$aRow = mysql_fetch_array($result);
$count = $aRow['count'];
$this->memcached_library->add($key_cache, $count, 86400);
$this->set_memcachekeys($key_cache);
return $count;
} else {
return $getbuggy_carscount;
}
}
function get_carscount($where=null,$used_cars=0)
{
$key_cache = 'get_carscount24@' . $where.$used_cars;
//$this->memcached_library->delete($key_cache);
$get_carscount = $this->memcached_library->get($key_cache);
if (!$get_carscount && !is_numeric($get_carscount)) {
if($used_cars==0)
{
$sql = "select count(*) count from listings inner join clients on listings.client_id=clients.client_id where $where and used_cars='$used_cars' and publish_ocd='1'";
}
else{
$sql = "select count(*) count from usedcar_listings inner join clients on listings.client_id=clients.client_id where $where and used_cars='$used_cars' and publish_ocd='1'";
}
$result = mysql_query($sql);
$aRow = mysql_fetch_array($result);
$count = $aRow['count'];
$this->memcached_library->add($key_cache, $count, 86400);
$this->set_memcachekeys($key_cache);
return $count;
} else {
return $get_carscount;
}
}
function get_carscount_home($where)
{
$key_cache = 'get_carscounts1234@' . $where;
$get_carscount = $this->memcached_library->get($key_cache);
if (!$get_carscount && !is_numeric($get_carscount)) {
// $sql = "select count(*) count from listings where $where and and publish_ocd='1' and delete_status='0'";
$sql = "select count(*) count from listings where delete_status = 0 and car_type != 2 and daily_price_status='1' and listings.client_id in (select client_id from `clients` where emirate like '%Dubai%') and listings.client_id!=247 and publish_ocd='1' ";
$result = mysql_query($sql);
$aRow = mysql_fetch_array($result);
$count = $aRow['count'];
$this->memcached_library->add($key_cache, $count, 86400);
$this->set_memcachekeys($key_cache);
return $count;
} else {
return $get_carscount;
}
}
function get_premcarscount()
{
$key_cache = 'get_premcarscount';
$get_premcarscount = $this->memcached_library->get($key_cache);
if (!$get_premcarscount && !is_numeric($get_premcarscount)) {
$sql = "select count(*) count from listings INNER JOIN clients on listings.client_id=clients.client_id where delete_status = 0 and publish_ocd='1' and daily_price >= 400 and emirate='Dubai'";
$result = mysql_query($sql);
$aRow = mysql_fetch_array($result);
$count = $aRow['count'];
$this->memcached_library->add($key_cache, $count, 86400);
$this->set_memcachekeys($key_cache);
return $count;
} else {
return $get_premcarscount;
}
}
function get_sportscount_home()
{
$key_cache = 'get_sportscount_home7';
$get_sportscount = $this->memcached_library->get($key_cache);
if (!$get_sportscount && !is_numeric($get_sportscount)) {
/* $query_make = $this->db->query("SELECT GROUP_CONCAT(id ) as id FROM `make` WHERE `cartype` in (7) or `cartype1` in (7) or `cartype2` in (7) ");
$makeid = "";
if($query_make->num_rows() > 0){
$result = $query_make->row_array();
$makeid = $result["id"];
}
$sql = "select count(*) count from listings where delete_status = 0 and car_type != 2 and daily_price_status='1' and
(car_make in ($makeid) or
(car_type='7')or car_make in (SELECT id from make where doors='2')
and car_type NOT IN ('3','9','11','14')or
(keywords like '%Convertible%' or keywords like '%gtc%' or keywords like '%dawn%' or keywords like '%cabriolet%' or
keywords like '%grancabrio%' or keywords like '%spyder%' or car_make='481' or car_make='438')) and
listings.client_id in (select client_id from `clients` where emirate like '%Dubai%') and
listings.client_id!=247 and publish_ocd='1' ";
$result = mysql_query($sql);
$aRow = mysql_fetch_array($result);
$count = $aRow['count'] ;
$this->memcached_library->add($key_cache, $count, 3600);
$this->set_memcachekeys($key_cache);
return $count;*/
//$sql = "select count(*) count from listings inner join make on listings.car_make=make.id where publish_ocd='1' and delete_status = 0 and listings.car_type != 2 and daily_price_status='1' and (make.cartype in (7) or make.cartype1 in (7) or make.cartype2 in (7)) and client_id in (select client_id from clients where emirate='Dubai')";
$sql = "select count(*) count from listings inner join clients on listings.client_id=clients.client_id where delete_status = 0 and car_type != 2 and daily_price_status='1' and (car_make in (SELECT id FROM `make` WHERE `cartype` in (7) or `cartype1` in (7) or `cartype2` in (7) or `cartype3` in (7)) or car_type='7' ) and clients.emirate like '%Dubai%' and ( IF(`daily_price_offer` != '=', daily_price_offer >='850', daily_price >= 850) and daily_price!='0') and listings.client_id!=247 and publish_ocd='1'";
$result = mysql_query($sql);
$aRow = mysql_fetch_array($result);
$count = $aRow['count'];
$this->memcached_library->add($key_cache, $count, 86400);
$this->set_memcachekeys($key_cache);
return $count;
} else {
return $get_sportscount;
}
}
function get_luxurycount()
{
$key_cache = 'get_luxurycount9';
$get_premcarscount = $this->memcached_library->get($key_cache);
if (!$get_premcarscount && !is_numeric($get_premcarscount)) {
/* $query_make = $this->db->query("SELECT GROUP_CONCAT(id ) as id FROM `make` WHERE `cartype` in (4,8) or `cartype1` in (4,8) or `cartype2` in (4,8) ");
$makeid = "";
if($query_make->num_rows() > 0){
$result = $query_make->row_array();
$makeid = $result["id"];
}
$makeid=$makeid.'0';
$sql = "select count(*) count from listings where delete_status = 0 and car_type != 2 and daily_price_status='1' and
(car_make in ($makeid)
or (car_type='4,8')
or car_make in (SELECT id from make where doors='2') and car_type NOT IN ('3','9','11','14') or
(keywords like '%Convertible%' or keywords like '%gtc%' or keywords like '%dawn%' or keywords like '%cabriolet%' or keywords like '%grancabrio%' or keywords like '%spyder%' or car_make='481' or car_make='438')) and
listings.client_id in (select client_id from `clients` where emirate like '%Dubai%') and
daily_price >= 800 and daily_price!='0' and listings.client_id!=247 and publish_ocd='1'";*/
$sql = "select count(*) count from listings inner join clients on listings.client_id=clients.client_id where delete_status = 0 and car_type != 2 and daily_price_status='1' and (car_make in (SELECT id FROM `make` WHERE `cartype` in (8) or `cartype1` in (8) or `cartype2` in (8) or `cartype3` in (8)) or car_type='8' ) and clients.emirate like '%Dubai%' and ( IF(`daily_price_offer` != '=', daily_price_offer >='850', daily_price >= 850) and daily_price!='0') and listings.client_id!=247 and publish_ocd='1'";
$result = mysql_query($sql);
$aRow = mysql_fetch_array($result);
$count = $aRow['count'];
$this->memcached_library->add($key_cache, $count, 86400);
$this->set_memcachekeys($key_cache);
return $count;
} else {
return $get_premcarscount;
}
}
function get_sportscount()
{
$key_cache = 'get_sportscount';
$get_sportscount = $this->memcached_library->get($key_cache);
if (!$get_sportscount && !is_numeric($get_sportscount)) {
$sql = "select count(*) count from listings INNER JOIN clients on listings.client_id=clients.client_id where delete_status = 0 and publish_ocd='1' and car_type = '7' and emirate='Dubai'";
$result = mysql_query($sql);
$aRow = mysql_fetch_array($result);
$count = $aRow['count'];
$this->memcached_library->add($key_cache, $count, 86400);
$this->set_memcachekeys($key_cache);
return $count;
} else {
return $get_sportscount;
}
}
function get_carmake($where)
{
$key_cache = 'get_carmake@' . $where;
$get_carmake = $this->memcached_library->get($key_cache);
if (!$get_carmake && !is_numeric($get_carmake)) {
$sql = "select car_model , count(*) count from listings where $where and publish_ocd='1' group by car_model";
$result = mysql_query($sql);
while ($aRow = mysql_fetch_array($result)) {
$car_make = $aRow['car_model'];
$carmake = $this->get_name($car_make, "models", "name");
$list[$carmake["name"]] = $car_make . "-" . $aRow['count'];
}
$this->memcached_library->add($key_cache, $list, 86400);
$this->set_memcachekeys($key_cache);
return $list;
} else {
return $get_carmake;
}
}
function get_carmake_arabic($where)
{
$sql = "select car_model , count(*) count from listings where $where and publish_ocd='1' group by car_model";
$result = mysql_query($sql);
while ($aRow = mysql_fetch_array($result)) {
$car_make = $aRow['car_model'];
$carmake = $this->get_name($car_make, "models", "name_arabic");
$list[$carmake["name_arabic"]] = $car_make . "-" . $aRow['count'];
}
return $list;
}
function get_carmodel($id)
{
$sql = "select car_make , count(*) count from listings where car_model = '$id' and publish_ocd='1' group by car_make";
$result = mysql_query($sql);
while ($aRow = mysql_fetch_array($result)) {
$car_make = $aRow['car_make'];
$carmake = $this->get_name($car_make, "make", "name");
$list[$carmake["name"]] = $car_make;
}
return $list;
}
function get_area($emirate,$used_cars=0)
{
$key_cache = 'get_area@' . $emirate.$used_cars;
$get_area = $this->memcached_library->get($key_cache);
if (!$get_area && !is_numeric($get_area)) {
if($used_cars==0)
{
$sql = "select location from clients inner join listings on clients.client_id=listings.client_id where publish_ocd='1' and emirate ='$emirate' and location!='' group by location order by location asc";
}
else
{
$sql = "select location from clients inner join usedcar_listings on clients.client_id=usedcar_listings.client_id where publish_ocd='1' and emirate ='$emirate' and usedcar_listings.used_cars='$used_cars' and location!='' group by location order by location asc";
}
$result = mysql_query($sql);
while ($aRow = mysql_fetch_array($result)) {
$loc = $aRow['location'];
$array = explode('*', $loc);
foreach ($array as $key => $value) {
if (in_array($value, $dup)) {
continue;
}
$list[$value] = $value;
}
$dup[] = $value;
}
$this->memcached_library->add($key_cache, $list, 86400);
$this->set_memcachekeys($key_cache);
return $list;
} else {
return $get_area;
}
}
function get_cardelv($where,$used_cars=0)
{
$key_cache = 'get_cardelv@' . $where.$used_cars;
$get_cardelv = $this->memcached_library->get($key_cache);
if (!$get_cardelv && !is_numeric($get_cardelv)) {
if($used_cars==0)
{
$sql = "select pick_up , count(*) count from listings where $where and publish_ocd='1' group by pick_up";
}
else
{
$sql = "select pick_up , count(*) count from usedcar_listings where $where and usedcar_listings.used_cars='$used_cars' and publish_ocd='1' group by pick_up";
}
$result = mysql_query($sql);
while ($aRow = mysql_fetch_array($result)) {
$pick_up = $aRow['pick_up'];
$pickup = $this->get_name($pick_up, "pickup_policy", "name");
$list[$pickup["name"]] = $pick_up . "-" . $aRow['count'];
}
$this->memcached_library->add($key_cache, $list, 86400);
$this->set_memcachekeys($key_cache);
return $list;
} else {
return $get_cardelv;
}
}
function get_transmission($where,$used_cars=0)
{
$key_cache = 'get_transmission@' . $where.$used_cars;
$get_transmission = $this->memcached_library->get($key_cache);
if (!$get_transmission && !is_numeric($get_transmission)) {
if($used_cars==0)
{
$sql = "select transmission , count(*) count from listings where $where and publish_ocd='1' group by transmission";
}
else{
$sql = "select transmission , count(*) count from usedcar_listings where $where and used_cars='$used_cars' and publish_ocd='1' group by transmission";
}
$result = mysql_query($sql);
while ($aRow = mysql_fetch_array($result)) {
$transmission = $aRow['transmission'];
$transmission = $this->get_name($transmission, "transmission", "name");
$list[$transmission["name"]] = $aRow['transmission'] . "-" . $aRow['count'];
}
$this->memcached_library->add($key_cache, $list, 86400);
$this->set_memcachekeys($key_cache);
return $list;
} else {
return $get_transmission;
}
}
function getbuggy_cars_count($where)
{
$key_cache = 'getbuggy_cars_count@' . $where;
$getbuggy_cars_count = $this->memcached_library->get($key_cache);
// $this->memcached_library->delete($key_cache);
if (!$getbuggy_cars_count && !is_numeric($getbuggy_cars_count)) {
$sql = "select count(*) count from buggy_listing inner join clients on buggy_listing.client_id=clients.client_id where $where and car_type = '32' and publish_ocd='1'";
$result = mysql_query($sql) or die(mysql_error());
$aRow = mysql_fetch_array($result);
$count = $aRow['count'];
$this->memcached_library->add($key_cache, $count, 86400);
$this->set_memcachekeys($key_cache);
return $count;
} else {
return $getbuggy_cars_count;
}
}
function get_cars_count($where,$used_cars=0)
{
$key_cache = 'get_cars_count120@' . $where.$used_cars;
$get_cars_count = $this->memcached_library->get($key_cache);
// $this->memcached_library->delete($key_cache);
if (!$get_cars_count && !is_numeric($get_cars_count)) {
if($used_cars==0)
{
$sql = "select count(*) count from listings inner join clients on listings.client_id=clients.client_id where $where and publish_ocd='1'";
}
else
{
$sql = "select count(*) count from usedcar_listings inner join clients on usedcar_listings.client_id=clients.client_id where $where and usedcar_listings.used_cars='$used_cars' and publish_ocd='1'";
}
$result = mysql_query($sql) or die(mysql_error());
$aRow = mysql_fetch_array($result);
$count = $aRow['count'];
$this->memcached_library->add($key_cache, $count, 86400);
$this->set_memcachekeys($key_cache);
return $count;
} else {
return $get_cars_count;
}
}
function get_cars_coupecount($emirate,$used_cars=0)
{
$key_cache = 'get_cars_coupecount@' . $emirate.$used_cars;
$get_cars_coupecount = $this->memcached_library->get($key_cache);
if (!$get_cars_coupecount && !is_numeric($get_cars_coupecount)) {
if($used_cars==0)
{
$sql = "select count(*) count from make inner join listings on make.id=listings.car_make inner join clients on clients.client_id=listings.client_id where make.doors='2' and listings.publish_ocd='1' and listings.delete_status='0' and clients.emirate='$emirate' ";
}
else
{
$sql = "select count(*) count from make inner join usedcar_listings on make.id=usedcar_listings.car_make inner join clients on clients.client_id=usedcar_listings.client_id where make.doors='2' and usedcar_listings.used_cars='$used_cars' and usedcar_listings.publish_ocd='1' and usedcar_listings.delete_status='0' and clients.emirate='$emirate' ";
}
$result = mysql_query($sql);
$aRow = mysql_fetch_array($result);
$count = $aRow['count'];
$this->memcached_library->add($key_cache, $count, 86400);
$this->set_memcachekeys($key_cache);
return $count;
} else {
return $get_cars_coupecount;
}
}
function get_cars_convert($emirate,$used_cars=0)
{
$key_cache = "get_cars_convert@" . $emirate.$used_cars;
$cars_convert = $this->memcached_library->get($key_cache);
if (!$cars_convert && !is_numeric($cars_convert)) {
if($used_cars==0)
{
$sql = "select count(*) count from listings inner join clients on listings.client_id=clients.client_id where keywords like '%Convertible%' and publish_ocd='1' and delete_status='0' and emirate='$emirate'";
}
else
{
$sql = "select count(*) count from usedcar_listings inner join clients on usedcar_listings.client_id=clients.client_id where keywords like '%Convertible%' and publish_ocd='1'and usedcar_listings.used_cars='$used_cars' and delete_status='0' and emirate='$emirate'";
}
$result = mysql_query($sql);
$aRow = mysql_fetch_array($result);
$count = $aRow['count'];
$this->memcached_library->add($key_cache, $count, 86400);
$this->set_memcachekeys($key_cache);
return $count;
} else {
return $cars_convert;
}
}
function get_cars_ids()
{
$key_cache = "get_cars_ids";
$get_cars_ids = $this->memcached_library->get($key_cache);
if (!$get_cars_ids && !is_numeric($get_cars_ids)) {
$sql = "select ids from ids";
$result = mysql_query($sql);
$aRow = mysql_fetch_array($result);
$count = $aRow['ids'];
$this->memcached_library->add($key_cache, $count, 86400);
$this->set_memcachekeys($key_cache);
return $count;
} else {
return $get_cars_ids;
}
}
function insert_newsletter($newsletter)
{
$sql = "insert into newsletter (email) values ('" . mysql_real_escape_string($newsletter) . "')";
mysql_query($sql);
}
function insert_contact($post)
{
$ip = $this->get_your_ip();
echo $sql = "insert into contact (id,name,email,phone,message,ip) values ('',
'" . mysql_real_escape_string($post["NAME"]) . "',
'" . mysql_real_escape_string($post["EMAIL"]) . "',
'" . mysql_real_escape_string($post["MOBILE"]) . "',
'" . mysql_real_escape_string($post["NOTE"]) . "',
'" . mysql_real_escape_string($ip) . "'
)";
mysql_query($sql);
}
function check_ip_full_day($ip,$used_cars=0,$table='email_sms')
{
$date=date("Y-m-d");
$sql = mysql_query("select count(*) as count from $table where ip='$ip' and usedcar='$used_cars' and date(`time`)='$date'") or die(mysql_error());
$count=mysql_fetch_array($sql);
return $count['count'];
}
function track_click_phone($listing_id, $client_id)
{
$date_today=date('Y-m-d');
$ip = $this->get_your_ip();
$check_full_day_leads= $this->check_ip_full_day($ip,0,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='2' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ($hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
$sql = "insert into email_sms(client_id,listing_id,type,ip,daily_spam,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'2'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_phone2($listing_id, $client_id, $featured_listing, $best_offer_listing)
{
$ip = $this->get_your_ip();
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,0,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='2' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
$sql = "insert into email_sms(client_id,listing_id,type,ip,featured_listing,best_offer_listing,daily_spam,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'2'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_phone5($listing_id, $client_id, $featured_listing, $best_offer_listing, $verification, $price_stat, $premium)
{
$ip = $this->get_your_ip();
$user_id = 0;
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,0,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='2' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
if(isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
}
$sql = "insert into email_sms(client_id,user_id,listing_id,type,ip,featured_listing,best_offer_listing,verified_listing,price_stat,premium_listing,daily_spam,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'2'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($verification) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($premium) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_phone55_usedcar($listing_id, $client_id, $featured_listing, $best_offer_listing, $verification, $price_stat, $premium, $month_lead)
{
$ip = $this->get_your_ip();
$user_id = 0;
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,1,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='2' and usedcar = '1' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
if(isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
}
$sql = "insert into email_sms(client_id,user_id,listing_id,type,ip,featured_listing,best_offer_listing,verified_listing,price_stat,premium_listing,month_lead,daily_spam,usedcar,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'2'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($verification) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($premium) . "',"
. "'" . mysql_real_escape_string($month_lead) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'1'" . ","
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_phone55($listing_id, $client_id, $featured_listing, $best_offer_listing, $verification, $price_stat, $premium, $month_lead, $hourly = 0)
{
$ip = $this->get_your_ip();
$user_id = 0;
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,0,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='2' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
if(isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
}
$sql = "insert into email_sms(client_id,user_id,listing_id,type,ip,featured_listing,best_offer_listing,verified_listing,price_stat,premium_listing,month_lead,daily_spam,time,is_hourly) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'2'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($verification) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($premium) . "',"
. "'" . mysql_real_escape_string($month_lead) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'" . date('Y-m-d H:i:s') . "',"
."'".$hourly."'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_usedcar_click_phone55($listing_id, $client_id, $featured_listing, $best_offer_listing, $verification, $price_stat, $premium, $month_lead)
{
$ip = $this->get_your_ip();
$user_id = 0;
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,1,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='2' and ip='$ip' and usedcar = '1' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
if(isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
}
$sql = "insert into email_sms(client_id,user_id,listing_id,type,ip,featured_listing,best_offer_listing,verified_listing,price_stat,premium_listing,month_lead,daily_spam,usedcar,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'2'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($verification) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($premium) . "',"
. "'" . mysql_real_escape_string($month_lead) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'1'" . ","
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_phone4($listing_id, $client_id, $featured_listing, $best_offer_listing, $verification, $price_stat)
{
$ip = $this->get_your_ip();
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,0,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='2' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
$sql = "insert into email_sms(client_id,listing_id,type,ip,featured_listing,best_offer_listing,verified_listing,price_stat,daily_spam,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'2'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($verification) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_phone3($listing_id, $client_id, $featured_listing, $best_offer_listing, $verification)
{
$ip = $this->get_your_ip();
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,0,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='2' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
$sql = "insert into email_sms(client_id,listing_id,type,ip,featured_listing,best_offer_listing,verified_listing,daily_spam,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'2'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($verification) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function check_user_lead_count()
{
$ip = $this->get_your_ip();
$trackids = mysql_query("select id from email_sms where ip='$ip' group by client_id");
$trackid = mysql_fetch_array($trackids);
return ($trackid);
}
function track_click_whatsapp5_offer($listing_id, $client_id, $featured_listing, $best_offer_listing, $verification, $price_stat, $premium)
{
$ip = $this->get_your_ip();
$user_id = 0;
if(isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
}
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,0,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='5' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
$sql = "insert into email_sms(client_id,user_id,listing_id,type,ip,featured_listing,best_offer_listing,verified_listing,price_stat,premium_listing,whatsapp_offer,daily_spam,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'5'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($verification) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($premium) . "',"
. "'1'" . ","
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_whatsapp5($listing_id, $client_id, $featured_listing, $best_offer_listing, $verification, $price_stat, $premium)
{
$ip = $this->get_your_ip();
$user_id = 0;
if(isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
}
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,0,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='5' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
$sql = "insert into email_sms(client_id,user_id,listing_id,type,ip,featured_listing,best_offer_listing,verified_listing,price_stat,premium_listing,daily_spam,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'5'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($verification) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($premium) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_whatsapp_desert($id, $price, $name, $transfer_option, $adult_count, $child_count, $infant_count, $pickup){
$ip = $this->get_your_ip();
$user_id = 0;
if(isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
}
$sql = "insert into email_sms_desert(user_id,listing_id,ip,price,safari_name,transfer_option,adult_count,child_count,infant_count,pickupdate,time) values ("
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($id) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($price) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($transfer_option) . "',"
. "'" . mysql_real_escape_string($adult_count) . "',"
. "'" . mysql_real_escape_string($child_count) . "',"
. "'" . mysql_real_escape_string($infant_count) . "',"
. "'" . mysql_real_escape_string($pickup) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_whatsapp55_usedcar($listing_id, $client_id, $featured_listing, $best_offer_listing, $verification, $price_stat, $premium,$month_lead)
{
$ip = $this->get_your_ip();
$user_id = 0;
if(isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
}
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,1,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='5' and ip='$ip' and usedcar = '1' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
$sql = "insert into email_sms(client_id,user_id,listing_id,type,ip,featured_listing,best_offer_listing,verified_listing,price_stat,premium_listing,month_lead,daily_spam,usedcar,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'5'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($verification) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($premium) . "',"
. "'" . mysql_real_escape_string($month_lead) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'1'" . ","
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_whatsapp55($listing_id, $client_id, $featured_listing, $best_offer_listing, $verification, $price_stat, $premium,$month_lead,$hourly=0)
{
$ip = $this->get_your_ip();
$user_id = 0;
if(isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
}
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,0,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='5' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
$sql = "insert into email_sms(client_id,user_id,listing_id,type,ip,featured_listing,best_offer_listing,verified_listing,price_stat,premium_listing,month_lead,daily_spam,time,is_hourly) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'5'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($verification) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($premium) . "',"
. "'" . mysql_real_escape_string($month_lead) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'" . date('Y-m-d H:i:s') . "',"
."'".$hourly."'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_whatsapp4($listing_id, $client_id, $featured_listing, $best_offer_listing, $verification, $price_stat)
{
$ip = $this->get_your_ip();
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,0,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='5' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
$sql = "insert into email_sms(client_id,listing_id,type,ip,featured_listing,best_offer_listing,verified_listing,price_stat,daily_spam,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'5'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($verification) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_whatsapp($listing_id, $client_id)
{
$ip = $this->get_your_ip();
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,0,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='5' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
$sql = "insert into email_sms(client_id,listing_id,type,ip,daily_spam,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'5'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_usedcar_click_whatsapp($listing_id, $client_id)
{
$ip = $this->get_your_ip();
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,1,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='5' and usedcar = '1' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
$sql = "insert into email_sms(client_id,listing_id,type,ip,daily_spam,usedcar,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'5'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'1'" . ","
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_whatsapp2($listing_id, $client_id, $featured_listing, $best_offer_listing)
{
$ip = $this->get_your_ip();
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,0,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='5' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
$sql = "insert into email_sms(client_id,listing_id,type,ip,featured_listing,best_offer_listing,daily_spam,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'5'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function track_click_whatsapp3($listing_id, $client_id, $featured_listing, $best_offer_listing, $verification)
{
$ip = $this->get_your_ip();
$date_today=date('Y-m-d');
$check_full_day_leads= $this->check_ip_full_day($ip,0,'email_sms');
if($check_full_day_leads > 60)
{
$daily_spam='1';
}
else if(!empty($ip))
{
$check_spam_ip=mysql_query("select time from `email_sms` where listing_id='$listing_id' and type='5' and ip='$ip' and date(`time`)='$date_today'");
if(mysql_num_rows($check_spam_ip)>0){
$i=0;
while($spam = mysql_fetch_array($check_spam_ip))
{
$expiry_time = new DateTime($spam['time']);
$current_date = new DateTime();
$diff = $expiry_time->diff($current_date);
$hour=$diff->format('%h');
$minute=$diff->format('%i');
if(($hour==1 && $minute<5) || ( $hour==0))
{
$i++;
}
}
$dailyspam = $i;
if($dailyspam>=2)
{
$daily_spam='1';
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
}
else
{
$daily_spam='0';
}
$sql = "insert into email_sms(client_id,listing_id,type,ip,featured_listing,best_offer_listing,verified_listing,daily_spam,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'5'" . ","
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($verification) . "',"
. "'" . mysql_real_escape_string($daily_spam) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
//echo $sql;
mysql_query($sql);
}
function insert_email_latest7($client_id, $listing_id, $name, $email, $mobile, $message, $car, $status, $pick_up, $drop_off, $featured_listing, $best_offer_listing, $check_verification, $restrict_leads, $price_stat, $message_for_user, $message_for_client, $premium_listing)
{
$ip = $this->get_your_ip();
$sql = "insert into email_sms (client_id,listing_id,name,email,mobile,type,message,status,car_name,pickupdate,dropoffdate,featured_listing,best_offer_listing,verified_listing,restrict_leads,ip,price_stat,message_for_user,message_for_client,premium_listing,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'1'" . ","
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($status) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . mysql_real_escape_string($pick_up) . "',"
. "'" . mysql_real_escape_string($drop_off) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($check_verification) . "',"
. "'" . mysql_real_escape_string($restrict_leads) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($message_for_user) . "',"
. "'" . mysql_real_escape_string($message_for_client) . "',"
. "'" . mysql_real_escape_string($premium_listing) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
return mysql_insert_id();
}
function insert_email_latest8($client_id, $listing_id, $name, $email, $mobile, $message, $car, $status, $pick_up, $drop_off, $featured_listing, $best_offer_listing, $check_verification, $restrict_leads, $price_stat, $message_for_user, $message_for_client, $premium_listing, $page)
{
$ip = $this->get_your_ip();
$user_id = 0;
if(isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
}
$sql = "insert into email_sms (client_id,user_id,listing_id,name,email,mobile,type,message,status,car_name,pickupdate,dropoffdate,featured_listing,best_offer_listing,verified_listing,restrict_leads,ip,price_stat,message_for_user,message_for_client,premium_listing,page,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'1'" . ","
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($status) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . mysql_real_escape_string($pick_up) . "',"
. "'" . mysql_real_escape_string($drop_off) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($check_verification) . "',"
. "'" . mysql_real_escape_string($restrict_leads) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($message_for_user) . "',"
. "'" . mysql_real_escape_string($message_for_client) . "',"
. "'" . mysql_real_escape_string($premium_listing) . "',"
. "'" . mysql_real_escape_string($page) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
return mysql_insert_id();
}
function updateuserid($insertid, $name, $email, $uid){
$sql = "update email_sms set user_id = '" . $uid . "', name = '".$name."', email = '".$email."' where id = $insertid";
mysql_query($sql);
//echo $sql;
}
function insert_email_latest88($client_id, $listing_id, $name, $email, $mobile, $message, $car, $status, $pick_up, $drop_off, $featured_listing, $best_offer_listing, $check_verification, $restrict_leads, $price_stat, $message_for_user, $message_for_client, $premium_listing, $page,$month_lead)
{
if (isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
} else {
$user_id = 0;
}
$ip = $this->get_your_ip();
$sql = "insert into email_sms (client_id,user_id,listing_id,name,email,mobile,type,message,status,car_name,pickupdate,dropoffdate,featured_listing,best_offer_listing,verified_listing,restrict_leads,ip,price_stat,message_for_user,message_for_client,premium_listing,page,month_lead,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'1'" . ","
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($status) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . mysql_real_escape_string($pick_up) . "',"
. "'" . mysql_real_escape_string($drop_off) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($check_verification) . "',"
. "'" . mysql_real_escape_string($restrict_leads) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($message_for_user) . "',"
. "'" . mysql_real_escape_string($message_for_client) . "',"
. "'" . mysql_real_escape_string($premium_listing) . "',"
. "'" . mysql_real_escape_string($page) . "',"
. "'" . mysql_real_escape_string($month_lead) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
return mysql_insert_id();
}
function insert_submit_form_status($user_id, $listing_id, $client_id,$email_feed) {
if($user_id == 0){
$sql = "update feedback_track set submit_enquiry_form = 1, email_sms_track_id = '$email_feed' where client_id = $client_id and listing_id = $listing_id";
} else {
$sql = "update feedback_track set submit_enquiry_form = 1, email_sms_track_id = '$email_feed' where client_id = $client_id and listing_id = $listing_id and user_id = $user_id";
}
mysql_query($sql);
return $sql;
}
function insert_email_latest9($client_id, $listing_id,$car_typ, $name, $email, $mobile, $message, $car, $status, $pick_up, $drop_off, $featured_listing, $best_offer_listing, $check_verification, $restrict_leads, $price_stat, $message_for_user, $message_for_client, $premium_listing = '')
{
$ip = $this->get_your_ip();
$page = "Details Page";
$user_id = 0;
if(isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
}
$sql = "insert into email_sms (client_id,user_id,listing_id,car_type,name,email,mobile,type,message,status,car_name,pickupdate,dropoffdate,featured_listing,best_offer_listing,verified_listing,restrict_leads,ip,price_stat,message_for_user,message_for_client,page,time,premium_listing) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($car_typ) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'6'" . ","
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($status) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . mysql_real_escape_string($pick_up) . "',"
. "'" . mysql_real_escape_string($drop_off) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($check_verification) . "',"
. "'" . mysql_real_escape_string($restrict_leads) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($message_for_user) . "',"
. "'" . mysql_real_escape_string($message_for_client) . "',"
. "'" . mysql_real_escape_string($page) . "',"
. "'" . date('Y-m-d H:i:s') . "',"
. "'" . mysql_real_escape_string($premium_listing) . "'"
. ")";
mysql_query($sql);
return mysql_insert_id();
}
function insert_email_latest6($client_id, $listing_id, $name, $email, $mobile, $message, $car, $status, $pick_up, $drop_off, $featured_listing, $best_offer_listing, $check_verification, $restrict_leads, $price_stat, $message_for_user, $message_for_client, $premium_listing = '', $start_time, $used_cars=0)
{
$ip = $this->get_your_ip();
$page = "Details Page";
$user_id = 0;
if(isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
}
$sql = "insert into email_sms (client_id,user_id,listing_id,name,email,mobile,type,message,status,car_name,pickupdate,dropoffdate,featured_listing,best_offer_listing,verified_listing,restrict_leads,ip,price_stat,message_for_user,message_for_client,page,time,premium_listing,usedcar,start_time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'1'" . ","
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($status) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . mysql_real_escape_string($pick_up) . "',"
. "'" . mysql_real_escape_string($drop_off) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($check_verification) . "',"
. "'" . mysql_real_escape_string($restrict_leads) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($message_for_user) . "',"
. "'" . mysql_real_escape_string($message_for_client) . "',"
. "'" . mysql_real_escape_string($page) . "',"
. "'" . date('Y-m-d H:i:s') . "',"
. "'" . mysql_real_escape_string($premium_listing) . "',"
. "'" . mysql_real_escape_string($used_cars) . "',"
. "'" . mysql_real_escape_string($start_time) . "'"
. ")";
mysql_query($sql);
return mysql_insert_id();
}
function insert_email_latest66($client_id, $listing_id, $name, $email, $mobile, $message, $car, $status, $pick_up, $drop_off, $featured_listing, $best_offer_listing, $check_verification, $restrict_leads, $price_stat, $message_for_user, $message_for_client, $premium_listing = '',$month_lead)
{
$ip = $this->get_your_ip();
$page = "Details Page";
$user_id = 0;
if(isset($_COOKIE['void']) && $this->session->userdata("userr_id") != ""){
$user_id = $this->session->userdata("userr_id");
}
$sql = "insert into email_sms (client_id,user_id,listing_id,name,email,mobile,type,message,status,car_name,pickupdate,dropoffdate,featured_listing,best_offer_listing,verified_listing,restrict_leads,ip,price_stat,message_for_user,message_for_client,page,time,month_lead,premium_listing) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($user_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'1'" . ","
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($status) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . mysql_real_escape_string($pick_up) . "',"
. "'" . mysql_real_escape_string($drop_off) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($check_verification) . "',"
. "'" . mysql_real_escape_string($restrict_leads) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($price_stat) . "',"
. "'" . mysql_real_escape_string($message_for_user) . "',"
. "'" . mysql_real_escape_string($message_for_client) . "',"
. "'" . mysql_real_escape_string($page) . "',"
. "'" . date('Y-m-d H:i:s') . "',"
. "'" . mysql_real_escape_string($month_lead) . "',"
. "'" . mysql_real_escape_string($premium_listing) . "'"
. ")";
mysql_query($sql);
return mysql_insert_id();
}
function insert_email_latest5($client_id, $listing_id, $name, $email, $mobile, $message, $car, $status, $pick_up, $drop_off, $featured_listing, $best_offer_listing, $check_verification, $restrict_leads)
{
$ip = $this->get_your_ip();
$sql = "insert into email_sms (client_id,listing_id,name,email,mobile,type,message,status,car_name,pickupdate,dropoffdate,featured_listing,best_offer_listing,verified_listing,restrict_leads,ip,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'1'" . ","
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($status) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . mysql_real_escape_string($pick_up) . "',"
. "'" . mysql_real_escape_string($drop_off) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($check_verification) . "',"
. "'" . mysql_real_escape_string($restrict_leads) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
}
function insert_spam_email_captcha($client_id, $listing_id, $name, $email, $mobile, $messasge_txt, $car, $page_current)
{
$ip = $this->get_your_ip();
$sql = "insert into email_sms_captcha_spam (client_id,listing_id,name,email,mobile,message,car,ip,page,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'" . mysql_real_escape_string($messasge_txt) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($page_current) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
}
function insert_all_spam($name, $email, $mobile, $message, $ip, $page)
{
$sql = "insert into email_all_spam (name,email,mobile,message,ip,page,time) values ("
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($page) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
}
function insert_spam_email($client_id, $listing_id, $name, $email, $mobile, $message, $car, $status, $pick_up, $drop_off, $featured_listing, $best_offer_listing, $check_verification, $restrict_leads)
{
$ip = $this->get_your_ip();
$sql = "insert into email_sms_spam (client_id,listing_id,name,email,mobile,type,message,status,car_name,pickupdate,dropoffdate,featured_listing,best_offer_listing,verified_listing,restrict_leads,ip,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'1'" . ","
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($status) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . mysql_real_escape_string($pick_up) . "',"
. "'" . mysql_real_escape_string($drop_off) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($check_verification) . "',"
. "'" . mysql_real_escape_string($restrict_leads) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
}
function insert_email_latest($client_id, $listing_id, $name, $email, $mobile, $message, $car, $status)
{
$ip = $this->get_your_ip();
$sql = "insert into email_sms (client_id,listing_id,name,email,mobile,type,message,status,car_name,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'1'" . ","
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($status) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
}
function insert_email_latest2($client_id, $listing_id, $name, $email, $mobile, $message, $car, $status, $pick_up, $drop_off)
{
$ip = $this->get_your_ip();
$sql = "insert into email_sms (client_id,listing_id,name,email,mobile,type,message,status,car_name,pickupdate,dropoffdate,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'1'" . ","
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($status) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . mysql_real_escape_string($pick_up) . "',"
. "'" . mysql_real_escape_string($drop_off) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
}
function insert_email_latest3($client_id, $listing_id, $name, $email, $mobile, $message, $car, $status, $pick_up, $drop_off, $featured_listing, $best_offer_listing)
{
$ip = $this->get_your_ip();
$sql = "insert into email_sms (client_id,listing_id,name,email,mobile,type,message,status,car_name,pickupdate,dropoffdate,featured_listing,best_offer_listing,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'1'" . ","
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($status) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . mysql_real_escape_string($pick_up) . "',"
. "'" . mysql_real_escape_string($drop_off) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
}
function insert_email_latest4($client_id, $listing_id, $name, $email, $mobile, $message, $car, $status, $pick_up, $drop_off, $featured_listing, $best_offer_listing, $check_verification)
{
$ip = $this->get_your_ip();
$sql = "insert into email_sms (client_id,listing_id,name,email,mobile,type,message,status,car_name,pickupdate,dropoffdate,featured_listing,best_offer_listing,verified_listing,ip,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'1'" . ","
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($status) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . mysql_real_escape_string($pick_up) . "',"
. "'" . mysql_real_escape_string($drop_off) . "',"
. "'" . mysql_real_escape_string($featured_listing) . "',"
. "'" . mysql_real_escape_string($best_offer_listing) . "',"
. "'" . mysql_real_escape_string($check_verification) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
}
function insert_email($client_id, $listing_id, $name, $email, $mobile, $pickup, $dropoff, $pickupdate, $dropoffdate, $message, $car, $status)
{
$ip = $this->get_your_ip();
$sql = "insert into email_sms (client_id,listing_id,name,email,mobile,pickup,dropoff,pickupdate,dropoffdate,type,message,status,car_name,time) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($listing_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email) . "',"
. "'" . mysql_real_escape_string($mobile) . "',"
. "'" . mysql_real_escape_string($pickup) . "',"
. "'" . mysql_real_escape_string($dropoff) . "',"
. "'" . mysql_real_escape_string($pickupdate) . "',"
. "'" . mysql_real_escape_string($dropoffdate) . "',"
. "'1'" . ","
. "'" . mysql_real_escape_string($message) . "',"
. "'" . mysql_real_escape_string($status) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
}
function insert_email_lease($client_id, $name, $email_add, $phone_number, $sender, $period, $type, $message_req, $ip, $web_address)
{
$sql = "insert into email_lease (client_id,name,email_id,mobile,sender,period,car_type,message,ip,web_address,ts) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email_add) . "',"
. "'" . mysql_real_escape_string($phone_number) . "',"
. "'" . mysql_real_escape_string($sender) . "',"
. "'" . mysql_real_escape_string($period) . "',"
. "'" . mysql_real_escape_string($type) . "',"
. "'" . mysql_real_escape_string($message_req) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($web_address) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
}
function insert_email_lease2($client_id, $name, $email_add, $phone_number, $sender, $period, $type, $message_req, $emirates, $ip, $web_address)
{
$sql = "insert into email_lease (client_id,name,email_id,mobile,sender,period,car_type,message,emirates,ip,web_address,ts) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email_add) . "',"
. "'" . mysql_real_escape_string($phone_number) . "',"
. "'" . mysql_real_escape_string($sender) . "',"
. "'" . mysql_real_escape_string($period) . "',"
. "'" . mysql_real_escape_string($type) . "',"
. "'" . mysql_real_escape_string($message_req) . "',"
. "'" . mysql_real_escape_string($emirates) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($web_address) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
}
function insert_email_lease_newsection($lease_type, $insert_id, $lease_id, $client_id, $name, $email_add, $phone_number, $sender, $period, $type, $message_req, $emirates, $ip, $web_address, $car, $message_for_user, $message_for_client)
{
$sql = "insert into email_lease (lease_type,insert_id,lease_id,client_id,car_name,name,email_id,mobile,sender,period,car_type,message,emirates,ip,web_address,message_for_user,message_for_client,ts) values ("
. "'" . mysql_real_escape_string($lease_type) . "',"
. "'" . mysql_real_escape_string($insert_id) . "',"
. "'" . mysql_real_escape_string($lease_id) . "',"
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($car) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email_add) . "',"
. "'" . mysql_real_escape_string($phone_number) . "',"
. "'" . mysql_real_escape_string($sender) . "',"
. "'" . mysql_real_escape_string($period) . "',"
. "'" . mysql_real_escape_string($type) . "',"
. "'" . mysql_real_escape_string($message_req) . "',"
. "'" . mysql_real_escape_string($emirates) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($web_address) . "',"
. "'" . mysql_real_escape_string($message_for_user) . "',"
. "'" . mysql_real_escape_string($message_for_client) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
return mysql_insert_id();
}
function insert_email_lease_spam($client_id, $name, $email_add, $phone_number, $sender, $period, $type, $message_req, $emirates, $ip, $web_address)
{
$sql = "insert into email_lease_spam (client_id,name,email_id,mobile,sender,period,car_type,message,emirates,ip,web_address,ts) values ("
. "'" . mysql_real_escape_string($client_id) . "',"
. "'" . mysql_real_escape_string($name) . "',"
. "'" . mysql_real_escape_string($email_add) . "',"
. "'" . mysql_real_escape_string($phone_number) . "',"
. "'" . mysql_real_escape_string($sender) . "',"
. "'" . mysql_real_escape_string($period) . "',"
. "'" . mysql_real_escape_string($type) . "',"
. "'" . mysql_real_escape_string($message_req) . "',"
. "'" . mysql_real_escape_string($emirates) . "',"
. "'" . mysql_real_escape_string($ip) . "',"
. "'" . mysql_real_escape_string($web_address) . "',"
. "'" . date('Y-m-d H:i:s') . "'"
. ")";
mysql_query($sql);
}
function insert_shownumber($client_id, $listing_id)
{
$ip = $this->get_your_ip();
// Updated to Codeigniter Query Builder for prevent SQL Injection
$res = $this->db->insert('email_sms', array('client_id' => $client_id, 'listing_id' => $listing_id, 'type' => '2', 'ip' => $ip));
}
function get_search_info($complete_url)
{
$key_cache="get_search_info1".$complete_url; //if modifying key then modify on the premium listing controller
$search_info = $this->memcached_library->get($key_cache);
if (!$search_info && !is_numeric($search_info)) {
$sql = mysql_query("select * from search_info where url like '%$complete_url%'");
if (mysql_num_rows($sql) > 0) {
$listings = array();
while ($val = mysql_fetch_array($sql)) {
$aRow[$val['id']] ['title'] = $val['title'];
$aRow[$val['id']] ['description'] = $val['meta_desc'];
$aRow[$val['id']] ['h1'] = $val['h1'];
$aRow[$val['id']] ['h2'] = $val['h2'];
$aRow[$val['id']] ['bottom_content'] = $val['bottom_content'];
$aRow[$val['id']] ['faq_title'] = $val['faq_title'];
$aRow[$val['id']] ['faq'] = $val['faq'];
}
$listings=$aRow;
}
else{
$listings="0";
}
$this->memcached_library->add($key_cache, $listings, 86400);
return $listings;
}
else
{
return $search_info;
}
}
function premium_queries($url_premium,$order)
{
//$key_cache = 'premium_queries_lat2@'.$url_premium.'@'.$order;
$key_cache="premium_queries_lat4".$url_premium; //if modifying key then modify on the premium listing controller
// $this->memcached_library->delete($key_cache);
$premium_queries = $this->memcached_library->get($key_cache);
if (!$premium_queries && !is_numeric($premium_queries)) {
if (strpos($order, 'featured') !== false) {
$order = str_ireplace("featured desc", "", $order);
$order = str_ireplace(", images_verify desc", "images_verify desc", $order);
}
$sql = mysql_query("select listing_id,client_id from premium_listings where seo_url='$url_premium'");
if (mysql_num_rows($sql) > 0) {
$listings = array();
while ($val = mysql_fetch_array($sql)) {
$lists = $val['listing_id'];
$client_id = $val['client_id'];
$sql2 = mysql_query("select listings.id from listings inner join clients on listings.client_id=clients.client_id where listings.id='$lists' and publish_ocd='1'");
if (mysql_num_rows($sql2) > 0) {
$listings[] = $lists;
} else {
$val2 = [];
$sql3 = mysql_query("select listings.id from listings inner join clients on listings.client_id=clients.client_id where listings.client_id='$client_id' and publish_ocd='1' order by $order refresh desc limit 1");
if (mysql_num_rows($sql3) > 0) {
$val2 = mysql_fetch_array($sql3);
$listings[] = $val2['id'];
}
}
}
}
else{
$listings="0";
}
$this->memcached_library->add($key_cache, $listings);
return $listings;
}
else
{
return $premium_queries;
}
}
function premium_queries_used($url_premium,$order)
{
//$key_cache = 'premium_queries_lat2@'.$url_premium.'@'.$order;
$key_cache="premium_queries_lat_used4".$url_premium; //if modifying key then modify on the premium listing controller
// $this->memcached_library->delete($key_cache);
$premium_queries = $this->memcached_library->get($key_cache);
if (!$premium_queries && !is_numeric($premium_queries)) {
if (strpos($order, 'featured') !== false) {
$order = str_ireplace("featured desc", "", $order);
$order = str_ireplace(", images_verify desc", "images_verify desc", $order);
}
$sql = mysql_query("select listing_id,client_id from premium_listings where seo_url='$url_premium'");
if (mysql_num_rows($sql) > 0) {
$listings = array();
while ($val = mysql_fetch_array($sql)) {
$lists = $val['listing_id'];
$client_id = $val['client_id'];
$sql2 = mysql_query("select usedcar_listings.id from usedcar_listings inner join clients on usedcar_listings.client_id=clients.client_id where usedcar_listings.id='$lists' and publish_ocd='1'");
if (mysql_num_rows($sql2) > 0) {
$listings[] = $lists;
} else {
$val2 = [];
$sql3 = mysql_query("select usedcar_listings.id from usedcar_listings inner join clients on usedcar_listings.client_id=clients.client_id where usedcar_listings.client_id='$client_id' and publish_ocd='1' order by $order refresh desc limit 1");
if (mysql_num_rows($sql3) > 0) {
$val2 = mysql_fetch_array($sql3);
$listings[] = $val2['id'];
}
}
}
}
else{
$listings="0";
}
$this->memcached_library->add($key_cache, $listings);
return $listings;
}
else
{
return $premium_queries;
}
}
public function get_seo_slider($seo_parameter_slider, $emirate)
{
$key_cache = 'get_seo_slider294512@' . $seo_parameter_slider . '@' . $emirate;
// $this->memcached_library->delete($key_cache);
$get_seo_slider = $this->memcached_library->get($key_cache);
if (!$get_seo_slider && !is_numeric($get_seo_slider)) {
$parameter_array_slider = explode("&", $seo_parameter_slider);
$countcarcompany_slider = substr_count($seo_parameter_slider, 'carcompany%5B%5D');
$countgroup_slider = substr_count($seo_parameter_slider, 'group%5B%5D');
$countlisting_slider = substr_count($seo_parameter_slider, 'listing_id%5B%5D');
//echo $countlisting_slider;
foreach ($parameter_array_slider as $i) {
# split into keyword and value
list($keyword_slider, $value_slider) = explode('=', $i, 2);
if ($keyword_slider == 'group%5B%5D' || $keyword_slider == 'group[]' || $keyword_slider == '&group' || $keyword_slider == 'group') {
if ($countgroup_slider > 1) {
$group_slider[] = $value_slider;
} else {
$group_slider = $value_slider;
}
} elseif ($keyword_slider == 'listing_id%5B%5D' || $keyword_slider == 'listing[]' || $keyword_slider == 'listing') {
if ($countlisting_slider > 1) {
$carlisting_slider[] = $value_slider;
} else {
$carlisting_slider = $value_slider;
}
} elseif ($keyword_slider == 'carcompany%5B%5D' || $keyword_slider == 'carcompany[]' || $keyword_slider == 'carcompany') {
if ($countcarcompany_slider > 1) {
$carcompany_slider[] = $value_slider;
} else {
$carcompany_slider = $value_slider;
}
} elseif ($keyword_slider == 'fea' || $keyword_slider == 'fea%5B%5D' || $keyword_slider == 'fea[]') {
$fea_slider[] = $value_slider;
} elseif ($keyword_slider == 'convertible') {
$convertible_slider = $value_slider;
} elseif ($keyword_slider == 'cruise-control') {
$cruise_control_slider = $value_slider;
} elseif ($keyword_slider == 'coupe') {
$coupe_slider = $value_slider;
} elseif ($keyword_slider == 'carmake') {
$carmake_slider = $value_slider;
} elseif ($keyword_slider == 'carmodel') {
$carmodel_slider = $value_slider;
} elseif ($keyword_slider == 'year') {
$year_slider = $value_slider;
} else {
$keyword_slider = $value_slider;
}
}
if (!empty($carcompany_slider)) {
if (is_array($carcompany_slider)) {
$carcompany = array_filter($carcompany_slider);
if (!empty($carcompany_slider)) {
$carcompany_where_slider = implode(",", $carcompany_slider);
if (1 === preg_match('~[0-9]~', $carcompany_where_slider)) {
$where_slider[] = " listings.client_id in (" . $carcompany_where_slider . ")";
}
}
} else {
if ($carcompany_slider != '0' || $carcompany_slider != '') {
$where_slider[] = " listings.client_id in (" . $carcompany_slider . ")";
}
}
}
if (!empty($carlisting_slider)) {
if (is_array($carlisting_slider)) {
$carcompany = array_filter($carlisting_slider);
if (!empty($carlisting_slider)) {
$carlisting_where_slider = implode(",", $carlisting_slider);
if (1 === preg_match('~[0-9]~', $carlisting_where_slider)) {
$where_slider[] = " listings.id in (" . $carlisting_where_slider . ")";
}
}
} else {
if ($carlisting_slider != '0' || $carlisting_slider != '') {
$where_slider[] = " listings.id in (" . $carlisting_slider . ")";
}
}
}
if (!empty($fea_slider)) {
$fea_where2_slider = implode(",", $fea_slider);
if (1 === preg_match('~[0-9]~', $fea_where2_slider)) {
foreach ($fea_slider as $fea_where_slider) {
$where_slider[] = " CONCAT(',', free_features, ',') like '%,$fea_where_slider,%'";
}
}
}
if (!empty($cruise_control_slider)) {
$where_slider[] = "cruise_control='1'";
}
if (!empty($convertible_slider)) {
$where_convertible_slider = "or (keywords like '%Convertible%' or keywords like '%gtc%' or keywords like '%dawn%' or keywords like '%cabriolet%' or keywords like '%grancabrio%' or keywords like '%spyder%' or car_make='481' or car_make='438')";
$where_convertible2_slider = "(keywords like '%Convertible%' or keywords like '%gtc%' or keywords like '%dawn%' or keywords like '%cabriolet%' or keywords like '%grancabrio%' or keywords like '%spyder%' or car_make='481' or car_make='438') ";
} else {
$where_convertible_slider = "";
}
if (!empty($coupe_slider)) {
$where_coupe_slider = "or car_make in (SELECT id from make where doors='2') and car_type NOT IN ('3','9','11','14')";
$where_coupe2_slider = "car_make in (SELECT id from make where doors='2') and car_type NOT IN ('3','9','11','14')";
} else {
$where_coupe_slider = "";
}
if (!empty($group_slider)) {
if (is_array($group_slider)) {
$group_slider = array_filter($group_slider);
$group_where_slider = implode(",", $group_slider);
if (1 === preg_match('~[0-9]~', $group_where_slider)) {
$where_slider[] = "(car_type in (" . $group_where_slider . ")" . $where_coupe_slider . $where_convertible_slider . ")";
}
} else {
$group_where_slider = $group_slider;
$where_slider[] = "(car_type='$group_where_slider'" . $where_coupe_slider . $where_convertible_slider . ")";
}
} elseif (!empty($coupe_slider) && !empty($convertible_slider)) {
$where_slider[] = "(" . $where_convertible2_slider . " or " . $where_coupe2_slider . ")";
} elseif (!empty($coupe_slider)) {
$where_slider[] = "$where_coupe2_slider";
} elseif (!empty($convertible_slider)) {
$where_slider[] = "$where_convertible2_slider";
}
if (!empty($year_slider)) {
$where_slider[] = " year= '$year_slider'";
}
if (!empty($carmake_slider)) {
//$carmake_where = implode(",", $carmake);
$where_slider[] = " car_model in (" . $carmake_slider . ")";
}
if (!empty($carmodel_slider) && $carmodel_slider != '0') {
//$carmake_where = implode(",", $carmake);
$where_slider[] = " car_make in (" . $carmodel_slider . ")";
}
$where_slider[] = " listings.client_id in (select client_id from `clients` where emirate like '%$emirate%')";
if (!empty($where_slider)) {
$where_stmt_slider = implode(" and ", $where_slider);
} else {
$where_stmt_slider = "1";
}
$order_slider = "featured desc , page desc ,";
if ($where_stmt_slider == '1') {
$seott = "0";
$brands_array = array();
} else {
list($seott,$brands_array) = $this->GetAllCars_slider('0', '5', $where_stmt_slider, $order_slider);
}
if(empty($seott))
{
$seott="0";
$brands_array = array();
}
$this->memcached_library->add($key_cache, array($seott,$brands_array), 86400);
$this->set_memcachekeys($key_cache);
return array($seott,$brands_array);
} else {
return $get_seo_slider;
}
}
function get_track_id()
{
$key_cache = 'get_track_id';
$get_track_id = $this->memcached_library->get($key_cache);
if (!$get_track_id && !is_numeric($get_track_id)) {
$trackids = mysql_query("select id from call_tracking order by id DESC limit 1");
$trackid = mysql_fetch_array($trackids);
$this->memcached_library->add($key_cache, $trackid, 86400);
$this->set_memcachekeys($key_cache);
return $trackid;
} else {
return $get_track_id;
}
}
function insert_calltrack_usedcar($client_id, $client_name, $listing_id)
{
$ip = $this->get_your_ip();
// Updated to Codeigniter Query Builder for prevent SQL Injection
$res = $this->db->insert('usedcar_call_tracking', [
'client_id' => $client_id,
'client_name' => $client_name,
'listing_id' => $listing_id,
'ip' => $ip
]);
return $this->db->insert_id();
}
function insert_calltrack($client_id, $client_name, $listing_id)
{
$ip = $this->get_your_ip();
// Updated to Codeigniter Query Builder for prevent SQL Injection
$res = $this->db->insert('call_tracking', [
'client_id' => $client_id,
'client_name' => $client_name,
'listing_id' => $listing_id,
'ip' => $ip
]);
return $this->db->insert_id();
}
function insert_usedcar_calltrack($client_id, $client_name, $listing_id)
{
$ip = $this->get_your_ip();
// Updated to Codeigniter Query Builder for prevent SQL Injection
$res = $this->db->insert('usedcar_call_tracking', [
'client_id' => $client_id,
'client_name' => $client_name,
'listing_id' => $listing_id,
'ip' => $ip
]);
return $this->db->insert_id();
}
function update_calltrack($track_id, $field, $value)
{
echo $sql = "update call_tracking set $field = '" . $value . "' where id = $track_id";
mysql_query($sql);
}
function get_contact_details($client_id)
{
$key_cache = 'get_contact_details@' . $client_id;
$get_contact_details = $this->memcached_library->get($key_cache);
if (!$get_contact_details && !is_numeric($get_contact_details)) {
//$sql = "select email , phone_number , sms_phone , company_name from clients where client_id = $client_id";
// Code updated for prevent SQL Injection risks
$query = $this->db->query("SELECT * FROM clients WHERE client_id = ?", [$client_id]);
$aRow = $query->row_array();
$this->memcached_library->add($key_cache, $aRow, 86400);
$this->set_memcachekeys($key_cache);
return $aRow;
} else {
return $get_contact_details;
}
}
function languages_speak_list()
{
$key_cache = 'languages_speak_list';
// $languages_speak_list=$this->memcached_library->delete($key_cache);
$languages_speak_list = $this->memcached_library->get($key_cache);
if (!$languages_speak_list && !is_numeric($languages_speak_list)) {
$this->db->select('*');
$this->db->from('languages_speak');
$query = $this->db->get() or die(mysql_error());
$trans_result = $query->result_array();
foreach ($trans_result as $row) {
$result[$row["id"]] = $row["language"];
}
$this->memcached_library->add($key_cache, $result, 86400);
$this->set_memcachekeys($key_cache);
return $result;
} else {
return $languages_speak_list;
}
}
function get_user($client_id, $username, $password)
{
$sql = "select id , client_id from users_c where " . " username = '"
. mysql_real_escape_string($username) . "' and password=md5('"
. mysql_real_escape_string($password) . "')";
$result = mysql_query($sql);
$aRow = mysql_fetch_array($result);
if (empty($aRow)) {
return false;
}
return $aRow;
}
/*
function sms_to_client($to,$message){
$text = urlencode("$message");
//echo "http://api.clickatell.com/http/sendmsg?user=oneclickgroup&password=OCXKcOOddLNNPH&api_id=3522402&to=$to&text=$text" ;
file_get_contents("http://api.clickatell.com/http/sendmsg?user=oneclickgroup&password=OCXKcOOddLNNPH&api_id=3522402&to=$to&text=$text&senderid=OCD");
return 1;
}
function sms_to_client($to,$message){
$text = urlencode("$message");
file_get_contents("http://mshastra.com/sendurlcomma.aspx?user=20077167&pwd=mahesh20&senderid=oneclickdrv&mobileno=$to&msgtext=$message&priority=High&CountryCode=ALL");
return 1;
}
function sms_to_client($to,$message){
$text = urlencode("$message");
file_get_contents("http://mshastra.com/sendurlcomma.aspx?user=20077167&pwd=mahesh20&senderid=oneclickdrv&mobileno=$to&msgtext=$text&priority=High&CountryCode=ALL");
return 1;
}*/
function sms_to_client($to, $message)
{
$text = urlencode("$message");
$country_code = substr($to, 0, 2);
if ($country_code == "91") {
$senderid = "OCDRVE";
} else {
$senderid = "OneClickDrv";
}
file_get_contents("http://mshastra.com/sendurlcomma.aspx?user=20087796&pwd=Ocd@123&senderid=$senderid&mobileno=+$to&msgtext=$text&CountryCode=ALL");
return 1;
}
function min_price()
{
$key_cache = "min_price";
$min_price = $this->memcached_library->get($key_cache);
if (!$min_price && !is_numeric($min_price)) {
$sql = "select min(daily_price) price from listings INNER JOIN clients on listings.client_id=clients.client_id where delete_status = 0 and publish_ocd='1' and daily_price > 0 and clients.client_country='UAE' ";
$result = mysql_query($sql);
$aRow = mysql_fetch_array($result);
$count = $aRow['price'];
$this->memcached_library->add($key_cache, $count, 86400);
$this->set_memcachekeys($key_cache);
return $count;
} else {
return $min_price;
}
}
function get_all_companies()
{
$sql = "select * from clients";
$result = mysql_query($sql);
while ($aRow = mysql_fetch_array($result)) {
$list[] = $aRow;
}
return $list;
}
/* Model for seo search attribute*/
function get_seo_data($url_id)
{
$key_cache = 'get_seo_data29012@' . $url_id;
// $this->memcached_library->delete($key_cache);
$get_seo_data = $this->memcached_library->get($key_cache);
if (!$get_seo_data && !is_numeric($get_seo_data)) {
$this->set_memcachekeys($key_cache);
$this->db->select('*');
$this->db->from('seo_search');
$this->db->where('url', $url_id);
//$this->db->or_where("(url LIKE '$url_id')");
$this->db->limit('1');
$query = $this->db->get() or die(mysql_error());
if ($query->num_rows() > 0) {
$this->memcached_library->add($key_cache, $query->result_array(), 86400);
return $query->result_array();
} else {