Возник вопрос, что делать с модулями Most Reviews Module, Latest Reviews Module? Их уже использовать нельзя?
В их первоначальном виде конечно нельзя, ведь они вытягивают данные совсем из других таблиц базы.
Можно попробовать перенацелить запрос на JComments, там в принципе ключевые поля полностью совместимы.
Если идти таким путём, то вот что у меня, например, получилось с файлом mod_sobi2latestreviewed.php:
<?php
/**
* @version $Id: mod_sobi2latestreviewed.php 4848 2009-01-24 20:04:45Z Sigrid Suski $
* @package: Sigsiu Online Business Index 2 Latest Reviews Module
* ===================================================
* @author
* Name: Sigrid & Radek Suski, Sigsiu.NET
* Email: sobi@sigsiu.net
* Url: http://www.sigsiu.net
* ===================================================
* @copyright Copyright (C) 2007-2009 Sigsiu.NET (http://www.sigsiu.net). All rights reserved.
* @license see http://www.gnu.org/copyleft/gpl.html GNU/GPL.
* SOBI2 Latest Reviews Module 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.
*/
(defined( '_VALID_MOS' ) || defined( '_JEXEC' ) ) || ( trigger_error( 'Restricted access', E_USER_ERROR ) && exit() );
defined( "DS" )
|| define( "DS",DIRECTORY_SEPARATOR);
$add =
defined( 'JPATH_SITE' )? DS.'mod_sobi2latestreviewed' : null;
defined( '_SOBI_CMSROOT' ) || define( '_SOBI_CMSROOT', str_replace( DS.'modules'.$add, null, dirname( __FILE__ ) ) );
class_exists( 'sobi2Config' ) || require_once( _SOBI_CMSROOT.DS.'components'.DS.'com_sobi2'.DS.'config.class.php' );
if (!function_exists('sobi2cutString')) {
function sobi2cutString($text, $max, $encoding) {
if ($max == 0)
return $text;
if ((function_exists("mb_strlen")) && (substr($encoding,0,3) == "UTF")) {
$len = mb_strlen($text, $encoding);
}
else
$len = strlen($text);
if ($len > $max) {
if ((function_exists("mb_substr")) && (substr($encoding,0,3) == "UTF")) {
$text = mb_substr($text, 0, $max, $encoding);
}
else
$text = substr($text, 0, $max);
$text = $text."...";
}
return $text;
}
}
if (!function_exists('sobi2TransformTemplate')) {
function sobi2TransformTemplate($revTemplate, $icon, $image, $e, $title, $text, $author) {
static $placeHolder = array();
$placeHolderReplacement = array();
$placeHolder[] = "{titlelink}";
$placeHolderReplacement[] = $e;
$placeHolder[] = "{iconlink}";
$placeHolderReplacement[] = $icon;
$placeHolder[] = "{imagelink}";
$placeHolderReplacement[] = $image;
$placeHolder[] = "{title}";
$placeHolderReplacement[] = $title;
$placeHolder[] = "{text}";
$placeHolderReplacement[] = $text;
$placeHolder[] = "{author}";
$placeHolderReplacement[] = $author;
$revTemplate = str_replace($placeHolder, $placeHolderReplacement, $revTemplate);
return $revTemplate;
}
}
//error_reporting(E_ALL);
//ini_set("display_errors","on");
//Get the parameters
$class = $params->get('moduleclass_sfx');
$limit = $params->get('count',5);
$table = $params->get('moduletable', 0); //only J1.0
$entryicon = $params->get('entryicon',0);
$entryimage = $params->get('entryimage',0);
$showTitle = $params->get('title',1);
$maxlength = $params->get('item_length', 50);
$direction = $params->get('direction', 1);
$showNoEntries = $params->get('showNoEntries', "");
$categorydepend = $params->get('categorydepend', 0);
if(!$limit || $limit < 1)
$limit = 5;
$useTemplate = $params->get('useTemplate', 0);
$revTemplate = str_replace( array( "\n", "\r", "\t" ), null, $params->get('revTemplate', "{link}"));
$maxRevLength = $params->get('maxRevLength', 0);
$config =& sobi2Config::getInstance();
$database =& $config->getDb();
$S_Itemid = $config->sobi2Itemid;
$catId = sobi2Config::request( $_REQUEST,'catid',0 );
$now = $config->getTimeAndDate();
$loadfile = false;
if (!(defined("_JEXEC"))) {
$loadfile = true;
}
if (!defined('_SOBI2_CSS_LOADED')) {
define('_SOBI2_CSS_LOADED', true);
$config->addCustomHeadTag( "<link rel='StyleSheet' href='{$config->liveSite}/components/com_sobi2/includes/com_sobi2.css' type='text/css' />\n",$loadfile);
}
$where = null;
if (($catId > 1) && ($categorydepend == 1)) {
$where = "(sitem.itemid IN (SELECT itemid FROM #__sobi2_cat_items_relations WHERE catid = {$catId})) AND ";
}
$showRTitle = $showRText = $showRAuthor = true;
$what = null;
if ($useTemplate)
$what .= ", rev.title AS reviewTitle, rev.comment AS reviewText, rev.name AS reviewAuthor";
$query = "SELECT sitem.itemid, sitem.title, sitem.icon, sitem.image {$what} FROM #__jcomments AS rev LEFT JOIN #__sobi2_item AS sitem ON sitem.itemid = rev.object_id WHERE {$where} (rev.comment != '' AND rev.object_group = 'com_sobi2' AND rev.published = 1 AND sitem.published = 1 AND (sitem.publish_down > '{$now}' OR sitem.publish_down = '{$config->nullDate}')) ORDER BY rev.date DESC LIMIT 0, {$limit}";
$database->setQuery( $query );
$s_results = $database->loadObjectList();
if ($database->getErrorNum())
echo $database->getErrorMsg();
$iso = explode( '=', _ISO );
$encoding = strtoupper($iso[1]);
echo "\n";
echo "<!-- Start of SOBI2 Latest Reviews Module -->\n";
if( !( defined( "_JEXEC" ) ) ) {
if ($table)
echo "<table cellpadding=\"0\" cellspacing=\"0\" class=\"moduletable{$class}\"><tr><td>\n";
}
if(count($s_results)) {
if ($direction == 1)
echo "<ul class=\"sobi2latestreviewed{$class}\">\n";
$imagepath = $config->key('general', 'images_folder');
if (!$imagepath)
$imagepath = '/images/com_sobi2/clients/';
foreach($s_results as $s_result) {
$url = "index.php?option=com_sobi2&sobi2Task=sobi2Details&sobi2Id={$s_result->itemid}&Itemid={$S_Itemid}";
$url = sobi2Config::sef($url);
$myTitle = $config->getSobiStr($s_result->title);
$myFullTitle = $myTitle;
$icon = null;
if ($entryicon) {
$imagename = $s_result->icon;
if ((!$imagename) && ($config->key('frontpage', 'default_ico'))) {
$imagename = $config->key( 'frontpage', 'default_ico' );
}
if($imagename && file_exists("{$config->absolutePath}{$imagepath}{$imagename}")) {
$icon = "<a href=\"{$url}\" title=\"{$myFullTitle}\"><img style=\"border-style:none;\" src=\"{$config->liveSite}{$imagepath}{$imagename}\" title=\"{$myFullTitle}\" alt=\"{$myFullTitle}\"/></a> ";
}
}
$image = null;
if ($entryimage) {
$imagename = $s_result->image;
if ((!$imagename) && ($config->key('frontpage', 'default_img'))) {
$imagename = $config->key( 'frontpage', 'default_img' );
}
if($imagename && file_exists("{$config->absolutePath}{$imagepath}{$imagename}")) {
$image = "<a href=\"{$url}\" title=\"{$myFullTitle}\"><img style=\"border-style:none;\" src=\"{$config->liveSite}{$imagepath}{$imagename}\" title=\"{$myFullTitle}\" alt=\"{$myFullTitle}\"/></a> ";
}
}
$e = null;
if ($showTitle) {
$myTitle = sobi2cutString($myTitle, $maxlength, $encoding);
$e = "<a href=\"{$url}\" title=\"{$myFullTitle}\">{$myTitle}</a>";
}
$revcontent = null;
if ($useTemplate) {
$revText = sobi2cutString($s_result->reviewText, $maxRevLength, $encoding);
$revcontent = sobi2TransformTemplate($revTemplate, $icon, $image, $e, $s_result->reviewTitle, $revText, $s_result->reviewAuthor);
}
if ($icon || $image || $e || $revcontent) {
if ($direction == 1)
echo "<li class=\"sobi2latestreviewed{$class}\">{$icon}{$image}{$e}</li>\n";
else {
if ($revcontent)
echo "<div class=\"sobi2latestreviewed{$class}\" style=\"float:left; margin: 5px;\">\n\t{$revcontent}\n</div>\n";
else
echo "<div class=\"sobi2latestreviewed{$class}\" style=\"float:left; margin: 5px;\">\n\t{$icon}{$image}{$e}\n</div>\n";
}
}
}
if ($direction == 1)
echo "</ul>\n";
else
echo "<div style=\"clear:both;\"></div>\n";
}
else { //no matching entries
if ($showNoEntries) {
echo "<div class=\"sobi2latestreviewed_empty{$class}\" style=\"margin: 5px;\">{$showNoEntries}</div>\n";
}
}
if( !( defined( "_JEXEC" ) ) ) {
if ($table)
echo "</td></tr></table>\n";
}
echo "<!-- End of SOBI2 Latest Reviews Module -->\n";
?>
Педмены сделаны только в строках 116 и 118. Работает при выводе списком, но при выводе div-ом и с использованием шаблона глючит, т.к. я тоже новичёк, но для иллюстрации идеи это наверное не помешает.
Конечно, Сергею все эти модули переделать под себя = 17 минут работы. <-тонкий намёк, да.
