News & Email Community Bulletin Generator

[christec]

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

[FWC]

Cool! I'll have to try this when I get home from work tonight. :)

[Princeton]

GREAT JOB! I was hoping for a text or html version.

thank you and keep up the great work.

[FWC]

I lied. I installed it during lunch. Excellent job!! :D

[DarkReaper]

Does this display the forums in a straight list or in a hierarchy?

[Robert Basil]

Well,

I told you in the other thread I'm not ready to give up on this hack. :)

I gave up on the script not being able to add the fields in my user table so I added them myself using these commands (Yes, it worked fine)


ALTER TABLE user ADD receivebulletin SMALLINT (5) UNSIGNED DEFAULT '1' not null



ALTER TABLE user ADD receivebulletin_type SMALLINT (5) UNSIGNED DEFAULT '1' not null


Then I made the changes according to the admin_commbull.txt

I then accessed the commbull.php via the web and yes, it FINALLY asked me for my admin username and password (This was my stumbling block with the old version)

I entered my username and password and then got the screen stating:

"User tables have been altered sucessfully.

Installation instructions for the News and Email Community Bulletin Generator. "

So I made all of the changes according to this file. And then I clicked on the "Go" button at the bottom of the page.

And....... nothing. :( The same install page just keeps repeating itself when I click on the "Go" button.


Sooooo close..........

Any ideas?

[christec]

Originally posted by DarkReaper
Does this display the forums in a straight list or in a hierarchy?

Hierarchy, just like the list is displayed in the modify forum section, Sorted by Categories, but listed in a straight line.

[christec]

And....... nothing. The same install page just keeps repeating itself when I click on the "Go" button.
Have you tried the link through the Admin CP

[Robert Basil]

Originally posted by christec

Have you tried the link through the Admin CP

Yes, it just keeps repeating itself there also.

[christec]

Originally posted by Sportbikeworld


Yes, it just keeps repeating itself there also.
How about www.yoursite.com/forums/admin/commbull.php?&action=info

[DarkReaper]

I already have the first version of this installed, what should I do to upgrade?

[christec]

Upgrade instructions
Copy the new commbull.php file over your existing (backup your old one first) one.
Access the commbull.php either through the Admin CP or directly through web browser.
Installation will appear and install new user table field.
Read the installation instructions. There are some additional fields to be added. Mainly for the "user option to select html or text" in a template and the member.php file.
For additional Admin options see the attached admin_commbull text file.

[christec]

Originally posted by Sportbikeworld


Yes, it just keeps repeating itself there also.

PROBLEM SOLVED

[christec]

In general, any comments or feedback?

[FWC]

Originally posted by christec
In general, any comments or feedback? This hack is wonderful!! The only feature left I could imagine asking for is remembering settings. Seriously, this is great work. I know you built upon a great hack, but your contribution shouldn't be underestimated.

People who are using earlier versions of this have no idea what they are missing. :)

[amykhar]

Thank you :) it was a nice upgrade.

Working fine and installation was a snap.

Amy

[JJR512]

Originally posted by christec
In general, any comments or feedback?
Yes. Is there an easy way to change the appearance of the HTML email sent out? Some easy way to change the colors, fonts, etc. Maybe make it take these things from the board's own styles.

[amykhar]

I noticed a SIGNIFICANT improvement in how many people actually came to check out the board because of the bulletin.

I have been sending out the old style bulletin for months, with pretty decent results. However, the new style brought in people that haven't logged on in ages. And they stuck around to read stuff instead of just going to the control panel to turn off the bulletin option.

Nice job :)

Amy

[christec]

Originally posted by JJR512

Yes. Is there an easy way to change the appearance of the HTML email sent out? Some easy way to change the colors, fonts, etc. Maybe make it take these things from the board's own styles.

It is pretty much hard coded. I wanted to keep the html output to a minimum. There are some color variables in the commbull.php file to change the colors. Just look for this section.

// HTML Color Variables
$cbgLink = "";
$cbgVLink = "";
$cbgALink = "";
$cbgTitleText = "#41344A";
$cbgTableHead = "#626194";
$cbgTHFontColor = "#FFF788";
$cbgTableCategory = "#A4A1CD";
$cbgTableCells = "#E7E7F1";

[centris]

Great update, the html bulletin looks awsome, thanks guys.

[RobAC]

The admin_commbull.txt file is in binary code in the zip file. I've downloaded it twice and I get the same thing.

[centris]

Originally posted by RobAC
The admin_commbull.txt file is in binary code in the zip file. I've downloaded it twice and I get the same thing.

sorry wrong file

[centris]

Commbull txt file;

[RobAC]

I installed this hack and tested it out. Nice job! However, just a couple things. Towards the top of the bulletin in front of one of the table tags is an extra { that shouldn't be there.

Also....towards the bottom, Recieve should be Receive. :D Would also be nice to see the total number of registered members in the Stats section. Other than that, looks great. Thanks!

[christec]

These extra " { and } " brackets that you're seeing are used to remove text when you post the bulletin to a forum. They are also removed when the bulletin is emailed. Example. The script generates each users info, like posts, last time the user visited ... These brackets surround the user info so when the bulletin is posted to a forum the user information is removed. If you remove the brackets then the post in the forum will show the users stats from the user generating the email. It also removes the news articles sections when you post to a forum. There is no reason to maintain multiple copies of the news information.

These brackets are also explained in the "Preview Email" section under the Community Bulletin Generator. :)

[Prince]

Why are there NO instructions to add this hack?

All I see in the zip are the Admin CP instructions.

Am I missing something here???

[FWC]

Originally posted by Prince
Why are there NO instructions to add this hack?

All I see in the zip are the Admin CP instructions.

Am I missing something here??? The instructions are in the installer that runs the first time you access the hack. Upload the file, edit your admin cp and run it. It will walk you through the rest.

[christec]

OK I will put install instructions on the first post.

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 installation instructions.

That's it.
:)

[Prince]

Oh, okay.

I installed the older version before I upgraded my VB to 2.2.1 and I thought I remembered having to edit some files...maybe not.

[christec]

The files to edit are listed in the commbull install instructions, which are displayed when you access the commbull file through a web browser.

[Sukij]

Hi..

Got problem !!! The Age behind the name is shift down.. Normally, Benjapa(26), Duengpon(34).... etc.
Please help..

UPCOMING BIRTHDAYS:
December 3: Benjapa
December 5: Duengpon (26)
December 5: Busakorn Laohawiroj (34)

[christec]

Originally posted by Sukij
Hi..
Got problem !!! The Age behind the name is shift down.. Normally, Benjapa(26), Duengpon(34).... etc.
Please help..


Birthday Fix:
Find This:

if ($user[birthday] != $lastbirthday) {
if ($datebits[0] != "0000") {
$currentdate = date($calformat2, mktime(0,0,0,$datebits[1],$datebits[2],0));
$birthdayspreview .=" <tr>\n";
$birthdayspreview .=" <td><font size=\"2\">$currentdate: <a href=\"$bburl/member.php?action=getinfo&userid=$user[userid]\">$user[username]$age</a></font></td>\n";
$birthdayspreview .=" </tr>\n";
// text mail option start
$text_birthdayspreview .= "\n$currentdate:\n";
// text mail option end
$age = " (".($thisyear - $datebits[0]).")";
} else {
$currentdate = date($calformat2, mktime(0,0,0,$datebits[1],$datebits[2],0));
$birthdayspreview .= " <tr>\n";
$birthdayspreview .=" <td><font size=\"2\">$currentdate: <a href=\"$bburl/member.php?action=getinfo&userid=$user[userid]\">$user[username]$age</a></font></td>\n";
$birthdayspreview .=" </tr>\n";
// text mail option start
$text_birthdayspreview .= "\n$currentdate:\n";
// text mail option end
$age = "";
}
}

Replace With This

if ($user[birthday] != $lastbirthday) {
if ($datebits[0] != "0000") {
$currentdate = date($calformat2, mktime(0,0,0,$datebits[1],$datebits[2],0));
$age = " (".($thisyear - $datebits[0]).")";
$birthdayspreview .=" <tr>\n";
$birthdayspreview .=" <td><font size=\"2\">$currentdate: <a href=\"$bburl/member.php?action=getinfo&userid=$user[userid]\">$user[username]$age</a></font></td>\n";
$birthdayspreview .=" </tr>\n";
// text mail option start
$text_birthdayspreview .= "\n$currentdate:\n";
// text mail option end
} else {
$currentdate = date($calformat2, mktime(0,0,0,$datebits[1],$datebits[2],0));
$age = "";
$birthdayspreview .= " <tr>\n";
$birthdayspreview .=" <td><font size=\"2\">$currentdate: <a href=\"$bburl/member.php?action=getinfo&userid=$user[userid]\">$user[username]$age</a></font></td>\n";
$birthdayspreview .=" </tr>\n";
// text mail option start
$text_birthdayspreview .= "\n$currentdate:\n";
// text mail option end
}
}

[christec]

News & Emil Community Bulletin Generator has been updated to fix a typo and the Birthday Date bug.

:)

[JJR512]

So just download the new .zip and upload the new commbull.php, and that's all there is? That will fix the problem Sukij mentioned, or do we still need to do what you said in Post 32?

[christec]

Originally posted by JJR512
So just download the new .zip and upload the new commbull.php, and that's all there is? That will fix the problem Sukij mentioned, or do we still need to do what you said in Post 32?

YES, Just download the new .zip file and then upload the new commbull.php file.
That's it.

[Steve Machol]

Great hack! One problem though - it doesn't find my Super Moderators even though I choose to send to them. Any ideas?

[DarkReaper]

Would it be possible to have it remember settings? That would help a LOT.

Also, I spent about 5 minutes getting the settings right, then hit preview, forgot someting, hit back, and it was reset! :(

[Steve Machol]

I have a problem that I need help with. Although I set:

"Only include threads that have been started or replied to since this date? Note: Only applies to sections sorted by Most Replies or Most Views (others automatically adhere to above date)"

....to 'Yes', the choices for Most Replies and Most Views does not adhere to the date I choose. Instead it chooses them from the beginning. How can I fix this?

[RobAC]

Is there a way to set NO as the default for the forums selected in the admin panel when putting the bulletin together? I only select a few forums, so I end up having to click NO on most of the forums that I have.

[christec]

Originally posted by smachol
I have a problem that I need help with. Although I set:

"Only include threads that have been started or replied to since this date? Note: Only applies to sections sorted by Most Replies or Most Views (others automatically adhere to above date)"

....to 'Yes', the choices for Most Replies and Most Views does not adhere to the date I choose. Instead it chooses them from the beginning. How can I fix this?

This option inlcludes the complete thread, not just the posts.
"Only include threads that have been started or replied to"

If a new thread is start on 1 May 2001 and the last post is 1 June 2001 and you select the date to be 25 May 2001, it will include this thread because of the last post being after 25 May.
Does that make sense?

[Steve Machol]

Yes, that makes sense. However it doesn't work that way. For instance I choose to include threads that only had new posts after 11/01/01. However the script chose threads that hadn't had any new posts since last March! I've done this several times with the exat same results. I'd appreciate any help you could provide in fixing this.

[christec]

Could this be related to ubb and need the ubbdatefix.php?

[Steve Machol]

Nope, I've already run ubbdatefix.php.

[christec]

Originally posted by DarkReaper
Also, I spent about 5 minutes getting the settings right, then hit preview, forgot someting, hit back, and it was reset! :(
Do you access the bulletin generator through the admin cp or directly to the file? I tested this with IE and through the admin cp, selected some options, clicked Preview Email, looked at it, clicked back, and all the options that I selected were still there.

[Steve Machol]

I access commbull.php directly. I don't have the desire or need to hack my admin/index.php file.

[Edit - Oops! I see your question wasn't directed to me.]

[christec]

Originally posted by smachol
Yes, that makes sense. However it doesn't work that way. For instance I choose to include threads that only had new posts after 11/01/01. However the script chose threads that hadn't had any new posts since last March! I've done this several times with the exat same results. I'd appreciate any help you could provide in fixing this.
Are you selecting the "Include Hot Threads only" option?

[Steve Machol]

[QUOTE]Originally posted by christec

Are you selecting the "Include Hot Threads only" option?

[christec]

Steve,
Can you post (or PM me) the exact options that you are selecting, excluding the forums and groups?

[Steve Machol]

Here's the options page:

[Steve Machol]

And here's the email it generated. Notice the 'Last Post On' dates:

[christec]

I can not replicate this problem on my machine. I'll keep looking though. I did notice that the thread (in pic) "The Future of Opticianry" had 83 replies and only 41 views. Is this correct. Could there be a problem with the database? Not sure, I just noticed that.

[Steve Machol]

The reason for the discrepancy in that thread is that thread when I was still running UBB. Since switching to vB it hasn't had many views.

[Steve Machol]

Any progress on figuring out the problem I'm having? I need to send out my monthly newsletter in the next couple of days and would like to use this. However I can't use it if it picks old threads.

Thanks for any help you can provide! :)

[christec]

After carefully looking at the dates you are choosing I am seeing (see pic) that you choose Jan 11, 2001. Every thread in the bulletin (see pic) is after that date. The format is day, month, year. Not month, day, year.
:D

[Steve Machol]

OMG, I feel so stupid! I was thinking like an American and assumed the first field was the month not the day. Thanks!

[FWC]

Originally posted by smachol
I was thinking like an American and assumed the first field was the month not the day. Thanks! I hate that when that happens. :)

[DarkReaper]

Originally posted by DarkReaper
Would it be possible to have it remember settings? That would help a LOT.

It would save time, as the settings wouldn't have to be re-configured every time...

[Sadie Frost]

(Edit: Answered my own stupid question lol)

This looks great, btw! :)

[Ninth Dimension]

This is a fantastic hack, i'm very very impressed with it, I do however have some questions (i'm sorry if these have already been asked)

First off, I would like to add the ability to change the users commbull details in the control panel, but the text file included in the zip file with the instructions on it is all squshed up, with no line breaks making it very hard to read.

second of all, I'm really interested in knowing how I might be able to edit the colours of the html email so they fit into my site better, how would I do this?

Edit OK, you can ignore the above, i've done it now :)

Cool script.

[Ninth Dimension]

This is a fantastic hack, however i've just noticed a problem with it. The Plain text mail that is sent out is fine, but the HTML email has a problem, none of the new lines (in the features news articles bit at the top) are converted to <br>'s in it, which means that it is all delered at one big block of text, which can be hard to read.

Now i'm no expert on this, but I should image this can be solved by using the nl2br() function, any ideas?

Thanx in advance, cool script.

[sccr410]

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

[DJ FRESCO]

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]

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]

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]

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

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]

That worked

[over]

seems a good hack :) gonna install it :D

[Held der Nacht]

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]

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

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:
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]

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

Yes

[Held der Nacht]

Can nobody help me ? :(

My users get the text mode e-mails as .txt file (textfile) in the mail.

[slideboxer]

Originally posted by DJ FRESCO
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

So what's the word on the fix for this error? I get it whenever I allow birthdays or events into the bulletin. Doesn't happen when I leave them as zero. ANyone get this to go?

[The Matrix 7]

My users get the text mode e-mails as .txt file (textfile) in the mail.

The problem is recovered

[pigsy]

Now we just need a way of saving the settings. Changing them each time is a real chore!

Good work though!

[pran]

Is it possible to configure the sender of the e-mail?

[Dan Flynn]

Hello,

Can anyone tell me what might be wrong. I sent a test email to myself.

The dates are all messed up. 1938????? plus recent post are from 38 and last post 2 uears ago in 2000.

Thanks

[cditty]

I seem to be having a problem in the members.php page. It doesn't seem to remember the yes/no choice the user made. It reflects it in the database, just not on the page itself.

Any tips?

Chris

[Ig@r]

Installed and tested!
Good job! Thank you!

Now, can I make it work with cron?

[cditty]

Can anyone offer any advice on this? I want to send a bulletin out to my people but I want them to be able to remove themselves if they want.

Chris

[christec]

Under the users control panel a user can select NOT to receive the community bulletin.

[cditty]

Right. But for some reason, on mine choice section, it does not show the user's current choice.

I have reinstalled this twice and even tried it with the older version and still had the same problem.

Chris

[cditty]

Anyone?

[The Matrix 7]

hello,

i want delete the option for html e-mails.

I want only send in text mod.

Can me anybody help, please ?

The Matrix

[cditty]

christec, any ideas on mine?

[Ninth Dimension]

why would you want to remove the html emails? this is the best part of this hack, although I will admit that the colour's used are not too good.

[The Matrix 7]

I have modifed the Newsletter and i don't want mal a HTML version.

I have now fixed my problem. I have delete the HTML option from the script.

The Matrix

[Ninth Dimension]

One thing that you might need to check is the database, i noticed that when I first run this hack, all of the members on my forum where automaticly set to get html emails, you will have to check that this is not true on your forum, or everyone is going to get html email anyway.

[xug]

Originally posted by cditty
Right. But for some reason, on mine choice section, it does not show the user's current choice.

I have reinstalled this twice and even tried it with the older version and still had the same problem.

Chris


I have the same problem as cditty and I hope somebody can help us out on this, lots of my members pm me constantly with this question, why it don't show up.


Please, please, please help us out.

Many thanks in advance to anyone who can figure out this little bug.

[centris]

Folks the optional hacks in admin/user.php (4) are what you need for this, also the modifyoptions template, member.php, I would re-check your code. This post is a bit late, have you got it sorted out?

[cditty]

Originally posted by xug



I have the same problem as cditty and I hope somebody can help us out on this, lots of my members pm me constantly with this question, why it don't show up.


Please, please, please help us out.

Many thanks in advance to anyone who can figure out this little bug.

Well, I'm glad to see that I am not the only one having this problem. I won't even send a newsletter out because if a use wants to unsubscribe, it'll confuse them because there is nothing to indictation their selection.

Chris

[Essamz]

anybody tried it with 2.2.4?
I can't make it to work, everytime I click on preview, it stays forever, and then the server times out

[FWC]

Originally posted by Essamz
anybody tried it with 2.2.4?
I can't make it to work, everytime I click on preview, it stays forever, and then the server times out We just sent one out tonight with 2.2.4 and it worked.

[boatdesign]

I would like to use this mod to send an email to users who have not posted in the last x days, for example those who have not posted in the last two weeks. Is this possible?

[boatdesign]

OK it looks like the easiest way to do this is to create a new user group like "members-inactive", move the members who have not posted or visited in a while to that group, and then send to that group only.

Then I can manually move people between groups if they do visit or as new people become members of the inactive group.

I figure there's no point in emailing people the new topics if they're visiting my forum everyday or every couple of days anyway.

Very nice mod BTW.

[boatdesign]

Another thing which would be nice would be to have a (View) link next to calendar events linked to the detailed event info.

[Scrooge]

This is working great for me and I absolutely love it! I do have a problem though. For some reason my dates are screwed up. For example, the "Most Recent Threads" section is sending out threads with a date in 2003!? I viewed those threads and the dates are actually in 2001. Any ideas?

[Scrooge]

A little more info on this that I got from staring at the email I sent myself. It seems that the dates that are getting screwed up depend on the date of the last reply in a thread. If the last reply was at the end of the month then the date of the thread starting is messed up. Here is what I am getting:

If the last reply was 10-31-2001 then the original thread is change to 7-10-2003.

Last reply of 8-31-2001 changes to 7-8-2003, 7-31-01 to 7-7-03, 7-30-01 to 7-06-2003, 5-31-01 to 7-5-03, 3-31-01 to 7-03-03, etc. See the pattern?

If the day of the last reply is the 30th it changes the month of the starting thread to June. For example, last reply on 10-30-01 changes the starting date to 6-10-03.

I'm confused, are you? :)

[Dan Flynn]

I have the date problem also. my says 1938????? Does anyone know how to fix this?

[Scrooge]

I found it :) Mine is because I originally had UBB. I found the fix in the old version of this program. It is at

https://vborg.vbsupport.ru/showthread.php?s=&threadid=32129&perpage=15&highlight=community&display=&pagenumber=2

Look for the post by Prince with a fix for the dates.

[Dan Flynn]

Thankss,

When I tried it I got a 404 page. I made the file as directed and put it in the admin file.

http://www.mydomain.com/admin/fixubbdate.php I do get the page that says if you backed up proceed. When I click that link I get the 404 and the address I get sent too is http://www.powerwashnetwork.com/admin/fixubbdate.php?action=doconvert

Any ideas ?

[Dan Flynn]

Well that last address is wrong. This site may be blocking out certain words. But I think you get the point.

[akaler]

Originally posted by Held der Nacht
Can nobody help me ? :(

My users get the text mode e-mails as .txt file (textfile) in the mail. I just installed this hack. Works great except for this problem.

Anybody know how to how to fix this?

[JulianD]

Yeah, i'm having this behavior. Or it's supposed to work like this?

[Gholsie]

Some of my users are complaining about yellow text on a white background. This seems to only happen to a few users. It might be limited to their Email client, but, I'm not sure.

I can see the HTML messages just fine using Outlook. But, some of the users using Eudora for instance have seen this problem.

Anyone else experience this?

[hypedave]

since I have upgraded to vb 2.2.5 , it takes forever two send out emails, I only have 200 members at the moment and on 2.2.4. I could send to all at the same time, not I have to send to 25 at a time, I have also experienced the yellow text problem as well

[k2k bigbird]

Can someone post a sample screen shot or a text of what users actually receive in their email ?

Also, I have 10,000+ members, would my server handle this generation and mass mailing?

[zeedy2k]

works and its great, is there anyway I can change the colours of the HTML mailing?

[NTLDR]

Originally posted by zeedy2k
works and its great, is there anyway I can change the colours of the HTML mailing?

Took me a while to find it (then realised it was right under my nose :cheeky: )

Look for:

// HTML Color Variables

In commbull.php and you can changes the colors there ;)

[FleaBag]

Thanks for this hack, seems to be working well on 2.2.5. :)

[zeedy2k]

Thanks NTLDR for the help, about to fix it now.

[JoshFink]

Is there a way to put a plain text message at the top of the page in case they are in HTML and they can't read the message?

This is what I would like to put, but I don't know how to make it appear in text and not HTML format :


---------------------------------------------------------------------------
The email you are receiving is in HTML format. If you are having
trouble reading this, it is because your email
program does not support HTML email.

Please follow the below link to change back to text email.

---------------------------------------------------------------------------


Thanks

Josh

[FleaBag]

Working on 2.2.6. Thanks! :)

[thebigboss]

Originally posted by JoshFink
Is there a way to put a plain text message at the top of the page in case they are in HTML and they can't read the message?

This is what I would like to put, but I don't know how to make it appear in text and not HTML format :


---------------------------------------------------------------------------
The email you are receiving is in HTML format. If you are having
trouble reading this, it is because your email
program does not support HTML email.

Please follow the below link to change back to text email.

---------------------------------------------------------------------------


Thanks

Josh

The quickest way to do that Josh, would be to put <!-- just after the <html> paste in your text you want to appear and put --> after it, before the <head>


<html>
<!--
The email you are receiving is in HTML format. If you are having
trouble reading this, it is because your email
program does not support HTML email.

Please follow the below link to change back to text email.
-->
<head>

Would be easy enough to edit commbull.php to make that permenant.

put it in the first $header =

// set html header for mail
$header = "<html><head></head><body link=\"$cbgLink\" vlink=\"$cbgVLink\" alink=\"$cgbALink\">\n";

between the <html> and <head> and it should appear everytime you generate the community bulletin.

[JoshFink]

Thank You, I will try it out this week.

Josh

[FleaBag]

I'm guessing this error is to do with this hack... I've installed lots of hacks to date, anyone able to help me with this?


Database error in vBulletin 2.2.6:

Invalid SQL: UPDATE user
SET adminemail='1', receivebulletin='0',
receivebulletin_type='0',

showemail='1',invisible='0',cookieuser='1',
maxposts='-1',daysprune='-1',
timezoneoffset='0',emailnotification='1',
startofweek='1',options='15',receivepm='1',
emailonpm='1',pmpopup='1',usergroupid='2',
nosessionhash='0'
WHERE userid='1222'
mysql error: Unknown column 'receivebulletin' in 'field list'

mysql error number: 1054

Date: Sunday 23rd of June 2002 01:03:04 AM
Script: http://www.gamerforums.com/board/board/member.php
Referer:
http://www.gamerforums.com/board/member.php?action=editoptions


Thanks in advance! :)

[FleaBag]

*Bump*

[FleaBag]

Issue resolved. My bad.

[BaldNut]

when i try and preview e-mail i get:

There seems to have been a slight problem with the Health & Fitness Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
--------------------------------------------------------------------

any ideas?

[freeshares1]

FANTASTIC HACK!!!....

Thanks

phil

[Darren Lewis]

This is a great hack and should hopefully prove invaluable.

One minor problem during my testing:-

If a thread is moved to another forum and a redirect left behind in the original forum, it is showing up in the bulletin twice. If no redirect is left, the moved thread only shows up once.

Darren.

[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!! :D

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,stylei d,parentemail,coppauser,homepage,icq,aim,yahoo,sig nature,adminemail,receivebulletin,receivebulletin_ type,showemail,invisible,usertitle,customtitle,joi ndate,cookieuser,daysprune,lastvisit,lastactivity, lastpost,posts,timezoneoffset,emailnotification,re ceivepm,emailonpm,ipaddress,pmpopup,options,birthd ay) VALUES (NULL,'2','test2','ad0234829205b9033196ba818f7a872 b','test2@hotmail.com','1','','0','http://www.','','','','','1','1','1','0','','0',102773669 0,'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... ;)

[afterlab]

They must first say "Yes" that they want to receive the newsletter. Tell them to go find it within their User CP:

User CP > Edit Options

[Kars10]

Ok.
But in "my" own CP is also switched to yes, i i didnt get the Newsletter...

The script says : sending Mail, Site 1/2...
but on the Point where 78 Users are send, ....its ready.
I didnt get a second site... and i can´t reload that page, without sending the Mail to the 78 Users twice.
Ive installed everything correctly. The installation was very easy.
But why i cant send to more than 78 users?
Is there a query i cant run, that in all cps is switched to yes...
Normaly after the installation, all is switched to yes?
I dont think that 280 Users regonize that ive made a new install of a Newsletter-Script and switched in there CP to No..
And ther Problem is, i cant tested without sending the Mails. I dont want to spam my Board-Members!

[FleaBag]

Works with 2.2.7. Top work! :D

[Aurore]

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

Any solution ?

Thanks

[wolfe]

since i added this i get an error


Database error in vBulletin Control Panel 2.2.4:

Invalid SQL: UPDATE user SET away='0',awaydate=UNIX_TIMESTAMP('1970-01-01 01:00:00'),returndate='0000-00-00',awayreason='',birthday='0000-00-00',options='15',usergroupid='10',username='rpm',e mail=useremail@site.com,styleid='14',parentemail=' ',coppauser=0,homepage='http://www.',icq='',aim='',yahoo='',signature='',adminema il=1,receivebulletin=1,receivebulletin_type=1,show email,showemail=1,invisible=0,usertitle=<strong>Moderator</strong><br><img src="{stars}/1stars.gif">,customtitle=0,joindate=UNIX_TIMESTAMP('2002-09-04 17:54:20'),cookieuser=1,nosessionhash=0,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2002-09-04 20:35:39'),lastactivity=UNIX_TIMESTAMP('2002-09-04 21:11:46'),lastpost=UNIX_TIMESTAMP('2002-09-04 19:10:38'),posts='20',timezoneoffset='0',emailnoti fication=1,receivepm='1',emailonpm='0',ipaddress=' 62.30.77.26',pmpopup=IF(pmpopup=2 AND 0=1,pmpopup,'0') WHERE userid=331
mysql error: You have an error in your SQL syntax near 'showemail=1,invisible=0,usertitle=<strong>Moderator</strong><br><img src="{stars' at line 1

mysql error number: 1064

Date: Wednesday 04th of September 2002 09:49:36 PM
Script: http://mysite.com/forums/forums/admin/user.php
Referer: http://mysite.com/forums/admin/user.php?action=edit&userid=331


whats that all mean :(

[Joe Page]

Very nice add-on, thanks :)

[Webdork]

Quick thanks from me too, works perfectly.

Would love to see a version where you could add a message to top of mailout...

Can do this simply by cutting and pasting in the html and the text form of the mailout, but would be nice if you could add a message when compiling.

[tractor-beam]

Howdy folks,

I just installed this great hack on my vBulletin 2.2.5 web site and it works great. I too wanted the bulletin to create hyperlinked calendar events.

I'v been messing around with PHP for a month or so and decided to try and hack the "commbull.php" myself to see what I could do.

I made two very small changes to the code and here is my results. I'll post the changes if anyone is interested.

- Gerry

[LightBringer]

I installed this hack recently and I am experiencing an issue where the news article titles (the ones selected here: Select news articles to include in your email) aren't all showing up.

Notice how the thread titled "Unreal Tournament 2003 Server Specs Demo" has a nice table behind it and the title actually shows up?

The ones above it do not show the title or the table.

Screenie included

Could really use some help on this one.
http://www.brainphreeze.com/images/commbull.jpg

[Aurore]

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

Any solution ?

Thanks

[christec]

Aurore,

Try this;
Edit the commbull.php file.

Find this line:
$textEmailHeader .= "Content-Type: text/text\n";

and replace it with this line:
$textEmailHeader .= "Content-Type: text/plain\n";

Let me know if that works. :)

[LightBringer]

Hey christec, I attempted to use the fix that you pm'd me with, but now only the very first news article has the header and the rest don't. heh

Any ideas?

[Aurore]

Originally posted by christec
Aurore,

Try this;
Edit the commbull.php file.

Find this line:
$textEmailHeader .= "Content-Type: text/text\n";

and replace it with this line:
$textEmailHeader .= "Content-Type: text/plain\n";

Let me know if that works. :)

Thank you very very much! It works perfectly!!!

[Willard Reece]

I installed it and my wifes pc got email from nobody @,,,,,,,,.com possible scam but most went thru ok.

This is what I needed , maybe it willget my users in gear and come back more often...

Thanks
Willard Reece

[Willard Reece]

I just found a problem with my install of this...

If I go to admin panel and try to add user it errors out..

Anyone know why this is happening?

[Willard Reece]

I am hearing that on line 165 you have the columns: receivebulletin,receivebulletin_type,showemail

but just these values:
'$receivebulletin','$showemail'

this is in the user.php

anyone know what I need to do to it. To make the admin add new user work.
I really don't want to uninstall the hack.

The install program put these in.

[tractor-beam]

Originally posted by hypedave
since I have upgraded to vb 2.2.5 , it takes forever two send out emails, I only have 200 members at the moment and on 2.2.4. I could send to all at the same time, not I have to send to 25 at a time, I have also experienced the yellow text problem as well

I'm running 2.2.5 as well and some users never received the very first newsletter I sent out. Everyone SHOULD have. I have less than 70 registered members. I am wondering if this newsletter hack looks to see if the "receive e-mail from Admin" effects the sending of the e-mails.

Hmmmmm.....

- Gerry

[Willard Reece]

I removed receivebulletin,receivebulletin_type from my user.php and it all works now,,

[digitalJE5U5]

Works on 2.2.8 - Nice Hack man! Cant wait to see what you come up with next.

[JoshFink]

This may be asking too much, but is there a way to get a "Preview HTML" button that would show you what it looked like first?

Thanks

Josh

[NTLDR]

Originally posted by JoshFink
This may be asking too much, but is there a way to get a "Preview HTML" button that would show you what it looked like first?

Thats a good idea Josh, something like the preview buttons for the templates would be good.

[LightBringer]

Christec, any updates on the issues I was having before?

https://vborg.vbsupport.ru/showthread.php?postid=301992#post301992

https://vborg.vbsupport.ru/showthread.php?postid=302432#post302432

[JoshFink]

NTLDR , thanks for the help. That would be great.

Josh

[groovesalad]

Everything works great, except I'm having one issue. When I try to get the Bulletin to post on my message board in HTML format, the format is really messed up. I thought that maybe it was just posting incorrectly, so I just copied and pasted the HTML from the "Preview" screen before sending out the Newsletter and just pasted that into one of my forums. Still the same problem. I even checked the HTML source and it matched the "Preview" screen. Not sure why it's doing this. I'm almost positive NTLDR can figure this one out :)

http://groove-salad.com/forum/showthread.php?s=&threadid=177

[groovesalad]

When I try to use this, here is what I get as an error

[Sat Oct 19 19:17:10 2002] [error] [client 66.68.71.58] Empty script output

Anyone know what that means?

[NTLDR]

Here we go, the mod for the Preview button for the HTML, note variables like $username are not parsed in the preview.

Find:

maketableheader("Preview of your TEXT email");

Above it add:

?><tr class='firstalt' valign='top'>
<td><p></p></td><td><p>
<SCRIPT LANGUAGE="JavaScript">
function displayHTML() {
var inf = document.name.message.value;
win = window.open(", ", 'popup', 'width=800,height=500,toolbar=no,status=yes,scroll bars=yes');
win.document.write("" + inf + "");
}
</script>
<input type='button' value='Preview' accesskey='p' onclick='javascript:displayHTML()'></p></td></tr>
<?php

Thats it, you then get a preview button right under the HTML text area :D

Note: vB puts a space between java and script here: onclick='java script:displayHTML It should be javascript, one word ;)

[Littlebit]

Hi NTLDR,
yep...another Netscape java error...I got this script error in my java log from your script add for the preview
Error: missing ; before statement
Source Code:
java script:displayHTML()
Any ideas? I think I'm going to make sure I don't have some weird Java setting messed up in my browser too. :/

[NTLDR]

I've only got IE installed and I'm no Java expert or fan. Does the preview for templates work in the ACP? That is basicly the code from there modified to work with this hack.

[Littlebit]

I got it! it was just being being stubborn over the space between java and script. It works with the space removed. :)
Man, I've decided that Netscape is way picky with it's code.

I forgot to say thanks for the nifty add ;)

[NTLDR]

Originally posted by Littlebit
It works with the space removed. :)
Man, I've decided that Netscape is way picky with it's code.

The space isn't meant to be there ;) vB puts it in automatically for security reasons so it wouldn't have worked in any browser.

[Littlebit]

Oh that's good to know! I'll make sure to keep an eye for that from now on...could be my reason for the last few snags I've ran into :nervous: :cheeky:

[David_McPherson]

Anyone that might be able to help a "newbe" with a couple issues that appear to be happening..

I installed this hack and when I have it dump into the forum it shows up like this photo. It also when I put in the username who sent it #1 which is ME and it shows in the Post that it was the number ONE (1) that posted not my user name which for my test board is "testing"

http://mcpherson-racing.com/dave/commbull.gif

Any help would be appreciated.. thanks.

[David_McPherson]

I figured out the username thing... That was just "stupid" of me... Doh....

I'm also having this issue in the usercp... it seems that the box info is all messed up. Maybe is something in a "older" hack that I installed on my testing board??

http://mcpherson-racing.com/dave/commbull2.gif

Thanks for the help..

[NTLDR]

Originally posted by David_McPherson
I'm also having this issue in the usercp... it seems that the box info is all messed up. Maybe is something in a "older" hack that I installed on my testing board??

Check where you have placed the code in the modify options template. You have probably just put it in slightly the wrong place ;)

[FleaBag]

All's good with 2.2.8. Thanks. :)

[Angelus]

I have this error (https://vborg.vbsupport.ru/showthread.php?postid=314607#post314607) also. What can one make against it? Already times thanks for assistance.

[David_McPherson]

Which error the one with box placement in the USER CP? If its this one... Follow the fix that NDLTR put up.. I just copied it to the "end of the code" on the modify options template. It needs to go in the middle someplace where ever you like actually.

Or the other one where it seems to NOT dump the information correctly into the post? I still have this problem.. :(

[Angelus]

I unfortunately mean first of your problems. Second always went with me. And as it seems, is we only the those as posting in the board make ;)

[David_McPherson]

I'll try to get to the bottom of it. I'll ask a few people that I know. But absolutely no promises... :)

[asweetdeal]

I recently switched servers and now when I try to send out my bulletin I don't get the button to send the next page all I get is a bunch of !!!!!! and then a copy of the bulletin itself... how can I fix this?? Attached is a copy of the problem (bottom of the page after the 1st page of emails is sent). I tried it with the default of 300, then 100, then 50... it always comes out this way, no link to the next page...

Thanks in advance!!

[diettalk]

What would be a cool addition would be to pull like the 2-5 most current topics in each forum? It would give a better idea of the conversations going on thru out the site.

[M.C.]

hallo. i want ask where that hack hold defoult template for generation e-mail?

P.S. Anywhere it`s a super hack!!! Good Luck!
P.P.S Sorry for my english 8)

[NTLDR]

<a href="https://vborg.vbsupport.ru/showthread.php?s=&postid=322284#post322284" target="_blank">https://vborg.vbsupport.ru/showt...284#post322284</a>

Theres also no need to cross post.

[diettalk]

Also if it could filter out the bdays of inactive users. That way your not saying happy birthday to uses that no longer use your site.

Originally posted by diettalk
What would be a cool addition would be to pull like the 2-5 most current topics in each forum? It would give a better idea of the conversations going on thru out the site.

[M.C.]

so i can`t understand... the last version support bdays mail? if not it`ll be cool to add that function & one more add - send email bulletin automaticly every one week (month, 3-month, half-year, year, etc...).

sorry, if all that functions already in, i just install it few hours ago and not look at it close 8)

[David_McPherson]

Is anyone here able to provide support for my issue that is still UNRESOLVED? Thanks.....

See post #162

[limey]

I already tried searching:

In admin CP how do you add the Yes/No option to editing users?

Yes its in the usercp, but not in the admin/usercp editing area.

thanks.

[superstar3]

It appears that I am not receiving failed email addresses, and I know that I do have a few that are not valid. This means that they are going to be sitting on the server. How can I fix this so that any failed are sent back to my site email address?

Any help much appreciated.

Thanks

[limey]

@home.com email addys come back to me.

[superstar3]

Sorry what does this mean?

Thanks

[limey]

Originally posted by superstar3
Sorry what does this mean?

Thanks

Your problem is most likely related to your virtusertable if you are running sendmail on linux.

My problem is related to anyone with @home.com email addresses. They end up in the admin@mywebsite.com's email.

[christec]

I don't think the @home.com domain exists any more. If you still have users with this email address you will need to update them.

[mikeB]

OK before asking a dumb question I read this whole thread...

Question: Is there a way to automatically do the next page? My server times out if I send more than 100 emails at once and I have over 14,000 members ... and right now sitting here and manually hitting Send Next Page (49/144) sucks! hehh

any help would be appreciated!

[papoo]

thanks

[mikeB]

03-17-03 at 06:40 PM mikeB said this in Post #183 (https://vborg.vbsupport.ru/showthread.php?postid=368126#post368126)
OK before asking a dumb question I read this whole thread...

Question: Is there a way to automatically do the next page? My server times out if I send more than 100 emails at once and I have over 14,000 members ... and right now sitting here and manually hitting Send Next Page (49/144) sucks! hehh

any help would be appreciated!

bump

anyone?

[chitown]

this is a very useful hack
Thank You

[Stud_Muffin]

Any one running this on vb 2.3.0?

[mikeB]

03-17-03 at 06:40 PM mikeB said this in Post #183 (https://vborg.vbsupport.ru/showthread.php?postid=368126#post368126)
OK before asking a dumb question I read this whole thread...

Question: Is there a way to automatically do the next page? My server times out if I send more than 100 emails at once and I have over 14,000 members ... and right now sitting here and manually hitting Send Next Page (49/144) sucks! hehh

any help would be appreciated!

fyi: this https://vborg.vbsupport.ru/showthread.php?s=&threadid=47886&highlight=community+bulletin

fixed my problem, thank god

[Intex]

Very nice hack Christec.

Is there any way to save the options you choose? I'd also like to set the background colour (hardcoded) - can you let me know how to do this.

Thanks.

[Gutspiller]

How do I change the purple color of the html email to whatever color I want or to my forum colors?

[mlx]

If I did not oversee a reply, noone ever fixed the problem described here (https://vborg.vbsupport.ru/showthread.php?postid=314607#post314607).

I did the following which fixed it for me.

replace (around line 885):

$message2 = eregi_replace("\{[^}]*\}","",$message);


with:

$message2 = ereg_replace("\r\n","",$message);
$message2 = eregi_replace("\{[^}]*\}","",$message2);


Oh and last but not least thanks for the great hack.

[subu1]

sorry , i have the same Problem https://vborg.vbsupport.ru/showthread.php?postid=317725#post317725

what can i do

thxx subu1

[David_McPherson]

04-11-03 at 02:40 PM mlx said this in Post #191 (https://vborg.vbsupport.ru/showthread.php?postid=380568#post380568)
If I did not oversee a reply, noone ever fixed the problem described here (https://vborg.vbsupport.ru/showthread.php?postid=314607#post314607).

I did the following which fixed it for me.

replace (around line 885):

$message2 = eregi_replace("\{[^}]*\}","",$message);


with:

$message2 = ereg_replace("\r\n","",$message);
$message2 = eregi_replace("\{[^}]*\}","",$message2);


Oh and last but not least thanks for the great hack.


I get a parse error with this......

[Cyn]

I'm running 2.2.9 and installation went 1,2,3 perfect for me. No problems there at all. Only problem is when I try to preview the email after making my selections it times out. So I haven't yet been able to send one to myself to see if it's working okay. I'll give it a go early morning. Perhaps the network traffic caused the timeout.

[Xyphen]

Can anyone tell me if this hack works with vB2.3.0? I need to know please... thnx!

[Xyphen]

OOooo, installed on vB2.3.0 and it works perfect!

[Cyn]

I'm still getting TCP/IP timeouts when I try to generate the preview email. Anyone have any idea what the problem might be for me? Please?

[Cyn]

Bumpity bump bump! Anyone know why I'm getting TCP_ERROR "There was a communication problem" when trying to run the Preview Email?

[Alien]

I would really love to save settings, is there anyone who was able to get this to save settings? I'd like to keep the same settings each week so I don't have to select it all manually again. :)

-Jason

[bigwest]

11-22-01 at 08:57 AM christec said this in Post #14 (https://vborg.vbsupport.ru/showthread.php?postid=202075#post202075)
In general, any comments or feedback?
In my opinion this is one of the coolest hacks I have ever installed and run.

Talk about useful!!!!

Seriously, this is great work!

[dstruct2k]

Awesome. Just awesome. I had problems with it stoppping after about 30 or so e-mails, but I realized I just have to send less at once.

Also hoping a version of this will show up that saves your settings... I'm tired of doing it manually.

[Ageel]

05-18-03 at 12:04 AM Alien said this in Post #199 (https://vborg.vbsupport.ru/showthread.php?postid=396404#post396404)
I would really love to save settings, is there anyone who was able to get this to save settings? I'd like to keep the same settings each week so I don't have to select it all manually again. :)

-Jason


mmmmmmmm
I agree with u,
I think there should be some variables that hold:

excluded forums
excluded user groups


or there reverse, i.e. Include

:)

thanx for this great hack

[Evil Chris]

This hack is the closet thing to what I was looking for to send out HTML Newsletters from my board.

All I really wanted to do to send HTML newsletters from my board was to prepare the newsletter in my html editor, and paste it into the message box to send to users.

Before the commbull hack, I was unable to do this.

For anyone else who might want to use this hack in this way, here is what you can do. Firstly, I do not give my users the option to take either html or text. They all get html.

I generate the mailing with commbull, but I delete the entire message after hitting preview. I then paste my HTML newsletter in the box and hit send.

I've done some tests, and it works fine so far. It even shows up in Yahoo and Hotmail web based email.

[ImportPassion]

05-17-03 at 07:04 PM Alien said this in Post #199 (https://vborg.vbsupport.ru/showthread.php?postid=396404#post396404)
I would really love to save settings, is there anyone who was able to get this to save settings? I'd like to keep the same settings each week so I don't have to select it all manually again. :)

-Jason

I think I am going to tackle this one. Will need a new table tho.

D

[Webdork]

I thought at some stage I saw a hack that automatically clicked the "send next batch" button on the email generator - I did a search through this thread and the other 2 bulletin ones but couldnt find it - anyone know ?

[memobug]

So far, so good with my install under vB 2.2.6, following the instructions for 2.2.x

I just wanted to note that the install is not as straightforward as the first post might have you believe. After launching the php, database manipulations are made, and a template and two to three php routines need to be modified in a few places.

Since the 2.2.4 install was not documented, I was very careful about backup and comparing the replaced material and it took me about an hour and a half, including NETLDR's mod for HTML preview and the "optional" hack which makes it possible for the ADMIN to adjust the users' bulletin preferences.

Was it worth it? I need a bit more time to see how much I can customize it, but at the outset, I would say so!

Thanks & regards,

Matt

[Diva]

Hi. I am having a problem with the hack. It is great, except it only sends to 178 people. No matter what I do, it only sends to that many. I even installed the hack below and no dice. Anyone have a suggestion?


08-19-03 at 12:58 AM Webdork said this in Post #205 (https://vborg.vbsupport.ru/showthread.php?postid=427000#post427000)
I thought at some stage I saw a hack that automatically clicked the "send next batch" button on the email generator - I did a search through this thread and the other 2 bulletin ones but couldnt find it - anyone know ?


It was on the page before. HERE (https://vborg.vbsupport.ru/showthread.php?s=&threadid=47886&highlight=community+bulletin) is the link to the hack. I hope it helps.

[Aaron1]

This hack is pretty good indeed, although the fact it doesn't work flawless (most of the time it won't show the topic's (news) article title, i'll need to manually insert it) i am very happy with it. :)

Just an idea: Wouldn't the news items be alot cooler, if you see the persons avatar on the left of the news topic? This will give more props to the submitter of the news. And i'll bet it will look much nicer.... Just like it does on this homepage:
http://www.vbulletin.org/index.php?s=

[Aaron1]

Here you can check a sample what i send out to 2000 members each week:

http://www.xs4all.nl/%7Eaaron1/forumimages/weekly.html

Hope you like it...

But i'd love it if this hack will be bugfixed though (see previous post)

Thanks y'all...

/Aaron

[Diva]

Hi. I have found a way to send it through the CPanel so that all the members can get it. The only problem is the last part where user information is. This is what shows when you send it.

{USER INFORMATION:
These are your current user details
Your username is: "Guess"
Forgotten your password?
You have "$posts" posts
You registered on "$joindate"
You were last active on the boards at "$lastactivity"

--------------------------------------------------------------------------------
The Weekly Crier is a way for members to keep up to date and join in on the fun. Hope to see you on the boards soon!

The No Chick Trix Forum Administrator.}

How can I fix this so that the "{" don't show and the postcount, etc... do?

[MaxScript]

vb3 b7 ?

can we get it to work there ?

[vfxtalk]

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

[diettalk]

Here... (https://vborg.vbsupport.ru/showthread.php?t=61980)

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

[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

2 of 4
Then Find This:
$DB_site->query("INSERT INTO user (userid,usergroupid,username,password,email,stylei d,parentemail,coppauser,homepage,icq,aim,yahoo,sig nature,adminemail,showemail,invisible,usertitle,cu stomtitle,joindate,cookieuser,daysprune,lastvisit, lastactivity,lastpost,posts,timezoneoffset,emailno tification,receivepm,emailonpm,ipaddress,pmpopup,o ptions,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','$dayspru ne',$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,stylei d,parentemail,coppauser,homepage,icq,aim,yahoo,sig nature,adminemail,receivebulletin,receivebulletin_ type,showemail,invisible,usertitle,customtitle,joi ndate,cookieuser,daysprune,lastvisit,lastactivity, lastpost,posts,timezoneoffset,emailnotification,re ceivepm,emailonpm,ipaddress,pmpopup,options,birthd ay) 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','$dayspru ne',$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]

[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

2 of 4
Then Find This:
$DB_site->query("INSERT INTO user (userid,usergroupid,username,password,email,stylei d,parentemail,coppauser,homepage,icq,aim,yahoo,sig nature,adminemail,showemail,invisible,usertitle,cu stomtitle,joindate,cookieuser,daysprune,lastvisit, lastactivity,lastpost,posts,timezoneoffset,emailno tification,receivepm,emailonpm,ipaddress,pmpopup,o ptions,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','$dayspru ne',$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,stylei d,parentemail,coppauser,homepage,icq,aim,yahoo,sig nature,adminemail,receivebulletin,receivebulletin_ type,showemail,invisible,usertitle,customtitle,joi ndate,cookieuser,daysprune,lastvisit,lastactivity, lastpost,posts,timezoneoffset,emailnotification,re ceivepm,emailonpm,ipaddress,pmpopup,options,birthd ay) 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','$dayspru ne',$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]

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]

[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]

WHHOOOOPSS .. great great HACK .. *installed*

[memobug]

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]

.. 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

[Highlander]

i can add user withozt problems ..

[memobug]

Hi Highlander,

I am not talking about the Community Bulletin Generator, but the standard Admin panel - I mean to add a user to your forum database by going to the admin panel and clicking ADD under Users. Then create a new user and click SAVE.

Regards,

Matt

[globalinsites]

I have vbulletin Version 2.3.3 and News and Email Community Bulletin Generator version 1.0 by Christec. Is there an additional hack available that will automatically send all the pages of the bulletin, so that I don't have to click the next page button every time? That would make it a lot easier. I've tried increasing the number of emails sent on one page, but if it exceeds 1000 the page freezes and I have to start all over again.

[memobug]

If you are talking about this hack, it has a box that says "Automatically advance to the next page" or something and a place to put in the delay

Regardsm

Matt

[globalinsites]

Yes I am talking about this hack? News and Email Community Bulletin Generator version 1.0 by Christec? But I don't have the "Automatically advance to the next page" box..

[memobug]

Yes I am talking about this hack? News and Email Community Bulletin Generator version 1.0 by Christec? But I don't have the "Automatically advance to the next page" box..Sorry, it was me who was confused. Those options are in the vbulletin 3 version (https://vborg.vbsupport.ru/showthread.php?t=66334). I don't know about the vbullet 2 version any longer, it has been awhile since I have used it, and I didn't realize I was still subscribed to this thread.

Regards,

Matt

[globalinsites]

So can anyone tell me how I can get it to advance to the next page automatically?

[YLP1]

Hi Everyone... I am fairly new to VB and PHP and I would love to add this to my board....will this work on VB version 3.0.7?

Thanks in advance.

[Marco van Herwaarden]

Hi Everyone... I am fairly new to VB and PHP and I would love to add this to my board....will this work on VB version 3.0.7?

Thanks in advance.This is a hack written for vB2. vB2 and vB3 are interenally complete different, so 99.99% of the vB2 hacks will not work on vB3.

[Regs]

YLP1,

There is an updated version for vB3.xx

Sorry I don't have the link for it handy but a search here should produce it.

Cheers,

~Regs.