/** * Load plugin configuration from database * * @param string $pi_name Plugin name * @return boolean true on success, otherwise false * @see plugin_initconfig_forum * */ function plugin_load_configuration_forum($pi_name) { global $_CONF; $base_path = $_CONF['path'] . 'plugins/' . $pi_name . '/'; require_once $_CONF['path_system'] . 'classes/config.class.php'; require_once $base_path . 'install_defaults.php'; return plugin_initconfig_forum(); }
/** * Loads the configuration records for the Online Config Manager * * @return boolean true = proceed with install, false = an error occured * */ function plugin_load_configuration_forum() { global $_CONF; require_once $_CONF['path'] . 'plugins/forum/install_defaults.php'; return plugin_initconfig_forum(); }
/** * Called by the plugin Editor to run the SQL Update for a plugin update */ function forum_upgrade() { global $_CONF, $_TABLES, $_FF_CONF, $_FF_CONF; require_once $_CONF['path_system'] . 'classes/config.class.php'; $curversion = DB_getItem($_TABLES['plugins'], 'pi_version', "pi_name = 'forum'"); switch ($curversion) { case "2.3": case "2.3.2": if (upgrade_232() == 0) { DB_query("UPDATE {$_TABLES['plugins']} SET `pi_version` = '2.5RC1' WHERE `pi_name` = 'forum' LIMIT 1"); } else { return false; } case "2.5RC1": if (upgrade_25() == 0) { DB_query("UPDATE {$_TABLES['plugins']} SET `pi_version` = '2.7', `pi_gl_version` = '1.4.1' WHERE `pi_name` = 'forum' LIMIT 1"); } else { return false; } case "2.6": case "2.7": case "2.7.1": case "2.7.2": if (upgrade_30() == 0) { DB_query("UPDATE {$_TABLES['plugins']} SET `pi_version` = '3.0', `pi_gl_version` = '1.0.0' WHERE `pi_name` = 'forum' LIMIT 1"); } else { return false; } case "3.0.0": case "3.0": // need to migrate the configuration to our new online configuration. require_once $_CONF['path_system'] . 'classes/config.class.php'; require_once $_CONF['path'] . 'plugins/forum/install_defaults.php'; plugin_initconfig_forum(); include $_CONF['path'] . 'plugins/forum/forum.php'; case "3.1.0.fusion": $c = config::get_instance(); $c->add('enable_fm_integration', 0, 'select', 0, 1, 0, 120, true, 'forum'); $c->add('allow_memberlist', 0, 'select', 0, 0, 0, 25, true, 'forum'); $c->del('show_popular_perpage', 'forum'); DB_query("UPDATE {$_TABLES['plugins']} SET pi_version = '3.1.1',pi_gl_version='1.1.2' WHERE pi_name = 'forum'"); case '3.1.1': case '3.1.2': case '3.1.3': $c = config::get_instance(); $c->add('enable_user_rating_system', FALSE, 'select', 0, 0, 0, 22, TRUE, 'forum'); $c->add('bbcode_signature', TRUE, 'select', 0, 0, 0, 37, true, 'forum'); $c->add('use_wysiwyg_editor', false, 'select', 0, 2, 0, 85, true, 'forum'); DB_query("ALTER TABLE {$_TABLES['ff_forums']} ADD `rating_view` INT( 8 ) NOT NULL ,ADD `rating_post` INT( 8 ) NOT NULL", 1); DB_query("ALTER TABLE {$_TABLES['ff_userinfo']} ADD `rating` INT( 8 ) NOT NULL "); DB_query("ALTER TABLE {$_TABLES['ff_userinfo']} ADD signature MEDIUMTEXT"); DB_query("ALTER TABLE {$_TABLES['ff_userprefs']} ADD notify_full tinyint(1) NOT NULL DEFAULT '0' AFTER alwaysnotify"); $sql = "CREATE TABLE IF NOT EXISTS {$_TABLES['ff_rating_assoc']} ( " . "`user_id` mediumint( 9 ) NOT NULL , " . "`voter_id` mediumint( 9 ) NOT NULL , " . "`grade` smallint( 6 ) NOT NULL , " . "`topic_id` int( 11 ) NOT NULL , " . " KEY `user_id` (`user_id`), " . " KEY `voter_id` (`voter_id`) );"; DB_query($sql); // add forum.html feature DB_query("INSERT INTO {$_TABLES['features']} (ft_name, ft_descr, ft_gl_core) VALUES ('forum.html','Can post using HTML',0)", 1); $ft_id = DB_insertId(); $grp_id = intval(DB_getItem($_TABLES['groups'], 'grp_id', "grp_name = 'forum Admin'")); DB_query("INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES ({$ft_id}, {$grp_id})", 1); DB_query("UPDATE {$_TABLES['plugins']} SET pi_version = '3.1.4',pi_gl_version='1.1.5' WHERE pi_name = 'forum'"); case '3.1.4': DB_query("ALTER TABLE {$_TABLES['ff_rating_assoc']} DROP PRIMARY KEY", 1); DB_query("UPDATE {$_TABLES['plugins']} SET pi_version = '3.1.5',pi_gl_version='1.1.6' WHERE pi_name = 'forum'"); case '3.1.5': case '3.1.6': case '3.1.7': DB_query("ALTER TABLE {$_TABLES['ff_userprefs']} ADD topic_order varchar(10) NOT NULL DEFAULT 'ASC' AFTER notify_once"); DB_query("ALTER TABLE {$_TABLES['ff_userprefs']} ADD use_wysiwyg_editor tinyint(3) NOT NULL DEFAULT '1' AFTER topic_order"); DB_query("ALTER TABLE {$_TABLES['ff_topic']} ADD `status` int(10) unsigned NOT NULL DEFAULT '0' AFTER locked"); $c = config::get_instance(); $c->add('bbcode_disabled', 0, 'select', 0, 2, 6, 165, true, 'forum'); $c->add('smilies_disabled', 0, 'select', 0, 2, 6, 170, true, 'forum'); $c->add('urlparse_disabled', 0, 'select', 0, 2, 6, 175, true, 'forum'); case '3.2.0': // convert watch records $c = config::get_instance(); $c->del('pre2.5_mode', 'forum'); $c->del('mysql4+', 'forum'); $c->add('use_sfs', true, 'select', 0, 2, 0, 135, true, 'forum'); DB_query("UPDATE {$_TABLES['conf_values']} SET value='s:11:\"m/d/y h:i a\";' WHERE name='default_Datetime_format' AND group_name='forum'"); DB_query("UPDATE {$_TABLES['conf_values']} SET value='s:11:\"M d Y H:i a\";' WHERE name='default_Topic_Datetime_format' AND group_name='forum'"); _forum_cvt_watch(); // drop watch table // attachment handling... DB_query("ALTER TABLE {$_TABLES['ff_topic']} ADD attachments INT NOT NULL DEFAULT '0' AFTER views"); $sql = "SELECT id FROM {$_TABLES['ff_topic']} WHERE pid=0"; $result = DB_query($sql); while ($F = DB_fetchArray($result)) { $sql = "SELECT count(*) AS count FROM {$_TABLES['ff_topic']} topic left join {$_TABLES['ff_attachments']} att ON topic.id=att.topic_id WHERE (topic.id=" . (int) $F['id'] . " OR topic.pid=" . $F['id'] . ") and att.filename <> ''"; $attResult = DB_query($sql); if (DB_numRows($attResult) > 0) { list($attCount) = DB_fetchArray($attResult); DB_query("UPDATE {$_TABLES['ff_topic']} SET attachments=" . $attCount . " WHERE id=" . (int) $F['id']); } } DB_query("UPDATE {$_TABLES['plugins']} SET pi_version = '3.3.0',pi_gl_version='1.3.0' WHERE pi_name = 'forum'"); case '3.3.0': $c = config::get_instance(); $c->add('allowed_html', 'p,b,i,strong,em,br,pre,img,ol,ul,li,u', 'text', 0, 2, 0, 82, true, 'forum'); DB_query("UPDATE {$_TABLES['plugins']} SET pi_version = '3.3.1',pi_gl_version='1.4.0' WHERE pi_name = 'forum'"); default: DB_query("ALTER TABLE {$_TABLES['ff_forums']} DROP INDEX forum_id", 1); DB_query("ALTER TABLE {$_TABLES['ff_rating_assoc']} DROP PRIMARY KEY", 1); DB_query("UPDATE {$_TABLES['plugins']} SET pi_version = '" . $_FF_CONF['pi_version'] . "',pi_gl_version='" . $_FF_CONF['gl_version'] . "' WHERE pi_name = 'forum'"); return true; } }