$upgrade->drop_index(sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'subscribethread', 3, 5), 'subscribethread', 'threadid'); $upgrade->run_query(sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'subscribethread', 4, 5), "ALTER IGNORE TABLE " . TABLE_PREFIX . "subscribethread ADD UNIQUE threadid (threadid, userid)", MYSQL_ERROR_KEY_EXISTS); $upgrade->add_index(sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'subscribethread', 5, 5), 'subscribethread', 'userid', array('userid', 'folderid')); $upgrade->execute(); } // ############################################################################# // Thread Alter if ($vbulletin->GPC['step'] == 2) { $upgrade->add_index(sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'thread', 1, 1), 'thread', 'dateline', 'dateline'); $upgrade->execute(); } // ############################################################################# // FINAL step (notice the SCRIPTCOMPLETE define) if ($vbulletin->GPC['step'] == 3) { // Build cache of usergroups with image permission set for all avatar categories build_image_permissions(); // tell log_upgrade_step() that the script is done define('SCRIPTCOMPLETE', true); } // ############################################################################# print_next_step(); print_upgrade_footer(); /** * Stores a serialized list of usergroups who do not have permission to use any avatars into the datastore * * @return None */ function build_image_permissions() { global $vbulletin; $output = array();
$ordercache["{$item[$itemid]}"] = $item['displayorder']; } unset($item); $db->free_result($items); foreach ($vbulletin->GPC['order'] as $id => $displayorder) { $id = intval($id); $displayorder = intval($displayorder); if ($displayorder != $ordercache["{$id}"]) { $db->query_write("UPDATE " . TABLE_PREFIX . $vbulletin->GPC['table'] . " SET displayorder = {$displayorder} WHERE {$itemid} = {$id}"); } } } } } build_image_cache($vbulletin->GPC['table']); build_image_permissions($vbulletin->GPC['table']); $_REQUEST['do'] = 'viewimages'; } // ###################### Start View Images ####################### if ($_REQUEST['do'] == 'viewimages') { $vbulletin->input->clean_array_gpc('r', array('pagesub' => TYPE_INT, 'page' => TYPE_INT, 'perpage' => TYPE_INT, 'imagecategoryid' => TYPE_INT, 'massmove' => TYPE_INT)); if (!empty($vbulletin->GPC['pagesub'])) { $vbulletin->GPC['page'] = $vbulletin->GPC['pagesub']; } if ($vbulletin->GPC['page'] < 1) { $vbulletin->GPC['page'] = 1; } if ($vbulletin->GPC['perpage'] < 1) { $vbulletin->GPC['perpage'] = 20; } $startat = ($vbulletin->GPC['page'] - 1) * $vbulletin->GPC['perpage'];