Hello, I am opening a new topic for this since I think my questions in a Previous topic about this have been looked over since I originally marked it as resolved, but it isn’t. case: I migrated to discourse, and members of the old forum all have TL1, which they find not fair, so I wanted to bump t…

Maybe: users = User.where('admin = false') users.update_all(trust_level: 2)

[image] Canapin: users = User.where(‘admin = false’) users.update_all(trust_level: 2) This query will change all moderators to trust level 2 as well. I’m not sure @Queth really wants to do that.

There is an Howto to bulk move all the users from a lower TL to an higher level (and viceversa) [image] Modify trust level for all users Self-Hosting Here’s an example of a bulk operation to set the trust level to 2 for all users currently at trust level 0 or 1…

Thank you so much for your fast replies! @Canapin , @neounix I don’t mind changing mods to tl2 temporarily, I can set their TL manually afterwards I think. I don’t think it would impact mod abilities? Would it? @dax Thank you! We are talking about 20k users, 10k are tl1 after migration, and the o…

[image] Queth: Would there be a way to include some kind of registration date criteria? Eg all TL1 who registered before March 17 2020? Yes @Queth Would you like me to post a copy of the structure of the users table so you can see all the different entries there? Update: Here is it @Queth …

Thank you @neounix ! Would it be possible to help me with the correct query? Because I don’t know how to do that… probably include somewhere Where user created at < [march 17 2020 but then formatted correctly]

[image] Queth: Where user created at < [march 17 2020 but then formatted correctly] I would love to; but some things are easier (and better) done by you doing a bit of your own homework. You have all the pieces of the puzzle, so my advise is to spend a bit of time and learn to write an SQL qu…

Thanks :slight_smile: Well I do have basic basic knowledge but writing queries from scratch is still something I rather copy paste from a trusted source instead of trying to devise my own. But thank you indeed for the building blocks!

[image] Queth: Thanks :slight_smile: Well I do have basic basic knowledge but writing queries from scratch is still something I rather copy paste from a trusted source instead of trying to devise my own. But thank you indeed for the building blocks! It’s always a good idea to SELECT first a…

Commande Rails pour promouvoir en masse les utilisateurs en TL2 ?

Dev

dax (Daniela) Avril 25, 2020, 9:43 4

Il existe un tutoriel pour déplacer en masse tous les utilisateurs d’un niveau de confiance inférieur à un niveau supérieur (et vice versa)

Sujet		Réponses	Vues
Promoting users to TL2 when joining a group - retrospectively? Support	11	719	Février 26, 2023
How do I promote all users to trust level 1? Support trust-levels	6	1677	Mars 19, 2020
Mass promotion to TL2 via manual command? Support	3	726	Avril 20, 2020
User isn't promoted to TL2 Support	13	1307	Décembre 15, 2020
Self Hosted Reassess trust levels Support	1	83	Septembre 18, 2024

Commande Rails pour promouvoir en masse les utilisateurs en TL2 ?

Sujets connexes