';
return $out;
}
function show_text_info() {
$result = MSQ_utf("
SELECT
c_content, c_header, c_header_show
FROM
c_content `c`
LEFT JOIN c_content_lng `l` ON `c`.c_id = `l`.c_id AND lng_id = {$_SESSION['lng']}
WHERE
c_descr = 'underbanner_text'
ORDER BY
c_order
");
while ( $row = mysql_fetch_assoc( $result ) ) {
$content = str_replace(array(' a ', ' v ', ' s ', ' u ', ' o '), array(' a ', ' v ', ' s ', ' u ', ' o '), $row['c_content'])."
\n";
$out .= content_box(
'big'
, ( $row['c_header_show'] ? $row['c_header'] : '' )
, $content
, $link
, false
);
}
return $out;
}
function show_premium_objects() {
global $conf_basedir, $lang, $conf_page_listing;
$sql = "
SELECT DISTINCT
stl.state_id, stl.state_name
, rgl.region_id, rgl.region_name, rgl.region_desc
, rsl.resort_id, rsl.resort_name, rsl.resort_desc
, ob.obj_id, ob.obj_type
, obl.obj_name, obl.obj_desc
, g.p_id, g.p_x_small, g.p_y_small
, gl.p_alt
FROM
c_state `st`
LEFT JOIN c_state_lng `stl` ON stl.state_id = st.state_id AND stl.lng_id = {$_SESSION['lng']}
, c_region `rg`
LEFT JOIN c_region_lng `rgl` ON rgl.region_id = rg.region_id AND rgl.lng_id = {$_SESSION['lng']}
, c_resort `rs`
LEFT JOIN c_resort_lng `rsl` ON rsl.resort_id = rs.resort_id AND rsl.lng_id = {$_SESSION['lng']}
, c_object `ob`
LEFT JOIN c_object_lng `obl` ON obl.obj_id = `ob`.obj_id AND obl.lng_id = {$_SESSION['lng']}
LEFT JOIN c_gallery_bind `gb` ON gb.bind_type = 3 AND gb.bind_order = 1 AND gb.bind_id = ob.obj_id
LEFT JOIN c_gallery `g` ON g.p_id = gb.p_id
LEFT JOIN c_gallery_lng `gl` ON gl.p_id = g.p_id AND gl.p_lng = {$_SESSION['lng']}
WHERE
st.state_id = rg.state_id
AND rg.region_id = rs.region_id
AND rs.resort_id = ob.resort_id
AND ob.obj_front_page = 1
AND ob.obj_hidden = 0
ORDER BY
RAND()
LIMIT " . (int) $conf_page_listing;
$result = MSQ_utf( $sql );
while ( $row = mysql_fetch_assoc($result) ) {
$out .= object_preview( $row, 'apartment' );
}
return $out;
}
/* ZOBRAZOVACI CAST SKRIPTU */
require '../../../system/page_start.php'; // hlavicka stranky
require '../../../system/page_body.php'; // telo stranky
require '../../../system/page_end.php'; // paticka stranky vcetne uzavreni spojeni s databazi
?>
';
}
$out .= '