PDA

View Full Version : Load members of certain usergroup only?

AFemaleProdigy
08-28-2009, 08:52 PM
I am creating some custom pages that will display members of certain usergroups rather then all members of the forum. So I have a usergroup called "technicians" and a custom field "state" (aka "field7"). On one page I want to load only the members from the group "technicians" that live in a certain state (example:MN).

I have my custom page created already. It is displaying ALL members right now. Can someone tell me how to list only members from the "technician" usergroup that live in the state I specify?

I am guessing I could use some sort of conditional statement? Like IF user is in this group "x" and field7=MN then display userdata?

Thanks!
RLShare
08-29-2009, 10:51 AM
In your SQL query, join the 'userfield' table on the condition 'userfield.userid = user.userid' and then add a WHERE clause to the statement such as 'userfield.fieldxx = whatever'.
AFemaleProdigy
09-02-2009, 08:12 PM
I'm sorry, but I don't exactly know how to write that. I'm still learning php and conditional statements. :o I usually try to figure it out myself, but I am a little stumped. Can you write it out for me?
Dismounted
09-03-2009, 06:05 AM
And your page currently contains? (Please post your code.)
AFemaleProdigy
09-10-2009, 02:07 PM
Sorry it took me so long to write back. Here is what I have so far. I just imported a bunch of users that don't have their state entered yet so just know this page does correctly display the state. Still a work in progress.

http://amtech.abovemls.com/community/technician-roster.php

Here is the code for my custom template...

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>Technician Roster - $vboptions[bbtitle]</title>
$headinclude
<LINK HREF="../AMtechVB.css" TYPE="text/css" REL="stylesheet"/>
</head>
<body style="color:#FFCC33">
$header

<div id="content">
<div >

<div id="primary">
<h1>$vbphrase[technician_roster]</h1>

<form action="profile.php?do=deleteusergroups&amp;usergroupid=$userg roupid" method="post">
<input type="hidden" name="do" value="deleteusergroups" />
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="securitytoken" value="$bbuserinfo[securitytoken]" />
<input type="hidden" name="usergroupid" value="$usergroupid" />
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center" style="border-bottom-width:0px">
<tr>
<td class="tcat" width="100%">
Alabama

</td>

</tr>
</table>
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr align="center">
<td class="thead" align="$stylevar[left]" nowrap="nowrap"><a href="$sorturl<if condition="!$show['sorturlnoargs']">&amp;</if>order=ASC&amp;sort=username&amp;pp=$perpage$usergrouplink">$vbphrase[username]</a> $sortarrow[username]</td>
<if condition="$show['usergroup']"><td class="thead"><input name="allbox" type="checkbox" value="Check All" title="$vbphrase[check_uncheck_all]" onClick="checkall(this.form);" /></td></if>
</tr>
$memberlistbits
<tr>
<td class="tfoot" colspan="15" align="$stylevar[right]">

</td>
</tr>
</table>
</form>






</div><!-- #primary -->
<div id="secondary" class="sidebar">
<ul id="subMenu">
<li><a href="#">Benefits</a></li>
<li><a href="#">Boards of Directors</a></li>
<li class="active"><a href="#">Certification</a></li>
<li><a href="#">Charter</a></li>
<li><a href="#">Code of Ethics</a></li>
<li><a href="#">Contact Amtech</a></li>
<li><a href="#">Join Now</a></li>
<li><a href="#">Officers</a></li>
</ul>
</div><!-- #secondary -->
</div><!-- #wrap -->
</div><!-- #content -->

<div id="siteInfo">
<ul>
<li class="first"><a href="#">About AMTECH</a></li>
<li><a href="#">Why Join?</a></li>
<li><a href="#">Community Forums</a></li>
<li><a href="#">Member Resources</a></li>
<li><a href="#">Training &amp; Services</a></li>
<li><a href="#">Contact AMTECH</a></li>
</ul>
<h6>AM-TECH Assaociation of Marine Technicians &copy;2009 All rights reserved </h6>
</div><!-- #siteInfo -->

</body>
</html>


--------------- Added 10 Sep 2009 at 11:09 ---------------

Do you need the code for the php page code too because this site keeps telling me it's too many characters?

--------------- Added 1252606073 at 1252606073 ---------------

Can anyone just show me what the code would be for...

if a user's $userinfo[field7] (custom profile field) equals "X" (variable) then display those user's usernames?

I have tried to write this tons of ways and can't figure it out. I have no training in this stuff. This is what I came up with after scouring the web and guessing and finally gave up on...

<if condition="$userinfo[field7] == OH"><a href="member.php?$session[sessionurl]u=$userinfo[userid]">$userinfo[musername]</a></if>
AFemaleProdigy
09-14-2009, 04:22 PM
Help? Please?
binaryg
09-14-2009, 04:33 PM
in your template, you can match the member to their usergroup with

<if condition="is_member_of($bbuserinfo, X, Y, Z)">
AFemaleProdigy
09-14-2009, 04:49 PM
That doesn't include the custom field variable I need. I need to call by IF (custom profile field = "x"), then display usernames.

This is basicly a secondary custom member page, but I need to group individuals by state which is listed in their custom profile field (field7). I can't just use a sort arrow for the full list either. I have to break them up into groups by state of residence.
binaryg
09-14-2009, 05:40 PM
What about
<if condition="is_member_of($bbuserinfo, X, Y, Z)">
<if condition="$profilefield[value] == "somevalue">
do stuff
</if>
</if>
AFemaleProdigy
09-14-2009, 06:54 PM
I seem to be having a problem with that. I keep getting a parse error when I try to save the template with the second IF statement in it. The first one for the usergroup is ok, but when I add the one for the profile field it kills it. Maybe I am not changing the values correctly? This is what I have tried so far...

<if condition="is_member_of($bbuserinfo, 2, 6)">
<if condition="$profilefield[field7] == "OH">
do stuff
</if>
</if>

and also this...

<if condition="is_member_of($bbuserinfo, 2, 6)">
<if condition="$userinfo[field7] == "OH">
do stuff
</if>
</if>

I get this parse error only when the second IF statement is included...
----
The following error occurred when attempting to evaluate this template:

Parse error: syntax error, unexpected T_DO in /var/www/vhosts/am-tech.org/httpdocs/community/includes/adminfunctions_template.php(3939) : eval()'d code on line 45

This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.

--------------- Added 14 Sep 2009 at 16:00 ---------------

I also just tried this because I think a quote was missing or something. It eliminated the parse error, but did not output the test text.

<if condition="is_member_of($bbuserinfo, 2, 6)">
<if condition="$profilefield[field7] == 'OH'">
test
</if>
</if>

--------------- Added 1252959502 at 1252959502 ---------------

Ok, so I messed around some more and came up with this code, but it's only showing MY username to me if my state matches the field7 value. It's not listing all members with that value which is what I need. It should be a list of all members with that field7 value.

<if condition="is_member_of($bbuserinfo, 2, 6)">
<if condition="$bbuserinfo[field7] == 'OH'">
$bbuserinfo[username]
</if>
</if>
binaryg
09-14-2009, 07:45 PM
for that you are going to need to loop through the values for each member and use that code. Though, it would probably be a bit more simple just to use a php file and select all the members from the database that meet your criteria. You might be able to get away with that if you were able to copy some code from the memberlist templates, essentially creating your own, and then use your custom information to sort the users but I think you would probably need to enable that particular field to be indexed in the memberlist. I wouldn't know which is the easiest route. I haven't played with member data very much.

ohh, and it looks like your parse error is the result of the first " in "OH". It closes out the tag
AFemaleProdigy
09-14-2009, 08:57 PM
I did make my custom page based off of the memberlist.php but I don't know what to add in there and then what to put in my template to make this work.

--------------- Added 1252966903 at 1252966903 ---------------

What would be the fastest way for me to get this working? :)
binaryg
09-14-2009, 10:14 PM
$users= $db->query_first("
SELECT member AS member
FROM " . TABLE_PREFIX . "members AS members
WHERE useridcolumn = " . $useridvariable . " AND fieldcolumn = dataforfield
LIMIT 1
");

There's probably all sorts of things wrong with that's should get you started... plug whatever info you need in there and see where it takes ya. That's what I do