bbPress

Info

• 5 posts
• 3 voices
• Started 2 years ago by iang
• Latest reply from iang
• This topic is not resolved

Tags

• $bbdb
• profile

• Posts in this topic

How to print all user profiles

1. • 
   • iang
   • Member

   • Posted 2 years ago #

   I want to display a list of all the users on my blog (wbs80.com) and their profile information.
   I have been looking at the bbpress code and trying several tests...but unfortunately without success.

   My approach is to get the list of profile keys, get the list of users and for each user display the username and profile information. The code segment that I have is:

   <?php
   require_once ('../../bb-load.php');

   global $bddb;

   $profile_keys = get_profile_info_keys();
   //print_r($profile_keys);

   $userinfo = $bbdb->get_results("SELECT * FROM $bbdb->users WHERE user_status = 0 ORDER BY 'ID'");
   //print_r($userinfo);

   foreach ($userinfo as $key) {

   $metainfo = $bbdb->get_results("SELECT * FROM $bbdb->usermeta WHERE user_id = $key->ID");

   // ???

   }
   ?>

   I don't know how to use the "profile_keys" value(s) to access the "metainfo" data structure and extract the data.

   Any help would be greatly appreciated!
2. • 
   • chrishajer
   • Moderator

   • Posted 2 years ago #

   Hopefully this is only a typo here, not in your actual code:

   global $bddb;

   Should be $bbdb.
3. • 
   • Sam Bauers
   • Key Master

   • Posted 2 years ago #

   You aren't inside a function so there's no need to globalise $bbdb.

   This will get you every user (including all meta) into the array $users:

   $user_ids = $bbdb->get_col( "SELECT ID FROM $bbdb->users WHERE user_status = 0 ORDER BY id;", 0 );
   $users = bb_get_user( $user_ids );
   print_r( $users );
4. • 
   • chrishajer
   • Moderator

   • Posted 2 years ago #

   Thanks Sam. I didn't know what was wrong, but I did see the typo.
5. • 
   • iang
   • Member

   • Posted 2 years ago #

   Thanks Sam...this is exactly what I needed to get me going after being stuck for days :-)
   For completeness, here is the first working version of my code:

   <?php
   require_once('../bb-load.php');
   bb_get_header();
   ?>

   <script src="../my-js/sorttable.js"></script>
   <?php

   $tbl_header=<<<EOD
   
   </br>
   <h3><center><font color="#880000">WBS80 Registered Users</font></center></h3>
   <center><i><font size="2">(click on table header to sort</font>)</i></center>
   
   </br>
   <table class="sortable" width='100%' border='1' cellpadding='4' cellspacing='0' align='center'>
   <tr>
   <th>lname</th>
   <th>fname</th>
   <th>email</th>
   <th>city</th>
   <th>state/province</th>
   <th>country</th>
   </tr>
   EOD;

   $user_ids = $bbdb->get_col( "SELECT ID FROM $bbdb->users WHERE user_status = 0 ORDER BY id;", 0 );

   foreach ($user_ids as $key => $value) {

   if ($value == 1) {
   continue;
   }

   $users = bb_get_user( $value );

   $lname = strtolower($users->last_name);
   $fname = strtolower($users->first_name);
   $email = strtolower($users->user_email);
   $city = strtolower($users->city);
   $state = strtolower($users->state);
   $country = strtolower($users->country);

   $tbl_info .=<<<EOD
   <tr>
   <td>$lname</td>
   <td>$fname</td>
   <td>$email</td>
   <td>$city</td>
   <td>$state</td>
   <td>$country</td>
   </tr>
   EOD;

   }

   $tbl_footer = "</table>";

   $tbl =<<<TBL
   $tbl_header
   $tbl_info
   $tbl_footer
   TBL;

   print $tbl;

   ?>
   <p><h3 id="tag">AGE QUOD AGIS</h3></p>
   <?php bb_get_footer(); ?>

6. You must log in to post.