$response = $rets->Login();
var_dump($response);
//$response=$rets->GetCount('Property','11','(363=|A)');
//print $response.'<br/>';
$sysid_array = $rets->GetDataArray('Property', '11', '(363=|A)', 'sysid', null);
//echo count($sysid_array).'<br/>';
foreach ($sysid_array as $index => $array) {
//echo '<br/>['.$index.']'.$array['sysid'].'<br/>';
insert_sysid($array['sysid']);
}
$selectSQL = "SELECT sysid FROM sysid_raw WHERE imported='N' AND problem='N' LIMIT 0, 50";
$get_sysid = mysql_query_or_die($selectSQL, $useradmin);
while ($row_get_sysid = mysql_fetch_assoc($get_sysid)) {
$new_sysid = $row_get_sysid['sysid'];
$listing_array = $rets->GetDataArray('Property', '11', '(sysid=' . $new_sysid . ')', null, null);
if (insert_update_listing($listing_array[0])) {
if (update_sysid_in_raw($new_sysid)) {
echo "<br/><span style=\"color:#336633;\">[info] sysid updated in sysid_raw database. {$new_sysid} imported='Y'.</span><br/>";
}
} else {
echo "<br/><span style=\"color:#FF0000;\">[warning] didn't get anything from the server</span><br/>";
sysid_problem_in_raw($new_sysid);
}
}
/*$selectSQL = "SELECT sysid FROM listings WHERE ISNULL(title_to_land) LIMIT 0,8";
$get_sysid = mysql_query_or_die($selectSQL, $useradmin);
while ($row_get_sysid=mysql_fetch_assoc($get_sysid)){
$new_sysid=$row_get_sysid['sysid'];
$listing_array = $rets->GetDataArray('Property','11','(sysid='.$new_sysid.')',null,null);
if(insert_update_listing($listing_array[0])){
echo "<br/><span style=\"color:#336633\">[info] Title to land updated</span><br/>";
function import_sysid()
{
global $useradmin, $rets;
$selectSQL = "SELECT sysid FROM sysid_raw_new LIMIT 0, 50";
$get_sysid = mysql_query_or_die($selectSQL, $useradmin);
while ($row_get_sysid = mysql_fetch_assoc($get_sysid)) {
$listing_array = $rets->GetDataArray('Property', '11', '(sysid=' . $row_get_sysid['sysid'] . ')', null, 1);
if (insert_update_listing($listing_array[0])) {
echo "<br/>[Info] Successfully inserted to listings databse<br/>";
$deleteSQL = "DELETE FROM sysid_raw_new WHERE sysid=" . $row_get_sysid['sysid'];
$result = mysql_query_or_die($deleteSQL, $useradmin);
} else {
echo "<br/>[Warning] Error occured when inserting record<br/>";
}
}
$selectSQL = "SELECT listings.sysid FROM sysid_raw_current LEFT JOIN listings ON sysid_raw_current.sysid=listings.sysid WHERE listings.status='D'";
$get_sysid = mysql_query_or_die($selectSQL, $useradmin);
while ($row_get_sysid = mysql_fetch_assoc($get_sysid)) {
echo "<br/>re-activating sysid:" . $row_get_sysid['sysid'] . "<br/>";
$updateSQL = sprintf("UPDATE listings SET status=%s WHERE sysid=%s", GetSQLValueString('A', "text"), GetSQLValueString($row_get_sysid['sysid'], "int"));
$result = mysql_query_or_die($updateSQL, $useradmin);
}
}
