Hey Abi,

This requires quite a bit of hack if you want to achieve this but it is do-able, you just need to run a SQL query to see if the user achieved such badges on the site.

The mapping between a badge and the user is stored on the table #__social_badges_maps . If the user earned a badge, a new record will be stored in this table

Hi Mark,

I can query the table but can't translate that to what I want to achieve.

SELECT *
FROM `xxx_social_badges_maps`
WHERE badge_id =32

(A) Assuming that I want to check if badge id 32 and id 67 are earned by the user and points > 500, then echo "hello hello".

How can I do this - I know this is outside normal support but I need my ranking system to be a bit better that my initial thoughts.

Thanks for all your help.

Hey Abi,

The quickest way would be something like this:

$user = FD::user();

$db = JFactory::getDBO();

$query = 'select * from jos_social_badges_maps where user_id = ' . $user->id . ' and (badge_id=67 or badge_id=32)';

$db->setQuery($query);

$result = $db->loadObjectList();



$hasBadges = count($result) == 2;



if ($hasBadges && $user->getPoints() > 500) {

       echo 'hello hello';

}

Thanks Mark, but unfortunately it gave various problems and I tried to modify it but had no clear idea of what i was doing. Here is my modification but I used the actual table name. badge IDs 20 & 32 exist and my test user has both. I think that $user was interfering with something in default.header.php so I changed it to $userme. <?php echo $userme; ?> outputs SocialUser


<?php

$userme = FD::user(); ?>
<?php $db = JFactory::getDBO(); ?>
<?php $query = 'select * from XXX_social_badges_maps where user_id = ' . $userme->id . ' and (badge_id=20 or badge_id=32)'; ?>


<?php $db->setQuery($query);
$result = $db->loadObjectList(); ?>

<?php $hasBadges = count($result) == 2; ?>


<?php

if ($hasBadges && $user->getPoints() < 500) {
echo 'hello hello';
}
?>

Hi Abi,

May I know what is the error that you are facing with the example code that my colleague Mark shown to you? By the way you should also change all the variable $user to $userme at your last if statement:

if ($hasBadges && $user->getPoints() < 500) {

echo 'hello hello';

}

// change it to

if ($hasBadges && $userme->getPoints() < 500) {

echo 'hello hello';

}

Hi Ezrul,

It works great except for two things that I noticed.

(1) If userA meets the criteria ( badges id=67 and id=32) AND points <500 logs on to the website, then her profile properly displays "hello hello". But if she views the profile of another user UserB e.g with only one badge with id=20, then the profile display still shows "hello hello". It does not check to see if the other user has requisite badges,


(2) Only a user that is logged on can see the 'hello hello' associated with her account, but I want the public to be a able to see it. In the above example userA can see her 'hello hello' but userB cannot see it nor can the public see it.

I appreciate all the help that I'm getting.

Thanks StackIdeas - excellent EasySocial and superb support!!

You are most welcome Abi.