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
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