phpBB mChat

[RMcGirr83]

You can try this which should display a message in the chat

OPEN

mchat.php

FIND

Code: Select all

				// Run cleaner
				$sql = 'TRUNCATE TABLE ' . MCHAT_TABLE;
				$db->sql_query($sql);

AFTER ADD

Code: Select all

				$message = 'Messages have been pruned';
				
				// Add function part code from http://wiki.phpbb.com/Parsing_text
				$uid = $bitfield = $options = ''; // will be modified by generate_text_for_storage
				generate_text_for_storage($message, $uid, $bitfield, $options, $mchat_allow_bbcode, $mchat_urls, $mchat_smilies);				

				// message stating who cleared chat
				$sql_ary = array(	
					'user_id'			=> $user->data['user_id'],
					'user_ip'			=> $user->data['session_ip'],
					'message' 			=> $message,
					'bbcode_bitfield'	=> $bitfield,
					'bbcode_uid'		=> $uid,
					'bbcode_options'	=> $options,
					'message_time'		=> time()
				);
				$sql = 'INSERT INTO ' . MCHAT_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
				$db->sql_query($sql);

I haven't tested it though so user beware. Make a backup of your file first.

[EDIT]Removed forum_id and post_id[/EDIT]

[Dragoth]

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'forum_id' in 'field list' [1054]

SQL

INSERT INTO phpbb_mchat (forum_id, post_id, user_id, user_ip, message, bbcode_bitfield, bbcode_uid, bbcode_options, message_time) VALUES (0, 0, '2', '99.108.180.160', 'Messages have been pruned', '', '', 7, 1273270646)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: mchat.php
LINE: 149
CALL: dbal_mysql->sql_query()

thats what come up when you clear chat

[RMcGirr83]

Remove these two entries.

Code: Select all

              'forum_id'          => 0,
               'post_id'         => 0,      

the forum_id and post_id are for the new topic add-on.

[Dragoth]

alright RMcGirr83 you rock it work perfect

[RMcGirr83]

[Patriotqube]

Hey

i just installed your mchat mod and it seems to work nicely

thx

i do have a small question tho
im using customstyles and it seems to me that the mchatbody is prosilver, is there a way to make it blend better in to my style?

link --> http://et.qubenet.net/index.php

also im not sure what it is but when i tries to admin my users now i get this error

Code: Select all

Parse error: syntax error, unexpected ';', expecting ')' in /opt/games/et.qubenet.net/forum/includes/acp/acp_users.php on line 1524

but i didnt touch that file so im like lost.
hope someone can help

[Paul]

MOD Updated to version 1.3.4
See first post for Download Link

[Paul]

MOD Updated to version 1.3.5
See first post for Download Link

[Marc]

MOD Updated to version 1.3.6
See first post for Download Link

[DavidIQ]

MOD Updated to version 1.3.7
See first post for Download Link

[Marc]

MOD Updated to version 1.3.8
See first post for Download Link