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

[Cyricx]

It's not working for me at all, and I've followed the instructions to a T... even followed the "non-instructions" by adding the phrase in

The pm title comes across as "Join Request:"

and the message comes up with what I set in as the variable with nothing else, so it's not pulling the $groupname[title] and I'm not sure what the "convert to url" code is supposed to do.

Here is my insertjoinrequest function and you can see from it I've followed your instructions to a T.

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

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

	globalize($_POST, array('usergroupid' => INT));

	$url = "profile.php?do=editusergroups";

	if ($request = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "usergrouprequest 

WHERE userid=$bbuserinfo[userid] AND usergroupid=$usergroupid"))
	{
		// request already exists, just say okay...
		eval(print_standard_redirect('usergroup_requested'));
	}
	else

	{
		// insert the request
		$DB_site->query("
			INSERT INTO " . TABLE_PREFIX . "usergrouprequest
				(userid,usergroupid,reason,dateline)
			VALUES
				($bbuserinfo[userid], $usergroupid, '" . 

addslashes(htmlspecialchars_uni($_POST['reason'])) . "', " . TIMENOW . ")
		");

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

			}
               }

		eval(print_standard_redirect('usergroup_requested'));
	}

}

Your absolutely right, I can't believe the devs didn't add this in by default. Would really love to have this hack working though, any help is appreciated

[amykhar]

Diid you add the phrase that is listed in the updated instructions? The convert url code simply converts any links you may use in the phrase to make them clickable.

Because you mention the "nonexistant phrase" I am concerned that you didn't see the portion of the instructions where that is added (around line 4 of the instruction file.)

[Cyricx]

Ah bugger, saw the post by Sandman saying that the upgrade instructions needed to include that, didn't see anything about ya updaing them.

So this is a case of "Open mouth insert foot"

I had an older version that I had snagged when this was first brought up.

Thanks Amy! Awesome mod!

[amykhar]

Ported: https://vborg.vbsupport.ru/showthread.php?t=83086

[|Jordan|]

This doesnt work in 3.0.12

I've checked and rechecked the file checks and i didnt miss anything.

[parash]

would it be possible to clear more... i tried it 3times but same error came...i dunno what is worng in it..