chamilo / chamilo-lms

        }

        $path = Database::escape_string($path);

        if (!empty($courseId) && !empty($path)) {

            $sql = "SELECT id FROM $table

                    WHERE

                        c_id = $courseId AND

                        path LIKE BINARY '$path' AND

                        session_id = $sessionId

                    LIMIT 1";

            $result = Database::query($sql);

            if (Database::num_rows($result)) {

                $row = Database::fetch_array($result);

                return intval($row['id']);

            }

        }

        return false;

    }

        $sessionIsCoach = Database::store_result($result);

    }

    if (!empty($session_id)) {

        $sql = "SELECT DISTINCT id, name, access_start_date, access_end_date

                FROM $session_table

                WHERE session.id_coach =  '".$userId."' AND id = '$session_id'

                ORDER BY access_start_date, access_end_date, name";

        $result = Database::query($sql);

        if (!empty($sessionIsCoach)) {

            $sessionIsCoach = array_merge($sessionIsCoach , Database::store_result($result));

        } else {

            $sessionIsCoach = Database::store_result($result);

        }

    }

    return (count($sessionIsCoach) > 0);

}