chamilo / chamilo-lms

    public function updateMailAgreementLink($userId, $courseId, $sessionId)

    {

        $data = $this->getUserAcceptedLegal($userId, $courseId, $sessionId);

        if (!empty($data)) {

            $table = Database::get_main_table(

                'session_rel_course_rel_user_legal'

            );

            $uniqueId = api_get_unique_id();

            Database::update(

                $table,

                array('mail_agreement_link' => $uniqueId),

                array('id = ? ' => array($data['id']))

            );

            $this->sendMailLink($uniqueId, $userId, $courseId, $sessionId);

        }

    }

    /**

                // The page must be refreshed to show the recently created tab

                echo "<script>location.href = '".Security::remove_XSS($_SERVER['REQUEST_URI'])."';</script>";

            }

        } else {

            $settingsCurrentTable = Database::get_main_table(TABLE_MAIN_SETTINGS_CURRENT);

            $conditions = array(

                'where' => array(

                    "variable = 'show_tabs' AND title = ? AND comment = ? " => array(

                        $langString,

                        $pluginUrl

                    )

                )

            );

            $result = Database::select('subkey', $settingsCurrentTable, $conditions);

            if (!empty($result)) {

                $this->deleteTab($result[0]['subkey']);

            }

        }

    }

    /**