'; return '
'; } function reiter_tabelle_ende(){ # return ''; return '
'; } function reiter_tabelle_eintrag($nmaktiv,$hyperlink,$val_hyperlink){ # if ($nmaktiv == ""){ # return ' #

'.$val_hyperlink.'

'; # } else { # return ' #
'.$val_hyperlink.'
'; # } if ($nmaktiv == ""){ return '
'.$val_hyperlink.'
'; } else { return '
'.$val_hyperlink.'
'; } } function pferde_titel ($nr,$lang){ $lk=connect(); $sql="SELECT name,sp1,sp2,sp3,sp4,text,nr,farbe,geburtstag,homepage,mutterstute,rennpferd,hengststute,owner,breeder,kommentar,status,purchase,vater,mutter FROM ".$lang."_horses WHERE nr='".$nr."'"; $result = mysqli_query( $lk, $sql); $row = mysqli_fetch_row($result); return $row[0]." (".kdate("Y",$row[8]).")"; } function horse_titel ($nr,$lang){ $lk=connect(); $sql="SELECT name,geburtstag,hengststute,vater,mutter FROM pferde WHERE nr='".$nr."'"; $result = mysqli_query( $lk, $sql); $row = mysqli_fetch_row($result); return $row[0]." (".kdate("Y",$row[1]).")"; } function pferde_subtitel ($nr,$lang){ $lk=connect(); $sql="SELECT name,sp1,sp2,sp3,sp4,text,nr,farbe,geburtstag,homepage,mutterstute,rennpferd,hengststute,owner,breeder,kommentar,status,purchase,vater,mutter FROM ".$_SESSION['lang']."_horses WHERE nr='".$nr."'"; $result = mysqli_query( $lk, $sql); $row = mysqli_fetch_row($result); if ($row[12] == "hengst" && $lang == "de") $sex = "Hengst"; if ($row[12] == "stute" && $lang == "de") $sex = "Stute"; if ($row[12] == "hengst" && $lang == "en") $sex = "M"; if ($row[12] == "stute" && $lang == "en") $sex = "F"; $vater_sql="SELECT name,vater FROM pferde WHERE nr='".$row[18]."'"; $vater_result = mysqli_query($lk,$vater_sql); $vater_row = mysqli_fetch_row($vater_result); $mutter_sql="SELECT name,vater FROM pferde WHERE nr='".$row[19]."'"; $mutter_result = mysqli_query($lk,$mutter_sql); $mutter_row = mysqli_fetch_row($mutter_result); $strURL = substr($_SERVER['QUERY_STRING'],0,strlen($_SERVER['QUERY_STRING'])-6); $vater_url = "index.php?".$strURL."&nr=$row[18]&his=1"; $mutter_url = "index.php?".$strURL."&nr=$row[19]&his=1"; $v_sql="SELECT name FROM ".$_SESSION['lang']."_horses WHERE nr='".$row[18]."'"; $v_result = mysqli_query($lk,$v_sql); $m_sql="SELECT name FROM ".$_SESSION['lang']."_horses WHERE nr='".$row[19]."'"; $m_result = mysqli_query($lk,$m_sql); if (mysqli_num_rows( $v_result ) > 0){ if (mysqli_num_rows( $m_result ) > 0){ if ($_SESSION['lang'] == "de"){ #return 'test'; #return $vater_row[0]; return ucfirst($sex).' v. '.$vater_row[0].' a.d. '.$mutter_row[0].''; } else { return ucfirst($sex).' by '.$vater_row[0].' out of '.$mutter_row[0].''; } } else { if ($_SESSION['lang'] == "de"){ #return 'test'; return ucfirst($sex).' v. '.$vater_row[0].' a.d. '.$mutter_row[0]; } else { return ucfirst($sex).' by '.$vater_row[0].' out of '.$mutter_row[0]; } } } else { if (mysqli_num_rows( $m_result ) > 0){ if ($_SESSION['lang'] == "de"){ #return 'test'; return ucfirst($sex).' v. '.$vater_row[0].' a.d. '.$mutter_row[0].''; } else { return ucfirst($sex).' by '.$vater_row[0].' out of '.$mutter_row[0].''; } } else { if ($_SESSION['lang'] == "de"){ #return 'test'; return ucfirst($sex).' v. '.$vater_row[0].' a.d. '.$mutter_row[0]; } else { return ucfirst($sex).' by '.$vater_row[0].' out of '.$mutter_row[0]; } } } } function horse_subtitel ($nr,$lang){ $lk=connect(); $sql="SELECT name,geburtstag,hengststute,vater,mutter FROM pferde WHERE nr='".$nr."'"; $result = mysqli_query( $lk, $sql); $row = mysqli_fetch_row($result); if (strtoupper($row[2]) == "M" && $lang == "de") $sex = "Hengst"; if (strtoupper($row[2]) == "F" && $lang == "de") $sex = "Stute"; if (strtoupper($row[2]) == "M" && $lang == "en") $sex = "M"; if (strtoupper($row[2]) == "F" && $lang == "en") $sex = "F"; $vater_sql="SELECT name,vater FROM pferde WHERE nr='".$row[3]."'"; $vater_result = mysqli_query($lk,$vater_sql); $vater_row = mysqli_fetch_row($vater_result); $mutter_sql="SELECT name,vater FROM pferde WHERE nr='".$row[4]."'"; $mutter_result = mysqli_query($lk,$mutter_sql); $mutter_row = mysqli_fetch_row($mutter_result); if ($lang == "de"){ return ucfirst($sex)." v. ".$vater_row[0]." a.d. ".$mutter_row[0]; } else { return ucfirst($sex)." by ".$vater_row[0]." out of ".$mutter_row[0]; } } function getparent($fatherormother,$ebene,$pnr) { $lk=connect(); if ($fatherormother=="mother") $mof="mutter"; else $mof="vater"; $i=0; while ($i<$ebene) { $sql="SELECT A.name,A.nr,A.geburtstag FROM pferde AS A, pferde AS B WHERE B.nr='$pnr' AND B.$mof=A.nr"; $res=mysqli_query($lk,$sql); $row=mysqli_fetch_row($res); $i++; $pnr=$row[1]; } return $row; } ?>>"; $val_news_alle = "all news >>"; $val_news_oben = "top"; $val_news_zurueck = "<< back"; /* =================================================== */ /* Definition der Textbausteine Immobilien */ /* =================================================== */ $val_immobilien = "real estate"; $val_immobilien_refnr = "ref.-nr."; $val_immobilien_detail = "details"; $val_immobilien_beobachten = "add to watchlist"; $val_immobilien_druck = "print version"; $val_immobilien_zurueck = "back"; $val_immobilien_reftext = "reference number:"; $val_immobilien_kontakt = "contact and Info"; $val_immobilien_ort = "town:"; $val_immobilien_kategorie = "categorie:"; $val_immobilien_wfl = "living area (m²):"; $val_immobilien_grund = "land area (m²):"; $val_immobilien_schlaf = "number of bedrooms:"; $val_immobilien_bad = "number of bathrooms:"; $val_immobilien_beschreibung = "description"; $val_immobilien_provisionen = "no commission is due to be paid by the buyer."; $val_immobilien_auf_anfrage = "on request"; $val_immobilien_druck_detail = "OBJECT DETAILS"; /* =================================================== */ /* Definition Loginbereich */ /* =================================================== */ $val_login_head = "Customer Login"; $val_login_name = "User name"; $val_login_pass = "Password"; $val_login_send = "Login"; $val_login_false = "Login failed"; $val_logout_head = "Logged in as:"; $val_logout_send = "Logout"; $val_user_edit = "Change data"; $val_user_edit_save = "save changes"; $val_user_edit_message = "data saved!"; $val_user_edit_ok = "<< ok >>"; $val_user_name = "Name"; $val_user_email = "First name"; $val_user_login = "Login-Name"; $val_user_password = "Password"; $val_user_passw_confirm = "Confirm password"; $val_user_info = "INFO"; $val_user_response_1 = "Thank you very much"; $val_user_response_2 = "Your personal account has been updated"; $val_user_response_failed_1 = "Please check your data!"; $val_user_response_failed_2 = ""; $val_user_message_1 = "Update your personal account."; $val_user_message_2 = "*Confirm password please."; $val_account_header = "Apply for user account"; $val_account_new = "Not registered yet? Apply now"; $val_login_title = "Customer login"; $val_login_text1 = "Please understand that some content only registered customers can be made available."; $val_login_text2 = "It's necessary that you identify yourself with your personal login information in order to use this service."; $val_login_text3 = ""; $val_login_text4 = ""; $val_login_text5 = ""; /* =================================================== */ /* Definition shop */ /* =================================================== */ $val_shop_name = "Onlineshop"; $val_shop_warenkorb_mini = "shoppping basket"; $val_shop_artikel_mini = "article"; $val_shop_anzahl1_mini = "total: "; $val_shop_anzahl2_mini = "article"; $val_shop_anz_mini = "amount"; $val_shop_preis_mini = "price"; $val_shop_gesamt_mini = "total"; $val_shop_waehrung_mini = "Euro"; $val_shop_aendern_mini = "[edit]"; $val_shop_bestellen_mini = "[order]"; $val_shop_aktualisieren = "[refresh]"; $val_shop_artikel_waehrung_mini = "€"; $val_shop_artikel_summe_mini = "total:"; $val_shop_artikel_waehrung2_mini = "€"; $val_shop_suchen = ">> search"; $val_shop_kein_suchbegriff = "please enter searchtext!"; $val_shop_warenkorb = "basket"; $val_shop_in_warenkorb = "[add to basket]"; $val_shop_anzahl_in_warenkorb = " articles added to basket!"; $val_shop_zurueck = "[back]"; $val_shop_weiter = "[next]"; $val_shop_schliessen = "[close]"; $val_shop_nav_1 = "article:"; $val_shop_nav_2 = "to:"; $val_shop_nav_3 = "of:"; $val_shop_nav_4 = "articles"; $val_shop_keine_artikel = "no articles found!"; $val_shop_zusatz_1 = "incl. taxes"; $val_shop_artikelbez = "no.:"; $val_shop_waehrung = "€"; $val_shop_detail = "[more...]"; $val_shop_bestellen = "[order]"; $val_shop_anz = "amount:"; $val_shop_preis = "price:"; $val_shop_artikel_aendern_abfragen ="edit amount?"; $val_shop_artikel_loeschen_abfragen ="delete?"; $val_shop_artikel_waehrung = "€"; $val_shop_artikel_summe = "total:"; $val_shop_artikel_waehrung2 = "€"; $val_shop_artikel_aendern = "[edit]"; $val_shop_artikel_löschen = "[delete]"; /* =================================================== */ /* Definition Produktkatalog */ /* =================================================== */ $val_prod_name = "CATALOGUE"; $val_prod_suchen = ">> search"; $val_prod_kein_suchbegriff = "please enter search value!"; $val_prod_zurueck = "[back]"; $val_prod_weiter = "[next]"; $val_prod_schliessen = "[close]"; $val_prod_nav_1 = "article:"; $val_prod_nav_2 = "to:"; $val_prod_nav_3 = "of:"; $val_prod_nav_4 = "article"; $val_prod_keine_artikel = "no article found!"; $val_prod_zusatz_1 = ""; $val_prod_artikelbez = "ordernr:"; $val_prod_detail = "[details...]"; /* =================================================== */ /* Definition bestellungen */ /* =================================================== */ /* =================================================== */ /* CUSTOMIZING STAUFFENBERG START */ /* =================================================== */ /* =================================================== */ /* Definition der Textbausteine horses */ /* =================================================== */ $val_horses_title = "Foals"; $val_horses_mares = "Broodmares"; $val_horses_mares_ehemalig = "Former Mares"; $val_horses_pedigree = "Cataloguepedigree"; #$val_horses_history = "Details"; $val_horses_5xpedigree = "5 x Pedigree"; $val_horses_profil = "Profile"; $val_horses_detail = "Short note"; $val_horses_performances = "Performances"; $val_horses_nachkommen = "Offspring"; $val_horses_fotos = "Pictures"; $val_horses_video = "Video"; $val_horses_yo = "yo"; /* =================================================== */ /* Definition der Textbausteine horses / records */ /* =================================================== */ $val_records_starts = "Starts"; $val_records_date = "Date"; $val_records_rank = "Place"; $val_records_horse = "Horse"; $val_records_race = "Race Course"; $val_records_place = "Location"; $val_records_pricemoney = "Prizemoney"; $val_records_type = "Type"; /* =================================================== */ /* Definition der Textbausteine horses / breed */ /* =================================================== */ $val_breed_title = "Breeding Records & Matings"; $val_breed_title_1 = "Breeding Records"; $val_breed_title_2 = "Matings"; $val_breed_mare = "Mare"; $val_breed_covered = "covered by"; $val_breed_not_covered = "not covered"; $val_breed_maiden = "Maiden"; $val_breed_last = "last service"; $val_breed_result = "Result"; $val_von = "by"; /* =================================================== */ /* Definition der Textbausteine horses / foals */ /* =================================================== */ $val_foal_title = "Foals"; $val_foal_year_title = "Yearlings"; $val_foal_name = "Name"; $val_foal_sex = "color"; $val_foal_sex_2 = "sex"; $val_foal_parents = "sire"; $val_foal_parents_2 = "dam"; $val_foal_birth = "born"; /* =================================================== */ /* Definition der Textbausteine horses / history */ /* =================================================== */ $val_history_breeder = "Breeder:"; $val_history_owner = "Owner:"; $val_history_purchased = "purchased"; $val_history_race_record = "Carreer"; $val_history_age = "Age"; $val_history_starts = "Starts"; $val_history_first = "1."; $val_history_places = "Places"; $val_history_prizemoney = "Pricemoney"; $val_history_total = "Total"; $val_history_breeding_record = "Breeding Record"; $val_history_year = "Year:"; $val_history_foal = "Foal:"; $val_history_sex = "Sex:"; $val_history_sire = "Sire:"; /* =================================================== */ /* Definition der Textbausteine horses / horse */ /* =================================================== */ $val_horse_title = "Mares"; $val_horse_name = "Name"; $val_foal_family = "family"; $val_horse_sex = "sex"; $val_horse_parents = "sire"; $val_horse_parents_2 = "dam"; $val_horse_birth = "born"; /* =================================================== */ /* Definition der Textbausteine horses / pedigree */ /* =================================================== */ $val_pedigree_father = "sire"; $val_pedigree_mother = "dam"; $val_pedigree_pdf = "Cataloguepedigree (PDF-File)"; $val_profile_pdf = "Profile (PDF Download)"; $val_auction_pdf = "Salespedigree (PDF-File)"; /* =================================================== */ /* Definition der Textbausteine horses / performances */ /* =================================================== */ $val_performances_starts = "Starts"; $val_performances_date = "Date"; $val_performances_place = "Location"; $val_performances_races = "Race course"; $val_performances_distance = "Distance"; $val_performances_prize = "Win money"; $val_performances_category = "Category"; $val_performances_type = "Type"; $val_performances_weight = "Weight"; $val_performances_rank = "Place"; $val_performances_prizemoney = "Prize money"; /* =================================================== */ /* Definition der Textbausteine horses / stats */ /* =================================================== */ $val_stats_title = "Statistic"; $val_stats_to = "including"; $val_stats_total = "All"; $val_stats_3j = "3yo and older"; $val_stats_products = "Offspring"; $val_stats_wins = "Wins"; $val_stats_starts = "Starter"; $val_stats_inmoney = "in the money"; $val_stats_2j_starts = "2yo Starter"; $val_stats_2j_money = "2yo in the money"; $val_stats_stakes = "Stakesperformer"; $val_stats_winsum = "Prizemoney"; $val_stats_winsum_child = "Prizemoney/Offspring"; $val_stats_winsum_starts = "Prizemoney/Starter"; /* =================================================== */ /* Definition der Textbausteine races */ /* =================================================== */ $val_races_course = "Race course:"; $val_races_rank = "Place"; $val_races_horse = "Horse"; $val_races_weight = "Weight"; $val_races_owner = "Owner (Trainer)"; $val_races_rider = "Jockey"; $val_races_quotes = "Odds"; $val_races_richterspruch = "offical verdict:"; $val_races_preisgeld = "Prizemoney"; /* =================================================== */ /* Definition der Textbausteine sale */ /* =================================================== */ $val_sale_title = "Successes"; /* =================================================== */ /* Definition der Textbausteine sale / auction */ /* =================================================== */ $val_auction_title = "Sales"; $val_auction_name = "Name"; $val_auction_sex = "color"; $val_auction_sex_2 = "sex"; $val_auction_parents = "sire"; $val_auction_parents_2 = "dam"; $val_auction_birth = "born"; $val_auction_lot = "Lot"; /* =================================================== */ /* Definition der Textbausteine stable / archiv */ /* =================================================== */ $val_archiv_title = "Racing Stable"; $val_archiv_name = "Name"; $val_archiv_starts = "Starts"; $val_archiv_wins = "Wins"; $val_archiv_place = "Places"; $val_archiv_winsum = "Prize Money"; $val_archiv_total = "Total"; $val_archiv_headline = "PICTURES OF THE HORSES AND THEIR SUCCESSES"; $val_archiv_age = "yo."; /* =================================================== */ /* Definition der Textbausteine stable */ /* =================================================== */ $val_stable_title = "Racing Management"; $val_horse_gestuet_title = "Breeding successes"; /* =================================================== */ /* CUSTOMIZING STAUFFENBERG ENDE */ /* =================================================== */ ?>

EBF Mirror Punters Club Maiden Stakes, Maiden - 1.738 m - GBP3,234.50

1
Lycidas
9-3
T Coles, Graf & Gräfin Stauffenberg (T Coles)
S Donohoe
3.780
2
Ace of Valhalla
9-3
I Wilson (Sir H Cecil)
T Queally
3
Confirmed
9-3
Sheikh Sultan bin Khalifa al Nahayan (M Botti)
A Kirby
11, 2 1/2-1 1/2-1/2-1-3 1/2, 1:50,38