\n";
	}

//create the destination database object
	if ($export_type == "db") {
		$dest_db = new PDO('sqlite:/tmp/fusionpbx.db');
	}

//set the headers
	if ($export_type == "sql" && !$debug) {
		header('Content-type: application/octet-binary');
		header('Content-Disposition: attachment; filename=database_backup.sql');
	}

//set the timeout to two hours
	set_time_limit(7200);

//add an rfc compliant version 4 uuid function
	if (!function_exists('uuid')) {
		function uuid() {
			return sprintf( '%04x%04x-%04x-%04x-%04x-%04x%04x%04x',
				// 32 bits for 'time_low'
				mt_rand( 0, 0xffff ), mt_rand( 0, 0xffff ),

				// 16 bits 'for time_mid'
				mt_rand( 0, 0xffff ),

				// 16 bits for 'time_hi_and_version',
				// four most significant bits holds version number 4
				mt_rand( 0, 0x0fff ) | 0x4000,

				// 16 bits, 8 bits for 'clk_seq_hi_res',
				// 8 bits for 'clk_seq_low',
				// two most significant bits holds zero and one for variant DCE1.1
				mt_rand( 0, 0x3fff ) | 0x8000,

				// 48 bits for 'node'
				mt_rand( 0, 0xffff ), mt_rand( 0, 0xffff ), mt_rand( 0, 0xffff )
			);
		}
	}

$schema_pgsql = <<prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$v_id = $row['v_id'];
		$domain_array[$v_id]['domain_name'] = check_str($row['domain_name']);
		$domain_array[$v_id]['domain_uuid'] = uuid();
		$domain_array[$v_id]['domain_description'] = check_str($row['domain_description']);

		$sql = "insert into v_domains ";
		$sql .= "(";
		$sql .= "domain_uuid, ";
		$sql .= "domain_name, ";
		$sql .= "domain_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$domain_array[$v_id]['domain_uuid']."', ";
		$sql .= "'".$domain_array[$v_id]['domain_name']."', ";
		$sql .= "'".$domain_array[$v_id]['domain_description']."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; } 
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); } 
		unset($sql);
	}
	unset ($prep_statement);

//export the default settings path
	$sql = "select * from v_system_settings ";
	$sql .= "limit 1 ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		//general
			$v_id = check_str($row["v_id"]);
			$domain_name = check_str($row["v_domain"]);
		//switch
			$switch_base_dir = check_str($row["v_dir"]);
			$switch_bin_dir = check_str($row["bin_dir"]);
			$switch_conf_dir = check_str($row["v_conf_dir"]);
			$switch_db_dir = check_str($row["v_db_dir"]);
			$switch_dialplan_dir = check_str($row["v_dialplan_default_dir"]);
			if (substr($switch_dialplan_dir, -(strlen($domain_name))) == $domain_name) {
				$switch_dialplan_dir = substr($switch_dialplan_dir, 0, -(strlen($domain_name)+1));
			}
			$switch_extensions_dir = check_str($row["v_extensions_dir"]);
			if (substr($switch_extensions_dir, -(strlen($domain_name))) == $domain_name) {
				$switch_extensions_dir = substr($switch_extensions_dir, 0, -(strlen($domain_name)+1));
			}
			$switch_gateways_dir = check_str($row["v_gateways_dir"]);
			$switch_grammar_dir = check_str($row["v_grammar_dir"]);
			$switch_log_dir = check_str($row["v_log_dir"]);
			$switch_mod_dir = check_str($row["v_mod_dir"]);
			if (strlen($row["v_provisioning_tftp_dir"]) > 0) { $switch_provision_dir = check_str($row["v_provisioning_tftp_dir"]); }
			if (strlen($row["v_provisioning_ftp_dir"]) > 0) { $switch_provision_dir = check_str($row["v_provisioning_ftp_dir"]); }
			if (strlen($row["v_provisioning_https_dir"]) > 0) { $switch_provision_dir = check_str($row["v_provisioning_https_dir"]); }
			if (strlen($row["v_provisioning_http_dir"]) > 0) { $switch_provision_dir = check_str($row["v_provisioning_http_dir"]); }
			$switch_recordings_dir = check_str($row["v_recordings_dir"]);
			if (substr($switch_recordings_dir, -(strlen($domain_name))) == $domain_name) {
				$switch_recordings_dir = substr($switch_extensions_dir, 0, -(strlen($domain_name)+1));
			}
			$switch_scripts_dir = check_str($row["v_scripts_dir"]);
			$switch_sounds_dir = check_str($row["v_sounds_dir"]);
			$switch_storage_dir = check_str($row["v_storage_dir"]);
			$switch_voicemail_dir = check_str($row["v_voicemail_dir"]);
		//server
			$server_startup_script_dir = check_str($row["v_startup_script_dir"]);
			$server_backup_dir = check_str($row["v_backup_dir"]);
			$server_temp_dir = check_str($row["tmp_dir"]);
		//domain
			$domain_menu_uuid = strtolower(check_str($row["v_menu_uuid"]));
			$domain_time_zone =  check_str($row["v_time_zone"]);
			$domain_template_name = check_str($row["v_template_name"]);

	//add the default settings
		$x = 0;
		$tmp[$x]['name'] = 'uuid';
		$tmp[$x]['value'] = $domain_menu_uuid;
		$tmp[$x]['category'] = 'domain';
		$tmp[$x]['subcategory'] = 'menu';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'name';
		$tmp[$x]['value'] = $domain_time_zone;
		$tmp[$x]['category'] = 'domain';
		$tmp[$x]['subcategory'] = 'time_zone';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'name';
		$tmp[$x]['value'] = $domain_template_name;
		$tmp[$x]['category'] = 'domain';
		$tmp[$x]['subcategory'] = 'template';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $server_temp_dir;
		$tmp[$x]['category'] = 'server';
		$tmp[$x]['subcategory'] = 'temp';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $server_startup_script_dir;
		$tmp[$x]['category'] = 'server';
		$tmp[$x]['subcategory'] = 'startup_script';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $server_backup_dir;
		$tmp[$x]['category'] = 'server';
		$tmp[$x]['subcategory'] = 'backup';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_bin_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'bin';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $install_switch_base_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'base';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_conf_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'conf';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_db_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'db';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_log_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'log';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_extensions_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'extensions';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_gateways_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'gateways';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_dialplan_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'dialplan';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_mod_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'mod';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_scripts_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'scripts';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_grammar_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'grammar';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_storage_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'storage';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_voicemail_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'voicemail';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_recordings_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'recordings';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_sounds_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'sounds';
		$tmp[$x]['enabled'] = 'true';
		$x++;
		$tmp[$x]['name'] = 'dir';
		$tmp[$x]['value'] = $switch_provision_dir;
		$tmp[$x]['category'] = 'switch';
		$tmp[$x]['subcategory'] = 'provision';
		$tmp[$x]['enabled'] = 'false';
		$x++;
		//$dest_db->beginTransaction();
		foreach($tmp as $row) {
			$sql = "insert into v_default_settings ";
			$sql .= "(";
			$sql .= "default_setting_uuid, ";
			$sql .= "default_setting_name, ";
			$sql .= "default_setting_value, ";
			$sql .= "default_setting_category, ";
			$sql .= "default_setting_subcategory, ";
			$sql .= "default_setting_enabled ";
			$sql .= ") ";
			$sql .= "values ";
			$sql .= "(";
			$sql .= "'".uuid()."', ";
			$sql .= "'".$row['name']."', ";
			$sql .= "'".$row['value']."', ";
			$sql .= "'".$row['category']."', ";
			$sql .= "'".$row['subcategory']."', ";
			$sql .= "'".$row['enabled']."' ";
			$sql .= ")";
			if ($export_type == "sql") { echo check_sql($sql).";\n"; } 
			if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
			unset($sql);
		}
		//$dest_db->commit();
		unset($tmp);
	}
	unset ($prep_statement);

//get the user array
	$sql = "select username, v_id from v_users ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$v_id = check_str($row["v_id"]);
		$username = check_str($row["username"]);
		$user_array[$v_id][$username]['user_uuid'] = uuid();
		$user_array[$v_id][$username]['contact_uuid'] = uuid();
	}
	//print_r($user_array);
	unset ($prep_statement);

//export the group members and add them into group users
	$sql = "select * from v_group_members ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$group_user_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$username = check_str($row["username"]);
		$group_name = check_str($row["group_id"]);
		$user_uuid = $user_array[$v_id][$username]['user_uuid'];

		if (strlen($domain_uuid) > 0 && strlen($user_uuid) > 0) {
			$sql = "insert into v_group_users ";
			$sql .= "(";
			$sql .= "group_user_uuid, ";
			$sql .= "domain_uuid, ";
			$sql .= "group_name, ";
			$sql .= "user_uuid ";
			$sql .= ")";
			$sql .= "values ";
			$sql .= "(";
			$sql .= "'".$group_user_uuid."', ";
			$sql .= "'".$domain_uuid."', ";
			$sql .= "'".$group_name."', ";
			if (strlen($user_uuid) > 0) {
				$sql .= "'".$user_uuid."' ";
			}
			else {
				$sql .= "null ";
			}
			$sql .= ")";
			if ($export_type == "sql") { echo check_sql($sql).";\n"; }
			if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
		}
	}
	unset ($prep_statement);

//export the group permissions
	$sql = "select * from v_group_permissions ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$group_permission_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$permission_name = check_str($row["permission_id"]);
		$group_name = check_str($row["group_id"]);

		if (strlen($domain_uuid) > 0) {
			$sql = "insert into v_group_permissions ";
			$sql .= "(";
			$sql .= "group_permission_uuid, ";
			$sql .= "domain_uuid, ";
			$sql .= "permission_name, ";
			$sql .= "group_name ";
			$sql .= ")";
			$sql .= "values ";
			$sql .= "(";
			$sql .= "'".$group_permission_uuid."', ";
			$sql .= "'".$domain_uuid."', ";
			$sql .= "'".$permission_name."', ";
			$sql .= "'".$group_name."' ";
			$sql .= ")";
			if ($export_type == "sql") { echo check_sql($sql).";\n"; }
			if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
		}
	}
	unset ($prep_statement);

//export the groups
	$sql = "select * from v_groups ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$group_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$group_name = check_str($row["group_id"]);
		$group_description = check_str($row["group_desc"]);

		if (strlen($domain_uuid) > 0) {
			$sql = "insert into v_groups ";
			$sql .= "(";
			$sql .= "group_uuid, ";
			$sql .= "domain_uuid, ";
			$sql .= "group_name, ";
			$sql .= "group_description ";
			$sql .= ")";
			$sql .= "values ";
			$sql .= "(";
			$sql .= "'".$group_uuid."', ";
			$sql .= "'".$domain_uuid."', ";
			$sql .= "'".$group_name."', ";
			$sql .= "'".$group_description."' ";
			$sql .= ")";
			if ($export_type == "sql") { echo check_sql($sql).";\n"; }
			if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
		}
	}
	unset ($prep_statement);

//export the menus
	$sql = "select * from v_menus ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$menu_uuid = check_str($row["menu_uuid"]);
		$menu_name = check_str($row["menu_name"]);
		$menu_language = check_str($row["menu_language"]);
		$menu_description = check_str($row["menu_desc"]);

		$sql = "insert into v_menus ";
		$sql .= "(";
		$sql .= "menu_uuid, ";
		$sql .= "menu_name, ";
		$sql .= "menu_language, ";
		$sql .= "menu_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$menu_uuid."', ";
		$sql .= "'".$menu_name."', ";
		$sql .= "'".$menu_language."', ";
		$sql .= "'".$menu_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the menu items
	$sql = "select * from v_menu_items ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$menu_item_uuid = strtolower(check_str($row["menu_item_uuid"]));
		$menu_uuid = strtolower(check_str($row["menu_uuid"]));
		$menu_item_parent_uuid = strtolower(check_str($row["menu_item_parent_uuid"]));
		$menu_item_title = check_str($row["menu_item_title"]);
		$menu_item_link = check_str($row["menu_item_str"]);
		$menu_item_category = check_str($row["menu_item_category"]);
		$menu_item_protected = check_str($row["menu_item_protected"]);
		$menu_item_order = check_str($row["menu_item_order"]);
		$menu_item_description = check_str($row["menu_item_desc"]);
		$menu_item_add_user = check_str($row["menu_item_add_user"]);
		$menu_item_add_date = check_str($row["menu_item_add_date"]);
		$menu_item_mod_user = check_str($row["menu_item_mod_user"]);
		$menu_item_mod_date = check_str($row["menu_item_mod_date"]);

		$sql = "insert into v_menu_items ";
		$sql .= "(";
		$sql .= "menu_item_uuid, ";
		$sql .= "menu_uuid, ";
		$sql .= "menu_item_parent_uuid, ";
		$sql .= "menu_item_title, ";
		$sql .= "menu_item_link, ";
		$sql .= "menu_item_category, ";
		$sql .= "menu_item_protected, ";
		$sql .= "menu_item_order, ";
		$sql .= "menu_item_description, ";
		$sql .= "menu_item_add_user, ";
		$sql .= "menu_item_add_date, ";
		$sql .= "menu_item_mod_user, ";
		$sql .= "menu_item_mod_date ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$menu_item_uuid."', ";
		$sql .= "'".$menu_uuid."', ";
		if (strlen($menu_item_parent_uuid) > 0) {
			$sql .= "'".$menu_item_parent_uuid."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$menu_item_title."', ";
		$sql .= "'".$menu_item_link."', ";
		$sql .= "'".$menu_item_category."', ";
		$sql .= "'".$menu_item_protected."', ";
		$sql .= "'".$menu_item_order."', ";
		$sql .= "'".$menu_item_description."', ";
		$sql .= "'".$menu_item_add_user."', ";
		$sql .= "'".$menu_item_add_date."', ";
		$sql .= "'".$menu_item_mod_user."', ";
		$sql .= "'".$menu_item_mod_date."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the groups assigned to the menu itmes
	$sql = "select * from v_menu_item_groups ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$menu_uuid = check_str($row["menu_uuid"]);
		$menu_item_uuid = check_str($row["menu_item_uuid"]);
		$group_name = check_str($row["group_id"]);

		if (strlen($menu_item_uuid) > 0) {
			$sql = "insert into v_menu_item_groups ";
			$sql .= "(";
			$sql .= "menu_uuid, ";
			$sql .= "menu_item_uuid, ";
			$sql .= "group_name ";
			$sql .= ")";
			$sql .= "values ";
			$sql .= "(";
			$sql .= "'".$menu_uuid."', ";
			$sql .= "'".$menu_item_uuid."', ";
			$sql .= "'".$group_name."' ";
			$sql .= ")";
			if ($export_type == "sql") { echo check_sql($sql).";\n"; }
			if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
		}
	}
	unset ($prep_statement);

//export the users
	$sql = "select * from v_users ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$v_id = check_str($row["v_id"]);
		$username = check_str($row["username"]);
		$user_uuid = $user_array[$v_id][$username]['user_uuid'];
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$password = check_str($row["password"]);
		$salt = check_str($row["salt"]);
		$contact_uuid = $user_array[$v_id][$username]['contact_uuid'];
		$user_status = check_str($row["user_status"]);
		$user_time_zone = check_str($row["user_time_zone"]);
		$user_type = check_str($row["user_type"]);
		$user_category = check_str($row["user_category"]);

		if (strlen($user_uuid) == 0) {
			$user_uuid = uuid();
		}

		if (strlen($domain_uuid) > 0) {
			if (strlen($username) > 0) {
				$sql = "insert into v_users ";
				$sql .= "(";
				$sql .= "user_uuid, ";
				$sql .= "domain_uuid, ";
				$sql .= "username, ";
				$sql .= "password, ";
				$sql .= "salt, ";
				$sql .= "contact_uuid, ";
				$sql .= "user_status, ";
				$sql .= "user_add_user, ";
				$sql .= "user_add_date ";
				$sql .= ")";
				$sql .= "values ";
				$sql .= "(";
				$sql .= "'".$user_uuid."', ";
				$sql .= "'".$domain_uuid."', ";
				$sql .= "'".$username."', ";
				$sql .= "'".$password."', ";
				$sql .= "'".$salt."', ";
				$sql .= "'".$contact_uuid."', ";
				$sql .= "'".$user_status."', ";
				$sql .= "'".$user_add_user."', ";
				$sql .= "'".$user_add_date."' ";
				$sql .= ")";
				if ($export_type == "sql") { echo check_sql($sql).";\n"; }
				if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
			}

			//export contacts
				$contact_name_given = check_str($row["user_first_name"]);
				$contact_name_family = check_str($row["user_last_name"]);
				$contact_organization = check_str($row["user_company_name"]);
				$contact_email = check_str($row["user_email"]);
				$contact_note = check_str($row["user_notes"]);
				$contact_url = check_str($row["user_url"]);

				$sql = "insert into v_contacts ";
				$sql .= "(";
				$sql .= "contact_uuid, ";
				$sql .= "domain_uuid, ";
				$sql .= "contact_type, ";
				$sql .= "contact_organization, ";
				$sql .= "contact_name_given, ";
				$sql .= "contact_name_family, ";
				$sql .= "contact_email, ";
				$sql .= "contact_url, ";
				$sql .= "contact_time_zone, ";
				$sql .= "contact_note ";
				$sql .= ")";
				$sql .= "values ";
				$sql .= "(";
				$sql .= "'".$contact_uuid."', ";
				$sql .= "'".$domain_uuid."', ";
				if ($user_type == 'user') {
					$sql .= "'user', ";
				}
				else {
					$sql .= "'".$user_category."', ";
				}
				$sql .= "'".$contact_organization."', ";
				$sql .= "'".$contact_name_given."', ";
				$sql .= "'".$contact_name_family."', ";
				$sql .= "'".$contact_email."', ";
				$sql .= "'".$contact_url."', ";
				$sql .= "'".$user_time_zone."', ";
				$sql .= "'".$contact_note."' ";
				$sql .= ")";
				if ($export_type == "sql") { echo check_sql($sql).";\n"; }
				if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }

			//export the contact addresses
				$x = 0;
				if (strlen($row["user_physical_city"]) > 0) {
					$addresses[$x]['address_1'] = check_str($row["user_physical_address_1"]);
					$addresses[$x]['address_2'] = check_str($row["user_physical_address_2"]);
					$addresses[$x]['city'] = check_str($row["user_physical_city"]);
					$addresses[$x]['state_province'] = check_str($row["user_physical_state_province"]);
					$addresses[$x]['country'] = check_str($row["user_physical_country"]);
					$addresses[$x]['postal_code'] = check_str($row["user_physical_postal_code"]);
					$addresses[$x]['address_type'] = 'work';
					$x++;
				}
				if (strlen($row["user_mailing_city"]) > 0) {
					$addresses[$x]['address_1'] = check_str($row["user_mailing_address_1"]);
					$addresses[$x]['address_2'] = check_str($row["user_mailing_address_2"]);
					$addresses[$x]['city'] = check_str($row["user_mailing_city"]);
					$addresses[$x]['state_province'] = check_str($row["user_mailing_state_province"]);
					$addresses[$x]['country'] = check_str($row["user_mailing_country"]);
					$addresses[$x]['postal_code'] = check_str($row["user_mailing_postal_code"]);
					$addresses[$x]['address_type'] = 'work';
					$x++;
				}
				if (strlen($row["user_billing_city"]) > 0) {
					$addresses[$x]['address_1'] = check_str($row["user_billing_address_1"]);
					$addresses[$x]['address_2'] = check_str($row["user_billing_address_2"]);
					$addresses[$x]['city'] = check_str($row["user_billing_city"]);
					$addresses[$x]['state_province'] = check_str($row["user_billing_state_province"]);
					$addresses[$x]['country'] = check_str($row["user_billing_country"]);
					$addresses[$x]['postal_code'] = check_str($row["user_billing_postal_code"]);
					$addresses[$x]['address_type'] = 'work';
					$x++;
				}
				if (strlen($row["user_shipping_city"]) > 0) {
					$addresses[$x]['address_1'] = check_str($row["user_shipping_address_1"]);
					$addresses[$x]['address_2'] = check_str($row["user_shipping_address_2"]);
					$addresses[$x]['city'] = check_str($row["user_shipping_city"]);
					$addresses[$x]['state_province'] = check_str($row["user_shipping_state_province"]);
					$addresses[$x]['country'] = check_str($row["user_shipping_country"]);
					$addresses[$x]['postal_code'] = check_str($row["user_shipping_postal_code"]);
					$addresses[$x]['address_type'] = 'work';
				}
				foreach($addresses as $address) {
					$sql = "insert into v_contact_addresses ";
					$sql .= "(";
					$sql .= "contact_address_uuid, ";
					$sql .= "contact_uuid, ";
					$sql .= "domain_uuid, ";
					$sql .= "address_type, ";
					$sql .= "address_street, ";
					$sql .= "address_extended, ";
					$sql .= "address_locality, ";
					$sql .= "address_region, ";
					$sql .= "address_postal_code, ";
					$sql .= "address_country ";
					$sql .= ")";
					$sql .= "values ";
					$sql .= "(";
					$sql .= "'".uuid()."', ";
					$sql .= "'".$contact_uuid."', ";
					$sql .= "'".$domain_uuid."', ";
					$sql .= "'".$address["address_type"]."', ";
					$sql .= "'".$address["address_1"]."', ";
					$sql .= "'".$address["address_2"]."', ";
					$sql .= "'".$address["city"]."', ";
					$sql .= "'".$address["state_province"]."', ";
					$sql .= "'".$address["postal_code"]."', ";
					$sql .= "'".$address["country"]."' ";
					$sql .= ")";
					if ($export_type == "sql") { echo check_sql($sql).";\n"; }
					if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
				}
				unset($addresses);

			//export the contact phone numbers
				$x = 0;
				if (strlen($row["user_phone_1"]) > 0) {
					$phones[$x]['number'] = check_str($row["user_phone_1"]);
					$phones[$x]['type'] = 'work';
					$x++;
				}
				if (strlen($row["user_phone_2"]) > 0) {
					$phones[$x]['number'] = check_str($row["user_phone_2"]);
					$phones[$x]['type'] = 'work';
					$x++;
				}
				if (strlen($row["user_phone_mobile"]) > 0) {
					$phones[$x]['number'] = check_str($row["user_phone_mobile"]);
					$phones[$x]['type'] = 'cell';
					$x++;
				}
				if (strlen($row["user_phone_emergency_mobile"]) > 0) {
					$phones[$x]['number'] = check_str($row["user_phone_emergency_mobile"]);
					$phones[$x]['type'] = 'x-emergency';
					$x++;
				}
				if (strlen($row["user_phone_fax"]) > 0) {
					$phones[$x]['number'] = check_str($row["user_phone_fax"]);
					$phones[$x]['type'] = 'fax';
					$x++;
				}
				foreach($phones as $phone) {
					$sql = "insert into v_contact_phones ";
					$sql .= "(";
					$sql .= "contact_phone_uuid, ";
					$sql .= "domain_uuid, ";
					$sql .= "contact_uuid, ";
					$sql .= "phone_type, ";
					$sql .= "phone_number ";
					$sql .= ")";
					$sql .= "values ";
					$sql .= "(";
					$sql .= "'".uuid()."', ";
					$sql .= "'".$domain_uuid."', ";
					$sql .= "'".$contact_uuid."', ";
					$sql .= "'".$phone["type"]."', ";
					$sql .= "'".$phone["number"]."' ";
					$sql .= ")";
					if ($export_type == "sql") { echo check_sql($sql).";\n"; }
					if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
				}
				unset($phones);

			//add to user settings
				//$user_template_name = $row["user_template_name"];
				if (strlen($row["user_time_zone"]) > 0) {
					$user_settings[$x]['category'] = 'domain';
					$user_settings[$x]['sub_category'] = 'time_zone';
					$user_settings[$x]['name'] = "name";
					$user_settings[$x]['value'] = check_str($row["user_time_zone"]);
					$x++;
				}
				foreach($user_settings as $setting) {
					$sql = "insert into v_user_settings ";
					$sql .= "(";
					$sql .= "user_setting_uuid, ";
					$sql .= "user_setting_category, ";
					$sql .= "user_setting_subcategory, ";
					$sql .= "user_setting_name, ";
					$sql .= "user_setting_value, ";
					$sql .= "user_setting_enabled, ";
					$sql .= "user_uuid ";
					$sql .= ") ";
					$sql .= "values ";
					$sql .= "(";
					$sql .= "'".uuid()."', ";
					$sql .= "'".$setting["category"]."', ";
					$sql .= "'".$setting["sub_category"]."', ";
					$sql .= "'".$setting["name"]."', ";
					$sql .= "'".$setting["value"]."', ";
					$sql .= "'true', ";
					$sql .= "'".$user_uuid."' ";
					$sql .= ")";
					$db->exec(check_sql($sql));
				}
				unset($user_settings);
		}
	}
	unset ($prep_statement);

//export the call broadcasts
	$sql = "select * from v_call_broadcast ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$call_call_broadcast_uuid = uuid();
		$broadcast_name = check_str($row["broadcast_name"]);
		$broadcast_description = check_str($row["broadcast_desc"]);
		$broadcast_timeout = check_str($row["broadcast_timeout"]);
		$broadcast_concurrent_limit = check_str($row["broadcast_concurrent_limit"]);
		$recording_uuid = check_str($row["recording_uuid"]);
		$broadcast_caller_id_name = check_str($row["broadcast_caller_id_name"]);
		$broadcast_caller_id_number = check_str($row["broadcast_caller_id_number"]);
		$broadcast_destination_type = check_str($row["broadcast_destination_type"]);
		$broadcast_phone_numbers = check_str($row["broadcast_phone_numbers"]);
		$broadcast_destination_data = check_str($row["broadcast_destination_data"]);

		$sql = "insert into v_call_broadcasts ";
		$sql .= "(";
		$sql .= "call_call_broadcast_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "broadcast_name, ";
		$sql .= "broadcast_description, ";
		$sql .= "broadcast_timeout, ";
		$sql .= "broadcast_concurrent_limit, ";
		$sql .= "recording_uuid, ";
		$sql .= "broadcast_caller_id_name, ";
		$sql .= "broadcast_caller_id_number, ";
		$sql .= "broadcast_destination_type, ";
		$sql .= "broadcast_phone_numbers, ";
		$sql .= "broadcast_destination_data ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$call_call_broadcast_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$broadcast_name."', ";
		$sql .= "'".$broadcast_description."', ";
		$sql .= "'".$broadcast_timeout."', ";
		$sql .= "'".$broadcast_concurrent_limit."', ";
		$sql .= "null, ";
		$sql .= "'".$broadcast_caller_id_name."', ";
		$sql .= "'".$broadcast_caller_id_number."', ";
		$sql .= "'".$broadcast_destination_type."', ";
		$sql .= "'".$broadcast_phone_numbers."', ";
		$sql .= "'".$broadcast_destination_data."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export call center agents
	$sql = "select * from v_call_center_agent ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$call_center_agent_uuid = uuid();
		$agent_name = check_str($row["agent_name"]);
		$agent_type = check_str($row["agent_type"]);
		$agent_call_timeout = check_str($row["agent_call_timeout"]);
		$agent_contact = check_str($row["agent_contact"]);
		$agent_status = check_str($row["agent_status"]);
		$agent_logout = check_str($row["agent_logout"]);
		$agent_max_no_answer = check_str($row["agent_max_no_answer"]);
		$agent_wrap_up_time = check_str($row["agent_wrap_up_time"]);
		$agent_reject_delay_time = check_str($row["agent_reject_delay_time"]);
		$agent_busy_delay_time = check_str($row["agent_busy_delay_time"]);
		$agent_no_answer_delay_time = check_str($row["agent_no_answer_delay_time"]);

		$sql = "insert into v_call_center_agents ";
		$sql .= "(";
		$sql .= "call_center_agent_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "agent_name, ";
		$sql .= "agent_type, ";
		$sql .= "agent_call_timeout, ";
		$sql .= "agent_contact, ";
		$sql .= "agent_status, ";
		$sql .= "agent_logout, ";
		$sql .= "agent_max_no_answer, ";
		$sql .= "agent_wrap_up_time, ";
		$sql .= "agent_reject_delay_time, ";
		$sql .= "agent_busy_delay_time, ";
		$sql .= "agent_no_answer_delay_time ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$call_center_agent_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$agent_name."', ";
		$sql .= "'".$agent_type."', ";
		$sql .= "'".$agent_call_timeout."', ";
		$sql .= "'".$agent_contact."', ";
		$sql .= "'".$agent_status."', ";
		$sql .= "'".$agent_logout."', ";
		$sql .= "'".$agent_max_no_answer."', ";
		$sql .= "'".$agent_wrap_up_time."', ";
		$sql .= "'".$agent_reject_delay_time."', ";
		$sql .= "'".$agent_busy_delay_time."', ";
		$sql .= "'".$agent_no_answer_delay_time."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export call center logs
	$sql = "select * from v_call_center_logs ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$cc_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$cc_queue = check_str($row["cc_queue"]);
		$cc_action = check_str($row["cc_action"]);
		$cc_count = check_str($row["cc_count"]);
		$cc_agent = check_str($row["cc_agent"]);
		$cc_agent_system = check_str($row["cc_agent_system"]);
		$cc_agent_status = check_str($row["cc_agent_status"]);
		$cc_agent_state = check_str($row["cc_agent_state"]);
		$cc_agent_uuid = check_str($row["cc_agent_uuid"]);
		$cc_selection = check_str($row["cc_selection"]);
		$cc_cause = check_str($row["cc_cause"]);
		$cc_wait_time = check_str($row["cc_wait_time"]);
		$cc_talk_time = check_str($row["cc_talk_time"]);
		$cc_total_time = check_str($row["cc_total_time"]);
		$cc_epoch = check_str($row["cc_epoch"]);
		$cc_date = check_str($row["cc_date"]);
		$cc_agent_type = check_str($row["cc_agent_type"]);
		$cc_member_uuid = check_str($row["cc_member_uuid"]);
		$cc_member_session_uuid = check_str($row["cc_member_session_uuid"]);
		$cc_member_cid_name = check_str($row["cc_member_cid_name"]);
		$cc_member_cid_number = check_str($row["cc_member_cid_number"]);
		$cc_agent_called_time = check_str($row["cc_agent_called_time"]);
		$cc_agent_answered_time = check_str($row["cc_agent_answered_time"]);
		$cc_member_joined_time = check_str($row["cc_member_joined_time"]);
		$cc_member_leaving_time = check_str($row["cc_member_leaving_time"]);
		$cc_bridge_terminated_time = check_str($row["cc_bridge_terminated_time"]);
		$cc_hangup_cause = check_str($row["cc_hangup_cause"]);

		$sql = "insert into v_call_center_logs ";
		$sql .= "(";
		$sql .= "cc_uuid, ";
		$sql .= "cc_queue, ";
		$sql .= "cc_action, ";
		$sql .= "cc_count, ";
		$sql .= "cc_agent, ";
		$sql .= "cc_agent_system, ";
		$sql .= "cc_agent_status, ";
		$sql .= "cc_agent_state, ";
		$sql .= "cc_agent_uuid, ";
		$sql .= "cc_selection, ";
		$sql .= "cc_cause, ";
		$sql .= "cc_wait_time, ";
		$sql .= "cc_talk_time, ";
		$sql .= "cc_total_time, ";
		$sql .= "cc_epoch, ";
		$sql .= "cc_date, ";
		$sql .= "cc_agent_type, ";
		$sql .= "cc_member_uuid, ";
		$sql .= "cc_member_session_uuid, ";
		$sql .= "cc_member_cid_name, ";
		$sql .= "cc_member_cid_number, ";
		$sql .= "cc_agent_called_time, ";
		$sql .= "cc_agent_answered_time, ";
		$sql .= "cc_member_joined_time, ";
		$sql .= "cc_member_leaving_time, ";
		$sql .= "cc_bridge_terminated_time, ";
		$sql .= "cc_hangup_cause ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$cc_uuid."', ";
		$sql .= "'".$cc_queue."', ";
		$sql .= "'".$cc_action."', ";
		if (strlen($cc_count) > 0) {
			$sql .= "'".$cc_count."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$cc_agent."', ";
		$sql .= "'".$cc_agent_system."', ";
		$sql .= "'".$cc_agent_status."', ";
		$sql .= "'".$cc_agent_state."', ";
		$sql .= "'".$cc_agent_uuid."', ";
		$sql .= "'".$cc_selection."', ";
		$sql .= "'".$cc_cause."', ";
		$sql .= "'".$cc_wait_time."', ";
		$sql .= "'".$cc_talk_time."', ";
		$sql .= "'".$cc_total_time."', ";
		if (strlen($cc_epoch) > 0) {
			$sql .= "'".$cc_epoch."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$cc_date."', ";
		$sql .= "'".$cc_agent_type."', ";
		$sql .= "'".$cc_member_uuid."', ";
		$sql .= "'".$cc_member_session_uuid."', ";
		$sql .= "'".$cc_member_cid_name."', ";
		$sql .= "'".$cc_member_cid_number."', ";
		if (strlen($cc_agent_called_time) > 0) {
			$sql .= "'".$cc_agent_called_time."', ";
		}
		else {
			$sql .= "null, ";
		}
		if (strlen($cc_agent_answered_time) > 0) {
			$sql .= "'".$cc_agent_answered_time."', ";
		}
		else {
			$sql .= "null, ";
		}
		if (strlen($cc_member_joined_time) > 0) {
			$sql .= "'".$cc_member_joined_time."', ";
		}
		else {
			$sql .= "null, ";
		}
		if (strlen($cc_member_leaving_time) > 0) {
			$sql .= "'".$cc_member_leaving_time."', ";
		}
		else {
			$sql .= "null, ";
		}
		if (strlen($cc_bridge_terminated_time) > 0) {
			$sql .= "'".$cc_bridge_terminated_time."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$cc_hangup_cause."' ";
		$sql .= ")";
		//if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		//if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the call center queues
	$sql = "select * from v_call_center_queue ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$call_center_queue_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$queue_name = check_str($row["queue_name"]);
		$queue_extension = check_str($row["queue_extension"]);
		$queue_strategy = check_str($row["queue_strategy"]);
		$queue_moh_sound = check_str($row["queue_moh_sound"]);
		$queue_record_template = check_str($row["queue_record_template"]);
		$queue_time_base_score = check_str($row["queue_time_base_score"]);
		$queue_max_wait_time = check_str($row["queue_max_wait_time"]);
		$queue_max_wait_time_with_no_agent = check_str($row["queue_max_wait_time_with_no_agent"]);
		$queue_tier_rules_apply = check_str($row["queue_tier_rules_apply"]);
		$queue_tier_rule_wait_second = check_str($row["queue_tier_rule_wait_second"]);
		$queue_tier_rule_no_agent_no_wait = check_str($row["queue_tier_rule_no_agent_no_wait"]);
		$queue_timeout_action = check_str($row["queue_timeout_action"]);
		$queue_discard_abandoned_after = check_str($row["queue_discard_abandoned_after"]);
		$queue_abandoned_resume_allowed = check_str($row["queue_abandoned_resume_allowed"]);
		$queue_tier_rule_wait_multiply_level = check_str($row["queue_tier_rule_wait_multiply_level"]);
		$queue_cid_prefix = check_str($row["queue_cid_prefix"]);
		$queue_description = check_str($row["queue_description"]);

		$sql = "insert into v_call_center_queues ";
		$sql .= "(";
		$sql .= "call_center_queue_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "queue_name, ";
		$sql .= "queue_extension, ";
		$sql .= "queue_strategy, ";
		$sql .= "queue_moh_sound, ";
		$sql .= "queue_record_template, ";
		$sql .= "queue_time_base_score, ";
		$sql .= "queue_max_wait_time, ";
		$sql .= "queue_max_wait_time_with_no_agent, ";
		$sql .= "queue_tier_rules_apply, ";
		$sql .= "queue_tier_rule_wait_second, ";
		$sql .= "queue_tier_rule_no_agent_no_wait, ";
		$sql .= "queue_timeout_action, ";
		$sql .= "queue_discard_abandoned_after, ";
		$sql .= "queue_abandoned_resume_allowed, ";
		$sql .= "queue_tier_rule_wait_multiply_level, ";
		$sql .= "queue_cid_prefix, ";
		$sql .= "queue_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$call_center_queue_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$queue_name."', ";
		$sql .= "'".$queue_extension."', ";
		$sql .= "'".$queue_strategy."', ";
		$sql .= "'".$queue_moh_sound."', ";
		$sql .= "'".$queue_record_template."', ";
		$sql .= "'".$queue_time_base_score."', ";
		$sql .= "'".$queue_max_wait_time."', ";
		$sql .= "'".$queue_max_wait_time_with_no_agent."', ";
		$sql .= "'".$queue_tier_rules_apply."', ";
		$sql .= "'".$queue_tier_rule_wait_second."', ";
		$sql .= "'".$queue_tier_rule_no_agent_no_wait."', ";
		$sql .= "'".$queue_timeout_action."', ";
		$sql .= "'".$queue_discard_abandoned_after."', ";
		$sql .= "'".$queue_abandoned_resume_allowed."', ";
		$sql .= "'".$queue_tier_rule_wait_multiply_level."', ";
		$sql .= "'".$queue_cid_prefix."', ";
		$sql .= "'".$queue_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the call center tiers
	$sql = "select * from v_call_center_tier ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$call_center_tier_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$agent_name = check_str($row["agent_name"]);
		$queue_name = check_str($row["queue_name"]);
		$tier_level = check_str($row["tier_level"]);
		$tier_position = check_str($row["tier_position"]);

		$sql = "insert into v_call_center_tiers ";
		$sql .= "(";
		$sql .= "call_center_tier_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "agent_name, ";
		$sql .= "queue_name, ";
		$sql .= "tier_level, ";
		$sql .= "tier_position ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$call_center_tier_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$agent_name."', ";
		$sql .= "'".$queue_name."', ";
		$sql .= "'".$tier_level."', ";
		$sql .= "'".$tier_position."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export contacts
	$sql = "select * from v_contacts ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$contact_id = check_str($row["contact_id"]);
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$contact_uuid = uuid();
		$contact_type = check_str($row["type"]);
		$contact_organization = check_str($row["org"]);
		$contact_name_given = check_str($row["n_given"]);
		$contact_name_family = check_str($row["n_family"]);
		$contact_nickname = check_str($row["nickname"]);
		$contact_title = check_str($row["title"]);
		$contact_role = check_str($row["role"]);
		$contact_email = check_str($row["email"]);
		$contact_url = check_str($row["url"]);
		$contact_time_zone = check_str($row["tz"]);
		$contact_note = check_str($row["note"]);

		//set the contact_uuid
		$contact_array[$contact_id]['contact_uuid'] = $contact_uuid;

		$sql = "insert into v_contacts ";
		$sql .= "(";
		$sql .= "contact_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "contact_type, ";
		$sql .= "contact_organization, ";
		$sql .= "contact_name_given, ";
		$sql .= "contact_name_family, ";
		$sql .= "contact_nickname, ";
		$sql .= "contact_title, ";
		$sql .= "contact_role, ";
		$sql .= "contact_email, ";
		$sql .= "contact_url, ";
		$sql .= "contact_time_zone, ";
		$sql .= "contact_note ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$contact_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$contact_type."', ";
		$sql .= "'".$contact_organization."', ";
		$sql .= "'".$contact_name_given."', ";
		$sql .= "'".$contact_name_family."', ";
		$sql .= "'".$contact_nickname."', ";
		$sql .= "'".$contact_title."', ";
		$sql .= "'".$contact_role."', ";
		$sql .= "'".$contact_email."', ";
		$sql .= "'".$contact_url."', ";
		$sql .= "'".$contact_time_zone."', ";
		$sql .= "'".$contact_note."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the contact addresses
	$sql = "select * from v_contacts_adr ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$contact_address_uuid = uuid();
		$contact_id = check_str($row["contact_id"]);
		$address_type = check_str($row["adr_type"]);
		$address_street = check_str($row["adr_street"]);
		$address_extended = check_str($row["adr_extended"]);
		$address_locality = check_str($row["adr_locality"]);
		$address_region = check_str($row["adr_region"]);
		$address_postal_code = check_str($row["adr_postal_code"]);
		$address_country = check_str($row["adr_country"]);
		$address_latitude = check_str($row["adr_latitude"]);
		$address_longitude = check_str($row["adr_longitude"]);

		//get the contact_uuid
		$contact_uuid = $contact_array[$contact_id]['contact_uuid'];

		$sql = "insert into v_contact_addresses ";
		$sql .= "(";
		$sql .= "contact_address_uuid, ";
		$sql .= "contact_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "address_type, ";
		$sql .= "address_street, ";
		$sql .= "address_extended, ";
		$sql .= "address_locality, ";
		$sql .= "address_region, ";
		$sql .= "address_postal_code, ";
		$sql .= "address_country, ";
		$sql .= "address_latitude, ";
		$sql .= "address_longitude ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$contact_address_uuid."', ";
		$sql .= "'".$contact_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$address_type."', ";
		$sql .= "'".$address_street."', ";
		$sql .= "'".$address_extended."', ";
		$sql .= "'".$address_locality."', ";
		$sql .= "'".$address_region."', ";
		$sql .= "'".$address_postal_code."', ";
		$sql .= "'".$address_country."', ";
		$sql .= "'".$address_latitude."', ";
		$sql .= "'".$address_longitude."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the contact phone numbers
	$sql = "select * from v_contacts_tel ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$contact_phone_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$contact_id = check_str($row["contact_id"]);
		$phone_type = check_str($row["tel_type"]);
		$phone_number = check_str($row["tel_number"]);

		//get the contact_uuid
		$contact_uuid = $contact_array[$contact_id]['contact_uuid'];

		if (strlen($contact_uuid) > 0) {
			$sql = "insert into v_contact_phones ";
			$sql .= "(";
			$sql .= "contact_phone_uuid, ";
			$sql .= "domain_uuid, ";
			$sql .= "contact_uuid, ";
			$sql .= "phone_type, ";
			$sql .= "phone_number ";
			$sql .= ")";
			$sql .= "values ";
			$sql .= "(";
			$sql .= "'".$contact_phone_uuid."', ";
			$sql .= "'".$domain_uuid."', ";
			$sql .= "'".$contact_uuid."', ";
			$sql .= "'".$phone_type."', ";
			$sql .= "'".$phone_number."' ";
			$sql .= ")";
		}
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the contact notes
	$sql = "select * from v_contact_notes ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$contact_note_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$contact_id = check_str($row["contact_id"]);
		$contact_note = check_str($row["notes"]);
		$last_mod_date = check_str($row["last_mod_date"]);
		$last_mod_user = check_str($row["last_mod_user"]);

		//get the contact_uuid
		$contact_uuid = $contact_array[$contact_id]['contact_uuid'];

		$sql = "insert into v_contact_notes ";
		$sql .= "(";
		$sql .= "contact_note_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "contact_uuid, ";
		$sql .= "contact_note, ";
		$sql .= "last_mod_date, ";
		$sql .= "last_mod_user ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$contact_note_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$contact_uuid."', ";
		$sql .= "'".$contact_note."', ";
		$sql .= "'".$last_mod_date."', ";
		$sql .= "'".$last_mod_user."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the rss data
	$sql = "select * from v_rss ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$rss_id = check_str($row["rss_id"]);
		$rss_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$rss_language = check_str($row["rss_language"]);
		$rss_category = check_str($row["rss_category"]);
		$rss_sub_category = check_str($row["rss_sub_category"]);
		$rss_title = check_str($row["rss_title"]);
		$rss_link = check_str($row["rss_link"]);
		$rss_description = check_str($row["rss_desc"]);
		$rss_img = check_str($row["rss_img"]);
		$rss_optional_1 = check_str($row["rss_optional_1"]);
		$rss_optional_2 = check_str($row["rss_optional_2"]);
		$rss_optional_3 = check_str($row["rss_optional_3"]);
		$rss_optional_4 = check_str($row["rss_optional_4"]);
		$rss_optional_5 = check_str($row["rss_optional_5"]);
		$rss_add_date = check_str($row["rss_add_date"]);
		$rss_add_user = check_str($row["rss_add_user"]);
		$rss_del_date = check_str($row["rss_del_date"]);
		$rss_del_user = check_str($row["rss_del_user"]);
		$rss_order = check_str($row["rss_order"]);
		$rss_content = check_str($row["rss_content"]);
		$rss_group = check_str($row["rss_group"]);

		//set the rss_uuid
		$rss_array[$rss_id]['rss_uuid'] = $rss_uuid;

		$sql = "insert into v_rss ";
		$sql .= "(";
		$sql .= "rss_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "rss_language, ";
		$sql .= "rss_category, ";
		$sql .= "rss_sub_category, ";
		$sql .= "rss_title, ";
		$sql .= "rss_link, ";
		$sql .= "rss_description, ";
		$sql .= "rss_img, ";
		$sql .= "rss_optional_1, ";
		$sql .= "rss_optional_2, ";
		$sql .= "rss_optional_3, ";
		$sql .= "rss_optional_4, ";
		$sql .= "rss_optional_5, ";
		$sql .= "rss_add_date, ";
		$sql .= "rss_add_user, ";
		$sql .= "rss_del_date, ";
		$sql .= "rss_del_user, ";
		$sql .= "rss_order, ";
		$sql .= "rss_content, ";
		$sql .= "rss_group ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$rss_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$rss_language."', ";
		$sql .= "'".$rss_category."', ";
		$sql .= "'".$rss_sub_category."', ";
		$sql .= "'".$rss_title."', ";
		$sql .= "'".$rss_link."', ";
		$sql .= "'".$rss_description."', ";
		$sql .= "'".$rss_img."', ";
		$sql .= "'".$rss_optional_1."', ";
		$sql .= "'".$rss_optional_2."', ";
		$sql .= "'".$rss_optional_3."', ";
		$sql .= "'".$rss_optional_4."', ";
		$sql .= "'".$rss_optional_5."', ";
		$sql .= "'".$rss_add_date."', ";
		$sql .= "'".$rss_add_user."', ";
		$sql .= "'".$rss_del_date."', ";
		$sql .= "'".$rss_del_user."', ";
		$sql .= "'".$rss_order."', ";
		$sql .= "'".$rss_content."', ";
		$sql .= "'".$rss_group."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the rss sub data
	$sql = "select * from v_rss_sub ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$rss_sub_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$rss_id = check_str($row["rss_id"]);
		$rss_sub_language = check_str($row["rss_sub_language"]);
		$rss_sub_title = check_str($row["rss_sub_title"]);
		$rss_sub_link = check_str($row["rss_sub_link"]);
		$rss_sub_description = check_str($row["rss_sub_desc"]);
		$rss_sub_optional_1 = check_str($row["rss_sub_optional_1"]);
		$rss_sub_optional_2 = check_str($row["rss_sub_optional_2"]);
		$rss_sub_optional_3 = check_str($row["rss_sub_optional_3"]);
		$rss_sub_optional_4 = check_str($row["rss_sub_optional_4"]);
		$rss_sub_optional_5 = check_str($row["rss_sub_optional_5"]);
		$rss_sub_add_date = check_str($row["rss_sub_add_date"]);
		$rss_sub_add_user = check_str($row["rss_sub_add_user"]);
		$rss_sub_del_user = check_str($row["rss_sub_del_user"]);
		$rss_sub_del_date = check_str($row["rss_sub_del_date"]);

		//get the rss_uuid
		$rss_uuid = $rss_array[$rss_id]['rss_uuid'];

		$sql = "insert into v_rss_sub ";
		$sql .= "(";
		$sql .= "rss_sub_uuid, ";
		$sql .= "rss_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "rss_sub_language, ";
		$sql .= "rss_sub_title, ";
		$sql .= "rss_sub_link, ";
		$sql .= "rss_sub_description, ";
		$sql .= "rss_sub_optional_1, ";
		$sql .= "rss_sub_optional_2, ";
		$sql .= "rss_sub_optional_3, ";
		$sql .= "rss_sub_optional_4, ";
		$sql .= "rss_sub_optional_5, ";
		$sql .= "rss_sub_add_date, ";
		$sql .= "rss_sub_add_user, ";
		$sql .= "rss_sub_del_user, ";
		$sql .= "rss_sub_del_date ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$rss_sub_uuid."', ";
		$sql .= "'".$rss_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$rss_sub_language."', ";
		$sql .= "'".$rss_sub_title."', ";
		$sql .= "'".$rss_sub_link."', ";
		$sql .= "'".$rss_sub_description."', ";
		$sql .= "'".$rss_sub_optional_1."', ";
		$sql .= "'".$rss_sub_optional_2."', ";
		$sql .= "'".$rss_sub_optional_3."', ";
		$sql .= "'".$rss_sub_optional_4."', ";
		$sql .= "'".$rss_sub_optional_5."', ";
		$sql .= "'".$rss_sub_add_date."', ";
		$sql .= "'".$rss_sub_add_user."', ";
		$sql .= "'".$rss_sub_del_user."', ";
		$sql .= "'".$rss_sub_del_date."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the rss sub category data
	$sql = "select * from v_rss_sub_category ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$rss_sub_category_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$rss_sub_category_language = check_str($row["rss_sub_category_language"]);
		$rss_category = check_str($row["rss_category"]);
		$rss_sub_category = check_str($row["rss_sub_category"]);
		$rss_sub_category_description = check_str($row["rss_sub_category_desc"]);
		$rss_sub_add_user = check_str($row["rss_sub_add_user"]);
		$rss_sub_add_date = check_str($row["rss_sub_add_date"]);

		$sql = "insert into v_rss_sub_category ";
		$sql .= "(";
		$sql .= "rss_sub_category_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "rss_sub_category_language, ";
		$sql .= "rss_category, ";
		$sql .= "rss_sub_category, ";
		$sql .= "rss_sub_category_description, ";
		$sql .= "rss_sub_add_user, ";
		$sql .= "rss_sub_add_date ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$rss_sub_category_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$rss_sub_category_language."', ";
		$sql .= "'".$rss_category."', ";
		$sql .= "'".$rss_sub_category."', ";
		$sql .= "'".$rss_sub_category_description."', ";
		$sql .= "'".$rss_sub_add_user."', ";
		$sql .= "'".$rss_sub_add_date."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//get the database connection information
	$sql = "select * from v_database_connections ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$database_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$database_type = check_str($row["db_type"]);
		$database_host = check_str($row["db_host"]);
		$database_port = check_str($row["db_port"]);
		$database_name = check_str($row["db_name"]);
		$database_username = check_str($row["db_username"]);
		$database_password = check_str($row["db_password"]);
		$database_path = check_str($row["db_path"]);
		$database_description = check_str($row["db_description"]);

		$sql = "insert into v_databases ";
		$sql .= "(";
		$sql .= "database_uuid, ";
		$sql .= "database_type, ";
		$sql .= "database_host, ";
		$sql .= "database_port, ";
		$sql .= "database_name, ";
		$sql .= "database_username, ";
		$sql .= "database_password, ";
		$sql .= "database_path, ";
		$sql .= "database_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$database_uuid."', ";
		$sql .= "'".$database_type."', ";
		$sql .= "'".$database_host."', ";
		$sql .= "'".$database_port."', ";
		$sql .= "'".$database_name."', ";
		$sql .= "'".$database_username."', ";
		$sql .= "'".$database_password."', ";
		$sql .= "'".$database_path."', ";
		$sql .= "'".$database_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the dialplan
	$sql = "select * from v_dialplan_includes ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$dialplan_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$dialplan_include_id = check_str($row["dialplan_include_id"]);
		$app_uuid = '742714e5-8cdf-32fd-462c-cbe7e3d655db'; //dialplan app_uuid
		$dialplan_name = check_str($row["extension_name"]);
		$dialplan_number = check_str($row["extension_number"]);
		//$dialplan_context = check_str($row["context"]);
		$dialplan_continue = check_str($row["extension_continue"]);
		$dialplan_order = check_str($row["dialplan_order"]);
		$dialplan_enabled = check_str($row["enabled"]);
		$dialplan_description = check_str($row["descr"]);
		//$opt_1_name = check_str($row["opt_1_name"]);
		//$opt_1_value = check_str($row["opt_1_value"]);

		//set the dialplan order
		if ($dialplan_order < 320) { $dialplan_order = 320; }

		//set the dialplan_uuid
		$dialplan_array[$dialplan_include_id]['dialplan_uuid'] = $dialplan_uuid;

		//set the dialplan context
		if (count($domain_array) > 1) {
			$dialplan_context = $domain_array[$v_id]['domain_name'];
		}
		else {
			$dialplan_context = "default";
		}

		if (strlen($domain_uuid) > 0) {
			$sql = "insert into v_dialplans ";
			$sql .= "(";
			$sql .= "dialplan_uuid, ";
			$sql .= "domain_uuid, ";
			$sql .= "app_uuid, ";
			$sql .= "dialplan_name, ";
			$sql .= "dialplan_number, ";
			$sql .= "dialplan_context, ";
			$sql .= "dialplan_continue, ";
			$sql .= "dialplan_order, ";
			$sql .= "dialplan_enabled, ";
			$sql .= "dialplan_description ";
			$sql .= ")";
			$sql .= "values ";
			$sql .= "(";
			$sql .= "'".$dialplan_uuid."', ";
			$sql .= "'".$domain_uuid."', ";
			$sql .= "'".$app_uuid."', ";
			$sql .= "'".$dialplan_name."', ";
			$sql .= "'".$dialplan_number."', ";
			$sql .= "'".$dialplan_context."', ";
			$sql .= "'".$dialplan_continue."', ";
			$sql .= "'".$dialplan_order."', ";
			$sql .= "'".$dialplan_enabled."', ";
			$sql .= "'".$dialplan_description."' ";
			$sql .= ")";
			if ($export_type == "sql") { echo check_sql($sql).";\n"; }
			if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
		}
	}
	unset ($prep_statement);

//export the dialplan details
	$sql = "select * from v_dialplan_includes_details ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$dialplan_detail_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$dialplan_include_id = check_str($row["dialplan_include_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$dialplan_detail_tag = check_str($row["tag"]);
		$dialplan_detail_type = check_str($row["field_type"]);
		$dialplan_detail_data = check_str($row["field_data"]);
		$dialplan_detail_break = check_str($row["field_break"]);
		$dialplan_detail_inline = check_str($row["field_inline"]);
		$dialplan_detail_group = check_str($row["field_group"]);
		$dialplan_detail_order = check_str($row["field_order"]);
		//	$dialplan_detail_data = str_replace("\\\\", "\\", $dialplan_detail_data);

		//get the dialplan_uuid
		$dialplan_uuid = $dialplan_array[$dialplan_include_id]['dialplan_uuid'];

		if (strlen($domain_uuid) > 0 && strlen($dialplan_uuid) > 0 ) {
			$sql = "insert into v_dialplan_details ";
			$sql .= "(";
			$sql .= "dialplan_detail_uuid, ";
			$sql .= "domain_uuid, ";
			$sql .= "dialplan_uuid, ";
			$sql .= "dialplan_detail_tag, ";
			$sql .= "dialplan_detail_type, ";
			$sql .= "dialplan_detail_data, ";
			$sql .= "dialplan_detail_break, ";
			$sql .= "dialplan_detail_inline, ";
			$sql .= "dialplan_detail_group, ";
			$sql .= "dialplan_detail_order ";
			$sql .= ")";
			$sql .= "values ";
			$sql .= "(";
			$sql .= "'".$dialplan_detail_uuid."', ";
			$sql .= "'".$domain_uuid."', ";
			$sql .= "'".$dialplan_uuid."', ";
			$sql .= "'".$dialplan_detail_tag."', ";
			$sql .= "'".$dialplan_detail_type."', ";
			$sql .= "'".$dialplan_detail_data."', ";
			$sql .= "'".$dialplan_detail_break."', ";
			$sql .= "'".$dialplan_detail_inline."', ";
			if (strlen($dialplan_detail_group) > 0) {
				$sql .= "'".$dialplan_detail_group."', ";
			}
			else {
				$sql .= "null, ";
			}
			if (strlen($dialplan_detail_order) > 0) {
				$sql .= "'".$dialplan_detail_order."' ";
			}
			else {
				$sql .= "'330' ";
			}
			$sql .= ")";
			if ($export_type == "sql") { echo check_sql($sql).";\n"; }
			if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
		}
	}
	unset ($prep_statement);

//export the inbound routes
	$sql = "select * from v_public_includes ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$public_include_id = $row["public_include_id"];
		$dialplan_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$app_uuid = 'c03b422e-13a8-bd1b-e42b-b6b9b4d27ce4';
		$dialplan_name = check_str($row["extension_name"]);
		$dialplan_context = 'public';
		$dialplan_continue = check_str($row["extension_continue"]);
		$dialplan_order = check_str($row["public_order"]);
		$dialplan_enabled = check_str($row["enabled"]);
		$dialplan_description = check_str($row["descr"]);

		//set the dialplan_uuid
		$public_dialplan_array[$public_include_id]['dialplan_uuid'] = $dialplan_uuid;

		$sql = "insert into v_dialplans ";
		$sql .= "(";
		$sql .= "dialplan_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "app_uuid, ";
		$sql .= "dialplan_name, ";
		$sql .= "dialplan_context, ";
		$sql .= "dialplan_continue, ";
		$sql .= "dialplan_order, ";
		$sql .= "dialplan_enabled, ";
		$sql .= "dialplan_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$dialplan_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$app_uuid."', ";
		$sql .= "'".$dialplan_name."', ";
		$sql .= "'".$dialplan_context."', ";
		$sql .= "'".$dialplan_continue."', ";
		$sql .= "'".$dialplan_order."', ";
		$sql .= "'".$dialplan_enabled."', ";
		$sql .= "'".$dialplan_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export inbound route details
	$sql = "select * from v_public_includes_details ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$dialplan_detail_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$public_include_id = check_str($row["public_include_id"]);
		$dialplan_detail_tag = check_str($row["tag"]);
		$dialplan_detail_type = check_str($row["field_type"]);
		$dialplan_detail_data = check_str($row["field_data"]);
		$dialplan_detail_break = check_str($row["field_break"]);
		$dialplan_detail_inline = check_str($row["field_inline"]);
		$dialplan_detail_group = check_str($row["field_group"]);
		$dialplan_detail_order = check_str($row["field_order"]);

		//get the dialplan_uuid
		$dialplan_uuid = $public_dialplan_array[$public_include_id]['dialplan_uuid'];

		$sql = "insert into v_dialplan_details ";
		$sql .= "(";
		$sql .= "dialplan_detail_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "dialplan_uuid, ";
		$sql .= "dialplan_detail_tag, ";
		$sql .= "dialplan_detail_type, ";
		$sql .= "dialplan_detail_data, ";
		$sql .= "dialplan_detail_break, ";
		$sql .= "dialplan_detail_inline, ";
		$sql .= "dialplan_detail_group, ";
		$sql .= "dialplan_detail_order ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$dialplan_detail_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$dialplan_uuid."', ";
		$sql .= "'".$dialplan_detail_tag."', ";
		$sql .= "'".$dialplan_detail_type."', ";
		$sql .= "'".$dialplan_detail_data."', ";
		$sql .= "'".$dialplan_detail_break."', ";
		$sql .= "'".$dialplan_detail_inline."', ";
		if (strlen($dialplan_detail_group) > 0) {
			$sql .= "'".$dialplan_detail_group."', ";
		}
		else {
			$sql .= "null, ";
		}
		if (strlen($dialplan_detail_order) > 0) {
			$sql .= "'".$dialplan_detail_order."' ";
		}
		else {
			$sql .= "null ";
		}
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//set the app_uuid for the dialplan outbound route
	$sql = "select * from v_dialplan_includes_details ";
	$sql .= "where (";
	$sql .= "field_data like '%sofia/gateway/%' ";
	$sql .= "or field_data like '%freetdm%' ";
	$sql .= "or field_data like '%openzap%' ";
	$sql .= "or field_data like '%dingaling%' ";
	$sql .= "or field_data like '%enum_auto_route%' ";
	$sql .= ") ";
	$prepstatement = $db->prepare(check_sql($sql));
	$prepstatement->execute();
	$result = $prepstatement->fetchAll();
	foreach ($result as &$row) {
		$dialplan_include_id = check_str($row["dialplan_include_id"]);

		//get the dialplan_uuid
		$dialplan_uuid = $dialplan_array[$dialplan_include_id]['dialplan_uuid'];

		$sql = "update v_dialplans set ";
		$sql .= "app_uuid = '8c914ec3-9fc0-8ab5-4cda-6c9288bdc9a3' ";
		$sql .= "where dialplan_uuid = '$dialplan_uuid'";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
		unset($sql);
	}
	unset ($prepstatement);

//export the extensions
	$sql = "select * from v_extensions ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$extension_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$extension = check_str($row["extension"]);
		$number_alias = check_str($row["number_alias"]);
		$password = check_str($row["password"]);
		$user_list = check_str($row["user_list"]);
		$provisioning_list = check_str($row["provisioning_list"]);
		$mailbox = check_str($row["mailbox"]);
		$vm_password = check_str($row["vm_password"]);
		$accountcode = check_str($row["accountcode"]);
		$effective_caller_id_name = check_str($row["effective_caller_id_name"]);
		$effective_caller_id_number = check_str($row["effective_caller_id_number"]);
		$outbound_caller_id_name = check_str($row["outbound_caller_id_name"]);
		$outbound_caller_id_number = check_str($row["outbound_caller_id_number"]);
		$limit_max = check_str($row["limit_max"]);
		$limit_destination = check_str($row["limit_destination"]);
		$vm_enabled = check_str($row["vm_enabled"]);
		$vm_mailto = check_str($row["vm_mailto"]);
		$vm_attach_file = check_str($row["vm_attach_file"]);
		$vm_keep_local_after_email = check_str($row["vm_keep_local_after_email"]);
		$user_context = check_str($row["user_context"]);
		$toll_allow = check_str($row["toll_allow"]);
		$call_group = check_str($row["callgroup"]);
		$hold_music = check_str($row["hold_music"]);
		$auth_acl = check_str($row["auth_acl"]);
		$cidr = check_str($row["cidr"]);
		$sip_force_contact = check_str($row["sip_force_contact"]);
		$nibble_account = check_str($row["nibble_account"]);
		$sip_force_expires = check_str($row["sip_force_expires"]);
		$enabled = check_str($row["enabled"]);
		$description = check_str($row["description"]);
		$mwi_account = check_str($row["mwi_account"]);
		$sip_bypass_media = check_str($row["sip_bypass_media"]);

		$sql = "insert into v_extensions ";
		$sql .= "(";
		$sql .= "extension_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "extension, ";
		$sql .= "number_alias, ";
		$sql .= "password, ";
		$sql .= "provisioning_list, ";
		$sql .= "mailbox, ";
		$sql .= "vm_password, ";
		$sql .= "accountcode, ";
		$sql .= "effective_caller_id_name, ";
		$sql .= "effective_caller_id_number, ";
		$sql .= "outbound_caller_id_name, ";
		$sql .= "outbound_caller_id_number, ";
		$sql .= "limit_max, ";
		$sql .= "limit_destination, ";
		$sql .= "vm_enabled, ";
		$sql .= "vm_mailto, ";
		$sql .= "vm_attach_file, ";
		$sql .= "vm_keep_local_after_email, ";
		$sql .= "user_context, ";
		$sql .= "toll_allow, ";
		$sql .= "call_group, ";
		$sql .= "hold_music, ";
		$sql .= "auth_acl, ";
		$sql .= "cidr, ";
		$sql .= "sip_force_contact, ";
		$sql .= "nibble_account, ";
		$sql .= "sip_force_expires, ";
		$sql .= "enabled, ";
		$sql .= "description, ";
		$sql .= "mwi_account, ";
		$sql .= "sip_bypass_media ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$extension_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$extension."', ";
		$sql .= "'".$number_alias."', ";
		$sql .= "'".$password."', ";
		$sql .= "'".$provisioning_list."', ";
		$sql .= "'".$mailbox."', ";
		$sql .= "'".$vm_password."', ";
		$sql .= "'".$accountcode."', ";
		$sql .= "'".$effective_caller_id_name."', ";
		$sql .= "'".$effective_caller_id_number."', ";
		$sql .= "'".$outbound_caller_id_name."', ";
		$sql .= "'".$outbound_caller_id_number."', ";
		if (strlen($limit_max) > 0) {
			$sql .= "'".$limit_max."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$limit_destination."', ";
		$sql .= "'".$vm_enabled."', ";
		$sql .= "'".$vm_mailto."', ";
		$sql .= "'".$vm_attach_file."', ";
		$sql .= "'".$vm_keep_local_after_email."', ";
		$sql .= "'".$user_context."', ";
		$sql .= "'".$toll_allow."', ";
		$sql .= "'".$call_group."', ";
		$sql .= "'".$hold_music."', ";
		$sql .= "'".$auth_acl."', ";
		$sql .= "'".$cidr."', ";
		$sql .= "'".$sip_force_contact."', ";
		if (strlen($nibble_account) > 0) {
			$sql .= "'".$nibble_account."', ";
		}
		else {
			$sql .= "null, ";
		}
		if (strlen($sip_force_expires) > 0) {
			$sql .= "'".$sip_force_expires."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$enabled."', ";
		$sql .= "'".$description."', ";
		$sql .= "'".$mwi_account."', ";
		$sql .= "'".$sip_bypass_media."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }

		$user_list_array = explode("|", $user_list);
		foreach($user_list_array as $username){
			if (strlen($username) > 0) {
				$user_uuid = $user_array[$v_id][$username]['user_uuid'];
				if (strlen($user_uuid) > 0) {
					$sql = "insert into v_extension_users ";
					$sql .= "(";
					$sql .= "extension_user_uuid, ";
					$sql .= "domain_uuid, ";
					$sql .= "extension_uuid, ";
					$sql .= "user_uuid ";
					$sql .= ")";
					$sql .= "values ";
					$sql .= "(";
					$sql .= "'".uuid()."', ";
					$sql .= "'".$domain_uuid."', ";
					$sql .= "'".$extension_uuid."', ";
					$sql .= "'".$user_uuid."' ";
					$sql .= ")";
					if ($export_type == "sql") { echo check_sql($sql).";\n"; }
					if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
				}
			}
		}
		unset($user_list_array, $username, $extension_uuid);
	}
	unset ($prep_statement);

//get the conference identifiers
	$sql = "select * from v_dialplan_includes_details ";
	$sql .= "where field_data like 'conference_user_list%' ";
	$prepstatement = $db->prepare(check_sql($sql));
	$prepstatement->execute();
	$x = 0;
	$result = $prepstatement->fetchAll();
	foreach ($result as &$row) {
		$dialplan_include_id = $row["dialplan_include_id"];
		$field_type = $row["field_type"];
		$conference_array[$x]['dialplan_include_id'] = $dialplan_include_id;
		$x++;
	}
	unset ($prepstatement);

//get the conferences
	$sql = "select * from v_dialplan_includes ";
	$x = 0;
	foreach ($conference_array as &$row) {
		if ($x == 0) {
			$sql .= " where dialplan_include_id = '".$row['dialplan_include_id']."' \n";
		}
		else {
			$sql .= " or dialplan_include_id = '".$row['dialplan_include_id']."' \n";
		}
		$x++;
	}
	$sql .= "order by dialplan_order, extension_name asc ";
	$prep_statement = $db->prepare(check_sql($sql));
	$prep_statement->execute();
	$result = $prep_statement->fetchAll();
	foreach ($result as &$tmp) {
		//get the values from the database
			$v_id = check_str($tmp["v_id"]);
			$dialplan_include_id = check_str($tmp["dialplan_include_id"]);
		//get the dialplan
			$sql = "select * from v_dialplan_includes ";
			$sql .= "where v_id = '$v_id' ";
			$sql .= "and dialplan_include_id = '$dialplan_include_id' ";
			$row = $db->query($sql)->fetch();
			$conference_name = $row['extension_name'];
			$conference_name = str_replace("-", " ", $conference_name);
			//$context = $row['context'];
			$conference_order = $row['dialplan_order'];
			$conference_enabled = $row['enabled'];
			$conference_description = $row['descr'];
		//get the dialplan details
			$sql = "select * from v_dialplan_includes_details ";
			$sql .= "where v_id = '$v_id' ";
			$sql .= "and dialplan_include_id = '$dialplan_include_id' ";
			$prepstatement = $db->prepare(check_sql($sql));
			$prepstatement->execute();
			$result_details = $prepstatement->fetchAll();
			foreach ($result_details as &$row) {
				if ($row['field_type'] == "destination_number") {
					$conference_extension = $row['field_data'];
					$conference_extension = trim($conference_extension, '^$');
				}
				$field_data_array = explode("=", $row['field_data']);
				if ($field_data_array[0] == "conference_user_list") {
					$user_list = $field_data_array[1];
				}
				if ($row['field_type'] == "conference") {
					$field_data = $row['field_data'];
					$tmp_pos = stripos($field_data, "@");
					if ($tmp_pos !== false) {
						$tmp_field_data = substr($field_data, $tmp_pos+1, strlen($field_data));
						$tmp_field_data_array = explode("+",$tmp_field_data);
						foreach ($tmp_field_data_array as &$tmp_row) {
							if (is_numeric($tmp_row)) {
								$conference_pin_number = $tmp_row;
							}
							if (substr($tmp_row, 0, 5) == "flags") {
								$conference_flags = substr($tmp_row, 6, $tmp_row-1);
							}
						}
						$conference_profile = $tmp_field_data_array[0];
					}
				}
			}
		//get the uuids
			$dialplan_uuid = $dialplan_array[$dialplan_include_id]['dialplan_uuid'];
			$domain_uuid = $domain_array[$v_id]['domain_uuid'];
			$conference_uuid = uuid();
		//add the conference
			$sql = "insert into v_conferences ";
			$sql .= "(";
			$sql .= "domain_uuid, ";
			$sql .= "conference_uuid, ";
			$sql .= "dialplan_uuid, ";
			$sql .= "conference_name, ";
			$sql .= "conference_extension, ";
			$sql .= "conference_pin_number, ";
			$sql .= "conference_profile, ";
			$sql .= "conference_flags, ";
			$sql .= "conference_order, ";
			$sql .= "conference_description, ";
			$sql .= "conference_enabled ";
			$sql .= ")";
			$sql .= "values ";
			$sql .= "(";
			$sql .= "'$domain_uuid', ";
			$sql .= "'$conference_uuid', ";
			$sql .= "'$dialplan_uuid', ";
			$sql .= "'$conference_name', ";
			$sql .= "'$conference_extension', ";
			$sql .= "'$conference_pin_number', ";
			$sql .= "'$conference_profile', ";
			$sql .= "'$conference_flags', ";
			$sql .= "'$conference_order', ";
			$sql .= "'$conference_description', ";
			$sql .= "'$conference_enabled' ";
			$sql .= ")";
			if ($export_type == "sql") { echo check_sql($sql).";\n"; }
			if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }

		//add the assigned users to the conference
			$user_list_array = explode("|", $user_list);
			foreach($user_list_array as $username){
				if (strlen($username) > 0) {
					$user_uuid = $user_array[$v_id][$username]['user_uuid'];
					if (strlen($user_uuid) > 0) {
						$sql = "insert into v_conference_users ";
						$sql .= "(";
						$sql .= "conference_user_uuid, ";
						$sql .= "domain_uuid, ";
						$sql .= "conference_uuid, ";
						$sql .= "user_uuid ";
						$sql .= ")";
						$sql .= "values ";
						$sql .= "(";
						$sql .= "'".uuid()."', ";
						$sql .= "'".$domain_uuid."', ";
						$sql .= "'".$conference_uuid."', ";
						$sql .= "'".$user_uuid."' ";
						$sql .= ")";
						if ($export_type == "sql") { echo check_sql($sql).";\n"; }
						if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
					}
				}
			}
			unset($user_list_array);
	}
	unset ($prepstatement, $result, $sql, $user_list);

//get the fax information
	$sql = "select * from v_fax ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$fax_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$fax_extension = check_str($row["fax_extension"]);
		$fax_name = check_str($row["fax_name"]);
		$fax_email = check_str($row["fax_email"]);
		$fax_pin_number = check_str($row["fax_pin_number"]);
		$fax_caller_id_name = check_str($row["fax_caller_id_name"]);
		$fax_caller_id_number = check_str($row["fax_caller_id_number"]);
		$fax_user_list = check_str($row["fax_user_list"]);
		$fax_forward_number = check_str($row["fax_forward_number"]);
		$fax_description = check_str($row["fax_description"]);

		$sql = "insert into v_fax ";
		$sql .= "(";
		$sql .= "fax_uuid, ";
		$sql .= "domain_uuid, ";
		//dialplan_uuid
		$sql .= "fax_extension, ";
		$sql .= "fax_name, ";
		$sql .= "fax_email, ";
		$sql .= "fax_pin_number, ";
		$sql .= "fax_caller_id_name, ";
		$sql .= "fax_caller_id_number, ";
		$sql .= "fax_forward_number, ";
		$sql .= "fax_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$fax_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		//dialplan_uuid
		$sql .= "'".$fax_extension."', ";
		$sql .= "'".$fax_name."', ";
		$sql .= "'".$fax_email."', ";
		$sql .= "'".$fax_pin_number."', ";
		$sql .= "'".$fax_caller_id_name."', ";
		$sql .= "'".$fax_caller_id_number."', ";
		if (strlen($fax_forward_number) > 0) {
			$sql .= "'".$fax_forward_number."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$fax_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }

		$user_list_array = explode("|", $fax_user_list);
		foreach($user_list_array as $username){
			if (strlen($username) > 0) {
				$user_uuid = $user_array[$v_id][$username]['user_uuid'];
				if (strlen($user_uuid) > 0) {
					$sql = "insert into v_fax_users ";
					$sql .= "(";
					$sql .= "fax_user_uuid, ";
					$sql .= "domain_uuid, ";
					$sql .= "fax_uuid, ";
					$sql .= "user_uuid ";
					$sql .= ")";
					$sql .= "values ";
					$sql .= "(";
					$sql .= "'".uuid()."', ";
					$sql .= "'".$domain_uuid."', ";
					$sql .= "'".$fax_uuid."', ";
					$sql .= "'".$user_uuid."' ";
					$sql .= ")";
					if ($export_type == "sql") { echo check_sql($sql).";\n"; }
					if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
				}
			}
		}
		unset($user_list_array);
		unset($username);
	}
	unset ($prep_statement);

//export the gateways
	$sql = "select * from v_gateways ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$gateway_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$gateway = check_str($row["gateway"]);
		$username = check_str($row["username"]);
		$password = check_str($row["password"]);
		$auth_username = check_str($row["auth_username"]);
		$realm = check_str($row["realm"]);
		$from_user = check_str($row["from_user"]);
		$from_domain = check_str($row["from_domain"]);
		$proxy = check_str($row["proxy"]);
		$register_proxy = check_str($row["register_proxy"]);
		$outbound_proxy = check_str($row["outbound_proxy"]);
		$expire_seconds = check_str($row["expire_seconds"]);
		$register = check_str($row["register"]);
		$register_transport = check_str($row["register_transport"]);
		$retry_seconds = check_str($row["retry_seconds"]);
		$extension = check_str($row["extension"]);
		$ping = check_str($row["ping"]);
		$caller_id_in_from = check_str($row["caller_id_in_from"]);
		$supress_cng = check_str($row["supress_cng"]);
		$sip_cid_type = check_str($row["sip_cid_type"]);
		$extension_in_contact = check_str($row["extension_in_contact"]);
		$context = check_str($row["context"]);
		$profile = check_str($row["profile"]);
		$enabled = check_str($row["enabled"]);
		$description = check_str($row["description"]);

		$sql = "insert into v_gateways ";
		$sql .= "(";
		$sql .= "gateway_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "gateway, ";
		$sql .= "username, ";
		$sql .= "password, ";
		$sql .= "auth_username, ";
		$sql .= "realm, ";
		$sql .= "from_user, ";
		$sql .= "from_domain, ";
		$sql .= "proxy, ";
		$sql .= "register_proxy, ";
		$sql .= "outbound_proxy, ";
		$sql .= "expire_seconds, ";
		$sql .= "register, ";
		$sql .= "register_transport, ";
		$sql .= "retry_seconds, ";
		$sql .= "extension, ";
		$sql .= "ping, ";
		$sql .= "caller_id_in_from, ";
		$sql .= "supress_cng, ";
		$sql .= "sip_cid_type, ";
		$sql .= "extension_in_contact, ";
		$sql .= "context, ";
		$sql .= "profile, ";
		$sql .= "enabled, ";
		$sql .= "description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$gateway_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$gateway."', ";
		$sql .= "'".$username."', ";
		$sql .= "'".$password."', ";
		$sql .= "'".$auth_username."', ";
		$sql .= "'".$realm."', ";
		$sql .= "'".$from_user."', ";
		$sql .= "'".$from_domain."', ";
		$sql .= "'".$proxy."', ";
		$sql .= "'".$register_proxy."', ";
		$sql .= "'".$outbound_proxy."', ";
		$sql .= "'".$expire_seconds."', ";
		$sql .= "'".$register."', ";
		$sql .= "'".$register_transport."', ";
		$sql .= "'".$retry_seconds."', ";
		$sql .= "'".$extension."', ";
		$sql .= "'".$ping."', ";
		$sql .= "'".$caller_id_in_from."', ";
		$sql .= "'".$supress_cng."', ";
		$sql .= "'".$sip_cid_type."', ";
		$sql .= "'".$extension_in_contact."', ";
		$sql .= "'".$context."', ";
		$sql .= "'".$profile."', ";
		$sql .= "'".$enabled."', ";
		$sql .= "'".$description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the provisioning information
	$sql = "select * from v_hardware_phones ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$hardware_phone_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$phone_mac_address = check_str($row["phone_mac_address"]);
		$phone_label = check_str($row["phone_label"]);
		$phone_vendor = check_str($row["phone_vendor"]);
		$phone_model = check_str($row["phone_model"]);
		$phone_firmware_version = check_str($row["phone_firmware_version"]);
		$phone_provision_enable = check_str($row["phone_provision_enable"]);
		$phone_template = check_str($row["phone_template"]);
		$phone_username = check_str($row["phone_username"]);
		$phone_password = check_str($row["phone_password"]);
		$phone_time_zone = check_str($row["phone_time_zone"]);
		$phone_description = check_str($row["phone_description"]);

		$sql = "insert into v_hardware_phones ";
		$sql .= "(";
		$sql .= "hardware_phone_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "phone_mac_address, ";
		$sql .= "phone_label, ";
		$sql .= "phone_vendor, ";
		$sql .= "phone_model, ";
		$sql .= "phone_firmware_version, ";
		$sql .= "phone_provision_enable, ";
		$sql .= "phone_template, ";
		$sql .= "phone_username, ";
		$sql .= "phone_password, ";
		$sql .= "phone_time_zone, ";
		$sql .= "phone_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$hardware_phone_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$phone_mac_address."', ";
		$sql .= "'".$phone_label."', ";
		$sql .= "'".$phone_vendor."', ";
		$sql .= "'".$phone_model."', ";
		$sql .= "'".$phone_firmware_version."', ";
		$sql .= "'".$phone_provision_enable."', ";
		$sql .= "'".$phone_template."', ";
		$sql .= "'".$phone_username."', ";
		$sql .= "'".$phone_password."', ";
		$sql .= "'".$phone_time_zone."', ";
		$sql .= "'".$phone_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the hunt groups
	$sql = "select * from v_hunt_group ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$hunt_group_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$hunt_group_extension = check_str($row["hunt_group_extension"]);
		$hunt_group_id = check_str($row["hunt_group_id"]);
		$hunt_group_name = check_str($row["hunt_group_name"]);
		$hunt_group_type = check_str($row["hunt_group_type"]);
		$hunt_group_context = check_str($row["hunt_group_context"]);
		$hunt_group_timeout = check_str($row["hunt_group_timeout"]);
		$hunt_group_timeout_destination = check_str($row["hunt_group_timeout_destination"]);
		$hunt_group_timeout_type = check_str($row["hunt_group_time_out_type"]);
		$hunt_group_ringback = check_str($row["hunt_group_ringback"]);
		$hunt_group_cid_name_prefix = check_str($row["hunt_group_cid_name_prefix"]);
		$hunt_group_pin = check_str($row["hunt_group_pin"]);
		$hunt_group_caller_announce = check_str($row["hunt_group_caller_announce"]);
		$hunt_group_call_prompt = check_str($row["hunt_group_call_prompt"]);
		$hunt_group_user_list = check_str($row["hunt_group_user_list"]);
		$hunt_group_enabled = check_str($row["hunt_group_enabled"]);
		$hunt_group_description = check_str($row["hunt_group_descr"]);

		//set the hunt_group_uuid
		$hunt_group_array[$hunt_group_id]['hunt_group_uuid'] = $hunt_group_uuid;

		$sql = "insert into v_hunt_groups ";
		$sql .= "(";
		$sql .= "hunt_group_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "hunt_group_extension, ";
		$sql .= "hunt_group_name, ";
		$sql .= "hunt_group_type, ";
		$sql .= "hunt_group_context, ";
		$sql .= "hunt_group_timeout, ";
		$sql .= "hunt_group_timeout_destination, ";
		$sql .= "hunt_group_timeout_type, ";
		$sql .= "hunt_group_ringback, ";
		$sql .= "hunt_group_cid_name_prefix, ";
		$sql .= "hunt_group_pin, ";
		$sql .= "hunt_group_caller_announce, ";
		$sql .= "hunt_group_call_prompt, ";
		$sql .= "hunt_group_user_list, ";
		$sql .= "hunt_group_enabled, ";
		$sql .= "hunt_group_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$hunt_group_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$hunt_group_extension."', ";
		$sql .= "'".$hunt_group_name."', ";
		$sql .= "'".$hunt_group_type."', ";
		$sql .= "'".$hunt_group_context."', ";
		$sql .= "'".$hunt_group_timeout."', ";
		$sql .= "'".$hunt_group_timeout_destination."', ";
		$sql .= "'".$hunt_group_timeout_type."', ";
		$sql .= "'".$hunt_group_ringback."', ";
		$sql .= "'".$hunt_group_cid_name_prefix."', ";
		$sql .= "'".$hunt_group_pin."', ";
		$sql .= "'".$hunt_group_caller_announce."', ";
		$sql .= "'".$hunt_group_call_prompt."', ";
		$sql .= "'".$hunt_group_user_list."', ";
		$sql .= "'".$hunt_group_enabled."', ";
		$sql .= "'".$hunt_group_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the hunt group destinations
	$sql = "select * from v_hunt_group_destinations ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$hunt_group_destination_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$hunt_group_id = check_str($row["hunt_group_id"]);
		$destination_data = check_str($row["destination_data"]);
		$destination_type = check_str($row["destination_type"]);
		$destination_profile = check_str($row["destination_profile"]);
		$destination_timeout = check_str($row["destination_timeout"]);
		$destination_order = check_str($row["destination_order"]);
		$destination_enabled = check_str($row["destination_enabled"]);
		$destination_description = check_str($row["destination_descr"]);

		//get the hunt_group_uuid
		$hunt_group_uuid = $hunt_group_array[$hunt_group_id]['hunt_group_uuid'];

		$sql = "insert into v_hunt_group_destinations ";
		$sql .= "(";
		$sql .= "hunt_group_destination_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "hunt_group_uuid, ";
		$sql .= "destination_data, ";
		$sql .= "destination_type, ";
		$sql .= "destination_profile, ";
		$sql .= "destination_timeout, ";
		$sql .= "destination_order, ";
		$sql .= "destination_enabled, ";
		$sql .= "destination_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$hunt_group_destination_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$hunt_group_uuid."', ";
		$sql .= "'".$destination_data."', ";
		$sql .= "'".$destination_type."', ";
		$sql .= "'".$destination_profile."', ";
		$sql .= "'".$destination_timeout."', ";
		if (strlen($destination_order) > 0) {
			$sql .= "'".$destination_order."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$destination_enabled."', ";
		$sql .= "'".$destination_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the invoices
	if ($invoices) {
		//get the invoices and insert them
			$sql = "select * from v_invoices ";
			$prep_statement = $db->prepare($sql);
			$prep_statement->execute();
			$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
			foreach ($result as &$row) {
				$invoice_id = check_str($row["invoice_id"]);
				//set the invoice_uuid
				$invoice_array[$invoice_id]['uuid'] = uuid();
			}
			foreach ($result as &$row) {
				$invoice_id = check_str($row["invoice_id"]);
				$invoice_uuid = uuid();
				$v_id = check_str($row["v_id"]);
				$domain_uuid = $domain_array[$v_id]['domain_uuid'];
				$contact_id_from = check_str($row["contact_id_from"]);
				$contact_id_to = check_str($row["contact_id_to"]);
				$invoice_number = check_str($row["invoice_number"]);
				$invoice_date = check_str($row["invoice_date"]);
				$invoice_notes = check_str($row["invoice_notes"]);

				//get the uuids
				$invoice_uuid = $invoice_array[$invoice_id]['uuid'];
				$contact_uuid_from = $contact_array[$contact_id_from]['contact_uuid'];
				$contact_uuid_to = $contact_array[$contact_id_to]['contact_uuid'];

				$sql = "insert into v_invoices ";
				$sql .= "(";
				$sql .= "invoice_uuid, ";
				$sql .= "domain_uuid, ";
				$sql .= "contact_uuid_from, ";
				$sql .= "contact_uuid_to, ";
				$sql .= "invoice_number, ";
				$sql .= "invoice_date, ";
				$sql .= "invoice_notes ";
				$sql .= ")";
				$sql .= "values ";
				$sql .= "(";
				$sql .= "'".$invoice_uuid."', ";
				$sql .= "'".$domain_uuid."', ";
				if (strlen($contact_uuid_from) > 0) {
					$sql .= "'".$contact_uuid_from."', ";
				}
				else {
					$sql .= "null, ";
				}
				if (strlen($contact_uuid_to) > 0) {
					$sql .= "'".$contact_uuid_to."', ";
				}
				else {
					$sql .= "null, ";
				}
				if (strlen($invoice_number) > 0) {
					$sql .= "'".$invoice_number."', ";
				}
				else {
					$sql .= "null, ";
				}
				$sql .= "'".$invoice_date."', ";
				$sql .= "'".$invoice_notes."' ";
				$sql .= ")";
				if ($export_type == "sql") { echo check_sql($sql).";\n"; }
				if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
			}
			unset ($prep_statement);

		//export invoice items
			$sql = "select * from v_invoice_items ";
			$prep_statement = $db->prepare($sql);
			$prep_statement->execute();
			$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
			foreach ($result as &$row) {
				$invoice_item_uuid = uuid();
				$v_id = check_str($row["v_id"]);
				$domain_uuid = $domain_array[$v_id]['domain_uuid'];
				$invoice_id = check_str($row["invoice_id"]);
				$item_qty = check_str($row["item_qty"]);
				$item_description = check_str($row["item_desc"]);
				$item_unit_price = check_str($row["item_unit_price"]);

				//get the invoice_uuid
				$invoice_uuid = $invoice_array[$invoice_id]['uuid'];

				$sql = "insert into v_invoice_items ";
				$sql .= "(";
				$sql .= "invoice_item_uuid, ";
				$sql .= "domain_uuid, ";
				$sql .= "invoice_uuid, ";
				$sql .= "item_qty, ";
				$sql .= "item_desc, ";
				$sql .= "item_unit_price ";
				$sql .= ")";
				$sql .= "values ";
				$sql .= "(";
				$sql .= "'".$invoice_item_uuid."', ";
				$sql .= "'".$domain_uuid."', ";
				$sql .= "'".$invoice_uuid."', ";
				if (strlen($item_qty) > 0) {
					$sql .= "'".$item_qty."', ";
				}
				else {
					$sql .= "null, ";
				}
				$sql .= "'".$item_desc."', ";
				if (strlen($item_unit_price) > 0) {
					$sql .= "'".$item_unit_price."' ";
				}
				else {
					$sql .= "null ";
				}
				$sql .= ")";
				if ($export_type == "sql") { echo check_sql($sql).";\n"; }
				if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
			}
			unset ($prep_statement);
	}

//export the ivr menus
	$sql = "select * from v_ivr_menu ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$ivr_menu_id = check_str($row["ivr_menu_id"]);
		$ivr_menu_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$ivr_menu_name = check_str($row["ivr_menu_name"]);
		$ivr_menu_extension = check_str($row["ivr_menu_extension"]);
		$ivr_menu_greet_long = check_str($row["ivr_menu_greet_long"]);
		$ivr_menu_greet_short = check_str($row["ivr_menu_greet_short"]);
		$ivr_menu_invalid_sound = check_str($row["ivr_menu_invalid_sound"]);
		$ivr_menu_exit_sound = check_str($row["ivr_menu_exit_sound"]);
		$ivr_menu_confirm_macro = check_str($row["ivr_menu_confirm_macro"]);
		$ivr_menu_confirm_key = check_str($row["ivr_menu_confirm_key"]);
		$ivr_menu_tts_engine = check_str($row["ivr_menu_tts_engine"]);
		$ivr_menu_tts_voice = check_str($row["ivr_menu_tts_voice"]);
		$ivr_menu_confirm_attempts = check_str($row["ivr_menu_confirm_attempts"]);
		$ivr_menu_timeout = check_str($row["ivr_menu_timeout"]);
		$ivr_menu_exit_app = check_str($row["ivr_menu_exit_app"]);
		$ivr_menu_exit_data = check_str($row["ivr_menu_exit_data"]);
		$ivr_menu_inter_digit_timeout = check_str($row["ivr_menu_inter_digit_timeout"]);
		$ivr_menu_max_failures = check_str($row["ivr_menu_max_failures"]);
		$ivr_menu_max_timeouts = check_str($row["ivr_menu_max_timeouts"]);
		$ivr_menu_digit_len = check_str($row["ivr_menu_digit_len"]);
		$ivr_menu_direct_dial = check_str($row["ivr_menu_direct_dial"]);
		$ivr_menu_enabled = check_str($row["ivr_menu_enabled"]);
		$ivr_menu_description = check_str($row["ivr_menu_desc"]);

		//set the ivr_menu_uuid
		$ivr_menu_array[$ivr_menu_id]['ivr_menu_uuid'] = $ivr_menu_uuid;

		$sql = "insert into v_ivr_menus ";
		$sql .= "(";
		$sql .= "ivr_menu_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "ivr_menu_name, ";
		$sql .= "ivr_menu_extension, ";
		$sql .= "ivr_menu_greet_long, ";
		$sql .= "ivr_menu_greet_short, ";
		$sql .= "ivr_menu_invalid_sound, ";
		$sql .= "ivr_menu_exit_sound, ";
		$sql .= "ivr_menu_confirm_macro, ";
		$sql .= "ivr_menu_confirm_key, ";
		$sql .= "ivr_menu_tts_engine, ";
		$sql .= "ivr_menu_tts_voice, ";
		$sql .= "ivr_menu_confirm_attempts, ";
		$sql .= "ivr_menu_timeout, ";
		$sql .= "ivr_menu_exit_app, ";
		$sql .= "ivr_menu_exit_data, ";
		$sql .= "ivr_menu_inter_digit_timeout, ";
		$sql .= "ivr_menu_max_failures, ";
		$sql .= "ivr_menu_max_timeouts, ";
		$sql .= "ivr_menu_digit_len, ";
		$sql .= "ivr_menu_direct_dial, ";
		$sql .= "ivr_menu_enabled, ";
		$sql .= "ivr_menu_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$ivr_menu_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$ivr_menu_name."', ";
		$sql .= "'".$ivr_menu_extension."', ";
		$sql .= "'".$ivr_menu_greet_long."', ";
		$sql .= "'".$ivr_menu_greet_short."', ";
		$sql .= "'".$ivr_menu_invalid_sound."', ";
		$sql .= "'".$ivr_menu_exit_sound."', ";
		$sql .= "'".$ivr_menu_confirm_macro."', ";
		$sql .= "'".$ivr_menu_confirm_key."', ";
		$sql .= "'".$ivr_menu_tts_engine."', ";
		$sql .= "'".$ivr_menu_tts_voice."', ";
		$sql .= "'".$ivr_menu_confirm_attempts."', ";
		$sql .= "'".$ivr_menu_timeout."', ";
		$sql .= "'".$ivr_menu_exit_app."', ";
		$sql .= "'".$ivr_menu_exit_data."', ";
		$sql .= "'".$ivr_menu_inter_digit_timeout."', ";
		$sql .= "'".$ivr_menu_max_failures."', ";
		$sql .= "'".$ivr_menu_max_timeouts."', ";
		$sql .= "'".$ivr_menu_digit_len."', ";
		$sql .= "'".$ivr_menu_direct_dial."', ";
		$sql .= "'".$ivr_menu_enabled."', ";
		$sql .= "'".$ivr_menu_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the ivr menu options
	$sql = "select * from v_ivr_menu_options ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$ivr_menu_option_uuid = uuid();
		$ivr_menu_id = check_str($row["ivr_menu_id"]);
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$ivr_menu_option_digits = check_str($row["ivr_menu_options_digits"]);
		$ivr_menu_option_action = check_str($row["ivr_menu_options_action"]);
		$ivr_menu_option_param = check_str($row["ivr_menu_options_param"]);
		$ivr_menu_option_order = check_str($row["ivr_menu_options_order"]);
		$ivr_menu_option_description = check_str($row["ivr_menu_options_desc"]);
		//$ivr_menu_options_action = str_replace("\\\\", "\\", $ivr_menu_options_action);


		//get the ivr_menu_uuid
		$ivr_menu_uuid = $ivr_menu_array[$ivr_menu_id]['ivr_menu_uuid'];

		$sql = "insert into v_ivr_menu_options ";
		$sql .= "(";
		$sql .= "ivr_menu_option_uuid, ";
		$sql .= "ivr_menu_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "ivr_menu_option_digits, ";
		$sql .= "ivr_menu_option_action, ";
		$sql .= "ivr_menu_option_param, ";
		$sql .= "ivr_menu_option_order, ";
		$sql .= "ivr_menu_option_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$ivr_menu_option_uuid."', ";
		$sql .= "'".$ivr_menu_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$ivr_menu_option_digits."', ";
		$sql .= "'".$ivr_menu_option_action."', ";
		$sql .= "'".$ivr_menu_option_param."', ";
		$sql .= "'".$ivr_menu_option_order."', ";
		$sql .= "'".$ivr_menu_option_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the modules
	$sql = "select * from v_modules ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$module_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$module_label = check_str($row["module_label"]);
		$module_name = check_str($row["module_name"]);
		$module_description = check_str($row["module_desc"]);
		$module_category = check_str($row["module_category"]);
		$module_enabled = check_str($row["module_enabled"]);
		$module_default_enabled = check_str($row["module_default_enabled"]);

		$sql = "insert into v_modules ";
		$sql .= "(";
		$sql .= "module_uuid, ";
		$sql .= "module_label, ";
		$sql .= "module_name, ";
		$sql .= "module_description, ";
		$sql .= "module_category, ";
		$sql .= "module_enabled, ";
		$sql .= "module_default_enabled ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$module_uuid."', ";
		$sql .= "'".$module_label."', ";
		$sql .= "'".$module_name."', ";
		$sql .= "'".$module_description."', ";
		$sql .= "'".$module_category."', ";
		$sql .= "'".$module_enabled."', ";
		$sql .= "'".$module_default_enabled."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export to php services
	$sql = "select * from v_php_service ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$php_service_uuid = uuid();
		$service_name = check_str($row["service_name"]);
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$service_script = check_str($row["service_script"]);
		$service_enabled = check_str($row["service_enabled"]);
		$service_description = check_str($row["service_description"]);

		$sql = "insert into v_php_services ";
		$sql .= "(";
		$sql .= "php_service_uuid, ";
		$sql .= "service_name, ";
		$sql .= "domain_uuid, ";
		$sql .= "service_script, ";
		$sql .= "service_enabled, ";
		$sql .= "service_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$php_service_uuid."', ";
		$sql .= "'".$service_name."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$service_script."', ";
		$sql .= "'".$service_enabled."', ";
		$sql .= "'".$service_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the recordings
	$sql = "select * from v_recordings ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$recording_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$recording_filename = check_str($row["recording_filename"]);
		$recording_name = check_str($row["recording_name"]);
		$recording_description = check_str($row["recording_desc"]);

		$sql = "insert into v_recordings ";
		$sql .= "(";
		$sql .= "recording_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "recording_filename, ";
		$sql .= "recording_name, ";
		$sql .= "recording_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$recording_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$recording_filename."', ";
		$sql .= "'".$recording_name."', ";
		$sql .= "'".$recording_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the services
	$sql = "select * from v_services ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$service_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$service_name = check_str($row["v_service_name"]);
		$service_type = check_str($row["v_service_type"]);
		$service_data = check_str($row["v_service_data"]);
		$service_cmd_start = check_str($row["v_service_cmd_start"]);
		$service_cmd_stop = check_str($row["v_service_cmd_stop"]);
		$service_cmd_restart = check_str($row["v_service_cmd_restart"]);
		$service_description = check_str($row["v_service_desc"]);

		$sql = "insert into v_services ";
		$sql .= "(";
		$sql .= "service_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "service_name, ";
		$sql .= "service_type, ";
		$sql .= "service_data, ";
		$sql .= "service_cmd_start, ";
		$sql .= "service_cmd_stop, ";
		$sql .= "service_cmd_restart, ";
		$sql .= "service_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$service_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$service_name."', ";
		$sql .= "'".$service_type."', ";
		$sql .= "'".$service_data."', ";
		$sql .= "'".$service_cmd_start."', ";
		$sql .= "'".$service_cmd_stop."', ";
		$sql .= "'".$service_cmd_restart."', ";
		$sql .= "'".$service_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the settings
	$sql = "select * from v_settings ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$numbering_plan = check_str($row["numbering_plan"]);
		$smtp_password = check_str($row["default_gateway"]);
		$event_socket_ip_address = check_str($row["event_socket_ip_address"]);
		$event_socket_port = check_str($row["event_socket_port"]);
		$event_socket_password = check_str($row["event_socket_password"]);
		$xml_rpc_http_port = check_str($row["xml_rpc_http_port"]);
		$xml_rpc_auth_realm = check_str($row["xml_rpc_auth_realm"]);
		$xml_rpc_auth_user = check_str($row["xml_rpc_auth_user"]);
		$xml_rpc_auth_pass = check_str($row["xml_rpc_auth_pass"]);
		$admin_pin = check_str($row["admin_pin"]);
		$smtp_host = check_str($row["smtp_host"]);
		$smtp_secure = check_str($row["smtp_secure"]);
		$smtp_auth = check_str($row["smtp_auth"]);
		$smtp_username = check_str($row["smtp_username"]);
		$smtp_password = check_str($row["smtp_password"]);
		$smtp_from = check_str($row["smtp_from"]);
		$smtp_from_name = check_str($row["smtp_from_name"]);
		$mod_shout_decoder = check_str($row["mod_shout_decoder"]);
		$mod_shout_volume = check_str($row["mod_shout_volume"]);

		$sql = "insert into v_settings ";
		$sql .= "(";
		$sql .= "numbering_plan, ";
		$sql .= "event_socket_ip_address, ";
		$sql .= "event_socket_port, ";
		$sql .= "event_socket_password, ";
		$sql .= "xml_rpc_http_port, ";
		$sql .= "xml_rpc_auth_realm, ";
		$sql .= "xml_rpc_auth_user, ";
		$sql .= "xml_rpc_auth_pass, ";
		$sql .= "admin_pin, ";
		$sql .= "smtp_host, ";
		$sql .= "smtp_secure, ";
		$sql .= "smtp_auth, ";
		$sql .= "smtp_username, ";
		$sql .= "smtp_password, ";
		$sql .= "smtp_from, ";
		$sql .= "smtp_from_name, ";
		$sql .= "mod_shout_decoder, ";
		$sql .= "mod_shout_volume ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$numbering_plan."', ";
		$sql .= "'".$event_socket_ip_address."', ";
		$sql .= "'".$event_socket_port."', ";
		$sql .= "'".$event_socket_password."', ";
		$sql .= "'".$xml_rpc_http_port."', ";
		$sql .= "'".$xml_rpc_auth_realm."', ";
		$sql .= "'".$xml_rpc_auth_user."', ";
		$sql .= "'".$xml_rpc_auth_pass."', ";
		$sql .= "'".$admin_pin."', ";
		$sql .= "'".$smtp_host."', ";
		$sql .= "'".$smtp_secure."', ";
		$sql .= "'".$smtp_auth."', ";
		$sql .= "'".$smtp_username."', ";
		$sql .= "'".$smtp_password."', ";
		$sql .= "'".$smtp_from."', ";
		$sql .= "'".$smtp_from_name."', ";
		$sql .= "'".$mod_shout_decoder."', ";
		$sql .= "'".$mod_shout_volume."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//get the time conditions and use diaplan_uuid to set the app_uuid
	$sql = "select * from v_dialplan_includes_details ";
	$prepstatement = $db->prepare(check_sql($sql));
	$prepstatement->execute();
	$x = 0;
	$result = $prepstatement->fetchAll();
	foreach ($result as &$row) {
		$dialplan_include_id = $row["dialplan_include_id"];
		$field_type = $row["field_type"];
		//$field_data = $row["field_data"];

		//get the dialplan_uuid
		$dialplan_uuid = $dialplan_array[$dialplan_include_id]['dialplan_uuid'];

		switch ($row['field_type']) {
		case "hour":
			$time_array[$x]['dialplan_uuid'] = $dialplan_uuid;
			$x++;
			break;
		case "minute":
			$time_array[$x]['dialplan_uuid'] = $dialplan_uuid;
			$x++;
			break;
		case "minute-of-day":
			$time_array[$x]['dialplan_uuid'] = $dialplan_uuid;
			$x++;
			break;
		case "mday":
			$time_array[$x]['dialplan_uuid'] = $dialplan_uuid;
			$x++;
			break;
		case "mweek":
			$time_array[$x]['dialplan_uuid'] = $dialplan_uuid;
			$x++;
			break;
		case "mon":
			$time_array[$x]['dialplan_uuid'] = $dialplan_uuid;
			$x++;
			break;
		case "yday":
			$time_array[$x]['dialplan_uuid'] = $dialplan_uuid;
			$x++;
			break;
		case "year":
			$time_array[$x]['dialplan_uuid'] = $dialplan_uuid;
			$x++;
			break;
		case "wday":
			$time_array[$x]['dialplan_uuid'] = $dialplan_uuid;
			$x++;
			break;
		case "week":
			$time_array[$x]['dialplan_uuid'] = $dialplan_uuid;
			$x++;
			break;
		}
	}
	unset ($prepstatement);
	foreach ($time_array as &$row) {
		$sql = "update v_dialplans set ";
		$sql .= "app_uuid = '4b821450-926b-175a-af93-a03c441818b1' ";
		$sql .= "where dialplan_uuid = '".$row['dialplan_uuid']."' ";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
		unset($sql);
	}

//get the variables
	$sql = "select * from v_vars ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$var_uuid = uuid();
		$var_name = check_str($row["var_name"]);
		$var_value = check_str($row["var_value"]);
		$var_cat = check_str($row["var_cat"]);
		$var_enabled = check_str($row["var_enabled"]);
		$var_order = check_str($row["var_order"]);
		$var_description = check_str($row["var_desc"]);

		$sql = "insert into v_vars ";
		$sql .= "(";
		$sql .= "var_uuid, ";
		$sql .= "var_name, ";
		$sql .= "var_value, ";
		$sql .= "var_cat, ";
		$sql .= "var_enabled, ";
		$sql .= "var_order, ";
		$sql .= "var_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$var_uuid."', ";
		$sql .= "'".$var_name."', ";
		$sql .= "'".$var_value."', ";
		$sql .= "'".$var_cat."', ";
		$sql .= "'".$var_enabled."', ";
		$sql .= "'".$var_order."', ";
		$sql .= "'".$var_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the virtual tables
	$sql = "select * from v_virtual_tables ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$virtual_table_id = check_str($row["virtual_table_id"]);
		$virtual_table_uuid = uuid();

		//set the virtual_table_uuid
		$virtual_table_array[$virtual_table_id]['virtual_table_uuid'] = $virtual_table_uuid;
	}
	foreach ($result as &$row) {
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$virtual_table_id = check_str($row["virtual_table_id"]);
		$virtual_table_category = check_str($row["virtual_table_category"]);
		$virtual_table_label = check_str($row["virtual_table_label"]);
		$virtual_table_name = check_str($row["virtual_table_name"]);
		$virtual_table_auth = check_str($row["virtual_table_auth"]);
		$virtual_table_captcha = check_str($row["virtual_table_captcha"]);
		$virtual_table_parent_id = check_str($row["virtual_table_parent_id"]);
		$virtual_table_description = check_str($row["virtual_table_desc"]);

		//get the uuids
		$virtual_table_uuid = $virtual_table_array[$virtual_table_id]['virtual_table_uuid'];
		if (strlen($virtual_table_parent_id) > 0) {
			$virtual_table_parent_uuid = $virtual_table_array[$virtual_table_parent_id]['virtual_table_uuid'];
		}

		$sql = "insert into v_virtual_tables ";
		$sql .= "(";
		$sql .= "virtual_table_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "virtual_table_category, ";
		$sql .= "virtual_table_label, ";
		$sql .= "virtual_table_name, ";
		$sql .= "virtual_table_auth, ";
		$sql .= "virtual_table_captcha, ";
		$sql .= "virtual_table_parent_uuid, ";
		$sql .= "virtual_table_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$virtual_table_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$virtual_table_category."', ";
		$sql .= "'".$virtual_table_label."', ";
		$sql .= "'".$virtual_table_name."', ";
		$sql .= "'".$virtual_table_auth."', ";
		$sql .= "'".$virtual_table_captcha."', ";
		if (strlen($virtual_table_parent_uuid) > 0) {
			$sql .= "'".$virtual_table_parent_uuid."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$virtual_table_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//export the virtual table fields
	$sql = "select * from v_virtual_table_fields ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$virtual_table_field_id = check_str($row["virtual_table_field_id"]);
		$virtual_table_field_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$virtual_table_id = check_str($row["virtual_table_id"]);
		$virtual_field_label = check_str($row["virtual_field_label"]);
		$virtual_field_name = check_str($row["virtual_field_name"]);
		$virtual_field_type = check_str($row["virtual_field_type"]);
		$virtual_field_list_hidden = check_str($row["virtual_field_list_hidden"]);
		$virtual_field_column = check_str($row["virtual_field_column"]);
		$virtual_field_required = check_str($row["virtual_field_required"]);
		$virtual_field_order = check_str($row["virtual_field_order"]);
		$virtual_field_order_tab = check_str($row["virtual_field_order_tab"]);
		$virtual_field_description = check_str($row["virtual_field_desc"]);
		$virtual_field_value = check_str($row["virtual_field_value"]);

		//get the virtual_table_uuid
		$virtual_table_uuid = $virtual_table_array[$virtual_table_id]['virtual_table_uuid'];

		//set virtual_table_field_uuid
		$virtual_table_field_array[$virtual_table_field_id]['virtual_table_field_uuid'] = $virtual_table_field_uuid;
		if (strlen($virtual_table_uuid) > 0) {
			$sql = "insert into v_virtual_table_fields ";
			$sql .= "(";
			$sql .= "virtual_table_field_uuid, ";
			$sql .= "domain_uuid, ";
			$sql .= "virtual_table_uuid, ";
			$sql .= "virtual_field_label, ";
			$sql .= "virtual_field_name, ";
			$sql .= "virtual_field_type, ";
			$sql .= "virtual_field_list_hidden, ";
			$sql .= "virtual_field_column, ";
			$sql .= "virtual_field_required, ";
			$sql .= "virtual_field_order, ";
			$sql .= "virtual_field_order_tab, ";
			$sql .= "virtual_field_description, ";
			$sql .= "virtual_field_value ";
			$sql .= ")";
			$sql .= "values ";
			$sql .= "(";
			$sql .= "'".$virtual_table_field_uuid."', ";
			$sql .= "'".$domain_uuid."', ";
			$sql .= "'".$virtual_table_uuid."', ";
			$sql .= "'".$virtual_field_label."', ";
			$sql .= "'".$virtual_field_name."', ";
			$sql .= "'".$virtual_field_type."', ";
			$sql .= "'".$virtual_field_list_hidden."', ";
			$sql .= "'".$virtual_field_column."', ";
			$sql .= "'".$virtual_field_required."', ";
			$sql .= "'".$virtual_field_order."', ";
			$sql .= "'".$virtual_field_order_tab."', ";
			$sql .= "'".$virtual_field_description."', ";
			$sql .= "'".$virtual_field_value."' ";
			$sql .= ")";
			if ($export_type == "sql") { echo check_sql($sql).";\n"; }
			if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
		}
	}
	unset ($prep_statement);

//export the virtual table data
	$sql = "select * from v_virtual_table_data ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	while($row = $prep_statement->fetch(PDO::FETCH_ASSOC)) {
		$virtual_table_data_id = check_str($row["virtual_table_data_id"]);
		$virtual_table_data_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$virtual_table_id = check_str($row["virtual_table_id"]);
		$virtual_data_row_id = check_str($row["virtual_data_row_id"]);
		$virtual_field_name = check_str($row["virtual_field_name"]);
		$virtual_data_field_value = check_str($row["virtual_data_field_value"]);
		$virtual_data_add_user = check_str($row["virtual_data_add_user"]);
		$virtual_data_add_date = check_str($row["virtual_data_add_date"]);
		$virtual_data_del_user = check_str($row["virtual_data_del_user"]);
		$virtual_data_del_date = check_str($row["virtual_data_del_date"]);
		$virtual_table_parent_id = check_str($row["virtual_table_parent_id"]);
		$virtual_data_parent_row_uuid = check_str($row["virtual_data_parent_row_id"]);

		//get the virtual_table_uuid
		$virtual_table_uuid = $virtual_table_array[$virtual_table_id]['virtual_table_uuid'];
		if (strlen($virtual_table_parent_id) > 0) {
			$virtual_table_parent_uuid = $virtual_table_array[$virtual_table_parent_id]['virtual_table_uuid'];
		}

		//get or set the virtual table data row uuid
		if (strlen($virtual_table_array[$virtual_data_row_id]['virtual_data_row_uuid']) == 0) {
			$virtual_data_row_uuid = uuid();
			$virtual_table_array[$virtual_data_row_id]['virtual_data_row_uuid'] = $virtual_data_row_uuid;
		}
		else {
			$virtual_data_row_uuid = $virtual_table_array[$virtual_data_row_id]['virtual_data_row_uuid'];
		}

		$sql = "insert into v_virtual_table_data ";
		$sql .= "(";
		$sql .= "virtual_table_data_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "virtual_table_uuid, ";
		$sql .= "virtual_data_row_uuid, ";
		$sql .= "virtual_field_name, ";
		$sql .= "virtual_data_field_value, ";
		$sql .= "virtual_table_parent_uuid, ";
		$sql .= "virtual_data_parent_row_uuid, ";
		$sql .= "virtual_data_add_user, ";
		$sql .= "virtual_data_add_date, ";
		$sql .= "virtual_data_del_user, ";
		$sql .= "virtual_data_del_date ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$virtual_table_data_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$virtual_table_uuid."', ";
		$sql .= "'".$virtual_data_row_uuid."', ";
		$sql .= "'".$virtual_field_name."', ";
		$sql .= "'".$virtual_data_field_value."', ";
		if (strlen($virtual_table_parent_uuid) > 0) {
			$sql .= "'".$virtual_table_parent_uuid."', ";
		}
		else {
			$sql .= "null, ";
		}
		if (strlen($virtual_data_parent_row_uuid) > 0) {
			$sql .= "'".$virtual_data_parent_row_uuid."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$virtual_data_add_user."', ";
		$sql .= "'".$virtual_data_add_date."', ";
		$sql .= "'".$virtual_data_del_user."', ";
		$sql .= "'".$virtual_data_del_date."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//get the virtual table data name value pairs
	$sql = "select * from v_virtual_table_data_types_name_value ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$virtual_table_data_types_name_value_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$virtual_table_id = check_str($row["virtual_table_id"]);
		$virtual_table_field_id = check_str($row["virtual_table_field_id"]);
		$virtual_data_types_name = check_str($row["virtual_data_types_name"]);
		$virtual_data_types_value = check_str($row["virtual_data_types_value"]);

		//get the virtual_table_uuid
		$virtual_table_uuid = $virtual_table_array[$virtual_table_id]['virtual_table_uuid'];

		//get the virtual_table_field_uuid
		$virtual_table_field_uuid = $virtual_table_field_array[$virtual_table_field_id]['virtual_table_field_uuid'];
		if (strlen($virtual_table_uuid) > 0 && strlen($virtual_table_field_uuid) > 0) {
			$sql = "insert into v_virtual_table_data_types_name_value ";
			$sql .= "(";
			$sql .= "virtual_table_data_types_name_value_uuid, ";
			$sql .= "domain_uuid, ";
			$sql .= "virtual_table_uuid, ";
			$sql .= "virtual_table_field_uuid, ";
			$sql .= "virtual_data_types_name, ";
			$sql .= "virtual_data_types_value ";
			$sql .= ")";
			$sql .= "values ";
			$sql .= "(";
			$sql .= "'".$virtual_table_data_types_name_value_uuid."', ";
			$sql .= "'".$domain_uuid."', ";
			$sql .= "'".$virtual_table_uuid."', ";
			$sql .= "'".$virtual_table_field_uuid."', ";
			$sql .= "'".$virtual_data_types_name."', ";
			$sql .= "'".$virtual_data_types_value."' ";
			$sql .= ")";
			if ($export_type == "sql") { echo check_sql($sql).";\n"; }
			if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
		}
	}
	unset ($prep_statement);

//export voicemail greetings
	$sql = "select * from v_voicemail_greetings ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$greeting_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$user_id = check_str($row["user_id"]);
		$greeting_name = check_str($row["greeting_name"]);
		$greeting_description = check_str($row["greeting_description"]);

		$sql = "insert into v_voicemail_greetings ";
		$sql .= "(";
		$sql .= "greeting_uuid, ";
		$sql .= "user_id, ";
		$sql .= "domain_uuid, ";
		$sql .= "greeting_name, ";
		$sql .= "greeting_description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$greeting_uuid."', ";
		$sql .= "'".$user_id."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$greeting_name."', ";
		$sql .= "'".$greeting_description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//get the xmpp info
	$sql = "select * from v_xmpp ";
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	$result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
	foreach ($result as &$row) {
		$xmpp_profile_uuid = uuid();
		$v_id = check_str($row["v_id"]);
		$domain_uuid = $domain_array[$v_id]['domain_uuid'];
		$profile_name = check_str($row["profile_name"]);
		$username = check_str($row["username"]);
		$password = check_str($row["password"]);
		$dialplan = check_str($row["dialplan"]);
		$context = check_str($row["context"]);
		$rtp_ip = check_str($row["rtp_ip"]);
		$ext_rtp_ip = check_str($row["ext_rtp_ip"]);
		$auto_login = check_str($row["auto_login"]);
		$sasl_type = check_str($row["sasl_type"]);
		$xmpp_server = check_str($row["xmpp_server"]);
		$tls_enable = check_str($row["tls_enable"]);
		$usr_rtp_timer = check_str($row["usr_rtp_timer"]);
		$default_exten = check_str($row["default_exten"]);
		$vad = check_str($row["vad"]);
		$avatar = check_str($row["avatar"]);
		$candidate_acl = check_str($row["candidate_acl"]);
		$local_network_acl = check_str($row["local_network_acl"]);
		$enabled = check_str($row["enabled"]);
		$description = check_str($row["description"]);

		$sql = "insert into v_xmpp ";
		$sql .= "(";
		$sql .= "xmpp_profile_uuid, ";
		$sql .= "domain_uuid, ";
		$sql .= "profile_name, ";
		$sql .= "username, ";
		$sql .= "password, ";
		$sql .= "dialplan, ";
		$sql .= "context, ";
		$sql .= "rtp_ip, ";
		$sql .= "ext_rtp_ip, ";
		$sql .= "auto_login, ";
		$sql .= "sasl_type, ";
		$sql .= "xmpp_server, ";
		$sql .= "tls_enable, ";
		$sql .= "usr_rtp_timer, ";
		$sql .= "default_exten, ";
		$sql .= "vad, ";
		$sql .= "avatar, ";
		$sql .= "candidate_acl, ";
		$sql .= "local_network_acl, ";
		$sql .= "enabled, ";
		$sql .= "description ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$xmpp_profile_uuid."', ";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$profile_name."', ";
		$sql .= "'".$username."', ";
		$sql .= "'".$password."', ";
		$sql .= "'".$dialplan."', ";
		$sql .= "'".$context."', ";
		$sql .= "'".$rtp_ip."', ";
		$sql .= "'".$ext_rtp_ip."', ";
		$sql .= "'".$auto_login."', ";
		$sql .= "'".$sasl_type."', ";
		$sql .= "'".$xmpp_server."', ";
		$sql .= "'".$tls_enable."', ";
		$sql .= "'".$usr_rtp_timer."', ";
		$sql .= "'".$default_exten."', ";
		$sql .= "'".$vad."', ";
		$sql .= "'".$avatar."', ";
		$sql .= "'".$candidate_acl."', ";
		$sql .= "'".$local_network_acl."', ";
		$sql .= "'".$enabled."', ";
		$sql .= "'".$description."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//get the xml cdr info
	$sql = "select * from v_xml_cdr ";
	if ($debug) {
		$sql .= "limit 3 ";
	}
	$prep_statement = $db->prepare($sql);
	$prep_statement->execute();
	while($row = $prep_statement->fetch(PDO::FETCH_ASSOC)) {
		$uuid = check_str($row["v_id"]);
		$domain_name = check_str($row["domain_name"]);
		$accountcode = check_str($row["accountcode"]);
		$uuid = check_str($row["uuid"]);
		$direction = check_str($row["direction"]);
		$default_language = check_str($row["default_language"]);
		$context = check_str($row["context"]);
		$xml_cdr = check_str($row["xml_cdr"]);
		$caller_id_name = check_str($row["caller_id_name"]);
		$caller_id_number = check_str($row["caller_id_number"]);
		$destination_number = check_str($row["destination_number"]);
		$start_epoch = check_str($row["start_epoch"]);
		$start_stamp = check_str($row["start_stamp"]);
		$answer_stamp = check_str($row["answer_stamp"]);
		$answer_epoch = check_str($row["answer_epoch"]);
		$end_epoch = check_str($row["end_epoch"]);
		$end_stamp = check_str($row["end_stamp"]);
		$duration = check_str($row["duration"]);
		$mduration = check_str($row["mduration"]);
		$billsec = check_str($row["billsec"]);
		$billmsec = check_str($row["billmsec"]);
		$bridge_uuid = check_str($row["bridge_uuid"]);
		$read_codec = check_str($row["read_codec"]);
		$read_rate = check_str($row["read_rate"]);
		$write_codec = check_str($row["write_codec"]);
		$write_rate = check_str($row["write_rate"]);
		$remote_media_ip = check_str($row["remote_media_ip"]);
		$network_addr = check_str($row["network_addr"]);
		$recording_file = check_str($row["recording_file"]);
		$leg = check_str($row["leg"]);
		$pdd_ms = check_str($row["pdd_ms"]);
		$last_app = check_str($row["last_app"]);
		$last_arg = check_str($row["last_arg"]);
		$cc_side = check_str($row["cc_side"]);
		$cc_member_uuid = check_str($row["cc_member_uuid"]);
		$cc_queue_joined_epoch = check_str($row["cc_queue_joined_epoch"]);
		$cc_queue = check_str($row["cc_queue"]);
		$cc_member_session_uuid = check_str($row["cc_member_session_uuid"]);
		$cc_agent = check_str($row["cc_agent"]);
		$cc_agent_type = check_str($row["cc_agent_type"]);
		$waitsec = check_str($row["waitsec"]);
		$conference_name = check_str($row["conference_name"]);
		$conference_uuid = check_str($row["conference_uuid"]);
		$conference_member_id = check_str($row["conference_member_id"]);
		$digits_dialed = check_str($row["digits_dialed"]);
		$hangup_cause = check_str($row["hangup_cause"]);
		$hangup_cause_q850 = check_str($row["hangup_cause_q850"]);
		$sip_hangup_disposition = check_str($row["sip_hangup_disposition"]);

		$sql = "insert into v_xml_cdr ";
		$sql .= "(";
		$sql .= "domain_uuid, ";
		$sql .= "domain_name, ";
		$sql .= "accountcode, ";
		$sql .= "uuid, ";
		$sql .= "direction, ";
		$sql .= "default_language, ";
		$sql .= "context, ";
		$sql .= "xml_cdr, ";
		$sql .= "caller_id_name, ";
		$sql .= "caller_id_number, ";
		$sql .= "destination_number, ";
		$sql .= "start_epoch, ";
		$sql .= "start_stamp, ";
		$sql .= "answer_stamp, ";
		$sql .= "answer_epoch, ";
		$sql .= "end_epoch, ";
		$sql .= "end_stamp, ";
		$sql .= "duration, ";
		$sql .= "mduration, ";
		$sql .= "billsec, ";
		$sql .= "billmsec, ";
		$sql .= "bridge_uuid, ";
		$sql .= "read_codec, ";
		$sql .= "read_rate, ";
		$sql .= "write_codec, ";
		$sql .= "write_rate, ";
		$sql .= "remote_media_ip, ";
		$sql .= "network_addr, ";
		$sql .= "recording_file, ";
		$sql .= "leg, ";
		$sql .= "pdd_ms, ";
		$sql .= "last_app, ";
		$sql .= "last_arg, ";
		$sql .= "cc_side, ";
		$sql .= "cc_member_uuid, ";
		$sql .= "cc_queue_joined_epoch, ";
		$sql .= "cc_queue, ";
		$sql .= "cc_member_session_uuid, ";
		$sql .= "cc_agent, ";
		$sql .= "cc_agent_type, ";
		$sql .= "waitsec, ";
		$sql .= "conference_name, ";
		$sql .= "conference_uuid, ";
		$sql .= "conference_member_id, ";
		$sql .= "digits_dialed, ";
		$sql .= "hangup_cause, ";
		$sql .= "hangup_cause_q850, ";
		$sql .= "sip_hangup_disposition ";
		$sql .= ")";
		$sql .= "values ";
		$sql .= "(";
		$sql .= "'".$domain_uuid."', ";
		$sql .= "'".$domain_name."', ";
		$sql .= "'".$accountcode."', ";
		$sql .= "'".$uuid."', ";
		$sql .= "'".$direction."', ";
		$sql .= "'".$default_language."', ";
		$sql .= "'".$context."', ";
		$sql .= "'".$xml_cdr."', ";
		$sql .= "'".$caller_id_name."', ";
		$sql .= "'".$caller_id_number."', ";
		$sql .= "'".$destination_number."', ";
		$sql .= "'".$start_epoch."', ";
		if (strlen($start_stamp) > 0) {
			$sql .= "'".$start_stamp."', ";
		}
		else {
			$sql .= "null, ";
		}
		if (strlen($answer_stamp) > 0) {
			$sql .= "'".$answer_stamp."', ";
		}
		else {
			$sql .= "null, ";
		}
		if (strlen($answer_epoch) > 0) {
			$sql .= "'".$answer_epoch."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$end_epoch."', ";
		$sql .= "'".$end_stamp."', ";
		if (strlen($duration) > 0) {
			$sql .= "'".$duration."', ";
		}
		else {
			$sql .= "null, ";
		}
		if (strlen($mduration) > 0) {
			$sql .= "'".$mduration."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$billsec."', ";
		$sql .= "'".$billmsec."', ";
		$sql .= "'".$bridge_uuid."', ";
		$sql .= "'".$read_codec."', ";
		$sql .= "'".$read_rate."', ";
		$sql .= "'".$write_codec."', ";
		$sql .= "'".$write_rate."', ";
		$sql .= "'".$remote_media_ip."', ";
		$sql .= "'".$network_addr."', ";
		$sql .= "'".$recording_file."', ";
		$sql .= "'".$leg."', ";
		if (strlen($cc_member_uuid) > 0) {
			$sql .= "'".$pdd_ms."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$last_app."', ";
		$sql .= "'".$last_arg."', ";
		$sql .= "'".$cc_side."', ";
		if (strlen($cc_member_uuid) > 0) {
			$sql .= "'".$cc_member_uuid."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$cc_queue_joined_epoch."', ";
		$sql .= "'".$cc_queue."', ";
		if (strlen($cc_member_session_uuid) > 0) {
			$sql .= "'".$cc_member_session_uuid."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$cc_agent."', ";
		$sql .= "'".$cc_agent_type."', ";
		if (strlen($waitsec) > 0) {
			$sql .= "'".$waitsec."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$conference_name."', ";
		if (strlen($conference_uuid) > 0) {
			$sql .= "'".$conference_uuid."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$conference_member_id."', ";
		$sql .= "'".$digits_dialed."', ";
		$sql .= "'".$hangup_cause."', ";
		if (strlen($hangup_cause_q850) > 0) {
			$sql .= "'".$hangup_cause_q850."', ";
		}
		else {
			$sql .= "null, ";
		}
		$sql .= "'".$sip_hangup_disposition."' ";
		$sql .= ")";
		if ($export_type == "sql") { echo check_sql($sql).";\n"; }
		if ($export_type == "db") { $dest_db->exec(check_sql($sql)); }
	}
	unset ($prep_statement);

//used for debugging
	if ($debug) {
		echo "