WordPress Community Plugin Repair

Fix a WordPress Plugin

I have created a WordPress plugin for my community site but it is not working. Here is the basic writeup of the plugin:

High-Level Document: Add Work Plugin

---

Purpose

The Add Work plugin enables users to submit written work to "The Stage" for critique and feedback. It streamlines the submission process through a multi-step form, where users provide details about their work, such as genre, target audience, visibility settings, and the actual text of their submission. The plugin dynamically calculates the cost of submission based on user choices and integrates seamlessly with other components of the system, such as Critique Points, Genres, and BuddyPress Groups.

---

Key Features

1. Multi-Step Submission Form:

- Guides users through a step-by-step process for submitting their work.

- Includes options for adding novel chapters or standalone works.

2. Dynamic Cost Calculation:

- Calculates the total cost of submission based on:

- Word count.

- Visibility settings (e.g., Public, Private).

- Premium features like one-at-a-time critiques.

3. Integration with Related Plugins:

- Pulls data from Genres, Work Types, and Target Audiences.

- Leverages Critique Points for cost deductions.

- Integrates with BuddyPress Groups for restricted visibility.

4. Rich Text Editor:

- Supports formatted text submissions.

- Automatically sanitizes unsupported formatting for standard users.

5. Visibility Settings:

- Allows users to choose between Public, Restricted, or Private stages.

- Supports BuddyPress group restrictions for Premium and Sponsored members.

6. Admin-Friendly Shortcode:

- Provides a shortcode to embed the form on front-end pages for user access.

---

Database Tables Affected

1. `wp_the_stage`

Stores the submitted work and its associated metadata.

| Column Name | Data Type | Description |

|---------------------------|--------------------|---------------------------------------------------------------------------------------------------|

| `id` | `INT` | Primary Key. Unique identifier for each submitted work. |

| `user_id` | `INT` | ID of the user who submitted the work (references `wp_users`). |

| `novel_id` | `INT` | ID of the related novel (if the work is part of a novel). |

| `chapter_number` | `INT` | Chapter number of the work (if part of a novel). |

| `chapter_title` | `VARCHAR(255)` | Title of the chapter (if part of a novel). |

| `title` | `VARCHAR(255)` | Title of the work (if not part of a novel). |

| `part_number` | `INT` | Part number of the work, if it is divided into multiple parts. |

| `description` | `TEXT` | A short description of the submitted work. |

| `chapter_plot_summary` | `TEXT` | Summary of the plot for the chapter (if part of a novel). |

| `primary_genre` | `VARCHAR(255)` | Main genre of the work (references `wp_genre_control.primary_genre`). |

| `subgenre` | `TEXT` | Subgenre of the work (references `[login to view URL]`). |

| `work_type` | `VARCHAR(255)` | Type of work (references `[login to view URL]`). |

| `target_audience` | `VARCHAR(255)` | Target audience of the work (references `[login to view URL]`). |

| `visibility` | `VARCHAR(255)` | Visibility settings for the work. Options include Public, Private, or BuddyPress group. |

| `available_critiques` | `INT` | Number of critiques available for the work. |

| `main_stage` | `VARCHAR(50)` | Main stage of the work: Public or Private. |

| `current_stage` | `VARCHAR(255)` | Current status of the work: Awaiting, On Public Stage, Off Stage, etc. |

| `available_for_critique` | `BOOLEAN` | Whether the work is currently available for critique. |

| `one_at_a_time` | `BOOLEAN` | Restricts critiques to one user at a time if set to true. |

| `critique_in_progress` | `BOOLEAN` | Indicates if a critique is currently in progress for the work. |

| `date_submitted` | `DATETIME` | Timestamp of when the work was submitted. |

| `date_stage_change` | `DATETIME` | Timestamp of the last stage change for the work. |

| `max_word_count` | `INT` | Maximum word count allowed for the work. |

| `work` | `TEXT` | The actual text of the submitted work, stored in rich text format. |

| `critique_guidance` | `TEXT` | A short message to guide critiquers on what to focus on (max 100 words). |

---

2. `wp_critique_points`

Tracks the user's critique points and updates the balance when submitting work.

| Column Name | Data Type | Description |

|----------------------|---------------|------------------------------------------------|

| `user_id` | `INT` | ID of the user. References `wp_users`. |

| `points_balance` | `INT` | The user's current critique points balance. |

---

3. `wp_genre_control`

Provides the list of genres and subgenres used in submissions.

| Column Name | Data Type | Description |

|----------------------|--------------------|------------------------------------------------|

| `primary_genre` | `VARCHAR(255)` | The main genre of the work. |

| `subgenre` | `TEXT` | The subgenres associated with the primary genre. |

---

4. `wp_work_type`

Provides the list of work types available for selection.

| Column Name | Data Type | Description |

|----------------------|--------------------|------------------------------------------------|

| `type` | `VARCHAR(255)` | The type of work (e.g., novel, short story). |

---

5. `wp_target_audience`

Lists the target audiences available for selection.

| Column Name | Data Type | Description |

|----------------------|--------------------|------------------------------------------------|

| `audience` | `VARCHAR(255)` | The target audience for the work. |

---

Integration Points

1. Critique Points Plugin:

- Deducts points based on submission cost and updates the user's balance.

2. BuddyPress Integration:

- Supports group restrictions for Restricted visibility settings.

3. Genres, Work Types, and Target Audiences:

- Populates dropdown menus for user selection.

---

Purpose Summary

The Add Work plugin simplifies the process of submitting written works for critique while maintaining tight integration with related plugins and systems. By leveraging a structured database, dynamic interactivity, and a user-friendly interface, it enhances the critique process for both writers and reviewers.

Your job is to investigate the plugin and ensure it operates corrected as per the high level document. You will be given access to the admin system of the site to ensure it works correctly. All work is to be done on our UAT site. Once issue is resolve and tested, the plugin will be used in our production site when ready.

Note: To identified bot postings and ensure you have read the requirements, please put the following at the end of your bid for the job - I have fully read the job requirements and my hourly wage is set with the estimated time of completion given.

WordPress Plugin PHP JavaScript AJAX

Projektazonosító: #38826926

A projektről