фото автора в статьях
- Предыдущая
- 1
- 2
- Показаны 16-29 из 29

Просто задачи не было сделать красиво, была задача проверить )))
Помогите найти ошибку::
model.php
<?php /******************************************************************************/ // // // InstantCMS v1.10.3 // // http://instantcms.ru/ // // // // written by InstantCMS Team, 2007-2013 // // produced by InstantSoft, (www.instantsoft.ru) // // // // LICENSED BY GNU/GPL v2 // // // /******************************************************************************/ class cms_model_content{ public function __construct(){ $this->inDB = cmsDatabase::getInstance(); $this->config = cmsCore::getInstance()->loadComponentConfig('content'); cmsCore::loadLanguage('components/content'); cmsCore::loadLib('tags'); cmsCore::loadLib('karma'); } /* ==================================================================================================== */ /* ==================================================================================================== */ public static function getDefaultConfig() { 'readdesc' => 0, 'is_url_cyrillic' => 0, 'rating' => 1, 'perpage' => 15, 'pt_show' => 1, 'pt_disp' => 1, 'pt_hide' => 1, 'autokeys' => 1, 'img_small_w' => 100, 'img_big_w' => 200, 'img_sqr' => 1, 'img_users' => 1, 'watermark' => 1 ); return $cfg; } /* ==================================================================================================== */ /* ==================================================================================================== */ public function getCommentTarget($target, $target_id) { switch($target){ case 'article': $article = $this->inDB->get_fields('cms_content', "id='{$target_id}'", 'seolink, title'); if (!$article) { return false; } $result['link'] = $this->getArticleURL(null, $article['seolink']); $result['title'] = $article['title']; break; } return ($result ? $result : false); } /* ==================================================================================================== */ /* ==================================================================================================== */ public function updateRatingHook($target, $item_id, $points) { switch($target){ case 'content': $sql = "UPDATE cms_content SET rating = rating + ({$points}) WHERE id = '{$item_id}'"; break; } $this->inDB->query($sql); return true; } /* ==================================================================================================== */ /* ==================================================================================================== */ /** * Возвращает подкатегории категории * @return array */ public function getSubCats($parent_id, $recurse=false, $left_key=0, $right_key=0) { if($recurse){ $where = "NSLeft > $left_key AND NSRight < $right_key"; } else { $where = "parent_id = '$parent_id'"; } $sql = "SELECT * FROM cms_category WHERE {$where} AND published = 1"; $result = $this->inDB->query($sql); if (!$this->inDB->num_rows($result)) { return false; } while($subcat = $this->inDB->fetch_assoc($result)){ $subcat['content_count'] = $this->getArticleCountFromCat($subcat['NSLeft'], $subcat['NSRight']); $subcat['url'] = $this->getCategoryURL(null, $subcat['seolink']); $subcats[] = $subcat; } $subcats = cmsCore::callEvent('GET_CONTENT_SUBCATS', $subcats); return $subcats; } /* ==================================================================================================== */ /* ==================================================================================================== */ /** * Возвращает количество статей в категории и подкатегориях * @return int */ public function getArticleCountFromCat($left_key, $right_key) { $sql = "SELECT con.id FROM cms_content con INNER JOIN cms_category cat ON cat.id = con.category_id AND cat.NSLeft >= '$left_key' AND cat.NSRight <= '$right_key' WHERE con.published = 1 AND con.is_arhive = 0"; $result = $this->inDB->query($sql); return $this->inDB->num_rows($result); } /* ==================================================================================================== */ /* ==================================================================================================== */ /** * Возвращает дерево категорий * @return array */ public function getCatsTree() { $sql = "SELECT cat.id as id, cat.title as title, cat.NSLeft as NSLeft, cat.NSRight as NSRight, cat.NSLevel as NSLevel, cat.seolink as seolink FROM cms_category cat WHERE cat.NSLevel>0 ORDER BY cat.NSLeft"; $result = $this->inDB->query($sql); if (!$this->inDB->num_rows($result)) { return false; } while($subcat = $this->inDB->fetch_assoc($result)){ $subcats[] = $subcat; } $subcats = cmsCore::callEvent('GET_CONTENT_CATS_TREE', $subcats); return $subcats; } /* ==================================================================================================== */ /* ==================================================================================================== */ /** * Возвращает категории, доступные для публикования в них * @return array */ public function getPublicCats() { $inCore = cmsCore::getInstance()
в урле картинки уберите /small/
<img src="/images/users/avatars/
и внимательнее будьте
и больше не выкладывайте кучу кода
уже не в первый рази внимательнее будьте
И главное когда вставляю в com_content_read.tpl то работает!!! а в com_content_view.tpl не работает!!! тоесть не получает {$article.imageurl}!!!
Ну конечно же ни у кого не работает. Для того чтобы вывести аватарку в com_content_view.tpl вам нужно изменить запрос в методе getArticlesList. То есть открыть модель компонента, найти public function getArticlesList и привести запрос к такому виду:Ребята неужели у меня одного не работает?
$sql = "SELECT con.*, con.pubdate as fpubdate, cat.title as cat_title, cat.seolink as catseolink, cat.showdesc, u.nickname as author, u.login as user_login, p.imageurl as autor_ava FROM cms_content con INNER JOIN cms_category cat ON cat.id = con.category_id LEFT JOIN cms_users u ON u.id = con.user_id LEFT JOIN cms_user_profiles p ON p.user_id = u.id WHERE con.is_arhive = 0 {$this->inDB->where} {$this->inDB->group_by} {$this->inDB->order_by}\n";
- Предыдущая
- 1
- 2
- Показаны 16-29 из 29