jfederico / moodle-mod_bigbluebuttonbn

 *

 * @return string containing the sql used for getting the target bigbluebuttonbn instances

 */

function bigbluebuttonbn_get_recordings_deleted_sql_select($courseid = 0, $bigbluebuttonbnid = null, $subset = true) {

    $sql = "log = '" . BIGBLUEBUTTONBN_LOG_EVENT_DELETE . "' AND meta like '%has_recordings%' AND meta like '%true%'";

    if (empty($courseid)) {

        $courseid = 0;

    }

    if (empty($bigbluebuttonbnid)) {

        return $sql . " AND courseid = {$courseid}";

    }

    if ($subset) {

        return $sql . " AND bigbluebuttonbnid = '{$bigbluebuttonbnid}'";

    }

    return $sql . " AND courseid = {$courseid} AND bigbluebuttonbnid <> '{$bigbluebuttonbnid}'";

}

/**

 * Helper function to define the sql used for gattering the bigbluebuttonbnids whose meetingids should be included

 *

 * @return string containing the sql used for getting the target bigbluebuttonbn instances

 */

function bigbluebuttonbn_get_recordings_imported_sql_select($courseid = 0, $bigbluebuttonbnid = null, $subset = true) {

    $sql = "log = '" . BIGBLUEBUTTONBN_LOG_EVENT_IMPORT . "'";

    if (empty($courseid)) {

        $courseid = 0;

    }

    if (empty($bigbluebuttonbnid)) {

        return $sql . " AND courseid = '{$courseid}'";

    }

    if ($subset) {

        return $sql . " AND bigbluebuttonbnid = '{$bigbluebuttonbnid}'";

    }

    return $sql . " AND courseid = '{$courseid}' AND bigbluebuttonbnid <> '{$bigbluebuttonbnid}'";

}

/**

 * Helper function to get recordings and imported recordings together.