The Arcive of Official vBulletin Modifications Site.

vB Affiliates for 3.5 · **Released**: 09-17-2005

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.

Impreza04 · #42 09-21-2005, 01:21 PM

Nope.. Ive tried re-installing with overwrite on and its not creating the tables.. :ermm:

#43 09-21-2005, 05:00 PM

If you already have the affiliates database, I'll make a product for just the two plugins in the product.

Also, that was the fix for the affiliate admin page...are there any other errors?

Hawkbizkit · #44 09-21-2005, 11:48 PM

well all 3 php pages you have for this mod need the space removed after the " . TABLE_PREFIX . " cause it was in more than just the admin page. there was one more error i came up with but i can't remember since i uninstalled it anyways since i was tried of playing with it but maybe tonight i will give it another run...

and let you know of any problems

#45 09-21-2005, 11:49 PM

Quote:

Originally Posted by Hawkbizkit

well all 3 php pages you have for this mod need the space removed after the " . TABLE_PREFIX . " cause it was in more than just the admin page. there was one more error i came up with but i can't remember since i uninstalled it anyways since i was tried of playing with it but maybe tonight i will give it another run...

and let you know of any problems

Okay, thanks. I'll fix that tonight, and upload the new zip file.

Protoman · #46 09-23-2005, 07:03 PM

I'm having issues that I am unable to install vbAdvanced CMPS after installing this hack. not sure if it's just me or what.. so I tried to uninstall the hack and got an error.

Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
ALTER TABLE usergroup DELETE vbaffiliatespermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE vbaffiliatespermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL' at line 1
Error Number : 1064
Date         : Friday, September 23rd 2005 @ 01:45:58 PM
Script       : http://testvb.mysite.net/forum/admincp/plugin.php
Referrer     : http://testvb.mysite.net/forum/admincp/plugin.php?do=productdelete&productid=dvbt_vbaffiliates&s=
IP Address   : XXXXXX
Username     : admin
Classname    : vB_Database

Dark_Wizard · #47 09-23-2005, 07:28 PM

Quote:

Originally Posted by corollasbest

I'm having issues that I am unable to install vbAdvanced CMPS after installing this hack. not sure if it's just me or what.. so I tried to uninstall the hack and got an error.

Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
ALTER TABLE usergroup DELETE vbaffiliatespermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE vbaffiliatespermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL' at line 1
Error Number : 1064
Date         : Friday, September 23rd 2005 @ 01:45:58 PM
Script       : http://testvb.mysite.net/forum/admincp/plugin.php
Referrer     : http://testvb.mysite.net/forum/admincp/plugin.php?do=productdelete&productid=dvbt_vbaffiliates&s=
IP Address   : XXXXXX
Username     : admin
Classname    : vB_Database

The product xml file isn't correct for this hack...Danny, get in touch with me via IM....I have an updated xml file for you since I had the same issues as everyone else.

#48 09-24-2005, 01:44 AM

Quote:

Originally Posted by Dark_Wizard

The product xml file isn't correct for this hack...Danny, get in touch with me via IM....I have an updated xml file for you since I had the same issues as everyone else.

Okay, I pmed you.

Once I get this sorted out, I will fix the other bugs and do another update to BETA 1.0.5.

Hawkbizkit · #49 09-24-2005, 03:03 PM

Line 308 affiliates.php you are missing the " . TABLE_PREFIX . ". Other than that i think i fixed the installing/uninstalling and using functionallity so if you wanna take a look at the code or the pages i have fixed feel free to hit me up in the vb.org chat system or over MSN/Yahoo/AIM messanger.

Edit: Here are a few links to it up and running just fine
http://forum.overhauledpc.com/affili...listaffiliates
http://forum.overhauledpc.com/affiliate.php?do=apply
http://forum.overhauledpc.com/affiliate.php

ReadOrDie · #50 09-25-2005, 01:38 AM

I'm getting this error: Sorry but the affiliate section of the siteis currently disabled. How do I fix it? It's when I click on the affiliates tab.

#51 09-25-2005, 03:02 AM

Quote:

Originally Posted by ReadOrDie

I'm getting this error: Sorry but the affiliate section of the siteis currently disabled. How do I fix it? It's when I click on the affiliates tab.

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

ReadOrDie · #52 09-25-2005, 04:49 PM

Quote:

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"

#53 09-26-2005, 12:22 AM

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.

#54 09-26-2005, 12:25 AM

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 · #55 09-26-2005, 01:42 AM

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

#56 09-26-2005, 02:19 AM

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 · #57 09-26-2005, 01:22 PM

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 · #58 09-26-2005, 06:07 PM

Quote:

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 · #59 09-26-2005, 06:46 PM

Quote:

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 · #60 09-26-2005, 06:48 PM

Code:

 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 · #61 09-26-2005, 06:59 PM

This hack is becomming very troublesome...

Dark_Wizard · #62 09-26-2005, 08:43 PM

Quote:

Originally Posted by ReadOrDie

This hack is becomming very troublesome...

Try this file overwriting the one you have now..

#63 09-26-2005, 08:58 PM

Quote:

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 · #64 09-26-2005, 09:28 PM

Quote:

Originally Posted by loneranger

Code:

 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 · #65 09-26-2005, 10:00 PM

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 · #66 09-27-2005, 04:11 AM

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

#67 09-27-2005, 04:10 PM

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 · #68 09-27-2005, 09:39 PM

delete this post plz.

ReadOrDie · #69 09-27-2005, 09:42 PM

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

ReadOrDie · #70 09-27-2005, 09:48 PM

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

#71 09-27-2005, 11:24 PM

You have to set permissions in the usergroup manager

ReadOrDie · #72 09-28-2005, 12:38 AM

Quote:

Originally Posted by Danny.VBT

You have to set permissions in the usergroup manager

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

#73 09-28-2005, 01:00 AM

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

Impreza04 · #74 09-28-2005, 04:08 AM

Has the affiliate file been updated yet..?

ReadOrDie · #75 09-28-2005, 09:58 AM

Quote:

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

#76 09-28-2005, 01:51 PM

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

bi11i · #77 09-28-2005, 03:39 PM

Quote:

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 · #78 09-28-2005, 03:45 PM

Quote:

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 · #79 09-28-2005, 03:53 PM

Quote:

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

Quote:

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 · #80 09-28-2005, 05:14 PM

Quote:

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

Quote:

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

when running the query...

Hawkbizkit · #81 09-28-2005, 05:22 PM

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.12762 seconds Memory Usage 2,645KB Queries Executed 56 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (4)bbcode_code (13)bbcode_php (18)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (41)post_thanks_box (41)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (41)post_thanks_postbit_info (40)postbit (28)postbit_onlinestatus (41)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start postbit_imicons pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!