Something new to ignore!:P Who is using what theme?

[ZiNgA BuRgA]

Unless you need some fancy interface, an SQL query could do it.

SQL Code

select s.name,u.username,u.uid from mybb_users u left join mybb_themes s on ((u.style!=0 and s.tid=u.style) or (u.style=0 and s.def=1))

---

Or a listing of all the themes with users using each theme:

SQL Code

select s.name, group_concat(u.username) as users, count(u.uid) as numusers from mybb_themes s left join mybb_users u on ((u.style!=0 and s.tid=u.style) or (u.style=0 and s.def=1)) group by s.tid

---