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

[flaregun]

Originally Posted by AN-net

you can change the image via editing the affiliate in acp and to my knowledge you can still delete affiliates ever if inactive

I'm still getting the "X" and don't see the option in ACP to set a default image. Any ideas?

thanks

[AN-net]

Originally Posted by flaregun

I'm still getting the "X" and don't see the option in ACP to set a default image. Any ideas?

thanks

did they provide a full url including http:// for buttons?

[Splinteroid]

I'm new to all this, I was just wondering whether it is possible to get the top 5 affilates page (/affiliate.php?do=listaffiliates) to be displayed on the forum home? Perhaps underneath the 'who's online' and 'todays birthdays' bit without having to click on a link or anything. Kinda like this: http://img.photobucket.com/albums/v1...4/example2.jpg (in my case I would want it under the shoutbox perhaps)

Thanks in advance for any help you might offer

[flaregun]

Originally Posted by AN-net

did they provide a full url including http:// for buttons?

No, sorry, I mean i get the 'x' when there is no photo added. There should either be a default photo or no image call. Some users don't have a photo to upload.

[boo.3]

i get this error when running any querys

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. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VA

[AN-net]

Originally Posted by flaregun

No, sorry, I mean i get the 'x' when there is no photo added. There should either be a default photo or no image call. Some users don't have a photo to upload.

version 2 of this hack provides a default image if none is given

[Lyricsmama]

Hi.
Sorry to be a bother here but I'm having trouble with the redirecton when I click the affiliate's name/button. It just recycles forever and doesn't redirect, any suggestions?

TIA.

[The Realist]

In my affiliates > general settings box there are 2 buttons, one is Reset but my other one is blank, no text?

I presume it supposed to be Save but what do I need to do so I can correct it?

Laters

[o0Hubba0o]

Is this 3.0.7 compatible? I started running the queries and got an error on the first one. I'm fairly new to querries so I have no idea what to do with it:

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. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL a

I have no idea where I would find a "manual" to check this stuff like it says either.

[Marco van Herwaarden]

Please post the full error message. Difficult to tell what is wrong from that snippet.

PS A 'manual' you can find at http://www.mysql.com