Class Liga{ public function __construct() { global $wpdb; $this->db = $wpdb; } public function get_teams(){ $teams = $this->db->get_results("SELECT * FROM uks_posts WHERE post_type='druzyny' AND post_status='publish' ORDER BY post_title ASC "); return $teams; } public function get_games(){ $games = $this->db->get_results("SELECT * FROM uks_liga WHERE active!='0' ORDER BY game DESC "); return $games; } public function get_game($g){ $game = $this->db->get_results("SELECT * FROM uks_liga WHERE id='$g' "); return $game[0]; } public function add_game($team1,$team2,$game,$place){ if($this->db->insert('uks_liga', array( 'team1'=>$team1, 'team2'=>$team2, 'game'=>$game, 'place'=>$place, 'active'=>'1' ), array( '%d', '%s', '%s', '%s', '%d' ) )!==false){ return true; }else{ return false; } } public function update_game($id,$team1,$team2,$game,$place,$score1,$score2){ if($this->db->update('uks_liga', array( 'team1'=>$team1, 'team2'=>$team2, 'game'=>$game, 'place'=>$place, 'team1_score'=>$score1, 'team2_score'=>$score2 ), array("id"=> $id), array( '%d', '%s', '%s', '%s', '%d' ) )!==false){ return true; }else{ return false; } } public function delete_game($id){ if($this->db->update('uks_liga', array( 'active'=>0 ), array("id"=> $id), array('%d') )!==false){ return true; }else{ return false; } } public function get_coming_games($team=0,$limit=6){ $add = $team!=0 ? "AND team1='$team'" : ""; $games = $this->db->get_results("SELECT * FROM uks_liga WHERE active!='0' AND game >= NOW() $add ORDER BY game DESC LIMIT $limit"); return $games; } public function get_past_games($team=0,$limit=10){ $add = $team!=0 ? "AND team1='$team'" : ""; $games = $this->db->get_results("SELECT * FROM uks_liga WHERE active!='0' AND game <= NOW() $add ORDER BY game DESC LIMIT $limit"); return $games; } } ?> function liga_games(){ $l = new Liga(); ?>
Dodano nowy mecz!
Zapisano zmiany.
Mecz usunięty.
Podaj datę w formacie dd.mm.yyyy
Coś poszło nie tak, nie zapisano meczu do bazy danych
M\u0142odziki U-13 UKS-u 141 Warszawa (rocznik 2008\/09, grupa \u017c\u00f3\u0142ta) trenera Paw\u0142a Praczyka wygrali kolejne spotkanie, tym razem pewnie pokonuj\u0105c na wyje\u017adzie AP Rado\u015b\u0107 5:1.<\/p>\n\n\n\n
Pawe\u0142 Praczyk, trener UKS 141 Warszawa: U-13: Rado\u015b\u0107 – UKS 141 1:5 M\u0142odziki U-13 UKS-u 141 Warszawa (rocznik 2008\/09, grupa \u017c\u00f3\u0142ta) trenera Paw\u0142a Praczyka wygrali kolejne spotkanie, tym razem pewnie pokonuj\u0105c na wyje\u017adzie AP<\/p>\n","protected":false},"author":3,"featured_media":4030,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[38],"tags":[],"acf":[],"yoast_head":"\n
<\/strong>– Cala pierwsza po\u0142owa bardzo boja\u017aliwa, co poskutkowa\u0142o strat\u0105 przypadkowej bramki ju\u017c na samym pocz\u0105tku. Du\u017co chaosu wkrad\u0142o si\u0119 w nasz\u0105 gr\u0119, ale uda\u0142o nam si\u0119 wyr\u00f3wna\u0107 jeszcze przed zmian\u0105 stron.
Po przerwie zagrali\u015bmy zdecydowanie odwa\u017cniej, nie pozostawiaj\u0105c zbyt du\u017co miejsca rywalom. Od samego pocz\u0105tku atakowali\u015bmy bramk\u0119 Rado\u015bci, ale dopiero po czterdziestu pi\u0119ciu minutach gry wyszli\u015bmy na prowadzenie i ju\u017c do ko\u0144ca go nie oddali\u015bmy.<\/p>\n\n\n\n
bramki: <\/strong>Szpanowski, Matusiak, K.Brzozowski, J.Wieczorek, Suchodolski
UKS 141:<\/strong> \u017bemajtys – J.Wieczorek, K.Brzozowski, Bura, Dzieli\u0144ski, K.G\u00f3raj, K.Matusiak, L.Pietruli\u0144ski, Szpanowski, Markiewicz, Suchodolski, Su\u0142kowski.<\/p>\n","protected":false},"excerpt":{"rendered":"