include 'inc/golf.inc'; if (!$GTP_ID) $redirect=1; include 'inc/head.inc' ?> if (!$GTP_ID) { ?>
Nur nach Login verfügbar!
Falls der Browser keine automatische Weiterleitung unterstützt, bitte hier klicken! } else { $first = getdbtime($gmttime); $last = getdbtime($gmttime,72); $closed = getdbtime($gmttime,-72); include 'inc/scoreview.inc'; ?> if ($GPR_ID) { $rounds = mysql_query("select grd_start+0 from golf_round natural join golf_result where grs_id=".$GPR_ID); $round = mysql_fetch_row($rounds); if ($round[0] > $first ) { $sql = "update golf_prediction set "; for ($ii = 0; $ii<18; $ii++) $sql = $sql. "GPR_PAR_".($ii+1)."=".$GPR_PAR[$ii].","; $sql = $sql."GPR_CHANGE=".$first." where grs_id=".$GPR_ID; //echo $sql; mysql_query($sql); if ( 0Tippkarte nicht gespeichert!
"; } else echo "Tippabgabe zu spät!
"; } elseif ($GSC_ID) { $sql = "update golf_score set "; $today =0; for ($ii = 0; $ii<18; $ii++) { if ($GSC_PAR[$ii] != "-") { $sql = $sql. "GSC_PAR_".($ii+1)."=".$GSC_PAR[$ii].","; $today += $GSC_PAR[$ii]; } else $sql = $sql. "GSC_PAR_".($ii+1)."=NULL,"; } $sql = $sql." GSC_CHANGE=".$first.", GSC_SCORE=".$today.", gsc_warn=null where grs_id=".$GSC_ID; mysql_query($sql); if ( 0Wertung nicht fortgeschrieben!
"; } else { echo "Scorekarte nicht gespeichert!
"; } } else { mysql_query("insert into golf_prediction( grs_id) " ." select grs_id from golf_round natural join golf_result natural join golf_entered where gtp_id=".$GTP_ID." and grd_start > ".$first); echo "".mysql_affected_rows()." neue Tippkarten, "; //mysql_query("insert into golf_score( grd_id,gen_id) " //." select grd_id,gad.gen_id from golf_adopt gad natural join golf_entered natural join golf_event natural join golf_round where grd_start between //".$first." and ".$last." and gtp_id=".$GTP_ID); mysql_query("insert into golf_score( grs_id) " ." select grs.grs_id from golf_round natural join golf_result grs natural join golf_entered, golf_prediction gpr where grd_start between ".$closed." and ".$first." and grs.grs_id=gpr.grs_id AND gtp_id=".$GTP_ID); //echo mysql_error(); echo mysql_affected_rows()." neue Scorekarten.
"; } ?> // Scorecards $sql="select grs.grs_id,gcr_id,grd_nr,gev_name,gpl_name from " ."golf_event gev natural join golf_round grd natural join golf_result grs natural join golf_score gsc, golf_entered gen natural join golf_player gpl " ."where gen.gen_id=grs.gen_id and grs_penalty is null and grd_start between ".$closed." and ".$first." and gtp_id=".$GTP_ID ." order by grd_start"; $scores = mysql_query($sql ); //echo $sql; if ($score = mysql_fetch_row($scores)) {?>Offene Scorecards
do { echo ""; } while ($score = mysql_fetch_row($scores) ); } ?> // predictions $sql="select grs.grs_id,gcr_id,grd_nr,gev_name, gpl_name from " ."golf_event gev natural join golf_round grd natural join golf_result grs natural join golf_prediction gpr, golf_entered gen natural join golf_player gpl " ."where gen.gen_id=grs.gen_id and grd_start > ".$first." and gtp_id=".$GTP_ID ." order by grd_start"; $scores = mysql_query($sql ); if ($score = mysql_fetch_row($scores)) {?>Offene Spiele
do { echo ""; } while ($score = mysql_fetch_row($scores) ); } ?> } include 'inc/footer.inc' ?>