source: extensions/AdditionalPages/trunk/maintain.inc.php @ 11659

<?php

function plugin_install()
{
  global $prefixeTable, $conf;

  $query = 'SHOW TABLES LIKE "' . $prefixeTable . 'additionalpages"';
  $result = pwg_query($query);
  if (!mysql_fetch_row($result))
  {
    $query = 'CREATE TABLE ' . $prefixeTable . 'additionalpages (
id SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT,
pos SMALLINT( 5 ) NULL default NULL ,
lang VARCHAR( 255 ) NULL default NULL ,
title VARCHAR( 255 ) NOT NULL ,
content LONGTEXT NOT NULL ,
users VARCHAR( 255 ) NULL DEFAULT NULL ,
groups VARCHAR( 255 ) NULL DEFAULT NULL ,
level TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT "0" ,
permalink VARCHAR( 64 ) NULL DEFAULT NULL ,
standalone ENUM( "true", "false" ) NOT NULL DEFAULT "false" ,
PRIMARY KEY (id) ,
INDEX (pos) ,
INDEX (lang))
DEFAULT CHARACTER SET utf8';
    if ('mysql' == $conf['dblayer'])
    {
      $query .= ' ENGINE=MYISAM';
    }
    pwg_query($query.';');
  }

  if (!isset($conf['additional_pages']))
  {
    $config = array(
      'languages' => array('default' => 'Additional Pages'),
      'show_home' => true,
      'level_perm' => false,
      'group_perm' => false,
      'user_perm' => false,
      'language_perm' => false,
      'homepage' => null,
    );

    $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment)
VALUES ("additional_pages" , "'.pwg_db_real_escape_string(serialize($config)).'" , "Additional Pages configuration");';
    pwg_query($query);
  }
}

function plugin_activate()
{
  global $prefixeTable;

  $q = pwg_query('SHOW COLUMNS FROM ' . HISTORY_TABLE . ' LIKE "section"');
  $section = mysql_fetch_array($q);
  $type = $section['Type'];

  // Add additional page section into history table
  if (strpos($type, 'additional_page') === false)
  {
    $type = strtr($type , array(')' => ',\'additional_page\')'));
    pwg_query('ALTER TABLE ' . HISTORY_TABLE . ' CHANGE section section ' . $type . ' DEFAULT NULL');
  }
}

function plugin_uninstall()
{
  global $prefixeTable;

        $q = 'DROP TABLE ' . $prefixeTable . 'additionalpages;';
  pwg_query($q);

        $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="additional_pages" LIMIT 1;';
  pwg_query($q);
}

?>