Spamkill? More like Spambruise

[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?