Changeset 4174 for extensions/meta/maintain.inc.php
- Timestamp:
- Nov 2, 2009, 11:31:49 PM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/meta/maintain.inc.php
r3978 r4174 2 2 3 3 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!'); 4 5 $majm='meta 2.0.5'; 4 6 5 7 function plugin_install() … … 27 29 pwg_query($q); 28 30 29 31 $q = ' 30 32 INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (4,"robots","follow","name");'; 31 33 pwg_query($q); 32 34 33 $q = ' 34 ALTER TABLE '. CATEGORIES_TABLE.' ADD COLUMN `metaKeywords` VARCHAR( 255 )'; 35 pwg_query($q); 35 if (!defined('meta_img_TABLE')) define('meta_img_TABLE', $prefixeTable.'meta_img'); 36 $query = "CREATE TABLE IF NOT EXISTS ". meta_img_TABLE ." ( 37 id SMALLINT( 5 ) UNSIGNED NOT NULL , 38 metaKeyimg VARCHAR( 255 ) NOT NULL , 39 PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; 40 $result = pwg_query($query); 41 42 if (!defined('meta_cat_TABLE')) define('meta_cat_TABLE', $prefixeTable.'meta_cat'); 43 $query = "CREATE TABLE IF NOT EXISTS ". meta_cat_TABLE ." ( 44 id SMALLINT( 5 ) UNSIGNED NOT NULL , 45 metaKeycat VARCHAR( 255 ) NOT NULL , 46 PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; 47 $result = pwg_query($query); 36 48 49 $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm.'",1,"MAJ meta");'; 50 pwg_query($query); 37 51 } 38 52 … … 44 58 pwg_query($q); 45 59 46 $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param=" meta" LIMIT 1;';60 $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="'.$majm.'" LIMIT 1;'; 47 61 pwg_query($q); 48 62 49 $q = ' ALTER TABLE '. CATEGORIES_TABLE .' DROP COLUMN `metaKeywords`'; 50 pwg_query( $q ); 63 $q = 'DROP TABLE ' . $prefixeTable . 'meta_img;'; 64 pwg_query($q); 65 66 $q = 'DROP TABLE ' . $prefixeTable . 'meta_cat;'; 67 pwg_query($q); 51 68 } 52 69
Note: See TracChangeset
for help on using the changeset viewer.