Ryan

if($_POST['action'] == "nuke"){
        $username="xxxxxx";
        $password="xxxxxx";
        $database="xxxxxx";
        $server="xxxxxxx";

        //Connect to DB
        mysql_connect($server,$username,$password) or die("Unable to Conenct");
        @mysql_select_db($database) or die( "Unable to select database");

        //Get user id and ip
        $query= "SELECT * FROM phpbb_users WHERE username_clean = '".strtolower($_POST['username'])."';";
        $result=mysql_query($query) or die("Query Failed: ".$query);
        $row = mysql_fetch_array($result);

        $userID = $row['user_id'];
        $userIP = $row['user_ip'];

        //Delete User
        $query= "DELETE FROM phpbb_users WHERE user_id = ".$userID.";";
        mysql_query($query) or header("location: nuke.php?error=usernotfound"); //die("Post Deletion Failed.  Query: ".$query);

        //Delete posts
        $query= "DELETE FROM phpbb_posts WHERE poster_id = ".$userID.";";
        mysql_query($query) or die("Post Deletion Failed.  Query: ".$query);

        //Delete topics
        $query= "DELETE FROM phpbb_topics WHERE topic_poster = ".$userID.";";
        mysql_query($query) or die("Post Deletion Failed.  Query: ".$query);

        //Ban user ID
        $query = "INSERT INTO phpbb_banlist (ban_userid) VALUES (".$userID.");";
        mysql_query($query) or die("Banlist Update User ID Failed.  Query: ".$query);

        //Ban user IP address
        if(!empty($userIP)){
            $query = "INSERT INTO `vdp_forum_new`.`phpbb_banlist` (`ban_id`, `ban_userid`, `ban_ip`, `ban_email`, `ban_start`, `ban_end`, `ban_exclude`, `ban_reason`, `ban_give_reason`) VALUES (NULL, '0', '".$userIP."', '', '0', '0', '0', '', 'nuked');";
            mysql_query($query) or die("Banlist Update User IP Failed.  Query: ".$query);
        }

        //Fix 'last post by' and 'last post time' on forums that were affected by deleted posts
        $query = "SELECT * FROM phpbb_forums WHERE forum_last_poster_id = ".$userID.";";
        $result = mysql_query($query) or die("Query Failed: ".$query);
        while($row = mysql_fetch_assoc($result)){
            $query = "SELECT * FROM phpbb_posts WHERE forum_id = ".$row['forum_id']." ORDER BY post_time DESC LIMIT 1;";
            $result2 = mysql_query($query) or die("Query Failed: ".$query);

            //get last poster and time
            $row2 = mysql_fetch_array($result2);
            $realLastPosterID = $row2['poster_id'];
            $realLastPostTime = $row2['post_time'];

            //Set last post time
            $query = "UPDATE phpbb_forums SET forum_last_post_time = '".$realLastPostTime."' WHERE forum_id = ".$row['forum_id'].";";
            mysql_query($query) or die("Fix failed: ". $query);

            //Set last poster id
            $query = "UPDATE phpbb_forums SET forum_last_poster_id = ".$realLastPosterID." WHERE forum_id = ".$row['forum_id'].";";
            mysql_query($query) or die("Fix failed: ". $query);

            //Set last poster name
            $name = getName($realLastPosterID);
            $query = "UPDATE phpbb_forums SET forum_last_poster_name = '".$name."' WHERE forum_id = ".$row['forum_id'].";";
            mysql_query($query) or die("Fix failed: ". $query);
        }

        header("Location: nuke.php?success=1");
    }

    //Get username based on ID
    function getName($id){
        $query = "SELECT * FROM phpbb_users WHERE user_id = ".$id.";";
        $result = mysql_query($query) or die("Fix failed: ". $query);
        $row = mysql_fetch_array($result);
        return $row['username'];
    }
?>
<center><br />
    This form is <b>very</b> dangerous...be careful.<br /><br />
    <form method="post">
        Username: <input type="text" name="username" /> &nbsp; <input type="submit" value="Nuke" />
        <input type="hidden" name="action" value="nuke" />
    </form>
    <? if($_GET['success'] == 1){ ?>
    <br />
    Deleted user...<span style="color:green;">Success!</span><br />
    Deleted posts...<span style="color:green;">Success!</span><br />
    Banned Username...<span style="color:green;">Success!</span><br />
    Banned IP...<span style="color:green;">Success!</span><br />
    Fixed post info...<span style="color:green;">Success!</span><br />
    <? } ?>

    <? if($_GET['error'] == 'usernotfound'){ ?>
    <br />
    <span style="color:red;">Username not found.</span>
    <? } ?>

</center>