Add a new command that reports the current status of a provided AfC draft.
This command should be protected under the `I` flag.
== Logic ==
1. Check for page existence. If it doesn't exist, try to fuzzy-match to an existing page - add `Draft:` if it doesn't exist, differentiate by case, etc. If more than one found, ask for clarification.
1. Pull all the categories the page is in. Changes to #mediawikiapi_lib will be needed for this
1. Check the categories:
1. if in [[ https://en.wikipedia.org/wiki/Category:Pending_AfC_submissions_being_reviewed_now | Category:Pending AfC submissions being reviewed now ]], then the article is //supposedly// in the middle of being reviewed and we should report this.
1. if in [[ https://en.wikipedia.org/wiki/Category:Pending_AfC_submissions | Category:Pending AfC submissions ]], it's supposed to be in the review queue. See if we can pull the sortkey from the page to check - `C` or `M` probably means something is messed up or it's in the middle of acceptance and we should just report an error. `R` is probably an error as we should have already handled this. `D` should probably be raised as an info point, need to check what other categories a draft is in but otherwise it should be fine to continue with whatever else we find. `P` should contain everything else. There should also be "by date" categories which tell us how long a page has been in the queue for which might be useful to include in a message if we can sanely parse that out. Send a message saying something like `Review waiting for {duration}, please be patient. This may take more than {expected duration}. There are {totaldrafts} drafts currently waiting for review.`
1. if in [[ https://en.wikipedia.org/wiki/Category:Draft_AfC_submissions | Category:Draft AfC submissions ]], it's not currently submitted for review, and report this.
1. if in one of the rejected categories below, do something fancy with it reporting a brief summary of why it was rejected.
1. if in one of the declined categories below, do something fancy with it reporting a brief summary of why it was declined.
== Things to consider ==
* [x] As #hmb is inherently multi-wiki and multi-channel, we probably need a way of either disabling this when not in an enwiki channel.
* [x] Changes to the categories and messages - this shouldn't be hard-coded into the bot in case things change.
* [ ] Figure out how to pull the oldest draft
* Pulling the total number of drafts can be done with the existing command. It (hopefully) pulls from #mediawikiapi_lib anyway, so just do the same sort of call
* Performance - keep an eye on the number of API calls we're doing, as it might add up and impact performance.
== Rejection categories ==
* [[ https://en.wikipedia.org/wiki/Category:Rejected_AfC_submissions | Category:Rejected AfC submissions ]],
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_rejected_as_non-notable | Category:AfC submissions rejected as non-notable ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_rejected_as_unencyclopedic | Category:AfC submissions rejected as unencyclopedic ]]
== Decline categories ==
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_an_advertisement | AfC submissions declined as an advertisement ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_all_plot | AfC submissions declined as all plot ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_already_existing | AfC submissions declined as already existing ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_blank | AfC submissions declined as blank ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_BLP_violations | AfC submissions declined as BLP violations ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_copyright_violations | AfC submissions declined as copyright violations ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_with_a_custom_reason | AfC submissions declined with a custom reason ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_a_dictionary_definition | AfC submissions declined as a dictionary definition ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_a_duplicate | AfC submissions declined as a duplicate ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_an_essay | AfC submissions declined as an essay ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_a_non-notable_film | AfC submissions declined as a non-notable film ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_jokes | AfC submissions declined as jokes ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_lacking_context | AfC submissions declined as lacking context ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_lacking_reliable_third-party_sources | AfC submissions declined as lacking reliable third-party sources ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_needing_footnotes | AfC submissions declined as needing footnotes ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_needing_to_be_merged | AfC submissions declined as needing to be merged ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_a_neologism | AfC submissions declined as a neologism ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_a_news_report_on_a_single_event | AfC submissions declined as a news report on a single event ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_non-notable | AfC submissions declined as non-notable ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_a_non-notable_academic_topic | AfC submissions declined as a non-notable academic topic ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_a_non-notable_athletic_topic | AfC submissions declined as a non-notable athletic topic ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_a_non-notable_biography | AfC submissions declined as a non-notable biography ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_a_non-notable_musical_topic | AfC submissions declined as a non-notable musical topic ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_a_non-notable_organization | AfC submissions declined as a non-notable organization ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_non-notable_web_content | AfC submissions declined as non-notable web content ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_not_in_English | AfC submissions declined as not in English ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_not_suitable_for_Wikipedia | AfC submissions declined as not suitable for Wikipedia ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_not_written_in_a_neutral_point_of_view | AfC submissions declined as not written in a neutral point of view ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_being_previously_deleted | AfC submissions declined as being previously deleted ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_a_redirect | AfC submissions declined as a redirect ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_a_test | AfC submissions declined as a test ]]
* [[ https://en.wikipedia.org/wiki/Category:AfC_submissions_declined_as_being_vandalism_or_attack_pages | AfC submissions declined as being vandalism or attack pages ]]
== Database changes ==
``` lang=sql
CREATE TABLE reviewstatus (
id INT PRIMARY KEY AUTO_INCREMENT,
site INT NOT NULL,
state VARCHAR(20) NOT NULL,
category VARCHAR(250) NOT NULL,
UNIQUE KEY reviewstatus_unique (site, state, category),
CONSTRAINT reviewstatus_site_fk FOREIGN KEY (site) REFERENCES site (site_id)
) ENGINE=InnoDB;
INSERT INTO reviewstatus (site, state, category) VALUES
(1, 'inreview', 'Pending AfC submissions being reviewed now'),
(1, 'draft', 'Draft AfC submissions'),
(1, 'pending', 'Pending AfC submissions'),
(1, 'rejected', 'Rejected AfC submissions'),
(1, 'rejected', 'AfC submissions rejected as non-notable'),
(1, 'rejected', 'AfC submissions rejected as unencyclopedic'),
(1, 'declined', 'AfC submissions declined as an advertisement'),
(1, 'declined', 'AfC submissions declined as all plot'),
(1, 'declined', 'AfC submissions declined as already existing'),
(1, 'declined', 'AfC submissions declined as blank'),
(1, 'declined', 'AfC submissions declined as BLP violations'),
(1, 'declined', 'AfC submissions declined as copyright violations'),
(1, 'declined', 'AfC submissions declined with a custom reason'),
(1, 'declined', 'AfC submissions declined as a dictionary definition'),
(1, 'declined', 'AfC submissions declined as a duplicate'),
(1, 'declined', 'AfC submissions declined as an essay'),
(1, 'declined', 'AfC submissions declined as a non-notable film'),
(1, 'declined', 'AfC submissions declined as jokes'),
(1, 'declined', 'AfC submissions declined as lacking context'),
(1, 'declined', 'AfC submissions declined as lacking reliable third-party sources'),
(1, 'declined', 'AfC submissions declined as needing footnotes'),
(1, 'declined', 'AfC submissions declined as needing to be merged'),
(1, 'declined', 'AfC submissions declined as a neologism'),
(1, 'declined', 'AfC submissions declined as a news report on a single event'),
(1, 'declined', 'AfC submissions declined as non-notable'),
(1, 'declined', 'AfC submissions declined as a non-notable academic topic'),
(1, 'declined', 'AfC submissions declined as a non-notable athletic topic'),
(1, 'declined', 'AfC submissions declined as a non-notable biography'),
(1, 'declined', 'AfC submissions declined as a non-notable musical topic'),
(1, 'declined', 'AfC submissions declined as a non-notable organization'),
(1, 'declined', 'AfC submissions declined as non-notable web content'),
(1, 'declined', 'AfC submissions declined as not in English'),
(1, 'declined', 'AfC submissions declined as not suitable for Wikipedia'),
(1, 'declined', 'AfC submissions declined as not written in a neutral point of view'),
(1, 'declined', 'AfC submissions declined as being previously deleted'),
(1, 'declined', 'AfC submissions declined as a redirect'),
(1, 'declined', 'AfC submissions declined as a test'),
(1, 'declined', 'AfC submissions declined as being vandalism or attack pages');
```