UBB.Developers Forums UBB.threads 7 Development How Do I? sending mass email to users

I tried using the send mass mail function and it only sent it out to about 30-40 adresses. It said sent to batch 1 of 1 and showed me the addresses it sent it to. I have version 6.3. any ideas on this one? I tried checking the send one at a time box and also tried uncehcking it. Got pretty much the same results every time. I have almost 700 registered users.

It is possible that most of your users have opted out the receive emails option. In 6.3 I believe you actually have to choose to opt in to recieve the emails.

You can run this sql querry to see how many have elected to recieve emails.

SELECT U_Username,U_Email
FROM w3t_Users
WHERE U_AdminEmails = 'On'

CAn you tell me how step by step to run that query? Sorry Im new at this..Thanks

nevermind I got it..and there are a ton of email addresses in there when i di the query..id say at least 400-500..any ideas?

Admin -> SQL Query ->
Then enter that Query in the box.


This query might be better as it'll give you a count


SELECT COUNT (*)
FROM w3t_Users
WHERE U_AdminEmails = 'On'

count is 340 and id say it only set to 30-40 people..Any ideas?

So does it do more than one page..... in other words.... it does all the plain text email first.......

Try this query

SELECT COUNT (*)
FROM w3t_Users
WHERE U_AdminEmails = 'On'
AND U_EmailFormat = 'html'

for html i get 10...for plain text query I get 32? Yes it sends plain text first and html second...32 plus 10 does not = 340..What gives?

So somehow people don't have the right email format.

Try this query:

UPDATE w3t_Users
SET U_EmailFormat = 'plaintext'
WHERE U_EmailFormat != 'html'


That should update all the emails without an email preference.

It says 1 row updated..does that sound right?
My database was imported about 3 months ago for Ubb classic if that helps at all.

yeah, something might not have update right.


Try this:


SELECT COUNT(*)
FROM w3t_Users
WHERE U_AdminEmails = 'On'
SET U_EmailFormat = 'plaintext'


See what that count is.



Then do this:


SELECT COUNT(*)
FROM w3t_Users
WHERE U_AdminEmails = 'On'
SET U_EmailFormat = 'html'



If the numbers seem substantially higher.... try the email again. The emailer will cycle through all the plain text ones first.... then do the HTML mail.

I suggest this one instead:

SELECT U_EmailFormat,COUNT(*)
FROM w3t_Users
WHERE U_AdminEmails = 'On'
GROUP BY U_EmailFormat

Gotta Love the Master Jedi.

All Hail Dave!!

Just don't ask me how to tune MySQL.

LOL

I just love how you always come up with the ultimate QUERIES that combine functions when most of us know the BASIC ones.

ok to Dave L's query i get this

U_EmailFormat COUNT(*)
305
HTML 10
plaintext 33
Thoughts?

Josh Pet it says I have a syntax error in line 4 when trying to run your querys

I'm a tard. I copy and pasted and never properly edited.

OK 305 users still don't have an email preference defined.

Try this:

UPDATE w3t_Users
SET U_EmailFormat = 'plaintext'
WHERE U_EmailFormat <> 'html'

Then do Dave_L's query again.

1 row(s) affected by your query.

[]JoshPet said:


Then do Dave_L's query again. [/]

And see if the numbers are better.

same thing
U_EmailFormat COUNT(*)
306
HTML 10
plaintext 33

The UBB.threads SQL command function doesn't display NULL values correctly.

Try:

UPDATE w3t_Users
SET U_EmailFormat = 'plaintext'
WHERE U_EmailFormat <> 'html' OR U_EmailFormat IS NULL

Then repeat this query:

SELECT U_EmailFormat,COUNT(*)
FROM w3t_Users
WHERE U_AdminEmails = 'On'
GROUP BY U_EmailFormat

Might as well do this one too:

SELECT U_AdminEmails,COUNT(*)
FROM w3t_Users
GROUP BY U_AdminEmails

ok to the second two I got
U_AdminEmails COUNT(*)
337
Off 3
On 349


U_EmailFormat COUNT(*)
HTML 10
plaintext 339

so I guess with only 3 off and 680 registered users where are the other few hubdred in there?

They're probably either NULL or the empty string. I'm not sure whether the script interprets that as On or Off.

Try this...

UPDATE w3t_Users
SET U_AdminEmails = 'On'
WHERE U_AdminEmails <> 'Off'

then do Dave's query again.

You're forgetting about NULL again.

Oh so <> 'Off' won't update null huh?


Then :

UPDATE w3t_Users
SET U_AdminEmails = 'On'
WHERE U_AdminEmails IS NULL


Will that work?

I can never remember the rules for how NULL works with logical comparison operators. That's one reason why Rick should define all the columns as NOT NULL, unless there's really a good reason to do otherwise.

I would do:

UPDATE w3t_Users
SET U_AdminEmails = 'On'
WHERE U_AdminEmails <> 'Off' OR U_AdminEmails IS NULL

(This is assuming that you want to default to U_AdminEmails = 'On' for users who didn't indicate a preference, which increases the chances that someone might report you for spamming.)

And then do a SELECT query afterwards to see if it got everyone.

P.S. Here's a way of getting NULL values to show up as such when using the threads SQL command function (except the results would be misleading if there were any 'NULL', as opposed to NULL, values):

SELECT IF (U_Color IS NULL, 'NULL', U_Color) AS U_Color, COUNT(*)
FROM w3t_Users
GROUP BY U_Color

to the last query I got....yes i want the default to receive admin emails. now what?

U_Color COUNT(*)
683
#FF0000 5
NULL 1

That U_Color query was just a example for Josh. It has nothing to do with the emails.

Did you do this?

UPDATE w3t_Users
SET U_AdminEmails = 'On'
WHERE U_AdminEmails <> 'Off' OR U_AdminEmails IS NULL

And then do this to check the results, and post the output:

SELECT U_AdminEmails,COUNT(*)
FROM w3t_Users
GROUP BY U_AdminEmails

ok did both..for the second one i got....

U_AdminEmails COUNT(*)
Off 3
On 686

then i did your original query and got this

U_EmailFormat COUNT(*)
HTML 10
plaintext 676

So that should do it right?

Yes, the U_AdminEmails and U_EmailFormat columns look ok now. Wasn't that easy?

You have a funny definition of easy.

Hey thanks Dave and Josh pet for all your help!