CommBull (Community Bulletin)

vb3.5 Commbull
vb3.6 Commbull

Note:
The 3.6 version is a commercial product, any queries on it should be submitted to: vb3.6 Support Site

THIS THREAD IS FOR SUPPORT FOR 3.0 VERSIONS ONLY. PLEASE VISIT THE APPROPRIATE FORUMS (links above) FOR THEIR SUPPORT

[valid point]
it's been brought to my attention that not everyone knows what this is ... fair enough: This hack is considered a "weekly newsletter" by the fact that it will email members (only sent by an admin) who have opted to receive it new posts, hot threads, etc ... basically a summary of what has been going on since the last time the newsletter was sent out. However there is a vast number of options, and I won't go into detail of all of them ... you can view the the images that I've attached, but u will only get a full idea by installing it.
I would say that there is 0 risk of this installation doing any damage to your current install as these are the changes that it does (manually and automatically):
- change profile.php and admincp/index.php
- add a couple columns to user table (receivebulletin and receivebulletin_type)
- add some phrases to phrase table (receive_email_from_commbull, type_email_from_commbull, newsletterformat, commbul)
- add a row to datastore table (commbull)
- add some html to nav template for admin side
So, if you are unhappy with the install. you can just ignore that it's there and it'll never cause any problems ... your next upgrade will overwrite any changes to the index and profile pages and the extra columns in the DB won't be an issue

[mods that i've added from vB2 version]
- to change languages, comment/uncomment line 22 and 23 to switch from English to German
- save prefs (option)
- skip to page X in case of mailout freeze
- auto redirect to next page (option)
- adding personalized text to top of newsletter w/out searching through the two text & html fields ... u'll c what i mean :ermm:

[INSTALL]
drop the 3 files into the admincp directory and then go to admincp/commbull.php ... follow the instructions and you are good to go.
If you find that the option isn't showing up on the control panel after the install, then it's because you aren't using the default phrases. Go into phrase manager, search for 'commbull' and update the fields appropriately.

If something goes wrong, don't worry .. it checks for already completed updates to the database to avoid redundancy ... enjoy!!

[grandeur_69]

yup ... u have a version of PHP < 4.3 ... didn't realize that this function was part of such a recent build ...

try it now (have to say try, cuz i don't have a version less than 4.3) ... just grabbed what someone wrote specifically for this reason on the php.net site

[mikeB]

Originally Posted by grandeur_69

yup ... u have a version of PHP < 4.3 ... didn't realize that this function was part of such a recent build ...

try it now (have to say try, cuz i don't have a version less than 4.3) ... just grabbed what someone wrote specifically for this reason on the php.net site

I rrepleced the ones I had uploaded - Now Im getting this:
Parse error: parse error in /home/httpd/vhosts/bakermedia.com/httpdocs/learn/admincp/commbull.php on line 1383

[grandeur_69]

my bad ... uploaded the wrong file ... not very good at multi-tasking, i guess

[ImportPassion]

well, there is one unnecessary query I found in profile.php

instead of doing this

PHP Code:

    $receivebulletin = ($commbull) ? 1 : 0;
    
    $DB_site->query("
        UPDATE " . TABLE_PREFIX . "user SET
            receivebulletin = $receivebulletin
        WHERE userid = $bbuserinfo[userid]
    ");
    
    $receivebulletin_type = ($commbull_type) ? 1 : 0; 

    $DB_site->query(" 
        UPDATE " . TABLE_PREFIX . "user SET 
            receivebulletin_type = $receivebulletin_type 
        WHERE userid = $bbuserinfo[userid] 
    "); 


do this

PHP Code:

    $receivebulletin = ($commbull) ? 1 : 0;
    $receivebulletin_type = ($commbull_type) ? 1 : 0;     
    
    $DB_site->query("
        UPDATE " . TABLE_PREFIX . "user SET
            receivebulletin = $receivebulletin,
            receivebulletin_type = $receivebulletin_type             
        WHERE userid = $bbuserinfo[userid]
    "); 


[grandeur_69]

and, i'm sure you will find others. As i've been putting it together piece-by-piece and working out bugs, i haven't done a lot of optimizing.

[mikeB]

works now for me, thanks!!

[Blackbeard]

User table altered... sucessfully.
User table altered... sucessfully.
Phrase table updated (profile.php 1 of 3)... sucessfully.
Phrase table updated (profile.php 2 of 3)... sucessfully.
Phrase table updated (profile.php 3 of 3)... sucessfully.
Phrase table updated (admincp/index.php) ... sucessfully.

You may now proceed to use the Community Bulletin Script

In order to allow your users to unsubscribe from the bulletin, you will need to make the following alterations to your existing code and templates:

Upload admin/index.php and profile.php to your server, then go to your Admin CP and look for the "Send Community Bulletin" option under "Users" If you find that the option isn't showing up on the control panel, then it's because you aren't using the default phrases. Go into phrase manager, search for 'commbull' and update.

done all changes, could not find send community bulletin in users section, searched in phase manager for commbull and got this

No Phrases Matched Your Query

whats gone wrong????

iam running PHP v4.3.5

[grandeur_69]

be sure to check "Phrase Variable Name Only" when searching

[ImportPassion]

i tried sending to 3 ppl and it timed out

[Blackbeard]

Originally Posted by grandeur_69

be sure to check "Phrase Variable Name Only" when searching

Cheers that work great