– 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 |
| Ilvars Draulis (16.) |
65,24 |
3:4 |
59,96 |
Uldis Zeitmanis |
|
|
|
| Par 3. vietu |
| Edgars Ziemulis |
58,07 |
1:3 |
65,14 |
Juris Straubergs |
|
|
|
| Pusfināli |
| Ilvars Draulis (17., 18.) |
81,79 |
3:1 |
71,38 |
Edgars Ziemulis |
|
|
|
| Juris Straubergs |
60,26 |
2:3 |
63,13 |
Uldis Zeitmanis |
|
|
|
| Ceturtdaļfināli |
| Edgars Ziemulis |
55,61 |
3:1 |
53,41 |
Denijs Nērings |
|
|
|
| Juris Straubergs |
58,56 |
3:0 |
50,40 |
Modris Kandavnieks (180) |
|
|
|
| Uldis Zeitmanis |
64,13 |
3:1 |
51,26 |
Rihards Vosulis – Grigulis (B) |
|
|
|
Apakšgrupu spēles
| 1. grupa |
|
| Spēlētājs |
1 |
2 |
3 |
4 |
P-ti |
Legi |
Vieta |
Statistika |
| Ilvars Draulis |
|
3:0 |
3:1 |
2:3 |
2 |
8:4 |
1 |
18. |
| Modris Kandavnieks |
0:3 |
|
3:2 |
3:1 |
2 |
6:6 |
3 |
180, 180 |
| Jurijs Botvinko |
1:3 |
2:3 |
|
1:3 |
0 |
4:9 |
4 |
|
| Rihards Vosulis – Grigulis |
3:2 |
1:3 |
3:1 |
|
2 |
7:6 |
2 |
15., 152, 180 |
|
| 2. grupa |
|
| Spēlētājs |
1 |
2 |
3 |
4 |
P-ti |
Legi |
Vieta |
Statistika |
| Juris Straubergs |
|
3:2 |
3:0 |
|
2 |
6:2 |
1 |
18., 180 |
| Kirils Staruhins |
2:3 |
|
2:3 |
|
0 |
4:6 |
3 |
|
| Edgars Ziemulis |
0:3 |
3:2 |
|
|
1 |
3:5 |
2 |
|
|
|
|
|
|
|
|
|
|
|
| 3. grupa |
|
| Spēlētājs |
1 |
2 |
3 |
4 |
P-ti |
Legi |
Vieta |
Statistika |
| Uldis Zeitmanis |
|
3:0 |
3:0 |
|
2 |
6:0 |
1 |
|
| Oskars Konno |
0:3 |
|
2:3 |
|
0 |
2:6 |
3 |
174 |
| Denijs Nērings |
0:3 |
3:2 |
|
|
1 |
3:5 |
2 |
|
|
|
|
|
|
|
|
|
|
|
| Gandarījuma turnīrs |
|
| Spēlētājs |
1 |
2 |
3 |
4 |
P-ti |
Legi |
Vieta |
Statistika |
| Jurijs Botvinko |
|
3:2 |
1:3 |
|
1 |
4:5 |
2 |
|
| Oskars Konno |
2:3 |
|
1:3 |
|
0 |
3:6 |
3 |
|
| Kirils Staruhins |
3:1 |
3:1 |
|
|
2 |
6:2 |
1 |
|
|
|
|
|
|
|
|
|
|
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.
