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!!

[:Judge:]

Database error in vBulletin 3.0.8:

Invalid SQL:
UPDATE user SET
styleid = 1,
showvbcode = 2,
pmpopup = 0,
maxposts = -1,
daysprune = 0,
timezoneoffset = '-5',
startofweek = 1,
languageid = 0,
threadedmode = 0,
autosubscribe = -1,
showdonor = ,
options = 2519
WHERE userid = 1

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 '
options = 2519
WHERE userid = 1' at line 12

mysql error number: 1064

I get this error when I try to save my options. The email goes out but MySQL error with the options save.

I am starting this site out new and getting new members everyday, a sour profile save after signing up just is not going to work.

Please Help

[cmiller1014]

<font size="7">bump!!!!

Need For 3.5

Please</font>

[RetroDreams]

Originally Posted by grandeur_69

i'm planning on reworking this whole thing from scratch once the new version comes out .... proper language support, calender, etc, etc
.. i've been kind of out of the loop for awhile because I've been traveling the globe for work ...

I'd be willing to donate $5-$10 to make it so.

[cmiller1014]

Ill give $200 if it can be made for 3.5 and all the bugs ironed out

[dethfire]

The original author doesn't seem to be supporting it anymore. We need some fresh blood.

[cmiller1014]

He posted a few posts back but we do need someone who is motivated. I posted in requests, on vbulletin.com, i have exausted all my resources. I am even willing to pay for someones time and let the entire community have access to the code.

[Kihon Kata]

This is one of my favorite and most used hacks. I have almost 7,000 members I used this for on a regular basis and today it decided to mess up.

Today I received this error when sending:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/httpd/vhosts/makeuptalk.com/httpdocs/forums/admincp/commbull.php(1216) : eval()'d code on line 429

This was line 429:

 "\$hotonly2 = $hotonly2; ".

Any ideas?

[waternut]

Sorry guys, I am a little lost here with regards to the installation of this hack.

I followed the instruction and uploaded the 3 files to the admincp as instructed by the original author.

The standard installation screen comes up and the first step is to "Modify User Option Templates -> modify options template after: ...."

I have no idea where to locate this template... any one can point me in the right direction for this first step? please...

-waternut

[SilverBoy]

is there any way to let event and birthday block to work?

[xtreme-mobile]

i got this working but have no commbull option in my admin cp what have i missed (what a numpty i am lol)