50 || $storynum < 1) ? 10 : intval($storynum); $storynum = ceil($storynum / $pagecols) * $pagecols; $colwidth = ceil(100 / $pagecols); $numpages = ceil($allstories / $storynum); $pagenum = intval($pagenum); $pagenum = ($pagenum < 1) ? 1 : $pagenum; $pagenum = ($pagenum > $numpages) ? $numpages : $pagenum; $offset = ($pagenum-1) * $storynum ; $offset = ($offset < 0) ? 0 : $offset; $qry = "SELECT s.sid, s.informant, s.title, s.hometext, s.bodytext, s.comments, s.counter, s.notes, s.time, s.alanguage, s.acomm, s.aid, s.score, s.ratings, s.topic, t.topicname, t.topicimage, t.topictext, c.catid, c.title AS cattitle, a.url, a.email FROM ((${prefix}_stories AS s LEFT JOIN ${prefix}_stories_cat AS c ON s.catid = c.catid) LEFT JOIN ${prefix}_topics AS t ON s.topic = t.topicid) LEFT JOIN ${prefix}_authors AS a ON s.aid = a.aid WHERE " . $where . " ORDER BY s.time DESC, s.sid DESC LIMIT " . $offset . "," . $storynum . ";"; $result = sql_query($qry); $storiecount = 0; $topictext = ''; while ($stories[$storiecount] = sql_fetch_assoc($result)) { if (!empty($new_topic) && $storiecount == 0) { $topictext = $stories[$storiecount]["topictext"]; } $storiecount++; } if (empty($storiecount)) { $msg = "

" . _NOINFO4TOPIC . "

[ " . _GOTONEWSINDEX . " | " . _SELECTNEWTOPIC . " ]"; mxMessageScreen($msg); die(); } $pagetitle = _GOTONEWSINDEX; if (!empty($new_topic) && $topictext) { $pagetitle .= ', ' . $topictext; } if ($pagenum > 1) { $pagetitle .= ', ' . _NEWS_PAGE . ' ' . $pagenum; } include("header.php"); if (!empty($new_topic)) { OpenTable(); echo "" . $GLOBALS["sitename"] . ": " . $topictext . "

" . "

" . _SEARCHONTOPIC . ":   " . "" . "" . "" . "

" . "[ " . _GOTOHOME . " | " . _SELECTNEWTOPIC . " ]"; CloseTable(); echo "
"; } // End New Topic if (!empty($storiecount)) { $linkadd = (empty($new_topic)) ? "" : "&new_topic=" . $new_topic; if (empty($GLOBALS["home"])) { vkpShowPageLinks($numpages, $pagenum, $storynum, $allstories, $linkadd); } $i = 0; if ($pagecols > 1) { echo ""; } foreach($stories as $index => $story) { if (!is_array($story)) continue; $story = vkpGetStoryDetails($story); $i++; if ($pagecols > 1) { if ($i == 1) { echo ""; } echo ""; if ($i == $pagecols) { echo ""; $i = 0; } } } if ($pagecols > 1) { if ($i) { $colspan = $pagecols - $i; echo ""; } echo "

"; $story['column'] = $i; } else { $story['column'] = 1; } themeindex($story["aid"], $story["informant"], $story["datetime"], $story["title_formated"], $story["counter"], $story["topic"], $story["hometext"], $story["notes"], $story["morelink"], $story["topicname"], $story["topicimage"], $story["topictext"], $story); if ($pagecols > 1) { echo "

"; } echo "
"; vkpShowPageLinks($numpages, $pagenum, $storynum, $allstories, $linkadd); } include("footer.php"); } // ################################### function rate_article($sid, $score) { global $prefix, $sitename; list($sid, $score) = mxForceInteger($sid, $score); if ($score) { if ($score > 5) { $score = 5; } if ($score < 1) { $score = 1; } if (isset($_COOKIE['ratecookie'])) { $rcookie = base64_decode($_COOKIE['ratecookie']); $r_cookie = explode(":", $rcookie); } for ($i = 0; $i < sizeof($r_cookie); $i++) { if ($r_cookie[$i] == $sid) { $a = 1; } } if ($a == 1) { header("Location: modules.php?name=News&op=rate_complete&sid=$sid&rated=1"); } else { $result = sql_query("update ${prefix}_stories set score=score+$score, ratings=ratings+1 where sid=" . intval($sid)); $info = base64_encode("$rcookie$sid:"); mxSetCookie("ratecookie", $info, time() + 3600); header("Location: modules.php?name=News&op=rate_complete&sid=$sid"); } } else { include("header.php"); title("" . $GLOBALS["sitename"] . ": " . _ARTICLERATING); OpenTable(); echo "" . _DIDNTRATE . "

" . _GOBACK . ""; CloseTable(); include("footer.php"); } } if (empty($new_topic)) $new_topic = 0; if (empty($op)) $op = ""; switch ($op) { case "rate_article": if (empty($score)) $score = 0; rate_article((int)$sid, (int)$score); break; case "rate_complete": if (!isset($sid)) $sid = 0; if (empty($rated)) { mxRedirect("modules.php?name=News&file=article&sid=" . $sid, _THANKSVOTEARTICLE, 1); } elseif ($rated == 1) { mxRedirect("modules.php?name=News&file=article&sid=" . $sid, _ALREADYVOTEDARTICLE, 3); } break; default: theindex($new_topic); break; } ?>