chamilo / chamilo-lms

     * @param int $language_id

     * @return int The current type of terms and conditions

     */

    public static function get_type_of_terms_and_conditions($legal_id, $language_id)

    {

        $legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL);

        $legal_id = intval($legal_id);

        $language_id = intval($language_id);

        $sql = 'SELECT type FROM '.$legal_conditions_table.'

                WHERE id =  "'.$legal_id.'" AND language_id="'.$language_id.'"';

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

        return Database::result($rs, 0, 'type');

    }

    /**

     * @param int $userId

     *

     * @return array

     */

    public static function get_list_invitation_of_friends_by_user_id($userId)

    {

        if (empty($userId)) {

            return [];

        }

        $tbl_message = Database::get_main_table(TABLE_MESSAGE);

        $sql = 'SELECT user_sender_id, send_date, title, content

                FROM '.$tbl_message.'

                WHERE

                    user_receiver_id = '.intval($userId).' AND

                    msg_status = '.MESSAGE_STATUS_INVITATION_PENDING;

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

        $list = array();

        while ($row = Database::fetch_array($res, 'ASSOC')) {

            $list[] = $row;

        }

        return $list;

    }

    /**

     * Get invitation list sent by user

     * @param int $parent_id The parent id(Language father id)

     * @return array All information about language

     */

    public static function get_all_information_of_language($parent_id)

    {

        $table = Database::get_main_table(TABLE_MAIN_LANGUAGE);

        $sql = 'SELECT * FROM '.$table.' WHERE id = "'.intval($parent_id).'"';

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

        $all_information = array();

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

            $all_information = $row;

        }

        return $all_information;

    }

    /**

     * Get all information of chamilo file

     * @param int $id

     * @param float $weight

     */

    public static function updateEvaluationWeight($id, $weight)

    {

        $table_evaluation = Database::get_main_table(TABLE_MAIN_GRADEBOOK_EVALUATION);

        $id = intval($id);

        $evaluation = new Evaluation();

        $evaluation->add_evaluation_log($id);

        $sql = 'UPDATE '.$table_evaluation.'

               SET weight = '."'".Database::escape_string($weight)."'".'

               WHERE id = '.$id;

        Database::query($sql);

    }

    /**

     *