<?php
/**
* @package      EasySocial
* @copyright    Copyright (C) 2010 - 2012 Stack Ideas Sdn Bhd. All rights reserved.
* @license      GNU/GPL, see LICENSE.php
* EasySocial is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* See COPYRIGHT.php for copyright notices and details.
*/
defined('_JEXEC') or die('Unauthorized Access');

require_once(EBLOG_ADMIN_INCLUDES . '/maintenance/dependencies.php');

class EasyBlogMaintenanceScriptFixDuplicateIntroContent extends EasyBlogMaintenanceScript
{
	public static $title = "Fix issue where intro and content having the same content.";
	public static $description = "Fix issue where intro and content having the same content.";

	public function main()
	{
		$config = EB::config();
		$db = EB::db();

		$query = "select count(1) FROM `#__easyblog_post` WHERE `version` > '5.0.44' AND `intro` = `content`";
		$db->setQuery($query);
		$result = $db->loadResult();

		if ($result) {
			$update = "update `#__easyblog_post` SET `version` = '5.0.44'";
			$update .= " WHERE `version` > '5.0.44'";
			$update .= " AND `intro` = `content`";

			$db->setQuery($update);
			$db->query();
		}

		return true;
	}

}
