Jump to content

Archived

This topic is now archived and is closed to further replies.

xyn

Short advice.

Recommended Posts

Hi.
Would someone be able to give me some advice on the easiest and
most effective way of going about checking account activations.
Basically when they register it will register the time and date, I wanted
to check if the account has been activated with in 15 days,

If it has obviosuly the time and date will become the "last login" otherwise
it would stay the registered date & time. Clearly this way would work using
MYSQL, but I have no idea how to go about it.

If the acocunt has not been activated within 15 days I wanted it to be
deleted automatically.

Share this post


Link to post
Share on other sites
[quote author=xyn link=topic=103417.msg411733#msg411733 date=1155045459]
Hi.
Would someone be able to give me some advice on the easiest and
most effective way of going about checking account activations.
Basically when they register it will register the time and date, I wanted
to check if the account has been activated with in 15 days,

If it has obviosuly the time and date will become the "last login" otherwise
it would stay the registered date & time. Clearly this way would work using
MYSQL, but I have no idea how to go about it.

If the acocunt has not been activated within 15 days I wanted it to be
deleted automatically.
[/quote]

how is the date recorded? is it a datetime field, or set by time()

Share this post


Link to post
Share on other sites
The date and time is set by:
date("d-m-y"); [nn-nn-nnnn]
date("g:ia");    [n:nam/pm]

Share this post


Link to post
Share on other sites
some thing like this...

[code]
$borderdate = mktime(0, 0, 0, date("m"), date("d")-15 ,  date("Y"));  //15 days ago

mysql_query("DELETE FROM <table> WHERE `signup_date` =< '$borderdate');
[/code]

BUT... im only guessing, try running the same ish query but as a select, so see if it picks up the right members

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.