';
return '';
}
function reiter_tabelle_ende(){
# return '
';
return '';
}
function reiter_tabelle_eintrag($nmaktiv,$hyperlink,$val_hyperlink){
# if ($nmaktiv == ""){
# return ' | ';
# } else {
# return ' | ';
# }
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 */
/* =================================================== */
?>