=====Category Update Action=====
>>==See also:==
Documentation: UpdateCategoryActionInfo.>>This is the development page for the category update action.::c::

%%(php)
<?php
/**
 * Converts from original category system to the system used in PageAndCategoryDivisionInACategory.
 *
 * @version		0.1
 * @license http://www.gnu.org/copyleft/gpl.html GNU General Public License
 *
 * @author		{@link http://wikkawiki.org/MasinAlDujaili Masin Al-Dujaili} (original code)
 *
 * @uses Wakka::IsAdmin()
 * @uses Wakka::FormClose()
 * @uses Wakka::FormOpen()
 * @uses Wakka::LoadAllPages()
 * @uses Wakka::SavePage()
 *
 * @todo		cleaning up code;
 * @todo		use central regex library for validation;
 */

// constants
if (!defined('UPDATE_LABEL')) define('UPDATE_LABEL', 'Update');
if (!defined('NO_ADMIN_MESSAGE')) define('NO_ADMIN_MESSAGE', '<p>Only administrators are allowed to use this function.</p>');
if (!defined('PAGE_LOAD_ERROR_MESSAGE')) define('PAGE_LOAD_ERROR_MESSAGE', "<p>An error occured while loading Wikka's pages.</p>");
if (!defined('UPDATE_ACTION_TEXT')) define('UPDATE_ACTION_TEXT', '<p>Update the old category system using <strong>Category</strong>Name to the new category system using [[(cat)Name]].</p>'
	.'<p>This action uses some constants to determine what to replace. So it might easily be adapted to other uses.</p>'
	.'<p><strong>Warning</strong>: This action touches <strong>any</strong> page that contains categories in the '
	.'original Wikka way of categorizing. It might create heavy server load. It might even happen, that the script '
	.'times out -- as far as I know, this might be safe. But: Whenever manipulating the database it\'s a good idea to '
	.'make a backup of it before doing anything.</p>');
if (!defined('OLD_CATEGORY_PATTERN')) define('OLD_CATEGORY_PATTERN', '%s');
if (!defined('NEW_CATEGORY_REPLACE_PATTERN')) define('NEW_CATEGORY_REPLACE_PATTERN', '[[(cat)%s]]');
if (!defined('NEW_CATEGORY_SEARCH_PATTERN')) define('NEW_CATEGORY_SEARCH_PATTERN', '\[\[\(cat\)%s\]\]');
if (!defined('CATEGORY_UPDATE_NOTE')) define('CATEGORY_UPDATE_NOTE', 'category update');

function isNewCategory($body, $categories)
{
	$cats = array();
	foreach($categories as $cat) $cats[] = sprintf(NEW_CATEGORY_SEARCH_PATTERN,$cat);
	$cats = '/'.implode('|', $cats).'/';
	
	if(preg_match_all($cats, $body, $body_cats) > 0) return TRUE;
	
	return FALSE; // if we come here, the tested body is still using the old category system
}

function updateCategory($body, $categories)
{
	$old_cats = array();
	$new_cats = array();
	foreach($categories as $cat)
	{
		$old_cats[] = sprintf('/'.OLD_CATEGORY_PATTERN.'/',$cat);
		$new_cats[] = sprintf(NEW_CATEGORY_REPLACE_PATTERN,$cat);
	}

	return preg_replace($old_cats, $new_cats, $body);
}

if(isset($_POST['submit']) && $_POST['submit'] == UPDATE_LABEL)
{
	if($this->isAdmin()) // begin, check for access to all our pages
	{
		if ($pages = $this->LoadAllPages()) // load all pages
		{
			// get all categories and make one big regular expression out of them
			$categories = $this->LoadAll("select tag from ".$this->config["table_prefix"]."pages where latest='Y' AND body LIKE '".mysql_real_escape_string('%{{category%')."' order by time desc");
			foreach($categories as $category)
			{
				$cat_array[] = $category['tag'];
			}
			$cat_regex = '('.implode('|', $cat_array).')';


			// gather categories the pages belong to
			$page_cats = array();
			foreach($pages as $page)
			{
				$tag = $page['tag'];
				preg_match_all($cat_regex, $page['body'], $page_cats[$tag]);
				if(sizeof($page_cats[$tag][0])) // only process those pages which have categories
				{
					$page_cats[$tag]['isNew'] = isNewCategory($page['body'], $page_cats[$tag][0]);
					if(!$page_cats[$tag]['isNew'])
					{
						$page['body'] = updateCategory($page['body'], $page_cats[$tag][0]);
						$this->SavePage($page['tag'], $page['body'], CATEGORY_UPDATE_NOTE);
					}
				}
			}
		}
		else
		{
			echo PAGE_LOAD_ERROR_MESSAGE;
		}
	}
	else
	{
		echo NO_ADMIN_MESSAGE;
	}
}
else
{
	echo UPDATE_ACTION_TEXT;
	echo $this->FormOpen('', '', 'post').
			'<input name="submit" type="submit" value="'.
			UPDATE_LABEL.'" />'.
			$this->FormClose();
}
?>
%%
::c::----
CategoryDevelopmentActions