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.

ReadOrDie · #82 09-28-2005, 06:10 PM

Quote:

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 · #83 09-28-2005, 06:15 PM

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?

Quote:

$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 · #84 09-28-2005, 06:22 PM

Quote:

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:

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,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 · #85 09-28-2005, 06:30 PM

Quote:

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:

Code:

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?

#86 09-28-2005, 07:56 PM

Quote:

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

#87 09-28-2005, 10:06 PM

Please submit all bugs to

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

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

ReadOrDie · #88 09-29-2005, 01:07 AM

I'm still getting this error:

Quote:

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

Quote:

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

#90 09-29-2005, 01:55 AM

Quote:

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 · #91 09-29-2005, 04:25 AM

Cheers that new file worked..

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

Hawkbizkit · #92 09-29-2005, 04:37 AM

alright add this plugin to cache your templates also i attached a file to group the templates in your style

Impreza04 · #93 09-29-2005, 01:27 PM

Ta.. yay.. It all finally works I hope..
>> Another thing - When voting the default stars are used even though im using a custom template with unique rankings.
Any chance this can be fixed.?

ReadOrDie · #94 09-29-2005, 06:09 PM

Quote:

Originally Posted by Danny.VBT

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

What do you mean? I'm not good at editing files or whatever... :nervous:

#95 09-29-2005, 08:28 PM

Quote:

Originally Posted by ReadOrDie

What do you mean? I'm not good at editing files or whatever... :nervous:

You don't have to edit files, point your AdminCP page to this:

admincp/index.php?do=buildbitfields

so it's http://www.yourdomain.com/admincp/in...p?do=bitfields

Hawkbizkit · #96 09-29-2005, 09:13 PM

Quote:

Originally Posted by Impreza04

Ta.. yay.. It all finally works I hope..
>> Another thing - When voting the default stars are used even though im using a custom template with unique rankings.
Any chance this can be fixed.?

in template affiliate_listbits
Find:

PHP Code:


			
<img src="$stylevar[imagesfolder]/rating/rating_$rating.gif" />

and replace it with your location to your ratings images.

PHP Code:


			
<img src="$stylevar[imgdir_rating]/rating_$rating.gif" />

ReadOrDie · #97 09-30-2005, 01:11 AM

Quote:

Originally Posted by Danny.VBT

You don't have to edit files, point your AdminCP page to this:

admincp/index.php?do=buildbitfields

so it's http://www.yourdomain.com/admincp/in...p?do=bitfields

That doesn't work, it leads me straight to the frontpage of the admin CP.

#98 09-30-2005, 02:36 AM

Is your forum on debug mode?

ReadOrDie · #99 09-30-2005, 04:12 AM

Quote:

Originally Posted by Danny.VBT

Is your forum on debug mode?

How do I turn it on debug mode? Isn't there an easier way to fix the usergroups error?

xtreme-mobile · #**100** 09-30-2005, 08:00 PM

when i click view current affiliates it shows following error:

Database error in vBulletin 3.5.0:

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

MySQL Error : Unknown table 'affiliates' in on clause
Error Number : 1109
Date : Friday, September 30th 2005 @ 03:58:53 PM
Script : http://www.talk-365.com/forum/affili...listaffiliates
Referrer : http://www.talk-365.com/forum/affiliate.php
IP Address : xx.xxxx.xxx.xxx
Username : Dean
Classname : vb_database

any ideas?

Hawkbizkit · #**101** 09-30-2005, 08:22 PM

this file is working and should fix your problem unless the table is not in the database
https://vborg.vbsupport.ru/attachmen...chmentid=34901
in post #88

#**102** 09-30-2005, 08:31 PM

I've updated to BETA 1.0.7, this uses Hawkbizkit's affiliate.php file to fix the ON CLAUSE error. Just upload that new file, and it should work. Thanks Hawkbizkit.

ReadOrDie · #**103** 10-01-2005, 02:16 AM

The affiliates file didn't fix my error:

Quote:

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

Anyone got a solution?

#**104** 10-01-2005, 02:22 AM

Follow these instruction to put on debug mode

https://vborg.vbsupport.ru/showthread.php?t=82835

Then point your domain to the link I gave you.

It should say

"Bitfields rebuilt successfully" or something like that.

ReadOrDie · #**105** 10-01-2005, 02:52 AM

Quote:

Originally Posted by Danny.VBT

Follow these instruction to put on debug mode

https://vborg.vbsupport.ru/showthread.php?t=82835

Then point your domain to the link I gave you.

It should say

"Bitfields rebuilt successfully" or something like that.

Thanks anyways but this hack is a little too stressful for me, each time I solve one problem two more come up. I think I'll wait till this gets fixed, or kirby re-makes this into a usuable version. :ermm:

#**106** 10-01-2005, 03:15 AM

Quote:

Originally Posted by ReadOrDie

Thanks anyways but this hack is a little too stressful for me, each time I solve one problem two more come up. I think I'll wait till this gets fixed, or kirby re-makes this into a usuable version. :ermm:

Okay, that's your choice. I'm sure you could code a more stable version

-Danny

Andreas · #**107** 10-01-2005, 03:27 AM

Just a note:
Enabling debug mode is not necessary to rebuild bitfields.
Just point the browser to admincp/index.php?do=buildbitfields

I think i'll write a FAQ with some bold, red, blinking text in size 7:
Upload Bitfields XMLs before importing Products!

#**108** 10-01-2005, 03:30 AM

Quote:

Originally Posted by KirbyDE

Just a note:
Enabling debug mode is not necessary to rebuild bitfields.
Just point the browser to admincp/index.php?do=buildbitfields

I think i'll write a FAQ with some bold, red, blinking text in size 7:
Upload Bitfields XMLs before importing Products!

Kirby to the rescue again.

erratic assasin · #**109** 10-01-2005, 01:24 PM

Quote:

Originally Posted by iguanairs

You posted some pretty ignornat comments in the affiliates thread when it messed up your board. I guess you are smart enough to know that installing modifications is done at the users risk?

People like you ruin the boards and prevent some mods from being released. If it says beta, don't touch it. Those of us that know how to deal with and work out issues will install it. Sit on your hands like a good boy and wait for us to release the debugged version. Don't start running your mouth when you apparently can't do any of this yourself. This site doesn't need you....you need this site! Grow up and start showing a little gratitude. Modifications are free and no one gets paid for the time they take to write. When you are releasing mods, +++++ all you want. Until then, shut your mouth.

I agree with you I did check to see if it was a beta when I downloaded and installed guess I missed the tick in the box! and yes I have alot to learn... and you are right I do need this site more than it needs me...there is no excuse for my behaviour please forgive me ....:nervous:

I will go on bended knee and beg forgiveness!

@Danny VBT I am truly sorry for my outburst for that I have no excuses

@Any one else I offended I apologize!

yours (ashamedly)

Erratic assasin

Thank you iguanairs for your PM!

Capricia · #**110** 10-02-2005, 07:29 PM

I could use some help please, I just installed the first version tonight (1.4) I got errors then I read this thread and downloaded the newer version (1.7) still errors. Can anyone tell me what I'm doing wrong and how to fix this?

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM celestial affiliates_settings;

MySQL Error : Table 'd2751dig_new.celestial' doesn't exist
Error Number : 1146
Date : Sunday, October 2nd 2005 @ 11:27:30 PM
Script : http://www.celestialfaeries.com/affiliate.php
Referrer : http://www.celestialfaeries.com/index.php
IP Address : 212.238.236.169
Username : Vivianne
Classname : vb_database

And I get this in the ACP

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM celestialaffiliates_settings;

MySQL Error : Table 'd2751dig_new.celestialaffiliates_settings' doesn't exist
Error Number : 1146
Date : Sunday, October 2nd 2005 @ 11:30:04 PM
Script : http://www.celestialfaeries.com/admi...hp?do=settings
Referrer : http://www.celestialfaeries.com/admincp/index.php
IP Address : 212.238.236.169
Username : Vivianne
Classname : vb_database

subnet_rx · #**111** 10-03-2005, 10:28 PM

I'm getting this error when I try to run the cron job:

Fatal error: Call to a member function on a non-object in /includes/cron/affiliate_emptyrec.php on line 10

mcyates · #**112** 10-04-2005, 05:07 PM

I get this error when updating the usergroups.

Code:

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

mcyates · #**113** 10-04-2005, 05:12 PM

i've disabled this from my board for the time being.

mcyates · #**114** 10-04-2005, 05:12 PM

also i get this when running the cron job

Code:

Fatal error: Call to a member function on a non-object in /home/myfootba/public_html/includes/cron/affiliate_emptyrec.php on line 10

#**115** 10-04-2005, 08:35 PM

Quote:

Originally Posted by mcyates

I get this error when updating the usergroups.

Code:

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

Did you make sure to Upload the xml files before importing the product?

#**116** 10-04-2005, 08:37 PM

Quote:

Originally Posted by mcyates

also i get this when running the cron job

Code:

Fatal error: Call to a member function on a non-object in /home/myfootba/public_html/includes/cron/affiliate_emptyrec.php on line 10

Open up affiliate_emptyrec.php and put this right after <?php

PHP Code:


			
require_once('./global.php');

mcyates · #**117** 10-05-2005, 06:22 AM

Quote:

Originally Posted by Danny.VBT

Did you make sure to Upload the xml files before importing the product?

I uploaded it to the XML folder on the forum and imported it that way, it worked. The files cpnav_affiliates.xml and bitfield_vbaffiliates.xml where already on the server when i imported the file from my computer. I don't know why it didn't work when importing thr xml file from my pc. It worked when i uploaded it to the includes/xml directory. Thanks

mcyates · #**118** 10-06-2005, 01:40 PM

also the script does not send out any emails to new sites that join up. There is no option to delete sites in the lists.

Blackbeard · #**119** 10-07-2005, 01:40 PM

Is this going to be made into gold version, dont want to install a rc version then have to play again in a day or two

#**120** 10-07-2005, 03:45 PM

I'm upgrading the hack tonight that fixes various bugs...if no other bugs occur then it will be upgraded to Beta 2...then finally to GOLD.

Blackbeard · #**121** 10-07-2005, 04:19 PM

cheers m8

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.19308 seconds Memory Usage 2,613KB 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 (5)bbcode_code (5)bbcode_php (24)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 (4)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!