<?php
//echo "<pre>";
//print_r($_REQUEST);
//print_r($_SERVER);
//session_start();
//echo "</pre>";
include_once "config.php";
include_once "lib/common.lib.php";
require_once "lib/main.php";
require_once "lib/dbmysql.class.php";
require_once 'lib/awt_tpl.class.php';

$template_file = 'main-rss.tpl.html';
$error_message = '';
$content_type = '';
$where_house="";
$default_category = 'commercial-property-for-rent';
$category = array();
$not_found = 0;
    
$tpl = new AwtTpl();
$db2 = new DbMySQL(DB_HOST2, DB_PORT2, DB_NAME2, DB_USER2, DB_PWD2);
$db2->connect();

$sql = "SELECT ID,status_type,`type`,`status`,address,city,state,zip,last_update,created_date,source
        FROM houses h
        WHERE h.created_date > CURRENT_TIMESTAMP - interval '1' day
        AND h.true_state is not null
        AND true_state!=''
        ORDER BY last_update DESC
        LIMIT 100";
$houses = $db2->select($sql);

if(!$houses){
	$sql = "SELECT ID,status_type,`type`,`status`,address,city,state,zip,last_update,created_date,source
	        FROM houses h
	        WHERE DATE(h.created_date)=DATE(h.last_update)
	        AND h.true_state is not null
	        AND true_state!=''
	        ORDER BY last_update DESC
	        LIMIT 100";
	$houses = $db2->select($sql);
}

$tpl->assign("houses",    $houses);
$tpl->display($template_file);
?>