' . $lang['top_destinace'] . ''; $out_body .= '

'; $out_body .= show_top_destination(); function show_top_destination() { global $conf_basedir; $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 , 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']} LEFT JOIN c_gallery_bind `gb` ON gb.bind_id = rs.resort_id AND gb.bind_order = 1 AND gb.bind_type = 2 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']} , c_object `ob` WHERE st.state_id = rg.state_id AND rg.region_id = rs.region_id AND rs.resort_id = ob.resort_id AND rs.resort_top = 1 AND ob.obj_hidden = 0 ORDER BY stl.state_name , rgl.region_name , rsl.resort_name "; $result = MSQ_utf( $sql ); while ( $row = mysql_fetch_assoc($result) ) { $link = $conf_basedir . '/klient/scripts/main/pozadavek.php?s_resort=' . $row['resort_id']; $image = $row['p_id'] ? a_link( sprintf('

' , $conf_basedir , $row['p_id'] , $row['p_x_small'] , $row['p_y_small'] , trim( $row['alt'] ) ? ' alt="' . trim( $row['alt'] ) . '"' : '' ) , $link , trim( $row['resort_name'] ) ? trim( $row['resort_name'] ) : false , 'picture' ) : ''; $out .= sprintf('

', preg_match('/state|region/', $objType) ? ' noimage' : !$image ? ' paddednoimage' : '' ); $out .= $image; $out .= '

' . a_link($row['resort_name'], $link) . '

'; $out .= '' . a_link($row['state_name'], $conf_basedir . '/klient/scripts/main/pozadavek.php?s_state=' . $row['state_id']) . ' > ' . a_link($row['region_name'], $conf_basedir . '/klient/scripts/main/pozadavek.php?s_region=' . $row['region_id']) . ''; $out .= '

'; $out .= '

' . $row['resort_desc'] . '

'; $out .= ''; $out .= "

\n"; } 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 ?>