Administrative and Maintenance Tools - Commbull (Community Bulletin) 5.1a for vBulletin 4.01

This not the CommBull product itself. This is simply instructions for adapting it to work with vBulletin 4.x.

Download CommBull from: Commbull (Community Bulletin) 5.1a for vBulletin 3.8x

grandeur_69 has released his latest version of CommBull as a free add-on, indicating that he no longer has time to continue developing it. I am posting this here for the benefit of other vBulletin 4.x who don't want to lose the newsletter feature (grandeur_69 has approved this).

At https://vborg.vbsupport.ru/showpost....6&postcount=71 a member asks:

Hi, the version 5.1a work fine with vbulletin 4.0.1 ?

My response is posted at https://vborg.vbsupport.ru/showpost....5&postcount=72 and reproduced here...

I have the previous (commercial) version, 4.5f, which does run successfully via a cron job, running on 4.01. It required some modification of the installation instructions but it does work. I expect you should be able to get this version running as well, although as the coder noted the cron capability won't work.

1. Edit product-Commbull.xml and find the following line:

PHP Code:

        <dependency dependencytype="vbulletin" minversion="3.6.0" maxversion="3.8.99" /> 


Change to:

PHP Code:

        <dependency dependencytype="vbulletin" minversion="3.6.0" maxversion="4.99" /> 


2. Upload the files and import the product.

3. Now you need to do the template edits so that members can opt-in or opt-out of your newsletter. The current instructions are as follows:

4. Template modifications
--------------------------------------

Template: "Modify User Option" -> "modifyoptions"

After:

PHP Code:

                    <tr>
                        <td><label for="cb_adminemail"><input type="checkbox" name="options[adminemail]" value="1" id="cb_adminemail" $checked[adminemail] />$vbphrase[receive_email_from_bulletin_board_staff]</label><input type="hidden" name="set_options[adminemail]" value="1" /></td>
                    </tr> 


Add:

PHP Code:

                    <tr>
                        <td><label for="commbull"><input type="checkbox" name="commbull" value="1" id="commbull" $checked[receivebulletin] />$vbphrase[receive_email_from_commbull]</label><input type="hidden" name="set_options[receivebulletin]" value="1" /></td>
                    </tr>
                    <tr>
                        <td><br />$vbphrase[newsletterformat]<br /><label for="commbull_type"><input type="checkbox" name="commbull_type" value="1" id="commbull_type" $checked[receivebulletin_type] />$vbphrase[type_email_from_commbull]</label>
<input type="hidden" name="set_options[receivebulletin_type]" value="1" /></td>
                    </tr> 


Now, obviously this won't work in 4.x. These need to be modified as follows:

1. Edit Template: "Modify User Option" -> "modifyoptions"

FIND:

PHP Code:

<vb:if condition="$show['friend_email_request']">
                    <li>
                        <label for="cb_receivefriendemailrequest"><input type="checkbox" name="options[receivefriendemailrequest]" value="1" id="cb_receivefriendemailrequest" tabindex="1" {vb:raw checked.receivefriendemailrequest} /> {vb:rawphrase receive_friendship_req_email}</label>
                        <input type="hidden" name="set_options[receivefriendemailrequest]" value="1" />
                    </li>
                </vb:if> 


ADD AFTER:

PHP Code:

<vb:if condition="$show['receiveemail']">
<li>
    <label for="commbull"><input type="checkbox" name="commbull" value="1" id="commbull" tabindex="1" {vb:raw checked.receivebulletin} />{vb:rawphrase receive_email_from_commbull}</label>
    <input type="hidden" name="set_options[receivebulletin]" value="1" />
</li>
</vb:if> 


That first part (above) is the option to receive or not receive the newsletters.

Next would be the option for HTML or plain text emails, which should be:

PHP Code:

<vb:if condition="$show['receiveemail']">
<li>
    <label for="commbull_type"><input type="checkbox" name="commbull_type" value="1" id="commbull_type" tabindex="1" {vb:raw checked.receivebulletin_type} />{vb:rawphrase type_email_from_commbull}</label>
    <input type="hidden" name="set_options[receivebulletin_type]" value="1" />
</li>
</vb:if> 


Update:

This now works. I had a ( instead of a { on the previous code. Thanks to grandeur_69 for pointing this out!

Notes:

1. The product is not mine so I can't offer any support for CommBull itself. However, I have been using the paid versions of this mod for some time and I'm happy to offer what support I can for making the changes necessary to get it running on 4.x.
   
   
2. I have been in communication with grandeur_69. He has indicated that he has no objections to this thread and that as he gets time he will be trying to develop this add-on further as a free product.

Update July 12, 2010: Product XML file provided by grandeur_69 for vBulletin 4.x.

NOTE:

1. If you have already done the manual edits, do NOT use the XML file. And if you import the XML file, you should not need to do the manual edits.
   
2. Some people are encountering problems using the XML file. If you are one of them, uninstall the product and use the manual edits. Those seem to work just fine.

Update July 14, 2010: Error in XML file corrected.

[djbaxter]

Originally Posted by asuccar

Hey guys,

I downloaded & installed this great mod without a hitch...I configured the html to look exactly as I wanted it to.

When I was ready, I went to the send page and clicked on the 'send' button below...then the mod done its thing and listed all my user (blu blu...user...html ok) and way at the bottom it says 'All Done!.

Problem: None of my users got the email! And there's no way (that I know of) to verify delivery (something like 'sent mail')...can anyone tell me what's going on?

I see you also posted this in the CommBull thread at https://vborg.vbsupport.ru/showthread.php?t=230359 - you'll need to get grandeur_69 to help you with this. I'm just trying to provide support for adapting the add-on to 4.x but I'm not using version 5.1.

[robbiefritz]

So just to make sure that I understand, I download v5.1 from that page then use the xml file here to install?

[djbaxter]

Originally Posted by robbiefritz

So just to make sure that I understand, I download v5.1 from that page then use the xml file here to install?

I used the manual ediots and they are working well for me.

grandeur_69 provided the XML file but I have not personally tested it. However, if you're installing 5.1, by all means give the XML product file here a shot. If it doesn't work for you, try the manual edits instead.

[robbiefritz]

Originally Posted by djbaxter

I used the manual ediots and they are working well for me.

grandeur_69 provided the XML file but I have not personally tested it. However, if you're installing 5.1, by all means give the XML product file here a shot. If it doesn't work for you, try the manual edits instead.

Thanks m8! Appreciate your efforts.

[jiffylb1]

get this dtatabase error when trying to send news letter now did not happend before

Database error in vBulletin 4.0.5:
Invalid SQL:
UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1, lastpost='1281283070',lastposter='Diablo' WHERE forumid IN ();
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Error Number : 1064
Request Date : Sunday, August 8th 2010 @ 11:57:50 AM
Error Date : Sunday, August 8th 2010 @ 11:57:50 AM
Script : http://www.clearwaterbiker.biz/forum...ll.php?do=send
Referrer : http://www.clearwaterbiker.biz/forum...p/commbull.php
IP Address :
Username : admin
Classname : vB_Database
MySQL Version : 5.1.48-ius

[djbaxter]

Originally Posted by jiffylb1

get this dtatabase error when trying to send news letter now did not happend before

Database error in vBulletin 4.0.5:
Invalid SQL:
UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1, lastpost='1281283070',lastposter='Diablo' WHERE forumid IN ();
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Error Number : 1064
Request Date : Sunday, August 8th 2010 @ 11:57:50 AM
Error Date : Sunday, August 8th 2010 @ 11:57:50 AM
Script : http://www.clearwaterbiker.biz/forum...ll.php?do=send
Referrer : http://www.clearwaterbiker.biz/forum...p/commbull.php
IP Address :
Username : admin
Classname : vB_Database
MySQL Version : 5.1.48-ius

Please post thisv at https://vborg.vbsupport.ru/showthread.php?t=230359 - this thread is just about how to adapt CommBull to 4.x.

[Noerenberg]

i used your xml

my problem is, all my settings are right, i got the newsletter but NOT the users

[Dragonsys]

Originally Posted by Noerenberg

i used your xml

my problem is, all my settings are right, i got the newsletter but NOT the users

Check and make sure you selected the correct Usergroups
Also, make sure your users are set to receive email from Admins & to get the Newsletter

[djbaxter]

Originally Posted by Noerenberg

i used your xml

my problem is, all my settings are right, i got the newsletter but NOT the users

Originally Posted by Dragonsys

Check and make sure you selected the correct Usergroups
Also, make sure your users are set to receive email from Admins & to get the Newsletter

Thanks, Dragonsys.

Noerenberg, if you still have problems, try uninstalling the product and using the manual edits instead of the XML product file.

[RichieBoy67]

I know to ask in the other forum but I just wondered if there were any mods known to interfere with this mod?

Thankls