Ordered Mission Posts - A Nova Extension

This extension provides multiple methods for ordering mission posts. Day/Time, Date/Time, Stardate(decimal)/Time, and Post Numbering.

While this extension is not a fork of chronological_mission_posts it would not have been possible without it and Jon's other wonderful extensions.

This extension requires:

• Nova 2.6+
• Nova Extension jquery
• Nova Extension timepicker
• Nova Mod parser_events

Installation

• Install Required Extensions.
• Copy the entire directory into applications/extensions/nova_ext_ordered_mission_posts.
• Add the following to application/config/extensions.php: - Be sure the jquery and timepicker lines appear before nova_ext_ordered_mission_posts

  $config['extensions']['enabled'][] = 'nova_ext_ordered_mission_posts';

• If you were using chronological_mission_posts remove the $config['extensions']['enabled'][] = 'chronological_mission_posts'; line from application/config/extensions.php

Setup Using Admin Panel - Preferred

• Navigate to your Admin Control Panel
• Choose Ordered Mission Posts under Manage Extensions
• Create Database Columns by clicking "Create Column" for each column. Once all columns are added the message "All expected columns found in the database" will appear.
• Create Indexes by clicking Create Index. The button will appear when all Database columns are detected. Once indexes are added the message "All expected indexes found in the database." will appear.
• Click Update Controller Information to add the _email function to your application/controllers/write.php file. This allows Post Numbers to be included in Post emails.

Installation is now complete! If you previously used chronological_mission_posts check below on how to enable support.

Manual Setup - If not using the method above.

• Run the following commands on your MySQL database:

ALTER TABLE nova_posts ADD COLUMN nova_ext_ordered_post_day INTEGER NOT NULL DEFAULT 1;
ALTER TABLE nova_posts ADD COLUMN nova_ext_ordered_post_time VARCHAR(4) NOT NULL DEFAULT '0000';
ALTER TABLE nova_posts ADD COLUMN nova_ext_ordered_post_date VARCHAR(255) DEFAULT NULL;
ALTER TABLE nova_posts ADD COLUMN nova_ext_ordered_post_stardate VARCHAR(255) DEFAULT NULL;
ALTER TABLE nova_missions ADD COLUMN mission_ext_ordered_config_setting VARCHAR(255) DEFAULT NULL;
ALTER TABLE nova_missions ADD COLUMN mission_ext_ordered_post_numbering INTEGER NOT NULL DEFAULT 0;
ALTER TABLE nova_missions ADD COLUMN mission_ext_ordered_default_mission_date VARCHAR(255) DEFAULT NULL;
ALTER TABLE nova_missions ADD COLUMN mission_ext_ordered_default_stardate VARCHAR(255) DEFAULT NULL;
ALTER TABLE nova_missions ADD COLUMN mission_ext_ordered_legacy_mode INTEGER NOT NULL DEFAULT 0;
ALTER TABLE nova_missions ADD COLUMN mission_ext_ordered_is_new_record int(11) DEFAULT 0;
CREATE INDEX  post_ordered_mission_post ON nova_posts (`nova_ext_ordered_post_day`,`nova_ext_ordered_post_date`,`nova_ext_ordered_post_stardate`,`nova_ext_ordered_post_time`)";
CREATE INDEX  post_ordered_mission ON nova_missions (`mission_ext_ordered_config_setting`,`mission_ext_ordered_post_numbering`,`mission_ext_ordered_default_mission_date`,`mission_ext_ordered_default_stardate`,`mission_ext_ordered_legacy_mode`,`mission_ext_ordered_is_new_record`)";

• Add the following function in your applications/controllers/write.php file to overwrite _email function. This will allow the email subject to include Post numbers before the Post title.

protected function _email($type, $data)
    {   
        switch ($type)
        {
            case 'post':  
              if(($id = $this->input->post('mission', true)) !== false)
                {  

                       $query = $this->db->get_where('missions', array('mission_id' => $id));
                           $model = ($query->num_rows() > 0) ? $query->row() : false;
                           if(!empty($model) && $model->mission_ext_ordered_post_numbering==1)
                               {

               $queryCount = $this->db->get_where('posts', array('post_mission' => $id,'post_status'=>'activated'));
               $count = $queryCount->num_rows();
                    $title=$data['title'];
                   $data['title']="Post $count - $title";
                               }
                   }
                  parent::_email($type, $data);
            break;
            default:
                    parent::_email($type, $data);
            break;

        }

    }

Installation is now complete! If you previously used chronological_mission_posts check below on how to enable support.

Usage

• Create or Edit a mission.
• Choose the Timeline Configuration that best fits your game.
• If using Stardate or Date Time enter a default starting date.
• Enter other values as normal.
• Click submit.

Timeline Configuration

The extension supports the following Timeline Configurations and will sort the posts chronologically unless Post Numbering is enabled.

• Nova Default
  • This option displays the Default Timeline Field on Posts and sort is by post activation time, which is default Nova behavior.
• Day Time
  • Presents the writer with a Day and Time field on Mission Posts.
  • Posts are sorted by Day and then Time.
  • This is similar funcationality to chronological_mission_posts
• Date Time
  • Presents the writer with a Date and Time field on Mission Posts.
  • Posts are sorted by Date and then Time.
  • The Admin can also configure a Default Mission Date that will be seeded into posts to position the date picker.
  • Date format is Year-Month-Day ex: 2399-04-20
• Stardate (decimal)
  • Presents the writer with a Stardate and Time field on Mission Posts.
  • Posts are sorted by Stardate and then Time.
  • The Admin can also configure a Default Mission Stardate that will be seeded into posts to position the date picker.
  • Stardate format is decimal ex: 12345.67

Post Numbering Support

Many games prefer to order posts by post number. This extension will auotmatically add the correct post number and sort posts by number rather than chronologically.

• Check Post Numbering on the create or edit mission page.
• Click submit.

Labels

The majority of the labels for this extension can be modified in the admin control panel to fit the needs of your game.

chronological_mission_posts Support

This extension requires you to replace chronological_mission_posts however you can enable support for existing missions if you used it previously.

Enable Support

• Navigate to your Admin Control Panel
• Choose Ordered Mission Posts under Manage Extensions
• If the exention detects the columns required by chronological_mission_posts you will see the message "chronological_mission_posts database columns detected. You may enable Legacy Mode for existing Missions."
• Checking Legacy Mode and clicking Enable/Disable Legacy Mode will add the option to use the Day/Time values from chronologocal_mission_posts on existing missions.

Usage

• After enabling support edit an existing mission.
• Set the Timeline Configuration to Day Time
• Check Day Time Legacy Mode
• Click Submit

Your posts will now reference the values from chronological_mission_posts

Issues

If you encounter a bug or have a feature request, please report it on GitHub in the issue tracker here: https://github.com/reecesavage/nova-ext-ordered-mission-posts/issues

License

Copyright (c) 2021 Reece Savage.

This module is open-source software licensed under the MIT License. The full text of the license may be found in the LICENSE file.