Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

delete user by date & not validated condion

Quote Reply
delete user by date & not validated condion
Is there a way to delete users in LSQL admin that

a) are not validated

b) where created on or before a certain date

Likewise, is there a way to send out a bulk email to users who are not validated AND were created on or before a certain date

Seems searchs by addition date for users is not supported?
Quote Reply
Re: [scorpioncapital] delete user by date & not validated condion In reply to
Not sure about the second one, but the first can be done quite easily;

DELETE FROM lsql_Users WHERE Status = 'Not Validated'

CHeers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!