this is an awesome hack!!!! Kudos! Thanks a million!!

Anyone haveing date problems with "Threads posted most recently"?

look at my dates:

Title: "Heya, where is everyone from?" (posted 01-18-38 by SnoTurtle)
o 0 replies, 68 views, last post: 01:41 AM, 10-28-99 by SnoTurtle
o http://216.215.238.193/showthread.php?s=&threadid=2

Title: "Administrative Test Post" (posted 01-18-38 by donco)
o 0 replies, 58 views, last post: 08:12 AM, 03-13-00 by donco
o http://216.215.238.193/showthread.php?s=&threadid=3

Title: "Training / riding groups in Kuala Lumpur" (posted 01-18-38 by chrisbeddows)
o 1 replies, 67 views, last post: 02:23 PM, 05-15-00 by Joe Gardner
o http://216.215.238.193/showthread.php?s=&threadid=5

These are all old UBB threads that were coverted to vB forumat in version 1.12...

OH you didn't mention that! :) That I have a fix for...somewhere around here...umm let me find it.

*runs off to find it*

*runs back*

OK I got it. This is not my script being wrong. :D It is the way vB imports/imported UBB threads. So here's the deal: rename this to fixubbdate.php, upload it to your admin directory, [important step] backup your database [/important step] and then run it by going to it in a browser.

That should fix your dates and make it so the script selects them correctly. The basic idea of why it doesn't work is the old import script gave the threads dates 30+ years in the future...which means when selected by date those come first. :)

[edit]Upon further inspection I realized that Joe, not Dave, posted the second message. so the "oh you didn't mention that" doesn't apply but I can only assume that Dave's was imported too...(at least I can hope - then it means there's nothing wrong with my script :D).[/edit]

Kevin - Yes mine is a UBB import too-

Off to test the script

oops

*doh* I thought I fixed that last time I posted this script...anyway replace line 15 (which is currently
withsorry :(

Hi I installed this script with no problem and I did with the welcome message script. However although it says messages sent to user@domain.com and no error messages appear it does not actually send the email when i test it.

Pleae help!

I don't think it is a problem with this script but something to do with the server or database is this possible.

Cheers,
Nick

With my 2.0.1 works great ! Thx.

bye

Nice! The fix ubbdate work great, i can new use the hack! :) In the future, i would like to see a "set preferences" section, where we can set what we sent out, so we dont have to configure the email each time, also if it sent every thing out by itself (cron?) that would be dandy... :) Good job.

Just installed into version 2.0.1 took about 15 minutes was very easy . Worked without any errors. I have been using a mailing list from mailman and this is alot easier and better. Will this also send data from a locked forum? I hope so that way I can use the locked forum to write messages to members and than lock it back just for me to update on a weekly basis.

Kier/Tubedoog
Thanks Again

:cool:

This is a database error I get if I send the bulletin to all my users. It appears to mail out to everyone but it doesn't update the database.

If I send it out to a group that only has one user in it, it works flawlessly.

Any ideas?

Chad

Shouldn't that be ?

Hello tubedogg,

The script times out for me when I try and send the actual email to a usergroup.

any ideas?

:o :o :o Yes.

How many are you trying to send at once? Maybe decrease that number?

I tried just sending it to the Admins only...but that didn't work. There are only 3 admins in the "Admin Usergroup"

It must have something to do with the amount of forums or something.

Any other ideas...I'd really love to use this hack. :)

The number of forums shouldn't affect it - by the time you get to the sending screen, it's done gathering info.

Or do you mean it times out when trying to go to the preview screen?

Not sure if I've missed this in the thread somewhere, but are there plans (or does it already and I'm overlooking) for this to mail automagically on a pre-specified basis?

Thanks, love the hack!!

Oh I didn't realize it was a preview....yes it times out when it tries to preview it.

I have installed and ran for 2 weeks. Hack is great. One question though. When setting info to send out torwards the end you have a option to start a new thread with your email address in it. You put the username in to tell everyone who posted it also input the forum number where you want the new thread to appear. I did this both weeks but the thread never shows up in the mailing list that is sent out or in the forum. Everything else works fine.

Any idea's?

Joey

anybody?

I have list working now and also putting a copy of the email in the forum, but there is a question.

My first forum has 2 topics, the first is new/outages/ect.
the second is vbulletin 2.0
I choose to place email in forum 1. and it does but it places it under vbulletin the second optuin, how to I make it place under the first subforum of the first forum instead of the second subforum?

Joey

Do you mean it will work if I set birthdays to 0 or it won't work at all for me with that error? Just wishing I could get this to work. :(

I mean if you set birthdays to 0 it will work but without birthdays.

Oh, cool, great! Something's better than nothing - thanks.

I attempted to send out my Community Bulletin today. It sent it out to the first 76 people out of about 350 and then gave me this error:
What's this?

Just a quick guess, but maybe you tried to send to too many people at once. Try reducing the number of emails sent at one time. Once you set the initial options, and click on Preview Mailing, down at the bottom is a setting for Mails to send at once. By default, it is set to 500. Trying to generate and send 500 emails all at once may be a bit much for the particular server you're on, especially if your bulletin is larger than normal. Try setting it to maybe 100 users, and see if it works. It will take longer to complete the process, but at least you would be able to complete it.

Thanks! I will try that next time. Thanks for putting that error in plain English.

Kevin,

I noticed a small error in the e-mail text. You spelled "receive" wrong at the bottom. :)

I'm a lil dizzy after reading this thread....can ya clear up what .zip file I actually need to download?

Q: is it: commbull98.zip at the begining of this thread? I'm gonna wipe my VB clean and install VB 2.0...as I have a corrupt database and get errors when I try the upgrade scripts on my: vBulletin Version 2.0.0 Release Candidate 2.

Help
:confused:

The .zip file in the first message has been updated every time. Besides, there isn't another one in this thread, so that's the one you want :)

At first when I installed it, I got this error:

----------------------------------
There seems to have been a slight problem with the 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.
-----------------------------------

But then I turned the Brithdays annd Calendar stuff to 0 and it worked like a charm Whew! I'm gonna have some fun now..

Thanks:)

Hello, is a very good hack,

but i have some problems with the inclution of some code in members.php and index.php. All of this code i don't finde in the two files. waths happends???



I hope you can help me.

PS. I can open the file commbull.php an send mails to all users, but i didn't see the link in the cp.

i was to stupid to find the code, but at the moment i see it.

THX

Does this work on 2.0.3 ?

Yes.

perfektly it's a very good Hack and it works fine with V2.0.3

I just got this when trying to run commbull.php:

Fatal error: Call to undefined function: cpheader() in /usr/www/users/gandalf/starwarsguide.com/forums/commbull.php on line 6

You have to put commbull.php into your admin directory.

At the moment I'm just toying around with vBulletin, seeing what it can do etc, before putting it live (same thing can be said for my whole website actually), so I found the following error when I tried Previewing my "community bulletin"..

"Database error in vBulletin Control Panel: Invalid SQL: SELECT * FROM user WHERE SUBSTRING(birthday,6)>='08-08' AND SUBSTRING(birthday,6)<='08-22' 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: Wednesday 08th of August 2001 12:49:23 PM
Script: /forum/admin/commbull.php
Referer: http://www.dogwalks.org/forum/admin/commbull.php?"

If I set the number of birthdays to display to zero then it works... so I suspect that the problem is something like that there aren't 10 users subscribed to my forum, so therefore it's not gonna find 10 birthdays - 10 seems to be the default value for birthday output...

Just a minor error, doubt most people would see it, but thought you might like to know anyway.

Looking forward to using the community bulletin feature when I go live with the site :-).