Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

Re: [Alex] Two Related Questions

Quote Reply
Re: [Alex] Two Related Questions In reply to
Hi Alex,

I just did a test and found no inconsistency. Signed up for an account and then updated the users table (users_status) to Validated from default of 'Not Validated' thru sql.

What I would want is that the status is updated to Validated by manupulating the database

UPDATE `webmail_users` set users_status='Validated' WHERE users_status='Not Validated' and email like '%somedomain.com' and webmail_dgraph.dgraph_tempid in (SELECT * from webmail_tempid)

or something similar. I would need a script which can be run hourly as cron. This would keep the admin busy only for deleting all signups with invalid tempid value.

Do u forsee any problems and can u offer any help on this?

Thnx

Anup
Subject Author Views Date
Thread Two Related Questions anup123 3507 Feb 2, 2003, 4:20 AM
Thread Re: [anup123] Two Related Questions
Alex 3409 Feb 3, 2003, 5:04 PM
Post Re: [Alex] Two Related Questions
anup123 3398 Feb 5, 2003, 5:50 AM
Post Re: [Alex] Two Related Questions
anup123 3261 Jul 24, 2003, 5:34 PM