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)

[صورة] 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) [صورة] 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…

[صورة] 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]

[صورة] 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!

[صورة] 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 لترقية جماعية للمستخدمين إلى TL2

مطور

dax (Daniela) 25 أبريل 2020، 9:43ص 4

يوجد دليل حول كيفية نقل جميع المستخدمين دفعة واحدة من مستوى ثقة أدنى إلى مستوى أعلى (والعكس)

الموضوع		الردود	مرات العرض
Promoting users to TL2 when joining a group - retrospectively? Support	11	634	26 فبراير 2023
How do I promote all users to trust level 1? Support trust-levels	6	1609	19 مارس 2020
Mass promotion to TL2 via manual command? Support	3	690	20 أبريل 2020
User isn't promoted to TL2 Support	13	1234	15 ديسمبر 2020
Self Hosted Reassess trust levels Support	1	63	18 سبتمبر 2024

الأمر في Rails لترقية جماعية للمستخدمين إلى TL2

الموضوعات ذات الصلة