Hi, You can try "E*Reminders by alberciak, ninov
" which allows web-clients to set up reminders to automatically E-mail them at a certain time to remind them of special events.
Also you can do the same, but you need to run that script daily. Write new script contains reminder mail format. Write a query to get register User list not yet activated account.
echo date('l jS F (Y-m-d)', strtotime('-7 days'));
will give you date a week ago and Now check for user account not get activated since last 2 weeks and simply delete that records, you can get date, 2 week ago using script listed below.
echo date('l jS F (Y-m-d)', strtotime('-14 days'));