Full Board URL: www.club-k.co.nz
XMB Version: 1.9.11

What is the best way for me to delete logins if

they are over 1yr old
have no posts
and havent been logged in, in the last year.

I wouldnt mind a list before confirming deletion but I just want to tidy up the user datadase.

Q

http://forums.xmbforum2.com/viewthread.php?tid=776813


SELECT * from xmb_members where lastvisit < 'DATETIME' AND regdate < 'DATETIME' AND postnum = '0'

DELETE from xmb_members where lastvisit < 'DATETIME' AND regdate < 'DATETIME' AND postnum = '0'

That looks like it will work when i run the select version ...man its a large list .... eek.

I use the moderator/platinum member hack for paying members so dont want to delete any moderator stats .... also thinking about it regdate is irrelivant so

If I want to check against
lastvisit < 'DATETIME'
postnum = '0'
status = 'Member'

could I just modify the two statements to below to acheive the same thing

SELECT * from xmb_members where lastvisit < 'DATETIME' AND postnum = '0' AND status = ' Member'

DELETE from xmb_members where lastvisit < 'DATETIME' AND postnum = '0' AND status = ' Member'


Thanks

Q

just noticed lastvisit = '0' if they have never visited since registration. I have maybe 15 accouts in that status so will need to add the regdate back in there to correct that

consider me resolved - please close

Q