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)

[agiacosa]

I installed this hack on a 3.0.6 site. Everything installed fine. The problem is that when I add an affiliate, it doesn't show up in the affiliate index page. Everything else seems to happen. Email is sent to affiliate, it shows approved in AdminCP, etc.

What could it be?

[AN-net]

the affiliatemust be approved and active

[agiacosa]

It is.

[AN-net]

are sure that it is both because that active and approved are separate and that would be the only reason it would not show up.

[slow56k]

Hi,

I've installed everything as per instructions but when I come to run the queries I get an error. Any help is appreciated.

PHP Code:

 DROP TABLE IF EXISTS affiliates;
CREATE TABLE affiliates (
     affiliate_id int(10) NOT NULL auto_increment,
     sitename varchar(50) NOT NULL,
     siteurl varchar(250) NOT NULL,
     sitedesc mediumtext NOT NULL,
     buttonurl varchar(150) NOT NULL,
     type tinyint(4) NOT NULL,
     email varchar(250) NOT NULL,
     clicksout int(20) NOT NULL,
     clicksin int(20) NOT NULL,
     active tinyint(4) NOT NULL,
     totalrating bigint(20) NOT NULL,
     totalvotes bigint(20) NOT NULL,
     approved tinyint(4) NOT NULL,
     PRIMARY KEY (affiliate_id),
     KEY sitename (sitename),
     KEY siteurl (siteurl),
     KEY email (email)
); 


PHP Code:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL auto_increment,
' at line 1 


[slow56k]

Typical - as soon as I asked for help I found the answer. Thanks for the hack!!

[mikaelweb]

This hack is posted on difrent forum at this time

[venomx]

huh?

Take the link out and report it to vbulletin.

[venomx]

Hmm on my WOL I am getting this...
Unknown Location
/forums/affiliatein.php?do=image&a=1

I made all the edits in the files.. what do I need to do?

Also are we to get an email when people submit a site? I dont get one to tell me I have to go and approve a site..