- 9 Febbraio 2014
- 14
- 0
- Miglior risposta
- 0
Salve a tutti sciaxini.. vorrei capire come creare catalog_pages avendo catalog_items e furniture dei miei furni sql.
Ad esempio io ho questo catalog_items: Catalog_items
Codice PHP:
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES
(20500, 'PAGEID', '20500', 'fball_trophybrasil_silver', '100', '0', '0', '1'),
(20501, 'PAGEID', '20501', 'fball_trophybrasil_gold', '100', '0', '0', '1'),
(20503, 'PAGEID', '20503', 'Lfball_ball6', '100', '0', '0', '1'),
(20504, 'PAGEID', '20504', 'fball_audbench2', '100', '0', '0', '1'),
(20508, 'PAGEID', '20508', 'fball_trophybrasil_bronze', '100', '0', '0', '1'),
(20510, 'PAGEID', '20510', 'stories_football_board', '100', '0', '0', '1'),
(20511, 'PAGEID', '20511', 'stories_football_table', '100', '0', '0', '1');
E questa furniture: Codice PHP:
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`, `is_arrow`) VALUES
(20500, 'fball_trophybrasil_silver', 'fball_trophybrasil_silver', 's', 1, 1, 1, '0', '0', '0', 20500, '1', '1', '1', '1', '1', 'trophy', 2, '0', '0'),
(20501, 'fball_trophybrasil_gold', 'fball_trophybrasil_gold', 's', 1, 1, 1, '0', '0', '0', 20501, '1', '1', '1', '1', '1', 'trophy', 2, '0', '0'),
(20503, 'fball_ball6', 'fball_ball6', 's', 1, 1, 1, '0', '0', '0', 20503, '1', '1', '1', '1', '1', 'ball', 1, '0', '0'),
(20504, 'fball_audbench2', 'fball_audbench2', 's', 1, 1, 1, '0', '0', '0', 20504, '1', '1', '1', '1', '1', 'Default', 1, '0', '0'),
(20508, 'fball_trophybrasil_bronze', 'fball_trophybrasil_bronze', 's', 1, 1, 1, '0', '0', '0', 20508, '1', '1', '1', '1', '1', 'trophy', 2, '0', '0'),
(20510, 'stories_football_board', 'stories_football_board', 's', 1, 1, 1, '0', '0', '0', 20510, '1', '1', '1', '1', '1', 'Default', 1, '0', '0'),
(20511, 'stories_football_table', 'stories_football_table', 's', 1, 1, 1, '0', '0', '0', 20511, '1', '1', '1', '1', '1', 'Default', 1, '0', '0');
COME FACCIO CON QUESTI VALORI, AVENDO ANCHE FURNIDATA E PRODUCTDATA, A CREARE CATALOG_PAGES?
Ad esempio io ho questo catalog_items: Catalog_items
Codice PHP:
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES
(20500, 'PAGEID', '20500', 'fball_trophybrasil_silver', '100', '0', '0', '1'),
(20501, 'PAGEID', '20501', 'fball_trophybrasil_gold', '100', '0', '0', '1'),
(20503, 'PAGEID', '20503', 'Lfball_ball6', '100', '0', '0', '1'),
(20504, 'PAGEID', '20504', 'fball_audbench2', '100', '0', '0', '1'),
(20508, 'PAGEID', '20508', 'fball_trophybrasil_bronze', '100', '0', '0', '1'),
(20510, 'PAGEID', '20510', 'stories_football_board', '100', '0', '0', '1'),
(20511, 'PAGEID', '20511', 'stories_football_table', '100', '0', '0', '1');
E questa furniture: Codice PHP:
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`, `is_arrow`) VALUES
(20500, 'fball_trophybrasil_silver', 'fball_trophybrasil_silver', 's', 1, 1, 1, '0', '0', '0', 20500, '1', '1', '1', '1', '1', 'trophy', 2, '0', '0'),
(20501, 'fball_trophybrasil_gold', 'fball_trophybrasil_gold', 's', 1, 1, 1, '0', '0', '0', 20501, '1', '1', '1', '1', '1', 'trophy', 2, '0', '0'),
(20503, 'fball_ball6', 'fball_ball6', 's', 1, 1, 1, '0', '0', '0', 20503, '1', '1', '1', '1', '1', 'ball', 1, '0', '0'),
(20504, 'fball_audbench2', 'fball_audbench2', 's', 1, 1, 1, '0', '0', '0', 20504, '1', '1', '1', '1', '1', 'Default', 1, '0', '0'),
(20508, 'fball_trophybrasil_bronze', 'fball_trophybrasil_bronze', 's', 1, 1, 1, '0', '0', '0', 20508, '1', '1', '1', '1', '1', 'trophy', 2, '0', '0'),
(20510, 'stories_football_board', 'stories_football_board', 's', 1, 1, 1, '0', '0', '0', 20510, '1', '1', '1', '1', '1', 'Default', 1, '0', '0'),
(20511, 'stories_football_table', 'stories_football_table', 's', 1, 1, 1, '0', '0', '0', 20511, '1', '1', '1', '1', '1', 'Default', 1, '0', '0');
COME FACCIO CON QUESTI VALORI, AVENDO ANCHE FURNIDATA E PRODUCTDATA, A CREARE CATALOG_PAGES?