vB Affiliates for 3.5

Author: An-net
Ported by: Danny.vbt

Description:
Now add,manage,display all your communties/boards affiliates in a simple and organized fashion.

[high] This hack is in it's early BETA stages, and it should be used for DEBUGGING purposes only. [/high]

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

And more!

Install Overview:

[high] Please upload files before importing product! [/high]
(Thanks Kirby!)

File Uploads(4)
Template Edits(1)
Products(1)
Cron (1)


Please Note:

This hack is in BETA, if you find any bugs whatsoever report them, and I will fix them asap. (I'm almost positive that there will be a few silly bugs.)

Thank You,
And please click Install if you use this hack.


Updates:

BETA 1.0.7

Uploaded new affiliate.php by HawkBizKit, fixes ON clause error

BETA 1.0.6

Uploaded new affiliate.php by Dark_Wizard

BETA 1.0.5

Fixes Installation/Uninstallation issues and table prefix error

BETA 1.0.4

Added missing phrases, fixed permissions issue.

BETA 1.0.3

Fixed errors on xml product, also added auto rebuild bitfields.

BETA 1.0.2

Fixed parse error on affiliate.php

Screen Shots Below: They are Poorer quality due to gifs.

Originally Posted by Glovebox

You've lost me there matey, sorry! ;-)

Lol, I'm just talking to myself I guess. I'll provide an update that will do it automatically.

Okay, another update.

BETA 1.0.4 should fix the usergroup permission error, and also add the missing queries.

[erratic assasin]

@ Danny yeah your right! Im an ass .. Nice work .. and thank you ... :squareeyed:

[Brinnie]

can u use images?
if yes, can u specify a max width x height?

[Impreza04]

Ok.. now im gonna be a real pain:

Affiliateadmin.php

PHP Code:

Parse error: parse error, unexpected ',' in /home/imp04/public_html/forum/admincp/affiliateadmin.php on line 193 


affiliate.php

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM vB_ affiliates_settings;

MySQL Error  : Table 'imp04_vbulliten.vB_' doesn't exist
Error Number : 1146
Date         : Tuesday, September 20th 2005 @ 08:19:25 AM
Script       : http://www.playstation-racing.co.uk/forum/affiliate.php 


Uninstalling

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
DROP TABLE affiliates;

MySQL Error  : Unknown table 'affiliates'
Error Number : 1051
Date         : Tuesday, September 20th 2005 @ 08:23:42 AM
Script       : http://www.playstation-racing.co.uk/forum/admincp/plugin.php 


[Glovebox]

Thanks for your help Danny, works great now.

Minor niggle:

Code:

Appears at top of affialiates page, see my site to see what I mean.

Adam

Glovebox,

Look in your affiliate template, and there should be "Code:" there, remove it and it will fix it.

Impreza04, I fix the affiliateadmin.php error, I will upload it tonight. Also, it seems like you didn't properly install the product because the tables don't exist...

Brinnie,
Yes you can use image, and I think there is a set width. Check the admin cp setting of the hack.

[jugo]

go into the AFFILIATE template and remove Code:

And go into line 193 of the affiliateadmin.php file and change it to this:

	print_stop_message('approved_affiliate_x_successfully', $sitename);

Thanks Danny...awesome work..

[Omega Prime]

Is there any means to using this if the affiliate system was installed with 3.0.x? What I mean is that I tried running the plugin and got this:

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)
);

MySQL Error  : Table 'affiliates' already exists

I suppose I could just drop the old tables, but I had hoped that this would be more of an upgrade than a fresh install

[Hawkbizkit]

you forgot to add the " . TABLE_PREFIX . " in the xml for those of us that use prefix's like myself

Edit: also in the uninstall code to remove the usergroup database info your plugin added you put DELETE instead of DROP..

Edit2: well it looks like in the affiliateadmin.php you put a ton of spaces after the table prefix codes all over the place which cause many errors...