- Joined
- Feb 2, 2010
- Messages
- 1,742
- Reaction score
- 264
Hey again! I just made some sql's for the Straypixel furnitures.
Image:
Catalog_Page:
Catalog_Items:
Furniture:
Credits goes to me for making the SQL for them.. And for Sulake for making the furnitures.
Enjoy! And THANK me.
Btw, No flaming or spamming in this thread please. Thanks!
Image:
Catalog_Page:
Code:
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
(497, 3, 'Stray Pixels', 28, 1, '1', '1', 1, '0', '0', 7, 'default_3x3', 'Stray Pixel', '', '', 'Stray Pixel', '', '', '');
Catalog_Items:
Code:
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES
(10289, 497, '10289', 'easel_0', 25, 0, 1),
(10290, 497, '10290', 'easel_1', 25, 0, 1),
(10291, 496, '10291', 'easel_2', 25, 0, 1),
(10292, 497, '10292', 'easel_3', 25, 0, 1),
(10293, 497, '10293', 'easel_4', 25, 0, 1),
(10294, 497, '10294', 'easel_2', 25, 0, 1);
Furniture:
Code:
INSERT INTO `furniture` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`) VALUES
(10289, 'easel_0', 'easel_0', 's', 1, 1, 1, '0', '0', '0', 3582, '1', '1', '1', '1', '1', 'default', 2, '0'),
(10290, 'easel_1', 'easel_1', 's', 1, 1, 1, '0', '0', '0', 3594, '1', '1', '1', '1', '1', 'default', 3, '0'),
(10291, 'easel_2', 'easel_2', 's', 1, 1, 1, '0', '0', '0', 3603, '1', '1', '1', '1', '1', 'default', 3, '0'),
(10292, 'easel_3', 'easel_3', 's', 1, 1, 1, '1', '0', '0', 3596, '1', '1', '1', '1', '1', 'default', 6, '0'),
(10293, 'easel_4', 'easel_4', 's', 1, 1, 1, '0', '0', '0', 3600, '1', '1', '1', '1', '1', 'default', 5, '0'),
(10294, 'easel_2', 'easel_2', 's', 1, 1, 1, '0', '0', '0', 3603, '1', '1', '1', '1', '1', 'default', 6, '0');
Credits goes to me for making the SQL for them.. And for Sulake for making the furnitures.
Enjoy! And THANK me.
Btw, No flaming or spamming in this thread please. Thanks!