Zeile 77 | Zeile 77 |
---|
function upgrade3_convertattachments() {
|
function upgrade3_convertattachments() {
|
global $db, $output;
| global $db, $output, $settings;
|
$output->print_header("Attachment Conversion to Files");
| $output->print_header("Attachment Conversion to Files");
|
Zeile 87 | Zeile 87 |
---|
} else {
|
} else {
|
$app = $_POST['attachmentspage'];
| $app = (int)$_POST['attachmentspage'];
|
}
if($_POST['attachmentstart']) {
|
}
if($_POST['attachmentstart']) {
|
$startat = $_POST['attachmentstart'];
| $startat = (int)$_POST['attachmentstart'];
|
$upper = $startat+$app; $lower = $startat; }
| $upper = $startat+$app; $lower = $startat; }
|
Zeile 111 | Zeile 111 |
---|
$contents .= "<p>Converting attachments $lower to $upper (".$cnt['attachcount']." Total)</p>"; echo "<p>Converting attachments $lower to $upper (".$cnt['attachcount']." Total)</p>";
|
$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("uid", TABLE_PREFIX."attachments"))
| if($db->field_exists("uid", "attachments"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP uid;"); }
| { $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP uid;"); }
|
Zeile 119 | Zeile 119 |
---|
$db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments ADD uid smallint(6) NOT NULL AFTER posthash;");
|
$db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments ADD uid smallint(6) NOT NULL AFTER posthash;");
|
if($db->field_exists("thumbnail", TABLE_PREFIX."attachments"))
| if($db->field_exists("thumbnail", "attachments"))
|
{ // Drop thumbnail column $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP thumbnail"); }
|
{ // Drop thumbnail column $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP thumbnail"); }
|
if($db->field_exists("thumbnail", TABLE_PREFIX."attachments"))
| if($db->field_exists("thumbnail", "attachments"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP thumbnail;"); } // Add thumbnail column $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments ADD thumbnail varchar(120) NOT NULL;");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP thumbnail;"); } // Add thumbnail column $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments ADD thumbnail varchar(120) NOT NULL;");
|
if($db->field_exists("attachname", TABLE_PREFIX."attachments"))
| if($db->field_exists("attachname", "attachments"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP attachname;"); } // Add attachname column $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments ADD attachname varchar(120) NOT NULL AFTER filesize;");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP attachname;"); } // Add attachname column $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments ADD attachname varchar(120) NOT NULL AFTER filesize;");
|
if(!$db->field_exists("donecon", TABLE_PREFIX."attachments"))
| if(!$db->field_exists("donecon", "attachments"))
|
{ // Add temporary column $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments ADD donecon smallint(1) NOT NULL;");
| { // Add temporary column $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments ADD donecon smallint(1) NOT NULL;");
|
Zeile 191 | Zeile 191 |
---|
} else {
|
} else {
|
if($db->field_exists("donecon", TABLE_PREFIX."attachments"))
| if($db->field_exists("donecon", "attachments"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP donecon"); }
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP donecon"); }
|
if($db->field_exists("filedata", TABLE_PREFIX."attachments"))
| if($db->field_exists("filedata", "attachments"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP filedata"); }
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP filedata"); }
|
if($db->field_exists("thumbnailsm", TABLE_PREFIX."attachments"))
| if($db->field_exists("thumbnailsm", "attachments"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP thumbnailsm"); }
| { $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP thumbnailsm"); }
|
Zeile 227 | Zeile 227 |
---|
} else {
|
} else {
|
$app = $_POST['userspage'];
| $app = (int)$_POST['userspage'];
|
}
if($_POST['avatarstart']) {
|
}
if($_POST['avatarstart']) {
|
$startat = $_POST['avatarstart'];
| $startat = (int)$_POST['avatarstart'];
|
$upper = $startat+$app; $lower = $startat; }
| $upper = $startat+$app; $lower = $startat; }
|
Zeile 251 | Zeile 251 |
---|
$contents .= "<p>Converting avatars $lower to $upper (".$cnt['avatarcount']." Total)</p>";
// Add temporary column
|
$contents .= "<p>Converting avatars $lower to $upper (".$cnt['avatarcount']." Total)</p>";
// Add temporary column
|
if(!$db->field_exists("donecon", TABLE_PREFIX."avatars"))
| if(!$db->field_exists("donecon", "avatars"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."avatars ADD donecon smallint(1) NOT NULL;"); }
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."avatars ADD donecon smallint(1) NOT NULL;"); }
|
if($db->field_exists("avatartype", TABLE_PREFIX."attachments"))
| if($db->field_exists("avatartype", "attachments"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP avatartype;"); }
| { $db->write_query("ALTER TABLE ".TABLE_PREFIX."attachments DROP avatartype;"); }
|
Zeile 325 | Zeile 325 |
---|
$contents = "<p>Performing necessary database changes.</p>";
|
$contents = "<p>Performing necessary database changes.</p>";
|
if($db->field_exists("additionalgroups", TABLE_PREFIX."users"))
| if($db->field_exists("additionalgroups", "users"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP additionalgroups;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD additionalgroups varchar(200) NOT NULL default '' AFTER usergroup;");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP additionalgroups;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD additionalgroups varchar(200) NOT NULL default '' AFTER usergroup;");
|
if($db->field_exists("displaygroup", TABLE_PREFIX."users"))
| if($db->field_exists("displaygroup", "users"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP displaygroup;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD displaygroup smallint(6) NOT NULL default '0' AFTER additionalgroups;");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP displaygroup;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD displaygroup smallint(6) NOT NULL default '0' AFTER additionalgroups;");
|
if($db->field_exists("candisplaygroup", TABLE_PREFIX."usergroups"))
| if($db->field_exists("candisplaygroup", "usergroups"))
|
{
|
{
|
$db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP candisplaygroup;");
| $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP candisplaygroup;");
|
} $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD candisplaygroup varchar(3) NOT NULL;");
|
} $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD candisplaygroup varchar(3) NOT NULL;");
|
if(!$db->field_exists("reason", TABLE_PREFIX."banned"))
| if($db->field_exists("reason", "banned"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."banned DROP reason;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."banned ADD reason varchar(200) NOT NULL");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."banned DROP reason;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."banned ADD reason varchar(200) NOT NULL");
|
if($db->field_exists("rulestype", TABLE_PREFIX."forums"))
| if($db->field_exists("rulestype", "forums"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums DROP rulestype;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums ADD rulestype smallint(1) NOT NULL;");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums DROP rulestype;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums ADD rulestype smallint(1) NOT NULL;");
|
if($db->field_exists("rulestitle", TABLE_PREFIX."forums"))
| if($db->field_exists("rulestitle", "forums"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums DROP rulestitle;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums ADD rulestitle varchar(200) NOT NULL;");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums DROP rulestitle;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums ADD rulestitle varchar(200) NOT NULL;");
|
if($db->field_exists("rules", TABLE_PREFIX."forums"))
| if($db->field_exists("rules", "forums"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums DROP rules;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums ADD rules text NOT NULL;");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums DROP rules;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums ADD rules text NOT NULL;");
|
if($db->field_exists("usetranslation", TABLE_PREFIX."helpdocs"))
| if($db->field_exists("usetranslation", "helpdocs"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums DROP helpdocs;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."helpdocs ADD usetranslation CHAR( 3 ) NOT NULL AFTER document;");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums DROP helpdocs;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."helpdocs ADD usetranslation CHAR( 3 ) NOT NULL AFTER document;");
|
if($db->field_exists("enabled", TABLE_PREFIX."helpdocs"))
| if($db->field_exists("enabled", "helpdocs"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."helpdocs DROP enabled;"); }
| { $db->write_query("ALTER TABLE ".TABLE_PREFIX."helpdocs DROP enabled;"); }
|
Zeile 386 | Zeile 386 |
---|
$db->write_query("UPDATE ".TABLE_PREFIX."helpdocs SET hid='6' WHERE hid='7'"); $db->write_query("UPDATE ".TABLE_PREFIX."helpdocs SET hid='7' WHERE hid='8'");*/
|
$db->write_query("UPDATE ".TABLE_PREFIX."helpdocs SET hid='6' WHERE hid='7'"); $db->write_query("UPDATE ".TABLE_PREFIX."helpdocs SET hid='7' WHERE hid='8'");*/
|
if($db->field_exists("usetranslation", TABLE_PREFIX."helpsections"))
| if($db->field_exists("usetranslation", "helpsections"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."helpsections DROP usetranslation;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."helpsections ADD usetranslation CHAR( 3 ) NOT NULL AFTER description;");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."helpsections DROP usetranslation;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."helpsections ADD usetranslation CHAR( 3 ) NOT NULL AFTER description;");
|
if($db->field_exists("enabled", TABLE_PREFIX."helpsections"))
| if($db->field_exists("enabled", "helpsections"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."helpsections DROP enabled;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."helpsections ADD enabled CHAR( 3 ) NOT NULL AFTER usetranslation;");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."helpsections DROP enabled;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."helpsections ADD enabled CHAR( 3 ) NOT NULL AFTER usetranslation;");
|
if($db->field_exists("firstpost", TABLE_PREFIX."threads"))
| if($db->field_exists("firstpost", "threads"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."threads DROP firstpost;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."threads ADD firstpost int unsigned NOT NULL default '0' AFTER dateline;");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."threads DROP firstpost;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."threads ADD firstpost int unsigned NOT NULL default '0' AFTER dateline;");
|
if($db->field_exists("attachquota", TABLE_PREFIX."usergroups"))
| if($db->field_exists("attachquota", "usergroups"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP attachquota;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD attachquota bigint(30) NOT NULL default '0';");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP attachquota;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD attachquota bigint(30) NOT NULL default '0';");
|
if($db->field_exists("cancustomtitle", TABLE_PREFIX."usergroups"))
| if($db->field_exists("cancustomtitle", "usergroups"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP cancustomtitle;"); }
| { $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP cancustomtitle;"); }
|
Zeile 452 | Zeile 452 |
---|
KEY location2 (location2) );");
|
KEY location2 (location2) );");
|
if($db->field_exists("salt", TABLE_PREFIX."users"))
| if($db->field_exists("salt", "users"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP salt;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD salt varchar(10) NOT NULL AFTER password;");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP salt;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD salt varchar(10) NOT NULL AFTER password;");
|
if($db->field_exists("loginkey", TABLE_PREFIX."users"))
| if($db->field_exists("loginkey", "users"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP loginkey;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD loginkey varchar(50) NOT NULL AFTER salt;");
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP loginkey;"); } $db->write_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", "users"))
|
{ $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP pmnotify;"); }
| { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP pmnotify;"); }
|