query("SET NAMES 'utf8'"); /* Specifies whatever or not there should be a right menu on this page! */ $show_right_menu = false; /* Create the class object in order to manage the site cookie */ $coo = new Cookies_Manager_Class("UserCookie"); /* Start session management! Make at the following global variables available: SESSION_VERIFIED_USER[] (profile_id, username, password, user_level, first_name, middel_name, last_name) SESSION_VERIFIED_ADMIN[] (admin_id, username, password, admin_level, first_name, middel_name, last_name) */ start_page_session(); /* Call this method in order to check for auto login and so if auto_login is set! NOTICE that this method must have a pointer to the cookie as an argument!*/ check_for_autologin($coo); /* Call the method get_language in order to find out what language the page scould be in! NOTICE! that the method take one argument (the pointer og the cookie object)*/ $page_language = get_language($coo); /* Get left/right sitemenu picture url*/ $left_sitemenu_picture_id = get_left_sitemenu_picture_id(); if ($show_right_menu) { $right_sitemenu_picture_id = get_right_sitemenu_picture_id($left_sitemenu_picture_id); } /* Get standard "GET" variables */ $page_id=(isset($_GET['id'])) ? mysql_real_escape_string($_GET['id']) : "index"; $page_mode=(isset($_GET['mode'])) ? mysql_real_escape_string($_GET['mode']) : ""; $page_option=(isset($_GET['op'])) ? mysql_real_escape_string($_GET['op']) : ""; $referer_url=(isset($_GET['rurl'])) ? mysql_real_escape_string($_GET['rurl']) : ""; /**********************************************************************************/ /****************************** Special Initialising ******************************/ /**********************************************************************************/ /**********************************************************************************/ if($page_id == 'ft2013tilmelding') { if (!$name = str_replace("'", "''", @$_POST['name'])) { $name = '';} if (!$adresse = str_replace("'", "''", @$_POST['adresse'])) { $adresse = '';} if (!$email_address = str_replace("'", "''", @$_POST['email_address'])) { $email_address = '';} if (!$dof_medlems_nr = str_replace("'", "''", @$_POST['dof_medlems_nr'])) { $dof_medlems_nr = '';} if (!$mobil_nr = str_replace("'", "''", @$_POST['mobil_nr'])) { $mobil_nr = '';} if (!$ledige_bil_pladser = str_replace("'", "''", @$_POST['ledige_bil_pladser'])) { $ledige_bil_pladser = '';} $felttraef_anden_uge_end_42 = (isset($_POST['felttraef_anden_uge_end_42'])) ? mysql_real_escape_string($_POST['felttraef_anden_uge_end_42']) : ""; $felttraef_optimal_uge = (isset($_POST['felttraef_optimal_uge'])) ? mysql_real_escape_string($_POST['felttraef_optimal_uge']) : ""; $felttraef_ok_uge_38 = (isset($_POST['felttraef_ok_uge_38']) AND $_POST['felttraef_ok_uge_38']==1) ? 1 : 0; $felttraef_ok_uge_39 = (isset($_POST['felttraef_ok_uge_39']) AND $_POST['felttraef_ok_uge_39']==1) ? 1 : 0; $felttraef_ok_uge_40 = (isset($_POST['felttraef_ok_uge_40']) AND $_POST['felttraef_ok_uge_40']==1) ? 1 : 0; $felttraef_ok_uge_41 = (isset($_POST['felttraef_ok_uge_41']) AND $_POST['felttraef_ok_uge_41']==1) ? 1 : 0; $felttraef_ok_uge_42 = (isset($_POST['felttraef_ok_uge_42']) AND $_POST['felttraef_ok_uge_42']==1) ? 1 : 0; $felttraef_ok_uge_43 = (isset($_POST['felttraef_ok_uge_43']) AND $_POST['felttraef_ok_uge_43']==1) ? 1 : 0; $tilmeldings_date = date('Y-m-d H:i:s',time()); $sql_add_deltager = "Insert into tbl_project_ft2013 (name, adresse, email_address, mobil_nr, ledige_bil_pladser, tilmeldings_date, dof_medlems_nr, felttraef_optimal_uge, felttraef_anden_uge_end_42, felttraef_ok_uge_38, felttraef_ok_uge_39, felttraef_ok_uge_40, felttraef_ok_uge_41, felttraef_ok_uge_42, felttraef_ok_uge_43) values('$name', '$adresse', '$email_address', '$mobil_nr', '$ledige_bil_pladser', '$tilmeldings_date', '$dof_medlems_nr', '$felttraef_optimal_uge', '$felttraef_anden_uge_end_42', $felttraef_ok_uge_38, $felttraef_ok_uge_39, $felttraef_ok_uge_40, $felttraef_ok_uge_41, $felttraef_ok_uge_42, $felttraef_ok_uge_43)"; if($name != '') { $db->query($sql_add_deltager); } header("Location: projects.php?id=ft2013&mode=tilmelding_registreret"); exit; } if($page_id == '_sb2005tilmelding') { $error = false; $error_text = ""; if (!$name = str_replace("'", "''", @$_POST['name'])) { $name = ''; $error=true; $error_text .= "Navn skal oplyses"; } if (!$address = str_replace("'", "''", @$_POST['address'])) { $address = 'NULL'; } else { $address = "'" . $address . "'"; } if (!$email_address = str_replace("'", "''", @$_POST['email_address'])) { $email_address = 'NULL'; } else { $email_address = "'" . $email_address . "'"; } if (!$mobil_nr = str_replace("'", "''", @$_POST['mobil_nr'])) { $mobil_nr = 'NULL'; } else { $mobil_nr = "'" . $mobil_nr . "'"; } if (!$forslag = str_replace("'", "''", @$_POST['forslag'])) { $forslag = 'NULL'; } else { $forslag = "'" . $forslag . "'"; } $tilmeldings_date = date('Y-m-d H:i:s',time()); $tilmeldings_auto_id = make_uniqid(); $sql_add_deltager = "Insert into tbl_project_sb2005 (name, address, email_address, mobil_nr, forslag, tilmeldings_date, tilmeldings_auto_id) values('$name', $address, $email_address, $mobil_nr, $forslag, '$tilmeldings_date', '$tilmeldings_auto_id')"; if(!$error) { $db->query($sql_add_deltager); $sql_tilmeldings_id = "Select tilmeldings_id From tbl_project_sb2005 Where tilmeldings_auto_id='" . $tilmeldings_auto_id . "'"; $db->query($sql_tilmeldings_id, "tilmeldings_id"); $tilmeldings_id_row = $db->row("tilmeldings_id"); $tilmeldings_id = $tilmeldings_id_row['tilmeldings_id']; for($i = 1; $i <= 10; $i++) { if ($sb2005_lokalitets_navn = str_replace("'", "''", @$_POST['sb2005_lokalitets_navn_' . $i])) { $region_id = @$_POST['region_id_' . $i]; if (!$sb2005_periode_start_d = str_replace("'", "''", @$_POST['sb2005_periode_start_d_' . $i])) { $sb2005_periode_start_d = 'NULL'; } else { $sb2005_periode_start_d = "'" . $sb2005_periode_start_d . "'"; } if (!$sb2005_periode_start_m = str_replace("'", "''", @$_POST['sb2005_periode_start_m_' . $i])) { $sb2005_periode_start_m = 'NULL'; } else { $sb2005_periode_start_m = "'" . $sb2005_periode_start_m . "'"; } if (!$sb2005_periode_slut_d = str_replace("'", "''", @$_POST['sb2005_periode_slut_d_' . $i])) { $sb2005_periode_slut_d = 'NULL'; } else { $sb2005_periode_slut_d = "'" . $sb2005_periode_slut_d . "'"; } if (!$sb2005_periode_slut_m = str_replace("'", "''", @$_POST['sb2005_periode_slut_m_' . $i])) { $sb2005_periode_slut_m = 'NULL'; } else { $sb2005_periode_slut_m = "'" . $sb2005_periode_slut_m . "'"; } $sql_add_lokalitet = "Insert into tbl_project_sb2005_lokaliteter (tilmeldings_id, sb2005_lokalitets_navn, region_id, sb2005_periode_start_d, sb2005_periode_slut_d, sb2005_periode_start_m, sb2005_periode_slut_m) values($tilmeldings_id, '$sb2005_lokalitets_navn', $region_id, $sb2005_periode_start_d, $sb2005_periode_slut_d, $sb2005_periode_start_m, $sb2005_periode_slut_m)"; $db->query($sql_add_lokalitet); } } } if(!$error) { header("Location: projects.php?id=sb2005&mode=tilmelding_registreret"); exit; } else { header("Location: projects.php?id=sb2005&mode=tilmelding_fejl"); exit; } } /**********************************************************************************/ /************************************ Functions ***********************************/ /**********************************************************************************/ /**********************************************************************************/ /*********************************** Page Start ***********************************/ /**********************************************************************************/ ?>
|
"; include("./include/menu_items_tracker.php"); echo " "; ?> |
"; gui_backbutton(); ?> |