d7/d02/pda_8php_source.html

<?php

include dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mainfile.php';


header("Content-Type: text/html");

echo "<html><head><title>" . htmlspecialchars($xoopsConfig['sitename']) . "</title>

      <meta name='HandheldFriendly' content='True' />

      <meta name='PalmComputingPlatform' content='True' />

      </head>

      <body>";


$sql = "SELECT storyid, title FROM " . $xoopsDB->prefix("stories") . " WHERE published>0 AND published<" . time() . " ORDER BY published DESC";

$result = $xoopsDB->query($sql, 10, 0);

//TODO Remove this hardcoded string

if (!$result) {

    echo "An error occured";

} else {

    echo "<img src='images/logo.gif' alt='" . htmlspecialchars($xoopsConfig['sitename'], ENT_QUOTES) . "' border='0' /><br />";

    echo "<h2>" . htmlspecialchars($xoopsConfig['slogan']) . "</h2>";

    echo "<div>";

    while (list ($storyid, $title) = $xoopsDB->fetchRow($result)) {

        echo "<a href='" . XOOPS_URL . "/modules/news/print.php?storyid=$storyid'>" . htmlspecialchars($title) . "</a><br />";

    }

    echo "</div>";

}

echo "</body></html>";


?>