<?php 
# exe.php

/* included files: */
require_once("include/site_constants.php");
require_once("include/standard_functions.php");
require_once("include/db_mysql.php");
require_once("include/PHPMailer/PHPMailerAutoload.php");

/**********************************************************************************/
/********************************** Initialising **********************************/
/**********************************************************************************/

/* Create database object */
$db = new DB_Spencer_Class(array(PRIMARY_DB_HOST, PRIMARY_DB_USER, PRIMARY_DB_PASSWORD, PRIMARY_DB_DATABASE, 0, 0));
$db->query("SET NAMES 'utf8'");

/* 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);


/**********************************************************************************/
/****************************** Special Initialising ******************************/
/**********************************************************************************/

if (!$page_id = @$_POST['id']) {
	if (!$page_id = @$_GET['id']) {
		header("Location: info.php?id=text&code=error");
		exit;
	}
}

if (!$page_mode = @$_POST['mode']) {
	if (!$page_mode = @$_GET['mode']) {
		$page_mode = '';
	}
}

if (!$page_option = @$_POST['op']) {
	if (!$page_option = @$_GET['op']) {
		$page_option = ''; 
	}
}

if (!$referer_url = @$_POST['rurl']) {
	if (!$referer_url = @$_GET['rurl']) {
		$referer_url = '';
	}
}


/**********************************************************************************/
/*********************************** Page Start ***********************************/
/**********************************************************************************/

switch ($page_id) {
/******************************************************************************************/
/********************************** UPDATE USER PROFILE ***********************************/
/******************************************************************************************/
	case 'updateuser':
		include("./include/exe/exe_user_update_profile.php");
		break;

/******************************************************************************************/
/************************************ UPDATE PASSWORD *************************************/
/******************************************************************************************/
	case 'changepassword':
		include("./include/exe/exe_user_update_password.php");
		break;

/******************************************************************************************/
/************************************ E-MAIL SETTINGS *************************************/
/******************************************************************************************/
	case 'updateemail':
		include("./include/exe/exe_user_update_email.php");
		break;

/******************************************************************************************/
/************************************* DK TICK INFO ***************************************/
/******************************************************************************************/
	case 'updatedktickinfo':
		include("./include/exe/exe_user_update_dk_tick_info.php");
		break;

/******************************************************************************************/
/**************************************** DK TICK *****************************************/
/******************************************************************************************/
	case 'updatedktick':
		include("./include/exe/exe_user_update_dk_tick.php");
		break;

/******************************************************************************************/
/************************************* WP TICK INFO ***************************************/
/******************************************************************************************/
	case 'updatewptickinfo':
		include("./include/exe/exe_user_update_wp_tick_info.php");
		break;

/******************************************************************************************/
/**************************************** WP TICK *****************************************/
/******************************************************************************************/
	case 'updatewptick':
		include("./include/exe/exe_user_update_wp_tick.php");
		break;

/******************************************************************************************/
/************************************* FALSE WP TICK **************************************/
/******************************************************************************************/
	case 'updatewpfalsetick':
		include("./include/exe/exe_user_update_wp_false_tick.php");
		break;

/******************************************************************************************/
/************************************* SEND ARTICLE ***************************************/
/******************************************************************************************/
	case 'send_article_by_email':
		include("./include/exe/exe_send_article_by_email.php");
		break;


/******************************************************************************************/
/******************************* ADMIN - ADD NEWS ARTICLE *********************************/
/******************************************************************************************/
	case 'admin_add_news_article':
		include("./include/exe/exe_admin_add_news_article.php");
		break;


/******************************************************************************************/
/***************************** ADMIN - UPDATE NEWS ARTICLE ********************************/
/******************************************************************************************/
	case 'admin_update_news_article':
		include("./include/exe/exe_admin_update_news_article.php");
		break;

/******************************************************************************************/
/***************************** ADMIN - DELETE NEWS ARTICLE ********************************/
/******************************************************************************************/
	case 'admin_delete_news_article':
		include("./include/exe/exe_admin_delete_news_article.php");
		break;




/******************************************************************************************/
/***************************** ADMIN - ADD WP OBSERVATION *********************************/
/******************************************************************************************/
	case 'admin_add_wp_obs':
		include("./include/exe/exe_admin_wp_obs_add.php");
		break;

/******************************************************************************************/
/***************************** ADMIN - DELETE WP OBSERVATION ********************************/
/******************************************************************************************/
	case 'admin_delete_wp_obs':
		include("./include/exe/exe_admin_wp_obs_delete.php");
		break;


/******************************************************************************************/
/***************************** ADMIN - UPDATE WP OBSERVATION ********************************/
/******************************************************************************************/
	case 'admin_update_wp_obs':
		include("./include/exe/exe_admin_wp_obs_update.php");
		break;



/******************************************************************************************/
/***************************** ADMIN - ADD Faroese OBSERVATION *********************************/
/******************************************************************************************/
	case 'admin_add_faroese_obs':
		include("./include/exe/exe_admin_faroese_obs_add.php");
		break;

/******************************************************************************************/
/***************************** ADMIN - DELETE Faroese OBSERVATION ********************************/
/******************************************************************************************/
	case 'admin_delete_faroese_obs':
		include("./include/exe/exe_admin_faroese_obs_delete.php");
		break;


/******************************************************************************************/
/***************************** ADMIN - UPDATE Faroese OBSERVATION ********************************/
/******************************************************************************************/
	case 'admin_update_faroese_obs':
		include("./include/exe/exe_admin_faroese_obs_update.php");
		break;



/******************************************************************************************/
/***************************** ADMIN - ADD DK OBSERVATION *********************************/
/******************************************************************************************/
	case 'admin_add_dk_obs':
		include("./include/exe/exe_admin_dk_obs_add.php");
		break;

/******************************************************************************************/
/***************************** ADMIN - DELETE DK OBSERVATION ********************************/
/******************************************************************************************/
	case 'admin_delete_dk_obs':
		include("./include/exe/exe_admin_dk_obs_delete.php");
		break;


/******************************************************************************************/
/***************************** ADMIN - UPDATE DK OBSERVATION ********************************/
/******************************************************************************************/
	case 'admin_update_dk_obs':
		include("./include/exe/exe_admin_dk_obs_update.php");
		break;


/*******************************************************************************************/
/*****************************       USER - TIP13 2008      ********************************/
/*******************************************************************************************/

	case 'user_tip13_2008_update_species':
		include("./include/exe/exe_user_tip13_2008_update_species.php");
		break;

/*******************************************************************************************/
/*****************************       USER - TIP13 2007      ********************************/
/*******************************************************************************************/

	case 'user_tip13_2007_update_species':
	//	include("./include/exe/exe_user_tip13_2007_update_species.php");
		break;


/*******************************************************************************************/
/*****************************       USER - TIP13 2009      ********************************/
/*******************************************************************************************/

	case 'user_tip13_2009_update_species':
		include("./include/exe/exe_user_tip13_2009_update_species.php");
		break;




/******************************************************************************************/
/***************************** USER - TIP13 ********************************/
/******************************************************************************************/
	case 'user_tip13_2005_update_species':
	//	include("./include/exe/exe_user_tip13_2005_update_species.php");
		break;

/******************************************************************************************/
/***************************** USER - TIP13 ********************************/
/******************************************************************************************/
	case 'updatetip13kupon':
		include("./include/exe/exe_user_tip13_update_kupon.php");
		break;


/******************************************************************************************/
/***************************** USER - TIP13 ********************************/
/******************************************************************************************/
	case 'updatetip13kupon2004':
		include("./include/exe/exe_user_tip13_2004_update_kupon.php");
		break;


/******************************************************************************************/
/******************************* ADMIN - ADD DK RECORD ************************************/
/******************************************************************************************/
	case 'admin_dk_list_add_record':
		include("./include/exe/exe_admin_dk_list_add_record.php");
		break;

/******************************************************************************************/
/******************************* ADMIN - UPDATE DK RECORD ************************************/
/******************************************************************************************/
	case 'admin_dk_list_update_record':
		include("./include/exe/exe_admin_dk_list_update_record.php");
		break;

/******************************************************************************************/
/******************************* ADMIN - UPDATE DK RECORD ************************************/
/******************************************************************************************/
	case 'admin_dk_list_delete_record_confirmed':
		include("./include/exe/exe_admin_dk_list_delete_record_confirmed.php");
		break;













/******************************************************************************************/
/************************** ADMIN - BIRD SPECIES - ADD NEW ********************************/
/******************************************************************************************/
	case 'admin_bird_species_add':
		include("./include/exe/exe_admin_bird_species_add.php");
		break;


	case 'exe_frontend_photo_update':
		include("./include/exe/exe_admin_frontend_photo_update.php");
		break;





/******************************************************************************************/
/************************************* SEND PASSWORD **************************************/
/******************************************************************************************/
	case 'sendpassword':
		$login_info_send_based_on_username = false;
		$login_info_send_based_on_email = false;
		/************************** GET PARAMS **************************/

			$emailaddress_post=(isset($_POST['emailaddress'])) ? mysql_real_escape_string($_POST['emailaddress']) : "";
			$username_post=(isset($_POST['username'])) ? mysql_real_escape_string($_POST['username']) : "";

		/******************** CHECK USERNAME AND E-MAIL ADDRESS ********************/
			if($emailaddress_post == '' AND $username_post == '') {
				header("Location: info.php?id=text&code=error");
				exit;
			}

		/************************** GET LOGIN INFO BASED ON USERNAME **************************/
			if($username_post != '') {
				$sql_get_login_info_based_on_username = "Select first_name, middel_name, last_name, username, password, email_address From tbl_profiles Where username='" . $username_post . "' Limit 1";

				$db->query($sql_get_login_info_based_on_username, "get_login_info_based_on_username");
			
				if($db->db_num_rows("get_login_info_based_on_username") == 1) {
					$array_user_info = $db->row("get_login_info_based_on_username");

					$username = $array_user_info["username"];
					$password = $array_user_info["password"];
					$firstname = $array_user_info["first_name"];
					$middlename = $array_user_info["middel_name"];
					$lastname = $array_user_info["last_name"];
					$emailaddress = $array_user_info["email_address"];

					/************************** SEND E-MAIL TO NEW USER **************************/
						
						$mail_subject = ($page_language == 'dk') ? "Netfugl.dk - Logind informationer!" : "Netfugl.dk - Login information!";

						$mail_message_text = ($page_language == 'dk') ? "Dine logind informationer er følgende:\r\n\r\n" : "Your login information are as follow:\r\n\r\n";
						$mail_message_text .= ($page_language == 'dk') ? "Brugernavn: " : "Username: ";
						$mail_message_text .= $username . "\r\n";
						$mail_message_text .= "Password: ";
						$mail_message_text .= $password . "\r\n\r\n";
						$mail_message_text .= ($page_language == 'dk') ? "Med venlig hilsen . . . Holdet bag Netfugl.dk" : "Cheers... the Netfugl.dk team";

		
		/********************************* SEND E-MAIL ********************************/
		/******************************************************************************/
			$sendmail_to_address = $emailaddress;
			$sendmail_to_name = "";
			$sendmail_from_address = "netfugl@netfugl.dk";
			$sendmail_from_name = "";
			$sendmail_subject = $mail_subject;
			$sendmail_msg = $mail_message_text . "\n";

			if(sendmail($sendmail_to_address, $sendmail_to_name, $sendmail_from_address, $sendmail_from_name, $sendmail_subject, $sendmail_msg)) {
				//echo "E-mail afsendt!";
			} else {
				//echo "ERROR - Der opstod en fejl ved afsendelse af e-mail!";
			}

		/******************************************************************************/
		/******************************************************************************/



					/******************************************************************************/

					$login_info_send_based_on_username = true;
				} else {
					$login_info_send_based_on_username = false;
				}
			} else {
				$login_info_send_based_on_username = false;
			}


		/************************** GET LOGIN INFO BASED ON E-MAIL **************************/
			if($emailaddress_post != '') {
				$sql_get_login_info_based_on_email = "Select first_name, middel_name, last_name, username, password, email_address From tbl_profiles Where email_address='" . $emailaddress_post . "' Limit 1";

				$db->query($sql_get_login_info_based_on_email, "get_login_info_based_on_email");
			
				if($db->db_num_rows("get_login_info_based_on_email") == 1) {
					$array_user_info = $db->row("get_login_info_based_on_email");

					$username = $array_user_info["username"];
					$password = $array_user_info["password"];
					$firstname = $array_user_info["first_name"];
					$middlename = $array_user_info["middel_name"];
					$lastname = $array_user_info["last_name"];
					$emailaddress = $array_user_info["email_address"];

					/************************** SEND E-MAIL TO NEW USER **************************/
						

						$mail_subject = ($page_language == 'dk') ? "Netfugl.dk - Logind informationer!" : "Netfugl.dk - Login information!";

						$mail_message_text = ($page_language == 'dk') ? "Dine logind informationer er følgende:\r\n\r\n" : "Your login information are as follow:\r\n\r\n";
						$mail_message_text .= ($page_language == 'dk') ? "Brugernavn: " : "Username: ";
						$mail_message_text .= $username . "\r\n";
						$mail_message_text .= "Password: ";
						$mail_message_text .= $password . "\r\n\r\n";
						$mail_message_text .= ($page_language == 'dk') ? "Med venlig hilsen . . . Holdet bag Netfugl.dk" : "Cheers... the Netfugl.dk team";


		/********************************* SEND E-MAIL ********************************/
		/******************************************************************************/
			$sendmail_to_address = $emailaddress;
			$sendmail_to_name = "";
			$sendmail_from_address = "netfugl@netfugl.dk";
			$sendmail_from_name = "";
			$sendmail_subject = $mail_subject;
			$sendmail_msg = $mail_message_text . "\n";

			if(sendmail($sendmail_to_address, $sendmail_to_name, $sendmail_from_address, $sendmail_from_name, $sendmail_subject, $sendmail_msg)) {
				//echo "E-mail afsendt!";
			} else {
				//echo "ERROR - Der opstod en fejl ved afsendelse af e-mail!";
			}

		/******************************************************************************/
		/******************************************************************************/

					/******************************************************************************/

					$login_info_send_based_on_email = true;
				} else {
					$login_info_send_based_on_email = false;
				}
			} else {
				$login_info_send_based_on_email = false;
			}

			if($login_info_send_based_on_username == false AND $login_info_send_based_on_email == false) {
				header("Location: info.php?id=text&code=10");
				exit;
			}

		/************************** OK - REDIRECT **************************/
			header("Location: info.php?id=text&code=9");
			exit;

		break;

/******************************************************************************************/
/**************************************** NEW USER ****************************************/
/******************************************************************************************/
	case 'newuser':
		$error = false;

		/************************** GET PARAMS **************************/
			if(isset($_POST['firstname']) AND $_POST['firstname']!='') {
				$firstname=mysql_real_escape_string($_POST['firstname']);
			} else {
				$firstname="";
				$error = true;
			}

			if(isset($_POST['lastname']) AND $_POST['lastname']!='') {
				$lastname=mysql_real_escape_string($_POST['lastname']);
			} else {
				$lastname="";
				$error = true;
			}

			if (!$country_id = (INT) @$_POST['country_id']) {$error = true;}


			$middlename=(isset($_POST['middlename'])) ? mysql_real_escape_string($_POST['middlename']) : "";
			$address=(isset($_POST['address'])) ? mysql_real_escape_string($_POST['address']) : "";
			$city=(isset($_POST['city'])) ? mysql_real_escape_string($_POST['city']) : "";
			$postcode=(isset($_POST['postcode'])) ? mysql_real_escape_string($_POST['postcode']) : "";
			$home_number=(isset($_POST['home_number'])) ? mysql_real_escape_string($_POST['home_number']) : "";
			$mobil_number=(isset($_POST['mobil_number'])) ? mysql_real_escape_string($_POST['mobil_number']) : "";

			if (!$year_of_birth = (INT) @$_POST['year_of_birth']) {
				$year_of_birth = 'Null';
			} else {
				if($year_of_birth < 1900 OR $year_of_birth > date('Y',time()) OR !is_numeric($year_of_birth)) {
					$year_of_birth = 'Null';
				} else {
					$year_of_birth = "'" . $year_of_birth . "'";
				}
			}

			if (!$sex = @$_POST['sex']) {
				$error = true;
			} else {
				if($sex != 'm' AND $sex != 'f') {$error = true;}
			}

			if(isset($_POST['emailaddress']) AND $_POST['emailaddress']!='') {
				$emailaddress = mysql_real_escape_string($_POST['emailaddress']);
			} else {
				$emailaddress = "";
				$error = true;
			}


			if (!$show_email_address = @$_POST['show_email_address']) {
				$show_email_address = '0';
			} else {
				if($show_email_address != '1') {$show_email_address = '0';}
			}

			if(isset($_POST['username']) AND $_POST['username']!='') {
				$username=mysql_real_escape_string($_POST['username']);
			} else {
				$username="";
				$error = true;
			}

			if(isset($_POST['password1']) AND $_POST['password1']!='') {
				$password1=mysql_real_escape_string($_POST['password1']);
			} else {
				$password1="";
				$error = true;
			}

			if(isset($_POST['password2']) AND $_POST['password2']!='') {
				$password2=mysql_real_escape_string($_POST['password2']);
			} else {
				$password2="";
				$error = true;
			}


			if (strpos($password1, '<')!==false OR strpos($emailaddress, '<')!==false OR strpos($address, '<')!==false OR strpos($firstname, '<')!==false OR strpos($lastname, '<')!==false OR strpos($mobil_number, '<')!==false OR strpos($home_number, '<')!==false OR strpos($middlename, '<')!==false OR strpos($city, '<')!==false OR strpos($postcode, '<')!==false OR strpos($username, '<')!==false) {
				$error = true;
			}


			if (strpos($password1, '>')!==false OR strpos($emailaddress, '>')!==false OR strpos($address, '>')!==false OR strpos($firstname, '>')!==false OR strpos($lastname, '>')!==false OR strpos($mobil_number, '>')!==false OR strpos($home_number, '>')!==false OR strpos($middlename, '>')!==false OR strpos($city, '>')!==false OR strpos($postcode, '>')!==false OR strpos($username, '>')!==false) {
				$error = true;
			}

			if (strpos($password1, '=')!==false OR strpos($emailaddress, '=')!==false OR strpos($address, '=')!==false OR strpos($firstname, '=')!==false OR strpos($lastname, '=')!==false OR strpos($mobil_number, '=')!==false OR strpos($home_number, '=')!==false OR strpos($middlename, '=')!==false OR strpos($city, '=')!==false OR strpos($postcode, '=')!==false OR strpos($username, '=')!==false) {
				$error = true;
			}

			if (strpos($password1, '(')!==false OR strpos($emailaddress, '(')!==false OR strpos($address, '(')!==false OR strpos($firstname, '(')!==false OR strpos($lastname, '(')!==false OR strpos($mobil_number, '(')!==false OR strpos($home_number, '(')!==false OR strpos($middlename, '(')!==false OR strpos($city, '(')!==false OR strpos($postcode, '(')!==false OR strpos($username, '(')!==false) {
				$error = true;
			}

			if(stristr($address,'http://')) {
				$error = true;
			}

			if(stristr($mobil_number,'LG') OR stristr($mobil_number,'Nokia') OR stristr($mobil_number,'HTC') OR stristr($mobil_number,'Sony')) {
				$error = true;
			}

			if($country_id == 137) {
				$error = true;
			}

			if($firstname == $lastname) {
				$error = true;
			}

		/************************** CHECK PASSWORD **************************/
			if($error OR ($password1 != $password2)) {
				/*En fejl opstod da ikke alle oplysninger er til stede!*/
				header("Location: http://www.netfugl.dk");
				exit;
			}

		/************************** CHECK USERNAME **************************/
			$sql_check_username = "Select new_user_id From tbl_new_users Where username='" . $username . "'";
			$db->query($sql_check_username, "check_username");

			if($db->db_num_rows("check_username") > 0) {
				/* Det angivede brugernavn er allerede benyttet */
				header("Location: info.php?id=text&code=2");
				exit;
			}			

		/************************** ADD NEW USER **************************/
			/*Making the SQL statement and save it in the string : strSQL */

			$new_user_added_date = date('Y-m-d H:i:s',time());

			$sql_add_new_user = "Insert into tbl_new_users (username, password, first_name, middle_name, last_name, address, city, postcode, country_id, year_of_birth, sex, mobil_number, home_number, email_address, show_email_address, added_on_date, is_a_member) ";
			
			$sql_add_new_user .= "values('$username', '$password1', '$firstname', '$middlename', '$lastname', '$address', '$city', '$postcode', '$country_id', $year_of_birth, '$sex', '$mobil_number', '$home_number', '$emailaddress', $show_email_address, '$new_user_added_date', 0)";

			$db->query($sql_add_new_user, "add_new_user");

		/************************** SEND E-MAIL TO NEW USER **************************/
		

			$mail_subject = "Link til aktivering af Netfugl.dk brugeroprettelse!";

			$mail_message_text = "For at aktivere din brugeroprettelse hos Netfugl.dk skal du trykke på nedenstående link:\n\n";
			
			$mail_message_text .= "http://www.netfugl.dk/exe.php?id=activate&username=" . $username . "\n\n";

			$mail_message_text .= "Bemærk, ved at aktivere ovenstående link og dermed brugerprofilen accepteres de retningslinier, der er nævnt i tilmeldingsproceduren.\n\n";
			
			$mail_message_text .= "Såfremt ovenstående link ikke fremstår som et link, kopiere da linket og aktiver det manuelt i en browser. Skulle der opstår problemer kan Netfugl.dk kontaktes på e-mail: netfugl@netfugl.dk\n\n";

			$mail_message_text .= "Med venlig hilsen... Netfugl.dk";
			
		/********************************* SEND E-MAIL ********************************/
		/******************************************************************************/
			$sendmail_to_address = $emailaddress;
			$sendmail_to_name = "";
			$sendmail_from_address = "netfugl@netfugl.dk";
			$sendmail_from_name = "";
			$sendmail_subject = $mail_subject;
			$sendmail_msg = $mail_message_text . "\n";


			if(sendmail($sendmail_to_address, $sendmail_to_name, $sendmail_from_address, $sendmail_from_name, $sendmail_subject, $sendmail_msg)) {
				//echo "E-mail afsendt!";
			} else {
				//echo "ERROR - Der opstod en fejl ved afsendelse af e-mail!";
			}

		/******************************************************************************/
		/******************************************************************************/

		/************************** OK - REDIRECT **************************/
			header("Location: info.php?id=text&code=3");
			exit;

		break;



/******************************************************************************************/
/**************************************** NEW USER ****************************************/
/******************************************************************************************/
	case 'activate':
		/************************** CHECK USERNAME **************************/	

			if(isset($_GET['username']) AND $_GET['username']!='') {
				$username = mysql_real_escape_string($_GET['username']);
			} else {
				/* Det aktiverede link er ikke blevet aktiveret som forventet! Der manglede et brugernavn! */
				header("Location: info.php?id=text&code=5");
				exit;
			}

		/************************** CHECK USER INFO **************************/

			$sql_get_user_info = "Select username, password, first_name, middle_name, last_name, address, city, postcode, country_id, year_of_birth, sex, mobil_number, home_number, email_address, show_email_address, added_on_date, is_a_member From tbl_new_users Where username='" . $username . "'";

			$db->query($sql_get_user_info, "get_user_info");
			
			if($db->db_num_rows("get_user_info") == 0) {
				/* Det angivede brugernavn er aldrig tilmeldt Netfugl.dk! */
				header("Location: info.php?id=text&code=7");
				exit;
			}

			$array_user_info = $db->row("get_user_info");

			if($array_user_info["is_a_member"] == 1) {
				/* Du har forsøgt at bekræfte en tilmelding som allerede er bekræftet! */
				header("Location: info.php?id=text&code=6");
				exit;
			}


		/************************** GET USER INFO **************************/
			$password = str_replace("'", "", $array_user_info["password"]);
			$firstname = str_replace("'", "''", $array_user_info["first_name"]);
			$middlename = str_replace("'", "''", $array_user_info["middle_name"]);
			$lastname = str_replace("'", "''", $array_user_info["last_name"]);
			$address = str_replace("'", "''", $array_user_info["address"]);
			$city = str_replace("'", "''", $array_user_info["city"]);
			$postcode = str_replace("'", "''", $array_user_info["postcode"]);
			$country_id = $array_user_info["country_id"];
			$year_of_birth = $array_user_info["year_of_birth"];
			$sex = $array_user_info["sex"];
			$mobil_number = str_replace("'", "''", $array_user_info["mobil_number"]);
			$home_number = str_replace("'", "''", $array_user_info["home_number"]);
			$emailaddress = str_replace("'", "''", $array_user_info["email_address"]);
			$show_email_address = $array_user_info["show_email_address"];

			if ($year_of_birth != '') {
				$year_of_birth = "'" . $year_of_birth . "'";
			} else {
				$year_of_birth = 'Null';
			}

		/************************** ADD NEW USER **************************/
			/*Making the SQL statement and save it in the string : strSQL */

			$user_added_date = date('Y-m-d H:i:s',time());

			$sql_add_user = "Insert into tbl_profiles (username, password, first_name, middel_name, last_name, address, city, postcode, country_id, year_of_birth, sex, mobil_number, home_number, email_address, show_email_address, profile_added, last_update_profile) ";
			$sql_add_user .= "values('$username', '$password', '$firstname', '$middlename', '$lastname', '$address', '$city', '$postcode', '$country_id', $year_of_birth, '$sex', '$mobil_number', '$home_number', '$emailaddress', $show_email_address, '$user_added_date', '$user_added_date')";

			$db->query($sql_add_user, "add_user");

		/************************** SET NEW USER TO ACTIVE **************************/
			$sql_update_new_user = "Update tbl_new_users Set is_a_member = 1 Where username='" . $username . "'";

			$db->query($sql_update_new_user);


		/************************** SEND E-MAIL TO NEW USER **************************/

			$mail_subject = ($page_language == 'dk') ? "Velkommen til Netfugl" : "Welcome to Netfugl";

			$mail_message_text = ($page_language == 'dk') ? "Velkommen til Netfugl.dk\r\n\r\n" : "Welcome to Netfugl.dk\r\n\r\n";
			$mail_message_text .= "Din brugeroprettelse hos Netfugl.dk er hermed gennemført! Du har nu mulighed for at logge ind på Netfugl.dk og begynde at bruge de ekstra muligheder det giver at være oprettet som bruger. Dine logind oplysninger er følgende:\r\n\r\n";
			$mail_message_text .= "Username: " . $username . "\r\n";
			$mail_message_text .= "Password: " . $password . "\r\n\r\n";
			$mail_message_text .= "Vi håber du vil blive tilfreds med hjemmesiden!\r\n\r\n";
			$mail_message_text .= "Med venlig hilsen . . . Netfugl.dk";

		/********************************* SEND E-MAIL ********************************/
		/******************************************************************************/
			$sendmail_to_address = $emailaddress;
			$sendmail_to_name = "";
			$sendmail_from_address = "netfugl@netfugl.dk";
			$sendmail_from_name = "";
			$sendmail_subject = $mail_subject;
			$sendmail_msg = $mail_message_text . "\n";

			if(sendmail($sendmail_to_address, $sendmail_to_name, $sendmail_from_address, $sendmail_from_name, $sendmail_subject, $sendmail_msg)) {
				//echo "E-mail afsendt!";
			} else {
				//echo "ERROR - Der opstod en fejl ved afsendelse af e-mail!";
			}

		/******************************************************************************/
		/******************************************************************************/

					/************************** SEND E-MAIL TO NEW USER **************************/

						$mail_subject = "Netfugl.dk - Aktivering af ny bruger!";

						$mail_message_text = "Ny bruger aktiveret med følgende informationer:\r\n\r\n";
						$mail_message_text .= "Fornavn: " . $firstname . "\r\n";
						$mail_message_text .= "Mellemnavn: " . $middlename . "\r\n";
						$mail_message_text .= "Efternavn: " . $lastname . "\r\n";
						$mail_message_text .= "Adresse: " . $address . "\r\n";
						$mail_message_text .= "By: " . $city . "\r\n";
						$mail_message_text .= "Postnummer: " . $postcode . "\r\n";
						$mail_message_text .= "Land (id): " . $country_id . "\r\n";
						$mail_message_text .= "Fødselsår: " . $year_of_birth . "\r\n";
						$mail_message_text .= "Sex: " . $sex . "\r\n";
						$mail_message_text .= "Mobil nr.: " . $mobil_number . "\r\n";
						$mail_message_text .= "Hjemme nr.: " . $home_number . "\r\n";
						$mail_message_text .= "Username: " . $username . "\r\n";
						$mail_message_text .= "Password: " . $password . "\r\n";
						$mail_message_text .= "E-mail adresse: " . $emailaddress . "\r\n";
						$mail_message_text .= "Vis e-mail adresse: " . $show_email_address . "\r\n";
						$mail_message_text .= "Tilføjet dato: " . $user_added_date . "\r\n";

						$mail_message_text .= "\r\n";

						

		/********************************* SEND E-MAIL ********************************/
		/******************************************************************************/
			$sendmail_to_address = "bentzon@dsr.kvl.dk";
			$sendmail_to_name = "";
			$sendmail_from_address = "netfugl@netfugl.dk";
			$sendmail_from_name = "";
			$sendmail_subject = $mail_subject;
			$sendmail_msg = $mail_message_text . "\n";

			if(sendmail($sendmail_to_address, $sendmail_to_name, $sendmail_from_address, $sendmail_from_name, $sendmail_subject, $sendmail_msg)) {
				//echo "E-mail afsendt!";
			} else {
				//echo "ERROR - Der opstod en fejl ved afsendelse af e-mail!";
			}

		/******************************************************************************/
		/******************************************************************************/

					/******************************************************************************/



		/************************** OK - REDIRECT **************************/
			/* Velkommen til Netfugl.dk! */
			header("Location: info.php?id=text&code=4");
			exit;

		break;


/******************************************************************************************/
/************************************ CHANGE LANGUAGE *************************************/
/******************************************************************************************/
	case 'cl':
		$page_language = @$_GET['language'];
		if (!$page_language OR ($page_language != 'uk' AND $page_language != 'dk')) {
			$page_language = 'dk';
		}

		/*
		if ($url = @$_GET['url']) {
			$url = str_replace('_a_', '&', $url);
			$url = str_replace('&language=dk', '', $url);
			$url = str_replace('&language=uk', '', $url);
			$url = str_replace('?language=dk', '?', $url);
			$url = str_replace('?language=uk', '?', $url);
			$url = str_replace('?&', '?', $url);
			if (strstr($url, '?')) {
				if (strlen(strstr($url, '?')) == 1) {
					$url .= "language=" . $page_language;
				} else {
					$url .= "&language=" . $page_language;
				}
			} else {
				$url .= "?language=" . $page_language;
			}

		} else {
			$url = get_script_url('site_url');
		}

		$coo = new Cookies_Manager_Class("UserCookie");
		
		if (!$coo->get("language") OR ($coo->get("language") != $page_language)) {
			$coo->put("language", $page_language);
			$coo->set_cookie();
		}
		*/

		$url = "http://www.netfugl.dk?language=" . $page_language;

		header("Location: " . $url);
		exit;
		break;

	default :
		header("Location: index.php");
		exit;
		break;
}

restore_error_handler();
	$db->db_close();
?>