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.

[Dark_Wizard]

Originally Posted by ReadOrDie

This hack is becomming very troublesome...

Try this file overwriting the one you have now..

Originally Posted by Dark_Wizard

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

Lol, Sorry I changed I the it, and put you as a supporter. Is their a Dark Visor on vb.org?

And to everyone getting annoyed, or irratated by the errors and updates of the hack. Please realize that this is only in the BETA stages without these errors the hack would not progress!

[Hawkbizkit]

Originally Posted by 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

very simple fix on line 309 in the affiliate.php change this

PHP Code:

                                        ON affiliates.type = affiliates_types.id 


with this

PHP Code:

                                        ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id 


[Dark_Wizard]

I have already changed the file in the post above and it's better to do it this way:

PHP Code:

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


[Impreza04]

Nope sorry. None of those fixes work. Same error still occurs :ermm:

This should be a simple fix, by combining both of the suggested fixes..I'll do this later tonight and upgrade the hack with the new affiliate file.

[ReadOrDie]

delete this post plz.

[ReadOrDie]

Sorry about that, It's working now. I reinstalled the adminaffiliate.php thing! I'm clicking install!

[ReadOrDie]

Now it says I don't have permission...How do I not have permission? I'm the administrator. When I click on the affiliates in the forum it says you may not have enough priviledges blah blah blah...

You have to set permissions in the usergroup manager