Find "Inactive" Users
We use a flag in our database to show whether a user account has been made "inactive" (ie disabled so they cant access the board.. used when an emplyee leaves our company).
I am trying to add a line to the user.php file to add a link similar to the FIND ALL USERS that will list all the "inactive" accounts.
This is the SQL query that does what I want..
SELECT * FROM `user` where empactive=0 LIMIT 0, 30
Is there any way I can add this to a link so that user.php will run this query and show the results?
I was hoping that it would be a simple line like the "List visitors in the last 24 hours" link.
Any help would be appreciated!
|