uninstall.php 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  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. * @package chamilo.plugin.bigbluebutton
  7. */
  8. /**
  9. * Queries
  10. */
  11. $t_settings = Database::get_main_table(TABLE_MAIN_SETTINGS_CURRENT);
  12. $t_options = Database::get_main_table(TABLE_MAIN_SETTINGS_OPTIONS);
  13. $sql = "DELETE FROM $t_settings WHERE variable = 'bbb_plugin'";
  14. Database::query($sql);
  15. $sql = "DELETE FROM $t_options WHERE variable = 'bbb_plugin'";
  16. Database::query($sql);
  17. $sql = "DELETE FROM $t_settings WHERE variable = 'bbb_plugin_host'";
  18. Database::query($sql);
  19. $sql = "DELETE FROM $t_settings WHERE variable = 'bbb_plugin_salt'";
  20. Database::query($sql);
  21. $sql = "DROP TABLE plugin_bbb";
  22. Database::query($sql);
  23. // update existing courses to add conference settings
  24. $t_courses = Database::get_main_table(TABLE_MAIN_COURSE);
  25. $sql = "SELECT id, code, db_name FROM $t_courses ORDER BY id";
  26. $res = Database::query($sql);
  27. while ($row = Database::fetch_assoc($res)) {
  28. $t_course = Database::get_course_table(TABLE_COURSE_SETTING,$row['db_name']);
  29. $sql_course = "DELETE FROM $t_course WHERE variable = 'big_blue_button_meeting_name'";
  30. $r = Database::query($sql_course);
  31. $sql_course = "DELETE FROM $t_course WHERE variable = 'big_blue_button_attendee_password'";
  32. $r = Database::query($sql_course);
  33. $sql_course = "DELETE FROM $t_course WHERE variable = 'big_blue_button_moderator_password'";
  34. $r = Database::query($sql_course);
  35. $sql_course = "DELETE FROM $t_course WHERE variable = 'big_blue_button_welcome_message'";
  36. $r = Database::query($sql_course);
  37. $t_tool = Database::get_course_table(TABLE_TOOL_LIST,$row['db_name']);
  38. $sql_course = "DELETE FROM $t_tool WHERE link = '../../plugin/bbb/start.php'";
  39. $r = Database::query($sql_course);
  40. }