SnowStorm Tables [Plus Rev.2]

[trylix]

Hello, I'm trylix and today post the sqls the snow storm to PlusEMU Rev.2 for some users ...

--
-- Estrutura da tabela `snow_items`
--


CREATE TABLE IF NOT EXISTS `snow_items` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `ItemId` int(11) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `X` int(11) NOT NULL,
  `Y` int(11) NOT NULL,
  `Rot` int(11) NOT NULL,
  `SpriteId` int(11) NOT NULL,
  `Extradata` varchar(10) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;


--
-- Extraindo dados da tabela `snow_items`
--


INSERT INTO `snow_items` (`Id`, `ItemId`, `Name`, `X`, `Y`, `Rot`, `SpriteId`, `Extradata`) VALUES
(1, 0, 'snst_ballpile', 8, 14, 1, 320, '0'),
(2, 1, 'snst_ballpile', 36, 30, 1, 320, '0'),
(3, 2, 'snst_iceblock', 22, 25, 1, 3359, ''),
(4, 3, 'snst_ballpile', 36, 21, 1, 320, '0'),
(5, 4, 'snst_iceblock', 22, 17, 1, 3359, ''),
(6, 5, 'snst_ballpile', 22, 23, 1, 320, '0'),
(7, 6, 'snst_ballpile', 36, 27, 1, 320, '0'),
(8, 7, 'snst_ballpile', 16, 21, 1, 320, '0'),
(9, 8, 'snst_iceblock', 9, 29, 1, 3359, ''),
(10, 9, 'snst_iceblock', 35, 18, 1, 3359, ''),
(11, 10, 'snst_ballpile', 8, 29, 1, 320, '0'),
(12, 11, 'snst_iceblock', 9, 17, 1, 3359, ''),
(13, 12, 'snst_iceblock', 9, 23, 1, 3359, ''),
(14, 13, 'snst_iceblock', 35, 27, 1, 3359, ''),
(15, 14, 'snst_ballpile', 36, 18, 1, 320, '0'),
(16, 15, 'snst_ballpile', 36, 24, 1, 320, '0'),
(17, 16, 'snst_ballpile', 28, 21, 1, 320, '0'),
(18, 17, 'snst_ballpile', 8, 17, 1, 320, '0'),
(19, 18, 'snst_ballpile', 36, 15, 1, 320, '0'),
(20, 19, 'snst_iceblock', 35, 15, 1, 3359, ''),
(21, 20, 'snst_ballpile', 24, 21, 1, 320, '0'),
(22, 21, 'snst_ballpile', 8, 23, 1, 320, '0'),
(23, 22, 'ads_background', 0, 22, 1, 0, ''),
(24, 23, 'snst_iceblock', 22, 21, 1, 3359, ''),
(25, 24, 'snst_ballpile', 22, 15, 1, 320, '0'),
(26, 25, 'snst_ballpile', 8, 26, 1, 320, '0'),
(27, 26, 'snst_iceblock', 9, 26, 1, 3359, ''),
(28, 27, 'snst_ballpile', 22, 27, 1, 320, '0'),
(29, 28, 'snst_iceblock', 9, 20, 1, 3359, ''),
(30, 29, 'snst_ballpile', 22, 19, 1, 320, '0'),
(31, 30, 'snst_ballpile', 8, 20, 1, 320, '0'),
(32, 31, 'snst_iceblock', 9, 14, 1, 3359, ''),
(33, 32, 'snst_iceblock', 35, 24, 1, 3359, ''),
(34, 33, 'snst_iceblock', 35, 30, 1, 3359, ''),
(35, 34, 'snst_iceblock', 18, 21, 1, 3359, ''),
(36, 35, 'snst_ballpile', 20, 21, 1, 320, '0'),
(37, 36, 'snst_iceblock', 26, 21, 1, 3359, ''),
(38, 37, 'snst_iceblock', 35, 21, 1, 3359, '');

--
-- Estrutura da tabela `snow_maps`
--


CREATE TABLE IF NOT EXISTS `snow_maps` (
  `id` int(11) NOT NULL,
  `heightmap` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Extraindo dados da tabela `snow_maps`
--


INSERT INTO `snow_maps` (`id`, `heightmap`) VALUES
(1, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxx000000000000000xxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxx00000000000000000xxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxx0000000000000000000xxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxx000000000000000000000xxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxx00000000000000000000000xxxxxxxxxxxxxxxxx\r\nxxxxxxxxx0000000000000000000000000xxxxxxxxxxxxxxxx\r\nxxxxxxxx000000000000000000000000000xxxxxxxxxxxxxxx\r\nxxxxxxx00000000000000000000000000000xxxxxxxxxxxxxx\r\nxxxxxx0000000000000000000000000000000xxxxxxxxxxxxx\r\nxxxxx000000000000000000000000000000000xxxxxxxxxxxx\r\nxxxxx0000000000000000000000000000000000xxxxxxxxxxx\r\nxxxxx00000000000000000000000000000000000xxxxxxxxxx\r\nxxxxx000000000000000000000000000000000000xxxxxxxxx\r\nxxxxx0000000000000000000000000000000000000xxxxxxxx\r\nxxxxx00000000000000000000000000000000000000xxxxxxx\r\nxxxxx000000000000000000000000000000000000000xxxxxx\r\nxxxxx0000000000000000000000000000000000000000xxxxx\r\n0xxxx00000000000000000000000000000000000000000xxxx\r\nxxxxx00000000000000000000000000000000000000000xxxx\r\nxxxxx00000000000000000000000000000000000000000xxxx\r\nxxxxx000000000000000000000000000000000000000000xxx\r\nxxxxx000000000000000000000000000000000000000000xxx\r\nxxxxx000000000000000000000000000000000000000000xxx\r\nxxxxxx00000000000000000000000000000000000000000xxx\r\nxxxxxxx0000000000000000000000000000000000000000xxx\r\nxxxxxxxx0000000000000000000000000000000000000xxxxx\r\nxxxxxxxxx00000000000000000000000000000000000xxxxxx\r\nxxxxxxxxxx000000000000000000000000000000000xxxxxxx\r\nxxxxxxxxxxx00000000000000000000000000000000xxxx0xx\r\nxxxxxxxxxxxx0000000000000000000000000000000xxxxxxx\r\nxxxxxxxxxxxxx00000000000000000000000000000xxxxxxxx\r\nxxxxxxxxxxxxxx0000000000000000000000000000xxxxxxxx\r\nxxxxxxxxxxxxxxx00000000000000000000000000xxxxxxxxx\r\nxxxxxxxxxxxxxxxx0000000000000000000000000xxxxxxxxx\r\nxxxxxxxxxxxxxxxxx00000000000000000000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxx0000000000000000000000xxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxx00000000000000000000xxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxx000000000000000xxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxx0000000000000xxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxx00000000000xxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxx0000000xxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');

--
-- Estrutura da tabela `snow_spawns`
--


CREATE TABLE IF NOT EXISTS `snow_spawns` (
  `map_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Extraindo dados da tabela `snow_spawns`
--


INSERT INTO `snow_spawns` (`map_id`) VALUES
(1);

credits:
I - trylix

sorry for my horrografia.. :s

[MentaL]

[Flare]

Thanks for this!

[Seat]

Useless

[Emily]

Are those items 100% complete? And could you give the real names of the models/maps (and not id 1 but something like model_shithere)?
For me, this is pretty useful. Thanks a lot.

[Mozilla2]

Hey, this is verry useful for me. Thanks!

[Jeanzinh0]

Are those items 100% complete? And could you give the real names of the models/maps (and not id 1 but something like model_shithere)?
For me, this is pretty useful. Thanks a lot.

model_snowwar1 and model_snowwar2 :)

[Squashing]

I think if you have the model name you need to create the map first, you can test it when you create a 'snowstorm' room in the hotel

[Emily]

model_snowwar1 and model_snowwar2 :)

Thanks a lot. This will actually help me a lot :)

[Marlon Colhado]

I think if you have the model name you need to create the map first, you can test it when you create a 'snowstorm' room in the hotel

I tested the tables:

Spoiler:

Perfect! :)

[ovflowd]

Godo release the Tablet, but, its only Tablet, without the structure on the Plus what diference this make?

[Receiver]

I tested the tables:

Spoiler:

Perfect! :)

Cool! Very nice.

[trylix]

Godo release the Tablet, but, its only Tablet, without the structure on the Plus what diference this make?

The Plus already has the initial structure of the snowstorm but still lacks some system, tomorrow I will bring packets of snowstorm updated and secure so you can open the Home panel snowstorm because a part of estrututa is incorrect, will not post today because I'm not on in PC...

Sorry for my horrografia.