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; } } ?>

Dodano nowy mecz!

Zapisano zmiany.

Mecz usunięty.

Rozgrywki

get_games() as $k=>$g){ $alt= $k % 2 == 0 ? "alternate" : ""; if($g->team1_score=="" || $g->team2_score==""){ if (strtotime($g->game) < time()) { $score="Nie podano"; }else{ $score="-"; } }else{ $score=$g->team1_score.':'.$g->team2_score; };?>
Drużyna Przeciwnik Miejsce Data Wynik Edytuj Usuń
01.01.70 00:00


get_teams(); if($_GET["game_id"]!=''){ var_dump($_GET['game_id']); $vals = $l->get_game($_GET['game_id']); }else{ $vals = []; $title="Dodaj mecz"; } wp_enqueue_script('jquery-ui-datepicker'); wp_register_style('jquery-ui', 'http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css'); wp_enqueue_style('jquery-ui'); ?>

Podaj datę w formacie dd.mm.yyyy

Coś poszło nie tak, nie zapisano meczu do bazy danych

Drużyna
Przeciwnik
Miejsce spotkania
Data spotkania
Godzina spotkania
Wynik drużyny
Wynik przeciwnika
add_game($_POST["team1"],$_POST["team2"],$dt,$_POST["place"])){ wp_redirect(admin_url('admin.php?page=liga_games&success=1')); }else{ wp_redirect(admin_url('admin.php?page=liga_game_form&eval=2')); }} }else{ //update list($d,$m,$y) = explode(".",$_POST['gdate']); $dt=$y."-".$m."-".$d." ".$_POST['gtime'].":00"; if($l->update_game($_POST["game"],$_POST["team1"],$_POST["team2"],$dt,$_POST["place"],$_POST["team1_score"],$_POST["team2_score"])){ wp_redirect(admin_url('admin.php?page=liga_games&success=2')); }else{ wp_redirect(admin_url('admin.php?page=liga_game_form&eval=2')); } } } } function del_game(){ $l = new liga(); $l->delete_game($_POST["game"]); wp_redirect(admin_url('admin.php?page=liga_games&success=3')); } ?> {"id":4029,"date":"2020-10-12T20:51:19","date_gmt":"2020-10-12T18:51:19","guid":{"rendered":"https:\/\/uks141.pl\/?p=4029"},"modified":"2020-10-12T20:52:29","modified_gmt":"2020-10-12T18:52:29","slug":"radosny-wyjazd-mlodzikow","status":"publish","type":"post","link":"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/","title":{"rendered":"Radosny wyjazd M\u0142odzik\u00f3w"},"content":{"rendered":"\n

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:
<\/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

U-13: Rado\u015b\u0107 – UKS 141 1:5
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":"

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":"\nRadosny wyjazd M\u0142odzik\u00f3w - MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Radosny wyjazd M\u0142odzik\u00f3w - MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w\" \/>\n<meta property=\"og:description\" content=\"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\" \/>\n<meta property=\"og:url\" content=\"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/\" \/>\n<meta property=\"og:site_name\" content=\"MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-12T18:51:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-12T18:52:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/grochovia.pl\/wp-content\/uploads\/2020\/10\/2008-1-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1920\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"MattGebb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"MattGebb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuta\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/\",\"url\":\"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/\",\"name\":\"Radosny wyjazd M\u0142odzik\u00f3w - MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w\",\"isPartOf\":{\"@id\":\"https:\/\/grochovia.pl\/#website\"},\"datePublished\":\"2020-10-12T18:51:19+00:00\",\"dateModified\":\"2020-10-12T18:52:29+00:00\",\"author\":{\"@id\":\"https:\/\/grochovia.pl\/#\/schema\/person\/2b34b237248c9d10d0f8061a3029ad50\"},\"breadcrumb\":{\"@id\":\"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\/\/grochovia.pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Radosny wyjazd M\u0142odzik\u00f3w\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/grochovia.pl\/#website\",\"url\":\"https:\/\/grochovia.pl\/\",\"name\":\"MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/grochovia.pl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/grochovia.pl\/#\/schema\/person\/2b34b237248c9d10d0f8061a3029ad50\",\"name\":\"MattGebb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/grochovia.pl\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/678e00ac69d76f8c4cee2e557f9dc9f7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/678e00ac69d76f8c4cee2e557f9dc9f7?s=96&d=mm&r=g\",\"caption\":\"MattGebb\"},\"url\":\"https:\/\/grochovia.pl\/author\/mattgebb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Radosny wyjazd M\u0142odzik\u00f3w - MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/","og_locale":"pl_PL","og_type":"article","og_title":"Radosny wyjazd M\u0142odzik\u00f3w - MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w","og_description":"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","og_url":"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/","og_site_name":"MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w","article_published_time":"2020-10-12T18:51:19+00:00","article_modified_time":"2020-10-12T18:52:29+00:00","og_image":[{"width":2560,"height":1920,"url":"https:\/\/grochovia.pl\/wp-content\/uploads\/2020\/10\/2008-1-scaled.jpg","type":"image\/jpeg"}],"author":"MattGebb","twitter_card":"summary_large_image","twitter_misc":{"Napisane przez":"MattGebb","Szacowany czas czytania":"1 minuta"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/","url":"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/","name":"Radosny wyjazd M\u0142odzik\u00f3w - MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w","isPartOf":{"@id":"https:\/\/grochovia.pl\/#website"},"datePublished":"2020-10-12T18:51:19+00:00","dateModified":"2020-10-12T18:52:29+00:00","author":{"@id":"https:\/\/grochovia.pl\/#\/schema\/person\/2b34b237248c9d10d0f8061a3029ad50"},"breadcrumb":{"@id":"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/grochovia.pl\/aktualnosci\/radosny-wyjazd-mlodzikow\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/grochovia.pl\/"},{"@type":"ListItem","position":2,"name":"Radosny wyjazd M\u0142odzik\u00f3w"}]},{"@type":"WebSite","@id":"https:\/\/grochovia.pl\/#website","url":"https:\/\/grochovia.pl\/","name":"MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/grochovia.pl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pl-PL"},{"@type":"Person","@id":"https:\/\/grochovia.pl\/#\/schema\/person\/2b34b237248c9d10d0f8061a3029ad50","name":"MattGebb","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/grochovia.pl\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/678e00ac69d76f8c4cee2e557f9dc9f7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/678e00ac69d76f8c4cee2e557f9dc9f7?s=96&d=mm&r=g","caption":"MattGebb"},"url":"https:\/\/grochovia.pl\/author\/mattgebb\/"}]}},"_links":{"self":[{"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/posts\/4029"}],"collection":[{"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/comments?post=4029"}],"version-history":[{"count":3,"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/posts\/4029\/revisions"}],"predecessor-version":[{"id":4033,"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/posts\/4029\/revisions\/4033"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/media\/4030"}],"wp:attachment":[{"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/media?parent=4029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/categories?post=4029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/tags?post=4029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}