PHP get_points_initial_bonus_table_name Exemples

Exemple #1

Fichier : db_triggers.php Projet : Trying-On-The-Trades/panomanager

function check_create_new_wallet($user_id)
{
    global $wpdb;
    $wallet_table_name = get_wallet_table_name();
    $points_initial_bonus_table_name = get_points_initial_bonus_table_name();
    $flag = $wpdb->get_var("SELECT COUNT(*) FROM {$wallet_table_name} WHERE user_id = {$user_id}");
    if ($flag === '0') {
        $currency_qty = $wpdb->get_var("SELECT quantity FROM {$points_initial_bonus_table_name} WHERE id = 1");
        $wpdb->insert($wallet_table_name, array('user_id' => $user_id, 'available_currency' => $currency_qty), array('%d', '%d'));
    }
}

Exemple #2

Fichier : db_functions.php Projet : Trying-On-The-Trades/panomanager

function get_points_initial_bonus()
{
    global $wpdb;
    $initial_points_table_name = get_points_initial_bonus_table_name();
    $quantity = $wpdb->get_var("SELECT quantity FROM {$initial_points_table_name} WHERE id = 1 LIMIT 1");
    return $quantity;
}

Exemple #3

Fichier : database.php Projet : Trying-On-The-Trades/panomanager

function build_points_initial_bonus_sql()
{
    global $wpdb;
    $table_name = get_points_initial_bonus_table_name();
    $sql = "DROP TABLE IF EXISTS " . $table_name . ";";
    $wpdb->query($sql);
    $sql = "CREATE TABLE " . $table_name . "(\n    `id` int(11) NOT NULL AUTO_INCREMENT,\n    `quantity` int(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '100',\n    PRIMARY KEY (`id`)\n  );";
    $sql .= "INSERT INTO " . $table_name . "(\n    `quantity`\n  ) VALUES (\n    '100'\n  );";
    return $sql;
}