permaculture playing cards*
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: finding banned users via MySQL
 
Similar Threads
Ban IP?
WA #1.....word association
Youtube banned at workplace..
Forum-Reader-Package
please reply somebody need help