uninstall.php 1.8 KB

123456789101112131415161718192021222324252627282930313233343536
  1. <?php
  2. /**
  3. * This script is included by main/admin/settings.lib.php when unselecting a plugin
  4. * and is meant to remove things installed by the install.php script in both
  5. * the global database and the courses tables
  6. */
  7. $t_settings = Database::get_main_table(TABLE_MAIN_SETTINGS_CURRENT);
  8. $t_options = Database::get_main_table(TABLE_MAIN_SETTINGS_OPTIONS);
  9. $sql = "DELETE FROM $t_settings WHERE variable = 'bbb_plugin'";
  10. Database::query($sql);
  11. $sql = "DELETE FROM $t_options WHERE variable = 'bbb_plugin'";
  12. Database::query($sql);
  13. $sql = "DELETE FROM $t_settings WHERE variable = 'bbb_plugin_host'";
  14. Database::query($sql);
  15. $sql = "DELETE FROM $t_settings WHERE variable = 'bbb_plugin_salt'";
  16. Database::query($sql);
  17. $sql = "DROP TABLE plugin_bbb";
  18. Database::query($sql);
  19. // update existing courses to add conference settings
  20. $t_courses = Database::get_main_table(TABLE_MAIN_COURSE);
  21. $sql = "SELECT id, code, db_name FROM $t_courses ORDER BY id";
  22. $res = Database::query($sql);
  23. while ($row = Database::fetch_assoc($res)) {
  24. $t_course = Database::get_course_table(TABLE_COURSE_SETTING,$row['db_name']);
  25. $sql_course = "DELETE FROM $t_course WHERE variable = 'big_blue_button_meeting_name'";
  26. $r = Database::query($sql_course);
  27. $sql_course = "DELETE FROM $t_course WHERE variable = 'big_blue_button_attendee_password'";
  28. $r = Database::query($sql_course);
  29. $sql_course = "DELETE FROM $t_course WHERE variable = 'big_blue_button_moderator_password'";
  30. $r = Database::query($sql_course);
  31. $sql_course = "DELETE FROM $t_course WHERE variable = 'big_blue_button_welcome_message'";
  32. $r = Database::query($sql_course);
  33. $t_tool = Database::get_course_table(TABLE_TOOL_LIST,$row['db_name']);
  34. $sql_course = "DELETE FROM $t_tool WHERE link = '../../plugin/bbb/start.php'";
  35. $r = Database::query($sql_course);
  36. }