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, $repos) { global $what; /*$repos=array(); $res=$db->query("SELECT * FROM repo WHERE active=1 ORDER BY ID"); if ($res) while ($repo = $res->fetchObject()) { $repos[$repo->main][$repo->sub]=$repo; }*/ if (substr($what,0,1)=='%') { $sql=sprintf("SELECT DISTINCT name FROM rpm WHERE SUBSTRING(name,1,1)='%s' ORDER BY name", substr($what,1,1)); } else { $sql=sprintf("SELECT DISTINCT name FROM acls WHERE owner='%s' ORDER BY name", $what); } //echo "

SQL=$sql

"; /*echo "\n"; echo ""; foreach($repos as $repomain) { foreach ($repomain as $repo) { printf ("", $repo->main); break; } } echo "\n";*/ $i=0; $res=$db->query($sql); if ($res) while ($desc = $res->fetchObject()) { $rpmname = $desc->name; $sql2="SELECT DISTINCT owner FROM acls WHERE name LIKE '$rpmname'"; $res2=$db->query($sql2); $dispowner=""; if ($res2) while ($owner= $res2->fetchObject()) { if ($dispowner) $dispowner .= "
"; $dispowner .= sprintf ("%s", $_SERVER["PHP_SELF"], $owner->owner, $owner->owner); } $sql3 = "SELECT * FROM rpm WHERE name LIKE '$rpmname'"; $res3=$db->query($sql3); $rpm = ($res3 ? $res3->fetchObject() : false); if ($rpm) { $url = $rpm->url; $des = htmlentities($rpm->summary); $rpms=array(); do { $rpms[$rpm->repo_main."-".$rpm->repo_sub]=$rpm; } while ($rpm = $res3->fetchObject()); printf ("\n\t\n\t\n", ($i%2 ? "odd" : "even"), $rpmname, $des, $rpmname, $dispowner); foreach($repos as $repomain) { $display=""; $class=""; foreach ($repomain as $repo) { if (isset($rpms[$repo->main."-".$repo->sub])) { $rpm=$rpms[$repo->main."-".$repo->sub]; $maxver = (isset($rpms["rawhide-"]) ? $rpms["rawhide-"]->ver : ""); 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); $class = ($rpm->ver == $maxver ? "check" : "attn"); } break; case "": $display .= sprintf("%s-%s
", $rpm->ver, $rpm->rel); break; case "updates": $display .= sprintf("%s-%s (updates)
", $rpm->ver, $rpm->rel); $class = ($rpm->ver == $maxver ? "check" : "attn"); break; case "testing": $display .= sprintf("%s-%s (testing)
", $rpm->ver, $rpm->rel); $class = ($rpm->ver == $maxver ? "info" : "attn"); break; } } // RPM exists } // sub repo if ($class && $maxver) { printf("\t\n", $class, $display); } else if ($display) { printf("\t\n", $display); } else { echo "\t\n"; } } // mainrepo echo "\n"; $i++; } } // each Line } ?> Packages in Fedora

You are here:

Filter packages
query($sql); if ($res && $row=$res->fetchObject()) { printf("

Repositories last updated %s.

", date("r", $row->stamp)); } ?>

Packages in Fedora

PackageOwner(s)%s
%s%s%s%s 
"; //echo "
"; print_r($rpms); echo "
"; } catch(PDOException $e) { ?>
Package Owner(s)

Choose a criteria from the filter menu

getMessage()); ?>