The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 12-25-2002

Please do the following before attempting to install:

1.) Backup your Files before doing anything
2.) Be aware that although I have tested this myself, there may still be problems...If you do not backup your files, I cannot condone your install of this hack...
3.) If you want to Backup your Database, You can - There shouldn't be any need to...

The file you should have is:

vBaffiliates5.zip

Install Info:
Hack Version: 5.0 [Final]
Files to edit: 2
Templates to add:13 (New Install) / 0 (Upgrade from v4)
Templates to edit: As Many as needed (New Install) / Minimum of 1 (Upgrade)
Queries to Run: 6 (New Install) / 0 (Upgrade from v4)
Time to install: Approx 8-10 Minutes
Included files: There are 2 install files included - One is for upgrading from v4, and the other is for a new install - Do not mix them up

Credits
Requested by - DarkDraco07 here & Sinecure

Support - I am offering Support in this Thread ONLY...I unfortunately cannot be here during the coming weeks (Mon-Fri), so therefore you will have to rely on others for assitance, should it be urgent...If you do require assitance, please - Only reply in this thread

Hack info

What does it do? - Basically, you can allow registered board users to add Affiliation Links to the database, which have to be moderated by you...You can then display a Random Banner generated totally at random wherever you like, and it will be linked to the site of the submitter...Also it stores the Image Height and Width in the database, and you can limit the size of the Banners they can upload...If they change the image (located on their server) without editing their Banner, then it will not show up their Banner, Link, Hit Count, Edit Link or Site Name...They must then ask an Admin to update the Banner...Now there is also a List of the Banners on the site, and their Moderated Status...You can also choose how many Banners to show in the list

Testing

You can see the BETA Release here...

Changes since BETA

Changed the way that Links are shown
Added another Template to add

Changes since 1.0[Final]

Added missing re-direct template
Added another Template to add
Added image size restriction
Changed a template
Added an intelligent Image check to see if they changed the size of the image in an attempt to cheat the system

Changes since 2.0[Final]

Corrected forum/global.php mishap
Added a Hit Counter
Added a "User Edit" Screen
Changed a template
Update the Intelligent Image check to see if they changed the size of the image in an attempt to cheat the system

Changes since 3.0[Final]

Updated forum/global.php to show a Admin CP Options controlled number of Banners
Added a Banner List page, showing all the Banners and their Moderated Status
Added a Banner List page Banner Limit, to show only the number of Banners Randomnly that you want
Update the Intelligent Image check to see if they changed the size of the image in an attempt to cheat the system and put it in a while loop

Changes since 4.0[Final]

Updated forum/vbaffiliates.php to work with register_globals off, and modified code structure slightly
Updated admin/affiladmin.php to work with register_globals off, and modified code structure slightly

Additional Info/Updates

2.0[Final] - 2.0[Final] has just been released...This includes an Image Size restriction, and a clever system for those who think they can get around the system - It stores the image's height and width, and uses HTML to code the width and height of the image - If they change it, it will show a red "no image found" image instead...

3.0[Final] - 3.0[Final] has just been released...This includes an update to the Image Size restriction, and an update for the clever system for those who think they can get around the system - It stores the image's height and width, and uses HTML to code the width and height of the image - If they change it, it will not show their Banner, Link, Site Name, Edit Link or Hit Count...

4.0[Final] - 4.0[Final] has just been released...This includes an update to the Image Size restriction, and an update for the clever system for those who think they can get around the system - It stores the image's height and width, and uses HTML to code the width and height of the image - If they change it, it will not show their Banner, Link, Site Name, Edit Link or Hit Count...Now there is also a List of the Banners on the site, and their Moderated Status...You can also choose how many Banners to show in the list

5.0[Final] - 5.0[Final] has just been released...This release includes a new set of .php files which have been re-coded to work with register_globals off, and also the coding structure has been changed...

The next release is a List of "User's Banners" page, and a then a Timed function to set the Moderated status to 0 (No) when the time period expires...

Screenshots/Live Demo

There are NEW screenshots provided in the next post, in vBaffiliates5-screenshots.zip

Enjoy!

Satan

DarkDraco07 · #42 12-29-2002, 06:30 AM

can anyone tell me how to make it show more than 1 banner?
i changed the LIMIT 1 but it still shows 1

C.Birch · #43 12-29-2002, 09:21 AM

im having a really big prob adding anything to my database via phpmyadmin

eg try adding:

INSERT INTO settinggroup (settinggroupid,title,displayorder) VALUES (32,'vBaffiliates','99')

Get:
Error
SQL-query : [Edit]

INSERT INTO settinggroup (settinggroupid,title,displayorder) VALUES (32,\'vBaffiliates\',\'99\')

MySQL said:

You have an error in your SQL syntax near '\'vBaffiliates\',\'99\')' at line 1

Try:
CREATE TABLE `vbaffiliates` (
`linkid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(100) NOT NULL,
`link` VARCHAR(150) NOT NULL,
`b_link` VARCHAR(150) NOT NULL,
`moderated` smallint(6) DEFAULT '0' NOT NULL,
`height` smallint(6) NOT NULL,
`width` smallint(6) NOT NULL,
`hits` smallint(6) DEFAULT '0' NOT NULL,
`userid` smallint(6) NOT NULL
) TYPE = MYISAM;

Get:
Error
SQL-query : [Edit]

CREATE TABLE `vbaffiliates` (
`linkid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(100) NOT NULL,
`link` VARCHAR(150) NOT NULL,
`b_link` VARCHAR(150) NOT NULL,
`moderated` smallint(6) DEFAULT \'0\' NOT NULL,
`height` smallint(6) NOT NULL,
`width` smallint(6) NOT NULL,
`hits` smallint(6) DEFAULT \'0\' NOT NULL,
`userid` smallint(6) NOT NULL
) TYPE = MYISAM;

MySQL said:

You have an error in your SQL syntax near '\'0\' NOT NULL,
`height` smallint(6) NOT NULL,
`width` smallint(6) NOT NULL,
' at line 6

can someone help its doing it for almost everything i try that needs database work but it never used to

Chris M · #44 12-29-2002, 11:12 AM

Hmmm...

Perhaps you should install FireFly's "SQL Query via Admin CP" Hack...

All I can say is that the queries worked for me, but it looks like your phpmyadmin may have a problem...

Is it just this hack, or does it do it for others?

@DarkDraco07 - I am sure that changing the LIMIT value should work...

Satan

DarkDraco07 · #45 12-29-2002, 01:05 PM

i changed the limit to 99 and it still only shows 1 banner

DarkDraco07 · #46 12-29-2002, 01:08 PM

btw, i put the $affiliate var on the myvbindex page. does that have anything to do with my prob?

Chris M · #47 12-29-2002, 01:10 PM

Indeed...

I shall look into it...

Satan

DarkDraco07 · #48 12-29-2002, 04:36 PM

i tried puttin it on my forumhome template but it still shows 1

Chris M · #49 12-29-2002, 05:56 PM

@DarkDraco07 - I am releasing v4 soon, which has the option for this and much more

Satan

Chris M · #50 12-29-2002, 06:35 PM

v4 Released!

vBaffiliates4 has been released!

It includes a Banner List Page (with randomnly generated banners), a Limit to the Number of Banners to List on the page, and the Support for an Admin Options controlled Number of Banners to show

Satan

kevo · #51 12-29-2002, 07:46 PM

::clicks install::.. This looks great.. Is there going to be any other future versions?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.11032 seconds Memory Usage 2,310KB Queries Executed 25 (?)
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 (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)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 postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start 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!