<?php
   // --- START EDIT --- \\
$database_name = "phoenix";
$database_host = "localhost";
$database_user = "root";
$database_pass = "pass";
// ------- END EDIT ------- \\

mysql_connect($database_host,$database_user,$database_pass);
if (!$con)
  {
  die('Could not connect to Database: ' . mysql_error());
  }
mysql_select_db($database_name);

$errors = 0;
if ($_POST) {

if ($_POST['old'] = "" | $_POST['new'] = "") {
echo 'Error! Name cannot be nothing!';
$errors = 1;
}
if ($errors = 1) {
$result = mysql_query('UPDATE users SET username = \''.$_POST['new'].'\' WHERE username = \''.$_POST['old'].'\'');

if (!$result) {
echo 'Update Name [FAILED]';
}
else {
    echo 'Updated Name [DONE]';
}

$result = mysql_query('UPDATE rooms SET owner = \''.$_POST['new'].'\' WHERE owner = \''.$_POST['old'].'\'');

if (!$result) {
echo 'Update Rooms [FAILED]';
}
else {
    echo 'Updated Rooms [DONE]';
}

$result = mysql_query('UPDATE chatlogs SET user_name = \''.$_POST['new'].'\' WHERE user_name = \''.$_POST['old'].'\'');

if (!$result) {
echo 'Update Chatlogs [FAILED]';
}
else {
    echo 'Updated Chatlogs [DONE]';
}


}
else {
echo "Unknown Error!";
}
}
?>

<form action="" method="post">
    Old Name:  <input type="text" name="old" />    New Name: <input type="text" name="new" /><br />
    <input type="submit" value="Change!" />
</form>