| Zeile 9 | Zeile 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 330 | Zeile 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 480 | Zeile 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 616 | Zeile 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 747 | Zeile 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 861 | Zeile 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 1116 | Zeile 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 1246 | Zeile 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 1301 | Zeile 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 1386 | Zeile 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 1405 | Zeile 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 1504 | Zeile 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 1579 | Zeile 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 1628 | Zeile 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 1642 | Zeile 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 1676 | Zeile 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 1710 | Zeile 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 1742 | Zeile 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 1760 | Zeile 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 1793 | Zeile 1795 |
|---|
}
}
$next_task = 7;
|
}
}
$next_task = 7;
|
break;
| break;
|
case 5:
if(!$_POST['ipspage'])
{
| case 5:
if(!$_POST['ipspage'])
{
|
| Zeile 1801 | Zeile 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 2124 | Zeile 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 2197 | Zeile 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 2234 | Zeile 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 2291 | Zeile 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 2366 | Zeile 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'");
|