[Summary view] [Print] [Text view]

   1  <?php
   2  
   3  // do everything in here which is neccessary for module setup
   4  
   5  // ceate neccessary db table
   6  $sql = "CREATE TABLE IF NOT EXISTS `".DB_PREPEND."phpwcms_calendar` (
   7    `calendar_id` int(11) NOT NULL auto_increment,
   8    `calendar_created` datetime NOT NULL default '0000-00-00 00:00:00',
   9    `calendar_changed` datetime NOT NULL default '0000-00-00 00:00:00',
  10    `calendar_status` int(1) NOT NULL default '0',
  11    `calendar_start` datetime NOT NULL default '0000-00-00 00:00:00',
  12    `calendar_end` datetime NOT NULL default '0000-00-00 00:00:00',
  13    `calendar_allday` int(1) NOT NULL default '0',
  14    `calendar_range` int(1) NOT NULL default '0',
  15    `calendar_range_start` date NOT NULL default '0000-00-00',
  16    `calendar_range_end` date NOT NULL default '0000-00-00',
  17    `calendar_title` varchar(255) NOT NULL default '',
  18    `calendar_where` varchar(255) NOT NULL default '',
  19    `calendar_text` mediumtext NOT NULL,
  20    `calendar_tag` varchar(255) NOT NULL default '',
  21    `calendar_object` longtext NOT NULL,
  22    `calendar_refid` int(11) NOT NULL default '0',
  23    PRIMARY KEY  (`calendar_id`),
  24    KEY `calendar_status` (`calendar_status`),
  25    KEY `calendar_start` (`calendar_start`),
  26    KEY `calendar_end` (`calendar_end`),
  27    KEY `calendar_tag` (`calendar_tag`),
  28    KEY `calendar_refid` (`calendar_refid`),
  29    KEY `calendar_range` (`calendar_range`)
  30  ) ENGINE=MyISAM"._dbGetCreateCharsetCollation();
  31  
  32  if(_dbQuery($sql, 'CREATE')) {
  33  
  34      echo '<p class="title">Calendar setup</p>';
  35      echo '<p>Please delete folder <b>setup</b> which can be found inside the module folder here:<br />';
  36      echo str_replace(PHPWCMS_ROOT, '', $phpwcms['modules'][$module]['path']).'</p>';
  37  
  38  } else {
  39  
  40      echo '<p class="title">Calendar setup</p>';
  41      echo '<p class="error">Error creating <b>calendar</b> initial database table:</p>';
  42      echo '<p>'.html_entities(@mysql_error()).'</p>';
  43  
  44  }
  45  
  46  
  47  ?>