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.

Daniel · #2 09-18-2005, 05:39 AM

Loving it, loving it... nice.

#3 09-18-2005, 05:41 AM

For some reason it wont let me add any more screen shots...it looks exactly the same as the one for 3.0.x, so you can look at that thread untill I upload the screenies.

erratic assasin · #4 09-18-2005, 07:07 AM

Thanks dude you must have read my mind....lol....."instal clicked"

erratic assasin · #5 09-18-2005, 07:38 AM

Parse error: parse error, unexpected ';' in /home/****/*****/*****/affiliate.php on line 575

any ideas?

also

<td class="vbmenu_control"><a href="$vboptions[bburl]/memberlist.php?$session[sessionurl]">$vbphrase[members_list]</a></td>

is not in my navbar template.... :ermm:

Snake · #6 09-18-2005, 11:05 AM

Live demo please?

FleaBag · #7 09-18-2005, 02:22 PM

Great work Danny! Will install tomorrow... Can't wait for vBspace now...

#8 09-18-2005, 02:52 PM

I'm going to work now, I'll sort the bugs once I get home.

Impreza04 · #9 09-18-2005, 08:24 PM

I get this error when trying to update my usergroups even when Ive uninstalled the product..

PHP Code:


			
Invalid SQL:

UPDATE vB_usergroup SET



### UPDATE QUERY GENERATED BY fetch_query_sql() ###

       `title` = 'Administrators',

       `description` = '',

       `usertitle` = 'Administrator',

       `opentag` = '',

       `closetag` = '',

       `passwordexpires` = '0',

       `passwordhistory` = '0',

       `ucash_paycheck` = '0.00',

       `forumpermissions` = '68157439',

       `attachlimit` = '0',

       `pmquota` = '50',

       `pmpermissions` = '3',

       `pmsendmax` = '5',

       `calendarpermissions` = '63',

       `wolpermissions` = '31',

       `adminpermissions` = '3',

       `genericpermissions` = '205520831',

       `genericoptions` = '31',

       `profilepicmaxwidth` = '100',

       `profilepicmaxheight` = '100',

       `profilepicmaxsize` = '65535',

       `avatarmaxwidth` = '120',

       `avatarmaxheight` = '120',

       `avatarmaxsize` = '20000',

       `ecdownloadpermissions` = '2047',

       `vbaffiliatespermissions` = '0'

WHERE usergroupid=6;



MySQL Error  : Unknown column 'vbaffiliatespermissions' in 'field list'

Error Number : 1054

#10 09-18-2005, 11:36 PM

Quote:

Originally Posted by Impreza04

I get this error when trying to update my usergroups even when Ive uninstalled the product..

PHP Code:


			
Invalid SQL:

UPDATE vB_usergroup SET



### UPDATE QUERY GENERATED BY fetch_query_sql() ###

       `title` = 'Administrators',

       `description` = '',

       `usertitle` = 'Administrator',

       `opentag` = '',

       `closetag` = '',

       `passwordexpires` = '0',

       `passwordhistory` = '0',

       `ucash_paycheck` = '0.00',

       `forumpermissions` = '68157439',

       `attachlimit` = '0',

       `pmquota` = '50',

       `pmpermissions` = '3',

       `pmsendmax` = '5',

       `calendarpermissions` = '63',

       `wolpermissions` = '31',

       `adminpermissions` = '3',

       `genericpermissions` = '205520831',

       `genericoptions` = '31',

       `profilepicmaxwidth` = '100',

       `profilepicmaxheight` = '100',

       `profilepicmaxsize` = '65535',

       `avatarmaxwidth` = '120',

       `avatarmaxheight` = '120',

       `avatarmaxsize` = '20000',

       `ecdownloadpermissions` = '2047',

       `vbaffiliatespermissions` = '0'

WHERE usergroupid=6;



MySQL Error  : Unknown column 'vbaffiliatespermissions' in 'field list'

Error Number : 1054

Did you remove the xml file? and rebuild bitfields?

Also, the hack has been updated to BETA 1.0.2 which should fix the affiliate.php parse error.

loonytune15 · #11 09-19-2005, 01:29 PM

I hope it runs better than the vb3 one, i had nothing but probs with it.

Impreza04 · #12 09-19-2005, 01:38 PM

I get this error when Importing the product.

PHP Code:


			
Parse error: parse error, unexpected '<' in /home/imp04/public_html/forum/admincp/plugin.php(1192) : eval()'d code on line 1

Sorry to be a pain..

erratic assasin · #13 09-19-2005, 06:21 PM

Oh dear this hack needs some major work! more errors than a dyslexic school boy.. at the momment im trying to rebuild my board thanks for the extra work load dude....

user groups .. will not let me add a new group ???

removed XML files and still .. wont let me???

my advise "DO NOT INSTALL BETA VERSIONS"

BamaStangGuy · #14 09-19-2005, 06:33 PM

Quote:

Originally Posted by erratic assasin

Oh dear this hack needs some major work! more errors than a dyslexic school boy.. at the momment im trying to rebuild my board thanks for the extra work load dude....

user groups .. will not let me add a new group ???

removed XML files and still .. wont let me???

my advise "DO NOT INSTALL BETA VERSIONS"

Quote:

my advise "DO NOT INSTALL BETA VERSIONS"

Your... not smart...

If everyone had your mentality EVERYTHING would remain beta including the very forum software you are using.

AN-net · #15 09-19-2005, 07:04 PM

Quote:

Originally Posted by erratic assasin

Oh dear this hack needs some major work! more errors than a dyslexic school boy.. at the momment im trying to rebuild my board thanks for the extra work load dude....

user groups .. will not let me add a new group ???

removed XML files and still .. wont let me???

my advise "DO NOT INSTALL BETA VERSIONS"

wow someone is ungrateful...

Glovebox · #16 09-19-2005, 07:24 PM

Whats ungrateful about it? It doesnt work and it messes up the database and usergroups. Rude and offensive yes, but not ungrateful.

Adam

erratic assasin · #17 09-19-2005, 07:39 PM

read below!

erratic assasin · #18 09-19-2005, 07:49 PM

Quote:

Originally Posted by BrentWilson

Your... not smart...

If everyone had your mentality EVERYTHING would remain beta including the very forum software you are using.

sorry if you feel that my comments where out of place! but when you are limited in .php and your board has been running well until you install said hack you do tend to get a little pissed...

My apologise to the author of the hack .... I was angry and well theres no excuse....sorry for my outburst..

@Brent-Wilson mind your "expletive" business! when I want your opinion I will ask for it!

Quote:

Your... not smart...

smart enough to warn peeps who do not know much about .php that this hack has more holes than dutch cheese..

anyway what are you married to the author?

and do you own a mustang?

erratic assasin · #19 09-19-2005, 07:59 PM

Quote:

Originally Posted by AN-net

wow someone is ungrateful...

Question "DID YOU INSTALL IT????" Hmm I wonder why??? :speechless:

AN-net · #20 09-19-2005, 08:06 PM

Quote:

Originally Posted by erratic assasin

Question "DID YOU INSTALL IT????" Hmm I wonder why??? :speechless:

actually i initially created this hack

erratic assasin · #21 09-19-2005, 08:49 PM

Quote:

Originally Posted by AN-net

actually i initially created this hack

Yep and heres another members quote""

Quote:

Originally Posted by loonytune15

I hope it runs better than the vb3 one, i had nothing but probs with it.

seems nether of you could get it right....

#22 09-19-2005, 09:06 PM

This is BETA for a reason, and anyone who has installed this on a live board should not complain to me. I don't mean to sound rude, but that's how it is.

I'll look into the bugs now...

#23 09-19-2005, 09:15 PM

Okay, this should fix the product import bug. I put php tags in the install code which caused the problem. Uninstall orignal product, Reupload product and install, on a test board.

I also appreciate everyone who gave constructive comments, and reported bugs. Thank you.

Glovebox · #24 09-19-2005, 09:24 PM

Still getting this on install danny:

Parse error: parse error, unexpected '<' in /home/*****/public_html/admincp/plugin.php(1156) : eval()'d code on line 1

AN-net · #25 09-19-2005, 09:24 PM

Quote:

Originally Posted by erratic assasin

Yep and heres another members quote""

seems nether of you could get it right....

someone is in a grouchy mood>_>

#26 09-19-2005, 09:43 PM

Quote:

Originally Posted by Glovebox

Still getting this on install danny:

Parse error: parse error, unexpected '<' in /home/*****/public_html/admincp/plugin.php(1156) : eval()'d code on line 1

Forgot to upload the new .zip package. Try now, thanks again for your patience.

Glovebox · #27 09-19-2005, 10:18 PM

Looking better bud, just a couple of things I picked up regarding phrases:

Maybe more than this but I havent checked it out fully yet.

Adam

Edit: Also

MySQL Error : Unknown column 'vbaffiliatespermissions' in 'field list'
When trying to do anything with usergroup permissions.

#28 09-19-2005, 10:21 PM

Okay, seems like I forgot to add the phrases to the Product. Will update, thanks for the report.

#29 09-19-2005, 10:32 PM

Doh! I forgot to tell you to run the query needed. That's what is causing the permissions error.

Glovebox · #30 09-19-2005, 10:38 PM

You've lost me there matey, sorry! ;-)

#31 09-19-2005, 10:42 PM

Quote:

Originally Posted by Glovebox

You've lost me there matey, sorry! ;-)

Lol, I'm just talking to myself I guess. I'll provide an update that will do it automatically.

#32 09-19-2005, 11:13 PM

Okay, another update.

BETA 1.0.4 should fix the usergroup permission error, and also add the missing queries.

erratic assasin · #33 09-20-2005, 03:56 AM

@ Danny yeah your right! Im an ass .. Nice work .. and thank you ... :squareeyed:

Brinnie · #34 09-20-2005, 04:18 AM

can u use images?
if yes, can u specify a max width x height?

Impreza04 · #35 09-20-2005, 02:24 PM

Ok.. now im gonna be a real pain:

Affiliateadmin.php

PHP Code:


			
Parse error: parse error, unexpected ',' in /home/imp04/public_html/forum/admincp/affiliateadmin.php on line 193

affiliate.php

PHP Code:


			
Database error in vBulletin 3.5.0 Release Candidate 3:



Invalid SQL:

SELECT * FROM vB_ affiliates_settings;



MySQL Error  : Table 'imp04_vbulliten.vB_' doesn't exist

Error Number : 1146

Date         : Tuesday, September 20th 2005 @ 08:19:25 AM

Script       : http://www.playstation-racing.co.uk/forum/affiliate.php

Uninstalling

PHP Code:


			
Database error in vBulletin 3.5.0 Release Candidate 3:



Invalid SQL:

DROP TABLE affiliates;



MySQL Error  : Unknown table 'affiliates'

Error Number : 1051

Date         : Tuesday, September 20th 2005 @ 08:23:42 AM

Script       : http://www.playstation-racing.co.uk/forum/admincp/plugin.php

Glovebox · #36 09-20-2005, 03:28 PM

Thanks for your help Danny, works great now.

Minor niggle:

Code:

Appears at top of affialiates page, see my site to see what I mean.

Adam

#37 09-20-2005, 09:35 PM

Glovebox,

Look in your affiliate template, and there should be "Code:" there, remove it and it will fix it.

Impreza04, I fix the affiliateadmin.php error, I will upload it tonight. Also, it seems like you didn't properly install the product because the tables don't exist...

Brinnie,
Yes you can use image, and I think there is a set width. Check the admin cp setting of the hack.

jugo · #38 09-21-2005, 02:56 AM

go into the AFFILIATE template and remove Code:

And go into line 193 of the affiliateadmin.php file and change it to this:

Code:

	print_stop_message('approved_affiliate_x_successfully', $sitename);

Thanks Danny...awesome work..

Omega Prime · #39 09-21-2005, 03:06 AM

Is there any means to using this if the affiliate system was installed with 3.0.x? What I mean is that I tried running the plugin and got this:

Code:

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

MySQL Error  : Table 'affiliates' already exists

I suppose I could just drop the old tables, but I had hoped that this would be more of an upgrade than a fresh install

Hawkbizkit · #40 09-21-2005, 03:57 AM

you forgot to add the " . TABLE_PREFIX . " in the xml for those of us that use prefix's like myself

Edit: also in the uninstall code to remove the usergroup database info your plugin added you put DELETE instead of DROP..

Edit2: well it looks like in the affiliateadmin.php you put a ton of spaces after the table prefix codes all over the place which cause many errors...

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.20408 seconds Memory Usage 2,616KB Queries Executed 54 (?)
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 (2)bbcode_code (6)bbcode_php (13)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 (2)pagenav_pagelink (40)post_thanks_box (40)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (40)post_thanks_postbit_info (39)postbit (28)postbit_onlinestatus (40)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!