From c757506a0a598593115c377a6e4acf399f4d2b83 Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
Date: Sun, 21 Jun 2009 23:23:15 -0700
Subject: added option for email digest

you can now select to get emails only every N hours. They are saved in the database and a cron script will send them out.
---
 update_db.php | 42 ++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 42 insertions(+)
 create mode 100644 update_db.php

(limited to 'update_db.php')

diff --git a/update_db.php b/update_db.php
new file mode 100644
index 0000000..140dece
--- /dev/null
+++ b/update_db.php
@@ -0,0 +1,42 @@
+<?php
+error_reporting(E_ALL);
+
+include_once("config.php");                /* needs to be first in list, since other includes use this */
+include_once("./include/db.php");          /* database only */
+include_once("./include/functions.php");   /* the rest */
+
+/* make sure that user has set all variables in config.php */
+config_check();
+
+/* open the database */
+if(DB_open()<0)
+  exit();
+
+/* only callable via cron or CLI */
+if(isset($_SERVER['REMOTE_ADDR']))
+  exit();
+
+$old_version = DB_get_version();
+$current_version = 1;
+
+if($old_version < $current_version)
+  echo "Will upgrade your database now:\n";
+else
+  echo "You are up to date (version ${current_version}), nothing to do.\n";
+
+switch($old_version)
+  {
+  case 0:
+    /* add database for digesting */
+    DB_query("CREATE TABLE digest_email (".
+	     " `id` int(11) NOT NULL auto_increment,".
+	     " `email` varchar(255) default null,".
+	     " `create_date` timestamp NOT NULL default '0000-00-00 00:00:00',".
+	     " `content` text,".
+	     " UNIQUE KEY `id` (`id`),".
+	     " index (email))");
+    DB_query("UPDATE Version set version=1");
+    echo "Upgraded to version 1.\n";
+  }
+
+?>
\ No newline at end of file
-- 
cgit v1.2.3-18-g5258