| Author |
 Topic  |
|
|
Rigger82
Junior Member
USA
311 Posts |
 Posted - 18 April 2003 : 10:09:11
|
I would like to know if anyone has cobbled together the SQL to delete members who have not posted since x date (or in x days). Its kind of the same as the inactive user mod but I want to get rid of a large number... 770 approx that are over a year old without a post.
Anyone? |
Mark Christianson
Gulf War Veteran (82nd Airborne Division)
Owner/Operator of www.paratrooper.net
Rigger@paratrooper.net
"If freedom was shareware, soldiers are the ones who pay for it." |
Edited by - ruirib on 18 April 2003 15:09:40 |
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 18 April 2003 : 11:57:15
|
I think the closest anyone has come is in this thread:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=34565&whichpage=4&SearchTerms=inactive,users
They are talking about adding this feature to that MOD, but I don't think poor burthold has had time to do it for all the troubleshooting those guys are putting him through. |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized.  |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 April 2003 : 15:09:19
|
| It cannot be just a matter of SQL. You need to deal with the existing posts/replies by those users, so it really needs to be a mod. I'm moving this to the mod W/O Code forum. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Steve D.
Average Member
USA
640 Posts |
|
|
Rigger82
Junior Member
USA
311 Posts |
Posted - 18 April 2003 : 15:23:21
|
| Steve... yes, I figure you can use sql to write a stored proc that you can run and feed it parameters ... but what I DIDNT want to do is kill them from the MEMBERS table and worry about orphan records and proper handling of deleted users. I CAN of course reverse engineer the delete SINGLE user call and loop through it... just wanted to know if Im all alone in the universe with wanting to do a mass removal of old unused members. |
Mark Christianson
Gulf War Veteran (82nd Airborne Division)
Owner/Operator of www.paratrooper.net
Rigger@paratrooper.net
"If freedom was shareware, soldiers are the ones who pay for it." |
|
|
|
Valda
Starting Member
14 Posts |
Posted - 12 June 2003 : 20:43:21
|
quote:
Originally posted by Rigger82
Steve... yes, I figure you can use sql to write a stored proc that you can run and feed it parameters ... but what I DIDNT want to do is kill them from the MEMBERS table and worry about orphan records and proper handling of deleted users. I CAN of course reverse engineer the delete SINGLE user call and loop through it... just wanted to know if Im all alone in the universe with wanting to do a mass removal of old unused members.
So after this extremely verbose post, have you done it? have you created the ultimate mod that will delete all these users who are inactive or zero posts?
You are not alone, we are here with you... The Inactive users mod delete users 1 by 1 asking for authentication the whole time. It's one of those mods that are almost there, but not quite there... I have about 89 pages with 10 users per page... so that's what? 890 users left to go? I started out with 1032...
it's a killer...
|
|
|
| |
Topic |
|
Topic Locked
