d7/d02/pda_8php_source.html

 <?php

 /*

  You may not change or alter any portion of this comment or credits

  of supporting developers from this source code or any supporting source code

  which is considered copyrighted (c) material of the original comment or credit authors.


  This program is distributed in the hope that it will be useful,

  but WITHOUT ANY WARRANTY; without even the implied warranty of

  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

 */


 include __DIR__ . DIRECTORY_SEPARATOR . 'mainfile.php';

 $xoops_url = \XoopsBaseConfig::get('url');


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

 echo "<html><head><title>" . htmlspecialchars($xoops->getConfig('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($xoops->getConfig('sitename'), ENT_QUOTES) . "' border='0' /><br />";

     echo "<h2>" . htmlspecialchars($xoops->getConfig('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>";

$result
$result
Definition: pda.php:33

$xoops_url
$xoops_url
Definition: pda.php:23

DIRECTORY_SEPARATOR
defined('DS') or define('DS' DIRECTORY_SEPARATOR
Definition: common.php:41

$xoops
$xoops
Definition: admin.php:25

XoopsBaseConfig\get
static get($name)
Definition: XoopsBaseConfig.php:117

$xoopsDB
global $xoopsDB
Definition: common.php:36

include

$sql
$sql
Definition: pda.php:32