chamilo / chamilo-lms

     * Get platform language ID

     * @return     int     The platform language ID

     */

    public static function get_platform_language_id()

    {

        $name = api_get_setting('platformLanguage');

        $tbl_admin_languages = Database::get_main_table(TABLE_MAIN_LANGUAGE);

        $sql = "SELECT id FROM $tbl_admin_languages WHERE english_name ='$name'";

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

        if (Database::num_rows($res) < 1) {

            return false;

        }

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

        return $row['id'];

    }

    /**

     * Get parent language path (or null if no parent)

     * @param int $career_id

     * @return bool

     */

    public function get_status($career_id)

    {

        $TBL_CAREER = Database::get_main_table(TABLE_CAREER);

        $career_id = intval($career_id);

        $sql = "SELECT status FROM $TBL_CAREER WHERE id = '$career_id'";

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

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

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

            return $data['status'];

        } else {

            return false;

        }

    }

    /**

     * @param array $params

     * @param string session category ID

     * @return mixed false if the session category does not exist, array if the session category exists

     */

    public static function get_session_category($id)

    {

        $tbl_session_category = Database::get_main_table(TABLE_MAIN_SESSION_CATEGORY);

        $id = intval($id);

        $sql = "SELECT id, name, date_start, date_end

                FROM $tbl_session_category

                WHERE id= $id";

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

        $num = Database::num_rows($result);

        if ($num > 0) {

            return Database::fetch_array($result);

        } else {

            return false;

        }

    }

    /**

     * Get all session categories (filter by access_url_id)