PHP get_hotspot_table_name Examples

Example #1

File: db_triggers.php Project: Trying-On-The-Trades/panomanager

function regular_points_to_wallet($user_id, $skill_id)
{
    global $wpdb;
    $hotspost_table_name = get_hotspot_table_name();
    $points_table_name = get_user_skill_progress_table_name();
    $wallet_table_name = get_wallet_table_name();
    check_create_new_wallet($user_id);
    $currency = $wpdb->get_var("SELECT points FROM {$hotspost_table_name}\n      WHERE id = {$skill_id}");
    $total = $wpdb->get_var("SELECT available_currency FROM {$wallet_table_name} WHERE user_id = {$user_id}");
    $total += $currency;
    $wpdb->update($wallet_table_name, array('available_currency' => $total), array('user_id' => $user_id));
}

Example #2

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

function panno_uninstall()
{
    global $wpdb;
    // Get all the table names
    $pano_table_name = get_pano_table_name();
    $pano_text_table_name = get_pano_text_table_name();
    $quest_table_name = get_quest_table_name();
    $quest_text_table_name = get_quest_text_table_name();
    $mission_table_name = get_mission_table_name();
    $mission_text_table_name = get_mission_text_table_name();
    $hotspot_table_name = get_hotspot_table_name();
    $progress_table_name = get_user_progress_table_name();
    $skill_progress_table_name = get_user_skill_progress_table_name();
    $skill_bonus_pts_table_name = get_user_skill_bonus_pts_table_name();
    $type_table_name = get_type_table_name();
    $prereq_table_name = get_prereq_table_name();
    $activation_code_table_name = get_activation_code_table_name();
    $ads_table_name = get_ads_table_name();
    $ads_text_table_name = get_ads_text_table_name();
    $domain_table_name = get_domain_table_name();
    $tool_table_name = get_tool_table_name();
    // Drop all the tables
    $wpdb->query("DROP TABLE IF EXISTS {$pano_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$pano_text_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$quest_text_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$quest_text_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$mission_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$mission_text_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$hotspot_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$progress_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$skill_progress_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$skill_bonus_pts_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$type_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$prereq_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$activation_code_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$ads_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$ads_text_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$domain_table_name}");
    $wpdb->query("DROP TABLE IF EXISTS {$tool_table_name}");
    echo "bbbbbbbbb";
    // 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/panomanager

function get_regular_points_for_mission_tab($id)
{
    global $wpdb;
    $hotspot_table_name = get_hotspot_table_name();
    $user_progress_table = get_user_skill_progress_table_name();
    $regular_points = $wpdb->get_results("SELECT SUM(points) AS regular_points FROM {$hotspot_table_name} WHERE id IN (SELECT DISTINCT skill_id FROM {$user_progress_table} WHERE user_id = {$id})");
    $regular_points = $regular_points[0]->regular_points;
    if (empty($regular_points)) {
        $regular_points = 0;
    }
    return $regular_points;
}

Example #4

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

function build_hotspot_sql()
{
    $table_name = get_hotspot_table_name();
    $sql = 'CREATE TABLE ' . $table_name . ' (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `mission_id` int(11) DEFAULT NULL,
      `type_id` int(11) DEFAULT NULL,
      `name` varchar(255) NOT NULL DEFAULT "",
      `menu_name` varchar(255) NOT NULL DEFAULT "",
      `description` text,
      `hotspot_info` text,
      `hotspot_xml` text,
      `action_xml` text,
      `points` int(10) NOT NULL,
      `attempts` int(10) NOT NULL,
      `domain_id` int(11) DEFAULT NULL,
      `modal_url` text,
      PRIMARY KEY (`id`)
    );';
    return $sql;
}