phpBB mChat

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
Locked
pdpower
Registered User
Posts: 21
Joined: Fri Jun 26, 2009 11:44 am

Re: mChat new version

Post by pdpower »

Well, i solved the SQL statments errors, but still get that 'fart' sound every 10 seconds and messages are not refreshed.
Any help would be welcome!!!

Thanks guys
Forgereth
Registered User
Posts: 2
Joined: Wed Mar 24, 2010 12:31 pm
Name: Erik Douglas

Re: mChat new version

Post by Forgereth »

some issues with mchta.php file, running over one MSSQL Server Database.

Find this, its near line 260

Code: Select all

$sql = 'SELECT m.*, u.username, u.user_colour, u.user_id as userid
					FROM (' . MCHAT_TABLE . ' m, ' . USERS_TABLE . ' u)
						WHERE m.user_id = u.user_id
							AND m.message_id > ' . $mchat_message_last_id . '
				ORDER BY m.message_id DESC';	
and replace for this

Code: Select all

$sql = 'SELECT m.*, u.username, u.user_colour, u.user_id as userid
					FROM ' . MCHAT_TABLE . ' m, ' . USERS_TABLE . ' u
						WHERE m.user_id = u.user_id
							AND m.message_id > ' . $mchat_message_last_id . '
				ORDER BY m.message_id DESC';	
it will make the autorefresh/ajax/mchat file works
pdpower
Registered User
Posts: 21
Joined: Fri Jun 26, 2009 11:44 am

Re: mChat new version

Post by pdpower »

Forgereth wrote:some issues with mchta.php file, running over one MSSQL Server Database.

Find this, its near line 260

Code: Select all

$sql = 'SELECT m.*, u.username, u.user_colour, u.user_id as userid
					FROM (' . MCHAT_TABLE . ' m, ' . USERS_TABLE . ' u)
						WHERE m.user_id = u.user_id
							AND m.message_id > ' . $mchat_message_last_id . '
				ORDER BY m.message_id DESC';	
and replace for this

Code: Select all

$sql = 'SELECT m.*, u.username, u.user_colour, u.user_id as userid
					FROM ' . MCHAT_TABLE . ' m, ' . USERS_TABLE . ' u
						WHERE m.user_id = u.user_id
							AND m.message_id > ' . $mchat_message_last_id . '
				ORDER BY m.message_id DESC';	
it will make the autorefresh/ajax/mchat file works
Thanks!!!
Got it working now.
Litto
Registered User
Posts: 11
Joined: Sat Nov 14, 2009 2:49 am

Re: mChat new version

Post by Litto »

Hi, I have a question. This Mod works with Suubsilver2 based template?

How to intall it, thanks.
Gadget27
Registered User
Posts: 22
Joined: Mon May 18, 2009 8:53 am
Location: France (Eure)
Contact:

Re: mChat new version

Post by Gadget27 »

Litto wrote:Hi, I have a question. This Mod works with Suubsilver2 based template?

How to intall it, thanks.
In contrib repertory of mod you have the subsilver2 install ;)
I learn english with phpbb.com :)
User avatar
sam_8085
Registered User
Posts: 93
Joined: Wed Mar 25, 2009 4:28 am

Re: mChat new version

Post by sam_8085 »

kber wrote:
sam_8085 wrote:Hey stoker thanks for mChat newer verion

I use phpBB 3.0.7 PL1

I tried to install this mod, I did all the modification required. but the last change in overall_header.html

I'm not able to find where this line exists

Code: Select all

<li class="icon-faq"><a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a></li>
Can I find a solution for this ? Thanks in advance...
what is your style based on ?

Its based on Prosilver (Absolution)
Gadget27
Registered User
Posts: 22
Joined: Mon May 18, 2009 8:53 am
Location: France (Eure)
Contact:

Re: mChat new version

Post by Gadget27 »

@ sam_8085

Find:

Code: Select all

<img src="{T_THEME_PATH}/images/help.png" width="16" height="16" alt="" /> <a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a>
in place of :

Code: Select all

<li class="icon-faq"><a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a></li>
This part of instructions is just to make a link for mchat page (not very important)
I learn english with phpbb.com :)
User avatar
sam_8085
Registered User
Posts: 93
Joined: Wed Mar 25, 2009 4:28 am

Re: mChat new version

Post by sam_8085 »

Ok I will give a try !!
Litto
Registered User
Posts: 11
Joined: Sat Nov 14, 2009 2:49 am

Re: mChat new version

Post by Litto »

It seems like everything is fine with the mChat, but i cant see it on the board index.. I did all the instructions..

What happen if i use the Uninstall?

Thanks
__________________

I uninstall and install it again, but I cant see it on my index.. Could someone tell me which could be the error?

Thanks again.
User avatar
RMcGirr83
Former Team Member
Posts: 22016
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: mChat new version

Post by RMcGirr83 »

Check the settings in the ACP and you will have to apply the edits to the html files for your style if it is not prosilver or subsilver2.
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beer Image
User avatar
sam_8085
Registered User
Posts: 93
Joined: Wed Mar 25, 2009 4:28 am

Re: mChat new version

Post by sam_8085 »

Gadget27 wrote:@ sam_8085

Find:

Code: Select all

<img src="{T_THEME_PATH}/images/help.png" width="16" height="16" alt="" /> <a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a>
in place of :

Code: Select all

<li class="icon-faq"><a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a></li>
This part of instructions is just to make a link for mchat page (not very important)
I did it, every thing is ok but look at this
3-30-2010 2-12-54 PM.png
3-30-2010 2-12-54 PM.png (5.61 KiB) Viewed 577 times
and here is the code

Code: Select all

        <div class="toolbar-right">
	        <img src="{T_THEME_PATH}/images/help.png" width="16" height="16" alt="" /> <a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a>
			<!-- IF S_MCHAT_ENABLE and U_MCHAT --><li class="icon-bump"><a href="{U_MCHAT}" title="{L_MCHAT}">{L_MCHAT}</a></li><!-- ENDIF -->
            <!-- IF S_DISPLAY_MEMBERLIST --><img src="{T_THEME_PATH}/images/group.png" width="16" height="16" alt="" /> <a href="{U_MEMBERLIST}" title="{L_MEMBERLIST_EXPLAIN}">{L_MEMBERLIST}</a><!-- ENDIF -->
            <!-- IF S_DISPLAY_SEARCH and not S_USER_LOGGED_IN --><img src="{T_THEME_PATH}/images/magnifier.png" width="16" height="16" alt="" /> <a href="{U_SEARCH}" title="{L_SEARCH}">{L_SEARCH}</a><!-- ENDIF --> 
            <!-- IF not S_USER_LOGGED_IN and S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) --><img src="{T_THEME_PATH}/images/add.png" width="16" height="16" alt="" /> <a href="{U_REGISTER}">{L_REGISTER}</a><!-- ENDIF -->
            <img src="{T_THEME_PATH}/images/<!-- IF not S_USER_LOGGED_IN -->key<!-- ELSE -->disconnect<!-- ENDIF -->.png" width="16" height="16" alt="" /> <a href="{U_LOGIN_LOGOUT}" title="{L_LOGIN_LOGOUT}" accesskey="x"<!-- IF S_USER_LOGGED_IN --> onclick="return logout_confirmation();"<!-- ENDIF -->>{L_LOGIN_LOGOUT}</a>
        </div><!-- /toolbar-right -->
    </div><!-- /toolbar -->
Please help me to come out of this !!!
User avatar
RMcGirr83
Former Team Member
Posts: 22016
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: mChat new version

Post by RMcGirr83 »

Try

Code: Select all

       <div class="toolbar-right">
           <img src="{T_THEME_PATH}/images/help.png" width="16" height="16" alt="" /> <a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a>
         <!-- IF S_MCHAT_ENABLE and U_MCHAT --><img src="{T_THEME_PATH}/images/icon_members.gif" width="16" height="16" alt="" /><a href="{U_MCHAT}" title="{L_MCHAT}">{L_MCHAT}</a><!-- ENDIF -->
            <!-- IF S_DISPLAY_MEMBERLIST --><img src="{T_THEME_PATH}/images/group.png" width="16" height="16" alt="" /> <a href="{U_MEMBERLIST}" title="{L_MEMBERLIST_EXPLAIN}">{L_MEMBERLIST}</a><!-- ENDIF -->
            <!-- IF S_DISPLAY_SEARCH and not S_USER_LOGGED_IN --><img src="{T_THEME_PATH}/images/magnifier.png" width="16" height="16" alt="" /> <a href="{U_SEARCH}" title="{L_SEARCH}">{L_SEARCH}</a><!-- ENDIF --> 
            <!-- IF not S_USER_LOGGED_IN and S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) --><img src="{T_THEME_PATH}/images/add.png" width="16" height="16" alt="" /> <a href="{U_REGISTER}">{L_REGISTER}</a><!-- ENDIF -->
            <img src="{T_THEME_PATH}/images/<!-- IF not S_USER_LOGGED_IN -->key<!-- ELSE -->disconnect<!-- ENDIF -->.png" width="16" height="16" alt="" /> <a href="{U_LOGIN_LOGOUT}" title="{L_LOGIN_LOGOUT}" accesskey="x"<!-- IF S_USER_LOGGED_IN --> onclick="return logout_confirmation();"<!-- ENDIF -->>{L_LOGIN_LOGOUT}</a>
        </div><!-- /toolbar-right -->
    </div><!-- /toolbar -->
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beer Image
User avatar
sam_8085
Registered User
Posts: 93
Joined: Wed Mar 25, 2009 4:28 am

Re: mChat new version

Post by sam_8085 »

Works Perfect, thaks alot !!
Litto
Registered User
Posts: 11
Joined: Sat Nov 14, 2009 2:49 am

Re: mChat new version

Post by Litto »

RMcGirr83 wrote:Check the settings in the ACP and you will have to apply the edits to the html files for your style if it is not prosilver or subsilver2.
I think i have done that. :/

I'm Using WoW MoonClaw style.
Litto
Registered User
Posts: 11
Joined: Sat Nov 14, 2009 2:49 am

Re: mChat new version

Post by Litto »

Done, I installed the mChat..

Thanks for the support, and thanks for sharing this mod! :)
Last edited by Litto on Tue Mar 30, 2010 3:14 pm, edited 1 time in total.
Locked

Return to “[3.0.x] MOD Database Releases”