<?php
// $Id: index.php,v 1.15 2004/05/25 10:53:08 mithyt2 Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <https://xoops.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, or //
// (at your option) any later version. //
// //
// 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. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
include '../../mainfile.php';
include_once XOOPS_ROOT_PATH.'/modules/AMS/class/class.newsstory.php';
if (isset($_GET['storytopic'])) {
$xoopsOption['storytopic'] = intval($_GET['storytopic']);
} else {
$xoopsOption['storytopic'] = 0;
}
if ( isset($_GET['storynum']) ) {
$xoopsOption['storynum'] = intval($_GET['storynum']);
if ($xoopsOption['storynum'] > $xoopsModuleConfig['max_items']) {
$xoopsOption['storynum'] = $xoopsModuleConfig['max_items'];
}
} elseif ($xoopsOption['storytopic'] > 0) {
$xoopsOption['storynum'] = $xoopsModuleConfig['storyhome_topic'];
}
else {
$xoopsOption['storynum'] = $xoopsModuleConfig['storyhome'];
}
if ( isset($_GET['start']) ) {
$start = intval($_GET['start']);
} else {
$start = 0;
}
if (empty($xoopsModuleConfig['newsdisplay']) || $xoopsModuleConfig['newsdisplay'] == 'Classic' || $xoopsOption['storytopic'] > 0) {
$showclassic = 1;
}
else {
$showclassic = 0;
}
$myts =& MyTextSanitizer::getInstance();
$pagetitle = $myts->makeTboxData4Show($xoopsModule->name());
$column_count = $xoopsModuleConfig['columnmode'];
if ($showclassic) {
$xoopsOption['template_main'] = 'ams_index.html';
}
else {
$xoopsOption['template_main'] = 'ams_by_topic.html';
}
include XOOPS_ROOT_PATH.'/header.php';
$xoopsTpl->assign('columnwidth', intval(1/$column_count*100));
if ($xoopsModuleConfig['displaynav'] == 1 ) {
$xoopsTpl->assign('displaynav', true);
$xt = new AmsTopic($xoopsDB->prefix('ams_topics'));
$allTopics = $xt->getAllTopics(true);
include_once(XOOPS_ROOT_PATH."/class/tree.php");
include_once(XOOPS_ROOT_PATH."/class/xoopsformloader.php");
$topic_tree = new XoopsObjectTree($allTopics, 'topic_id', 'topic_pid');
$topic_select_code = $topic_tree->makeSelBox('storytopic', 'topic_title', '-', $xoopsOption['storytopic'], true);
$topic_form = new XoopsThemeForm('', "topic_form", "index.php", "get");
$topic_form->addElement(new XoopsFormLabel('', $topic_select_code));
// Make number options
$i = 1;
while ($i <= $xoopsModuleConfig['max_items']) {
$options[$i] = $i;
if ($i == 1) {
$i = 5;
}
else {
$i = $i + 5;
}
}
$storynum_select = new XoopsFormSelect('', 'storynum', $xoopsOption['storynum']);
$storynum_select->addOptionArray($options);
$submit_btn = new XoopsFormButton('', 'submit', _GO, 'submit');
$topic_form->addElement($storynum_select);
$topic_form->addElement($submit_btn);
$topic_form->assign($xoopsTpl);
}
else {
$xoopsTpl->assign('displaynav', false);
}
if ($showclassic) {
$ihome = $xoopsOption['storytopic'] > 0 ? 1 : 0;
$sarray = AmsStory::getAllPublished($xoopsOption['storynum'], $start, $xoopsModuleConfig['restrictindex'], $xoopsOption['storytopic'], $ihome);
$scount = count($sarray);
$xoopsTpl->assign('story_count', $scount);
if ($scount > 0) {
$uids = array();
foreach ($sarray as $storyid => $thisstory) {
$uids[$thisstory->uid()] = $thisstory->uid();
}
$member_handler =& xoops_gethandler('member');
$user_arr = $member_handler->getUsers(new Criteria('uid', "(".implode(',', array_keys($uids)).")", 'IN') , true);
foreach ($sarray as $storyid => $thisstory) {
$stories[] = $thisstory->toArray(false, false, 0, $user_arr);
}
$xoopsTpl->assign('stories', $stories);
}
else {
$xoopsTpl->assign('stories', array());
}
$xoopsTpl->assign('columns', $column_count);
$totalcount = AmsStory::countPublishedByTopic($xoopsOption['storytopic'], $xoopsModuleConfig['restrictindex']);
if ( $totalcount > $scount ) {
include_once XOOPS_ROOT_PATH.'/class/pagenav.php';
$pagenav = new XoopsPageNav($totalcount, $xoopsOption['storynum'], $start, 'start', 'storytopic='.$xoopsOption['storytopic']);
$xoopsTpl->assign('pagenav', $pagenav->renderNav());
}
else {
$xoopsTpl->assign('pagenav', '');
}
if($xoopsOption['storytopic'] > 0)
{
if (!isset($xt)) {
$xt = new AmsTopic($xoopsDB->prefix('ams_topics'));
}
$xt->getTopic($xoopsOption['storytopic']);
$pagetitle .= ' - ' . $xt->topic_title();
$xoopsTpl->assign('breadcrumb', $xt->getTopicPath());
}
else {
$xoopsTpl->assign('breadcrumb', '');
}
}
else {
include_once(XOOPS_ROOT_PATH."/class/tree.php");
$xt = new AmsTopic($xoopsDB -> prefix("ams_topics"));
$allTopics = $xt->getAllTopics($xoopsModuleConfig['restrictindex']);
$topic_obj_tree = new XoopsObjectTree($allTopics, 'topic_id', 'topic_pid');
$alltopics = $topic_obj_tree->getFirstChild(0);
$article_counts = AmsStory::countPublishedOrderedByTopic();
$smarty_topics = array();
foreach (array_keys($alltopics) as $i) {
$allstories[$i] = AmsStory::getAllPublished($xoopsOption['storynum'], 0, false, $i, 0);
if (count($allstories[$i]) > 0) {
foreach ($allstories[$i] as $thisstory) {
$uids[$thisstory->uid()] = $thisstory->uid();
}
}
if (!isset($article_counts[$i])) {
$article_counts[$i] = 0;
}
}
if (count($uids) > 0) {
$member_handler =& xoops_gethandler('member');
$user_arr = $member_handler->getUsers(new Criteria('uid', "(".implode(',', array_keys($uids)).")", 'IN') , true);
foreach ($alltopics as $topicid => $topic) {
$topicstories = array();
foreach ($allstories[$topicid] as $thisstory) {
$topicstories[] = $thisstory->toArray(false, false, 0, $user_arr);
}
$subcount = 0;
$subs = array();
//$key = findKey($smarty_topics, $topicstories[0]['posttimestamp']);
$subtopics = $topic_obj_tree->getFirstChild($topicid);
$subcount = count($subtopics);
foreach (array_keys($subtopics) as $i) {
$subs[$i] = array('id' => $i, 'title' => $subtopics[$i]->topic_title(), 'imageurl' => $subtopics[$i]->topic_imgurl());
}
$smarty_topics[] = array('title' => $topic->topic_title(), 'stories' => $topicstories, 'id' => $topicid, 'subtopics' => $subs, 'articlecount' => $article_counts[$topicid], 'subtopiccount' => $subcount);
unset($subs);
}
}
//krsort($smarty_topics);
$xoopsTpl->assign('topics', $smarty_topics);
$xoopsTpl->assign('columns', $column_count);
$xoopsTpl->assign('breadcrumb', '');
}
if (XOOPS_COMMENT_APPROVENONE != $xoopsModuleConfig['com_rule']) {
$showcomments = 1;
}
else {
$showcomments = 0;
}
$xoopsTpl->assign('showcomments', $showcomments);
$xoopsTpl->assign('xoops_pagetitle', $pagetitle);
$xoopsTpl->assign('lang_go', _GO);
$xoopsTpl->assign('lang_on', _ON);
$xoopsTpl->assign('lang_printerpage', _AMS_NW_PRINTERFRIENDLY);
$xoopsTpl->assign('lang_sendstory', _AMS_NW_SENDSTORY);
$xoopsTpl->assign('lang_postedby', _POSTEDBY);
$xoopsTpl->assign('lang_reads', _READS);
$xoopsTpl->assign('lang_morereleases', _AMS_NW_MORERELEASES);
if ($xoopsOption['storytopic'] > 0) {
$topic = new AmsTopic($xoopsDB->prefix('ams_topics'), $xoopsOption['storytopic']);
$xoopsTpl->assign('topicbanner', $myts->displayTarea($topic->getBanner(), 1));
}
include_once XOOPS_ROOT_PATH.'/footer.php';
function findKey($array, $suggested_key) {
if (isset($array[$suggested_key])) {
return findKey($array, $suggested_key +1 );
}
return $suggested_key;
}
?>
include_once XOOPS_ROOT_PATH."/class/xoopsstory.php";
include_once XOOPS_ROOT_PATH."/modules/AMS/class/class.newstopic.php";
include_once XOOPS_ROOT_PATH.'/include/comment_constants.php';
class AmsStory extends XoopsStory
{
var $newstopic; // XoopsTopic object
var $change;
var $version;
var $revision;
var $revisionminor;
var $current;
var $texttable;
var $ratings; //individual ratings
var $rating; //average rating
var $updated; //Last update
var $_errors=array(); //errors encountered
var $isNew = false;
var $versionConflict = false;
var $banner;
var $VersionNo;
var $audienceid;
var $audience;
var $audiencetable;
var $_hasVersions = -1;
var $uname = "";
function AmsStory($storyid=-1, $getRating = false)
{
$this->db =& Database::getInstance();
$this->table = $this->db->prefix("ams_article");
$this->texttable = $this->db->prefix("ams_text");
$this->topicstable = $this->db->prefix("ams_topics");
$this->audiencetable = $this->db->prefix("ams_audience");
if (is_array($storyid)) {
$this->makeStory($storyid);
$this->newstopic = $this->topic();
} elseif($storyid != -1) {
$this->getStory(intval($storyid));
$this->newstopic = $this->topic(true);
if ($getRating != false) {
$this->getRatings();
}
}
else {
$this->isNew = true;
}
}
function topic($single_topic = false)
{
if (!$this->newstopic) {
if (false == $single_topic) {
$topics = AmsTopic::getAllTopics();
$this->newstopic = $topics[$this->topicid()];
}
else {
$this->newstopic = new AmsTopic($this->topicstable, $this->topicid());
}
}
return $this->newstopic;
}
function getStory($storyid)
{
$sql = "SELECT * FROM ".$this->table." n, ".$this->texttable." t, ".$this->audiencetable." a WHERE n.storyid=t.storyid AND n.audienceid=a.audienceid AND t.current=1 AND n.storyid=".$storyid."";
$array = $this->db->fetchArray($this->db->query($sql));
$this->makeStory($array);
}
function hometext($format="Show")
{
$myts =& MyTextSanitizer::getInstance();
$html = 1;
$smiley = 1;
$xcodes = 1;
if ( $this->nohtml() ) {
$html = 0;
}
if ( $this->nosmiley() ) {
$smiley = 0;
}
switch ( $format ) {
case "Show":
$hometext = $myts->displayTarea($this->hometext,$html,$smiley,$xcodes);
break;
case "Edit":
$hometext = $myts->htmlSpecialChars($this->hometext);
break;
case "Preview":
$hometext = $myts->previewTarea($this->hometext,$html,$smiley,$xcodes);
break;
case "InForm":
$hometext = $myts->htmlSpecialChars( $myts->stripSlashesGPC($this->hometext));
break;
case "N":
$hometext = stripslashes($this->hometext);
break;
}
return $hometext;
}
function bodytext($format="Show")
{
$myts =& MyTextSanitizer::getInstance();
$html = 1;
$smiley = 1;
$xcodes = 1;
if ( $this->nohtml() ) {
$html = 0;
}
if ( $this->nosmiley() ) {
$smiley = 0;
}
switch ( $format ) {
case "Show":
$bodytext = $myts->displayTarea($this->bodytext,$html,$smiley,$xcodes);
break;
case "Edit":
$bodytext = $myts->htmlSpecialChars($this->bodytext);
break;
case "Preview":
$bodytext = $myts->previewTarea($this->bodytext,$html,$smiley, $xcodes);
break;
case "InForm":
$bodytext = $myts->htmlSpecialChars($myts->stripSlashesGPC($this->bodytext));
break;
case "N":
$bodytext = stripslashes($this->bodytext);
break;
}
return $bodytext;
}
function getAllPublished($limit=0, $start=0, $checkRight = false, $topic=0, $ihome=0, $asobject=true, $order = 'published', $ids = false)
{
$db =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$ret = array();
$sql = "SELECT * FROM ".$db->prefix("ams_article")." n, ".$db->prefix("ams_text")." t, ".$db->prefix("ams_audience")." a WHERE t.storyid=n.storyid AND n.audienceid=a.audienceid AND published > 0 AND published <= ".time()." AND (expired = 0 OR expired > ".time().")";
if ( $topic != 0 ) {
if (!is_array($topic)) {
$sql .= " AND topicid=".intval($topic)." AND (ihome=1 OR ihome=0)";
}
else {
$sql .= " AND topicid IN (".implode(',', $topic).")";
}
} else {
if ($checkRight) {
global $xoopsUser, $xoopsModule;
if (!isset($xoopsModule) || $xoopsModule->getVar('dirname') != "AMS") {
$module_handler =& xoops_gethandler('module');
$newsModule =& $module_handler->getByDirname('AMS');
}
else {
$newsModule =& $xoopsModule;
}
$groups = $xoopsUser ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
$gperm_handler =& xoops_gethandler('groupperm');
$topics = $gperm_handler->getItemIds('ams_view', $groups, $newsModule->getVar('mid'));
$topics = implode(',', $topics);
$sql .= " AND topicid IN (".$topics.")";
}
if ( $ihome == 0 ) {
$sql .= " AND ihome=0";
}
}
if ($ids != false) {
$sql .= " AND n.storyid NOT IN (".implode(',', $ids).")";
}
$sql .= " AND t.current=1";
$sql .= " ORDER BY $order DESC";
$result = $db->query($sql,intval($limit),intval($start));
while ( $myrow = $db->fetchArray($result) ) {
if ( $asobject ) {
$ret[] = new AmsStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->makeTboxData4Show($myrow['title']);
}
}
return $ret;
}
include "langcheck.php";
all you have to do is query the db and hold the content in a variable without sanitising it
| Stats | |
| Goal: | $100.00 |
| Due Date: | Apr 30 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $100.00 |
 |
|
