[UPDATE] Mass PM (vB 2.0)

An update to the hack posted by chrispadfield at http://www.vbulletin.com/forum/showt...threadid=8582.

Updates:

1. Modified the look of page to match that of the email page.

2. Added select fields to send message to.

4. Fixed $adminuser and set to a hidden field.

Enjoy!

PHP Code:


<?php

require("./global.php");

adminlog();

cpheader();

  if ($action=="") {

  echo "<p>In the private message, you may use \$username, \$password and \$email.</p>";
  doformheader("masspm","masspm");

  makehiddencode("fromuserid","$bbuserid");
  makeinputcode("Subject:","title");
  maketextareacode("Message:","message","",10,40);

  echo "<tr><td colspan=2><b>Private message to users where:</b></td></tr>\n";
  makeinputcode("User Name contains","ausername");
  if ($pwdincp!=0) {
    makeinputcode("and password contains","apassword");
  }
  makechoosercode("and usergroup is","usergroupid","usergroup",-1,"Any");
  makeinputcode("and email contains","aemail");
  makeinputcode("and parent's email contains","parentemail");
  makeinputcode("and is coppa user (yes, no, blank for don't mind)","coppauser");
  makeinputcode("and homepage contains","homepage");
  makeinputcode("and ICQ Number contains","icq");
  makeinputcode("and AIM Handle contains","aim");
  makeinputcode("and Yahoo Messenger Handle contains","yahoo");
  makeinputcode("and Biography contains","biography");
  makeinputcode("and Signature contains","signature");
  makeinputcode("and User Title contains","usertitle");
  makeinputcode("and Join Date is after<br>(Format yyyy-mm-dd, leave blank for today)","joindateafter");
  makeinputcode("and Join Date is before<br>(Format yyyy-mm-dd, leave blank for today)","joindatebefore");
  makeinputcode("and Last Visit is after<br>(Format yyyy-mm-dd hh:mm:ss, leave blank for today)","lastvisitafter");
  makeinputcode("and Last Visit is before<br>(Format yyyy-mm-dd hh:mm:ss, leave blank for today)","lastvisitbefore");
  makeinputcode("and Last Post is after<br>(Format yyyy-mm-dd hh:mm:ss, leave blank for today)","lastpostafter");
  makeinputcode("and Last Post is before<br>(Format yyyy-mm-dd hh:mm:ss, leave blank for today)","lastpostbefore");
  makeinputcode("and Number of Posts is greater than","postslower");
  makeinputcode("and Number of Posts is less than","postsupper");

  doformfooter();
}

if ($action=="masspm") {   

if ($condition=="") {

    $condition="1=1";
    if ($ausername!="") {
      $condition.=" AND INSTR(username,'".addslashes(htmlspecialchars($ausername))."')>0";
    }
    if ($apassword!="") {
      $condition.=" AND INSTR(password,'".addslashes($apassword)."')>0";
    }
    if ($usergroupid!=-1 and $usergroupid!="") {
      $condition.=" AND usergroupid=$usergroupid";
    }
    if ($aemail!="") {
      $condition.=" AND INSTR(email,'".addslashes(htmlspecialchars($aemail))."')>0";
    }
    if ($parentemail!="") {
      $condition.=" AND INSTR(parentemail,'".addslashes(htmlspecialchars($parentemail))."')>0";
    }
    $coppauser=strtolower($coppauser);
    if ($coppauser=="yes") {
      $condition.=" AND coppauser=1";
    }
    if ($coppauser=="no") {
      $condition.=" AND coppauser=0";
    }
    if ($homepage!="") {
      $condition.=" AND INSTR(homepage,'".addslashes(htmlspecialchars($homepage))."')>0";
    }
    if ($icq!="") {
      $condition.=" AND INSTR(icq,'".addslashes(htmlspecialchars($icq))."')>0";
    }
    if ($aim!="") {
      $condition.=" AND INSTR(aim,'".addslashes(htmlspecialchars($aim))."')>0";
    }
    if ($yahoo!="") {
      $condition.=" AND INSTR(yahoo,'".addslashes(htmlspecialchars($yahoo))."')>0";
    }
    if ($biography!="") {
      $condition.=" AND INSTR(biography,'".addslashes(htmlspecialchars($biography))."')>0";
    }
    if ($signature!="") {
      $condition.=" AND INSTR(signature,'".addslashes($signature)."')>0";
    }
    if ($usertitle!="") {
      $condition.=" AND INSTR(usertitle,'".addslashes($usertitle)."')>0";
    }
    if ($joindateafter!="") {
      $condition.=" AND joindate>UNIX_TIMESTAMP('".addslashes($joindateafter)."')";
    }
    if ($joindatebefore!="") {
      $condition.=" AND joindate<UNIX_TIMESTAMP('".addslashes($joindatebefore)."')";
    }
    if ($lastvisitafter!="") {
      $condition.=" AND lastvisit>UNIX_TIMESTAMP('".addslashes($lastvisitafter)."')";
    }
    if ($lastvisitbefore!="") {
      $condition.=" AND lastvisit<UNIX_TIMESTAMP('".addslashes($lastvisitbefore)."')";
    }
    if ($lastpostafter!="") {
      $condition.=" AND lastpost>UNIX_TIMESTAMP('".addslashes($lastpostafter)."')";
    }
    if ($lastpostbefore!="") {
      $condition.=" AND lastpost<UNIX_TIMESTAMP('".addslashes($lastpostbefore)."')";
    }
    if ($postslower!="") {
      $condition.=" AND posts>'$postslower'";
    }
    if ($postsupper!="") {
      $condition.=" AND posts<'$postsupper'";
    }
  }

$users=$DB_site->query("SELECT userid,username,password,email FROM user WHERE $condition");
    
    while ($user=$DB_site->fetch_array($users)) {

    $userid=$user[userid];
    $message=$message;
    $message=str_replace("\$email",$user[email],$message);
    $message=str_replace("\$username",$user[username],$message);
    $message=str_replace("\$password",$user[password],$message);

    $sql=$DB_site->query("INSERT INTO privatemessage (privatemessageid, folderid, userid, touserid, fromuserid, title, message, dateline, showsignature, iconid, messageread) VALUES (NULL, '0', '$user[userid]', '$user[userid]', '$fromuserid', '".addslashes($title)."', '".addslashes($message)."', UNIX_TIMESTAMP(), '1', '0', '0')");
    
echo "PM sent to $user[userid] <br>";

    }
  }
    
?>

[JoshFink]

So, this version does fix the email notification problem? What else is fixed in there?

Thanks so much for the help.

Josh

[Mystics]

Besides the eMail notification problem, there was no "PM Popup" and the "Next Page" Button redirected to the wrong URL.

[JoshFink]

Thanks for the help. I'm going to install it now..

[Mystics]

I have uploaded a new Version:
https://vborg.vbsupport.ru/showthrea...&postid=219446

There was a Bug when sending a PM to many users over several pages (the wrong "fromuserid" was stored).

I also added a feature for automatic redirection to the next page.

Mystics

[wolfe]

can u add something where it alerts the members of a new PM if they have chose to recieve email on new PM

[Mystics]

@wolfe

Look at my attachment....

[nocturnix123]

Okay, I installed this on my local machine to test it...and so far it seems to work fine, except some minor problems....

1. when i go to http://localhost/forum/private.php?s=

The message is not there and it says "There are no messages to display in this folder for this time period."

I can only see it if i select to display the messages from the last year 2 days or more...

The dates *seem* right, any clue why the messages arent showing up in the inbox?

[nocturnix123]

NM, i figured it out

[AlexanderT]

The Hack works fine but requires one fix:

The first masspm I sent out was without a subject field (I forgot to enter it). Yet the Hack sent it out. The result was that every user received a PM he or she was unable to open (usercp doesn't give a link to the PM without a subject). I was forced to run a query on my database removing all the PM's without a subject again.

[lemarsu]

Hi,

Looks great...
But (there is always a But....) is there a way to pickup the new custom User Profile Fields, that I have created ?

It has all the normal ones:

User Name contains
and usergroup is
and email contains
and parent's email contains
and is coppa user (yes, no, blank for don't mind)
and homepage contains
and ICQ Number contains
and AIM Handle contains
and Yahoo Messenger Handle contains
and Biography contains
…….

Can we add the custom ones ? they do appear at the bottom of search for users?

LeMarsu