6. posmu uzvar Madars Razma

21. februārī, 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 pirmā un trīm – otrā un trešā. Pirmie no gruppas izgāja: Madars Razma, Ilvars Draulis un Nauris Gleglu, 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	W
N/A	0			Madars Razma	3
Rūdolfs Mežeckis	3			Rūdolfs Mežeckis	0
Jurijs Botvinko	0							Madars Razma	3
Nauris Gleglu	3							Ilvars Draulis	1
Barnaby Scothern	0			Nauris Gleglu	1
Uldis Zeitmanis	1			Ilvars Draulis	3			Rūdolfs Mežeckis	1
Ilvars Draulis	3							Nauris Gleglu	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 7. posms notiks 28. februārī pulksten 20:00.