Page 1 of 1
Recent Topics Scrolling
Posted: 27. March 2009 07:03
by DragonMaster
Your Portal Version: 1.0.0RC3
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Beginner
What have you done before the problem was there?
What have you already tryed to solve the problem?
Description and Message
I see that there is a Recent Topics small block that is scrolling here:
http://www.livewiremods.com/mods/viewforum.php?f=2
Anyone know where to get that block code?
Thanx In Advance!!!
Re: Recent Topics Scrolling
Posted: 27. March 2009 07:18
by Kevin
I think this is part of the stargate portal code. You might have a look on it.
Re: Recent Topics Scrolling
Posted: 27. March 2009 07:45
by DragonMaster
I have that as it was one I was thinking of using, but it was still not as nice as this one. I’ll take a look at the blocks but so far I had not had any luck getting them to work on this board
Re: Recent Topics Scrolling
Posted: 27. March 2009 09:29
by Kevin
DragonMaster wrote:but so far I had not had any luck getting them to work on this board
It should be possible.
If you have it downloaded yet, please show me the content of the belonging files. We might offer an adaption with respect to their work and credits.
Re: Recent Topics Scrolling
Posted: 27. March 2009 11:15
by DragonMaster
Here is my base test board I made for it:
http://www.ronnie-james-dio.com/PORTALT ... 5d8b6c9465
Here is the Recent Topic code
Code: Select all
<?php
/***************************************************************************
* block_recents_topics.php
* ------------------------
* begin : Sunday, 20th May, 2007
* copyright : (C) 2005 Michaelo - Michael O'Toole
* website : http://www.phpbbireland.com
* email : admin@phpbbireland.com
* last update : 21 February 2008
* licence : GPL vs2.0 [ see /docs/COPYING ]
*
* Note: Do not remove this copyright for the top of this page. Just
* append yours if you have modified it. Do not remove copyright...
***************************************************************************/
if ( !defined('IN_PHPBB') )
{
die("Hacking attempt");
}
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
$auth->acl($user->data);
// URL PARAMETERS
define('POST_TOPIC_URL', 't');
define('POST_CAT_URL', 'c');
define('POST_FORUM_URL', 'f');
define('POST_USERS_URL', 'u');
define('POST_POST_URL', 'p');
define('POST_GROUPS_URL', 'g');
global $user, $forum_id, $phpbb_root_path, $phpEx, $SID, $config , $template, $portal_config, $userdata, $config, $db, $phpEx;
// set up variables used //
$display_this_many = $k_config['number_of_recent_topics_to_display'];
$forum_count = $row_count = 0;
$except_forum_id = '';
$forum_data = array();
$recent_topic_row = array();
// get all forums //
$sql = "SELECT * FROM ". FORUMS_TABLE . " ORDER BY forum_id";
if (!$result = $db->sql_query($sql))
{
trigger_error('Error! Could not query forums information: ' . basename(dirname(__FILE__)) . '/' . basename(__FILE__) . ', line ' . __LINE__);
}
while( $row = $db->sql_fetchrow($result) )
{
$forum_data[] = $row;
$forum_count++;
}
$db->sql_freeresult($result);
for ($i = 1; $i < $forum_count; $i++)
{
if (!$auth->acl_gets('f_list', 'f_read', $forum_data[$i]['forum_id']))
{
$except_forum_id .= "'" . $forum_data[$i]['forum_id'] . "'";
$except_forum_id .= ",";
}
}
$except_forum_id = rtrim($except_forum_id,",");
if($except_forum_id == '')
$except_forum_id = '0';
$sql = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username, u.user_colour
FROM " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p, " . USERS_TABLE . " AS u
WHERE t.forum_id NOT IN (" . $except_forum_id . ")
AND t.topic_status <> 2
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u.user_id
ORDER BY p.post_id DESC
LIMIT " . $display_this_many;
if (!$result = $db->sql_query($sql, 300))
{
trigger_error("Could not query recent topics data");
}
while ($row = $db->sql_fetchrow($result))
{
$recent_topic_row[] = $row;
if( $row['forum_id'] > 0)
{
// Get forum name for this postid
$sql2 = "SELECT forum_name
FROM " . FORUMS_TABLE . "
WHERE forum_id = " . $row['forum_id'] . "
LIMIT " . 1;
if (!$my_result = $db->sql_query($sql2, 300))
{
trigger_error("Could not get forum name");
}
$my_row = $db->sql_fetchrow($my_result);
$recent_topic_row['forum_name'][$row_count] = $my_row['forum_name'];
$row_count ++;
}
}
$db->sql_freeresult($result);
$db->sql_freeresult($my_result);
$sql = "SELECT scroll, position
FROM " . K_BLOCKS_TABLE . "
WHERE title = 'Recent Topics' ";
if( $result = $db->sql_query($sql, 300) )
{
$rowx = $db->sql_fetchrow($result);
$scroll = $rowx['scroll'];
$display_center = $rowx['position'];
}
else
trigger_error("Could not query <strong>" . $recent_topics . "</strong> information");
$db->sql_freeresult($result);
($scroll) ? $style_row = 'scroll' : $style_row = 'static';
//$template->assign_block_vars($style_row, array());
// change topics to display count if there are less topics that set in ACP
if($display_this_many > $row_count)
$display_this_many = $row_count;
if($scroll)
{
$display_this_many = $row_count;
if($row_count <= 6)
{
$style_row = 'static';
$template->assign_vars(array(
'PROCESS' => false,
));
}
else
{
$template->assign_vars(array(
'PROCESS' => true,
));
}
}
for ( $i = 0; $i < $display_this_many; $i++ )
{
if ($recent_topic_row[$i]['user_id'] != -1)
{
if($display_center != 'C')
$recent_topic_row[$i]['topic_title'] = sgp_checksize ($recent_topic_row[$i]['topic_title'],20); // Michaelo's function to stop page from stretching due to long names in form select options... Names are truncated//
$view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . (($recent_topic_row[$i]['forum_id']) ? $recent_topic_row[$i]['forum_id'] : $forum_id) );
// add spaces for nice scrolling
$my_title = smilies_pass($recent_topic_row[$i]['topic_title']);
$length = strlen($my_title);
// padd if too long
if($length > 25)
{
sgp_checksize ($my_title, 25);
}
// do same for forum name
$my_forum = smilies_pass($recent_topic_row['forum_name'][$i]);
$length = strlen($my_forum);
// padd if too long
if($length > 25)
sgp_checksize ($my_forum, 25);
$template->assign_block_vars($style_row . '.recent_topic_row', array(
'U_FORUM' => append_sid("viewforum.$phpEx?" . POST_FORUM_URL . '=' . $recent_topic_row[$i]['forum_id']),
'U_LAST_POST' => $view_topic_url . '&p=' . $recent_topic_row[$i]['topic_last_post_id'] . '#p' . $recent_topic_row[$i]['topic_last_post_id'],
'U_TITLE' => append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $recent_topic_row[$i]['post_id']),
'S_FORUM' => $my_forum,
'S_POSTER' => get_username_string('full', $recent_topic_row[$i]['user_id'], $recent_topic_row[$i]['username'], $recent_topic_row[$i]['user_colour']),
'S_POSTTIME' => $user->format_date($recent_topic_row[$i]['post_time']),
'S_ROW_COUNT' => $i,
'S_TITLE' => $my_title,
'LAST_POST_IMG' => $user->img('icon_topic_newest', 'VIEW_LATEST_POST'),
)
);
}
}
$template->assign_vars(array(
'S_RECENT_TOPICS_COUNT_ASKED' => $display_this_many,
'S_RECENT_TOPICS_COUNT_RETURNED' => $row_count,
'S_ALIGN_IT' => 'center',
'S_DISPLAY_CENTRE' => $display_center,
'S_COUNT' => $display_this_many,
)
);
?>
Re: Recent Topics Scrolling
Posted: 27. March 2009 12:43
by Kevin
And the template code would be nice.
Re: Recent Topics Scrolling
Posted: 27. March 2009 14:18
by DragonMaster
Kevin wrote:And the template code would be nice.
That base I have is just basic prosilver....but I normally use Divine Black based on subsilver
Re: Recent Topics Scrolling
Posted: 27. March 2009 15:14
by Kevin
However - i need a template.
prosilver is fine - for other people, wanting to use it.
But please note: we are currently working on the next release of B3P. So it might be that i only get to have a look on it next week.
Re: Recent Topics Scrolling
Posted: 27. March 2009 17:52
by DragonMaster
Do you want my Divine Black?
If so, a base copy or the modded one I use?
Which files?
Re: Recent Topics Scrolling
Posted: 28. March 2009 05:52
by PeterS
Hi Kevin,
here the block_recent_topics.html
Code: Select all
<!-- IDTAG starts block_recent_topics.html 30th June 2008 copyright 2007 phpbbireland.com -->
<span class="block_data">
<!-- IF S_COUNT_RECENT -->
<div style="width:100%; overflow:visible;" >
<!-- BEGIN scrollwide -->
<!-- BEGIN recent_topic_row -->
<strong>{staticwide.recent_topic_row.ORI_LAST_POST_IMG} <a href="{scrollwide.recent_topic_row.U_TITLE}" > {scrollwide.recent_topic_row.S_TITLE}</a></strong>
<br /> by: {scrollwide.recent_topic_row.S_POSTER} <br />
<span class="tiny">{scrollwide.recent_topic_row.S_POSTTIME}</span><br />
<!--<a href="{scrollwide.recent_topic_row.U_TITLE}" >{L_RECENT_REPLY}{scrollwide.recent_topic_row.ORI_LAST_POST_IMG}</a><br /><br />-->
<!-- END recent_topic_row -->
<!-- END scrollwide -->
<!-- BEGIN staticwide -->
<!-- BEGIN recent_topic_row -->
<strong>{staticwide.recent_topic_row.ORI_LAST_POST_IMG} <a href="{staticwide.recent_topic_row.U_TITLE}" > {staticwide.recent_topic_row.S_TITLE}</a></strong>
<br /> by: {staticwide.recent_topic_row.S_POSTER} <br />
<span class="tiny">{staticwide.recent_topic_row.S_POSTTIME}</span> <br />
<!-<a href="{staticwide.recent_topic_row.U_TITLE}" >{L_RECENT_REPLY}{staticwide.recent_topic_row.ORI_LAST_POST_IMG}</a><br /><br />-->
<!-- END recent_topic_row -->
<!-- END staticwide -->
</div>
<!-- ELSE -->
<div><center><span class="genmed"><strong>{L_NO_RECENT_TOPICS}</strong></span></center></div>
<!-- ENDIF -->
</span>
<!-- IDTAG ends block_recent_topics -->
and
block_recent_topic_wide.html
Code: Select all
<!-- IDTAG starts block_recent_topics.html 30th June 2008 copyright 2007 phpbbireland.com -->
<span class="block_data">
<!-- IF S_COUNT_RECENT -->
<div style="width:100%; overflow:visible;">
<table width="100%" cellpadding="1" cellspacing="1">
<!-- BEGIN scrollwide -->
<!-- BEGIN recent_topic_row -->
<!-- IF scrollwide.recent_topic_row.S_ROW_COUNT == 0 -->
<tr>
<td width="auto">{L_TITLE}</td>
<td width="auto">{L_POSTER}</td>
<td align="right" width="auto">{L_POSTED}/{L_EDITED}</td>
</tr>
<tr><td colspan="3"><hr /></td></tr>
<!-- ENDIF -->
<!-- IF scrollwide.recent_topic_row.S_UNIQUE -->
<tr class="bg3"><td colspan="3" width="auto" style="text-align:left;"><strong><a href="{scrollwide.recent_topic_row.U_FORUM}">{scrollwide.recent_topic_row.S_FORUM}</a></strong></td><!--<td style="text-align:right;">{L_FORUM}</td>--></tr>
<!-- ENDIF -->
<!-- IF scrollwide.recent_topic_row.S_ROW_COUNT is even --><tr class="bg2"><!-- ELSE --><tr class="bg1"><!-- ENDIF -->
<td width="auto">{scrollwide.recent_topic_row.LAST_POST_IMG} <a href="{scrollwide.recent_topic_row.U_TITLE}" >
<span class="<!-- IF scrollwide.recent_topic_row.S_TYPE == 2 or scrollwide.recent_topic_row.S_TYPE == 3 -->red<!-- ELSEIF scrollwide.recent_topic_row.S_TYPE == 4 or scrollwide.recent_topic_row.S_TYPE == 5 -->orange<!-- ELSEIF scrollwide.recent_topic_row.S_TYPE == 1 -->green<!-- ELSE --><!-- ENDIF -->">{scrollwide.recent_topic_row.S_TITLE}</span></a>:
</td>
<td width="auto">{scrollwide.recent_topic_row.S_POSTER} </td>
<td align="right" width="auto">{scrollwide.recent_topic_row.S_POSTTIME}</td>
</tr>
<!-- END recent_topic_row -->
<tr><td colspan="3">
<table width="100%" cellpadding="0" cellspacing="0">
<td class="bg3" style="padding:3px;" align="left" width="auto"><b>Legend:</b><span class="red"> Announcements</span>, <span class="green"> Sticky</span>, <span class="orange"> News</span> and <b> Normal</b> posts.</td>
<td class="bg3" style="padding:3px;" align="right" width="auto"><b>{SEARCH_TYPE}, {SEARCH_LIMIT}</b></td>
</table>
</td></tr>
<!-- END scrollwide -->
<!-- BEGIN staticwide -->
<!-- BEGIN recent_topic_row -->
<!-- IF staticwide.recent_topic_row.S_ROW_COUNT == 0 -->
<tr>
<td width="auto">{L_TITLE}</td>
<td width="auto">{L_POSTER}</td>
<td align="right" width="auto">{L_POSTED}/{L_EDITED}</td>
</tr>
<tr><td colspan="3"><hr /></td></tr>
<!-- ENDIF -->
<!-- IF staticwide.recent_topic_row.S_UNIQUE -->
<tr class="bg3"><td colspan="3" width="auto" style="text-align:left;"><strong><a href="{staticwide.recent_topic_row.U_FORUM}">{staticwide.recent_topic_row.S_FORUM}</a></strong></td><!--<td style="text-align:right;">{L_FORUM}</td>--></tr>
<!-- ENDIF -->
<!-- IF staticwide.recent_topic_row.S_ROW_COUNT is even --><tr class="bg2"><!-- ELSE --><tr class="bg1"><!-- ENDIF -->
<td width="auto">{staticwide.recent_topic_row.LAST_POST_IMG} <a href="{staticwide.recent_topic_row.U_TITLE}" >
<span class="<!-- IF staticwide.recent_topic_row.S_TYPE == 2 or staticwide.recent_topic_row.S_TYPE == 3 -->red<!-- ELSEIF staticwide.recent_topic_row.S_TYPE == 4 or staticwide.recent_topic_row.S_TYPE == 5 -->orange<!-- ELSEIF staticwide.recent_topic_row.S_TYPE == 1 -->green<!-- ELSE --><!-- ENDIF -->">{staticwide.recent_topic_row.S_TITLE}</span></a>:
</td>
<td width="auto">{staticwide.recent_topic_row.S_POSTER} </td>
<td align="right" width="auto">{staticwide.recent_topic_row.S_POSTTIME}</td>
</tr>
<!-- END recent_topic_row -->
<tr><td colspan="3">
<table width="100%" cellpadding="0" cellspacing="0">
<td class="bg3" style="padding:3px;" align="left" width="auto"><b>{SEARCH_TYPE}, {SEARCH_LIMIT}</b></td>
<td class="bg3" style="padding:3px;" align="right" width="auto"><b>Title Legend:</b><span class="red"> Announcements</span>, <span class="green"> Sticky</span>, <span class="orange"> News</span><b> Normal</b></td>
</table>
</td></tr>
<!-- END staticwide -->
</table>
</div>
<!-- ELSE -->
<div><center><span class="genmed"><strong>{L_NO_RECENT_TOPICS}</strong></span></center></div>
<!-- ENDIF -->
</span>
<!-- IDTAG ends block_recent_topics -->
Peter
Re: Recent Topics Scrolling
Posted: 28. March 2009 09:44
by DragonMaster
Thank you MUCH!!!
I will install that as soon as I have a few minutes and advise here
Again...THANK YOU!!!
Re: Recent Topics Scrolling
Posted: 28. April 2009 15:28
by bc2005
Is it possible for Board3 Portal users to add a scrolling recent topics block?
Kind regards,
Hans
Re: Recent Topics Scrolling
Posted: 28. June 2010 14:11
by helwoe
I'm interested in this as well. How do you add that code into a prosilver based theme?
helwoe
Re: Recent Topics Scrolling
Posted: 13. May 2012 02:44
by sp0k
hello any new news on this one.....i would like to use this