Commbull (Community Bulletin)

[PURPOSE]
send a newsletter to all subscribed members (html or txt) notifying them of various going-ons in the forum:
- new threads
- hot threads
- b-days
- events
- etc

No longer commercial ... latest version: https://vborg.vbsupport.ru/showthread.php?t=230359

[INSTALL]
- upload 3 files
- import plugin

[MODS]
- 1 template mod (modifyoptions)
- 2 fields added to user table

[IMPORTANT - SUPPORT]
problems relating to the commercial version are not suported here and will be deleted by the mods.

[grandeur_69]

[criscokid] the "send community bulletin" link should be under your user options ... check your phrases for "commbull". The other two options don't show up in the admincp, only in the usercp ...

[soletrader] no, this mod doesn't work with 3.6

[criscokid]

Originally Posted by grandeur_69

[criscokid] the "send community bulletin" link should be under your user options ... check your phrases for "commbull". The other two options don't show up in the admincp, only in the usercp ...

I checked before making my posting - and they don't appear there. The 'commbull CP Phrase' exsists. Another thing... when I go into /forums/admincp/commbull.php the combull page takes up the entire screen... ie: no CP menu down the left hand side of the screen.

"The other two options don't show up in the admincp, only in the usercp..." - not a very good idea... people are lazy and find it easier to fire off an email with the words 'unsubscribe' than do it for themselves. With the mod as it it is there isn't even the ability for an admin to do this on a users behalf.

[grandeur_69]

i'm working on some of the phrase problems ... we had similar problems with the 3.0.1 version.

[juanchi]

Something is wrong with my installation althought everything seems to be working o.k. no one receives the email.

[grandeur_69]

i'm assuming this is for 3.5.4 ... the mail may be queued if you have that turned on. Other than that, check your mail log to see if they are getting sent out.

The only thing that I have ever encoutered with this, is that debugging was turned on, but i just double-checked the included package and it's not.

[jblackburn]

Should this work with 3.5.5? I'm getting the following error when trying to set the prefs with commbull.php:

Database error in vBulletin 3.5.5:

Invalid SQL:
INSERT INTO datastore VALUES ('commbull','$includedate = 1; $numtopics1 = 5; $topicorder1 = "dateline"; $hotonly1 = 0; $reuse1 = 0; $numtopics2 = 5; $topicorder2 = "dateline"; $hotonly2 = 0; $reuse2 = 0; $numtopics3 = 5; $topicorder3 = "dateline"; $hotonly3 = 0; $reuse3 = 0; $numtopics4 = 0; $topicorder4 = "dateline"; $hotonly4 = 0; $numpolls = 0; $numevents = 10; $numbirthdays = 10; $dostats = 0; $newlines = 1; $douserinfo = 0; $mail_subject = "Concerto Networks Community Forum Update"; $calendarid = "0"; $sc = "-"; $rsc = 75; $lic = "o"; $fixcss = "0"; $extramaterial = \'\';$def_calendar["1"] = 0; $def_forum["1"] = 0; $def_forum["14"] = 1; $def_forum["16"] = 0; $def_forum["13"] = 1; $def_forum["15"] = 0; $def_forum["2"] = 1; $def_forum["20"] = 0; $def_forum["4"] = 1; $def_forum["17"] = 0; $def_forum["24"] = 1; $def_forum["8"] = 1; $def_forum["7"] = 1; $def_forum["23"] = 1; $def_forum["12"] = 1; $def_forum["11"] = 1; $def_forum["10"] = 1; $def_forum["6"] = 1; $def_forum["26"] = 1; $def_forum["18"] = 0; $def_forum["3"] = 1; $def_forum["25"] = 1; $def_forum["43"] = 0; $def_forum["44"] = 1; $def_forum["19"] = 0; $def_forum["9"] = 1; $def_forum["21"] = 0; $def_forum["5"] = 1; $def_forum["49"] = 1; $def_forum["29"] = 0; $def_forum["30"] = 0; $def_forum["37"] = 1; $def_forum["38"] = 1; $def_forum["39"] = 1; $def_forum["40"] = 1; $def_forum["41"] = 1; $def_forum["42"] = 1; $def_forum["32"] = 0; $def_forum["54"] = 1; $def_forum["55"] = 1; $def_forum["56"] = 1; $def_forum["57"] = 1; $def_forum["33"] = 0; $def_forum["50"] = 1; $def_forum["51"] = 1; $def_forum["52"] = 1; $def_forum["53"] = 1; $def_forum["31"] = 0; $def_forum["45"] = 1; $def_forum["46"] = 1; $def_forum["47"] = 1; $def_forum["48"] = 1; $def_forum["28"] = 0; $def_forum["27"] = 0; $def_group["1"] = 0; $def_group["2"] = 0; $def_group["3"] = 0; $def_group["4"] = 0; $def_group["5"] = 0; $def_group["6"] = 1; $def_group["7"] = 0; $def_group["8"] = 0; $def_group["9"] = 0; $def_group["10"] = 0; $def_group["11"] = 0; $auto_nextpage = 1; $auto_timer = 1; $save_prefs = 1; $postcopy = 0; $pfid = 0; $pftype = 0; $pcu = "0"; $open = 1; ');

MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Thursday, October 5th 2006 @ 03:23:58 PM
Script : http://www.address.com/forum/admincp/commbull.php
Referrer : http://www.address/forum/admincp/commbull.php
IP Address : xx.xx.xx.xx
Username : name
Classname : vb_database

[grandeur_69]

hmm, looks like they may have made a change. I'll update the db query to fix this. You can redownload the package, but just overwrite the one /admincp/commbull.php file.

[jblackburn]

Originally Posted by grandeur_69

hmm, looks like they may have made a change. I'll update the db query to fix this. You can redownload the package, but just overwrite the one /admincp/commbull.php file.

The fix worked for me on 3.5.5 on the header issue, but still have these two problems (1 minor, 1 major):

1. Major - the email doesn't send (no one receives it). The screen looks like this after a send:

User: - () .... text ok
User: - () .... text ok
User: - () .... text ok
User: - () .... text ok

2. Minor - There's no listing in the Admin CP User section to send newsletter.

PS: If buying this would help, I'll gladly spend the 10 bucks.

[grandeur_69]

ok ... i see. Something that i had done to fix one problem created another. I am uploading the new version right now. Just give me 10 minutes from the post time so that i can upload it before you get to it.

... however, if you do end up upgrading to vb3.6, you will need to have someone hack the file to make it work or purchase the licensed version.

[klaush]

Originally Posted by jblackburn

The fix worked for me on 3.5.5 on the header issue, but still have these two problems (1 minor, 1 major):

1. Major - the email doesn't send (no one receives it). The screen looks like this after a send:

User: - () .... text ok
User: - () .... text ok
User: - () .... text ok
User: - () .... text ok

2. Minor - There's no listing in the Admin CP User section to send newsletter.

PS: If buying this would help, I'll gladly spend the 10 bucks.

Same Problems here. So i think no emails could be send?

Thanks for helping!