| @@ -1,6 +1,5 @@ | ||
| 1 | 1 | <?php |
| 2 | - | |
| 3 | 2 | /** |
| 4 | 3 | * Functions to perform snippet operations |
| 5 | 4 | * |
| 6 | 5 | * @package Code_Snippets |
| @@ -5,171 +4,448 @@ | ||
| 5 | 4 | * |
| 6 | 5 | * @package Code_Snippets |
| 7 | 6 | */ |
| 8 | 7 | |
| 8 | +namespace Code_Snippets; | |
| 9 | + | |
| 10 | +use Exception; | |
| 11 | +use Code_Snippets\Model\Snippet; | |
| 12 | +use Code_Snippets\Utils\Validator; | |
| 13 | +use Throwable; | |
| 14 | +use function Code_Snippets\Utils\get_self_option; | |
| 15 | +use function Code_Snippets\Utils\validate_network_param; | |
| 16 | +use function Code_Snippets\Utils\update_self_option; | |
| 17 | + | |
| 9 | 18 | /** |
| 10 | - * Retrieve a list of snippets from the database | |
| 19 | + * Get the locked status for a snippet from wp_options. | |
| 11 | 20 | * |
| 12 | - * @since 2.0 | |
| 21 | + * @param int $snippet_id Snippet ID. | |
| 22 | + * @param bool|null $network Whether the snippet is network-wide (true) or site-wide (false). | |
| 13 | 23 | * |
| 14 | - * @uses $wpdb to query the database for snippets | |
| 15 | - * @uses code_snippets()->db->get_table_name() to dynamically retrieve the snippet table name | |
| 24 | + * @return bool Whether the snippet is locked. | |
| 25 | + */ | |
| 26 | +function is_snippet_locked( int $snippet_id, ?bool $network = null ): bool { | |
| 27 | + $network = validate_network_param( $network ); | |
| 28 | + $locked_snippets = get_self_option( $network, 'code_snippets_locked', [] ); | |
| 29 | + | |
| 30 | + return isset( $locked_snippets[ $snippet_id ] ) && $locked_snippets[ $snippet_id ]; | |
| 31 | +} | |
| 32 | + | |
| 33 | +/** | |
| 34 | + * Set the locked status for a snippet in wp_options. | |
| 16 | 35 | * |
| 17 | - * @param array $ids The IDs of the snippets to fetch | |
| 18 | - * @param bool|null $multisite Retrieve multisite-wide or site-wide snippets? | |
| 36 | + * @param int $snippet_id Snippet ID. | |
| 37 | + * @param bool $locked Whether the snippet should be locked. | |
| 38 | + * @param bool|null $network Whether the snippet is network-wide (true) or site-wide (false). | |
| 19 | 39 | * |
| 20 | - * @return array An array of Snippet objects | |
| 40 | + * @return void | |
| 21 | 41 | */ |
| 22 | -function get_snippets( array $ids = array(), $multisite = null ) { | |
| 23 | - /** @var wpdb $wpdb */ | |
| 24 | - global $wpdb; | |
| 42 | +function set_snippet_locked( int $snippet_id, bool $locked, ?bool $network = null ): void { | |
| 43 | + $network = validate_network_param( $network ); | |
| 44 | + $locked_snippets = get_self_option( $network, 'code_snippets_locked', [] ); | |
| 25 | 45 | |
| 26 | - $db = code_snippets()->db; | |
| 27 | - $multisite = $db->validate_network_param( $multisite ); | |
| 28 | - $table = $db->get_table_name( $multisite ); | |
| 46 | + if ( $locked ) { | |
| 47 | + $locked_snippets[ $snippet_id ] = true; | |
| 48 | + } else { | |
| 49 | + unset( $locked_snippets[ $snippet_id ] ); | |
| 50 | + } | |
| 29 | 51 | |
| 30 | - $ids_count = count( $ids ); | |
| 52 | + update_self_option( $network, 'code_snippets_locked', $locked_snippets ); | |
| 53 | +} | |
| 31 | 54 | |
| 32 | - /* If only one ID has been passed in, defer to the get_snippet() function */ | |
| 33 | - if ( 1 == $ids_count ) { | |
| 34 | - return array( get_snippet( $ids[0] ) ); | |
| 55 | +/** | |
| 56 | + * Clean the cache where active snippets are stored. | |
| 57 | + * | |
| 58 | + * @param string $table_name Snippets table name. | |
| 59 | + * @param array<string>|false $scopes List of scopes. Optional. If not provided, will flush the cache for all scopes. | |
| 60 | + * | |
| 61 | + * @return void | |
| 62 | + */ | |
| 63 | +function clean_active_snippets_cache( string $table_name, $scopes = false ) { | |
| 64 | + $scope_groups = $scopes | |
| 65 | + ? [ $scopes ] | |
| 66 | + : [ | |
| 67 | + // Content snippets. | |
| 68 | + [ 'head-content', 'body-content', 'footer-content' ], | |
| 69 | + | |
| 70 | + // Function snippets. | |
| 71 | + [ 'global', 'single-use', 'front-end' ], | |
| 72 | + [ 'global', 'single-use', 'admin' ], | |
| 73 | + ]; | |
| 74 | + | |
| 75 | + foreach ( $scope_groups as $scopes ) { | |
| 76 | + wp_cache_delete( sprintf( 'active_snippets_%s_%s', sanitize_key( join( '_', $scopes ) ), $table_name ), CACHE_GROUP ); | |
| 35 | 77 | } |
| 78 | +} | |
| 36 | 79 | |
| 37 | - /* Build a query containing the specified IDs if there are any */ | |
| 38 | - if ( $ids_count > 1 ) { | |
| 39 | - $sql = sprintf( | |
| 40 | - 'SELECT * FROM %s WHERE id IN (%s);', | |
| 41 | - $table, | |
| 42 | - implode( ',', array_fill( 0, $ids_count, '%d' ) ) | |
| 43 | - ); | |
| 44 | - $sql = $wpdb->prepare( $sql, $ids ); | |
| 80 | +/** | |
| 81 | + * Flush all snippets caches for a given database table. | |
| 82 | + * | |
| 83 | + * @param string $table_name Snippets table name. | |
| 84 | + * | |
| 85 | + * @return void | |
| 86 | + */ | |
| 87 | +function clean_snippets_cache( string $table_name ) { | |
| 88 | + wp_cache_delete( "all_snippet_tags_$table_name", CACHE_GROUP ); | |
| 89 | + wp_cache_delete( "all_snippets_$table_name", CACHE_GROUP ); | |
| 90 | + clean_active_snippets_cache( $table_name ); | |
| 91 | +} | |
| 45 | 92 | |
| 46 | - } else { | |
| 47 | - $sql = "SELECT * FROM $table;"; | |
| 93 | +/** | |
| 94 | + * Flush an entire cache group, where the object cache supports it. | |
| 95 | + * | |
| 96 | + * Not all persistent cache drop-ins implement group flushing, and the function | |
| 97 | + * itself only exists from WordPress 6.1, so both are checked before use. A | |
| 98 | + * failure is not important: cache groups are scoped to the plugin version, so | |
| 99 | + * flushing is housekeeping rather than something correctness depends on, and | |
| 100 | + * anything left behind is evicted by the cache in its own time. | |
| 101 | + * | |
| 102 | + * @param string $group Cache group to flush. | |
| 103 | + * | |
| 104 | + * @return bool Whether the group was flushed. | |
| 105 | + */ | |
| 106 | +function flush_cache_group( string $group ): bool { | |
| 107 | + /** | |
| 108 | + * Short-circuits flushing a cache group. | |
| 109 | + * | |
| 110 | + * Returning a boolean skips the object cache entirely: false makes the | |
| 111 | + * caller fall back to deleting the known keys one by one, for a cache | |
| 112 | + * that reports group support it does not really have. | |
| 113 | + * | |
| 114 | + * @param bool|null $flushed Whether the group was flushed, or null to let the cache try. | |
| 115 | + * @param string $group Cache group. | |
| 116 | + */ | |
| 117 | + $flushed = apply_filters( 'code_snippets/pre_flush_cache_group', null, $group ); | |
| 118 | + | |
| 119 | + if ( null !== $flushed ) { | |
| 120 | + return (bool) $flushed; | |
| 48 | 121 | } |
| 49 | 122 | |
| 50 | - /* Retrieve the results from the database */ | |
| 51 | - $snippets = $wpdb->get_results( $sql, ARRAY_A ); | |
| 123 | + if ( ! function_exists( 'wp_cache_flush_group' ) || | |
| 124 | + ! function_exists( 'wp_cache_supports' ) || | |
| 125 | + ! wp_cache_supports( 'flush_group' ) ) { | |
| 126 | + return false; | |
| 127 | + } | |
| 52 | 128 | |
| 53 | - /* Convert snippets to snippet objects */ | |
| 54 | - foreach ( $snippets as $index => $snippet ) { | |
| 55 | - $snippet['network'] = $multisite; | |
| 56 | - $snippets[ $index ] = new Code_Snippet( $snippet ); | |
| 129 | + return wp_cache_flush_group( $group ); | |
| 130 | +} | |
| 131 | + | |
| 132 | +/** | |
| 133 | + * Flush the cache groups belonging to other versions of the plugin. | |
| 134 | + * | |
| 135 | + * @param string $previous_version Version the site was running beforehand. | |
| 136 | + * | |
| 137 | + * @return void | |
| 138 | + */ | |
| 139 | +function flush_versioned_cache_groups( string $previous_version ): void { | |
| 140 | + if ( '' !== $previous_version && PLUGIN_VERSION !== $previous_version ) { | |
| 141 | + flush_cache_group( CACHE_GROUP_BASE . '_' . $previous_version ); | |
| 57 | 142 | } |
| 58 | 143 | |
| 59 | - return apply_filters( 'code_snippets/get_snippets', $snippets, $multisite ); | |
| 144 | + // Versions before the group was scoped wrote to the unscoped group, and no | |
| 145 | + // version that scopes it ever writes there again. Clearing it means a site | |
| 146 | + // upgrading from 3.10.0 or 3.10.1 sheds the objects that would otherwise | |
| 147 | + // still be waiting to break its next rollback. | |
| 148 | + flush_cache_group( CACHE_GROUP_BASE ); | |
| 149 | + | |
| 150 | + // Where the cache cannot flush a whole group, the keys this plugin writes | |
| 151 | + // are deleted one by one instead, so an uninstall followed by a reinstall | |
| 152 | + // of the same version cannot read snippets that no longer exist. | |
| 153 | + if ( ! flush_cache_group( CACHE_GROUP ) ) { | |
| 154 | + flush_known_cache_keys(); | |
| 155 | + } | |
| 60 | 156 | } |
| 61 | 157 | |
| 62 | 158 | /** |
| 63 | - * Gets all of the used tags from the database | |
| 159 | + * Delete every key this plugin is known to write in its current cache group. | |
| 160 | + * | |
| 161 | + * @return void | |
| 162 | + */ | |
| 163 | +function flush_known_cache_keys(): void { | |
| 164 | + // Both tables' keys go, whether this is a network: deleting a key | |
| 165 | + // that was never written does not cost anything, and it keeps one path to test. | |
| 166 | + $tables = [ code_snippets()->db->get_table_name( false ), code_snippets()->db->get_table_name( true ) ]; | |
| 167 | + | |
| 168 | + foreach ( array_unique( $tables ) as $table ) { | |
| 169 | + clean_snippets_cache( $table ); | |
| 170 | + } | |
| 171 | + | |
| 172 | + wp_cache_delete( Settings\CACHE_KEY, CACHE_GROUP ); | |
| 173 | +} | |
| 174 | + | |
| 175 | +/** | |
| 176 | + * Retrieve a list of snippets from the database. | |
| 177 | + * Read operation. | |
| 178 | + * | |
| 179 | + * @param array<string> $ids The IDs of the snippets to fetch. | |
| 180 | + * @param bool|null $network Retrieve multisite-wide snippets (true) or site-wide snippets (false). | |
| 181 | + * | |
| 182 | + * @return Snippet[] List of Snippet objects. | |
| 183 | + * | |
| 64 | 184 | * @since 2.0 |
| 65 | 185 | */ |
| 186 | +function get_snippets( array $ids = [], ?bool $network = null ): array { | |
| 187 | + global $wpdb; | |
| 188 | + | |
| 189 | + // If only one ID has been passed in, defer to the get_snippet() function. | |
| 190 | + $ids_count = count( $ids ); | |
| 191 | + if ( 1 === $ids_count ) { | |
| 192 | + return [ get_snippet( $ids[0], $network ) ]; | |
| 193 | + } | |
| 194 | + | |
| 195 | + $network = validate_network_param( $network ); | |
| 196 | + $table_name = code_snippets()->db->get_table_name( $network ); | |
| 197 | + | |
| 198 | + $snippets = wp_cache_get( "all_snippets_$table_name", CACHE_GROUP ); | |
| 199 | + | |
| 200 | + // Fetch all snippets from the database if none are cached. | |
| 201 | + if ( ! is_array( $snippets ) ) { | |
| 202 | + $results = $wpdb->get_results( "SELECT * FROM $table_name", ARRAY_A ); | |
| 203 | + | |
| 204 | + $snippets = $results | |
| 205 | + ? array_map( | |
| 206 | + function ( $snippet_data ) use ( $network ) { | |
| 207 | + $snippet_data['network'] = $network; | |
| 208 | + $snippet = new Snippet( $snippet_data ); | |
| 209 | + // Load locked from wp_options. | |
| 210 | + if ( $snippet->id > 0 ) { | |
| 211 | + $snippet->locked = is_snippet_locked( $snippet->id, $network ); | |
| 212 | + } | |
| 213 | + return $snippet; | |
| 214 | + }, | |
| 215 | + $results | |
| 216 | + ) | |
| 217 | + : []; | |
| 218 | + | |
| 219 | + $snippets = apply_filters( 'code_snippets/get_snippets', $snippets, $network ); | |
| 220 | + | |
| 221 | + if ( 0 === $ids_count ) { | |
| 222 | + wp_cache_set( "all_snippets_$table_name", $snippets, CACHE_GROUP ); | |
| 223 | + } | |
| 224 | + } | |
| 225 | + | |
| 226 | + // If a list of IDs are provided, narrow down the snippets list. | |
| 227 | + if ( $ids_count > 0 ) { | |
| 228 | + $ids = array_map( 'intval', $ids ); | |
| 229 | + return array_values( | |
| 230 | + array_filter( | |
| 231 | + $snippets, | |
| 232 | + function ( Snippet $snippet ) use ( $ids ) { | |
| 233 | + return in_array( $snippet->id, $ids, true ); | |
| 234 | + } | |
| 235 | + ) | |
| 236 | + ); | |
| 237 | + } | |
| 238 | + | |
| 239 | + return $snippets; | |
| 240 | +} | |
| 241 | + | |
| 242 | +/** | |
| 243 | + * Gets all used tags from the database. | |
| 244 | + * Read operation. | |
| 245 | + * | |
| 246 | + * @since 2.0 | |
| 247 | + */ | |
| 66 | 248 | function get_all_snippet_tags() { |
| 67 | - /** @var wpdb $wpdb */ | |
| 68 | 249 | global $wpdb; |
| 250 | + $table_name = code_snippets()->db->get_table_name(); | |
| 251 | + $cache_key = "all_snippet_tags_$table_name"; | |
| 69 | 252 | |
| 70 | - /* Grab all tags from the database */ | |
| 253 | + $tags = wp_cache_get( $cache_key, CACHE_GROUP ); | |
| 254 | + if ( $tags ) { | |
| 255 | + return $tags; | |
| 256 | + } | |
| 257 | + | |
| 258 | + // Grab all tags from the database. | |
| 71 | 259 | $tags = array(); |
| 72 | - $table = code_snippets()->db->get_table_name(); | |
| 73 | - $all_tags = $wpdb->get_col( "SELECT `tags` FROM $table" ); | |
| 260 | + $all_tags = $wpdb->get_col( "SELECT tags FROM $table_name" ); | |
| 74 | 261 | |
| 75 | - /* Merge all tags into a single array */ | |
| 262 | + // Merge all tags into a single array. | |
| 76 | 263 | foreach ( $all_tags as $snippet_tags ) { |
| 77 | 264 | $snippet_tags = code_snippets_build_tags_array( $snippet_tags ); |
| 78 | 265 | $tags = array_merge( $snippet_tags, $tags ); |
| 79 | 266 | } |
| 80 | 267 | |
| 81 | - /* Remove duplicate tags */ | |
| 82 | - | |
| 83 | - return array_values( array_unique( $tags, SORT_REGULAR ) ); | |
| 268 | + // Remove duplicate tags. | |
| 269 | + $tags = array_values( array_unique( $tags, SORT_REGULAR ) ); | |
| 270 | + wp_cache_set( $cache_key, $tags, CACHE_GROUP ); | |
| 271 | + return $tags; | |
| 84 | 272 | } |
| 85 | 273 | |
| 86 | 274 | /** |
| 87 | - * Make sure that the tags are a valid array | |
| 88 | - * @since 2.0 | |
| 275 | + * Make sure that the tags are a valid array. | |
| 89 | 276 | * |
| 90 | - * @param mixed $tags The tags to convert into an array | |
| 277 | + * @param array|string $tags The tags to convert into an array. | |
| 91 | 278 | * |
| 92 | - * @return array The converted tags | |
| 279 | + * @return array<string> The converted tags. | |
| 280 | + * | |
| 281 | + * @since 2.0.0 | |
| 93 | 282 | */ |
| 94 | -function code_snippets_build_tags_array( $tags ) { | |
| 283 | +function code_snippets_build_tags_array( $tags ): array { | |
| 95 | 284 | |
| 96 | - /* If there are no tags set, return an empty array */ | |
| 285 | + /* If there are no tags set, return an empty array. */ | |
| 97 | 286 | if ( empty( $tags ) ) { |
| 98 | 287 | return array(); |
| 99 | 288 | } |
| 100 | 289 | |
| 101 | - /* If the tags are set as a string, convert them into an array */ | |
| 290 | + /* If the tags are set as a string, convert them into an array. */ | |
| 102 | 291 | if ( is_string( $tags ) ) { |
| 103 | - $tags = strip_tags( $tags ); | |
| 292 | + $tags = wp_strip_all_tags( $tags ); | |
| 104 | 293 | $tags = str_replace( ', ', ',', $tags ); |
| 105 | 294 | $tags = explode( ',', $tags ); |
| 106 | 295 | } |
| 107 | 296 | |
| 108 | - /* If we still don't have an array, just convert whatever we do have into one */ | |
| 109 | - | |
| 297 | + /* If we still don't have an array, just convert whatever we do have into one. */ | |
| 110 | 298 | return (array) $tags; |
| 111 | 299 | } |
| 112 | 300 | |
| 113 | 301 | /** |
| 114 | 302 | * Retrieve a single snippets from the database. |
| 115 | - * Will return empty snippet object if no snippet | |
| 116 | - * ID is specified | |
| 303 | + * Will return empty snippet object if no snippet ID is specified. | |
| 304 | + * Read operation. | |
| 117 | 305 | * |
| 118 | - * @since 2.0 | |
| 306 | + * @param int $id The ID of the snippet to retrieve. 0 to build a new snippet. | |
| 307 | + * @param bool|null $network Retrieve a multisite-wide snippet (true) or site-wide snippet (false). | |
| 119 | 308 | * |
| 120 | - * @uses $wpdb to query the database for snippets | |
| 121 | - * @uses code_snippets()->db->get_table_name() to dynamically retrieve the snippet table name | |
| 309 | + * @return ?Snippet A single snippet object. | |
| 122 | 310 | * |
| 123 | - * @param int $id The ID of the snippet to retrieve. 0 to build a new snippet | |
| 124 | - * @param boolean|null $multisite Retrieve a multisite-wide or site-wide snippet? | |
| 125 | - * | |
| 126 | - * @return Code_Snippet A single snippet object | |
| 311 | + * @since 2.0.0 | |
| 127 | 312 | */ |
| 128 | -function get_snippet( $id = 0, $multisite = null ) { | |
| 129 | - /** @var wpdb $wpdb */ | |
| 313 | +function get_snippet( int $id = 0, ?bool $network = null ): ?Snippet { | |
| 130 | 314 | global $wpdb; |
| 131 | 315 | |
| 132 | 316 | $id = absint( $id ); |
| 133 | - $table = code_snippets()->db->get_table_name( $multisite ); | |
| 317 | + $network = validate_network_param( $network ); | |
| 318 | + $table_name = code_snippets()->db->get_table_name( $network ); | |
| 134 | 319 | |
| 135 | - if ( 0 !== $id ) { | |
| 320 | + if ( 0 === $id ) { | |
| 321 | + // If an invalid ID is provided, then return an empty snippet object. | |
| 322 | + $snippet = new Snippet(); | |
| 136 | 323 | |
| 137 | - /* Retrieve the snippet from the database */ | |
| 138 | - $snippet = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $table WHERE id = %d", $id ) ); | |
| 324 | + } else { | |
| 325 | + $cached_snippets = wp_cache_get( "all_snippets_$table_name", CACHE_GROUP ); | |
| 139 | 326 | |
| 140 | - /* Unescape the snippet data, ready for use */ | |
| 141 | - $snippet = new Code_Snippet( $snippet ); | |
| 327 | + // Attempt to fetch snippet from the cached list, if it exists. | |
| 328 | + if ( is_array( $cached_snippets ) ) { | |
| 329 | + foreach ( $cached_snippets as $snippet ) { | |
| 330 | + if ( $snippet->id === $id ) { | |
| 331 | + return apply_filters( 'code_snippets/get_snippet', $snippet, $id, $network ); | |
| 332 | + } | |
| 333 | + } | |
| 334 | + } | |
| 142 | 335 | |
| 143 | - } else { | |
| 336 | + // Otherwise, retrieve the snippet from the database. | |
| 337 | + // phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching | |
| 338 | + $snippet_data = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $table_name WHERE id = %d", $id ) ); | |
| 339 | + $snippet = new Snippet( $snippet_data ); | |
| 340 | + } | |
| 144 | 341 | |
| 145 | - /* Get an empty snippet object */ | |
| 146 | - $snippet = new Code_Snippet(); | |
| 342 | + $snippet->network = $network; | |
| 343 | + | |
| 344 | + // Load locked from wp_options if snippet has an ID. | |
| 345 | + if ( $snippet->id > 0 ) { | |
| 346 | + $snippet->locked = is_snippet_locked( $snippet->id, $network ); | |
| 147 | 347 | } |
| 148 | 348 | |
| 149 | - $snippet->network = $multisite; | |
| 349 | + return apply_filters( 'code_snippets/get_snippet', $snippet, $id, $network ); | |
| 350 | +} | |
| 150 | 351 | |
| 151 | - return apply_filters( 'code_snippets/get_snippet', $snippet, $id, $multisite ); | |
| 352 | + | |
| 353 | +/** | |
| 354 | + * Ensure the list of shared network snippets is correct if one has been recently active or deactivated. | |
| 355 | + * Write operation. | |
| 356 | + * | |
| 357 | + * @access private | |
| 358 | + * | |
| 359 | + * @param Snippet[] $snippets Snippets that was recently updated. | |
| 360 | + * | |
| 361 | + * @return bool Whether an update was performed. | |
| 362 | + */ | |
| 363 | +function update_shared_network_snippets( array $snippets ): bool { | |
| 364 | + $shared_ids = []; | |
| 365 | + $unshared_ids = []; | |
| 366 | + | |
| 367 | + if ( ! is_multisite() ) { | |
| 368 | + return false; | |
| 369 | + } | |
| 370 | + | |
| 371 | + foreach ( $snippets as $snippet ) { | |
| 372 | + if ( $snippet->network ) { | |
| 373 | + if ( $snippet->shared_network ) { | |
| 374 | + $shared_ids[] = $snippet->id; | |
| 375 | + } else { | |
| 376 | + $unshared_ids[] = $snippet->id; | |
| 377 | + } | |
| 378 | + } | |
| 379 | + } | |
| 380 | + | |
| 381 | + if ( ! $shared_ids && ! $unshared_ids ) { | |
| 382 | + return false; | |
| 383 | + } | |
| 384 | + | |
| 385 | + $existing_shared_ids = get_site_option( 'shared_network_snippets', [] ); | |
| 386 | + $updated_shared_ids = array_values( array_diff( array_merge( $existing_shared_ids, $shared_ids ), $unshared_ids ) ); | |
| 387 | + | |
| 388 | + if ( $existing_shared_ids === $updated_shared_ids ) { | |
| 389 | + return false; | |
| 390 | + } | |
| 391 | + | |
| 392 | + update_site_option( 'shared_network_snippets', $updated_shared_ids ); | |
| 393 | + | |
| 394 | + // Deactivate the snippet on all sites if necessary. | |
| 395 | + if ( $unshared_ids ) { | |
| 396 | + $sites = get_sites( [ 'fields' => 'ids' ] ); | |
| 397 | + | |
| 398 | + foreach ( $sites as $site ) { | |
| 399 | + switch_to_blog( $site ); | |
| 400 | + $active_shared_ids = get_option( 'active_shared_network_snippets' ); | |
| 401 | + | |
| 402 | + if ( is_array( $active_shared_ids ) ) { | |
| 403 | + $active_shared_ids = array_diff( $active_shared_ids, $unshared_ids ); | |
| 404 | + update_option( 'active_shared_network_snippets', $active_shared_ids ); | |
| 405 | + } | |
| 406 | + | |
| 407 | + clean_active_snippets_cache( code_snippets()->db->ms_table ); | |
| 408 | + } | |
| 409 | + | |
| 410 | + restore_current_blog(); | |
| 411 | + } | |
| 412 | + | |
| 413 | + return true; | |
| 152 | 414 | } |
| 153 | 415 | |
| 154 | 416 | /** |
| 155 | - * Activates a snippet | |
| 417 | + * Activates a snippet. | |
| 418 | + * Write operation. | |
| 156 | 419 | * |
| 157 | - * @since 2.0 | |
| 420 | + * @param int $id ID of the snippet to activate. | |
| 421 | + * @param bool|null $network Whether the snippets are multisite-wide (true) or site-wide (false). | |
| 158 | 422 | * |
| 159 | - * @uses $wpdb to set the snippet's active status | |
| 160 | - * | |
| 161 | - * @param int $id The ID of the snippet to activate | |
| 162 | - * @param bool|null $multisite Are the snippets multisite-wide or site-wide? | |
| 423 | + * @return Snippet|string Snippet object on success, error message on failure. | |
| 424 | + * @since 2.0.0 | |
| 163 | 425 | */ |
| 164 | -function activate_snippet( $id, $multisite = null ) { | |
| 165 | - /** @var wpdb $wpdb */ | |
| 426 | +function activate_snippet( int $id, ?bool $network = null ) { | |
| 166 | 427 | global $wpdb; |
| 167 | - $db = code_snippets()->db; | |
| 168 | - $table = $db->get_table_name( $multisite ); | |
| 428 | + $network = validate_network_param( $network ); | |
| 429 | + $table_name = code_snippets()->db->get_table_name( $network ); | |
| 169 | 430 | |
| 170 | - $wpdb->update( | |
| 171 | - $table, | |
| 431 | + // Retrieve the snippet code from the database for validation before activating. | |
| 432 | + $snippet = get_snippet( $id, $network ); | |
| 433 | + | |
| 434 | + if ( 0 === $snippet->id ) { | |
| 435 | + // translators: %d: snippet identifier. | |
| 436 | + return sprintf( __( 'Could not locate snippet with ID %d.', 'code-snippets' ), $id ); | |
| 437 | + } | |
| 438 | + | |
| 439 | + if ( 'php' === $snippet->type ) { | |
| 440 | + $validator = new Validator( $snippet->code ); | |
| 441 | + if ( $validator->validate() ) { | |
| 442 | + return __( 'Could not activate snippet: code did not pass validation.', 'code-snippets' ); | |
| 443 | + } | |
| 444 | + } | |
| 445 | + | |
| 446 | + $result = $wpdb->update( | |
| 447 | + $table_name, | |
| 172 | 448 | array( 'active' => '1' ), |
| 173 | 449 | array( 'id' => $id ), |
| 174 | 450 | array( '%d' ), |
| 175 | 451 | array( '%d' ) |
| @@ -174,36 +450,108 @@ | ||
| 174 | 450 | array( '%d' ), |
| 175 | 451 | array( '%d' ) |
| 176 | 452 | ); |
| 177 | 453 | |
| 178 | - /* Remove snippet from shared network snippet list if it was Network Activated */ | |
| 179 | - if ( $table === $db && $shared_network_snippets = get_site_option( 'shared_network_snippets', false ) ) { | |
| 180 | - $shared_network_snippets = array_diff( $shared_network_snippets, array( $id ) ); | |
| 181 | - update_site_option( 'shared_network_snippets', $shared_network_snippets ); | |
| 454 | + if ( ! $result ) { | |
| 455 | + return __( 'Could not activate snippet.', 'code-snippets' ); | |
| 182 | 456 | } |
| 183 | 457 | |
| 184 | - do_action( 'code_snippets/activate_snippet', $id, $multisite ); | |
| 458 | + update_shared_network_snippets( [ $snippet ] ); | |
| 459 | + do_action( 'code_snippets/activate_snippet', $snippet, $network ); | |
| 460 | + clean_snippets_cache( $table_name ); | |
| 461 | + return $snippet; | |
| 185 | 462 | } |
| 186 | 463 | |
| 187 | 464 | /** |
| 188 | - * Deactivate a snippet | |
| 465 | + * Activates multiple snippets. | |
| 466 | + * Write operation. | |
| 189 | 467 | * |
| 190 | - * @since 2.0 | |
| 468 | + * @param array<int> $ids The IDs of the snippets to activate. | |
| 469 | + * @param bool|null $network Whether the snippets are multisite-wide (true) or site-wide (false). | |
| 191 | 470 | * |
| 192 | - * @uses $wpdb to set the snippets' active status | |
| 471 | + * @return Snippet[]|null Snippets which were successfully activated, or null on failure. | |
| 193 | 472 | * |
| 194 | - * @param int $id The ID of the snippet to deactivate | |
| 195 | - * @param bool|null $multisite Are the snippets multisite-wide or site-wide? | |
| 473 | + * @since 2.0.0 | |
| 196 | 474 | */ |
| 197 | -function deactivate_snippet( $id, $multisite = null ) { | |
| 198 | - /** @var wpdb $wpdb */ | |
| 475 | +function activate_snippets( array $ids, ?bool $network = null ): ?array { | |
| 199 | 476 | global $wpdb; |
| 200 | - $db = code_snippets()->db; | |
| 201 | - $table = $db->get_table_name( $multisite ); | |
| 477 | + $network = validate_network_param( $network ); | |
| 478 | + $table_name = code_snippets()->db->get_table_name( $network ); | |
| 202 | 479 | |
| 203 | - /* Set the snippet to active */ | |
| 480 | + $snippets = get_snippets( $ids, $network ); | |
| 204 | 481 | |
| 205 | - $wpdb->update( | |
| 482 | + if ( ! $snippets ) { | |
| 483 | + return null; | |
| 484 | + } | |
| 485 | + | |
| 486 | + // Loop through each snippet code and validate individually. | |
| 487 | + $valid_ids = []; | |
| 488 | + $valid_snippets = []; | |
| 489 | + | |
| 490 | + // Names claimed by snippets already accepted into this batch. A snippet is | |
| 491 | + // otherwise validated only against what PHP has declared so far, which does | |
| 492 | + // not include the other snippets about to be activated alongside it. | |
| 493 | + $claimed_identifiers = []; | |
| 494 | + | |
| 495 | + foreach ( $snippets as $snippet ) { | |
| 496 | + // Only PHP is validated. The validator looks for redeclarations of | |
| 497 | + // existing PHP functions and classes, which says nothing meaningful | |
| 498 | + // about CSS or JavaScript. | |
| 499 | + if ( 'php' !== $snippet->type ) { | |
| 500 | + $valid_ids[] = $snippet->id; | |
| 501 | + $valid_snippets[] = $snippet; | |
| 502 | + continue; | |
| 503 | + } | |
| 504 | + | |
| 505 | + $validator = new Validator( $snippet->code, $claimed_identifiers ); | |
| 506 | + $code_error = $validator->validate(); | |
| 507 | + | |
| 508 | + if ( ! $code_error ) { | |
| 509 | + $claimed_identifiers = $validator->get_claimed_identifiers(); | |
| 510 | + $valid_ids[] = $snippet->id; | |
| 511 | + $valid_snippets[] = $snippet; | |
| 512 | + } | |
| 513 | + } | |
| 514 | + | |
| 515 | + // If there are no valid snippets, then we're done. | |
| 516 | + if ( ! $valid_ids ) { | |
| 517 | + return null; | |
| 518 | + } | |
| 519 | + | |
| 520 | + // Build a SQL query containing all IDs, as wpdb::update does not support OR conditionals. | |
| 521 | + $ids_format = implode( ',', array_fill( 0, count( $valid_ids ), '%d' ) ); | |
| 522 | + | |
| 523 | + // phpcs:disable WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare | |
| 524 | + $rows_updated = $wpdb->query( $wpdb->prepare( "UPDATE $table_name SET active = 1 WHERE id IN ($ids_format)", $valid_ids ) ); | |
| 525 | + | |
| 526 | + if ( ! $rows_updated ) { | |
| 527 | + return null; | |
| 528 | + } | |
| 529 | + | |
| 530 | + update_shared_network_snippets( $valid_snippets ); | |
| 531 | + do_action( 'code_snippets/activate_snippets', $valid_snippets, $table_name ); | |
| 532 | + clean_snippets_cache( $table_name ); | |
| 533 | + return $valid_ids; | |
| 534 | +} | |
| 535 | + | |
| 536 | +/** | |
| 537 | + * Deactivate a snippet. | |
| 538 | + * Write operation. | |
| 539 | + * | |
| 540 | + * @param int $id ID of the snippet to deactivate. | |
| 541 | + * @param bool|null $network Whether the snippets are multisite-wide (true) or site-wide (false). | |
| 542 | + * | |
| 543 | + * @return Snippet|null Snippet that was deactivated on success, or null on failure. | |
| 544 | + * | |
| 545 | + * @since 2.0.0 | |
| 546 | + */ | |
| 547 | +function deactivate_snippet( int $id, ?bool $network = null ): ?Snippet { | |
| 548 | + global $wpdb; | |
| 549 | + $network = validate_network_param( $network ); | |
| 550 | + $table = code_snippets()->db->get_table_name( $network ); | |
| 551 | + | |
| 552 | + // Set the snippet to inactive. | |
| 553 | + $result = $wpdb->update( | |
| 206 | 554 | $table, |
| 207 | 555 | array( 'active' => '0' ), |
| 208 | 556 | array( 'id' => $id ), |
| 209 | 557 | array( '%d' ), |
| @@ -209,248 +557,541 @@ | ||
| 209 | 557 | array( '%d' ), |
| 210 | 558 | array( '%d' ) |
| 211 | 559 | ); |
| 212 | 560 | |
| 213 | - /* Update the recently active list */ | |
| 561 | + if ( ! $result ) { | |
| 562 | + return null; | |
| 563 | + } | |
| 214 | 564 | |
| 215 | - $recently_active = array( $id => time() ); | |
| 565 | + // Update the recently active list. | |
| 566 | + $snippet = get_snippet( $id ); | |
| 567 | + $recently_active = get_self_option( $network, 'recently_active_snippets', [] ); | |
| 568 | + $recently_active[ $id ] = time(); | |
| 569 | + update_self_option( $network, 'recently_active_snippets', $recently_active ); | |
| 216 | 570 | |
| 217 | - if ( $table === $db->table ) { | |
| 571 | + update_shared_network_snippets( [ $snippet ] ); | |
| 572 | + do_action( 'code_snippets/deactivate_snippet', $id, $network ); | |
| 573 | + clean_snippets_cache( $table ); | |
| 218 | 574 | |
| 219 | - update_option( | |
| 220 | - 'recently_activated_snippets', | |
| 221 | - $recently_active + (array) get_option( 'recently_activated_snippets', array() ) | |
| 222 | - ); | |
| 575 | + return $snippet; | |
| 576 | +} | |
| 223 | 577 | |
| 224 | - } elseif ( $table === $db->ms_table ) { | |
| 578 | +/** | |
| 579 | + * Deletes a snippet from the database. | |
| 580 | + * Write operation. | |
| 581 | + * | |
| 582 | + * @param int $id ID of the snippet to delete. | |
| 583 | + * @param bool|null $network Delete from network-wide (true) or site-wide (false) table. | |
| 584 | + * | |
| 585 | + * @return bool Whether the snippet was deleted successfully. | |
| 586 | + * | |
| 587 | + * @since 2.0.0 | |
| 588 | + */ | |
| 589 | +function delete_snippet( int $id, ?bool $network = null ): bool { | |
| 590 | + global $wpdb; | |
| 591 | + $network = validate_network_param( $network ); | |
| 592 | + $table = code_snippets()->db->get_table_name( $network ); | |
| 225 | 593 | |
| 226 | - update_site_option( | |
| 227 | - 'recently_activated_snippets', | |
| 228 | - $recently_active + (array) get_site_option( 'recently_activated_snippets', array() ) | |
| 229 | - ); | |
| 594 | + $snippet = get_snippet( $id, $network ); | |
| 595 | + | |
| 596 | + // Prevent deletion of locked snippets. | |
| 597 | + if ( $snippet->locked ) { | |
| 598 | + return false; | |
| 230 | 599 | } |
| 231 | 600 | |
| 232 | - do_action( 'code_snippets/deactivate_snippet', $id, $multisite ); | |
| 601 | + $result = $wpdb->delete( | |
| 602 | + $table, | |
| 603 | + array( 'id' => $id ), | |
| 604 | + array( '%d' ) | |
| 605 | + ); | |
| 606 | + | |
| 607 | + if ( $result ) { | |
| 608 | + do_action( 'code_snippets/delete_snippet', $snippet, $network ); | |
| 609 | + clean_snippets_cache( $table ); | |
| 610 | + | |
| 611 | + $recently_active = get_self_option( $network, 'recently_active_snippets', [] ); | |
| 612 | + | |
| 613 | + if ( isset( $recently_active[ $id ] ) ) { | |
| 614 | + unset( $recently_active[ $id ] ); | |
| 615 | + update_self_option( $network, 'recently_active_snippets', $recently_active ); | |
| 616 | + } | |
| 617 | + } | |
| 618 | + | |
| 619 | + return (bool) $result; | |
| 233 | 620 | } |
| 234 | 621 | |
| 235 | 622 | /** |
| 236 | - * Deletes a snippet from the database | |
| 623 | + * Trashes a snippet from the database. | |
| 624 | + * Write operation. | |
| 237 | 625 | * |
| 238 | - * @since 2.0 | |
| 239 | - * @uses $wpdb to access the database | |
| 240 | - * @uses code_snippets()->db->get_table_name() to dynamically retrieve the name of the snippet table | |
| 626 | + * @param int $id ID of the snippet to trash. | |
| 627 | + * @param bool|null $network Trash from network-wide (true) or site-wide (false) table. | |
| 241 | 628 | * |
| 242 | - * @param int $id The ID of the snippet to delete | |
| 243 | - * @param bool|null $multisite Delete from site-wide or network-wide table? | |
| 629 | + * @return bool Whether the snippet was trashed successfully. | |
| 630 | + * | |
| 631 | + * @since 3.8.0 | |
| 244 | 632 | */ |
| 245 | -function delete_snippet( $id, $multisite = null ) { | |
| 246 | - /** @var wpdb $wpdb */ | |
| 633 | +function trash_snippet( int $id, ?bool $network = null ): bool { | |
| 247 | 634 | global $wpdb; |
| 635 | + $network = validate_network_param( $network ); | |
| 636 | + $table = code_snippets()->db->get_table_name( $network ); | |
| 248 | 637 | |
| 249 | - $wpdb->delete( | |
| 250 | - code_snippets()->db->get_table_name( $multisite ), | |
| 251 | - array( 'id' => $id ), | |
| 252 | - array( '%d' ) | |
| 253 | - ); | |
| 638 | + $snippet = get_snippet( $id, $network ); | |
| 254 | 639 | |
| 255 | - do_action( 'code_snippets/delete_snippet', $id, $multisite ); | |
| 640 | + // Prevent trashing of locked snippets. | |
| 641 | + if ( $snippet->locked ) { | |
| 642 | + return false; | |
| 643 | + } | |
| 644 | + | |
| 645 | + $wpdb->update( $table, [ 'active' => '-1' ], [ 'id' => $id ], [ '%d' ] ); | |
| 646 | + | |
| 647 | + do_action( 'code_snippets/trash_snippet', $snippet, $network ); | |
| 648 | + clean_snippets_cache( $table ); | |
| 649 | + | |
| 650 | + return true; | |
| 256 | 651 | } |
| 257 | 652 | |
| 258 | 653 | /** |
| 259 | - * Saves a snippet to the database. | |
| 654 | + * Restore a trashed snippet by setting its active status back to 0 (inactive). | |
| 655 | + * Write operation. | |
| 260 | 656 | * |
| 261 | - * @since 2.0 | |
| 657 | + * @param int $id Snippet ID to restore. | |
| 658 | + * @param bool|null $network Whether the snippet is multisite-wide (true) or site-wide (false). | |
| 262 | 659 | * |
| 263 | - * @uses $wpdb to update/add the snippet to the database | |
| 264 | - * @uses code_snippets()->db->get_table_name() To dynamically retrieve the name of the snippet table | |
| 660 | + * @return bool Whether the restore was successful. | |
| 265 | 661 | * |
| 266 | - * @param Code_Snippet $snippet The snippet to add/update to the database | |
| 267 | - * | |
| 268 | - * @return int The ID of the snippet | |
| 662 | + * @since 3.8.0 | |
| 269 | 663 | */ |
| 270 | -function save_snippet( Code_Snippet $snippet ) { | |
| 271 | - /** @var wpdb $wpdb */ | |
| 664 | +function restore_snippet( int $id, ?bool $network = null ): bool { | |
| 272 | 665 | global $wpdb; |
| 666 | + $network = validate_network_param( $network ); | |
| 667 | + $table = code_snippets()->db->get_table_name( $network ); | |
| 273 | 668 | |
| 274 | - $table = code_snippets()->db->get_table_name( $snippet->network ); | |
| 669 | + $result = $wpdb->update( $table, [ 'active' => '0' ], [ 'id' => $id ], [ '%d' ] ); | |
| 275 | 670 | |
| 276 | - /* Build array of data to insert */ | |
| 277 | - $data = array( | |
| 278 | - 'name' => $snippet->name, | |
| 279 | - 'description' => $snippet->desc, | |
| 280 | - 'code' => $snippet->code, | |
| 281 | - 'tags' => $snippet->tags_list, | |
| 282 | - 'scope' => $snippet->scope, | |
| 283 | - 'priority' => $snippet->priority, | |
| 284 | - 'active' => intval( $snippet->active ), | |
| 285 | - ); | |
| 671 | + if ( $result ) { | |
| 672 | + do_action( 'code_snippets/restore_snippet', $id, $network ); | |
| 673 | + clean_snippets_cache( $table ); | |
| 674 | + } | |
| 286 | 675 | |
| 287 | - /* Create a new snippet if the ID is not set */ | |
| 288 | - if ( 0 == $snippet->id ) { | |
| 676 | + return (bool) $result; | |
| 677 | +} | |
| 289 | 678 | |
| 290 | - $wpdb->insert( $table, $data, '%s' ); | |
| 291 | - $snippet->id = $wpdb->insert_id; | |
| 679 | +/** | |
| 680 | + * Test snippet code for errors, augmenting the snippet object. | |
| 681 | + * | |
| 682 | + * @param Snippet $snippet Snippet object. | |
| 683 | + */ | |
| 684 | +function test_snippet_code( Snippet $snippet ) { | |
| 685 | + $snippet->code_error = null; | |
| 686 | + $snippet->code_error_trace = null; | |
| 292 | 687 | |
| 293 | - do_action( 'code_snippets/create_snippet', $snippet->id, $table ); | |
| 294 | - } else { | |
| 688 | + if ( 'php' !== $snippet->type ) { | |
| 689 | + return; | |
| 690 | + } | |
| 295 | 691 | |
| 296 | - /* Otherwise update the snippet data */ | |
| 297 | - $wpdb->update( $table, $data, array( 'id' => $snippet->id ), null, array( '%d' ) ); | |
| 692 | + $validator = new Validator( $snippet->code ); | |
| 693 | + $result = $validator->validate(); | |
| 298 | 694 | |
| 299 | - do_action( 'code_snippets/update_snippet', $snippet->id, $table ); | |
| 695 | + if ( $result ) { | |
| 696 | + $snippet->code_error = [ $result['message'], $result['line'] ]; | |
| 697 | + $snippet->code_error_trace = ( new Exception() )->getTraceAsString(); | |
| 300 | 698 | } |
| 301 | 699 | |
| 302 | - return $snippet->id; | |
| 700 | + if ( ! $snippet->code_error && 'single-use' !== $snippet->scope ) { | |
| 701 | + $result = execute_snippet( $snippet->code, $snippet->id, true ); | |
| 702 | + | |
| 703 | + if ( $result instanceof Throwable ) { | |
| 704 | + $snippet->code_error = [ | |
| 705 | + ucfirst( rtrim( $result->getMessage(), '.' ) ) . '.', | |
| 706 | + $result->getLine(), | |
| 707 | + ]; | |
| 708 | + $snippet->code_error_trace = $result->getTraceAsString(); | |
| 709 | + } | |
| 710 | + } | |
| 303 | 711 | } |
| 304 | 712 | |
| 305 | 713 | /** |
| 306 | - * Update a snippet entry given a list of fields | |
| 714 | + * Saves a snippet to the database. | |
| 715 | + * Write operation. | |
| 307 | 716 | * |
| 308 | - * @param int $snippet_id The ID of the snippet to update | |
| 309 | - * @param array $fields An array of fields mapped to their values | |
| 310 | - * @param bool $network Whether the snippet is network-wide or site-wide | |
| 717 | + * @param Snippet|array<string, mixed> $snippet The snippet to add/update to the database. | |
| 718 | + * | |
| 719 | + * @return Snippet|null Updated snippet. | |
| 720 | + * | |
| 721 | + * @since 2.0.0 | |
| 311 | 722 | */ |
| 312 | -function update_snippet_fields( $snippet_id, $fields, $network = null ) { | |
| 313 | - /** @var wpdb $wpdb */ | |
| 723 | +function save_snippet( $snippet ): ?Snippet { | |
| 314 | 724 | global $wpdb; |
| 725 | + $table = code_snippets()->db->get_table_name( $snippet->network ); | |
| 315 | 726 | |
| 316 | - $table = code_snippets()->db->get_table_name( $network ); | |
| 727 | + if ( ! $snippet instanceof Snippet ) { | |
| 728 | + $snippet = new Snippet( $snippet ); | |
| 729 | + } | |
| 317 | 730 | |
| 318 | - /* Build a new snippet object for the validation */ | |
| 319 | - $snippet = new Code_Snippet(); | |
| 320 | - $snippet->id = $snippet_id; | |
| 731 | + // Prevent modification of locked snippets (allow unlocking itself). | |
| 732 | + if ( 0 !== $snippet->id ) { | |
| 733 | + $old_snippet = get_snippet( $snippet->id, $snippet->network ); | |
| 321 | 734 | |
| 322 | - /* Validate fields through the snippet class and copy them into a clean array */ | |
| 323 | - $clean_fields = array(); | |
| 735 | + if ( $old_snippet->locked && $snippet->locked ) { | |
| 736 | + // If it was locked and the new request still wants it locked, | |
| 737 | + // prevent changes to sensitive fields (code and name). | |
| 738 | + $snippet->code = $old_snippet->code; | |
| 739 | + $snippet->name = $old_snippet->name; | |
| 740 | + } | |
| 741 | + } | |
| 324 | 742 | |
| 325 | - foreach ( $fields as $field => $value ) { | |
| 743 | + // Update the last modification date if necessary. | |
| 744 | + $snippet->update_modified(); | |
| 326 | 745 | |
| 327 | - if ( $snippet->set_field( $field, $value ) ) { | |
| 328 | - $clean_fields[ $field ] = $snippet->$field; | |
| 746 | + // Strip any wrapper markup that came along with the pasted code. | |
| 747 | + $snippet->code = normalize_snippet_code( $snippet->code, $snippet->type ); | |
| 748 | + | |
| 749 | + if ( 'php' === $snippet->type ) { | |
| 750 | + // Deactivate snippet if code contains errors. | |
| 751 | + if ( $snippet->active && 'single-use' !== $snippet->scope ) { | |
| 752 | + test_snippet_code( $snippet ); | |
| 753 | + | |
| 754 | + if ( $snippet->code_error ) { | |
| 755 | + $snippet->active = 0; | |
| 756 | + } | |
| 329 | 757 | } |
| 330 | 758 | } |
| 331 | 759 | |
| 332 | - /* Update the snippet in the database */ | |
| 333 | - $wpdb->update( $table, $clean_fields, array( 'id' => $snippet->id ), null, array( '%d' ) ); | |
| 334 | - do_action( 'code_snippets/update_snippet', $snippet->id, $table ); | |
| 760 | + // Increment the revision number unless revision = 1 or revision is not set. | |
| 761 | + if ( $snippet->revision && $snippet->revision > 1 ) { | |
| 762 | + $snippet->increment_revision(); | |
| 763 | + } | |
| 764 | + | |
| 765 | + // Shared network snippets are always considered inactive. | |
| 766 | + $snippet->active = $snippet->active && ! $snippet->shared_network; | |
| 767 | + | |
| 768 | + // Snippet authorship: track who created and who last edited each snippet. | |
| 769 | + // `created_by` is fixed at insert time; `updated_by` reflects every save. | |
| 770 | + $current_user_id = get_current_user_id(); | |
| 771 | + $author_id = $current_user_id > 0 ? $current_user_id : null; | |
| 772 | + | |
| 773 | + // Build the list of data to insert (excluding locked, which is stored in wp_options). | |
| 774 | + $data = [ | |
| 775 | + 'name' => $snippet->name, | |
| 776 | + 'description' => $snippet->desc, | |
| 777 | + 'code' => $snippet->code, | |
| 778 | + 'tags' => $snippet->tags_list, | |
| 779 | + 'scope' => $snippet->scope, | |
| 780 | + 'condition_id' => intval( $snippet->condition_id ), | |
| 781 | + 'priority' => $snippet->priority, | |
| 782 | + 'active' => intval( $snippet->active ), | |
| 783 | + 'modified' => $snippet->modified, | |
| 784 | + 'revision' => $snippet->revision, | |
| 785 | + 'cloud_id' => $snippet->cloud_id_owner ? $snippet->cloud_id_owner : null, | |
| 786 | + 'updated_by' => $author_id, | |
| 787 | + ]; | |
| 788 | + | |
| 789 | + // Create a new snippet if the ID is not set. | |
| 790 | + if ( 0 === $snippet->id ) { | |
| 791 | + $data['created_by'] = $author_id; | |
| 792 | + $result = $wpdb->insert( $table, $data, '%s' ); | |
| 793 | + if ( false === $result ) { | |
| 794 | + return null; | |
| 795 | + } | |
| 796 | + | |
| 797 | + $snippet->id = $wpdb->insert_id; | |
| 798 | + $updated = get_snippet( $snippet->id, $snippet->network ); | |
| 799 | + $updated->code_error = $snippet->code_error; | |
| 800 | + $updated->code_error_trace = $snippet->code_error_trace; | |
| 801 | + do_action( 'code_snippets/create_snippet', $updated, $table ); | |
| 802 | + | |
| 803 | + if ( $updated->id > 0 ) { | |
| 804 | + set_snippet_locked( $updated->id, $updated->locked, $updated->network ); | |
| 805 | + } | |
| 806 | + } else { | |
| 807 | + // Otherwise, update the snippet data. | |
| 808 | + $existing = get_snippet( $snippet->id, $snippet->network ); | |
| 809 | + | |
| 810 | + set_snippet_locked( $snippet->id, $snippet->locked, $snippet->network ); | |
| 811 | + $wpdb->update( $table, $data, [ 'id' => $snippet->id ], null, [ '%d' ] ); | |
| 812 | + | |
| 813 | + $updated = get_snippet( $snippet->id, $snippet->network ); | |
| 814 | + $updated->code_error = $snippet->code_error; | |
| 815 | + $updated->code_error_trace = $snippet->code_error_trace; | |
| 816 | + | |
| 817 | + do_action( 'code_snippets/update_snippet', $updated, $table, $existing, $snippet ); | |
| 818 | + | |
| 819 | + if ( ! $updated->active && $existing->active ) { | |
| 820 | + $recently_active = get_self_option( $updated->network, 'recently_active_snippets', [] ); | |
| 821 | + $recently_active[ $updated->id ] = time(); | |
| 822 | + update_self_option( $updated->network, 'recently_active_snippets', $recently_active ); | |
| 823 | + } elseif ( ! $updated->active ) { | |
| 824 | + $recently_active = get_self_option( $updated->network, 'recently_active_snippets', [] ); | |
| 825 | + | |
| 826 | + if ( isset( $recently_active[ $updated->id ] ) ) { | |
| 827 | + unset( $recently_active[ $updated->id ] ); | |
| 828 | + update_self_option( $updated->network, 'recently_active_snippets', $recently_active ); | |
| 829 | + } | |
| 830 | + } | |
| 831 | + } | |
| 832 | + | |
| 833 | + update_shared_network_snippets( [ $updated ] ); | |
| 834 | + clean_snippets_cache( $table ); | |
| 835 | + return $updated; | |
| 335 | 836 | } |
| 336 | 837 | |
| 337 | 838 | /** |
| 338 | - * Execute a snippet | |
| 839 | + * Resolve a user ID to a compact author object for display. | |
| 339 | 840 | * |
| 340 | - * Code must NOT be escaped, as | |
| 341 | - * it will be executed directly | |
| 841 | + * Returns the user's ID, display name, and avatar URL, or null when the ID is | |
| 842 | + * empty or the user no longer exists. Results are cached per request, so a list | |
| 843 | + * of snippets sharing authors only triggers one lookup per distinct user. | |
| 342 | 844 | * |
| 343 | - * @since 2.0 | |
| 845 | + * @param int $user_id User ID to resolve. | |
| 344 | 846 | * |
| 345 | - * @param string $code The snippet code to execute | |
| 346 | - * @param int $id The snippet ID | |
| 347 | - * @param bool $catch_output Whether to attempt to suppress the output of execution using buffers | |
| 348 | - * | |
| 349 | - * @return mixed The result of the code execution | |
| 847 | + * @return array{id: int, display_name: string, avatar_url: string}|null | |
| 350 | 848 | */ |
| 351 | -function execute_snippet( $code, $id = 0, $catch_output = true ) { | |
| 849 | +function get_snippet_author( int $user_id ): ?array { | |
| 850 | + static $cache = []; | |
| 352 | 851 | |
| 353 | - if ( empty( $code ) ) { | |
| 354 | - return false; | |
| 852 | + if ( $user_id <= 0 ) { | |
| 853 | + return null; | |
| 355 | 854 | } |
| 356 | 855 | |
| 357 | - if ( $catch_output ) { | |
| 358 | - ob_start(); | |
| 856 | + if ( ! array_key_exists( $user_id, $cache ) ) { | |
| 857 | + $user = get_userdata( $user_id ); | |
| 858 | + $cache[ $user_id ] = $user ? | |
| 859 | + [ | |
| 860 | + 'id' => $user_id, | |
| 861 | + 'display_name' => $user->display_name, | |
| 862 | + 'avatar_url' => (string) get_avatar_url( $user_id, [ 'size' => 32 ] ), | |
| 863 | + ] : | |
| 864 | + null; | |
| 359 | 865 | } |
| 360 | 866 | |
| 361 | - $result = eval( $code ); | |
| 867 | + return $cache[ $user_id ]; | |
| 868 | +} | |
| 362 | 869 | |
| 363 | - if ( $catch_output ) { | |
| 364 | - ob_end_clean(); | |
| 870 | +/** | |
| 871 | + * Execute a snippet. | |
| 872 | + * Execute operation. | |
| 873 | + * | |
| 874 | + * Code must NOT be escaped, as it will be executed directly. | |
| 875 | + * | |
| 876 | + * @param string $code Snippet code to execute. | |
| 877 | + * @param int $id Snippet ID. | |
| 878 | + * @param bool $force Force snippet execution, even if save mode is active. | |
| 879 | + * | |
| 880 | + * @return Throwable|mixed Code error if encountered during execution, or result of snippet execution otherwise. | |
| 881 | + * | |
| 882 | + * @since 2.0.0 | |
| 883 | + * @noinspection PhpUndefinedConstantInspection | |
| 884 | + * | |
| 885 | + * phpcs:disable Squiz.PHP.Eval.Discouraged | |
| 886 | + */ | |
| 887 | +function execute_snippet( string $code, int $id = 0, bool $force = false ) { | |
| 888 | + /** | |
| 889 | + * Do not continue if safe mode is active. | |
| 890 | + * | |
| 891 | + * @noinspection PhpUndefinedConstantInspection | |
| 892 | + */ | |
| 893 | + if ( empty( $code ) || ( ! $force && defined( 'CODE_SNIPPETS_SAFE_MODE' ) && CODE_SNIPPETS_SAFE_MODE ) ) { | |
| 894 | + return false; | |
| 365 | 895 | } |
| 366 | 896 | |
| 367 | - do_action( 'code_snippets/after_execute_snippet', $id, $code, $result ); | |
| 897 | + ob_start(); | |
| 368 | 898 | |
| 899 | + try { | |
| 900 | + $result = eval( $code ); | |
| 901 | + } catch ( Throwable $throwable ) { | |
| 902 | + $result = $throwable; | |
| 903 | + } | |
| 904 | + | |
| 905 | + ob_end_clean(); | |
| 906 | + | |
| 907 | + do_action( 'code_snippets/after_execute_snippet', $code, $id, $result ); | |
| 369 | 908 | return $result; |
| 370 | 909 | } |
| 371 | 910 | |
| 372 | 911 | /** |
| 373 | - * Run the active snippets | |
| 912 | + * Retrieve a single snippets from the database using its cloud ID. | |
| 374 | 913 | * |
| 375 | - * @since 2.0 | |
| 914 | + * Read operation. | |
| 376 | 915 | * |
| 377 | - * @return bool true on success, false on failure | |
| 916 | + * @param string $cloud_id The Cloud ID of the snippet to retrieve. | |
| 917 | + * @param bool|null $multisite Retrieve a multisite-wide snippet (true) or site-wide snippet (false). | |
| 918 | + * | |
| 919 | + * @return Snippet|null A single snippet object or null if no snippet was found. | |
| 920 | + * | |
| 921 | + * @since 3.5.0 | |
| 378 | 922 | */ |
| 379 | -function execute_active_snippets() { | |
| 923 | +function get_snippet_by_cloud_id( string $cloud_id, ?bool $multisite = null ): ?Snippet { | |
| 924 | + global $wpdb; | |
| 380 | 925 | |
| 381 | - /* Bail early if safe mode is active */ | |
| 382 | - if ( defined( 'CODE_SNIPPETS_SAFE_MODE' ) && CODE_SNIPPETS_SAFE_MODE || ! apply_filters( 'code_snippets/execute_snippets', true ) ) { | |
| 383 | - return false; | |
| 926 | + $multisite = validate_network_param( $multisite ); | |
| 927 | + $table_name = code_snippets()->db->get_table_name( $multisite ); | |
| 928 | + | |
| 929 | + $cached_snippets = wp_cache_get( "all_snippets_$table_name", CACHE_GROUP ); | |
| 930 | + | |
| 931 | + // Attempt to fetch snippet from the cached list, if it exists. | |
| 932 | + if ( is_array( $cached_snippets ) ) { | |
| 933 | + foreach ( $cached_snippets as $snippet ) { | |
| 934 | + if ( $snippet->cloud_id === $cloud_id ) { | |
| 935 | + return apply_filters( 'code_snippets/get_snippet_by_cloud_id', $snippet, $cloud_id, $multisite ); | |
| 936 | + } | |
| 937 | + } | |
| 384 | 938 | } |
| 385 | 939 | |
| 386 | - /** @var wpdb $wpdb */ | |
| 387 | - global $wpdb; | |
| 388 | - $db = code_snippets()->db; | |
| 940 | + // Otherwise, search for the snippet from the database. | |
| 941 | + $snippet_data = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $table_name WHERE cloud_id = %s", $cloud_id ) ); // cache pass, db call ok. | |
| 942 | + $snippet = $snippet_data ? new Snippet( $snippet_data ) : null; | |
| 389 | 943 | |
| 390 | - $current_scope = is_admin() ? 'admin' : 'front-end'; | |
| 391 | - $queries = array(); | |
| 944 | + // Load locked from wp_options if snippet exists. | |
| 945 | + if ( $snippet && $snippet->id > 0 ) { | |
| 946 | + $snippet->network = $multisite; | |
| 947 | + $snippet->locked = is_snippet_locked( $snippet->id, $multisite ); | |
| 948 | + } | |
| 392 | 949 | |
| 393 | - $sql_format = "SELECT id, code, scope FROM %s WHERE scope IN ('global', 'single-use', %%s) "; | |
| 394 | - $order = 'ORDER BY priority ASC, id ASC'; | |
| 950 | + return apply_filters( 'code_snippets/get_snippet_by_cloud_id', $snippet, $cloud_id, $multisite ); | |
| 951 | +} | |
| 395 | 952 | |
| 396 | - /* Fetch snippets from site table */ | |
| 397 | - if ( $wpdb->get_var( "SHOW TABLES LIKE '$db->table'" ) === $db->table ) { | |
| 398 | - $queries[ $db->table ] = $wpdb->prepare( sprintf( $sql_format, $db->table ) . 'AND active=1 ' . $order, $current_scope ); | |
| 953 | +/** | |
| 954 | + * Remove the wrapper markup that a snippet's code does not need. | |
| 955 | + * | |
| 956 | + * Snippet code is stored bare: PHP is evaluated already inside PHP, and CSS and | |
| 957 | + * JavaScript are wrapped in their own tags when printed. People increasingly | |
| 958 | + * paste code generated by an AI assistant, which almost always arrives wrapped | |
| 959 | + * in the tags for its language and sometimes in a markdown code fence as well. | |
| 960 | + * | |
| 961 | + * Leaving that markup in place fails differently depending on the type, and all | |
| 962 | + * three ways are unhelpful. PHP raises a syntax error, so the snippet saves and | |
| 963 | + * is then quietly deactivated. CSS and JavaScript have no syntax check at all, | |
| 964 | + * so they save as active and emit doubled tags on the front end with nothing | |
| 965 | + * reported anywhere. | |
| 966 | + * | |
| 967 | + * Only a wrapper around the whole snippet is removed. Tags appearing partway | |
| 968 | + * through the code are left alone, since those are the author's own. | |
| 969 | + * | |
| 970 | + * @param string $code Snippet code as provided. | |
| 971 | + * @param string $type Snippet type: php, css, js or html. | |
| 972 | + * | |
| 973 | + * @return string Code with any surrounding wrapper markup removed. | |
| 974 | + */ | |
| 975 | +function normalize_snippet_code( string $code, string $type ): string { | |
| 976 | + // A markdown fence around the whole snippet, as copied from a chat window. | |
| 977 | + // The closing fence only goes when an opening one was there: on its own it | |
| 978 | + // is the author's content, as in an HTML snippet ending in backticks. | |
| 979 | + $code = preg_replace( '/\A\s*```[a-z]*[ \t]*\R/i', '', $code, 1, $fenced ); | |
| 980 | + | |
| 981 | + if ( $fenced ) { | |
| 982 | + $code = preg_replace( '/\R\s*```\s*\z/', '', $code ); | |
| 399 | 983 | } |
| 400 | 984 | |
| 401 | - /* Fetch snippets from the network table */ | |
| 402 | - if ( is_multisite() && $wpdb->get_var( "SHOW TABLES LIKE '$db->ms_table'" ) === $db->ms_table ) { | |
| 403 | - $active_shared_ids = get_option( 'active_shared_network_snippets', array() ); | |
| 985 | + switch ( $type ) { | |
| 986 | + case 'php': | |
| 987 | + // `php` is matched as a whole word so that `<?phpinfo()` is not | |
| 988 | + // mistaken for an opening tag followed by `info()`. | |
| 989 | + $code = preg_replace( '/\A\s*<\?(?:php\b)?/i', '', $code ); | |
| 990 | + $code = preg_replace( '/\?>\s*\z/', '', $code ); | |
| 991 | + break; | |
| 404 | 992 | |
| 405 | - /* If there are active shared snippets, include them in the query */ | |
| 406 | - if ( is_array( $active_shared_ids ) && count( $active_shared_ids ) ) { | |
| 993 | + case 'css': | |
| 994 | + $code = preg_replace( '/\A\s*<style\b[^>]*>/i', '', $code ); | |
| 995 | + $code = preg_replace( '/<\/style\s*>\s*\z/i', '', $code ); | |
| 996 | + break; | |
| 407 | 997 | |
| 408 | - /* Build a list of "%d, %d, %d ..." for every active network shared snippet we have */ | |
| 409 | - $active_shared_ids_format = implode( ',', array_fill( 0, count( $active_shared_ids ), '%d' ) ); | |
| 998 | + case 'js': | |
| 999 | + $code = preg_replace( '/\A\s*<script\b[^>]*>/i', '', $code ); | |
| 1000 | + $code = preg_replace( '/<\/script\s*>\s*\z/i', '', $code ); | |
| 1001 | + break; | |
| 1002 | + } | |
| 410 | 1003 | |
| 411 | - /* Include them in the query */ | |
| 412 | - $sql = sprintf( $sql_format, $db->ms_table ) . " AND (active=1 OR id IN ($active_shared_ids_format)) $order"; | |
| 1004 | + // Drop the single line break left behind by an opening tag on its own line, | |
| 1005 | + // so the stored code does not gain a blank first line each time. | |
| 1006 | + return preg_replace( '/\A\R/', '', $code ); | |
| 1007 | +} | |
| 413 | 1008 | |
| 414 | - /* Add the scope number to the IDs array, so that it is the first variable in the query */ | |
| 415 | - array_unshift( $active_shared_ids, $current_scope ); | |
| 416 | - $queries[ $db->ms_table ] = $wpdb->prepare( $sql, $active_shared_ids ); | |
| 417 | - array_shift( $active_shared_ids ); // remove it afterwards as we need this variable later | |
| 1009 | +/** | |
| 1010 | + * Update a snippet entry given a list of fields. | |
| 1011 | + * Write operation. | |
| 1012 | + * | |
| 1013 | + * @param int $snippet_id ID of the snippet to update. | |
| 1014 | + * @param array<string, mixed> $fields An array of fields mapped to their values. | |
| 1015 | + * @param bool|null $network Update in network-wide (true) or site-wide (false) table. | |
| 1016 | + */ | |
| 1017 | +function update_snippet_fields( int $snippet_id, array $fields, ?bool $network = null ) { | |
| 1018 | + global $wpdb; | |
| 418 | 1019 | |
| 419 | - } else { | |
| 420 | - $sql = sprintf( $sql_format, $db->ms_table ) . 'AND active=1 ' . $order; | |
| 421 | - $queries[ $db->ms_table ] = $wpdb->prepare( $sql, $current_scope ); | |
| 1020 | + $network = validate_network_param( $network ); | |
| 1021 | + $table = code_snippets()->db->get_table_name( $network ); | |
| 1022 | + | |
| 1023 | + // Build a new snippet object for the validation. | |
| 1024 | + $snippet = new Snippet(); | |
| 1025 | + $snippet->id = $snippet_id; | |
| 1026 | + | |
| 1027 | + // Validate fields through the snippet class and copy them into a clean array. | |
| 1028 | + $clean_fields = array(); | |
| 1029 | + $locked_value = null; | |
| 1030 | + | |
| 1031 | + foreach ( $fields as $field => $value ) { | |
| 1032 | + // Handle locked separately (stored in wp_options). | |
| 1033 | + if ( 'locked' === $field ) { | |
| 1034 | + if ( $snippet->set_field( $field, $value ) ) { | |
| 1035 | + $locked_value = $snippet->$field; | |
| 1036 | + } | |
| 1037 | + continue; | |
| 422 | 1038 | } |
| 1039 | + | |
| 1040 | + if ( $snippet->set_field( $field, $value ) ) { | |
| 1041 | + $clean_fields[ $field ] = $snippet->$field; | |
| 1042 | + } | |
| 423 | 1043 | } |
| 424 | 1044 | |
| 425 | - foreach ( $queries as $table_name => $query ) { | |
| 426 | - $active_snippets = $wpdb->get_results( $query, 'ARRAY_A' ); | |
| 1045 | + // Update the snippet in the database (excluding locked). | |
| 1046 | + if ( ! empty( $clean_fields ) ) { | |
| 1047 | + $wpdb->update( $table, $clean_fields, array( 'id' => $snippet->id ), null, array( '%d' ) ); | |
| 1048 | + } | |
| 427 | 1049 | |
| 428 | - if ( ! is_array( $active_snippets ) ) { | |
| 429 | - continue; | |
| 430 | - } | |
| 1050 | + // Save locked to wp_options if it was provided. | |
| 1051 | + if ( null !== $locked_value ) { | |
| 1052 | + set_snippet_locked( $snippet->id, $locked_value, $network ); | |
| 1053 | + } | |
| 431 | 1054 | |
| 432 | - /* Loop through the returned snippets and execute the PHP code */ | |
| 433 | - foreach ( $active_snippets as $snippet ) { | |
| 434 | - $snippet_id = intval( $snippet['id'] ); | |
| 435 | - $code = $snippet['code']; | |
| 1055 | + clean_snippets_cache( $table ); | |
| 1056 | + $updated = get_snippet( $snippet->id, $network ); | |
| 1057 | + if ( $updated->id ) { | |
| 1058 | + do_action( 'code_snippets/update_snippet', $updated, $table ); | |
| 1059 | + } | |
| 1060 | +} | |
| 436 | 1061 | |
| 437 | - // if the snippet is a single-use snippet, deactivate it before execution to ensure that the process always happens | |
| 438 | - if ( 'single-use' === $snippet['scope'] ) { | |
| 439 | - if ( $table_name === $db->ms_table && isset( $active_shared_ids ) && | |
| 440 | - false !== ( $key = array_search( $snippet_id, $active_shared_ids ) ) ) { | |
| 441 | - unset( $active_shared_ids[ $key ] ); | |
| 442 | - $active_shared_ids = array_values( $active_shared_ids ); | |
| 443 | - update_option( 'active_shared_network_snippets', $active_shared_ids ); | |
| 444 | - } else { | |
| 445 | - $wpdb->update( $table_name, array( 'active' => '0' ), array( 'id' => $snippet_id ), array( '%d' ), array( '%d' ) ); | |
| 446 | - } | |
| 447 | - } | |
| 1062 | +/** | |
| 1063 | + * Evaluate a snippet by loading it from the filesystem. | |
| 1064 | + * | |
| 1065 | + * @param string $code Snippet code. | |
| 1066 | + * @param string $file Snippet filename. | |
| 1067 | + * @param int $id Snippet ID. | |
| 1068 | + * @param bool $force Force snippet execution, even if save mode is active. | |
| 1069 | + * | |
| 1070 | + * @return bool|Exception|Throwable|null Code error if encountered during execution, or result of snippet execution otherwise. | |
| 1071 | + */ | |
| 1072 | +function execute_snippet_from_flat_file( string $code, string $file, int $id = 0, bool $force = false ) { | |
| 1073 | + if ( ! is_file( $file ) ) { | |
| 1074 | + execute_snippet( $code, $id, $force ); | |
| 1075 | + return true; | |
| 1076 | + } | |
| 448 | 1077 | |
| 449 | - if ( apply_filters( 'code_snippets/allow_execute_snippet', true, $snippet_id, $table_name ) ) { | |
| 450 | - execute_snippet( $code, $snippet_id ); | |
| 451 | - } | |
| 452 | - } | |
| 1078 | + /* @noinspection PhpUndefinedConstantInspection */ | |
| 1079 | + if ( ! $force && defined( 'CODE_SNIPPETS_SAFE_MODE' ) && CODE_SNIPPETS_SAFE_MODE ) { | |
| 1080 | + return false; | |
| 453 | 1081 | } |
| 454 | 1082 | |
| 455 | - return true; | |
| 1083 | + ob_start(); | |
| 1084 | + | |
| 1085 | + try { | |
| 1086 | + require_once $file; | |
| 1087 | + $result = null; | |
| 1088 | + } catch ( Throwable $throwable ) { | |
| 1089 | + $result = $throwable; | |
| 1090 | + } | |
| 1091 | + | |
| 1092 | + ob_end_clean(); | |
| 1093 | + | |
| 1094 | + do_action( 'code_snippets/after_execute_snippet_from_flat_file', $file, $id ); | |
| 1095 | + | |
| 1096 | + return $result ?? null; | |
| 456 | 1097 | } |
