How to delete a large number of Profile/User AND their content?
Using Jamroom
michael:
Strumelia's correct with the "click on the Last Login" column header to see USERS who haven't logged in, but you're wanting to delete their profile too.
Feel 70% sure I've built a jrPrune module in the past for someone to cull users and profiles, but I can't find it.
Every item is timestamped so we can know if its older than a year old. Is that something you'd also like? an option to "delete any forum posts, or blog posts or other content that is older than 1 year" even if the user is still an active user on the site?
( Thinking does it need automation )
--edit--
Found it, but its an old module for Jamroom 4. adding it to suggestions.
Right, I want to delete their profile and all their content if they're not active anymore.
Looks like it's manual.
Is there an SQL query that can check the last time they logged in for a specific profile? So I can make sure I am not deleting active members before I hit the kill switch?
Btw strum, I too did this before I moved from Ning because I had 10 000+ member initially. I ended up writing an automated script to delete members from my list of inactives. I'm looking for a way to do this in Jamroom.
Since it was manual (sort of) on Ning too, I'm not in worst shape than I was