'; 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 */ /* =================================================== */ ?>
04.11.2010
Gr.2
Down Royal/IRE
Gr.2
10.000 €
2
13.10.2010
Gr.3
Punchestown/IRE
Gr.3
6.100 €
2
25.09.2010
L
Cologne/GER
L
13.000 €
1
02.09.2010
L
Baden-Baden/GER
L
12.000 €
1
02.10.2010
L
Hannover/GER
L
12.000 €
1
22.10.2010
L
Baden-Baden/GER
L
5.000 €
2
31.05.2010
L
Taeby/SWE
L
2.924 €
5
16.06.2010
L.
Nantes/F
L.
2.750 €
5
24.07.2010
L
München/GER
L
2.400 €
3
27.03.2010
L
Düsseldorf/GER
L
1.200 €
4
08.05.2010
L
Köln/GER
L
1.000 €
4
12.06.2010
NL
München/GER
NL
11.000 €
2
11.09.2010
NL
Dortmund/GER
NL
2.000 €
5
12.06.2010
Allowance
Hollywood Park/USA
Allowance
14.181 €
1
22.07.2010
Allowance
Del Mar/USA
Allowance
5.268 €
2
08.05.2010
Allowance
Taeby/SWE
Allowance
5.156 €
1
22.10.2010
Allowance
Kincsem Park/HUN
Allowance
1.981 €
1
06.02.2010
Allowance
Roma/ITY
Allowance
1.122 €
2
21.08.2010
Allowance
Miesau/GER
Allowance
1.000 €
1
25.09.2010
Allowance
Mannheim/GER
Allowance
950 €
1
02.10.2010
Allowance
München/GER
Allowance
700 €
2
02.01.2010
Allowance
Dortmund/GER
Allowance
400 €
2
23.01.2010
Allowance
Dortmund/GER
Allowance
400 €
3
07.09.2010
Handicap
Betfair Park/AUS
Handicap
13.168 €
1
16.09.2010
Handicap
Saint Cloud/F
Handicap
12.000 €
1
14.04.2010
Handicap
Fontainebleau/F
Handicap
9.120 €
1
14.05.2010
Handicap
Strassbourg/FR
Handicap
8.500 €
1
14.09.2010
Handicap
Auteuil/F
Handicap
6.440 €
3
21.05.2010
Handicap
Chester/GB
Handicap
6.330 €
1
30.07.2010
Handicap
Doncaster/GB
Handicap
6.226 €
1
05.05.2010
Handicap
Goodwood/GB
Handicap
4.964 €
1
02.07.2010
Handicap
Nottingham/GB
Handicap
4.703 €
1
14.08.2010
Handicap
Pontefract/GB
Handicap
3.960 €
1
19.08.2010
Handicap
York/GB
Handicap
3.822 €
4
15.10.2010
Handicap
Auteuil/FR
Handicap
3.800 €
4
28.03.2010
Handicap
Lingfield/GB
Handicap
3.043 €
1
14.01.2010
Handicap
Wolverhampton/GB
Handicap
2.129 €
1
02.08.2010
Handicap
Catterick/GB
Handicap
2.056 €
1
04.07.2010
Handicap
Windsor/GB
Handicap
1.744 €
2
15.11.2010
Handicap
Angers/F
Handicap
1.615 €
4
02.09.2010
Handicap
Baden-Baden/GER
Handicap
1.400 €
3
29.07.2010
Handicap
Newmarket/GB
Handicap
1.391 €
3
06.07.2010
Handicap
Kempton/GB
Handicap
1.388 €
2
08.12.2010
Handicap
Kempton/GB
Handicap
1.377 €
2
03.11.2010
Handicap
Lingfield/GB
Handicap
1.205 €
2
31.07.2010
Handicap
Düsseldorf/GER
Handicap
1.000 €
3
30.04.2010
Handicap
Düsseldorf/GER
Handicap
1.000 €
4
13.07.2010
Handicap
Hamburg/GER
Handicap
900 €
3
02.10.2010
Handicap
Kincsem Park/HUN
Handicap
872 €
1
03.07.2010
Handicap
München/GER
Handicap
840 €
2
27.04.2010
Handicap
Kempton/GB
Handicap
721 €
3
08.02.2010
Handicap
Southwell/GB
Handicap
633 €
2
30.12.2010
Handicap
Neuss/GER
Handicap
600 €
3
14.09.2010
Handicap
Yarmouth/GB
Handicap
505 €
4
21.01.2010
Handicap
Wolverhampton/GB
Handicap
441 €
2
12.05.2010
Handicap
Dortmund/GER
Handicap
400 €
4
08.06.2010
Handicap
Kempton/GB
Handicap
380 €
4
09.05.2010
Handicap
Wolverhampton/GB
Handicap
364 €
4
03.02.2010
Handicap
Wolverhampton/GB
Handicap
363 €
3
09.06.2010
Handicap
Nottingham/GB
Handicap
321 €
4
15.09.2010
Handicap
Wolverhampton/GB
Handicap
253 €
3
18.07.2010
Handicap
Beverley/GB
Handicap
224 €
4
21.04.2010
Maiden
Nantes/FR
Maiden
7.000 €
1
12.04.2010
Maiden
Pontefract/GB
Maiden
5.143 €
1
10.04.2010
Maiden
Frankfurt/GER
Maiden
3.000 €
1
10.08.2010
Maiden
Frankfurt/GER
Maiden
3.000 €
1
05.10.2010
Maiden
Cologne/GER
Maiden
3.000 €
1
01.10.2010
Maiden
Longchamp/FR
Maiden
2.500 €
4
12.07.2010
Maiden
Hamburg/GER
Maiden
1.700 €
2
09.07.2010
Maiden
Hamburg/GER
Maiden
1.400 €
2
12.05.2010
Maiden
Dortmund/GER
Maiden
1.200 €
2
19.06.2010
Maiden
Dortmund/GER
Maiden
1.200 €
2
30.12.2010
Maiden
Neuss/GER
Maiden
1.050 €
2
13.03.2010
Maiden
Neuss/GER
Maiden
1.050 €
2
28.03.2010
Maiden
Lingfield/GB
Maiden
895 €
2
08.05.2010
Maiden
München/GER
Maiden
650 €
2
14.08.2010
Maiden
Kincsem Park/HUN
Maiden
634 €
1
22.05.2010
Maiden
Saarbruecken/GER
Maiden
600 €
2
22.05.2010
Maiden
Hoppegarten/GER
Maiden
600 €
3
17.06.2010
Maiden
Bremen/GER
Maiden
600 €
3
05.10.2010
Maiden
Cologne/GER
Maiden
600 €
3
03.06.2010
Maiden
Goodwood/GB
Maiden
349 €
4
14.08.2010
Maiden
München/GER
Maiden
300 €
4
28.08.2010
Maiden
Berlin-Hoppegarten/GER
Maiden
300 €
4
12.08.2010
Del Mar/USA
612 €
5