Smr\Pages\Player\GalacticPost\PaperDeleteProcessor::build()

Complexity

Conditions	4
Paths	3

Size

Total Lines	20
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php declare(strict_types=1);
	public function build(AbstractSmrPlayer $player): never {
		$db = Database::getInstance();
		// Should we delete this paper?
		if (Request::get('action') == 'Yes') {

			// Should the articles associated with the paper be deleted as well?
			if (Request::get('delete_articles') == 'Yes') {
				$dbResult = $db->read('SELECT * FROM galactic_post_paper_content WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' AND paper_id = ' . $db->escapeNumber($this->paperID));
				foreach ($dbResult->records() as $dbRecord) {
					$db->write('DELETE FROM galactic_post_article WHERE article_id = ' . $db->escapeNumber($dbRecord->getInt('article_id')) . ' AND game_id = ' . $db->escapeNumber($player->getGameID()));
				}
			}

			// Delete the paper and the article associations
			$db->write('DELETE FROM galactic_post_paper WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' AND paper_id = ' . $db->escapeNumber($this->paperID));
			$db->write('DELETE FROM galactic_post_paper_content WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' AND paper_id = ' . $db->escapeNumber($this->paperID));
		}

		$container = new EditorOptions();
		$container->go();
	}