Hunt out Inactive Users

I made this cause someone asked for it in the requests. I'm not even sure if it counts as a hack (just two lines of code to hack )!

Basically you plop the inactiveusers.php down in your admin dir. It will list all your users, show important info such as When they were last active, when they last posted, when they joined etc.
If they havent posted at all, and have been a user for more than 3 days (you can specify how many days) then it will say they are inactive! And if you click the "YES!" link (under the Inactive? column) it will let you delete the person (it prompts you first).

You can add a link to the admin CP. Here are the 'full' steps on how to install the 'hack':

Step One: open index.php in your admin folder

Find:

PHP Code:

makenavoption("Build Mailing List","email.php?action=genlist"); 


REPLACE WITH:

PHP Code:

makenavoption("Build Mailing List","email.php?action=genlist","<br>");
makenavoption("Find Inactive Users","inactiveusers.php?"); 


Step Two:
Copy inactiveusers.php (attached below) into your admin folder

And you're done! hard, eh ;p
I was going to add the option to specifiy how many users per page since this would be bad for larger forums. But I couldnt figure it out. If anyone wants to give me a hand with that I would appreciate it.

Have fun ^_^ :bunny:

[EDIT: This hack is really old, and currently nothing (other than stuff on the first page) is added in this hack. I'll update this soon with something new for you guys with mods form this thread. Aswell there was a small update on post #29, go here for the update: https://vborg.vbsupport.ru/showthrea...719#post249719 ]

[voogru]

i have 100+ inactive members..Umm how do i Mass delete?

[Floris]

I was just wondering.
In the screenshot from post 2, and sorry if this already has been mentioned, you can see Rahvin having last post to NEVER, and posts colums says 0, but Redemption 09 also has posts to zero, yet he has last post date, and not never. ERR ?

[TECK]

takara, could you please be kind and let ur know if the attachment in the first post have all the mods listed in the thread?
thanks.

[Size]

Look at this piece of code in inactiveusers.php

while ($row=$DB_site->fetch_array($result) and ++$bgcounter) {
	$bgcolor = iif($bgcounter%2==0, 'firstalt', 'secondalt');
	$ddate=time();
	$isinactive=$ddate-$row["joindate"];
	if (($row["lastpost"]==0)&&($isinactive>$timeactive)) {
		$yninactive="<a href=\"user.php?s=$session[sessionhash]&action=remove&userid=".$row["userid"]."\" target='_blank'><font color=\"#FF0000\">YES!</font></a>";
	} else {
		$yninactive="No</font>";
	}
	if ($row["lastpost"]==0) { 
		$lastpost="<font color=\"red\">NEVER</font>";
	}else { 
		$timefull=time();
		$lastpost=date("m-d-Y h:i A", $row["lastpost"]);
	}
	$extendateLA=date("m-d-Y h:i A", $row["lastactivity"]);
	$extendateJD=date("m-d-Y h:i A", $row["joindate"]);
        echo ("<tr class=\"$bgcolor\"><td align=\"left\">".$row["userid"]."</td><td align=\"left\"><a href='../member.php?s=$session[sessionhash]&action=getinfo&userid=$row[userid]' target='_blank'>".$row["username"]."</a></td><td align=\"left\">$extendateJD</td><td align=\"left\">$lastpost</td><td align=\"left\">$extendateLA</td><td align=\"center\">".$row["posts"]."</td><td align=\"left\">".$row["ipaddress"]."</td><td align=\"left\">$yninactive</td></tr>");
}

in this if-else structure

if (($row["lastpost"]==0)&&($isinactive>$timeactive)) {
		$yninactive="<a href=\"user.php?s=$session[sessionhash]&action=remove&userid=".$row["userid"]."\" target='_blank'><font color=\"#FF0000\">YES!</font></a>";
	} else {
		$yninactive="No</font>";
	}

delete the else {.....}, and move the closing } for the if to right before the closing } for the while loop. The altered code looks like this:

while ($row=$DB_site->fetch_array($result) and ++$bgcounter) {
	$bgcolor = iif($bgcounter%2==0, 'firstalt', 'secondalt');
	$ddate=time();
	$isinactive=$ddate-$row["joindate"];
	if (($row["lastpost"]==0)&&($isinactive>$timeactive)) {
		$yninactive="<a href=\"user.php?s=$session[sessionhash]&action=remove&userid=".$row["userid"]."\" target='_blank'><font color=\"#FF0000\">YES!</font></a>";
	
	if ($row["lastpost"]==0) { 
		$lastpost="<font color=\"red\">NEVER</font>";
	}else { 
		$timefull=time();
		$lastpost=date("m-d-Y h:i A", $row["lastpost"]);
	}
	$extendateLA=date("m-d-Y h:i A", $row["lastactivity"]);
	$extendateJD=date("m-d-Y h:i A", $row["joindate"]);
        echo ("<tr class=\"$bgcolor\"><td align=\"left\">".$row["userid"]."</td><td align=\"left\"><a href='../member.php?s=$session[sessionhash]&action=getinfo&userid=$row[userid]' target='_blank'>".$row["username"]."</a></td><td align=\"left\">$extendateJD</td><td align=\"left\">$lastpost</td><td align=\"left\">$extendateLA</td><td align=\"center\">".$row["posts"]."</td><td align=\"left\">".$row["ipaddress"]."</td><td align=\"left\">$yninactive</td></tr>");
	}
}

You're welcome in advance

[Vile]

Nice hack, works like a charm.
Beware zero posters!

[inetd]

Size, big thx for addon

[mewgood]

how do you delete the inactive user? like mass delete

[wolfe]

can someone please help on this hack i have added all the above but it is saying i am inactive and i am admin i am online but it still says i am inactive.

[wolfe]

[high]* wolfe BUMPS post and Crys for help HELP!!![/high]

[Illuvatar]

Hey Takara!

/me moves site to new server, installs VB 2.2.7, re-applies this most excellent hack!

lol

Works like a charm.....again!

Many thanks,
Illu