MythVantage specific pkgs

author: James Meyer <james.meyer@operamail.com> 2008-11-09 02:33:06 (GMT)
committer: James Meyer <james.meyer@operamail.com> 2008-11-09 02:33:06 (GMT)
commit: 1ba69cc033dfbd0a6c4c29c6d877c7e753f96e8e (patch)
tree: f336ee91ce16c6591fff50340562e07e15aa1a55 /abs/mv-core/webcal
parent: 75b1bceb21faab32d8f519d6f7f7062a226f9047 (diff)
download: linhes_pkgbuild-1ba69cc033dfbd0a6c4c29c6d877c7e753f96e8e.zip
linhes_pkgbuild-1ba69cc033dfbd0a6c4c29c6d877c7e753f96e8e.tar.gz
linhes_pkgbuild-1ba69cc033dfbd0a6c4c29c6d877c7e753f96e8e.tar.bz2
8 files changed, 1785 insertions, 0 deletions
diff --git a/abs/mv-core/webcal/PKGBUILD b/abs/mv-core/webcal/PKGBUILD
new file mode 100755
index 0000000..efa8237
--- /dev/null
+++ b/abs/mv-core/webcal/PKGBUILD
@@ -0,0 +1,35 @@
+pkgname=webcalendar
+pkgver=1.2.b1
+pkgrel=11
+pkgdesc="Web based calendar"
+license="GPL"
+arch=('i686')
+
+url="http://www.k5n.us/webcalendar.php"
+source=(http://voxel.dl.sourceforge.net/sourceforge/webcalendar/WebCalendar-1.2.b1.tar.gz config.php settings.php send_reminders.patch createdb.sql sendreminders.sh posix.tab)
+depends="local-website"
+install=webcal.install
+
+build() {
+cd $startdir/src
+mkdir -p  $startdir/pkg/data/srv/httpd/htdocs/webcal
+mkdir -p $startdir/pkg/usr/bin
+cp $startdir/src/sendreminders.sh $startdir/pkg/usr/bin/
+chmod 755 $startdir/pkg/usr/bin/sendreminders.sh
+
+cp -rp  WebCalendar-$pkgver/* $startdir/pkg/data/srv/httpd/htdocs/webcal
+
+cp createdb.sql $startdir/pkg/data/srv/httpd/htdocs/webcal/
+cp  config.php $startdir/pkg/data/srv/httpd/htdocs/webcal/includes
+cp  settings.php $startdir/pkg/data/srv/httpd/htdocs/webcal/includes
+cp -f posix.tab $startdir/pkg/data/srv/httpd/htdocs/webcal/includes/zone.tab
+
+cd $startdir/pkg/data/srv/httpd/htdocs/webcal/tools
+
+patch -p0 < $startdir/src/send_reminders.patch
+
+chmod 755 $startdir/pkg/data/srv/httpd/htdocs/webcal/tools/send_reminders.php
+
+
+}
+
diff --git a/abs/mv-core/webcal/config.php b/abs/mv-core/webcal/config.php
new file mode 100644
index 0000000..d803440
--- /dev/null
+++ b/abs/mv-core/webcal/config.php
@@ -0,0 +1,263 @@
+<?php
+/* This file loads configuration settings from the data file settings.php and
+ * sets up some needed variables.
+ *
+ * The settings.php file is created during installation using the web-based db
+ * setup page (install/index.php).
+ *
+ * <b>Note:</b>
+ * DO NOT EDIT THIS FILE!
+ *
+ *
+ * @author Craig Knudsen <cknudsen@cknudsen.com>
+ * @copyright Craig Knudsen, <cknudsen@cknudsen.com>, http://www.k5n.us/cknudsen
+ * @license http://www.gnu.org/licenses/gpl.html GNU GPL
+ * @version $Id: config.php,v 1.75.2.9 2008/02/17 02:21:25 cknudsen Exp $
+ * @package WebCalendar
+ */
+
+/* Prints a fatal error message to the user along with a link to the
+ * Troubleshooting section of the WebCalendar System Administrator's Guide.
+ *
+ * Execution is aborted.
+ *
+ * @param string  $error  The error message to display
+ * @internal We don't normally put functions in this file. But, since this
+ *           file is included before some of the others, this function either
+ *           goes here or we repeat this code in multiple files.
+ *           Additionally, we don't want to call too many external functions
+ *           from here since we could end up calling the function that called
+ *           this one.
+ * NOTES: Don't call translate from here.  This function if often called
+ * before translation stuff is initialized!
+ */
+function die_miserable_death ( $error ) {
+  global $APPLICATION_NAME, $LANGUAGE, $login, $TROUBLE_URL;
+  // Make sure app name is set.
+  $appStr = ( empty ( $APPLICATION_NAME ) ? 'WebCalendar' : $APPLICATION_NAME );
+
+  $h2_label = $appStr . ' ' . 'Error';
+  $title = $appStr . ': ' . 'Fatal Error';
+  $trouble_label = 'Troubleshooting Help';
+  $user_BGCOLOR = '#FFFFFF';
+
+  echo <<<EOT
+<html>
+  <head><title>{$title}</title></head>
+  <body bgcolor ="{$user_BGCOLOR}">
+    <h2>{$h2_label}</h2>
+    <p>{$error}</p><hr />
+    <p><a href="{$TROUBLE_URL}" target="_blank">{$trouble_label}</a></p>
+  </body>
+</html>
+EOT;
+  exit;
+}
+
+function db_error ( $doExit = false, $sql = '' ) {
+  global $settings;
+
+  $ret = str_replace ( 'XXX', dbi_error (), translate ( 'Database error XXX.' ) )
+   . ( ! empty ( $settings['mode'] ) && $settings['mode'] == 'dev' && !
+    empty ( $sql ) ? '<br />SQL:<br />' . $sql : '' );
+
+  if ( $doExit ) {
+    echo $ret;
+    exit;
+  } else
+    return $ret;
+}
+
+/**
+  * Get the full path to a file located in the webcalendar includes
+  * directory.
+  */
+function get_full_include_path ( $filename )
+{
+  if ( preg_match ( "/(.*)config.php/", __FILE__, $matches ) ) {
+    $fileLoc = $matches[1] . $filename;
+    return $fileLoc;
+  } else {
+    // Oops.  This file is not named config.php!
+    die_miserable_death ( "Crap!  Someone renamed config.php" );
+  }
+}
+
+function do_config ( $fileLoc ) {
+  global $db_database, $db_host, $db_login, $db_password, $db_persistent,
+  $db_type, $NONUSER_PREFIX, $phpdbiVerbose, $PROGRAM_DATE, $PROGRAM_NAME,
+  $PROGRAM_URL, $PROGRAM_VERSION, $readonly, $run_mode, $settings, $single_user,
+  $single_user_login, $TROUBLE_URL, $use_http_auth, $user_inc;
+
+  $PROGRAM_VERSION = 'v1.2.b1';
+  $PROGRAM_DATE = '25 Feb 2008';
+  $PROGRAM_NAME = 'WebCalendar ' . "$PROGRAM_VERSION ($PROGRAM_DATE)";
+  $PROGRAM_URL = 'http://www.k5n.us/webcalendar.php';
+  $TROUBLE_URL = 'docs/WebCalendar-SysAdmin.html#trouble';
+
+  // Open settings file to read.
+  $settings = array ();
+  if ( file_exists ( $fileLoc ) ) {
+    $fd = @fopen ( $fileLoc, 'rb', true );
+  }
+  if ( empty ( $fd ) && defined ( '__WC_INCLUDEDIR' ) ) {
+    $fd = @fopen ( __WC_INCLUDEDIR . '/settings.php', 'rb', true );
+    if ( $fd )
+      $fileLoc = __WC_INCLUDEDIR . '/settings.php';
+  }
+  // If still empty.... use __FILE__.
+  if ( empty ( $fd ) ) {
+    $testName = get_full_include_path ( "settings.php" );
+    $fd = @fopen ( $fileLoc, 'rb', true );
+    if ( $fd )
+      $fileLoc = $testName;
+  }
+  if ( empty ( $fd ) || filesize ( $fileLoc ) == 0 ) {
+    // There is no settings.php file.
+    // Redirect user to install page if it exists.
+    if ( file_exists ( 'install/index.php' ) ) {
+      header ( 'Location: install/index.php' );
+      exit;
+    } else
+      die_miserable_death (
+        translate ( 'Could not find settings.php file...' ) );
+  }
+
+  // We don't use fgets () since it seems to have problems with Mac-formatted
+  // text files. Instead, we read in the entire file, and split the lines manually.
+  $data = '';
+  while ( ! feof ( $fd ) ) {
+    $data .= fgets ( $fd, 4096 );
+  }
+  fclose ( $fd );
+
+  // Replace any combination of carriage return (\r) and new line (\n)
+  // with a single new line.
+  $data = preg_replace ( "/[\r\n]+/", "\n", $data );
+
+  // Split the data into lines.
+  $configLines = explode ( "\n", $data );
+
+  for ( $n = 0, $cnt = count ( $configLines ); $n < $cnt; $n++ ) {
+    $buffer = trim ( $configLines[$n], "\r\n " );
+    if ( preg_match ( '/^#|\/\*/', $buffer ) || // comments
+        preg_match ( '/^<\?/', $buffer ) || // start PHP code
+        preg_match ( '/^\?>/', $buffer ) ) // end PHP code
+      continue;
+    if ( preg_match ( '/(\S+):\s*(\S+)/', $buffer, $matches ) )
+      $settings[$matches[1]] = $matches[2];
+    // echo "settings $matches[1] => $matches[2]<br />";
+  }
+  $configLines = $data = '';
+
+  // Extract db settings into global vars.
+  $db_database = $settings['db_database'];
+  $db_host = $settings['db_host'];
+  $db_login = $settings['db_login'];
+  $db_password = $settings['db_password'];
+  $db_persistent = ( preg_match ( '/(1|yes|true|on)/i',
+      $settings['db_persistent'] ) ? '1' : '0' );
+  $db_type = $settings['db_type'];
+
+  // If no db settings, then user has likely started install but not yet
+  // completed.  So, send them back to the install script.
+  if ( empty ( $db_type ) ) {
+    if ( file_exists ( 'install/index.php' ) ) {
+      header ( 'Location: install/index.php' );
+      exit;
+    } else
+      die_miserable_death (
+        translate ( 'Incomplete settings.php file...' ) );
+  }
+
+  // Use 'db_cachedir' if found, otherwise look for 'cachedir'.
+  if ( ! empty ( $settings['db_cachedir'] ) )
+    dbi_init_cache ( $settings['db_cachedir'] );
+  else
+  if ( ! empty ( $settings['cachedir'] ) )
+    dbi_init_cache ( $settings['cachedir'] );
+
+  if ( ! empty ( $settings['db_debug'] ) &&
+      preg_match ( '/(1|true|yes|enable|on)/i', $settings['db_debug'] ) )
+    dbi_set_debug ( true );
+
+  foreach ( array ( 'db_type', 'db_host', 'db_login', 'db_password' ) as $s ) {
+    if ( empty ( $settings[$s] ) )
+      die_miserable_death ( str_replace ( 'XXX', $s,
+          translate ( 'Could not find XXX defined in...' ) ) );
+  }
+
+  // Allow special settings of 'none' in some settings[] values.
+  // This can be used for db servers not using TCP port for connection.
+  $db_host = ( $db_host == 'none' ? '' : $db_host );
+  $db_password = ( $db_password == 'none' ? '' : $db_password );
+
+  $readonly = preg_match ( '/(1|yes|true|on)/i',
+    $settings['readonly'] ) ? 'Y' : 'N';
+
+  if ( empty ( $settings['mode'] ) )
+    $settings['mode'] = 'prod';
+
+  $run_mode = ( preg_match ( '/(dev)/i', $settings['mode'] ) ? 'dev' : 'prod' );
+  $phpdbiVerbose = ( $run_mode == 'dev' ) ;
+  $single_user = preg_match ( '/(1|yes|true|on)/i',
+    $settings['single_user'] ) ? 'Y' : 'N';
+
+  if ( $single_user == 'Y' )
+    $single_user_login = $settings['single_user_login'];
+
+  if ( $single_user == 'Y' && empty ( $single_user_login ) )
+    die_miserable_death ( str_replace ( 'XXX', 'single_user_login',
+        translate ( 'You must define XXX in' ) ) );
+
+  $use_http_auth = ( preg_match ( '/(1|yes|true|on)/i',
+      $settings['use_http_auth'] ) ? true : false );
+
+  // Type of user authentication.
+  $user_inc = $settings['user_inc'];
+
+  // If sqlite, the db file is in the include directory
+  if ( $db_type == 'sqlite' )
+    $db_database = get_full_include_path ( $db_database );
+
+  // Check the current installation version.
+  // Redirect user to install page if it is different from stored value.
+  // This will prevent running WebCalendar until UPGRADING.html has been
+  // read and required upgrade actions completed.
+  $c = @dbi_connect ( $db_host, $db_login, $db_password, $db_database, false );
+  if ( $c ) {
+    $rows = dbi_get_cached_rows ( 'SELECT cal_value FROM webcal_config
+       WHERE cal_setting = \'WEBCAL_PROGRAM_VERSION\'' );
+    if ( ! $rows ) {
+      // &amp; does not work here...leave it as &.
+      header ( 'Location: install/index.php?action=mismatch&version=UNKNOWN' );
+      exit;
+    } else {
+      $row = $rows[0];
+      if ( empty ( $row ) || $row[0] != $PROGRAM_VERSION ) {
+        // &amp; does not work here...leave it as &.
+        header ( 'Location: install/index.php?action=mismatch&version='
+         . ( empty ( $row ) ? 'UNKNOWN' : $row[0] ) );
+        exit;
+      }
+    }
+    dbi_close ( $c );
+  } else { // Must mean we don't have a settings.php file.
+    // NOTE: if we get a connect error when running send_reminders.php,
+    // we may want to show that error message here.
+    // &amp; does not work here...leave it as &.
+    header ( 'Location: install/index.php?action=mismatch&version=UNKNOWN' );
+    exit;
+  }
+
+  // We can add extra 'nonuser' calendars such as a holiday, corporate,
+  // departmental, etc. We need a unique prefix for these calendars
+  // so we don't get them mixed up with real logins. This prefix should be
+  // a maximum of 5 characters and should NOT change once set!
+  $NONUSER_PREFIX = '_NUC_';
+
+  if ( $single_user != 'Y' )
+    $single_user_login = '';
+}
+
+?>
diff --git a/abs/mv-core/webcal/createdb.sql b/abs/mv-core/webcal/createdb.sql
new file mode 100644
index 0000000..e511483
--- /dev/null
+++ b/abs/mv-core/webcal/createdb.sql
@@ -0,0 +1,810 @@
+-- MySQL dump 10.11
+--
+-- Host: localhost    Database: webcal
+-- ------------------------------------------------------
+-- Server version	5.0.60
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `webcal_access_function`
+--
+
+DROP TABLE IF EXISTS `webcal_access_function`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_access_function` (
+  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_permissions` varchar(64) collate latin1_general_ci NOT NULL,
+  PRIMARY KEY  (`cal_login`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_access_function`
+--
+
+LOCK TABLES `webcal_access_function` WRITE;
+/*!40000 ALTER TABLE `webcal_access_function` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_access_function` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_access_user`
+--
+
+DROP TABLE IF EXISTS `webcal_access_user`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_access_user` (
+  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_other_user` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_can_view` int(11) NOT NULL default '0',
+  `cal_can_edit` int(11) NOT NULL default '0',
+  `cal_can_approve` int(11) NOT NULL default '0',
+  `cal_can_invite` char(1) collate latin1_general_ci default 'Y',
+  `cal_can_email` char(1) collate latin1_general_ci default 'Y',
+  `cal_see_time_only` char(1) collate latin1_general_ci default 'N',
+  PRIMARY KEY  (`cal_login`,`cal_other_user`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_access_user`
+--
+
+LOCK TABLES `webcal_access_user` WRITE;
+/*!40000 ALTER TABLE `webcal_access_user` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_access_user` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_asst`
+--
+
+DROP TABLE IF EXISTS `webcal_asst`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_asst` (
+  `cal_boss` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_assistant` varchar(25) collate latin1_general_ci NOT NULL,
+  PRIMARY KEY  (`cal_boss`,`cal_assistant`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_asst`
+--
+
+LOCK TABLES `webcal_asst` WRITE;
+/*!40000 ALTER TABLE `webcal_asst` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_asst` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_blob`
+--
+
+DROP TABLE IF EXISTS `webcal_blob`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_blob` (
+  `cal_blob_id` int(11) NOT NULL,
+  `cal_id` int(11) default NULL,
+  `cal_login` varchar(25) collate latin1_general_ci default NULL,
+  `cal_name` varchar(30) collate latin1_general_ci default NULL,
+  `cal_description` varchar(128) collate latin1_general_ci default NULL,
+  `cal_size` int(11) default NULL,
+  `cal_mime_type` varchar(50) collate latin1_general_ci default NULL,
+  `cal_type` char(1) collate latin1_general_ci NOT NULL,
+  `cal_mod_date` int(11) NOT NULL,
+  `cal_mod_time` int(11) NOT NULL,
+  `cal_blob` longblob,
+  PRIMARY KEY  (`cal_blob_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_blob`
+--
+
+LOCK TABLES `webcal_blob` WRITE;
+/*!40000 ALTER TABLE `webcal_blob` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_blob` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_categories`
+--
+
+DROP TABLE IF EXISTS `webcal_categories`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_categories` (
+  `cat_id` int(11) NOT NULL,
+  `cat_owner` varchar(25) collate latin1_general_ci default NULL,
+  `cat_name` varchar(80) collate latin1_general_ci NOT NULL,
+  `cat_color` varchar(8) collate latin1_general_ci default NULL,
+  PRIMARY KEY  (`cat_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_categories`
+--
+
+LOCK TABLES `webcal_categories` WRITE;
+/*!40000 ALTER TABLE `webcal_categories` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_categories` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_config`
+--
+
+DROP TABLE IF EXISTS `webcal_config`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_config` (
+  `cal_setting` varchar(50) collate latin1_general_ci NOT NULL,
+  `cal_value` varchar(100) collate latin1_general_ci default NULL,
+  PRIMARY KEY  (`cal_setting`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_config`
+--
+
+LOCK TABLES `webcal_config` WRITE;
+/*!40000 ALTER TABLE `webcal_config` DISABLE KEYS */;
+INSERT INTO `webcal_config` VALUES ('SERVER_URL','http://vmtest/webcal/'),('APPLICATION_NAME','Title'),('ADD_LINK_IN_VIEWS','N'),('ADMIN_OVERRIDE_UAC','Y'),('ALLOW_ATTACH','N'),('ALLOW_ATTACH_ANY','N'),('ALLOW_ATTACH_PART','N'),('ALLOW_COLOR_CUSTOMIZATION','Y'),('ALLOW_COMMENTS','N'),('ALLOW_COMMENTS_ANY','N'),('ALLOW_COMMENTS_PART','N'),('ALLOW_CONFLICT_OVERRIDE','Y'),('ALLOW_CONFLICTS','N'),('ALLOW_EXTERNAL_HEADER','N'),('ALLOW_EXTERNAL_USERS','N'),('ALLOW_HTML_DESCRIPTION','Y'),('ALLOW_SELF_REGISTRATION','N'),('ALLOW_USER_HEADER','N'),('ALLOW_USER_THEMES','Y'),('ALLOW_VIEW_OTHER','Y'),('APPROVE_ASSISTANT_EVENT','Y'),('AUTO_REFRESH','N'),('AUTO_REFRESH_TIME','0'),('BGCOLOR','#FFFFFF'),('BGIMAGE',''),('BGREPEAT','repeat fixed center'),('BOLD_DAYS_IN_YEAR','Y'),('CAPTIONS','#B04040'),('CATEGORIES_ENABLED','Y'),('CELLBG','#C0C0C0'),('CONFLICT_REPEAT_MONTHS','6'),('CUSTOM_HEADER','N'),('CUSTOM_SCRIPT','N'),('CUSTOM_TRAILER','N'),('DATE_FORMAT','LANGUAGE_DEFINED'),('DATE_FORMAT_MD','LANGUAGE_DEFINED'),('DATE_FORMAT_MY','LANGUAGE_DEFINED'),('DATE_FORMAT_TASK','LANGUAGE_DEFINED'),('DEMO_MODE','N'),('DISABLE_ACCESS_FIELD','N'),('DISABLE_CROSSDAY_EVENTS','N'),('DISABLE_LOCATION_FIELD','N'),('DISABLE_PARTICIPANTS_FIELD','N'),('DISABLE_POPUPS','N'),('DISABLE_PRIORITY_FIELD','N'),('DISABLE_REMINDER_FIELD','N'),('DISABLE_REPEATING_FIELD','N'),('DISABLE_URL_FIELD','Y'),('DISPLAY_ALL_DAYS_IN_MONTH','N'),('DISPLAY_CREATED_BYPROXY','Y'),('DISPLAY_DESC_PRINT_DAY','Y'),('DISPLAY_END_TIMES','N'),('DISPLAY_LOCATION','N'),('DISPLAY_LONG_DAYS','N'),('DISPLAY_MINUTES','N'),('DISPLAY_MOON_PHASES','N'),('DISPLAY_SM_MONTH','Y'),('DISPLAY_TASKS','N'),('DISPLAY_TASKS_IN_GRID','N'),('DISPLAY_UNAPPROVED','Y'),('DISPLAY_WEEKENDS','Y'),('DISPLAY_WEEKNUMBER','Y'),('EMAIL_ASSISTANT_EVENTS','Y'),('EMAIL_EVENT_ADDED','Y'),('EMAIL_EVENT_CREATE','N'),('EMAIL_EVENT_DELETED','Y'),('EMAIL_EVENT_REJECTED','Y'),('EMAIL_EVENT_UPDATED','Y'),('EMAIL_FALLBACK_FROM','youremailhere'),('EMAIL_HTML','N'),('EMAIL_MAILER','mail'),('EMAIL_REMINDER','Y'),('ENABLE_CAPTCHA','N'),('ENABLE_GRADIENTS','N'),('ENABLE_ICON_UPLOADS','N'),('ENTRY_SLOTS','144'),('EXTERNAL_NOTIFICATIONS','N'),('EXTERNAL_REMINDERS','N'),('FONTS','Arial, Helvetica, sans-serif'),('FREEBUSY_ENABLED','N'),('GENERAL_USE_GMT','Y'),('GROUPS_ENABLED','N'),('H2COLOR','#000000'),('HASEVENTSBG','#FFFF33'),('IMPORT_CATEGORIES','Y'),('LANGUAGE','none'),('LIMIT_APPTS','N'),('LIMIT_APPTS_NUMBER','6'),('LIMIT_DESCRIPTION_SIZE','N'),('MENU_DATE_TOP','Y'),('MENU_ENABLED','Y'),('MENU_THEME','default'),('MYEVENTS','#006000'),('NONUSER_AT_TOP','Y'),('NONUSER_ENABLED','Y'),('OTHERMONTHBG','#D0D0D0'),('OVERRIDE_PUBLIC','N'),('OVERRIDE_PUBLIC_TEXT','Not available'),('PARTICIPANTS_IN_POPUP','N'),('PLUGINS_ENABLED','N'),('POPUP_BG','#FFFFFF'),('POPUP_FG','#000000'),('PUBLIC_ACCESS','N'),('PUBLIC_ACCESS_ADD_NEEDS_APPROVAL','N'),('PUBLIC_ACCESS_CAN_ADD','N'),('PUBLIC_ACCESS_DEFAULT_SELECTED','N'),('PUBLIC_ACCESS_DEFAULT_VISIBLE','N'),('PUBLIC_ACCESS_OTHERS','Y'),('PUBLIC_ACCESS_VIEW_PART','N'),('PUBLISH_ENABLED','Y'),('PULLDOWN_WEEKNUMBER','N'),('REMEMBER_LAST_LOGIN','N'),('REMINDER_DEFAULT','N'),('REMINDER_OFFSET','240'),('REMINDER_WITH_DATE','N'),('REMOTES_ENABLED','N'),('REPORTS_ENABLED','N'),('REQUIRE_APPROVALS','Y'),('RSS_ENABLED','N'),('SELF_REGISTRATION_BLACKLIST','N'),('SELF_REGISTRATION_FULL','Y'),('SEND_EMAIL','N'),('SERVER_TIMEZONE','America/New_York'),('SITE_EXTRAS_IN_POPUP','N'),('SMTP_AUTH','N'),('SMTP_HOST','localhost'),('SMTP_PASSWORD',''),('SMTP_PORT','25'),('SMTP_USERNAME',''),('STARTVIEW','month.php'),('SUMMARY_LENGTH','80'),('TABLEBG','#000000'),('TEXTCOLOR','#000000'),('THBG','#FFFFFF'),('THFG','#000000'),('TIME_FORMAT','12'),('TIME_SLOTS','24'),('TIME_SPACER','&raquo;&nbsp;'),('TIMED_EVT_LEN','D'),('TIMEZONE','America/New_York'),('TODAYCELLBG','#FFFF33'),('UAC_ENABLED','N'),('USER_PUBLISH_ENABLED','Y'),('USER_PUBLISH_RW_ENABLED','Y'),('USER_RSS_ENABLED','N'),('USER_SEES_ONLY_HIS_GROUPS','Y'),('USER_SORT_ORDER','cal_lastname, cal_firstname'),('WEBCAL_PROGRAM_VERSION','v1.2.b1'),('WEEK_START','0'),('WEEKEND_START','6'),('WEEKENDBG','#D0D0D0'),('WEEKNUMBER','#FF6633'),('WORK_DAY_END_HOUR','17'),('WORK_DAY_START_HOUR','8');
+/*!40000 ALTER TABLE `webcal_config` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_entry`
+--
+
+DROP TABLE IF EXISTS `webcal_entry`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_entry` (
+  `cal_id` int(11) NOT NULL,
+  `cal_group_id` int(11) default NULL,
+  `cal_ext_for_id` int(11) default NULL,
+  `cal_create_by` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_date` int(11) NOT NULL,
+  `cal_time` int(11) default NULL,
+  `cal_mod_date` int(11) default NULL,
+  `cal_mod_time` int(11) default NULL,
+  `cal_duration` int(11) NOT NULL,
+  `cal_due_date` int(11) default NULL,
+  `cal_due_time` int(11) default NULL,
+  `cal_priority` int(11) default '5',
+  `cal_type` char(1) collate latin1_general_ci default 'E',
+  `cal_access` char(1) collate latin1_general_ci default 'P',
+  `cal_name` varchar(80) collate latin1_general_ci NOT NULL,
+  `cal_location` varchar(100) collate latin1_general_ci default NULL,
+  `cal_url` varchar(100) collate latin1_general_ci default NULL,
+  `cal_completed` int(11) default NULL,
+  `cal_description` text collate latin1_general_ci,
+  PRIMARY KEY  (`cal_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_entry`
+--
+
+LOCK TABLES `webcal_entry` WRITE;
+/*!40000 ALTER TABLE `webcal_entry` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_entry` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_entry_categories`
+--
+
+DROP TABLE IF EXISTS `webcal_entry_categories`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_entry_categories` (
+  `cal_id` int(11) NOT NULL default '0',
+  `cat_id` int(11) NOT NULL default '0',
+  `cat_order` int(11) NOT NULL default '0',
+  `cat_owner` varchar(25) collate latin1_general_ci default NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_entry_categories`
+--
+
+LOCK TABLES `webcal_entry_categories` WRITE;
+/*!40000 ALTER TABLE `webcal_entry_categories` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_entry_categories` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_entry_ext_user`
+--
+
+DROP TABLE IF EXISTS `webcal_entry_ext_user`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_entry_ext_user` (
+  `cal_id` int(11) NOT NULL default '0',
+  `cal_fullname` varchar(50) collate latin1_general_ci NOT NULL,
+  `cal_email` varchar(75) collate latin1_general_ci default NULL,
+  PRIMARY KEY  (`cal_id`,`cal_fullname`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_entry_ext_user`
+--
+
+LOCK TABLES `webcal_entry_ext_user` WRITE;
+/*!40000 ALTER TABLE `webcal_entry_ext_user` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_entry_ext_user` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_entry_log`
+--
+
+DROP TABLE IF EXISTS `webcal_entry_log`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_entry_log` (
+  `cal_log_id` int(11) NOT NULL,
+  `cal_entry_id` int(11) NOT NULL,
+  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_user_cal` varchar(25) collate latin1_general_ci default NULL,
+  `cal_type` char(1) collate latin1_general_ci NOT NULL,
+  `cal_date` int(11) NOT NULL,
+  `cal_time` int(11) default NULL,
+  `cal_text` text collate latin1_general_ci,
+  PRIMARY KEY  (`cal_log_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_entry_log`
+--
+
+LOCK TABLES `webcal_entry_log` WRITE;
+/*!40000 ALTER TABLE `webcal_entry_log` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_entry_log` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_entry_repeats`
+--
+
+DROP TABLE IF EXISTS `webcal_entry_repeats`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_entry_repeats` (
+  `cal_id` int(11) NOT NULL default '0',
+  `cal_type` varchar(20) collate latin1_general_ci default NULL,
+  `cal_end` int(11) default NULL,
+  `cal_endtime` int(11) default NULL,
+  `cal_frequency` int(11) default '1',
+  `cal_days` char(7) collate latin1_general_ci default NULL,
+  `cal_bymonth` varchar(50) collate latin1_general_ci default NULL,
+  `cal_bymonthday` varchar(100) collate latin1_general_ci default NULL,
+  `cal_byday` varchar(100) collate latin1_general_ci default NULL,
+  `cal_bysetpos` varchar(50) collate latin1_general_ci default NULL,
+  `cal_byweekno` varchar(50) collate latin1_general_ci default NULL,
+  `cal_byyearday` varchar(50) collate latin1_general_ci default NULL,
+  `cal_wkst` char(2) collate latin1_general_ci default 'MO',
+  `cal_count` int(11) default NULL,
+  PRIMARY KEY  (`cal_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_entry_repeats`
+--
+
+LOCK TABLES `webcal_entry_repeats` WRITE;
+/*!40000 ALTER TABLE `webcal_entry_repeats` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_entry_repeats` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_entry_repeats_not`
+--
+
+DROP TABLE IF EXISTS `webcal_entry_repeats_not`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_entry_repeats_not` (
+  `cal_id` int(11) NOT NULL,
+  `cal_date` int(11) NOT NULL,
+  `cal_exdate` int(1) NOT NULL default '1',
+  PRIMARY KEY  (`cal_id`,`cal_date`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_entry_repeats_not`
+--
+
+LOCK TABLES `webcal_entry_repeats_not` WRITE;
+/*!40000 ALTER TABLE `webcal_entry_repeats_not` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_entry_repeats_not` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_entry_user`
+--
+
+DROP TABLE IF EXISTS `webcal_entry_user`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_entry_user` (
+  `cal_id` int(11) NOT NULL default '0',
+  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_status` char(1) collate latin1_general_ci default 'A',
+  `cal_category` int(11) default NULL,
+  `cal_percent` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`cal_id`,`cal_login`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_entry_user`
+--
+
+LOCK TABLES `webcal_entry_user` WRITE;
+/*!40000 ALTER TABLE `webcal_entry_user` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_entry_user` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_group`
+--
+
+DROP TABLE IF EXISTS `webcal_group`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_group` (
+  `cal_group_id` int(11) NOT NULL,
+  `cal_owner` varchar(25) collate latin1_general_ci default NULL,
+  `cal_name` varchar(50) collate latin1_general_ci NOT NULL,
+  `cal_last_update` int(11) NOT NULL,
+  PRIMARY KEY  (`cal_group_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_group`
+--
+
+LOCK TABLES `webcal_group` WRITE;
+/*!40000 ALTER TABLE `webcal_group` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_group` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_group_user`
+--
+
+DROP TABLE IF EXISTS `webcal_group_user`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_group_user` (
+  `cal_group_id` int(11) NOT NULL,
+  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
+  PRIMARY KEY  (`cal_group_id`,`cal_login`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_group_user`
+--
+
+LOCK TABLES `webcal_group_user` WRITE;
+/*!40000 ALTER TABLE `webcal_group_user` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_group_user` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_import`
+--
+
+DROP TABLE IF EXISTS `webcal_import`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_import` (
+  `cal_import_id` int(11) NOT NULL,
+  `cal_name` varchar(50) collate latin1_general_ci default NULL,
+  `cal_date` int(11) NOT NULL,
+  `cal_type` varchar(10) collate latin1_general_ci NOT NULL,
+  `cal_login` varchar(25) collate latin1_general_ci default NULL,
+  PRIMARY KEY  (`cal_import_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_import`
+--
+
+LOCK TABLES `webcal_import` WRITE;
+/*!40000 ALTER TABLE `webcal_import` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_import` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_import_data`
+--
+
+DROP TABLE IF EXISTS `webcal_import_data`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_import_data` (
+  `cal_import_id` int(11) NOT NULL,
+  `cal_id` int(11) NOT NULL,
+  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_import_type` varchar(15) collate latin1_general_ci NOT NULL,
+  `cal_external_id` varchar(200) collate latin1_general_ci default NULL,
+  PRIMARY KEY  (`cal_id`,`cal_login`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_import_data`
+--
+
+LOCK TABLES `webcal_import_data` WRITE;
+/*!40000 ALTER TABLE `webcal_import_data` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_import_data` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_nonuser_cals`
+--
+
+DROP TABLE IF EXISTS `webcal_nonuser_cals`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_nonuser_cals` (
+  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_lastname` varchar(25) collate latin1_general_ci default NULL,
+  `cal_firstname` varchar(25) collate latin1_general_ci default NULL,
+  `cal_admin` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_is_public` char(1) collate latin1_general_ci NOT NULL default 'N',
+  `cal_url` varchar(255) collate latin1_general_ci default NULL,
+  PRIMARY KEY  (`cal_login`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_nonuser_cals`
+--
+
+LOCK TABLES `webcal_nonuser_cals` WRITE;
+/*!40000 ALTER TABLE `webcal_nonuser_cals` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_nonuser_cals` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_reminders`
+--
+
+DROP TABLE IF EXISTS `webcal_reminders`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_reminders` (
+  `cal_id` int(11) NOT NULL default '0',
+  `cal_date` int(11) NOT NULL default '0',
+  `cal_offset` int(11) NOT NULL default '0',
+  `cal_related` char(1) collate latin1_general_ci NOT NULL default 'S',
+  `cal_before` char(1) collate latin1_general_ci NOT NULL default 'Y',
+  `cal_last_sent` int(11) NOT NULL default '0',
+  `cal_repeats` int(11) NOT NULL default '0',
+  `cal_duration` int(11) NOT NULL default '0',
+  `cal_times_sent` int(11) NOT NULL default '0',
+  `cal_action` varchar(12) collate latin1_general_ci NOT NULL default 'EMAIL',
+  PRIMARY KEY  (`cal_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_reminders`
+--
+
+LOCK TABLES `webcal_reminders` WRITE;
+/*!40000 ALTER TABLE `webcal_reminders` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_reminders` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_report`
+--
+
+DROP TABLE IF EXISTS `webcal_report`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_report` (
+  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_report_id` int(11) NOT NULL,
+  `cal_is_global` char(1) collate latin1_general_ci NOT NULL default 'N',
+  `cal_report_type` varchar(20) collate latin1_general_ci NOT NULL,
+  `cal_include_header` char(1) collate latin1_general_ci NOT NULL default 'Y',
+  `cal_report_name` varchar(50) collate latin1_general_ci NOT NULL,
+  `cal_time_range` int(11) NOT NULL,
+  `cal_user` varchar(25) collate latin1_general_ci default NULL,
+  `cal_allow_nav` char(1) collate latin1_general_ci default 'Y',
+  `cal_cat_id` int(11) default NULL,
+  `cal_include_empty` char(1) collate latin1_general_ci default 'N',
+  `cal_show_in_trailer` char(1) collate latin1_general_ci default 'N',
+  `cal_update_date` int(11) NOT NULL,
+  PRIMARY KEY  (`cal_report_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_report`
+--
+
+LOCK TABLES `webcal_report` WRITE;
+/*!40000 ALTER TABLE `webcal_report` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_report` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_report_template`
+--
+
+DROP TABLE IF EXISTS `webcal_report_template`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_report_template` (
+  `cal_report_id` int(11) NOT NULL,
+  `cal_template_type` char(1) collate latin1_general_ci NOT NULL,
+  `cal_template_text` text collate latin1_general_ci,
+  PRIMARY KEY  (`cal_report_id`,`cal_template_type`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_report_template`
+--
+
+LOCK TABLES `webcal_report_template` WRITE;
+/*!40000 ALTER TABLE `webcal_report_template` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_report_template` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_site_extras`
+--
+
+DROP TABLE IF EXISTS `webcal_site_extras`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_site_extras` (
+  `cal_id` int(11) NOT NULL default '0',
+  `cal_name` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_type` int(11) NOT NULL,
+  `cal_date` int(11) default '0',
+  `cal_remind` int(11) default '0',
+  `cal_data` text collate latin1_general_ci
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_site_extras`
+--
+
+LOCK TABLES `webcal_site_extras` WRITE;
+/*!40000 ALTER TABLE `webcal_site_extras` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_site_extras` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_timezones`
+--
+
+DROP TABLE IF EXISTS `webcal_timezones`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_timezones` (
+  `tzid` varchar(100) collate latin1_general_ci NOT NULL default '',
+  `dtstart` varchar(25) collate latin1_general_ci default NULL,
+  `dtend` varchar(25) collate latin1_general_ci default NULL,
+  `vtimezone` text collate latin1_general_ci,
+  PRIMARY KEY  (`tzid`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_timezones`
+--
+
+LOCK TABLES `webcal_timezones` WRITE;
+/*!40000 ALTER TABLE `webcal_timezones` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_timezones` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_user`
+--
+
+DROP TABLE IF EXISTS `webcal_user`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_user` (
+  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_passwd` varchar(32) collate latin1_general_ci default NULL,
+  `cal_lastname` varchar(25) collate latin1_general_ci default NULL,
+  `cal_firstname` varchar(25) collate latin1_general_ci default NULL,
+  `cal_is_admin` char(1) collate latin1_general_ci default 'N',
+  `cal_email` varchar(75) collate latin1_general_ci default NULL,
+  `cal_enabled` char(1) collate latin1_general_ci default 'Y',
+  `cal_telephone` varchar(50) collate latin1_general_ci default NULL,
+  `cal_address` varchar(75) collate latin1_general_ci default NULL,
+  `cal_title` varchar(75) collate latin1_general_ci default NULL,
+  `cal_birthday` int(11) default NULL,
+  `cal_last_login` int(11) default NULL,
+  PRIMARY KEY  (`cal_login`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_user`
+--
+
+LOCK TABLES `webcal_user` WRITE;
+/*!40000 ALTER TABLE `webcal_user` DISABLE KEYS */;
+INSERT INTO `webcal_user` VALUES ('Me','318b2739ddc2c16c97b33c9b04b79f3e',NULL,NULL,'Y',NULL,'Y',NULL,NULL,NULL,NULL,NULL);
+/*!40000 ALTER TABLE `webcal_user` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_user_layers`
+--
+
+DROP TABLE IF EXISTS `webcal_user_layers`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_user_layers` (
+  `cal_layerid` int(11) NOT NULL default '0',
+  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_layeruser` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_color` varchar(25) collate latin1_general_ci default NULL,
+  `cal_dups` char(1) collate latin1_general_ci default 'N',
+  PRIMARY KEY  (`cal_login`,`cal_layeruser`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_user_layers`
+--
+
+LOCK TABLES `webcal_user_layers` WRITE;
+/*!40000 ALTER TABLE `webcal_user_layers` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_user_layers` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_user_pref`
+--
+
+DROP TABLE IF EXISTS `webcal_user_pref`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_user_pref` (
+  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_setting` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_value` varchar(100) collate latin1_general_ci default NULL,
+  PRIMARY KEY  (`cal_login`,`cal_setting`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_user_pref`
+--
+
+LOCK TABLES `webcal_user_pref` WRITE;
+/*!40000 ALTER TABLE `webcal_user_pref` DISABLE KEYS */;
+INSERT INTO `webcal_user_pref` VALUES ('Me','LANGUAGE','none'),('Me','TIMEZONE','America/New_York'),('Me','DATE_FORMAT','LANGUAGE_DEFINED'),('Me','DATE_FORMAT_MY','LANGUAGE_DEFINED'),('Me','DATE_FORMAT_MD','LANGUAGE_DEFINED'),('Me','DATE_FORMAT_TASK','LANGUAGE_DEFINED'),('Me','TIME_FORMAT','12'),('Me','WEEK_START','0'),('Me','WEEKEND_START','6'),('Me','WORK_DAY_START_HOUR','8'),('Me','WORK_DAY_END_HOUR','17'),('Me','STARTVIEW','month.php'),('Me','FONTS','Arial, Helvetica, sans-serif'),('Me','DISPLAY_SM_MONTH','N'),('Me','DISPLAY_WEEKENDS','Y'),('Me','DISPLAY_LONG_DAYS','N'),('Me','DISPLAY_MINUTES','N'),('Me','DISPLAY_END_TIMES','N'),('Me','DISPLAY_ALL_DAYS_IN_MONTH','N'),('Me','DISPLAY_WEEKNUMBER','Y'),('Me','DISPLAY_TASKS','N'),('Me','DISPLAY_TASKS_IN_GRID','N'),('Me','DISPLAY_MOON_PHASES','N'),('Me','DISPLAY_UNAPPROVED','Y'),('Me','TIMED_EVT_LEN','D'),('Me','CATEGORY_VIEW','0'),('Me','DISABLE_CROSSDAY_EVENTS','N'),('Me','DISPLAY_DESC_PRINT_DAY','Y'),('Me','ENTRY_SLOTS','144'),('Me','TIME_SLOTS','24'),('Me','AUTO_REFRESH','N'),('Me','AUTO_REFRESH_TIME','0'),('Me','THEME','none'),('Me','MENU_THEME','default'),('Me','APPROVE_ASSISTANT_EVENT','Y'),('Me','DISPLAY_CREATED_BYPROXY','Y'),('Me','USER_REMOTE_ACCESS','0'),('Me','USER_PUBLISH_ENABLED','Y'),('Me','USER_PUBLISH_RW_ENABLED','Y'),('Me','FREEBUSY_ENABLED','N'),('Me','BGCOLOR','#FFFFFF'),('Me','H2COLOR','#000000'),('Me','TEXTCOLOR','#000000'),('Me','MYEVENTS','#006000'),('Me','TABLEBG','#000000'),('Me','THBG','#FFFFFF'),('Me','THFG','#000000'),('Me','CELLBG','#C0C0C0'),('Me','TODAYCELLBG','#FFFF33'),('Me','HASEVENTSBG','#FFFF33'),('Me','WEEKENDBG','#D0D0D0'),('Me','OTHERMONTHBG','#D0D0D0'),('Me','WEEKNUMBER','#FF6633'),('Me','POPUP_BG','#FFFFFF'),('Me','POPUP_FG','#000000');
+/*!40000 ALTER TABLE `webcal_user_pref` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_user_template`
+--
+
+DROP TABLE IF EXISTS `webcal_user_template`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_user_template` (
+  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_type` char(1) collate latin1_general_ci NOT NULL,
+  `cal_template_text` text collate latin1_general_ci,
+  PRIMARY KEY  (`cal_login`,`cal_type`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_user_template`
+--
+
+LOCK TABLES `webcal_user_template` WRITE;
+/*!40000 ALTER TABLE `webcal_user_template` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_user_template` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_view`
+--
+
+DROP TABLE IF EXISTS `webcal_view`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_view` (
+  `cal_view_id` int(11) NOT NULL,
+  `cal_owner` varchar(25) collate latin1_general_ci NOT NULL,
+  `cal_name` varchar(50) collate latin1_general_ci NOT NULL,
+  `cal_view_type` char(1) collate latin1_general_ci default NULL,
+  `cal_is_global` char(1) collate latin1_general_ci NOT NULL default 'N',
+  PRIMARY KEY  (`cal_view_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_view`
+--
+
+LOCK TABLES `webcal_view` WRITE;
+/*!40000 ALTER TABLE `webcal_view` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_view` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `webcal_view_user`
+--
+
+DROP TABLE IF EXISTS `webcal_view_user`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `webcal_view_user` (
+  `cal_view_id` int(11) NOT NULL,
+  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
+  PRIMARY KEY  (`cal_view_id`,`cal_login`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `webcal_view_user`
+--
+
+LOCK TABLES `webcal_view_user` WRITE;
+/*!40000 ALTER TABLE `webcal_view_user` DISABLE KEYS */;
+/*!40000 ALTER TABLE `webcal_view_user` ENABLE KEYS */;
+UNLOCK TABLES;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2008-08-04 17:58:18
diff --git a/abs/mv-core/webcal/posix.tab b/abs/mv-core/webcal/posix.tab
new file mode 100644
index 0000000..ca20ef0
--- /dev/null
+++ b/abs/mv-core/webcal/posix.tab
@@ -0,0 +1,586 @@
+-	 - 	
+-	 - 	Europe
+-	 - 	Europe/Belfast
+-	 - 	Europe/Paris
+-	 - 	Europe/Bratislava
+-	 - 	Europe/Monaco
+-	 - 	Europe/Vilnius
+-	 - 	Europe/Skopje
+-	 - 	Europe/Chisinau
+-	 - 	Europe/Nicosia
+-	 - 	Europe/Rome
+-	 - 	Europe/Gibraltar
+-	 - 	Europe/Sarajevo
+-	 - 	Europe/Budapest
+-	 - 	Europe/Moscow
+-	 - 	Europe/Ljubljana
+-	 - 	Europe/Copenhagen
+-	 - 	Europe/London
+-	 - 	Europe/Simferopol
+-	 - 	Europe/Andorra
+-	 - 	Europe/Guernsey
+-	 - 	Europe/Volgograd
+-	 - 	Europe/Mariehamn
+-	 - 	Europe/Luxembourg
+-	 - 	Europe/Amsterdam
+-	 - 	Europe/Jersey
+-	 - 	Europe/Athens
+-	 - 	Europe/Oslo
+-	 - 	Europe/Lisbon
+-	 - 	Europe/Istanbul
+-	 - 	Europe/Kiev
+-	 - 	Europe/Malta
+-	 - 	Europe/Helsinki
+-	 - 	Europe/Kaliningrad
+-	 - 	Europe/Bucharest
+-	 - 	Europe/Zaporozhye
+-	 - 	Europe/Madrid
+-	 - 	Europe/Dublin
+-	 - 	Europe/Vaduz
+-	 - 	Europe/Brussels
+-	 - 	Europe/Sofia
+-	 - 	Europe/Riga
+-	 - 	Europe/Podgorica
+-	 - 	Europe/Tiraspol
+-	 - 	Europe/Warsaw
+-	 - 	Europe/Isle_of_Man
+-	 - 	Europe/Stockholm
+-	 - 	Europe/Tallinn
+-	 - 	Europe/Zurich
+-	 - 	Europe/Berlin
+-	 - 	Europe/Tirane
+-	 - 	Europe/Prague
+-	 - 	Europe/Uzhgorod
+-	 - 	Europe/Vienna
+-	 - 	Europe/Vatican
+-	 - 	Europe/Zagreb
+-	 - 	Europe/Samara
+-	 - 	Europe/San_Marino
+-	 - 	Europe/Minsk
+-	 - 	Europe/Belgrade
+-	 - 	EST5EDT
+-	 - 	Chile
+-	 - 	Chile/EasterIsland
+-	 - 	Chile/Continental
+-	 - 	NZ
+-	 - 	CST6CDT
+-	 - 	GB
+-	 - 	Etc
+-	 - 	Etc/GMT+6
+-	 - 	Etc/GMT-1
+-	 - 	Etc/GMT-3
+-	 - 	Etc/GMT-9
+-	 - 	Etc/GMT0
+-	 - 	Etc/GMT-8
+-	 - 	Etc/GMT+1
+-	 - 	Etc/GMT-12
+-	 - 	Etc/Greenwich
+-	 - 	Etc/GMT-0
+-	 - 	Etc/GMT-11
+-	 - 	Etc/GMT+5
+-	 - 	Etc/Universal
+-	 - 	Etc/GMT+0
+-	 - 	Etc/GMT-7
+-	 - 	Etc/GMT-10
+-	 - 	Etc/GMT-13
+-	 - 	Etc/UTC
+-	 - 	Etc/GMT-14
+-	 - 	Etc/UCT
+-	 - 	Etc/GMT-5
+-	 - 	Etc/GMT-6
+-	 - 	Etc/GMT+4
+-	 - 	Etc/GMT+7
+-	 - 	Etc/GMT+8
+-	 - 	Etc/GMT+12
+-	 - 	Etc/GMT+10
+-	 - 	Etc/GMT
+-	 - 	Etc/GMT-2
+-	 - 	Etc/GMT+9
+-	 - 	Etc/GMT-4
+-	 - 	Etc/GMT+2
+-	 - 	Etc/GMT+3
+-	 - 	Etc/GMT+11
+-	 - 	Etc/Zulu
+-	 - 	GMT0
+-	 - 	Asia
+-	 - 	Asia/Kuala_Lumpur
+-	 - 	Asia/Macao
+-	 - 	Asia/Dushanbe
+-	 - 	Asia/Pontianak
+-	 - 	Asia/Katmandu
+-	 - 	Asia/Rangoon
+-	 - 	Asia/Saigon
+-	 - 	Asia/Oral
+-	 - 	Asia/Bishkek
+-	 - 	Asia/Dacca
+-	 - 	Asia/Brunei
+-	 - 	Asia/Baku
+-	 - 	Asia/Kamchatka
+-	 - 	Asia/Kuching
+-	 - 	Asia/Ashgabat
+-	 - 	Asia/Riyadh
+-	 - 	Asia/Almaty
+-	 - 	Asia/Nicosia
+-	 - 	Asia/Magadan
+-	 - 	Asia/Ulan_Bator
+-	 - 	Asia/Omsk
+-	 - 	Asia/Colombo
+-	 - 	Asia/Novosibirsk
+-	 - 	Asia/Manila
+-	 - 	Asia/Tehran
+-	 - 	Asia/Gaza
+-	 - 	Asia/Hovd
+-	 - 	Asia/Kashgar
+-	 - 	Asia/Yerevan
+-	 - 	Asia/Chungking
+-	 - 	Asia/Vladivostok
+-	 - 	Asia/Bahrain
+-	 - 	Asia/Qatar
+-	 - 	Asia/Tashkent
+-	 - 	Asia/Calcutta
+-	 - 	Asia/Kuwait
+-	 - 	Asia/Anadyr
+-	 - 	Asia/Thimphu
+-	 - 	Asia/Aqtobe
+-	 - 	Asia/Macau
+-	 - 	Asia/Vientiane
+-	 - 	Asia/Ashkhabad
+-	 - 	Asia/Kolkata
+-	 - 	Asia/Makassar
+-	 - 	Asia/Pyongyang
+-	 - 	Asia/Damascus
+-	 - 	Asia/Bangkok
+-	 - 	Asia/Dili
+-	 - 	Asia/Kabul
+-	 - 	Asia/Ho_Chi_Minh
+-	 - 	Asia/Riyadh87
+-	 - 	Asia/Harbin
+-	 - 	Asia/Shanghai
+-	 - 	Asia/Istanbul
+-	 - 	Asia/Tbilisi
+-	 - 	Asia/Karachi
+-	 - 	Asia/Amman
+-	 - 	Asia/Jakarta
+-	 - 	Asia/Dhaka
+-	 - 	Asia/Tel_Aviv
+-	 - 	Asia/Chongqing
+-	 - 	Asia/Riyadh88
+-	 - 	Asia/Ujung_Pandang
+-	 - 	Asia/Ulaanbaatar
+-	 - 	Asia/Dubai
+-	 - 	Asia/Singapore
+-	 - 	Asia/Taipei
+-	 - 	Asia/Jayapura
+-	 - 	Asia/Thimbu
+-	 - 	Asia/Qyzylorda
+-	 - 	Asia/Tokyo
+-	 - 	Asia/Urumqi
+-	 - 	Asia/Aden
+-	 - 	Asia/Hong_Kong
+-	 - 	Asia/Krasnoyarsk
+-	 - 	Asia/Riyadh89
+-	 - 	Asia/Irkutsk
+-	 - 	Asia/Sakhalin
+-	 - 	Asia/Choibalsan
+-	 - 	Asia/Aqtau
+-	 - 	Asia/Yekaterinburg
+-	 - 	Asia/Jerusalem
+-	 - 	Asia/Seoul
+-	 - 	Asia/Samarkand
+-	 - 	Asia/Beirut
+-	 - 	Asia/Muscat
+-	 - 	Asia/Phnom_Penh
+-	 - 	Asia/Baghdad
+-	 - 	Asia/Yakutsk
+-	 - 	Portugal
+-	 - 	W-SU
+-	 - 	Greenwich
+-	 - 	Eire
+-	 - 	GMT-0
+-	 - 	MST7MDT
+-	 - 	MET
+-	 - 	EST
+-	 - 	Pacific
+-	 - 	Pacific/Efate
+-	 - 	Pacific/Fiji
+-	 - 	Pacific/Norfolk
+-	 - 	Pacific/Pitcairn
+-	 - 	Pacific/Noumea
+-	 - 	Pacific/Enderbury
+-	 - 	Pacific/Ponape
+-	 - 	Pacific/Midway
+-	 - 	Pacific/Niue
+-	 - 	Pacific/Gambier
+-	 - 	Pacific/Kosrae
+-	 - 	Pacific/Wake
+-	 - 	Pacific/Auckland
+-	 - 	Pacific/Palau
+-	 - 	Pacific/Tongatapu
+-	 - 	Pacific/Apia
+-	 - 	Pacific/Tahiti
+-	 - 	Pacific/Truk
+-	 - 	Pacific/Honolulu
+-	 - 	Pacific/Chatham
+-	 - 	Pacific/Galapagos
+-	 - 	Pacific/Pago_Pago
+-	 - 	Pacific/Guam
+-	 - 	Pacific/Nauru
+-	 - 	Pacific/Kwajalein
+-	 - 	Pacific/Wallis
+-	 - 	Pacific/Tarawa
+-	 - 	Pacific/Saipan
+-	 - 	Pacific/Easter
+-	 - 	Pacific/Fakaofo
+-	 - 	Pacific/Majuro
+-	 - 	Pacific/Johnston
+-	 - 	Pacific/Funafuti
+-	 - 	Pacific/Samoa
+-	 - 	Pacific/Guadalcanal
+-	 - 	Pacific/Yap
+-	 - 	Pacific/Port_Moresby
+-	 - 	Pacific/Kiritimati
+-	 - 	Pacific/Marquesas
+-	 - 	Pacific/Rarotonga
+-	 - 	Japan
+-	 - 	ROC
+-	 - 	Universal
+-	 - 	WET
+-	 - 	Navajo
+-	 - 	Iran
+-	 - 	Factory
+-	 - 	Egypt
+-	 - 	MST
+-	 - 	Australia
+-	 - 	Australia/Queensland
+-	 - 	Australia/Lindeman
+-	 - 	Australia/Broken_Hill
+-	 - 	Australia/Victoria
+-	 - 	Australia/Darwin
+-	 - 	Australia/Hobart
+-	 - 	Australia/Lord_Howe
+-	 - 	Australia/North
+-	 - 	Australia/ACT
+-	 - 	Australia/NSW
+-	 - 	Australia/West
+-	 - 	Australia/Tasmania
+-	 - 	Australia/LHI
+-	 - 	Australia/Eucla
+-	 - 	Australia/Canberra
+-	 - 	Australia/Melbourne
+-	 - 	Australia/South
+-	 - 	Australia/Currie
+-	 - 	Australia/Sydney
+-	 - 	Australia/Yancowinna
+-	 - 	Australia/Perth
+-	 - 	Australia/Adelaide
+-	 - 	Australia/Brisbane
+-	 - 	EET
+-	 - 	GMT+0
+-	 - 	Africa
+-	 - 	Africa/Tunis
+-	 - 	Africa/Lome
+-	 - 	Africa/Asmara
+-	 - 	Africa/Harare
+-	 - 	Africa/Windhoek
+-	 - 	Africa/Tripoli
+-	 - 	Africa/Dakar
+-	 - 	Africa/Mogadishu
+-	 - 	Africa/Bujumbura
+-	 - 	Africa/Cairo
+-	 - 	Africa/Casablanca
+-	 - 	Africa/Gaborone
+-	 - 	Africa/Libreville
+-	 - 	Africa/Porto-Novo
+-	 - 	Africa/Ouagadougou
+-	 - 	Africa/Lubumbashi
+-	 - 	Africa/Blantyre
+-	 - 	Africa/El_Aaiun
+-	 - 	Africa/Conakry
+-	 - 	Africa/Djibouti
+-	 - 	Africa/Kampala
+-	 - 	Africa/Ndjamena
+-	 - 	Africa/Maseru
+-	 - 	Africa/Lusaka
+-	 - 	Africa/Johannesburg
+-	 - 	Africa/Nouakchott
+-	 - 	Africa/Ceuta
+-	 - 	Africa/Malabo
+-	 - 	Africa/Sao_Tome
+-	 - 	Africa/Abidjan
+-	 - 	Africa/Lagos
+-	 - 	Africa/Kigali
+-	 - 	Africa/Asmera
+-	 - 	Africa/Kinshasa
+-	 - 	Africa/Monrovia
+-	 - 	Africa/Banjul
+-	 - 	Africa/Nairobi
+-	 - 	Africa/Brazzaville
+-	 - 	Africa/Timbuktu
+-	 - 	Africa/Bangui
+-	 - 	Africa/Bamako
+-	 - 	Africa/Accra
+-	 - 	Africa/Dar_es_Salaam
+-	 - 	Africa/Luanda
+-	 - 	Africa/Bissau
+-	 - 	Africa/Douala
+-	 - 	Africa/Khartoum
+-	 - 	Africa/Freetown
+-	 - 	Africa/Maputo
+-	 - 	Africa/Niamey
+-	 - 	Africa/Addis_Ababa
+-	 - 	Africa/Algiers
+-	 - 	Africa/Mbabane
+-	 - 	Atlantic
+-	 - 	Atlantic/St_Helena
+-	 - 	Atlantic/Faeroe
+-	 - 	Atlantic/Madeira
+-	 - 	Atlantic/Bermuda
+-	 - 	Atlantic/South_Georgia
+-	 - 	Atlantic/Cape_Verde
+-	 - 	Atlantic/Faroe
+-	 - 	Atlantic/Reykjavik
+-	 - 	Atlantic/Jan_Mayen
+-	 - 	Atlantic/Canary
+-	 - 	Atlantic/Azores
+-	 - 	Atlantic/Stanley
+-	 - 	Hongkong
+-	 - 	Poland
+-	 - 	Libya
+-	 - 	UTC
+-	 - 	UCT
+-	 - 	Israel
+-	 - 	CET
+-	 - 	Brazil
+-	 - 	Brazil/Acre
+-	 - 	Brazil/East
+-	 - 	Brazil/West
+-	 - 	Brazil/DeNoronha
+-	 - 	ROK
+-	 - 	Singapore
+-	 - 	America
+-	 - 	America/Tijuana
+-	 - 	America/Detroit
+-	 - 	America/Noronha
+-	 - 	America/Santiago
+-	 - 	America/Montevideo
+-	 - 	America/Panama
+-	 - 	America/La_Paz
+-	 - 	America/Guatemala
+-	 - 	America/Boa_Vista
+-	 - 	America/Costa_Rica
+-	 - 	America/Resolute
+-	 - 	America/Scoresbysund
+-	 - 	America/Denver
+-	 - 	America/Whitehorse
+-	 - 	America/Kentucky
+-	 - 	America/Kentucky/Louisville
+-	 - 	America/Kentucky/Monticello
+-	 - 	America/Pangnirtung
+-	 - 	America/Yellowknife
+-	 - 	America/Phoenix
+-	 - 	America/Martinique
+-	 - 	America/Cuiaba
+-	 - 	America/Lima
+-	 - 	America/Winnipeg
+-	 - 	America/Menominee
+-	 - 	America/St_Johns
+-	 - 	America/Regina
+-	 - 	America/Guayaquil
+-	 - 	America/Maceio
+-	 - 	America/Hermosillo
+-	 - 	America/Barbados
+-	 - 	America/Halifax
+-	 - 	America/Asuncion
+-	 - 	America/Manaus
+-	 - 	America/Dominica
+-	 - 	America/Catamarca
+-	 - 	America/Grenada
+-	 - 	America/Montserrat
+-	 - 	America/Mazatlan
+-	 - 	America/Recife
+-	 - 	America/Rosario
+-	 - 	America/Iqaluit
+-	 - 	America/Porto_Acre
+-	 - 	America/Managua
+-	 - 	America/Antigua
+-	 - 	America/Indiana
+-	 - 	America/Indiana/Vevay
+-	 - 	America/Indiana/Tell_City
+-	 - 	America/Indiana/Winamac
+-	 - 	America/Indiana/Indianapolis
+-	 - 	America/Indiana/Petersburg
+-	 - 	America/Indiana/Knox
+-	 - 	America/Indiana/Vincennes
+-	 - 	America/Indiana/Marengo
+-	 - 	America/Thunder_Bay
+-	 - 	America/Dawson
+-	 - 	America/Yakutat
+-	 - 	America/Edmonton
+-	 - 	America/New_York
+-	 - 	America/Tortola
+-	 - 	America/Nassau
+-	 - 	America/Inuvik
+-	 - 	America/Atikokan
+-	 - 	America/St_Kitts
+-	 - 	America/Fortaleza
+-	 - 	America/Ensenada
+-	 - 	America/Cordoba
+-	 - 	America/Araguaina
+-	 - 	America/Marigot
+-	 - 	America/Godthab
+-	 - 	America/Rio_Branco
+-	 - 	America/St_Barthelemy
+-	 - 	America/Knox_IN
+-	 - 	America/Indianapolis
+-	 - 	America/Cambridge_Bay
+-	 - 	America/St_Vincent
+-	 - 	America/Anguilla
+-	 - 	America/Merida
+-	 - 	America/Santo_Domingo
+-	 - 	America/Coral_Harbour
+-	 - 	America/St_Lucia
+-	 - 	America/Juneau
+-	 - 	America/Chicago
+-	 - 	America/Toronto
+-	 - 	America/Belize
+-	 - 	America/Virgin
+-	 - 	America/Port_of_Spain
+-	 - 	America/Boise
+-	 - 	America/Adak
+-	 - 	America/Cancun
+-	 - 	America/Curacao
+-	 - 	America/Glace_Bay
+-	 - 	America/Jujuy
+-	 - 	America/Fort_Wayne
+-	 - 	America/Caracas
+-	 - 	America/Nipigon
+-	 - 	America/Louisville
+-	 - 	America/Anchorage
+-	 - 	America/Chihuahua
+-	 - 	America/Moncton
+-	 - 	America/Goose_Bay
+-	 - 	America/Rankin_Inlet
+-	 - 	America/Dawson_Creek
+-	 - 	America/Cayman
+-	 - 	America/Bogota
+-	 - 	America/Montreal
+-	 - 	America/Monterrey
+-	 - 	America/Argentina
+-	 - 	America/Argentina/ComodRivadavia
+-	 - 	America/Argentina/La_Rioja
+-	 - 	America/Argentina/San_Juan
+-	 - 	America/Argentina/Catamarca
+-	 - 	America/Argentina/Cordoba
+-	 - 	America/Argentina/Jujuy
+-	 - 	America/Argentina/Ushuaia
+-	 - 	America/Argentina/Buenos_Aires
+-	 - 	America/Argentina/Tucuman
+-	 - 	America/Argentina/San_Luis
+-	 - 	America/Argentina/Mendoza
+-	 - 	America/Argentina/Rio_Gallegos
+-	 - 	America/Puerto_Rico
+-	 - 	America/El_Salvador
+-	 - 	America/Port-au-Prince
+-	 - 	America/Miquelon
+-	 - 	America/Havana
+-	 - 	America/Tegucigalpa
+-	 - 	America/Sao_Paulo
+-	 - 	America/Buenos_Aires
+-	 - 	America/Eirunepe
+-	 - 	America/Nome
+-	 - 	America/Cayenne
+-	 - 	America/Guadeloupe
+-	 - 	America/Danmarkshavn
+-	 - 	America/Aruba
+-	 - 	America/Porto_Velho
+-	 - 	America/Campo_Grande
+-	 - 	America/Paramaribo
+-	 - 	America/Los_Angeles
+-	 - 	America/Atka
+-	 - 	America/Rainy_River
+-	 - 	America/Bahia
+-	 - 	America/Jamaica
+-	 - 	America/Vancouver
+-	 - 	America/Guyana
+-	 - 	America/Shiprock
+-	 - 	America/Mexico_City
+-	 - 	America/St_Thomas
+-	 - 	America/Belem
+-	 - 	America/Mendoza
+-	 - 	America/North_Dakota
+-	 - 	America/North_Dakota/Center
+-	 - 	America/North_Dakota/New_Salem
+-	 - 	America/Blanc-Sablon
+-	 - 	America/Thule
+-	 - 	America/Swift_Current
+-	 - 	America/Grand_Turk
+-	 - 	Kwajalein
+-	 - 	Turkey
+-	 - 	Cuba
+-	 - 	Indian
+-	 - 	Indian/Antananarivo
+-	 - 	Indian/Mahe
+-	 - 	Indian/Chagos
+-	 - 	Indian/Mauritius
+-	 - 	Indian/Kerguelen
+-	 - 	Indian/Christmas
+-	 - 	Indian/Maldives
+-	 - 	Indian/Reunion
+-	 - 	Indian/Comoro
+-	 - 	Indian/Mayotte
+-	 - 	Indian/Cocos
+-	 - 	PST8PDT
+-	 - 	US
+-	 - 	US/Arizona
+-	 - 	US/Eastern
+-	 - 	US/Pacific
+-	 - 	US/Central
+-	 - 	US/East-Indiana
+-	 - 	US/Indiana-Starke
+-	 - 	US/Pacific-New
+-	 - 	US/Mountain
+-	 - 	US/Aleutian
+-	 - 	US/Michigan
+-	 - 	US/Hawaii
+-	 - 	US/Alaska
+-	 - 	US/Samoa
+-	 - 	HST
+-	 - 	Arctic
+-	 - 	Arctic/Longyearbyen
+-	 - 	GMT
+-	 - 	NZ-CHAT
+-	 - 	GB-Eire
+-	 - 	Canada
+-	 - 	Canada/Eastern
+-	 - 	Canada/Pacific
+-	 - 	Canada/Central
+-	 - 	Canada/East-Saskatchewan
+-	 - 	Canada/Atlantic
+-	 - 	Canada/Mountain
+-	 - 	Canada/Newfoundland
+-	 - 	Canada/Saskatchewan
+-	 - 	Canada/Yukon
+-	 - 	posix.tab
+-	 - 	Jamaica
+-	 - 	Antarctica
+-	 - 	Antarctica/South_Pole
+-	 - 	Antarctica/Casey
+-	 - 	Antarctica/Rothera
+-	 - 	Antarctica/Palmer
+-	 - 	Antarctica/Syowa
+-	 - 	Antarctica/Davis
+-	 - 	Antarctica/McMurdo
+-	 - 	Antarctica/DumontDUrville
+-	 - 	Antarctica/Vostok
+-	 - 	Antarctica/Mawson
+-	 - 	Iceland
+-	 - 	Mexico
+-	 - 	Mexico/General
+-	 - 	Mexico/BajaNorte
+-	 - 	Mexico/BajaSur
+-	 - 	PRC
+-	 - 	Zulu
+-	 - 	Mideast
+-	 - 	Mideast/Riyadh87
+-	 - 	Mideast/Riyadh88
+-	 - 	Mideast/Riyadh89
diff --git a/abs/mv-core/webcal/send_reminders.patch b/abs/mv-core/webcal/send_reminders.patch
new file mode 100644
index 0000000..9076b0c
--- /dev/null
+++ b/abs/mv-core/webcal/send_reminders.patch
@@ -0,0 +1,38 @@
+--- send_reminders.php.orig	2008-08-04 18:02:14.000000000 -0500
++++ send_reminders.php	2008-08-07 15:15:28.000000000 -0500
+@@ -1,4 +1,4 @@
+-#!/usr/local/bin/php -q
++#!/usr/bin/php -q
+ <?php
+ /* $Id: send_reminders.php,v 1.81.2.8 2008/02/18 17:42:02 cknudsen Exp $
+  *
+@@ -313,6 +313,10 @@
+       translate ( 'could not find event id XXX in database.' ) ) . "\n";
+     return;
+   }
++ //Always send via ghosd
++    $name = $row[9];
++    $p =  system("/usr/bin/notify.py NFO \"$name\"", $retval);
++  
+ 
+   // Send mail. We send one user at a time so that we can switch
+   // languages between users if needed (as well as HTML vs plain text).
+@@ -475,7 +479,6 @@
+     }
+ 
+     $subject = translate ( 'Reminder' ) . ': ' . stripslashes ( $name );
+-
+     if ( $debug )
+       echo "Sending mail to $recip (in $userlang).<br />\n";
+ 
+@@ -570,7 +573,9 @@
+     }
+     // Factor in repeats if set.
+     if ( $repeats > 0 && $times_sent <= $repeats )
+-      $remind_time += ( $reminder['duration'] * 60 * $times_sent );
++      $remind_time = ($reminder['duration']*60 + $lastsent  );
++//	Don't know what this is line is doing, but the above seems better to me
++//      $remind_time += ( $reminder['duration'] * 60 * $times_sent );
+ 
+     if ( $debug )
+       echo ( empty ( $offset_msg ) ? '' : $offset_msg . '<br />' ) . '
diff --git a/abs/mv-core/webcal/sendreminders.sh b/abs/mv-core/webcal/sendreminders.sh
new file mode 100644
index 0000000..ac99058
--- /dev/null
+++ b/abs/mv-core/webcal/sendreminders.sh
@@ -0,0 +1,5 @@
+#!/bin/bash
+. /etc/profile
+cd /data/srv/httpd/htdocs/webcal/tools
+./send_reminders.php
+
diff --git a/abs/mv-core/webcal/settings.php b/abs/mv-core/webcal/settings.php
new file mode 100644
index 0000000..c43b705
--- /dev/null
+++ b/abs/mv-core/webcal/settings.php
@@ -0,0 +1,18 @@
+<?php
+/* updated via install/index.php on Mon, 04 Aug 2008 06:44:26 -1100
+install_password: a744c6d7842ac39db07f6191e31c69ce
+db_type: mysql
+db_host: localhost
+db_database: webcal
+db_login: webcal
+db_password: webcal
+db_persistent: false
+db_cachedir: /data/srv/tmp
+readonly: false
+user_inc: user.php
+use_http_auth: false
+single_user: true
+single_user_login: Me
+mode: prod
+# end settings.php */
+?>
diff --git a/abs/mv-core/webcal/webcal.install b/abs/mv-core/webcal/webcal.install
new file mode 100644
index 0000000..290b8b0
--- /dev/null
+++ b/abs/mv-core/webcal/webcal.install
@@ -0,0 +1,30 @@
+post_install() {
+	mkdir /data/srv/tmp
+	chmod 777 /data/srv/tmp
+        mysql -u root -e 'create database webcal;'  
+	mysql -u root -e "GRANT ALL PRIVILEGES ON *.* TO webcal@localhost IDENTIFIED BY 'webcal' WITH GRANT OPTION;"
+	echo installing the default webcal  database
+	#install tables
+	mysql webcal  <   /data/srv/httpd/htdocs/webcal/createdb.sql
+	chown -R nobody:nobody /data/srv/httpd/htdocs/webcal/
+	chmod 775 /data/srv/httpd/htdocs/webcal/includes
+	MVDIR=/usr/bin
+	ln -s $MVDIR/sendreminders.sh  /etc/cron.tenminutes/01-sendreminders.sh
+	. /etc/systemconfig
+	mysql webcal -e "update webcal_config set cal_value="\"${timezone}\"" where cal_setting='SERVER_TIMEZONE' ;"  
+	mysql webcal -e "update webcal_config set cal_value="\"${timezone}\"" where cal_setting='TIMEZONE' ;"  
+	mysql webcal -e "update webcal_user_pref  set cal_value="\"${timezone}\"" where cal_setting='TIMEZONE' ;"  
+}
+post_upgrade() {
+	echo "nothing to do"
+chown -R nobody:nobody /data/srv/httpd/htdocs/webcal/
+	chmod 775 /data/srv/httpd/htdocs/webcal/includes
+	MVDIR=/usr/bin
+	ln -s $MVDIR/sendreminders.sh  /etc/cron.tenminutes/01-sendreminders.sh
+
+
+}
+
+op=$1 
+shift 
+$op $*
author	James Meyer <james.meyer@operamail.com>	2008-11-09 02:33:06 (GMT)
committer	James Meyer <james.meyer@operamail.com>	2008-11-09 02:33:06 (GMT)
commit	1ba69cc033dfbd0a6c4c29c6d877c7e753f96e8e (patch)
tree	f336ee91ce16c6591fff50340562e07e15aa1a55 /abs/mv-core/webcal
parent	75b1bceb21faab32d8f519d6f7f7062a226f9047 (diff)
download	linhes_pkgbuild-1ba69cc033dfbd0a6c4c29c6d877c7e753f96e8e.zip linhes_pkgbuild-1ba69cc033dfbd0a6c4c29c6d877c7e753f96e8e.tar.gz linhes_pkgbuild-1ba69cc033dfbd0a6c4c29c6d877c7e753f96e8e.tar.bz2