vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Administrative and Maintenance Tools - [DBTech] vBMail v2 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=266142)

mescalin 04-12-2012 06:39 PM

Problem was CFS firewall was blocking port 993 in my server. And when i open that port it collects them. Sorry about that, i couldnt think of firewall im using.

Now i collected bounced mails then i ran "Bounced Mail Threshold" it sent members pms and changed their setting. When i rerun it it sends same pms to these same users again and again in each "Bounced Mail Threshold" run. Shouldnt it send pm only once and process one member only once?

my "Bounced Mail Threshold" is 1

DragonByte Tech 04-12-2012 06:51 PM

It will only send it to them once, unless for some reason it fails to set dbtech_vbmail_bounceflag to 1 for those users. Check that it has correctly flipped to 1 for those users :)


Fillip

elsparkodiablo 04-18-2012 12:39 AM

I've installed this and am running into a problem. We use google as our mail server with mail.(ourdomain).com aliased to google. I've set up a bounced email address - bounced@(ourdomain).com through google, but I'm not sure what to put in the vbmail settings in order to get this active and working. When I attempt to run the cron task for bounced mails, it times out and gives me weird error messages.

DragonByte Tech 04-18-2012 12:42 AM

You can get the answer for this 3 posts above yours :)

IMAP Host: imap.gmail.com
IMAP Port: 993
Use SSL: Yes


Fillip

elsparkodiablo 04-18-2012 12:58 AM

Thanks for the fast followup, I had to put the bounced@(ourdomain).com instead of just bounced in the email field. Sorry.

I have 180k users, with probably tens of thousands who are orphaned, spammers, etc. Is there going to be a way to mass delete bounced emails?

DragonByte Tech 04-18-2012 01:17 AM

vBMail will collect the bounced mail from your server and store it on your server - it's not supposed to be deleted from vBMail's database :)


Fillip

elsparkodiablo 04-18-2012 01:13 PM

Fillip, just wanted to say that I'm pretty impressed with this. I'll probably be buying a lifetime version shortly.

Have you given any thought to extending this to handle unsubscribing members from threads & forums as well, making it an all in one program?

DragonByte Tech 04-18-2012 01:43 PM

It already does, if they reach the bounced mail threshold they will be unsubscribed from those parts as well to avoid future bounced mail :)


Fillip

elsparkodiablo 04-18-2012 01:51 PM

Whoa, really? It removes their thread / forum subscriptions? You should REALLY list that as a feature above then, that makes this a MUST HAVE. Great work, and thank you again for a good piece of software.

DragonByte Tech 04-18-2012 02:21 PM

It doesn't remove them, simply turns off email notification for them :)

Removing them outright would be disruptive to users who then proceed to change their email address to a valid one.


Fillip

elsparkodiablo 04-18-2012 02:43 PM

Is there a way to have this automatically notify the member in question that their email has bounced?

DragonByte Tech 04-18-2012 02:51 PM

Not straight away, but once they have reached the threshold they will receive a PM stating what has happened and what they need to do :)


Fillip

Tri@de 05-09-2012 12:25 PM

There's a way to use html code to make newsletter?

DragonByte Tech 05-09-2012 01:22 PM

Yeah, you can use HTML code :)


Fillip

Martyn1983 05-10-2012 06:24 PM

Can the number of emails sent per hour be altered?

Our server has a limit off 200 and at the moment my email is being swamped with auto-responses saying mail cannot be sent :(

DragonByte Tech 05-10-2012 06:31 PM

vBMail uses vBulletin's mailqueue system and I don't believe it supports email per hour limit at this time. Any modification that implements this (if it exists) will work with vBMail, though :)


Fillip

Martyn1983 05-10-2012 06:36 PM

Quote:

Originally Posted by DragonByte Tech (Post 2328172)
vBMail uses vBulletin's mailqueue system and I don't believe it supports email per hour limit at this time. Any modification that implements this (if it exists) will work with vBMail, though :)


Fillip

Ah - that's a pity :(

Will the bounced message re-send of their own accord? We really do need to get mails sent out to get old members back on the site again, but to up the email limit will cost money we simply don't have :(

DragonByte Tech 05-10-2012 06:41 PM

It will not, no.

There are plenty of shared hosts that don't impose an email per hour limit, so I suggest you shop around if your current host is unwilling to accomodate you :)


Fillip

Martyn1983 05-10-2012 06:45 PM

Damn.

We just moved hosts due to our hold hosts server continually dying on us.

Tri@de 05-10-2012 07:13 PM

Quote:

Originally Posted by DragonByte Tech (Post 2327712)
Yeah, you can use HTML code :)


Fillip

I tried but i had some odd behaviour:
i have to write on the editor without spaces like this
Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Alteregonline Newsletter</title><link rel="Shortcut Icon" href="favicon.ico" type="image/x-icon" /></head><body ><center><!-- Table for background color when body tags are stripped --><table align="center" width="98%" bgcolor="#000000" cellpadding="0" cellspacing="0"><tbody>
instead of:
Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Alteregonline Newsletter</title>
<link rel="Shortcut Icon" href="favicon.ico" type="image/x-icon" />
</head>
<body >
<center>
<!-- Table for background color when body tags are stripped -->
<table align="center" width="98%" bgcolor="#000000" cellpadding="0" cellspacing="0">
<tbody>

There's a way to avoid this?
If i use spaces the newsletter appear messed up.

Logician 05-11-2012 07:31 AM

Quote:

Originally Posted by DragonByte Tech (Post 2298063)
Whoops, that was an oversight, that should not happen. Thanks for letting me know :)

Open /dbtech/vbmail/includes/class_dm_message.php and comment out both instances of the following code:
PHP Code:

VBMAIL_CACHE::build_cache('message'); 

Feel free to delete that datastore entry via
Code:

DELETE FROM vb_datastore WHERE title = 'dbtech_vbmail_message'
to save some database space :)


Fillip

Thanks for this fix. After a while, it was also producing Fatal Error Allowed memory size of ... exceeded error as well. :)

DragonByte Tech 05-11-2012 02:26 PM

Quote:

Originally Posted by Tri@de (Post 2328187)
I tried but i had some odd behaviour:
i have to write on the editor without spaces like this
Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Alteregonline Newsletter</title><link rel="Shortcut Icon" href="favicon.ico" type="image/x-icon" /></head><body ><center><!-- Table for background color when body tags are stripped --><table align="center" width="98%" bgcolor="#000000" cellpadding="0" cellspacing="0"><tbody>
instead of:
Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Alteregonline Newsletter</title>
<link rel="Shortcut Icon" href="favicon.ico" type="image/x-icon" />
</head>
<body >
<center>
<!-- Table for background color when body tags are stripped -->
<table align="center" width="98%" bgcolor="#000000" cellpadding="0" cellspacing="0">
<tbody>

There's a way to avoid this?
If i use spaces the newsletter appear messed up.

That's probably because we convert new lines to <br /> tags. This is essential in order to allow non-HTML only mails to be sent.

Unfortunately to my knowledge there is no way around this :(


Fillip

DragonByte Tech 05-28-2012 09:37 PM

vBMail v1.1.6
Feature: Now compatible with vBulletin 4.2.0's Navigation Manager.

Fillip

mescalin 06-06-2012 03:01 PM

i use that mod for only bounced mail handling but have a problem with it. it changes user group of banned members too. So their bans are lifted because of bounced mails.

DragonByte Tech 06-08-2012 05:25 PM

Could you please re-create this as a new bug report over at our forum? Sadly it's too easy for posts here on vb.org to get lost / missed :(

Thanks :)


Fillip

John Lester 07-10-2012 11:30 PM

Fillip I have a question about the unsubscribe part. When they click the link at the bottom of the email, what happens next? Does it take them to a page where they enter their email address and click a button? Does it send them another email with another link to click?

I'm having serious problems with my host (hostmonster) and finding an appropriate opt out solution :(

Hmmm does this handle ALL outgoing emails? IE birthday emails, thread subscriptions, new pm notifies? Or are those still handled by vBulletin? Reason I ask is that hostmonster requires a 1 click opt out for all emails. Meaning that after the user clicks the link in the email, they enter their email addy in a box and click a link/button and be completely done with the unsubscribing process.

DragonByte Tech 07-11-2012 03:00 PM

Quote:

Originally Posted by John Lester (Post 2346829)
Fillip I have a question about the unsubscribe part. When they click the link at the bottom of the email, what happens next? Does it take them to a page where they enter their email address and click a button? Does it send them another email with another link to click?

I'm having serious problems with my host (hostmonster) and finding an appropriate opt out solution :(

They will be unsubscribed as soon as they click the link, no need to enter email address or click anything else on the page :)

Quote:

Originally Posted by John Lester (Post 2346829)
Hmmm does this handle ALL outgoing emails? IE birthday emails, thread subscriptions, new pm notifies? Or are those still handled by vBulletin? Reason I ask is that hostmonster requires a 1 click opt out for all emails. Meaning that after the user clicks the link in the email, they enter their email addy in a box and click a link/button and be completely done with the unsubscribing process.

No vBMail doesn't handle those. Also, those emails are opt-in so they should be exempt from those requirements.


Fillip

John Lester 07-11-2012 04:05 PM

I agree with you Fillip that the birthday emails and such are all opt in and should be exempt, but my retarded host says no.

I don't send out mass emails so I probably won't install this mod, but if it's like any of your other mods I'm sure it rocks :) Thank you for taking the time to answer my questions.

cisoprogressivo 07-13-2012 10:26 AM

I uninstalled vBmail and sometime I get this database error:

Quote:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_dbtech_vbmail AS phrasegroup_dbtech_vbmail,
phrasegroup_user AS phrasegroup_user,
phrasegroup_album AS phrasegroup_album,
phrasegroup_posting AS phrasegroup_posting,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM forumvb_language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_dbtech_vbmail' in 'field list'
Error Number : 1054
Request Date : Friday, July 13th 2012 @ 12:22:08 PM
Error Date : Friday, July 13th 2012 @ 12:22:08 PM
Script : http://www.androidworld.it/forum/vbmail.php?langid=1
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version :

DragonByte Tech 07-14-2012 02:40 PM

You need to delete the files from this mod once you've uninstalled it.

Fillip

cisoprogressivo 07-16-2012 09:13 AM

I decided to reinstall vBMail and I get a lot of this error:
Quote:

Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE forumvb_user SET
usergroupid = 2,
usertitle = 'Baby Android',
customtitle = 0,
dbtech_vbmail_bounceflag = '0',
displaygroupid = 0
WHERE userid = 49125;

MySQL Error : Unknown column 'dbtech_vbmail_bounceflag' in 'field list'
Error Number : 1054
Request Date : Monday, July 16th 2012 @ 12:08:37 PM
Error Date : Monday, July 16th 2012 @ 12:08:38 PM
Script : http://www.androidworld.it/forum/reg...fd9295a3ac9827
Referrer :
IP Address : ***
Username : ste9822
Classname : vB_Database
MySQL Version :

DragonByte Tech 07-16-2012 12:05 PM

Run these 2 queries:
Code:

alter table forumvb_dbtech_vbmail_mailinglist add external enum('0', '1') not null default '0'
Code:

alter table forumvb_user add dbtech_vbmail_bounceflag enum('0', '1') not null default '0'

Fillip

cisoprogressivo 07-19-2012 02:15 PM

Quote:

Originally Posted by DragonByte Tech (Post 2348651)
Run these 2 queries:
Code:

alter table forumvb_dbtech_vbmail_mailinglist add external enum('0', '1') not null default '0'
Code:

alter table forumvb_user add dbtech_vbmail_bounceflag enum('0', '1') not null default '0'

Fillip

Thank you!

dany_danay 07-24-2012 05:33 PM

Sorry, but i want to send an HTML email, but when i put it in the ck editor, obviously, it doesnt parse... I can send html mail?

DragonByte Tech 07-24-2012 10:30 PM

Yeah, you can send HTML email :)

You can test it by creating a new mailing list only you have access to, then send a test HTML email :)


Fillip

rebelde 08-08-2012 04:13 AM

Fillip,

Great job with the bounced email handling. I'm not sure you understand what a big deal this is. Building on your code, we can now block a lot of outgoing emails that will bounce.

I just created an add-on modification (the Poor Man's Bounced Email Handler) that uses your vBMail as a basis to block "new post" notifications. I hope you don't mind and that people find it useful.

DragonByte Tech 08-08-2012 04:49 PM

I had a quick look at your code, unless I'm reading it wrong I think it's already covered by vBMail :)

The hook you used is executed in exec_send_notification, and the query only returns users that match
Code:

subscribethread.emailupdate IN (1, 4)
whereas part of vBMail's "remove the user from everything email related" cron job code is setting that column to 0 - so in theory it shouldn't fetch users vBMail has dealt with :)

For the record; we'll never give permission to re-use our code :)


Fillip

rebelde 08-08-2012 05:11 PM

Quote:

Originally Posted by DragonByte Tech (Post 2355587)
unless I'm reading it wrong I think it's already covered by vBMail

There might be a bug. Without my small bit of code, emails were still being sent out to users whose emails were bouncing. With my code, those emails stopped going out.

DragonByte Tech 08-17-2012 10:55 PM

vBMail v1.1.7:
Feature: The Affiliate ID setting now properly integrates with the link-back

Fillip

DragonByte Tech 08-25-2012 05:59 PM

Affiliate ID link hotfix

Fillip


All times are GMT. The time now is 06:54 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.01942 seconds
  • Memory Usage 1,846KB
  • 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
  • (10)bbcode_code_printable
  • (1)bbcode_php_printable
  • (10)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