Got it. I deleted the <dfn> tags around the description text and all is well in the world. :squareeyed:

Anyway of resetting the stats on a weekly basis or am I looking at digging into the database for that?

you mean resetting the clicks in and out?

Exactly. Even with a reasonable delay on clicks - people will cheat so it's nice to either give others a fair chance at being listed or keep the cheaters very busy.

hmm ill see if i have time to write up a cron script

That would be great if you have time. Didn't mean to make work for you ... just looking for the easiest way to maintain my affiliate list now that it's installed and running well.

Before I install this, does this hack have a master on-off switch, that would make the affiliates section completely unavailable\available for users?

Yes it does and you can also grant access to only certain usergroups - like mods for example

SQL question... how can I get the following query to list ORDER BY totalratings / totalvotes ?

I'm looking to list affiliates based on average ratings instead of totals but "calcrating" isn't entered into the db.

change that to this:


reply back on how that works;)

It still orders them by totalrating which isn't necesarily correct. I have a "two star" affiliate listed before a "four star" one because of extra votes for a higher total. I think there needs to be some sort of division equasion - SORT BY (totalrating / totalvotes) DESC - for example to list by average.