Here is the php-file (kuht_head.php) I'm talking about. Perhaps there is a clever
connaisseur around who sees these things directly.
<?php
// ------------------------------------------------------------------------- //
// XOOPS - PHP Content Management System //
// <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. //
// //
// 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 at kuht dot 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->xoopsCodeDecode($fhometext); // BB Codes
$block['hometext'] = $myts->nl2Br($block['hometext']);
$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.' <input type="text" name="options[]" value="'.$options[0].'" /> '._MB_KUHT_TITLELENGTH.' <br />';
$form.= '<b>'._MB_KUHT_OTHERNEWS.'</b><br />';
$form.= _MB_KUHT_ORDER.' <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.' <input type="text" size="2" name="options[]" value="'.$options[2].'" /> '._MB_KUHT_ARTCLS.'<br />';
$form.= _MB_KUHT_CHARS.' <input type="text" size="2"name="options[]" value="'.$options[3].'" /> '._MB_KUHT_LENGTH.'<br />';
$form.= _MB_KUHT_TOPICS.' <input type="text" size="2" name="options[]" value="'.$options[4].'" />';
return $form;
}
?>
