Copying an entire usergroup to another usergroup

Smog · Post by **Smog** » Thu Dec 25, 2008 9:48 pm

phpBB v3

I need to copy all members of an usergroup (Pre-defined groups, Registered users) to another usergroup.

Any idea how to perform such mass action. member by member is not a good idea, xxxx members......

TIA,

Smog

ameeck · Post by **ameeck** » Thu Dec 25, 2008 9:51 pm

Why do you need to do this? Are you trying to achieve something else with this?

Smog · Post by **Smog** » Thu Dec 25, 2008 10:00 pm

I have made a Newsletter Group, all existing registered members have to be be added to that group. Will be a so called "open group type". In that way, afterwards all members are able to make a choice for a stay in that new group, and unscribe/subscribe themself (join/resign selected procedure).

ameeck · Post by **ameeck** » Thu Dec 25, 2008 10:21 pm

You can choose wheter you want to recieve mass e-mails in your UCP.

UCP :: Board preferences :: Administrators can e-mail me information

Smog · Post by **Smog** » Thu Dec 25, 2008 10:30 pm

I know. However not where I am looking for. For my board it is absolute necessary to have all newsletter subscribers in a separate user group. So remain the question: how-to perform such mass copy action?

ameeck · Post by **ameeck** » Thu Dec 25, 2008 10:44 pm

Here is a small script that should handle it, edit $group_id (registered users group ID) and $new_group_id (the newsletter group id), save it as add_group.php and upload to your website. Then run it through your browser, delete it after use.

Code: Select all

<?php
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();

$group_id = 2;
$new_group_id = 7;
$user_array = array();

$sql = 'SELECT u.user_id FROM ' . USERS_TABLE . ' u, ' . USER_GROUP_TABLE . ' ug WHERE u.user_id = ug.user_id AND ug.group_id = ' . $group_id;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)){
    $user_array[] = $row['user_id'];
}
$db->sql_freeresult();
$result = group_user_add($new_group_id, $user_array);

if ($result === false)
{
    echo 'OK!';
}
else
{
    trigger_error($result, E_USER_ERROR);
}

?>

Smog · Post by **Smog** » Thu Dec 25, 2008 11:23 pm

Well ameeck, i am deeply impressed by your fast support!

Your script performed exact the action i needed, no errors and a 1 second job. Txs a lot!

Happy Holidays,

Smog

stainless_steelrat · Post by **stainless_steelrat** » Tue Jan 06, 2009 7:42 pm

I'm trying to "borrow" this to do an update for some users that I have... I've modified the where clause to include another field value on the users table, but when I run the add_user.php page, it just gives me a relatively generic error about "The requested user does not exist."

Code: Select all

ug WHERE u.user_contrib = 1 AND u.user_id = ug.user_id AND ug.group_id =

Never mind.... I found the source of the issue:

Code: Select all

ug WHERE u.user_contrib = "1" AND u.user_id = ug.user_id AND ug.group_id =

Needed quotes around the "1" to get it to work.... if you put '1' it closed the string improperly... and it wasn't reading the value without quotes around it.
Thanks....

advertisements