include("/home/cbhprope/public_html/gasper/_inc/admin.inc"); include("/home/cbhprope/public_html/gasper/_inc/team.inc"); include("/home/cbhprope/public_html/gasper/_inc/propmain.inc"); include("/home/cbhprope/public_html/gasper/_inc/propmain-lvar.inc"); include("/home/cbhprope/public_html/gasper/_inc/propertysearch.inc"); include("/home/cbhprope/public_html/gasper/_inc/StringUtil.inc"); include("/home/cbhprope/public_html/gasper/_inc/HtmlUtil.inc"); include("/home/cbhprope/public_html/gasper/_inc/openhouse.inc"); include("/home/cbhprope/public_html/gasper/_inc/dbconnect.inc"); $action = "ourl"; $search = PropertySearch::getInstance($_GET['sid']); include("/home/cbhprope/public_html/gasper/_inc/listings/parsesearch.inc"); include("/home/cbhprope/public_html/gasper/_inc/listings/queryWhereTrend.inc"); include("/home/cbhprope/public_html/gasper/_inc/listings/queryWhereLVAR.inc"); // get the counts for both feeds include("/home/cbhprope/public_html/gasper/_inc/listings/listingsCountTrend.inc"); include("/home/cbhprope/public_html/gasper/_inc/listings/listingsCountLVAR.inc"); // see if we are looking for a particular feed $feed = $_GET['f']; if (!$feed) { $feed = $totalCountTrend > $totalCountLVAR ? "T" : "L"; } if (isset($feed) == false || $feed == "T") { $totalCount = $totalCountTrend; include("/home/cbhprope/public_html/gasper/_inc/listings/listingsQueryTrend.inc"); } else if ($feed == "L") { $totalCount = $totalCountLVAR; include("/home/cbhprope/public_html/gasper/_inc/listings/listingsQueryLVAR.inc"); } // load opens if (isset($props) && count($props) > 0 && false) { foreach ($props as $prop) { if (isset($idLst)) { $idLst .= ","; } $idLst .= "'".$prop->getListNum()."'"; } $now = date("Y-m-d"); $q = "SELECT * FROM AGENT_OPENHOUSE WHERE OH_DATE >= '$now' AND LISTNUM IN ($idLst) ORDER BY OH_DATE ASC"; $ohResult = mysql_query($q); $numOpens = mysql_num_rows($ohResult); for ($i = 0; $i < $numOpens; $i++) { $row = mysql_fetch_array($ohResult); $propId = $row["TREND_ID"]; if (isset($openHouses) && isset($openHouses[$propId])) { // already have an open for this property, continue continue; } $open = OpenHouse::loadInstance($row, false); $openHouses[$open->getListnum()] = $open; } } ?>