Changeset 15149 for extensions/typetags/maintain.inc.php

Timestamp:

May 20, 2012, 12:38:07 PM (12 years ago)

Author:

mistic100

Message:

• display typetags everywhere (not only tags page)
• little redesign of admin page + code cleaning

File:

• extensions/typetags/maintain.inc.php (modified) (3 diffs)

extensions/typetags/maintain.inc.php

@@ -10 +10 @@
   if (!in_array('id_typetags', $result))
   {
-    pwg_query('ALTER TABLE '.TAGS_TABLE.' ADD COLUMN `id_typetags` SMALLINT(5)');
+    pwg_query('ALTER TABLE '.TAGS_TABLE.' ADD COLUMN `id_typetags` SMALLINT(5);');
   }
 
@@ -16 +16 @@
   if (!mysql_fetch_row($result))
   {
-    $q = 'CREATE TABLE '. $prefixeTable .'typetags(
-      id smallint(5) unsigned NOT NULL auto_increment,
-      name VARCHAR(255) NOT NULL,
-      color VARCHAR(255) NOT NULL,
-      PRIMARY KEY  (id));';
-    pwg_query($q);
+    $query = '
+CREATE TABLE `'. $prefixeTable .'typetags` (
+  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+  `name` varchar(255) NOT NULL,
+  `color` varchar(255) NOT NULL,
+  PRIMARY KEY (`id`)
+) DEFAULT CHARSET=utf8
+;';
+    pwg_query($query);
+  }
+  
+  conf_update_param('TypeTags', serialize(array('show_all'=>true)));
+}
+
+function plugin_activate()
+{
+  global $conf;
+  
+  if (!isset($conf['TypeTags']))
+  {
+    conf_update_param('TypeTags', serialize(array('show_all'=>true)));
   }
 }
@@ -29 +44 @@
   global $prefixeTable;
 
-  $q = ' ALTER TABLE '.TAGS_TABLE.' DROP COLUMN `id_typetags`';
-  pwg_query( $q );
-
-  $q = ' DROP TABLE '. $prefixeTable .'typetags;';
-  pwg_query($q);
+  pwg_query('ALTER TABLE '.TAGS_TABLE.' DROP COLUMN `id_typetags`');
+  pwg_query('DROP TABLE '. $prefixeTable .'typetags;');
+  pwg_query('DELETE FROM '.CONFIG_TABLE.' WHERE param = "TypeTags" LIMIT 1;');
 }