[BETA] AJAX Chat MOD

[Gonculator]

MOD Title: AJAX Chat MOD
MOD Author: Handyman
MOD Description: This MOD adds a community chat area to your forum.
This chat is AJAX based, so new posts will display automatically without a page refresh.
New posts will show up every 5 seconds if you're actively chatting in the chat area. If you're idle (haven't posted in 5 minutes) new posts will show up every 15 seconds and if you've been idle 15 minutes or more, new posts will show up every 60 seconds.

This version of the AJAX chat has been updated by Lostmind with changes for phpBB 3.0.6.
Lostmind also added instructions for subsilver2 and improved the explanation of the database installation to hopefully make it easier to understand.
MOD Version: 2.0.0B9
MOD Status: BETA

Tested on phpBB version: 3.0.6
Released: 10 Dec 2009

Installation Level: easy
Installation Time: ~ 3 Minutes
MOD FAQ: View Frequently Asked Question(s)

Demo: Click here to visit the demo website

This is an automated message posted by STG’s MOD Manager version 0.2.0

[Handyman]

To automatically prune chat messages older than what you can see in teh chatbox (to keep the db clear)

open chat.php

Find

Code: Select all

$sql = 'SELECT * FROM ' . CHAT_TABLE . ' ORDER BY message_id DESC';
        $result = $db->sql_query_limit($sql, 25);
        $rows = $db->sql_fetchrowset($result);

        foreach ($rows as $row)
        {
            if ($count++ == 0)
            {
                $last_id = $row['message_id'];
            }
            $template->assign_block_vars('chatrow', array(
                'MESSAGE_ID'    => $row['message_id'],
                'USERNAME_FULL'    => clean_username(get_username_string('full', $row['user_id'], $row['username'], $row['user_colour'], $user->lang['GUEST'])),
                'MESSAGE'        => generate_text_for_display($row['message'], $row['bbcode_uid'], $row['bbcode_bitfield'], $row['bbcode_options']),
                'TIME'            => $user->format_date($row['time']),
                'CLASS'            => ($row['message_id'] % 2) ? 1 : 2,
            ));
        }
        $db->sql_freeresult($result);   

Replace with

Code: Select all

$sql = 'SELECT * FROM ' . CHAT_TABLE . ' ORDER BY message_id DESC';
        $result = $db->sql_query_limit($sql, 25);
        $rows = $db->sql_fetchrowset($result);
        $db->sql_freeresult($result);

        $delete_id = 0;
        foreach ($rows as $row)
        {
            if ($count++ == 0)
            {
                $last_id = $row['message_id'];
            }
            $template->assign_block_vars('chatrow', array(
                'MESSAGE_ID'    => $row['message_id'],
                'USERNAME_FULL'    => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour'], $user->lang['GUEST']),
                'MESSAGE'        => generate_text_for_display($row['message'], $row['bbcode_uid'], $row['bbcode_bitfield'], $row['bbcode_options']),
                'TIME'            => $user->format_date($row['time']),
                'CLASS'            => ($row['message_id'] % 2) ? 1 : 2,
            ));
            $delete_id = $row['message_id'];
        }
        
        $sql = 'DELETE FROM ' . CHAT_TABLE . '
            WHERE message_id < ' . $delete_id;
        $db->sql_query($sql);   

That will then delete all messages older than the last one displayed in the chat and will also only delete when you first view the chat.

Chat archive page, by nicholasalipaz

note: I have not personally checked this file and I don't know much about it currently.
This is posted as a for the benefit of everybody who's asking for one and since Nicholas was nice enough to make one, here it is :)
Good luck with it :good:
Nicholas should be around if you have any questions about it.

chat_archive.zip

[noumanrafi nomi]

i am really tired to get the way of installing AJAX CHAT.

please guys, at least make a topic of AJAX INSTALLATION or guide me how to install AJAX CHAT on phpbb3.0.3

I don't see install directions for subsilver2.

[Sniper_E]

The install directions came with the download.
Open the install.xml file with your web browser and follow all of the install directions.

Hey Creeper they are the same as for prosilver. There is a directory called prosilver and another directory called subSilver.

The files in the prosilver directory get copied over into your prosilver type style.
The files in the subSilver directory get copied over into your subsilver2 type style the same way.

If it says Open: styles/prosilver/template/overall_header.html then you Open: styles/subsilver2/template/overall_header.html
And Copy: root/styles/prosilver/imageset/* To: styles/prosilver/imageset/*
Means Copy: root/styles/subSilver/imageset/* To: styles/subsilver2/imageset/*
It installs the same way for both types of styles. The header link added could be slightly different for a lot of fancy styles.

[Cr33per]

I cant find any of the line in overall_header in subsilver2

Code: Select all

<a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}" class="icon-faq">{L_FAQ}</a>

Edit: Okl I see that its not needed for my style. Is there anyway possible I could get the code changes in chat_body that STG uses for BF_Vista.

[aikowolf Patrick]

is there any other useful information in the installation pack beside installing?

i.e. is there a way to check the history?
can you delete messages you find off base or rude/
etc, etc.

thanks!

[Cr33per]

Works good except in Firefox I can't see the delete post img for admins.
I can see them in E7 except they look like errors.
Other then that I like it.

[Paladin]

Can someone guide me on how to implement this on the header and/or footer of my main forum site please?
What do I need to add and where? The css and files of the phpBB3 are quite different from the phpBB2 I was using till 2 days ago

Also, when i type in Greek and press enter nothing happens. It does not support or recognize or do anything when a different lang than English is typed. Is there a codepage I can change somewhere and let it type Greek?

Other than that, it's an EXCELLENT addition! Thank you

[MuleMarine]

I too am a bit frustrated. When the install says to "Copy: root/chat.php
To: chat.php", does that mean create a new folder and name it "chat.php"? And do I install this inside my phpbb3 folder or outside of it? Thanks.

[Cr33per]

I too am a bit frustrated. When the install says to "Copy: root/chat.php
To: chat.php", does that mean create a new folder and name it "chat.php"? And do I install this inside my phpbb3 folder or outside of it? Thanks.

Root means the folder directory of your forums.

How do I get the online list on the left side like here on STG? If I get no answer that's fine I can live with it like this.
http://www.clan33.net/forums/chat.php