Can not install Topic Text in Mouseover for B3P

[kolja]

Hello Forum

I tried to install the Topic Text in Mouseover MOD but i cant find two things:

portal/block/recent.php
Find

$sql_where .= ' AND forum_id <> ' . trim($id);

Replace With

$sql_where .= ' AND t.forum_id <> ' . trim($id);

The Find specified by the MOD could not be found


Find
//
// Recent announcements
//
$sql = 'SELECT topic_title, forum_id, topic_id
FROM ' . TOPICS_TABLE . '
WHERE topic_status <> ' . FORUM_LINK . '
AND topic_approved = 1
AND ( topic_type = ' . POST_ANNOUNCE . ' OR topic_type = ' . POST_GLOBAL . ' )
AND topic_moved_id = 0
' . $sql_where . '
ORDER BY topic_time DESC';

Replace With

//
// Recent announcements
//
$sql = 'SELECT t.topic_title, t.forum_id, t.topic_id, pt.post_text
FROM ' . TOPICS_TABLE . ' t
LEFT JOIN ' . POSTS_TABLE . ' pt
ON pt.post_id = t.topic_first_post_id
WHERE t.topic_status <> ' . FORUM_LINK . '
AND t.topic_approved = 1
AND ( t.topic_type = ' . POST_ANNOUNCE . ' OR t.topic_type = ' . POST_GLOBAL . ' )
AND t.topic_moved_id = 0
' . $sql_where . '
ORDER BY t.topic_time DESC';

The Find specified by the MOD could not be found

I use the PHPBB 3.0.7, the Board3Portal1.0.5 and of cause this Integrate Topic Text Hover in Board 3 Portal (Update 1.0.3)

Can anyone please help me ?

Kolja

[wang5555]

The "Topic Text Hover in Board 3 Portal (Update 1.0.3)" just is applicable on Board3Portal 1.0.4.
It need some change for Board3Portal 1.0.5.
I will update it as quickly as possible.

[kolja]

Great!

I will wait

Kolja