Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

finding banned users via MySQL

 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi!

I was wondering.. what MySQL query can I run to show me the names of all currently banned/deleted users?
[originally posted on jforum.net by lote49]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
For deleted users there is a column named "deleted" in jforum_users; just check it for the records flagged with "1" . For banned users, just do a join with jforum_banlist.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic