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';
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';
Thanks!!!Forgereth wrote:some issues with mchta.php file, running over one MSSQL Server Database.
Find this, its near line 260and replace for thisCode: 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 worksCode: 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';
In contrib repertory of mod you have the subsilver2 installLitto wrote:Hi, I have a question. This Mod works with Suubsilver2 based template?
How to intall it, thanks.
kber wrote:what is your style based on ?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
Can I find a solution for this ? Thanks in advance...Code: Select all
<li class="icon-faq"><a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a></li>
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>
Code: Select all
<li class="icon-faq"><a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a></li>
I did it, every thing is ok but look at thisGadget27 wrote:@ sam_8085
Find:in place of :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>
This part of instructions is just to make a link for mchat page (not very important)Code: Select all
<li class="icon-faq"><a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a></li>
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 -->
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 -->
I think i have done that. :/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.