Vb3 Affiliate Hack

Description:
This hack lists/displays affiliates added by you and other usergroups.

Features:
-Administration System
-Approval System
-Top Listing System
-Types/Categories for Affiliates
-Affiliate image buttons
-Affiliate descriptions
-Hit counter for Affiliates
-Rating System
-Editing for both types/categories and affiliates via admincp
-Vb Code Parsing

Author: Antonbomb22/AN-Net

Features for Next Version:
-Image link verification
-in and out hit counters
-more administration options and control
-usergroup permissions
-automatic emailing upon approval
-pagination
-cached templates
-and much more...

Live Demo:
http://www.animationation.net/community/affiliate.php

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

Sorry if this is in wrong forum.

PS: this is my first hack, im so excited

*Click Install*

Fixes: (Category Fix - 6:28 PM EST 4/14/04)https://vborg.vbsupport.ru/showpost.php?p=485373

[Blaine0002]

just so you know u forgot the .zip file extension...

[AN-net]

what do you mean?

[Blaine0002]

inside the main zip theres another file that should have the .zip extension..

[AN-net]

well i would suggest you use version 2 of this hack anyways

[Blaine0002]

ill stay with this version untill i NEED 2.0

[AN-net]

ok, if you wish. anyways what file needs another zip?

[stan68]

im getting a error when trying to add the query

ALTER TABLE affiliates CHANGE clicks clicksout INT( 20 ) NOT NULL ;
ALTER TABLE affiliates2 ADD clicksin INT(20) DEFAULT '0' NOT NULL, ADD approved tinyint(4) NOT NULL;

first error is this
Error

SQL-query :

ALTER TABLE affiliates CHANGE clicks clicksout INT( 20 ) NOT NULL

MySQL said:


Unknown column 'clicks' in 'affiliates'
and the other is this


Error

SQL-query :

ALTER TABLE affiliates2 ADD clicksin INT( 20 ) DEFAULT '0' NOT NULL ,
ADD approved tinyint( 4 ) NOT NULL

MySQL said:


Table 'nukesm.affiliates2' doesn't exist

[AN-net]

sry the queries should be:
ALTER TABLE affiliates CHANGE clicks clicksout INT( 20 ) NOT NULL ;
ALTER TABLE affiliates ADD clicksin INT(20) DEFAULT '0' NOT NULL, ADD approved tinyint(4) NOT NULL;

and this belongs in the version 2 thread

[Lurk]

I've installed it...
but i don't see the things to the right... how do i enable or add them?

[ZoNe|GsT]

This mod would be a great a addition to our community.

Read the whole thread and I'm aware it's for 3.0, but would like to know if anyone has gotten it to work for 3.0.1?