// Always call session start before anything else
session_start();
require_once("lang.php");
require_once("alpaca_functions.php");
HandleLanguage("InformationForAnimal");
$ASCountry = $HTTP_SESSION_VARS["ASCountry"];
$AlpacaName = $HTTP_GET_VARS["AlpacaName"];
$AnimalID = $HTTP_GET_VARS["AnimalID"];
$BreederID = $HTTP_GET_VARS["BreederID"];
$BreederName = $HTTP_GET_VARS["BreederName"];
$OverideCurrency= $HTTP_GET_VARS["Currency"];
if (isset($HTTP_GET_VARS["Direct"]))
{
$Direct = $HTTP_GET_VARS["Direct"];
}
else
{
$Direct = 0;
}
if (isset($HTTP_GET_VARS["Sold"]))
{
$Sold = $HTTP_GET_VARS["Sold"];
}
else
{
$Sold = 0;
}
if (isset($HTTP_GET_VARS["New"]))
{
$New = $HTTP_GET_VARS["New"];
}
else
{
$New = 0;
}
if (isset($HTTP_GET_VARS["FromCustSearch"]))
{
$FromCustSearch = $HTTP_GET_VARS["FromCustSearch"];
}
else
{
$FromCustSearch = 0;
}
if (isset($HTTP_GET_VARS["PackageID"]))
{
$PackageID = $HTTP_GET_VARS["PackageID"];
$PackageName = $HTTP_GET_VARS["PackageName"];
$PackageName = stripslashes($PackageName);
$EscPackageName = EscapeForHtml($PackageName);
$Package = true;
if (isset($HTTP_GET_VARS["FromBreeder"]))
{
$FromBreeder = 1;
$Currency = $HTTP_GET_VARS["Currency"];
}
else
{
$FromBreeder = 0;
}
}
else
$Package = false;
$AlpacaName = stripslashes($AlpacaName);
$BreederName = stripslashes($BreederName);
if ($Sold)
$SoldStr = " (".$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 $langKw["alpacainfo"]; ?> echo $langKw["generalinfo"]; ?>
echo $langKw["priceinfo"]; ?>
"; echo $langKw["fleeceinfo"]; echo" "; echo "
"; echo $langKw["additionalinfoforfemales"]; echo " "; } echo "
echo $langKw["contact"]; ?>
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ";
echo " ";
}
if (AlpacaPhotoExistsInDir($AnimalID, "Animal", "1"))
{
echo "";
echo " |