Location: PHPKode > projects > OxyNews > oxynews/install2.php
<? 
/*
	OxyNews, a PHP news management program
    Copyright (C) 2002  OxyTeam
    This program is free software; you can redistribute it and/or modify 
    it under the terms of the GNU General Public License as published by 
    the Free Software Foundation; either version 2 of the License, or 
    (at your option) any later version. 

    This program is distributed in the hope that it will be useful, 
    but WITHOUT ANY WARRANTY; without even the implied warranty of 
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the 
    GNU General Public License for more details. 

    You should have received a copy of the GNU General Public License 
    along with this program; if not, write to the Free Software 
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA 
*/
// www.php-arena.com
// www.oxynews.net
// www.oxyscripts.com
//************************************************************** 
//* This is install.php 
//************************************************************** 
##Include Files 
include ("oxynews_config.php"); 

if (empty($users_tab)) {
$users_tab = "oxynews_users";
}

$sql_update_field_lost = "ALTER TABLE `$oxynews_mysql_database_name`.`$users_tab` CHANGE `lost` `lost` char(1) NOT NULL default '0';";

?>
<head>
<title>OxyNews: Update Script - v0.3 to v0.3.2</title>
</head>
<body>
<center>
<font face="Arial" size="2">OxyNews: Update Script - v0.3 to v0.3.2<p>
<?

if ($startupdate) {

echo "Updating...<p>"; 

## Updatind fields

oxynews_mysql_query($sql_update_field_lost, "Updating Field: lost");

echo "<B>OxyNews Update Script Complete.</B><br>
If any of the complete signs are red, then find the bug that made the script fail, remove it, and then run the script again. (Remember that those actions that worked now, will fail next time you run this script, well most of them will.)
<p>By sure to delete this file when done..."; 

} else {
?>

Welcome.<br>
This script will update OxyNews v0.3 to v0.3.2.<p>
<form action="install2.php">
If you have changed what the tables was named when you installed OxyNews v0.3<br>
then enter the new names here, of just leave empty to use the scripts default names<br>
Users table: <input type="text" name="admin_tab" size="15"> -> oxynews_users<br>
<input type="submit" value="Run the update script" name="startupdate">
</form>

<?
}
?>
</font>
</center>
</body>
Return current item: OxyNews