# Datenbankanbindung
require('link.php');
if (!mysql_select_db("c5asvtri01", $link))
die("Kann Datenbank nicht anwaehlen...");
### LIGATERMINE
# Alle Eintr?ge ausgeben
#
$datenow = "${yearnow}-${monthnow}-${daynow}";
$user = $_POST["user"];
$password = $_POST["password"];
# Post ID zur event_id mappen
$edit = $_POST["edit"];
#print "Benutzer: $user
";
#print "EDIT: $edit
";
if ($edit <>1) {
print "Landesliga Süd
"; # print $datenow; $query3 = "SELECT event_id, event_date, event_title, event_dist, event_url, event_user FROM cal_event WHERE event_user = 'Liga' AND event_date >= CURDATE() AND event_deleted <> 1 ORDER BY event_date, event_title"; $result3 = @mysql_query($query3,$link) or die ("Fehler 310: Fehler bei Abfrage"); $numrow3 = mysql_num_rows($result3); if ($numrow3 == 0) { print "
"; print " | Datum | "; print "Wettbewerb | "; print "Distanz | "; print "|
---|---|---|---|---|
";
# print "";
if ($new == 1) { print " | ![]() ";
print $event_date_conv;
print " | ";
if (preg_match("/http:\/\/[0-9a-z]/i",$event_url)) {
print "$event_title";
} else {
print $event_title;
}
print " | ";
print $event_dist;
print " | ";
print " |
$eintrag Einträge |
"; } ### EINZELSTARTER # Alle Eintr?ge ausgeben # print ""; if ($edit == 1) { print "Termin von $user"; } else { print "Einzelstarter "; } print "
";
$datenow = "${yearnow}-${monthnow}-${daynow}";
# print $datenow;
if ($edit == 1) {
$query3 = "SELECT event_id, event_date, event_title, event_dist, event_url, event_user FROM cal_event WHERE event_date >= CURDATE() AND event_deleted <> 1 AND event_user = '$user' ORDER BY event_date, event_title";
} else {
$query3 = "SELECT event_date, event_title, event_dist, event_url, event_user FROM cal_event WHERE event_date >= CURDATE() AND event_user <> 'Liga' AND event_deleted <> 1 ORDER BY event_date, event_title";
}
$result3 = @mysql_query($query3,$link) or die ("Fehler 310: Fehler bei Abfrage");
#print $query3;
$numrow3 = mysql_num_rows($result3);
if ($numrow3 == 0) {
print "Keine Termine eingetragen.
";
} else {
print "
"; print " | Datum | "; print "Name | "; print "Wettbewerb | "; print "Distanz | "; if ($edit == 1) { print "Edit | "; } print "
---|
";
print "";
if ($new == 1) { print " | ![]() ";
print $event_date_conv;
print " | ";
print $event_user;
print " | ";
if (preg_match("/http:\/\/[0-9a-z]/i",$event_url)) {
print "$event_title";
} else {
print $event_title;
}
print " | ";
print $event_dist;
print " | ";
print " ";
if ($edit == 1) {
print "";
print "";
print " | ";
}
print " |
Frühere Termine"; print "
";
$datenow = "${yearnow}-${monthnow}-${daynow}";
# print $datenow;
if ($edit == 1) {
$query3 = "SELECT event_id, event_date, event_title, event_dist, event_url, event_finishing_time, event_ranking, event_starters, event_ranking_ag, event_ag, event_user FROM cal_event WHERE event_date < CURDATE() AND event_deleted <> 1 AND event_user = '$user' ORDER BY event_date, event_title";
} else {
$query3 = "SELECT event_date, event_title, event_dist, event_url, event_finishing_time, event_ranking, event_starters, event_ranking_ag, event_ag, event_user FROM cal_event WHERE event_date >= CURDATE() AND event_user <> 'Liga' AND event_deleted <> 1 ORDER BY event_date, event_title";
}
$result3 = @mysql_query($query3,$link) or die ("Fehler 310: Fehler bei Abfrage");
#print $query3;
$numrow3 = mysql_num_rows($result3);
if ($numrow3 == 0) {
print "Keine Termine eingetragen.
";
} else {
print "
"; print " | Datum | "; print "Name | "; print "Wettbewerb | "; print "Distanz | "; print "Zeit | "; print "Platz | "; print "Platz AK | "; if ($edit == 1) { print "Edit | "; } print "
---|
";
if ($new == 1) { print "![]() | "; print $event_date_conv; print " | "; print $event_user; print " | "; if (preg_match("/http:\/\/[0-9a-z]/i",$event_url)) { print "$event_title"; } else { print $event_title; } print " | "; print $event_dist; print " | "; # Zeit print ""; if (!$event_finishing_time == "") { print $event_finishing_time; } print " | "; # Platzierung Gesamt print ""; if (!$event_ranking == "") { print $event_ranking; print " / "; print $event_starters; } print " | "; # Platzierung AK print ""; if (!$event_ranking_ag == "") { print $event_ranking_ag; print " ("; print $event_ag; print ")"; } print " | "; print ""; print ""; print " | "; print "
Aktuelle Artikel
Triathlonteam des ASV Süchteln steigt auf! 2. Rang in der Tageswertung und 3. Platz in der Gesamtwertung
Das Triathlonteam des ASV Süchteln ging beim vierten und letzten Wettkampf der Landesliga Süd beim 10. Stadtwerke Ratingen Triathlon über 1000 m Schwimmen, 40 km Radfahren und 10 km Laufen an den Start. Weiterlesen
- ASV Triathlon Damen erfolgreich Kommentar hinterlassen
- Süchtelner Triathlonteam kämpft sich auf Aufstiegsplatz vor Kommentar hinterlassen
- 4. Platz beim Niederrhein Triathlon in Kalkar Kommentar hinterlassen
- Nachwuchscup in MG Kommentar hinterlassen
- ASV Erfolg beim 31. Aasee Triathlon in Bocholt. Kommentar hinterlassen
- Mannschaftssieg und zwei Altersklassen-Siege beim Rahser Run Kommentar hinterlassen
- Triathleten des ASV beim IRONMAN 70.3 Kraichgau Kommentar hinterlassen