$trtitle
|
|
| $treaders |
Installing Table'; vbflush();
$db->hide_errors();
$db->query_write("CREATE TABLE ".TABLE_PREFIX."whoread (
userid int(10) unsigned NOT NULL default 0,
threadid int(10) unsigned NOT NULL default 0,
dateline int(10) unsigned NOT NULL default 0,
ipaddress varchar(20) NOT NULL default '',
PRIMARY KEY (userid,threadid),
KEY dateline (threadid,dateline),
KEY ipaddress (ipaddress))
");
$db->show_errors();
]]>
Removing Table'; vbflush();
$db->hide_errors();
$db->query_write("DROP TABLE ".TABLE_PREFIX."whoread");
$db->show_errors();
]]>
hide_errors();
$db->query_write("TRUNCATE ".TABLE_PREFIX."whoread");
$data = $vbulletin->db->query_read("SELECT * FROM ".TABLE_PREFIX."threadread ORDER BY readtime DESC LIMIT 10000");
echo 'Data Copy - Processing '.$vbulletin->db->num_rows($data).' Records'; vbflush();
while ($list = $vbulletin->db->fetch_array($data))
{
$count += 1;
$time = $list['readtime'];
$userid = $list['userid'];
$threadid = $list[threadid];
$db->query_write("INSERT INTO ".TABLE_PREFIX."whoread
(userid, threadid, dateline, ipaddress)
VALUES ($userid, $threadid, $time, '')
");
if (!($count%1000)) echo 'Processed '.$count.' Records'; vbflush();
}
echo 'Processing Complete'; vbflush();
$db->show_errors();
]]>
|
$trtitle
|
|
| $treaders |