vb.org Archive - Find, Optionally Email and Optionally Delete Inactive Members

Quote:

Originally posted by hypedave

Just the delete I suppose

Here ya go:

in manageInactive.php Find:

Code:

 $userArray=$DB_site->query("SELECT username,userid,email,adminemail,emailDate FROM user WHERE lastactivity<$cutoffdate and emailDate<$dateCut ORDER BY username");

Replace with:

Code:

 $userArray=$DB_site->query("SELECT username,userid,email,posts,adminemail,emailDate FROM user WHERE lastactivity<$cutoffdate and emailDate<$dateCut ORDER BY username");

Find:

Code:

      // We are just going to delete the inactive users with no warning

       $DB_site->query("UPDATE post SET username='".addslashes($user[username])."',userid=0 WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM user WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM userfield WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM access WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM calendar_events WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM customavatar WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM moderator WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM privatemessage WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM subscribeforum WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM subscribethread WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM session WHERE userid='$user[userid]'");

        $countDelete++;

       $inactiveUsersDeleted .=$user[username]."\n";

       echo("Deleted ". $user[username]."<br>");

Replace with: (change X to be the number of posts you choose)

Code:

 if($user[posts] < X) {

      // We are just going to delete the inactive users with no warning

       $DB_site->query("UPDATE post SET username='".addslashes($user[username])."',userid=0 WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM user WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM userfield WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM access WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM calendar_events WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM customavatar WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM moderator WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM privatemessage WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM subscribeforum WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM subscribethread WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM session WHERE userid='$user[userid]'");

        $countDelete++;

       $inactiveUsersDeleted .=$user[username]."\n";

       echo("Deleted ". $user[username]."<br>");

}

Find:

Code:

      if($user[emailDate]<$dateCut) {

       $DB_site->query("UPDATE post SET username='".addslashes($user[username])."',userid=0 WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM user WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM userfield WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM access WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM calendar_events WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM customavatar WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM moderator WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM privatemessage WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM subscribeforum WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM subscribethread WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM session WHERE userid='$user[userid]'");

        $countDelete++;

        $inactiveUsersDeleted .=$user[username]."\n";

       echo("Deleted ". $user[username]."<br>");

Replace With: (Change X as above)

Code:

if ($user[posts] < X) {

      if($user[emailDate]<$dateCut) {

       $DB_site->query("UPDATE post SET username='".addslashes($user[username])."',userid=0 WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM user WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM userfield WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM access WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM calendar_events WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM customavatar WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM moderator WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM privatemessage WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM subscribeforum WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM subscribethread WHERE userid='$user[userid]'");

       $DB_site->query("DELETE FROM session WHERE userid='$user[userid]'");

        $countDelete++;

        $inactiveUsersDeleted .=$user[username]."\n";

       echo("Deleted ". $user[username]."<br>");

}

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01314 seconds Memory Usage 1,754KB 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 (6)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)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
Messages: