*
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/
use Chevereto\Legacy\Classes\DB;
use Chevereto\Legacy\Classes\Login;
use Chevereto\Legacy\Classes\Settings;
use Chevereto\Legacy\Classes\User;
use Chevereto\Legacy\Classes\Variable;
use Chevereto\Legacy\G\Handler;
use function Chevere\Filesystem\filePhpForPath;
use function Chevere\Message\message;
use function Chevere\Parameter\getType;
use function Chevere\Standard\randomString;
use function Chevereto\Encryption\encodeEncrypt;
use function Chevereto\Encryption\hasEncryption;
use function Chevereto\Encryption\randomKey;
use function Chevereto\Legacy\chevereto_die;
use function Chevereto\Legacy\cheveretoVersionInstalled;
use function Chevereto\Legacy\G\bytes_to_mb;
use function Chevereto\Legacy\G\debug;
use function Chevereto\Legacy\G\get_ini_bytes;
use function Chevereto\Legacy\G\hasEnvDbInfo;
use function Chevereto\Legacy\G\logger;
use function Chevereto\Legacy\G\redirect;
use function Chevereto\Legacy\G\set_status_header;
use function Chevereto\Legacy\G\starts_with;
use function Chevereto\Legacy\G\str_replace_first;
use function Chevereto\Legacy\G\str_replace_last;
use function Chevereto\Legacy\get_chevereto_version;
use function Chevereto\Legacy\getPreCodeHtml;
use function Chevereto\Legacy\getSetting;
use function Chevereto\Vars\env;
use function Chevereto\Vars\post;
if (PHP_SAPI !== 'cli') {
/** @var Handler $handler */
$context = $handler->requestArray()[0] ?? false;
if (! $context) {
throw new LogicException(
message('Missing context')
);
}
if (! in_array($context, ['install', 'update'], true)) {
throw new LogicException(message('Invalid context'));
}
}
if (cheveretoVersionInstalled() !== ''
&& (PHP_SAPI !== 'cli' && ! Login::isAdmin())
) {
set_status_header(403);
throw new LogicException(message('Request denied. You must be an admin to be here.'), 403);
}
if (function_exists('opcache_reset')) {
try {
opcache_reset();
// @phpstan-ignore-next-line
} catch (Throwable) {
// Ignore, Zend OPcache API is restricted by "restrict_api" configuration directive
}
}
$doctitles = [
'connect' => 'Database connection',
'ready' => 'Ready to install',
'finished' => 'Installation complete',
'env' => 'Update app/env.php',
'already' => 'Already installed',
'update' => 'Update needed',
'updated' => 'Update complete',
'update_failed' => 'Update failed',
];
$doing = 'connect';
$db_array = [
'db_host' => true,
'db_name' => true,
'db_user' => true,
'db_pass' => false,
'db_tablePrefix' => false,
'db_port' => false,
];
$error = false;
$db_conn_error = "Can't connect to the target database. The server replied with this:
%s
Please fix your MySQL info.";
$installed_version = cheveretoVersionInstalled();
$settings_updates = [
'3.0.0' => [
'analytics_code' => '',
'auto_language' => 1,
// 'chevereto_version_installed' => APP_VERSION, // deprecated @4.2.0
'comment_code' => '',
// 'crypt_salt' => randomString(8), // deprecated @4.2.0
'default_language' => 'en',
'default_timezone' => 'America/Santiago',
'email_from_email' => 'from@chevereto.internal',
'email_from_name' => 'Chevereto',
'email_incoming_email' => 'incoming@chevereto.internal',
'email_mode' => env()['CHEVERETO_SERVICING'] === 'server' ? 'mail' : 'smtp',
'email_smtp_server' => '',
'email_smtp_server_password' => '',
'email_smtp_server_port' => '',
'email_smtp_server_security' => '',
'email_smtp_server_username' => '',
'enable_uploads' => 1,
// 'facebook' => 0, // Deprecated in 4.0.0-beta.11
// 'facebook_app_id' => '',
// 'facebook_app_secret' => '',
'flood_uploads_day' => '1000',
'flood_uploads_hour' => '500',
'flood_uploads_minute' => '50',
'flood_uploads_month' => '10000',
'flood_uploads_notify' => 0,
'flood_uploads_protection' => 1,
'flood_uploads_week' => '5000',
// 'google' => 0, // Deprecated in 4.0.0-beta.11
// 'google_client_id' => '',
// 'google_client_secret' => '',
'guest_uploads' => 1,
'listing_items_per_page' => '24',
'maintenance' => 0,
'captcha' => 0, //recaptcha
'captcha_secret' => '', //recaptcha_private_key
'captcha_sitekey' => '', //recaptcha_public_key
'captcha_threshold' => '5', //recaptcha_threshold
'theme' => 'Peafowl',
// 'twitter' => 0, // Deprecated in 4.0.0-beta.11
// 'twitter_api_key' => '',
// 'twitter_api_secret' => '',
'upload_filenaming' => 'original',
'upload_image_path' => 'images',
// 'upload_max_filesize_mb' => (string) min(25, bytes_to_mb(get_ini_bytes(ini_get('upload_max_filesize')))),
'upload_medium_size' => '500', // upload_medium_width
'upload_storage_mode' => 'datefolder',
'upload_thumb_height' => '320',
'upload_thumb_width' => '320',
'website_description' => 'A free image hosting service powered by Chevereto',
'website_doctitle' => 'Chevereto image hosting',
'website_name' => 'Chevereto',
],
'3.0.1' => null,
'3.0.2' => null,
'3.0.3' => null,
'3.0.4' => null,
'3.0.5' => null,
'3.1.0' => [
'website_explore_page' => 1,
//'theme_peafowl_home_uid' => '1'
],
'3.1.1' => null,
'3.1.2' => null,
'3.2.0' => [
// 'twitter_account' => 'chevereto',
//'theme_peafowl_download_button' => 1,
'enable_signups' => 1,
],
'3.2.1' => null,
'3.2.2' => [
'favicon_image' => 'default/favicon.png',
'logo_image' => 'default/logo.png',
'logo_vector' => 'default/logo.svg',
'theme_custom_css_code' => '',
'theme_custom_js_code' => '',
],
'3.2.3' => [
'website_keywords' => 'image sharing, image hosting, chevereto',
// 'logo_vector_enable' => 1,
'watermark_enable' => 0,
'watermark_image' => 'default/watermark.png',
'watermark_position' => 'center center',
'watermark_margin' => '10',
'watermark_opacity' => '50',
//'banner_home_before_cover' => NULL,
'banner_home_after_cover' => '',
'banner_home_after_listing' => '',
'banner_image_image-viewer_foot' => '',
'banner_image_image-viewer_top' => '',
'banner_image_after_image-viewer' => '',
'banner_image_after_header' => '',
'banner_image_before_header' => '',
'banner_image_footer' => '',
'banner_content_tab-about_column' => '',
'banner_content_before_comments' => '',
'banner_explore_after_top' => '',
'banner_user_after_top' => '',
'banner_user_before_listing' => '',
'banner_album_before_header' => '',
'banner_album_after_header' => '',
],
'3.2.4' => null,
'3.2.5' => [
'api_v1_key' => randomString(64),
],
'3.2.6' => null,
'3.3.0' => [
'listing_pagination_mode' => 'classic',
'banner_listing_before_pagination' => '',
'banner_listing_after_pagination' => '',
'show_nsfw_in_listings' => 0,
'show_banners_in_nsfw' => 0,
//'theme_peafowl_nsfw_upload_checkbox' => 1,
//'privacy_mode' => 'public',
//'website_mode' => 'public',
'website_privacy_mode' => 'public',
'website_content_privacy_mode' => 'default',
],
'3.3.1' => null,
'3.3.2' => [
'show_nsfw_in_random_mode' => 0,
],
'3.4.0' => [
//'theme_peafowl_tone' => 'light',
//'theme_peafowl_image_listing_size' => 'fixed'
],
'3.4.1' => null,
'3.4.2' => null,
'3.4.3' => [
'cdn' => 0,
'cdn_url' => '',
],
'3.4.4' => [
'website_search' => 1,
'website_random' => 1,
'theme_logo_height' => '',
'theme_show_social_share' => 1,
// 'theme_show_embed_content' => 1, // deprecated @3.14.2
'theme_show_embed_uploader' => 1,
],
'3.4.5' => [
// 'user_routing' => 1, // deprecated @4.0.0.beta.7
'require_user_email_confirmation' => 1,
'require_user_email_social_signup' => 1,
],
'3.4.6' => null,
'3.5.0' => [
//'active_storage' => NULL // deprecated
],
'3.5.1' => null,
'3.5.2' => null,
'3.5.3' => null,
'3.5.4' => null,
'3.5.5' => [
// 'last_used_storage' => '', // deprecated @4.2.0
],
'3.5.6' => null,
'3.5.7' => [
// 'vk' => 0, // Deprecated in 4.0.0-beta.11
// 'vk_client_id' => '',
// 'vk_client_secret' => '',
],
'3.5.8' => null,
'3.5.9' => null,
'3.5.10' => null,
'3.5.11' => null,
'3.5.12' => [
'theme_download_button' => 1,
'theme_nsfw_upload_checkbox' => 1,
// 'theme_tone' => 'light', // Renamed in 4.0.0.beta.5
'theme_image_listing_sizing' => 'fixed',
],
'3.5.13' => null,
'3.5.14' => null,
'3.5.15' => [
'listing_columns_phone' => '2',
'listing_columns_phablet' => '3',
'listing_columns_tablet' => '4',
'listing_columns_laptop' => '5',
'listing_columns_desktop' => '6',
//'logged_user_logo_link' => 'homepage', // Removed in 3.7.0
'homepage_style' => 'landing',
'homepage_cover_image' => 'default/home_cover.jpg',
'homepage_uids' => '',
'homepage_endless_mode' => 0,
],
'3.5.16' => null,
'3.5.17' => null,
'3.5.18' => null,
'3.5.19' => [
'user_image_avatar_max_filesize_mb' => '1',
'user_image_background_max_filesize_mb' => '2',
],
'3.5.20' => [
'theme_image_right_click' => 0,
],
'3.5.21' => null,
'3.6.0' => [
// 'minify_enable' => 0, // Removed in 3.19
'theme_show_exif_data' => 1,
// 'theme_top_bar_color' => 'white', // Removed in 3.15.0
//'theme_main_color' => null, // Removed in 4.0.0.beta.4
//'theme_top_bar_button_color' => 'blue', // Removed in 4.0.0.beta.4
'logo_image_homepage' => 'default/logo_homepage.png',
'logo_vector_homepage' => 'default/logo_homepage.svg',
'homepage_cta_color' => 'accent',
'homepage_cta_outline' => 0,
'watermark_enable_guest' => 1,
'watermark_enable_user' => 1,
'watermark_enable_admin' => 1,
],
'3.6.1' => [
'homepage_title_html' => '',
'homepage_paragraph_html' => '',
'homepage_cta_html' => '',
'homepage_cta_fn' => '',
'homepage_cta_fn_extra' => '',
'language_chooser_enable' => 1,
'languages_disable' => '',
],
'3.6.2' => [
'website_mode' => 'community',
'website_mode_personal_routing' => '', //'single_user_mode_routing'
'website_mode_personal_uid' => '', //'single_user_mode_id'
],
'3.6.3' => null,
'3.6.4' => [
'enable_cookie_law' => 0,
'theme_nsfw_blur' => 0,
],
'3.6.5' => [
'watermark_target_min_width' => '100',
'watermark_target_min_height' => '100',
'watermark_percentage' => '4',
'watermark_enable_file_gif' => 0,
],
'3.6.6' => [
// 'id_padding' => '0', // deprecated @4.2.0
],
'3.6.7' => null,
'3.6.8' => [
'upload_image_exif' => 1,
'upload_image_exif_user_setting' => 1,
'enable_expirable_uploads' => 1,
//'banner_home_before_cover_nsfw' => NULL, // Deprecate
'banner_home_after_cover_nsfw' => '',
'banner_home_after_listing_nsfw' => '',
'banner_image_image-viewer_foot_nsfw' => '',
'banner_image_image-viewer_top_nsfw' => '',
'banner_image_after_image-viewer_nsfw' => '',
'banner_image_after_header_nsfw' => '',
'banner_image_before_header_nsfw' => '',
'banner_image_footer_nsfw' => '',
'banner_content_tab-about_column_nsfw' => '',
'banner_content_before_comments_nsfw' => '',
'banner_explore_after_top_nsfw' => '',
'banner_user_after_top_nsfw' => '',
'banner_user_before_listing_nsfw' => '',
'banner_album_before_header_nsfw' => '',
'banner_album_after_header_nsfw' => '',
'banner_listing_before_pagination_nsfw' => '',
'banner_listing_after_pagination_nsfw' => '',
],
'3.6.9' => null,
'3.7.0' => null,
'3.7.1' => null,
'3.7.2' => [
'upload_medium_size' => '750',
'upload_medium_fixed_dimension' => 'width',
],
'3.7.3' => [
'enable_followers' => 1,
'enable_likes' => 1,
'enable_consent_screen' => 0,
'user_minimum_age' => '',
'consent_screen_cover_image' => 'default/consent-screen_cover.jpg',
],
'3.7.4' => null,
'3.7.5' => [
'enable_redirect_single_upload' => 0,
'route_image' => 'image',
'route_album' => 'album',
],
'3.8.0' => [
'enable_duplicate_uploads' => 0,
// 'update_check_datetimegmt' => '', // deprecated @4.2.0
// 'update_check_notified_release' => APP_VERSION, // deprecated @4.2.0
'update_check_display_notification' => 1,
],
'3.8.1' => null,
'3.8.2' => null,
'3.8.3' => null, // Chevereto Free hook
'3.8.4' => [
'banner_home_before_title' => '',
'banner_home_after_cta' => '',
'banner_home_before_title_nsfw' => '',
'banner_home_after_cta_nsfw' => '',
// 'upload_enabled_image_formats' => 'jpg,png,bmp,gif',
'upload_threads' => '2',
'enable_automatic_updates_check' => 1,
'comments_api' => 'js',
'disqus_shortname' => '',
'disqus_public_key' => '',
'disqus_secret_key' => '',
],
'3.8.5' => null,
'3.8.6' => null,
'3.8.7' => null,
'3.8.8' => null,
'3.8.9' => [
// 'image_load_max_filesize_mb' => '3',
],
'3.8.10' => null,
'3.8.11' => null,
'3.8.12' => [
'upload_max_image_width' => '0',
'upload_max_image_height' => '0',
],
'3.8.13' => null,
'3.9.0' => [
'auto_delete_guest_uploads' => '',
],
'3.9.1' => null,
'3.9.2' => null,
'3.9.3' => null,
'3.9.4' => null,
'3.9.5' => null,
'3.10.0' => null,
'3.10.1' => null,
'3.10.2' => [
'enable_user_content_delete' => 1,
],
'3.10.3' => [
'enable_plugin_route' => 1,
'sdk_pup_url' => '',
],
'3.10.4' => null,
'3.10.5' => null,
'3.10.6' => [
'website_explore_page_guest' => 1,
'explore_albums_min_image_count' => '1',
// 'upload_max_filesize_mb_guest' => '0.5',
'notify_user_signups' => 0,
// 'listing_viewer' => 1,
],
'3.10.7' => null,
'3.10.8' => null,
'3.10.9' => null,
'3.10.10' => null,
'3.10.11' => null,
'3.10.12' => null,
'3.10.13' => null,
'3.10.14' => null,
'3.10.15' => null,
'3.10.16' => null,
'3.10.17' => null,
'3.10.18' => null,
'3.11.0' => null,
'3.11.1' => [
'seo_image_urls' => 1,
'seo_album_urls' => 1,
],
'3.12.0' => [
// 'website_https' => 'auto',
],
'3.12.1' => null,
'3.12.2' => null,
'3.12.3' => null,
'3.12.4' => [
'upload_gui' => 'page',
'captcha_api' => 'hcaptcha', //recaptcha_version(2,3),hcaptcha
],
'3.12.5' => null,
'3.12.6' => null,
'3.12.7' => null,
'3.12.8' => [
'force_captcha_contact_page' => 1, //force_recaptcha_contact_page
],
'3.12.9' => null,
'3.12.10' => null,
'3.13.0' => [
'dump_update_query' => 0,
],
'3.13.1' => null,
'3.13.2' => null,
'3.13.3' => null,
'3.13.4' => [
'enable_powered_by' => 1,
'akismet' => 0,
'akismet_api_key' => '',
'stopforumspam' => 0,
],
'3.13.5' => null,
'3.14.0' => [
// 'upload_enabled_image_formats' => 'jpg,png,bmp,gif,webp',
],
'3.14.1' => null,
'3.15.0' => [
// 'hostname' => null,
'theme_show_embed_content_for' => 'all', // none,users,all
],
'3.15.1' => null,
'3.15.2' => null,
'3.16.0' => [
'moderatecontent' => 0,
'moderatecontent_key' => '',
'moderatecontent_block_rating' => 'a', // ,a,t
'moderatecontent_flag_nsfw' => 'a', // ,a,t
'moderatecontent_auto_approve' => 0,
'moderate_uploads' => '', // ,all,guest,
'image_lock_nsfw_editing' => 0,
],
'3.16.1' => null,
'3.16.2' => null,
'3.17.0' => null,
'3.17.1' => null,
'3.17.2' => null,
'3.18.0' => null,
'3.18.1' => null,
'3.18.2' => null,
'3.18.3' => null,
'3.20.0' => null,
'3.20.1' => null,
'3.20.2' => null,
'3.20.3' => null,
'3.20.4' => null,
'3.20.5' => null,
'3.20.6' => null,
'3.20.7' => null,
'3.20.8' => [
'enable_uploads_url' => 0,
],
'3.20.9' => null,
'3.20.10' => null,
'3.20.11' => null,
'3.20.12' => null,
'3.20.13' => [
// 'chevereto_news' => 'a:0:{}', // deprecated @4.2.0
// 'cron_last_ran' => '0000-00-00 00:00:00', // deprecated @4.2.0
],
'3.20.14' => null,
'3.20.15' => null,
'3.20.16' => null,
'4.0.0.beta.1' => null,
'4.0.0.beta.2' => null,
'4.0.0.beta.3' => null,
'4.0.0.beta.4' => null,
'4.0.0.beta.5' => [
'logo_type' => 'vector', // vector,image,text,
// 'theme_palette' => '0',
],
'4.0.0.beta.7' => [
'route_user' => 'user',
'root_route' => 'user',
],
'4.0.0.beta.8' => null,
'4.0.0.beta.9' => [
'arachnid' => 0,
// 'arachnid_key' => '', @ deprecated @4.2.0
'image_first_tab' => 'about', //embeds,about,info
],
'4.0.0-beta.10' => null,
'4.0.0-beta.11' => [
'website_random_guest' => 1,
'website_search_guest' => 1,
'debug_errors' => 0,
// 'news_check_datetimegmt' => '', // deprecated @4.2.0
],
'4.0.0' => null,
'4.0.1' => null,
'4.0.2' => null,
'4.0.3' => null,
'4.0.4' => [
'stop_words' =>
// https://dev.mysql.com/doc/refman/8.0/en/string-literals.html#character-escape-sequences
<<<'SPAM'
richard blank
costa rica[\\\'s]*? call center
call center sales
SPAM,
],
'4.0.5' => null,
'4.0.6' => [
'semantics_album' => '',
'semantics_albums' => '',
'semantics_image' => '',
'semantics_images' => '',
'semantics_user' => '',
'semantics_users' => '',
'semantics_explore' => '',
'semantics_discovery' => '',
'semantics_category' => '',
'semantics_categories' => '',
],
'4.0.7' => null,
'4.0.8' => null,
'4.0.9' => null,
'4.0.10' => [
'listing_viewer' => 0,
],
'4.0.11' => null,
'4.0.12' => null,
'4.1.0' => [
'twitter_account' => '',
'theme_font' => '0',
// 'upload_enabled_image_formats' => 'jpg,png,bmp,gif,webp,mp4,webm',
],
'4.1.1' => [
// 'upload_enabled_image_formats' => 'jpg,png,bmp,gif,webp,mov,mp4,webm',
],
'4.1.2' => null,
'4.1.3' => [
'user_profile_view' => 'files',
],
'4.1.4' => null,
'4.2.0' => [
'upload_enabled_image_formats' => 'avif,jpg,png,bmp,gif,webp,mov,mp4,webm',
'theme_palette' => '10',
'asset_storage_api_id' => '',
'asset_storage_url' => '',
'asset_storage_account_id' => '',
'asset_storage_account_name' => '',
'asset_storage_bucket' => '',
'asset_storage_key' => '',
'asset_storage_region' => '',
'asset_storage_secret' => '',
'asset_storage_server' => '',
'asset_storage_service' => '',
'asset_storage_use_path_style_endpoint' => 0,
'guest_albums' => 0,
'route_video' => 'video',
'route_audio' => 'audio',
'cache_ttl' => '0',
'image_load_max_filesize_mb' => '5',
'upload_max_filesize_mb_guest' => '10',
'arachnid_api_username' => '',
'arachnid_api_password' => '',
],
'4.2.1' => null,
'4.2.2' => null,
'4.2.3' => null,
'4.2.4' => null,
'4.2.5' => null,
'4.3.0' => [
'semantics_video' => '',
'semantics_videos' => '',
'semantics_tag' => '',
'semantics_tags' => '',
'semantics_file' => '',
'semantics_files' => '',
'theme_palette_user_select' => 1,
'upload_max_filesize_mb' => (string) bytes_to_mb(get_ini_bytes(env()['CHEVERETO_MAX_UPLOAD_SIZE'])),
'enable_api_user' => 1,
'enable_api_guest' => 0,
],
'4.3.1' => null,
'4.3.2' => null,
'4.3.3' => null,
'4.3.4' => null,
'4.3.5' => null,
'4.3.6' => null,
'4.3.7' => null,
'4.4.0' => null,
'4.4.1' => null,
'4.4.2' => null,
];
/**
* The following settings are for enabling backwards compatibility
* It is recommended to use a proper storage device when possible!
*
* You can configure both asset/external storage from the admin dashboard.
*/
if ((bool) env()['CHEVERETO_ENABLE_LOCAL_STORAGE']) {
// Reflect a path under /images/ which is the default persistent storage mounted path for zero config
// target -> /images/_assets/content/images...
$asset_storage_default = [
'asset_storage_api_id' => '8',
'asset_storage_bucket' => PATH_PUBLIC . 'images/_assets/',
'asset_storage_url' => env()['CHEVERETO_HOSTNAME_PATH'] . 'images/_assets/',
];
if ($installed_version !== '') {
// Legacy application stores assets relative to root
// target -> /content/images/...
if (env()['CHEVERETO_SERVICING'] === 'server') {
$asset_storage_default = [
'asset_storage_api_id' => '8',
'asset_storage_bucket' => PATH_PUBLIC,
'asset_storage_url' => env()['CHEVERETO_HOSTNAME_PATH'],
];
}
}
$settings_updates['4.2.0'] = array_merge($settings_updates['4.2.0'], $asset_storage_default);
}
$variables_updates = [
'4.2.0' => [
'id_padding' => 0,
'crypt_salt' => '',
'chevereto_version_installed' => APP_VERSION,
'last_used_storage' => 0,
'update_check_datetimegmt' => '0000-00-00 00:00:00',
'update_check_notified_release' => APP_VERSION,
'chevereto_news' => [],
'cron_last_ran' => '0000-00-00 00:00:00',
'news_check_datetimegmt' => '0000-00-00 00:00:00',
'storages_all' => 0,
'storages_active' => 0,
'login_providers_active' => 0,
],
'4.4.0' => [
'hmac_secret_token' => randomKey()->base64(),
'hmac_secret_upload' => randomKey()->base64(),
'hmac_secret_api_key' => randomKey()->base64(),
],
];
$cheveretoFreeMap = [
'1.0.0' => '3.8.3',
'1.0.1' => '3.8.3',
'1.0.2' => '3.8.3',
'1.0.3' => '3.8.4',
'1.0.4' => '3.8.4',
'1.0.5' => '3.8.8',
'1.0.6' => '3.8.10',
'1.0.7' => '3.8.11',
'1.0.8' => '3.8.13',
'1.0.9' => '3.9.5',
'1.0.10' => '3.10.5',
'1.0.11' => '3.10.5',
'1.0.12' => '3.10.5',
'1.0.13' => '3.10.5',
'1.1.0' => '3.10.18',
'1.1.1' => '3.10.18',
'1.1.2' => '3.10.18',
'1.1.3' => '3.10.18',
'1.1.4' => '3.10.18',
'1.2.0' => '3.15.2',
'1.2.1' => '3.15.2',
'1.2.2' => '3.15.2',
'1.2.3' => '3.15.2',
'1.3.0' => '3.16.2',
'1.4.0' => '3.16.2',
'1.5.0' => '3.16.2',
'1.6.0' => '3.16.2',
'1.6.1' => '3.16.2',
'1.6.2' => '3.16.2',
];
$settings_delete = [
'banner_home_before_cover',
'banner_home_before_cover_nsfw',
'cloudflare', // 3.15.0
'theme_show_embed_content', // 3.15.0
'theme_top_bar_color', // 3.15.0
'minify_enable', // 3.19.0,
'theme_main_color',
'theme_top_bar_button_color',
'website_https', // 4.0.5
];
$settings_rename = [
// 3.5.12
'theme_peafowl_home_uid' => 'homepage_uids',
'theme_peafowl_download_button' => 'theme_download_button',
'theme_peafowl_nsfw_upload_checkbox' => 'theme_nsfw_upload_checkbox',
'theme_peafowl_image_listing_size' => 'theme_image_listing_sizing',
// 3.5.15
'theme_home_uids' => 'homepage_uids',
'theme_home_endless_mode' => 'homepage_endless_mode',
// 3.6.2
'single_user_mode_routing' => 'website_mode_personal_routing',
'single_user_mode_id' => 'website_mode_personal_uid',
// 3.7.2
'upload_medium_width' => 'upload_medium_size',
// 4.0.3
'recaptcha_version' => 'captcha_api',
'recaptcha' => 'captcha',
'recaptcha_private_key' => 'captcha_secret',
'recaptcha_public_key' => 'captcha_sitekey',
'recaptcha_threshold' => 'captcha_threshold',
'force_recaptcha_contact_page' => 'force_captcha_contact_page',
];
$initial_settings = [];
$initial_variables = [];
foreach ($settings_updates as $k => $v) {
if (array_key_exists($k, $variables_updates)) {
$initial_variables += $variables_updates[$k];
}
if ($v === null) {
continue;
}
$initial_settings += $v;
}
try {
$is_2X = ((int) DB::get('info', [
'key' => 'version',
])) > 0;
} catch (Exception $e) {
$is_2X = false;
}
$isMariaDB = false;
if (hasEnvDbInfo()) {
if (! DB::hasInstance()) {
DB::fromEnv();
}
$db = DB::getInstance();
$sqlServerVersion = $db->getAttr(PDO::ATTR_SERVER_VERSION);
$db->closeCursor();
$innoDBrequiresVersion = '5.6'; // default:mysql
if (stripos($sqlServerVersion, 'MariaDB') !== false) {
$isMariaDB = true;
$innoDBrequiresVersion = '10.0.5';
$explodeSqlVersion = explode('-', $sqlServerVersion, 2);
foreach ($explodeSqlVersion as $pos => $ver) {
if (str_starts_with($ver, 'MariaDB')) {
continue;
}
$sqlServerVersion = $ver;
}
}
$doing = 'ready';
}
$fulltext_engine = 'InnoDB';
$maintenance = getSetting('maintenance');
if (isset($cheveretoFreeMap[$installed_version])) {
$installed_version = $cheveretoFreeMap[$installed_version];
}
if ($installed_version !== '') {
$doing = 'already';
}
$opts = getopt('C:') ?: [];
$safe_post = Handler::var('safe_post');
if (! empty(post())) {
$params = post();
if (isset(post()['debug'])) {
$params['debug'] = true;
}
} elseif ($opts !== []) {
if ($doing === 'already') {
$opts = getopt('C:d::');
} else {
$opts = getopt('C:u:e:x:d::');
$params = [];
$missing = [];
foreach ([
'username' => 'u',
'email' => 'e',
'password' => 'x',
] as $k => $o) {
$params[$k] = $opts[$o] ?? null;
if (! isset($params[$k])) {
$missing[] = $k . " -{$o}";
}
}
if ($missing !== []) {
logger('Missing ' . implode(', ', $missing) . "\n");
exit(255);
}
}
$params['dump'] = isset($opts['d']);
}
if ($isMariaDB && isset($sqlServerVersion)) {
$explodeMariaVersion = explode('.', $sqlServerVersion);
$mariaVersion = ($explodeMariaVersion[0] ?? '10')
. '.'
. ($explodeMariaVersion[1] ?? '');
switch ($mariaVersion) {
case '10.0':
case '10.1':
case '10.2':
case '10.3':
$mysql_version = '5'; // 5.7
break;
case '10.4':
case '10.5':
case '10.6':
default:
$mysql_version = '8'; // 8.0
break;
}
} else {
$mysql_version = version_compare($sqlServerVersion ?? '8', '8', '>=')
? '8'
: '5';
}
$dbSchemaVer = sprintf('mysql-%s', $mysql_version);
$paramsCheck = $params ?? [];
unset($paramsCheck['dump']);
$query_populate_stats =
<< $v) {
$db_settings_keys[] = $v['setting_name'];
}
} catch (Exception $e) {
}
try {
$db_variables = DB::get('variables', 'all');
foreach ($db_variables as $k => $v) {
$db_variables_keys[] = $v['variable_name'];
}
} catch (Exception $e) {
}
if ((
! empty($db_settings_keys)
&& count($initial_settings) !== count($db_settings_keys)
) || (version_compare(APP_VERSION, $installed_version, '>'))
) {
if (! array_key_exists(APP_VERSION, $settings_updates)) {
throw new LogicException(
(string) message(
'Outdated installation files. Re-upload %folder% folder with the one from %version%',
folder: 'app/legacy/install',
version: APP_VERSION
)
);
}
$schema = [];
$raw_schema = DB::queryFetchAll(
'SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA="'
. env()['CHEVERETO_DB_NAME']
. '" AND TABLE_NAME LIKE "'
. env()['CHEVERETO_DB_TABLE_PREFIX']
. '%";'
);
foreach ($raw_schema as $k => $v) {
$TABLE = preg_replace('#' . env()['CHEVERETO_DB_TABLE_PREFIX'] . '#i', '', strtolower($v['TABLE_NAME']), 1);
$COLUMN = $v['COLUMN_NAME'];
if (! array_key_exists($TABLE, $schema)) {
$schema[$TABLE] = [];
}
$schema[$TABLE][$COLUMN] = $v;
}
$triggers_to_remove = [
'album_insert',
'album_delete',
'follow_insert',
'follow_delete',
'image_insert',
'image_update',
'image_delete',
'like_insert',
'like_delete',
'notification_insert',
'notification_update',
'notification_delete',
'user_insert',
'user_delete',
];
$db_triggers = DB::queryFetchAll('SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS');
if ($db_triggers) {
$drop_trigger_sql = null;
foreach ($db_triggers as $k => $v) {
$trigger = $v['TRIGGER_NAME'];
if (in_array($v['TRIGGER_NAME'], $triggers_to_remove, true)) {
$drop_trigger = 'DROP TRIGGER IF EXISTS `' . $v['TRIGGER_NAME'] . '`;' . "\n";
$drop_trigger_sql .= $drop_trigger;
}
}
if ($drop_trigger_sql !== null) {
$drop_trigger_sql = rtrim($drop_trigger_sql, "\n");
$remove_triggers = false;
$remove_triggers = DB::queryExecute($drop_trigger_sql);
if ($remove_triggers === 0) {
chevereto_die('', 'To proceed you will need to run these queries in your database server:
', "Can't remove table triggers");
}
}
}
$DB_indexes = [];
$raw_indexes = DB::queryFetchAll(
'SELECT DISTINCT TABLE_NAME, INDEX_NAME, INDEX_TYPE FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = "'
. env()['CHEVERETO_DB_NAME']
. '"'
);
foreach ($raw_indexes as $k => $v) {
$TABLE = preg_replace('#' . env()['CHEVERETO_DB_TABLE_PREFIX'] . '#i', '', strtolower($v['TABLE_NAME']), 1);
$INDEX_NAME = $v['INDEX_NAME'];
if (! array_key_exists($TABLE, $DB_indexes)) {
$DB_indexes[$TABLE] = [];
}
$DB_indexes[$TABLE][$INDEX_NAME] = $v;
}
$CHV_indexes = [];
foreach (new DirectoryIterator(PATH_APP . 'schemas/' . $dbSchemaVer) as $fileInfo) {
if ($fileInfo->isDot() || $fileInfo->isDir() || ! array_key_exists($fileInfo->getBasename('.sql'), $schema)) {
continue;
}
$crate_table = file_get_contents(realpath($fileInfo->getPathname()));
if (preg_match_all('/(?:(?:FULLTEXT|UNIQUE)\s*)?KEY `(\w+)` \(.*\)/', $crate_table, $matches)) {
$CHV_indexes[$fileInfo->getBasename('.sql')] = array_combine($matches[1], $matches[0]);
}
}
$engines = [];
$raw_engines = DB::queryFetchAll(
'SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA = "'
. env()['CHEVERETO_DB_NAME']
. '" AND TABLE_NAME LIKE "'
. env()['CHEVERETO_DB_TABLE_PREFIX']
. '%";'
);
$update_table_storage = [];
foreach ($raw_engines as $k => $v) {
$TABLE = preg_replace('#' . env()['CHEVERETO_DB_TABLE_PREFIX'] . '#i', '', strtolower($v['TABLE_NAME']), 1);
$engines[$TABLE] = $v['ENGINE'];
if ($v['ENGINE'] !== 'InnoDB') {
$update_table_storage[] = 'ALTER TABLE ' . $v['TABLE_NAME'] . ' ENGINE = InnoDB;';
}
}
if ($update_table_storage !== []) {
chevereto_die('', 'Database table storage engine needs to be updated to InnoDB. Run the following command(s) in your MySQL console:
Review Converting Tables from MyISAM to InnoDB.
', 'Convert MyISAM tables to InnoDB');
}
$isUtf8mb4 = $installed_version === ''
|| version_compare($installed_version, '3.12.10', '>');
$modifyIntUnsignedNotNullAutoIncrement = [
'op' => 'MODIFY',
'type' => 'INT UNSIGNED',
'prop' => 'NOT NULL AUTO_INCREMENT',
];
$modifyIntUnsignedNotNull = [
'op' => 'MODIFY',
'type' => 'INT UNSIGNED',
'prop' => 'NOT NULL',
];
$modifyBigIntUnsignedNotNull = array_merge(
$modifyIntUnsignedNotNull,
[
'type' => 'BIGINT UNSIGNED',
]
);
$modifyIntUnsignedDefaultNull = [
'op' => 'MODIFY',
'type' => 'INT UNSIGNED',
'prop' => 'DEFAULT NULL',
];
$update_table = [
'3.1.0' => [
'logins' => [
'login_resource_id' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
'login_secret' => [
'op' => 'MODIFY',
'type' => 'text',
'prop' => "DEFAULT NULL COMMENT 'The secret part'",
],
],
'users' => [
'user_name' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
],
'settings' => [
'setting_value' => [
'op' => 'MODIFY',
'type' => 'text', //3.13.0
'prop' => null,
],
'setting_default' => [
'op' => 'MODIFY',
'type' => 'text', //3.13.0
'prop' => null,
],
],
],
'3.3.0' => [
'albums' => [
'album_privacy' => [
'op' => 'MODIFY',
'type' => "ENUM('public','password','private','private_but_link','custom')",
'prop' => "DEFAULT 'public'",
],
],
],
'3.4.0' => [
'images' => [
'image_category_id' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => 'DEFAULT NULL',
],
],
'albums' => [
'album_description' => [
'op' => 'ADD',
'type' => 'text',
'prop' => null,
],
],
'categories' => [],
],
'3.5.0' => [
'images' => [
// 'image_original_exifdata' => [
// 'op' => 'MODIFY',
// 'type' => 'text',
// 'prop' => null,
// ],
'image_storage' => [
'op' => 'CHANGE',
'to' => 'image_storage_mode',
'type' => "ENUM('datefolder','direct','old')",
'prop' => "NOT NULL DEFAULT 'datefolder'",
],
'image_chain' => [
'op' => 'ADD',
'type' => 'TINYINT',
'prop' => 'NOT NULL',
'tail' => << [],
'storage_apis' => [],
],
'3.5.3' => [
'storages' => [
'storage_region' => [
'op' => 'ADD',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
],
],
'3.5.5' => [
'queues' => [],
'storages' => [
'storage_server' => [
'op' => 'ADD',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
'storage_capacity' => [
'op' => 'ADD',
'type' => 'BIGINT UNSIGNED',
'prop' => 'DEFAULT NULL',
],
'storage_space_used' => [
'op' => 'ADD',
'type' => 'BIGINT UNSIGNED',
'prop' => "DEFAULT '0'",
'tail' => << [
'image_thumb_size' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => 'NOT NULL',
],
'image_medium_size' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
],
],
'3.5.7' => [
'queues' => [
'queue_type' => [
'op' => 'MODIFY',
'type' => "ENUM('storage-delete')",
'prop' => 'NOT NULL',
'tail' => << [
'storage_server' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
],
],
'3.5.8' => [
'images' => [
'op' => 'ALTER',
'prop' => 'ENGINE=%table_engine%; CREATE FULLTEXT INDEX `searchindex` ON `%table_prefix%images`(image_name, image_description, image_original_filename)',
],
'albums' => [
'op' => 'ALTER',
'prop' => 'ENGINE=%table_engine%; CREATE FULLTEXT INDEX `searchindex` ON `%table_prefix%albums`(album_name, album_description)',
],
'users' => [
'op' => 'ALTER',
'prop' => 'ENGINE=%table_engine%; CREATE FULLTEXT INDEX `searchindex` ON `%table_prefix%users`(user_name, user_username)',
],
],
'3.5.9' => [
'images' => [
'image_title' => [
'op' => 'ADD',
'type' => 'VARCHAR(100)', // 3.6.5
'prop' => 'DEFAULT NULL',
'tail' => << [
'album_name' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(100)', // 3.6.5
'prop' => 'NOT NULL',
],
],
],
'3.5.11' => [
'queues' => [
'queue_attempts' => [
'op' => 'ADD',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT 0',
],
'queue_status' => [
'op' => 'ADD',
'type' => "ENUM('pending','failed')",
'prop' => "NOT NULL DEFAULT 'pending'",
],
],
],
'3.5.12' => [
'query' => << [
'ip_bans' => [],
],
'3.6.0' => [
'users' => [
'user_newsletter_subscribe' => [
'op' => 'ADD',
'type' => 'TINYINT',
'prop' => "NOT NULL DEFAULT '1'",
],
'user_show_nsfw_listings' => [
'op' => 'ADD',
'type' => 'TINYINT',
'prop' => "NOT NULL DEFAULT '0'",
],
'user_bio' => [
'op' => 'ADD',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
],
],
'3.6.2' => [
'storages' => [
'storage_key' => [
'op' => 'MODIFY',
'type' => 'text', //3.13.0
'prop' => null,
],
'storage_secret' => [
'op' => 'MODIFY',
'type' => 'text', //3.13.0
'prop' => null,
],
],
],
'3.6.3' => [
'storages' => [
'storage_account_id' => [
'op' => 'ADD',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
'storage_account_name' => [
'op' => 'ADD',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
],
'query' => << [
'query' => << [
'images' => [
'image_title' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(100)',
'prop' => 'DEFAULT NULL',
],
],
'albums' => [
'album_name' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(100)',
'prop' => 'NOT NULL',
],
],
],
'3.6.7' => [
'pages' => [],
],
'3.6.8' => [
'users' => [
'user_image_keep_exif' => [
'op' => 'ADD',
'type' => 'TINYINT',
'prop' => "NOT NULL DEFAULT '1'",
],
'user_image_expiration' => [
'op' => 'ADD',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
],
'images' => [
'image_expiration_date_gmt' => [
'op' => 'ADD',
'type' => 'datetime',
'prop' => 'DEFAULT NULL',
],
],
],
'3.7.0' => [
'deletions' => [],
'follows' => [],
'likes' => [],
'notifications' => [],
'stats' => [],
'albums' => [
'album_creation_ip' => [
'op' => 'ADD',
'type' => 'VARCHAR(255)',
'prop' => 'NOT NULL',
],
'album_likes' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
],
'images' => [
'image_likes' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
],
'users' => [
'user_registration_ip' => [
'op' => 'ADD',
'type' => 'VARCHAR(255)',
'prop' => 'NOT NULL',
],
'user_likes' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0' COMMENT 'Likes made to content owned by this user'",
],
'user_liked' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0' COMMENT 'Likes made by this user'",
],
'user_following' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
'user_followers' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
'user_content_views' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
'user_notifications_unread' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
],
'query' => $query_populate_stats,
],
'3.7.5' => [
'users' => [
'user_is_private' => [
'op' => 'ADD',
'type' => 'TINYINT',
'prop' => "NOT NULL DEFAULT '0'",
],
],
'storages' => [
'storage_service' => [
'op' => 'ADD',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
],
],
'3.8.0' => [
'images' => [
'image_is_animated' => [
'op' => 'ADD',
'type' => 'TINYINT',
'prop' => "NOT NULL DEFAULT '0'",
],
],
'albums' => [
'album_password' => [
'op' => 'ADD',
'type' => 'text',
'prop' => null,
],
],
'requests' => [
//'request_type' => [], void in 4.0.0-beta.10
'request_content_id' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => 'DEFAULT NULL',
],
],
],
'3.9.0' => [
'albums' => [
'album_views' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
],
'likes' => [
'like_content_type' => [
'op' => 'MODIFY',
'type' => "ENUM('image','album')",
'prop' => 'DEFAULT NULL',
],
],
'notifications' => [
'notification_content_type' => [
'op' => 'MODIFY',
'type' => "ENUM('user','image','album')",
'prop' => 'NOT NULL',
],
],
'stats' => [
'stat_album_views' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
'stat_album_likes' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
'stat_likes' => [
'op' => 'CHANGE',
'to' => 'stat_image_likes',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
],
],
'3.10.13' => [
'images' => [
'image_source_md5' => [
'op' => 'ADD',
'type' => 'VARCHAR(32)',
'prop' => 'DEFAULT NULL',
],
],
],
'3.11.0' => [
'query' => << [
'imports' => [],
'importing' => [],
'images' => [
'image_storage_mode' => [
'op' => 'MODIFY',
'type' => "ENUM('datefolder','direct','old','path')",
'prop' => "NOT NULL DEFAULT 'datefolder'",
],
'image_path' => [
'op' => 'ADD',
'type' => 'VARCHAR(4096)',
'prop' => 'DEFAULT NULL',
],
],
// 4.3.0
// 'albums' => [
// 'album_user_id' => [
// 'op' => 'MODIFY',
// 'type' => 'INT UNSIGNED',
// 'prop' => 'DEFAULT NULL',
// ],
// ],
'users' => [
'user_is_manager' => [
'op' => 'ADD',
'type' => 'TINYINT',
'prop' => "NOT NULL DEFAULT '0'",
],
],
'query' => << [
'pages' => [
'page_internal' => [
'op' => 'ADD',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
],
'query' => << [
'settings' => [
'setting_name' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(255)',
'prop' => 'CHARACTER SET utf8 COLLATE utf8_bin NOT NULL',
],
],
'deletions' => [
'deleted_content_ip' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(255)',
'prop' => 'NOT NULL',
],
],
'ip_bans' => [
'ip_ban_ip' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(255)',
'prop' => 'NOT NULL',
],
'ip_ban_message' => [
'op' => 'MODIFY',
'type' => 'text',
'prop' => 'DEFAULT NULL',
],
],
'pages' => [
'page_internal' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
],
'users' => [
'user_username' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(255)',
'prop' => 'NOT NULL',
],
'user_email' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
'user_image_expiration' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
'user_registration_ip' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(255)',
'prop' => 'NOT NULL',
],
],
/*
* Note: The change from utf8 to utf8mb4 causes that TEXT changes to MEDIUMTEXT to ensure that the
* converted data will fit in the resulting column. Same goes for MEDIUMTEXT -> LONGTEXT
*
* https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
* Look for "For a column that has a data type of VARCHAR or one"
*/
'query' => (
isset($DB_indexes['albums']['album_creation_ip'])
? << [
'query' => << [
'deletions' => [
'deleted_content_original_filename' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(255)',
'prop' => 'DEFAULT NULL',
],
],
'logins' => [
'login_type' => [
'op' => 'MODIFY',
'type' => "ENUM('password','session','cookie','facebook','twitter','google','vk','cookie_facebook','cookie_twitter','cookie_google','cookie_vk')",
'prop' => 'NOT NULL',
],
],
],
'3.15.0' => [
'imports' => [
'import_continuous' => [
'op' => 'ADD',
'type' => 'TINYINT',
'prop' => "NOT NULL DEFAULT '0'",
],
],
'query' => << [
'locks' => [],
'images' => [
'image_is_approved' => [
'op' => 'ADD',
'type' => 'TINYINT',
'prop' => "NOT NULL DEFAULT '1'",
],
],
],
'3.17.0' => [
'albums' => [
'album_cover_id' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => 'DEFAULT NULL',
],
'album_parent_id' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => 'DEFAULT NULL',
],
],
'images' => [
'image_is_360' => [
'op' => 'ADD',
'type' => 'TINYINT',
'prop' => "NOT NULL DEFAULT '0'",
],
],
'query' => << [
'assets' => [],
'pages' => [
'page_code' => [
'op' => 'ADD',
'type' => 'text',
'prop' => null,
],
],
'query' => << [
'query' => << [
'query' => << [
'query' => 'UPDATE `%table_prefix%settings` SET `setting_value`="default/watermark.png" WHERE `setting_name`="watermark_image" AND `setting_value`="watermark.png";',
],
'3.20.5' => [
'query' => 'UPDATE `%table_prefix%settings` SET `setting_typeset`="string" WHERE `setting_name`="explore_albums_min_image_count";',
],
'3.20.6' => [
'query' => << [
'users' => [
'user_palette_id' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
],
'query' => version_compare($installed_version, '3.15.0', '>=')
? 'ALTER TABLE `%table_prefix%users` DROP COLUMN `user_is_dark_mode`;'
: '',
],
'4.0.0.beta.7' => [
'api_keys' => [],
// 4.4.0
// 'images_hash' => []
],
'4.0.0-beta.10' => [
'two_factors' => [],
'requests' => [
'request_type' => [
'op' => 'MODIFY',
'type' => "ENUM('upload','signup','account-edit','account-password-forgot','account-password-reset','account-resend-activation','account-email-needed','account-change-email','account-activate','login','content-password','account-two-factor')",
'prop' => 'NOT NULL',
],
],
],
'4.0.0-beta.11' => [
'pages' => [
'page_code' => [
'op' => 'MODIFY',
'type' => 'text',
'prop' => null,
],
],
'login_connections' => [],
'login_cookies' => [],
'login_passwords' => [],
'login_providers' => [],
'query' => << [
'query' => $albumUpdateQueries ?? '',
],
'4.0.1' => [
'query' => << [
'albums' => [
'album_cta_enable' => [
'op' => 'ADD',
'type' => 'TINYINT',
'prop' => "NOT NULL DEFAULT '0'",
],
'album_cta' => [
'op' => 'ADD',
'type' => 'longtext',
'prop' => null,
],
],
],
'4.1.0' => [
'storages' => [
'storage_type_chain' => [
'op' => 'ADD',
'type' => 'TINYINT UNSIGNED',
'prop' => 'NOT NULL DEFAULT "1"',
],
],
'images' => [
'image_size' => $modifyBigIntUnsignedNotNull,
'image_frame_size' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
'image_duration' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
'image_type' => [
'op' => 'ADD',
'type' => 'TINYINT UNSIGNED',
'prop' => "as (case
when `image_extension` in ('pdf','doc','md') then 4
when `image_extension` in ('mp3','m4a','wav') then 3
when `image_extension` in ('mp4','webm') then 2
when `image_extension` in ('jpg','jpeg','gif','png','webp') then 1
else 0 end) stored",
],
],
],
'4.2.0' => [
'users' => [
'user_id' => $modifyIntUnsignedNotNullAutoIncrement,
'user_file_meta_tag_camera_model' => [
'op' => 'ADD',
'type' => 'TINYINT',
'prop' => "NOT NULL DEFAULT '0'",
],
],
'categories' => [
'category_url_key' => [
'op' => 'MODIFY',
'type' => 'VARCHAR(32)',
'collation' => 'utf8mb4_bin',
'prop' => 'NOT NULL',
],
],
'storages' => [
'storage_use_path_style_endpoint' => [
'op' => 'ADD',
'type' => 'TINYINT UNSIGNED',
'prop' => 'NOT NULL DEFAULT "0"',
],
'storage_deleted_at' => [
'op' => 'ADD',
'type' => 'DATETIME',
'prop' => 'NULL DEFAULT NULL',
],
],
'images' => [
'image_id' => $modifyIntUnsignedNotNullAutoIncrement,
'image_type' => [
'op' => 'MODIFY',
'type' => 'TINYINT UNSIGNED',
'prop' => "as (case
when `image_extension` in ('pdf','doc','md') then 4
when `image_extension` in ('mp3','m4a','wav') then 3
when `image_extension` in ('mp4','webm','mov') then 2
when `image_extension` in ('avif','jpg','jpeg','gif','png','webp') then 1
else 0 end) stored",
],
],
'stats' => [
'stat_tags' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
'stat_cron_runs' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
'stat_cron_time' => [
'op' => 'ADD',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
],
'albums' => [
'album_id' => $modifyIntUnsignedNotNullAutoIncrement,
],
'tags' => [],
'tags_files' => [],
'tags_users' => [],
'tags_albums' => [],
'variables' => [],
'query' => << [
'images' => [
'image_original_exifdata' => [
'op' => 'MODIFY',
'type' => 'mediumtext',
'prop' => null,
],
],
'importing' => [
'importing_content_id' => [
'op' => 'MODIFY',
'type' => 'INT UNSIGNED',
'prop' => 'DEFAULT NULL',
],
],
],
'4.3.0' => [
'query.1' => $db->getSqlDropForeignKey('tags_albums', 'tags_albums_ibfk_1')
. $db->getSqlDropForeignKey('tags_albums', 'tags_albums_ibfk_2')
. $db->getSqlDropForeignKey('tags_albums', 'tags_albums_ibfk_3')
. $db->getSqlDropForeignKey('tags_users', 'tags_users_ibfk_1')
. $db->getSqlDropForeignKey('tags_users', 'tags_users_ibfk_2')
. $db->getSqlDropForeignKey('tags_files', 'tags_files_ibfk_1')
. $db->getSqlDropForeignKey('tags_files', 'tags_files_ibfk_2')
. $db->getSqlDropIndex('images', 'image_md5')
. $db->getSqlDropIndex('images', 'image_source_md5')
. $db->getSqlDropIndex('deletions', 'deleted_content_md5'),
'assets' => [
'asset_md5' => [
'op' => 'CHANGE',
'to' => 'asset_checksum',
'type' => 'VARCHAR(32)',
'prop' => 'NOT NULL',
],
],
'albums' => [
'album_id' => $modifyIntUnsignedNotNullAutoIncrement,
'album_user_id' => $modifyIntUnsignedDefaultNull,
'album_cover_id' => $modifyIntUnsignedDefaultNull,
'album_parent_id' => $modifyIntUnsignedDefaultNull,
],
'api_keys' => [
'api_key_id' => $modifyIntUnsignedNotNullAutoIncrement,
'api_key_user_id' => $modifyIntUnsignedDefaultNull,
],
'confirmations' => [
'confirmation_id' => $modifyIntUnsignedNotNullAutoIncrement,
'confirmation_user_id' => $modifyIntUnsignedNotNull,
],
'deletions' => [
'deleted_id' => $modifyIntUnsignedNotNullAutoIncrement,
'deleted_content_id' => $modifyIntUnsignedNotNull,
'deleted_content_user_id' => $modifyIntUnsignedDefaultNull,
'deleted_content_md5' => [
'op' => 'CHANGE',
'to' => 'deleted_content_checksum',
'type' => 'VARCHAR(32)',
'prop' => 'DEFAULT NULL',
],
],
'follows' => [
'follow_id' => $modifyIntUnsignedNotNullAutoIncrement,
'follow_user_id' => $modifyIntUnsignedNotNull,
'follow_followed_user_id' => $modifyIntUnsignedNotNull,
],
'images' => [
'image_id' => $modifyIntUnsignedNotNullAutoIncrement,
'image_user_id' => $modifyIntUnsignedDefaultNull,
'image_album_id' => $modifyIntUnsignedDefaultNull,
'image_storage_id' => $modifyIntUnsignedDefaultNull,
'image_category_id' => $modifyIntUnsignedDefaultNull,
'image_md5' => [
'op' => 'CHANGE',
'to' => 'image_checksum',
'type' => 'VARCHAR(32)',
'prop' => 'NOT NULL',
],
'image_source_md5' => [
'op' => 'CHANGE',
'to' => 'image_source_checksum',
'type' => 'VARCHAR(32)',
'prop' => 'DEFAULT NULL',
],
],
'logins' => [
'login_id' => $modifyIntUnsignedNotNullAutoIncrement,
'login_user_id' => $modifyIntUnsignedNotNull,
],
'login_passwords' => [
'login_password_id' => $modifyIntUnsignedNotNullAutoIncrement,
'login_password_user_id' => $modifyIntUnsignedNotNull,
],
'login_cookies' => [
'login_cookie_id' => $modifyIntUnsignedNotNullAutoIncrement,
'login_cookie_user_id' => $modifyIntUnsignedNotNull,
'login_cookie_connection_id' => [
'op' => 'MODIFY',
'type' => 'INT UNSIGNED',
'prop' => 'DEFAULT 0',
],
],
'login_connections' => [
'login_connection_id' => $modifyIntUnsignedNotNullAutoIncrement,
'login_connection_user_id' => $modifyIntUnsignedNotNull,
'login_connection_provider_id' => $modifyIntUnsignedNotNull,
],
'likes' => [
'like_id' => $modifyIntUnsignedNotNullAutoIncrement,
'like_user_id' => $modifyIntUnsignedDefaultNull,
'like_content_id' => $modifyIntUnsignedNotNull,
'like_content_user_id' => $modifyIntUnsignedDefaultNull,
],
'notifications' => [
'notification_id' => $modifyIntUnsignedNotNullAutoIncrement,
'notification_user_id' => $modifyIntUnsignedNotNull,
'notification_trigger_user_id' => $modifyIntUnsignedDefaultNull,
'notification_type_id' => $modifyIntUnsignedNotNull,
],
'tags_albums' => [
'tag_album_tag_id' => $modifyIntUnsignedNotNull,
'tag_album_user_id' => $modifyIntUnsignedNotNull,
'tag_album_album_id' => $modifyIntUnsignedNotNull,
],
'tags_files' => [
'tag_file_tag_id' => $modifyIntUnsignedNotNull,
'tag_file_file_id' => $modifyIntUnsignedNotNull,
],
'tags_users' => [
'tag_user_tag_id' => $modifyIntUnsignedNotNull,
'tag_user_user_id' => $modifyIntUnsignedNotNull,
],
'tags' => [
'tag_id' => $modifyIntUnsignedNotNullAutoIncrement,
'tag_user_id' => $modifyIntUnsignedNotNull,
],
'two_factors' => [
'two_factor_id' => $modifyIntUnsignedNotNullAutoIncrement,
'two_factor_user_id' => $modifyIntUnsignedDefaultNull,
],
'requests' => [
'request_id' => $modifyIntUnsignedNotNullAutoIncrement,
'request_user_id' => $modifyIntUnsignedDefaultNull,
'request_content_id' => $modifyIntUnsignedDefaultNull,
],
'users' => [
'user_id' => $modifyIntUnsignedNotNullAutoIncrement,
'user_palette_id' => [
'op' => 'MODIFY',
'type' => 'INT UNSIGNED',
'prop' => "NOT NULL DEFAULT '0'",
],
],
'uploads' => [],
'uploads_chunks' => [],
'query.2' => << [
'login_cookies' => [
'login_cookie_last_seen_gmt' => [
'op' => 'ADD',
'type' => 'DATETIME',
'prop' => 'NULL',
],
],
'images' => [
'image_delete_hash' => [
'op' => 'ADD',
'type' => 'VARCHAR(255)',
'prop' => 'NULL',
],
],
'query' => version_compare($installed_version, '4.0.0.beta.7', '>=')
?
<< $changes) {
if (version_compare($version, $installed_version, '<=')) {
continue;
}
foreach ($changes as $table => $columns) {
if ($table === 'query' || str_starts_with($table, 'query.')) {
if (version_compare($version, $installed_version, '>')) {
$sql_update[] = (string) $columns;
}
continue;
}
$schema_table = $schema[$table] ?? [];
$create_table = false;
if (! array_key_exists($table, $schema)
&& ! in_array($table, $required_sql_files, true)
) {
$create_table = true;
} elseif ($table === 'storages' && ! array_key_exists('storage_bucket', $schema_table)) {
$create_table = true;
}
if (! in_array($table, $required_sql_files, true) && $create_table) {
/** @var string $schemaTableSql */
$schemaTableSql = file_get_contents(PATH_APP . 'schemas/' . $dbSchemaVer . '/' . $table . '.sql')
?: throw new LogicException('Missing schema file for table ' . $table);
$sql_update[] = $schemaTableSql;
$required_sql_files[] = $table;
}
if (in_array($table, $required_sql_files, true)) {
continue;
}
if (isset($columns['op'])) {
if ($columns['op'] === 'ALTER') { // @phpstan-ignore-line
if ($DB_indexes[$table]['searchindex']
&& strpos($columns['prop'] ?? '', 'CREATE FULLTEXT INDEX `searchindex`') !== false
) {
continue 2;
}
$collate = '';
if (isset($columns['collation'])) {
$collate = sprintf('COLLATE %s', $columns['collation']);
}
$sql_update[] = strtr(
'ALTER TABLE `%table_prefix%' . $table . '` %collate %prop; %tail',
[
'%collate' => $collate,
'%prop' => $columns['prop'],
'%tail' => $columns['tail'] ?? '',
]
);
}
continue;
}
foreach ($columns as $column => $column_meta) {
$query = null;
$schema_column = $schema_table[$column] ?? null;
switch ($column_meta['op']) {
case 'MODIFY':
// schema expression always comes with lowercase keywords
$schemaExpression = $schema_column['GENERATION_EXPRESSION'] ?? '';
$columnExpression = preg_replace('/\s+/', ' ', $column_meta['prop'] ?? '');
$isGenerated = str_contains(mb_strtolower($schema_column['EXTRA'] ?? ''), 'generated');
$isStored = str_contains(mb_strtolower($schema_column['EXTRA'] ?? ''), 'stored');
if ($isGenerated && $isStored) {
$columnExpression = str_replace_first('as (', '', $columnExpression);
$columnExpression = str_replace_last(') stored', '', $columnExpression);
}
$schemaCollation = mb_strtolower($schema_column['COLLATION_NAME'] ?? '');
$columnCollation = mb_strtolower($column_meta['collation'] ?? '');
$collationUpdated = $columnCollation !== ''
&& $schemaCollation !== $columnCollation;
$dataType = mb_strtoupper($schema_column['DATA_TYPE'] ?? '');
$columnMetaType = mb_strtoupper($column_meta['type']);
$schemaColumn = mb_strtoupper($schema_column['COLUMN_TYPE'] ?? '');
if (in_array($dataType, ['INT', 'TINYINT', 'BIGINT'])) {
$schemaColumn = preg_replace('/\(\d+\)/', '', $schemaColumn);
}
if (
array_key_exists($column, $schema[$table])
&& (
$schemaColumn !== $columnMetaType
|| $collationUpdated
|| preg_match('/DEFAULT NULL/i', $column_meta['prop'] ?? '')
&& ($schema_column['IS_NULLABLE'] ?? '') === 'NO'
)
) {
$query = '`%column` %type';
if ($collationUpdated) {
$query .= ' COLLATE %collation';
}
}
break;
case 'CHANGE':
if (array_key_exists($column, $schema[$table])
&& ! array_key_exists($column_meta['to'], $schema[$table])
) {
$query = '`%column` `%to` %type';
}
break;
case 'ADD':
if (! array_key_exists($column, $schema[$table])) {
$query = '`%column` %type';
}
break;
}
if ($query !== null) {
$stock_tr = ['op', 'type', 'to', 'prop', 'tail', 'collation'];
$meta_tr = [];
foreach ($stock_tr as $v) {
$meta_tr['%' . $v] = $column_meta[$v] ?? '';
}
$sql_update[] = strtr(
'ALTER TABLE `%table_prefix%' . $table . '` %op ' . $query . ' %prop; %tail',
array_merge([
'%column' => $column,
], $meta_tr)
);
}
}
}
}
foreach ($CHV_indexes as $table => $indexes) {
$field_prefix = DB::getFieldPrefix($table);
foreach ($indexes as $index => $indexProp) {
if ($index === 'searchindex' || $index === $field_prefix . '_id' || ! starts_with($field_prefix . '_', $index)) {
continue;
}
if (! array_key_exists($index, $DB_indexes[$table])) {
$sql_update[] = 'ALTER TABLE `%table_prefix%' . $table . '` ADD ' . $indexProp . ';';
}
}
}
$versions = array_keys(array_merge($settings_updates, $update_table));
foreach ($versions as $k) {
$sql = '';
foreach ($settings_updates[$k] ?? [] as $settingKey => $settingValue) {
if (in_array($settingKey, $db_settings_keys, true)) {
continue;
}
$settingType = Settings::getType($settingValue);
$sql .= << $variableValue) {
if (in_array($variableKey, $db_variables_keys, true)) {
continue;
}
$variableType = getType($variableValue);
$variableValue = Variable::getValueAsString($variableType, $variableValue);
if (hasEncryption() && in_array($variableKey, Variable::ENCRYPTED_NAMES, true)) {
$variableValue = encodeEncrypt($variableValue);
}
$sql .= << $v) {
if (array_key_exists($k, Settings::get())) {
$settingValue = Settings::get()[$k];
$value = $settingValue === null
? 'NULL'
: "'{$settingValue}'";
$sql_update[] = << PATH_PUBLIC,
'%table_prefix%' => env()['CHEVERETO_DB_TABLE_PREFIX'],
'%table_root_prefix%' => env()['CHEVERETO_DB_TABLE_ROOT_PREFIX'],
'%table_engine%' => $fulltext_engine,
]);
$sql_update = preg_replace('/[ \t]+/', ' ', preg_replace('/\s*$^\s*/m', "\n", $sql_update));
$isDumpUpdate = Settings::get('dump_update_query');
if (($params['dump'] ?? null) === true) {
$isDumpUpdate = true;
}
if (! $isDumpUpdate && PHP_SAPI !== 'cli') {
$totalDb = DB::get('stats', [
'type' => 'total',
])[0] ?? null;
$totalImages = (int) ($totalDb['stat_images'] ?? 0);
$stopWordsRegex = '/add|alter|modify|change/i';
$slowUpdate = preg_match_all($stopWordsRegex, $sql_update);
if ($slowUpdate && $totalImages >= 1000000) {
$sql_update = '# To protect your DB is mandatory to run this MySQL script directly in your database console.'
. "\n" . '# Database:' . env()['CHEVERETO_DB_NAME'] . "\n" . $sql_update;
$isDumpUpdate = true;
}
}
if ($isDumpUpdate) {
$dumpMessage = '# Dumped update query (to manually run in the database console)'
. "\n\n"
. $sql_update;
debug($dumpMessage . "\n");
xr($dumpMessage);
exit();
}
$updateMessageWrap = PHP_SAPI === 'cli'
? <<>> %error%'
: getPreCodeHtml('>>> %error%');
$db = DB::getInstance();
$db->query($sql_update);
$updated = false;
try {
logger("[STATUS] Updating Chevereto database (this may take a while)...\n");
logger("[SQL]\n{$sql_update}\n");
$updated = $db->exec();
$versionDatabase = $db::get(
table: 'variables',
where: [
'name' => 'chevereto_version_installed',
],
limit: 1,
)['variable_value'] ?? '';
if ($versionDatabase !== APP_VERSION) {
throw new LogicException();
}
} catch (Throwable $e) {
throw new LogicException(
(string) message(
<<getMessage()
)
);
}
if ($updated) {
new Settings(reCache: true);
new Variable(reCache: true);
$itWasUpdated = true;
}
$doing = 'updated';
} else {
try {
$db = DB::getInstance();
} catch (Exception $e) {
$error = true;
$error_message = sprintf($db_conn_error, $e->getMessage());
}
$doing = $error ? 'connect' : 'ready';
if ($installed_version !== null) {
$itWasUpdated = false;
$doing = 'already';
}
}
}
$input_errors = [];
if ($installed_version === '' && ! empty($params)) {
if (isset($params['username'])
&& ! in_array($doing, ['already', 'update'], true)
) {
$doing = 'ready';
}
switch ($doing) {
case 'connect':
$db_details = [];
foreach ($db_array as $k => $v) {
if ($v && $params[$k] === '') {
$error = true;
break;
}
$db_details[ltrim($k, 'db_')] = $params[$k] ?? null;
}
if ($error) {
$error_message = 'Please fill the database details.';
} else {
$db_details['driver'] = 'mysql';
try {
$db_details['port'] = (int) ($db_details['port'] ?? 3306);
$db_details['pdoAttrs'] = [];
$db = new DB(...$db_details);
} catch (Exception $e) {
$error = true;
$error_message = sprintf($db_conn_error, $e->getMessage());
}
if (! $error) {
$env = [];
$env['%encryptionKey%'] = randomKey()->base64();
foreach ($db_details as $k => $v) {
$env["%{$k}%"] = $v;
}
$dotenvTemplate = << '%host%',
'CHEVERETO_DB_NAME' => '%name%',
'CHEVERETO_DB_PASS' => '%pass%',
'CHEVERETO_DB_PORT' => '%port%',
'CHEVERETO_DB_USER' => '%user%',
'CHEVERETO_DB_TABLE_PREFIX' => '%tablePrefix%',
'CHEVERETO_ENCRYPTION_KEY' => '%encryptionKey%',
];
EOT;
$envDotPhpContents = strtr($dotenvTemplate, $env);
try {
$envDotPhp = filePhpForPath(PATH_APP . 'env.php');
$envDotPhp->file()->removeIfExists();
$envDotPhp->file()->create();
$envDotPhp->file()->put($envDotPhpContents);
$doing = 'ready';
} catch (Throwable) {
$doing = 'env';
}
}
if ($doing === 'ready') {
redirect('install', 302);
}
}
break;
case 'ready':
if (! filter_var($params['email'], FILTER_VALIDATE_EMAIL)) {
$input_errors['email'] = _s('Invalid email');
}
if (! User::isValidUsername($params['username'])) {
$input_errors['username'] = _s('Invalid username');
}
if (! preg_match('/' . Settings::USER_PASSWORD_PATTERN . '/', $params['password'] ?? '')) {
$input_errors['password'] = _s('Invalid password');
}
if (count($input_errors) > 0) {
$error = true;
$error_message = 'Please correct your data to continue.';
} else {
$create_table = [];
foreach (new DirectoryIterator(PATH_APP . 'schemas/' . $dbSchemaVer) as $fileInfo) {
if ($fileInfo->isDot()
|| $fileInfo->isDir()
) {
continue;
}
$create_table[$fileInfo->getBasename('.sql')] = realpath($fileInfo->getPathname());
}
$install_sql =
<<getOffset();
$offsetHours = round(abs($offset) / 3600);
$offsetMinutes = round((abs($offset) - $offsetHours * 3600) / 60);
$offset = ($offset < 0 ? '-' : '+')
. (strlen((string) $offsetHours) < 2 ? '0' : '')
. $offsetHours
. ':'
. (strlen((string) $offsetMinutes) < 2 ? '0' : '')
. $offsetMinutes;
$install_sql .=
<< $table_tags,
'tags_files' => $table_tags_files,
]);
foreach ($create_table as $k => $v) {
$install_sql .= strtr(file_get_contents($v), [
'%rootPath%' => PATH_PUBLIC,
'%table_prefix%' => $table_prefix,
'%table_root_prefix%' => env()['CHEVERETO_DB_TABLE_ROOT_PREFIX'],
'%table_engine%' => $fulltext_engine,
]) . "\n\n";
}
$id_padding = $is_2X ? 0 : 999;
$install_sql .= strtr($query_populate_stats, [
'%rootPath%' => PATH_PUBLIC,
'%table_prefix%' => $table_prefix,
'%table_root_prefix%' => env()['CHEVERETO_DB_TABLE_ROOT_PREFIX'],
'%table_engine%' => $fulltext_engine,
]);
//$params['dump'] = true;
if (($params['dump'] ?? false) === true) {
debug($install_sql);
logger("\n");
exit(0);
}
$crypt_salt = $params['crypt_salt'] ?? randomString(8);
$db = DB::getInstance();
$db->query($install_sql);
$db->exec();
$db->closeCursor();
$initial_variables['id_padding'] = $id_padding;
$initial_variables['crypt_salt'] = $crypt_salt;
foreach ($initial_variables as $k => $v) {
Variable::set($k, $v);
}
Settings::insert($initial_settings);
$insert_admin = User::insert([
'username' => $params['username'],
'email' => $params['email'],
'is_admin' => 1,
'language' => $initial_settings['default_language'],
'timezone' => $initial_settings['default_timezone'],
]);
Login::addPassword($insert_admin, $params['password']);
$doing = 'finished';
}
break;
}
}
if (PHP_SAPI === 'cli') {
if ($error === true) {
$error_message ??= 'An error occurred.';
throw new LogicException(
(string) message(
"{$error_message}: %errors%",
errors: implode("\n", $input_errors)
)
);
}
switch ($doing) {
case 'already':
logger(
($itWasUpdated ?? false)
? "[NOTICE] Chevereto is already installed\n"
: "[NOTICE] Chevereto is already updated\n"
);
break;
case 'finished':
logger("[OK] Chevereto has been installed\n");
break;
case 'updated':
logger(
($itWasUpdated ?? false)
? "[OK] Chevereto database has been updated\n"
: "[NOTICE] Chevereto is already updated\n"
);
break;
case 'update_failed':
logger("[ERROR] Chevereto database update failure\n");
exit(255);
}
} else {
$doctitle = $doctitles[$doing] . ' - Chevereto ' . get_chevereto_version(true);
$system_template = PATH_PUBLIC_CONTENT_LEGACY_SYSTEM . 'template.php';
$install_template = PATH_APP_LEGACY_INSTALL . 'template/' . $doing . '.php';
ob_start();
require_once $install_template;
$html = ob_get_contents();
ob_end_clean();
require_once $system_template;
}
exit(0);