1
bigbrofan
Site Members -vs- Non Response to Email...
  • 2004/12/3 6:42

  • bigbrofan

  • Just popping in

  • Posts: 22

  • Since: 2004/11/25


I am setting up XOOPS to require email validation (ie... they must click in the link in the email that is sent before they are members on the system.)

What I need to know is how I can see all of those that have been sent the email but have NOT responded.

Is there a quick way for me to re-send the email to them?

Is there a way that I can purge them from the database or is this done automatically?

Thanks in advance for the help.

2
irmtfan
Re: Site Members -vs- Non Response to Email...
  • 2004/12/3 7:03

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


huum unfortunatly there is no way to delete inactive users after a same time.

personally i write a little php file to delete them (im too newbi in php and MySQL so sorry for basic code) btw share with you:

define("user""database_username");
define("pass""database_password");
define("host""localhost"); //or change it to yours
define("db""database_name");


$cxn mysql_connect(host ,userpass);
mysql_select_db(db);

$delete_time time() - ( 24 60 60 );  // 5 days/month * 24 hrs/day
// * 60 minutes/hour * 60 seconds/min.

$sql "DELETE from `xoops_users` WHERE `last_login` = '0' AND `user_regdate` < '$delete_time'";
//This script would delete everyuser older than 5 days that has been not active.

$result mysql_query($sql$cxn);
?>

just save it as a file like "inactive_delete.php" and run it.i run this file with chron job every day.
WARNNING: dont put this file in your ROOT because this is no secure at all.

Login

Who's Online

442 user(s) are online (55 user(s) are browsing Support Forums)


Members: 0


Guests: 442


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Sep 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits