PHP WP_Clanwars Maps::table Exemples

Exemple #1

Fichier : rounds.class.php Projet : pronebird/wp-clanwars

    static function get_rounds($match_id)
    {
        global $wpdb;
        return $wpdb->get_results($wpdb->prepare('SELECT t1.*, t2.title, t2.screenshot FROM `' . self::table() . '` AS t1
						 LEFT JOIN `' . \WP_Clanwars\Maps::table() . '` AS t2
						 ON t2.id = t1.map_id
						 WHERE t1.match_id=%d ORDER BY t1.id ASC, t1.group_n ASC', $match_id));
    }

Exemple #2

Fichier : wp-clanwars.php Projet : pronebird/wp-clanwars

 public function on_uninstall()
 {
     global $wpdb;
     delete_option(WP_CLANWARS_CATEGORY);
     delete_option(WP_CLANWARS_DEFAULTCSS);
     \WP_Clanwars\ACL::destroy();
     $tables = array();
     array_push(\WP_Clanwars\Games::table());
     array_push(\WP_Clanwars\Maps::table());
     array_push(\WP_Clanwars\Rounds::table());
     array_push(\WP_Clanwars\Matches::table());
     array_push(\WP_Clanwars\Teams::table());
     foreach ($tables as $table) {
         $wpdb->query("DROP TABLE `{$table}`");
     }
 }