<?php
/**
 * MyBB 1.8
 * Copyright 2014 MyBB Group, All Rights Reserved
 *
 * Website: http://www.mybb.com
 * License: http://www.mybb.com/about/license
 *
 */

/**
 * Find and replace a string in a particular template through every template set.
 *
 * @param string The name of the template
 * @param string The regular expression to match in the template
 * @param string The replacement string
 * @param int Set to 1 to automatically create templates which do not exist for that set (based off master) - Defaults to 1
 * @param int The maximum possible replacements for the regular expression
 * @return boolean true if updated one or more templates, false if not.
 */

function find_replace_templatesets($title, $find, $replace, $autocreate=1, $sid=false, $limit=-1)
{
	global $db, $mybb;

	$return = false;

    $sqlwhere = '>\'0\'';

	$template_sets = array(-2, -1);

	// Select all global with that title if not working on a specific template set
	if($sid !== false)
	{
        $sqlwhere = '=\''.(int)$sid.'\'';

		$query = $db->simple_select("templates", "tid, template", "title = '".$db->escape_string($title)."' AND sid='-1'");
		while($template = $db->fetch_array($query))
		{
			// Update the template if there is a replacement term or a change
			$new_template = preg_replace($find, $replace, $template['template'], $limit);
			if($new_template == $template['template'])
			{
				continue;
			}

			// The template is a custom template.  Replace as normal.
			$updated_template = array(
				"template" => $db->escape_string($new_template)
			);
			$db->update_query("templates", $updated_template, "tid='{$template['tid']}'");
		}
	}

	// Select all other modified templates with that title
	$query = $db->simple_select("templates", "tid, sid, template", "title = '".$db->escape_string($title)."' AND sid{$sqlwhere}");
	while($template = $db->fetch_array($query))
	{
		// Keep track of which templates sets have a modified version of this template already
		$template_sets[] = $template['sid'];

		// Update the template if there is a replacement term or a change
		$new_template = preg_replace($find, $replace, $template['template'], $limit);
		if($new_template == $template['template'])
		{
			continue;
		}

		// The template is a custom template.  Replace as normal.
		$updated_template = array(
			"template" => $db->escape_string($new_template)
		);
		$db->update_query("templates", $updated_template, "tid='{$template['tid']}'");

		$return = true;
	}

	// Add any new templates if we need to and are allowed to
	if($autocreate != 0)
	{
		// Select our master template with that title
		$query = $db->simple_select("templates", "title, template", "title='".$db->escape_string($title)."' AND sid='-2'", array('limit' => 1));
		$master_template = $db->fetch_array($query);
		$master_template['new_template'] = preg_replace($find, $replace, $master_template['template'], $limit);

		if($master_template['new_template'] != $master_template['template'])
		{
			// Update the rest of our template sets that are currently inheriting this template from our master set
			$query = $db->simple_select("templatesets", "sid", "sid NOT IN (".implode(',', $template_sets).") AND sid{$sqlwhere}");
			while($template = $db->fetch_array($query))
			{
				$insert_template = array(
					"title" => $db->escape_string($master_template['title']),
					"template" => $db->escape_string($master_template['new_template']),
					"sid" => $template['sid'],
					"version" => $mybb->version_code,
					"status" => '',
					"dateline" => TIME_NOW
				);
				$db->insert_query("templates", $insert_template);

				$return = true;
			}
		}
	}

	return $return;
}
