//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
"; $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); //$redirected_url=str_replace("%20", " ", $redirected_url); //print "$redirected_url
"; header("Location: $redirected_url"); } include ("/sites/relocationusa_tp/register_globals.htm"); $theirip=$_SERVER['REMOTE_ADDR']; include "header_variables.htm"; include "/sites/relocationusa_tp/spam_lead_checks.htm"; $thisbrokerage='DallasRelo'; $myphone='(469)909-0255'; $site_name=('dallasrealestate-homes.com'); $mydir='ntreis'; $company='DallasRelo'; $partner='unassigned'; $lastrecip='lastrecip_phx'; $recip_page='recip_page_phx'; $entry_date='entry_date_phx'; //$table='partners'; //print ("--$whichsection--"); $key=date("F j, Y"); //$key=date('l jS \of F Y \h\i\h\o'); $thispath=$_SERVER["REQUEST_URI"]; //print "$thispath"; //$thispath=str_replace("%20", " ", $thispath); $htmcount=substr_count($thispath, ".htm"); $TXcount=substr_count($thispath, "%20TX%20"); //corrects for improperly created urls that don't find similar homes $homescount=substr_count($thispath, "/homes/"); $spacecount=substr_count($thispath, "%20"); //print "
$spacecount"; if ($spacecount>=5 and $htmcount and $homescount and !$TXcount) { //print "Homes Page"; $homespage='yes'; //set header ok after www. url redirect if ($www_count==1){ //header("HTTP/1.1 200 OK"); } } if (!substr_count($thispath, "/blog/") and !substr_count($thispath, "enter_commitment.htm") and !substr_count($thispath, ".js") and !substr_count($thispath, "getimages")) { //load rest of header file //print_r($_COOKIE); //$mypath=($SCRIPT_NAME); //$mypath=$thispath; $mypath=str_replace("%20", " ", $thispath); $today=date("Y-m-d H:i:s"); //print "$today"; //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/ntreis/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_county/")) {$modifier=("Horse ");} if (substr_count($mypath, "/horse_city/")) {$modifier=("Horse ");} if (substr_count($mypath, "/county/")) {$ender=(" County");} 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/")) { if ($show[0]=='3'){ $show=substr($show, 5, 100); }elseif ($show[0]=='1' or $show[0]=='9'){ $show=substr($show, 8, 100); } } if (substr_count($mypath, "/property/")) $show=substr($show, 7, 100); 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, "/county.htm")) {$between=('by');} if (substr_count($mypath, "/high.htm")) {$show=('High School'); $between=('by'); $list="yes";} if (substr_count($mypath, "/middle.htm")) {$show=('Middle School '); $between=('by'); $list="yes";} if (substr_count($mypath, "/elementary.htm")) {$show=('Elementary School '); $between=('by'); $list="yes";} if (substr_count($mypath, "/district.htm")) {$show='School District'; $between=('by'); $list="yes";} if (substr_count($mypath, "/primary.htm")) {$ender=' School'; $between=('by'); $list="yes";} if (substr_count($mypath, "/intermediate.htm")) {$ender=' School'; $between=('by'); $list="yes";} if (substr_count($mypath, "/senior.htm")) {$ender=' School'; $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 Texas")) {$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_city.htm")) {$between=('by'); $ender=(' Property');} //if (substr_count($mypath, "/horse_county.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');} if (substr_count($mypath, "/land")) {$firstpart=('Vacant Land');} if (substr_count($mypath, "/acres/")) {$firstpart=('Homes with Land');} if (substr_count($mypath, "/income")) {$firstpart=('Income Property');} if (substr_count($mypath, "/commercial")) {$firstpart=('Commercial Property');} //print ("|$mypath|
");
//$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='Dallas';
//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");
//print ("$mypath");
?>
HI THERE
"; ?> if (!substr_count($thispath, "/homes/")){ ?> /* */?> /* */?> /* */?> } //end if if ($mypath=='/' or substr_count($mypath, "index.htm")) {?> }elseif (substr_count($mypath, "Builder/") or substr_count($mypath, "Subdivisions/") or substr_count($mypath, "sasearch.asp") or substr_count($mypath, "getdata.asp") or substr_count($mypath, "paged_re_listings.asp")) {?> /* */?> /* */?> }else{?> } ?> $day_of_month=date("j"); //print "$day_of_month"; ?> // necessary for slideshow?> /* //moved to top of paged_re_listings */?> /*
" class="smalllink">Home Page | http://www.dallasrealestate-homes.com/data/ntreis/sasearch.asp" class="smalllink">Property Search | Site Map |
*/ include "/sites/relocationusa_tp/header_footer_links.htm"; ?> //} //end if } //end if load rest of file if not .js ?> /* */?>
//print ($mlsno); //print "$host"; //SET UP TABLE QUERY FOR MATCHING RECORDS $host="localhost"; $user="getdata"; $password="getdata"; $dbname="ntreis"; $tablename="ntreis_homes"; $link=mysqli_connect ($host, $user, $password, $dbname); //$query="select officename, mlsno, listingpicture, listingpicturewebsite, street_suffix, zip, state, mun, price, nsew, addrnum, addrname from $tablename where mlsno=$mlsno"; //$query="select * from $tablename where mlsno=$mlsno"; $query="select * from ntreis_homes left join ntreis_images on (ntreis_homes.matrix_unique_id=ntreis_images.mls_no and ntreis_images.photonum='1') where ntreis_homes.mlsno='$mlsno'"; //$query="select * from ntreis_homes_similar left join ntreis_images on (ntreis_homes_similar.mlsno=ntreis_images.mls_no and ntreis_images.photonum='1') where ntreis_homes_similar.mlsno='$mlsno'"; //print "$query"; $result= mysqli_query ($link, $query); $num_rows = mysqli_num_rows($result); //print $num_rows; if ($num_rows) { $active_listing='yes'; //print "$active_listing"; while ($Row=mysqli_fetch_array ($result)) { } // close while loop }else{ //print("
include "agents_property_request.htm"; ?> //include("/sites/default/data/getfooter.php")?> //if ($mypath!="/index.htm"){ ?> /*
*/ if (!substr_count($thispath, "/blog/") and !substr_count($thispath, "enter_commitment.htm") and !substr_count($thispath, ".js") and !substr_count($thispath, "getimages")) { //load rest of header file ?>/*
" class="smalllink">Home Page | http://www.dallasrealestate-homes.com/data/ntreis/sasearch.asp" class="smalllink">Property Search | Site Map |
"; } //else{ //if ($mypath!='/index.htm'){ //include "/sites/relocationusa_tp/armls/blogs.php"; //} //print ("