[insert_php]
$current_user = wp_get_current_user();
$bbp_user_id = $current_user->ID;
$page_idx = $_GET[‘page_namex’];
if($bbp_user_id !=0) {//if user exists, only then do
//get a list of private groups for this user – this must be just one group, as otherwise this code won’t work or produce strange results !
$group=get_user_meta( $bbp_user_id, ‘private_group’,true);
//Then since we store a single group as either ‘groupx’ or ‘*groupx*’ we need to check which (if a user has had multiple groups and is now a single group, this could happen)
$pos= strpos($group,’*’);
//if false then we just have a group
if($pos === false) {
}
else {
//We have a group with * at either end, so need to strip this
$group = substr($group, 1, -1);
}
//now find which forum has this group assigned
//Again there must be only one forum with this group assigned
global $wpdb;
$forum_id=$wpdb->get_col(“select post_id from $wpdb->postmeta where meta_value = ‘$group’ AND meta_key =’_private_group'”) ;
//turn array into string
$forum_id = implode (“”,$forum_id);
$uniquepostforumidforrecord=’member-database’ . “:” . $forum_id;
//get name and unit number from pdb
global $wpdb;
$useremail= $current_user->user_email;
$sql = “SELECT * FROM wp_xmncn1z6pn_participants_database p where p.email LIKE ‘%$useremail%’ and p.unique_id_page_forum=’$uniquepostforumidforrecord'”;
//echo $sql;
$member_results=$wpdb->get_results($sql);
$membersname=”;
$membersunit=”;
foreach ( $member_results as $memberval)
{
$membersname=$memberval->first_name;
$membersunit=$memberval->unit_number;
}
//echo $membersname;
$current_user->first_name=$membersname;
$current_user->user_url=$membersunit;
if($page_idx == ‘Legalconfirmform’) {
echo do_shortcode(‘[contact-form-7 id=”1502″ title=”Legal Case Confirmation Form”]’);
}
if($page_idx == ‘forumsubjectform’) {
echo do_shortcode(‘[contact-form-7 id=”1744″ title=”Forum Subject Request Form”]’);
}
} else {
$actual_link = “http://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]”;
echo ‘Login to forum to proceed’;
}
[/insert_php]