[Chris] Mass User Upgrade

[Christos Teriakis]

Mass Usere Upgrade
by ChrisTERiS (http://www.christeris.com)


This is a minimod, asked from a Member in the community, and I thought that maybe it will be helpful to other members, that's why I'm posting it here.

1.- What it does
Mass Upgarde a selection of users to a specific usergroup
You have the ability to choose between updating the main usergroup, or adding the new usergroup in the user's additional usergroups
Even if wasn't on the original request, I added a feature to rollback an upgrade in case that you did something wrong.2.- Installation
Download and unzip the file UpgradeUsers.zip
Upload all files from upload folder to your forum installation.
Import the product-upgradeusers.xml
Click on Upgrade Users menu option and start working.Enjoy it
Chris

PS- If you find it useful I'll appreciate if you Like my Facebook page (https://www.facebook.com/pages/ChrisTERiS/363428363737904). Thank you.

[faisaly.com]

think you forgot something Chris?

[Christos Teriakis]

ehhh??........ Unless that I lost my mind, I can swear that I've uploaded 1 file and 3 screenshots. My apologies...

[Christos Teriakis]

I don't think that it was something wrong from my side. When I tried to re-upload the file, the upload folder was the one that I had the files in. So, for sure I've uploaded them. In any case, now everything is ok.

Chris

[faisaly.com]

yup showing now, thank you

[EasyEazy]

Hi Chris. Upgraded from the version you gave me earlier and got this error when adding members to a test usergroup.

Users were added to the group however I got the following database error. Also it was not added to the history page so I couldn't roll it back.



Invalid SQL:
INSERT INTO vbupgradeusers
SET usernames = '3,26,1,24',
usergroupid = '34',
usergroup = 'testing',
upgradeat = '1354379164',
primarygroup = '0';

MySQL Error : Unknown column 'primarygroup' in 'field list'
Error Number : 1054
Request Date : Saturday, December 1st 2012 @ 04:26:03 PM
Error Date : Saturday, December 1st 2012 @ 04:26:04 PM
Script : *****************************upgradeusers_admin.ph p?do=upgrade
Referrer : ****************************upgradeusers_admin.php ?do=upgrade&action=insert

[Christos Teriakis]

Ochh sorry. I forgo that there was someone who has installed this mod before releasing. There are 2 ways to solve it.
1.- To uninstall the previous one and make a new installation
2.- If you're familiar on using phpMyAdmin connect to database and add to the table:
...prefix..upgradeuser a field:
Name: primarygroup
Type: TINYINT
Size: 1
Default value: 0

Chris

[EasyEazy]

Ochh sorry. I forgo that there was someone who has installed this mod before releasing. There are 2 ways to solve it.
1.- To uninstall the previous one and make a new installation
2.- If you're familiar on using phpMyAdmin connect to database and add to the table:
...prefix..upgradeuser a field:
Name: primarygroup
Type: TINYINT
Size: 1
Default value: 0

Chris

Uninstalled and reinstalled and its working fine. Thanks for this modification.

[EasyEazy]

Request of possible Chris

I know you have done a roll back feature for this but would it be possible to have an option to empty a usergroup as well. I don't want to delete the group just remove all those in that group.

Thanks in advance

[XGC Viper XI]

I install this on our test site. I encounter two issues. Once I added the user to a new secondary group, the usergroup rank image did not display on their profile. Also, when selecting users, this test site has about 50,000 members. It was extremely slow and lagged a lot. Therefore, this would not work on our actual site that has about 70,000 members. I have few suggestions.

1) Add another option to select users by usergroup (both primary and secondary), then display only the user from that usergroup.

2) When promoting or moving members into another usergroup, provide an option to remove them from the usergroup that was selected in suggestion 1. That way when we move them to one usergroup, we can take them out of the originating usergroup.

3) Regarding the undos, once it has been done and is never to be undone, can you add an option to delete from history? Other wise the list would get extremely long for us very quick.

If this is possible, this would make this mode extremely useful.

THanks
Viper