Register / Login

Help coderanch get a

new server

by contributing to the fundraiser

Post Reply Bookmark Topic Watch Topic
New Topic

programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums

this forum made possible by our volunteer staff, including ...

Marshals:

Campbell Ritchie
Ron McLeod
Paul Clapham
Devaka Cooray
Liutauras Vilda

Sheriffs:

Jeanne Boyarsky
paul wheaton
Henry Wong

Saloon Keepers:

Stephan van Hulst
Tim Holloway
Tim Moores
Carey Brown
Mikalai Zaikin

Bartenders:

Lou Hamers
Piet Souris
Frits Walraven

Forum:

JForum

finding banned users via MySQL

Migrated From Jforum.net

Ranch Hand

Posts: 17424

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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]

jQuery in Action, 3rd edition

reply

Bookmark Topic

Watch Topic

New Topic

Boost this thread!

Similar Threads