PHP get_deck_words_table_name Examples

Example #1

File: database.php Project: Trying-On-The-Trades/vocabulary-plugin

function build_deck_words_sql()
{
    $table_name = get_deck_words_table_name();
    $sql = 'CREATE TABLE `' . $table_name . '` (
    `deck_id` int(10) NOT NULL,
    `dictionary_id` int(10) NOT NULL,
    PRIMARY KEY (deck_id, dictionary_id),
    FOREIGN KEY (deck_id) REFERENCES ' . get_decks_table_name() . '(id) ON DELETE CASCADE,

    FOREIGN KEY (dictionary_id) REFERENCES ' . get_dictionary_table_name() . '(id) ON DELETE CASCADE
    )ENGINE=MyISAM DEFAULT CHARSET=latin1;';
    return $sql;
}

Example #2

File: uninstall.php Project: Trying-On-The-Trades/vocabulary-plugin

function wordpleh_uninstall()
{
    global $wpdb;
    // Get all the table names
    $deck_word_table_name = get_deck_words_table_name();
    $dictionary_table_name = get_dictionary_table_name();
    $deck_table_name = get_decks_table_name();
    $word_category_table_name = get_word_categories_table_name();
    // Drop all the tables
    $wpdb->query("DROP TABLE IF EXISTS {$deck_word_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$dictionary_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$deck_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$word_category_table_name}");
    // Update the db version to 0 so the next time the plugin is run it will reinstall
    update_option("panno_db_version", PANO_DB_VERSION);
}

Example #3

File: db_functions.php Project: Trying-On-The-Trades/vocabulary-plugin

function delete_deck_word_by_deck($deck_id)
{
    global $wpdb;
    $table_name = get_deck_words_table_name();
    $wpdb->delete($table_name, array('deck_id' => $deck_id));
}