home *** CD-ROM | disk | FTP | other *** search
/ PC World 2005 April / PCWorld_2005-04_cd.bin / akce / web / unitednuke / unitednuke.exe / html / blocks / block-Random_Headlines.php < prev    next >
PHP Script  |  2004-01-10  |  3KB  |  61 lines
  1. <?php
  2.  
  3. /************************************************************************/
  4. /* PHP-NUKE: Web Portal System                                          */
  5. /* ===========================                                          */
  6. /*                                                                      */
  7. /* Copyright (c) 2002 by Francisco Burzi                                */
  8. /* http://phpnuke.org                                                   */
  9. /*                                                                      */
  10. /* This program is free software. You can redistribute it and/or modify */
  11. /* it under the terms of the GNU General Public License as published by */
  12. /* the Free Software Foundation; either version 2 of the License.       */
  13. /************************************************************************/
  14.  
  15. if (eregi("block-Random_Headlines.php", $_SERVER['PHP_SELF'])) {
  16.     Header("Location: index.php");
  17.     die();
  18. }
  19.  
  20. global $prefix, $multilingual, $currentlang, $db, $tipath, $user, $cookie;
  21.  
  22. $r_options = "";
  23. if (isset($cookie[4])) { $r_options .= "&mode=$cookie[4]"; }
  24. if (isset($cookie[5])) { $r_options .= "&order=$cookie[5]"; }
  25. if (isset($cookie[6])) { $r_options .= "&thold=$cookie[6]"; }
  26.  
  27. if ($multilingual == 1) {
  28.     $querylang = "AND (alanguage='$currentlang' OR alanguage='')"; /* the OR is needed to display stories who are posted to ALL languages */
  29. } else {
  30.     $querylang = "";
  31. }
  32.  
  33. $numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_topics"));
  34. if ($numrows > 1) {
  35.     $result = $db->sql_query("SELECT topicid FROM ".$prefix."_topics");
  36.     while ($row = $db->sql_fetchrow($result)) {
  37.     $topicid = intval($row['topicid']);
  38.     $topic_array .= "$topicid-";
  39.     }
  40.     $r_topic = explode("-",$topic_array);
  41.     mt_srand((double)microtime()*1000000);
  42.     $numrows = $numrows-1;
  43.     $topic = mt_rand(0, $numrows);
  44.     $topic = $r_topic[$topic];
  45. } else {
  46.     $topic = 1;
  47. }
  48. $row2 = $db->sql_fetchrow($db->sql_query("SELECT topicimage, topictext FROM ".$prefix."_topics WHERE topicid='$topic'"));
  49. $topicimage = $row2['topicimage'];
  50. $topictext = $row2['topictext'];
  51. $content = "<br><center><a href=\"modules.php?name=News&new_topic=$topic\"><img src=\"$tipath$topicimage\" border=\"0\" alt=\"$topictext\" title=\"$topictext\"></a><br>[ <a href=\"modules.php?name=Search&topic=$topic\">$topictext</a> ]</center><br>";
  52. $content .= "<table border=\"0\" width=\"100%\">";
  53. $result3 = $db->sql_query("SELECT sid, title FROM ".$prefix."_stories WHERE topic='$topic' $querylang ORDER BY sid DESC LIMIT 0,9");
  54. while ($row3 = $db->sql_fetchrow($result3)) {
  55. $sid = intval($row3['sid']);
  56. $title = $row3['title'];
  57.     $content .= "<tr><td valign=\"top\"><strong><big>·</big></strong></td><td><a href=\"modules.php?name=News&file=article&sid=$sid$r_options\">$title</a></td></tr>";
  58. }
  59. $content .= "</table>";
  60.  
  61. ?>