How to create a participation badge

[shuban]

I'd like to create a participation badge where you're given a badge based on how many times a member has particpated in the forum.

For instance, a member could have 50 posts, but those posts were only made in 7 topics total. Therefore, they have participated 7 times.

Or, in the same way, the member may have 50 posts and 3 topics, so it would be 10 times participated.

How could this be done?

[SMFHacks]

What do you mean by participated? Number of topics?

Either way it would be done by an SQL query to get the criteria that you are basing the participation on.

[shuban]

What do you mean by participated? Number of topics?

Either way it would be done by an SQL query to get the criteria that you are basing the participation on.

Participation, as in, how many topics you've been a part of.

Like, you could have 6 posts in total, but those 6 posts were made in 2 topics. So essentially, you've only participated in two discussions.

Do you get what I mean?

[SMFHacks]

A query like this should do it

Code: [Select]

SELECT count(distinct id_topic) as total from smf_messages where id_member =  ####memberidhere####


[shuban]

A query like this should do it

Code: [Select]

SELECT count(distinct id_topic) as total from smf_messages where id_member =  ####memberidhere####


YES! You're right... But, where would I place this? And how could I implement this in badgeawards.php?

[SMFHacks]

It would be in the same area as the topic starter badges/post badges in the badgewards php file.

[shuban]

I tried this:

Code: [Select]

// Participation Awards

$badgeAction = 'participation10';
if ($memberContext[$memberID]['topic_count'] >= 10 && !in_array($badgeAction,$currentBadges))
{

$result = db_query("
SELECT COUNT(distinct id_topic) AS total FROM {$db_prefix}smf_messages WHERE ID_MEMBER = $memberID
", __FILE__, __LINE__); 
$totalRow = mysql_fetch_assoc($result);
if ($totalRow['total'] > 0)
{
$badgeID = GetBadgeIDByAction($badgeAction);
$ret = AddBadgeToMember($memberID,$badgeID,false);
if ($ret == true)
{
$currentBadges[] = $badgeAction;
$newBadges[]  = $badgeAction;
}
}
}
But nothing happened What am I doing wrong?

[SMFHacks]

Get rid of $memberContext[$memberID]['topic_count'] >= 10 &&
Or change to
$memberContext[$memberID][posts'] > 0 &&

[SMFHacks]

Right now the way you have it coded will give anyone who ever made a post a badge... not sure if that's what you want...

if ($totalRow['total'] > 0)


That part above is key you can have different badges depending on a total number...

[shuban]

I think this did the trick, for now

Code: [Select]

// Participation Awards // Still needs work

$badgeAction = 'participation10';
if ($memberContext[$memberID]['posts'] != 0 && !in_array($badgeAction,$currentBadges))
{

$result = db_query("
SELECT COUNT(distinct id_topic) AS total FROM {$db_prefix}messages WHERE ID_MEMBER = $memberID
", __FILE__, __LINE__); 
$totalRow = mysql_fetch_assoc($result);
if ($totalRow['total'] >= 10)
{
$badgeID = GetBadgeIDByAction($badgeAction);
$ret = AddBadgeToMember($memberID,$badgeID,false);
if ($ret == true)
{
$currentBadges[] = $badgeAction;
$newBadges[]  = $badgeAction;
}
}
}