chamilo / chamilo-lms

     * Drop the database tables for the plugin

     * @return void

     */

    private function uninstallDatabase()

    {

        /* Drop plugin tables */

        $advancedSubscriptionQueueTable = Database::get_main_table(TABLE_ADVANCED_SUBSCRIPTION_QUEUE);

        $sql = "DROP TABLE IF EXISTS $advancedSubscriptionQueueTable; ";

        Database::query($sql);

        /* Delete settings */

        $settingsTable = Database::get_main_table(TABLE_MAIN_SETTINGS_CURRENT);

        Database::query("DELETE FROM $settingsTable WHERE subkey = 'advanced_subscription'");

    }

    /**

     * Get the error messages list

     * Drop the database tables for the plugin

     * @return void

     */

    private function uninstallDatabase()

    {

        /* Drop plugin tables */

        $pensTable = Database::get_main_table(PENSPlugin::TABLE_PENS);

        $sql = "DROP TABLE IF EXISTS $pensTable; ";

        Database::query($sql);

        /* Delete settings */

        $settingsTable = Database::get_main_table(TABLE_MAIN_SETTINGS_CURRENT);

        Database::query("DELETE FROM $settingsTable WHERE subkey = 'plugin_pens'");

    }

    /**

     * Get the error messages list

/**

 * Lock settings that can't be changed in other portals

 */

function lockSettings()

{

    $access_url_locked_settings = api_get_locked_settings();

    $table = Database::get_main_table(TABLE_MAIN_SETTINGS_CURRENT);

    foreach ($access_url_locked_settings as $setting) {

        $sql = "UPDATE $table SET access_url_locked = 1 WHERE variable  = '$setting'";

        Database::query($sql);

    }

}

/**

 * Update dir values

 * @param   bool    $listCampus Whether we authorize

 * @todo the $_settings should be reloaded here. => write api function for this and use this in global.inc.php also.

 */

function api_register_campus($listCampus = true) {

    $tbl_settings = Database :: get_main_table(TABLE_MAIN_SETTINGS_CURRENT);

    $sql = "UPDATE $tbl_settings SET selected_value='true' WHERE variable='registered'";

    Database::query($sql);

    if (!$listCampus) {

        $sql = "UPDATE $tbl_settings SET selected_value='true' WHERE variable='donotlistcampus'";

        Database::query($sql);

    }

}

/**

 * Checks whether current user is a student boss