{"slug":"booking","name":"Booking Calendar","description":"WP Booking Calendar plugin for full-day bookings, time-slot appointments, rentals & events. Accept bookings and inquiries with flexible contact forms","author":"wpdevelop","active_installs":50000,"version":"11.3","wp_org_url":"https://wordpress.org/plugins/booking/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"booking","full_table_name":"wp_booking","description":"Stores booking data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"booking_coupons","full_table_name":"wp_booking_coupons","description":"Stores booking coupons data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"booking_dates_props","full_table_name":"wp_booking_dates_props","description":"Stores booking dates props data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"booking_dates_prop_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"resource_id","type":"bigint(10)","nullable":false,"primary_key":false},{"name":"calendar_date","type":"datetime","nullable":false,"primary_key":false},{"name":"prop_name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"prop_value","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_booking_dates_props ( booking_dates_prop_id bigint(20) unsigned NOT NULL auto_increment, resource_id bigint(10) NOT NULL default 1, calendar_date datetime NOT NULL default '0000-00-00 00:00:00', prop_name varchar(200) NOT NULL default '', prop_value text, PRIMARY KEY (booking_dates_prop_id) )\"; */ } /** * Update dates status * * @param $params array( 'resource_id' => 1, // int 'prop_name' => 'date_status', // 'rate', 'allow_start_day_selection', 'allow_days_number_to_select', 'availability_count', ... 'prop_value' => 'unavailable', // 'available', 'unavailable' , 'pending', 'approved' 'dates_selection' => '' // '2023-04-04 | 2023-04-07' ) * * @return bool|int - return how many DB rows affected -how many dates processed */ function wpbc_availability__update_dates_status__sql( $params ){ $defaults = array( 'resource_id' => 1, // int 'prop_name' => 'date_status', // 'rate', 'allow_start_day_selection', 'allow_days_number_to_select', 'availability_count', ... 'prop_value' => 'unavailable', // 'available', 'unavailable' , 'pending', 'approved' 'dates_selection' => '' // '2023-04-04 | 2023-04-07' );"},{"table_name":"booking_form_structures","full_table_name":"wp_booking_form_structures","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"high","columns":[{"name":"booking_form_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"form_slug","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"owner_user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"scope","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"version","type":"int(11)","nullable":false,"primary_key":false},{"name":"booking_resource_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"engine","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"engine_version","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"structure_json","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"settings_json","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"advanced_form","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"content_form","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"is_default","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"picture_url","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"created_by","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"updated_by","type":"bigint(20) unsigned","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_booking_form_structures ( booking_form_id bigint(20) unsigned NOT NULL auto_increment, form_slug VARCHAR(191) NOT NULL, status VARCHAR(32) NOT NULL, owner_user_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, scope varchar(64) NOT NULL default 'global', version int(11) NOT NULL default 1, booking_resource_id BIGINT UNSIGNED NULL, engine varchar(32) NOT NULL default 'bfb', engine_version varchar(16) NOT NULL default '1.0', structure_json LONGTEXT NOT NULL, settings_json LONGTEXT NULL, advanced_form LONGTEXT NULL, content_form LONGTEXT NULL, is_default TINYINT(1) NOT NULL DEFAULT 0, title VARCHAR(255) NOT NULL, description TEXT NULL, picture_url text NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, created_by bigint(20) unsigned DEFAULT NULL, updated_by bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (booking_form_id), UNIQUE KEY form_slug_status (form_slug, status, owner_user_id) ) {$charset_collate}\"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter $wpdb->query( $simple_sql );"},{"table_name":"booking_seasons","full_table_name":"wp_booking_seasons","description":"Stores booking seasons data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"booking_types_meta","full_table_name":"wp_booking_types_meta","description":"Stores additional metadata (key-value pairs) for booking types records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bookingdates","full_table_name":"wp_bookingdates","description":"Stores bookingdates data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"booking_dates_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"booking_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"booking_date","type":"datetime","nullable":false,"primary_key":false},{"name":"approved","type":"bigint(20) unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_bookingdates ( booking_dates_id bigint(20) unsigned NOT NULL auto_increment, booking_id bigint(20) unsigned NOT NULL, booking_date datetime NOT NULL default '0000-00-00 00:00:00', approved bigint(20) unsigned NOT NULL default 0, PRIMARY KEY (booking_dates_id) ) {$charset_collate}\"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter $wpdb->query( $simple_sql );"},{"table_name":"bookingtypes","full_table_name":"wp_bookingtypes","description":"Stores bookingtypes data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":8}