PHP vB_Database_Alter_MySQL::drop_index示例

示例#1

文件： options.php 项目： benyamin20/vbregistration

        print_yes_no_row($vbphrase['remove_fulltext_indices'], 'deleteindex', true);
    } else {
        print_description_row(construct_phrase($vbphrase['your_forum_is_currently_using_default_search'], TABLE_PREFIX, $warning1, $warning2));
        print_yes_no_row($vbphrase['empty_postindex_and_word'], 'deletepostindex', false);
    }
    print_submit_row($vbphrase['go'], 0);
}
// #################### Start Change Search Type #####################
if ($_POST['do'] == 'dosearchtype') {
    $vbulletin->input->clean_array_gpc('p', array('deleteindex' => TYPE_BOOL, 'deletepostindex' => TYPE_BOOL));
    require_once DIR . '/includes/class_dbalter.php';
    $db_alter = new vB_Database_Alter_MySQL($db);
    if ($vbulletin->options['fulltextsearch']) {
        if ($vbulletin->GPC['deleteindex']) {
            if ($db_alter->fetch_table_info('post')) {
                $db_alter->drop_index('title');
            } else {
                print_stop_message('dbalter_' . $db_alter->fetch_error(), $db_alter->fetch_error_message());
            }
            if ($db_alter->fetch_table_info('thread')) {
                $db_alter->drop_index('title');
            } else {
                print_stop_message('dbalter_' . $db_alter->fetch_error(), $db_alter->fetch_error_message());
            }
        }
    } else {
        // add indices
        if ($db_alter->fetch_table_info('post')) {
            if (!$db_alter->add_index('title', array('title', 'pagetext'), 'fulltext', true)) {
                print_stop_message('dbalter_' . $db_alter->fetch_error(), $db_alter->fetch_error_message());
            }