Some help implementing this tradetracker script please

[Dramacydril]

Hi,

I have this problem that i can solve.
I made a agreement with a trade tracker company (tracking pixel). They gave me a installation manual but i cant get it to work.
The following is from the manual meant for OSCOMMERCE, there isnt any zencart manual so i used this one since oscommerce looks a lot like zencart.
They also give me my campaignid & productid numbers + 2 php files (tradetracker.php and index.php)

================================================================================ =================

Contents of tradetracker.php: http://pastebin.com/QviZLxFy
Contents of index.php: http://pastebin.com/XLKq5GK0

Step 1
I put the index.php file in a new folder (root website) named BEVEILIGING (security in english)

Step 2
I put the tradetracker.php file in the INCLUDES folder just like the manual described.

Step 3 (tpl_checkout_success_default.php)
Put this code in the bottom of the page before the </body> tag. (there isnt a body tag by the way)

<!-- tradetracker //-->
<?php $campaignID = 'myownnumber'; $productID = 'myownnumber'; ?>
<?php $imageTag = include './includes/tradetracker.php'; echo $imageTag; ?>
<!-- tradetracker_eof //-->

So i did these steps with no problems.


================================================================================ =================

No i have my own tradetracker account where i can see if there are any sales made from the tracking cookie including. the order number, total price, email etc.

The problem is that i only see the clicks made but no SALE information. I tried a 100 times but still nothing. I think there's something wrong with the index.php file (sql codes). Im no php / mysql pro! Can somebody please tell me what im doing wrong?

Thank you 1000x