vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Administrative and Maintenance Tools - Commbull (Community Bulletin) 5.1b (https://vborg.vbsupport.ru/showthread.php?t=230359)

rluna559 07-12-2010 08:17 AM

i would like the commbull.php cron file. I plan to use it with Pauls mail queue hack. Thanks.

Dragonsys 07-14-2010 01:51 PM

There is a problem with the phrases in the xml file.

Code:

<phrase name="settings" version="5.0"><![CDATA[Settings]]></phrase>
The phrase above, overwrites the existing VB Phrase for settings. This is not really a huge problem, but if you uninstall Commbull, then it removes this phrase, which makes everything else in VB which uses it look funny, and you have to recreate the phrase.

This phrase should be removed from the Commbull xml file, so that this product neither installs nor removes it.



BTW, this is an awesome product, and I look forward to seeing what you do with it in the future.

grandeur_69 07-14-2010 02:27 PM

that's what you get for uninstalling an awesome product ;) ... i will make sure I update the code XML

Dragonsys 07-14-2010 02:59 PM

Quote:

Originally Posted by grandeur_69 (Post 2069071)
that's what you get for uninstalling an awesome product ;) ... i will make sure I update the code XML

lol I know right. I only uninstalled for testing. I have reinstalled it now anyway :P

Dragonsys 07-17-2010 04:29 PM

is it possible to give a usergroup, other than Admin, access to send newsletters?

Dragonsys 07-17-2010 05:25 PM

when I click on Send I get this at the top of the page:

Quote:

Parse error: syntax error, unexpected T_STRING in /.../forums/admincp/commbull_functions_preview.php(121) : eval()'d code on line 25
everything seems to be working fine though...

Eric 07-18-2010 12:24 AM

Quote:

Originally Posted by blackberry (Post 2062924)
I just renamed admincp to admincpforum and its giving me error i have changed the code like mentioned

Code:

$vbulletin->config['Misc']['admincpforum']
tell me wht to write

thanks

You're not supposed to change the actual variable. It should be:

PHP Code:

$config['Misc']['admincpdir'] = 'admincpforum'

In your ./includes/config.php file or if you're editing this within one of the mod files it should be:

PHP Code:

$vbulletin->config['Misc']['admincpdir'] = 'admincpforum'

Quote:

Originally Posted by Dragonsys (Post 2070743)
when I click on Send I get this at the top of the page:



everything seems to be working fine though...

Edit ./admincp/commbull_template_html.php

Find on line #182
Code:

<td><a href=\"{$vbulletin->options['bburl']}/login.php?do=lostpw&$commbull[referal_tag]\">{\$vbphrase[forgotten_your_password]}?</a></td>
replace with
Code:

<td><a href=\"{\$vbulletin->options['bburl']}/login.php?do=lostpw&\$commbull[referal_tag]\">{\$vbphrase[forgotten_your_password]}?</a></td>

asuccar 07-19-2010 11:27 PM

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?

Alfa1 07-20-2010 12:17 AM

I emailed a newsletter with the default setup to myself and opened it in squirrelmail: there was no content at all.
Sending it to a more advanced email webmail solution did have good results.

I wonder what % of people uses an email solution that is able to open this?

asuccar 07-20-2010 05:28 AM

None of my users actually got an email at all. I'm using my host smtp server that lets me send 500 emails an hour...I only have 300 members:) - i.e. assuming this mod uses the same email details as found in admincp-->settings-->options-->email options...or not?

Dragonsys 07-20-2010 01:48 PM

Quote:

Originally Posted by asuccar (Post 2071764)
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?

Try sending a test email from admincp and see if it works. I would suspect a problem with your mail settings


Quote:

Originally Posted by Alfa1 (Post 2071782)
I emailed a newsletter with the default setup to myself and opened it in squirrelmail: there was no content at all.
Sending it to a more advanced email webmail solution did have good results.

I wonder what % of people uses an email solution that is able to open this?

hmmm... squirrelmail works perfectly fine for me. I use it to check my email all the time, and I am able to see these newlestters perfectly. Now you have to remember, that squirrelmail does not view HTML, so an HTML email you have to click on the download as file link to view it.

Dragonsys 07-20-2010 05:40 PM

Quote:

Originally Posted by SecondV (Post 2070878)
Edit ./admincp/commbull_template_html.php

Find on line #182
Code:

<td><a href=\"{$vbulletin->options['bburl']}/login.php?do=lostpw&$commbull[referal_tag]\">{\$vbphrase[forgotten_your_password]}?</a></td>
replace with
Code:

<td><a href=\"{\$vbulletin->options['bburl']}/login.php?do=lostpw&\$commbull[referal_tag]\">{\$vbphrase[forgotten_your_password]}?</a></td>

did not correct the problem (only when using commbull_template_html.php) :
Code:

Parse error: syntax error, unexpected T_STRING in /.../forums/admincp/commbull_functions_preview.php(121) : eval()'d code on line 25

Found it:
Find:
Code:

    <td>
      <a target="_blank" href="\\\$commbull_unsubscribe">\$vbphrase[tounsubscribe]</a>

</td>

Replace with:
Code:

    <td><a target=\"_blank\" href=\"\\\$commbull_unsubscribe\">\$vbphrase[tounsubscribe]</a></td>

asuccar 07-21-2010 01:53 AM

Thanks Dragonsys.

Ok, really dumb question...how do I send a test email in combull? All the other mail features on my site are working perfectly!

Cheers!

Dragonsys 07-21-2010 02:09 PM

Quote:

Originally Posted by asuccar (Post 2072253)
Thanks Dragonsys.

Ok, really dumb question...how do I send a test email in combull? All the other mail features on my site are working perfectly!

Cheers!

On the Commbull settings page. Deselect all usergroups except for Administrators, then send a Commbull mail.
of course if you have more than one person in Administrators then they will all get the mail.

joeychgo 07-22-2010 09:24 PM

Has anyone created better CSS images? Honestly, I preferred the old look much more.

djbaxter 07-22-2010 10:26 PM

Quote:

Originally Posted by joeychgo (Post 2073095)
Has anyone created better CSS images? Honestly, I preferred the old look much more.

So use the old version. That's what I'm using.

asuccar 07-23-2010 10:55 PM

Hey dj,

Thanks for all your help so far. I did as you said, selected only administrators but when I go to the send page, the page simply displays

Quote:

Error! no users to send to
[Go back]
I've triple checked, and my admin group definitely has 1 primary user (myself:)...what's the deal? Any help appreciated!

djbaxter 07-23-2010 11:10 PM

No offense intended here but if you're the only admin, then check the obvious:
  • you have checked the box for "Receive admin emails" in your UserCP
  • you have checked the box for "Receive CommBull newsletter"
  • you have saved these settings after checking the boxes
  • you have a valid email address entered in your UserCP settings

Then check AdminCP | Settings | Email Options:

Scroll down to

Quote:

SMTP Email
Set this option to yes to use an SMTP server rather than the internal PHP mail() function. Yes No
Set it to No. Or if it's already set to No, try setting it to Yes to bypass PHP (mail) and use SMTP.

masterme 08-21-2010 11:52 AM

Unfortunally I do not get it to work. Installed fine and am able to do all the settings. But no matter what I do, I do not receive any newsletter.

I have tried smtp and tried without. Tested if the username and pw were correct, check.
Also checked with my co-admin with an gmail adres, did not receive it too.

I have my own server and manage it myself, so those settings (max send per hour, safe mode etc) are ok.

Any more ideas what could be the cause of the trouble?

kartik786 08-21-2010 01:28 PM

I dont know why this guys request was completely ignored

https://vborg.vbsupport.ru/showpost....&postcount=123

I have similar issues and would love to use this mod.

please let me know how to resolve this error :
Quote:

Database error in vBulletin 3.8.3:

Invalid SQL:
ALTER TABLE user ADD receivebulletin SMALLINT (5) UNSIGNED DEFAULT '1' not null;

MySQL Error : Duplicate column name 'receivebulletin'
Error Number : 1060
Request Date : Saturday, August 21st 2010 @ 10:04:56 AM
Error Date : Saturday, August 21st 2010 @ 10:04:56 AM

djbaxter 08-21-2010 01:59 PM

From phpMyAdmin or from vBulletin AdminCP | Maintenance | Execute SQL Query, typemin and execute the following:

Code:

ALTER TABLE user DROP receivebulletin
Then reinstall.

grandeur_69 08-21-2010 02:10 PM

Quote:

Originally Posted by masterme (Post 2087333)
Unfortunally I do not get it to work. Installed fine and am able to do all the settings. But no matter what I do, I do not receive any newsletter.

I have tried smtp and tried without. Tested if the username and pw were correct, check.
Also checked with my co-admin with an gmail adres, did not receive it too.

I have my own server and manage it myself, so those settings (max send per hour, safe mode etc) are ok.

Any more ideas what could be the cause of the trouble?

commbull simply uses vbulletin's mail sending function, so the problem is not likely to be from commbull itself.

check 2 things:
- the vbulletin mailqueue table to see if they are being added there
- server maillog to see how they are being handled by your server

grandeur_69 08-21-2010 02:17 PM

Quote:

Originally Posted by kartik786 (Post 2087371)
I dont know why this guys request was completely ignored

https://vborg.vbsupport.ru/showpost....&postcount=123

I have similar issues and would love to use this mod.

please let me know how to resolve this error :

i'm not entirely sure why the uninstall did not drop the column receivebulletin, as the uninstall info is pretty straight forward and drops the 3 columns that are added.

My guess might be that you do not have permissions to use the SQL query "show columns", as both the install code and uninstall code check to see if the columns are there before installing / uninstalling.

I may have to figure out a way to check that "show columns" actually returns the proper results before running these checks.

to manually uninstall:
Code:

ALTER TABLE user DROP receivebulletin;
ALTER TABLE user DROP INDEX receivebulletin;
ALTER TABLE user DROP receivebulletin_type;


kartik786 08-21-2010 02:18 PM

Thanks dj,

After doing that, another error crawled up

Database error in vBulletin 3.8.3:

Quote:

Invalid SQL:
ALTER TABLE user ADD receivebulletin_type SMALLINT (5) UNSIGNED DEFAULT '1' not null;

MySQL Error : Duplicate column name 'receivebulletin_type'
Error Number : 1060
Request Date : Saturday, August 21st 2010 @ 11:13:37 AM
Error Date : Saturday, August 21st 2010 @ 11:14:35 AM

kartik786 08-21-2010 02:20 PM

Thanks for the quick support,

Does anything change knowing that I already dropped a table as suggested by DJ ?

Appreciate the promptness in response :)

Quote:

Originally Posted by grandeur_69 (Post 2087390)
i'm not entirely sure why the uninstall did not drop the column receivebulletin, as the uninstall info is pretty straight forward and drops the 3 columns that are added.

My guess might be that you do not have permissions to use the SQL query "show columns", as both the install code and uninstall code check to see if the columns are there before installing / uninstalling.

I may have to figure out a way to check that "show columns" actually returns the proper results before running these checks.

to manually uninstall:
Code:

ALTER TABLE user DROP receivebulletin;
ALTER TABLE user DROP INDEX receivebulletin;
ALTER TABLE user DROP receivebulletin_type;



djbaxter 08-21-2010 03:43 PM

Quote:

Originally Posted by kartik786 (Post 2087393)
Thanks for the quick support,

Does anything change knowing that I already dropped a table as suggested by DJ ?

Appreciate the promptness in response :)

Yes: Ignore the first DROP as you've already done that. Run the other two:

Code:

ALTER TABLE user DROP receivebulletin;
ALTER TABLE user DROP INDEX receivebulletin;
ALTER TABLE user DROP receivebulletin_type;


kartik786 08-22-2010 04:58 PM

Okay Installed successfully but have some internal issues with my vendors code conflicting with this.. lets see how it goes.

djbaxter 08-22-2010 05:10 PM

Those are three separate SQL statements:

Code:

ALTER TABLE user DROP receivebulletin;
That one failed because you already deleted that table.

Try the following two separately. If you get an error like you did above, basically saying the table doesn't exist, don't worry about it - that's just telling you there's nothing to delete.

Code:

ALTER TABLE user DROP INDEX receivebulletin;
Code:

ALTER TABLE user DROP receivebulletin_type;
When all of those are removed, then you can reinstall the add-on.

djbaxter 08-22-2010 05:14 PM

Oh, and if you are using a table prefix, that needs to be prepended to the SQL statement:

Code:

ALTER TABLE {TABLE-PREFIX}user DROP receivebulletin;
ALTER TABLE {TABLE-PREFIX}user DROP INDEX receivebulletin;
ALTER TABLE {TABLE-PREFIX}user DROP receivebulletin_type;

ReplaceE {TABLE-PREFIX} with your actual prefix.

Sunray 08-26-2010 08:16 PM

Hi,

Thanks for this great mod very useful.

I have installed it on vB 4.0.5 boad and send my first community newsletter to the admins for test. We received it. Then I sent it to all my members but unfortunately nobody received it.

I didn't changed any other options exepted the selection of usergroups.
Does somebody have had the same problem and can help me please ?

Thanks in advance

Cordially

grandeur_69 08-26-2010 10:09 PM

i can only suggest watching vb's mailqueue table and your server logs when sending it out to try and determine where the problem might be. If it's looping through and showing that the mail is being sent out to each user, i'm not sure where the problem might be.

Artes_Marciales 08-27-2010 06:28 AM

Thanks!!! : )

Sunray 08-28-2010 07:56 PM

Thanks for your reply grandeur_69 !
It seems the mails are being sent out but not to each member. if several members are in multi usergroups do they can receive also the newsletter or it is necessary to they have only one usergroup ?
Cordially

SilverBoy 11-21-2010 10:12 PM

thanks for this nice and useful hack.

I have a problem

in setting section when I select for "Only include threads that have been started or replied to since this date?" as yes, I get in the newsletter a thread older than the date I selected.

any help?

djbaxter 11-21-2010 10:33 PM

Quote:

Originally Posted by SilverBoy (Post 2124431)
in setting section when I select for "Only include threads that have been started or replied to since this date?" as yes, I get in the newsletter a thread older than the date I selected.

The thread may be older but when was the last post in the thread?

SilverBoy 11-22-2010 10:33 PM

the last post old to, I choose date as 1-11-2010 and I get threads with last post at 2005 !!

roymogg 11-23-2010 01:18 PM

Quote:

Originally Posted by Sunray (Post 2090021)
Hi,

Thanks for this great mod very useful.

I have installed it on vB 4.0.5 boad and send my first community newsletter to the admins for test. We received it. Then I sent it to all my members but unfortunately nobody received it.

I didn't changed any other options exepted the selection of usergroups.
Does somebody have had the same problem and can help me please ?

Thanks in advance

Cordially

I re-installed the mod on my 4.08 board and created a bulletin - I have been using it for about two years and installed the latest version etc. Sending to admins works fine but when I select 'registered users' for example and activate the send procedure the procedure loops on page 0 of 12 and keeps repeating the first 300 users - it does not advance to the next page. I disabled the mod (if there is any other way to stop this running please advise) in the plugin manager but have already sent out a pile of bulletins repeatedly to this user group.

They each got about 20 copies so I am not very popular!

Has anyone had a similar problem and if so how did you resolve it?

cheers

Roy

SilverBoy 11-27-2010 09:52 PM

no advices to solve my problem?

Warlord 11-27-2010 11:57 PM

This. Is. Awesome.

*installed*

waelmagdy 12-11-2010 10:22 PM

this hack makes a bad impact on the mail server use it with cushion especially if you have less than vps server or if you have a lot of members with wrong or bad e-mails


All times are GMT. The time now is 11:33 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01550 seconds
  • Memory Usage 1,856KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (17)bbcode_code_printable
  • (2)bbcode_php_printable
  • (19)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete