Paddy Wheelans darts turnīru reitinga līderis Madars Razma

– 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.
Gruppu spēļu rezultāti:
get_results(‘
SELECT g.group_num as group_number
,p.name as player_name
,p.surname as player_surname
,g.place as place
FROM groups g
,players p
WHERE g.date = “‘ . $t_date . ‘”
and g.player_id = p.id
ORDER BY group_num, place’);
$group_num = 0;
foreach ($players as $player){
if($group_num != $player->group_number){
if($group_num != 0){
?>

group_number;
?>
. grupa

Vieta	Spēlētajs
place; ?>	player_name . ‘ ‘ . $player->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:

Astodaļ-fināli				Ceturdaļ-fināli				Pus-fināli				Fināls
Ilvars Draulis	W
N/A	0			Ilvars Draulis	3
Viktors Bautra	0			Barnaby Scothern	0
Barnaby Scothern	2							Ilvars Draulis	3
Jānis Pinka	W							Jānis Pinka	2
N/A	0			Jānis Pinka	3
N/A	0			Uldis Zeitmanis	1
Uldis Zeitmanis	W											Ilvars Draulis	2
Jurijs Botvinko	W											Rūdolfs Mežeckis	3
N/A	0			Jurijs Botvinko	3
N/A	0			Anatolijs Žukas	1
Anatolijs Žukas	W							Jurijs Botvinko	0
Laima Upeniece	0							Rūdolfs Mežeckis	3
Mareks Gražuls	2			Mareks Gražuls	1
N/A	0			Rūdolfs Mežeckis	3							Jānis Pinka	2
Rūdolfs Mežeckis	W											Jurijs Botvinko	3

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 darts reitinga  darts reitinga kopvertejums” href=”http://new.paddydarts.lv/reitings/#“> kopvērtējums .

Paddy Whelans   darts statistika” href=”http://new.paddydarts.lv/statistika/#“>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 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); ?>. posms – pulksten 20:00.