Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 21 Jan 2015, 15:11
VodkaFish VodkaFish is offline
 
Join Date: Oct 2003
Disabling email for older accounts

Is there any easy way (outside of a sql statement, which is what I assume I'm going to need here) to disable old accounts from receiving emails? Most people who receive the birthday email seem to like it, but those who haven't logged in in years, the chances of a bounce are high, and I'd like to avoid those.

I'm thinking I can write a sql statement setting receive admin emails to no on activity date before 'x', but before I did, I wanted to know if there was some control panel way to do it.
Reply With Quote
  #2  
Old 21 Jan 2015, 17:14
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
I can't think of any way to do that without a query.
Reply With Quote
  #3  
Old 21 Jan 2015, 17:51
VodkaFish VodkaFish is offline
 
Join Date: Oct 2003
Thanks. Should I be looking at the allowemail column? Searching in the forums makes it look like it's in the options column as WHERE options & 16 instead of WHERE allowemail = 'yes'
Reply With Quote
  #4  
Old 21 Jan 2015, 17:54
nerbert nerbert is offline
 
Join Date: May 2008
If it's mostly birthday emails you're concerned with and you don't mind a file edit it looks like you could modify includes/cron/birthday.php so the query there picks up lastactivity and a conditional determines whether to send the email based on the time elapsed
Reply With Quote
  #5  
Old 21 Jan 2015, 17:55
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Originally Posted by VodkaFish View Post
Thanks. Should I be looking at the allowemail column? Searching in the forums makes it look like it's in the options column as WHERE options & 16 instead of WHERE allowemail = 'yes'

Yeah, it's the options & 16 one. It should be something like

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

where you'd add your date check code. It checks for options & 16 because it does a subtraction to unset the bit, so of course you dont' want to do it unless it's already set. I took that from the "canned" queries in the Maintenance menu, and I don't know enough SQL to know why they don't use a bitmask.
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
vBulletin POP3 / IMAP Email Client for vB3 - Web-based access to POP email accounts! Erwin vBulletin 3.0 Full Releases 309 09 May 2008 12:31
vB POP3 / IMAP Email Client 1.4 - Web-based access to POP email accounts Erwin vBulletin 2.x Full Releases 288 17 Jun 2004 13:30



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 16:43.

Layout Options | Width: Wide Color: