1:  2:  3:  4:  5:  6:  7:  8:  9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 

<?php

/**
 * H5p utilities.
 */
class H5pUtil {

    /**
     * Get H5P by Id.
     */
    public static function getH5pById($id, $fields=array()) {
        global $wpdb;

        if (!$fields)
            $fields=array("*");

        else
            if (!in_array("id",$fields))
                $fields[]="id";

        $fieldsString=join(",",$fields);

        $q=$wpdb->prepare(
            "SELECT $fieldsString ".
            "FROM   {$wpdb->prefix}h5p_contents ".
            "WHERE  id=%s",
            $id
        );

        if ($wpdb->last_error)
            throw new Exception($wpdb->last_error);

        return $wpdb->get_row($q,ARRAY_A);
    }

    /**
     * Get H5p title.
     */
    public static function getH5pTitleById($id) {
        $h5p=H5pUtil::getH5pById($id,array("title"));
        return $h5p["title"];
    }

    /**
     * Get h5p id.
     */
    public static function getH5pIdBy($by, $value) {
        global $wpdb;

        $q=$wpdb->prepare(
            "SELECT id ".
            "FROM   {$wpdb->prefix}h5p_contents ".
            "WHERE  $by=%s",
            $value
        );

        if ($wpdb->last_error)
            throw new Exception($wpdb->last_error);

        return $wpdb->get_var($q);
    }

    /**
     * Find h5p id.
     */
    public static function getH5pIdByShortcodeArgs($args) {
        if (array_key_exists("id", $args))
            return H5pUtil::getH5pIdBy("id",$args["id"]);

        else if (array_key_exists("title", $args))
            return H5pUtil::getH5pIdBy("title",$args["title"]);

        else if (array_key_exists("slug", $args))
            return H5pUtil::getH5pIdBy("slug",$args["slug"]);
    }   
}