collapse

* Simple Portal Archived Forum

This is an Archive Forum.

The content in this forum may be out-of-date or have been superseded by newer information, and links in forum pages to other sites may not work.
This forum contains archives for future reference.

Visit our thread at Simple Machines Forum for current support.

SMF 2.1 users: EhPortal is a ported version of Simple Portal specifically designed for the SMF 2.1 branch.
Please visit web-develop.ca to download EhPortal and for its support.

* User Info

 
 
Welcome, Guest. Please login or register.

* Who's Online

  • Dot Guests: 522
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Shoutbox

Refresh History
  • Shoutbox is not for support!
  • {OCS}MasterSeal: Yup, Still adore SP
    April 21, 2019, 07:08:06 PM
  • {OCS}MasterSeal: STILL love SP :)
    November 24, 2018, 05:05:50 AM
  • ♦ Ninja ZX-10RR ♦: <3 aegersz
    September 13, 2018, 03:36:09 PM
  • aegersz: I STILL <3 LOVE SimplePortal
    September 13, 2018, 07:11:39 AM
  • aegersz: o LOVE you guys - Simple Portal rocks !
    May 09, 2018, 05:18:59 AM
  • Chen Zhen: our apologies for the site being down.. please read server issues topic
    March 22, 2018, 05:32:38 AM
  • {OCS}MasterSeal: LOL PLEASE forget I just posted that. I found the answer in my own dang post back in 2015. lol sorry!
    July 04, 2017, 10:47:55 PM
  • {OCS}MasterSeal: I know this SB isnt' for support, but I just have a general question. Who would I contact to find out where SP stores its block info? Is it DB driven or files? I searched the site but came up with nothing. probably my fault any insight is appreciated.
    July 04, 2017, 10:43:36 PM
  • ♦ Ninja ZX-10RR ♦: Excuse me but what does Simpleportal have to deal with that?
    February 05, 2017, 08:21:14 PM
  • WhiteEagle: of course IMHO that site appears to be dead :(
    February 04, 2017, 01:08:05 PM
  • WhiteEagle: If I can get that, then I'll use it for that site...
    February 04, 2017, 01:07:35 PM
  • WhiteEagle: decided to not use SMF for any projects, unless I can get a copy of the premium version of the fanfiction archive plugin
    February 04, 2017, 01:06:54 PM
  • expertdecisions: cloudflare
    January 28, 2017, 08:01:47 AM
  • aegersz: SM release 2.0.13 !
    January 12, 2017, 06:00:13 AM
  • raffo: Tks Emanuele, even if I didn't understand the fix :D
    November 07, 2016, 02:01:20 AM
  • emanuele: [link]
    November 01, 2016, 12:43:50 PM
  • emanuele: raffo: the English support board is a good place. ;)
    November 01, 2016, 12:43:38 PM
  • raffo: Where can I find the fix for the shoutbox?
    November 01, 2016, 05:06:09 AM
  • {OCS}MasterSeal: To the SP team, I make a point to come here and thank you as much as possible for your work.  so again, THANK YOU!
    October 28, 2016, 10:38:05 AM
  • emanuele: That's indeed funny, the limit is present only in the patch and not the full install.
    October 22, 2016, 06:14:58 PM

* Recent Posts

Adding Forums Button to Nav bar by jirapon
[August 01, 2019, 09:07:12 AM]


Re: Board Icons by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 04:03:41 PM]


MOVED: Czech translation???? by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 03:04:51 PM]


Board Icons by jirapon
[July 30, 2019, 07:28:44 AM]


Re: Thankyou Simpleportal, by ♦ Ninja ZX-10RR ♦
[July 29, 2019, 09:41:29 AM]

If you're interested in helping other members with support requests, consider joining the Community Support Helpers group.

Author Topic: Memberlist Box  (Read 5798 times)

0 Members and 1 Guest are viewing this topic.

Offline Smasher

  • Semi Newbie
  • *
  • Posts: 10
  • Gender: Male
  • SMF Version: 2 RC1.2
  • SP Version: 2.3
Memberlist Box
« on: July 11, 2014, 05:24:50 PM »
I am trying to pull the memberlist into a left side Custom PHP box. Once I do this I am going to modify it and display certain users from membergroups. Can someone give me a clue as to how to pull this information in?

I can see what I need when I am on the memberlist page but not when I am on others such as Whos online or Profile.
<( Smasher )>

ElkArte 1.0 RC 2 | SimplePortal 2.4

Offline oNLy1

  • Jr. Member
  • **
  • Posts: 53
  • SMF Version: 2.0.2
  • SP Version: 2.3.5
Re: Memberlist Box
« Reply #1 on: July 26, 2014, 04:19:32 AM »
sounds like it would be a lot easier to do it in a HTML or BBC block as I am not sure if your asking for the code for custom 'certain users from membergroups' block - or that you have such code, and just not enabling it to show on Whois or Profile pages, which would be editing the block Advanced Options and checking off some Actions.

Offline Smasher

  • Semi Newbie
  • *
  • Posts: 10
  • Gender: Male
  • SMF Version: 2 RC1.2
  • SP Version: 2.3
Re: Memberlist Box
« Reply #2 on: July 26, 2014, 09:01:11 PM »
I believe what I want to do is something like the code below... however with my very limited knowledge of databases and php, I have no clue as to what I am doing wrong... or what I am missing here...

[Note: Using ElkArte and not SMF]

Code: [Select]
global $db_prefix, $scripturl, $memberContext, $modSettings;

$request = $db->query('', '
SELECT id_member, member_name
FROM {db_prefix}members
        WHERE id_member IN ({array_int:users})
LIMIT 50'
);

$members = array();
while ($row = $db->fetch_assoc($request))
$members[] = $row;
$db->free_result($request);

foreach ($members as $m)
{
         echo ' '. $m[id_member] .' '. $m[member_name] .' <br><br>';
}
« Last Edit: July 26, 2014, 09:03:20 PM by Smasher »
<( Smasher )>

ElkArte 1.0 RC 2 | SimplePortal 2.4

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: Memberlist Box
« Reply #3 on: July 27, 2014, 07:36:10 AM »
I think this is what you need to make the code above work:

Code: [Select]
$db = database();

$request = $db->query('', '
SELECT id_member, member_name
FROM {db_prefix}members
LIMIT 50'
);
$members = array();
while ($row = $db->fetch_assoc($request))
$members[] = $row;
$db->free_result($request);

foreach ($members as $member)
echo $member['id_member'], ': ', $member['member_name'], '<br />';

It's a matter of modifying the query to filter the results. For example, in order to fetch the members of the group with the id of 5, you would need to change the query as the following:

Code: [Select]
$request = $db->query('', '
SELECT id_member, member_name
FROM {db_prefix}members
WHERE id_group = {int:group}',
array(
'id_group' => 5,
)
);
And slowly, you come to realize... It's all as it should be...

Offline Smasher

  • Semi Newbie
  • *
  • Posts: 10
  • Gender: Male
  • SMF Version: 2 RC1.2
  • SP Version: 2.3
Re: Memberlist Box
« Reply #4 on: July 27, 2014, 03:21:10 PM »
[SiNaN] -- Thank you so much, that is exactly what I needed... I will definitely be able to accomplish what I need now...
<( Smasher )>

ElkArte 1.0 RC 2 | SimplePortal 2.4

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: Memberlist Box
« Reply #5 on: July 27, 2014, 03:21:44 PM »
Glad to hear that that helped. You're welcome. ;)
And slowly, you come to realize... It's all as it should be...

Offline Smasher

  • Semi Newbie
  • *
  • Posts: 10
  • Gender: Male
  • SMF Version: 2 RC1.2
  • SP Version: 2.3
Re: Memberlist Box
« Reply #6 on: July 28, 2014, 06:27:42 PM »
How do I pull something into the query that is a little deeper than one level?
 
for example $context['members']['options']['cust_qwert']
<( Smasher )>

ElkArte 1.0 RC 2 | SimplePortal 2.4