vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Hunt out Inactive Users (https://vborg.vbsupport.ru/showthread.php?t=38448)

voogru 05-24-2002 04:55 PM

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

Floris 06-05-2002 08:43 AM

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 06-05-2002 08:52 AM

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 06-05-2002 06:48 PM

Look at this piece of code in inactiveusers.php
Code:

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
Code:

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:

Code:

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 07-31-2002 02:36 AM

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

inetd 07-31-2002 02:46 AM

Size, big thx for addon ;)

mewgood 08-20-2002 12:10 AM

how do you delete the inactive user? like mass delete

wolfe 09-01-2002 02:53 PM

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 09-03-2002 09:26 PM

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

Illuvatar 09-06-2002 08:19 PM

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


All times are GMT. The time now is 12:31 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01246 seconds
  • Memory Usage 1,738KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete