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 zielona) trenera Kamila Rutkowskiego zaj\u0119li 2. i 4. miejsce w pierwszej tegorocznej edycji Kinder-ligi Juniora Zacisze.<\/p>\n\n\n\n
Kamil Rutkowski, trener UKS 141 Warszawa:<\/strong> UKS 141 I:<\/strong> Kruszona, D.Jankowski, K.Janowski, Bogucki, Suchodolski, Busma, Szlast, Sz.Pich. M\u0142odziki U-13 UKS-u 141 Warszawa (rocznik 2008\/09, grupa zielona) trenera Kamila Rutkowskiego zaj\u0119li 2. i 4. miejsce w pierwszej tegorocznej edycji Kinder-ligi Juniora Zacisze.<\/p>\n","protected":false},"author":3,"featured_media":4492,"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
– W minion\u0105 niedziel\u0119 nasze dwie ekipy z grupy zielonej rocznika 2008\/09 zako\u0144czy\u0142y pierwsz\u0105 edycj\u0119 Kinder-ligi organizowanej przez UKS Junior Zacisze, w kt\u00f3rej pokazali\u015bmy si\u0119 z dobrej strony, ko\u0144cz\u0105c rozgrywki na 2. i 4. miejscu. Dzi\u0119kuj\u0119 wszystkim za zaanga\u017cowanie, za walk\u0119 oraz ogromn\u0105 ch\u0119\u0107 do gry, kt\u00f3ra przynosi nam widoczne zadowolenie i fajn\u0105 zabaw\u0119.<\/p>\n\n\n\n
UKS 141 II: <\/strong>Timofieiev, Wardzi\u0144ski-Linaje, Pawlus, R.Cie\u015blak, T.Jaroszewicz, Pietrusiak, Kosza\u0142ka, Bartkowiak.<\/p>\n","protected":false},"excerpt":{"rendered":"