include 'inc/golf.inc'; include 'inc/head.inc' ?> if ($GEV_ID) { $events = mysql_query( "select gtr_name,gsn_caption,gev_name,gev_loc,date_format(gev_begin,'%d.%m.%y'), date_format(gev_end,'%d.%m.%y'), gev_id from golf_tour gtr natural join golf_event gev natural join golf_season gsn WHERE gev_id=".$GEV_ID); $event = mysql_fetch_row($events); ?>
if (!$GRD_NR) $GRD_NR=">0"; $tippers = mysql_query("select gtp.gtp_id,gtp_name, gev.gev_name, gev.gev_id,gen_qualified,sum(grs_strokes)+sum(grs_penalty),sum(grs_played),gpl_name,gen.gen_id from golf_event gev natural join golf_round grd natural join golf_result natural join golf_entered gen natural join golf_player , golf_tipper gtp where gtp.gtp_id=gen.gtp_id AND grd_nr".$GRD_NR." and gev.gev_id=".$GEV_ID." group by gtp.gtp_id,gtp_name, gev.gev_name, gev.gev_id,gen_qualified,gpl_name order by 6"); ?>
Rang | Tipper | Spieler | Score | Gespielt |
---|---|---|---|---|
if ($score < $tipper[5]) { $rang +=$counter; $score=$tipper[5]; $counter=1; } else { $counter++; } if ($GTP_ID==$tipper[0] ) { $hasentered=1; echo ""; } echo $rang; if ($GTP_ID==$tipper[0] ) echo ""; echo " | "; ?>if ($GTP_ID==$tipper[0] ) { echo ""; } echo "".$tipper[1].""; if ($GTP_ID==$tipper[0] ) echo ""; ?> | if ($GTP_ID==$tipper[0] ) { echo ""; } echo "".$tipper[7].""; if ($GTP_ID==$tipper[0] ) echo ""; ?> | if ($GTP_ID==$tipper[0] ) { echo ""; } if ($tipper[5]) echo $tipper[5]; else echo "PAR"; if ($GTP_ID==$tipper[0] ) echo ""; ?> | if ($GTP_ID==$tipper[0] ) { echo ""; } echo $tipper[6]; if ($GTP_ID==$tipper[0] ) echo ""; ?> | echo "
".$player[1]." für dieses Turnier melden
"; } else { $players = mysql_query("select gpl_id from golf_entered natural join golf_result natural join golf_round where gev_id=".$GEV_ID); while ($player = mysql_fetch_row($players)) $gpls=$gpls.",".$player[0]; $players = mysql_query("select gpl_id,gpl_name from golf_player where gpl_id not in (0".$gpls.") order by 2"); if ($player = mysql_fetch_row($players)) { ?>
"; } else { echo "Neuen Spieler anlegen und für dieses Turnier melden
"; } } } ?> } else { $events = mysql_query( "select gtp_name, sum(gen_money), count(gen_id) FROM golf_tipper gtp LEFT OUTER JOIN golf_entered gen ON gen.gtp_id = gtp.gtp_id WHERE gtp_role is null GROUP BY gtp_name ORDER BY 2 DESC, 3,1"); ?>
Order Of Merit
Rang | Tipper | Preisgeld | Teilnahmen |
if ($lastmoney > $event[1]) { $rang = $rang+$counter; $lastmoney=$event[1]; $counter=1; } else { $counter++; } echo $rang; ?> | echo $event[0] ?> | echo $lastmoney ?> | echo $event[2] ?> |