Various modifications for phpBB3 ⇒ Mchat top poster

[dmzx]

Mchat top poster

this will show a users Mchat post count (Not forum post count)

Open mchat.php

Find This may be a partial find and not the whole line

Code: Select all

// Run code...
            if ($mchat_view)
            {

Add after Add these lines on a new blank line after the preceding line(s) to find

Code: Select all

$sql = 'SELECT m.user_id, COUNT(m.message_id) AS post_count, u.username, u.user_colour
                    FROM ' . MCHAT_TABLE . ' m
                        LEFT JOIN ' . USERS_TABLE . ' u ON (m.user_id = u.user_id)
                        GROUP BY u.user_id ORDER BY post_count DESC';
                $result = $db->sql_query_limit($sql, 10);

                while ($row = $db->sql_fetchrow($result))
                {   
                    $template->assign_block_vars('mchaters', array(
                        'USER_NAME'        => get_username_string('no_profile', $row['user_id'], $row['username'], $row['user_colour']) . ' (' . $row['post_count'] . ')',
                    ));
                }
                $db->sql_freeresult($result);

Open language/en/mods/mchat_lang.php

Find This may be a partial find and not the whole line

Code: Select all

'MCHAT_SMILES'                => 'Smilies',

Add after Add these lines on a new blank line after the preceding line(s) to find

Code: Select all

'MCHAT_TOP_POSTERS'            => 'Top Posters',

Open styles/your style/template/mchat_body.html

Find This may be a partial find and not the whole line

Code: Select all

<div style="text-align:center;">{L_MCHAT_COPYRIGHT}</div>

Add after Add these lines on a new blank line after the preceding line(s) to find

Code: Select all

<!-- IF .mchaters --><p><strong>{L_MCHAT_TOP_POSTERS}</strong><br/>
             <!-- BEGIN mchaters -->{mchaters.USER_NAME} <!-- IF not mchaters.S_LAST_ROW -->,<!-- ENDIF --><!-- END mchaters --></p><!-- ENDIF -->

[Napster]

Hi, would love this but these edits are different on the new mchat extension is it possible to show me where new edits go please.

[Sniper_E]

The edits in the extension are close to the same.

Instead of editing the mchat.php you will edit the core/render_helper.php.

Open core/render_helper.php

Find This may be a partial find and not the whole line [ line 1080 ]

Code: Select all

				// Run code...
				if ($mchat_view)
				{

Add after Add these lines on a new blank line after the preceding line(s) to find

Code: Select all

				$sql = 'SELECT m.user_id, COUNT(m.message_id) AS post_count, u.username, u.user_colour
                    FROM ' . $this->mchat_table . ' m
                        LEFT JOIN ' . USERS_TABLE . ' u ON (m.user_id = u.user_id)
                        GROUP BY u.user_id ORDER BY post_count DESC';
                $result = $this->db->sql_query_limit($sql, 10);

                while ($row = $this->db->sql_fetchrow($result))
                {   
                    $this->template->assign_block_vars('mchaters', array(
                        'USER_NAME'        => get_username_string('no_profile', $row['user_id'], $row['username'], $row['user_colour']) . ' (' . $row['post_count'] . ')',
                    ));
                }
                $this->db->sql_freeresult($result);

And the edit to the mchat_body.html has a different Find.

Open styles/prosilver/template/mchat_body.html

Find This may be a partial find and not the whole line [ line 1080 ]

Code: Select all

				{L_MCHAT_COPYRIGHT}

Add after Add these lines on a new blank line after the preceding line(s) to find

Code: Select all

				<!-- IF .mchaters --><p><strong>{L_MCHAT_TOP_POSTERS}</strong><br/>
				<!-- BEGIN mchaters -->{mchaters.USER_NAME} <!-- IF not mchaters.S_LAST_ROW -->,<!-- ENDIF --><!-- END mchaters --></p><!-- ENDIF -->

The language file edit is the same.

Open language/en/common.php

Find This may be a partial find and not the whole line [ line 1080 ]

Code: Select all

	//Custom edits
	'REPLY_WITH_LIKE'	=>'Like This Post',

Add after Add these lines on a new blank line after the preceding line(s) to find

Code: Select all

					'MCHAT_TOP_POSTERS'	=> 'Top Posters',

[Napster]

Thank you

[alfi0815]

Hello,
and for mchat 1.0.0 RC1???

[dmzx]

Hello,
and for mchat 1.0.0 RC1???

There is in this section

[killfrenzy]

The edits in the extension are close to the same.

Instead of editing the mchat.php you will edit the core/render_helper.php.

Open core/render_helper.php

Find This may be a partial find and not the whole line [ line 1080 ]

Code: Select all

				// Run code...
				if ($mchat_view)
				{

Add after Add these lines on a new blank line after the preceding line(s) to find

Code: Select all

				$sql = 'SELECT m.user_id, COUNT(m.message_id) AS post_count, u.username, u.user_colour
                    FROM ' . $this->mchat_table . ' m
                        LEFT JOIN ' . USERS_TABLE . ' u ON (m.user_id = u.user_id)
                        GROUP BY u.user_id ORDER BY post_count DESC';
                $result = $this->db->sql_query_limit($sql, 10);

                while ($row = $this->db->sql_fetchrow($result))
                {   
                    $this->template->assign_block_vars('mchaters', array(
                        'USER_NAME'        => get_username_string('no_profile', $row['user_id'], $row['username'], $row['user_colour']) . ' (' . $row['post_count'] . ')',
                    ));
                }
                $this->db->sql_freeresult($result);

And the edit to the mchat_body.html has a different Find.

Open styles/prosilver/template/mchat_body.html

Find This may be a partial find and not the whole line [ line 1080 ]

Code: Select all

				{L_MCHAT_COPYRIGHT}

Add after Add these lines on a new blank line after the preceding line(s) to find

Code: Select all

				<!-- IF .mchaters --><p><strong>{L_MCHAT_TOP_POSTERS}</strong><br/>
				<!-- BEGIN mchaters -->{mchaters.USER_NAME} <!-- IF not mchaters.S_LAST_ROW -->,<!-- ENDIF --><!-- END mchaters --></p><!-- ENDIF -->

The language file edit is the same.

Open language/en/common.php

Find This may be a partial find and not the whole line [ line 1080 ]

Code: Select all

	//Custom edits
	'REPLY_WITH_LIKE'	=>'Like This Post',

Add after Add these lines on a new blank line after the preceding line(s) to find

Code: Select all

					'MCHAT_TOP_POSTERS'	=> 'Top Posters',

What version of mchat is this? I can't find render_helper.php in core folder. I'm using mchat 3.4

[dmzx]

Instead of editing the mchat.php you will edit the core/render_helper.php.

The latest version dont use render_helper no more.
There is now an extension for this (addon) to add the Top Poster, no need to edit anything no more.

[killfrenzy]

Instead of editing the mchat.php you will edit the core/render_helper.php.

The latest version dont use render_helper no more.
There is now an extension for this (addon) to add the Top Poster, no need to edit anything no more.

This is for donators only latest version of mchat?

[dmzx]

There is an extension in VIP indeed.

[sindyciaray]

Seems like the real post here cheers I PROMISE I WONT POST BS LINKS TO FAT SITES NO MORE

edited by martin

[dmzx]

Seems like the real post here cheers I PROMISE I WONT POST BS LINKS TO FAT SITES NO MORE

edited by martin

Martin