query("SELECT * FROM repo WHERE active=1 ORDER BY ID");
if ($res) while ($repo = $res->fetchObject()) {
$repos[$repo->main][$repo->sub]=$repo;
}
// echo "
"; print_r($repos);echo "
";
foreach($repos as $repomain) {
foreach ($repomain as $repo) {
/*printf ("
%s
", $repo->main);*/
$repos[$repo->main][$repo->sub] = $repo;
break;
}
}
return $repos;
}
function Report ($db, $type, $repos) {
global $what;
$i=0;
$resup=$db->query("SELECT * FROM upstream WHERE type='$type' ORDER BY name");
if ($resup) while ($upstream = $resup->fetchObject()) {
$rpmname = $upstream->name;
$sql2="SELECT DISTINCT owner FROM acls WHERE name = '$rpmname'";
$res2=$db->query($sql2);
$owners=array();
if ($res2) while ($owner= $res2->fetchObject()) $owners[] = $owner->owner;
$sql = "SELECT * FROM rpm WHERE name = '$rpmname'";
$res=$db->query($sql);
$rpm = ($res ? $res->fetchObject() : false);
switch ($what) {
case '%fedora':
$display = ($rpm !== false);
break;
case '%stable':
$display = !empty($upstream->stable);
break;
case '%all':
$display = true;
break;
default: // owner
$display = (array_search($what, $owners) !== false);
break;
}
if ($display) {
if ($rpm) {
$dispname = "summary) . "\">$rpmname";
} else {
$dispname = $rpmname;
}
$rpms=array();
if ($rpm) do {
$rpms[$rpm->repo_main."-".$rpm->repo_sub]=$rpm;
} while ($rpm = $res->fetchObject());
$dispowner="";
foreach ($owners as $owner) {
if ($dispowner) $dispowner .= " ";
$dispowner .= sprintf ("%s", $_SERVER["PHP_SELF"], $owner, $owner);
}
printf ("
\n\t
%s %s
\n\t
%s
\n\t
%s%s
\n",
($i%2 ? "odd" : "even"), $dispname,
($upstream->channel != $upstream->type ? "channel: " . $upstream->channel : ""),
$dispowner,
($upstream->stable ? "".$upstream->stable." " : " "),
($upstream->unstable && (!$upstream->stable || $upstream->stable!=$upstream->unstable) ? $upstream->unstable." (".$upstream->state.")" : " "));
$verup = strtolower($upstream->stable ? $upstream->stable : $upstream->unstable);
foreach($repos as $repomain) {
$display="";
$class="";
foreach ($repomain as $repo) {
if (isset($rpms[$repo->main."-".$repo->sub])) {
$rpm=$rpms[$repo->main."-".$repo->sub];
$verpm=$rpm->ver;
if (preg_match("/\.((beta|RC)\d*)\./i", $rpm->rel, $res)) {
$verpm .= strtolower($res[1]);
}
switch ($repo->sub) {
case "base":
if (isset($rpms[$repo->main."-updates"])) {
$display .= sprintf("%s-%s ", $rpm->ver, $rpm->rel);
} else {
$display .= sprintf("%s-%s ", $rpm->ver, $rpm->rel);
}
if ($verup==$verpm) $class="check";
break;
case "":
$display .= sprintf("%s-%s ", $rpm->ver, $rpm->rel);
if ($verup==$verpm) $class="check";
break;
case "updates":
$display .= sprintf("%s-%s (updates) ", $rpm->ver, $rpm->rel);
if ($verup==$verpm) $class="check";
break;
case "testing":
$display .= sprintf("%s-%s (testing) ", $rpm->ver, $rpm->rel);
if ($verup==$verpm) $class="info";
break;
}
} // RPM exists
} // sub repo
if ($display && empty($class)) $class="attn";
if ($display) {
printf("\t
%s
\n", $class, $display);
} else {
echo "\t
\n";
}
} // mainrepo
echo "
\n";
$i++;
}
} // each $unstable
echo "
$i packages found
\n";
}
?>
<?php echo $type; ?> extensions in Fedora