[SQL] Infobus 20.03.16 6:36
Eae galera do Power-pixel, hoje venho trazer á [SQL] Infobus, Caso você deseja querer usar este SQL, observe se você tem "Quartos Oficiais ou Publicos" e "Funciona em Phoenix e New Crypto".
Navigator_Publics:
Rooms:
INSERT INTO `rooms` (`id`, `roomtype`, `caption`, `owner`, `description`, `category`, `state`, `users_now`, `users_max`, `model_name`, `public_ccts`, `score`, `tags`, `icon_bg`, `icon_fg`, `icon_items`, `password`, `wallpaper`, `floor`, `landscape`, `allow_pets`, `allow_pets_eat`, `allow_walkthrough`, `allow_hidewall`) VALUES
(COLOQUE AQUI O ID DO QUARTO PUBLICO , 'public', 'Infobus', '', 'Mis de bus niet!', 0, 'open', 0, 50, 'park_b', 'hh_room_park,hh_room_park_uk', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0')
Room_models:
INSERT INTO `room_models` (`id`, `door_x`, `door_y`, `door_z`, `door_dir`, `heightmap`, `public_items`, `club_only`) VALUES
('park', 11, 2, 0, 6, '0000x0000000\r\n0000xx000000\r\n000000000000\r\n00000000000x\r\n000000000000\r\n00x0000x0000', 'QDHC00cornerchair2HHHPAHB01cornerchair1IHHPAHA02chair1JHHPAHA03chair1KHHPAHH05table1QAHHPAHE06chair1lineRAHHPAHA07chair1SAHHPAHF08chair1frontendPBHHPAHJ010hububarRBHHPAHB10cornerchair1HIHJHA20chair1HJHJHA30chair1HKHJHA40chair1HPAHJHF50chair1frontendHQAHJHI53table2KQAHPAHD55modchairQAQAHHHI58table2PBQAHPA', '0')
Navigator_Publics:
- Código:
INSERT INTO `navigator_publics` (`id`, `ordernum`, `bannertype`, `caption`, `image`, `image_type`, `room_id`, `category_parent_id`) VALUES
(8, 8, '2', 'Infobus', 'park', 'internal', 8, 12)
Rooms:
INSERT INTO `rooms` (`id`, `roomtype`, `caption`, `owner`, `description`, `category`, `state`, `users_now`, `users_max`, `model_name`, `public_ccts`, `score`, `tags`, `icon_bg`, `icon_fg`, `icon_items`, `password`, `wallpaper`, `floor`, `landscape`, `allow_pets`, `allow_pets_eat`, `allow_walkthrough`, `allow_hidewall`) VALUES
(COLOQUE AQUI O ID DO QUARTO PUBLICO , 'public', 'Infobus', '', 'Mis de bus niet!', 0, 'open', 0, 50, 'park_b', 'hh_room_park,hh_room_park_uk', 0, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0')
Room_models:
INSERT INTO `room_models` (`id`, `door_x`, `door_y`, `door_z`, `door_dir`, `heightmap`, `public_items`, `club_only`) VALUES
('park', 11, 2, 0, 6, '0000x0000000\r\n0000xx000000\r\n000000000000\r\n00000000000x\r\n000000000000\r\n00x0000x0000', 'QDHC00cornerchair2HHHPAHB01cornerchair1IHHPAHA02chair1JHHPAHA03chair1KHHPAHH05table1QAHHPAHE06chair1lineRAHHPAHA07chair1SAHHPAHF08chair1frontendPBHHPAHJ010hububarRBHHPAHB10cornerchair1HIHJHA20chair1HJHJHA30chair1HKHJHA40chair1HPAHJHF50chair1frontendHQAHJHI53table2KQAHPAHD55modchairQAQAHHHI58table2PBQAHPA', '0')
- Código:
OBSERVAÇÃO: NO "ROOMS' PROCURE POR "Coloque aqui o ID DO QUARTO PUBLICO" E MODIFIQUE POR UM DESSES ID DE QUARTO
http://prntscr.com/ahjzwf // Vá no nome do Quarto que vc modificou e troque por "Infobus"
- Código:
Observação: Caso de erro ao trocar "http://prntscr.com/ahk0zr" volte em rooms "e Apague o quarto que deseja mod-
ificar e Insira a SQL novamente! Depois so ligar emulador e se divertir!
- Código:
PRINTS: http://prntscr.com/ahk1es