123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103 |
- <?php
- class OpenMeetingsPlugin extends Plugin
- {
- public $isCoursePlugin = true;
-
- public $course_settings = array(array(
- 'name' => 'openmeetings_record_and_store',
- 'type' => 'checkbox'
- ));
- public static function create()
- {
- static $result = null;
- return $result ? $result : $result = new self();
- }
- protected function __construct()
- {
- parent::__construct('2.0', 'Francis Gonzales', array('tool_enable' => 'boolean', 'host' =>'text', 'user' => 'text', 'pass' => 'text'));
- }
- public function install()
- {
- $table = Database::get_main_table('plugin_openmeetings');
-
-
-
-
- $sql = "CREATE TABLE IF NOT EXISTS $table (
- id INT unsigned NOT NULL auto_increment PRIMARY KEY,
- c_id INT unsigned NOT NULL DEFAULT 0,
- session_id INT unsigned NOT NULL DEFAULT 0,
- room_id INT unsigned NOT NULL DEFAULT 0,
- meeting_name VARCHAR(255) NOT NULL DEFAULT '',
- attendee_pw VARCHAR(255) NOT NULL DEFAULT '',
- moderator_pw VARCHAR(255) NOT NULL DEFAULT '',
- record INT NOT NULL DEFAULT 0,
- status INT NOT NULL DEFAULT 0,
- created_at DATETIME NOT NULL,
- closed_at DATETIME,
- calendar_id INT DEFAULT 0,
- welcome_msg TEXT NOT NULL DEFAULT '')";
- Database::query($sql);
-
- $this->install_course_fields_in_all_courses();
- }
- public function uninstall()
- {
- $t_settings = Database::get_main_table(TABLE_MAIN_SETTINGS_CURRENT);
- $t_options = Database::get_main_table(TABLE_MAIN_SETTINGS_OPTIONS);
- $t_tool = Database::get_course_table(TABLE_TOOL_LIST);
-
- $sql = "DELETE FROM $t_settings WHERE variable = 'openmeetings_tool_enable'";
- Database::query($sql);
- $sql = "DELETE FROM $t_settings WHERE variable = 'openmeetings_pass'";
- Database::query($sql);
- $sql = "DELETE FROM $t_settings WHERE variable = 'openmeetings_user'";
- Database::query($sql);
- $sql = "DELETE FROM $t_settings WHERE variable = 'openmeetings_host'";
- Database::query($sql);
-
- $sql = "DELETE FROM $t_settings WHERE variable = 'openmeetings_plugin'";
- Database::query($sql);
- $sql = "DELETE FROM $t_options WHERE variable = 'openmeetings_plugin'";
- Database::query($sql);
-
- $sql = "DELETE FROM $t_tool WHERE name = 'openmeetings' AND c_id = c_id";
- Database::query($sql);
- $t = Database::get_main_table('plugin_openmeetings');
- $sql = "DROP TABLE IF EXISTS $t";
- Database::query($sql);
-
- $this->uninstall_course_fields_in_all_courses($this->course_settings);
- }
-
- public function course_install($course_id, $add_tool_link = true)
- {
-
- $this->install_course_fields($course_id, $add_tool_link);
- }
- }
|