UPDATE mybb_posts
SET message = REPLACE(REPLACE(REPLACE(message, 'DarkCyan', 'LightSeaGreen'), '#afeeee', 'LightSeaGreen'), '#00A5A5', 'LightSeaGreen')
WHERE
uid IN (14643, 18600, 19084, 20092, 23280, 28171, 30538, 30731, 31442, 31541, 31584, 31716, 31717, 32732, 32747, 31753, 33261, 33320, 33435, 33653, 33682, 18600, 33079, 16014, 18060, 23861, 19336, 19948, 31553, 32855, 16170, 3584, 16985, 20144, 18725, 24981, 31157, 16686, 25821, 32173, 32882, 88, 9923, 4776, 20585, 18378, 30937, 28325, 22842, 12849, 22610, 27687, 15331, 17979, 15111, 34686, 35644, 20092, 30538, 18954, 26439, 9237, 20263, 28171, 33320, 31541, 23917, 21406, 17193, 33435, 34009, 33261, 14542, 16751, 4473, 16606, 16774, 18817, 34240, 32732, 32747, 33653, 33991, 33682, 4907, 4738, 4535, 5255, 5161, 9412, 10405, 11287, 16301, 7739, 18992, 19158, 19674, 18677, 14232, 7508, 6035, 27663, 25358, 31303, 34843, 34558, 6088, 18602, 12028, 923, 14545, 23588, 30242, 11356, 34990, 35068, 19084, 23280, 30731, 31717, 31716, 31753, 34650, 18853)
AND message <> REPLACE(REPLACE(REPLACE(message, 'DarkCyan', 'LightSeaGreen'), '#afeeee', 'LightSeaGreen'), '#00A5A5', 'LightSeaGreen');

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (message <> REPLACE(REPLACE(REPLACE(message, 'DarkCyan', 'LightSeaGreen'), '' at line 2

Battleship availability is a tough one. Whilst the Unioners according to the lore we’ve set out have the technical means to access battleships and technically have the blueprints for one battleship model, I’m leery of the concept of power creep and it pervading the faction and what we’re trying to do with it, so most of the role-play we set out on the subject was over the Donau and Oder, but the possibility was always there in the sidelines. We discussed very early on the possibility of roleplaying battleships, but we didn’t want to give people the impression that we were roleplaying only for an end goal. Unioner shipbuilders consider themselves the descendants of those who once forged the Rheinland Imperial Navy, and wear that banner with absolute pride. Just as there are Ideologically motivated, militarised Hessians, and Hessians who behave as common pirates and smugglers, there are all spectrums of Unioners. A battleship would ultimately represent the absolute peak - the top end of the more ideologically oriented spectra.



Tactically, we regard the Unioners to be at an inferior level of mobilisation to the Red Hessians and SCRA (which we’re setting up as their primary unlawful antagonists), whilst they’re at a similar level of influence over the Rheinland underworld. It’s conceivable that the Unioners, in a time of desperation, could deploy one or two battleships - but they would be limited and rare - and currently, there are none in existence.

I think the inclusion of battleships, if done right, could not only be harmless but very much advantageous to gameplay - if done in a limited manner. It would have to be OFL only, and would be extremely tightly regulated within the OFL. I.E: Basically only 1ic and 2ics fly them, and under incredibly regulated circumstances (such as attacks into Omega 54 and Texas), where they would be fitting considering the weight class of vessels that they would commonly expect to attack. They would be hung up by their bulk in other locations, owing to the fact that the majority of Unioner bases are in asteroid fields of varying densities.

So I’d go for: Yes, battleship is acceptable in very limited amounts against the SCRA, Hessians, and possibly in Liberty (all of which are factions that have battleships to field on their own terms). Scrutiny would be on OFL Unioners to make sure they don’t screw it up and make a mess of them - which, of course, would naturally lead to perk revocation.


There are functional gameplay possibilities in having battleship access. For one, balanced, multi-class capital ship fights against the Hessians would be possible. We’ve tried to keep up the tradition of long, pervasive conflicts in the Texas system as well. Such a perk would have the potential to bring back old memories.

Mind you, the primary objective of the perk was the Donau and the Oder. Battleships would simply be another tool at the OFL’s disposal to use as an RP platform - role-play the construction of in times of absolute, purest need against the Red Hessians as part of the defence of the Koeln theatre. It would play well into the apocalyptic themes that we’re crafting for the Unioners, and the intent to treat them as counterweights to the Hessians within Rheinland itself.