Madars uzvarēja pēdējo marta spēli

28. marta, turnīra spēlē piedalījās get_results(‘SELECT count(*) as players FROM result WHERE date = “‘ . $t_date . ‘”‘); echo($players[0]->players); ?> dalībnieki. Spēlētāji bija sadalīti 3 grupas: pa trim. Pirmie no grupas izgāja: Madars Razma, Ilvars Draulis un Jurijs Botvinko, bet no grupām neizdevās 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 radītajos grupu spēles izcēlas:

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

Izslēgšanās spēles:

Ceturdal-finali				Pus-finali				Finals
Madars Razma	3
N/A	0			Madars Razma	3
Uldis Zeitmanis	2			Mareks Grazuls	1
Mareks Grazuls	3							Madars Razma	3
Jurijs Botvinko	3							Ilvars Draulis	0
Kirils Staruhins	2			Jurijs Botvinko	1
N/A	0			Ilvars Draulis	3			Mareks Grazuls	3
Ilvars Draulis	3							Jurijs Botvinko	1

Statistikas radītajos izslēgšanās spēles izcēlās:

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 radītajos finālā izcēlās:

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

Kopvertejums

Paddy Whelans 2013 darts reitinga  kopvērtējums .

Paddy Whelans 2013 statistika.

Sacensības katru ceturtdienu no 20:00 notiek Vecrīgas krodziņā Paddy Whelans telpas. Dāmām šajā turnīra tiek piedāvāts handikaps 100 punkti katra legā. Tāpat šautras šeit var uzmetā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 12. posms notiks 28. marta pulksten 20:00.