svn: /pear/pearweb/trunk/ public_html/channels/index.php sql/channels.sql

clockwerx                                Sat, 09 Apr 2011 13:40:24 +0000

Revision: http://svn.php.net/viewvc?view=revision&revision=310087

Log:
Fixed SQL, Channels page lists channels from DB

Changed paths:
    U   pear/pearweb/trunk/public_html/channels/index.php
    U   pear/pearweb/trunk/sql/channels.sql

Modified: pear/pearweb/trunk/public_html/channels/index.php
===================================================================
--- pear/pearweb/trunk/public_html/channels/index.php	2011-04-09 13:35:17 UTC (rev 310086)
+++ pear/pearweb/trunk/public_html/channels/index.php	2011-04-09 13:40:24 UTC (rev 310087)
@@ -17,6 +17,10 @@
    +----------------------------------------------------------------------+
    $Id$
 */
+require_once 'pear-database-channel.php';
+
+$channels = channel::listActive();
+
 response_header("Channels");

 $tabs = array("List" => array("url" => "/channels/index.php",
@@ -39,6 +43,12 @@

 <h2>List of Sites</h2>

+<dl>
+<?php foreach ($channels as $channel) { ?>
+  <dt><a href="<?php print $channel['project_link']; ?>"><?php print $channel['project_label']; ?></a></dt>
+  <dl><kbd>$ pear channel-discover <?php print $channel['name']; ?></kbd></dl>
+<?php } ?>
+</dl>
 <ul>
   <li><a href="http://pear.11abacus.com/">11abacus</a></li>
   <li><a href="http://pear.agavi.org/">Agavi</a></li>

Modified: pear/pearweb/trunk/sql/channels.sql
===================================================================
--- pear/pearweb/trunk/sql/channels.sql	2011-04-09 13:35:17 UTC (rev 310086)
+++ pear/pearweb/trunk/sql/channels.sql	2011-04-09 13:40:24 UTC (rev 310087)
@@ -5,8 +5,10 @@
   project_link varchar(255) NOT NULL default '',
   contact_name varchar(255) NOT NULL default '',
   contact_email varchar(255) NOT NULL default '',
-  PRIMARY KEY  (name),
+  PRIMARY KEY  (name)
 );

 INSERT INTO channels VALUES ('pear.php.net', 1, 'PEAR', 'http://pear.php.net/', 'PEAR Webmaster', '[email protected]');

+INSERT INTO channels VALUES ('pecl.php.net', 1, 'PECL', 'http://pecl.php.net/', 'PEAR Webmaster', '[email protected]');
+