| Zeile 3 | Zeile 3 |
|---|
* MyBB 1.2
* Copyright � 2006 MyBB Group, All Rights Reserved
*
|
* MyBB 1.2
* Copyright � 2006 MyBB Group, All Rights Reserved
*
|
* Website: http://www.mybboard.com
* License: http://www.mybboard.com/eula.html
| * Website: http://www.mybboard.net
* License: http://www.mybboard.net/eula.html
|
*
|
*
|
* $Id: upgrade3.php 1930 2006-07-12 02:00:11Z chris $
| * $Id: upgrade3.php 3030 2007-04-26 00:19:47Z Tikitiki $
|
*/
/**
| */
/**
|
| Zeile 103 | Zeile 103 |
|---|
$lower = 1;
}
|
$lower = 1;
}
|
require_once "../inc/settings.php";
| require_once MYBB_ROOT."inc/settings.php";
|
$query = $db->query("SELECT COUNT(aid) AS attachcount FROM ".TABLE_PREFIX."attachments");
$cnt = $db->fetch_array($query);
$contents .= "<p>Converting attachments $lower to $upper (".$cnt['attachcount']." Total)</p>";
echo "<p>Converting attachments $lower to $upper (".$cnt['attachcount']." Total)</p>";
|
$query = $db->query("SELECT COUNT(aid) AS attachcount FROM ".TABLE_PREFIX."attachments");
$cnt = $db->fetch_array($query);
$contents .= "<p>Converting attachments $lower to $upper (".$cnt['attachcount']." Total)</p>";
echo "<p>Converting attachments $lower to $upper (".$cnt['attachcount']." Total)</p>";
|
if(!$db->field_exists("donecon", TABLE_PREFIX."attachments"))
{
|
if(!$db->field_exists("uid", TABLE_PREFIX."attachments"))
{
|
// Add uid column
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments ADD uid smallint(6) NOT NULL AFTER posthash;");
|
// Add uid column
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments ADD uid smallint(6) NOT NULL AFTER posthash;");
|
| | }
|
|
|
| | if($db->field_exists("thumbnail", TABLE_PREFIX."attachments"))
{
|
// Drop thumbnail column
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments DROP thumbnail");
|
// Drop thumbnail column
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments DROP thumbnail");
|
| | }
|
|
|
| | if(!$db->field_exists("thumbnail", TABLE_PREFIX."attachments"))
{
|
// Readd thumbnail column
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments ADD thumbnail varchar(120) NOT NULL;");
|
// Readd thumbnail column
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments ADD thumbnail varchar(120) NOT NULL;");
|
| | }
|
|
|
| | if(!$db->field_exists("attachname", TABLE_PREFIX."attachments"))
{
|
// Add attachname column
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments ADD attachname varchar(120) NOT NULL AFTER filesize;");
|
// Add attachname column
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments ADD attachname varchar(120) NOT NULL AFTER filesize;");
|
| }
if(!$db->field_exists("donecon", TABLE_PREFIX."attachments"))
{
|
// Add temporary column
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments ADD donecon smallint(1) NOT NULL;");
}
| // Add temporary column
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments ADD donecon smallint(1) NOT NULL;");
}
|
| Zeile 143 | Zeile 156 |
|---|
unset($attachment['filedata']);
if($ext == "gif" || $ext == "png" || $ext == "jpg" || $ext == "jpeg" || $ext == "jpe")
{
|
unset($attachment['filedata']);
if($ext == "gif" || $ext == "png" || $ext == "jpg" || $ext == "jpeg" || $ext == "jpe")
{
|
require_once "../inc/functions_image.php";
| require_once MYBB_ROOT."inc/functions_image.php";
|
$thumbname = str_replace(".attach", "_thumb.$ext", $filename);
$thumbnail = generate_thumbnail("../uploads/".$filename, "../uploads", $thumbname, $settings['attachthumbh'], $settings['attachthumbw']);
if($thumbnail['code'] == 4)
| $thumbname = str_replace(".attach", "_thumb.$ext", $filename);
$thumbnail = generate_thumbnail("../uploads/".$filename, "../uploads", $thumbname, $settings['attachthumbh'], $settings['attachthumbw']);
if($thumbnail['code'] == 4)
|
| Zeile 163 | Zeile 176 |
|---|
$nextact = "3_convertattachments";
$startat = $startat+$app;
$contents .= "<p><input type=\"hidden\" name=\"attachmentspage\" value=\"$app\" /><input type=\"hidden\" name=\"attachmentstart\" value=\"$startat\" />Done. Click Next to move on to the next set of attachments.</p>";
|
$nextact = "3_convertattachments";
$startat = $startat+$app;
$contents .= "<p><input type=\"hidden\" name=\"attachmentspage\" value=\"$app\" /><input type=\"hidden\" name=\"attachmentstart\" value=\"$startat\" />Done. Click Next to move on to the next set of attachments.</p>";
|
}
| }
|
else
{
|
else
{
|
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments DROP donecon");
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments DROP filedata");
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments DROP thumbnailsm");
| if($db->field_exists("donecon", TABLE_PREFIX."attachments"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments DROP donecon");
}
if($db->field_exists("filedata", TABLE_PREFIX."attachments"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments DROP filedata");
}
if($db->field_exists("thumbnailsm", TABLE_PREFIX."attachments"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."attachments DROP thumbnailsm");
}
|
$nextact = "3_convertavatars";
$contents .= "<p>Done</p><p>All attachments have been moved to the file system. The next step is converting avatars to the file system.</p>";
$contents .= "<p>If you wish to change the number of uploaded avatars to process per page then you can do so below.</p>";
| $nextact = "3_convertavatars";
$contents .= "<p>Done</p><p>All attachments have been moved to the file system. The next step is converting avatars to the file system.</p>";
$contents .= "<p>If you wish to change the number of uploaded avatars to process per page then you can do so below.</p>";
|
| Zeile 188 | Zeile 210 |
|---|
if(!$_POST['userspage'])
{
$app = 50;
|
if(!$_POST['userspage'])
{
$app = 50;
|
}
else
{
$app = $_POST['userspage'];
}
| }
else
{
$app = $_POST['userspage'];
}
|
if($_POST['avatarstart'])
{
$startat = $_POST['avatarstart'];
$upper = $startat+$app;
$lower = $startat;
|
if($_POST['avatarstart'])
{
$startat = $_POST['avatarstart'];
$upper = $startat+$app;
$lower = $startat;
|
}
| }
|
else
{
$startat = 0;
$upper = $app;
$lower = 1;
|
else
{
$startat = 0;
$upper = $app;
$lower = 1;
|
}
| }
|
|
|
require_once "../inc/settings.php";
| require_once MYBB_ROOT."inc/settings.php";
|
$query = $db->query("SELECT COUNT(uid) AS avatarcount FROM ".TABLE_PREFIX."avatars");
$cnt = $db->fetch_array($query);
|
$query = $db->query("SELECT COUNT(uid) AS avatarcount FROM ".TABLE_PREFIX."avatars");
$cnt = $db->fetch_array($query);
|
| Zeile 216 | Zeile 238 |
|---|
// Add temporary column
if(!$db->field_exists("donecon", TABLE_PREFIX."avatars"))
|
// Add temporary column
if(!$db->field_exists("donecon", TABLE_PREFIX."avatars"))
|
{
| {
|
$db->query("ALTER TABLE ".TABLE_PREFIX."avatars ADD donecon smallint(1) NOT NULL;");
|
$db->query("ALTER TABLE ".TABLE_PREFIX."avatars ADD donecon smallint(1) NOT NULL;");
|
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD avatartype varchar(10) NOT NULL AFTER avatar;");
| }
if(!$db->field_exists("avatartype", TABLE_PREFIX."attachments"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD avatartype varchar(10) NOT NULL AFTER avatar;");
|
}
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."avatars WHERE donecon!='1' ORDER BY uid ASC LIMIT $app");
| }
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."avatars WHERE donecon!='1' ORDER BY uid ASC LIMIT $app");
|
| Zeile 265 | Zeile 290 |
|---|
}
else
{
|
}
else
{
|
$db->query("DROP TABLE ".TABLE_PREFIX."avatars");
| if($db->table_exists(TABLE_PREFIX."attachments"))
{
$db->query("DROP TABLE ".TABLE_PREFIX."avatars");
}
|
$nextact = "3_dbchanges2";
$contents .= "<p>Done</p><p>All avatars have been moved to the file system. The next step is performing the necessary database modifications for MyBB Gold.</p>";
}
$output->print_contents($contents);
$output->print_footer($nextact);
}
|
$nextact = "3_dbchanges2";
$contents .= "<p>Done</p><p>All avatars have been moved to the file system. The next step is performing the necessary database modifications for MyBB Gold.</p>";
}
$output->print_contents($contents);
$output->print_footer($nextact);
}
|
|
|
function upgrade3_dbchanges2()
{
global $db, $output;
|
function upgrade3_dbchanges2()
{
global $db, $output;
|
$output->print_header("Database Changes");
$contents = "<p>Performing necessary database changes.</p>";
| $output->print_header("Database Changes");
|
|
|
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD additionalgroups varchar(200) NOT NULL default '' AFTER usergroup;");
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD displaygroup smallint(6) NOT NULL default'0' AFTER additionalgroups;");
$db->query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD candisplaygroup varchar(3) NOT NULL;");
| $contents = "<p>Performing necessary database changes.</p>";
|
|
|
$db->query("ALTER TABLE ".TABLE_PREFIX."banned ADD reason varchar(200) NOT NULL");
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD rulestype smallint(1) NOT NULL;");
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD rulestitle varchar(200) NOT NULL;");
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD rules text NOT NULL;");
$db->query("ALTER TABLE ".TABLE_PREFIX."helpdocs ADD usetranslation CHAR( 3 ) NOT NULL AFTER document;");
$db->query("ALTER TABLE ".TABLE_PREFIX."helpdocs ADD enabled CHAR( 3 ) NOT NULL AFTER usetranslation;");
/*
This will break the upgrade for users who have customised help documents
$db->query("UPDATE ".TABLE_PREFIX."helpdocs SET hid='6' WHERE hid='7'");
$db->query("UPDATE ".TABLE_PREFIX."helpdocs SET hid='7' WHERE hid='8'");*/
$db->query("ALTER TABLE ".TABLE_PREFIX."helpsections ADD usetranslation CHAR( 3 ) NOT NULL AFTER description;");
$db->query("ALTER TABLE ".TABLE_PREFIX."helpsections ADD enabled CHAR( 3 ) NOT NULL AFTER usetranslation;");
$db->query("ALTER TABLE ".TABLE_PREFIX."threads ADD firstpost int unsigned NOT NULL default '0' AFTER dateline;");
| if(!$db->field_exists("additionalgroups", TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD additionalgroups varchar(200) NOT NULL default '' AFTER usergroup;");
}
if(!$db->field_exists("displaygroup", TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD displaygroup smallint(6) NOT NULL default'0' AFTER additionalgroups;");
}
if(!$db->field_exists("candisplaygroup", TABLE_PREFIX."usergroups"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD candisplaygroup varchar(3) NOT NULL;");
}
if(!$db->field_exists("reason", TABLE_PREFIX."banned"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."banned ADD reason varchar(200) NOT NULL");
}
if(!$db->field_exists("rulestype", TABLE_PREFIX."forums"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD rulestype smallint(1) NOT NULL;");
}
if(!$db->field_exists("rulestitle", TABLE_PREFIX."forums"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD rulestitle varchar(200) NOT NULL;");
}
if(!$db->field_exists("rules", TABLE_PREFIX."forums"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD rules text NOT NULL;");
}
if(!$db->field_exists("usetranslation", TABLE_PREFIX."helpdocs"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."helpdocs ADD usetranslation CHAR( 3 ) NOT NULL AFTER document;");
}
if(!$db->field_exists("enabled", TABLE_PREFIX."helpdocs"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."helpdocs ADD enabled CHAR( 3 ) NOT NULL AFTER usetranslation;");
}
/*
This will break the upgrade for users who have customised help documents
$db->query("UPDATE ".TABLE_PREFIX."helpdocs SET hid='6' WHERE hid='7'");
$db->query("UPDATE ".TABLE_PREFIX."helpdocs SET hid='7' WHERE hid='8'");*/
|
|
|
$db->query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD attachquota bigint(30) NOT NULL default '0';");
$db->query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD cancustomtitle varchar(3) NOT NULL;");
| if(!$db->field_exists("usetranslation", TABLE_PREFIX."helpsections"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."helpsections ADD usetranslation CHAR( 3 ) NOT NULL AFTER description;");
}
if(!$db->field_exists("enabled", TABLE_PREFIX."helpsections"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."helpsections ADD enabled CHAR( 3 ) NOT NULL AFTER usetranslation;");
}
if(!$db->field_exists("firstpost", TABLE_PREFIX."threads"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."threads ADD firstpost int unsigned NOT NULL default '0' AFTER dateline;");
}
if(!$db->field_exists("attachquota", TABLE_PREFIX."usergroups"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD attachquota bigint(30) NOT NULL default '0';");
}
if(!$db->field_exists("cancustomtitle", TABLE_PREFIX."usergroups"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD cancustomtitle varchar(3) NOT NULL;");
}
$db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."groupleaders;");
|
$db->query("CREATE TABLE ".TABLE_PREFIX."groupleaders (
lid smallint(6) NOT NULL auto_increment,
gid smallint(6) NOT NULL,
| $db->query("CREATE TABLE ".TABLE_PREFIX."groupleaders (
lid smallint(6) NOT NULL auto_increment,
gid smallint(6) NOT NULL,
|
| Zeile 314 | Zeile 381 |
|---|
PRIMARY KEY(lid)
);");
|
PRIMARY KEY(lid)
);");
|
| | $db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."joinrequests;");
|
$db->query("CREATE TABLE ".TABLE_PREFIX."joinrequests (
rid smallint(6) NOT NULL auto_increment,
uid smallint(6) NOT NULL,
| $db->query("CREATE TABLE ".TABLE_PREFIX."joinrequests (
rid smallint(6) NOT NULL auto_increment,
uid smallint(6) NOT NULL,
|
| Zeile 323 | Zeile 391 |
|---|
PRIMARY KEY(rid)
);");
|
PRIMARY KEY(rid)
);");
|
$db->query("DROP TABLE ".TABLE_PREFIX."online;");
| $db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."online;");
|
$db->query("CREATE TABLE ".TABLE_PREFIX."sessions (
sid varchar(32) NOT NULL default '',
uid int unsigned NOT NULL default '0',
| $db->query("CREATE TABLE ".TABLE_PREFIX."sessions (
sid varchar(32) NOT NULL default '',
uid int unsigned NOT NULL default '0',
|
| Zeile 340 | Zeile 408 |
|---|
KEY location2 (location2)
);");
|
KEY location2 (location2)
);");
|
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD salt varchar(10) NOT NULL AFTER password;");
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD loginkey varchar(50) NOT NULL AFTER salt;");
| if(!$db->field_exists("salt", TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD salt varchar(10) NOT NULL AFTER password;");
}
if(!$db->field_exists("loginkey", TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD loginkey varchar(50) NOT NULL AFTER salt;");
}
|
if($db->field_exists("pmnotify", TABLE_PREFIX."users"))
|
if($db->field_exists("pmnotify", TABLE_PREFIX."users"))
|
{
| {
|
$db->query("ALTER TABLE ".TABLE_PREFIX."users DROP pmnotify;");
|
$db->query("ALTER TABLE ".TABLE_PREFIX."users DROP pmnotify;");
|
| | }
if(!$db->field_exists("pmnotify", TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD pmnotify varchar(3) NOT NULL AFTER pmpopup;");
|
}
|
}
|
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD pmnotify varchar(3) NOT NULL AFTER pmpopup;");
| |
|
|
$db->query("DROP TABLE ".TABLE_PREFIX."settinggroups");
| $db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."settinggroups");
|
$db->query("CREATE TABLE ".TABLE_PREFIX."settinggroups (
gid smallint(6) NOT NULL auto_increment,
|
$db->query("CREATE TABLE ".TABLE_PREFIX."settinggroups (
gid smallint(6) NOT NULL auto_increment,
|
| Zeile 360 | Zeile 439 |
|---|
PRIMARY KEY (gid)
) TYPE=MyISAM;");
|
PRIMARY KEY (gid)
) TYPE=MyISAM;");
|
$db->query("DROP TABLE ".TABLE_PREFIX."settings");
| $db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."settings");
|
$db->query("CREATE TABLE ".TABLE_PREFIX."settings (
sid smallint(6) NOT NULL auto_increment,
|
$db->query("CREATE TABLE ".TABLE_PREFIX."settings (
sid smallint(6) NOT NULL auto_increment,
|
| Zeile 374 | Zeile 453 |
|---|
PRIMARY KEY (sid)
) TYPE=MyISAM;");
|
PRIMARY KEY (sid)
) TYPE=MyISAM;");
|
| | $db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."datacache;");
|
$db->query("CREATE TABLE ".TABLE_PREFIX."datacache (
title varchar(30) NOT NULL default '',
cache mediumtext NOT NULL,
| $db->query("CREATE TABLE ".TABLE_PREFIX."datacache (
title varchar(30) NOT NULL default '',
cache mediumtext NOT NULL,
|
| Zeile 696 | Zeile 776 |
|---|
echo "Done</p>";
|
echo "Done</p>";
|
$contents .= "<font color=\red\"><b>WARNING:</font> The next step will delete any custom themes or templates you have! Please back them up before continuing!</p>";
| $contents .= "<span style=\"color: red; font-weight: bold;\">WARNING:</span> The next step will delete any custom themes or templates you have! Please back them up before continuing!</p>";
|
$output->print_contents($contents);
$output->print_footer("3_done");
}
| $output->print_contents($contents);
$output->print_footer("3_done");
}
|