chamilo / chamilo-lms

        $TBL_COURSE = Database::get_main_table(TABLE_MAIN_COURSE);

        $exe_id = intval($exe_id);

        $result = array();

        if (!empty($exe_id)) {

            $sql = " SELECT q.*, tee.*

                FROM $TBL_EXERCICES as q

                INNER JOIN $TBL_TRACK_EXERCICES as tee

                ON q.id = tee.exe_exo_id

                INNER JOIN $TBL_COURSE c

                ON c.id = tee.c_id

                WHERE tee.exe_id = $exe_id

                AND q.c_id = c.id";

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

            $result = Database::fetch_array($res_fb_type, 'ASSOC');

        }

        return $result;

    }

    public static function getInstance($id)

    {

        $vhost = new stdClass();

        if ($id) {

            $id = (int) $id;

            $sql = "SELECT * FROM vchamilo WHERE id = $id";

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

            $vhost =  (object) Database::fetch_array($result, 'ASSOC');

        }

        return $vhost;

    }

                ) as t1

                ";

        if ($getCount) {

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

            $count = 0;

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

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

                $count = $rows['count'];

            }

            return $count;

        }

        if (!empty($column) && !empty($direction)) {

            $column = str_replace('u.', '', $column);

        $conditionsToString = implode('AND ', $conditions);

        if (empty($courseCode)) {

            $sql = "SELECT count(poster_id) as count

                    FROM $tbl_forum_post post 

                    INNER JOIN $tbl_forum forum

                    ON (forum.forum_id = post.forum_id AND forum.c_id = post.c_id)

                    WHERE $conditionsToString";

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

            $row = Database::fetch_array($rs, 'ASSOC');

            return $row['count'];

        }

        require_once api_get_path(SYS_CODE_PATH).'forum/forumconfig.inc.php';