[ Pedido Quarto Oficial ]

Ola Pessoal Estou a Procura de uma Sql do Info Bus Aki Ja Testei Todas dão erro Então é isso Postem Varios Quartos Oficiais Incluindo Info bus

@ Obs: A Maioria dos quartos publicos que Postaram aki ja Puis no Meu Hotel mas Kero Inovação Novos Quartos

Olá, aqui tem:

Código:

INSERT INTO `navigator_publics` (`id`, `ordernum`, `bannertype`, `caption`, `image`, `image_type`, `room_id`, `category_parent_id`) VALUES
(8, 8, '1', 'Infobus', 'park', 'internal', 8, 12)


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
(8, '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');


INSERT INTO `room_models` (`id`, `door_x`, `door_y`, `door_z`, `door_dir`, `heightmap`, `public_items`, `club_only`) VALUES
('park_b', 11, 2, 0, 6, '0000x0000000\r\n0000xx000000\r\n000000000000\r\n00000000000x\r\n000000000000\r\n00x0000x0000', 'QDHC00cornerchair2HHHPAHB01cornerchair1IHHPAHA02chair1JHHPAHA03chair1KHHPAHH05table1QAHHPAHE06chair1lineRAHHPAHA07chair1SAHHPAHF08chair1frontendPBHHPAHJ010hububarRBHHPAHB10cornerchair1HIHJHA20chair1HJHJHA30chair1HKHJHA40chair1HPAHJHF50chair1frontendHQAHJHI53table2KQAHPAHD55modchairQAQAHHHI58table2PBQAHPA', '0');

Colocar em SQL's

Maradinho Quando Fui add A Sql Rooms Apareceu o Seguinte erro

#1062 - Duplicate entry '8' for key 'PRIMARY'

Oq Pod Ser Isso

Olá, leia este tópico:
https://www.power-pixel.net/t807-

Olá isso e Erros Com Codigos Percistentes Melhores Informações Leia o Topico Seguinte

https://www.power-pixel.net/t807-adicionando-espacos-publicos-no-seu-habbo

Atéé.

Tente apagar os quartos que tenham o ID 8 e recoloque este código.

Código:


INSERT INTO `navigator_publics` (`id`, `ordernum`, `bannertype`, `caption`, `image`, `image_type`, `room_id`, `category_parent_id`) VALUES
(8, 8, '1', 'Infobus', 'park', 'internal', 8, 12)


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
(8, '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');


INSERT INTO `room_models` (`id`, `door_x`, `door_y`, `door_z`, `door_dir`, `heightmap`, `public_items`, `club_only`) VALUES
('park_b', 11, 2, 0, 6, '0000x0000000\r\n0000xx000000\r\n000000000000\r\n00000000000x\r\n000000000000\r\n00x0000x0000', 'QDHC00cornerchair2HHHPAHB01cornerchair1IHHPAHA02chair1JHHPAHA03chair1KHHPAHH05table1QAHHPAHE06chair1lineRAHHPAHA07chair1SAHHPAHF08chair1frontendPBHHPAHJ010hububarRBHHPAHB10cornerchair1HIHJHA20chair1HJHJHA30chair1HKHJHA40chair1HPAHJHF50chair1frontendHQAHJHI53table2KQAHPAHD55modchairQAQAHHHI58table2PBQAHPA', '0');




e siga este tutorial.

Código:

http://www.power-pixel.net/t807-adicionando-espacos-publicos-no-seu-habbo