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

MaxScript · #**212** 10-22-2003, 08:04 PM

vb3 b7 ?

can we get it to work there ?

vfxtalk · #**213** 03-07-2004, 06:17 AM

any chance we could revive this hack for vB 3 ?? would be a fantastic hack!!

diettalk · #**214** 03-07-2004, 10:06 AM

Here...

Quote:

Originally Posted by vfxtalk

any chance we could revive this hack for vB 3 ?? would be a fantastic hack!!

memobug · #**215** 03-08-2004, 09:22 PM

I am pretty sure there is a bug in this hack that prevents you from adding new members!

1) Whenever I try a to manually add a new user with admin cp, I get a MYSQL error that says

"Column count doesn't match value count at row 1"

It dumps the terms, which I compared and they don't add up.

I looked at step 2

PHP Code:


			
2 of 4

Then Find This:

    $DB_site->query("INSERT INTO user (userid,usergroupid,username,password,email,styleid,parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,showemail,invisible,usertitle,customtitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,emailnotification,receivepm,emailonpm,ipaddress,pmpopup,options,birthday) VALUES (NULL,'$usergroupid','".addslashes(htmlspecialchars($ausername))."','".addslashes(md5($apassword))."','".addslashes(htmlspecialchars($email))."','$userstyleid','".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','$customtitle',$joindate,'$cookieuser','$daysprune',$lastvisit,$lastactivity,$lastpost,'$posts','$timezoneoffset','$emailnotification','$receivepm','$emailonpm','".addslashes($aipaddress)."','$pmpopup','$options','birthday')");



Replace With:

    $DB_site->query("INSERT INTO user (userid,usergroupid,username,password,email,styleid,parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,receivebulletin,receivebulletin_type,showemail,invisible,usertitle,customtitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,emailnotification,receivepm,emailonpm,ipaddress,pmpopup,options,birthday) VALUES (NULL,'$usergroupid','".addslashes(htmlspecialchars($ausername))."','".addslashes(md5($apassword))."','".addslashes(htmlspecialchars($email))."','$userstyleid','".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$receivebulletin',      (THERE SHOULD BE A '$receivebulletin_type', here!!!!!)                                    '$showemail','$invisible','".addslashes($usertitle)."','$customtitle',$joindate,'$cookieuser','$daysprune',$lastvisit,$lastactivity,$lastpost,'$posts','$timezoneoffset','$emailnotification','$receivepm','$emailonpm','".addslashes($aipaddress)."','$pmpopup','$options','birthday')");

And it looks like '$receivebulletin_type', is missing from the REPLACE WITH section. I added it back in and everything seems to be fine.

Could someone verify this, please?

Gary King · #**216** 03-08-2004, 11:06 PM

[QUOTE=memobug]I am pretty sure there is a bug in this hack that prevents you from adding new members!

1) Whenever I try a to manually add a new user with admin cp, I get a MYSQL error that says

"Column count doesn't match value count at row 1"

It dumps the terms, which I compared and they don't add up.

I looked at step 2

PHP Code:


			
2 of 4

Then Find This:

    $DB_site->query("INSERT INTO user (userid,usergroupid,username,password,email,styleid,parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,showemail,invisible,usertitle,customtitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,emailnotification,receivepm,emailonpm,ipaddress,pmpopup,options,birthday) VALUES (NULL,'$usergroupid','".addslashes(htmlspecialchars($ausername))."','".addslashes(md5($apassword))."','".addslashes(htmlspecialchars($email))."','$userstyleid','".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','$customtitle',$joindate,'$cookieuser','$daysprune',$lastvisit,$lastactivity,$lastpost,'$posts','$timezoneoffset','$emailnotification','$receivepm','$emailonpm','".addslashes($aipaddress)."','$pmpopup','$options','birthday')");



Replace With:

    $DB_site->query("INSERT INTO user (userid,usergroupid,username,password,email,styleid,parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,receivebulletin,receivebulletin_type,showemail,invisible,usertitle,customtitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,emailnotification,receivepm,emailonpm,ipaddress,pmpopup,options,birthday) VALUES (NULL,'$usergroupid','".addslashes(htmlspecialchars($ausername))."','".addslashes(md5($apassword))."','".addslashes(htmlspecialchars($email))."','$userstyleid','".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$receivebulletin',      (THERE SHOULD BE A '$receivebulletin_type', here!!!!!)                                    '$showemail','$invisible','".addslashes($usertitle)."','$customtitle',$joindate,'$cookieuser','$daysprune',$lastvisit,$lastactivity,$lastpost,'$posts','$timezoneoffset','$emailnotification','$receivepm','$emailonpm','".addslashes($aipaddress)."','$pmpopup','$options','birthday')");

And it looks like '$receivebulletin_type', is missing from the REPLACE WITH section. I added it back in and everything seems to be fine.

Could someone verify this, please?

memobug · #**217** 03-08-2004, 11:19 PM

I would appreciate it if you would take another look Gary. I just downloaded the hack again from Post #1 in this thread for comparison with what I installed months ago and that parameter($receivebulletin_type) is definitely missing from the VALUES portion of the replacement string.

Whether you do or don't have it - can you verify that you can add a forum member manually - from admin cp USER->ADD - without getting a PHP error on submit?

Thanks & regards,

Matt

Gary King · #**218** 03-08-2004, 11:38 PM

[QUOTE=memobug]I would appreciate it if you would take another look Gary. I just downloaded the hack again from Post #1 in this thread for comparison with what I installed months ago and that parameter($receivebulletin_type) is definitely missing from the VALUES portion of the replacement string.

Whether you do or don't have it - can you verify that you can add a forum member manually - from admin cp USER->ADD - without getting a PHP error on submit?

Thanks & regards,

Matt

Highlander · #**219** 04-03-2004, 05:11 AM

WHHOOOOPSS .. great great HACK .. *installed*

memobug · #**220** 04-03-2004, 06:23 AM

Highlander, would you verify whether YOU can use the Admin panel to manually add a member without having an SQL error?

(Maybe it is just the version of SQL I am running that wants the term count to match the values)

Regards,

Matt

P.S. For some odd reason, I got three copies of the notification email for your post!

Highlander · #**221** 04-06-2004, 03:01 AM

.. threa mails?
i get no errors when i start a bulletin and write a username in the file dof the Comm Generator ..did you mean that?

or where else i can write a username in a field?

Wich version do you have? Maybe PHP Version problem.. i have 4.06 thats very old.. and i have to change very often manually some things.. you see the string and error in his exact place..so you can locate the string who do this error..so you can look for changing it to make it right

greating

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05048 seconds Memory Usage 2,359KB 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 (1)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 (3)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!