Changeset 17716 for extensions/SmartAlbums/maintain.inc.php
- Timestamp:
- Sep 3, 2012, 3:06:50 PM (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/SmartAlbums/maintain.inc.php
r16939 r17716 2 2 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!'); 3 3 4 global $prefixeTable; 5 define('smart_table', $prefixeTable . 'category_filters'); 6 7 define('smart_default_config', serialize(array( 8 'update_on_upload' => false, 9 'show_list_messages' => true, 10 'smart_is_forbidden' => true, 11 ))); 4 include_once(PHPWG_PLUGINS_PATH . 'SmartAlbums/include/install.inc.php'); 12 5 13 6 function plugin_install() 14 7 { 15 /* create table to store filters */ 16 pwg_query( 17 'CREATE TABLE IF NOT EXISTS `' . smart_table . '` ( 18 `category_id` smallint(5) unsigned NOT NULL, 19 `type` varchar(16) NOT NULL, 20 `cond` varchar(16) NULL, 21 `value` text 22 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 23 ;'); 24 25 /* add a collumn to image_category_table */ 26 pwg_query('ALTER TABLE `' . IMAGE_CATEGORY_TABLE . '` ADD `smart` ENUM(\'true\', \'false\') NOT NULL DEFAULT \'false\';'); 27 28 /* config parameter */ 29 conf_update_param('SmartAlbums', smart_default_config); 8 smart_albums_install(); 9 define('smart_albums_installed', true); 30 10 } 31 11 32 12 function plugin_activate() 33 13 { 34 global $conf; 35 36 if (!isset($conf['SmartAlbums'])) 14 if (!defined('smart_albums_installed')) 37 15 { 38 conf_update_param('SmartAlbums', smart_default_config); 39 } 40 else 41 { 42 $new_conf = unserialize($conf['SmartAlbums']); 43 // new param in 2.0.2 44 if (!isset($new_conf['smart_is_forbidden'])) 45 { 46 $new_conf['smart_is_forbidden'] = true; 47 conf_update_param('SmartAlbums', smart_default_config); 48 } 49 } 50 51 // some filters renamed in 2.0 52 $name_changes = array( 53 'the' => 'the_post', 54 'before' => 'before_post', 55 'after' => 'after_post', 56 'the_crea' => 'the_taken', 57 'before_crea' => 'before_taken', 58 'after_crea' => 'after_taken', 59 ); 60 foreach ($name_changes as $old => $new) 61 { 62 pwg_query('UPDATE ' . smart_table . ' SET cond = "'.$new.'" WHERE cond = "'.$old.'";'); 16 smart_albums_install(); 63 17 } 64 18 } 65 19 66 20 function plugin_uninstall() 67 { 68 pwg_query('DROP TABLE `' . smart_table . '`;'); 21 { 22 global $prefixeTable; 23 24 pwg_query('DROP TABLE `' . $prefixeTable . 'category_filters`;'); 69 25 pwg_query('ALTER TABLE `' . IMAGE_CATEGORY_TABLE . '` DROP `smart`;'); 70 26 pwg_query('DELETE FROM `' . CONFIG_TABLE . '` WHERE param = \'SmartAlbums\' LIMIT 1;');
Note: See TracChangeset
for help on using the changeset viewer.