[ABD] - Delete Inactive User Timer

[TCR_500]

Modification Name: Delete Inactive User Timer
Author: TCR_500

Modification Description: This mod adds a timer to the common.php file to delete users that have registered an account, but have not activated it yet. The time interval can be adjusted directly from the common.php file to any interval you want. By default, it's a 24-hour interval.

Modification Version: 0.5.1.2

Requirements: Use only if your Account activation setting is set to "By User". Otherwise, you will be in a race against time to activate the user before the user is deleted.

Make a backup of your database and your common.php file.

phpBB v3.0.7-LP1 or newer recommended.

Features:

• Automatically deletes a user after a set time interval if the user has registered, but not activated their account.
• 0.5.1.2 Update: Fixes a few bugs and adds a list of user-friendly variables to help with programming.
• Detailed instruction set on how to install and modify this mod are included.

Demo URL: Delete Inactive User v0.5.1.2 Beta Demo
Modification Download: Delete Inactive User v0.5.1.2 Beta Download

[Ather]

incase some 1 doesnt know, you can edit this line to change the time

Code: Select all

    if($user_inactive_time == $user_regdate and $usercheck_time == $user_inactive_time + (24 * 60 * 60)) 

also, note that this mod will replace your existing common.php so if you have a forum with modifications, you'll need to be extra careful

[jmjm003]

Lets do this again after looking at your file better versus mine.

Is it correct to say. All we need to do is find

Code: Select all

?>

in common.php

And add before

Code: Select all

$usercheck_time = time();
$sql_usercheck = "SELECT * FROM " . USERS_TABLE . " WHERE user_inactive_reason='1' ";
$result_usercheck = $db->sql_query($sql_usercheck);
while($row_usercheck = $db->sql_fetchrow($result_usercheck))
{
	$user_id = $row_usercheck['user_id'];
	$user_inactive_time = $row_usercheck['user_inactive_time'];
	$user_regdate = $row_usercheck['user_regdate'];
	if($user_inactive_time == $user_regdate and $usercheck_time == $user_inactive_time + (24 * 60 * 60))
	{
		$sql_usercheck_remove = "DELETE FROM " . USERS_TABLE . " WHERE user_inactive_time='$user_inactive_time' ";
		$result_usercheck_remove = $db->sql_query($sql_usercheck_remove);
	}
}

I appreciate the mod. It's dangerous to just give a new copy of a file. You and I both know someone is going to overwrite their current one and possibly cause issues with other mods. Should they? No.

If you could confirm the changes then it's simple enough to just mod your own file.

[TCR_500]

Those are the changes I made to the file. I will fix that problem with the files being overridden so it won't accidentally override any other modifications that might be there.

[heredia21]

Have you fixed the problem?

[TCR_500]

Not yet. I'm not that fast at coding. Plus, I can't find the control that tells the software if the user is an admin or not.

[jmjm003]

A new, unactivated user wouldn't be an admin to begin with. Or, did I completely miss what you were talking about?

[TCR_500]

I'm building an install file that adds the code at the end of the common.php file. It requires an admin to run the script.

[robra]

Hi.
The link to download is broken.

Thanks

[robra]

IS IT A JOKE ???

Now, the download link is redirecting to Walmart comercial page(*no spamming please* )
Could someone fix that problem to download the correct MOD ?

Thank you.

[tumba25]

The MOD author has not replied in this topic since July 29th 2010, so I'll lock this as abandoned.

If you, the MOD author, wants to continue developing this MOD, please contact a MOD team member.

[tumba25]

The MOD author wants to continue developing this MOD so I'll unlock the topic.

[robra]

Great...

The TCR_500 gave me the new link address to download:
Delete Inactive User v0.5.1.2 Beta
I already installed it and I have one question:
If I will want change the delete time of the inactive user for 3 days(72 hours), then I will change the line:

Code: Select all

// Use above variables as referance.
$delete_user_time = 24 * $timespan_hour;	// 24 hours is default!

To:

Code: Select all

// Use above variables as referance.
$delete_user_time = 72 * $timespan_hour;	// 24 hours is default!

Or:

Code: Select all

// Use above variables as referance.
$delete_user_time = 3 * $timespan_day;    // 24 hours is default!

Thank you, very much.

[robra]

Hi, TCR_500.

If could look my request of MOD on page http://www.phpbb.com/community/viewtopi ... &t=2118741, I will appreciate a lot.
This request MOD is about "Auto Remind Inactives Users + Auto Delete Them".
The idea is that it work basically this way:
An user created an account but not activated it.
After the first day of created your account, the user will receive an e-mail automatically reminding him that your account was created but not activated yet and he has 2 days more to do that.
After the second day of created your account, the user will receive an e-mail automatically reminding him that your account was created but not activated yet and he has 1 days more to do that.
After third day of created your account, the user will receive an e-mail automatically notifying that your account was deleted because expired the time to activate it.
It's a suggestion only.

Thank you.

[robra]

Great...

The TCR_500 gave me the new link address to download:
Delete Inactive User v0.5.1.2 Beta
I already installed it and I have one question:
If I will want change the delete time of the inactive user for 3 days(72 hours), then I will change the line:

Code: Select all

// Use above variables as referance.
$delete_user_time = 24 * $timespan_hour;	// 24 hours is default!

To:

Code: Select all

// Use above variables as referance.
$delete_user_time = 72 * $timespan_hour;	// 24 hours is default!

Or:

Code: Select all

// Use above variables as referance.
$delete_user_time = 3 * $timespan_day;    // 24 hours is default!

Thank you, very much.

The 2 ways are right.

Thanks.