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>