vb.org Archive - Administrative and Maintenance Tools - Commbull (Community Bulletin) 5.1b

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)

Quote:

Originally Posted by LauraS (Post 2217447)

Our developer is having issues with the files; he says he cannot unzip. Any hints here???

Laura

Download the zip file again. He has a corrupted or incomplete zip file.

Quote:

Originally Posted by kartik786 (Post 2144824)

I have over 2,30,000 members. I tried using this mod but the send queue fails / stops abruptly and then I have to hit the back button. Also it conflicts with vbseo in a way and takes jargon code from footer. We have a nehlam dedicated server.

I'm willing to pay but can someone tell me how

a.) I can send an email to all my members without having to watch the queue page update every x seconds and then stop?

b.) Reduce server loads and ensure the bounced emails are not sent again.

I'm sorry but was this addressed?

mails are properly sent only to gmail users, all other users are facing problems either with blank emails or no emails. Any solution to fix this ?

Quote:

Originally Posted by StarBuG (Post 2215544)

I get the following error when I try to send the newsletter:

Code:

Warning: Missing argument 1 for vB_Database::query_write(), called in [path]/acp/commbull_functions.php on line 366 and defined in [path]/includes/class_core.php on line 438





Database error in vBulletin 4.1.4:



Invalid SQL:

;



MySQL Error   : Query was empty

Error Number  : 1065

Request Date  : Friday, July 1st 2011 @ 02:27:27 PM

Error Date    : Friday, July 1st 2011 @ 02:27:27 PM

Script        : http://www.adsenseexperts.com/acp/commbull.php?do=send

Referrer      : http://www.adsenseexperts.com/acp/commbull.php

IP Address    : xxx

Username      : me

Classname     : vB_Database

MySQL Version : 5.0.51a-24+lenny5

I run 4.14, this is a fresh install (with modifications from the 4.0 Version Thread) and I have selected usergroups and forums for the newsletter.
I can see the newsletter preview but when I click send I get the above error.

Can anyone help me with this?

Any help is appreciated

I am having the same problem

Working 4.1.4 with edits. Thanks.

Anyone ever figure out how to include photopost into commbull?

I had a problem with this mod where sometimes it wouldn't send out emails or it sent out several to the same user, duplicated emails.
In my case I did two things to solve this:
1 In Vbulletin>admincp>Options>settings>Email Options

Use Mailqueue System set to "Yes, with locking"
This prevents duplicated newsletter from going out and also helps the smooth distribution of those newsletters.

2 SMTP Email set this to yes!
Now fill in the settings for your smtp server and hit save.
Since doing this I'm able to send out newsletters without problems to over 5,000 members.
Hope this helps.

we wrote a PHP script that runs on our server that cleans everything up.

PHP Code:


		
			
<?php

define('DB_SERVER_NAME', 'localhost');
define('DB_USER_NAME', 'user');
define('DB_PASSWORD', 'pass');

$forum_dbs[] = 'db1';
$forum_dbs[] = 'db2';

$server = 'pop.gmail.com';
$user = 'email@email.com';
$password = 'password';

$conn = mysql_connect(DB_SERVER_NAME, DB_USER_NAME, DB_PASSWORD);
if ($conn) {
        $port = '995/pop3/ssl';

        set_time_limit(6000);

        $link = imap_open("{".$server.":".$port."}INBOX",$user,$password);

        if (!$link) {
                echo "Cannot create POP3 connection to $server: ".imap_last_error();
                return;
        }
        processMessages($link);
}

function processMessages($link, $max = 1000) {
  $check = imap_check($link);
  $num = $check->Nmsgs;

  if ($num > $max) {
        print "Processing first $max of $num messages\n";
        $num = $max;
  }

  print "Processed messages will be deleted from mailbox\n";

  for ($x=1; $x <= $num; $x++) {
    set_time_limit(60);
    flush();
        print "processing $x of $num messages\n";
    $processed = processBounce($link,$x);
    // delete it anyway - we've seen it, tried to process it, no need to do it again
    imap_mail_move($link, "$x:$x", "[Google Mail]/Trash");
    flush();
  }
  flush();
  print "\nClosing mailbox, and purging messages\n\n";

  set_time_limit(60 * $num);
  imap_expunge($link);
  imap_close($link);
}

function processBounce($link,$num) {
  global $forum_dbs, $conn;
  $headerinfo = imap_headerinfo($link,$num);
  $matched = false;

  $subject = strtolower($headerinfo->subject);

  if (strpos($subject, 'undelivered') !== false || strpos($subject, 'returned') !== false) {
        $email_address = '';
          $body = imap_body($link,$num);
          $pos = strpos($body, 'Undelivered Message');
          if ($pos) {
                $body = substr($body, $pos);
            preg_match ("/To: (.*)/i", $body, $match);
            if (is_array($match) && isset($match[1])) $email_address = trim($match[1]);
          }
          if ($email_address) {
                print "procesing email '$email_address'\n";
                // loop through the dbs to find the user and turn off emails to that address
                foreach ($forum_dbs as $db_name) {
                        if (mysql_select_db($db_name, $conn)) {
                                $query = "SELECT * FROM user WHERE email = '".mysql_real_escape_string($email_address) ."'";
                                $result = mysql_query($query, $conn);
                                if ($result && $user = mysql_fetch_assoc($result)) {
                                        echo "cleaning user '$email_address' from $db_name\n";
                                        $matched = true;
                                        $user_id = $user['user_id'];
                                        // no weekly newsletter
                                        mysql_query("UPDATE user SET receivebulletin = 0 WHERE userid = $user_id", $conn);
                                        // no longer receive admin emails
                                        mysql_query("UPDATE user SET options = options - 16 WHERE options & 16 AND userid = $user_id", $conn);
                                }
                        }
                }
          }
  }
  return $matched;
}

?>

Couple notes:
- everything gets bounced to our Google Apps account, so your setup may be slightly different
- we have multiple forums that run to the same email address, so we pass an array of DB's

I've installed this but when trying to access the settings etc. receive the following error:

Code:

Invalid SQL:



SELECT   administrator.*, 

FROM  user AS user

LEFT JOIN userfield AS userfield ON (user.userid =  userfield.userid)

LEFT JOIN usertextfield AS usertextfield ON  (usertextfield.userid =  user.userid) LEFT JOIN administrator AS administrator ON   (administrator.userid = user.userid) LEFT JOIN language AS language ON   (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 

LEFT  JOIN usergroup AS mgcugp ON (user.usergroupid=mgcugp.usergroupid) 

WHERE  user.userid = 3;



MySQL Error   : Unknown column  'language.phrasegroup_commbull' in 'field list'

Error Number  : 1054

Also, I'm not sure if I have all the right files as I receive an error when I try to open the zip file.

the error doesn't even make sense. I don't see phrasegroup_commbull in the search query for it to display that error. The product XML file is the one that would include these changes to the database.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01363 seconds Memory Usage 1,790KB 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 (2)bbcode_code_printable (1)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: