I put this together to help my board usergroup leaders keep track of incoming join requests, and thought it might be useful to others.

I just added some code to profile.php immediately above the line "// insert the request":


$leaders = $DB_site->query("
SELECT ugl.userid, username, email
FROM " . TABLE_PREFIX . "usergroupleader AS ugl
INNER JOIN " . TABLE_PREFIX . "user AS user USING(userid)
WHERE ugl.usergroupid = $usergroupid
");
while ($leader = $DB_site->fetch_array($leaders))
{
vbmail($leader["email"], "new forums usergroup join request",
"A Forums user has asked to join a usergroup that you lead.\nPlease handle it at http://www.domain.com/forums/profile.php?do=editusergroups",
true);
}


This is rather quick and dirty, but it does seem to work well for our purposes. Perhaps others can improve on it.