get_charset_collate(); require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); // Events table $table_name_events = $wpdb->prefix . ABP_EVENTS_TABLE; $sql_events = "CREATE TABLE $table_name_events ( id mediumint(9) NOT NULL AUTO_INCREMENT, name tinytext NOT NULL, description text DEFAULT '' NOT NULL, date_ranges longtext NOT NULL, -- Store as JSON or serialized data time_slots longtext NOT NULL, -- Store as JSON or serialized data created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, updated_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id) ) $charset_collate;"; dbDelta($sql_events); // Appointments table $table_name_appointments = $wpdb->prefix . ABP_APPOINTMENTS_TABLE; $sql_appointments = "CREATE TABLE $table_name_appointments ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, event_id mediumint(9) NOT NULL, user_id bigint(20) unsigned DEFAULT NULL, -- Can be null for guest bookings if allowed later appointment_time datetime NOT NULL, unique_booking_id varchar(64) NOT NULL, -- Unique ID for reference status varchar(20) DEFAULT 'confirmed' NOT NULL, -- e.g., confirmed, cancelled user_name varchar(100) DEFAULT NULL, -- If guest booking user_email varchar(100) DEFAULT NULL, -- If guest booking created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, updated_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), UNIQUE KEY unique_booking_id (unique_booking_id), KEY event_id (event_id), KEY user_id (user_id), KEY appointment_time (appointment_time) ) $charset_collate;"; dbDelta($sql_appointments); // Add options or default settings if needed // add_option('abp_some_setting', 'default_value'); } ?> prefix . ABP_EVENTS_TABLE; return $wpdb->get_row($wpdb->prepare("SELECT * FROM $table_name WHERE id = %d", $event_id)); } function abp_insert_event($data) { global $wpdb; $table_name = $wpdb->prefix . ABP_EVENTS_TABLE; $data['created_at'] = current_time('mysql'); $data['updated_at'] = current_time('mysql'); // Remember to sanitize data before insertion // $wpdb->insert($table_name, $sanitized_data); // return $wpdb->insert_id; } // ... more functions for update, delete, get_all etc. for both tables */ ?>

0; $page_title = $is_editing ? __('Edit Event', 'appointment-booking') : __('Add New Event', 'appointment-booking'); // In a real scenario, you would load event data here if $is_editing is true // $event_data = $is_editing ? abp_get_event($event_id) : null; ?>

" class="regular-text">

[Calendar View Placeholder]