cBB Chat 1.1.0 - Forum topics in the chat

When you enable show new forum topics in chat, you get this:
New topic: topic title (with link to that new topic)

Is it possible to do it like this?
New topic: topic title (with link to that new topic) in forum titel (with link to that forum)
New reply: topic title (with link to that reply) in forum (with link to that forum)

[IvanPF]

New topic: topic title (with link to that new topic) in forum titel (with link to that forum)

This is possible, you need to do this changes:

1. Open /ext/canidev/chat/chat_ajax.php
2. Find:

Code: Select all

               $sql = 'SELECT topic_id, forum_id, topic_title, topic_time, topic_visibility, topic_first_post_id,
                  topic_poster AS poster_id, topic_first_poster_name AS poster_username
                  FROM ' . TOPICS_TABLE . "
                  WHERE topic_time > $last_update
                  ORDER BY topic_time DESC";

3.Replace with:

Code: Select all

               $sql = 'SELECT t.topic_id, t.forum_id, t.topic_title, t.topic_time, t.topic_visibility, t.topic_first_post_id,
                  t.topic_poster AS poster_id, t.topic_first_poster_name AS poster_username, f.forum_name
                  FROM ' . TOPICS_TABLE . ' t
                     LEFT JOIN ' . FORUMS_TABLE . " f ON(f.forum_id = t.forum_id)
                  WHERE topic_time > $last_update
                  ORDER BY topic_time DESC";

4. Find:

Code: Select all

                     $ary += array(
                        'IS_TOPIC'         => true,
                        'TOPIC_TITLE'      => censor_text($row['topic_title']),
                        'S_DATE'         => $this->user->format_date($row['topic_time']),
                        
                        'U_TOPIC'         => append_sid($this->root_path . 'viewtopic.' . $this->php_ext . '?f=' . $row['forum_id'] . '&t=' . $row['topic_id']),
                        'U_TOPIC_EDIT'      => ($edit_allowed) ? append_sid($this->root_path . 'posting.' . $this->php_ext, 'mode=edit&f=' . $row['forum_id'] . '&p=' . $row['topic_first_post_id']) : '',
                     );

5.Replace with:

Code: Select all

                     $ary += array(
                        'IS_TOPIC'         => true,
                        'FORUM_NAME'      => $row['forum_name'],
                        'TOPIC_TITLE'      => censor_text($row['topic_title']),
                        'S_DATE'         => $this->user->format_date($row['topic_time']),
                        
                        'U_FORUM'         => append_sid($this->root_path . 'viewforum.' . $this->php_ext . '?f=' . $row['forum_id']),
                        'U_TOPIC'         => append_sid($this->root_path . 'viewtopic.' . $this->php_ext . '?f=' . $row['forum_id'] . '&t=' . $row['topic_id']),
                        'U_TOPIC_EDIT'      => ($edit_allowed) ? append_sid($this->root_path . 'posting.' . $this->php_ext, 'mode=edit&f=' . $row['forum_id'] . '&p=' . $row['topic_first_post_id']) : '',
                     );

6. Open /ext/canidev/chat/styles/{your style or prosilver}/template/chat_ajax.html
7. Find:

Code: Select all

<strong>{L_NEW_TOPIC}:</strong> <a href="{message.U_TOPIC}">{message.TOPIC_TITLE}</a>

8. Add after:

Code: Select all

{L_IN} <a href="{message.U_FORUM}">{message.FORUM_NAME}</a>

9. Go to ACP > General and Purge the cache.

New reply: topic title (with link to that reply) in forum (with link to that forum)

In teory, this is possible, but it would consume many resources in forums with a lot of movement.

New topic: topic title (with link to that new topic) in forum titel (with link to that forum)

Just tested and it's working fine

New reply: topic title (with link to that reply) in forum (with link to that forum)

In teory, this is possible, but it would consume many resources in forums with a lot of movement.

I know, but i like to use this on my forum.
I think the query can be easy made so thet every New Post (with a link to New Post) comes in the chat instead of splitting New Topic or New Reply like i asked in my first post.
So will you write this query to do that please? And also change this 2 arrays conform the query?

Code: Select all

'U_TOPIC'         => append_sid($this->root_path . 'viewtopic.' . $this->php_ext . '?f=' . $row['forum_id'] . '&t=' . $row['topic_id']),
                        'U_TOPIC_EDIT'      => ($edit_allowed) ? append_sid($this->root_path . 'posting.' . $this->php_ext, 'mode=edit&f=' . $row['forum_id'] . '&p=' . $row['topic_first_post_id']) : '',

Thank you very much