vb.org Archive - how to move user from all groups to one other

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - how to move user from all groups to one other (https://vborg.vbsupport.ru/showthread.php?t=256488)

ManuelW

01-04-2011 04:03 PM

how to move user from all groups to one other

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

01-04-2011 07:25 PM

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

01-05-2011 04:01 PM

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");

All times are GMT. The time now is 11:38 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01060 seconds Memory Usage 1,727KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: