– tika aizvadīts 2019. 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
Žanis Buklovskis (15., 156)
71,5
3:4
68,8
Nauris Glelgu (18. x3, 105, 103)
Par 3. vietu
Valters Melderis
0:W
Ilvars Draulis
Pusfināli
Žanis Buklovskis (18.)
72,84
3:2
68,69
Valters Melderis
Ilvars Draulis
55,73
2:3
65,62
Nauris Glelgu (15., 18.)
Ceturtdaļfināli
Žanis Buklovskis (16.)
70,05
3:2
66,14
Kirils Staruhins
Valters Melderis (17., 100)
62,56
3:1
50,97
Jānis Cērps
Ilvars Draulis
54,11
3:1
53,41
Juris Straubergs
Nauris Glelgu (18.)
69,37
3:0
55,76
Jurijs Botvinko
Apakšgrupu spēles
1. grupa
Spēlētājs
1
2
3
4
P-ti
Legi
Vieta
Statistika
Žanis Buklovskis
2:0
2:0
1:2
2
5:2
1
15.
Jurijs Botvinko
0:2
2:1
2:0
2
4:3
2
Edgars Ziemulis
0:2
1:2
0:2
0
1:6
4
Juris Straubergs
2:1
0:2
2:0
2
4:3
3
2. grupa
Spēlētājs
1
2
3
4
P-ti
Legi
Vieta
Statistika
Ilvars Draulis
2:0
2:0
2:0
3
6:0
1
180
Kirils Staruhins
0:2
0:2
2:1
1
2:5
3
Jānis Cērps
0:2
2:0
2:0
2
4:2
2
Rihards Vosulis – Grigulis
0:2
1:2
0:2
0
1:6
4
3. grupa
Spēlētājs
1
2
3
4
P-ti
Legi
Vieta
Statistika
Valters Melderis
2:3
3:0
1
5:3
2
18., B
Nauris Gleglu
3:2
3:0
2
6:2
1
15.
Ēriks Rēķis
0:3
0:3
0
0:6
3
Gandarījuma turnīrs
Fināls:
Ēriks Rēķis (37,29) 0:2 Edgars Ziemulis (60,12)
Pusfināls:
Rihards Vosulis – Grigulis 0:2 Edgars Ziemulis
Fināla video
VIDEO
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
Paddy Whelans . gada sezonas reitinga darts reitinga kopvērtējums” href=”http://www.paddydarts.lv/reitings/#“> kopvērtējums. .
Paddy Whelans . gada sezonas darts statistika” href=”http://www.paddydarts.lv/statistika/#“>statistika .
Sacensības katru ceturtdienu no 19:30 notiek Vecrīgas krodziņa Paddy Whelan`s Irish Pub telpās. 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.