Where is the file location where this patch needs to be applied?Quote:
Replace
byCode:$db->Execute("UPDATE " . TABLE_SUPERTRACKER . " SET last_click = NOW(), exit_page='" . zen_db_input(zen_db_prepare_input(urldecode($_SERVER['REQUEST_URI']))) . "', exit_page_name='" . $page_title . "', num_clicks=num_clicks+1, added_cart='" . $tracking_data->fields['added_cart'] . "', categories_viewed='" . $categories_viewed . "', products_viewed='" . $tracking_data->fields['products_viewed'] . "', customer_id='" . $customer_id . "', completed_purchase='" . $completed_purchase . "', cart_contents='" . $cart_contents . "', cart_total = '" . $cart_total . "', order_id = '" . $order_id . "' WHERE tracking_id='" . $tracking_data->fields['tracking_id'] . "'");
Code:$db->Execute("UPDATE " . TABLE_SUPERTRACKER . "
SET last_click = NOW(),
exit_page='" . zen_db_input(zen_db_prepare_input(urldecode($_SERVER['REQUEST_URI']))) . "',
exit_page_name='" . $page_title . "',
num_clicks=num_clicks+1,
added_cart='" . zen_db_input($tracking_data->fields['added_cart']) . "',
categories_viewed='" . zen_db_input($categories_viewed) . "',
products_viewed='" . zen_db_input($tracking_data->fields['products_viewed']) . "',
customer_id='" . (int)$customer_id . "',
completed_purchase='" . zen_db_input($completed_purchase) . "',
cart_contents='" . zen_db_input($cart_contents) . "',
cart_total = '" . zen_db_input($cart_total) . "',
order_id = '" . (int)$order_id . "'
WHERE tracking_id='" . (int)$tracking_data->fields['tracking_id'] . "'");