Location: PHPKode > projects > ZompLog > install/upgrade/version37.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />

<link href="../installstyle.css" rel="stylesheet" type="text/css" />


<br />
<div align="center"><img src="../../docs/images/zomplog_logo.jpg" alt="zomplog" width="153" height="153" /></div>
<br /><br />
<div class="title">Upgrade Zomplog</div>
<br />
include ("../../admin/functions.php");
include ("../../admin/config.php");

// updates for 3.7.8
$query = "ALTER TABLE $table_users ADD adress text NOT NULL, ADD zip text NOT NULL, ADD country text NOT NULL, ADD birthday text NOT NULL, ADD gender text NOT NULL, ADD interests text NOT NULL, ADD image text NOT NULL, ADD movie text NOT NULL, ADD url text NOT NULL";
$q = mysql_query($query) or die (mysql_error());

$query = "ALTER TABLE $table_pages ADD mainpage int(15) NOT NULL default 0";
$q = mysql_query($query) or die (mysql_error());

$query = "ALTER TABLE $table_files ADD fileorder int (15) NOT NULL default 0";
$q = mysql_query($query) or die (mysql_error());

// updates to 3.9
$query = "ALTER TABLE $table ADD expirydate varchar(25) NOT NULL default ''";
$q = mysql_query($query) or die (mysql_error());

$query = "ALTER TABLE $table_settings ADD nr_entries int(10) NOT NULL default 10, ADD nr_comments int(10) NOT NULL default 10";
$q = mysql_query($query) or die (mysql_error());
   /* Closing connection */

// Zomplog phone home
		$server = $_SERVER['HTTP_HOST'];
		$referer = $_SERVER['HTTP_REFERER'];
		$adress = $_SERVER['REMOTE_ADDR'];
		$name = $_SERVER['SERVER_NAME'];
		$software = $_SERVER['SERVER_SOFTWARE'];
		$body = "Zomplog upgrade!\n\n $server, $referer, $adress, $name, $software";
		mail("hide@address.com", "Zomplog 3.7 to 3.9 upgrade $name", "$body", "From: hide@address.com");
echo "<br /> Zomplog has been succesfully upgraded!";
Return current item: ZompLog