8 lines
4.4 KiB
SQL
8 lines
4.4 KiB
SQL
ALTER TABLE snarbolax_projectxdb.gates MODIFY wheels TEXT NOT NULL;
|
|
|
|
INSERT INTO `gates` (`gateId`, `internalId`, `name`, `icon`, `backgroundColorization`, `iconColorization`, `priority`, `tokens`, `flags`, `sourceId`, `sourcePortal`, `destinationId`, `depth`, `wheels`, `description`) VALUES (1, 'training_1', 'm.training_1', 'pawn', '<?xml version=\"1.0\" encoding=\"UTF-8\"?><java class=\"com.threerings.export.XMLImporter\" version=\"1.0\">\r\n<object class=\"com.threerings.opengl.renderer.config.ColorizationConfig$Normal\">\r\n<colorization>787</colorization>\r\n</object>\r\n</java>','<?xml version=\"1.0\" encoding=\"UTF-8\"?><java class=\"com.threerings.export.XMLImporter\" version=\"1.0\">\r\n<object class=\"com.threerings.opengl.renderer.config.ColorizationConfig$Normal\">\r\n<colorization>532</colorization>\r\n</object>\r\n</java>', 0, 0, 0, 1, 'from_training_1', 0, 0, '<?xml version=\"1.0\" encoding=\"UTF-8\"?><java class=\"com.threerings.export.XMLImporter\" version=\"1.0\"><object class=\"[Lcom.github.thetya.server.dungeon.data.GateData$Wheel;\"><entry class=\"com.github.thetya.server.dungeon.data.GateData$Constant\"><wedges><entry class=\"com.github.thetya.server.dungeon.data.GateData$Lobby\"><levelId>1</levelId><depthOffset>1</depthOffset></entry></wedges><lengths>6.2831855</lengths></entry><entry class=\"com.github.thetya.server.dungeon.data.GateData$Constant\"><wedges><entry class=\"com.github.thetya.server.dungeon.data.GateData$Level\"><levelId>3</levelId><depthOffset>1</depthOffset></entry></wedges><lengths>6.2831855</lengths></entry></object></java>', 'm.training_1_desc');
|
|
|
|
INSERT INTO `gates` (`gateId`, `internalId`, `name`, `icon`, `backgroundColorization`, `iconColorization`, `priority`, `tokens`, `flags`, `sourceId`, `sourcePortal`, `destinationId`, `depth`, `wheels`, `description`) VALUES (2, 'tutorial', '~Tutorial Gate', 'locked', '<?xml version=\"1.0\" encoding=\"UTF-8\"?><java class=\"com.threerings.export.XMLImporter\" version=\"1.0\"> <object class=\"com.threerings.opengl.renderer.config.ColorizationConfig$Normal\"><colorization>772</colorization></object></java>','<?xml version=\"1.0\" encoding=\"UTF-8\"?><java class=\"com.threerings.export.XMLImporter\" version=\"1.0\"><object class=\"com.threerings.opengl.renderer.config.ColorizationConfig$Normal\"><colorization>515</colorization></object></java>', 0, 0, 1, 0, '', 0, 0, '<?xml version=\"1.0\" encoding=\"UTF-8\"?><java class=\"com.threerings.export.XMLImporter\" version=\"1.0\"> <object class=\"[Lcom.github.thetya.server.dungeon.data.GateData$Wheel;\"><entry class=\"com.github.thetya.server.dungeon.data.GateData$Constant\"><wedges><entry class=\"com.github.thetya.server.dungeon.data.GateData$Level\"> <levelId>2</levelId><depthOffset>2</depthOffset></entry></wedges><lengths>6.2831855</lengths></entry></object></java>','~New knights are sent to this gate to start their journey with Spiral Knights.');
|
|
|
|
INSERT INTO `gates` (`gateId`, `internalId`, `name`, `icon`, `backgroundColorization`, `iconColorization`, `priority`, `tokens`, `flags`, `sourceId`, `sourcePortal`, `destinationId`, `depth`, `wheels`, `description`) VALUES (3, 'final_test_gate', 'm.final_test_gate', 'arrow_down', '<?xml version=\"1.0\" encoding=\"UTF-8\"?><java class=\"com.threerings.export.XMLImporter\" version=\"1.0\">\n<object class=\"com.threerings.opengl.renderer.config.ColorizationConfig$Normal\">\n<colorization>524</colorization>\n</object>\n</java>','<?xml version=\"1.0\" encoding=\"UTF-8\"?><java class=\"com.threerings.export.XMLImporter\" version=\"1.0\">\n<object class=\"com.threerings.opengl.renderer.config.ColorizationConfig$Normal\">\n<colorization>779</colorization>\n</object>\n</java>', 0, 0, 0, 1, '', 2, 0, '<?xml version=\"1.0\" encoding=\"UTF-8\"?><java class=\"com.threerings.export.XMLImporter\" version=\"1.0\"><object class=\"[Lcom.github.thetya.server.dungeon.data.GateData$Wheel;\"><entry class=\"com.github.thetya.server.dungeon.data.GateData$Constant\"><wedges><entry class=\"com.github.thetya.server.dungeon.data.GateData$Lobby\"><levelId>1</levelId><depthOffset>1</depthOffset></entry></wedges><lengths>6.2831855</lengths></entry><entry class=\"com.github.thetya.server.dungeon.data.GateData$Constant\"><wedges><entry class=\"com.github.thetya.server.dungeon.data.GateData$Level\"><levelId>4</levelId><depthOffset>1</depthOffset></entry></wedges><lengths>6.2831855</lengths></entry></object></java>', 'm.final_test_desc');
|