The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 11-18-2001

Updated 30 Nov 2001
Fixed a typo and Birthday Date Bug
---------------------------------------------

Here's a new version of the Community Bulletin + HTML
With the changes and the inclusion of the news section I have
titled it News and Email Community Bulletin Generator.

Here's a list of the changes/modifications that were made

Include News Articles (Threads) in bulletin.
Remove vbCode from news articles before sending email.
User email options include HTML or Text.
Forums are sorted by displayorder.
Category forums do not contain yes/no option.
Private forums marked as no by default.
Fix lasteventdate bug.
Modify admin/index.php installation instructions for version 2.2.x and version 2.0.x.
Include Admin CP edit user option to include Receive Community Email Bulletin and Type (HTML or TEXT).
Remove user password, send link instead.
Preview of HTML and TEXT email.
Post to Forum can be HTML or TEXT
Modified a few mysql SELECT * queries to include only necessary fields.
Cosmetic changes
......

To install
Copy the commbull.php file to the admin/ directory.
WIth a web browser access the commbull.php file.

Example: http: //yoursite.com/forums/admin/commbull.php

Follow the additional installation instructions.

This hack is based on Community Bulletin Generator by Kier
and additional Community Bulletin Generator functions by Kevin

Additional: This hack has only been tested on my machines. I don't have the ability to send emails
to a lot of users so this has not been tested either.

Remember: BACKUP and TEST.
213

sccr410 · #62 01-29-2002, 07:34 PM

How can I edit the register.php file so people can decide to subscribe to a newsletter when they register?

DJ FRESCO · #63 02-11-2002, 03:10 PM

What to do now??? Please advise

thanks,

dj fresco

Database error in vBulletin Control Panel: Invalid SQL: SELECT userid,username,birthday FROM user WHERE SUBSTRING(birthday,6)>='02-11' AND SUBSTRING(birthday,6)<='02-25' ORDER BY SUBSTRING(birthday,6) LIMIT 0,10
mysql error: You have an error in your SQL syntax near 'SUBSTRING(birthday,6) LIMIT 0,10' at line 1
mysql error number: 1064
Date: Monday 11th of February 2002 12:08:05 PM
Script: /forum/admin/commbull.php
Referer: http://www.djfresco.com/forum/admin/commbull.php

centris · #64 02-11-2002, 04:55 PM

Quote:

Originally posted by sccr410
How can I edit the register.php file so people can decide to subscribe to a newsletter when they register?

If you apply the script hacks "member.php and admin/index.php" and the modifyoptions template addition this option will be included in the member registration area by default and the Admin CP.

DJ FRESCO
Check member.php for script errors if you hacked this script.

DJ FRESCO · #65 02-11-2002, 06:40 PM

I made sure to check my hack code everything is okay... This is the error I get now:

Database error in vBulletin Control Panel 2.2.2:

Invalid SQL: SELECT userid,username,birthday FROM user WHERE SUBSTRING(birthday,6)>='02-11' AND SUBSTRING(birthday,6)<='02-25' ORDER BY SUBSTRING(birthday,6) LIMIT 0,10
mysql error: You have an error in your SQL syntax near 'SUBSTRING(birthday,6) LIMIT 0,10' at line 1

mysql error number: 1064

Date: Monday 11th of February 2002 03:28:57 PM
Script: http://www.djfresco.com/forum/forum/admin/commbull.php
Referer: http://www.djfresco.com/forum/admin/commbull.php

slideboxer · #66 02-13-2002, 03:32 AM

I keep getting the following databse error whenever I include the birthdays in the bulletin:

Quote:

Database error in vBulletin Control Panel 2.2.2:

Invalid SQL: SELECT * FROM user WHERE SUBSTRING(birthday,6)>='02-13' AND SUBSTRING(birthday,6)<='02-27' ORDER BY SUBSTRING(birthday,6) LIMIT 0,10
mysql error: You have an error in your SQL syntax near 'SUBSTRING(birthday,6) LIMIT 0,10' at line 1

mysql error number: 1064

Works fine and well when I set the birthdays/events stuff to 0, but otherwise I get the error. Ideas?

DJ FRESCO · #67 02-13-2002, 10:06 AM

That worked

over · #68 02-13-2002, 10:40 AM

seems a good hack

gonna install it

Held der Nacht · #69 02-13-2002, 06:22 PM

hello,

i have a small problem.

When a User want get his Mail as text, then he get a E-Mail with a .txt file. How i can change it, that the Text is in the Mail without a .txt file ?

I hope anybody can me help.

Thx.

slideboxer · #70 02-19-2002, 03:44 AM

Quote:

Originally posted by slideboxer
I keep getting the following databse error whenever I include the birthdays in the bulletin:

Quote:

Database error in vBulletin Control Panel 2.2.2:

Invalid SQL: SELECT * FROM user WHERE SUBSTRING(birthday,6)>='02-13' AND SUBSTRING(birthday,6)<='02-27' ORDER BY SUBSTRING(birthday,6) LIMIT 0,10
mysql error: You have an error in your SQL syntax near 'SUBSTRING(birthday,6) LIMIT 0,10' at line 1

mysql error number: 1064

Works fine and well when I set the birthdays/events stuff to 0, but otherwise I get the error. Ideas?

*bump*

Also, receiving this error message while executing the mailings:

Quote:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/www/abudokan/forums/admin/commbull.php on line 932

Is this simply from sending too many (300) mails at a time?

christec · #71 02-19-2002, 01:06 PM

Quote:

Is this simply from sending too many (300) mails at a time?

Yes

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04654 seconds Memory Usage 2,312KB 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 (6)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 (4)pagenav_pagelink (1)pagenav_pagelinkrel (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!