Hi Alex,

I miss an important feature in the User Administration.
If Users will sign up, but dont enter the validate code,
then in the User Table there will be a lot of unregistered users.
Now I want to delete unregistered Users which are older then one month, but I have no date or timestamp when they signed up. So I cant delete unregistered users, because I dont know which are old entrys or which are new.

Can you give us a step to step descripton of adding such add-date in the user table?

The easiest way is to go to the DATABASE option SQL Monitor area:

You want to add a field:

ALTER TABLE Users ADD Last_Updated Timestamp (14);

That will create a timestamp field, called Last_Updated, and you can use that.


PUGDOG® Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum

Or you could add a column in the Users table using the specs that puddog provided, although I would use Date rather than TimeStamp.

Then in the Default Field, you could put today's date...2001-03-11.

OR if you use pugdog's method, you will have to do an additional query in the SQL MONITOR:



Regards,

Eliot Lee

Ooops... and no matter what you do, don't forget to resync the def file from the Admin area!!! to make the changes known.

PUGDOG® Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum