chamilo / chamilo-lms

            $session_condition = '(session_id = 0 OR session_id IS NULL)';

        }

        if (!isset($this->exercise_data)) {

            $sql = 'SELECT * FROM '.$this->get_forum_thread_table().'

                    WHERE c_id = '.$this->course_id.' AND  thread_id = '.$this->get_ref_id().' AND '.$session_condition;

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

            $this->exercise_data = Database::fetch_array($query);

        }

        return $this->exercise_data;

    }

            $this->exercise_data = Database::fetch_array($query);

            // Try with iid

            if (empty($this->exercise_data)) {

                $sql = 'SELECT * FROM '.$this->get_studpub_table()."

                        WHERE

                            c_id ='".$course_info['real_id']."' AND

                            iid = '".$this->get_ref_id()."' ";

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

                $this->exercise_data = Database::fetch_array($query);

            }

        }

        return $this->exercise_data;

     */

    private function get_learnpath_data()

    {

        if (!isset($this->learnpath_data)) {

            $sql = 'SELECT * FROM '.$this->get_learnpath_table().'

                    WHERE c_id = ' . $this->course_id.' AND id = '.$this->get_ref_id().' ';

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

            $this->learnpath_data = Database::fetch_array($result);

        }

        return $this->learnpath_data;

    }