All rooms are set apart from the main house with their own entrances. Each room has its own shower or bathroom, bar fridge, tea trays, TV with M-NET and heater..
getCfg( 'shownoauth' );
$now = date( 'Y-m-d H:i:s', time()+$mosConfig_offset*60*60 );
$nullDate = $database->getNullDate();
$limit = ' limit 5';
$query = "SELECT a.id"
."\n FROM #__content AS a"
."\n INNER JOIN #__categories AS b ON b.id = a.catid"
."\n WHERE a.state = 1"
. ( $noauth ? "\n AND a.access <= $my->gid AND b.access <= $my->gid" : '' )
."\n AND (a.publish_up = '$nullDate' OR a.publish_up <= '$now' ) "
."\n AND (a.publish_down = '$nullDate' OR a.publish_down >= '$now' )"
."\n AND catid = 626"
."\n ORDER BY a.ordering"
."\n $limit"
;
$database->setQuery( $query );
$rows = $database->loadResultArray();
$numrows = count( $rows );
?>
All rooms are set apart from the main house with their own entrances. Each room has its own shower or bathroom, bar fridge, tea trays, TV with M-NET and heater..
