terça-feira, 8 de novembro de 2011

Colocando Novos Mobis


Furniture:

(91037, 'sb_cans', 'sb_cans', 's', 1, 1, 1, '1', '0', '0', 4033, '1', '1', '1', '1', '1', 'vendingmachine', 1, '22, 26'),
(91038, 'sb_tag1', 'sb_tag1', 'i', 1, 1, 1, '0', '0', '0', 4406, '1', '1', '1', '1', '1', 'default', 2, '0'),
(91039, 'sb_tag2', 'sb_tag2', 'i', 1, 1, 1, '0', '0', '0', 4408, '1', '1', '1', '1', '1', 'default', 2, '0'),
(91040, 'sb_tag3', 'sb_tag3', 'i', 1, 1, 1, '0', '0', '0', 4409, '1', '1', '1', '1', '1', 'default', 2, '0'),
(91041, 'sb_tile', 'sb_tile', 's', 2, 2, 0.1, '1', '0', '1', 4034, '1', '1', '1', '1', '1', 'default', 1, '0'),
(91042, 'sb_wall', 'sb_wall', 'i', 1, 1, 1, '0', '0', '0', 4407, '1', '1', '1', '1', '1', 'default', 2, '0'),
(91031, 'prizetrophy_skate*1', 'prizetrophy_skate*1', 's', 1, 1, 1, '0', '0', '0', 4027, '1', '1', '1', '1', '1', 'trophy', 1),
(91032, 'prizetrophy_skate*2', 'prizetrophy_skate*2', 's', 1, 1, 1, '0', '0', '0', 4028, '1', '1', '1', '1', '1', 'trophy', 1),
(91033, 'prizetrophy_skate*3', 'prizetrophy_skate*3', 's', 1, 1, 1, '0', '0', '0', 4029, '1', '1', '1', '1', '1', 'trophy', 1),
(91034, 'sb_block', 'sb_block', 's', 2, 2, 0.7, '1', '0', '1', 4032, '1', '1', '1', '1', '1', 'default', 2),
(91035, 'sb_rail', 'sb_rail', 's', 1, 1, 0.5, '1', '0', '1', 4030, '1', '1', '1', '1', '1', 'default', 2),
(91036, 'sb_ramp', 'sb_ramp', 's', 2, 2, 1, '1', '0', '1', 4031, '1', '1', '1', '1', '1', 'default', 2);




Catalog_items:

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES
(91037, '389', '91037', 'sb_cans', '3', '0', '1'),
(91038, '389', '91038', 'sb_tag1', '3', '0', '1'),
(91039, '389', '91039', 'sb_tag2', '3', '0', '1'),
(91040, '389', '91040', 'sb_tag3', '3', '0', '1'),
(91041, '389', '91041', 'sb_tile', '3', '0', '1'),
(91042, '389', '91042', 'sb_wall', '3', '0', '1'),
(91031, '389', '91031', 'prizetrophy_skate*1', '5', '0', '1'),
(91032, '389', '91032', 'prizetrophy_skate*2', '5', '0', '1'),
(91033, '389', '91033', 'prizetrophy_skate*3', '5', '0', '1'),
(91034, '389', '91034', 'sb_block', '3', '0', '1'),
(91035, '389', '91035', 'sb_rail', '3', '0', '1'),
(91036, '389', '91036', 'sb_ramp', '3', '0', '1');


Catalog_Page:


INSERT INTO
`catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`,
`icon_image`, `visible`, `enabled`, `min_rank`, `club_only`,
`coming_soon`, `order_num`, `page_layout`, `page_headline`,
`page_teaser`, `page_special`, `page_text1`, `page_text2`,
`page_text_details`, `page_text_teaser`) VALUES
(389, 3, 'Skate', 1, 122, '1', '1', 1, '0', '0', 389, 'default_3x3',
'catalog_spe_headline1_es', 'urban_teaser_es', '', '', '', 'Clique no item para mais informações', '');




OBS: Se der erro faltando a tabela "coming_soon", adicione este código no catalog_page e insira o código do catalog_page novamente !



ALTER TABLE `catalog_pages` ADD `coming_soon` enum('0','1') NOT NULL DEFAULT '0'

0 comentários:

Postar um comentário