Extended Pedigree

[insert_php]

$dogid = $_GET[id];
if ($dogid == “”) {$dogid = 1;}

/* This program gets news items from the database */
$db=mysql_connect (“localhost”, “dantero”, “kCHqQnXF8DhxZaU”) or die (‘I cannot connect to the database because: ‘ . mysql_error());
mysql_select_db (“dantero_dantero”);

$sql = “select dogs.* from dogs WHERE dogs.id = ” . $dogid;
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);

if ($dogid == 125) {
$showname = $row[‘name’] . ” / Vassiliev des Contes d’Hoffmann”;
} else {
$showname = $row[‘name’];
}
$name = str_replace( “‘”, “”, $row[‘name’]);
$name = str_replace( “’”, “”, $name);

echo “

“;

$gens = $_GET[g];
if ($gens == “”) {$gens = 5;}
$lid = $_GET[lid];
if ($lid == “”) {$lid = 1;}
$real = 0;

echo “

” . chr(10);

if ($_GET[id] <> “”) {

echo “Return to Page

” . chr(10);

$mdog = 0; /* maximum dog to find */
$count = 1;
while ($count < $gens) { $mdog = $mdog + pow(2, $count); $count = $count + 1; } $names[0] = $dogid; GetParents1($dogid, 0, $mdog); if ($gens == 3) {PrintPedi3();} if ($gens == 4) {PrintPedi4();} if ($gens == 5) {PrintPedi5();} if ($gens > 5) {PrintPedi1($gens);}

} else {
$gens = 4;
echo “

” . chr(10);

$sql = “SELECT litters.sire, litters.dam, S.name as sname, D.name as dname FROM `litters` LEFT OUTER JOIN dogs as S on S.id = litters.sire LEFT OUTER JOIN dogs as D on D.id = litters.dam WHERE litters.id = ” . $lid;
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);
$lsire = $row[‘sire’];
$ldam = $row[‘dam’];
$lsname = $row[‘sname’];
$ldname = $row[‘dname’];

$mdog = 0; /* maximum dog to find */
$count = 1;
while ($count < $gens) { $mdog = $mdog + pow(2, $count); $count = $count + 1; } $names[0] = $dogid; GetParents1($lsire, 0, $mdog); PrintPediLit($lsname); $mdog = 0; /* maximum dog to find */ $count = 1; while ($count < $gens) { $mdog = $mdog + pow(2, $count); $count = $count + 1; } $names[0] = $dogid; GetParents1($ldam, 0, $mdog); PrintPediLit($ldname); echo "

” . chr(10);
echo “
” . chr(10);
}

mysql_close($db);

echo “

“;

function GetParents1($id, $loc, $mdog) {
global $names, $real;

$sql = “select dogs.* from dogs WHERE dogs.id = ” . $id;
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);
$sire = ($loc * 2) + 1;
$dam = ($loc * 2) + 2;

$names[$loc] = $row[‘name’];

if ($loc <= $mdog) { if ($real == "1") { GetParents1($row['rsire'], $sire, $mdog); GetParents1($row['rdam'], $dam, $mdog); } else { GetParents1($row['sire'], $sire, $mdog); GetParents1($row['dam'], $dam, $mdog); } } } function PrintPediOld($loc, $indent) { /* $loc and $indent normally 0 */ global $mdog, $names, $gens; $count = 0; while ($count < $indent) { echo " "; $count = $count + 1; } echo $names[$loc] . "
“;

$sire = ($loc * 2) + 1;
$dam = ($loc * 2) + 2;

if ($loc <= $mdog) { PrintPedi1($sire, $indent+1); PrintPedi1($dam, $indent+1); } } function PrintPedi1($gens) { global $mdog, $names; $columns = pow(2, $gens); $cgen = 1; echo "

” . chr(10);
echo “

” . chr(10);
while ($cgen <= $gens) { $dcount = (pow(2, $cgen)-1)*2; echo "

” . chr(10);
while (pow(2, $cgen)-1 <= $dcount) { echo "

” . chr(10);
$dcount = $dcount – 1;
}
echo “

” . chr(10);
$cgen = $cgen + 1;
}

echo “

” . $names[0] . “

” . $names[$dcount] . “

” . chr(10);

}

function PrintPedi3() {
global $names;
// echo “

” . $names[0] . “

” . chr(10);
echo “

” . chr(10);
echo ”

” . chr(10);
echo “

” . $names[‘1’] . “	” . $names[‘3’] . “	” . $names[‘7’] . “
		” . $names[‘8’] . “
	” . $names[‘4’] . “	” . $names[‘9’] . “
		” . $names[’10’] . “
” . $names[‘2’] . “	” . $names[‘5’] . “	” . $names[’11’] . “
		” . $names[’12’] . “
	” . $names[‘6’] . “	” . $names[’13’] . “
		” . $names[’14’] . “

” . chr(10);
echo “
” . chr(10);

}

function PrintPedi4() {
global $names;
// echo “

” . $names[0] . “

” . chr(10);
echo “

” . chr(10);
echo ”

” . chr(10);
echo “

” . $names[‘1’] . “	” . $names[‘3’] . “	” . $names[‘7’] . “	” . $names[’15’] . “
			” . $names[’16’] . “
		” . $names[‘8’] . “	” . $names[’17’] . “
			” . $names[’18’] . “
	” . $names[‘4’] . “	” . $names[‘9’] . “	” . $names[’19’] . “
			” . $names[’20’] . “
		” . $names[’10’] . “	” . $names[’21’] . “
			” . $names[’22’] . “
” . $names[‘2’] . “	” . $names[‘5’] . “	” . $names[’11’] . “	” . $names[’23’] . “
			” . $names[’24’] . “
		” . $names[’12’] . “	” . $names[’25’] . “
			” . $names[’26’] . “
	” . $names[‘6’] . “	” . $names[’13’] . “	” . $names[’27’] . “
			” . $names[’28’] . “
		” . $names[’14’] . “	” . $names[’29’] . “
			” . $names[’30’] . “

” . chr(10);
echo “
” . chr(10);

}

function PrintPedi5() {
global $names;
// echo “

” . $names[0] . “

” . chr(10);
echo “

” . chr(10);
echo ”

” . chr(10);
echo “

” . $names[‘1’] . “	” . $names[‘3’] . “	” . $names[‘7’] . “	” . $names[’15’] . “	” . $names[’31’] . “
				” . $names[’32’] . “
			” . $names[’16’] . “	” . $names[’33’] . “
				” . $names[’34’] . “
		” . $names[‘8’] . “	” . $names[’17’] . “	” . $names[’35’] . “
				” . $names[’36’] . “
			” . $names[’18’] . “	” . $names[’37’] . “
				” . $names[’38’] . “
	” . $names[‘4’] . “	” . $names[‘9’] . “	” . $names[’19’] . “	” . $names[’39’] . “
				” . $names[’40’] . “
			” . $names[’20’] . “	” . $names[’41’] . “
				” . $names[’42’] . “
		” . $names[’10’] . “	” . $names[’21’] . “	” . $names[’43’] . “
				” . $names[’44’] . “
			” . $names[’22’] . “	” . $names[’45’] . “
				” . $names[’46’] . “
” . $names[‘2’] . “	” . $names[‘5’] . “	” . $names[’11’] . “	” . $names[’23’] . “	” . $names[’47’] . “
				” . $names[’48’] . “
			” . $names[’24’] . “	” . $names[’49’] . “
				” . $names[’50’] . “
		” . $names[’12’] . “	” . $names[’25’] . “	” . $names[’51’] . “
				” . $names[’52’] . “
			” . $names[’26’] . “	” . $names[’53’] . “
				” . $names[’54’] . “
	” . $names[‘6’] . “	” . $names[’13’] . “	” . $names[’27’] . “	” . $names[’55’] . “
				” . $names[’56’] . “
			” . $names[’28’] . “	” . $names[’57’] . “
				” . $names[’58’] . “
		” . $names[’14’] . “	” . $names[’29’] . “	” . $names[’59’] . “
				” . $names[’60’] . “
			” . $names[’30’] . “	” . $names[’61’] . “
				” . $names[’62’] . “

” . chr(10);
echo “
” . chr(10);

}

function PrintPediLit($pname) {
global $names;
echo ”

” . chr(10);
echo ”

” . $pname . “

” . chr(10);
echo ”

” . $names[‘1’] . “

” . chr(10);
echo ”

” . $names[‘3’] . “

” . chr(10);
echo ”

” . $names[‘7’] . “

” . chr(10);
echo ”

” . $names[’15’] . “

” . chr(10);
echo ”

” . $names[’16’] . “

” . chr(10);
echo ”

” . $names[‘8’] . “

” . chr(10);
echo ”

” . $names[’17’] . “

” . chr(10);
echo ”

” . $names[’18’] . “

” . chr(10);
echo ”

” . $names[‘4’] . “

” . chr(10);
echo ”

” . $names[‘9’] . “

” . chr(10);
echo ”

” . $names[’19’] . “

” . chr(10);
echo ”

” . $names[’20’] . “

” . chr(10);
echo ”

” . $names[’10’] . “

” . chr(10);
echo ”

” . $names[’21’] . “

” . chr(10);
echo ”

” . $names[’22’] . “

” . chr(10);
echo ”

” . $names[‘2’] . “

” . chr(10);
echo ”

” . $names[‘5’] . “

” . chr(10);
echo ”

” . $names[’11’] . “

” . chr(10);
echo ”

” . $names[’23’] . “

” . chr(10);
echo ”

” . $names[’24’] . “

” . chr(10);
echo ”

” . $names[’12’] . “

” . chr(10);
echo ”

” . $names[’25’] . “

” . chr(10);
echo ”

” . $names[’26’] . “

” . chr(10);
echo ”

” . $names[‘6’] . “

” . chr(10);
echo ”

” . $names[’13’] . “

” . chr(10);
echo ”

” . $names[’27’] . “

” . chr(10);
echo ”

” . $names[’28’] . “

” . chr(10);
echo ”

” . $names[’14’] . “

” . chr(10);
echo ”

” . $names[’29’] . “

” . chr(10);
echo ”

” . $names[’30’] . “

” . chr(10);
echo ”

” . chr(10);

}

[/insert_php]