Ilvars Draulis labākais aprīļa otrajā posmā

Līdz ar siltāka laika iestāšanos arī statistikas sasalums ir beidzies un vairums spēlētāju papildināja savus sezonas statistikas rādītāju krājumus.


– tika aizvadīts 2018. 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šanās spēles

Žanis W
0
Žanis (62,83) 2  180
Valters (63,00) 3
0
Valters W
1/2 fināls
Valters (72,73) 3  180
Haralds (67,44) 1
Jurijs W
0
Jurijs (51,88) 2  180
Haralds (55,80) 3  B
0 Fināls Valters (64,03) 2
Haralds W Ilvars (72,15) 4
17., 16.
Uldis W 3. vieta Haralds (57,14) 2
0 Uldis (57,73) 3
104
Uldis (60,03) 3
Rihards (51,57) 1
0
Rihards W
1/2 fināls
Uldis (70,60) 1  18., 177
Ilvars (78,32) 3 15., 106
Lauris (60,28) 2
Denijs (52,86) 1
Lauris (60,29) 0
Ilvars (79,11) 3  15.
0
Ilvars W

 

Apakšgrupu spēles

1. grupa
Spēlētājs 1 2 3 4 P-ti Legi Vieta Statistika
Žanis Buklovskis 1:2 2:0 2:0 2 5:2 1 15., 180
Rihards Vosulis-Grigulis 2:1 2:1 1:2 2 5:4 2 171
Denijs Nērings 0:2 1:2 2:0 1 3:4 3 180
Ralfs Bialkovskis 0:2 2:1 0:2 1 2:5 4
2. grupa
Spēlētājs 1 2 3 4 P-ti Legi Vieta Statistika
Ilvars Draulis 3:0 3:1 2 6:1 1 B
Laima Upeniece 0:3 0:3 0 0:6 3
Jurijs Botvinko 1:3 3:0 1 4:3 2
3. grupa
Spēlētājs 1 2 3 4 P-ti Legi Vieta Statistika
Uldis Zeitmanis 3:0 3:1 2 6:1 1  17., 18.
Zigmunds Krauklis 0:3 0:3 0 0:6 3
Valters Melderis 1:3 3:0 1 4:3 2
4. grupa
Spēlētājs 1 2 3 4 P-ti Legi Vieta Statistika
Haralds Trankals 3:1 3:0 2 6:1 1
Lauris Karavics 1:3 3:0 1 4:3 2
Kaspars Dubra 0:3 0:3 0 0:6 3

 

Gandarījuma turnīrs

Fināls:
Oskars Konno 0:2 Zigmunds Krauklis

Pusfināli:
Kaspars Dubra 1:2 Oskars Konno
Zigmunds Krauklis 2:1 Ralfs Bialkovskis

Fināla video ieraksts


 

Statistikas apkopojums:

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++;
}
?>

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=”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++;
}
?>

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=”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++;
}
?>

Apakšgrupu spēļu statistika

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 20:00 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.

Nākamā 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 + 1); ?>. posma norises laiks: pulksten 20:00.