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')); } }
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; }
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; }