hide_errors();
$vbulletin->db->query_write("ALTER TABLE `" . TABLE_PREFIX . "user` ADD threads INT(10) UNSIGNED NOT NULL DEFAULT '0'");
$vbulletin->db->query_write("ALTER TABLE `" . TABLE_PREFIX . "user` ADD showcybstats TINYINT( 1 ) DEFAULT '1' NOT NULL");
$vbulletin->db->query_write("
UPDATE " . TABLE_PREFIX . "user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON forum.forumid = thread.forumid
WHERE visible = 1
AND (forum.options & 4096)
AND user.userid=postuserid
)
");
$cyb_check_indexes = $vbulletin->db->query_read("SHOW INDEX FROM " . TABLE_PREFIX . "user");
while ($cyb_found_indexes = $vbulletin->db->fetch_array($cyb_check_indexes))
{
if ($cyb_found_indexes['Key_name'] == 'threads')
{
$cyb_ind_a = true;
}
if ($cyb_found_indexes['Key_name'] == 'post_thanks_thanked_times')
{
$cyb_ind_b = true;
}
}
if (!$cyb_ind_a)
{
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD INDEX (threads)");
}
if (mysql_query("SELECT post_thanks_thanked_times FROM " . TABLE_PREFIX . "user LIMIT 0") AND !$cyb_ind_b)
{
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD INDEX (post_thanks_thanked_times)");
}
$db->show_errors();]]>
hide_errors();
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user DROP threads");
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user DROP showcybstats");
$db->show_errors();]]>
| $vbphrase[cyb_disabled] | $forumjump |