rendered paste body function insert_wtf_information($order_id) { if(is_numeric($order_id)) { //------------------------- if(is_array($_SESSION["wtf"]) && count($_SESSION["wtf"]) > 0) { $referer_uri = tep_db_prepare_input($_SESSION["wtf"]["referer_uri"]); $referer_host = tep_db_prepare_input($_SESSION["wtf"]["referer_host"]); $referer_type = tep_db_prepare_input($_SESSION["wtf"]["referer_type"]); $referer_keywords = tep_db_prepare_input($_SESSION["wtf"]["referer_keywords"]); $ad_id = tep_db_prepare_input($_SESSION["wtf"]["ad_id"]); $parsed_uri = tep_db_prepare_input($_SESSION["wtf"]["parsed_uri"]); $get_variables = tep_db_prepare_input($_SESSION["wtf"]["get_variables"]); } //------------------------- $ip_address = tep_db_input(tep_db_prepare_input($this->ip_address)); $order_id = (int)$order_id; $domain_id = (int)$this->domain_id; $method_id = 3; // 3 = Online Method $total_visits = (int)$this->get_total_site_visits(); //------------------------- // Data for orders_source__orders table tep_db_query("INSERT INTO orders_source__orders (order_id,domain_id,method_id,number_of_visits,referer_uri,referer_type,get_variables,ip_address) values ('".$order_id."','".$domain_id."','".$method_id."','".$total_visits."','".$referer_uri."','".$referer_type."','".base64_encode(serialize($get_variables))."','".$ip_address."')"); //------------------------- // Data for orders_source__keywords table $orders_source_id = tep_db_insert_id(); if(isset($referer_keywords) && $referer_keywords != '') { tep_db_query("INSERT INTO orders_source__keywords (orders_source_id,keyword) values ('".$orders_source_id."','".$referer_keywords."')"); } } }