vB Affiliates v.2

vB Affiliates v.2

Author: Antonbomb22

Description:
Now add,manage,display all your communties/boards affiliates in a simple and organized fashion.

Features:
-Administration Panel
-multiple affilliates
-image button verification
-modules
-top listing
-types/categories
-reporting system
-rating system
-in and out clicking system
-redirects
-delay system
-disclaimers
-extremely customizeable
-display options
-pagination
-approval system
-usergroup permissions
-active system
-image buttons

Changes from Version 1:
-administration intergrated better
-added a delay system
-added a report system
-4 new modules
-display options
-pagination
-click in features with buttons so affiliates may link back
-cached templates
-quicked load speeds
-image button verification
-more options
-approval system
-usergroup permissions

Known Bugs:
-if an affiliates site goes down completely the verification/validation system will report errors

Some notes(usually rare):
-server load may increase a little bit if you have all modules active
-load time may a little bit increase if you have image validation on

Live Demo:
http://www.animationation.net/community/affiliate.php
http://www.game-realms.net/vb/affili...listaffiliates

Offical Support/Suggestion forum: http://www.animationation.net/commun...splay.php?f=58

plz click install

Enjoy

edit:
attachment updated, wrong queries for upgrade instruct.
updated zip file with new template edit
updated zip file with new affiliate.php
update zip file with new queries
Those who has alrdy downloaded follow the following links for file updates:
https://vborg.vbsupport.ru/showpost.php?p=491667
https://vborg.vbsupport.ru/showpost.php?p=491675
https://vborg.vbsupport.ru/showpost.php?p=496126
updated zip file with few fixes(4/14/04)

[Bryan Ex]

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

[Bryan Ex]

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

[AN-net]

you mean resetting the clicks in and out?

[Bryan Ex]

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.

[AN-net]

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

[Bryan Ex]

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.

[djohn]

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

[Bryan Ex]

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 ?

$mvotes= $DB_site->query_first("SELECT sitename,buttonurl,affiliate_id,siteurl,totalvotes FROM affiliates WHERE active='1' AND approved='1' ORDER BY totalvotes DESC");

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

[AN-net]

$mvotes= $DB_site->query_first("SELECT sitename,buttonurl,affiliate_id,siteurl,totalvotes FROM affiliates WHERE active='1' AND approved='1' ORDER BY totalvotes DESC");

change that to this:

PHP Code:

$mvotes= $DB_site->query_first("SELECT sitename,buttonurl,affiliate_id,siteurl,totalvotes FROM affiliates WHERE active='1' AND approved='1' ORDER BY totalvotes DESC,totalrating DESC"); 


reply back on how that works

[Bryan Ex]

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.