WordPress database error: [Table 'wp_options' is marked as crashed and should be repaired]
SELECT option_value FROM wp_options WHERE option_name = 'cron' LIMIT 1

WordPress database error: [Incorrect key file for table './ninelegends/wp_options.MYI'; try to repair it]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1568828594;a:1:{s:32:\"recovery_mode_clean_expired_keys\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [Incorrect key file for table './ninelegends/wp_options.MYI'; try to repair it]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1568828594;a:1:{s:34:\"wp_privacy_delete_old_export_files\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [Incorrect key file for table './ninelegends/wp_options.MYI'; try to repair it]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1568828594;a:1:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [Incorrect key file for table './ninelegends/wp_options.MYI'; try to repair it]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1568828594;a:1:{s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [Incorrect key file for table './ninelegends/wp_options.MYI'; try to repair it]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1568828594;a:1:{s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

Cleaning up NS demos « ninelegends
 

Cleaning up NS demos

Unfortunately, moviemaking is a process that requires both mindbendingly creative and horribly boring tasks. Most of the preparation work that has to be done before making a movie falls under the “horribly boring” category. Cleaning up demos is one of these essential tasks that need to be completed before the actual “moviemaking” begins, in order to create a great movie. In this guide I will show you how to clean up demos easily and reasonably efficiently.

 

By following this guide you will remove the scoreboard, popupmenu and minimaps from any demos you apply it to. The result is a demo (and by extension: movie) without unneccesary visual obstructions.

 

Cleaning up demos is only necessary for POV (some call them first person) demos. HLTV demos aren’t dirty and don’t require cleaning (…sorry). This guide was made with the Half-Life modification Natural Selection in mind and will probably not be applicable to other games.

 

IMPORTANT: MAKE BACKUPS OF YOUR DEMOS BEFORE ATTEMPTING TO DO ANYTHING DESCRIBED IN THIS GUIDE

 

1. Download XVI32 (or a similar HEX editor).

 

2. Install XVI32.

 

3. Open the demo you want to fix with XVI32.

 

4. Click CTRL+R (opens up the search and replace box).

 

5. Follow the illustrated examples:

 

(Click Replace all)

 

Find: +showmap, Replace with: -showmap

 

Find: +showscores, Replace with: -showscores

 

Find: +popupmenu, Replace with: -popupmenu

 

Save the squeaky clean demo

 

Easy peasy eh? Once you realize you may have to do this to more than 30 demos for a decent length movie you might not feel so cocky however…