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
Mimo pocz\u0105tkowej straty pi\u0119ciu goli \u017baki U-9 UKS-u 141 Warszawa (rocznik 2013, grupa \u017c\u00f3\u0142ta) trenera Kamila Rutkowskiego odwr\u00f3cili losy spotkania z AP EsKadr\u0105.<\/p>\n\n\n\n
Kamil Rutkowski, trener UKS 141 Warszawa:<\/strong> U-9: UKS 141 – EsKadra Mimo pocz\u0105tkowej straty pi\u0119ciu goli \u017baki U-9 UKS-u 141 Warszawa (rocznik 2013, grupa \u017c\u00f3\u0142ta) trenera Kamila Rutkowskiego odwr\u00f3cili losy spotkania z AP EsKadr\u0105.<\/p>\n","protected":false},"author":3,"featured_media":5110,"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
– Zacz\u0119li\u015bmy zdekoncentrowani, szybko trac\u0105c dwa gole po w\u0142asnych b\u0142\u0119dach. Pierwsze dwie kwarty by\u0142y generalnie s\u0142abe w naszym wykonaniu, gdy\u017c grali\u015bmy zbyt indywidualnie i niedok\u0142adnie. Przebudzili\u015bmy si\u0119 w trzeciej kwarcie przy wyniku 0:5 dla go\u015bci. Od tego czasu jakby wysz\u0142a do gry inna dru\u017cyna „UKaeSiak\u00f3w”: skoncentrowani, skuteczni, waleczni i przede wszystkim graj\u0105cy zespo\u0142owo. Dali\u015bmy rad\u0119 odrobi\u0107 stracone gole oraz zdobyli\u015bmy zwyci\u0119skiego, a nawet mieli\u015bmy apetyty na wi\u0119cej. Niesamowity powr\u00f3t z dalekiej podr\u00f3\u017cy! Brawo dru\u017cyna!<\/p>\n\n\n\n
UKS 141: <\/strong>Trzci\u0144ski, Jakubowska, Fedyszyn, Adamczak, M.Popowski, Skupi\u0144ski, Modro, Strza\u0142kowski, Rajewski, Legat.<\/p>\n","protected":false},"excerpt":{"rendered":"