home *** CD-ROM | disk | FTP | other *** search
/ Cricao de Sites - 650 Layouts Prontos / WebMasters.iso / CMS / xoops-2.0.18.1.exe / xoops-2.0.18.1 / htdocs / pda.php < prev    next >
Encoding:
PHP Script  |  2005-11-03  |  2.9 KB  |  56 lines
  1. <?php
  2. // $Id: pda.php 2 2005-11-02 18:23:29Z skalpa $
  3. //  ------------------------------------------------------------------------ //
  4. //                XOOPS - PHP Content Management System                      //
  5. //                    Copyright (c) 2000 XOOPS.org                           //
  6. //                       <http://www.xoops.org/>                             //
  7. //  ------------------------------------------------------------------------ //
  8. //  This program is free software; you can redistribute it and/or modify     //
  9. //  it under the terms of the GNU General Public License as published by     //
  10. //  the Free Software Foundation; either version 2 of the License, or        //
  11. //  (at your option) any later version.                                      //
  12. //                                                                           //
  13. //  You may not change or alter any portion of this comment or credits       //
  14. //  of supporting developers from this source code or any supporting         //
  15. //  source code which is considered copyrighted (c) material of the          //
  16. //  original comment or credit authors.                                      //
  17. //                                                                           //
  18. //  This program is distributed in the hope that it will be useful,          //
  19. //  but WITHOUT ANY WARRANTY; without even the implied warranty of           //
  20. //  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the            //
  21. //  GNU General Public License for more details.                             //
  22. //                                                                           //
  23. //  You should have received a copy of the GNU General Public License        //
  24. //  along with this program; if not, write to the Free Software              //
  25. //  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307 USA //
  26. //  ------------------------------------------------------------------------ //
  27.  
  28. include "mainfile.php";
  29. header("Content-Type: text/html");
  30.  
  31. echo "<html><head><title>". htmlspecialchars($xoopsConfig['sitename'])."</title>
  32.       <meta name='HandheldFriendly' content='True' />
  33.       <meta name='PalmComputingPlatform' content='True' />
  34.       </head>
  35.       <body>";
  36.  
  37. $sql = "SELECT storyid, title FROM ".$xoopsDB->prefix("stories")." WHERE published>0 AND published<".time()." ORDER BY published DESC";
  38.  
  39. $result = $xoopsDB->query($sql,10,0);
  40.  
  41. if (!$result) {
  42.     echo "An error occured";
  43. } else {
  44.     echo "<img src='images/logo.gif' alt='".htmlspecialchars($xoopsConfig['sitename'], ENT_QUOTES)."' border='0' /><br />";
  45.     echo "<h2>".htmlspecialchars($xoopsConfig['slogan'])."</h2>";
  46.     echo "<div>";
  47.     while (list($storyid, $title) = $xoopsDB->fetchRow($result)) {
  48.         echo "<a href='".XOOPS_URL."/modules/news/print.php?storyid=$storyid'>".htmlspecialchars($title)."</a><br />";
  49.  
  50.     }
  51.     echo "</div>";
  52. }
  53.  
  54. echo "</body></html>";
  55.  
  56. ?>