Pm All Members *Via Email Form

[insanctus]

As asked for Here (https://vborg.vbsupport.ru/showthread.php?t=63662)

What this does, is turn your admin email all into an email or pm all.

I did it this way due to less clutter and files also effective.

I will offer support as my time allows.

See Screan Shot To See Effect.

[Vivi Ornitier]

oh wow, good stuff man, gvery good thinking *clicks install*

[insanctus]

No trouble at all, the thought on how to do it this way came to me in the middle of dinner.

Very odd this hack is not showing up on main page....

[Vivi Ornitier]

it's not showing up for some reason

I can't find the

if (!$_POST['test'])
{
echo $vbphrase['emailing']." \n";
vbmail($user['email'], $_POST['subject'], $sendmessage, true, $_POST['from']);
}
}

Instead the part i do find in email.php is

if (!$_POST['test'])
{
echo $vbphrase['emailing']." \n";
vbmail($user['email'], $_POST['subject'], $sendmessage, true, $_POST['from']);
}
else
{
echo $vbphrase['test'] . " ... \n";
}

[insanctus]

Ok Instead Do This

Find

echo $vbphrase['emailing']." \n";
vbmail($user['email'], $_POST['subject'], $sendmessage, true, $_POST['from']);


Replace With

if ($_POST['pm']==1){// Lets PM All Instead
$DB_site->query("INSERT INTO pmtext (fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie)
VALUES ($bbuserinfo[userid], '$bbuserinfo[username]', '$_POST[subject]', '" . addslashes($sendmessage) . "', '" . serialize(array($user[userid] => $user[username])) . "', 0, " . TIMENOW . ", 0, 0)");
$pmid = $DB_site->insert_id();
$DB_site->query("UPDATE user SET pmtotal=pmtotal+1, pmunread=pmunread+1, pmpopup=2 WHERE userid=$user[userid]");
$DB_site->query("INSERT INTO pm (pmtextid, userid, folderid, messageread) VALUES ('$pmid', '$user[userid]', '0', '0')");
}else{
echo $vbphrase['emailing']." \n";
vbmail($user['email'], $_POST['subject'], $sendmessage, true, $_POST['from']);
}

I will update the txt now

[Vivi Ornitier]

i get this error when i mass pm it. It stops at the UserID 464 with a guy's name X's Angel, this is the sql error it gives.


Database error in vBulletin 3.0.0:

Invalid SQL: INSERT INTO pmtext (fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie)
VALUES (1, 'deathscythehell', 'test #3', 'testing once more', 'a:1:{i:464;s:9:"X's Angel";}', 0, 1083469828, 0, 0)
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's Angel";}', 0, 1083469828, 0, 0)' at line 2

mysql error number: 1064

Date: Sunday 02nd of May 2004 03:50:29 AM
Script: http://forums.squareultima.com/admincp/email.php
Referer: http://forums.squareultima.com/admincp/email.php?do=start
Username: deathscythehell
IP Address: 64.40.53.44

[allhandl]

fantastic work. Went flawlessly

[insanctus]

Are you possitive you added it in right spot, I just did a test on my site of 940 members and it worked as planed.

[insanctus]

i get this error when i mass pm it. It stops at the UserID 464 with a guy's name X's Angel, this is the sql error it gives.


Database error in vBulletin 3.0.0:

Invalid SQL: INSERT INTO pmtext (fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie)
VALUES (1, 'deathscythehell', 'test #3', 'testing once more', 'a:1:{i:464;s:9:"X's Angel";}', 0, 1083469828, 0, 0)
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's Angel";}', 0, 1083469828, 0, 0)' at line 2

mysql error number: 1064

Date: Sunday 02nd of May 2004 03:50:29 AM
Script: http://forums.squareultima.com/admincp/email.php
Referer: http://forums.squareultima.com/admincp/email.php?do=start
Username: deathscythehell
IP Address: 64.40.53.44
Do me a favor and post your exact code from that section

It sounds to me like you did the first edit, then put the fix over top of it.

[Vivi Ornitier]

Ya, i think it's somethin to do with confliction with apostrophes. You can't have any ' in a name or else it screws it up?

[insanctus]

fantastic work. Went flawlessly
Good to hear :) , I did install to 2 sites and both going as planned.

[Boofo]

That's easy to fix. You just need to add an addslashes to the username variable when inserting it into the db.

[Vivi Ornitier]

hey insanctus, you should create a user with an apostrophe in its name and then try mass pming. I'm pretty dead set sure it's the apostrophes doin the error.

[insanctus]

Find $DB_site->query("INSERT INTO pmtext (fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie)
VALUES ($bbuserinfo[userid], '$bbuserinfo[username]', '$_POST[subject]', '" . addslashes($sendmessage) . "', '" . serialize(array($user[userid] => $user[username])) . "', 0, " . TIMENOW . ", 0, 0)");

Replace with
$DB_site->query("INSERT INTO pmtext
(fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie
)
VALUES
($bbuserinfo[userid], '" . addslashes($bbuserinfo[username]) . "', '$_POST[subject]', '" . addslashes($sendmessage) . "', '" . serialize(array($user[userid] => addslashes($user['username']))) . "', 0, " . TIMENOW . ", 0, 0)");

I will update the text now

[Vivi Ornitier]

parse error on line 201 and line 201 is just a ).

[insanctus]

Sounds like you missed some of the code copy. Can you post your code?

[Vivi Ornitier]

Sounds like you missed some of the code copy. Can you post your code?

here is email.php

[insanctus]

here is email.php

$DB_site->query("INSERT INTO pmtext
(fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie
)
VALUES
($bbuserinfo[userid], '" . addslashes($bbuserinfo[username]) . "', '$_POST[subject]', '" . addslashes($sendmessage) . "', '" . serialize(array($user[userid] => addslashes($user['username']))) . "', 0, " . TIMENOW . ", 0, 0)"

You forgot the ); at the end , it should be

$DB_site->query("INSERT INTO pmtext
(fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie
)
VALUES
($bbuserinfo[userid], '" . addslashes($bbuserinfo[username]) . "', '$_POST[subject]', '" . addslashes($sendmessage) . "', '" . serialize(array($user[userid] => addslashes($user['username']))) . "', 0, " . TIMENOW . ", 0, 0)");

[Boofo]

here is email.php

Vivi Ornitier, you need to remove the link for that file. vBulletin files are not allowed to be posted here. Please just post the code you need looked at. ;)

[Vivi Ornitier]

workin perfectly ;)

[Boofo]

Will this work even if they have pms or emails turned off from Admins?

[insanctus]

Will this work even if they have pms or emails turned off from Admins?
Yes, it even makes it have a pop up , no matter if they choose :)

You will have to click the ignore those who do not want emails from admin though.

I found this the most efficent way to do the hack.

[insanctus]

workin perfectly ;)
Sweet, and thanks for finding that ' in name bug. I not do not have any members that have that so it did not effect me :)

[Boofo]

Then I better click install, huh? ;)

[insanctus]

Then I better click install, huh? ;)
Please do :), so far only one has.... lol

[templates911]

nice. Ive been waiting forever on this hack! Installing now.

[templates911]

im getting a Parse error: parse error in email.php on line 204

[insanctus]

im getting a Parse error: parse error in email.php on line 215
Can you post your line 215 for me?

[Floris]

Can you post your line 215 for me?
Can I limit this to a usergroup? I.e. Mass PM all admins, or registered members .. ?

[insanctus]

Can I limit this to a usergroup? I.e. Mass PM all admins, or registered members .. ?
Yes using the search criteria as you would a mass email, it works exact same way :)

It has all the options of mass email. I do recommend checking the "Include users that have declined admin emails?"

[Oblivion Knight]

Thanks.! Works great.. :D
I made this work with phrases too, just to be a little cleaner.

[templates911]

would you mind me emailing the file to you? I think its a problem with another hack i had installed on the email.php

[trainer]

is there way you could do a auto-reload the next page after X number of seconds? sending out 10k emails or PM's kill the server or time-out. being able to auto-reload the next page so we can do 50-100 at a time would really make things alot easier!

[Smoker]

Sory for my very very bad englisch.

This Hack no email sends to the user which it has a PM :(

bye
Smoker

[FleaBag]

Sweet - wanted this for a while as my e-mail always times out.

[insanctus]

would you mind me emailing the file to you? I think its a problem with another hack i had installed on the email.php
Email it to me admin@sanoxs.com I will take a look.

[insanctus]

Sory for my very very bad englisch.

This Hack no email sends to the user which it has a PM :(

bye
Smoker

If you mean it does not email them they have a new pm then no, I could add this in but the point of it was to not have them emailed.

is there way you could do a auto-reload the next page after X number of seconds? sending out 10k emails or PM's kill the server or time-out. being able to auto-reload the next page so we can do 50-100 at a time would really make things alot easier!

I can look into it later, I think it would be very possible.

Thanks.! Works great..
I made this work with phrases too, just to be a little cleaner

Very cool, glad it came in handy.

[subu1]

If you mean it does not email them they have a new pm then no, I could add this in but the point of it was to not have them emailed.


oh yes please do it, we need this function :-)))

greetz subu1

[SnowBot]

oh yes please do it, we need this function :-)))

greetz subu1
why do u need that function? Just email what you would have said in the PM.

Great hack, installing later but will click install :)

[BigJohnson]

How can we fix this?

Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in /forum/admincp/email.php on line 132

[insanctus]

How can we fix this?

Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in /forum/admincp/email.php on line 132
Can you show me the code at 132?

It is hard to fix when can not see the code.

[TheShell]

If you mean it does not email them they have a new pm then no, I could add this in but the point of it was to not have them emailed.



Yes, please add this funktion or tell us please how can we do that?


Thanks a lot ..

Gruss

[insanctus]

Yes, please add this funktion or tell us please how can we do that?


Thanks a lot ..

Gruss
You want it to email everyone that they have a new pm?

Or only those who want emails when they get a new pm?

[TheShell]

You want it to email everyone that they have a new pm?



Yes, thats what i want.

Gruss

[insanctus]

Yes, thats what i want.

Gruss
I just have to ask, if you do that, what is the point to pming them and not just emailing it?

[TheShell]

Ok ..

The Problem is, when you emailing something - many users dont read that ( spam ) but when you pming something an they people become a email with "Hello $username, you have a new pm ... in FORUMNAME" they come at the forum and read the pm. Thats all ;o)

In many other vB Forums i have read the same problem and many admins want this option for vb3. Me Toooooo ..

Gruss

[subu1]

why do u need that function? Just email what you would have said in the PM.



If i send my Members a email, (you have a Pm from the Webmaster) suddenly very vile Members come to read around this, my Record lies in 117 Members simultaneously and 552 Members at the same day.

sorry for my bad englisch, that was my translation Machine *g*

greetz subu1 and thxxx

[sc4r3d]

thank you bro

[insanctus]

So it would say private message from (admins name) ?

[TheShell]

Yes ;o)

Gruss

[subu1]

So it would say private message from (admins name) ?

si *g*

[CharlieBrownDE]

So it would say private message from (admins name) ?

yeah:)

[insanctus]

Ok here it is, It sends a email to everyone saying they got the pm you just mass pmed them (I find this silly myself but hey I will show the code)

I will not be adding this code into txt file for I think it is not ideal.

Find

$DB_site->query("INSERT INTO pm (pmtextid, userid, folderid, messageread) VALUES ('$pmid', '$user[userid]', '0', '0')");


After it place this on a new line.
$touserinfo= array();
$touserinfo=$user;
eval(fetch_email_phrases('pmreceived', $user['langageid'], '', 'email'));
vbmail($user['email'], $emailsubject, $emailmessage);

Enjoy :)

[Smoker]

nice :)

Goes very well :)

Thanks
Smoker

[subu1]

thxxxxxx, :-)

[CharlieBrownDE]

hello together,

for my not so good one English but I has a problem and excuse further I don't know there!
if I want to send a message, then I get an error message with database note. I had indicated although pay a deposit been different.

what can it be due to?


here the error message:

Pming
Zeige Benutzer 1 bis 135 von insgesamt 135
148 - Name des letzten Users wird hier angezeigt ....

note:
this chop you translated on German and the forum is going on in German.

[dutchbb]

Finally! One of the best hacks out here imo, thanks for this

/me clicks install

[insanctus]

hello together,

for my not so good one English but I has a problem and excuse further I don't know there!
if I want to send a message, then I get an error message with database note. I had indicated although pay a deposit been different.

what can it be due to?


here the error message:



note:
this chop you translated on German and the forum is going on in German.
I do not see any database info in that.

[insanctus]

Finally! One of the best hacks out here imo, thanks for this

* Triple_T clicks install
Most welcome :), glad I could help

[Sooner95]

/me clicks install... nice job M8....good hack

[DivisionByZero]

Is there a way to override the "print_yes_no" and clean it up and make it look professional by doing the following:

replacing the "PM instead of Email" line with:

Method: PM or E-mail

and changing "yes" to "PM" and "no" to "E-mail" ???

Great Hack!

[Oblivion Knight]

It would appear that the usergroup "Awaiting E-mail Confirmation" doesn't receive the PM.. It may be the same for other usergroups, I haven't tested it yet.. I'm testing this on 3.0.3 (slowly getting around to upgrading and re-installing hacks) - any ideas?

[Princeton]

exactly what I needed ... INSTALLED

thank you

[Sean S]

As asked for Here (https://vborg.vbsupport.ru/showthread.php?t=63662)

What this does, is turn your admin email all into an email or pm all.

I did it this way due to less clutter and files also effective.

I will offer support as my time allows.

See Screan Shot To See Effect.
thanks, works perfect. Install!

[Noiz Pollution]

I'm liking the look of this hack although I have 1 question.
If I send out a mass PM will the users who have an email alert telling them they have a PM receive an email when the PM hits their inbox? From what I've read this doesn't seem to be the case.

Cheers,
Robert

[Noiz Pollution]

*bump*

[Noiz Pollution]

*bump*

[insanctus]

*bump*
I think in second page is where I posted the code to email them, that they have a new pm.

I did not put it in the code for I personally did not like the idea, so I added it in a post.

[Noiz Pollution]

I think in second page is where I posted the code to email them, that they have a new pm.

I did not put it in the code for I personally did not like the idea, so I added it in a post.This post?:
Ok here it is, It sends a email to everyone saying they got the pm you just mass pmed them (I find this silly myself but hey I will show the code)

I will not be adding this code into txt file for I think it is not ideal.

Find

$DB_site->query("INSERT INTO pm (pmtextid, userid, folderid, messageread) VALUES ('$pmid', '$user[userid]', '0', '0')");


After it place this on a new line.
$touserinfo= array();
$touserinfo=$user;
eval(fetch_email_phrases('pmreceived', $user['langageid'], '', 'email'));
vbmail($user['email'], $emailsubject, $emailmessage);

Enjoy :)

[allandk]

I think in second page is where I posted the code to email them, that they have a new pm.

I did not put it in the code for I personally did not like the idea, so I added it in a post.

insanctus: why don't you answer my email ?

/Allan

[Noiz Pollution]

This post?:
*bump*

[insanctus]

*bump*
Yes that post ..... it emails all saying they just got a pm.


@all try now I had an email issue.

[y2krazy]

/me clicks install!

[mholtum]

Work Great! All of 2 minute install! Thank you! *Clicks Install*

[trulylowcarb]

works great on vb3.07 -thanks

[Oblivion Knight]

This mod has been updated (with permission from insanctus)..

The new thread can be found here (https://vborg.vbsupport.ru/showthread.php?s=&threadid=74450).

[trulylowcarb]

Sheesh. Can't imagine how I found this thread FIRST.... thanks for the update info!

[T3MEDIA]

Yeah... odd... Thank god cuz that other one by Zero just dont work... (mass PM)

[Jagged Tooth]

Great Hack, Thanks.
/me clicks install

--Jagged Tooth--

[h2ojunkie]

Anyone know if this has been ported to 3.5?