![[8WR] XenPorta (Portal)](/community/data/resource_icons/0/90.jpg?1380991375){kind=icon}
No one can really help you with specifics as everyone is personal preference and a per site basis. If you don't know how to do it how you want it, hire a coder or post in the http://xenforo.com/community/forums/styling-and-customization-questions.47/ forum.
If you feel entitled to people sharing there hard work with you for free than please contribute something yourself. I think people would be more likely to help you if you help them.
For instance maybe sharing the block code you found or making a resource?
<?php
class EWRporta_Block_RecentSlider extends XenForo_Model
{
public function getModule(&$options)
{
$options['forum'] = implode(',', $this->getModelFromCache('EWRporta_Model_Promotes')->getPromoteForums());
$news = $this->_getDb()->fetchAll("
SELECT xf_thread.*, xf_post.message, xf_attachment.*, xf_attachment_data.*,
IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) AS promote_date
FROM xf_thread
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
INNER JOIN xf_attachment ON (xf_attachment.content_id = xf_thread.first_post_id AND xf_attachment.content_type = 'post')
INNER JOIN xf_attachment_data ON (xf_attachment_data.data_id = xf_attachment.data_id AND xf_attachment_data.filename = ? AND xf_attachment_data.thumbnail_width > 0)
LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
WHERE (xf_thread.node_id IN (".$options['forum'].") OR EWRporta_promotes.promote_date < ?)
AND xf_thread.discussion_state = 'visible'
AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?
ORDER BY promote_date DESC
LIMIT ?
", array($options['filename'], XenForo_Application::$time, XenForo_Application::$time, $options['limit']));
$options['parseText'] = true;
return $news;
}
}<xen:require css="EWRblock_RecentSlider.css" />
<div class="section sectionMain" id="recentFeatures">
<xen:require js="js/8wayrun/EWRporta_jquery-ui-1.9.0.custom.min.js" />
<xen:require js="js/8wayrun/EWRporta_tabs-rotate.js" />
<script type="text/javascript">
$(document).ready(function(){
$("#feature").tabs({fx:{opacity: "toggle"}}).tabs("rotate", 5000, true);
});
</script>
<div id="feature">
<ul class="ui-tabs-nav nav">
<xen:foreach loop="$RecentSlider" value="$news" i="$i">
<li class="ui-tabs-nav-item" id="fragment-{$i}"><a href="#nav-fragment-{$i}"><img alt="{$news.title}" class="featured_thumb" src="{xen:link attachments, $news}" title="{$news.title}" /><span></span></a></li>
</xen:foreach>
</ul>
<xen:foreach loop="$RecentSlider" value="$news" i="$i">
<div id="nav-fragment-{$i}" class="ui-tabs-panel article<xen:if is="{$i}>1"> hide</xen:if>">
<a href="{xen:link threads, $news}"><img alt="{$news.title}" class=" featured" src="{xen:link attachments, $news}" title="{$news.title}" /></a>
<div class="glass">
<h2><a href="{xen:link threads, $news}">{$news.title}</a></h2>
<div>{xen:helper wordtrim, $news.messageText, {$option.trimexcerpt}}</div>
</div>
</div>
</xen:foreach>
<div class="clear"></div>
</div>
</div>
<xen:require css="EWRporta.css" />
<xen:if is="{$blocks.top-left}">
<div class="sidebar topLeftBlocks">
<xen:foreach loop="$blocks.top-left" value="$block">
{xen:raw $block}
</xen:foreach>
</div>
</xen:if>
<xen:if is="{$blocks.top-right}">
<div class="sidebar topRightBlocks {xen:if '{$blocks.top-left}', 'centerShift'}">
<xen:foreach loop="$blocks.top-right" value="$block">
{xen:raw $block}
<br>
</xen:foreach>
</div>
</xen:if>.topRightBlocks { border: none; }
It's @Bob B 's awesome addon called Showcase. http://xenforo.com/community/resources/showcase.1208/
Fantastic! Thanks, man. Much appreciated!
SELECT xf_thread.*, xf_user.*, xf_post.message, xf_post.attach_count, xf_node.title AS node_title,
IF(xf_user.username IS NULL, xf_thread.username, xf_user.username) AS username,
IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) AS promote_date,
EWRporta_promotes.promote_icon, EWRporta_promotes.promote_data
FROM xf_thread
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
INNER JOIN xf_node ON (xf_node.node_id = xf_thread.node_id)
LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
WHERE ( xf_thread.node_id IN ('109') OR EWRporta_promotes.promote_date < ? )
AND xf_thread.discussion_state = 'visible'
AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?
ORDER BY promote_date DESC
LIMIT ?, ?
Params: 1393070876, 1393070876, 0, 10
Run Time: 0.916767
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_thread ALL node_id_last_post_date,node_id_sticky_state_last_post 262728 Using where; Using temporary; Using filesort
SIMPLE xf_node eq_ref PRIMARY PRIMARY 4 mus37_xenforo.xf_thread.node_id 1
SIMPLE EWRporta_promotes eq_ref PRIMARY PRIMARY 4 mus37_xenforo.xf_thread.thread_id 1 Using where
SIMPLE xf_user eq_ref PRIMARY PRIMARY 4 mus37_xenforo.xf_thread.user_id 1
SIMPLE xf_post eq_ref PRIMARY PRIMARY 4 mus37_xenforo.xf_thread.first_post_id 1SELECT xf_thread.*, xf_user.*, xf_post.message, xf_post.attach_count, xf_node.title AS node_title,
IF(xf_user.username IS NULL, xf_thread.username, xf_user.username) AS username,
IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) AS promote_date,
EWRporta_promotes.promote_icon, EWRporta_promotes.promote_data
FROM xf_thread
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
INNER JOIN xf_node ON (xf_node.node_id = xf_thread.node_id)
LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
WHERE ( xf_thread.node_id IN ('109') )
AND xf_thread.discussion_state = 'visible'
AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?
ORDER BY promote_date DESC
LIMIT ?, ?
Params: 1393072334, 0, 10
Run Time: 0.003232
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_node const PRIMARY PRIMARY 4 const 1 Using temporary; Using filesort
SIMPLE xf_thread ref node_id_last_post_date,node_id_sticky_state_last_post node_id_last_post_date 4 const 27 Using index condition; Using where
SIMPLE EWRporta_promotes eq_ref PRIMARY PRIMARY 4 mus37_xenforo.xf_thread.thread_id 1 Using where
SIMPLE xf_user eq_ref PRIMARY PRIMARY 4 mus37_xenforo.xf_thread.user_id 1
SIMPLE xf_post eq_ref PRIMARY PRIMARY 4 mus37_xenforo.xf_thread.first_post_id 1 $news = $this->_getDb()->fetchAll("
SELECT xf_thread.*, xf_user.*, xf_post.message, xf_post.attach_count, xf_node.title AS node_title,
IF(xf_user.username IS NULL, xf_thread.username, xf_user.username) AS username,
IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) AS promote_date,
EWRporta_promotes.promote_icon, EWRporta_promotes.promote_data
FROM xf_thread
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
INNER JOIN xf_node ON (xf_node.node_id = xf_thread.node_id)
LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
$fromWhere
WHERE ( xf_thread.node_id IN (".$this->_getDb()->quote($options['forum']).") OR EWRporta_promotes.promote_date < ? )
AND xf_thread.discussion_state = 'visible'
AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?
ORDER BY $fromOrder promote_date DESC
LIMIT ?, ?
", array(XenForo_Application::$time, XenForo_Application::$time, $page, $options['limit'])); $news = $this->_getDb()->fetchAll("
SELECT xf_thread.*, xf_user.*, xf_post.message, xf_post.attach_count, xf_node.title AS node_title,
IF(xf_user.username IS NULL, xf_thread.username, xf_user.username) AS username,
IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) AS promote_date,
EWRporta_promotes.promote_icon, EWRporta_promotes.promote_data
FROM xf_thread
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
INNER JOIN xf_node ON (xf_node.node_id = xf_thread.node_id)
LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
$fromWhere
WHERE ( xf_thread.node_id IN (".$this->_getDb()->quote($options['forum'])."))
AND xf_thread.discussion_state = 'visible'
AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?
ORDER BY $fromOrder promote_date DESC
LIMIT ?, ?
", array(XenForo_Application::$time, $page, $options['limit']));
You mean "Auto Promote in certain node"?
