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)

[Bild] 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) [Bild] 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…

[Bild] 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]

[Bild] 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 que…

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!

[Bild] 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 an…

Rails-Befehl, um Benutzer massenhaft auf TL2 zu befördern?

Entwickler

dax (Daniela) 25. April 2020 um 09:43 4

Es gibt eine Anleitung, wie man alle Benutzer von einem niedrigeren Vertrauenslevel auf ein höheres Level verschiebt (und umgekehrt): Modify trust level for all users

Thema		Antworten	Aufrufe
Promoting users to TL2 when joining a group - retrospectively? Support	12	612	28. März 2023
How do I promote all users to trust level 1? Support trust-levels	8	1585	19. März 2024
Mass promotion to TL2 via manual command? Support	5	679	27. Mai 2024
User isn't promoted to TL2 Support	13	1191	15. Dezember 2020
Self Hosted Reassess trust levels Support	1	60	18. September 2024

Rails-Befehl, um Benutzer massenhaft auf TL2 zu befördern?

Verwandte Themen