#include <db.style>
# Some useful definitions for Infodrom Linx
#

<define-tag linxtop whitespace=delete>
<div style="padding-top: 5px;"></div>
<a href="<root_prefix>linx/"><img src="<root_prefix>gifs/linx.gif" border=0 width=228 height=55 alt="Infodrom Linx"></a><p>
</define-tag>

<define-tag linxbot whitespace=delete>
<div align="right"><img src="<root_prefix>gifs/powered_by_linux.gif" alt="Powered by Linux"></div>
</define-tag>

<define-tag linxcolh>00c8ff</define-tag>
<define-tag linxcold>e6e8fa</define-tag>
<define-tag linxcoln>ffffff</define-tag>

<define-tag recent>10</define-tag>

<define-tag linx>
<?
  $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
               or die("Unable to connect to SQL server");

  $sth = pg_exec ($dbh, "%0");

  $category = "";
  if (pg_NumRows ($sth) > 0) {
    echo '<div class="linx">'."\n";

    for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
      $row = pg_fetch_array ($sth, $nr);

      if ($category != $row['category']) {
        printf ('<div class="category"><strong><a href="lookup.php?category=%s">%s</a></strong></div>'."\n",
	       urlencode($row['category']), $row['category']);
        $category = $row['category'];
	$linx = 0;
      }
      printf ('<div class="link%d"><a href="%s">%s</a></div>'."\n",
	     $linx, $row['url'], $row['subject']);
      $linx = (int)!$linx;
    }
    echo "</div>\n";
  }
?>
</define-tag>