Vergleich install/resources/upgrade30.php - 1.8.3 - 1.8.23

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 9Zeile 9
 */

/**

 */

/**

 * Upgrade Script: 1.6.14 or 1.6.15

 * Upgrade Script: 1.6.14, 1.6.15, 1.6.16, 1.6.17 or 1.6.18

 */

$upgrade_detail = array(

 */

$upgrade_detail = array(

Zeile 330Zeile 330
	$db->update_query('profilefields', array('viewableby' => '-1', 'editableby' => '-1'));

global $footer_extra;

	$db->update_query('profilefields', array('viewableby' => '-1', 'editableby' => '-1'));

global $footer_extra;

	$footer_extra = "<script type=\"text/javascript\">$(document).ready(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";

	$footer_extra = "<script type=\"text/javascript\">$(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges2");


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges2");

Zeile 480Zeile 480
	$db->update_query('forums', array('usethreadcounts' => 1), 'usepostcounts = 1');

global $footer_extra;

	$db->update_query('forums', array('usethreadcounts' => 1), 'usepostcounts = 1');

global $footer_extra;

	$footer_extra = "<script type=\"text/javascript\">$(document).ready(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";

	$footer_extra = "<script type=\"text/javascript\">$(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges3");


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges3");

Zeile 616Zeile 616
	}

global $footer_extra;

	}

global $footer_extra;

	$footer_extra = "<script type=\"text/javascript\">$(document).ready(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";

	$footer_extra = "<script type=\"text/javascript\">$(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges4");


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges4");

Zeile 747Zeile 747
	$db->update_query("maillogs", $update_array, "tid > '0'");

global $footer_extra;

	$db->update_query("maillogs", $update_array, "tid > '0'");

global $footer_extra;

	$footer_extra = "<script type=\"text/javascript\">$(document).ready(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";

	$footer_extra = "<script type=\"text/javascript\">$(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges5");


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges5");

Zeile 861Zeile 861
	}

global $footer_extra;

	}

global $footer_extra;

	$footer_extra = "<script type=\"text/javascript\">$(document).ready(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";

	$footer_extra = "<script type=\"text/javascript\">$(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges6");


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges6");

Zeile 1116Zeile 1116
		$groups[] = "'{$group['gid']}'";
}


		$groups[] = "'{$group['gid']}'";
}


	$usergroups = implode(',', $groups);
$db->update_query('usergroups', array('canbereported' => 1), "gid IN ({$usergroups})");




	if(!empty($groups))
{
$usergroups = implode(',', $groups);
$db->update_query('usergroups', array('canbereported' => 1), "gid IN ({$usergroups})");
}


$db->update_query('usergroups', array('canviewboardclosed' => 1), 'cancp = 1');



$db->update_query('usergroups', array('canviewboardclosed' => 1), 'cancp = 1');


Zeile 1246Zeile 1249
	}
else
{

	}
else
{

		$threads = $_POST['theadspage'];

		$threads = (int)$_POST['theadspage'];

	}

if($_POST['threadstart'])
{

	}

if($_POST['threadstart'])
{

		$startat = $_POST['threadstart'];

		$startat = (int)$_POST['threadstart'];

		$upper = $startat+$threads;
$lower = $startat;
}

		$upper = $startat+$threads;
$lower = $startat;
}

Zeile 1301Zeile 1304
	$output->print_contents($contents);

global $footer_extra;

	$output->print_contents($contents);

global $footer_extra;

	$footer_extra = "<script type=\"text/javascript\">$(document).ready(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";

	$footer_extra = "<script type=\"text/javascript\">$(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";


$output->print_footer($nextact);
}


$output->print_footer($nextact);
}

Zeile 1386Zeile 1389
			$db->modify_column("warninglevels", "percentage", "smallint(3) NOT NULL default '0'");
$db->modify_column("warningtypes", "points", "smallint unsigned NOT NULL default '0'");
$db->modify_column("warnings", "points", "smallint unsigned NOT NULL default '0'");

			$db->modify_column("warninglevels", "percentage", "smallint(3) NOT NULL default '0'");
$db->modify_column("warningtypes", "points", "smallint unsigned NOT NULL default '0'");
$db->modify_column("warnings", "points", "smallint unsigned NOT NULL default '0'");

			break;
}


			break;
}


	if($db->type != "pgsql")
{
// PgSQL doesn't support longtext

	if($db->type != "pgsql")
{
// PgSQL doesn't support longtext

Zeile 1405Zeile 1408
	}

global $footer_extra;

	}

global $footer_extra;

	$footer_extra = "<script type=\"text/javascript\">$(document).ready(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";

	$footer_extra = "<script type=\"text/javascript\">$(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges_optimize2");


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges_optimize2");

Zeile 1504Zeile 1507
	}

global $footer_extra;

	}

global $footer_extra;

	$footer_extra = "<script type=\"text/javascript\">$(document).ready(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";

	$footer_extra = "<script type=\"text/javascript\">$(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges_optimize3");


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges_optimize3");

Zeile 1579Zeile 1582
	}

global $footer_extra;

	}

global $footer_extra;

	$footer_extra = "<script type=\"text/javascript\">$(document).ready(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";

	$footer_extra = "<script type=\"text/javascript\">$(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges_optimize4");


$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges_optimize4");

Zeile 1628Zeile 1631
		"threads" => array("dateline", "lastpost"),
"threadsread" => array("dateline"),
"threadsubscriptions" => array("dateline"),

		"threads" => array("dateline", "lastpost"),
"threadsread" => array("dateline"),
"threadsubscriptions" => array("dateline"),

		"threadsread" => array("dateline"),

 
		"usergroups" => array("reputationpower", "maxreputationsday", "maxreputationsperuser", "maxreputationsperthread", "attachquota"),
"users" => array("regdate", "lastactive", "lastvisit", "lastpost", "timeonline", "moderationtime", "suspensiontime", "suspendsigtime"),
"warningtypes" => array("expirationtime"),

		"usergroups" => array("reputationpower", "maxreputationsday", "maxreputationsperuser", "maxreputationsperthread", "attachquota"),
"users" => array("regdate", "lastactive", "lastvisit", "lastpost", "timeonline", "moderationtime", "suspensiontime", "suspendsigtime"),
"warningtypes" => array("expirationtime"),

Zeile 1642Zeile 1644
		foreach($columns as $column)
{
if($db->type == "pgsql")

		foreach($columns as $column)
{
if($db->type == "pgsql")

			{

			{

				$db->modify_column($table, $column, "int", "set", "'0'");
}
else if($db->type == "sqlite")

				$db->modify_column($table, $column, "int", "set", "'0'");
}
else if($db->type == "sqlite")

			{

			{

				$change_column[] = "CHANGE {$column} {$column} int unsigned NOT NULL default '0'";
}
else
{
$change_column[] = "MODIFY {$column} int unsigned NOT NULL default '0'";
}

				$change_column[] = "CHANGE {$column} {$column} int unsigned NOT NULL default '0'";
}
else
{
$change_column[] = "MODIFY {$column} int unsigned NOT NULL default '0'";
}

		}

		}

		if($db->type != "pgsql")
{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."{$table} ".implode(", ", $change_column));

		if($db->type != "pgsql")
{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."{$table} ".implode(", ", $change_column));

		}
}


		}
}


	$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges_smilies");
}

	$output->print_contents("<p>Click next to continue with the upgrade process.</p>");
$output->print_footer("30_dbchanges_smilies");
}

Zeile 1676Zeile 1678
	if($db->type == 'pgsql')
{
$db->modify_column("smilies", "find", "text", "set");

	if($db->type == 'pgsql')
{
$db->modify_column("smilies", "find", "text", "set");

	}

	}

	else
{
$db->modify_column("smilies", "find", "text NOT NULL");

	else
{
$db->modify_column("smilies", "find", "text NOT NULL");

Zeile 1710Zeile 1712
				else
{
$find[] = $dupe['find'];

				else
{
$find[] = $dupe['find'];

				}

				}

			}
$dupes = rtrim($dupes, ',');
$db->delete_query('smilies', 'sid IN('.$dupes.')');

			}
$dupes = rtrim($dupes, ',');
$db->delete_query('smilies', 'sid IN('.$dupes.')');

Zeile 1742Zeile 1744
	{
case 8:
echo "<p>Adding database indices (3/3)...</p>";

	{
case 8:
echo "<p>Adding database indices (3/3)...</p>";

			flush();


			flush();


			if(!$db->index_exists('users', 'lastip'))
{
// This may take a while
if($db->type == "mysql" || $db->type == "mysqli")

			if(!$db->index_exists('users', 'lastip'))
{
// This may take a while
if($db->type == "mysql" || $db->type == "mysqli")

				{

				{

					$db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD INDEX lastip (lastip)");

					$db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD INDEX lastip (lastip)");

				}

				}

				elseif($db->type == "pgsql")
{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD INDEX (`lastip`)");

				elseif($db->type == "pgsql")
{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD INDEX (`lastip`)");

Zeile 1760Zeile 1762
			break;
case 7:
echo "<p>Adding database indices (2/3)...</p>";

			break;
case 7:
echo "<p>Adding database indices (2/3)...</p>";

			flush();

			flush();


if(!$db->index_exists('users', 'regip'))
{


if(!$db->index_exists('users', 'regip'))
{

Zeile 1793Zeile 1795
				}
}
$next_task = 7;

				}
}
$next_task = 7;

			break;

			break;

		case 5:
if(!$_POST['ipspage'])
{

		case 5:
if(!$_POST['ipspage'])
{

Zeile 1801Zeile 1803
			}
else
{

			}
else
{

				$ipp = $_POST['ipspage'];

				$ipp = (int)$_POST['ipspage'];

			}

if($_POST['ipstart'])
{

			}

if($_POST['ipstart'])
{

				$startat = $_POST['ipstart'];

				$startat = (int)$_POST['ipstart'];

				$upper = $startat+$ipp-1;
$lower = $startat;
}

				$upper = $startat+$ipp-1;
$lower = $startat;
}

Zeile 2124Zeile 2126
		$contents = "<p><input type=\"hidden\" name=\"iptask\" value=\"{$next_task}\" />{$iptable}{$ipstart}Done. Click Next to continue the IP conversion.</p>";

global $footer_extra;

		$contents = "<p><input type=\"hidden\" name=\"iptask\" value=\"{$next_task}\" />{$iptable}{$ipstart}Done. Click Next to continue the IP conversion.</p>";

global $footer_extra;

		$footer_extra = "<script type=\"text/javascript\">$(document).ready(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";

		$footer_extra = "<script type=\"text/javascript\">$(function() { var button = $('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>";

		$nextact = "30_dbchanges_ip";
}


		$nextact = "30_dbchanges_ip";
}


Zeile 2197Zeile 2199
					$sid = $db->insert_query("themestylesheets", $new_stylesheet);
$css_url = "css.php?stylesheet={$sid}";


					$sid = $db->insert_query("themestylesheets", $new_stylesheet);
$css_url = "css.php?stylesheet={$sid}";


					$cached = cache_stylesheet($tid, $stylesheet['attributes']['name'], $stylesheet['value']);

					$cached = cache_stylesheet(1, $stylesheet['attributes']['name'], $stylesheet['value']);


if($cached)
{


if($cached)
{

Zeile 2234Zeile 2236
	}

$update_array = array(

	}

$update_array = array(

		"properties" => $db->escape_string(serialize($properties)),
"stylesheets" => $db->escape_string(serialize($stylesheets))

		"properties" => $db->escape_string(my_serialize($properties)),
"stylesheets" => $db->escape_string(my_serialize($stylesheets))

	);

$db->update_query("themes", $update_array, "tid = '1'");

	);

$db->update_query("themes", $update_array, "tid = '1'");

Zeile 2291Zeile 2293
			}
}


			}
}


		$db->update_query("themes", array("properties" => $db->escape_string(serialize($properties))), "tid='{$theme['tid']}'");

		$db->update_query("themes", array("properties" => $db->escape_string(my_serialize($properties))), "tid='{$theme['tid']}'");

	}

$contents .= "done.</p>";

	}

$contents .= "done.</p>";

Zeile 2366Zeile 2368
			}

$update_array = array(

			}

$update_array = array(

				"properties" => $db->escape_string(serialize($properties)),
"stylesheets" => $db->escape_string(serialize($stylesheets))

				"properties" => $db->escape_string(my_serialize($properties)),
"stylesheets" => $db->escape_string(my_serialize($stylesheets))

			);

$db->update_query("themes", $update_array, "tid = '2'");

			);

$db->update_query("themes", $update_array, "tid = '2'");