| Author |
 Topic Search  Topic Options
|
billd3 
Senior Member
Joined: 19 February 2003
Location: United States
Status: Offline
Points: 530
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: need list of suspended members
Posted: 13 February 2012 at 7:35pm |
|
Is there a way to get a list of the members who have been "suspended" ??
there are some who we'd like to see if they desire to return to good standing after some changes we've made in rules and moderators, etc.
I know this would include spammers, but I could filter for that probably since we make notes in their profile when we suspend them.
Is there some SQL query or commend, or something in the control panel we can use??
|
|
BillD
http://theamcpages.com
http://theamcforum.com
|
 |
Scotty32
Moderator Group
Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 February 2012 at 12:47pm |
There isn't anything in the forum I dont think. But if you are using MSSQL you should be able to use the query:
SELECT * FROM tblAuthor WHERE Suspended = 1 |
How ever, I don't know what the field name is, so you will have to change the part in red to the real field name.
|
|
|
|
billd3
Senior Member
Joined: 19 February 2003
Location: United States
Status: Offline
Points: 530
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 February 2012 at 7:15pm |
|
It is MSSQL, so I can run a query from the control panel I believe as it's hosted here with WW.
I thought I saw an area to run queries against the databases.
Thanks - that's a start anyway!
|
|
BillD
http://theamcpages.com
http://theamcforum.com
|
|
Scotty32
Moderator Group
Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 February 2012 at 12:07pm |
|
If your hosted with Web Wiz then in your hosting control panel go to the list of MSSQL databases, and click on the "Database Tools" link.
This will take you to myLittleAdmin, Once there click on the "Tools" tab then "New Query".
As I say, you will most likely need to change the red part as I cant remember the field name.
|
|
|
|
billd3
Senior Member
Joined: 19 February 2003
Location: United States
Status: Offline
Points: 530
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 February 2012 at 6:04pm |
Thanks much. The field is "Banned" So I ran this
SELECT * FROM tblAuthor WHERE Banned = 1
|
and got my results.
|
|
BillD
http://theamcpages.com
http://theamcforum.com
|
|
aladin11
Groupie
Joined: 10 October 2009
Status: Offline
Points: 70
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 February 2012 at 3:20am |
|
In my forum, I create a "Banned" group. Everytime I ban an user, I'm also move this user to "Banned" group. Then just go to member list, choose sort by group.
|
|
Scotty32
Moderator Group
Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 February 2012 at 1:07pm |
I my self dont use the "suspended" feature, I've also created a "banned" group which has no read or write permissions on any forum. I also added some code to send any user in that group to the "insufficient_permissions.asp" page. (Note: you also need to add code to the insuff. perms. page to stop a redirect loop) aladin, you can actually add the Group ID to the memberlist.asp url to select only those users. eg: https://forums.webwiz.net/members.asp?gid=3
|
|
|
|
billd3
Senior Member
Joined: 19 February 2003
Location: United States
Status: Offline
Points: 530
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 February 2012 at 1:40am |
Scotty I'm curious as to why that method instead of the suspended feature? If they wish to read, all they need to do is come back as guest. They could also still receive and send PM, right?
|
|
BillD
http://theamcpages.com
http://theamcforum.com
|
|
