<?php
$cache = $PowerBB->_CONF['info_row']['side_bar_last_topics_cache'];
$cache_time = $PowerBB->_CONF['info_row']['side_bar_last_topics_time'];
$cache_long = $PowerBB->_CONF['info_row']['side_bar_last_topics_long'];
$Now= $PowerBB->_CONF['now'];
$cache_end = $cache_time+($cache_long*60);
if(!$cache || !$cache_time || ($cache_end < $Now))
{
$testArr = Array();
$forum_not = $PowerBB->_CONF['info_row']['side_bar_forum_not'] . ',' . $PowerBB->_CONF['info_row']['last_subject_writer_not_in'];
$limit = $PowerBB->_CONF['info_row']['side_bar_last_topics_limit'];
$order = $PowerBB->_CONF['info_row']['side_bar_last_topics_order'];
if($PowerBB->_CONF['info_row']['thumb_addon_active']){
$query = $PowerBB->DB->sql_query("SELECT `id`,`native_write_time`,`write_time`,`last_replier`,`title`,`writer`,`icon`,`visitor`, `reply_number`,`sec_subject`,`delete_topic`,`review_subject`,`section`,`thumb_path` FROM " . $PowerBB->table['subject'] . " WHERE `sec_subject` <>1 AND `delete_topic` <>1 AND `review_subject` <>1 AND `section` not in (" .$forum_not. ") ORDER by `$order` DESC LIMIT $limit ");
}
else
{
$query = $PowerBB->DB->sql_query("SELECT `id`,`native_write_time`,`write_time`,`last_replier`,`title`,`writer`,`icon`,`visitor`, `reply_number`,`sec_subject`,`delete_topic`,`review_subject`,`section` FROM " . $PowerBB->table['subject'] . " WHERE `sec_subject` <>1 AND `delete_topic` <>1 AND `review_subject` <>1 AND `section` not in (" .$forum_not. ") ORDER by `$order` DESC LIMIT $limit ");
}
while($pbb = $PowerBB->DB->sql_fetch_array($query)){
$pbb['title'] = $PowerBB->Powerparse->censor_words($pbb['title']);
$pbb['title'] = $PowerBB->Powerparse->_wordwrap($pbb['title'],$PowerBB->_CONF['info_row']['side_bar_title_long']);
$pbb['date'] = $PowerBB->functions->date($pbb['write_time']);
$testArr[] = $pbb;
}
$cache = @base64_encode(@serialize($testArr));
$update1 = $PowerBB->DB->sql_query("UPDATE " . $PowerBB->table['info'] . " SET value='$cache' WHERE var_name='side_bar_last_topics_cache' ");
$update2 = $PowerBB->DB->sql_query("UPDATE " . $PowerBB->table['info'] . " SET value='$Now' WHERE var_name='side_bar_last_topics_time' ");
}
$pbb= @unserialize(@base64_decode($cache));
$PowerBB->_CONF['template']['while']['DataList'] = $pbb;
?>




<table style="width:100%">
{Des::while}{DataList}
<tr>
{if {$_CONF['info_row']['side_bar_last_topics_thumb']} ==1}
<td class="sb_thumb">
{if {$DataList['thumb_path']} }
<img src="{$DataList['thumb_path']}" alt="" width="{$_CONF['info_row']['side_bar_thumb_width']}" height="{$_CONF['info_row']['side_bar_thumb_height']}">
{else}
<img src="develop/nothumb.jpg" alt="" class="sb_thumb"  width="{$_CONF['info_row']['side_bar_thumb_width']}" height="{$_CONF['info_row']['side_bar_thumb_height']}">
{/if}
</td>
{/if}
<td class="last_topics">
{if {$DataList['reply_number']} > {$_CONF['info_row']['perpage']}}
<?php
$pages_number = @ceil($PowerBB->_CONF['template']['while']['DataList'][$this->x_loop]['reply_number']/$PowerBB->_CONF['info_row']['perpage']);
$count = $pages_number*$PowerBB->_CONF['info_row']['perpage']-$PowerBB->_CONF['info_row']['perpage'];
?>
<a href="index.php?page=topic&amp;show=1&amp;id={$DataList['id']}&count=<?php echo $count;?>"
{else}

<a href="index.php?page=topic&amp;show=1&amp;id={$DataList['id']}-{$DataList['title']}">{$DataList['title']}</a>

{/if}

<br>
<span class="last_p">&nbsp;</span>
<a href="index.php?page=profile&amp;show=1&amp;username={$DataList['last_replier']}"><b>{$DataList['last_replier']}</b></a>
<br>
<i class="IconNewsTime fa fa-history pkr-c"></i>
<span class="sb_date">
<?php echo $PowerBB->functions->time($PowerBB->_CONF['template']['while']['DataList'][$this->x_loop]['write_time']); ?>
 <?php echo $PowerBB->functions->time_ago($PowerBB->_CONF['template']['while']['DataList'][$this->x_loop]['write_time']); ?>
</span>
</td>
</tr>
{/Des::while}
</table>
<?php
unset($cache);
unset($pbb);
unset($PowerBB->_CONF['template']['while']['DataList']);
?>