(".$langKw["SOLD"].")"; else if ($New) $SoldStr = " (".$langKw["NEW"].")"; else $SoldStr = ""; $PageTitle = $langTl["InformationForAnimal"]; do_html_header("$PageTitle: $AlpacaName$SoldStr"); $EscBreederName = EscapeForHtml($BreederName); $sessionid = session_id(); if ($Package) { if ($FromBreeder) echo ""; else echo ""; } else { if ($FromCustSearch) echo ""; else echo ""; } if ($Package) echo $langKw["backtopackagedetails"]; else { if ($Direct) { if ($FromCustSearch) echo $langKw["backtosearchresults"]; else echo $langKw["backtoanimallist"]; } else { if ($Sold) echo $langKw["backtosoldlist"]; else echo $langKw["backtobreederanimallist"]; } } echo ""; echo "

"; $JSPopupCodeDone = false; $JSIndex = 0; if (alpaca_db_connection($connection)) // Connect to the alpaca database { $query = "SELECT " ."BloodLinage, " ."RegisteredWith, " ."AlpacaType, " ."CriaAtFoot, " ."CriaDescription, " ."BreedType, " ."Homozygous, " ."SireName, " ."DamName, " ."SireColour, " ."DamColour, " ."SireSolidColour, " ."DamSolidColour, " ."SireBreedType, " ."DamBreedType, " ."SireSire, " ."SireDam, " ."DamSire, " ."DamDam, " ."SireSireSire, " ."SireSireDam, " ."SireDamSire, " ."SireDamDam, " ."DamSireSire, " ."DamSireDam, " ."DamDamSire, " ."DamDamDam, " ."PrizesWon, " ."LastFleeceSD, " ."LastFleeceCV, " ."FirstFlMicron, " ."LastFlMicron, " ."Price, " ."FORMAT(Price,2) AS FormatPrice, " ."Currency, " ."FibreOver30, " ."Yield, " ."SF, " ."Colour, " ."DateOfBirth, " ."DateLastFleece, " ."NumberCrias, " ."CriaSire, " ."CriaSireColour, " ."CriaDueDate, " ."CriaDOB, " ."Description, " ."SolidColour, " ."Proven, " ."FibreAuthority, " ."FleeceNumber, " ."CriaSex, " ."PriceOptions, " ."Curve, " ."CriaAtFootSire, " ."CriaAtFootSireColour, " ."Photo1Title, " ."Photo2Title, " ."Photo3Title, " ."AlpacaImageFile, " ."AlpacaImageFile2, " ."AlpacaImageFile3 " ."FROM Animal " ."where AnimalID=$AnimalID"; // Find the user in the database $result = mysql_query($query,$connection); $num_results = mysql_num_rows($result); if ($num_results > 0) { $data = mysql_fetch_array($result); $BloodLinage = $data["BloodLinage"]; $RegisteredWith = $data["RegisteredWith"]; $AlpacaType = $data["AlpacaType"]; $AlpacaType = TranslateToLocalLang($AlpacaType); $BreedType = $data["BreedType"]; $BreedType = TranslateToLocalLang($BreedType); $Homozygous = $data["Homozygous"]; if ($BreedType == "Suri") { if ($Homozygous) { $BreedType = "Suri (Homozygous)"; } } $SireName = $data["SireName"]; $DamName = $data["DamName"]; $SireColour = $data["SireColour"]; $SireColour = TranslateToLocalLang($SireColour); $DamColour = $data["DamColour"]; $DamColour = TranslateToLocalLang($DamColour); $SireSolidColour= $data["SireSolidColour"]; $SireSolidColour= TranslateToLocalLang($SireSolidColour); $DamSolidColour = $data["DamSolidColour"]; $DamSolidColour = TranslateToLocalLang($DamSolidColour); $SireBreedType = $data["SireBreedType"]; $SireBreedType = TranslateToLocalLang($SireBreedType); $DamBreedType = $data["DamBreedType"]; $DamBreedType = TranslateToLocalLang($DamBreedType); $SireSire = $data["SireSire"]; $SireDam = $data["SireDam"]; $SireSireSire = $data["SireSireSire"]; $SireSireDam = $data["SireSireDam"]; $SireDamSire = $data["SireDamSire"]; $SireDamDam = $data["SireDamDam"]; $DamSire = $data["DamSire"]; $DamDam = $data["DamDam"]; $DamSireSire = $data["DamSireSire"]; $DamSireDam = $data["DamSireDam"]; $DamDamSire = $data["DamDamSire"]; $DamDamDam = $data["DamDamDam"]; $PrizesWon = $data["PrizesWon"]; $LastFleeceSD = $data["LastFleeceSD"]; $LastFleeceCV = $data["LastFleeceCV"]; $FirstFlMicron = $data["FirstFlMicron"]; $LastFlMicron = $data["LastFlMicron"]; $Price = $data["Price"]; $FormatPrice = $data["FormatPrice"]; $Currency = $data["Currency"]; $FibreOver30 = $data["FibreOver30"]; $Yield = $data["Yield"]; $SF = $data["SF"]; $Curve = $data["Curve"]; $Colour = $data["Colour"]; $Colour = TranslateToLocalLang($Colour); $DateOfBirth = $data["DateOfBirth"]; $DateLastFleece = $data["DateLastFleece"]; $NumberCrias = $data["NumberCrias"]; $CriaSire = $data["CriaSire"]; $CriaSireColour = $data["CriaSireColour"]; $CriaSireColour = TranslateToLocalLang($CriaSireColour); $CriaAtFootSire = $data["CriaAtFootSire"]; $CriaAtFootSireColour = $data["CriaAtFootSireColour"]; $CriaAtFootSireColour = TranslateToLocalLang($CriaAtFootSireColour); $CriaDueDate = $data["CriaDueDate"]; $CriaDOB = $data["CriaDOB"]; $Description = $data["Description"]; $CriaDescription= $data["CriaDescription"]; $SolidColour = $data["SolidColour"]; $Proven = $data["Proven"]; $AlpacaImageFile= $data["AlpacaImageFile"]; $AlpacaImageFile2= $data["AlpacaImageFile2"]; $AlpacaImageFile3= $data["AlpacaImageFile3"]; $CriaAtFoot = $data["CriaAtFoot"]; $Photo1Title = $data["Photo1Title"]; $Photo2Title = $data["Photo2Title"]; $Photo3Title = $data["Photo3Title"]; $CriaSex = $data["CriaSex"]; $PriceOptions = $data["PriceOptions"]; $FibreAuthority = $data["FibreAuthority"]; $FleeceNumber = $data["FleeceNumber"]; // Overide Currency $Currency = $OverideCurrency; $TransCurrency = TranslateToLocalLang($Currency); $BloodLinage = stripslashes($BloodLinage); $RegisteredWith = stripslashes($RegisteredWith); $SireName = stripslashes($SireName); $DamName = stripslashes($DamName); $PrizesWon = stripslashes($PrizesWon); $Description = stripslashes($Description); $CriaDescription= stripslashes($CriaDescription); $CriaSire = stripslashes($CriaSire); $CriaAtFootSire = stripslashes($CriaAtFootSire); $SireSire = stripslashes($SireSire); $SireDam = stripslashes($SireDam); $SireSireSire = stripslashes($SireSireSire); $SireSireDam = stripslashes($SireSireDam); $SireDamSire = stripslashes($SireDamSire); $SireDamDam = stripslashes($SireDamDam); $DamSire = stripslashes($DamSire); $DamDam = stripslashes($DamDam); $DamSireSire = stripslashes($DamSireSire); $DamSireDam = stripslashes($DamSireDam); $DamDamSire = stripslashes($DamDamSire); $DamDamDam = stripslashes($DamDamDam); $Photo1Title = stripslashes($Photo1Title); $Photo2Title = stripslashes($Photo2Title); $Photo3Title = stripslashes($Photo3Title); $FleeceNumber = stripslashes($FleeceNumber); $CriaSex = stripslashes($CriaSex); $PriceOptions = stripslashes($PriceOptions); $FibreAuthority = stripslashes($FibreAuthority); $FleeceNumber = TranslateToLocalLang($FleeceNumber); $CriaSex = TranslateToLocalLang($CriaSex); $PriceOptions = TranslateToLocalLang($PriceOptions); mysql_free_result($result); // Get the Dates GetPHPDateFormat($DateFormat); if ($DateOfBirth != NULL) // Should never be NULL - but check anyway. { $query = "SELECT UNIX_TIMESTAMP(DateOfBirth) FROM Animal " ."WHERE AnimalID='$AnimalID'"; $result = mysql_query($query,$connection); $data = mysql_fetch_array($result); $DOBUnixTimeStamp = $data["UNIX_TIMESTAMP(DateOfBirth)"]; DateFudge($DOBUnixTimeStamp); $DOBDateFormated = date($DateFormat,$DOBUnixTimeStamp); mysql_free_result($result); } if ($DateLastFleece != "0000-00-00") { $query = "SELECT UNIX_TIMESTAMP(DateLastFleece) FROM Animal " ."WHERE AnimalID='$AnimalID'"; $result = mysql_query($query,$connection); $data = mysql_fetch_array($result); $DLFlUnixTimeStamp = $data["UNIX_TIMESTAMP(DateLastFleece)"]; DateFudge($DLFlUnixTimeStamp); $DLFDateFormated = date($DateFormat,$DLFlUnixTimeStamp); mysql_free_result($result); } else { $DLFlUnixTimeStamp = 0; $DLFDateFormated = NULL; } if ($CriaDueDate != "0000-00-00") { $query = "SELECT UNIX_TIMESTAMP(CriaDueDate), " ."UNIX_TIMESTAMP(DATE_ADD(CriaDueDate,INTERVAL 11 MONTH)) " ."AS EstimatedDueDate " ."FROM Animal " ."WHERE AnimalID='$AnimalID'"; $result = mysql_query($query,$connection); $data = mysql_fetch_array($result); $CDUnixTimeStamp = $data["UNIX_TIMESTAMP(CriaDueDate)"]; DateFudge($CDUnixTimeStamp); $ESCDUnixTimeStamp = $data["EstimatedDueDate"]; DateFudge($ESCDUnixTimeStamp); $CDDateFormated = date($DateFormat,$CDUnixTimeStamp); $ESCDDateFormated = date($DateFormat,$ESCDUnixTimeStamp); mysql_free_result($result); } else { $CDUnixTimeStamp = 0; $CDDateFormated = NULL; } if ($CriaDOB != "0000-00-00") { $query = "SELECT UNIX_TIMESTAMP(CriaDOB) " ."FROM Animal " ."WHERE AnimalID='$AnimalID'"; $result = mysql_query($query,$connection); $data = mysql_fetch_array($result); $CDOBUnixTimeStamp = $data["UNIX_TIMESTAMP(CriaDOB)"]; DateFudge($CDOBUnixTimeStamp); $CDOBDateFormated = date($DateFormat,$CDOBUnixTimeStamp); mysql_free_result($result); } else { $CDOBUnixTimeStamp = 0; $CDOBDateFormated = NULL; } $breederquery = "SELECT SalesTax FROM Breeder WHERE BreederID=$BreederID"; // Find the breeder in the database $result = mysql_query($breederquery,$connection); $num_results = mysql_num_rows($result); if ($num_results > 0) { $data = mysql_fetch_array($result); $SalesTax = $data["SalesTax"]; $SalesTax = TranslateToLocalLang($SalesTax); $Success = true; mysql_free_result($result); } } } if (!$Success) { echo "$langTx[0]
"; exit; } else { UpdateHits("Animal", $AnimalID); $JSPopupCodeDone = false; } if ($Direct) $Width = "100%"; else $Width = "700"; ?> "; } ?>

  

"; echo ""; } ?> "; echo ""; echo ""; echo ""; } if ($RegisteredWith) { echo ""; echo ""; echo ""; echo ""; } if ($Description) { echo ""; echo ""; echo ""; echo ""; } if ($PrizesWon) { echo ""; echo ""; echo ""; echo ""; } ?>
"; echo "
"; echo $langKw["picture"]; echo "
"; echo "("; echo $langKw["clickonpicforlarger"]; echo ")"; echo "
"; echo ""; echo "\"$AlpacaName\""; echo ""; if (AlpacaPhotoExistsInDir($AnimalID,"Animal","T2")) { echo "  "; echo ""; echo "\"$AlpacaName\""; echo ""; } if (AlpacaPhotoExistsInDir($AnimalID,"Animal","T3")) { echo "  "; echo ""; echo "\"$AlpacaName\""; echo ""; } echo "
"; echo "
"; echo $langKw["bloodlineage"]; echo"
"; echo "
$BloodLinage
"; echo "
"; echo $langKw["organisationsregisteredwith"]; echo"
"; echo "
"; echo nl2br($RegisteredWith); echo "
"; echo "
"; echo $langKw["description"]; echo"
"; echo "
"; echo nl2br($Description); echo "
"; echo "
"; echo $langKw["prizeswon"]; echo"
"; echo "
"; echo nl2br($PrizesWon); echo "

  

0) { ?>
0) { $Symbol = ""; GetCurrencySymbol($Currency,$Symbol); echo "$Symbol"; echo "$FormatPrice"; } else if ($PriceOptions == $langKw["na"]) { echo $langKw["contactforprice"]; } else { echo $PriceOptions; } ?>
  "; echo $langKw["fleeceinfo"]; echo"

"; echo ""; if ($DLFDateFormated) { echo ""; echo ""; echo ""; echo ""; DoCalculateFleeceAge($DOBUnixTimeStamp,$DLFlUnixTimeStamp); } else { if ( $LastFleeceSD != 0.0 || $LastFleeceCV != 0.0 || $LastFlMicron != 0.0 || $FibreOver30 != 127) { echo ""; echo ""; echo ""; echo ""; } } if ($FibreAuthority != $langUkKw["notspecified"]) { if ( $LastFleeceSD != 0.0 || $LastFleeceCV != 0.0 || $LastFlMicron != 0.0 || $FibreOver30 != 127) { echo ""; echo ""; echo ""; echo ""; } } if ($FleeceNumber != $langKw["notspecified"]) { if ( $LastFleeceSD != 0.0 || $LastFleeceCV != 0.0 || $LastFlMicron != 0.0 || $FibreOver30 != 127) { echo ""; echo ""; echo ""; echo ""; } } if ($FirstFlMicron && $FirstFlMicron != 0.0) { echo ""; echo ""; echo ""; echo ""; } if ($LastFlMicron && $LastFlMicron != 0.0) { echo ""; echo ""; echo ""; echo ""; } if ($LastFleeceSD && $LastFleeceSD != 0.0) { echo ""; echo ""; echo ""; echo ""; } if ($LastFleeceCV && $LastFleeceCV != 0.0) { echo ""; echo ""; echo ""; echo ""; } if ($FibreOver30 != "" && $FibreOver30 != 127) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $ComfortFactor = 100 - $FibreOver30; echo ""; echo ""; } if ($Yield && $Yield != 0.0) { echo ""; echo ""; echo ""; echo ""; } if ($SF && $SF != 0.0) { echo ""; echo ""; echo ""; echo ""; } if ($Curve && $Curve != 0.0) { echo ""; echo ""; echo ""; echo ""; } echo "
"; echo "
"; echo $langKw["dolastsample"]; echo "
"; echo "
$DLFDateFormated
"; echo "
"; echo $langKw["dolastsample"]; echo "
"; echo "
"; echo $langKw["didnotsubmitlastsample"]; echo "
"; echo "

"; echo $langKw["fibretestingauthority"]; echo "

"; echo "
$FibreAuthority
"; echo "

"; echo $langKw["fleecenumber"]; echo "

"; echo "
$FleeceNumber
"; echo "

"; echo $langKw["micronfirstsample"]; echo "

"; echo "
$FirstFlMicron
"; echo "
"; echo $langKw["micronlastsample"]; echo "
"; echo "
$LastFlMicron
"; echo "
"; echo $langKw["sdlastsample"]; echo "
"; echo "
$LastFleeceSD
"; echo "
"; echo $langKw["cvlastsample"]; echo "
"; echo "
$LastFleeceCV
"; echo "
"; echo $langKw["over30lastsample"]; echo "
"; echo "
$FibreOver30
"; echo "
"; echo $langKw["lastcomfortfactor"]; echo "
"; echo "
$ComfortFactor
"; echo "
"; echo $langKw["yieldlastsample"]; echo "
"; echo "
$Yield
"; echo "
"; echo $langKw["sflastsample"]; echo "
"; echo "
$SF
"; echo "
"; echo $langKw["curvelastsample"]; echo "
"; echo "
$Curve
"; } if ($AlpacaType == $langKw["female"] || $AlpacaType == $langKw["pregnantfemale"]) { if ($NumberCrias != 127 || ($AlpacaType == $langKw["pregnantfemale"] && $CriaSire) || ($AlpacaType == $langKw["pregnantfemale"] && $CDDateFormated) || $CriaAtFoot) { echo "

  "; echo $langKw["additionalinfoforfemales"]; echo "

"; } echo ""; if ($NumberCrias != 127) { echo ""; echo ""; echo ""; echo ""; } if ($AlpacaType == $langKw["pregnantfemale"] && $CriaSire) { $StudMatchFound = false; if ($ASCountry == "United Kingdom") { $CountrySQL = "(Country='England' OR Country='Scotland' OR Country='Wales' OR Country='Northern Ireland')"; } else { $CountrySQL = "Country='$ASCountry'"; } $SlashCriaSire = addslashes($CriaSire); $query = "SELECT AnimalID, AlpacaName FROM Stud, Breeder WHERE AlpacaName='$SlashCriaSire'" ."AND Breeder.UserID=Stud.UserID AND $CountrySQL"; $result = mysql_query($query,$connection); $num_results = mysql_num_rows($result); if ($num_results > 0) { $data = mysql_fetch_array($result); $StudAnimalID = $data["AnimalID"]; $StudName = $data["AlpacaName"]; $StudMatchFound = true; } echo ""; echo ""; if ($StudMatchFound) { if (AlpacaPhotoExistsInDir($StudAnimalID, "Stud", "T")) { $StudThumbExists = true; } else { $StudThumbExists = false; } $EscAnimalName = EscapeForHtml($StudName); $EscBreederName = EscapeForHtml($BreederName); if ($StudThumbExists) { if ($JSPopupCodeDone) { $JSIndex ++; ?> "; echo "$CriaSire"; echo ""; } else { echo ""; } echo ""; if ($CriaSireColour != $langKw["notspecified"]) { echo ""; echo ""; echo ""; echo ""; } } if ($AlpacaType == $langKw["pregnantfemale"] && $CDDateFormated) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } if ($CriaAtFoot) { echo ""; echo ""; echo ""; echo ""; if ($CriaSex != $langKw["notspecified"]) { echo ""; echo ""; echo ""; echo ""; } if ($CriaAtFootSire != $langKw["na"] && $CriaAtFootSire != "") { $StudMatchFound = false; if ($ASCountry == "United Kingdom") { $CountrySQL = "(Country='England' OR Country='Scotland' OR Country='Wales' OR Country='Northern Ireland')"; } else { $CountrySQL = "Country='$ASCountry'"; } $SlashCriaSire = addslashes($CriaAtFootSire); $query = "SELECT AnimalID, AlpacaName FROM Stud, Breeder WHERE AlpacaName='$SlashCriaSire'" ."AND Breeder.UserID=Stud.UserID AND $CountrySQL"; $result = mysql_query($query,$connection); $num_results = mysql_num_rows($result); if ($num_results > 0) { $data = mysql_fetch_array($result); $StudAnimalID = $data["AnimalID"]; $StudName = $data["AlpacaName"]; $StudMatchFound = true; } echo ""; echo ""; if ($StudMatchFound) { if (AlpacaPhotoExistsInDir($StudAnimalID, "Stud", "T")) { $StudThumbExists = true; } else { $StudThumbExists = false; } $EscAnimalName = EscapeForHtml($StudName); $EscBreederName = EscapeForHtml($BreederName); if ($StudThumbExists) { if ($JSPopupCodeDone) { $JSIndex ++; ?> "; echo "$CriaAtFootSire"; echo ""; } else { echo ""; } echo ""; if ($CDOBUnixTimeStamp > 0) { echo ""; echo ""; echo ""; echo ""; DoCalculateCriaAge($CDOBUnixTimeStamp); } } if ($CriaAtFootSireColour != $langKw["notspecified"]) { echo ""; echo ""; echo ""; echo ""; } } if ($CriaAtFoot && $CriaDescription != "") { echo ""; echo ""; echo ""; echo ""; } echo "
"; echo "
";echo $langKw["numbercriasbred"]; echo "
"; echo "
$NumberCrias
"; echo "
"; echo $langKw["coveringmale"]; echo "
"; echo "
$CriaSire
"; echo "
"; echo $langKw["coveringmalecolour"]; echo "
"; echo "
$CriaSireColour
"; echo "
"; echo $langKw["lastmatingdate"]; echo "
"; echo "
$CDDateFormated
"; echo "
"; echo $langKw["datecriadue"]; echo "
"; echo "
$ESCDDateFormated
"; echo "
"; echo $langKw["sellingwithcria"]; echo "
"; echo "
"; if ($CriaAtFoot) echo $langKw["yes"]; else echo $langKw["no"]; echo "
"; echo "
"; echo $langKw["sexofcria"]; echo "
"; echo "
"; echo $CriaSex; echo "
"; echo "
"; echo $langKw["sireofcria"]; echo "
"; echo "
"; echo $CriaAtFootSire; echo "
"; echo "
"; echo $langKw["criadob"]; echo "
"; echo "
"; echo "$CDOBDateFormated"; echo "
"; echo "
"; echo $langKw["colourofcriasire"]; echo "
"; echo "
"; echo $CriaAtFootSireColour; echo "
"; echo "
"; echo $langKw["criadescription"]; echo "
"; echo "
$CriaDescription
"; } ?>

  

"; echo $langKw["sendmessage"]; echo ""; ?>

 

"; echo "

"; } if (AlpacaPhotoExistsInDir($AnimalID, "Animal", "1")) { echo ""; echo "
"; if ($Photo1Title) echo $Photo1Title; else echo $langKw["alpacaphoto1"]; echo "  "; echo "("; echo $langKw["backtoalpacainfo"]; echo ")"; echo "

"; echo "\"$AlpacaName\""; echo "
"; } if (AlpacaPhotoExistsInDir($AnimalID, "Animal", "2")) { echo "

"; echo ""; if ($Photo2Title) echo $Photo2Title; else echo $langKw["alpacaphoto2"]; echo "  "; echo "("; echo $langKw["backtoalpacainfo"]; echo ")"; echo "

"; echo "\"$AlpacaName\""; echo "
"; } if (AlpacaPhotoExistsInDir($AnimalID, "Animal", "3")) { echo "

"; echo ""; if ($Photo3Title) echo $Photo3Title; else echo $langKw["alpacaphoto3"]; echo "  "; echo "("; echo $langKw["backtoalpacainfo"]; echo ")"; echo "

"; echo "\"$AlpacaName\""; echo "
"; } if ( AlpacaPhotoExistsInDir($AnimalID, "Animal", "1") || AlpacaPhotoExistsInDir($AnimalID, "Animal", "2") || AlpacaPhotoExistsInDir($AnimalID, "Animal", "3") ) { echo "

"; if ($FromBreeder) echo ""; else echo "
"; } else { if ($FromCustSearch) echo "
"; else echo "
"; } if ($Package) echo $langKw["backtopackagedetails"]; else { if ($Direct) { if ($FromCustSearch) echo $langKw["backtosearchresults"]; else echo $langKw["backtoanimallist"]; } else { if ($Sold) echo $langKw["backtosoldlist"]; else echo $langKw["backtobreederanimallist"]; } } echo ""; mysql_close($connection); do_html_footer(); ?>