Create a new version of paste: f2dd5c4a3

New Paste

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>

Optional Paste Settings

Syntax Highlighting:

Paste Expiration:

Paste Exposure:

Paste Name / Title:

Hello Guest
Sign Up or Login

You are currently not logged in, this means you can not edit or delete anything you paste. Sign Up or Login

Pastebin.com Tools & Applications

Windows

Firefox

Chrome

iOS

WebOS

Android

Mac

Opera

Click.to

UNIX

WinPhone