source: extensions/title/maintain.inc.php @ 25617

<?php

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

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

    $q = 'CREATE TABLE ' . $prefixeTable . 'title(
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
page VARCHAR( 255 ) NOT NULL ,
title lONGTEXT NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;';
    pwg_query($q);
        
        $q = '
INSERT INTO ' . $prefixeTable . 'title(id,page,title)VALUES (1,"home","");';
    pwg_query($q);
        $q = '
INSERT INTO ' . $prefixeTable . 'title(id,page,title)VALUES (2,"best_rated","");';
    pwg_query($q);
                $q = '
INSERT INTO ' . $prefixeTable . 'title(id,page,title)VALUES (3,"most_visited","");';
    pwg_query($q);
                $q = '
INSERT INTO ' . $prefixeTable . 'title(id,page,title)VALUES (4,"recent_pics","");';
    pwg_query($q);
                $q = '
INSERT INTO ' . $prefixeTable . 'title(id,page,title)VALUES (5,"recent_cats","");';
    pwg_query($q);
                $q = '
INSERT INTO ' . $prefixeTable . 'title(id,page,title)VALUES (6,"favorites","");';
    pwg_query($q);      
                $q = '
INSERT INTO ' . $prefixeTable . 'title(id,page,title)VALUES (7,"tags","");';
    pwg_query($q);
                $q = '
INSERT INTO ' . $prefixeTable . 'title(id,page,title)VALUES (8,"comments","");';
    pwg_query($q);
                $q = '
INSERT INTO ' . $prefixeTable . 'title(id,page,title)VALUES (9,"about","");';
    pwg_query($q);
                $q = '
INSERT INTO ' . $prefixeTable . 'title(id,page,title)VALUES (10,"search","");';
    pwg_query($q);
                $q = '
INSERT INTO ' . $prefixeTable . 'title(id,page,title)VALUES (11,"random","");';
    pwg_query($q);
                $q = '
INSERT INTO ' . $prefixeTable . 'title(id,page,title)VALUES (12,"notification","");';
    pwg_query($q);      
        
if (!defined('TITLE_PHOTO_TABLE')) define('TITLE_PHOTO_TABLE', $prefixeTable.'title_photo');
        $query = "CREATE TABLE IF NOT EXISTS ". TITLE_PHOTO_TABLE ." (
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
title VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
        $result = pwg_query($query);

if (!defined('TITLE_ALBUM_TABLE')) define('TITLE_ALBUM_TABLE', $prefixeTable.'title_album');    
        $query = "CREATE TABLE IF NOT EXISTS ". TITLE_ALBUM_TABLE ." (
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
title VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
        $result = pwg_query($query);
        
  if (empty($conf['contacttitle']))
  {
        $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("contacttitle","","contacttitle");';
    pwg_query($query);
  }

  
        if (!defined('TITLE_AP_TABLE')) define('TITLE_AP_TABLE', $prefixeTable.'title_ap');     
        $query = "CREATE TABLE IF NOT EXISTS ". TITLE_AP_TABLE ." (
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
title VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
        $result = pwg_query($query);
        
}

function plugin_activate()
{
    global $conf, $prefixeTable;
  if (empty($conf['contacttitle']))
  {
        $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("contacttitle","","contacttitle");';
    pwg_query($query);
  }
  
        if (!defined('TITLE_AP_TABLE')) define('TITLE_AP_TABLE', $prefixeTable.'title_ap');     
        $query = "CREATE TABLE IF NOT EXISTS ". TITLE_AP_TABLE ." (
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
title VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
        $result = pwg_query($query);
    
}

function plugin_uninstall()
{
    
        global $prefixeTable;

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

        $q = 'DROP TABLE ' . $prefixeTable . 'title_album;';
    pwg_query($q);
        
        $q = 'DROP TABLE ' . $prefixeTable . 'title_ap;';
    pwg_query($q);
        
        $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="contacttitle" LIMIT 1;';
    pwg_query($q);
}


?>