[cocjh1]

Has anybody considered writing this as a plug-in for 3.6??

Note, I had to slightly modify the above code to work on 3.6...

PHP Code:

            $usergroupid = $vbulletin->input->clean_gpc('p', 'usergroupid', TYPE_UINT);
    
            $leaders = $db->query_read("
                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->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);
            }