Add Fanart Game

Adding a new game for fanart requires some fairly hacky work. It's not yet documented, and isn't done that often, hence this page. These are the steps necessary to create a new game for fanart.

1. Add the game to the game_name_conversion table. This table is stupid but not using it requires a lot of rework for fanart. 2. Add the game similarly to common.php's configuration of game names and shortnames. 3. Add the game subjects to the fanart_subjects table to preload a few for submission. 4. Add the game to fanart/submit.php's checkboxes, using the game's abbreviation as the value for the form checkbox. 5. Images for Persona Modern, Persona Classic, Scanner Classic

SQL:

-- create the game name conversion
INSERT INTO `grave_con`.`game_name_conversion` (`sort`, `game_name`, `game_abbrev`) VALUES ('60', 'Bravely Default', 'BD');

-- create some fanart subjects
INSERT INTO  `grave_con`.`fanart_subjects` (
`subject_id` ,
`game` ,
`subject`
)
VALUES (
NULL ,  'BD',  'Agnes'
), (
NULL ,  'BD',  'Tiz'
), (
NULL ,  'BD',  'Edea'
), (
NULL ,  'BD',  'Ringabel'
);