//IM COMMENTING OUT THE HOST/USER/PASS CONFIGS FROM PAGES THAT QUERY HOMES DATA SO THEY CAN USE THE CONFIG BELOW TO QUERY HOMES DATA FROM OTHER SERVER. REFERRALS DB QUERIES WILL BE LEFT AS THEY ARE SO THEY QUERY/ADD/UPDATE THE LOCAL SERVER USING THE LOCALHOST CREDENTIALS THEY HAVE. //$host="db.saguaromail.com"; //$user="thisuser"; //$password="thispassxyz"; $host="localhost"; $user="root"; $password="baldeagle"; $user_agent=$_SERVER['HTTP_USER_AGENT']; //print "$user_agent
"; $ip= $REMOTE_ADDR; $existing_url="http://". $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; //print "$existing_url
"; $www_count=substr_count($existing_url, "http://www."); //print "$www_count
"; if ($www_count==0){ $redirected_url=str_replace("http://", "http://www.", $existing_url); //print "$redirected_url
"; header("Location: $redirected_url"); } include ("/sites/relocationusa_tp/register_globals.htm"); include "header_variables.htm"; include "/sites/relocationusa_tp/spam_lead_checks.htm"; $thisbrokerage='relocationUSA'; $theirip=$_SERVER['REMOTE_ADDR']; $myphone='(602)562-8416'; $mydir="armls"; $site_name=('phoenixrealestate-homes.com'); $partner='barb'; $lastrecip='lastrecip_phx'; $recip_page='recip_page_phx'; $entry_date='entry_date_phx'; //$table='partners'; $thispath=$_SERVER["REQUEST_URI"]; //$thispath=str_replace("%20", " ", $thispath); $htmcount=substr_count($thispath, ".htm"); $homescount=substr_count($thispath, "/homes/"); $spacecount=substr_count($thispath, "%20"); //print "
$spacecount"; if ($spacecount>=5 and $htmcount and $homescount) { //print "Homes Page"; $homespage='yes'; //set header ok after www. url redirect if ($www_count==1){ //header("HTTP/1.1 200 OK"); } } //print "$thispath
"; if (!substr_count($thispath, "/blog/") and !substr_count($thispath, "enter_commitment.htm") and !substr_count($thispath, ".js") ) { //load rest of header file //print "$thispath"; //print ("--$whichsection--"); //print_r($_COOKIE); $key=date("F j, Y"); //$key=date('l jS \of F Y \h\i\h\o'); $mypath=str_replace("%20", " ", $thispath); $today=date("Y-m-d H:i:s"); //print ("$mypath
"); $rev=strrev($mypath); //print ("$rev
"); $pos=strpos($rev, "/"); //print ("$pos
"); $show=substr($rev, 0, $pos); //print ("$show
"); $show=strrev($show); //print ("$show
"); $show=substr($show, 0, strlen($show)-4 ); //print ("$show
"); $underscorepos=strpos($show, "_"); if ($underscorepos) { $pagenum=substr($show, $underscorepos+1); //print $pagenum; $show=substr($show, 0, $underscorepos); } //if ($mlsno and $show!="saproperty") header("location:/data/armls/saproperty.asp?mlsno=$mlsno"); //REFORMAT CASE AND CHANGE CERTAIN FILENAMES VALUES $show=ucwords($show); $show=str_replace(" Of ", " of ", $show); $show=str_replace("Golfcity", "City", $show); $show=str_replace("Golfcourse", "Golf Community", $show); $show=str_replace("Listingtype", "Property Type", $show); $show=str_replace("Golfcommunity", "Golf Community", $show); //$show=str_replace("Horse", "City", $show); $show=str_replace("Index", "", $show); $show=str_replace("Popular", "Subdivision", $show); //print $show; //SET THE MODIFIER, MIDDLER, BETWEEN, ENDER AS APPROPRIATE if (substr_count($mypath, "/golf/")) {$modifier=("Golf ");} if (substr_count($mypath, "/gated/")) {$ender=(" Communities");} if (substr_count($mypath, "/construction/")) {$ender=(" Construction");} if (substr_count($mypath, "/levels/")) {$ender=(" Story");} if (substr_count($mypath, "/style/")) {$ender=(" Style");} if (substr_count($mypath, "/bedrooms/")) {$ender=(" Bedroom");} if (substr_count($mypath, "/baths/")) {$ender=(" Bath");} if (substr_count($mypath, "/horse/")) {$modifier=("Horse ");} if (substr_count($mypath, "/Apartment Style/")) {$modifier=("Apartment Style ");} if (substr_count($mypath, "/Single Family/")) {$modifier=("Single Family ");} if (substr_count($mypath, "/Single Family (New)/")) {$modifier=("Single Family (New) ");} if (substr_count($mypath, "/Townhouse/")) {$modifier=("Townhouse ");} if (substr_count($mypath, "/Townhouse (New)/")) {$modifier=("Townhouse (New) ");} if (substr_count($mypath, "/Patio Home/")) {$modifier=("Patio Home ");} if (substr_count($mypath, "/Loft Style/")) {$modifier=("Loft Style ");} if (substr_count($mypath, "/Gemini Twin/")) {$modifier=("Gemini Twin ");} if (substr_count($mypath, "/Modular Home/")) {$modifier=("Modular Home ");} if (substr_count($mypath, "/bankowned.htm")) {$modifier="Bank Owned"; $between=''; $show='by City';} if (substr_count($mypath, "/bankowned/")) {$modifier="Bank Owned";} if (substr_count($mypath, "/shortsale.htm")) {$modifier="Short Sale"; $between=''; $show='by City';} if (substr_count($mypath, "/shortsale/")) {$modifier="Short Sale";} if (substr_count($mypath, "/leasepurchase.htm")) {$modifier="Lease Purchase"; $between=''; $show=' ';} if (substr_count($mypath, "/leasepurchase/")) {$modifier="Lease Purchase";} //if (substr_count($mypath, "/district/")) {$middler=("District");} if (substr_count($mypath, "/area/")) {$middler=("Area");} //if (substr_count($mypath, "/acres/")) {$ender=(" on 1 or more Acres of Land");} if (substr_count($mypath, "/homes/")) $show=substr($show, 7, 100); if (substr_count($mypath, "/property/")) $show=substr($show, 7, 100); /* if (substr_count($mypath, "/levels/") or substr_count($mypath, "/zip/")) {} else { $digits = array("0", "1", "2", "3", "4", "5", "6", "7", "8", "9"); $show=str_replace($digits,"",$show); } */ if (substr_count($mypath, "/levels/")) $show=$show{0}; //only show first digit & leave out the page # if (substr_count($mypath, "/zip/")) $show=substr($show, 0, 5); //only show first digit & leave out the page # $between='in'; if (substr_count($mypath, "/address.htm")) {$between=('by');} if (substr_count($mypath, "/popular.htm")) {$between=('by');} if (substr_count($mypath, "/high.htm")) {$show=('High School'); $between=('by'); $list="yes";} if (substr_count($mypath, "/middle.htm")) {$show=('Junior High School '); $between=('by'); $list="yes";} if (substr_count($mypath, "/elementary.htm")) {$show=('Elementary School '); $between=('by'); $list="yes";} if (substr_count($mypath, "/districthigh.htm")) {$show='High School District'; $between=('by'); $list="yes";} if (substr_count($mypath, "/districtelem.htm")) {$show='Elementary School District'; $between=('by'); $list="yes";} if (substr_count($mypath, "/style.htm")) {$between=('by');} if (substr_count($mypath, "/rent.htm")) {$between=('for');} if (substr_count($mypath, "/University of Arizona")) {$between=('near');} if (substr_count($mypath, "/Acres")) {$between=""; $show="with Land"; $list="yes";} //if (substr_count($mypath, "/golf.htm")) {$between=('by'); $ender=" Community";} if (substr_count($mypath, "/gated.htm")) {$between=('by'); $ender=" Community";} if (substr_count($mypath, "/listingtype.htm")) {$between=('by'); $list="yes";} if (substr_count($mypath, "/subdivision.htm")) {$between=('by'); $list="yes";} if (substr_count($mypath, "/community.htm")) {$between=('by'); $list="yes";} if (substr_count($mypath, "/golf.htm")) {$between=('by'); $modifier=('Golf');} if (substr_count($mypath, "/school.htm")) {$between=('by'); $list="yes";} if (substr_count($mypath, "/construction.htm")) {$between=('by'); $list="yes";} if (substr_count($mypath, "/zoning.htm")) {$between=('by'); $list="yes";} if (substr_count($mypath, "/levels.htm")) {$between=('by'); $list="yes";} if (substr_count($mypath, "/bedrooms.htm")) {$between=('by');} if (substr_count($mypath, "/bathrooms.htm")) {$between=('by');} if (substr_count($mypath, "/city.htm")) {$between=('by'); $list="yes";} if (substr_count($mypath, "/area.htm")) {$between=('by'); $list="yes";} if (substr_count($mypath, "/zip.htm")) {$between=('by'); $list="yes";} if (substr_count($mypath, "/builder.htm")) {$between=('by'); $list="yes";} if (substr_count($mypath, "/retirement.htm")) {$show=('Active Adult Communities');} if (substr_count($mypath, "/golfcity.htm")) {$modifier='Golf Course '; $between=('by');} if (substr_count($mypath, "/golfcourse.htm")) {$modifier='Golf Course '; $between=('by');} if (substr_count($mypath, "/golfcommunity.htm")) {$between=('by');} if (substr_count($mypath, "/horse.htm")) {$between=('by'); $ender=(' Property');} if (substr_count($mypath, "/combination")) {$between=('by'); $list="yes";} if (substr_count($mypath, "/income listingtype.htm")) {$show="Income Property Type"; $between=('by'); $list="yes";} $firstpart="Real Estate"; if (substr_count($mypath, "/favorite_sites/")) {$firstpart=('Recommended Sites');} elseif (substr_count($mypath, "/saved/contact_form.htm")) print ("
");
//$KWD IS THE START OF THE TITLE AND HEADING - IT IS 'TUCSON' or ANOTHER CITY
//$REDUNDANT is KWD but is set to nothing if it's in $SHOW
$kwd='Phoenix';
//SET THE KWD TO THE OTHER CITY IF THERE IS ONE
if (substr_count("$mypath", "/acres/")) {$kwd="$show";}
if (substr_count("$mypath", "/horse/")) {$kwd="$show";}
if (substr_count("$mypath", "/city/")) {$kwd="$show";}
$redundant=$kwd;
if (substr_count($show, $kwd)) $redundant='';
//print ("|$show| |$kwd| |$redundant|
");
//SOME FINAL CHEATS FOR CASES WHERE LISTING BY CITY BUT WANT SHOW TO BE SOMETHING ELSE
if (substr_count($mypath, "/golfcity.htm")) {$show_space=str_replace("City", "Golf", $show_space);}
if (substr_count($mypath, "/horse.htm")) {$show_space=str_replace("City", "Horse Property", $show_space);}
include("lastrecip.php");
//include("top_content.php");
?>
//
?>
"; //ignore pest client user if ($theirip!='45.155.204.82') { //include("/sites/default/data/getheader.php"); if ($filename){ //IF PAGE PREGENERATED print ("\n"); } //print("$whereclause
"); //print("$num_args"); //decode whereclause //$whereclause=urldecode($whereclause); $whereclause = str_replace("\\" , "" , $whereclause); $url_subdivision=(urlencode($subdivision)); //print ("$url_subdivision"); //SET START RECORD BASED ON PAGING MOVE $count=0; if (!$start_record) {$start_record=1;} if ($paging_move=="previous") {$start_record = $start_record - 40;} elseif ($paging_move=="next") {$start_record = $start_record + 40;} if ($start_record<1) {$start_record=1;} //print("$whereclause"); $thisday= (date("d")-1); $thismonth=date("m"); $thisyear=date("y"); $thishour= date("H"); $thisminute=date("i"); $thissecond=date("s"); $yesterday=date("Y-m-d H:i:s", mktime($thishour, $thisminute, $thissecond, $thismonth, $thisday, $thisyear)); //SET UP TABLE QUERY FOR MATCHING RECORDS $host="localhost"; $user="getdata"; $password="getdata"; $dbname="armls"; $tablename="armls_homes"; $link=mysqli_connect ($host, $user, $password, $dbname); if ($keyword=='newlistings') { if ($city) $thiscity="and city='$city'"; $today=date("Ymd"); $query="select cross_streets, latitude, longitude, url, propsubtype, subdivision, mls_number, sqft, sellertype, mlsno, bedrooms, baths, street_suffix, zip, city, price, addrnum, unit, state, addrname, nsew from armls_homes left join armls_images on (armls_homes.mlsno=armls_images.mls_no and armls_images.photonum='1') left join newlistings on mlsno=mls_number where listing_date>='$yesterday' and listing_count='1' $thiscity order by price, internal_listing_id"; }else{ $query="select concat_ws(' ', NULLIF(addrnum, ''), NULLIF(nsew, ''), NULLIF(addrname, ''), NULLIF(street_suffix, ''), NULLIF(unit, ''), NULLIF(city, ''), NULLIF(state, '')) as address, cross_streets, sellertype, sqft, latitude, longitude, url, propsubtype, subdivision, mlsno, bedrooms, baths, street_suffix, zip, city, price, addrnum, unit, addrname, nsew, state from armls_homes left join armls_images on (armls_homes.mlsno=armls_images.mls_no and armls_images.photonum='1')".$whereclause;} //echo ("$query"); $data=mysqli_query ($link, $query); $num_rows = mysqli_num_rows($data); //print $num_rows; if (substr_count($mypath, "/sasearch.asp") or substr_count($mypath, "/getdata.asp") or substr_count($mypath, "/paged_re_listings.asp")){ $thiswidth="width=975"; } //CREATE TABLE AND PRINT NAVIGATIONAL & STATISTICAL STUFF print "
\n");
if ($keyword or ($whereclause and $whereclause!=" order by price")) { //only show if whereclause
//include navigation section
include("navigation_greeting.asp");
include("navigation_data.asp");
print " "; if ($filename){ print ("\$show_this=\"$show_this\"; \$whereclause=\"$whereclause\"; include(\"/sites/default/data/armls/saved/banner.htm\");?>\n"); //print " "; }elseif ($num_rows){ include("saved/banner.htm"); //print " "; } //End of Table & Statistical/Navigational Stuff print (" | ||||
\n\n | ||||
\n"; if ("$Row[url]"){ print ("");} else {print ("");} print ("\n | ");
if ("$Row[addrnum]"){print ("$Row[addrnum] ");}
print("$Row[nsew] $Row[addrname]");
if ("$Row[street_suffix]"!="Parkway") {print (" $Row[street_suffix]");}
if ("$Row[unit]") {print (" #$Row[unit]");}
print(" "); if ("$Row[city]") {print ("$Row[city]");} elseif ("$Row[county]") {print (", $Row[county] county");} print(", Arizona $Row[zip] "); if ($site=="phoenix") { print ("\$subdivision=\"$Row[subdivision]\"; \$city=\"$Row[city]\"; include(\"/sites/default/data/armls/page_subdivision.php\");?>\n"); }else{ include("page_subdivision_live.php"); } //end if phx site print(" "); print(" "); //if ($Row[sellertype]) {print "$Row[sellertype]";} if ("$Row[cross_streets]") {print "Near $Row[cross_streets]"; }else{ print " "; } if ("$Row[bedrooms]" or "$Row[baths]") print(" "); if ("$Row[bedrooms]"=='1') $plural="Bedroom"; elseif ("$Row[bedrooms]">1) $plural="Bedrooms"; if ("$Row[bedrooms]") {print("$Row[bedrooms] $plural ");} if ("$Row[baths]"=='1') $plural_baths="Bath"; elseif ("$Row[baths]">1) $plural_baths="Baths"; if ("$Row[baths]") { //remove decimal places if filled with zeros $these_baths=str_replace(".00", "", "$Row[baths]"); $these_baths=str_replace("0", "", "$these_baths"); if ("$Row[baths]") {print("$Row[baths] $plural_baths ");} } print (" | ");
print("Property Details "); $City = str_replace(" ", "+", "$Row[city]"); //$State = str_replace(" ", "+", $Row[state]); $State='AZ'; $Addrnum = str_replace(" ", "+", "$Row[addrnum]"); $Nsew = str_replace(" ", "+", "$Row[nsew]"); $Addrname = str_replace(" ", "+", "$Row[addrname]"); $Street_Suffix = str_replace(" ", "+", "$Row[street_suffix]"); $Zip = str_replace(" ", "+", "$Row[zip]"); $mapstring="city=$Mun&state=$State&address=$addrnum+$nsew+$addrname+$Street_Suffix&zip=$Zip&country=us&zoom=10"; $mapstring=str_replace("++", "+", "$mapstring"); $mapstring=str_replace("++", "+", "$mapstring"); $mapstring=str_replace("++", "+", "$mapstring"); $latitude="$Row[latitude]"; $longitude="$Row[longitude]"; $county="$Row[County]"; $unit="$Row[Unit]"; print "Request Information ";
print("\$");
print number_format("$Row[price]"); //print(" $Row[propsubtype]"); print(" "); if ("$Row[sqft]") {print (number_format("$Row[sqft]")." Sqft");} if (($minlotsqft or $maxlotsqft) and $Row[lotsqft]){ if ($Row[lotsqft]>=43560) { $page_acres=floor($Row[lotsqft]/43560); //$page_acres=($Row[lotsqft]/43560); if ($page_acres=='1') $plural="Acre"; elseif ($page_acres>1) $plural="Acres"; print(" ".$page_acres." $plural"); //print(number_format($page_acres,2)." $plural"); } } print(" "); if ("$Row[sqft]") {print "";} //if ($newonmarket) print " Listed $Row[listing_date]"; print (" | ||
\n | ||||
if ($filename){
print ("\$whereclause=\"$whereclause\"; include(\"/sites/default/data/armls/saved/banner.htm\");?>\n");
//print " "; }elseif ($num_rows){ include("saved/banner.htm"); //print " "; } //include navigation section //include("navigation_greeting.asp"); include("navigation_data.asp"); }//end if whereclause }// end if pest user ?> |
include "/sites/relocationusa_tp/header_footer_links.htm"; $armls_in_path=strpos($mypath, "/armls"); $arr = array("homes", "property", "area", "listingtype", "builder", "subdivision", "community", "zip", "armls", "elementary", "junior", "high", "district", "city", "horse"); foreach ($arr as $arg) { $found_script=strpos($mypath, "/$arg/"); if ($found_script === false) {} else $found='true'; } //end for //print "
"; //print " "; include "/sites/relocationusa_tp/footer_phone_number_display.htm"; ?> } //end if not js or thispath ?>