Location: PHPKode > projects > PHPFreeNews > phpfn/Upgrade/Upgrade115117.php
<?php
$OldDBVersion = "1.15";
$NewDBVersion = "1.17";
/*	+--------------------------------------------------------------
	| PHPFreeNews - News Headlines on your website                |
	| Developed by Jim Willsher.                                  |
	| http://www.phpfreenews.co.uk                                |
	+-------------------------------------------------------------+
*/

require("../Config/Config.php");
require("../Inc/Functions.php");

$UpgradeScript = $_SERVER['PHP_SELF'];
$Step = isset($_GET['step']) ? $_GET['step'] : '';
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
	<HEAD>
		<TITLE>
		<?= $SiteDescription ?>
		Upgrade Version <?= $OldDBVersion ?> Database to Version <?= $NewDBVersion ?> Database</TITLE>
		<META name="Author" content="Jim Willsher">
		<META name="Keywords" content="PHP, News, Headlines, PHPFreeNews">
		<META name="Description" content="PHP Free News">
		<LINK rel="stylesheet" href="../Inc/Styles.css" type="text/css" />
	</HEAD>
	<body>
		<P class="plaintext"><IMG src="../Inc/Images/<?= $AdminSiteLogo ?>" width="266" height="61"></p>
		<P class="plaintext">
			<?php
			// =============================================================================================================

			if ($Step == "")
			{
				// First Stage
				?>
			Welcome to the Version <?= $OldDBVersion ?> to <?= $NewDBVersion ?> Upgrade Script for <B>
			<?= $SiteDescription ?>
			</B>.<br />
			<br />
			This script will update your database to make it compliant with Version <?= $NewDBVersion ?> of<?= $SiteDescription ?>. <br />
			The installer will upgrade database <B>"<?= $db ?>"</B>. Remember to upgrade every database you have.</p>
			<P class="plaintext">It is assumed that you are already running version <?= $OldDBVersion ?> or later. <br />
			<br />
			The MySql User in your Config.php file must have the following permissions: ALTER.<br />
			Once the database has been installed you can safely revoke ALTER. <br />
			<br />
			<A href="<?=$UpgradeScript?>?step=1">Perform Upgrade >></A>
			<?php
			}

			// =============================================================================================================

			elseif ($Step == "1")
			{
				// Set up the tables...
				echo ("<br />Updating Table: news_users...");
				$sql_query = mysql_query("ALTER TABLE news_users
						ADD MustChangePassword TINYINT NOT NULL DEFAULT '0',
						CHANGE Password Password VARCHAR(32) NOT NULL");
				if ($sql_query)
				{
					echo ("<b> Done!</b>");
				}
				else
				{
					echo mysql_error();
					exit();
				}

				echo ("<br />Resetting password on ALL accounts to \"password\"...");
				$sql_query = mysql_query("UPDATE news_users SET `Password` = MD5(\"password\"), MustChangePassword='1'");
				if ($sql_query)
				{
					echo ("<b> Done!</b>");
				}
				else
				{
					echo mysql_error();
					exit();
				}

				echo ("<br />Resetting password on default Admin account to \"Admin\"...");
				$sql_query = mysql_query("UPDATE news_users SET `Password` = MD5(\"Admin\"),  MustChangePassword='1' WHERE ID = 1");
				if ($sql_query)
				{
					echo ("<b> Done!</b>");
				}
				else
				{
					echo mysql_error();
					exit();
				}


				// ===============================================================================================

				?>
				<br />
				<br />
				If there were no errors generated then the Database was updated successfully.<br />
				Please now delete this installation file (<?= $_SERVER['PHP_SELF'] ?>) or make it inaccessible. <br />
				<br />
				<?php
			}
			?>
		</p>
	</body>
</HTML>
Return current item: PHPFreeNews