[ic] Affiliate bugfix?

[Mike Heins]

Quoting Kevin Old (kold@carolina.rr.com):
> I was implementing the Affiliate part of IC on my site and I might have
> run into a bug.  I went to setup an affiliate and the affiliate id that
> was generated by IC was 00010.  I tried accessing pages via
> http://myurl/cgi-bin/mycat?mv_pc=00010 and it never tracked any visits
> or orders.
> 
> I searched the list and found a posting that shed some light -
> http://www.icdevgroup.org/pipermail/interchange-users/2002-August/024621.html
> 
> <snip>
> 
> mv_pc=nnn (numeric)
>          A meaningless unqiue number which will increment in you simply 
> reload the page.
>          This is to prevent browser caching
> 
> mv_pc=wwww+ (an alpha string of variable length)
>          This will be interpreted as an affiliate code.
> 
> </snip>
> 
> I changed my affiliate id to kevinold and everything works like a charm.
> 
> Is someone working on the affiliate id generator so that it complies
> with the standards set?  Seems that the affiliate table has the id field
> set at varchar, so someone must have worked on it at one time.
> 

Actually, this can be fixed right in the dbconf/*/affiliate.* files:

Database affiliate AUTO_NUMBER A00000

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

Fast, reliable, cheap.  Pick two and we'll talk.  -- unknown