– tika aizvadīts 2020. gada sezonas get_results(‘select count(*) as skaits from (SELECT * FROM `result` WHERE date <= "' . $t_date . '" and YEAR(date) = ' . strftime("%G", strtotime($t_date)) . ' group by date) a'); echo($tournaments[0]->skaits); ?>. posms kurā piedalījās get_results(‘
SELECT count(*) as players
FROM result
WHERE date = “‘ . $t_date . ‘”‘);
echo($players[0]->players);
?> dalībnieki.
Izslēgšanas spēles
| Fināls |
| Jurijs Botvinko |
47,1 |
2:5 |
47,4 |
Uldis Zeitmanis |
|
spēles protokols |
|
| Par 3. vietu |
| Lauris Karavics (105) |
53,8 |
4:1 |
53,8 |
Juris Straubergs |
|
spēles protokols |
|
| Pusfināli |
| Jurijs Botvinko |
64,2 |
4:1 |
61,6 |
Lauris Karavics |
|
spēles protokols |
|
| Juris Straubergs |
54,1 |
0:4 |
56,2 |
Uldis Zeitmanis |
|
spēles protokols |
|
| Ceturtdaļfināli |
| Lauris Karavics |
62,7 |
4:3 |
63,5 |
Žanis Buklovskis |
|
spēles protokols |
|
Apakšgrupu spēles
| 1. grupa |
|
| Spēlētājs |
1 |
2 |
3 |
4 |
P-ti |
Legi |
Vieta |
Statistika |
| Žanis Buklovskis |
|
3:0 |
0:3 |
2:3 |
1 |
5:6 |
3 |
17. |
| Dzintars Baumanis |
0:3 |
|
2:3 |
3:2 |
1 |
5:8 |
4 |
180 |
| Uldis Zeitmanis |
3:0 |
3:2 |
|
1:3 |
2 |
7:5 |
2 |
116 |
| Jurijs Botvinko |
3:2 |
2:3 |
3:1 |
|
2 |
8:6 |
1 |
|
|
| 2. grupa |
|
| Spēlētājs |
1 |
2 |
3 |
4 |
P-ti |
Legi |
Vieta |
Statistika |
| Juris Straubergs |
|
3:0 |
1:3 |
|
1 |
4:3 |
1 |
|
| Sandis Duks |
0:3 |
|
3:1 |
|
1 |
3:4 |
3 |
|
| Lauris Karavics |
3:1 |
1:3 |
|
|
1 |
4:4 |
2 |
|
|
|
|
|
|
|
|
|
|
Gandarījuma turnīrs
(47,7) Dzintars Baumanis 1:3 Sandis Duks (49,8)
Statistikas apkopojums:
| Fināla statistika |
get_results(‘SELECT players.name as name, players.surname as surname, s1.achivement as ach, (select count(1) from statistika s2 where s2.player_id = s1.player_id and s2.date = “‘ . $t_date . ‘” and s2.stype=”F”) as ach_c FROM players, statistika s1 where players.id = s1.player_id and s1.date = “‘ . $t_date . ‘” and s1.stype=”F” order by ach_c desc, players.surname’);
$len = count($players);
$i = 0;
foreach( $players as $player){
$player_name = ($player_name == ” ? $player->name . ‘ ‘ . $player->surname : $player_name);
$new_player_name = $player->name . ‘ ‘ . $player->surname;
if($player_name != $new_player_name){
?>
|
|
|
name . ‘ ‘ . $player->surname;
}
if($i == $len-1){
$achiv .= ($achiv == ” ? $player->ach : ‘,’ . $player->ach);
?>
|
|
|
ach : ‘,’ . $player->ach);
$i++;
}
?>
| Izslēgšanas spēļu statistika |
get_results(‘SELECT players.name as name, players.surname as surname, s1.achivement as ach, (select count(1) from statistika s2 where s2.player_id = s1.player_id and s2.date = “‘ . $t_date . ‘” and s2.stype=”P”) as ach_c FROM players, statistika s1 where players.id = s1.player_id and s1.date = “‘ . $t_date . ‘” and s1.stype=”P” order by ach_c desc, players.surname’);
$len = count($players);
$i = 0;
foreach( $players as $player){
$player_name = ($player_name == ” ? $player->name . ‘ ‘ . $player->surname : $player_name);
$new_player_name = $player->name . ‘ ‘ . $player->surname;
if($player_name != $new_player_name){
?>
|
|
|
name . ‘ ‘ . $player->surname;
}
if($i == $len-1){
$achiv .= ($achiv == ” ? $player->ach : ‘,’ . $player->ach);
?>
|
|
|
ach : ‘,’ . $player->ach);
$i++;
}
?>
| Apakšgrupu spēļu statistika |
get_results(‘SELECT players.name as name, players.surname as surname, s1.achivement as ach, (select count(1) from statistika s2 where s2.player_id = s1.player_id and s2.date = “‘ . $t_date . ‘” and s2.stype=”G”) as ach_c FROM players, statistika s1 where players.id = s1.player_id and s1.date = “‘ . $t_date . ‘” and s1.stype=”G” order by ach_c desc, players.surname’);
$len = count($players);
$i = 0;
foreach( $players as $player){
$player_name = ($player_name == ” ? $player->name . ‘ ‘ . $player->surname : $player_name);
$new_player_name = $player->name . ‘ ‘ . $player->surname;
if($player_name != $new_player_name){
?>
|
|
|
name . ‘ ‘ . $player->surname;
}
if($i == $len-1){
$achiv .= ($achiv == ” ? $player->ach : ‘,’ . $player->ach);
?>
|
|
|
ach : ‘,’ . $player->ach);
$i++;
}
?>
Papildus informācija
. gada sezonas reitinga darts reitinga kopvērtējums” href=”http://www.paddydarts.lv/reitings/#“> kopvērtējums..
. gada sezonas darts statistika” href=”http://www.paddydarts.lv/statistika/#“>statistika.
PEPSI Darts sacensības katru otrdienu no 19:30 notiek Pepsi Centrs telpās (Uzvaras bulvāris 10, Rīga). Dāmām šajā turnīrā tiek piedāvāts handikaps 100 punkti katrā legā.
Laipni aicināts ikviens interesents, kurš vēlas iemācīties šo lielisko spēli vai arī parādīt uz ko ir spējīgs.
