prefix . "lockerpad_vaults"; $exists = $wpdb->get_var( $wpdb->prepare("SHOW TABLES LIKE %s", $wpdb->esc_like($vaults)), ) === $vaults; if (!$exists) { return; } $legacy = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM %i WHERE purpose<>'page'", $vaults, ), ); if ( $wpdb->last_error || $legacy || get_option("lockerpad_paid_connection") ) { return; } $retired = $wpdb->get_var( "SELECT COUNT(*) FROM {$wpdb->postmeta} WHERE meta_key='_lockerpad_retired'", ); if ($wpdb->last_error || $retired) { return; } require_once __DIR__ . "/includes/class-crypto.php"; if (!class_exists("LockerPad\\Plugin", false)) { require_once __DIR__ . "/includes/class-plugin.php"; } try { $crypto = LockerPad\Plugin::crypto(); // Unreferenced legacy files or backups must also remain recoverable. $dir = $crypto->directory(); foreach (scandir($dir) ?: [] as $entry) { if ( !in_array( $entry, [".", "..", "master.key", ".write.lock"], true, ) ) { return; } } $rows = $wpdb->get_results( "SELECT post_id,meta_value FROM {$wpdb->postmeta} WHERE meta_key='_lockerpad_previous_password'", ); if ($wpdb->last_error) { return; } $passwords = []; foreach ($rows as $row) { $passwords[(int) $row->post_id] = $crypto->decrypt( $row->meta_value, "page-password:" . $row->post_id, ); } // Prepare all previous passwords before changing anything. Missing keys // must not turn a previously protected page into a public page. foreach ($passwords as $id => $password) { if ( $wpdb->update( $wpdb->posts, ["post_password" => $password], ["ID" => $id], ) === false ) { return; } delete_post_meta($id, "_lockerpad_vault"); delete_post_meta($id, "_lockerpad_previous_password"); clean_post_cache($id); } foreach ( [ "vaults", "clients", "sessions", "rates", "access", "events", "media", ] as $table ) { $wpdb->query( $wpdb->prepare( "DROP TABLE IF EXISTS %i", $wpdb->prefix . "lockerpad_" . $table, ), ); } $names = $wpdb->get_col( $wpdb->prepare( "SELECT option_name FROM %i WHERE option_name LIKE %s", $wpdb->options, $wpdb->esc_like("lockerpad_") . "%", ), ); foreach ($names as $name) { delete_option($name); } wp_clear_scheduled_hook("lockerpad_cleanup"); // Delete only our two known files. Never recursively remove a folder. if ( basename($crypto->key_path()) === "master.key" && dirname($crypto->key_path()) === $dir ) { wp_delete_file($crypto->key_path()); } wp_delete_file($dir . "/.write.lock"); // Atomic, nonrecursive removal: fail safely if another file appeared since the check. // phpcs:ignore WordPress.WP.AlternativeFunctions.file_system_operations_rmdir @rmdir($dir); wp_cache_flush(); if (function_exists("sg_cachepress_purge_cache")) { sg_cachepress_purge_cache(); } } catch (\Throwable $error) { // Retain data and keys rather than risking irreversible loss on Delete. return; } } lockerpad_uninstall_pages();