News & Email Community Bulletin Generator

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

[freeshares1]

I have one really quick question. I would like 2 things.

1 - On the calendar events i would like these to be hyperlinks like the thread links. anyone point me in the direction?

2 - I have many events on the same day and would like to put a line space between each day.

Thanks in advance

[Heineken77]

I have a problem

I installed this hack, and it works wonderfully!!! It emails the bulletin and everything!!

BUT .. now when I go into member.php ((for example, try to access anything that deals with member.php))) I get this error

Parse error: parse error, expecting `']'' in /home/hsphere/local/home/heineken/nba2k3.net/forum/member.php on line 902

My member.php file is attatched. Any ideas what I did wrong?

Sincerely,
Heineken

[christec]

Check your file, line 902 just ends, like it was cut off. At least in the file that you attached above.

[Heineken77]

Woohoo!! Chris bro I didn't even realize that!!

Thank you very much for pointing that out..I'm an idiot lol.

KILLER hack you guys put together here, and lovin' the HTML!!

Thanks again

[Aurore]

How could I get the dates in French?

Thank You

[DestyNova]

It works well but there is one small problem..

I have one vb at net and two at local (one clean install and one hacked with few hacks)

All three forums I test by add "username" thur Users category to add user and always get this error..

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: 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,'2','test2','ad0234829205b9033196ba818f7a872b','test2@hotmail.com','1','','0','http://www.','','','','','1','1','1','0','','0',1027736690,'1','-1',1027736690,1027736690,1027736690,'0','0','1','1','0','','0','15','birthday')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Friday 26th of July 2002 08:24:50 PM
Script: http://localhost/test
Referer:

At first I would think that one of hack screw it up so I decide to install new one without any kind of hack and test this hack, result is all same so this hack seem screw the database.
I have no problem with others like send this email community to members nor register new username by register at forum but not thur "add" at AdminCP cuz of this database error.

Any idea? I dont want to uninstall this hack cuz of that simple database error.

[Aurore]

When the bulletin is sent in text file to members, it is a file that is attach to the mail?

Any solution ?

Thanks

[Aaron RV]

Hi.

This hack tested for 2.2.6?

Thank's.

[Aurore]

Tested on a vBulletin board 2.2.6

[Kars10]

Hello Guys!!
This is one of the greatest hacks ive ever saw...
but when i send the emails, it sends only to 78 People on my Board. Ive got 360 registered Members. Ive looked and everything seems alright. The Usergroupes i want to send the mail is checked.
Please help me. My Members ask why some of them don?t get the Newsletter...