| @@ -1,12 +1,12 @@ | ||
| 1 | 1 | <?php |
| 2 | 2 | /** |
| 3 | 3 | * @package FireBox |
| 4 | - * @version 1.0.9 Free | |
| 4 | + * @version 3.1.14 Free | |
| 5 | 5 | * |
| 6 | 6 | * @author FirePlugins <[email protected]> |
| 7 | 7 | * @link https://www.fireplugins.com |
| 8 | - * @copyright Copyright © 2021 FirePlugins All Rights Reserved | |
| 8 | + * @copyright Copyright © 2026 FirePlugins All Rights Reserved | |
| 9 | 9 | * @license GNU GPLv3 <http://www.gnu.org/licenses/gpl.html> or later |
| 10 | 10 | */ |
| 11 | 11 | |
| 12 | 12 | namespace FireBox\Core\Tables; |
| @@ -19,8 +19,16 @@ | ||
| 19 | 19 | use FPFramework\Includes\DB; |
| 20 | 20 | |
| 21 | 21 | class Box extends DB |
| 22 | 22 | { |
| 23 | + /** | |
| 24 | + * The column list below covers wp_posts in full, so inserts can safely be | |
| 25 | + * restricted to it. | |
| 26 | + * | |
| 27 | + * @var bool | |
| 28 | + */ | |
| 29 | + protected $enforce_insert_columns = true; | |
| 30 | + | |
| 23 | 31 | public function __construct() |
| 24 | 32 | { |
| 25 | 33 | $this->table_name = 'posts'; |
| 26 | 34 | $this->primary_key = 'ID'; |
| @@ -26,18 +34,40 @@ | ||
| 26 | 34 | $this->primary_key = 'ID'; |
| 27 | 35 | } |
| 28 | 36 | |
| 29 | 37 | /** |
| 30 | - * Get columns and formats | |
| 38 | + * Get columns and formats | |
| 31 | 39 | * |
| 40 | + * Keys are lower-cased because DB::insert()/update() normalise incoming data with | |
| 41 | + * array_change_key_case() before intersecting against this list. | |
| 42 | + * | |
| 32 | 43 | * @return array |
| 33 | 44 | */ |
| 34 | 45 | public function get_columns() |
| 35 | 46 | { |
| 36 | 47 | return array( |
| 37 | - 'ID' => '%d', | |
| 38 | - 'post_author' => '%d', | |
| 39 | - 'post_status' => '%s', | |
| 40 | - 'post_type' => '%s' | |
| 48 | + 'id' => '%d', | |
| 49 | + 'post_author' => '%d', | |
| 50 | + 'post_date' => '%s', | |
| 51 | + 'post_date_gmt' => '%s', | |
| 52 | + 'post_content' => '%s', | |
| 53 | + 'post_title' => '%s', | |
| 54 | + 'post_excerpt' => '%s', | |
| 55 | + 'post_status' => '%s', | |
| 56 | + 'comment_status' => '%s', | |
| 57 | + 'ping_status' => '%s', | |
| 58 | + 'post_password' => '%s', | |
| 59 | + 'post_name' => '%s', | |
| 60 | + 'to_ping' => '%s', | |
| 61 | + 'pinged' => '%s', | |
| 62 | + 'post_modified' => '%s', | |
| 63 | + 'post_modified_gmt' => '%s', | |
| 64 | + 'post_content_filtered' => '%s', | |
| 65 | + 'post_parent' => '%d', | |
| 66 | + 'guid' => '%s', | |
| 67 | + 'menu_order' => '%d', | |
| 68 | + 'post_type' => '%s', | |
| 69 | + 'post_mime_type' => '%s', | |
| 70 | + 'comment_count' => '%d' | |
| 41 | 71 | ); |
| 42 | 72 | } |
| 43 | 73 | } |
