Esempio n. 1
0
    $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();
Esempio n. 2
0
                    $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'];