Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

delete user by date & not validated condion

Oct 30, 2003, 11:04 AM
scorpioncapital
User (150 posts)
Oct 30, 2003, 11:04 AM
Post #1 of 2
Views: 384
Shortcut
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?
Oct 31, 2003, 2:21 AM
Andy
Veteran / Moderator (17366 posts)
Andy's avatar
Oct 31, 2003, 2:21 AM
Post #2 of 2
Views: 364
Shortcut
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

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates