how to move user from all groups to one other

[ManuelW]

Hey Guys,

i'm using vB 3.8.* and the self_delete_mod and it works so far.
But i won't delete the User. I will remove them from all groups an set to another group.

I have the group id "24" and the user id "$sd_info['userid']".

the original code to delete the user

PHP Code:

        $sd_userdm =& datamanager_init('User', $vbulletin, ERRTYPE_SILENT);
        $sd_userdm->set_existing($sd_info);
        $sd_userdm->delete();
        unset($sd_userdm); 


but i can't find some helping code to replace the delete command with move to a group.

i tryed to create a own code, but i dont know if it works. maybe it's correct :-/

PHP Code:

$vbulletin->$db->query_write("UPDATE " .TABLE_PREFIX. "user SET usergroupid="24" where userid=".$sd_info['userid']); 


thanks for help
Manu

[BirdOPrey5]

In the promotion.php cron file the code that changes a usergroup is as follows:

PHP Code:

    $vbulletin->db->query_write("
        UPDATE " . TABLE_PREFIX . "user
        SET displaygroupid = IF(displaygroupid = usergroupid, $joinusergroupid, displaygroupid),
        usergroupid = $joinusergroupid,

        infractiongroupid =
        " . (!empty($sql_id["$joinusergroupid"]) ? "
        CASE
            " . implode(" \r\n", $sql_id["$joinusergroupid"]) . "
        ELSE 0
        END" : "0") . "

        ,infractiongroupids =
        " . (!empty($sql["$joinusergroupid"]) ? "
        CASE
            " . implode(" \r\n", $sql["$joinusergroupid"]) . "
        ELSE ''
        END" : "''") . "

        WHERE userid IN (0$ids)
    "); 


I'd suggest adapting that to your needs.

[ManuelW]

Ok, thanks it helps a lot.

Now it works fine with this code

PHP Code:

    $vbulletin->db->query_write("UPDATE+"+.+TABLE_PREFIX+.+"user
                                                    SET+displaygroupid+=+$the_new_group, usergroupid+= $the_new_group, membergroupids+=+''
                                                    WHERE+userid+= $sd_cool_userid");