Page 80 of 80

Re: mChat new version

Posted: Fri May 07, 2010 10:13 pm
by 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]

Re: mChat new version

Posted: Fri May 07, 2010 10:18 pm
by 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

Re: mChat new version

Posted: Fri May 07, 2010 10:36 pm
by 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.

Re: mChat new version

Posted: Fri May 07, 2010 10:41 pm
by Dragoth
alright RMcGirr83 you rock it work perfect

Re: mChat new version

Posted: Fri May 07, 2010 10:48 pm
by RMcGirr83
:D

Re: mChat new version

Posted: Sat May 08, 2010 12:36 am
by 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

Re: phpBB mChat

Posted: Mon Dec 06, 2010 10:19 am
by Paul
MOD Updated to version 1.3.4
See first post for Download Link

Re: phpBB mChat

Posted: Sat Feb 26, 2011 9:10 pm
by Paul
MOD Updated to version 1.3.5
See first post for Download Link

Re: phpBB mChat

Posted: Thu Oct 24, 2013 7:38 am
by Marc
MOD Updated to version 1.3.6
See first post for Download Link

Re: phpBB mChat

Posted: Sun Dec 29, 2013 2:46 am
by DavidIQ
MOD Updated to version 1.3.7
See first post for Download Link

Re: phpBB mChat

Posted: Tue Mar 11, 2014 10:17 pm
by Marc
MOD Updated to version 1.3.8
See first post for Download Link