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}`"); } }
static function get_match($args) { global $wpdb; $defaults = array('from_date' => 0, 'id' => false, 'game_id' => false, 'sum_tickets' => false, 'limit' => 0, 'offset' => 0, 'orderby' => 'id', 'order' => 'asc'); $args = \WP_Clanwars\Utils::extract_args($args, $defaults); extract($args); $where_query = ''; $limit_query = ''; $order_query = ''; $order = strtolower($order); if ($order != 'asc' && $order != 'desc') { $order = 'asc'; } $order_query = 'ORDER BY t1.`' . $orderby . '` ' . $order; if ($id != 'all' && $id !== false) { if (!is_array($id)) { $id = array($id); } $id = array_map('intval', $id); $where_query[] = 't1.id IN (' . join(', ', $id) . ')'; } if ($game_id != 'all' && $game_id !== false) { if (!is_array($game_id)) { $game_id = array($game_id); } $game_id = array_map('intval', $game_id); $where_query[] = 't1.game_id IN (' . join(', ', $game_id) . ')'; } if ($from_date > 0) { $where_query[] = 't1.date >= FROM_UNIXTIME(' . intval($from_date) . ')'; } if ($limit > 0) { $limit_query = $wpdb->prepare('LIMIT %d, %d', $offset, $limit); } if (!empty($where_query)) { $where_query = 'WHERE ' . join(' AND ', $where_query); } $rounds_table = \WP_Clanwars\Rounds::table(); $games_table = \WP_Clanwars\Games::table(); $teams_table = \WP_Clanwars\Teams::table(); $matches_table = static::table(); if ($sum_tickets) { $subquery = <<<SQL \t \t\t\t( \t\t\t\tSELECT SUM(sumt1.tickets1) \t\t\t\tFROM `{$rounds_table}` AS sumt1 \t\t\t\tWHERE sumt1.match_id = t1.id \t\t\t) AS team1_tickets, \t\t\t( \t\t\t\tSELECT SUM(sumt2.tickets2) \t\t\t\tFROM `{$rounds_table}` AS sumt2 \t\t\t\tWHERE sumt2.match_id = t1.id \t\t\t) AS team2_tickets SQL; $subquery = trim($subquery); } else { $subquery = 'NULL'; } $query = <<<SQL \t\tSELECT \t\t\tt1.*, \t\t\tt2.title AS game_title, \t\t\tt2.abbr AS game_abbr, \t\t\tt2.icon AS game_icon, \t\t\ttt1.title AS team1_title, \t\t\ttt2.title AS team2_title, \t\t\ttt1.country AS team1_country, \t\t\ttt2.country AS team2_country, \t\t\t{$subquery} \t\tFROM `{$matches_table}` AS t1 \t\t\tLEFT JOIN `{$games_table}` AS t2 ON t1.game_id = t2.id \t\t\tLEFT JOIN `{$teams_table}` AS tt1 ON t1.team1 = tt1.id \t\t\tLEFT JOIN `{$teams_table}` AS tt2 ON t1.team2 = tt2.id \t\t{$where_query} \t\t{$order_query} \t\t{$limit_query} SQL; return \WP_Clanwars\DB::get_results($query); }