Send Private Message to Public Group Leader on Join Requests

This quick and dirty little hack sends a PM to the leaders of a public group when a join request has been made.

I am surprised this isn't built into vbulletin.

Amy

[kall]

Originally Posted by the Sandman

Someone finally put in a join request and the PM was properly generated so I can verify that this works (on a security patched vB 3.0.3 Board).

On 3.0.6 it 'works' .. I get a PM called something like "Join request:*username*" but no more details.

Amy: is it possible to get the group name in the body of the message somewhere?

[amykhar]

I'll look at making the message more robust.

Amy

[amykhar]

OK. I updated the instructions to include the group name and a link to the validation page. If you have already installed, do the following to upgrade:

Find:

if ($_POST['do'] == 'insertjoinrequest')
{

Add After:

  require_once('./includes/functions_bbcodeparse.php');
  require_once('./includes/functions_newpost.php');

Find the code block originally added in the hack.

Replace with:

		
	       $leaders = $DB_site->query("
				SELECT ugl.userid, username
				FROM " . TABLE_PREFIX . "usergroupleader AS ugl
				INNER JOIN " . TABLE_PREFIX . "user AS user USING(userid)
				WHERE ugl.usergroupid = $usergroupid
			");
			$groupname = $DB_site->query_first("
			SELECT title
			FROM " . TABLE_PREFIX . "usergroup
			WHERE usergroupid = $usergroupid
			ORDER BY usergroupid DESC
			LIMIT 1
		    ");
			if ($DB_site->num_rows($leaders))
			{
				
				$_groupleaders = array();
                        $tostring = array(); 

				while ($leader = $DB_site->fetch_array($leaders))
				{
                           // Send a PM to the leaders letting them know a join request has been made.
						   $message = construct_phrase($vbphrase['group_memberships_message'], $groupname[title]);
						   $message = convert_url_to_bbcode($message);
                           $tostring["$leader[userid]"] = $leader['username']; 

                           $DB_site->query("INSERT INTO " . TABLE_PREFIX . "pmtext\n\t(fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature)\nVALUES\n\t($bbuserinfo[userid], '" . addslashes($bbuserinfo['username']) . "', 'Join Request:', '".addslashes(htmlspecialchars($message))."', '" . addslashes(serialize($tostring)) . "', 0, " . TIMENOW . ", 1)");
                           $pmtextid = $DB_site->insert_id(); 
                           $DB_site->query("INSERT INTO " . TABLE_PREFIX . "pm (pmtextid, userid, messageread) VALUES ($pmtextid, $leader[userid], 0)"); 
                           $DB_site->shutdown_query("UPDATE " . TABLE_PREFIX . "user SET pmtotal=pmtotal+1, pmunread=pmunread+1 WHERE userid = $leader[userid]"); 

			}
               }

[trackpads]

Originally Posted by amykhar

OK. I updated the instructions to include the group name and a link to the validation page. If you have already installed, do the following to upgrade:

Find:

if ($_POST['do'] == 'insertjoinrequest')
{

Add After:

  require_once('./includes/functions_bbcodeparse.php');
  require_once('./includes/functions_newpost.php');

Find the code block originally added in the hack.

Replace with:

		
	       $leaders = $DB_site->query("
				SELECT ugl.userid, username
				FROM " . TABLE_PREFIX . "usergroupleader AS ugl
				INNER JOIN " . TABLE_PREFIX . "user AS user USING(userid)
				WHERE ugl.usergroupid = $usergroupid
			");
			$groupname = $DB_site->query_first("
			SELECT title
			FROM " . TABLE_PREFIX . "usergroup
			WHERE usergroupid = $usergroupid
			ORDER BY usergroupid DESC
			LIMIT 1
		    ");
			if ($DB_site->num_rows($leaders))
			{
				
				$_groupleaders = array();
                        $tostring = array(); 

				while ($leader = $DB_site->fetch_array($leaders))
				{
                           // Send a PM to the leaders letting them know a join request has been made.
						   $message = construct_phrase($vbphrase['group_memberships_message'], $groupname[title]);
						   $message = convert_url_to_bbcode($message);
                           $tostring["$leader[userid]"] = $leader['username']; 

                           $DB_site->query("INSERT INTO " . TABLE_PREFIX . "pmtext\n\t(fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature)\nVALUES\n\t($bbuserinfo[userid], '" . addslashes($bbuserinfo['username']) . "', 'Join Request:', '".addslashes(htmlspecialchars($message))."', '" . addslashes(serialize($tostring)) . "', 0, " . TIMENOW . ", 1)");
                           $pmtextid = $DB_site->insert_id(); 
                           $DB_site->query("INSERT INTO " . TABLE_PREFIX . "pm (pmtextid, userid, messageread) VALUES ($pmtextid, $leader[userid], 0)"); 
                           $DB_site->shutdown_query("UPDATE " . TABLE_PREFIX . "user SET pmtotal=pmtotal+1, pmunread=pmunread+1 WHERE userid = $leader[userid]"); 

			}
               }

Excellent work Amy! I dont know why this isnt in the stock vb either!

[ricker]

great hack! thanks.
*installed*

[settimio]

Well...
I've applied the send html hack shown in another post and I'd like to send a periodical newsletter to people who joined a public group called Newsletter.
The standard Vbulletin doesn't allow to send email to public groups...
Is there a fast and simpler way to hack the forum so I can send bulk email to members of a public group?

[amykhar]

Setti, your question is off topic for this thread. You should probably start a new thread in general mod discussion if you are going to do it yourself or in one of the request forums if you need somebody to do it for you.

[the Sandman]

The upgrade instructions for early adopters need to include the new phrase addition.

[Cyricx]

Hmm this doesn't seem to be working with 3.0.7

Anyone have this workin on that version? If so I'll try a clean profile.php

[amykhar]

It's working on my 3.0.7 with no problems and no changes required.