Grassblade and Learndash Add-On

Hi Michael-
Yes I need the achievement warded with the associated points.

Does this all make sense ok?
Matt

Hi Michael-
I tried the code but it did not award any achievements. Two things:
1. Could you say if I have the plugin formatted correctly. I am no PHP expert.

2. Also, I’d be happy to hard code in the Lesson ID’s if that would make it guaranteed to work.

Here is my code:

[ Moderator note: Code fixed, please wrap code in backticks or use the code button. ]

<?php
/*
Plugin Name: Fix Grassblade Mark Complete for BadgeOS
Plugin URI:
Description: Processes BadgeOS Badges on Grassblade Mark Complete functions
Version: 0.1
Author: Matt McLean
Author URI:
License: GPLv2
*/

function ap_badge_award_grassblade($data) {

//This is the bit I got from Pankaj:

add_action("learndash_lesson_completed", function ($data) {
$lesson_id = $data["lesson"]->ID;
$user_id = $data["user"]->ID;

//Required BadgeOS Code Here

global $wpdb;

$sql = "SELECT post_id as lesson FROM " . $wpdb->postmeta . " WHERE meta_key = %s AND meta_value = %d";
$rs1 = $wpdb->get_results( $wpdb->prepare( $sql, '_badgeos_learndash_object_id', $lesson_id ) );
if ( !empty( $rs1 ) ) {
//Only need one of the "steps" to get the appropriate achievement ID later.
$step_id = $rs1[0]->lesson;
}

$sql = "SELECT DISTINCT p2p_to as achievement_id FROM " . $wpdb->prefix . "p2p WHERE p2p_from = %d";
$rs2 = $wpdb->get_results( $wpdb->prepare( $sql, $step_id ) );
if ( !empty( $rs2 ) ) {
//We'll have our achievement ID!
$achievement_id = $rs2[0]->achievement_id;
}

if ( !empty( $achievement_id ) ) {
badgeos_maybe_award_achievement_to_user( $achievement_id, $user_id );
}

Here is the response from the BadgeOS Developer:

"Well, from the looks of it, you have the user ID already, which is good. The question is where can we get the achievement ID necessary to award. It looks like you'll have the lesson ID that we can work with.

Try out the code below. Best way I could think of offhand to get the achievement ID based on lesson ID.

global $wpdb;

$sql = "SELECT post_id as lesson FROM " . $wpdb->postmeta . " WHERE meta_key = %s AND meta_value = %d";
$rs1 = $wpdb->get_results( $wpdb->prepare( $sql, '_badgeos_learndash_object_id', $lesson_id ) );
if ( !empty( $rs1 ) ) {
//Only need one of the "steps" to get the appropriate achievement ID later.
$step_id = $rs1[0]->lesson;
}

$sql = "SELECT DISTINCT p2p_to as achievement_id FROM " . $wpdb->prefix . "p2p WHERE p2p_from = %d";
$rs2 = $wpdb->get_results( $wpdb->prepare( $sql, $step_id ) );
if ( !empty( $rs2 ) ) {
//We'll have our achievement ID!
$achievement_id = $rs2[0]->achievement_id;
}

if ( !empty( $achievement_id ) ) {
badgeos_maybe_award_achievement_to_user( $achievement_id, $user_id );
}

Michael-
Thank you so much for your efforts. Unfortunately it is not working for me. I installed the plugin and tried 3 different lesson with Grassblade content. The Lesson is marked complete but the associated badge is not awarded. I have the badge setting set to “Complete Steps” and the step is a Learndash Lesson being completed.

Did I need to change anything in the plugin as far as entering any lesson ID numbers?

Thanks again and let me know what else I can try.

Matt

Also, Michael- Grassblade has quoted me a very reasonable rate to try and debug the plugin. Should I go ahead with that or do you think you’re close?

Thank you so much!
Matt

Before we go any further I need to ask this: Is the plugin designed to take into account one particular Achievement ID and one particular Lesson ID? I can’t find in the code where those id’s would be. When you say “assuming we have the right lesson ID that is tied to the BadgeOS achievement in question”…..what do you think they are? I tried to ask this earlier so sorry if I wasn’t clear.

So for example, the badge ID would be: 29846

The lesson ID would be: 29801

Do these numbers need to go into the code somewhere??