| Zeile 6 | Zeile 6 |
|---|
* Website: http://www.mybboard.com
* License: http://www.mybboard.com/eula.html
*
|
* Website: http://www.mybboard.com
* License: http://www.mybboard.com/eula.html
*
|
* $Id: upgrade5.php 2187 2006-09-02 13:48:31Z chris $
| * $Id: upgrade5.php 2439 2006-11-26 14:00:13Z CraKteR $
|
*/
/**
| */
/**
|
| Zeile 29 | Zeile 29 |
|---|
$output->print_header("Performing Queries");
echo "<p>Performing necessary upgrade queries..</p>";
|
$output->print_header("Performing Queries");
echo "<p>Performing necessary upgrade queries..</p>";
|
| |
|
$db->query("ALTER TABLE ".TABLE_PREFIX."users CHANGE avatartype avatartype varchar(10) NOT NULL;");
|
$db->query("ALTER TABLE ".TABLE_PREFIX."users CHANGE avatartype avatartype varchar(10) NOT NULL;");
|
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD totalpms int(10) NOT NULL default '0' AFTER showcodebuttons;");
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD newpms int(10) NOT NULL default '0' AFTER totalpms;");
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD unreadpms int(10) NOT NULL default '0' AFTER newpms;");
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD showredirect char(3) NOT NULL default '' AFTER showquickreply;");
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD avatardimensions varchar(10) NOT NULL default '' AFTER avatar;");
$db->query("ALTER TABLE ".TABLE_PREFIX."threads ADD unapprovedposts INT(10) unsigned NOT NULL default '0' AFTER visible;");
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD unapprovedthreads INT(10) unsigned NOT NULL default '0' AFTER rules;");
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD unapprovedposts INT(10) unsigned NOT NULL default '0' AFTER rules;");
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD defaultdatecut smallint(4) unsigned NOT NULL default '0' AFTER unapprovedposts;");
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD defaultsortby varchar(10) NOT NULL default '' AFTER defaultdatecut;");
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD defaultsortorder varchar(4) NOT NULL default '' AFTER defaultsortby;");
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD lastposteruid int(10) unsigned NOT NULL default '0' AFTER lastposter;");
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD lastpostsubject varchar(120) NOT NULL default '' AFTER lastposttid");
$db->query("ALTER TABLE ".TABLE_PREFIX."threads ADD lastposteruid int unsigned NOT NULL default '0' AFTER lastposter");
$db->query("ALTER TABLE ".TABLE_PREFIX."groupleaders ADD canmanagemembers char(3) NOT NULL default '' AFTER uid;");
$db->query("ALTER TABLE ".TABLE_PREFIX."groupleaders ADD canmanagerequests char(3) NOT NULL default '' AFTER canmanagemembers;");
$db->query("ALTER TABLE ".TABLE_PREFIX."adminoptions ADD caneditlangs char(3) NOT NULL default '' AFTER canedithelp;");
$db->query("ALTER TABLE ".TABLE_PREFIX."adminoptions ADD canrundbtools char(3) NOT NULL default ''");
$db->query("ALTER TABLE ".TABLE_PREFIX."themes ADD allowedgroups text NOT NULL default '' AFTER extracss;");
$db->query("ALTER TABLE ".TABLE_PREFIX."moderators ADD canmovetononmodforum char(3) NOT NULL default '' AFTER canmanagethreads;");
$db->query("ALTER TABLE ".TABLE_PREFIX."themes ADD csscached bigint(30) NOT NULL default '0'");
$db->query("UPDATE ".TABLE_PREFIX."adminoptions SET caneditlangs='yes'");
| if(!$db->field_exists('totalpms', TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD totalpms int(10) NOT NULL default '0' AFTER showcodebuttons;");
}
if(!$db->field_exists('newpms', TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD newpms int(10) NOT NULL default '0' AFTER totalpms;");
}
if(!$db->field_exists('unreadpms', TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD unreadpms int(10) NOT NULL default '0' AFTER newpms;");
}
if(!$db->field_exists('showredirect', TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD showredirect char(3) NOT NULL default '' AFTER showquickreply;");
}
if(!$db->field_exists('avatardimensions', TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD avatardimensions varchar(10) NOT NULL default '' AFTER avatar;");
}
if(!$db->field_exists('unapprovedposts', TABLE_PREFIX."threads"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."threads ADD unapprovedposts INT(10) unsigned NOT NULL default '0' AFTER visible;");
}
if(!$db->field_exists('unapprovedthreads', TABLE_PREFIX."forums"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD unapprovedthreads INT(10) unsigned NOT NULL default '0' AFTER rules;");
}
if(!$db->field_exists('unapprovedposts', TABLE_PREFIX."forums"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD unapprovedposts INT(10) unsigned NOT NULL default '0' AFTER rules;");
}
if(!$db->field_exists('defaultdatecut', TABLE_PREFIX."forums"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD defaultdatecut smallint(4) unsigned NOT NULL default '0' AFTER unapprovedposts;");
}
if(!$db->field_exists('defaultsortby', TABLE_PREFIX."forums"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD defaultsortby varchar(10) NOT NULL default '' AFTER defaultdatecut;");
}
if(!$db->field_exists('defaultsortorder', TABLE_PREFIX."forums"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD defaultsortorder varchar(4) NOT NULL default '' AFTER defaultsortby;");
}
if(!$db->field_exists('lastposteruid', TABLE_PREFIX."forums"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD lastposteruid int(10) unsigned NOT NULL default '0' AFTER lastposter;");
}
if(!$db->field_exists('lastpostsubject', TABLE_PREFIX."forums"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."forums ADD lastpostsubject varchar(120) NOT NULL default '' AFTER lastposttid");
}
if(!$db->field_exists('lastposteruid', TABLE_PREFIX."threads"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."threads ADD lastposteruid int unsigned NOT NULL default '0' AFTER lastposter");
}
if(!$db->field_exists('canmanagemembers', TABLE_PREFIX."groupleaders"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."groupleaders ADD canmanagemembers char(3) NOT NULL default '' AFTER uid;");
}
if(!$db->field_exists('canmanagerequests', TABLE_PREFIX."groupleaders"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."groupleaders ADD canmanagerequests char(3) NOT NULL default '' AFTER canmanagemembers;");
}
if(!$db->field_exists('caneditlangs', TABLE_PREFIX."adminoptions"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."adminoptions ADD caneditlangs char(3) NOT NULL default '' AFTER canedithelp;");
}
if(!$db->field_exists('canrundbtools', TABLE_PREFIX."adminoptions"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."adminoptions ADD canrundbtools char(3) NOT NULL default ''");
}
if(!$db->field_exists('allowedgroups', TABLE_PREFIX."themes"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."themes ADD allowedgroups text NOT NULL AFTER extracss;");
}
if(!$db->field_exists('canmovetononmodforum', TABLE_PREFIX."moderators"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."moderators ADD canmovetononmodforum char(3) NOT NULL default '' AFTER canmanagethreads;");
}
if(!$db->field_exists('csscached', TABLE_PREFIX."themes"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."themes ADD csscached bigint(30) NOT NULL default '0'");
}
$db->query("UPDATE ".TABLE_PREFIX."adminoptions SET caneditlangs='yes' WHERE canrunmaint='yes'");
$db->query("UPDATE ".TABLE_PREFIX."adminoptions SET caneditlangs='no' WHERE canrunmaint='no'");
|
$db->query("UPDATE ".TABLE_PREFIX."adminoptions SET canrundbtools='yes' WHERE canrunmaint='yes'");
$db->query("UPDATE ".TABLE_PREFIX."adminoptions SET canrundbtools='no' WHERE canrunmaint='no'");
$db->query("UPDATE ".TABLE_PREFIX."settings SET optionscode='select\r\ninstant=Instant Activation\r\nverify=Send Email Verification\r\nrandompass=Send Random Password\r\nadmin=Administrator Activation' WHERE name = 'regtype'");
$db->query("UPDATE ".TABLE_PREFIX."users SET totalpms='-1', newpms='-1', unreadpms='-1'");
$db->query("UPDATE ".TABLE_PREFIX."settings SET name='maxmessagelength' WHERE name='messagelength'");
|
$db->query("UPDATE ".TABLE_PREFIX."adminoptions SET canrundbtools='yes' WHERE canrunmaint='yes'");
$db->query("UPDATE ".TABLE_PREFIX."adminoptions SET canrundbtools='no' WHERE canrunmaint='no'");
$db->query("UPDATE ".TABLE_PREFIX."settings SET optionscode='select\r\ninstant=Instant Activation\r\nverify=Send Email Verification\r\nrandompass=Send Random Password\r\nadmin=Administrator Activation' WHERE name = 'regtype'");
$db->query("UPDATE ".TABLE_PREFIX."users SET totalpms='-1', newpms='-1', unreadpms='-1'");
$db->query("UPDATE ".TABLE_PREFIX."settings SET name='maxmessagelength' WHERE name='messagelength'");
|
$db->query("UPDATE ".TABLE_PREFIX."users SET language=''");
$db->query("UPDATE ".TABLE_PREFIX."settings SET value='english' WHERE name='cplanguage'");
$db->query("UPDATE ".TABLE_PREFIX."settings SET value='english' WHERE name='bblanguage'");
| |
$db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."mycode");
$db->query("CREATE TABLE ".TABLE_PREFIX."mycode (
cid int unsigned NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
|
$db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."mycode");
$db->query("CREATE TABLE ".TABLE_PREFIX."mycode (
cid int unsigned NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
|
description text NOT NULL default '',
regex text NOT NULL default '',
replacement text NOT NULL default '',
| description text NOT NULL,
regex text NOT NULL,
replacement text NOT NULL,
|
active char(3) NOT NULL default '',
PRIMARY KEY(cid)
) TYPE=MyISAM;");
| active char(3) NOT NULL default '',
PRIMARY KEY(cid)
) TYPE=MyISAM;");
|
| Zeile 115 | Zeile 196 |
|---|
uid int unsigned NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
ipaddress varchar(120) NOT NULL default '',
|
uid int unsigned NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
ipaddress varchar(120) NOT NULL default '',
|
threads text NOT NULL default '',
posts text NOT NULL default '',
| threads text NOT NULL,
posts text NOT NULL,
|
searchtype varchar(10) NOT NULL default '',
resulttype varchar(10) NOT NULL default '',
|
searchtype varchar(10) NOT NULL default '',
resulttype varchar(10) NOT NULL default '',
|
querycache text NOT NULL default '',
| querycache text NOT NULL,
|
PRIMARY KEY (sid)
) TYPE=MyISAM;");
| PRIMARY KEY (sid)
) TYPE=MyISAM;");
|
| Zeile 142 | Zeile 223 |
|---|
$bannedips = $db->fetch_field($query, 'sid');
$bannedips = explode(" ", $bannedips);
$bannedips = implode(",", $bannedips);
|
$bannedips = $db->fetch_field($query, 'sid');
$bannedips = explode(" ", $bannedips);
$bannedips = implode(",", $bannedips);
|
$query = $db->query("UPDATE ".TABLE_PREFIX."settings SET value='".$db->escape_string($bannedips)."' WHERE name='bannedips'");
| $db->query("UPDATE ".TABLE_PREFIX."settings SET value='".$db->escape_string($bannedips)."' WHERE name='bannedips'");
|
|
|
$query = $db->query("DROP TABLE ".TABLE_PREFIX."reputation");
| $db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."reputation");
|
|
|
$query = $db->query("CREATE TABLE ".TABLE_PREFIX."reputation (
| $db->query("CREATE TABLE ".TABLE_PREFIX."reputation (
|
rid int unsigned NOT NULL auto_increment,
uid int unsigned NOT NULL default '0',
adduid int unsigned NOT NULL default '0',
| rid int unsigned NOT NULL auto_increment,
uid int unsigned NOT NULL default '0',
adduid int unsigned NOT NULL default '0',
|
| Zeile 156 | Zeile 237 |
|---|
PRIMARY KEY(rid)
) TYPE=MyISAM;");
|
PRIMARY KEY(rid)
) TYPE=MyISAM;");
|
$query = $db->query("CREATE TABLE ".TABLE_PREFIX."mailqueue (
| $db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."mailqueue");
$db->query("CREATE TABLE ".TABLE_PREFIX."mailqueue (
|
mid int unsigned NOT NULL auto_increment,
mailto varchar(200) NOT NULL,
mailfrom varchar(200) NOT NULL,
| mid int unsigned NOT NULL auto_increment,
mailto varchar(200) NOT NULL,
mailfrom varchar(200) NOT NULL,
|
| Zeile 164 | Zeile 246 |
|---|
message text NOT NULL,
headers text NOT NULL,
PRIMARY KEY(mid)
|
message text NOT NULL,
headers text NOT NULL,
PRIMARY KEY(mid)
|
) TYPE=MyISAM;");
$db->query("UPDATE ".TABLE_PREFIX."users SET reputation='0'");
| ) TYPE=MyISAM;");
$db->query("UPDATE ".TABLE_PREFIX."users SET reputation='0'");
|
$db->query("UPDATE ".TABLE_PREFIX."usergroups SET reputationpower='1'");
$db->query("UPDATE ".TABLE_PREFIX."usergroups SET reputationpower='2' WHERE cancp='yes'");
|
$db->query("UPDATE ".TABLE_PREFIX."usergroups SET reputationpower='1'");
$db->query("UPDATE ".TABLE_PREFIX."usergroups SET reputationpower='2' WHERE cancp='yes'");
|
$db->query("ALTER TABLE ".TABLE_PREFIX."users DROP rating;");
$db->query("ALTER TABLE ".TABLE_PREFIX."threads ADD attachmentcount int(10) unsigned NOT NULL default '0'");
$db->query("ALTER TABLE ".TABLE_PREFIX."posts ADD posthash varchar(32) NOT NULL default '' AFTER visible");
| if($db->field_exists('rating', TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users DROP rating;");
}
if(!$db->field_exists('attachmentcount', TABLE_PREFIX."threads"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."threads ADD attachmentcount int(10) unsigned NOT NULL default '0'");
}
if(!$db->field_exists('posthash', TABLE_PREFIX."posts"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."posts ADD posthash varchar(32) NOT NULL default '' AFTER visible");
}
|
$db->query("ALTER TABLE ".TABLE_PREFIX."attachtypes CHANGE extension extension varchar(10) NOT NULL;");
|
$db->query("ALTER TABLE ".TABLE_PREFIX."attachtypes CHANGE extension extension varchar(10) NOT NULL;");
|
$db->query("ALTER TABLE ".TABLE_PREFIX."threads ADD deletetime int(10) unsigned NOT NULL default '0' AFTER attachmentcount");
$db->query("ALTER TABLE ".TABLE_PREFIX."sessions ADD loginattempts tinyint(2) NOT NULL default '1'");
$db->query("ALTER TABLE ".TABLE_PREFIX."sessions ADD failedlogin bigint(30) NOT NULL default '0'");
$db->query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD canviewthreads char(3) NOT NULL default '' AFTER canview");
$db->query("ALTER TABLE ".TABLE_PREFIX."forumpermissions ADD canviewthreads char(3) NOT NULL default '' AFTER canview");
$db->query("DROP TABLE ".TABLE_PREFIX."regimages");
|
if(!$db->field_exists('deletetime', TABLE_PREFIX."threads"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."threads ADD deletetime int(10) unsigned NOT NULL default '0' AFTER attachmentcount");
}
if(!$db->field_exists('loginattempts', TABLE_PREFIX."sessions"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."sessions ADD loginattempts tinyint(2) NOT NULL default '1'");
}
if(!$db->field_exists('failedlogin', TABLE_PREFIX."sessions"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."sessions ADD failedlogin bigint(30) NOT NULL default '0'");
}
if(!$db->field_exists('canviewthreads', TABLE_PREFIX."usergroups"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD canviewthreads char(3) NOT NULL default '' AFTER canview");
}
if(!$db->field_exists('canviewthreads', TABLE_PREFIX."forumpermissions"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."forumpermissions ADD canviewthreads char(3) NOT NULL default '' AFTER canview");
}
$db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."captcha");
|
$db->query("CREATE TABLE ".TABLE_PREFIX."captcha (
imagehash varchar(32) NOT NULL default '',
imagestring varchar(8) NOT NULL default '',
dateline bigint(30) NOT NULL default '0'
) TYPE=MyISAM;");
|
$db->query("CREATE TABLE ".TABLE_PREFIX."captcha (
imagehash varchar(32) NOT NULL default '',
imagestring varchar(8) NOT NULL default '',
dateline bigint(30) NOT NULL default '0'
) TYPE=MyISAM;");
|
$db->query("ALTER TABLE ".TABLE_PREFIX."moderatorlog ADD data text NOT NULL default '' AFTER action;");
| if(!$db->field_exists('data', TABLE_PREFIX."moderatorlog"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."moderatorlog ADD data text NOT NULL AFTER action;");
}
$db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."adminsessions");
|
$db->query("CREATE TABLE ".TABLE_PREFIX."adminsessions (
sid varchar(32) NOT NULL default '',
uid int unsigned NOT NULL default '0',
| $db->query("CREATE TABLE ".TABLE_PREFIX."adminsessions (
sid varchar(32) NOT NULL default '',
uid int unsigned NOT NULL default '0',
|
| Zeile 206 | Zeile 317 |
|---|
lastactive bigint(30) NOT NULL default '0'
) TYPE=MyISAM;");
|
lastactive bigint(30) NOT NULL default '0'
) TYPE=MyISAM;");
|
| | $db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."modtools");
|
$db->query("CREATE TABLE ".TABLE_PREFIX."modtools (
tid smallint unsigned NOT NULL auto_increment,
name varchar(200) NOT NULL,
| $db->query("CREATE TABLE ".TABLE_PREFIX."modtools (
tid smallint unsigned NOT NULL auto_increment,
name varchar(200) NOT NULL,
|
| Zeile 217 | Zeile 329 |
|---|
PRIMARY KEY (tid)
) TYPE=MyISAM;");
|
PRIMARY KEY (tid)
) TYPE=MyISAM;");
|
$db->query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD disporder smallint(6) NOT NULL default '0' AFTER image");
| if(!$db->field_exists('disporder', TABLE_PREFIX."usergroups"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD disporder smallint(6) NOT NULL default '0' AFTER image");
}
|
$db->query("UPDATE ".TABLE_PREFIX."usergroups SET canviewthreads=canview");
$db->query("UPDATE ".TABLE_PREFIX."forumpermissions SET canviewthreads=canview");
|
$db->query("UPDATE ".TABLE_PREFIX."usergroups SET canviewthreads=canview");
$db->query("UPDATE ".TABLE_PREFIX."forumpermissions SET canviewthreads=canview");
|
echo "Done</p>";
echo "<p>Click next to continue with the upgrade process.</p>";
| $contents .= "Done</p>";
$contents .= "<p>Click next to continue with the upgrade process.</p>";
|
$output->print_contents($contents);
$output->print_footer("5_redoconfig");
}
| $output->print_contents($contents);
$output->print_footer("5_redoconfig");
}
|
| Zeile 256 | Zeile 372 |
|---|
exit;
}
|
exit;
}
|
$fh = @fopen(MYBB_ROOT."/inc/config.php", "w");
| $fh = @fopen(MYBB_ROOT."inc/config.php", "w");
|
if(!$fh)
{
echo "<p><span style=\"color: red; font-weight: bold;\">Unable to open inc/config.php</span><br />Before the upgrade process can continue, you need to changes the permissions of inc/config.php so it is writable.</p><input type=\"hidden\" name=\"uid\" value=\"{$uid}\" />";
| if(!$fh)
{
echo "<p><span style=\"color: red; font-weight: bold;\">Unable to open inc/config.php</span><br />Before the upgrade process can continue, you need to changes the permissions of inc/config.php so it is writable.</p><input type=\"hidden\" name=\"uid\" value=\"{$uid}\" />";
|
| Zeile 275 | Zeile 391 |
|---|
}
$configdata = "<?php
/**
|
}
$configdata = "<?php
/**
|
* Daatabase configuration
| * Database configuration
|
*/
\$config['dbtype'] = '{$config['dbtype']}';
| */
\$config['dbtype'] = '{$config['dbtype']}';
|
| Zeile 284 | Zeile 400 |
|---|
\$config['password'] = '{$config['password']}';
\$config['database'] = '{$config['database']}';
\$config['table_prefix'] = '{$config['table_prefix']}';
|
\$config['password'] = '{$config['password']}';
\$config['database'] = '{$config['database']}';
\$config['table_prefix'] = '{$config['table_prefix']}';
|
/**
|
/**
|
* Admin CP directory
* For security reasons, it is recommended you
* rename your Admin CP directory. You then need
| * Admin CP directory
* For security reasons, it is recommended you
* rename your Admin CP directory. You then need
|
| Zeile 351 | Zeile 467 |
|---|
}
else
{
|
}
else
{
|
$query = $db->simple_select(TABLE_PREFIX."threads", "COUNT(*) as num_threads");
| $query = $db->simple_select(TABLE_PREFIX."threads", "COUNT(*) as num_threads", "closed NOT LIKE 'moved|%'");
|
$num_threads = $db->fetch_field($query, 'num_threads');
$tpp = intval($_POST['tpp']);
$start = intval($_POST['start']);
$end = $start+$tpp;
|
$num_threads = $db->fetch_field($query, 'num_threads');
$tpp = intval($_POST['tpp']);
$start = intval($_POST['start']);
$end = $start+$tpp;
|
| | if($end > $num_threads)
{
$end = $num_threads;
}
|
echo "<p>Updating {$start} to {$end} of {$num_threads}...</p>";
|
echo "<p>Updating {$start} to {$end} of {$num_threads}...</p>";
|
$query = $db->simple_select(TABLE_PREFIX."threads", "tid, firstpost", "", array("order_by" => "tid", "order_dir" => "asc", "limit" => $tpp, "limit_start" => $start));
| $query = $db->simple_select(TABLE_PREFIX."threads", "tid, firstpost", "closed NOT LIKE 'moved|%'", array("order_by" => "tid", "order_dir" => "asc", "limit" => $tpp, "limit_start" => $start));
|
while($thread = $db->fetch_array($query))
{
update_thread_count($thread['tid']);
| while($thread = $db->fetch_array($query))
{
update_thread_count($thread['tid']);
|