Excluding one member group from...

[Uhura!]

I did not understand this

Replace 1 in the $exculde_from_top array with the group id(s) you have, separated by comma.

Can you clarify?

Thanks!

[Joker™]

Code Select Expand

[code$exculde_from_top = array('staff1 group id', 'staff2 group id');

'1' represents admin group .

[Uhura!]

Crazy question. Where can I see a group's ID?

[Joker™]

Crazy question. Where can I see a group's ID?

Administration Center » Membergroups » Edit Membergroups

Click on each member group who's id is required. See the url and number after 'group=' in the url represents the group id.

Easy way use this

[Uhura!]

Crazy question. Where can I see a group's ID?

Administration Center » Membergroups » Edit Membergroups

Click on each member group who's id is required. See the url and number after 'group=' in the url represents the group id.

Easy way use this

Hi,

The part in red is where I get lost.

[Joker™]

Please read the description of the mod. It'll help you to understand what I'm trying to say.

[Hj Ahmad Rasyid Hj Ismail]

Nice modification Joker.

[Uhura!]

Please read the description of the mod. It'll help you to understand what I'm trying to say.

I see the problem now...

I have no "ID" Column... See the attachment. But... I saw the group # in the link when I hit "modify"... Group 2!

So - I will try this now

[Uhura!]

Do I need to correct exculde to be exclude?

[Uhura!]

Error:
An Error Has Occurred!
Unknown column 'm.id_group' in 'where clause'
File: /home/ourmo0/public_html/community/Sources/PortalBlocks.php
Line: 494

[Joker™]

I see the problem now...

I have no "ID" Column... See the attachment. But... I saw the group # in the link when I hit "modify"... Group 2!

So - I will try this now

It's not a default SMF feature. For that only I've created the above mentioned mod.

Error:
An Error Has Occurred!
Unknown column 'm.id_group' in 'where clause'
File: /home/ourmo0/public_html/community/Sources/PortalBlocks.php
Line: 494

Grrr, this is what happens while working on multiple things


Make edits to following file(Make backup of file before editing)

Sources/PortalBocks.php

Code (Find this function:) Select Expand

sp_topPoster

Now in this function only make the following edits

Code (Find:) Select Expand

$type = !empty($parameters['type']) ? (int) $parameters['type'] : 0;

Code (Add after:) Select Expand

$exculde_from_top = array('1');

Code (Find:) Select Expand

$request = $smcFunc['db_query']('', '
SELECT
mem.id_member, mem.real_name, COUNT(*) as posts,
mem.avatar, a.id_attach, a.attachment_type, a.filename
FROM {db_prefix}messages AS m
LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
LEFT JOIN {db_prefix}attachments AS a ON (a.id_member = mem.id_member)
WHERE m.poster_time > {int:start_time}
AND m.id_member != 0
GROUP BY mem.id_member
ORDER BY posts DESC
LIMIT {int:limit}',
array(
'start_time' => $start_time,
'limit' => $limit,
)
);

Code (Replace it with:) Select Expand

$request = $smcFunc['db_query']('', '
SELECT
mem.id_member, mem.real_name, COUNT(*) as posts,
mem.avatar, a.id_attach, a.attachment_type, a.filename
FROM {db_prefix}messages AS m
LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
LEFT JOIN {db_prefix}attachments AS a ON (a.id_member = mem.id_member)
WHERE m.poster_time > {int:start_time}
AND m.id_member != 0
                AND mem.id_group NOT IN ({array_int:exculde_from_top})
GROUP BY mem.id_member
ORDER BY posts DESC
LIMIT {int:limit}',
array(
'start_time' => $start_time,
'limit' => $limit,
                'exculde_from_top' => $exculde_from_top,
)
);

Code (Find:) Select Expand

$request = $smcFunc['db_query']('','
SELECT
m.id_member, m.real_name, m.posts, m.avatar,
a.id_attach, a.attachment_type, a.filename
FROM {db_prefix}members AS m
LEFT JOIN {db_prefix}attachments AS a ON (a.id_member = m.id_member)
ORDER BY posts DESC
LIMIT {int:limit}',
array(
'limit' => $limit,
)
);

Code (Replace it with:) Select Expand

$request = $smcFunc['db_query']('','
SELECT
m.id_member, m.real_name, m.posts, m.avatar,
a.id_attach, a.attachment_type, a.filename
FROM {db_prefix}members AS m
LEFT JOIN {db_prefix}attachments AS a ON (a.id_member = m.id_member)
                WHERE m.id_group NOT IN ({array_int:exculde_from_top})
ORDER BY posts DESC
LIMIT {int:limit}',
array(
'limit' => $limit,
                'exculde_from_top' => $exculde_from_top,
)
);

Replace 1 in the $exculde_from_top array with the group id(s) you have, separated by comma.

[Uhura!]

Thanks!

Do I need to correct exculde to be exclude?

[Colin]

Unless you want to fix every instance of it.

[Kindred]

You should also note:   Support for and assistance with specific mods should be requested in the support thread for that individual mod.   Since this is a request for help with SimplePortal, it SHOULD have been posted in the SimplePortal support thread (or on the simpleportal support site), not in the main SMF support area.