right below

How can I change last post time to -> server time + 6 hours (GMT+1)?
Thanks :)

The time will be displayed as whatever you set in your User CP - the server time is automatically adjusted by vB.

In Admin CP I have:
Time Zone Offset
Time (in hours) that the server is offset from GMT. = GMT -5 hours
In My User CP I have: GMT +1 (Central Europe)

The last post time in the Community bulletin is GMT -5.

Don't know way. :(

I can't find that line in the commbull97.php file at all.

That's because vB removed the two backslashes.

Try this

First of all: Great Hack :D

But I had a problem when letting the Script create a new Thread. Actually my "News and Announcements" Forum is moderated, so I?m getting this Error when trying to use the "Create Thread" function in the bulletin mailer. The thread and post tables are updated correctly, but updating the forum table causes a problem.

I am getting this SQL error:

@chrispadfield:
[QUOTE]Originally posted by The_Sisko
Turn Birthdays to 0!!!
Your mysql version is not up to date and doesn't support SUBSTRING!

arr. ok thank you.

I get this error after I tried to send the mails out.

Could not execute mail delivery program in /homepages/31/d11193551/htdocs/forum/admin/commbull.php on line 541

any tips for me ??

Santa

great hack.. hats of the both kiew and tubedogg.

One possibility... can you add the automaric javascript forwarding thing when sending out?

Cheers

this is great works very well on my board, installed without any problems (then again how could you have problems with such an easy way to install)

Well done to both of you, i know for one i will be using this hack.

There is one little thing tho it auto picks up your url, but i dont what a Dlink to the board i want to put my main domain name in as i have phpnuke running on my site, is there anyway to do this in the next ver maybe? or tell me know i can do that now?

Thanks and great work dudes

More errors for me. I already had to set birthdays to 0 and now this one pops up (commbull097):

Database error in vBulletin Control Panel: Invalid SQL: UPDATE user SET WHERE
userid='1'
mysql error: You have an error in your SQL syntax near 'WHERE userid='1'' at line 1
mysql error number: 1064

The line I found in commbull is, I think:
$d = $DB_site->query("UPDATE user SET ".iif($foruminfo[countposts],"posts=posts+1","")." WHERE userid='$id[id]'");

So, what's this? More version misery?

mmm...I didn't really think that one one through. I'll fix it up hopefully by this weekend.

cant wait to add it when its fixed !!!:D

I updated the script so it fixed that stupid bug. Sorry I didn't think about that before. :o

oh NOW you update the script Kevin....after I just downloaded the old version again and made the script change to correct the email formatting problem....which still didn't work. Great timing Kev! :D :D :D

the install worked but then when you go to send this happens, the output is posted in the forum but thats it, no emails are sent ?

--------CUT----------

Database error in vBulletin Control Panel: Invalid SQL: UPDATE user SET 'posts=posts+1' WHERE userid='1'
mysql error: You have an error in your SQL syntax near ''posts=posts+1' WHERE userid='1'' at line 1
mysql error number: 1064
Date: Sunday 03rd of June 2001 12:22:17 PM

--------CUT--------

i just installed it . Everything works even tested it by sending emails out.

Fixed. Download the zip file and reupload commbull.php.

tubedogg & Kier, thank you for this hack! It's awesome!!!

WOW.... great fix

This looks great and I can't wait for it to work but I got this error and I do not know enough about mySQL or php to figure where it came from

After installing the hack and setting up the preferences .. I clicked the okay or whatever and it sent me this error

Database error in vBulletin Control Panel: Invalid SQL: SELECT * FROM user WHERE SUBSTRING(birthday,6)>='06-10' AND SUBSTRING(birthday,6)<='06-24' 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

Not sure what to do to fix it..

Set birthdays to 0.

Thank you thank you thank you!

This hack rules!!!

I love watching who's online after I send out the weekly bulletin. People that I thought had died show up on the board and poke around.

Thanks for this great hack. :)

Now, I can't resist picking on you a little bit and asking for this hack to be upgraded so that it maintains the settings (the forums not to include, how many threads to include, etc.) so that all I have to do is tell it to send once a week.

Amy

When I try previewing the mail I get the database error.

Anyone got any ideas?

Tiss ok, I see the post above about it. Thanks

Im having problems with the Threads posted most recently option, im showing the first few threads posted, not the last threads posted. Is this a v.98 bug, or am i using this wrong? :)

- Will adding the new field to user database cause any conflict in future vb release?

- Just in case if we do not want to use this script after adding the new field to user database, how do we revert back any changes to the database?

- Hope that hack will appear in the next vb release.

This is great.

Thanks!!!!

Not unless this hack becomes part of vB itself, in which case Kier or I (or somebody) will try to make sure that some sort of contingency exists for those that already installed it.

DROP receivebulletin FROM user;
Run that query from telnet or phpMyAdmin.

Maybe. ;)

Thanks tubedogg!

The hack installed great, but when ever I try and run the hack...it timesout.....I have over 150 forums, maybe that is why.

Too bad...I really want to use it. :(

Does it timeout after the first screen or when going to send emails?

ooops - ignore

Kevin,

Thanks for this wonderful hack. I went through all the steps and got to the part where I can specify when it goes out, to who, etc., but I got the "There seems to have been a slight problem with the database..." error and this e-mail:
Any idea? Thanks!

Unfortunately that's a limitation of some older versions of MySQL that don't allow sorting by substring. For right now the workaround is to set birthdays to 0 and not send them until I can figure out some other way to do it. :(

Damn I am having problems:

I have set the comm to only use data from the 1st of June onwards but look at the dates in this snip from the preview.

NB dates are in European format date:month:year

Double-check that you have "Only include threads that have been started or replied to since this date?" set to Yes. It is set to No by default.