Older Snapshot

[crshNbrn]

I am using a old snapshot tep_pr2.2_B20020224.zip , I have got this mod to work due to the great planning of the development team to allow old osc builds to function...THANKS FOR THAT. I had to make 1 or 2 edits to get it to work and have a couple of questions.

 

in affiliate_application_top.php this array seems to cause the problem.

 

if (!$link_to) $link_to = "0";

$sql_data_array = array('affiliate_id' => $affiliate_ref,

'affiliate_clientdate' => $affiliate_clientdate,

'affiliate_clientbrowser' => $affiliate_clientbrowser,

'affiliate_clientip' => $affiliate_clientip,

'affiliate_clientreferer' => $affiliate_clientreferer,

'affiliate_products_id' => $affiliate_products_id,

'affiliate_banner_id' => $affiliate_banner_id);

 

if i comment out //'affiliate_products_id' => $affiliate_products_id, all the banner links work fine but doing this makes it so the admin it will not show "clicked products" it then only shows why the user came as Startpage not the product_id image that was click.

Now if i use it as above code as is the problem is the link will work ref=1&products_id=3&affiliate_banner_id=1 , but an non product specific link will not ref=1&affiliate_banner_id=1 giving the error below .... note that the affiliate_products_id is then not present in the insert sql:

 

insert into affiliate_clickthroughs (affiliate_id, affiliate_clientdate, affiliate_clientbrowser, affiliate_clientip, affiliate_clientreferer, affiliate_products_id, affiliate_banner_id) values ('1', '2003-07-17 01:20:57', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; Win 9x 4.90)', '192.168.0.10', 'http://www.site.com/', , '1')

 

 

I tried playing with affiliate_products_id below but each way seemed to break another part.

 

if (!$link_to) $link_to = "0";

$sql_data_array = array('affiliate_id' => $affiliate_ref,

'affiliate_clientdate' => $affiliate_clientdate,

'affiliate_clientbrowser' => $affiliate_clientbrowser,

'affiliate_clientip' => $affiliate_clientip,

'affiliate_clientreferer' => $affiliate_clientreferer,

//'affiliate_products_id' => (!$affiliate_products_id) ? '0' : $affiliate_products_id,

//'affiliate_products_id' => '0',

'affiliate_products_id' => $affiliate_products_id,

'affiliate_banner_id' => $affiliate_banner_id);

 

Has anyone else had the problem with ref=1&products_id=3&affiliate_banner_id=1 working and a link ref=1&affiliate_banner_id=1 ending in an error?

Is it ok to run the script as below? Will it truly only affect the tracking of what product a user click to come to the site?:

 

if (!$link_to) $link_to = "0";

$sql_data_array = array('affiliate_id' => $affiliate_ref,

'affiliate_clientdate' => $affiliate_clientdate,

'affiliate_clientbrowser' => $affiliate_clientbrowser,

'affiliate_clientip' => $affiliate_clientip,

'affiliate_clientreferer' => $affiliate_clientreferer,

//'affiliate_products_id' => $affiliate_products_id,

'affiliate_banner_id' => $affiliate_banner_id);

 

 

If anyone needs to know what edits i did to make it work on an older CSV just email me I will be happy to let you know.

 

Hats off to you Henri Schmidhuber

thanks for the excellent mod.