[Sarcoth]

Hey Banana,

I think I have a good one for you.

I am setting up a custom question to ask my moderators to select a name belonging to usergroup 2.

PHP Code:

$answer .= '<select name="'.$formbit[id].'">';
$members = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "user
WHERE usergroupid = 2
ORDER BY username ASC");
    while($row = $db->fetch_array($members)) {
$answer .= '<option value="'.$row[username].'"';
if ($row[username] == $thisanswer) {
$answer .= 'selected="selected"';
}
$answer .= '>'.$row[username].'</option>';
}
$answer .= '</select>'; 


That works great; I've given this question the reference of shuser. This will allow my moderators to select the name they want. When they click submit, I want the name selected to have the primary usergroup changed to usergroup 18. Here is what I tried as my first test (Form Hood: Before Submit):

PHP Code:

if ($complete) {
    $userinfo=fetch_userinfo($qo[shuserid]);
    $user=$userinfo;
    
    //$userinfo = $vbulletin->userinfo;
    $user['usergroupid'] = 18;
    
    if (empty($user['usergroupid'])) {
        $user['usergroupid'] = 2;
    }
    
    $getusergroupid = iif($userinfo['displaygroupid'] != $userinfo['usergroupid'], $userinfo['displaygroupid'], $user['usergroupid']);
    
    $user_usergroup =& $vbulletin->usergroupcache["$user[usergroupid]"];
    $display_usergroup =& $vbulletin->usergroupcache["$getusergroupid"];

    $userdata =& datamanager_init('User', $vbulletin, ERRTYPE_STANDARD);
    $userdata->set_existing($userinfo);
    $userdata->set('usergroupid', $user['usergroupid']);
    $userdata->set_usertitle(
        $user['customtitle'] ? $user['usertitle'] : '',
        false,
        $display_usergroup,
        ($user_usergroup['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canusecustomtitle']) ? true : false,
        ($user_usergroup['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['cancontrolpanel']) ? true : false
    );

    require_once(DIR . '/includes/functions_ranks.php');
    
    if ($user['userid'] == $vbulletin->userinfo['userid']) {
        $vbulletin->userinfo['usergroupid'] = $user['usergroupid'];
        $vbulletin->userinfo['displaygroupid'] = $user['usergroupid'];
    }

    $userdata->save();
} 


Obviously, now I realize that the usergroup update code was meant to use a userid, not the username. So, what do you suggest? I was thinking that I could find a way to use the username for searching for the userid, I need to remember how I did that in the past, and then put that into the code. Do you know how to do that off hand? I'll keep searching.

Thanks.