Valentines 2013 (BCStorm + Phoenix)

Page 1 of 3 123 LastLast
Results 1 to 15 of 37
  1. 05-02-13 #1
    Spheral
    Eye Eye Capt'n Spheral is offline
    MemberRank
    May 2010 Join Date
    TumptonshireLocation
    2,488Posts

    Valentines 2013 (BCStorm + Phoenix)

    Since the previous thread, was youknow, a bit dodgey, i made a quick one myself.
    The interaction_mode_count (Phoenix) and cycle_count (BCStorm) need to be updated






    Bcstorm SQLs
    -------
    Items_base
    -------
    Code:
    INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55496', '4860', 'val13_build_3', 'val13_build_3', 's', '1', '2', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');
INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55497', '4861', 'val13_gond_post', 'val13_gond_post', 's', '1', '1', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');
INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55498', '4862', 'val13_gond_mid1', 'val13_gond_mid1', 's', '2', '1', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');
INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55499', '4863', 'val13_water', 'val13_water', 's', '2', '2', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');
INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55500', '4864', 'val13_div_2', 'val13_div_2', 's', '1', '1', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');
INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55501', '4865', 'val13_gond_front', 'val13_gond_front', 's', '2', '1', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');
INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55502', '4866', 'val13_build_1', 'val13_build_1', 's', '2', '3', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');
INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55503', '4867', 'val13_build_2', 'val13_build_2', 's', '1', '2', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');
INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55504', '4868', 'val13_gond_back', 'val13_gond_back', 's', '2', '1', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');
INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55505', '4869', 'val13_gond_mid2', 'val13_gond_mid2', 's', '2', '1', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');
INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55506', '4870', 'val13_div_1', 'val13_div_1', 's', '1', '1', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');
INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55507', '4478', 'val13_wall_2', 'val13_wall_2', 'i', '0', '0', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');
INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55508', '4479', 'val13_wall_3', 'val13_wall_3', 'i', '0', '0', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');
INSERT INTO `items_base` (`item_id`, `sprite_id`, `public_name`, `item_name`, `type`, `width`, `length`, `height`, `allow_stack`, `allow_walk`, `allow_sit`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `cycle_count`, `vending_ids`) VALUES ('55509', '4480', 'val13_wall_1', 'val13_wall_1', 'i', '0', '0', '1.00', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '0', '0');

    Run these after: (fix for cycle_count)
    Code:
    UPDATE `items_base` SET `cycle_count`='4' WHERE (`item_id`='55509');
UPDATE `items_base` SET `cycle_count`='4' WHERE (`item_id`='55508');
UPDATE `items_base` SET `cycle_count`='4' WHERE (`item_id`='55507');
UPDATE `items_base` SET `cycle_count`='2' WHERE (`item_id`='55506');
UPDATE `items_base` SET `cycle_count`='2' WHERE (`item_id`='55505');
UPDATE `items_base` SET `cycle_count`='2' WHERE (`item_id`='55504');
UPDATE `items_base` SET `cycle_count`='6' WHERE (`item_id`='55503');
UPDATE `items_base` SET `cycle_count`='2' WHERE (`item_id`='55502');
UPDATE `items_base` SET `cycle_count`='2' WHERE (`item_id`='55501');
UPDATE `items_base` SET `cycle_count`='2' WHERE (`item_id`='55500');
UPDATE `items_base` SET `height`='0.1', `allow_stack`='1', `allow_walk`='1' WHERE (`item_id`='55499');
UPDATE `items_base` SET `height`='1', `allow_sit`='1' WHERE (`item_id`='55498');
UPDATE `items_base` SET `cycle_count`='2' WHERE (`item_id`='55498');
UPDATE `items_base` SET `cycle_count`='2' WHERE (`item_id`='55497');
UPDATE `items_base` SET `cycle_count`='2' WHERE (`item_id`='55496');
UPDATE `items_base` SET `allow_sit`='1' WHERE (`item_id`='55505');
    -------
    catalog_items
    -------
    Code:
    INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55496', 'val13_build_3', '3', '0', '1', '0', '0', '0');
INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55497', 'val13_gond_post', '3', '0', '1', '0', '0', '0');
INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55498', 'val13_gond_mid1', '3', '0', '1', '0', '0', '0');
INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55499', 'val13_water', '3', '0', '1', '0', '0', '0');
INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55500', 'val13_div_2', '3', '0', '1', '0', '0', '0');
INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55501', 'val13_gond_front', '3', '0', '1', '0', '0', '0');
INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55502', 'val13_build_1', '3', '0', '1', '0', '0', '0');
INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55503', 'val13_build_2', '3', '0', '1', '0', '0', '0');
INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55504', 'val13_gond_back', '3', '0', '1', '0', '0', '0');
INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55505', 'val13_gond_mid2', '3', '0', '1', '0', '0', '0');
INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55506', 'val13_div_1', '3', '0', '1', '0', '0', '0');
INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55507', 'val13_wall_2', '3', '0', '1', '0', '0', '0');
INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55508', 'val13_wall_3', '3', '0', '1', '0', '0', '0');
INSERT INTO `catalog_items_copy` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`) VALUES ('926', '55509', 'val13_wall_1', '3', '0', '1', '0', '0', '0');
    Phoenix SQLs
    ------
    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`, `is_arrow`, `height_adjustable`) VALUES('55496',  'val13_build_3', 'val13_build_3', 's', '1', '2', '1.00', '0', '0', '0', '4860', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
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`, `height_adjustable`) VALUES('55497',  'val13_gond_post', 'val13_gond_post', 's', '1', '1', '1.00', '0', '0', '0', '4861', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
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`, `height_adjustable`) VALUES('55498',  'val13_gond_mid1', 'val13_gond_mid1', 's', '2', '1', '1.00', '0', '0', '0', '4862', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
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`, `height_adjustable`) VALUES('55499',  'val13_water', 'val13_water', 's', '2', '2', '1.00', '0', '0', '0', '4863', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
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`, `height_adjustable`) VALUES('55500',  'val13_div_2', 'val13_div_2', 's', '1', '1', '1.00', '0', '0', '0', '4864', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
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`, `height_adjustable`) VALUES('55501',  'val13_gond_front', 'val13_gond_front', 's', '2', '1', '1.00', '0', '0', '0', '4865', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
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`, `height_adjustable`) VALUES('55502',  'val13_build_1', 'val13_build_1', 's', '2', '3', '1.00', '0', '0', '0', '4866', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
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`, `height_adjustable`) VALUES('55503',  'val13_build_2', 'val13_build_2', 's', '1', '2', '1.00', '0', '0', '0', '4867', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
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`, `height_adjustable`) VALUES('55504',  'val13_gond_back', 'val13_gond_back', 's', '2', '1', '1.00', '0', '0', '0', '4868', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
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`, `height_adjustable`) VALUES('55505',  'val13_gond_mid2', 'val13_gond_mid2', 's', '2', '1', '1.00', '0', '0', '0', '4869', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
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`, `height_adjustable`) VALUES('55506',  'val13_div_1', 'val13_div_1', 's', '1', '1', '1.00', '0', '0', '0', '4870', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
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`, `height_adjustable`) VALUES('55507',  'val13_wall_2', 'val13_wall_2', 'i', '0', '0', '1.00', '0', '0', '0', '4478', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
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`, `height_adjustable`) VALUES('55508',  'val13_wall_3', 'val13_wall_3', 'i', '0', '0', '1.00', '0', '0', '0', '4479', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
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`, `height_adjustable`) VALUES('55509',  'val13_wall_1', 'val13_wall_1', 'i', '0', '0', '1.00', '0', '0', '0', '4480', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0');
    Run these after: (fix for interaction_modes_count)
    Code:
    UPDATE `furniture` SET `interaction_modes_count`='4' WHERE (`item_id`='55509');
UPDATE `furniture` SET `interaction_modes_count`='4' WHERE (`item_id`='55508');
UPDATE `furniture` SET `interaction_modes_count`='4' WHERE (`item_id`='55507');
UPDATE `furniture` SET `interaction_modes_count`='2' WHERE (`item_id`='55506');
UPDATE `furniture` SET `interaction_modes_count`='2' WHERE (`item_id`='55505');
UPDATE `furniture` SET `interaction_modes_count`='2' WHERE (`item_id`='55504');
UPDATE `furniture` SET `interaction_modes_count`='6' WHERE (`item_id`='55503');
UPDATE `furniture` SET `interaction_modes_count`='2' WHERE (`item_id`='55502');
UPDATE `furniture` SET `interaction_modes_count`='2' WHERE (`item_id`='55501');
UPDATE `furniture` SET `interaction_modes_count`='2' WHERE (`item_id`='55500');
UPDATE `furniture` SET `stack_height`='0.1', `can_stack`='1', `allow_walk`='1' WHERE (`item_id`='55499');
UPDATE `furniture` SET `stack_height`='1', `can_sit`='1' WHERE (`item_id`='55498');
UPDATE `furniture` SET `interaction_modes_count`='2' WHERE (`item_id`='55498');
UPDATE `furniture` SET `interaction_modes_count`='2' WHERE (`item_id`='55497');
UPDATE `furniture` SET `interaction_modes_count`='2' WHERE (`item_id`='55496');
UPDATE `furniture` SET `can_sit`='1' WHERE (`item_id`='55505');
    ------
    catalog_items
    ------
    Code:
    INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55496', 'val13_build_3', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55497', 'val13_gond_post', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55498', 'val13_gond_mid1', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55499', 'val13_water', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55500', 'val13_div_2', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55501', 'val13_gond_front', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55502', 'val13_build_1', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55503', 'val13_build_2', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55504', 'val13_gond_back', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55505', 'val13_gond_mid2', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55506', 'val13_div_1', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55507', 'val13_wall_2', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55508', 'val13_wall_3', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('PAGE_ID', '55509', 'val13_wall_1', '5', '0', '0', '1');
    Furnidata + Download Link

    ------
    furnidata
    ------
    Code:
    ["s","4860","val13_build_3","44944","0","1","2","","Venetian Building","Where the magic happens","","-1","-1","1,0","1"],["s","4861","val13_gond_post","44944","0","1","1","","Gondola Post","Romance on the river","","-1","-1","1,-0.3","1"],["s","4862","val13_gond_mid1","44944","0","2","1","","Gondola Middle Seat","Romance on the river","","-1","-1","1,0","1"],["s","4863","val13_water","44944","0","2","2","","Venetian Water","Floating flowers","","-1","-1","28,1.5","1"],["s","4864","val13_div_2","44944","0","1","1","","Venetian Divider","Dividing the lovers from the haters","","-1","-1","1,-0.1","1"],["s","4865","val13_gond_front","44944","0","2","1","","Gondola Front","Romance on the river","","-1","-1","1,0","1"],["s","4866","val13_build_1","44944","0","2","3","","Venetian Building","Where the magic happens","","-1","-1","1,0","1"],["s","4867","val13_build_2","44944","0","1","2","","Venetian Building Block","Build it tall","","-1","-1","","1"],["s","4868","val13_gond_back","44944","0","2","1","","Gondola Back","Romance on the river","","-1","-1","1,0","1"],["s","4869","val13_gond_mid2","44944","0","2","1","","Gondola Middle","Romance on the river","","-1","-1","1,0","1"],["s","4870","val13_div_1","44944","0","1","1","","Venetian Divider Corner","Dividing the lovers from the haters","","-1","-1","1,-0.1","1"],
    I forgot to add these to the furnidata xD
    Code:
    ["i","4478","val13_wall_2","44944","","","","","Venetian Wall","The walls of Venice","","-1","-1","1"],["i","4479","val13_wall_3","44944","","","","","Venetian Wall","The walls of Venice","","-1","-1","1"],["i","4480","val13_wall_1","44944","","","","","Venetian Wall","The walls of Venice","","-1","-1","1"]]
    ------
    download
    ------
    Click here to download from Dropbox!

    Missed one : http://images.habbo.com/dcr/hof_furn..._gond_mid2.swf (right click save as)

    Updated with wall items fix
    Last edited by Spheral; 05-02-13 at 10:14 PM.
  2. Check out our sponsor
    Valentines 2013 (BCStorm + Phoenix)
  3. 05-02-13 #2
    V for Vendetta
    Banned V for Vendetta is offline
    BannedRank
    Feb 2007 Join Date
    1,809Posts

    Re: Valentines 2013 (BCStorm + Phoenix)

    Thanks this is a way better release then the one before ..
  4. 05-02-13 #3
    Mush
    Valued Member Mush is offline
    MemberRank
    Oct 2012 Join Date
    NorwayLocation
    118Posts

    Re: Valentines 2013 (BCStorm + Phoenix)

    Wow, thanks!

    This will be useful, thanks alot.

  5. 05-02-13 #4
    The General
    Check http://arcturus.pw The General is offline
    DeveloperRank
    Aug 2011 Join Date
    7,607Posts

    Re: Valentines 2013 (BCStorm + Phoenix)

    This is how a release should be, image + Full SQLs + furnidata.

    Nice done John :)
  6. 05-02-13 #5
    Eronisch
    Developer Eronisch is offline
    MemberRank
    Jul 2009 Join Date
    The NetherlandsLocation
    1,328Posts

    Re: Valentines 2013 (BCStorm + Phoenix)

    In my opinion, the furniture is getting worst every release..
  7. 05-02-13 #6
    mark2390
    Member mark2390 is offline
    MemberRank
    Dec 2007 Join Date
    United StatesLocation
    72Posts

    Re: Valentines 2013 (BCStorm + Phoenix)

    Thanks John!
  8. 05-02-13 #7
    Gilibert
    **Danish aZure support** Gilibert is offline
    MemberRank
    Jan 2011 Join Date
    236Posts

    Re: Valentines 2013 (BCStorm + Phoenix)

    Anyone have the SQL for Phoenix 3.11
  9. 05-02-13 #8
    Spheral
    Eye Eye Capt'n Spheral is offline
    MemberRank
    May 2010 Join Date
    TumptonshireLocation
    2,488Posts

    Re: Valentines 2013 (BCStorm + Phoenix)

    I have added update queries you have to run once you add the furniture.

    + Its for Phoenix.. :s
  10. 05-02-13 #9
    powle
    Member powle is offline
    MemberRank
    Nov 2012 Join Date
    84Posts

    Re: Valentines 2013 (BCStorm + Phoenix)

    catalog_items fixxed:

    Code:
    INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55496', '308', '55496', 'val13_build_3', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55497', '308', '55497', 'val13_gond_post', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55498', '308', '55498', 'val13_gond_mid1', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55499', '308', '55499', 'val13_water', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55500', '308', '55500', 'val13_div_2', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55501', '308', '55501', 'val13_gond_front', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55502', '308', '55502', 'val13_build_1', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55503', '308', '55503', 'val13_build_2', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55504', '308', '55504', 'val13_gond_back', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55505', '308', '55505', 'val13_gond_mid2', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55506', '308', '55506', 'val13_div_1', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55507', '308', '55507', 'val13_wall_2', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55508', '308', '55508', 'val13_wall_3', '5', '0', '0', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('55509', '308', '55509', 'val13_wall_1', '5', '0', '0', '1');
  11. 05-02-13 #10
    Gilibert
    **Danish aZure support** Gilibert is offline
    MemberRank
    Jan 2011 Join Date
    236Posts

    Re: Valentines 2013 (BCStorm + Phoenix)

    Make a furniture fix too
  12. 05-02-13 #11
    Exonize
    G'nome sayin' Exonize is offline
    MemberRank
    May 2011 Join Date
    Czech RepublicLocation
    517Posts

    Re: Valentines 2013 (BCStorm + Phoenix)



    All the furnis are working but they are not showing any "image". Some of the old is also not working.
  13. 05-02-13 #12
    PRIZM
    Zephyr Studios PRIZM is offline
    MemberRank
    Feb 2012 Join Date
    DenmarkLocation
    2,291Posts

    Re: Valentines 2013 (BCStorm + Phoenix)

    Quote Originally Posted by Exonize View Post


    All the furnis are working but they are not showing any "image". Some of the old is also not working.
    I have the same problem matey. :(
  14. 05-02-13 #13
    powle
    Member powle is offline
    MemberRank
    Nov 2012 Join Date
    84Posts

    Re: Valentines 2013 (BCStorm + Phoenix)

    Quote Originally Posted by Prizm View Post
    I have the same problem matey. :(
    Same here!
  15. 05-02-13 #14
    Spheral
    Eye Eye Capt'n Spheral is offline
    MemberRank
    May 2010 Join Date
    TumptonshireLocation
    2,488Posts

    Re: Valentines 2013 (BCStorm + Phoenix)

    Quote Originally Posted by Prizm View Post
    I have the same problem matey. :(
    Das because i forgot to add the furnidata for the walls xD

    Here you go :
    ["i","4478","val13_wall_2","44944","","","","","Venetian Wall","The walls of Venice","","-1","-1","1"],["i","4479","val13_wall_3","44944","","","","","Venetian Wall","The walls of Venice","","-1","-1","1"],["i","4480","val13_wall_1","44944","","","","","Venetian Wall","The walls of Venice","","-1","-1","1"]]
  16. 05-02-13 #15
    Gilibert
    **Danish aZure support** Gilibert is offline
    MemberRank
    Jan 2011 Join Date
    236Posts

    Re: Valentines 2013 (BCStorm + Phoenix)

    Remove furniture 55507 55508 and 55509 and they work. Furniture are NOT clickable


Page 1 of 3 123 LastLast
« Previous Thread | Next Thread »

Advertisement