A small cleanup

[hmikko]

Thought to clean up database and some files a bit. But before I delete anything, need some help from smarter ones.

Which tables are safe to delete from database? Currently I use only System, Forums, Chat, Gallery and Calendar and not any plugins:

ipb_bbcode_mediatag
ipb_calendar_calendars
ipb_calendar_events
ipb_calendar_event_comments
ipb_calendar_event_reviews
ipb_calendar_event_rsvp
ipb_calendar_import_feeds
ipb_calendar_import_map
ipb_chat_log_archive
ipb_conv_apps
ipb_conv_link
ipb_conv_link_pms
ipb_conv_link_posts
ipb_conv_link_topics
ipb_core_acp_search_index
ipb_core_acp_tab_order
ipb_core_acronyms
ipb_core_admin_login_logs
ipb_core_admin_logs
ipb_core_admin_permission_rows
ipb_core_advertisements
ipb_core_announcements
ipb_core_api_keys
ipb_core_api_logs
ipb_core_applications
ipb_core_archive_log
ipb_core_archive_restore
ipb_core_attachments
ipb_core_attachments_map
ipb_core_banfilters
ipb_core_bulk_mail
ipb_core_cache
ipb_core_dev
ipb_core_dnames_change
ipb_core_edit_history
ipb_core_email_templates
ipb_core_emoticons
ipb_core_error_logs
ipb_core_files
ipb_core_files_temp
ipb_core_file_logs
ipb_core_file_storage
ipb_core_follow
ipb_core_geoip_cache
ipb_core_groups
ipb_core_hooks
ipb_core_hooks_files
ipb_core_ignored_users
ipb_core_image_proxy
ipb_core_incoming_emails
ipb_core_inline_messages
ipb_core_ipsconnect_queue
ipb_core_ipsconnect_slaves
ipb_core_item_markers
ipb_core_javascript
ipb_core_leaders
ipb_core_leaders_groups
ipb_core_like_cache
ipb_core_login_handlers
ipb_core_mail_error_logs
ipb_core_members
ipb_core_members_warn_actions
ipb_core_members_warn_logs
ipb_core_members_warn_reasons
ipb_core_member_ranks
ipb_core_member_status_replies
ipb_core_member_status_updates
ipb_core_menu
ipb_core_message_posts
ipb_core_message_topics
ipb_core_message_topic_user_map
ipb_core_moderators
ipb_core_moderator_logs
ipb_core_modules
ipb_core_notifications
ipb_core_notification_defaults
ipb_core_notification_preferences
ipb_core_permission_index
ipb_core_pfields_content
ipb_core_pfields_data
ipb_core_pfields_groups
ipb_core_plugins
ipb_core_polls
ipb_core_profanity_filters
ipb_core_question_and_answer
ipb_core_queue
ipb_core_ratings
ipb_core_rc_comments
ipb_core_rc_index
ipb_core_rc_reports
ipb_core_reputation_index
ipb_core_reputation_levels
ipb_core_rss_imported
ipb_core_search_index
ipb_core_search_index_tags
ipb_core_seo_meta
ipb_core_sessions
ipb_core_share_links
ipb_core_sitemap
ipb_core_soft_delete_log
ipb_core_spam_service_log
ipb_core_store
ipb_core_streams
ipb_core_sys_conf_settings
ipb_core_sys_cp_sessions
ipb_core_sys_lang
ipb_core_sys_lang_words
ipb_core_sys_login
ipb_core_sys_settings_titles
ipb_core_sys_social_groups
ipb_core_sys_social_group_members
ipb_core_tags
ipb_core_tags_cache
ipb_core_tags_perms
ipb_core_tasks
ipb_core_tasks_log
ipb_core_themes
ipb_core_theme_conflict
ipb_core_theme_content_history
ipb_core_theme_css
ipb_core_theme_resources
ipb_core_theme_settings_fields
ipb_core_theme_settings_values
ipb_core_theme_templates
ipb_core_upgrade_history
ipb_core_validating
ipb_core_view_updates
ipb_core_voters
ipb_core_widgets
ipb_core_widget_areas
ipb_core_widget_trash
ipb_custom_bbcode
ipb_forums_answer_ratings
ipb_forums_archive_posts
ipb_forums_archive_rules
ipb_forums_forums
ipb_forums_posts
ipb_forums_question_ratings
ipb_forums_rss_import
ipb_forums_rss_imported
ipb_forums_topics
ipb_forums_topic_mmod
ipb_gallery_albums
ipb_gallery_bandwidth
ipb_gallery_categories
ipb_gallery_comments
ipb_gallery_images
ipb_gallery_images_uploads
ipb_gallery_reviews
ipb_rc_reports_index
x_utf_ipb_convert_session
x_utf_ipb_convert_session_tables

 

And then conf_global.php file. It looks a bit old. I know a clean install looks a bit different.

<?php
define( 'SKIP_UPGRADE_CHECK', true );
$INFO['post_order_column']	=	'post_date';
$INFO['sql_driver']			=	'mysql';
$INFO['sql_host']			=	'XXX';
$INFO['sql_database']		=	'XXX';
$INFO['sql_user']			=	'XXX';
$INFO['sql_pass']			=	'XXX';
$INFO['sql_tbl_prefix']		=	'ipb_';
$INFO['sql_debug']			=	'0';
$INFO['sql_charset']        =   'utf8mb4';
$INFO['sql_utf8mb4']        =   true;
$INFO['board_start']		=	'XXX';
$INFO['installed']			=	'1';
$INFO['php_ext']			=	'php';
$INFO['safe_mode']		    =	'0';
$INFO['board_url']			=	'XXX';
$INFO['banned_group']		=	'5';
$INFO['admin_group']		=	'4';
$INFO['guest_group']		=	'2';
$INFO['member_group']		=	'3';
$INFO['auth_group']		    =	'1';
$INFO['use_friendly_urls']	=	'1';
$INFO['_jsDebug']			=	'0';
$INFO['mysql_tbl_type']		=	'InnoDB';

define('IN_DEV', 0);
/* Remote archive DB - complete these details if you\'re using a remote DB for the post archive.
   If content has already been archived in the local DB, this will need transferring and will not be done automatically. */
$INFO['archive_remote_sql_host']			=	'';
$INFO['archive_remote_sql_database']			=	'';
$INFO['archive_remote_sql_user']			=	'';
$INFO['archive_remote_sql_pass']			=	'';
$INFO['archive_remote_sql_charset']			=	'';

?>

 

And is there any file with a file tree which states what files should be in each folders? So I could delete old files which is not used.

Thanks in advance!

[MADMAN32395]

i did a cleanup on my site, what i recommend is BACKUP, then spin up a test installation, compare the two installations, delete/drop what isn't in the test install (but pay attention too, as some plugins and 3rd party apps make their own tables too).

as for the global conf, you could "version 4-ify" it.

Like this is what mine looks like now.

<?php

$INFO = array (
  'sql_host' => 'XXX',
  'sql_database' => 'XXX',
  'sql_user' => 'XXX',
  'sql_pass' => 'XXX',
  'sql_port' => 3306,
  'sql_socket' => '',
  'sql_tbl_prefix' => 'XXX',
  'sql_utf8mb4' => true,
  'board_start' => 1350762140,
  'installed' => true,
  'base_url' => 'https://www.gcinema.net/forums',
  'guest_group' => 2,
  'member_group' => 3,
  'admin_group' => 4,
);

I personally like the new style, looks cleaner. ; and move the   define('IN_DEV', 0);     to constants.php (if you don't have one make one); reason why you move the in_dev flag is that way you can write protect your global_conf as that doesn't change very often or at all.

<?php
define( 'IN_DEV', FALSE );

idk thats what I did to my site, and a few others.