– 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 |
| Jānis Kalniņš (16.) |
65,3 |
4:1 |
58,3 |
Rihards Vosulis – Grigulis |
|
spēles protokols |
|
| Par 3. vietu |
| Lauris Karavics (180, 180) |
57,1 |
3:2 |
58,2 |
Žanis Buklovskis |
|
spēles protokols |
|
| Pusfināli |
| Jānis Kalniņš |
69,8 |
3:1 |
67,5 |
Lauris Karavics |
|
spēles protokols |
|
| Rihards Vosulis – Grigulis |
63,9 |
3:1 |
66,7 |
Žanis Buklovskis (16., 180) |
|
spēles protokols |
|
| Ceturtdaļfināli |
| Lauris Karavics (16., 18., 167, B) |
75,8 |
3:2 |
57,8 |
Juris Straubergs (18., 161, B) |
|
spēles protokols |
|
| Jānis Kalniņš |
72,7 |
3:0 |
59,3 |
Anatolijs Žukovs |
|
spēles protokols |
|
| Žanis Buklovskis |
68,2 |
3:1 |
62,0 |
Kirils Staruhins |
|
spēles protokols |
|
| Rihards Vosulis – Grigulis |
58,8 |
3:2 |
58,7 |
Uldis Zeitmanis |
|
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 |
3:1 |
2 |
6:4 |
2 |
15., 101, 180 |
| Kārlis Zars |
0:3 |
|
1:3 |
1:3 |
0 |
2:9 |
4 |
|
| Lauris Karavics |
3:0 |
3:1 |
|
2:3 |
2 |
8:4 |
1 |
18., 180 |
| Uldis Zeitmanis |
1:3 |
3:1 |
3:2 |
|
2 |
7:6 |
3 |
|
|
| 2. grupa |
|
| Spēlētājs |
1 |
2 |
3 |
4 |
P-ti |
Legi |
Vieta |
Statistika |
| Jānis Kalniņš |
|
3:1 |
0:3 |
3:2 |
2 |
6:5 |
2 |
130 |
| Juris Straubergs |
1:3 |
|
1:3 |
3:1 |
1 |
5:7 |
3 |
14. |
| Rihards Vosulis – Grigulis |
3:0 |
3:1 |
|
3:1 |
3 |
9:2 |
1 |
|
| Haralds Trankals |
2:3 |
1:3 |
1:3 |
|
0 |
4:9 |
4 |
17. |
|
| 3. grupa |
|
| Spēlētājs |
1 |
2 |
3 |
4 |
P-ti |
Legi |
Vieta |
Statistika |
| Anatolijs Žukovs |
|
1:3 |
3:2 |
|
1 |
4:5 |
2 |
|
| Kirils Staruhins |
3:1 |
|
3:0 |
|
2 |
6:1 |
1 |
17., 180 |
| Kristīne Kuzmane |
2:3 |
0:3 |
|
|
0 |
2:6 |
3 |
|
|
|
|
|
|
|
|
|
|
Gandarījuma turnīrs
| Spēlētājs |
1 |
2 |
3 |
4 |
P-ti |
Legi |
Vieta |
Statistika |
| Kārlis Zars |
|
1:2 |
2:1 |
|
1 |
3:3 |
2 |
|
| Haralds Trankals |
2:1 |
|
2:1 |
|
2 |
4:2 |
1 |
|
| Kristīne Kuzmane |
1:2 |
1:2 |
|
|
0 |
2:3 |
3 |
|
|
|
|
|
|
|
|
|
|
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.
