Badges Displayed in Profile

   Community Suite
   SMF Gallery Pro
   SMF Store
   SMF Classifieds
   Newsletter Pro
   Downloads System Pro
   Ad Seller Pro
   Badge Awards
  
   Hacks and Mods
   Latest SMF Hacks
   TopTen Hacks
   Styles and Themes
   Add a Hack
   Manage Hacks
   Earn Money from Your Forum with these tips
   SMF Theme Generator
   SMF Package Parser
   Free SMF Hosting
   Buy Website Traffic
   Site Showcase
   Email Marketing Software

Advanced search

[shuban]

I purchased the software, at your convenience, could you provide me the profile.template.php code that displays all the badges earned?

Thank you

[SMFHacks]

Try this
Example code with caching. Just need to pass in/set $memberID

Code:

global $modSettings, $db_prefix, $boardurl;

if (empty($modSettings['badgeawards_url']))
$modSettings['badgeawards_url'] = $boardurl . '/badges/';
       
$badgesCache = array();
if (($badgesCache = cache_get_data('badge_display_' . $memberID, 60)) == null)
{

$result = db_query("
SELECT
b.id_badge, b.title, b.image, b.enabled, l.date
FROM ({$db_prefix}badgeawards_badges as b, {$db_prefix}badgeawards_badge_log as l)
WHERE l.id_badge = b.id_badge AND l.ID_MEMBER = $memberID
ORDER BY l.id_log DESC
LIMIT  $maxToShow
", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($result))
{
$badgesCache[] = $row;

}

cache_put_data('badge_display_' . $memberID, $badgesCache, 60);

}


// Tweak this loop for display
foreach($badgesCache as $row)
{
echo '<img src="' . $modSettings['badgeawards_url']  . $row['image'] . '" alt="' . $row['title'] . '" title="' . $row['title'] . '" /> ';

}
['code]

[shuban]

Got an error

Code:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY l.id_log DESC
LIMIT' at line 5
File:

SELECT
         b.id_badge, b.title, b.image, b.enabled, l.date
      FROM ({$db_prefix}badgeawards_badges as b, {$db_prefix}badgeawards_badge_log as l)
      WHERE l.id_badge = b.id_badge AND l.ID_MEMBER = $memberID
      ORDER BY l.id_log DESC
      LIMIT  $maxToShow
      ", __FILE__, __LINE__);
      while ($row = mysql_fetch_assoc($result))

Line 998 is ", __FILE__, __LINE__);

[SMFHacks]

Remove
LIMIT  $maxToShow

[shuban]

Now I get this:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY l.id_log DESC' at line 5

Code:

$result = db_query("
SELECT
b.id_badge, b.title, b.image, b.enabled, l.date
FROM ({$db_prefix}badgeawards_badges as b, {$db_prefix}badgeawards_badge_log as l)
WHERE l.id_badge = b.id_badge AND l.ID_MEMBER = $memberID
ORDER BY l.id_log DESC
", __FILE__, __LINE__);

Error on ", __FILE__, __LINE__);

This is for 1.x

[SMFHacks]

Are you setting $memberID = to anything before calling the query?
It should be set to the member id of the profile you are viewing.

[shuban]

No, what do I set $memberID to?

[shuban]

HEre's my profile.template...

I added the code to it already, just search for it...

[SMFHacks]

Before
$badgesCache = array();   
Add

Code:

$memberID = $context['member']['id'];

[shuban]

Before
$badgesCache = array();   
Add

Code:

$memberID = $context['member']['id'];

Looks great...

[shuban]

If I disable a badge, is it possible to not have it show up in people's profiles who have already earned it?

For instance, I disabled the "Level 1 Badge", but it's still showing up in people's profiles that they still have it

[SMFHacks]

Find

Code:

WHERE l.id_badge = b.id_badge AND l.ID_MEMBER = $memberID

Change

Code:

WHERE l.id_badge = b.id_badge AND l.ID_MEMBER = $memberID and b.enabled = 1

[shuban]

Worked, thank you

Members are really starting to like this!

[SMFHacks]

No problem. There is a lot you can do exceptionally with custom badges. Kinda makes the forum a mini game and people try to earn them all.

[shuban]

No problem. There is a lot you can do exceptionally with custom badges. Kinda makes the forum a mini game and people try to earn them all.

People sent me 10's of requests lol

Help Support the SMFHacks.com mod making.