| <? |
| require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_foundation_ro.class.php"; |
| require_once "ProjectInfo.class.php"; |
| |
| $dbc = new DBConnectionFoundation(); |
| $dbh = $dbc->connect(); |
| |
| $sql = "SELECT * FROM Projects WHERE Level <> 0 AND UrlIndex NOT LIKE '' LIMIT 1"; |
| $rs = mysql_query($sql, $dbh); |
| echo mysql_error($dbh); |
| |
| $row = mysql_fetch_assoc($rs); |
| |
| echo "<html><body>\n"; |
| $p = new ProjectInfo($row['ProjectID'],$row['UrlIndex']); |
| $p->getProjectInfo(); |
| $name = $p->getName(); |
| echo "<b>Name:</b> $name<br>\n"; |
| $shortname = $p->getShortName(); |
| echo "<b>Short name:</b> $shortname<br>\n"; |
| $url = $p->getURL(); |
| echo "<b>URL:</b> $url<br>\n"; |
| $summary = $p->getSummary(); |
| echo "<b>Summary:</b><br>\n"; |
| echo "$summary<br>\n"; |
| $description = $p->getDescription(); |
| echo "<b>Description:</b><br>\n"; |
| echo "$description<br>\n"; |
| $projectiplog = $p->getProjectIPLog(); |
| echo "<b>Project IP Log:</b> $projectiplog<br>\n"; |
| $mailinglists = $p->getMailingLists(); |
| echo "<b>Mailing Lists:</b><br>\n"; |
| print_r($mailinglists); |
| echo "<br>\n"; |
| $newsgroup = $p->getNewsgroup(); |
| echo "<b>Newsgroup:</b> $newsgroup<br>\n"; |
| $bugzilla = $p->getBugzilla(); |
| echo "<b>Bugzilla:</b> $bugzilla<br>\n"; |
| $blog = $p->getBlog(); |
| echo "<b>Blog:</b> $blog<br>\n"; |
| $cvs = $p->getCVS(); |
| echo "<b>CVS:</b> $cvs<br>\n"; |
| echo "</body></html>\n"; |
| |
| $dbc->disconnect(); |
| $dbh = null; |
| $dbc = null; |
| |
| ?> |
