'; echo "\r\n"; echo''; echo "\r\n"; session_start(); include_once("includes/config.php"); include_once("includes/lib_common.php"); include_once("class/rss_class.php"); include_once("class/lib_class.php"); include_once("class/db_class.php"); include_once("class/paper_class.php"); //include_once("includes/detect.php"); $mysqli = new mysqli($hostname, $username, $password, $database); if (isset($_GET['list'])) $list = $_GET["list"]; else $list = ''; if (isset($_GET["page"])) $page = $_GET["page"]; else $page = ''; if (isset($_GET["load"])) $load = $_GET["load"]; else $load = ''; $specialtyID = $_GET["specialtyID"]; $page = $_GET["page"]; $load = $_GET["load"]; $startpost = "47"; $per_page =5000;//define how links per page ?> https:/// daily 1.0 $item) { ?> https:// daily 0.9 $item) { ?> https://_new_homes.html daily 0.8 =4; --$i) { //5 city, 4 county pages //$strCity = "SELECT tblregionsmap.assignedRegion, tblregions.regionId, tblregions.`name`, tblregions.active, tblregions.regionType FROM tblregionsmap Inner Join tblregions ON tblregionsmap.assignedRegion = tblregions.regionId WHERE tblregionsmap.regionId = '".$stateID."' AND tblregions.regionType = 5 AND tblregions.active = 1 ORDER BY tblregions.`name` ASC "; $strCity = "SELECT a1.name, c1.name as state from tblregions a1 INNER JOIN tblregionsmap b1 ON a1.regionId = b1.assignedRegion INNER JOIN tblregions c1 ON c1.regionId = b1.regionId WHERE c1.regionType = 3 AND a1.regionType = $i and a1.active = 1 ORDER by name; "; //echo $strCity; $oRsCity = $mysqli->query($strCity); //$oRsCity = mysql_query($strCity, $objDB->oConn); //while($rowCity=mysql_fetch_array($oRsCity)) while($rowCity=mysqli_fetch_array($oRsCity)) { $stateLink = preg_replace(array("/ /","/'/"),array("_","_"),strtolower($rowCity["state"])); $ctname = preg_replace(array("/ /","/'/"),array("_","_"),strtolower($rowCity["name"])); //echo "".$rowCity["name"]."
\r\n"; //$ctname = str_replace(" ","_",strtolower($rowCity["name"])); //echo $domain."newhomes.html?state=".$value."&city=".$ctname."
"; ?> https://_new_homes.html weekly 0.8 https:/// daily 0.8 query($sql); while($string=$oRs->fetch_array()) { ?> https://www.newhomesagents.com daily 0.8 0) { $start = ($page - 1) * $per_page; $sql = "SELECT DISTINCT CONCAT('/', REPLACE(LOWER(d1.name),' ','_'), '/',REPLACE(LOWER(d1.name),' ','_'),'_',REPLACE(LOWER(b1.name),' ','_'),'/home',h1.homeId,'.html') as link FROM tblhomes h1 INNER JOIN tblregionsmap a1 ON a1.assignedRegion = h1.regionId INNER JOIN tblregions b1 ON b1.regionId = a1.regionId INNER JOIN tblregionsmap c1 ON a1.assignedRegion = c1.assignedRegion INNER JOIN tblregions d1 ON d1.regionId = c1.regionId WHERE h1.active = 1 AND a1.regionId > 52 AND c1.regionId < 53 LIMIT $start,$per_page "; //ex: https://www.newhomesagents.com/alabama/alabama_stockton/home20786.html $oRs = $mysqli->query($sql); while($string=$oRs->fetch_array()){?> https://www.newhomesagents.com daily 0.7 0) { $start = ($page - 1) * $per_page; if ($page == 1) { $sql = "SELECT CONCAT('/realestateagents.html?state=',URLSTATE) as link FROM states_url"; //ex: https://www.newhomesagents.com/realestateagents.html?state=district-of-columbia $oRs = $mysqli->query($sql); while($string=$oRs->fetch_array()){?> https://www.newhomesagents.com daily 0.7 query($sql); while($string=$oRs->fetch_array()){?> https://www.newhomesagents.com daily 0.7 0) { /* for ($i=1; $i<35; ++$i) { echo "Sitemap: https://www.newhomesagents.com/sitemap.php?list=agents&page=".$i."
"; } */ $start = ($page - 1) * $per_page; $sql = "SELECT DISTINCT CONCAT('/realestateagents.html?state=',b1.URLSTATE,'&city=',REPLACE(LOWER(a1.City),' ','-'),'&ID=',a1.ID) as link FROM f_brokers a1 LEFT JOIN states_url b1 ON b1.STCODE = a1.State ORDER BY a1.ID LIMIT $start,$per_page "; //ex: https://www.newhomesagents.com/realestateagents.html?state=tennessee&city=sevierville&ID=1 $oRs = $mysqli->query($sql); while($string=$oRs->fetch_array()){?> https://www.newhomesagents.com daily 0.7 0) { $start = ($page - 1) * $per_page; if ($page == 1) { $sql = "SELECT CONCAT('/mortgage.html?state=',URLSTATE) as link FROM states_url"; //ex: https://www.newhomesagents.com/realestateagents.html?state=district-of-columbia $oRs = $mysqli->query($sql); while($string=$oRs->fetch_array()){?> https://www.newhomesagents.com daily 0.7 query($sql); while($string=$oRs->fetch_array()){?> https://www.newhomesagents.com daily 0.7 0) { /* for ($i=1; $i<35; ++$i) { echo "Sitemap: https://www.newhomesagents.com/sitemap.php?list=agents&page=".$i."
"; } */ $start = ($page - 1) * $per_page; $sql = "SELECT DISTINCT CONCAT('/mortgage.html?state=',b1.URLSTATE,'&city=',REPLACE(LOWER(a1.post_city),' ','-'),'&ID=',a1.ID) as link FROM mortgagebrokers a1 LEFT JOIN states_url b1 ON b1.STCODE = a1.post_state WHERE a1.post_city IS NOT NULL LIMIT $start,$per_page "; //ex: https://www.newhomesagents.com/mortgage.html?state=alabama&city=birmingham&ID=7980 $oRs = $mysqli->query($sql); while($string=$oRs->fetch_array()){?> https://www.newhomesagents.com daily 0.7 0) { $start = ($page - 1) * $per_page; if ($page == 1) { $sql = "SELECT CONCAT('/',REPLACE(URLSTATE,'-','_'),'_communities.html') as link FROM states_url"; //ex: https://www.newhomesagents.com/district_of_columbia_communities.html $oRs = $mysqli->query($sql); while($string=$oRs->fetch_array()){?> https://www.newhomesagents.com daily 0.7 query($sql); while($string=$oRs->fetch_array()){?> https://www.newhomesagents.com daily 0.7