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)); }
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}`"); } }