R51 at 14:41, 17 November 2015

2015-11-17T14:41:04Z

← Older revision		Revision as of 14:41, 17 November 2015
Line 9:		Line 9:
	SQL:		SQL:
	<pre>-- create the game name conversion		<pre>-- create the game name conversion
	INSERT INTO ~~`grave_con`.~~`game_name_conversion` (`sort`, `game_name`, `game_abbrev`) VALUES ('60', 'Bravely Default', 'BD');		INSERT INTO `game_name_conversion` (`sort`, `game_name`, `game_abbrev`) VALUES ('60', 'Bravely Default', 'BD');

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

R51: Created page with "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 ne..."

2015-11-16T23:32:03Z

Created page with "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 ne..."

New page

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:
<pre>-- 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'
);
</pre>

Add Fanart Game - Revision history

R51 at 14:41, 17 November 2015

R51: Created page with "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 ne..."