– 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
| Fināls |
| Arnis Kupčs |
68,90 |
0:4 |
76,42 |
Ilvars Draulis (16.) |
|
|
|
| Par 3. vietu |
| Oskars Draulis |
|
2:3 |
|
Valters Melderis (16.) |
|
|
|
| Pusfināli |
| Arnis Kupčs (180, 177) |
61,77 |
3:0 |
55,04 |
Oskars Draulis |
|
|
|
| Valters Melderis |
65,93 |
1:3 |
62,42 |
Ilvars Draulis |
|
|
|
| Ceturtdaļfināli |
| Oskars Draulis (122) |
56,62 |
3:1 |
52,48 |
Jurijs Botvinko |
|
|
|
| Valters Melderis |
54,91 |
3:2 |
48,25 |
Denijs Nērings |
|
|
|
| Ilvars Draulis |
63,51 |
3:0 |
53,13 |
Haralds Trankals |
|
|
|
Apakšgrupu spēles
| 1. grupa |
|
| Spēlētājs |
1 |
2 |
3 |
4 |
P-ti |
Legi |
Vieta |
Statistika |
| Ilvars Draulis |
|
1:2 |
2:1 |
2:0 |
2 |
5:3 |
2 |
15., 101, 135 |
| Arnis Kupčs |
2:1 |
|
2:1 |
2:0 |
3 |
6:2 |
1 |
|
| Denijs Nērings |
1:2 |
1:2 |
|
2:0 |
1 |
4:4 |
3 |
B |
| Denis Buļbuk |
0:2 |
0:2 |
0:2 |
|
0 |
0:6 |
4 |
|
|
| 2. grupa |
|
| Spēlētājs |
1 |
2 |
3 |
4 |
P-ti |
Legi |
Vieta |
Statistika |
| Haralds Trankals |
|
3:0 |
3:2 |
|
2 |
6:2 |
1 |
120 |
| Oskars Draulis |
0:3 |
|
3:2 |
|
1 |
3:5 |
2 |
|
| Atis Bialkovskis |
2:3 |
2:3 |
|
|
0 |
46 |
3 |
|
|
|
|
|
|
|
|
|
|
|
| 3. grupa |
|
| Spēlētājs |
1 |
2 |
3 |
4 |
P-ti |
Legi |
Vieta |
Statistika |
| Valters Melderis |
|
3:1 |
3:0 |
|
2 |
6:1 |
1 |
100 |
| Jurijs Botvinko |
1:3 |
|
3:0 |
|
1 |
4:3 |
2 |
|
| Vladislavs Stebunovs |
0:3 |
0:3 |
|
|
0 |
0:6 |
3 |
|
|
|
|
|
|
|
|
|
|
Gandarījuma turnīrs
Vladislavs Stebunovs 3:2 Denis Buļbuk
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 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.
