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":614,"date":"2016-09-23T18:05:35","date_gmt":"2016-09-23T16:05:35","guid":{"rendered":"http:\/\/uks.scpdev.pl\/kadra-2009b\/"},"modified":"2016-09-23T18:05:35","modified_gmt":"2016-09-23T16:05:35","slug":"kadra-2009b","status":"publish","type":"post","link":"https:\/\/grochovia.pl\/bez-kategorii\/kadra-2009b\/","title":{"rendered":"kadra-2009b"},"content":{"rendered":"

ROCZNIK 2009<\/span><\/strong>
GRUPA ZIELONA<\/h1>\n

\"\"<\/a><\/p>\n\n\n\n\n\n
\n

sztab szkoleniowy:<\/strong><\/span><\/h4>\n<\/td>\n

\u00a0<\/td>\n\u00a0<\/td>\n<\/tr>\n
\n

nazwisko i imi\u0119\u00a0<\/strong><\/h4>\n<\/td>\n

\n

\u00a0funkcja\u00a0<\/strong><\/h4>\n<\/td>\n

\n

\u00a0data urodzenia<\/strong><\/h4>\n<\/td>\n<\/tr>\n

\n

DRO\u017bD\u017b Pawe\u0142<\/h4>\n<\/td>\n

\n

\u00a0I trener\u00a0<\/h4>\n<\/td>\n

\n

12.08.1989<\/h4>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

kadra zespo\u0142u:<\/strong><\/span><\/h4>\n<\/td>\n<\/tr>\n

\n

nazwisko i imi\u0119<\/strong><\/h4>\n<\/td>\n

\n

data urodzenia<\/strong><\/h4>\n<\/td>\n<\/tr>\n

\n

BALTROS Tymon<\/h4>\n<\/td>\n

\n

12.08.2009<\/h4>\n<\/td>\n<\/tr>\n

\n

CHARYTON Tymoteusz<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

G\u0141ADYSZ Wiktor<\/h4>\n<\/td>\n

\n

09.06.2009<\/h4>\n<\/td>\n<\/tr>\n

\n

GRACZYK Ignacy<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

JAROSZEWICZ Tymoteusz<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

KOCZWARSKI Mateusz<\/h4>\n<\/td>\n

\n

13.11.2009<\/h4>\n<\/td>\n<\/tr>\n

\n

KOSI\u0143SKI Natan<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

KRUSZONA Adam<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

LUBACZEWSKI Edward<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

MORY\u0143 Marek<\/h4>\n<\/td>\n

\n

30.11.2009<\/h4>\n<\/td>\n<\/tr>\n

\n

OJCZYK Zofia<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

RACZY\u0143SKI Gabriel<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

R\u00d3\u017bYCKI Jan<\/h4>\n<\/td>\n

\n

21.05.2009<\/h4>\n<\/td>\n<\/tr>\n

\n

R\u00d3\u017bYCKI Marek<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

RYDZEWSKI Micha\u0142<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

SZCZE\u015aNIAK Dariusz<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

SZEWCZUK Wojciech<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

UNISK Mateusz<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

WI\u015aNIEWSKI Oliwier<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

WYRZYKOWSKI Jan<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

ZAJ\u0104C Wojciech<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

ZAWISZA Nikodem<\/h4>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

ROCZNIK 2009GRUPA ZIELONA sztab szkoleniowy: \u00a0 \u00a0 nazwisko i imi\u0119\u00a0 \u00a0funkcja\u00a0 \u00a0data urodzenia DRO\u017bD\u017b Pawe\u0142 \u00a0I trener\u00a0 12.08.1989 kadra zespo\u0142u: nazwisko i imi\u0119 data urodzenia BALTROS Tymon 12.08.2009 CHARYTON Tymoteusz \u00a0 G\u0141ADYSZ Wiktor 09.06.2009 GRACZYK Ignacy \u00a0 JAROSZEWICZ Tymoteusz \u00a0 KOCZWARSKI Mateusz 13.11.2009 KOSI\u0143SKI Natan \u00a0 KRUSZONA Adam \u00a0 LUBACZEWSKI Edward \u00a0 MORY\u0143 Marek 30.11.2009 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[1],"tags":[],"acf":[],"yoast_head":"\nkadra-2009b - 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\/bez-kategorii\/kadra-2009b\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"kadra-2009b - MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w\" \/>\n<meta property=\"og:description\" content=\"ROCZNIK 2009GRUPA ZIELONA sztab szkoleniowy: \u00a0 \u00a0 nazwisko i imi\u0119\u00a0 \u00a0funkcja\u00a0 \u00a0data urodzenia DRO\u017bD\u017b Pawe\u0142 \u00a0I trener\u00a0 12.08.1989 kadra zespo\u0142u: nazwisko i imi\u0119 data urodzenia BALTROS Tymon 12.08.2009 CHARYTON Tymoteusz \u00a0 G\u0141ADYSZ Wiktor 09.06.2009 GRACZYK Ignacy \u00a0 JAROSZEWICZ Tymoteusz \u00a0 KOCZWARSKI Mateusz 13.11.2009 KOSI\u0143SKI Natan \u00a0 KRUSZONA Adam \u00a0 LUBACZEWSKI Edward \u00a0 MORY\u0143 Marek 30.11.2009 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/grochovia.pl\/bez-kategorii\/kadra-2009b\/\" \/>\n<meta property=\"og:site_name\" content=\"MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-23T16:05:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/lh3.googleusercontent.com\/hgWaHANWlFheKgHbdcYjzAxf_090ATrt4c9yKSl2nhhByHJVIiqrw-OOiEBGQ3U1AYOga3TLuXzLmVBEWXAaIUdy0W5CBlUi7sV7H8-fypoUSXe2QsB0BwPCXg5uJApTKcnEeH8wwtl_OAVhD6dVL04oDTIvy7Vfek8G8iPSlMzrm1T-g3WfaAOjVj7cYUp6MGfHt1OIryKVA-PKU3UvUcIMV96cj_PR1V9C7aM60xYS8BpqPXQOI-RzEaJbwzpncuI5tqw1Gi8QtdVCHItqGV2UhXCzwseJqRsPWj2C3HG5RNCDzqeD2NiNs5FSgEMMv3M6of4v5tNexuOyjC0dWuTr6ILtxC_rx_uO-WqcHIb2_JPKWRmmvdFGvK9x2USBXaSjnYp1nomzgqHgrfmgKM88WRLwttNCEm2kJPGpIF6paPZcY4aFOIEAnnhE0uWgXLkkXiqWyN2VCsaQJoizl2GUahVI0gkhdFGLqb1_z9yv34SRT6ORpockZNWgHEIcGO5dSW2Q8My9dsKxR3bCsssDEGc6nBFWX8kQ3Pcwg6rshHOJUSdmKBks4S2c4p_K6dvw4M_k7MOXULLB4Mwhvk30mGp8rtYJdrY087PP8Qy3kWMxJk7QFLNu=w600-h400-no\" \/>\n<meta name=\"author\" content=\"jahoo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"jahoo\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/grochovia.pl\/bez-kategorii\/kadra-2009b\/\",\"url\":\"https:\/\/grochovia.pl\/bez-kategorii\/kadra-2009b\/\",\"name\":\"kadra-2009b - MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w\",\"isPartOf\":{\"@id\":\"https:\/\/grochovia.pl\/#website\"},\"datePublished\":\"2016-09-23T16:05:35+00:00\",\"dateModified\":\"2016-09-23T16:05:35+00:00\",\"author\":{\"@id\":\"https:\/\/grochovia.pl\/#\/schema\/person\/2bc64babea19b71277b9e155f25a663c\"},\"breadcrumb\":{\"@id\":\"https:\/\/grochovia.pl\/bez-kategorii\/kadra-2009b\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/grochovia.pl\/bez-kategorii\/kadra-2009b\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/grochovia.pl\/bez-kategorii\/kadra-2009b\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\/\/grochovia.pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"kadra-2009b\"}]},{\"@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\/2bc64babea19b71277b9e155f25a663c\",\"name\":\"jahoo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/grochovia.pl\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7667624e4f0824767413112a27e2d47c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7667624e4f0824767413112a27e2d47c?s=96&d=mm&r=g\",\"caption\":\"jahoo\"},\"url\":\"https:\/\/grochovia.pl\/author\/jahoo\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"kadra-2009b - 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\/bez-kategorii\/kadra-2009b\/","og_locale":"pl_PL","og_type":"article","og_title":"kadra-2009b - MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w","og_description":"ROCZNIK 2009GRUPA ZIELONA sztab szkoleniowy: \u00a0 \u00a0 nazwisko i imi\u0119\u00a0 \u00a0funkcja\u00a0 \u00a0data urodzenia DRO\u017bD\u017b Pawe\u0142 \u00a0I trener\u00a0 12.08.1989 kadra zespo\u0142u: nazwisko i imi\u0119 data urodzenia BALTROS Tymon 12.08.2009 CHARYTON Tymoteusz \u00a0 G\u0141ADYSZ Wiktor 09.06.2009 GRACZYK Ignacy \u00a0 JAROSZEWICZ Tymoteusz \u00a0 KOCZWARSKI Mateusz 13.11.2009 KOSI\u0143SKI Natan \u00a0 KRUSZONA Adam \u00a0 LUBACZEWSKI Edward \u00a0 MORY\u0143 Marek 30.11.2009 […]","og_url":"https:\/\/grochovia.pl\/bez-kategorii\/kadra-2009b\/","og_site_name":"MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w","article_published_time":"2016-09-23T16:05:35+00:00","og_image":[{"url":"https:\/\/lh3.googleusercontent.com\/hgWaHANWlFheKgHbdcYjzAxf_090ATrt4c9yKSl2nhhByHJVIiqrw-OOiEBGQ3U1AYOga3TLuXzLmVBEWXAaIUdy0W5CBlUi7sV7H8-fypoUSXe2QsB0BwPCXg5uJApTKcnEeH8wwtl_OAVhD6dVL04oDTIvy7Vfek8G8iPSlMzrm1T-g3WfaAOjVj7cYUp6MGfHt1OIryKVA-PKU3UvUcIMV96cj_PR1V9C7aM60xYS8BpqPXQOI-RzEaJbwzpncuI5tqw1Gi8QtdVCHItqGV2UhXCzwseJqRsPWj2C3HG5RNCDzqeD2NiNs5FSgEMMv3M6of4v5tNexuOyjC0dWuTr6ILtxC_rx_uO-WqcHIb2_JPKWRmmvdFGvK9x2USBXaSjnYp1nomzgqHgrfmgKM88WRLwttNCEm2kJPGpIF6paPZcY4aFOIEAnnhE0uWgXLkkXiqWyN2VCsaQJoizl2GUahVI0gkhdFGLqb1_z9yv34SRT6ORpockZNWgHEIcGO5dSW2Q8My9dsKxR3bCsssDEGc6nBFWX8kQ3Pcwg6rshHOJUSdmKBks4S2c4p_K6dvw4M_k7MOXULLB4Mwhvk30mGp8rtYJdrY087PP8Qy3kWMxJk7QFLNu=w600-h400-no"}],"author":"jahoo","twitter_card":"summary_large_image","twitter_misc":{"Napisane przez":"jahoo"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/grochovia.pl\/bez-kategorii\/kadra-2009b\/","url":"https:\/\/grochovia.pl\/bez-kategorii\/kadra-2009b\/","name":"kadra-2009b - MKS Grochovia Warszawa - Klub pi\u0142karski Groch\u00f3w","isPartOf":{"@id":"https:\/\/grochovia.pl\/#website"},"datePublished":"2016-09-23T16:05:35+00:00","dateModified":"2016-09-23T16:05:35+00:00","author":{"@id":"https:\/\/grochovia.pl\/#\/schema\/person\/2bc64babea19b71277b9e155f25a663c"},"breadcrumb":{"@id":"https:\/\/grochovia.pl\/bez-kategorii\/kadra-2009b\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/grochovia.pl\/bez-kategorii\/kadra-2009b\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/grochovia.pl\/bez-kategorii\/kadra-2009b\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/grochovia.pl\/"},{"@type":"ListItem","position":2,"name":"kadra-2009b"}]},{"@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\/2bc64babea19b71277b9e155f25a663c","name":"jahoo","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/grochovia.pl\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7667624e4f0824767413112a27e2d47c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7667624e4f0824767413112a27e2d47c?s=96&d=mm&r=g","caption":"jahoo"},"url":"https:\/\/grochovia.pl\/author\/jahoo\/"}]}},"_links":{"self":[{"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/posts\/614"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/comments?post=614"}],"version-history":[{"count":0,"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/posts\/614\/revisions"}],"wp:attachment":[{"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/media?parent=614"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/categories?post=614"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/grochovia.pl\/wp-json\/wp\/v2\/tags?post=614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}