chamilo / chamilo-lms

 * @param   string  Tool ID

 * @param   int     Internal ID used in specific tool table

 */

function delete_all_values_for_item($course_id, $tool_id, $ref_id) {

  $table_sf_values = Database :: get_main_table(TABLE_MAIN_SPECIFIC_FIELD_VALUES);

  $sql = 'DELETE FROM %s WHERE course_code = \'%s\' AND tool_id = \'%s\' AND ref_id = %s';

  $sql = sprintf($sql, $table_sf_values, $course_id, $tool_id, $ref_id);

  Database::query($sql);

}

/**

 * Generates a code (one-letter string) for a given field name

/**

 * 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

     * 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

 * @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