<?php
// ------------------------------------------------------------------------- //
//                XOOPS - PHP Content Management System                      //
//                       <http://www.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.                                      //
//                                                                           //
//  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 //
// ------------------------------------------------------------------------- //
//                                                                           //
//                               "Spotlight"                                 //
//               http://linux.kuht.it  - http://www.kuht.it                  //
//                              spark@kuht.it                                //
//                                                                           //
//   Adaptation for XOOPS 2.0x by Herko (me at herkocoomans dot net) and     //
//                Dawilby (willemsen1 at chello dot nl)                      //
//---------------------------------------------------------------------------//
include_once(XOOPS_ROOT_PATH.'/class/xoopsstory.php');
include_once(XOOPS_ROOT_PATH.'/class/module.textsanitizer.php');
function b_head_kuht_show($options)
{
	global $xoopsDB, $xoopsConfig;
	$myts =& MyTextSanitizer::getInstance();
	$fhometext = "";
	$block = array();
	$block['title'] = _MB_KUHT_TITLE_SPOTLIGHT;
	$tdate = mktime(0,0,0,date("n"),date("j"),date("Y"));

	$block['lang_by']		= _MB_KUHT_BY;
	$block['lang_read']	= _MB_KUHT_READ;
	$block['lang_comments']	= _MB_KUHT_COMMENTS;
	$block['lang_write']	= _MB_KUHT_WRITE;
	$block['lang_othernews']= _MB_KUHT_OTHERNEWSTEXT;

	$var = $xoopsDB->query("SELECT news, auto, image, auto_image FROM ".$xoopsDB->prefix("spotlight")."",1,0);
	list ($number, $auto, $image, $auto_image) = $xoopsDB->fetchRow($var);
	if ($auto == 0) {
		// no auto selection
		$result = $xoopsDB->query("SELECT storyid, uid, title, hometext, comments, topicid FROM ".$xoopsDB->prefix("stories")." WHERE storyid=".$number." ",1,0);
	} else {
		// auto selection
		$result = $xoopsDB->query("SELECT storyid, uid, title, hometext, comments, topicid FROM ".$xoopsDB->prefix("stories")." WHERE published < ".time()." AND published > 0 AND (expired = 0 OR expired > ".time().") ORDER BY published DESC",1,0);
	}
	list ($fsid, $fautore, $ftitle, $fhometext, $fcomments, $ftopicid) = $xoopsDB->fetchRow($result);
	$result2 = $xoopsDB->query("SELECT uname, uid FROM ".$xoopsDB->prefix("users")." WHERE uid=".$fautore."",1,0);
	list ($fautorevero, $uidutente) = $xoopsDB->fetchRow($result2);

	if (!$fsid && !$ftitle) {
		$block['message'] = _MB_KUHT_NOTSELECT;
	} else {
		if ($auto_image == 0) {
			$block['image'] = $image;
		} else {
			$var_image = $xoopsDB->query("SELECT topicid FROM ".$xoopsDB->prefix("stories")." WHERE topicid=".$ftopicid."",1,0);
			list ($patt_image) = $xoopsDB->fetchRow($var_image);
			$block['url_display'] = $patt_image;

			$var_image2 = $xoopsDB->query("SELECT topic_imgurl FROM ".$xoopsDB->prefix("topics")." WHERE topic_id=".$patt_image."",1,0);
			list ($image_display) = $xoopsDB->fetchRow($var_image2);
			$block['image_display'] = $image_display;
		}
		if (!XOOPS_USE_MULTIBYTES) {
			if (strlen($ftitle) >= $options[0]) {
				$ftitle = substr($ftitle,0,($options[0] -1))."...";
			}
		}
		$block['title']		= $myts->makeTboxData4Show($ftitle);
		$block['uid']		= $myts->makeTboxData4Show($uidutente);
		$block['author']		= $myts->makeTboxData4Show($fautorevero);
		$block['hometext']	= $myts->makeTareaData4Show($fhometext);	// BB Codes
		$block['storyid']		= $myts->makeTboxData4Show($fsid);
		$block['comments']	= $myts->makeTboxData4Show($fcomments);
	}
	$nsql = "SELECT storyid, title, published, expired, counter FROM ".$xoopsDB->prefix("stories")." WHERE published < ".time()." AND published > 0 AND (expired = 0 OR expired > ".time().") AND storyid != ".$fsid." ORDER BY published DESC";
	$nresult = $xoopsDB->query($nsql,$options[2],0);
	while ( $myrow = $xoopsDB->fetchArray($nresult) ) {
		$news = array();
		$title = $myts->makeTboxData4Show($myrow["title"]);
		if ( !XOOPS_USE_MULTIBYTES ) {
			if (strlen($myrow['title']) >= $options[3]) {
				$title = $myts->makeTboxData4Show(substr($myrow['title'],0,($options[3] -1)))."...";
			}
		}
		$news['title'] = $title;
		$news['id'] = $myrow['storyid'];
		if ($options[1] == "published") {
			$news['hitsordate'] = formatTimestamp($myrow['published'],"s");
		} elseif ($options[1] == "counter") {
			$news['hitsordate'] = $myrow['counter'];
		}
		$block['stories'][] = $news;
	}
	if ($options[4] == 1) {
	// rb topic select form for news direct topic access
	$topic_options = '';
	$block['topicsel'] = '';
	$sql = "SELECT topic_id, topic_title FROM ".$xoopsDB->prefix("topics")." order by topic_title ASC ";
	if (!$r = $xoopsDB->query($sql)){
		exit();
	}
	if ($row = $xoopsDB->fetchArray($r)) {
		do {
		$id= $row['topic_id'];
		$title =$myts->makeTboxData4Show($row['topic_title']);
		if (!XOOPS_USE_MULTIBYTES ) {
			if (strlen($title) >= 20) {
				$title = substr($title,0,19)."...";
			}
		}
		$topic_options .= '<option value="'.$id.'">'.$title.'</option>';
	   }
	   while($row = $xoopsDB->fetchArray($r));
	}
	if ($topic_options <> '') {
		$block['topicsel'] = '<form action="'.XOOPS_URL.'/modules/news/index.php? method="post">';
		$block['topicsel'].= '<select name="storytopic" onchange="submit();">';
		$block['topicsel'].= '<option value="0" selected>'._MB_KUHT_CHOOSE.'</option>';
		$block['topicsel'].= $topic_options;
		$block['topicsel'].= '</select></form>';
	}
	// END rb topic select form for news direct topic access
	}
	return $block;
}

function b_head_kuht_edit($options)
{
	$form = _MB_KUHT_TITLECHARS.'&nbsp;<input type="text" name="options[]" value="'.$options[0].'" />&nbsp;'._MB_KUHT_TITLELENGTH.'&nbsp;<br />';
	$form.= '<b>'._MB_KUHT_OTHERNEWS.'</b><br />';
	$form.= _MB_KUHT_ORDER.'&nbsp;<select name="options[]">';
	$form.= '<option value="published"';
	if ($options[1] == "published") {
		$form .= ' selected="selected"';
	}
	$form.= '>'._MB_KUHT_DATE.'</option>';
	$form.= '<option value="counter"';
	if ($options[1] == "counter") {
		$form .= ' selected="selected"';
	}
	$form.= '>'._MB_KUHT_HITS.'</option>';
	$form.= '</select>';
	$form.= _MB_KUHT_DISP.'&nbsp;<input type="text" size="2" name="options[]" value="'.$options[2].'" />&nbsp;'._MB_KUHT_ARTCLS.'<br />';
	$form.= _MB_KUHT_CHARS.'&nbsp;<input type="text" size="2"name="options[]" value="'.$options[3].'" />&nbsp;'._MB_KUHT_LENGTH.'<br />';
	$form.= _MB_KUHT_TOPICS.'&nbsp;<input type="text" size="2" name="options[]" value="'.$options[4].'" />';
	return $form;
}
?>