/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('group_zone_access');
$GLOBALS['SITE_DB']->drop_if_exists('group_page_access');
$GLOBALS['SITE_DB']->drop_if_exists('match_key_messages');
delete_specific_permission('edit_own_lowrange_content');
delete_specific_permission('submit_highrange_content');
delete_specific_permission('submit_midrange_content');
delete_specific_permission('submit_lowrange_content');
delete_specific_permission('set_own_author_profile');
delete_specific_permission('rate');
delete_specific_permission('vote_in_polls');
delete_specific_permission('comment');
delete_specific_permission('have_personal_category');
delete_specific_permission('draw_to_server');
delete_specific_permission('see_unvalidated');
delete_specific_permission('jump_to_unvalidated');
delete_specific_permission('use_very_dangerous_comcode');
delete_specific_permission('open_virtual_roots');
delete_specific_permission('scheduled_publication_times');
delete_specific_permission('mass_delete_from_ip');
delete_specific_permission('exceed_filesize_limit');
delete_specific_permission('view_revision_history');
delete_specific_permission('sees_javascript_error_alerts');
delete_specific_permission('avoid_simplified_adminzone_look');
delete_specific_permission('see_software_docs');
delete_specific_permission('bypass_validation_lowrange_content');
delete_specific_permission('may_enable_staff_notifications');
$false_permissions = get_false_permissions();
foreach ($false_permissions as $permission) {
delete_specific_permission($permission[1]);
}
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('chargelog');
$GLOBALS['SITE_DB']->drop_if_exists('gifts');
delete_config_option('points_joining');
delete_config_option('points_posting');
delete_config_option('points_rating');
delete_config_option('points_voting');
delete_config_option('points_per_day');
delete_config_option('points_per_daily_visit');
delete_config_option('points_if_liked');
delete_config_option('points_show_personal_stats_points_left');
delete_config_option('points_show_personal_stats_points_used');
delete_config_option('points_show_personal_stats_gift_points_left');
delete_config_option('points_show_personal_stats_gift_points_used');
delete_config_option('points_show_personal_stats_total_points');
delete_config_option('points_show_personal_profile_link');
delete_specific_permission('give_points_self');
delete_specific_permission('have_negative_gift_points');
delete_specific_permission('give_negative_points');
delete_specific_permission('view_charge_log');
delete_specific_permission('use_points');
delete_specific_permission('trace_anonymous_gifts');
delete_menu_item_simple('_SEARCH:points:type=member:id={$USER_OVERIDE}');
delete_menu_item_simple('_SEARCH:points:type=member');
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('chat_rooms');
$GLOBALS['SITE_DB']->drop_if_exists('chat_messages');
$GLOBALS['SITE_DB']->drop_if_exists('chat_blocking');
$GLOBALS['SITE_DB']->drop_if_exists('chat_buddies');
$GLOBALS['SITE_DB']->drop_if_exists('chat_active');
$GLOBALS['SITE_DB']->drop_if_exists('chat_events');
$GLOBALS['SITE_DB']->drop_if_exists('chat_sound_effects');
delete_config_option('is_on_chat');
delete_config_option('chat_flood_timelimit');
delete_config_option('chat_default_post_colour');
delete_config_option('chat_default_post_font');
delete_config_option('chat_private_room_deletion_time');
delete_config_option('username_click_im');
delete_config_option('points_chat');
delete_config_option('chat_show_stats_count_users');
delete_config_option('chat_show_stats_count_rooms');
delete_config_option('chat_show_stats_count_messages');
delete_config_option('sitewide_im');
delete_config_option('group_private_chatrooms');
delete_specific_permission('create_private_room');
delete_specific_permission('start_im');
delete_specific_permission('moderate_my_private_rooms');
delete_specific_permission('ban_chatters_from_rooms');
$GLOBALS['SITE_DB']->query_delete('group_page_access', array('page_name' => 'cms_chat'));
$GLOBALS['SITE_DB']->query_delete('group_category_access', array('module_the_name' => 'chat'));
delete_menu_item_simple('_SEARCH:chat:type=misc');
delete_menu_item_simple('_SEARCH:chat:type=misc:member_id={$USER_OVERIDE}');
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('catalogues');
$GLOBALS['SITE_DB']->drop_if_exists('catalogue_fields');
$GLOBALS['SITE_DB']->drop_if_exists('catalogue_categories');
$GLOBALS['SITE_DB']->drop_if_exists('catalogue_entries');
$GLOBALS['SITE_DB']->drop_if_exists('catalogue_efv_long_trans');
$GLOBALS['SITE_DB']->drop_if_exists('catalogue_efv_short_trans');
$GLOBALS['SITE_DB']->drop_if_exists('catalogue_efv_long');
$GLOBALS['SITE_DB']->drop_if_exists('catalogue_efv_short');
$GLOBALS['SITE_DB']->drop_if_exists('catalogue_efv_float');
$GLOBALS['SITE_DB']->drop_if_exists('catalogue_efv_integer');
$GLOBALS['SITE_DB']->drop_if_exists('catalogue_entry_linkage');
$GLOBALS['SITE_DB']->drop_if_exists('catalogue_cat_treecache');
$GLOBALS['SITE_DB']->drop_if_exists('catalogue_childcountcache');
$GLOBALS['SITE_DB']->query_delete('group_category_access', array('module_the_name' => 'catalogues_category'));
$GLOBALS['SITE_DB']->query_delete('group_category_access', array('module_the_name' => 'catalogues_catalogue'));
$GLOBALS['SITE_DB']->query_delete('trackbacks', array('trackback_for_type' => 'catalogues'));
deldir_contents(get_custom_file_base() . '/uploads/catalogues', true);
delete_specific_permission('high_catalogue_entry_timeout');
delete_menu_item_simple('_SEARCH:catalogues:type=misc');
$cf = $GLOBALS['SITE_DB']->query_value_null_ok('menu_items', 'id', array('i_menu' => 'collab_features', 'i_url' => ''));
if (!is_null($cf)) {
delete_menu_item($cf);
}
delete_menu_item_simple('_SEARCH:catalogues:id=projects:type=index');
delete_menu_item_simple('_SEARCH:cms_catalogues:catalogue_name=projects:type=add_entry');
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('transactions');
$GLOBALS['SITE_DB']->drop_if_exists('trans_expecting');
delete_config_option('currency');
delete_config_option('ecommerce_test_mode');
delete_config_option('ipn_test');
delete_config_option('ipn');
delete_config_option('ipn_password');
delete_config_option('vpn_password');
delete_config_option('vpn_username');
delete_config_option('ipn_digest');
delete_config_option('payment_gateway');
delete_config_option('use_local_payment');
delete_config_option('pd_address');
delete_config_option('pd_email');
delete_config_option('pd_number');
delete_config_option('callback_password');
delete_specific_permission('access_ecommerce_in_test_mode');
delete_menu_item_simple('_SELF:purchase:type=misc');
delete_menu_item_simple('_SELF:invoices:type=misc');
delete_menu_item_simple('_SEARCH:purchase:type=misc');
delete_menu_item_simple('_SEARCH:invoices:type=misc');
delete_menu_item_simple('_SEARCH:subscriptions:type=misc');
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('iotd');
delete_specific_permission('choose_iotd');
$GLOBALS['SITE_DB']->query_delete('trackbacks', array('trackback_for_type' => 'iotds'));
deldir_contents(get_custom_file_base() . '/uploads/iotds', true);
delete_config_option('points_ADD_IOTD');
delete_config_option('points_CHOOSE_IOTD');
delete_config_option('iotd_update_time');
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('test_sections');
$GLOBALS['SITE_DB']->drop_if_exists('tests');
delete_specific_permission('perform_tests');
delete_specific_permission('add_tests');
delete_specific_permission('edit_own_tests');
delete_config_option('tester_forum_name');
delete_config_option('bug_report_text');
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('poll');
$GLOBALS['SITE_DB']->drop_if_exists('poll_votes');
delete_specific_permission('choose_poll');
$GLOBALS['SITE_DB']->query_delete('trackbacks', array('trackback_for_type' => 'polls'));
delete_config_option('points_ADD_POLL');
delete_config_option('points_CHOOSE_POLL');
delete_config_option('poll_update_time');
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('filedump');
delete_specific_permission('delete_anything_filedump');
delete_specific_permission('upload_filedump');
delete_specific_permission('upload_anything_filedump');
//deldir_contents(get_custom_file_base().'/uploads/filedump',true);
delete_menu_item_simple('_SEARCH:filedump:type=misc');
delete_config_option('filedump_show_stats_count_total_files');
delete_config_option('filedump_show_stats_count_total_space');
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('ticket_types');
$GLOBALS['SITE_DB']->drop_if_exists('tickets');
delete_config_option('ticket_text');
delete_config_option('ticket_forum_name');
delete_config_option('ticket_member_forums');
delete_config_option('ticket_type_forums');
delete_specific_permission('view_others_tickets');
delete_specific_permission('support_operator');
$GLOBALS['SITE_DB']->query_delete('group_category_access', array('module_the_name' => 'tickets'));
delete_menu_item_simple('_SEARCH:tickets:type=misc');
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('quizzes');
$GLOBALS['SITE_DB']->drop_if_exists('quiz_questions');
$GLOBALS['SITE_DB']->drop_if_exists('quiz_question_answers');
$GLOBALS['SITE_DB']->drop_if_exists('quiz_entries');
$GLOBALS['SITE_DB']->drop_if_exists('quiz_member_last_visit');
$GLOBALS['SITE_DB']->drop_if_exists('quiz_winner');
$GLOBALS['SITE_DB']->drop_if_exists('quiz_entry_answer');
delete_config_option('points_ADD_QUIZ');
delete_config_option('quiz_show_stats_count_total_open');
delete_specific_permission('bypass_quiz_repeat_time_restriction');
delete_menu_item_simple('_SEARCH:quiz:type=misc');
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('newsletter');
$GLOBALS['SITE_DB']->drop_if_exists('newsletters');
$GLOBALS['SITE_DB']->drop_if_exists('newsletter_archive');
$GLOBALS['SITE_DB']->drop_if_exists('newsletter_subscribe');
$GLOBALS['SITE_DB']->drop_if_exists('newsletter_drip_send');
$GLOBALS['SITE_DB']->drop_if_exists('newsletter_periodic');
delete_config_option('newsletter_text');
delete_config_option('newsletter_title');
delete_config_option('interest_levels');
delete_value('newsletter_whatsnew');
delete_value('newsletter_send_time');
delete_specific_permission('change_newsletter_subscriptions');
delete_menu_item_simple('_SEARCH:newsletter:type=misc');
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('banners');
$GLOBALS['SITE_DB']->drop_if_exists('banner_types');
$GLOBALS['SITE_DB']->drop_if_exists('banner_clicks');
$GLOBALS['SITE_DB']->query_delete('group_category_access', array('module_the_name' => 'banners'));
delete_config_option('is_on_banners');
delete_config_option('money_ad_code');
delete_config_option('use_banner_permissions');
delete_config_option('advert_chance');
delete_config_option('points_ADD_BANNER');
delete_config_option('admin_banners');
delete_config_option('banner_autosize');
delete_specific_permission('full_banner_setup');
delete_specific_permission('view_anyones_banner_stats');
delete_specific_permission('banner_free');
deldir_contents(get_custom_file_base() . '/uploads/banners', true);
//delete_menu_item_simple('_SEARCH:donate');
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('url_id_monikers');
$GLOBALS['SITE_DB']->drop_if_exists('cache');
$GLOBALS['SITE_DB']->drop_if_exists('cache_on');
$GLOBALS['SITE_DB']->drop_if_exists('security_images');
$GLOBALS['SITE_DB']->drop_if_exists('rating');
$GLOBALS['SITE_DB']->drop_if_exists('member_tracking');
$GLOBALS['SITE_DB']->drop_if_exists('trackbacks');
$GLOBALS['SITE_DB']->drop_if_exists('menu_items');
$GLOBALS['SITE_DB']->drop_if_exists('long_values');
$GLOBALS['SITE_DB']->drop_if_exists('tutorial_links');
$GLOBALS['SITE_DB']->drop_if_exists('translate_history');
$GLOBALS['SITE_DB']->drop_if_exists('edit_pings');
$GLOBALS['SITE_DB']->drop_if_exists('validated_once');
$GLOBALS['SITE_DB']->drop_if_exists('msp');
$GLOBALS['SITE_DB']->drop_if_exists('member_zone_access');
$GLOBALS['SITE_DB']->drop_if_exists('member_page_access');
$GLOBALS['SITE_DB']->drop_if_exists('member_category_access');
$GLOBALS['SITE_DB']->drop_if_exists('tracking');
$GLOBALS['SITE_DB']->drop_if_exists('sms_log');
$GLOBALS['SITE_DB']->drop_if_exists('confirmed_mobiles');
$GLOBALS['SITE_DB']->drop_if_exists('autosave');
$GLOBALS['SITE_DB']->drop_if_exists('messages_to_render');
$GLOBALS['SITE_DB']->drop_if_exists('url_title_cache');
$GLOBALS['SITE_DB']->drop_if_exists('review_supplement');
$GLOBALS['SITE_DB']->drop_if_exists('logged_mail_messages');
$GLOBALS['SITE_DB']->drop_if_exists('link_tracker');
$GLOBALS['SITE_DB']->drop_if_exists('incoming_uploads');
$GLOBALS['SITE_DB']->drop_if_exists('f_group_member_timeouts');
$GLOBALS['SITE_DB']->drop_if_exists('temp_block_permissions');
$GLOBALS['SITE_DB']->drop_if_exists('cron_caching_requests');
$GLOBALS['SITE_DB']->drop_if_exists('notifications_enabled');
$GLOBALS['SITE_DB']->drop_if_exists('digestives_tin');
$GLOBALS['SITE_DB']->drop_if_exists('digestives_consumed');
delete_specific_permission('reuse_others_attachments');
delete_specific_permission('use_sms');
delete_specific_permission('sms_higher_limit');
delete_specific_permission('sms_higher_trigger_limit');
delete_specific_permission('assume_any_member');
delete_config_option('url_monikers_enabled');
}
/**
* Standard modular install function.
*
* @param ?integer What version we're upgrading from (NULL: new install)
* @param ?integer What hack version we're upgrading from (NULL: new-install/not-upgrading-from-a-hacked-version)
*/
function install($upgrade_from = NULL, $upgrade_from_hack = NULL)
{
if (!is_null($upgrade_from) && $upgrade_from < 3) {
delete_specific_permission('choose_dotw');
delete_config_option('dotw_update_time');
$GLOBALS['SITE_DB']->rename_table('dotw', 'award_archive');
$GLOBALS['SITE_DB']->add_table_field('award_archive', 'a_type_id', 'AUTO_LINK', db_get_first_id());
$GLOBALS['SITE_DB']->alter_table_field('award_archive', 'id', 'ID_TEXT', 'content_id');
$GLOBALS['SITE_DB']->add_table_field('award_archive', 'member_id', 'USER', $GLOBALS['FORUM_DRIVER']->get_guest_id());
$GLOBALS['SITE_DB']->change_primary_key('award_archive', array('a_type_id', 'date_and_time'));
}
if (is_null($upgrade_from)) {
$GLOBALS['SITE_DB']->create_table('award_archive', array('a_type_id' => '*AUTO_LINK', 'date_and_time' => '*TIME', 'content_id' => 'ID_TEXT', 'member_id' => 'USER'));
}
$GLOBALS['SITE_DB']->create_index('award_archive', 'awardquicksearch', array('content_id'));
if (!is_null($upgrade_from) && $upgrade_from < 3 || is_null($upgrade_from)) {
$GLOBALS['SITE_DB']->create_table('award_types', array('id' => '*AUTO', 'a_title' => 'SHORT_TRANS', 'a_description' => 'LONG_TRANS', 'a_points' => 'INTEGER', 'a_content_type' => 'ID_TEXT', 'a_hide_awardee' => 'BINARY', 'a_update_time_hours' => 'INTEGER'));
require_lang('awards');
$GLOBALS['SITE_DB']->query_insert('award_types', array('a_title' => lang_code_to_default_content('DOTW'), 'a_description' => lang_code_to_default_content('DESCRIPTION_DOTW'), 'a_points' => 0, 'a_content_type' => 'download', 'a_hide_awardee' => 1, 'a_update_time_hours' => 168));
}
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('galleries');
$GLOBALS['SITE_DB']->drop_if_exists('images');
$GLOBALS['SITE_DB']->drop_if_exists('videos');
$GLOBALS['SITE_DB']->drop_if_exists('video_transcoding');
delete_config_option('default_video_width');
delete_config_option('default_video_height');
delete_config_option('maximum_image_size');
delete_config_option('max_personal_gallery_images_low');
delete_config_option('max_personal_gallery_images_high');
delete_config_option('max_personal_gallery_videos_low');
delete_config_option('max_personal_gallery_videos_high');
delete_config_option('points_ADD_IMAGE');
delete_config_option('points_ADD_VIDEO');
delete_config_option('galleries_show_stats_count_galleries');
delete_config_option('galleries_show_stats_count_images');
delete_config_option('galleries_show_stats_count_videos');
delete_config_option('show_empty_galleries');
delete_config_option('gallery_name_order');
delete_config_option('gallery_selectors');
delete_config_option('reverse_thumb_order');
delete_config_option('show_gallery_counts');
delete_config_option('video_bitrate');
delete_config_option('audio_bitrate');
delete_config_option('ffmpeg_path');
delete_config_option('transcoding_server');
delete_config_option('transcoding_zencoder_api_key');
delete_config_option('transcoding_zencoder_ftp_path');
delete_config_option('video_width_setting');
delete_config_option('video_height_setting');
delete_specific_permission('may_download_gallery');
delete_specific_permission('high_personal_gallery_limit');
delete_specific_permission('no_personal_gallery_limit');
$GLOBALS['SITE_DB']->query_delete('group_category_access', array('module_the_name' => 'galleries'));
$GLOBALS['SITE_DB']->query_delete('trackbacks', array('trackback_for_type' => 'galleries'));
deldir_contents(get_custom_file_base() . '/uploads/galleries', true, true);
deldir_contents(get_custom_file_base() . '/uploads/galleries_thumbs', true);
delete_menu_item_simple('_SEARCH:galleries:type=misc');
}
/**
* Standard modular uninstall function.
*/
function uninstall()
{
$GLOBALS['SITE_DB']->drop_if_exists('w_attempts');
$GLOBALS['SITE_DB']->drop_if_exists('w_inventory');
$GLOBALS['SITE_DB']->drop_if_exists('w_itemdef');
$GLOBALS['SITE_DB']->drop_if_exists('w_items');
$GLOBALS['SITE_DB']->drop_if_exists('w_members');
$GLOBALS['SITE_DB']->drop_if_exists('w_messages');
$GLOBALS['SITE_DB']->drop_if_exists('w_portals');
$GLOBALS['SITE_DB']->drop_if_exists('w_realms');
$GLOBALS['SITE_DB']->drop_if_exists('w_rooms');
$GLOBALS['SITE_DB']->drop_if_exists('w_travelhistory');
deldir_contents(get_custom_file_base() . '/uploads/ocworld', true);
require_code('ocworld');
if (addon_installed('pointstore')) {
$prices = get_ocworld_prices_default();
foreach (array_keys($prices) as $name) {
$GLOBALS['SITE_DB']->query_delete('prices', array('name' => $name), '', 1);
}
}
delete_specific_permission('administer_ocworld');
}
/**
* Standard modular install function.
*
* @param ?integer What version we're upgrading from (NULL: new install)
* @param ?integer What hack version we're upgrading from (NULL: new-install/not-upgrading-from-a-hacked-version)
*/
function install($upgrade_from = NULL, $upgrade_from_hack = NULL)
{
require_lang('calendar');
if (is_null($upgrade_from)) {
add_specific_permission('CALENDAR', 'view_calendar', true);
add_specific_permission('CALENDAR', 'add_public_events', true);
add_specific_permission('CALENDAR', 'view_personal_events', false, true);
add_specific_permission('CALENDAR', 'sense_personal_conflicts', false);
add_specific_permission('CALENDAR', 'view_event_subscriptions', false);
$GLOBALS['SITE_DB']->create_table('calendar_events', array('id' => '*AUTO', 'e_submitter' => 'USER', 'e_views' => 'INTEGER', 'e_title' => 'SHORT_TRANS', 'e_content' => 'LONG_TRANS', 'e_add_date' => 'TIME', 'e_edit_date' => '?TIME', 'e_recurrence' => 'ID_TEXT', 'e_recurrences' => '?INTEGER', 'e_seg_recurrences' => 'BINARY', 'e_start_year' => 'INTEGER', 'e_start_month' => 'INTEGER', 'e_start_day' => 'INTEGER', 'e_start_hour' => '?INTEGER', 'e_start_minute' => '?INTEGER', 'e_end_year' => '?INTEGER', 'e_end_month' => '?INTEGER', 'e_end_day' => '?INTEGER', 'e_end_hour' => '?INTEGER', 'e_end_minute' => '?INTEGER', 'e_timezone' => 'ID_TEXT', 'e_do_timezone_conv' => 'BINARY', 'e_is_public' => 'BINARY', 'e_priority' => 'INTEGER', 'allow_rating' => 'BINARY', 'allow_comments' => 'SHORT_INTEGER', 'allow_trackbacks' => 'BINARY', 'notes' => 'LONG_TEXT', 'e_type' => 'AUTO_LINK', 'validated' => 'BINARY'));
$GLOBALS['SITE_DB']->create_index('calendar_events', 'e_views', array('e_views'));
$GLOBALS['SITE_DB']->create_index('calendar_events', 'ces', array('e_submitter'));
$GLOBALS['SITE_DB']->create_index('calendar_events', 'publicevents', array('e_is_public'));
$GLOBALS['SITE_DB']->create_index('calendar_events', 'e_type', array('e_type'));
$GLOBALS['SITE_DB']->create_index('calendar_events', 'eventat', array('e_start_year', 'e_start_month', 'e_start_day', 'e_start_hour', 'e_start_minute'));
$GLOBALS['SITE_DB']->create_index('calendar_events', 'e_add_date', array('e_add_date'));
$GLOBALS['SITE_DB']->create_index('calendar_events', 'validated', array('validated'));
$GLOBALS['SITE_DB']->create_table('calendar_types', array('id' => '*AUTO', 't_title' => 'SHORT_TRANS', 't_logo' => 'SHORT_TEXT', 't_external_feed' => 'URLPATH'));
$default_types = array('system_command', 'general', 'birthday', 'public_holiday', 'vacation', 'appointment', 'commitment', 'anniversary');
foreach ($default_types as $type) {
$GLOBALS['SITE_DB']->query_insert('calendar_types', array('t_external_feed' => '', 't_title' => lang_code_to_default_content('DEFAULT_CALENDAR_TYPE__' . $type), 't_logo' => 'calendar/' . $type));
}
$GLOBALS['SITE_DB']->create_table('calendar_reminders', array('id' => '*AUTO', 'e_id' => 'AUTO_LINK', 'n_member_id' => 'USER', 'n_seconds_before' => 'INTEGER'));
$GLOBALS['SITE_DB']->create_table('calendar_interests', array('i_member_id' => '*USER', 't_type' => '*AUTO_LINK'));
}
if (is_null($upgrade_from) || $upgrade_from < 3) {
$GLOBALS['SITE_DB']->create_table('calendar_jobs', array('id' => '*AUTO', 'j_time' => 'TIME', 'j_reminder_id' => '?AUTO_LINK', 'j_member_id' => '?USER', 'j_event_id' => 'AUTO_LINK'));
$GLOBALS['SITE_DB']->create_index('calendar_jobs', 'applicablejobs', array('j_time'));
}
if (!is_null($upgrade_from) && $upgrade_from < 3) {
$GLOBALS['SITE_DB']->alter_table_field('calendar_events', 'e_edit_date', '?TIME');
$GLOBALS['SITE_DB']->alter_table_field('calendar_events', 'e_end_minute', '?INTEGER');
$GLOBALS['SITE_DB']->alter_table_field('calendar_events', 'e_end_hour', '?INTEGER');
$GLOBALS['SITE_DB']->alter_table_field('calendar_events', 'e_end_day', '?INTEGER');
$GLOBALS['SITE_DB']->alter_table_field('calendar_events', 'e_end_month', '?INTEGER');
$GLOBALS['SITE_DB']->alter_table_field('calendar_events', 'e_end_year', '?INTEGER');
}
if (!is_null($upgrade_from) && $upgrade_from < 4) {
$GLOBALS['SITE_DB']->add_table_field('calendar_events', 'allow_rating', 'BINARY', 0);
$GLOBALS['SITE_DB']->add_table_field('calendar_events', 'allow_comments', 'SHORT_INTEGER', 0);
$GLOBALS['SITE_DB']->add_table_field('calendar_events', 'allow_trackbacks', 'BINARY', 0);
$GLOBALS['SITE_DB']->add_table_field('calendar_events', 'notes', 'LONG_TEXT');
$GLOBALS['SITE_DB']->add_table_field('calendar_events', 'validated', 'BINARY', 1);
delete_specific_permission('edit_owned_events');
delete_specific_permission('edit_viewable_events');
add_config_option('ADD_CALENDAR_EVENT', 'points_ADD_CALENDAR_EVENT', 'integer', 'return addon_installed(\'points\')?\'2\':NULL;', 'POINTS', 'COUNT_POINTS_GIVEN');
$GLOBALS['SITE_DB']->rename_table('calendar_declarations_of_interest', 'calendar_interests');
}
if (!is_null($upgrade_from) && $upgrade_from < 5) {
$GLOBALS['SITE_DB']->add_table_field('calendar_events', 'e_seg_recurrences', 'BINARY', 0);
}
if (is_null($upgrade_from) || $upgrade_from < 5) {
add_config_option('EVENTS', 'calendar_show_stats_count_events', 'tick', 'return addon_installed(\'stats_block\')?\'0\':NULL;', 'BLOCKS', 'STATISTICS');
add_config_option('_EVENTS_THIS_WEEK', 'calendar_show_stats_count_events_this_week', 'tick', 'return addon_installed(\'stats_block\')?\'0\':NULL;', 'BLOCKS', 'STATISTICS');
add_config_option('_EVENTS_THIS_MONTH', 'calendar_show_stats_count_events_this_month', 'tick', 'return addon_installed(\'stats_block\')?\'0\':NULL;', 'BLOCKS', 'STATISTICS');
add_config_option('_EVENTS_THIS_YEAR', 'calendar_show_stats_count_events_this_year', 'tick', 'return addon_installed(\'stats_block\')?\'0\':NULL;', 'BLOCKS', 'STATISTICS');
$GLOBALS['SITE_DB']->create_index('calendar_events', 'ftjoin_etitle', array('e_title'));
$GLOBALS['SITE_DB']->create_index('calendar_events', 'ftjoin_econtent', array('e_content'));
}
if (!is_null($upgrade_from) && $upgrade_from < 6) {
$GLOBALS['SITE_DB']->delete_table_field('calendar_events', 'e_geo_position');
$GLOBALS['SITE_DB']->delete_table_field('calendar_events', 'e_groups_access');
$GLOBALS['SITE_DB']->delete_table_field('calendar_events', 'e_groups_modify');
$GLOBALS['SITE_DB']->add_table_field('calendar_events', 'e_timezone', 'ID_TEXT');
$GLOBALS['SITE_DB']->add_table_field('calendar_events', 'e_do_timezone_conv', 'BINARY');
$GLOBALS['SITE_DB']->alter_table_field('calendar_events', 'e_start_hour', '?INTEGER');
$GLOBALS['SITE_DB']->alter_table_field('calendar_events', 'e_start_minute', '?INTEGER');
$GLOBALS['SITE_DB']->add_table_field('calendar_types', 't_external_feed', 'URLPATH');
}
if (is_null($upgrade_from) || $upgrade_from < 6) {
$admin_groups = $GLOBALS['FORUM_DRIVER']->get_super_admin_groups();
$groups = $GLOBALS['FORUM_DRIVER']->get_usergroup_list(false, true);
// Save in permissions for event type
$types = $GLOBALS['SITE_DB']->query_select('calendar_types');
foreach ($types as $type) {
foreach (array_keys($groups) as $group_id) {
if (in_array($group_id, $admin_groups)) {
continue;
}
$GLOBALS['SITE_DB']->query_insert('group_category_access', array('module_the_name' => 'calendar', 'category_name' => strval($type['id']), 'group_id' => $group_id));
}
}
}
}
/**
* Install/upgrade OCF.
*
* @param ?float The version to upgrade from (NULL: fresh install).
*/
function install_ocf($upgrade_from = NULL)
{
require_code('ocf_members');
require_code('ocf_topics');
require_code('ocf_groups');
require_code('ocf_forums');
require_lang('ocf');
require_lang('ocf_config');
require_code('ocf_moderation_action');
require_code('ocf_posts_action');
require_code('ocf_members_action');
require_code('ocf_groups_action');
require_code('ocf_general_action');
require_code('ocf_forums_action');
require_code('ocf_topics_action');
require_code('database_action');
if (is_null($upgrade_from)) {
uninstall_ocf_everytime();
uninstall_ocf();
}
$test = $GLOBALS['FORUM_DB']->query('SELECT id FROM ' . $GLOBALS['FORUM_DB']->get_table_prefix() . 'f_forums', NULL, NULL, true);
$not_installed = is_null($test);
if ($not_installed) {
$upgrade_from = NULL;
}
if (is_null($upgrade_from) || $upgrade_from < 4.2) {
add_config_option('ENCRYPTION_KEY', 'encryption_key', 'line', 'require_code(\'encryption\');return is_encryption_available()?\'\':NULL;', 'PRIVACY', 'ADVANCED');
add_config_option('DECRYPTION_KEY', 'decryption_key', 'line', 'require_code(\'encryption\');return is_encryption_available()?\'\':NULL;', 'PRIVACY', 'ADVANCED');
add_config_option('IS_ON_POST_TITLES', 'is_on_post_titles', 'tick', 'return is_null($old=get_value(\'no_post_titles\'))?\'0\':invert_value($old);', 'SECTION_FORUMS', 'GENERAL');
add_config_option('IS_ON_ANONYMOUS_POSTS', 'is_on_anonymous_posts', 'tick', 'return is_null($old=get_value(\'ocf_no_anonymous_post\'))?\'0\':invert_value($old);', 'SECTION_FORUMS', 'GENERAL');
add_config_option('IS_ON_TIMEZONE_DETECTION', 'is_on_timezone_detection', 'tick', 'return is_null($old=get_value(\'no_js_timezone_detect\'))?\'0\':invert_value($old);', 'SECTION_FORUMS', 'GENERAL');
add_config_option('IS_ON_TOPIC_DESCRIPTIONS', 'is_on_topic_descriptions', 'tick', 'return is_null($old=get_value(\'no_topic_descriptions\'))?\'1\':invert_value($old);', 'SECTION_FORUMS', 'GENERAL');
add_config_option('IS_ON_TOPIC_EMOTICONS', 'is_on_topic_emoticons', 'tick', 'return is_null($old=get_value(\'ocf_no_topic_emoticons\'))?\'1\':invert_value($old);', 'SECTION_FORUMS', 'GENERAL');
add_config_option('DEFAULT_PREVIEW_GUESTS', 'default_preview_guests', 'tick', 'return is_null($old=get_value(\'no_default_preview_guests\'))?\'0\':invert_value($old);', 'SECTION_FORUMS', 'GENERAL');
add_config_option('FORCED_PREVIEW_OPTION', 'forced_preview_option', 'tick', 'return is_null($old=get_value(\'no_forced_preview_option\'))?\'0\':invert_value($old);', 'SECTION_FORUMS', 'GENERAL');
add_config_option('OVERT_WHISPER_SUGGESTION', 'overt_whisper_suggestion', 'tick', 'return is_null($old=get_value(\'disable_overt_whispering\'))?\'1\':invert_value($old);', 'SECTION_FORUMS', 'GENERAL');
add_config_option('IS_ON_INVISIBILITY', 'is_on_invisibility', 'tick', 'return is_null($old=get_value(\'no_invisible_option\'))?\'0\':invert_value($old);', 'SECTION_FORUMS', 'GENERAL');
add_config_option('ALLOW_ALPHA_SEARCH', 'allow_alpha_search', 'tick', 'return is_null($old=get_value(\'allow_alpha_search\'))?\'0\':$old;', 'SECTION_FORUMS', 'GENERAL');
add_config_option('ALLOW_EMAIL_DISABLE', 'allow_email_disable', 'tick', 'return is_null($old=get_value(\'disable_allow_emails_field\'))?\'1\':invert_value($old);', 'SECTION_FORUMS', 'GENERAL');
add_config_option('MAX_MEMBER_TITLE_LENGTH', 'max_member_title_length', 'integer', 'return addon_installed(\'ocf_member_titles\')?\'20\':NULL;', 'SECTION_FORUMS', 'GENERAL');
$GLOBALS['FORUM_DB']->drop_if_exists('f_member_cpf_perms');
$GLOBALS['FORUM_DB']->create_table('f_member_cpf_perms', array('member_id' => '*USER', 'field_id' => '*AUTO_LINK', 'guest_view' => 'BINARY', 'member_view' => 'BINARY', 'friend_view' => 'BINARY', 'group_view' => 'SHORT_TEXT'));
}
if (is_null($upgrade_from) || $upgrade_from < 2.5) {
add_config_option('HTTPAUTH_IS_ENABLED', 'httpauth_is_enabled', 'tick', 'return \'0\';', 'SECTION_FORUMS', 'ADVANCED', 1);
add_config_option('POST_HISTORY_DAYS', 'post_history_days', 'integer', 'return \'21\';', 'SECTION_FORUMS', 'GENERAL', 1);
}
if (is_null($upgrade_from)) {
// Add config options
add_config_option('FORUM_POSTS_PER_PAGE', 'forum_posts_per_page', 'integer', 'return has_no_forum()?NULL:\'20\';', 'SECTION_FORUMS', 'GENERAL');
add_config_option('FORUM_TOPICS_PER_PAGE', 'forum_topics_per_page', 'integer', 'return has_no_forum()?NULL:\'30\';', 'SECTION_FORUMS', 'GENERAL');
add_config_option('PREVENT_SHOUTING', 'prevent_shouting', 'tick', 'return has_no_forum()?NULL:\'1\';', 'SECTION_FORUMS', 'GENERAL');
add_config_option('RESTRICTED_USERNAMES', 'restricted_usernames', 'line', 'return do_lang(\'GUEST\').\', \'.do_lang(\'STAFF\').\', \'.do_lang(\'ADMIN\').\', \'.do_lang(\'MODERATOR\').\', googlebot\';', 'SECTION_FORUMS', 'GENERAL');
add_config_option('REQUIRE_NEW_MEMBER_VALIDATION', 'require_new_member_validation', 'tick', 'return \'0\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS');
add_config_option('REPORTED_POSTS_FORUM', 'reported_posts_forum', 'forum', 'return (has_no_forum()||(!addon_installed(\'ocf_reported_posts\')))?NULL:do_lang(\'ocf:REPORTED_POSTS_FORUM\');', 'SECTION_FORUMS', 'GENERAL');
add_config_option('ONE_PER_EMAIL_ADDRESS', 'one_per_email_address', 'tick', 'return \'1\';', 'SECTION_FORUMS', 'GENERAL');
add_config_option('HOT_TOPIC_DEFINITION', 'hot_topic_definition', 'integer', 'return has_no_forum()?NULL:\'20\';', 'SECTION_FORUMS', 'GENERAL');
}
if (!is_null($upgrade_from) && $upgrade_from < 7.2) {
$rows = $GLOBALS['FORUM_DB']->query('SELECT m_name FROM ' . $GLOBALS['FORUM_DB']->get_table_prefix() . 'db_meta WHERE (' . db_string_equal_to('m_type', '?INTEGER') . ' OR ' . db_string_equal_to('m_type', 'BINARY') . ') AND ' . db_string_equal_to('m_table', 'f_member_custom_fields'));
foreach ($rows as $row) {
$GLOBALS['FORUM_DB']->alter_table_field('f_member_custom_fields', $row['m_name'], 'SHORT_TEXT');
}
$i = 0;
do {
$rows = $GLOBALS['FORUM_DB']->query_select('f_member_custom_fields', array('*'), NULL, '', 100, $i);
foreach ($rows as $j => $row) {
foreach ($row as $key => $val) {
if (substr($key, 0, 6) == 'field_') {
$val = str_replace('|', chr(10), $val);
$row[$key] = $val;
}
}
if ($rows[$j] != $row) {
$GLOBALS['FORUM_DB']->query_update('f_member_custom_fields', array('mf_member_id' => $row['mf_member_id']), $row, '', 1);
}
}
$i += 100;
} while (count($rows) != 0);
$GLOBALS['FORUM_DB']->alter_table_field('f_members', 'm_track_contributed_topics', 'BINARY', 'm_auto_monitor_contrib_content');
}
if (!is_null($upgrade_from) && $upgrade_from < 4.0) {
$GLOBALS['FORUM_DB']->alter_table_field('f_members', 'm_password_compatibility_scheme', 'ID_TEXT', 'm_password_compat_scheme');
$GLOBALS['FORUM_DB']->delete_table_field('f_members', 'm_track_all_forums');
}
if (!is_null($upgrade_from) && $upgrade_from < 3.1) {
$GLOBALS['FORUM_DB']->add_table_field('f_emoticons', 'e_is_special', 'BINARY', 0);
$GLOBALS['FORUM_DB']->add_table_field('f_members', 'm_highlighted_name', 'BINARY', 0);
}
if (!is_null($upgrade_from) && $upgrade_from < 3.0) {
$rows = $GLOBALS['FORUM_DB']->query_select('f_forum_group_access', array('*'));
foreach ($rows as $row) {
if ($row['a_level'] > 1) {
$GLOBALS['SITE_DB']->query_insert('group_category_access', array('module_the_name' => 'forums', 'category_name' => strval($row['a_forum_id']), 'group_id' => $row['a_group_id']));
}
}
$GLOBALS['FORUM_DB']->drop_if_exists('f_forum_group_access');
delete_specific_permission('allow_deletive_moderation');
$GLOBALS['FORUM_DB']->delete_table_field('f_post_templates', 't_minimum_access_level');
$GLOBALS['FORUM_DB']->add_table_field('f_groups', 'g_is_presented_at_install', 'BINARY', 0);
$GLOBALS['FORUM_DB']->alter_table_field('f_custom_fields', 'cf_name', 'SHORT_TRANS');
$GLOBALS['FORUM_DB']->alter_table_field('f_groups', 'g_rank_image', 'ID_TEXT');
}
if (!is_null($upgrade_from) && $upgrade_from < 2.6) {
$GLOBALS['FORUM_DB']->add_table_field('f_groups', 'g_is_default', 'BINARY');
}
if (is_null($upgrade_from) || $upgrade_from < 4.0) {
add_config_option('MINIMUM_PASSWORD_LENGTH', 'minimum_password_length', 'integer', 'return \'4\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS');
add_config_option('MAXIMUM_PASSWORD_LENGTH', 'maximum_password_length', 'integer', 'return \'20\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS');
add_config_option('MINIMUM_USERNAME_LENGTH', 'minimum_username_length', 'integer', 'return \'1\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS');
add_config_option('MAXIMUM_USERNAME_LENGTH', 'maximum_username_length', 'integer', 'return \'20\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS');
add_config_option('PROHIBIT_PASSWORD_WHITESPACE', 'prohibit_password_whitespace', 'tick', 'return \'1\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS');
//add_config_option('PROHIBIT_PASSWORD_DICTIONARY','prohibit_password_dictionary','tick','return \'0\';','SECTION_FORUMS','USERNAMES_AND_PASSWORDS');
add_config_option('PROHIBIT_USERNAME_WHITESPACE', 'prohibit_username_whitespace', 'tick', 'return \'0\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS');
add_config_option('ASSIGN_RANDOM_AVATARS', 'random_avatars', 'tick', 'return addon_installed(\'ocf_member_avatars\')?\'1\':NULL;', 'SECTION_FORUMS', 'GENERAL');
add_config_option('CLUB_FORUM_PARENT_FORUM', 'club_forum_parent_forum', 'forum', 'return has_no_forum()?NULL:strval(db_get_first_id());', 'SECTION_FORUMS', 'GENERAL');
add_config_option('CLUB_FORUM_PARENT_CATEGORY', 'club_forum_parent_category', 'category', 'return has_no_forum()?NULL:strval(db_get_first_id());', 'SECTION_FORUMS', 'GENERAL');
add_config_option('DELETE_TRASHED_PTS', 'delete_trashed_pts', 'tick', 'return has_no_forum()?NULL:\'0\';', 'SECTION_FORUMS', 'GENERAL');
//add_config_option('ALLOW_MEMBER_INTEGRATION','allow_member_integration','list','return \'off\';','SECTION_FORUMS','USERNAMES_AND_PASSWORDS',0,'strict|on|hidden|off');
add_config_option('PROBATION_USERGROUP', 'probation_usergroup', 'usergroup', 'return do_lang(\'PROBATION\');', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS');
add_config_option('SHOW_FIRST_JOIN_PAGE', 'show_first_join_page', 'tick', 'return \'1\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS');
add_config_option('SKIP_EMAIL_CONFIRM_JOIN', 'skip_email_confirm_join', 'tick', 'return \'1\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS');
add_config_option('NO_DOB_ASK', 'no_dob_ask', 'list', 'return \'0\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS', 0, '0|1|2');
add_config_option('ALLOW_INTERNATIONAL', 'allow_international', 'tick', 'return \'1\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS');
}
if (is_null($upgrade_from) || $upgrade_from < 8.0) {
add_config_option('ALLOW_EMAIL_FROM_STAFF_DISABLE', 'allow_email_from_staff_disable', 'tick', 'return \'0\';', 'SECTION_FORUMS', 'GENERAL');
add_config_option('INTRO_FORUM_ID', 'intro_forum_id', '?forum', 'return \'\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS');
add_config_option('SIGNUP_FULLNAME', 'signup_fullname', 'tick', 'return \'0\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS');
}
if (!is_null($upgrade_from) && $upgrade_from < 8.1) {
delete_config_option('no_dob_ask');
add_config_option('NO_DOB_ASK', 'no_dob_ask', 'list', 'return \'0\';', 'SECTION_FORUMS', 'USERNAMES_AND_PASSWORDS', 0, '0|1|2');
// Recreate option
}
if (!is_null($upgrade_from) && $upgrade_from < 8.0) {
$GLOBALS['FORUM_DB']->add_table_field('f_members', 'm_allow_emails_from_staff', 'BINARY');
$GLOBALS['FORUM_DB']->add_table_field('f_custom_fields', 'cf_show_on_join_form', 'BINARY');
$GLOBALS['FORUM_DB']->add_table_field('f_forums', 'f_is_threaded', 'BINARY', 0);
$GLOBALS['FORUM_DB']->add_table_field('f_posts', 'p_parent_id', '?AUTO_LINK', NULL);
$GLOBALS['FORUM_DB']->query('UPDATE ' . $GLOBALS['FORUM_DB']->get_table_prefix() . 'f_custom_fields SET cf_show_on_join_form=cf_required');
delete_config_option('send_staff_message_post_validation');
require_code('notifications');
$start = 0;
do {
$rows = $GLOBALS['FORUM_DB']->query_select('f_forum_tracking', array('r_forum_id', 'r_member_id'), NULL, '', 100, $start);
foreach ($rows as $row) {
enable_notifications('ocf_topic', 'forum:' . strval($row['r_forum_id']), $row['r_member_id']);
}
$start += 100;
} while (count($rows) == 100);
$start = 0;
do {
$rows = $GLOBALS['FORUM_DB']->query_select('f_topic_tracking', array('r_topic_id', 'r_member_id'), NULL, '', 100, $start);
foreach ($rows as $row) {
enable_notifications('ocf_topic', strval($row['r_topic_id']), $row['r_member_id']);
}
$start += 100;
} while (count($rows) == 100);
$GLOBALS['FORUM_DB']->drop_if_exists('f_forum_tracking');
$GLOBALS['FORUM_DB']->drop_if_exists('f_topic_tracking');
}
if (!is_null($upgrade_from) && $upgrade_from < 4.2) {
$GLOBALS['FORUM_DB']->add_table_field('f_topics', 't_description_link', 'SHORT_TEXT');
$GLOBALS['FORUM_DB']->add_table_field('f_custom_fields', 'cf_encrypted', 'BINARY', 0);
}
if (!is_null($upgrade_from) && $upgrade_from < 4.0) {
$GLOBALS['FORUM_DB']->add_table_field('f_members', 'm_on_probation_until', '?TIME', time());
$GLOBALS['FORUM_DB']->add_table_field('f_members', 'm_pt_rules_text', 'LONG_TRANS', '');
$GLOBALS['FORUM_DB']->add_table_field('f_members', 'm_pt_allow', 'SHORT_TEXT', '*');
$GLOBALS['FORUM_DB']->add_table_field('f_forums', 'f_order', 'ID_TEXT', 'last_post');
// last_post,first_post,title
$GLOBALS['FORUM_DB']->add_table_field('f_groups', 'g_hidden', 'BINARY', 0);
$GLOBALS['FORUM_DB']->add_table_field('f_groups', 'g_order', 'INTEGER');
$GLOBALS['FORUM_DB']->add_table_field('f_groups', 'g_rank_image_pri_only', 'BINARY', 1);
$GLOBALS['FORUM_DB']->add_table_field('f_groups', 'g_open_membership', 'BINARY', 0);
$GLOBALS['FORUM_DB']->add_table_field('f_groups', 'g_is_private_club', 'BINARY', 0);
$GLOBALS['FORUM_DB']->add_table_field('f_posts', 'p_skip_sig', 'BINARY', 0);
$GLOBALS['FORUM_DB']->add_table_field('f_topics', 't_sunk', 'BINARY', 0);
$GLOBALS['FORUM_DB']->add_table_field('f_multi_moderations', 'mm_sink_state', '?BINARY', NULL);
$GLOBALS['FORUM_DB']->add_table_field('f_multi_moderations', 'mm_title_suffix', 'SHORT_TEXT');
$GLOBALS['FORUM_DB']->add_table_field('f_warnings', 'w_is_warning', 'BINARY', 1);
$GLOBALS['FORUM_DB']->add_table_field('f_warnings', 'p_silence_from_topic', '?AUTO_LINK');
$GLOBALS['FORUM_DB']->add_table_field('f_warnings', 'p_silence_from_forum', '?AUTO_LINK');
$GLOBALS['FORUM_DB']->add_table_field('f_warnings', 'p_probation', 'INTEGER', 0);
$GLOBALS['FORUM_DB']->add_table_field('f_warnings', 'p_banned_ip', 'IP');
$GLOBALS['FORUM_DB']->add_table_field('f_warnings', 'p_charged_points', 'INTEGER', 0);
$GLOBALS['FORUM_DB']->add_table_field('f_warnings', 'p_banned_member', 'BINARY', 0);
$GLOBALS['FORUM_DB']->add_table_field('f_warnings', 'p_changed_usergroup_from', '?GROUP');
}
if (is_null($upgrade_from) || $upgrade_from < 3.0) {
add_config_option('COPPA_ENABLED', 'is_on_coppa', 'tick', 'return \'0\';', 'PRIVACY', 'GENERAL');
add_config_option('FAX_NUMBER', 'privacy_fax', 'line', 'return \'\';', 'PRIVACY', 'GENERAL');
add_config_option('ADDRESS', 'privacy_postal_address', 'text', 'return \'\';', 'PRIVACY', 'GENERAL');
}
if (is_null($upgrade_from) || $upgrade_from < 2.6) {
add_config_option('INVITES_ENABLED', 'is_on_invites', 'tick', 'return \'0\';', 'SECTION_FORUMS', 'GENERAL');
add_config_option('INVITES_PER_DAY', 'invites_per_day', 'float', 'return \'1\';', 'SECTION_FORUMS', 'GENERAL');
}
if (!is_null($upgrade_from) && $upgrade_from < 2.5) {
$GLOBALS['FORUM_DB']->add_table_field('f_forums', 'f_redirection', 'SHORT_TEXT');
$GLOBALS['FORUM_DB']->add_table_field('f_forums', 'f_order_sub_alpha', 'BINARY');
$GLOBALS['FORUM_DB']->add_table_field('f_forums', 'f_intro_question', 'LONG_TRANS');
$GLOBALS['FORUM_DB']->add_table_field('f_forums', 'f_intro_answer', 'SHORT_TEXT');
$GLOBALS['FORUM_DB']->add_table_field('f_members', 'm_max_email_attach_size_mb', 'INTEGER', 3);
$GLOBALS['FORUM_DB']->add_table_field('f_members', 'm_zone_wide', 'BINARY', 1);
$GLOBALS['FORUM_DB']->add_table_field('f_members', 'm_notes', 'LONG_TEXT');
// TODO: remove
$GLOBALS['FORUM_DB']->add_table_field('f_emoticons', 'e_use_topics', 'BINARY', 1);
$GLOBALS['FORUM_DB']->add_table_field('f_topics', 't_pt_from_category', 'SHORT_TEXT');
$GLOBALS['FORUM_DB']->add_table_field('f_topics', 't_pt_to_category', 'SHORT_TEXT');
$GLOBALS['FORUM_DB']->add_table_field('f_custom_fields', 'cf_show_in_post_previews', 'BINARY', 1);
$GLOBALS['FORUM_DB']->add_table_field('f_custom_fields', 'cf_order', 'INTEGER');
$GLOBALS['FORUM_DB']->add_table_field('f_custom_fields', 'cf_only_group', '?GROUP');
$GLOBALS['FORUM_DB']->add_table_field('f_multi_moderations', 'mm_forum_multi_code', 'SHORT_TEXT');
$GLOBALS['FORUM_DB']->alter_table_field('f_topics', 't_emoticon', 'SHORT_TEXT');
$GLOBALS['FORUM_DB']->alter_table_field('f_emoticons', 'e_theme_img_code', 'SHORT_TEXT');
$GLOBALS['FORUM_DB']->promote_text_field_to_comcode('f_forums', 'f_description');
$GLOBALS['FORUM_DB']->alter_table_field('f_members', 'm_pass_hash_salted', 'SHORT_TEXT');
$GLOBALS['FORUM_DB']->drop_if_exists('f_groups');
$GLOBALS['FORUM_DB']->query_delete('f_emoticons');
}
if (!is_null($upgrade_from) && $upgrade_from < 3.1) {
$GLOBALS['FORUM_DB']->alter_table_field('f_custom_fields', 'cf_only_group', 'LONG_TEXT');
}
// If we have the forum installed to this db already, leave
if (is_null($upgrade_from) && $not_installed) {
uninstall_ocf();
$GLOBALS['FORUM_DB']->create_table('f_emoticons', array('e_code' => '*ID_TEXT', 'e_theme_img_code' => 'SHORT_TEXT', 'e_relevance_level' => 'INTEGER', 'e_use_topics' => 'BINARY', 'e_is_special' => 'BINARY'));
$GLOBALS['FORUM_DB']->create_index('f_emoticons', 'relevantemoticons', array('e_relevance_level'));
$GLOBALS['FORUM_DB']->create_index('f_emoticons', 'topicemos', array('e_use_topics'));
$GLOBALS['FORUM_DB']->create_table('f_custom_fields', array('id' => '*AUTO', 'cf_locked' => 'BINARY', 'cf_name' => 'SHORT_TRANS', 'cf_description' => 'SHORT_TRANS', 'cf_default' => 'LONG_TEXT', 'cf_public_view' => 'BINARY', 'cf_owner_view' => 'BINARY', 'cf_owner_set' => 'BINARY', 'cf_type' => 'ID_TEXT', 'cf_required' => 'BINARY', 'cf_show_in_posts' => 'BINARY', 'cf_show_in_post_previews' => 'BINARY', 'cf_order' => 'INTEGER', 'cf_only_group' => 'LONG_TEXT', 'cf_encrypted' => 'BINARY', 'cf_show_on_join_form' => 'BINARY'));
// These don't need to be filled in. We just use default from custom field if they aren't
$GLOBALS['FORUM_DB']->create_table('f_member_custom_fields', array('mf_member_id' => '*USER'));
//$GLOBALS['FORUM_DB']->create_index('f_member_custom_fields','fields_for_member',array('mf_member_id'));
ocf_make_boiler_custom_field('SELF_DESCRIPTION');
//ocf_make_boiler_custom_field('im_aim');
//ocf_make_boiler_custom_field('im_msn');
//ocf_make_boiler_custom_field('im_yahoo');
//ocf_make_boiler_custom_field('im_icq');
//ocf_make_boiler_custom_field('im_jabber');
ocf_make_boiler_custom_field('im_skype');
ocf_make_boiler_custom_field('sn_facebook');
ocf_make_boiler_custom_field('sn_google');
ocf_make_boiler_custom_field('sn_twitter');
ocf_make_boiler_custom_field('interests');
ocf_make_boiler_custom_field('location');
ocf_make_boiler_custom_field('occupation');
ocf_make_boiler_custom_field('staff_notes');
}
if (is_null($upgrade_from) || $upgrade_from < 2.6) {
$GLOBALS['FORUM_DB']->create_table('f_invites', array('id' => '*AUTO', 'i_inviter' => 'USER', 'i_email_address' => 'SHORT_TEXT', 'i_time' => 'TIME', 'i_taken' => 'BINARY'));
}
if (is_null($upgrade_from) && $not_installed) {
$GLOBALS['FORUM_DB']->create_table('f_group_members', array('gm_group_id' => '*GROUP', 'gm_member_id' => '*USER', 'gm_validated' => 'BINARY'));
$GLOBALS['FORUM_DB']->create_index('f_group_members', 'gm_validated', array('gm_validated'));
$GLOBALS['FORUM_DB']->create_index('f_group_members', 'gm_member_id', array('gm_member_id'));
$GLOBALS['FORUM_DB']->create_index('f_group_members', 'gm_group_id', array('gm_group_id'));
$GLOBALS['FORUM_DB']->create_table('f_members', array('id' => '*AUTO', 'm_username' => 'ID_TEXT', 'm_pass_hash_salted' => 'SHORT_TEXT', 'm_pass_salt' => 'SHORT_TEXT', 'm_theme' => 'ID_TEXT', 'm_avatar_url' => 'URLPATH', 'm_validated' => 'BINARY', 'm_validated_email_confirm_code' => 'SHORT_TEXT', 'm_cache_num_posts' => 'INTEGER', 'm_cache_warnings' => 'INTEGER', 'm_join_time' => 'TIME', 'm_timezone_offset' => 'SHORT_TEXT', 'm_primary_group' => 'GROUP', 'm_last_visit_time' => 'TIME', 'm_last_submit_time' => 'TIME', 'm_signature' => 'LONG_TRANS', 'm_is_perm_banned' => 'BINARY', 'm_preview_posts' => 'BINARY', 'm_dob_day' => '?INTEGER', 'm_dob_month' => '?INTEGER', 'm_dob_year' => '?INTEGER', 'm_reveal_age' => 'BINARY', 'm_email_address' => 'SHORT_TEXT', 'm_title' => 'SHORT_TEXT', 'm_photo_url' => 'URLPATH', 'm_photo_thumb_url' => 'URLPATH', 'm_views_signatures' => 'BINARY', 'm_auto_monitor_contrib_content' => 'BINARY', 'm_language' => 'ID_TEXT', 'm_ip_address' => 'IP', 'm_allow_emails' => 'BINARY', 'm_allow_emails_from_staff' => 'BINARY', 'm_notes' => 'LONG_TEXT', 'm_zone_wide' => 'BINARY', 'm_highlighted_name' => 'BINARY', 'm_pt_allow' => 'SHORT_TEXT', 'm_pt_rules_text' => 'LONG_TRANS', 'm_max_email_attach_size_mb' => 'INTEGER', 'm_password_change_code' => 'SHORT_TEXT', 'm_password_compat_scheme' => 'ID_TEXT', 'm_on_probation_until' => '?TIME'));
$GLOBALS['FORUM_DB']->create_index('f_members', '#search_user', array('m_username'));
$GLOBALS['FORUM_DB']->create_index('f_members', 'user_list', array('m_username'));
$GLOBALS['FORUM_DB']->create_index('f_members', 'menail', array('m_email_address'));
$GLOBALS['FORUM_DB']->create_index('f_members', 'external_auth_lookup', array('m_pass_hash_salted'));
$GLOBALS['FORUM_DB']->create_index('f_members', 'sort_post_count', array('m_cache_num_posts'));
$GLOBALS['FORUM_DB']->create_index('f_members', 'm_join_time', array('m_join_time'));
$GLOBALS['FORUM_DB']->create_index('f_members', 'whos_validated', array('m_validated'));
$GLOBALS['FORUM_DB']->create_index('f_members', 'birthdays', array('m_dob_day', 'm_dob_month'));
$GLOBALS['FORUM_DB']->create_index('f_members', 'ftjoin_msig', array('m_signature'));
$GLOBALS['FORUM_DB']->create_index('f_members', 'primary_group', array('m_primary_group'));
$GLOBALS['FORUM_DB']->create_index('f_members', 'avatar_url', array('m_avatar_url'));
// Used for uniform avatar randomisation
}
if (is_null($upgrade_from) || $upgrade_from < 2.5) {
$no_use_topics = array('party' => 1, 'christmas' => 1, 'offtopic' => 1, 'rockon' => 1, 'guitar' => 1, 'sinner' => 1, 'wink' => 1, 'kiss' => 1, 'nod' => 1, 'smile' => 1, 'mellow' => 1, 'whistle' => 1, 'shutup' => 1, 'cyborg' => 1);
$core_emoticons = array(':P' => 'cheeky', ":'(" => 'cry', ':dry:' => 'dry', ':$' => 'blush', ';)' => 'wink', 'O_o' => 'blink', ':wub:' => 'wub', ':cool:' => 'cool', ':lol:' => 'lol', ':(' => 'sad', ':)' => 'smile', ':thumbs:' => 'thumbs', ':offtopic:' => 'offtopic', ':|' => 'mellow', ':ninja:' => 'ph34r', ':o' => 'shocked');
$supported_emoticons = array(':rolleyes:' => 'rolleyes', ':D' => 'grin', '^_^' => 'glee', '(K)' => 'kiss', ':S' => 'confused', ':@' => 'angry', ':shake:' => 'shake', ':hand:' => 'hand', ':drool:' => 'drool', ':devil:' => 'devil', ':party:' => 'party', ':constipated:' => 'constipated', ':depressed:' => 'depressed', ':zzz:' => 'zzz', ':whistle:' => 'whistle', ':upsidedown:' => 'upsidedown', ':sick:' => 'sick', ':shutup:' => 'shutup', ':sarcy:' => 'sarcy', ':puppyeyes:' => 'puppyeyes', ':nod:' => 'nod', ':nerd:' => 'nerd', ':king:' => 'king', ':birthday:' => 'birthday', ':cyborg:' => 'cyborg', ':hippie:' => 'hippie', ':ninja2:' => 'ninja2', ':rockon:' => 'rockon', ':sinner:' => 'sinner', ':guitar:' => 'guitar');
$unused_emoticons = array(':christmas:' => 'christmas');
foreach ($core_emoticons as $a => $b) {
ocf_make_emoticon($a, 'ocf_emoticons/' . $b, 0, array_key_exists($b, $no_use_topics) ? 0 : 1);
}
foreach ($supported_emoticons as $a => $b) {
ocf_make_emoticon($a, 'ocf_emoticons/' . $b, 1, array_key_exists($b, $no_use_topics) ? 0 : 1);
}
foreach ($unused_emoticons as $a => $b) {
ocf_make_emoticon($a, 'ocf_emoticons/' . $b, 1, array_key_exists($b, $no_use_topics) ? 0 : 1);
}
$GLOBALS['FORUM_DB']->create_table('f_groups', array('id' => '*AUTO', 'g_name' => 'SHORT_TRANS', 'g_is_default' => 'BINARY', 'g_is_presented_at_install' => 'BINARY', 'g_is_super_admin' => 'BINARY', 'g_is_super_moderator' => 'BINARY', 'g_group_leader' => '?USER', 'g_title' => 'SHORT_TRANS', 'g_promotion_target' => '?GROUP', 'g_promotion_threshold' => '?INTEGER', 'g_flood_control_submit_secs' => 'INTEGER', 'g_flood_control_access_secs' => 'INTEGER', 'g_gift_points_base' => 'INTEGER', 'g_gift_points_per_day' => 'INTEGER', 'g_max_daily_upload_mb' => 'INTEGER', 'g_max_attachments_per_post' => 'INTEGER', 'g_max_avatar_width' => 'INTEGER', 'g_max_avatar_height' => 'INTEGER', 'g_max_post_length_comcode' => 'INTEGER', 'g_max_sig_length_comcode' => 'INTEGER', 'g_enquire_on_new_ips' => 'BINARY', 'g_rank_image' => 'ID_TEXT', 'g_hidden' => 'BINARY', 'g_order' => 'INTEGER', 'g_rank_image_pri_only' => 'BINARY', 'g_open_membership' => 'BINARY', 'g_is_private_club' => 'BINARY'));
$GLOBALS['FORUM_DB']->create_index('f_groups', 'ftjoin_gname', array('g_name'));
$GLOBALS['FORUM_DB']->create_index('f_groups', 'ftjoin_gtitle', array('g_title'));
$GLOBALS['FORUM_DB']->create_index('f_groups', 'is_private_club', array('g_is_private_club'));
$GLOBALS['FORUM_DB']->create_index('f_groups', 'is_super_admin', array('g_is_super_admin'));
$GLOBALS['FORUM_DB']->create_index('f_groups', 'is_super_moderator', array('g_is_super_moderator'));
$GLOBALS['FORUM_DB']->create_index('f_groups', 'is_default', array('g_is_default'));
$GLOBALS['FORUM_DB']->create_index('f_groups', 'hidden', array('g_hidden'));
$GLOBALS['FORUM_DB']->create_index('f_groups', 'is_presented_at_install', array('g_is_presented_at_install'));
$GLOBALS['FORUM_DB']->create_index('f_groups', 'gorder', array('g_order', 'id'));
// For the_zone_access table
require_code('zones2');
reinstall_module('adminzone', 'admin_permissions');
// Make guest
$guest_group = ocf_make_group(do_lang('GUESTS'), 0, 0, 0, do_lang('DESCRIPTION_GUESTS'));
// Make admin
$administrator_group = ocf_make_group(do_lang('ADMINISTRATORS'), 0, 1, 0, do_lang('DESCRIPTION_ADMINISTRATORS'), 'ocf_rank_images/admin', NULL, NULL, NULL, 0);
// Make mod
$super_moderator_group = ocf_make_group(do_lang('SUPER_MODERATORS'), 0, 0, 1, do_lang('DESCRIPTION_SUPER_MODERATORS'), 'ocf_rank_images/mod', NULL, NULL, NULL, 0);
// Make supermember
$super_member_group = ocf_make_group(do_lang('SUPER_MEMBERS'), 0, 0, 0, do_lang('DESCRIPTION_SUPER_MEMBERS'), '', NULL, NULL, NULL, 0);
// Make member
$member_group_4 = ocf_make_group(do_lang('DEFAULT_RANK_4'), 0, 0, 0, do_lang('DESCRIPTION_MEMBERS'), 'ocf_rank_images/4');
$member_group_3 = ocf_make_group(do_lang('DEFAULT_RANK_3'), 0, 0, 0, do_lang('DESCRIPTION_MEMBERS'), 'ocf_rank_images/3', $member_group_4, 10000);
$member_group_2 = ocf_make_group(do_lang('DEFAULT_RANK_2'), 0, 0, 0, do_lang('DESCRIPTION_MEMBERS'), 'ocf_rank_images/2', $member_group_3, 2500);
$member_group_1 = ocf_make_group(do_lang('DEFAULT_RANK_1'), 0, 0, 0, do_lang('DESCRIPTION_MEMBERS'), 'ocf_rank_images/1', $member_group_2, 400);
$member_group_0 = ocf_make_group(do_lang('DEFAULT_RANK_0'), 0, 0, 0, do_lang('DESCRIPTION_MEMBERS'), 'ocf_rank_images/0', $member_group_1, 100);
// Not default because primary is always defaulted to this one
// Make probation
$probation_group = ocf_make_group(do_lang('PROBATION'), 0, 0, 0, do_lang('DESCRIPTION_PROBATION'), '', NULL, NULL, NULL, 0);
}
if (is_null($upgrade_from) && $not_installed) {
$GLOBALS['FORUM_DB']->create_table('f_categories', array('id' => '*AUTO', 'c_title' => 'SHORT_TEXT', 'c_description' => 'LONG_TEXT', 'c_expanded_by_default' => 'BINARY'));
$category_id = ocf_make_category(do_lang('DEFAULT_CATEGORY_TITLE'), '');
$category_id_staff = ocf_make_category(do_lang('STAFF'), '');
$GLOBALS['FORUM_DB']->create_table('f_forums', array('id' => '*AUTO', 'f_name' => 'SHORT_TEXT', 'f_description' => 'LONG_TRANS', 'f_category_id' => '?AUTO_LINK', 'f_parent_forum' => '?AUTO_LINK', 'f_position' => 'INTEGER', 'f_order_sub_alpha' => 'BINARY', 'f_post_count_increment' => 'BINARY', 'f_intro_question' => 'LONG_TRANS', 'f_intro_answer' => 'SHORT_TEXT', 'f_cache_num_topics' => 'INTEGER', 'f_cache_num_posts' => 'INTEGER', 'f_cache_last_topic_id' => '?AUTO_LINK', 'f_cache_last_title' => 'SHORT_TEXT', 'f_cache_last_time' => '?TIME', 'f_cache_last_username' => 'SHORT_TEXT', 'f_cache_last_member_id' => '?USER', 'f_cache_last_forum_id' => '?AUTO_LINK', 'f_redirection' => 'SHORT_TEXT', 'f_order' => 'ID_TEXT', 'f_is_threaded' => 'BINARY'));
$GLOBALS['FORUM_DB']->create_index('f_forums', 'cache_num_posts', array('f_cache_num_posts'));
// Used to find active forums
$GLOBALS['FORUM_DB']->create_index('f_forums', 'subforum_parenting', array('f_parent_forum'));
$GLOBALS['FORUM_DB']->create_index('f_forums', 'findnamedforum', array('f_name'));
$GLOBALS['FORUM_DB']->create_index('f_forums', 'f_position', array('f_position'));
$typical_access = array($guest_group => 4, $administrator_group => 5, $super_moderator_group => 5, $probation_group => 2, $super_member_group => 4, $member_group_0 => 4, $member_group_1 => 4, $member_group_2 => 4, $member_group_3 => 4, $member_group_4 => 4);
$staff_post_access = array($guest_group => 1, $administrator_group => 5, $super_moderator_group => 5, $probation_group => 1, $super_member_group => 2, $member_group_0 => 1, $member_group_1 => 1, $member_group_2 => 1, $member_group_3 => 1, $member_group_4 => 1);
$staff_access = array($administrator_group => 5, $super_moderator_group => 5);
$root_forum = ocf_make_forum(do_lang('ROOT_FORUM'), '', NULL, $staff_post_access, NULL);
//ocf_make_forum(do_lang('NEWS'),'',$category_id,$staff_post_access,$root_forum);
ocf_make_forum(do_lang('DEFAULT_FORUM_TITLE'), '', $category_id, $typical_access, $root_forum);
//ocf_make_forum(do_lang('_FEEDBACK'),'',$category_id,$typical_access,$root_forum); We already have a feedback page
ocf_make_forum(do_lang('REPORTED_POSTS_FORUM'), '', $category_id_staff, $staff_access, $root_forum);
$trash_forum_id = ocf_make_forum(do_lang('TRASH'), '', $category_id_staff, $staff_access, $root_forum);
ocf_make_forum(do_lang('COMMENT_FORUM_NAME'), '', $category_id, $typical_access, $root_forum, 1, 1, 0, '', '', '', 'last_post', 1);
if (addon_installed('tickets')) {
require_lang('tickets');
ocf_make_forum(do_lang('TICKET_FORUM_NAME'), '', $category_id_staff, $staff_access, $root_forum);
}
$staff_forum_id = ocf_make_forum(do_lang('STAFF'), '', $category_id_staff, $staff_access, $root_forum);
$GLOBALS['FORUM_DB']->create_table('f_topics', array('id' => '*AUTO', 't_pinned' => 'BINARY', 't_sunk' => 'BINARY', 't_cascading' => 'BINARY', 't_forum_id' => '?AUTO_LINK', 't_pt_from' => '?USER', 't_pt_to' => '?USER', 't_pt_from_category' => 'SHORT_TEXT', 't_pt_to_category' => 'SHORT_TEXT', 't_description' => 'SHORT_TEXT', 't_description_link' => 'SHORT_TEXT', 't_emoticon' => 'SHORT_TEXT', 't_num_views' => 'INTEGER', 't_validated' => 'BINARY', 't_is_open' => 'BINARY', 't_poll_id' => '?AUTO_LINK', 't_cache_first_post_id' => '?AUTO_LINK', 't_cache_first_time' => '?TIME', 't_cache_first_title' => 'SHORT_TEXT', 't_cache_first_post' => '?LONG_TRANS', 't_cache_first_username' => 'ID_TEXT', 't_cache_first_member_id' => '?USER', 't_cache_last_post_id' => '?AUTO_LINK', 't_cache_last_time' => '?TIME', 't_cache_last_title' => 'SHORT_TEXT', 't_cache_last_username' => 'ID_TEXT', 't_cache_last_member_id' => '?USER', 't_cache_num_posts' => 'INTEGER'));
$GLOBALS['FORUM_DB']->create_index('f_topics', 't_num_views', array('t_num_views'));
$GLOBALS['FORUM_DB']->create_index('f_topics', 't_pt_to', array('t_pt_to'));
$GLOBALS['FORUM_DB']->create_index('f_topics', 't_pt_from', array('t_pt_from'));
$GLOBALS['FORUM_DB']->create_index('f_topics', 't_validated', array('t_validated'));
$GLOBALS['FORUM_DB']->create_index('f_topics', 'in_forum', array('t_forum_id'));
$GLOBALS['FORUM_DB']->create_index('f_topics', 'topic_order_time', array('t_cache_last_time'));
$GLOBALS['FORUM_DB']->create_index('f_topics', 'topic_order_time_2', array('t_cache_first_time'));
$GLOBALS['FORUM_DB']->create_index('f_topics', '#t_description', array('t_description'));
$GLOBALS['FORUM_DB']->create_index('f_topics', 'descriptionsearch', array('t_description'));
$GLOBALS['FORUM_DB']->create_index('f_topics', 'forumlayer', array('t_cache_first_title'));
$GLOBALS['FORUM_DB']->create_index('f_topics', 't_cascading', array('t_cascading'));
$GLOBALS['FORUM_DB']->create_index('f_topics', 't_cascading_or_forum', array('t_cascading', 't_forum_id'));
$GLOBALS['FORUM_DB']->create_index('f_topics', 'topic_order', array('t_cascading', 't_pinned', 't_cache_last_time'));
// Ordering for forumview, is picked up over topic_order_3 for just the ordering bit (it seems)
$GLOBALS['FORUM_DB']->create_index('f_topics', 'topic_order_2', array('t_forum_id', 't_cascading', 't_pinned', 't_sunk', 't_cache_last_time'));
// Total index for forumview, including ordering. Doesn't work on current MySQL.
$GLOBALS['FORUM_DB']->create_index('f_topics', 'topic_order_3', array('t_forum_id', 't_cascading', 't_pinned', 't_cache_last_time'));
// Total index for forumview, including ordering. Works if disable_sunk is turned on.
$GLOBALS['FORUM_DB']->create_index('f_topics', 'ownedtopics', array('t_cache_first_member_id'));
// Welcome topic
$topic_id = ocf_make_topic($staff_forum_id, '', '', 1, 1, 0, 0, 0, NULL, NULL, false);
$GLOBALS['FORUM_DB']->create_table('f_posts', array('id' => '*AUTO', 'p_title' => 'SHORT_TEXT', 'p_post' => 'LONG_TRANS', 'p_ip_address' => 'IP', 'p_time' => 'TIME', 'p_poster' => 'USER', 'p_intended_solely_for' => '?USER', 'p_poster_name_if_guest' => 'ID_TEXT', 'p_validated' => 'BINARY', 'p_topic_id' => 'AUTO_LINK', 'p_cache_forum_id' => '?AUTO_LINK', 'p_last_edit_time' => '?TIME', 'p_last_edit_by' => '?USER', 'p_is_emphasised' => 'BINARY', 'p_skip_sig' => 'BINARY', 'p_parent_id' => '?AUTO_LINK'));
$GLOBALS['FORUM_DB']->create_index('f_posts', 'p_validated', array('p_validated'));
$GLOBALS['FORUM_DB']->create_index('f_posts', 'in_topic', array('p_topic_id', 'p_time', 'id'));
$GLOBALS['FORUM_DB']->create_index('f_posts', 'post_order_time', array('p_time', 'id'));
$GLOBALS['FORUM_DB']->create_index('f_posts', 'p_last_edit_time', array('p_last_edit_time'));
$GLOBALS['FORUM_DB']->create_index('f_posts', 'posts_by', array('p_poster'));
$GLOBALS['FORUM_DB']->create_index('f_posts', 'find_pp', array('p_intended_solely_for'));
$GLOBALS['FORUM_DB']->create_index('f_posts', 'search_join', array('p_post'));
$GLOBALS['FORUM_DB']->create_index('f_posts', 'postsinforum', array('p_cache_forum_id'));
$GLOBALS['FORUM_DB']->create_index('f_posts', 'deletebyip', array('p_ip_address'));
}
if (is_null($upgrade_from) && $not_installed || !is_null($upgrade_from) && $upgrade_from < 4.0) {
$GLOBALS['FORUM_DB']->create_table('f_special_pt_access', array('s_member_id' => '*USER', 's_topic_id' => '*AUTO_LINK'));
$GLOBALS['FORUM_DB']->create_table('f_saved_warnings', array('s_title' => '*SHORT_TEXT', 's_explanation' => 'LONG_TEXT', 's_message' => 'LONG_TEXT'));
}
if (is_null($upgrade_from) && $not_installed || $upgrade_from < 2.5) {
$GLOBALS['FORUM_DB']->create_table('f_post_history', array('id' => '*AUTO', 'h_create_date_and_time' => 'TIME', 'h_action_date_and_time' => 'TIME', 'h_owner_member_id' => 'USER', 'h_alterer_member_id' => 'USER', 'h_post_id' => 'AUTO_LINK', 'h_topic_id' => 'AUTO_LINK', 'h_before' => 'LONG_TEXT', 'h_action' => 'ID_TEXT'));
$GLOBALS['FORUM_DB']->create_index('f_post_history', 'phistorylookup', array('h_post_id'));
$GLOBALS['FORUM_DB']->create_table('f_forum_intro_ip', array('i_forum_id' => '*AUTO_LINK', 'i_ip' => '*IP'));
$GLOBALS['FORUM_DB']->create_table('f_forum_intro_member', array('i_forum_id' => '*AUTO_LINK', 'i_member_id' => '*USER'));
$GLOBALS['FORUM_DB']->create_table('f_post_templates', array('id' => '*AUTO', 't_title' => 'SHORT_TEXT', 't_text' => 'LONG_TEXT', 't_forum_multi_code' => 'SHORT_TEXT', 't_use_default_forums' => 'BINARY'));
ocf_make_post_template(do_lang('DEFAULT_POST_TEMPLATE_bug_title'), do_lang('DEFAULT_POST_TEMPLATE_bug_text'), '', 0);
ocf_make_post_template(do_lang('DEFAULT_POST_TEMPLATE_task_title'), do_lang('DEFAULT_POST_TEMPLATE_task_text'), '', 0);
ocf_make_post_template(do_lang('DEFAULT_POST_TEMPLATE_fault_title'), do_lang('DEFAULT_POST_TEMPLATE_fault_text'), '', 0);
$GLOBALS['FORUM_DB']->create_index('f_posts', '#p_title', array('p_title'));
}
if (is_null($upgrade_from) && $not_installed) {
$GLOBALS['FORUM_DB']->create_table('f_polls', array('id' => '*AUTO', 'po_question' => 'SHORT_TEXT', 'po_cache_total_votes' => 'INTEGER', 'po_is_private' => 'BINARY', 'po_is_open' => 'BINARY', 'po_minimum_selections' => 'INTEGER', 'po_maximum_selections' => 'INTEGER', 'po_requires_reply' => 'BINARY'));
$GLOBALS['FORUM_DB']->create_table('f_poll_answers', array('id' => '*AUTO', 'pa_poll_id' => 'AUTO_LINK', 'pa_answer' => 'SHORT_TEXT', 'pa_cache_num_votes' => 'INTEGER'));
$GLOBALS['FORUM_DB']->create_table('f_poll_votes', array('pv_poll_id' => '*AUTO_LINK', 'pv_member_id' => '*USER', 'pv_answer_id' => '*AUTO_LINK'));
$GLOBALS['FORUM_DB']->create_table('f_multi_moderations', array('id' => '*AUTO', 'mm_name' => 'SHORT_TRANS', 'mm_post_text' => 'LONG_TEXT', 'mm_move_to' => '?INTEGER', 'mm_pin_state' => '?BINARY', 'mm_sink_state' => '?BINARY', 'mm_open_state' => '?BINARY', 'mm_forum_multi_code' => 'SHORT_TEXT', 'mm_title_suffix' => 'SHORT_TEXT'));
ocf_make_multi_moderation(do_lang('TRASH'), '', $trash_forum_id, 0, 0, 0);
$GLOBALS['FORUM_DB']->create_table('f_warnings', array('id' => '*AUTO', 'w_member_id' => 'USER', 'w_time' => 'TIME', 'w_explanation' => 'LONG_TEXT', 'w_by' => 'USER', 'w_is_warning' => 'BINARY', 'p_silence_from_topic' => '?AUTO_LINK', 'p_silence_from_forum' => '?AUTO_LINK', 'p_probation' => 'INTEGER', 'p_banned_ip' => 'IP', 'p_charged_points' => 'INTEGER', 'p_banned_member' => 'BINARY', 'p_changed_usergroup_from' => '?GROUP'));
$GLOBALS['FORUM_DB']->create_index('f_warnings', 'warningsmemberid', array('w_member_id'));
$GLOBALS['FORUM_DB']->create_table('f_moderator_logs', array('id' => '*AUTO', 'l_the_type' => 'ID_TEXT', 'l_param_a' => 'SHORT_TEXT', 'l_param_b' => 'SHORT_TEXT', 'l_date_and_time' => 'TIME', 'l_reason' => 'LONG_TEXT', 'l_by' => 'USER'));
$GLOBALS['FORUM_DB']->create_table('f_member_known_login_ips', array('i_member_id' => '*USER', 'i_ip' => '*IP', 'i_val_code' => 'SHORT_TEXT'));
if (strtoupper(ocp_srv('REQUEST_METHOD')) != 'POST') {
exit;
}
// Needed as YSlow can load as GET's in background and cause horrible results
// NB: post_param's will return default's if OCF is being installed but not used yet (e.g. IPB forum driver chosen at installation)
// Make guest
ocf_make_member(do_lang('GUEST'), '', '', NULL, NULL, NULL, NULL, array(), NULL, $guest_group, 1, time(), time(), '', NULL, '', 0, 1, 1, '', '', '', 1, 0, '', 1, 1, '', NULL, '', false);
// Make admin user
ocf_make_member(post_param('admin_username', 'admin'), post_param('ocf_admin_password', 'admin'), '', NULL, NULL, NULL, NULL, array(), NULL, $administrator_group, 1, time(), time(), '', 'themes/default/images/ocf_default_avatars/default_set/cool_flare.png', '', 0, 0, 1, '', '', '', 1, 1, '', 1, 1, '', NULL, '', false);
// Make test user
ocf_make_member('test', post_param('ocf_admin_password', 'admin'), '', NULL, NULL, NULL, NULL, array(), NULL, $member_group_0, 1, time(), time(), '', NULL, '', 0, 0, 1, '', '', '', 1, 0, '', 1, 1, '', NULL, '', false);
$GLOBALS['FORUM_DB']->create_table('f_read_logs', array('l_member_id' => '*USER', 'l_topic_id' => '*AUTO_LINK', 'l_time' => 'TIME'));
$GLOBALS['FORUM_DB']->create_index('f_read_logs', 'erase_old_read_logs', array('l_time'));
ocf_make_post($topic_id, do_lang('DEFAULT_POST_TITLE'), do_lang('DEFAULT_POST_CONTENT'), 0, true, 1, 0, do_lang('SYSTEM'), '127.0.0.1', time(), $GLOBALS['OCF_DRIVER']->get_guest_id(), NULL, NULL, NULL, false, true);
}
// Permissions have to be done after usergroups
if (is_null($upgrade_from)) {
// Add privileges
global $OCF_TRUE_PERMISSIONS, $OCF_FALSE_PERMISSIONS;
foreach ($OCF_TRUE_PERMISSIONS as $permission) {
add_specific_permission('SECTION_FORUMS', $permission, true);
}
foreach ($OCF_FALSE_PERMISSIONS as $permission) {
add_specific_permission('SECTION_FORUMS', $permission, false, $permission == 'view_other_pt');
}
}
if (!is_null($upgrade_from) && $upgrade_from < 3.1) {
add_specific_permission('SECTION_FORUMS', 'use_special_emoticons', false);
}
if (!is_null($upgrade_from) && $upgrade_from < 4.0) {
add_specific_permission('SECTION_FORUMS', 'member_maintenance', false);
add_specific_permission('SECTION_FORUMS', 'probate_members', false);
add_specific_permission('SECTION_FORUMS', 'own_avatars', true);
//add_specific_permission('SECTION_FORUMS','decide_comment_type',true); if we add threads
add_specific_permission('SECTION_FORUMS', 'control_usergroups', false, true);
add_specific_permission('SECTION_FORUMS', 'edit_personal_topic_posts', true);
add_specific_permission('SECTION_FORUMS', 'multi_delete_topics', false);
add_specific_permission('SECTION_FORUMS', 'show_user_browsing', false);
add_specific_permission('SECTION_FORUMS', 'see_hidden_groups', false);
add_specific_permission('SECTION_FORUMS', 'pt_anyone', false);
}
if (!is_null($upgrade_from) && $upgrade_from < 3.0) {
add_specific_permission('SECTION_FORUMS', 'view_profiles', true);
}
if (!is_null($upgrade_from) && $upgrade_from < 2.5) {
add_specific_permission('SECTION_FORUMS', 'moderate_personal_topic', false);
add_specific_permission('SECTION_FORUMS', 'disable_lost_passwords', false);
add_specific_permission('SECTION_FORUMS', 'view_any_profile_field', false);
add_specific_permission('SECTION_FORUMS', 'rename_self', true);
add_specific_permission('SECTION_FORUMS', 'double_post', false);
add_specific_permission('SECTION_FORUMS', 'close_own_topics', false);
add_specific_permission('SECTION_FORUMS', 'edit_own_polls', true);
add_specific_permission('SECTION_FORUMS', 'warn_members', false);
add_specific_permission('SECTION_FORUMS', 'see_warnings', false);
add_specific_permission('SECTION_FORUMS', 'see_ip', false);
add_specific_permission('SECTION_FORUMS', 'may_choose_custom_title', false);
add_specific_permission('SECTION_FORUMS', 'delete_account', false);
add_specific_permission('SECTION_FORUMS', 'view_other_pt', false);
add_specific_permission('SECTION_FORUMS', 'view_poll_results_before_voting', false);
add_specific_permission('SECTION_FORUMS', 'may_unblind_own_poll', true);
delete_specific_permission('enquire_on_new_ips');
}
}
