Viewing file:  listing_functions.php (5.34 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
/************************************************************
make array for each new visit
***************************************************************/
function makeListingsArray(){
global $dataStr, $properties;
//get makras data
$domain = "www.makrasrealestate.com";
$username = "makras";
$password = "agne0sri";
$database = "makras";
$db = mysql_connect("$domain", "$username", "$password");
mysql_select_db($database ,$db);
$query = "SELECT ID from listings WHERE active = 'yes' ORDER BY year desc, month desc";
$index_data = mysql_query($query, $db);
$rows = mysql_num_rows($index_data);
$database = "makras";
for ($i = 0; $i < $rows; $i++){
$ID = mysql_result($index_data, $i, 'ID');
$dataStr .= "$database-$ID,";
}
mysql_close($db);
if ($rows < 10){ //go to SFM database if there are less than 10 listings in makras db
//get SFM data
$dataStr .= file_get_contents('http://sfmkt.com/makras/getdata.php');
}
$dataStr = substr($dataStr, 0, -1); //get rid of the trailing comma
}//end function
/**************************************************************
GET INDEX DATA
***************************************************************/
function getIndexRecord($current, $dataStr){
global $index_data, $database, $arrayCount, $ID, $intro, $price, $title, $thumb;
$dataArray = explode(",", $dataStr);//split data array into entries like sfm-3 or makras-5
$arrayCount = count($dataArray);
for ($i = 0; $i < $arrayCount; $i++){//split array elements into component parts:sfm, 3
$values = explode ("-", $dataArray[$i]);
$dataArray[$i] = array($values[0], $values[1]);
}
$ID = $dataArray[$current][1];
if ($dataArray[$current][0] == "makras"){ //the current database
$domain = "www.makrasrealestate.com";
$username = "makras";
$password = "agne0sri";
$database = "makras";
$query = "SELECT ID, title, thumb, intro, price FROM listings WHERE ID = $ID";
$db = mysql_connect("$domain", "$username", "$password");
mysql_select_db($database ,$db);
$index_data = mysql_query($query, $db);
$ID = mysql_result($index_data, 0, 'ID');
$intro = mysql_result($index_data, 0, 'intro');
$price = mysql_result($index_data, 0, 'price');
$title = mysql_result($index_data, 0, 'title');
$thumb = mysql_result($index_data, 0, 'thumb');
}
else if ($dataArray[$current][0] == "sfm"){
$values = unserialize(file_get_contents('http://www.sfmkt.com/makras/getindexdata.php?ID='.$ID));
$intro = $values[1];
$price = $values[2];
$title = $values[3];
$thumb = $values[4];
}
}//end of function
/**************************************************************
detail detail detail detail detail detail detail detail
GET DETAIL DATA
detail detail detail detail detail detail detail detail
***************************************************************/
function getDetailRecord($current, $dataStr){
global $detail_data, $database, $arrayCount, $ID, $description, $price, $show_price, $title, $main_pic, $picture1, $picture2, $picture3, $picture4, $bullet1, $bullet2, $bullet3, $bullet4, $bullet5, $bullet6;
$dataArray = explode(",", $dataStr);//split data array into entries like sfm-3 or makras-5
$arrayCount = count($dataArray);
for ($i = 0; $i < $arrayCount; $i++){//split array elements into component parts:sfm, 3
$values = explode ("-", $dataArray[$i]);
$dataArray[$i] = array($values[0], $values[1]);
}
$ID = $dataArray[$current][1];
if ($dataArray[$current][0] == "makras"){ //the current database
$domain = "www.makrasrealestate.com";
$username = "makras";
$password = "agne0sri";
$database = "makras";
$query = "SELECT * FROM listings WHERE ID = $ID";
$db = mysql_connect("$domain", "$username", "$password");
mysql_select_db($database ,$db);
$detail_data = mysql_query($query, $db);
$ID = mysql_result($detail_data, 0, 'ID');
$description = mysql_result($detail_data, 0, 'description');
$price = mysql_result($detail_data, 0, 'price');
$show_price = mysql_result($detail_data, 0, 'show_price');
$title = mysql_result($detail_data, 0, 'title');
$main_pic = mysql_result($detail_data, 0, 'main_pic');
$picture1 = mysql_result($detail_data, 0, 'picture1');
$picture2 = mysql_result($detail_data, 0, 'picture2');
$picture3 = mysql_result($detail_data, 0, 'picture3');
$picture4 = mysql_result($detail_data, 0, 'picture4');
$bullet1 = mysql_result($detail_data, 0, 'bullet1');
$bullet2 = mysql_result($detail_data, 0, 'bullet2');
$bullet3 = mysql_result($detail_data, 0, 'bullet3');
$bullet4 = mysql_result($detail_data, 0, 'bullet4');
$bullet5 = mysql_result($detail_data, 0, 'bullet5');
$bullet6 = mysql_result($detail_data, 0, 'bullet6');//this bullet contains listings agent info
}
else if ($dataArray[$current][0] == "sfm"){
$values = unserialize(file_get_contents('http://www.sfmkt.com/makras/getdetail.php?ID='.$ID));
$description = $values[1];
$price = $values[2];
$show_price = $values[3];
$title = $values[4];
$main_pic = $values[5];
$picture1 = $values[6];
$picture2 = $values[7];
$picture3 = $values[8];
$picture4 = $values[9];
$bullet1 = $values[10];
$bullet2 = $values[11];
$bullet3 = $values[12];
$bullet4 = $values[13];
$bullet5 = $values[14];
$bullet6 = $values[15];
}
}//end of function
?>
|