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 ]

[Boofo]

Waht query is that? And what does it exacly do?

[Boofo]

Takara,

The number you enter in the top box for how many days you want to check for still reverts back to 3 instead of staying at the number you have chosen. Is there any way to make this number configurable or to at least stay in the box until you change it again?

[BrAinZ]

Originally posted by KuraFire
I think that I'll stick to running a phpMyAdmin query after giving a warning, first..

Could you explain in more detail please?

[IllNation]

help me out..I try to get the inactiveusers.php file and it won't let me, I want to open it in a text file but I need to know how

[MrBojangle1]

Nice hack. I have been lookin for one like this

[LuBi]

Could we also maybe see something that would aloow us to find users who have only a said amount of posts but have been members longer then a said amoutn of time?

[Ihsahn]

I downloaded your hack and tested it and i felt something wrong ...
members were called inactive even if they are not ...

so, i just made a little change to your code:

Find

PHP Code:

$isinactive=$ddate-$row["joindate"]; 


and Replace by

PHP Code:

$isinactive=$ddate-$row["lastactivity"]; 


for me, its ok now

Cheers
Ihsahn

[Webmasta XT]

ehh can you add a function to mail the inactive users for there last chance to go active or they will be deleted in 2 or 3 days?
just a question..

[Fatty_Bolger]

Thanks Takara!!! Works like a champ. Hopefully they delete option will be seldom used!!

[StarBuG]

Thx for the hack!

Looks great! I have a suggestion to make it more usefull (at least for me).
In your hack if u click on a username you are linkt to the users Profil! I don?t need to view the profile from the user I want the admin user menu! So I tempered a little with your code!

to do the changes open inactiveusers.php

find:

PHP Code:

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>"); 


replace it with:

PHP Code:

echo ("<tr class=\"$bgcolor\"><td align=\"left\">".$row["userid"]."</td><td align=\"left\"><a href='user.php?s=$session[sessionhash]&action=edit&userid=$row[userid]'>".$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>"); 


then save it and re upload

Thx again for your hack!!

Greetings

StarBuG