Trešo janvāra speli uzvarēja Madars

24. janvārī, turnira spēle piedalijas get_results(‘SELECT count(*) as players FROM result WHERE date = “‘ . $t_date . ‘”‘); echo($players[0]->players); ?> dalibnieki. Speletaji bija sadaliti 3 grupas: cetri pirmā un tris speletaji otrā un trešā. Pirmie no gruppas izgaja: Madars Razma, Rūdolfs Mežeckis un Ilvars Draulis, bet no grupam neizdevas iziet: Sandija Andersone, Barnaby Scothern un Laima Upeniece.

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

Ceturdal-finali				Pus-finali				Finals
Madars Razma	W
N/A	0			Madars Razma	3
Dmitrijs Blatovs	2			Jurijs Botvinko	0
Jurijs Botvinko	3							Madars Razma	3
Ilvars Draulis	3							Rudolfs Mezeckis	0
Janis Pinka	0			Ilvars Draulis	1
SteveMahony	0			Rudolfs Mezeckis	3			Jurijs Botvinko	0
Rudolfs Mezeckis	3							Ilvars Draulis	3

Statistikas raditajos izslegsanas 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 finala 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

Kopvertejums

Paddy Whelans 2013 darts reitingakopvertejums.

Paddy Whelans 2013statistika.

Sacensibas katru ceturtdienu no 20:00 notiek Vecrigas krodzina Paddy Whelans telpas. Damam saja turnira tiek piedavats handikaps 100 punkti katra lega. Tapat sautras seit var uzmetat ari ikdiena.

Laipni aicinats ikviens interesents, kurs velas iemacities so lielisko speli vai ari jau paradit uz ko ir spejigs.

Nakamais 4. posms notiks 31. janvari pulksten 20:00.