require '../../../system/config.php'; // nastaveni systemovych promennych pro admin sekci require '../../../system/db_connect.php'; // pripojeni k databazi require '../../../system/sessions.php'; // nastartovani session require '../../../system/functions.php'; // nacteni nadefinovanych funkci require '../../../system/functions_output.php'; // nacteni nadefinovanych funkci pro vystup require '../../../system/var_check.php'; // oslashovani promennych v $_POST a $_GET /* VYKONNA CAST SKRIPTU */ $lang = load_lng_terms($_SESSION['lng']); $title = $lang['nove_zarazene'] . ' | ' . $lang['cestovni_agentura']; $out_body .= show_last_inserted(); function show_last_inserted() { global $conf_basedir, $conf_page_listing, $lang; $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_hidden = 0 ORDER BY ob.obj_inserted DESC "; $result = MSQ_utf( $sql ); $to_page = $conf_page_listing; $page = $_GET['page'] ? $_GET['page'] : ($page ? $page : 1); $total = mysql_num_rows($result); $max = (int) ceil($total / $to_page); mysql_data_seek($result, ($page - 1) * $to_page); $i = 1; while ( $i <= $to_page && $row = mysql_fetch_assoc($result) ) { $out .= object_preview( $row, 'apartment' ); $i++; } return '