| Server IP : 172.67.178.83 / Your IP : 216.73.217.141 Web Server : Apache System : Linux hosting01.arsenalhost.com 4.18.0-425.13.1.lve.el8.x86_64 #1 SMP Mon Feb 27 15:23:24 EST 2023 x86_64 User : corbizre ( 1013) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/corbizre/yousellwelist.com/ |
Upload File : |
<?php
include_once "config.php";
require_once "lib/dbmysql.class.php";
require_once "lib/dbpgsql.class.php";
error_reporting(E_ALL);
$db = new DbMySQL(DB_HOST, DB_NAME, DB_USER, DB_PWD);
$db->connect();
$db2 = new DbPgSQL(DB_HOST2, DB_PORT2, DB_NAME2, DB_USER2, DB_PWD2);
$db2->connect();
$sql = "SELECT * FROM realty ORDER BY last_update DESC LIMIT 1";
$last_update = $db->select_row($sql);
if ($last_update['last_update'] < '2011-11-13 03:10:14') {
$last_update['last_update'] = '2011-11-13 03:10:14';
}
echo "LAST UPDATE: ".$last_update['last_update']."\n";
echo $sql = "SELECT count(*) as houses_count FROM houses WHERE last_update>='".$last_update['last_update']."'"."\n";
$houses_count = $db2->select_row($sql);
echo "HOUSES for UPDATE:".$houses_count['houses_count']."\n";
$processing = 100;
echo "iterations_number=" . $iterations_number = ceil($houses_count['houses_count'] / $processing)."\n";
$i=0;
for ($iteration = 0; $iteration < $iterations_number+1; $iteration++) {
$sql = "SELECT * FROM houses WHERE last_update>='".$last_update['last_update']."' LIMIT ".$processing." OFFSET ".($iteration * $processing);
echo $sql . "\n";
$houses = $db2->select($sql);
echo "HOUSES".$iteration."-".count($houses)."\n";
foreach($houses as $key=>$house){
$url_path = NULL;
if($house['address']!=''&&$house['state']!=''&&$house['zip']!=''&&$house['city']!=''){
$url_path = str_replace(" ","-",preg_replace("|[^[:alnum:]\s]|","",unhtmlspecialchars($house['address'])))."-".str_replace(" ","-",preg_replace("|[^[:alnum:]\s]|","",unhtmlspecialchars($house['city'])))."-".$house['state']."-".$house['zip'];
}
$findSql = "SELECT * FROM realty WHERE full_address_md5='" . $db->escapeSting($house['full_address_md5']) . "'";
$realty = $db->select_row($findSql);
if ($realty) {
$sql = "UPDATE realty SET
valid = '".(int) $db->escapeSting($house['valid'])."',
site_index = '".$db->escapeSting($house['site_index'])."',
property_id = '".$db->escapeSting($house['property_id'])."',
MLSID = '".$db->escapeSting($house['MLSID'])."',
REOID = '".$db->escapeSting($house['REOID'])."',
image_url = '".$db->escapeSting($house['image_url'])."',
image_url_orig = '".$db->escapeSting($house['image_url_orig'])."',
status_type = '".$db->escapeSting($house['status_type'])."',
status = '".$db->escapeSting($house['status'])."',
`type` = '".$db->escapeSting($house['type'])."',
address = '".$db->escapeSting(urldecode($house['address']))."',
country = '".$db->escapeSting($house['country'])."',
county = '".$db->escapeSting($house['county'])."',
city = '".$db->escapeSting($house['city'])."',
state = '".$db->escapeSting($house['state'])."',
zip = '".$db->escapeSting($house['zip'])."',
url = '".$db->escapeSting($house['url'])."',
agent = '".$db->escapeSting(trim($house['agent']))."',
price = '".$db->escapeSting($house['price'])."',
brokerage_firm = '".$db->escapeSting($house['brokerage_firm'])."',
brokerage_address = '".$db->escapeSting($house['brokerage_address'])."',
brokerage_city = '".$db->escapeSting($house['brokerage_city'])."',
brokerage_state = '".$db->escapeSting($house['brokerage_state'])."',
brokerage_zip = '".$db->escapeSting($house['brokerage_zip'])."',
brokerage_phone = '".$db->escapeSting($house['brokerage_phone'])."',
brokerage_email = '".$db->escapeSting($house['brokerage_email'])."',
phone = '".$db->escapeSting($house['phone'])."',
email = '".$db->escapeSting($house['email'])."',
created_date = '".$db->escapeSting($house['created_date'])."',
last_update = '".$db->escapeSting($house['last_update'])."',
additional_info = '".$db->escapeSting($house['additional_info'])."',
bedrooms = '".$db->escapeSting($house['bedrooms'])."',
bathrooms = '".$db->escapeSting($house['bathrooms'])."',
stories = '".$db->escapeSting($house['stories'])."',
sleeps = '".$db->escapeSting($house['sleeps'])."',
area = '".$db->escapeSting($house['area'])."',
living_area = '".$db->escapeSting($house['living_area'])."',
garages = '".$db->escapeSting($house['garages'])."',
parking_spaces = '".$db->escapeSting($house['parking_spaces'])."',
construction_year = '".$db->escapeSting($house['construction_year'])."',
patio = '".$db->escapeSting($house['patio'])."',
swimming_pool = '".$db->escapeSting($house['swimming_pool'])."',
basement = '".$db->escapeSting($house['basement'])."',
fire_place = '".$db->escapeSting($house['fire_place'])."',
back_yeard = '".$db->escapeSting($house['back_yeard'])."',
floors = '".$db->escapeSting($house['floors'])."',
flooring = '".$db->escapeSting($house['flooring'])."',
heating_type = '".$db->escapeSting($house['heating_type'])."',
sewer_type = '".$db->escapeSting($house['sewer_type'])."',
roof = '".$db->escapeSting($house['roof'])."',
rooms = '".$db->escapeSting($house['rooms'])."',
source = '".$db->escapeSting($house['source'])."',
market_type = '".$db->escapeSting($house['market_type'])."',
sale_status = '".$db->escapeSting($house['sale_status'])."',
image_thumb = '".$db->escapeSting($house['image_thumb'])."'
WHERE full_address_md5 = '".$db->escapeSting($house['full_address_md5'])."'";
} else {
$sql = "INSERT INTO realty
(
valid,
site_index,
property_id,
MLSID,
REOID,
image_url,
image_url_orig,
status_type,
status,
type,
address,
country,
county,
city,
state,
zip,
full_address_md5,
url,
agent,
price,
brokerage_firm,
brokerage_address,
brokerage_city,
brokerage_state,
brokerage_zip,
brokerage_phone,
brokerage_email,
phone,
email,
created_date,
last_update,
additional_info,
bedrooms,
bathrooms,
stories,
sleeps,
area,
living_area,
garages,
parking_spaces,
construction_year,
patio,
swimming_pool,
basement,
fire_place,
back_yeard,
floors,
flooring,
heating_type,
sewer_type,
roof,
rooms,
source,
market_type,
sale_status,
image_thumb
)
VALUES
(
'".(int) $db->escapeSting($house['valid'])."',
'".$db->escapeSting($house['site_index'])."',
'".$db->escapeSting($house['property_id'])."',
'".$db->escapeSting($house['MLSID'])."',
'".$db->escapeSting($house['REOID'])."',
'".$db->escapeSting($house['image_url'])."',
'".$db->escapeSting($house['image_url_orig'])."',
'".$db->escapeSting($house['status_type'])."',
'".$db->escapeSting($house['status'])."',
'".$db->escapeSting($house['type'])."',
'".$db->escapeSting(urldecode($house['address']))."',
'".$db->escapeSting($house['country'])."',
'".$db->escapeSting($house['county'])."',
'".$db->escapeSting($house['city'])."',
'".$db->escapeSting($house['state'])."',
'".$db->escapeSting($house['zip'])."',
'".$db->escapeSting($house['full_address_md5'])."',
'".$db->escapeSting($house['url'])."',
'".$db->escapeSting(trim($house['agent']))."',
'".$db->escapeSting($house['price'])."',
'".$db->escapeSting($house['brokerage_firm'])."',
'".$db->escapeSting($house['brokerage_address'])."',
'".$db->escapeSting($house['brokerage_city'])."',
'".$db->escapeSting($house['brokerage_state'])."',
'".$db->escapeSting($house['brokerage_zip'])."',
'".$db->escapeSting($house['brokerage_phone'])."',
'".$db->escapeSting($house['brokerage_email'])."',
'".$db->escapeSting($house['phone'])."',
'".$db->escapeSting($house['email'])."',
'".$db->escapeSting($house['created_date'])."',
'".$db->escapeSting($house['last_update'])."',
'".$db->escapeSting($house['additional_info'])."',
'".$db->escapeSting($house['bedrooms'])."',
'".$db->escapeSting($house['bathrooms'])."',
'".$db->escapeSting($house['stories'])."',
'".$db->escapeSting($house['sleeps'])."',
'".$db->escapeSting($house['area'])."',
'".$db->escapeSting($house['living_area'])."',
'".$db->escapeSting($house['garages'])."',
'".$db->escapeSting($house['parking_spaces'])."',
'".$db->escapeSting($house['construction_year'])."',
'".$db->escapeSting($house['patio'])."',
'".$db->escapeSting($house['swimming_pool'])."',
'".$db->escapeSting($house['basement'])."',
'".$db->escapeSting($house['fire_place'])."',
'".$db->escapeSting($house['back_yeard'])."',
'".$db->escapeSting($house['floors'])."',
'".$db->escapeSting($house['flooring'])."',
'".$db->escapeSting($house['heating_type'])."',
'".$db->escapeSting($house['sewer_type'])."',
'".$db->escapeSting($house['roof'])."',
'".$db->escapeSting($house['rooms'])."',
'".$db->escapeSting($house['source'])."',
'".$db->escapeSting($house['market_type'])."',
'".$db->escapeSting($house['sale_status'])."',
'".$db->escapeSting($house['image_thumb'])."'
) ON DUPLICATE KEY UPDATE
valid= '".(int) $db->escapeSting($house['valid'])."',
site_index= '".$db->escapeSting($house['site_index'])."',
property_id= '".$db->escapeSting($house['property_id'])."',
MLSID= '".$db->escapeSting($house['MLSID'])."',
REOID= '".$db->escapeSting($house['REOID'])."',
image_url= '".$db->escapeSting($house['image_url'])."',
image_url_orig= '".$db->escapeSting($house['image_url_orig'])."',
status_type= '".$db->escapeSting($house['status_type'])."',
status= '".$db->escapeSting($house['status'])."',
type= '".$db->escapeSting($house['type'])."',
address= '".$db->escapeSting(urldecode($house['address']))."',
country= '".$db->escapeSting($house['country'])."',
county= '".$db->escapeSting($house['county'])."',
city= '".$db->escapeSting($house['city'])."',
state= '".$db->escapeSting($house['state'])."',
zip= '".$db->escapeSting($house['zip'])."',
full_address_md5 = '".$db->escapeSting($house['full_address_md5'])."',
url = '".$db->escapeSting($house['url'])."',
agent= '".$db->escapeSting(trim($house['agent']))."',
price= '".$db->escapeSting($house['price'])."',
brokerage_firm= '".$db->escapeSting($house['brokerage_firm'])."',
brokerage_address= '".$db->escapeSting($house['brokerage_address'])."',
brokerage_city= '".$db->escapeSting($house['brokerage_city'])."',
brokerage_state= '".$db->escapeSting($house['brokerage_state'])."',
brokerage_zip= '".$db->escapeSting($house['brokerage_zip'])."',
brokerage_phone= '".$db->escapeSting($house['brokerage_phone'])."',
brokerage_email= '".$db->escapeSting($house['brokerage_email'])."',
phone= '".$db->escapeSting($house['phone'])."',
email= '".$db->escapeSting($house['email'])."',
created_date= '".$db->escapeSting($house['created_date'])."',
last_update= '".$db->escapeSting($house['last_update'])."',
additional_info= '".$db->escapeSting($house['additional_info'])."',
bedrooms= '".$db->escapeSting($house['bedrooms'])."',
bathrooms= '".$db->escapeSting($house['bathrooms'])."',
stories= '".$db->escapeSting($house['stories'])."',
sleeps= '".$db->escapeSting($house['sleeps'])."',
area= '".$db->escapeSting($house['area'])."',
living_area= '".$db->escapeSting($house['living_area'])."',
garages= '".$db->escapeSting($house['garages'])."',
parking_spaces= '".$db->escapeSting($house['parking_spaces'])."',
construction_year= '".$db->escapeSting($house['construction_year'])."',
patio= '".$db->escapeSting($house['patio'])."',
swimming_pool= '".$db->escapeSting($house['swimming_pool'])."',
basement= '".$db->escapeSting($house['basement'])."',
fire_place= '".$db->escapeSting($house['fire_place'])."',
back_yeard= '".$db->escapeSting($house['back_yeard'])."',
floors= '".$db->escapeSting($house['floors'])."',
flooring= '".$db->escapeSting($house['flooring'])."',
heating_type= '".$db->escapeSting($house['heating_type'])."',
sewer_type= '".$db->escapeSting($house['sewer_type'])."',
roof= '".$db->escapeSting($house['roof'])."',
rooms= '".$db->escapeSting($house['rooms'])."',
source= '".$db->escapeSting($house['source'])."',
market_type = '".$db->escapeSting($house['market_type'])."',
sale_status = '".$db->escapeSting($house['sale_status'])."',
image_thumb = '".$db->escapeSting($house['image_thumb'])."'
";
}
$home_sql=$sql;
if($db->query($sql)){
}else{
echo $sql;
echo $house['ID']."-".($i++)."\n";
exit;
}
//exit;
//FIX DATA
$sql="update realty set city='".$db->escapeSting(urldecode($house['city']))."', address='".$db->escapeSting(urldecode($house['address']))."' WHERE full_address_md5='".$db->escapeSting($house['full_address_md5'])."'";
$db->query($sql);
//SET - URL
if($house['address']!=''&&$house['state']!=''&&$house['zip']!=''&&$house['city']!=''){
$sql="update realty set url_path='".str_replace(" ","-",preg_replace("|[^[:alnum:]\s]|","",unhtmlspecialchars($house['address'])))."-".str_replace(" ","-",preg_replace("|[^[:alnum:]\s]|","",unhtmlspecialchars($house['city'])))."-".$house['state']."-".$house['zip']."' where (url_path is null or url_path!='') and full_address_md5='".$db->escapeSting($house['full_address_md5'])."'";
if($db->query($sql)){
}else{
//echo $home_sql;
// $sql = "SELECT ID,url_path FROM realty WHERE url_path='".str_replace(" ","-",preg_replace("|[^[:alnum:]\s]|","",unhtmlspecialchars($house['address'])))."-".str_replace(" ","-",preg_replace("|[^[:alnum:]\s]|","",unhtmlspecialchars($house['city'])))."-".$house['state']."-".$house['zip']."'";
// $house_old = $db->select_row($sql);
// $sql = $db->query("delete from realty where ID='".$house_old['ID']."'");
// $sql = $db->query("update realty set url_path='".$house_old['url_path']."' where ID='".$house['ID']."'");
}
}
}
}
print_r($houses_count);
function unhtmlspecialchars( $string )
{
$string = str_replace ( '&', '&', $string );
$string = str_replace ( ''', '\'', $string );
$string = str_replace ( '"', '\"', $string );
$string = str_replace ( '<', '<', $string );
$string = str_replace ( '>', '>', $string );
$string = str_replace ( '#', '', $string );
return $string;
}
?>