<?php

if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

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

  $query = 'SHOW TABLES LIKE "' . $prefixeTable . 'stuffs"';
  $result = pwg_query($query);
  if (!mysql_fetch_row($result))
  {
    $q = 'CREATE TABLE `' . $prefixeTable . 'stuffs` (
`id` smallint(5) NOT NULL,
`pos` smallint(5) NOT NULL,
`name` text NOT NULL,
`descr` varchar(255) default NULL,
`type` varchar(255) NOT NULL,
`path` varchar(255) default NULL,
`datas` longtext default NULL,
`users` varchar(255) default NULL,
`groups` varchar(255) default NULL,
`show_title` enum(\'true\',\'false\') NOT NULL,
`on_home` enum(\'true\',\'false\') NOT NULL,
`on_cats` enum(\'true\',\'false\') NOT NULL,
`on_picture` enum(\'true\',\'false\') NOT NULL,
`id_line` varchar(1) default NULL,
`width` smallint(9) default NULL,
PRIMARY KEY  (`id`),
KEY `on_home` (`on_home`),
KEY `on_cats` (`on_cats`),
KEY `on_picture` (`on_picture`)
) DEFAULT CHARSET=utf8;';
    pwg_query($q);
  
    $q = "INSERT INTO `" . $prefixeTable . "stuffs` (`id`, `pos`, `name`, `descr`, `type`, `path`, `datas`, `users`, `groups`, `show_title`, `on_home`, `on_cats`, `on_picture`, `id_line`, `width`) 
VALUES (0, 1, 'MainBlock', NULL, 'MainBlock', NULL, NULL, 'guest,generic,normal,admin,webmaster', NULL, 'true', 'true', 'true', 'true', NULL, NULL);";
    pwg_query($q);
  }
}

function plugin_activate($id, $version)
{
  global $plugins, $prefixeTable;

  // Check if upgrade is needed
  if ($version != $plugins->fs_plugins[$id]['version'])
  {
    define('STUFFS_VERSION', $plugins->fs_plugins[$id]['version']);
    include('admin/upgrade.inc.php');
  }
}

function plugin_uninstall()
{
    global $prefixeTable;

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

?>