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)

[venomx]

Where can I find it?

[mholtum]

The install went easy but when running the sql querry I get error 1064 ARGH!

[Scerina]

Oh, what an awesome hack! Could someone please install this for me please????? If you can help me, please email me at: Pandora@Sweet-November.Net

Thanx in advance

[mholtum]

Ok, I was ablew to get all of the queries to work except the first one. When I run it I get this error:

SQL-query: 

CREATE TABLE affiliatesaffiliate_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 )

MySQL said:  

#1064 - 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 'affiliate_id int(10) NOT NULL auto_increment,
     sitename varch

[mholtum]

Ok, I got it working! http://www.ravensrealm.net/forum/affiliates.php

[Scerina]

Is anyone else havin problem with this mySQL Query:

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_x_successfully', '<i>{1}\'s</i> has been updates!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_successfully', '<i>{1}</i> has been deleted!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_unsuccessfully', '<i>{1}</i> was not deleted due to your choice selection.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_successfully', '<i>{1}</i> has been successfully added to the data base.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_unsuccessfully', 'This affiliates could not be added to the database because you either did not enter an affiliate name or an affiliate url or an affiliate email.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_settings_successfully', 'Settings for Affiliates Addon Updated.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_successfully', '<i>{1}</i> was updated successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_unsuccessfully', 'The type was <u>not</u> updated because the types name was left blank.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_unsuccessfully', 'This type/category was not added to the database due to the name of this type/category not being filled in.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_successfully', '<i>{1}</i> was added to the database successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('0', 'approved_affiliate_x_successfully', '<i>{1}</i> has been approved successfully and an email has been dispatched to its admin\'s email.', '9000');

For some odd reason, it won't let me run this query...can someone help me???

[NightWalk8r]

i cant get this to work right. Please help me out.
I have it in a module for CMPS too.

here's the link to the module. http://www.anim3.com
here's the link to the main affiliate page http://www.anim3.com/forums/affiliat...listaffiliates

If you click on the link, it wouldnt work for some reason.

[bandare]

I'd like to get that vbadvanced mod if you can make it accessible pls.....

----------------------------------------------------

I have a problem. If I try to click on any of the affiliates links in that section, it just hangs rather than going to the webpage of the affilliate.... what is going wrong?

It keeps adding lots of hits to the affilliate link but doesnt actually go there until I hit the proceed button manually....

pls help!

[bandare]

Originally Posted by bondjetta

After speaking with Ianomed about this he pointed out some problems with the template STANDARD_REDIRECT and Firefox...as a result I've found (at least a temporary fix) a fix for this...go to your STANDARD_REDIRECT template and change:

		else
		{
			clearTimeout(timerID);
			window.status = "";
			window.location = "$js_url";
		}

to:

		else
		{
			clearTimeout(timerID);
			window.status = "";
			window.location = "$url";
		}

I'm testing it across a few different browsers right now, i'll post if i find any irregularities, but at least the URL's are forwarding now (making this module useful again )

I am still trying to fix this problem for my affiliates section and firefox/mozilla users.... I cant find the template STANDARD REDIRECT......... pls help.......

is this the only fix for the redirection fault for affiliates V2?

[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