Refs #3115. Migrated twitterservice to twitter_api. Added upgrade to migrate plugin and user settings.

git-svn-id: http://code.elgg.org/elgg/trunk@8699 36083f99-b078-4883-b0ff-0f9b5a30f544

1 files changed, 52 insertions, 0 deletions

diff --git a/engine/lib/upgrades/2011031300-1.8_svn-twitter_api-12b832a5a7a3e1bd.php b/engine/lib/upgrades/2011031300-1.8_svn-twitter_api-12b832a5a7a3e1bd.php
new file mode 100644
index 000000000..0774cbea4
--- /dev/null
+++ b/engine/lib/upgrades/2011031300-1.8_svn-twitter_api-12b832a5a7a3e1bd.php
@@ -0,0 +1,52 @@
+<?php
+/**
+ * Elgg 1.8-svn upgrade 2011031300
+ * twitter_api
+ *
+ * Updates the database for twitterservice to twitter_api changes.
+ */
+
+// make sure we have updated plugins
+elgg_generate_plugin_entities();
+
+$db_prefix = elgg_get_config('dbprefix');
+
+// find the old settings for twitterservice and copy them to the new one
+$options = array(
+	'type' => 'object',
+	'subtype' => 'plugin',
+	'joins' => array("JOIN {$db_prefix}objects_entity oe ON e.guid = oe.guid"),
+	'wheres' => array('title = "twitterservice"')
+);
+
+$objs = elgg_get_entities($options);
+
+if (!$objs) {
+	return true;
+}
+
+$service = $objs[0];
+
+$api = elgg_get_plugin_from_id('twitter_api');
+
+if (!$api) {
+	return true;
+}
+
+$settings = array('consumer_key', 'consumer_secret', 'sign_on', 'new_users');
+
+foreach ($settings as $setting) {
+	$api->setSetting($setting, $service->getSetting($setting));
+}
+
+// update the user settings
+$q = "UPDATE {$db_prefix}private_settings
+	SET name = replace('twitterservice', 'twitter_api', name)
+	WHERE name like '%twitterservice%'";
+
+update_data($q);
+
+if ($service->isActive()) {
+	$api->activate();
+	$service->deactivate();
+}