Hi,

I was going through the code of affiliate.module and affilate.install and had some queries.. regarding the table design and working logic

table: affiliate_details
aid - affiliate id (same as drupal user id) ??
enabled - is this affiliate enabled at the moment ??

table: affiliate_users
aid - affiliate id
uid - drupal userid that was created by a visitor from affiliate id's page
keywords - keyword used by affiliate url

table: affiliate_counts
aid - affiliate id
time - what is this field used for ????
keyword - keyword used by affiliate url
clicks - number of clicks on drupal site during this session ?????
users - number of users created on drupal site during this session ????

So when a user lands on the drupal site from an affiliate site say from example url

http://somesite.com/goto?site=http://mydrupalsite.com/?aid=5&keyword="foobar"

How does that click or workflow get recorded into the database ?

Appreciate any input.

Thanks.

Yashesh

Comments

debsjenkins’s picture

Is anyone using this on 4.7 ? I'm struggling to get it to work. I can't get clicks to register.
thanks in advance
Debs