Can not install Topic Text in Mouseover for B3P

Forum rules
This forum is not for support requests.

Only post Modifications for Board3 Portal 1.0.x in this forum.

Topic author
kolja
Active Member
Active Member
Posts: 29
Joined: 9. June 2010 16:44

Can not install Topic Text in Mouseover for B3P

Post by 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
User avatar

wang5555
Translator
Translator
Posts: 55
Joined: 18. December 2008 02:39
phpBB.com User: wang5555
Location: Taiwan

Re: Can not install Topic Text in Mouseover for B3P

Post by 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.
It is more blessed to give than to reveive, welcome to letter, thanks & good-bye!
Good luck ^_^
Welcome to my forum!!
http://wang5555.hopto.org/phpBB3/
p.s. Shut down computer before 11 clock night!!!

Topic author
kolja
Active Member
Active Member
Posts: 29
Joined: 9. June 2010 16:44

Re: Can not install Topic Text in Mouseover for B3P

Post by kolja »

Great!

I will wait :roll:

Kolja

Return to “board3 Portal v1.0.x - Modifications”