Codice: |
$content .= "<table border=\"0\" width=\"70%\">" |
Codice: |
<?php
/************************************************************************/
/* PHP-NUKE: Web Portal System */
/* =========================== */
/* */
/* Copyright (c) 2002 by Francisco Burzi */
/* http://phpnuke.org */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/
if (eregi("block-Random_Headlines.php", $_SERVER['PHP_SELF'])) {
Header("Location: index.html");
die();
}
global $prefix, $multilingual, $currentlang, $db, $tipath, $user, $cookie;
$r_options = "";
if (!isset($cookie[4])) { $r_options .= ".html"; }
if (isset($cookie[4])) { $r_options .= "-$cookie[4]"; }
if (isset($cookie[5])) { $r_options .= "-$cookie[5]"; }
if (isset($cookie[6])) { $r_options .= "-$cookie[6].html"; }
if ($multilingual == 1) {
$querylang = "AND (alanguage='$currentlang' OR alanguage='')"; /* the OR is needed to display stories who are posted to ALL languages */
} else {
$querylang = "";
}
$numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_topics"));
if ($numrows > 1) {
$sql = "SELECT topicid FROM ".$prefix."_topics";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$topicid = $row[topicid];
$topic_array .= "$topicid-";
}
$r_topic = explode("-",$topic_array);
mt_srand((double)microtime()*1000000);
$numrows = $numrows-1;
$topic = mt_rand(0, $numrows);
$topic = $r_topic[$topic];
} else {
$topic = 1;
}
$sql = "SELECT topicimage, topictext FROM ".$prefix."_topics WHERE topicid='$topic'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$topicimage = $row[topicimage];
$topictext = $row[topictext];
$content = "<br><center><a href=\"article-topic-$topic.html\"><img src=\"$tipath$topicimage\" border=\"0\" alt=\"$topictext\" title=\"$topictext\"></a><br>[ <a href=\"search-$topic.html\">$topictext</a> ]</center><br>";
$content .= "<table border=\"0\" width=\"70%\">";
$sql = "SELECT sid, title FROM ".$prefix."_stories WHERE topic='$topic' $querylang ORDER BY sid DESC LIMIT 0,9";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$content .= "<tr><td valign=\"top\"><strong><big>·</big></strong></td><td><a href=\"article$row[sid]$r_options\">$row[title]</a></td></tr>";
}
$content .= "</table>";
?> |