Oh no!  You’ve accidentally changed your WordPress site URL in the admin settings!  What are you going to do?

The following code is written in PHP 5 and utilizes the mysqli php extension.

Please use this file at your own risk!

<?php
#### WORDPRESS RESET ###########
##                            ##
## Allan Collins              ##
## http://allancollins.net    ##
##                            ##
## 1-12-2009                  ##
################################

// HOW TO USE:
// Simply type in the url in the text box to reset the WordPress site url.

// WARNING: 
// This file can be a HUGE security risk and has the potential to seriously
// mess up your site's database.  Please use with caution and DELETE THIS FILE when you 
// are done resetting your website.



// First, get database settings from wp-config.php...
require_once("wp-config.php");

// Create a new database object...
$db=new mysqli(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME);


// Was the form submitted?
if (isset($_POST['url'])) {

	$url=$_POST['url'];
	
	$query="UPDATE wp_options SET option_value='$url' WHERE option_name='siteurl'";
	
	$result=$db->query($query);

	echo "THERE WERE <b>" . $db->affected_rows . "</b> ROWS IN THE DATABASE AFFECTED!<br/><br/>";
	
	// Did the database query update anything?  If so, then stop the application...
	if ($db->affected_rows != 0) {
	
		die("Be Sure To Delete This File From Your Server When Complete!!!");
		
	}
	
}

// Query the current information in the database...
$query="SELECT option_value FROM wp_options WHERE option_name='siteurl'";

$result=$db->query($query);

$row=$result->fetch_object();

// Display the form and print out what is in the database...

?>

<form action="sitereset.php" method="post">
<b>Site URL:</b> <input type="text" name="url" size="60" value="<?php echo $row->option_value ?>" />
<br />
<br />
<input type="submit" value="RESET WORDPRESS" />
</form>

This entry was posted on Monday, January 12th, 2009 at 11:14 pm and is filed under Web Design. You can follow any responses to this entry through the RSS 2.0 feed.You can leave a response, or trackback from your own site.