[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_glossary` (
   7    `glossary_id` int(11) NOT NULL auto_increment,
   8    `glossary_created` datetime NOT NULL default '0000-00-00 00:00:00',
   9    `glossary_changed` datetime NOT NULL default '0000-00-00 00:00:00',
  10    `glossary_title` text NOT NULL,
  11    `glossary_tag` varchar(255) NOT NULL default '',
  12    `glossary_keyword` varchar(255) NOT NULL default '',
  13    `glossary_text` mediumtext NOT NULL,
  14    `glossary_highlight` int(1) NOT NULL default '0',
  15    `glossary_object` mediumtext NOT NULL,
  16    `glossary_status` int(1) NOT NULL default '0',
  17    PRIMARY KEY  (`glossary_id`),
  18    KEY `glossary_status` (`glossary_status`),
  19    KEY `glossary_tag` (`glossary_tag`),
  20    KEY `glossary_keyword` (`glossary_keyword`),
  21    KEY `glossary_highlight` (`glossary_highlight`)
  22  ) TYPE=MyISAM"._dbGetCreateCharsetCollation();
  23  
  24  if(_dbQuery($sql, 'CREATE')) {
  25  
  26      echo '<p class="title">Glossary setup</p>';
  27      echo '<p>Please delete folder <b>setup</b> which can be found inside the module folder here:<br />';
  28      echo str_replace(PHPWCMS_ROOT, '', $phpwcms['modules'][$module]['path']).'</p>';
  29  
  30  } else {
  31  
  32      echo '<p class="title">Glossary setup</p>';
  33      echo '<p class="error">Error creating <b>glossary</b> initial database table:</p>';
  34      echo '<p>'.html_entities(@mysql_error()).'</p>';
  35  
  36  }
  37  
  38  
  39  ?>