/** * update_360020 * * Catalog types are plugins now */ public static function update_360020() { $retval = true; $sql = "SELECT `id`, `catalog_type`, `path`, `remote_username`, `remote_password` FROM `catalog`"; $db_results = Dba::read($sql); $c = Catalog::create_catalog_type('local'); $c->install(); $c = Catalog::create_catalog_type('remote'); $c->install(); while ($results = Dba::fetch_assoc($db_results)) { if ($results['catalog_type'] == 'local') { $sql = "INSERT INTO `catalog_local` (`path`, `catalog_id`) VALUES (?, ?)"; $retval &= Dba::write($sql, array($results['path'], $results['id'])); } elseif ($results['catalog_type'] == 'remote') { $sql = "INSERT INTO `catalog_remote` (`uri`, `username`, `password`, `catalog_id`) VALUES (?, ?, ?, ?)"; $retval &= Dba::write($sql, array($results['path'], $results['remote_username'], $results['remote_password'], $results['id'])); } } $sql = "ALTER TABLE `catalog` DROP `path`, DROP `remote_username`, DROP `remote_password`"; $retval &= Dba::write($sql); $sql = "ALTER TABLE `catalog` MODIFY COLUMN `catalog_type` varchar(128)"; $retval &= Dba::write($sql); $sql = "UPDATE `artist` SET `mbid` = null WHERE `mbid` = ''"; $retval &= Dba::write($sql); $sql = "UPDATE `album` SET `mbid` = null WHERE `mbid` = ''"; $retval &= Dba::write($sql); $sql = "UPDATE `song` SET `mbid` = null WHERE `mbid` = ''"; $retval &= Dba::write($sql); return $retval; }
?> </th> <th class="cel_version"><?php echo T_('Version'); ?> </th> <th class="cel_action"><?php echo T_('Action'); ?> </th> </tr> </thead> <tbody> <?php foreach ($catalogs as $type) { $catalog = Catalog::create_catalog_type($type); if ($catalog == null) { continue; } $catalog->format(); if ($catalog->is_installed()) { $action = 'confirm_uninstall_catalog_type'; $action_txt = T_('Disable'); } else { $action = 'install_catalog_type'; $action_txt = T_('Activate'); } ?> <tr class="<?php echo UI::flip_class(); ?>