The Arcive of Official vBulletin Modifications Site.

Forum Welcome Text per Forum... · **Released**: 01-11-2003

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:

install_forumwelcometext_txt.php

Install Info:
Hack Version: 1.0
Files to edit: 2
Templates to add: 1
Templates to edit: 1
Queries to Run: 2
Time to install: Approx 5-7 Minutes

Credits
Requested by - assassingod

Support - 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 set a Welcome Text message (HTML can be used) for the forum/forums of your choice

Additional Info/Updates

Forum Welcome Text Info : The "Activate Forum Welcome?" option must be set to "YES" for this to enable the Forum Welcome Text.

Screenshots/Live Demo

See the posts below

Enjoy!

Satan

Chris M · #12 01-12-2003, 04:50 PM

All appears to be ok now

Satan

assassingod · #13 01-12-2003, 04:52 PM

Sweeet

Excellent hack! Thanks a million hellsatan

[high]* assassingod licks install[/high]

Chris M · #14 01-12-2003, 05:00 PM

[high]* Chris M licks, er...something

[/high]

Your welcome ag

Satan

Dean C · #15 01-12-2003, 05:26 PM

Looks really good satan - similar to filburt's hack and the forum header/footer hack

But i know you would have coded this yourself so good on ya

Regards

- miSt

Chris M · #16 01-12-2003, 06:47 PM

It is? I didn't even know that it existed:bored:

Ah well

Thanks!

Satan

Okiewan · #17 01-12-2003, 09:40 PM

:devious:

Quote:

MySQL said:
You have an error in your SQL syntax near 'ALTER TABLE `forum` ADD `welcometext` BLOB NOT NULL' at line 2

vLIMIT Sandman · #18 01-12-2003, 10:08 PM

Execute them separately. I got the something.

Run:

PHP Code:


			
ALTER TABLE `forum` ADD `enablewelcome` smallint(6) DEFAULT '0' NOT NULL

Then Run

PHP Code:


			
ALTER TABLE `forum` ADD `welcometext` BLOB NOT NULL

Great hack btw. Much like the ubb standard.

msu · #19 01-13-2003, 10:38 AM

nice hack

i like yr hacks man , keep going

installing . . .

bitbender · #20 01-15-2003, 01:34 PM

me too...

/me clicks *download* and then *install*

Okiewan · #21 01-16-2003, 04:00 PM

Anyone tried to add a new forum after installing this hack?
Getting MSQL errors!

Quote:

Database error in vBulletin Control Panel 2.2.1:

Invalid SQL: INSERT INTO forum
(forumid,styleid,title,description,active,displayo rder,parentid,
parentlist,allowposting,cancontainthreads,sponsorn ame,sponsorimg,
sponsorurl,daysprune,newpostemail,newthreademail,
moderatenew,allowhtml,allowbbcode,allowimages,allo wsmilies,allowicons,
styleoverride,allowratings,countposts,moderateatta ch,allowguestpostview,enablewelcome,welcometext)
VALUES
(NULL,'36','ProCircuit Direct','Questions/Discussions relating to ProCircuit products and services. Monitored by ProCircuit\'s Travis Wicks.','1','1','107',
'','1','1','30','','',
'0','0','1','0','1','1',
'1','1','1','0','0','')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Thursday 16th of January 2003 11:55:56 AM

Whats the best way to reverse the sql queries? Just delete the tables they created?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04861 seconds Memory Usage 2,308KB 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 (2)bbcode_php (2)bbcode_quote (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 (2)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!