The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 02-14-2001

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>";



    }

  }

    

?>

KarateKid · #32 12-09-2001, 08:11 PM

does it work for 2.2.1 ?

Mystics · #33 02-10-2002, 01:33 PM

I have adjusted the script a little bit.
It's now nearly the same as the "Send eMail to users"-Feature, so now you can test the process before sending and all variables get replaced correct.

The Script works perfect for vBulletin 2.2.x!

I have attached the script (German an English version!) to this Posting.

@NAM

Quote:

2. We really need Save function that keep all of our mass PM to users in Send Folder box. To keep for the record.

To save the sent PM in the Send Folder Box of the Admin who sent the PM, do the following (referring to my version of the script):

Search:

PHP Code:


			
    echo "<p><b>All done!</b></p>";

and replace it with:

PHP Code:


			
    echo "<p><b>All done!</b></p>";

    if (!$test) {

      $sql=$DB_site->query("INSERT INTO privatemessage (privatemessageid, folderid, userid, touserid, fromuserid, title, message, dateline, showsignature, iconid, messageread) VALUES (NULL,'-1','$fromuserid','$fromuserid','$fromuserid','".addslashes(htmlspecialchars($subject))."','".addslashes($sendmessage)."',".time().",'1','0','0')");

    }

2003-07-09:
Small update (changed code order)

2002-09-21:
Updated the archive with new versions (Bugfix + Automatic redirect Feature when sending over several pages.)

2002-07-12:
Updated the archive with new versions (Bugfix + eMail Feature)

Greetings,
Mystics

Jawelin · #34 02-11-2002, 08:20 AM

Thanks a lot. Very cool!

Actually there are - in your masspm.php - two lines with
All done! (one for first page, another for the multiple pages option)

Which of them should I replace with the above INSERT to save the PM in the outbox ?

Besides, the INSERT itself contains three identical values:
'$fromuserid','$fromuserid','$fromuserid',
Is it right (I shall not save the single target of each message...) ?
Hwr. that variable is NEVER defined anywhere :stupid: :stupid:

Thanks

Jawelin · #35 02-11-2002, 09:49 AM

Sorry Mystics, but I definetively think your insert queries

PHP Code:


			
$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(htmlspecialchars($subject))."','".addslashes($sendmessage)."',".time().",'1','0','0')");

and the other you specified two posts above, should be replaced with something like:

PHP Code:


			
// insert message in inbox of the receiver 

$DB_site->query("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title,message,dateline,showsignature,iconid,messageread,folderid,receipt) VALUES (NULL,$user[userid],$user[userid],$bbuserinfo[userid],'".addslashes(htmlspecialchars($subject))."','".addslashes($sendmessage)."',".time().",'1',0,0,0,0)");



// insert message in outbox of the sender 

$DB_site->query("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title,message,dateline,showsignature,iconid,messageread,folderid,receipt) VALUES (NULL,$bbuserinfo[userid],$user[userid],$bbuserinfo[userid],'".addslashes(htmlspecialchars($subject))."','".addslashes($sendmessage)."',".time().",'1',0,0,-1,0)");

What do you think about ?

Thnx

Mystics · #36 02-11-2002, 10:04 AM

Quote:

Originally posted by Jawelin
Actually there are - in your masspm.php - two lines with
All done! (one for first page, another for the multiple pages option)

This line does not appear two times!!!

There is one line with All done! and one line with All done! and as I wrote you should replace the second one!

Quote:

Originally posted by Jawelin
Besides, the INSERT itself contains three identical values:
'$fromuserid','$fromuserid','$fromuserid',
Is it right (I shall not save the single target of each message...) ?
Hwr. that variable is NEVER defined anywhere :stupid: :stupid:

This variable is defined!

PHP Code:


			
  makehiddencode("fromuserid","$bbuserid");

But you are right, you may replace $fromuserid with $bbuserid....I just have taken this from the original "hack".

The reason why this variable appears three times in the "Save-Sent-PM-in-My-Outbox" Feature is simple: you are the sender of the pm, you are the receiver of the pm and the PM belongs to you, so all userids have to be of course the same.

I have tested all of this before I posted it, so just believe me, it works!

Jawelin · #37 02-11-2002, 11:21 AM

Thnx for having cleaned out.
Bye

bluecat · #38 06-12-2002, 02:12 PM

Great hack. I'm wondering, is there a way to put to this in my control panel for easy access (rather then enter the url manually)? Thanks.

Mystics · #39 06-12-2002, 02:18 PM

Quote:

Originally posted by bluecat
Great hack. I'm wondering, is there a way to put to this in my control panel for easy access (rather then enter the url manually)? Thanks.

Open admin/index.php

Find:

PHP Code:


			
makenavoption("Email Users","email.php?action=start","<br>");

Add below it:

PHP Code:


			
makenavoption("Send PM to Users","masspm.php?action=start","<br>");

JoshFink · #40 07-12-2002, 05:40 PM

The only problem I see so far with this is that it does not send out a notification email if when someone receives a PM. Is there a way to fix this?

Thanks

Josh

Mystics · #41 07-12-2002, 05:55 PM

Quote:

Originally posted by JoshFink
The only problem I see so far with this is that it does not send out a notification email if when someone receives a PM. Is there a way to fix this?

I have replaced my attachment with the new version.

I have done the eMail Feature + Bugfix long time ago, sorry

Mystics

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05819 seconds Memory Usage 2,398KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (8)bbcode_php (5)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!