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)

[AN-net]

Originally Posted by Deviant++

What exactly is the difference between this and vb3 affiliates hack ..


this is the second version cause it's vb affliates v.2 ?


also, I can't run a single query this is what all it's saying

vBulletin Message 
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

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_records (
record_id int(10) NOT N

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_records (
record_id int(10) NOT N

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_settings (
active tinyint(4) NOT

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_types (
id int(10) NOT NULL auto_

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

NOTE : I am on windows 2003 server on plesk 6.5

try running it one query at a time

[Deviant++]

okay I got queries done..

[Deviant++]

Invalid SQL: SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,tota lrating,totalvotes FROM vb3_affiliates LEFT JOIN affiliates_types ON affiliates.type = affiliates_types.id WHERE active='1' AND approved='1' ORDER BY sitename DESC LIMIT 0,5
mysql error: Table 'dvdb.affiliates_types' doesn't exist

the tables threre..

I tried putting vb3_ ( which is my prefix ) on all of them or alterntively one by one, not making any difference..

[Deviant++]

Bah, had to hardcode it to get it working..

:disappointed: wouldn't take prefix's otherwise..

[Soto]

Originally Posted by BBCVman

OK, I have reinstalled the whole program. Now if you go and check it out, click on the link or banner that i have added to the affiliate program. its now not redirecting anywhere!
THis is what its doing:

http://www.bodybuildingcentral.net/forums/www.bodybuildingcentral.net

<-- as you can see its adding my site url again at the end! Then it goes to a 404 error page.

Here is the site and its set so guests can enter
www.bodybuildingcentral.net

thanks for any help on this, Im trying to get things rollin as fast as I can....

I'm having the same problem. When an affiliate is clicked it adds the affiliate url to my forum url so gives a 404.

Any ideas what's causing this, and how do I correct it. This is a great mod and I really want to work with it.

[Soto]

Ahhhh my fault, what an idiot I am! I checked the affiliate details in the the admincp and it was because I'd preapproved an affilitate without http:// at the beginning of the url. Changed that and now it works like a dream.

I made the board redirect template change mentioned earlier for better compatibility with Firefox - it works well, although in some cases you have to manually click "proceed" but it's a small price to pay.

Thanks so much for this.

Also, some people were asking how to make affiliates open in a new window. I made the following edits to allow that:

Basically in each case it's a case of adding target="blank" where ever needed - to save people the time of wading through the template files I've added a text file for the edits.

Can we get an affiliate thread going? We can really use this hack to its full potential then

[Soto]

Is anyone else having a problem where "hits in" doesn't seem to be working?

Everything else works, except for hits in.

Any ideas?

[Royalridge]

Out of the zip there is a serious functionality problem, links to sites in the "Top (X) Affiliates" section link directly to the site and bypass the "Links Out" counting. There is a fix that requires one query modification to affilate.php and a change to affiliate_topbits template.

[Royalridge]

Niggles:

• Administrator should be able to specify what page incoming hits are directed to rather than a force into the affiliate list. (I know this can be done through editing the affiliatein.php but ideally should be through control panel)
• Use of the re-direction template on hits in and out looks messy and should have a control panel option to disable.

[venomx]

Originally Posted by Royalridge

Out of the zip there is a serious functionality problem, links to sites in the "Top (X) Affiliates" section link directly to the site and bypass the "Links Out" counting. There is a fix that requires one query modification to affilate.php and a change to affiliate_topbits template.

And the fix is?