diff options
Diffstat (limited to 'admin/upgrade_inc.php')
| -rw-r--r-- | admin/upgrade_inc.php | 213 |
1 files changed, 0 insertions, 213 deletions
diff --git a/admin/upgrade_inc.php b/admin/upgrade_inc.php deleted file mode 100644 index 1eaa2c3..0000000 --- a/admin/upgrade_inc.php +++ /dev/null @@ -1,213 +0,0 @@ -<?php - -global $gBitSystem, $gUpgradeFrom, $gUpgradeTo, $gBitDb; - -require_once( BLOGS_PKG_CLASS_PATH.'BitBlogPost.php' ); - -$upgrades = array( - - 'BWR1' => array( - 'BWR2' => array( -array( 'DATADICT' => array( - array( 'DROPTABLE' => array( - 'tiki_blog_activity' - )), - array( 'RENAMECOLUMN' => array( - 'tiki_blogs' => array( - '`public`' => '`is_public` C(1)', - ), - )), - array( 'ALTER' => array( - 'tiki_blogs' => array( - 'content_id' => array( '`content_id`', 'I4' ), // , 'NOTNULL' ), - ), - 'tiki_blog_posts' => array( - 'publish_date' => array( '`publish_date`', 'I4' ), - 'expire_date' => array( '`expire_date`', 'I4' ), - ), - )), - // de-tikify tables - array( 'RENAMETABLE' => array( - 'tiki_blogs' => 'blogs', - 'tiki_blog_posts' => 'blog_posts', - )), - array( 'CREATE' => array ( - 'blogs_posts_map' => " - crosspost_note X, - post_content_id I4 NOT NULL, - blog_content_id I4 NOT NULL, - date_added I4 - CONSTRAINT ' - , CONSTRAINT `blogs_posts_map_post_ref` FOREIGN KEY (`post_content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`) - , CONSTRAINT `blogs_posts_map_blog_ref` FOREIGN KEY (`blog_content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)' - ", - )), - array( 'RENAMESEQUENCE' => array( - "tiki_blog_posts_post_id_seq" => "blog_posts_post_id_seq", - )), -)), - - -// query: update blogs with content_id's -// query2: map blog_posts blog_ids to new table blogs_posts_map -// query3: create a blogs_blog_id_seq and bring the table up to date with the current max blog_id used in the blogs table - this basically for mysql -array( 'PHP' => ' - global $gBitSystem; - // make sure bitblog content type is registered - require_once( BLOGS_PKG_PATH."BitBlog.php" ); - $tempBlog = new BitBlog(); - $query = "SELECT * FROM `'.BIT_DB_PREFIX.'blogs` b"; - if( $rs = $gBitSystem->mDb->query( $query ) ) { - while( !$rs->EOF ) { - $contentHash = array(); - $blogId = $rs->fields["blog_id"]; - $conId = $gBitDb->GenID( "liberty_content_id_seq" ); - error_log( $conId."->".$blogId ); - $contentHash["content_id"] = $conId; - $contentHash["content_type_guid"] = BITBLOG_CONTENT_TYPE_GUID; - $contentHash["user_id"] = $rs->fields["user_id"]; - $contentHash["modifier_user_id"] = $rs->fields["user_id"]; - $contentHash["format_guid"] = PLUGIN_GUID_TIKIWIKI; - $contentHash["data"] = $rs->fields["description"]; - $contentHash["title"] = substr( $rs->fields["title"], 0, 160 ); - $contentHash["created"] = $rs->fields["created"]; - $contentHash["last_modified"] = $rs->fields["last_modified"]; - $gBitSystem->mDb->associateInsert( "liberty_content", $contentHash ); - $hitsHash = array(); - $hitsHash["hits"] = $rs->fields["hits"]; - $hitsHash["content_id"] = $conId; - $gBitSystem->mDb->associateInsert( "liberty_content_hits", $hitsHash ); - $gBitSystem->mDb->query( "UPDATE `'.BIT_DB_PREFIX.'blogs` SET `content_id`=? WHERE `blog_id`=? ", array( $conId, $blogId ) ); - $rs->MoveNext(); - } - } - $query2 = "INSERT INTO `'.BIT_DB_PREFIX.'blogs_posts_map` (`post_content_id`,`blog_content_id`,`date_added`) (SELECT blp.`content_id`, blc.`content_id`, bplc.`created` FROM `'.BIT_DB_PREFIX.'blog_posts` blp INNER JOIN `'.BIT_DB_PREFIX.'liberty_content` bplc ON(blp.`content_id`=bplc.`content_id`) INNER JOIN `'.BIT_DB_PREFIX.'blogs` bl ON(blp.`blog_id`=bl.`blog_id`) INNER JOIN `'.BIT_DB_PREFIX.'liberty_content` blc ON(bl.`content_id`=blc.`content_id`))"; - $gBitSystem->mDb->query( $query2 ); - $query3 = $gBitDb->getOne("SELECT MAX(blog_id) FROM `'.BIT_DB_PREFIX.'blogs`"); - $tempId = $gBitDb->mDb->GenID("blogs_blog_id_seq", $query3); -' ), - -// Drop moved columns -array( 'DATADICT' => array( - array( 'DROPCOLUMN' => array( - 'blogs' => array( '`user_id`', '`description`', '`created`', '`last_modified`', '`hits`', '`title`', '`heading`', '`posts`' ), - 'blog_posts' => array ( '`blog_id`' ), - )), -)), - - - ) - ), - -'TIKIWIKI19' => array ( - 'TIKIWIKI18' => array ( -/* Sliced and diced TW 1.9 upgrade scripts that did actual schema alterations - -ALTER TABLE `tiki_blog_posts` ADD `priv` VARCHAR( 1 ); -ALTER TABLE `tiki_blogs` ADD `show_avatar` char(1) default NULL; -ALTER TABLE tiki_blog_posts MODIFY data_size int(11) unsigned NOT NULL default '0'; - -*/ - ) -), - -'BONNIE' => array( - 'BWR1' => array( - -// STEP 1 -array( 'DATADICT' => array( -array( 'RENAMECOLUMN' => array( - 'tiki_blog_activity' => array( '`blogId`' => '`blog_id` I4' ), - 'tiki_blog_posts' => array( '`postId`' => '`post_id` I4 AUTO' , - '`blogId`' => '`blog_id` I4' ), - 'tiki_blogs' => array( '`blogId`' => '`blog_id` I4 AUTO', - '`lastModif`' => '`last_modified` I8', - '`maxPosts`' => '`max_posts` I4' ), -)), - -array( 'ALTER' => array( - 'tiki_blog_posts' => array( - 'user_id' => array( '`user_id`', 'I4' ), // , 'NOTNULL' ), - 'content_id' => array( '`content_id`', 'I4' ), // , 'NOTNULL' ), - ), - 'tiki_blogs' => array( - 'user_id' => array( '`user_id`', 'I4' ), // , 'NOTNULL' ), - ), -)), -/* -blog_posts` SET user_id=(SELECT uu.user_id FROM users_users uu WHERE tiki_blog_posts.`user`=uu.login)", -"UPDATE `".BIT_DB_PREFIX."tiki_blogs` SET `user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `user`=login)", -"ALTER TABLE `".BIT_DB_PREFIX."tiki_blogs` DROP `user`" - ) -*/ -)), - -// STEP 2 -array( 'QUERY' => - array( 'SQL92' => array( - "UPDATE `".BIT_DB_PREFIX."tiki_blogs` SET `user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `".BIT_DB_PREFIX."users_users`.`login`=`".BIT_DB_PREFIX."tiki_blogs`.`user`)", - "UPDATE `".BIT_DB_PREFIX."tiki_blog_posts` SET `user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `".BIT_DB_PREFIX."users_users`.`login`=`".BIT_DB_PREFIX."tiki_blog_posts`.`user`)", - "UPDATE `".BIT_DB_PREFIX."tiki_preferences` set `value`='last_modified_desc' where `name`='blog_list_order'", - "UPDATE `".BIT_DB_PREFIX."tiki_categorized_objects` SET `object_type`='".BITBLOGPOST_CONTENT_TYPE_GUID."' WHERE `object_type`='blogpost'", - ), -)), - - -// STEP 3 -array( 'PHP' => ' - global $gBitSystem; - $startPost = $gBitSystem->mDb->getOne( "SELECT MAX(`post_id`) FROM `'.BIT_DB_PREFIX.'tiki_blog_posts`" ); - $gBitSystem->mDb->CreateSequence( "tiki_blog_posts_post_id_seq", $startPost + 1 ); - $query = "SELECT tbp.`post_id`, uu.`user_id`, uu.`user_id` AS modifier_user_id, tbp.`created`, tbp.`created` AS last_modified, tbp.`data`, tbp.`title` - FROM `'.BIT_DB_PREFIX.'tiki_blog_posts` tbp INNER JOIN `'.BIT_DB_PREFIX.'users_users` uu ON( tbp.`user`=uu.`login` )"; - if( $rs = $gBitSystem->mDb->query( $query ) ) { - while( !$rs->EOF ) { - $postId = $rs->fields["post_id"]; - unset( $rs->fields["post_id"] ); - $conId = $gBitDb->GenID( "tiki_content_id_seq" ); - $rs->fields["content_id"] = $conId; - $rs->fields["content_type_guid"] = BITBLOGPOST_CONTENT_TYPE_GUID; - $rs->fields["format_guid"] = PLUGIN_GUID_TIKIWIKI; - $gBitSystem->mDb->associateInsert( "tiki_content", $rs->fields ); - $gBitSystem->mDb->query( "UPDATE `'.BIT_DB_PREFIX.'tiki_blog_posts` SET `content_id`=? WHERE `post_id`=? ", array( $conId, $postId ) ); - $rs->MoveNext(); - } - } -' ), - - -// STEP 4 -array( 'QUERY' => - array( 'SQL92' => array( - // Update Blog Post comments - we have no Blog level comments in BWR1 - "UPDATE `".BIT_DB_PREFIX."tiki_comments` SET `objectType`='".BITBLOGPOST_CONTENT_TYPE_GUID."' WHERE `objectType`='post'", - "UPDATE `".BIT_DB_PREFIX."tiki_comments` SET `parent_id`=(SELECT `content_id` FROM `".BIT_DB_PREFIX."tiki_blog_posts` WHERE `post_id`=`".BIT_DB_PREFIX."tiki_comments`.`object`) WHERE `parent_id`=0 AND `objectType`='".BITBLOGPOST_CONTENT_TYPE_GUID."'", - // Update preferences - "INSERT INTO `".BIT_DB_PREFIX."tiki_preferences`( `name`, `value`, `package` ) VALUES( 'blog_posts_description_length', '500', '".BLOGS_PKG_NAME."' )", - // Update permissions for viewing future and expired posts - "INSERT INTO `".BIT_DB_PREFIX."users_permissions`( `perm_name`,`perm_desc`, `perm_level`, `package` ) VALUES( 'p_blog_posts_read_future', 'Can view future dated posts', 'editors', ".BLOGS_PKG_NAME." )", - "INSERT INTO `".BIT_DB_PREFIX."users_permissions`( `perm_name`,`perm_desc`, `perm_level`, `package` ) VALUES( 'p_blog_posts_read_expired', 'Can view expired posts', 'editors', ".BLOGS_PKG_NAME." )", - ), -)), - - -// STEP 5 -array( 'DATADICT' => array( - array( 'DROPCOLUMN' => array( - 'tiki_blog_posts' => array( '`user`', '`created`', '`data`', '`title`' ), - 'tiki_blogs' => array( '`user`' ), - )), -)), - - - ) -) - -); - -if( isset( $upgrades[$gUpgradeFrom][$gUpgradeTo] ) ) { - $gBitSystem->registerUpgrade( BLOGS_PKG_NAME, $upgrades[$gUpgradeFrom][$gUpgradeTo] ); -} - - -?> |