XF 1.5 How to find all users with "Display user as staff" selected?


Active member
Just as the title says.
How would I go about finding all users on my board who had "Display user as staff" selected?

I have quite a mess on my forum with some old members having this due to a bad staff setup from the past, how would I go about finding all the users who have this option selected in their profile so I can remove it.


Well-known member
Double check your findings though, go to the phpmyadmin or from cli into the mysql database, and sort the table that has the fields that disclose who's staff. I imported a few sites from xf and ipb, and people that didn't show in xenforo as such were clearly listed in the db.