Enter a package name\n";
} else {
try {
$db = new PDO ("mysql:dbname=" . MYBASE . ";host=" . MYHOST, MYUSER, MYPASS);
$sql = "SELECT rpm.*
FROM rpm
INNER JOIN repo ON (repo.main=rpm.repo_main AND repo.sub=rpm.repo_sub)
WHERE rpm.name='$name'
ORDER BY repo.id DESC";
$resrpm = $db->query($sql);
$rpm = ($resrpm ? $resrpm->fetchObject() : false);
$sql = "SELECT * FROM upstream WHERE name = '$name'";
$resup=$db->query($sql);
$up = ($resup ? $resup->fetchObject() : false);
$sql = "SELECT * FROM acls WHERE name = '$name'";
$resown=$db->query($sql);
$owner = ($resown ? $resown->fetchObject() : false);
if (!$rpm) {
echo "
$name not found
\n";
} else {
echo "
Package: $name
\n";
echo "
\n";
echo "Upstream info\n";
$i=0;
if ($rpm->summary) {
echo "| "; $i++;
echo "Summary: | ". $rpm->summary . " |
|---|
\n";
} else if ($owner->summary) {
echo "| "; $i++;
echo "Summary: | ". $owner->summary . " |
|---|
\n";
}
if ($rpm->url) {
echo "| "; $i++;
echo "URL: | ". $rpm->url . " |
|---|
\n";
}
if ($up && $up->type) {
echo "| "; $i++;
echo "Type: | ". $up->type . " |
|---|
\n";
}
if ($up && $up->channel) {
echo "| "; $i++;
echo "Channel: | ". $up->channel . " |
|---|
\n";
}
if ($up && $up->stable) {
echo "| "; $i++;
echo "Stable version: | ". $up->stable . " |
|---|
\n";
}
if ($up && $up->unstable && $up->stable!=$up->unstable) {
echo "| "; $i++;
echo "Unstable version: | ". $up->unstable . "";
if ($up->state) {
echo " (". $up->state . ")\n";
}
echo " |
|---|
\n";
}
if ($owner && $owner->owner) {
echo "| "; $i++;
echo "Owner: | ". $owner->owner . "";
if ($owner->cc) {
echo " (". $owner->cc . ")\n";
}
echo " |
|---|
\n";
}
echo "| ViewVC: | "; $i++;
echo "http://cvs.fedoraproject.org/viewvc/rpms/$name/";
echo " |
|---|
\n";
echo "
";
echo "
\n";
echo "Packages available in Fedora Repositories\n";
$prev=false;
do {
echo ""; $i++;
echo "| ".($rpm->repo_main==$prev ? " " : $prev=$rpm->repo_main)." | ";
echo "".$rpm->repo_sub." | ";
echo "".($rpm->epoch ? $rpm->epoch.":" : "").$rpm->ver."-".$rpm->rel." | ";
echo "
\n";
} while ($rpm = $resrpm->fetchObject());
echo "
";
}
}
catch(PDOException $e) {
printf("%s ERREUR : %s\n", date("r"), $e->getMessage());
}
}
?>