aspose file tools*
The moose likes JForum and the fly likes finding banned users via MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "finding banned users via MySQL" Watch "finding banned users via MySQL" New topic
Author

finding banned users via MySQL

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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]
 
Don't get me started about those stupid light bulbs.
 
subject: finding banned users via MySQL