From 825e994444fcdb73d62710d0d934e93a227bd30f Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Mon, 15 Sep 2014 17:26:26 +0200
Subject: Added eventlog class, improved db-update machanism.

A warning will be shown in the main menu bar if the database schema needs to be updated.
---
 inc/database.inc.php | 14 ++++++++++++++
 inc/eventlog.inc.php | 15 +++++++++++++++
 inc/property.inc.php |  5 +++++
 3 files changed, 34 insertions(+)
 create mode 100644 inc/eventlog.inc.php

(limited to 'inc')

diff --git a/inc/database.inc.php b/inc/database.inc.php
index e7a16ba1..a729b7fc 100644
--- a/inc/database.inc.php
+++ b/inc/database.inc.php
@@ -9,6 +9,20 @@ class Database
 
 	private static $dbh = false;
 	private static $statements = array();
+	
+	/**
+	 * Get database schema version - used for checking for updates
+	 * @return int Version of db schema
+	 */
+	public static function getExpectedSchemaVersion()
+	{
+		return 5;
+	}
+	
+	public static function needSchemaUpdate()
+	{
+		return Property::getCurrentSchemaVersion() < self::getExpectedSchemaVersion();
+	}
 
 	/**
 	 * Connect to the DB if not already connected.
diff --git a/inc/eventlog.inc.php b/inc/eventlog.inc.php
new file mode 100644
index 00000000..0d7f6d4a
--- /dev/null
+++ b/inc/eventlog.inc.php
@@ -0,0 +1,15 @@
+<?php
+
+class EventLog
+{
+	
+	public static function log($eventId, $message)
+	{
+		Database::exec("INSERT INTO eventlog (dateline, logtypeid, description)"
+			. " VALUES (UNIX_TIMESTAMP(), :eventid, :message)", array(
+				'eventid' => $eventId,
+				'message' => $message
+		));
+	}
+	
+}
diff --git a/inc/property.inc.php b/inc/property.inc.php
index 81de137f..605d901d 100644
--- a/inc/property.inc.php
+++ b/inc/property.inc.php
@@ -141,5 +141,10 @@ class Property
 	{
 		self::set('dl-' . $name, $taskId, 5);
 	}
+	
+	public static function getCurrentSchemaVersion()
+	{
+		return self::get('webif-version');
+	}
 
 }
-- 
cgit v1.2.3-55-g7522