– turnīrā piedalījās get_results(‘
SELECT count(*) as players
FROM result
WHERE date = “‘ . $t_date . ‘”‘);
echo($players[0]->players);
?> dalībnieki.
Grupu 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ētājs |
| place; ?> |
player_name . ‘ ‘ . $player->player_surname; ?> |
Statistikas rādītājos grupu spēlēs izcēlās:
| Spēlētājs |
Veikums |
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++;
}
?>
Izslēgšanās spēles:
| Astodaļ-fināli |
|
Ceturdaļ-fināli |
|
Pus-fināli |
|
Fināls |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mareks Gražuls |
W |
|
| N/A |
0 |
|
|
Mareks Gražuls |
2 |
|
| Uldis Zeitmanis |
W |
|
Uldis Zeitmanis |
3 |
|
| N/A |
0 |
|
|
|
Uldis Zeitmanis |
3 |
|
| Kaspars Darbinieks |
2 |
|
|
|
Nauris Gleglu |
1 |
|
| Jurijs Botvinko |
0 |
|
|
Kaspars Abramenko |
2 |
| Nauris Gleglu |
W |
|
Nauris Gleglu |
3 |
|
| N/A |
0 |
|
|
|
Uldis Zeitmanis |
0 |
| Barnaby Scothern |
W |
|
|
|
Madars Razma |
3 |
| N/A |
0 |
|
|
Barnaby Scothern |
3 |
|
| Raitis Gultnieks |
0 |
|
Rūdolfs Mežeckis |
2 |
|
| Rūdolfs Mežeckis |
2 |
|
|
|
Barnaby Scothern |
0 |
| Valters Melderis |
W |
|
|
|
Madars Razma |
3 |
|
| N/A |
0 |
|
|
Valters Melderis |
0 |
|
| Madars Razma |
W |
|
Madars Razma |
3 |
|
|
Nauris Gleglu |
3 |
| N/A |
0 |
|
|
Barnaby Scothern |
2 |
Statistikas rādītājos izslēgšanas spēlēs izcēlās:
| Spēlētājs |
Veikums |
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++;
}
?>
Statistikas rādītājos finālā izcēlās:
| Spēlētājs |
Veikums |
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++;
}
?>
Kopvērtējums
Paddy Whelans darts reitinga darts reitinga kopvērtējums” 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ņ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 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.
