BETA Custom News Block

[hooplah]

I have been working on a custom news block that displays a compact recent news item of any singular forums. I have it so far that it takes you to the forum of a last post but not to the last post in that forum. So the link generated would be something like; http://web site/viewtopic.php?f2&t=26

EDIT: Code working fine after changing as was advised

here is the code if it needs improving let me know

latest_posts.php

Code: Select all

<?php

/**
*
* @package - Board3portal
* @version $Id: latest_members.php 325 2008-08-17 18:59:40Z kevin74 $
* @copyright (c) kevin / saint ( www.board3.de/ ), (c) Ice, (c) nickvergessen ( www.flying-bits.org/ ), (c) redbull254 ( www.digitalfotografie-foren.de ), (c) Christian_N ( www.phpbb-projekt.de )
* @based on: phpBB3 Portal by Sevdin Filiz, www.phpbb3portal.com
* @license http://opensource.org/licenses/gpl-license.php GNU Public License 
*
*/

$offsets = 10;
$forumnumber = 2;

$sqls  = "SELECT * FROM phpbb_posts WHERE forum_id = '$forumnumber' ORDER BY Post_id DESC LIMIT $offsets";

$results = $db->sql_query($sqls);

// print the results in a table

while($list = $db->sql_fetchrow($results))
  {

    $template->assign_block_vars('reviews_rows', array(
    
'U_NEWNEWSLINK'   => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $list['forum_id'] . '&t=' . $list['topic_id'] . '&p=' . $list['post_id'] . '#p' . $list['post_id']), 
'R_RELEASETITLE'          => $list['post_subject']

        )
    );
  }


$template->assign_vars(array(
    'S_DISPLAY_LATEST_POSTS' => true,
));

?>

latest_posts.html

Code: Select all

<table class="tablebg" cellspacing="1" width="100%">
    <tr>
        <th class="cat"><span style="float: left"><img src="{T_THEME_PATH}/images/portal/portal_members.png" width="16px" height="16px" alt="" />&nbsp;Latest Additions</span></th>
    </tr>
    <tr class="row1">
        <td>
            <span style="float:left;"><strong>{Title}</strong></span>
            
            <!-- BEGIN reviews_rows -->

            <a href="{reviews_rows.U_NEWNEWSLINK}" >{reviews_rows.R_RELEASETITLE}</a>
         
            <br style="clear:both" />
            
            <!-- END reviews_rows -->
        </td>
    </tr>
</table>
<br /> 

If anyone wants to try this create and put the latest_posts.php in the root\portal\blocks folder, then create latest_posts.html in root\styles\your style\templates\portal\blocks folder.
edit root\portal.php find

Code: Select all

    if ($portal_config['portal_welcome'])
    {
        include($phpbb_root_path . 'portal/block/welcome.'.$phpEx);
    } 

add after

Code: Select all

        include($phpbb_root_path . 'portal/block/latest_posts.'.$phpEx);     

edit root\styles\your style\template\portal\portal_body.php and add the following line where you want the block to appear

Code: Select all

            <!-- INCLUDE portal/block/latest_posts.html --> 

to set the forum you want to display change the value in latest_posts.php for $forumnumber

[hooplah]

Ok I know i need to use append_sid() function in includes\functions to set sid.

should it be something like

'U_NEWNEWSLINK' => append_sid("{$phpbb_root_path}viewtopic.$phpEx"),

or should i use something like this in the page?

append_sid("{$phpbb_root_path}viewtopic.$phpEx?t=1&f=2");


Any help would be greatly appreciated. Thanks

[Kevin]

Hi,

i would suggest to do it this way:

replace:

Code: Select all

      'R_ID'                      => $list['post_id'],
      'R_TOPICID'                  => $list['topic_id'],
      'R_FORUMID'                  => $list['forum_id'], 

with:

Code: Select all

'U_NEWNEWSLINK'   => append_sid("$phpbb_root_path}viewtopic.$phpEx", 'f=' . $list['forum_id'] . '&t=' . $list['topic_id'] . '&p=' . $list['post_id'] . '#p' . $list['post_id']), 

and in your template instead of:

Code: Select all

<a href="./viewtopic.php?f{reviews_rows.R_FORUMID}&t={reviews_rows.R_TOPICID}" >{reviews_rows.R_RELEASETITLE}</a> 

just:

Code: Select all

<a href="{reviews_rows.U_NEWNEWSLINK}" >{reviews_rows.R_RELEASETITLE}</a> 

Thank you for sharing!

[hooplah]

Thanks for the help Kevin got it working a treat.

had to change

Code: Select all

'U_NEWNEWSLINK'   => append_sid("$phpbb_root_path}viewtopic.$phpEx", 'f=' . $list['forum_id'] . '&t=' . $list['topic_id'] . '&p=' . $list['post_id'] . '#p' . $list['post_id']), 

to this

Code: Select all

'U_NEWNEWSLINK'   => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $list['forum_id'] . '&t=' . $list['topic_id'] . '&p=' . $list['post_id'] . '#p' . $list['post_id']), 

Updated the code in my orriginal files so anyone who would like this block can have it working fine.

[Superman]

I've tried adding this block twice and I keep getting errors and lines of code saying it can't modify the header. It also breaks the CSS and the text on the page looks huge.

[hooplah]

can you post a board link m8 so i can see?

[the.ronin]

Great mod! Thanks for sharing.

Any suggestions on how to exclude stickied posts or announcements? Also to limit the number of characters in the title?

[edit] I also notice it is posting responses. Any way to get rid of that too?

[freedose]

Hi,
this is great mod... but i got eror:

Code: Select all

[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3548: Cannot modify header information - headers already sent by (output started at /portal/block/latest_posts.php:1)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3550: Cannot modify header information - headers already sent by (output started at /portal/block/latest_posts.php:1)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3551: Cannot modify header information - headers already sent by (output started at /portal/block/latest_posts.php:1)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3552: Cannot modify header information - headers already sent by (output started at /portal/block/latest_posts.php:1)

what im wrong? Im follow what exactly your code.

[hooplah]

Hi,
this is great mod... but i got eror:

Code: Select all

[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3548: Cannot modify header information - headers already sent by (output started at /portal/block/latest_posts.php:1)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3550: Cannot modify header information - headers already sent by (output started at /portal/block/latest_posts.php:1)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3551: Cannot modify header information - headers already sent by (output started at /portal/block/latest_posts.php:1)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3552: Cannot modify header information - headers already sent by (output started at /portal/block/latest_posts.php:1)

what im wrong? Im follow what exactly your code.

make sure there is no spaces before the <?php line on line 1

[freedose]

thanks bro!
it work now....

it show like this.



if you could tell me, if able to make table like image below:

[hooplah]

No Problems, keep an eye on this post over the next couple of weeks i'll make some variations

[freedose]

of coz bro!
always in my notify topic....

[Matt]

First, I love this mod. Thank you very much for making it available. I have a quick question about adapting it. Is there a way to make just this block display only the newest topic, without showing replies and without having newly replied to topics show back up?

Thank you very much for your time,
Matt

[can99]

TO make this mod work with the latest version of the Database I had to change this line in latest_post.php



$sqls = "SELECT * FROM phpbb_posts WHERE forum_id = '$forumnumber' ORDER BY Post_id DESC LIMIT $offsets";

to


$sqls = "SELECT * FROM posts WHERE forum_id = '$forumnumber' ORDER BY Post_id DESC LIMIT $offsets";

[can99]

Does anyone have any idea how you could add 2 of these mods to the portal page WITHOUT is screwing up the posts, see I added 2 versions of the mod, one called latest_posts.html and .php and another called latest_newpost.html and .php, and added the code to the portal.php and portal_body.html

It works BUT it just simply duplicates the forum posts in each block ... ie:

Local Business
Concession Trailer For Your Next Event
artist needs condo>guest house

New Poster Lounge
Concession Trailer For Your Next Event
artist needs condo>guest house

Now I am missing something really really simple, does anyone know what it is?