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.

[ReadOrDie]

Originally Posted by Danny.VBT

In Admin Cp- > Affiliate Setting -> Set that the affiliate section is enabled.

Could you be more specific? Or provide screenshots? Because I'm looking everywhere in the Admin CP and I can't find something that says "Affiliate Setting"

AdminCP -> Affiliates -> General Settings -> Is the Affiliates Addon Active? If not, no one can view this addon - > Set to yes

If you can't see Affiliates category in the admincp, make sure you upload the cpnav_affiliates.xml file to your includes/xml directory.

Okay, thanks to Dark_Wizard for updating the xml product, the hack has been updated to BETA 1.0.5.

This fixes the various problems with installation/uninstallation, and it also should fix the "TABLE_PREFIX" problem.

( I did a find/replace to take the spaces away)

[ReadOrDie]

Now I'm getting this error: Parse error: parse error, unexpected ',' in /www/g/************/htdocs/forum/admincp/affiliateadmin.php on line 193

Hm...I don't see anything wrong with that line, nor did I make any changes to it. Can you post line 193 of the file on here, so I can take a look?

Is anyone else having this problem?

[Impreza04]

Everything is working on my test board apart from when trying to view affiliate.php

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM vb_ affiliates_settings;

MySQL Error  : Table 'integram_crg.vb_' doesn't exist
Error Number : 1146
Date         : Monday, September 26th 2005 @ 04:22:45 PM 


EDIT: Actually I see the problem myself and its fixed..

PHP Code:

//################## Begin Settings###################//
$setting= $db->query_first("SELECT * FROM " . TABLE_PREFIX ." affiliates_settings"); 


Has a space..
Replace with

PHP Code:

//################## Begin Settings###################//
$setting= $db->query_first("SELECT * FROM " . TABLE_PREFIX ."affiliates_settings"); 


Lets try on my real board


The disabled message
"Sorry but the affiliate section of the siteis currently disabled."
Needs a space between site and is

and

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,totalrating,totalvotes 
                                        FROM vB_affiliates LEFT JOIN vB_affiliates_types 
                                        ON affiliates.type = affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY sitename DESC 
                                        LIMIT 0,20;

MySQL Error  : Unknown table 'affiliates' in on clause
Error Number : 1109
Date         : Monday, September 26th 2005 @ 09:05:35 AM
Script       : http://www.playstation-racing.co.uk/forum/affiliate.php?do=listaffiliates 


[ReadOrDie]

Originally Posted by Danny.VBT

Hm...I don't see anything wrong with that line, nor did I make any changes to it. Can you post line 193 of the file on here, so I can take a look?

Is anyone else having this problem?

I don't get what you mean...

[Dark_Wizard]

Originally Posted by Danny.VBT

Okay, thanks to Dark Visor for updating the xml product, the hack has been updated to BETA 1.0.5.

This fixes the various problems with installation/uninstallation, and it also should fix the "TABLE_PREFIX" problem.

( I did a find/replace to take the spaces away)

LOL...close enough. Although Dark Visor may like it...

[loneranger]

 Database error in vBulletin 3.5.0 Release Candidate 3: 

Invalid SQL: 
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,tota  lrating,totalvotes  
                                        FROM vB_affiliates LEFT JOIN vB_affiliates_types  
                                        ON affiliates.type = affiliates_types.id  
                                        WHERE active='1' AND approved='1'  
                                        ORDER BY sitename DESC  
                                        LIMIT 0,20; 

MySQL Error  : Unknown table 'affiliates' in on clause

i am getting this error too is there a solution yet as i need this

[ReadOrDie]

This hack is becomming very troublesome...