Frank
c63af7becc
Hints used to be 11 hardcoded PHP strings/thresholds in
SendMainframeHintsCommand, walked through a fixed if/else chain. They
are now Hint rows (game, condition, thresholdSeconds, message,
sortOrder) manageable at /admin/games/{game}/hints - freely
addable, removable, and reorderable per game, which sets up exactly
what's needed for difficulty-dependent hint timing later (Easy/Medium/
Hard are separate games, so each gets its own hint set).
The condition a hint fires behind (e.g. "hasn't used help yet",
"isn't verified yet") is still a fixed, code-defined check
(HintCondition enum) tied to real game state - a true free-form
condition editor would need a full rules engine, which is out of
scope. What's fully free-form is which hints exist, in what order,
gated behind which of those conditions, with what wording and timing.
SendMainframeHintsCommand now reads hints from the DB: walking them in
sortOrder, it finds the first distinct condition still unresolved for
a player, fires the most-escalated hint sharing that condition whose
threshold has passed, and stops - matching the original "stop at the
first unresolved, dependent step" behavior.
Migration seeds every existing game with the previous hardcoded
hints so behavior doesn't regress on deploy. Two minor fidelity
simplifications from the original hardcoded logic, called out here
since they're easy to miss: the "go to rapports directory" hint no
longer additionally checks whether the player is already in that
folder, and the two chat hints are now independent conditions
(broadcast done / contacted everyone privately) instead of one
combined check - both are edge-case-only behavior changes, not
regressions in the common path.
54 lines
3.2 KiB
PHP
54 lines
3.2 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace DoctrineMigrations;
|
|
|
|
use Doctrine\DBAL\Schema\Schema;
|
|
use Doctrine\Migrations\AbstractMigration;
|
|
|
|
final class Version20260810140000 extends AbstractMigration
|
|
{
|
|
public function getDescription(): string
|
|
{
|
|
return 'Create hint table and seed it with the previously-hardcoded mainframe hints for every existing game';
|
|
}
|
|
|
|
public function up(Schema $schema): void
|
|
{
|
|
$this->addSql('CREATE TABLE hint (id INT AUTO_INCREMENT NOT NULL, game_id INT NOT NULL, hint_condition VARCHAR(30) NOT NULL, threshold_seconds INT NOT NULL, message LONGTEXT NOT NULL, sort_order INT NOT NULL, INDEX IDX_HINT_GAME (game_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
|
|
$this->addSql('ALTER TABLE hint ADD CONSTRAINT FK_HINT_GAME FOREIGN KEY (game_id) REFERENCES `game` (id) ON DELETE CASCADE');
|
|
|
|
// Seed every existing game with the hints that used to be hardcoded in
|
|
// SendMainframeHintsCommand, so behavior doesn't regress the moment the
|
|
// command switches to reading from this table.
|
|
$seed = [
|
|
['help_used', 120, 'Have you already checked which functions are available to you through the help command?', 10],
|
|
['broadcast_done', 300, 'You should establish communications with your fellow agents.', 20],
|
|
['contacted_all_privately', 420, 'The AI virus can see all communication if you are using open communication channels. Make sure you send private messages to all other agents as well, so I know you can.', 30],
|
|
['verified', 600, 'You need the help of your fellow agents to verify you. If both other agents have helped you in your verification, i can get you more rights. The help command might give you some more information.', 40],
|
|
['verified', 780, 'You are still not verified! Please get your verification codes from your colleagues so you can verify.', 50],
|
|
['left_home_directory', 900, 'You can change the folder you are working in. Check the help command for more information', 60],
|
|
['all_decoded', 1020, 'You should go to the rapports directory to check out the rapports.', 70],
|
|
['all_decoded', 1140, "Not all messages can be decoded by every agent. Every agent has their own personal decoding method. If you can't decode a message, maybe a colleague can.", 80],
|
|
['none', 1380, 'Have you checked out the help command to see what you can do?', 90],
|
|
['none', 1560, 'HURRY! The AI virus is almost done decoding the last files before it will send everything out!', 100],
|
|
['none', 1680, 'Please remove the files soon! The AI virus can not win! It will be a disaster if it does!', 110],
|
|
];
|
|
|
|
foreach ($seed as [$condition, $threshold, $message, $sortOrder]) {
|
|
$this->addSql(
|
|
'INSERT INTO hint (game_id, hint_condition, threshold_seconds, message, sort_order) '
|
|
. 'SELECT id, ?, ?, ?, ? FROM `game`',
|
|
[$condition, $threshold, $message, $sortOrder]
|
|
);
|
|
}
|
|
}
|
|
|
|
public function down(Schema $schema): void
|
|
{
|
|
$this->addSql('ALTER TABLE hint DROP FOREIGN KEY FK_HINT_GAME');
|
|
$this->addSql('DROP TABLE hint');
|
|
}
|
|
}
|