Trešo marta spēli uzvarēja Madars

21. martā, turnīra spelē piedalijas get_results(‘SELECT count(*) as players FROM result WHERE date = “‘ . $t_date . ‘”‘); echo($players[0]->players); ?> dalibnieki. Speletāji bija sadalīti 3 grupas: pa četriem speletājiem pirmas divas un trīm trešā. Pirmie no gruppas izgāja: Madars Razma, Ilvars Draulis un Jurijs Botvinko, bet no grupam neizdevas iziet: get_results(‘
select p.name, p.surname
from `result` r1,
`players` p
where r1.points =(SELECT min(r2.points) as mnimal FROM `result` r2 WHERE r2.date = “‘ . $t_date . ‘”)
and r1.date = “‘ . $t_date . ‘”
and r1.player_id = p.id’);
$i = 0;
foreach( $players as $player){
if($i != 0){
echo(‘, ‘);
}
$i++;
echo($player->name . ‘ ‘ . $player->surname);
}?>.

Statistikas raditajos gruppu speles izcelas:

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

Speletajs	Veikums

Izlegšanas speles:

Ceturdal-finali				Pus-finali				Finals
Madars Razma	3
Sandija Andersone	0			Madars Razma	3
Liza Pugina	3			Liza Pugina	2
Viktors Bautra	1							Madars Razma	3
Jurijs Botvinko	0							Ilvars Draulis	1
Uldis Zeitmanis	3			Uldis Zeitmanis	0
Mikhails Dolgoborodovs	0			Ilvars Draulis	3			Liza Pugina	2
Ilvars Draulis	3							Uldis Zeitmanis	3

Statistikas raditajos izslegšanas speles izcelas:

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

Speletajs	Veikums

Statistikas raditajos finalā izcelas:

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

Speletajs	Veikums

Kopvērtējums

Paddy Whelans 2013 darts reitinga kopvērtējums.

Paddy Whelans 2013 statistika.

Sacensības katru ceturtdienu no 20:00 notiek Vecrīgas krodziņa Paddy Whelans telpās. Dāmām šajā turnīrā tiek piedāvāts handikaps 100 punkti katrā legā. Tāpat šautras šeit var uzmētāt arī ikdienā.

Laipni aicināts ikviens interesents, kurš vēlas iemācīties šo lielisko spēli vai arī jau parādīt uz ko ir spējīgs.

Nākamais 11. posms notiks 28. martā pulksten 20:00.