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')); } ?> 1.0MKS Grochovia Warszawa - Klub piłkarski Grochówhttps://grochovia.plMattGebbhttps://grochovia.pl/author/mattgebb/Młodziki po jedenastu - MKS Grochovia Warszawa - Klub piłkarski Grochówrich600338<blockquote class="wp-embedded-content" data-secret="KVCWXjpr1d"><a href="https://grochovia.pl/aktualnosci/mlodziki-po-jedenastu/">Młodziki po jedenastu</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://grochovia.pl/aktualnosci/mlodziki-po-jedenastu/embed/#?secret=KVCWXjpr1d" width="600" height="338" title="„Młodziki po jedenastu” — MKS Grochovia Warszawa - Klub piłkarski Grochów" data-secret="KVCWXjpr1d" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript"> /*! This file is auto-generated */ !function(c,d){"use strict";var e=!1,o=!1;if(d.querySelector)if(c.addEventListener)e=!0;if(c.wp=c.wp||{},c.wp.receiveEmbedMessage);else if(c.wp.receiveEmbedMessage=function(e){var t=e.data;if(!t);else if(!(t.secret||t.message||t.value));else if(/[^a-zA-Z0-9]/.test(t.secret));else{for(var r,s,a,i=d.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),n=d.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),o=new RegExp("^https?:$","i"),l=0;l<n.length;l++)n[l].style.display="none";for(l=0;l<i.length;l++)if(r=i[l],e.source!==r.contentWindow);else{if(r.removeAttribute("style"),"height"===t.message){if(1e3<(s=parseInt(t.value,10)))s=1e3;else if(~~s<200)s=200;r.height=s}if("link"===t.message)if(s=d.createElement("a"),a=d.createElement("a"),s.href=r.getAttribute("src"),a.href=t.value,!o.test(a.protocol));else if(a.host===s.host)if(d.activeElement===r)c.top.location.href=t.value}}},e)c.addEventListener("message",c.wp.receiveEmbedMessage,!1),d.addEventListener("DOMContentLoaded",t,!1),c.addEventListener("load",t,!1);function t(){if(o);else{o=!0;for(var e,t,r,s=-1!==navigator.appVersion.indexOf("MSIE 10"),a=!!navigator.userAgent.match(/Trident.*rv:11\./),i=d.querySelectorAll("iframe.wp-embedded-content"),n=0;n<i.length;n++){if(!(r=(t=i[n]).getAttribute("data-secret")))r=Math.random().toString(36).substr(2,10),t.src+="#?secret="+r,t.setAttribute("data-secret",r);if(s||a)(e=t.cloneNode(!0)).removeAttribute("security"),t.parentNode.replaceChild(e,t);t.contentWindow.postMessage({message:"ready",secret:r},"*")}}}}(window,document); </script> https://grochovia.pl/wp-content/uploads/2020/10/122837814_3252747994848334_1182096974156904253_o.jpg6401144UKS 141 Warszawa U-13 (rocznik 2008/09) trenera Pawła Praczyka wygrał sparingowe starcie z TURBO Academy Warszawa 6:5. Dla "UKaeSiaków" było to pierwsze