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

You have to set permissions in the usergroup manager

Nothing in the usergroup manager says anything about affiliates...

Did you upload the bitfield_vbaffiliates.xml file into your includes/xml directory?

[Impreza04]

Has the affiliate file been updated yet..?

[ReadOrDie]

Originally Posted by Danny.VBT

Did you upload the bitfield_vbaffiliates.xml file into your includes/xml directory?

Alright I installed it, but yet again I'm getting another error:
Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 628

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

[bi11i]

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


thanks, that fixed my SQL error, also.

Are the General Settings optimally configured by default?

[bi11i]

Database error in vBulletin 3.5.0 Release Candidate 3:

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

MySQL Error : Unknown table 'opio_affiliates' in on clause
Error Number : 1109
Date : Wednesday, September 28th 2005 @ 11:45:15 AM
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

I'm still getting this error no matter which hack to the mod I try. Any definitive solution?

[Hawkbizkit]

Originally Posted by bi11i

I'm still getting this error no matter which hack to the mod I try. Any definitive solution?

you are missing the who affiliates table it's self it looks like try runing the query to install the table

CREATE TABLE `opio_affiliates` (
`affiliate_id` int(10) NOT NULL auto_increment,
`sitename` varchar(50) NOT NULL default '',
`siteurl` varchar(250) NOT NULL default '',
`sitedesc` mediumtext NOT NULL,
`buttonurl` varchar(150) NOT NULL default '',
`type` tinyint(4) NOT NULL default '0',
`email` varchar(250) NOT NULL default '',
`clicksout` int(20) NOT NULL default '0',
`clicksin` int(20) NOT NULL default '0',
`active` tinyint(4) NOT NULL default '0',
`totalrating` bigint(20) NOT NULL default '0',
`totalvotes` bigint(20) NOT NULL default '0',
`approved` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`affiliate_id`),
KEY `sitename` (`sitename`),
KEY `siteurl` (`siteurl`),
KEY `email` (`email`)
) ;

[bi11i]

Originally Posted by Hawkbizkit

you are missing the who affiliates table it's self it looks like try runing the query to install the table

error number: 1050
error desc: Table 'opio_affiliates' already exists

when running the query...

[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: on the first line in this code there is a space between tota lrating just remove the 2 spaces and it should work just fine.

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...

EDIT: Fix down in post #88