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.

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

Nope, I've already run ubbdatefix.php.

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.

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

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

[QUOTE]Originally posted by christec

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

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

Here's the options page:

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

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.

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.

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! :)

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

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

I hate that when that happens. :)

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

(Edit: Answered my own stupid question lol)

This looks great, btw! :)

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.

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.

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

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

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.

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

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

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

That worked

seems a good hack :) gonna install it :D

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.

*bump*

Also, receiving this error message while executing the mailings:
Is this simply from sending too many (300) mails at a time?

Yes

Can nobody help me ? :(

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

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 problem is recovered

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

Good work though!

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

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

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

Installed and tested!
Good job! Thank you!

Now, can I make it work with cron?

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

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