[tbones]

If you want to delete also the votes of the spammer, use this code (inspired by rossooline, http://forums.pligg.com/general-help...ml#post52705):

Step 1: admin_users.php
Find the function called "yeskillspam" (around line 313) and follow it down to where it ends (around line 343) and insert the following code:

PHP Code:

//////////////////////////////////// NEW KILL SPAM //////////////////////////////////////////
        if ($_GET["mode"] == "yeskillspam2"){ // killspam step 2
            $user= $db->get_row('SELECT * FROM ' . table_users .' where user_login="'.$_GET["user"].'"');
            
            canIChangeUser($user->user_level);
            
            if ($user) {
                
                $db->query('DELETE FROM `' . table_users . '` WHERE `user_id` = "'.$_GET["id"].'"');
                $db->query('DELETE FROM `' . table_links . '` WHERE `link_author` = "'.$_GET["id"].'"');
                $db->query('DELETE FROM `' . table_comments . '` WHERE `comment_user_id` = "'.$_GET["id"].'"');

//Delete the votes
$db->query('DELETE FROM `' . table_votes . '` WHERE `vote_user_id` = "'.$_GET["id"].'"');

                
                // breadcrumbs and page title
                $navwhere['text1'] = $main_smarty->get_config_vars('PLIGG_Visual_Header_AdminPanel');
                $navwhere['link1'] = getmyurl('admin', '');
                $navwhere['text2'] = $main_smarty->get_config_vars('PLIGG_Visual_Header_AdminPanel_1');
                $navwhere['link2'] = my_pligg_base . "/admin_users.php";
                $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_Breadcrumb_User_Disable_2');
                $main_smarty->assign('navbar_where', $navwhere);
                $main_smarty->assign('posttitle', " / " . $main_smarty->get_config_vars('PLIGG_Visual_Header_AdminPanel'));
                
                // pagename
                define('pagename', 'admin_users'); 
                $main_smarty->assign('pagename', pagename);

                header("Location: ".my_pligg_base."/admin_users.php");
                
                
            }
            else{showmyerror('userdoesntexist');}
            
        }
/////////////////////////////////// END New KILL SPAM //////////////////////////////////// 


[NewsHeatDotCom]

Here are the queries I have added to my "yeskillspam" section of admin_users.php. It fully removes the user from every trace of the database.

I replaced:

PHP Code:

$db->query('UPDATE `' . table_users . '` SET `user_pass` = "63205e60098a9758101eeff9df0912ccaaca6fca3e50cdce3" WHERE `user_login` = "'.$_GET["user"].'"');
$db->query('UPDATE `' . table_users . '` SET `user_email` = "blank@blank.com" WHERE `user_login` = "'.$_GET["user"].'"');
$db->query('UPDATE `' . table_links . '` SET `link_status` = "discard" WHERE `link_author` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_comments . '` WHERE `comment_user_id` = "'.$_GET["id"].'"'); 


with:

PHP Code:

//New Code to Truly Kill the User
$db->query('DELETE FROM `' . table_votes . '` WHERE `vote_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_saved_links . '` WHERE `saved_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_trackbacks . '` WHERE `trackback_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_friends . '` WHERE `friend_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_messages . '` WHERE `sender` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_messages . '` WHERE `receiver` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_pageviews . '` WHERE `pv_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_comments . '` WHERE `comment_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_links . '` WHERE `link_author` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_users . '` WHERE `user_id` = "'.$_GET["id"].'"'); 


I have tested this code both on a local installation and a live installation and have seen no issues after killspaming a user.

[bbrian017]

Nice work guys! This is all too cool and what do you know... a little common sense!

Great work! 100%

[tbones]

Originally Posted by NewsHeatDotCom

PHP Code:

//New Code to Truly Kill the User
$db->query('DELETE FROM `' . table_votes . '` WHERE `vote_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_saved_links . '` WHERE `saved_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_trackbacks . '` WHERE `trackback_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_friends . '` WHERE `friend_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_messages . '` WHERE `sender` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_messages . '` WHERE `receiver` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_pageviews . '` WHERE `pv_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_comments . '` WHERE `comment_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_links . '` WHERE `link_author` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' . table_users . '` WHERE `user_id` = "'.$_GET["id"].'"'); 


I guess no one ever thought about this relations By the way: Does trackback work at your installation?

Furthermore, I would prefer to see the pageview information at the summary pages next to age, author and so on. By this, all relevant information would be in one spot. Do you see any change to realize it, at least IF this story has been visited?

[mett]

Hello

i try to install this mod in Plig 1.0, but when i click "Yes", i get this message: The page you were looking for doesn't exist!

[NewsHeatDotCom]

This mod is coded for Pligg 9.9.0 beta. It may no longer work in Pligg 1.0 due to database changes, or page structure changes. I have not verified this as I have not looked at the Pligg 1.0 code yet.

[Yankidank]

Adding some bits of this code to Pligg 1.0 RC2 so that it will.
Added the following to admin_users.php:

                    $db->query('DELETE FROM `' . table_votes . '` WHERE `vote_user_id` = "'.sanitize($_GET["id"], 3).'"');
                    $db->query('DELETE FROM `' . table_saved_links . '` WHERE `saved_user_id` = "'.sanitize($_GET["id"], 3).'"');
                    $db->query('DELETE FROM `' . table_trackbacks . '` WHERE `trackback_user_id` = "'.sanitize($_GET["id"], 3).'"');
                    $db->query('DELETE FROM `' . table_friends . '` WHERE `friend_id` = "'.sanitize($_GET["id"], 3).'"');
                    $db->query('DELETE FROM `' . table_messages . '` WHERE `sender` = "'.sanitize($_GET["id"], 3).'"');
                    $db->query('DELETE FROM `' . table_messages . '` WHERE `receiver` = "'.sanitize($_GET["id"], 3).'"');

[mett]

sorry, i modify code in admin_users.php but still get erro

Here is the code i use:

		//////////////////////////////////// NEW KILL SPAM //////////////////////////////////////////
        if ($_GET["mode"] == "yeskillspam2"){ // killspam step 2
            $user= $db->get_row('SELECT * FROM ' . table_users .' where user_login="'.$_GET["user"].'"');
            
            canIChangeUser($user->user_level);
            
            if ($user) {
                
  $db->query('DELETE FROM `' . table_votes . '` WHERE `vote_user_id` = "'.sanitize($_GET["id"], 3).'"');
                    $db->query('DELETE FROM `' . table_saved_links . '` WHERE `saved_user_id` = "'.sanitize($_GET["id"], 3).'"');
                    $db->query('DELETE FROM `' . table_trackbacks . '` WHERE `trackback_user_id` = "'.sanitize($_GET["id"], 3).'"');
                    $db->query('DELETE FROM `' . table_friends . '` WHERE `friend_id` = "'.sanitize($_GET["id"], 3).'"');
                    $db->query('DELETE FROM `' . table_messages . '` WHERE `sender` = "'.sanitize($_GET["id"], 3).'"');
                    $db->query('DELETE FROM `' . table_messages . '` WHERE `receiver` = "'.sanitize($_GET["id"], 3).'"');

                
                // breadcrumbs and page title
                $navwhere['text1'] = $main_smarty->get_config_vars('PLIGG_Visual_Header_AdminPanel');
                $navwhere['link1'] = getmyurl('admin', '');
                $navwhere['text2'] = $main_smarty->get_config_vars('PLIGG_Visual_Header_AdminPanel_1');
                $navwhere['link2'] = my_pligg_base . "/admin_users.php";
                $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_Breadcrumb_User_Disable_2');
                $main_smarty->assign('navbar_where', $navwhere);
                $main_smarty->assign('posttitle', " / " . $main_smarty->get_config_vars('PLIGG_Visual_Header_AdminPanel'));
                
                // pagename
                define('pagename', 'admin_users'); 
                $main_smarty->assign('pagename', pagename);

                header("Location: ".my_pligg_base."/admin_users.php");
                
                
            }
            else{showmyerror('userdoesntexist');}
            
        }
/////////////////////////////////// END New KILL SPAM ////////////////////////////////////