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



    }

  }

    

?>

#12 02-15-2001, 10:44 PM

I have updated this as well if anyone is interested, here is a screen shot and I added it to the control panel. I eliminated the other queries such as lastpost etc.. since I was only lookin to Mass PM a group or all groups. Here it is:

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



  echo "<tr><td colspan=2><b>Private message to groups where:</b></td></tr>\n";

  if ($pwdincp!=0) {

    makeinputcode("and password contains","apassword");

  }

  makechoosercode("Usergroup is:","usergroupid","usergroup",-1,"Any");

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

  makeinputcode("Subject:","title");

  maketextareacode("Message:","message","",10,40);



  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 ($usertitle!="") {

      $condition.=" AND INSTR(usertitle,'".addslashes($usertitle)."')>0";

    }



  }



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



    }

  }

    

?>

Here is the control panel addition:

find this in admin/index.php below "User Groups and Permissions:

Code:

<tr><td><hr></td></tr>

add this above it:

Code:

<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr bgcolor="#3F3849"><td><font color="#BCB6CD">
<b>Mass Private Message</b>
</font></td></tr></table>
<a href="masspm.php"> Create Message </a> |
</td></tr>

Here is the pic:

#13 02-16-2001, 07:49 AM

needs to be ammeneded to send to just moderators though as moderators arn't a usergroup anymore.

#14 02-16-2001, 08:08 AM

Quote:

Originally posted by chrispadfield
moderators arn't a usergroup anymore.

(COPPA) Users Awaiting Moderation [edit][list all users]
Administrator [edit][list all users]
Moderators [edit] [remove][list all users]
Registered [edit][list all users]
Super Moderator [edit][list all users]
Unregistered / Not Logged In [edit][list all users]
Users Awaiting Email Confirmation [edit][list all users]

That's all folks

They are on my forum...?

#15 02-16-2001, 01:15 PM

Actually.. Unless you move them into a group on your own they are all set to the Registered User's Group when you upgrade. Moderator permissions are handled through a separate moderators table now.

#16 03-01-2001, 02:59 PM

I sent a test message to my moderators' user group last night, which is 5 people. To test it out, I included the $username, $password, and $email variables as it says you can. When it was sent out, instead of doing the person's the message was going to, all 5 messages had the info of the first person it was sent to.

i.e. I sent it to users 5, 49, 65, 100, 105 and in all of them it put the info for user 5.

Any ideas?

Thanks for a great hack otherwise.

#17 03-02-2001, 03:46 PM

subst:

Code:

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

with:

Code:

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

(add slashes before $ otherwise it will parse as a var) :-)

#18 03-02-2001, 11:00 PM

I don't understand how to install this hack?

Upload masspm.php
Then I get lost?

Help?

#19 03-03-2001, 12:01 AM

that is it, the run masspm.php.

I used wreckman's and it went pearshaped and did not send the message for some reason so had to use my old one to do it. Not sure what the bug is but something not quite right i don't think?

TechTalk · #20 04-14-2001, 04:00 PM

VERSION 2.1 VERSION 2.1!!! PLEASE ADD

~Chris

kreker · #21 05-06-2001, 10:21 AM

all right! works fine

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07800 seconds Memory Usage 2,360KB Queries Executed 25 (?)
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 (4)bbcode_code (2)bbcode_php (1)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 (3)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 (3)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_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!