<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
	<head>
		<title>Packages in Fedora</title>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
		<link rel="stylesheet" type="text/css" media="print" href="http://docs.fedoraproject.org/css/print.css">
		<style type="text/css" media="screen">
			@import url("http://docs.fedoraproject.org/css/layout.css");
			@import url("http://docs.fedoraproject.org/css/content.css");
			@import url("http://docs.fedoraproject.org/css/docbook.css");
            
body {
    background-image:none; 
}
.error {
    background:url(http://fedoraproject.org/wikidata/kindofblue/img/icon-error.png) no-repeat left;
    padding-left: 21px;
}

.info {
    background:url(http://fedoraproject.org/wikidata/kindofblue/img/icon-info.png) no-repeat left;
    padding-left: 21px;
}

.attn {
    background:url(http://fedoraproject.org/wikidata/kindofblue/img/attention.png) no-repeat left;
    padding-left: 21px;
}

.check {
    background:url(http://fedoraproject.org/wikidata/kindofblue/img/checkmark.png) no-repeat left;
    padding-left: 21px;
}

.cpan {
    background:url(http://www.perl.com/favicon.ico) no-repeat left;
    padding-left: 18px;
}

.rt {
    background:url(/img/rt.png) no-repeat left;
    padding-left: 18px;
}

.bz {
    background:url(/img/bz.png) no-repeat left;
    padding-left: 18px;
}

<?php

require "config.inc.php";
if (!isset($_GET['rpm'])) {
   die("missing arg.");
}
$name = $_GET['rpm'];

?>
		</style>

		<meta name="MSSmartTagsPreventParsing" content="TRUE">
		<link rel="shortcut icon" href="http://docs.fedoraproject.org//images/favicon.ico">
		<link rel="icon" href="http://docs.fedoraproject.org//images/favicon.ico">
	</head>

	<body>
		<!-- header BEGIN -->
		<div id="fedora-header">
			<div id="fedora-header-logo">

			<a href="http://fedoraproject.org"><img src="http://docs.fedoraproject.org//images/header-fedora_logo01.png" alt="Fedora Project"></a>
			</div>

			<div id="fedora-header-items">
            <span class="fedora-header-search">
               <form action='zoom.php' method='get'>
               Package&nbsp;:&nbsp;
               <input type='text' name='rpm' size='20' />
               <input type="image" src='http://docs.fedoraproject.org/images/header-search.png' alt="Search" />
            </form></span>
			</div>

		</div>

		<div id="fedora-nav"></div>
			&nbsp;<img src='http://docs.fedoraproject.org/images/link-offsite-side.png' />
			<a href="./">Reports home</a>
			&nbsp;<img src='http://docs.fedoraproject.org/images/link-offsite-side.png' />
			Package detail
		<!-- header END -->
		
		<!-- leftside BEGIN -->
		<div id="fedora-side-left">
                </div>

		<!-- leftside END -->

		<!-- content BEGIN -->
        <div id="fedora-middle-one">
            <div class="fedora-corner-tr">&nbsp;</div>
            <div class="fedora-corner-tl">&nbsp;</div>
            <div id="fedora-content">

        <!-- document BEGIN -->

<?php
if (!$name) {
   echo "<h1>Enter a package name</h1>\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 "<h1>$name not found</h1>\n";
      } else {
         echo "<h1>Package: $name</h1>\n";
         echo "<table id='fedora-list-packages'>\n";
         echo "<tr><th colspan='2'>Upstream info</th></tr>\n"; 
         $i=0;
         
         if ($rpm->summary) {
            echo "<tr class='".($i%2 ? 'odd' : 'even')."'><td>"; $i++;
            echo "Summary</td><td><strong>". $rpm->summary . "</strong></td></tr>\n";
         } else if ($owner->summary) {
            echo "<tr class='".($i%2 ? 'odd' : 'even')."'><td>"; $i++;
            echo "Summary</td><td><strong>". $owner->summary . "</strong></td></tr>\n";
         }
         if ($rpm->url) {
            echo "<tr class='".($i%2 ? 'odd' : 'even')."'><td>"; $i++;
            echo "URL</td><td><strong><a href='".$rpm->url."'>". $rpm->url . "</a></strong></td></tr>\n";
         }
         if ($up && $up->type) {
            echo "<tr class='".($i%2 ? 'odd' : 'even')."'><td>"; $i++;
            echo "Type</td><td><strong>". $up->type . "</strong></td></tr>\n";
         }
         if ($up && $up->channel) {
            echo "<tr class='".($i%2 ? 'odd' : 'even')."'><td>"; $i++;
            echo "Channel</td><td><strong>". $up->channel . "</strong></td></tr>\n";
         }
         if ($up && $up->stable) {
            echo "<tr class='".($i%2 ? 'odd' : 'even')."'><td>"; $i++;
            echo "Stable version</td><td><strong>". $up->stable . "</strong></td></tr>\n";
         }
         if ($up && $up->unstable && $up->stable!=$up->unstable) {
            echo "<tr class='".($i%2 ? 'odd' : 'even')."'><td>"; $i++;
            echo "Unstable version</td><td><strong>". $up->unstable . "</strong>";
            if ($up->state) {
               echo " (". $up->state . ")\n";
            }
            echo "</td></tr>\n";
         }
         if ($owner && $owner->owner) {
            echo "<tr class='".($i%2 ? 'odd' : 'even')."'><td>"; $i++;
            echo "Owner</td><td><strong>". $owner->owner . "</strong>";
            if ($owner->cc) {
               echo " (". $owner->cc . ")\n";
            }
            echo "</td></tr>\n";
         }
         echo "<tr class='".($i%2 ? 'odd' : 'even')."'><td>ViewVC</td>"; $i++;
         echo "<td><a href='http://cvs.fedoraproject.org/viewvc/rpms/$name/'>http://cvs.fedoraproject.org/viewvc/rpms/$name/</a>";
         echo "</td></tr>\n";

         echo "</table>";
      
         echo "<br /><table id='fedora-list-packages'>\n";
         echo "<tr><th colspan='3'>Packages available in Fedora Repositories</th></tr>\n";
         $prev=false;
         do {
            echo "<tr class='".($i%2 ? 'odd' : 'even')."'>"; $i++;
            echo "<td><strong>".($rpm->repo_main==$prev ? "&nbsp;" : $prev=$rpm->repo_main)."</strong></td>";
            echo "<td>".$rpm->repo_sub."</td>";
            echo "<td>".($rpm->epoch ? $rpm->epoch.":" : "").$rpm->ver."-".$rpm->rel."</td>";
            echo "</tr>\n";
         } while ($rpm = $resrpm->fetchObject());
         echo "</table>";
      }
   }
   catch(PDOException $e) {
      printf("%s ERREUR : %s\n", date("r"),  $e->getMessage());
   }
}
?>


        <!-- document END -->
        </div>
            <div class="fedora-corner-br">&nbsp;</div>
            <div class="fedora-corner-bl">&nbsp;</div>
        </div>

		<!-- content END -->
		
		<!-- footer BEGIN -->

		<div id="fedora-footer">
			<br/>The Fedora Project is maintained and driven by the community and sponsored by Red Hat. 
			<br/><a href="http://fedoraproject.org/wiki/Legal">Legal</a> | <a href="http://fedoraproject.org/wiki/Legal/TrademarkGuidelines">Trademark Guidelines</a>
			<br>		
		</div>

		<!-- footer END -->
	</body>
</html>