[RedTurtle]

Ok so looking at the way that the mod that moves users to the awaiting moderation usergroup works, it hooks at register_addmember_complete. It calls an external file via this code:

if ($vbulletin->options['madp_prevention'] >= 0 AND ($vbulletin->options['madp_prevention'] < 4 OR $vbulletin->options['madp_silent_mode']))
{
	require_once(DIR . '/madp/prevention.php');
}
else
{
	require_once(DIR . '/madp/set.php');
}

Then in prevention.php, the part that seems to be doing the usergroup changing is this:

PHP Code:

if (!$vbulletin->options['madp_silent_mode'])
        {
            // we caught multiple(s)
            $user = $vbulletin->userinfo;

            $prevuserdm =& datamanager_init('User', $vbulletin, ERRTYPE_SILENT);
            $prevuserdm->set_existing($user);
            
            if ($prevent_set)
            {
                $prevuserdm->set('usergroupid', $prevent_group);
                $prevuserdm->set('displaygroupid', 0);

                if ($vbulletin->usergroupcache["{$prevent_group}"]['usertitle'] != '')
                {
                    $prevuserdm->set('usertitle', $vbulletin->usergroupcache["{$prevent_group}"]['usertitle']);
                    $prevuserdm->set('customtitle', 0);
                }

                $peventmsg = $vbphrase['madp_message_prevented'];
            }
            else
            {
                $peventmsg = $vbphrase['madp_message_error'];
                $verbose_msgs += ERROR_USERGROUP_CACHE;
            }

            $prevuserdm->save();
            unset($prevuserdm);
        } 


If I try my code at register_addmember_complete, it doesn't seem to work.

My code:

if(!$vbulletin->options['verifyemail'] AND $user['usertitle'] == 'Deactivated')
{
$newusergroupid = 4;
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "useractivation 
                                                    SET usergroupid = '".$newusergroupid."' 
                                                    WHERE activationid = '".$activateid."' LIMIT 1 ");
}

Could it have anything to do with my trying to do a SQL write whereas the other plugin doesn't seem to be doing that? Sorry if that is a stupid question.