Hi Mark,
Great Contrib!!! :thumbsup:
I have a little question. In the source of supertracker.php (the one that is placed in the classes folder) I discovered a little piece of code at the end of the file I don't understand:
$time_arrived = date('Y-m-d H:i:s');
$landing_page = addslashes(tep_db_input(urldecode($_SERVER['REQUEST_URI'])));
$query = "INSERT INTO `supertracker` (`ip_address`, `browser_string`, `country_code`, `country_name`, `referrer`,`referrer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`) VALUES ('" . $ip . "','" . $browser_string . "','" . $country_code . "', '" . $country_name . "', '" . $referrer . "', '" . $query_string . "','" . $landing_page . "','" . $current_page . "','" . $time_arrived . "','" . $time_arrived . "')";
tep_db_query($query);
$refquery = "INSERT INTO `orders` (`orders_referrer`) VALUES ('" . $referrer . "')";
tep_db_query($refquery);
}//end if for prohibited pages
}//end else
}//End big If statement (Record Exclusion for certain IPs)
}//End function update
}//End Class
?>
The piece I was interested in was that where it says:
$refquery = "INSERT INTO `orders` (`orders_referrer`) VALUES ('" . $referrer . "')";
tep_db_query($refquery);
As I can say, it looks as it should update the table orders_referrer which should be in Orders. I could not find that you made this field in the setup and I made this field by hand. I hoped it would be filled with the referrer of the client that belonged with the order.
I was looking for a field that stored that information with the order. Can you (or maybe someone else) help me out a little where I could put a little code in your supertracker.php so that the referrer would be put in that table orders_referrer within the Orders table?
Kind regards!
Maurice