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

What page are you getting that error? I think I filtered out a integer type variable, that's what is causing the error.

I'm getting the error when I try to update the usergroups. It happens right after I press "update"

[bi11i]

Another problem I'm having is the displaying of $bbuserinfo in the error message I received concerning insufficient privilges. Is global.php missing from somewhere? It looks to be in the two affiliate files. Any ideas?

$bbuserinfo[username], you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account. Use the contact form to find out why.

[bi11i]

Originally Posted by Hawkbizkit

oh dummy me i read your error wrong sorry well i would say try this code

Find: (should be around line 307ish in affiliates.php)

PHP Code:

            $faffiliate=$db->query_read("SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,totalrating,totalvotes 
                                        FROM " . TABLE_PREFIX . "affiliates AS affiliates LEFT JOIN " . TABLE_PREFIX . "affiliates_types  AS affiliates_type
                                        ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY $by $in 
                                        LIMIT $limitvalue,$perpage"
                                        ); 


Replace with:

PHP Code:

            $faffiliate=$db->query_read("SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,totalrating,totalvotes 
                                        FROM " . TABLE_PREFIX . "affiliates LEFT JOIN " . TABLE_PREFIX . "affiliates_types 
                                        ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY $by $in 
                                        LIMIT $limitvalue,$perpage"
                                        ); 


Thats how i have my code setup and it is working just fine and when i tried it your way it doesn't work...

I've got this with your new modification:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,tota lrating,totalvotes
FROM opio_affiliates LEFT JOIN opio_affiliates_types
ON opio_affiliates.type = opio_affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY sitename DESC
LIMIT 0,5;

MySQL Error : Unknown column 'tota' in 'field list'
Error Number : 1054
Date : Wednesday, September 28th 2005 @ 02:17:58 PM
Script : http://forum.opiophile.org/affiliate...listaffiliates
Referrer : http://forum.opiophile.org/affiliate.php
IP Address : 192.168.0.110
Username : bi11i
Classname : vB_Database_MySQLi

[bi11i]

Originally Posted by bi11i

I've got this with your new modification:

I managed to correct the totalrating line.

On to the next problem:

I added an affiliate via the Admin Panel. It doesn't show. So I need to approve it via the admin panel? I'm not sure why this would be, but after I do approve it, get this error:

Warning: mail() [function.mail]: SMTP server response: 503 No recipient(s). in \admincp\affiliateadmin.php on line 191

The email fields are filled out, plus it went way too quick to have gotten that info from my mailserver.

The the other problem is that if an image is not added to an affiliate, I get the old x'd out box. Any way to fix that?

Also, shouldn't the affiliates open up in a new window?

Last, wouldn't it be best to include an if statement in the navbar for when the affiliates is turned off?

Originally Posted by ReadOrDie

I'm getting the error when I try to update the usergroups. It happens right after I press "update"

Try rebuilding the bitfields manually through the admincp. I'm going to open my test board with this on, along with a bug tracker so I can easily find all the bugs..Also, I will post an update right now...

Please submit all bugs to

http://www.dev.tobroadway.com/forum/vbugs.php

You do not have to register to post bugs...

[ReadOrDie]

I'm still getting this error:

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 628

Whatever it is, it has something to do with classcore.php...

[Hawkbizkit]

Originally Posted by bi11i

I've got this with your new modification:

dangit i don't know why but each time i post something using the PHP tags it wants to add a space somewhere where it should not.....meaning fix this space it added in the first line..

edit dangit it still keeps adding the space just try replacing it with this page
or just in the first line fix the space between tota lrating to totalrating

Originally Posted by ReadOrDie

I'm still getting this error:

Whatever it is, it has something to do with classcore.php...

Did you try manually rebuilding the bitfields via the Admin Cp Option? It seems like it isn't doing it now..

[Impreza04]

Cheers that new file worked..

One small thing though:
Uncached templates: affiliate_list (1)
Uncached templates: affiliate_listbits (1)