Mediabot

After a long (very long) refactoring campaign, Mediabot finally migrated most of its command handling to a proper Context-based architecture.

Yes, this includes:

• removing years of implicit state,
• surviving strict mode,
• fixing bugs that existed longer than some IRC networks,
• and arguing endlessly with ChatGPT (which sometimes won, often didn’t).

The bot is now running in production on:

• Undernet (as historical mediabot and as a separate ubot),
• Epiknet (#gabou, #35+ans),

and surprisingly… it mostly works.

There are still rough edges, but the hard part is done. Future me will be thankful. Probably.

ALTER TABLE CHANNEL_PURGED ADD COLUMN purged_by VARCHAR(255) DEFAULT NULL; ALTER TABLE CHANNEL_PURGED ADD COLUMN purged_at DATETIME DEFAULT CURRENT_TIMESTAMP;

I had to do this for a long time, sorry guys

ALTER TABLE CHANNEL_LOG MODIFY ts DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;

ALTER TABLE RESPONDERS MODIFY responder VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY answer TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE CHANNEL MODIFY name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;