Location: PHPKode > projects > ZompLog > install/upgrade/version38.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 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.8 to 3.9 upgrade $name", "$body", "From: hide@address.com");
echo "<br /> Zomplog has been succesfully upgraded!";
Return current item: ZompLog