Help on flags mod

[FragaCampos]

Hello there.
Dunno if this is the right place to ask, but i hope it's ok 

Can anyone check if this mod can be modified to had a column in the memberlist with the flag of each member? Does anyone knows if this is "easy" to implement?

Thanks anyhow.

[D M G]

The memberlist is a real pain to mess with!

[[SiNaN]]

Memberlist.php

Find:

Code Select Expand

'posts' => array(

Replace:

Code Select Expand

'country' => array(
'label' => 'Country'
),
'posts' => array(

This will add the column to the template.

Memberlist.template.php

Find:

Code Select Expand

// Assuming there are members loop through each one displaying their data.

Replace:

Code Select Expand

$flags = CountryFlag();

// Assuming there are members loop through each one displaying their data.

This will load all the flags and their information.

Find:

Code Select Expand

<td class="windowbg2" width="15">', $member['posts'], '</td>

Replace:

Code Select Expand

<td class="windowbg2" width="15">', $member['posts'], '</td>
<td class="windowbg2" width="15">', !empty($member['options']['country']) ? '<img src="' . $settings['default_theme_url'] . '/images/flags/' . $member['options']['country'] . '.png" alt="' . $flags[$member['options']['country']] . '" />' : '', '</td>

This will output the info for every user.

Find:

Code Select Expand

<td colspan="12">';

Replace:

Code Select Expand

<td colspan="13">';

Find:

Code Select Expand

<td colspan="12" class="', empty($settings['use_tabs']) ? 'catbg' : 'titlebg', '">';

Replace:

Code Select Expand

<td colspan="13" class="', empty($settings['use_tabs']) ? 'catbg' : 'titlebg', '">';

Find:

Code Select Expand

<td colspan="12" class="windowbg">', $txt[170], '</td>

Replace:

Code Select Expand

<td colspan="13" class="windowbg">', $txt[170], '</td>

Find:

Code Select Expand

<td class="titlebg" colspan="12">', $txt[139], ': ', $context['page_index'], '</td>

Replace:

Code Select Expand

<td class="titlebg" colspan="13">', $txt[139], ': ', $context['page_index'], '</td>

Above are the template colspan fixes.

[FragaCampos]

First of all, thank you very much for helping on this 

I made all the changes and it works, but with a minor problem. As you can see in the screenshot, the columns "country" and "posts" are switched. Help? 

[[SiNaN]]

Sorry.

Now,

MemberList.template.php

Find:

Code Select Expand

         <td class="windowbg2" width="15">', $member['posts'], '</td>
         <td class="windowbg2" width="15">', !empty($member['options']['country']) ? '<img src="' . $settings['default_theme_url'] . '/images/flags/' . $member['options']['country'] . '.png" alt="' . $flags[$member['options']['country']] . '" />' : '', '</td>

Replace:

Code Select Expand

         <td class="windowbg2" width="15">', !empty($member['options']['country']) ? '<img src="' . $settings['default_theme_url'] . '/images/flags/' . $member['options']['country'] . '.png" alt="' . $flags[$member['options']['country']] . '" />' : '', '</td>
         <td class="windowbg2" width="15">', $member['posts'], '</td>

[FragaCampos]

Thanks a million [SiNaN]. For your help and readiness.
I'lll share this piece of code of yours in the mod section.

[CraigPal]

Thanks bunches!

The only problem I have is that I get an error when trying to sort by country:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 50' at line 5
File: /home1/rawpaleo/public_html/Sources/Memberlist.php
Line: 345

Craig

_________________
Raw Paleolithic Diet

[FragaCampos]

It's true, i didn't notice that...

[[SiNaN]]

Missed that, sorry.

Memberlist.php

Find:

Code Select Expand

'posts' => array(
'down' => 'mem.posts DESC',

Replace:

Code Select Expand

'country' => array(
'down' => 'ISNULL(tc.value) ASC, tc.value ASC',
'up' => 'ISNULL(tc.value) DESC, tc.value DESC'
),
'posts' => array(
'down' => 'mem.posts DESC',

Find:

Code Select Expand

LEFT JOIN {$db_prefix}membergroups AS mg ON (mg.ID_GROUP = IF(mem.ID_GROUP = 0, mem.ID_POST_GROUP, mem.ID_GROUP))" : '') . "

Replace:

Code Select Expand

LEFT JOIN {$db_prefix}membergroups AS mg ON (mg.ID_GROUP = IF(mem.ID_GROUP = 0, mem.ID_POST_GROUP, mem.ID_GROUP))" : '') . ($_REQUEST['sort'] === 'country' ? "
LEFT JOIN {$db_prefix}themes AS tc ON (tc.ID_MEMBER = mem.ID_MEMBER AND tc.variable = 'country')" : '') . "

[FragaCampos]

Works great, thanks once more [SiNaN]!

PS: Hope that depression goes away soon...

[Andrijachi]

Thanks for this ... working perfectly!