[SQL] Battle Banzai (80%)

Page 1 of 2 12 LastLast
Results 1 to 15 of 24
  1. #1
    yerro Adde is offline
    MemberRank
    Feb 2010 Join Date
    none ur bizzLocation
    2,731Posts

    [SQL] Battle Banzai (80%)

    Hey! Battleball furnitures.


    cata items
    Code:
    INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES
    (600014, 120, '2785090', 'bb_knj1', 3, 0, 1),
    (600015, 120, '2785091', 'bb_gate_r', 1, 0, 1),
    (600016, 120, '2785092', 'bb_tddhnd', 3, 0, 1),
    (600017, 120, '2785093', 'bb_lightdiv', 4, 0, 1),
    (600018, 120, '2785094', 'bb_tddhead', 4, 0, 1),
    (600019, 120, '2785095', 'bb_pyramid', 3, 0, 1),
    (600020, 120, '2785096', 'bb_patch1', 5, 0, 1),
    (600021, 120, '2785097', 'bb_fnc3', 3, 0, 1),
    (600022, 120, '2785098', 'bb_gate_y', 2, 0, 1),
    (600023, 120, '2785099', 'bb_apparatus', 3, 0, 1),
    (600024, 120, '2785100', 'bb_caterbody', 2, 0, 1),
    (600025, 120, '2785101', 'bb_knj2', 3, 0, 1),
    (600026, 120, '2785102', 'bb_fnc1', 3, 0, 1),
    (600027, 120, '2785103', 'bb_puck', 3, 0, 1),
    (600028, 120, '2785104', 'bb_rnd_tele', 3, 0, 1),
    (600029, 120, '2785105', 'bb_gate_b', 3, 0, 1),
    (600030, 120, '2785106', 'bb_score_r', 3, 0, 1),
    (600031, 120, '2785107', 'bb_painimies1', 3, 0, 1),
    (600032, 120, '2785108', 'bb_painimies2', 5, 0, 1),
    (600035, 120, '2785096', 'bb_patch1', 5, 0, 100),
    (600002, 120, '2785078', 'bb_score_b', 3, 0, 1),
    (600003, 120, '2785079', 'bb_robo', 3, 0, 1),
    (600004, 120, '2785080', 'bb_dragon', 8, 0, 1),
    (600005, 120, '2785081', 'bb_ducklight', 3, 0, 1),
    (600006, 120, '2785082', 'bb_caterhead', 3, 0, 1),
    (600007, 120, '2785083', 'bb_cargobox', 4, 0, 1),
    (600008, 120, '2785084', 'bb_gate_g', 3, 0, 1),
    (600009, 120, '2785085', 'bb_crchair3', 4, 0, 1),
    (600010, 120, '2785086', 'bb_score_g', 3, 0, 1),
    (600011, 120, '2785087', 'bb_crchair', 3, 0, 1),
    (600012, 120, '2785088', 'bb_crchair2', 3, 0, 1),
    (600013, 120, '2785089', 'bb_score_y', 3, 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`, `foot_figure`) VALUES
    (2785108, 'bb_painimies2', 'bb_painimies2', 'i', 1, 1, 1, '0', '0', '1', 4342, '1', '1', '1', '1', '1', 'default', 3, '0', ''),
    (2785078, 'bb_score_b', 'bb_score_b', 'i', 1, 1, 1, '0', '1', '0', 3615, '1', '1', '1', '1', '1', 'default', 2, '0', ''),
    (2785079, 'bb_robo', 'bb_robo', 's', 2, 2, 2, '0', '0', '0', 3616, '1', '1', '1', '1', '1', 'default', 3, '0', ''),
    (2785080, 'bb_dragon', 'bb_dragon', 's', 3, 1, 2.5, '0', '0', '0', 3617, '1', '1', '1', '1', '1', 'default', 3, '0', ''),
    (2785081, 'bb_ducklight', 'bb_ducklight', 's', 1, 1, 3, '0', '0', '0', 3618, '1', '1', '1', '1', '1', 'default', 8, '0', ''),
    (2785082, 'bb_caterhead', 'bb_caterhead', 's', 1, 1, 1, '0', '0', '0', 3619, '1', '1', '1', '1', '1', 'default', 3, '0', ''),
    (2785083, 'bb_cargobox', 'bb_cargobox', 's', 2, 1, 1, '0', '0', '0', 3620, '1', '1', '1', '1', '1', 'default', 3, '0', ''),
    (2785084, 'bb_gate_g', 'bb_gate_g', 's', 1, 1, 0, '0', '0', '1', 3621, '1', '1', '1', '1', '1', 'default', 2, '0', ''),
    (2785085, 'bb_crchair3', 'bb_crchair3', 's', 1, 1, 1, '0', '1', '0', 3622, '1', '1', '1', '1', '1', 'default', 3, '0', ''),
    (2785086, 'bb_score_g', 'bb_score_g', 'i', 1, 1, 1, '0', '1', '0', 3623, '1', '1', '1', '1', '1', 'default', 1, '0', ''),
    (2785087, 'bb_crchair', 'bb_crchair', 's', 1, 1, 1, '0', '1', '0', 3624, '1', '1', '1', '1', '1', 'default', 3, '0', ''),
    (2785088, 'bb_crchair2', 'bb_crchair2', 's', 1, 1, 1, '0', '1', '0', 3625, '1', '1', '1', '1', '1', 'default', 3, '0', ''),
    (2785089, 'bb_score_y', 'bb_score_y', 'i', 1, 1, 1, '1', '0', '0', 3626, '1', '1', '1', '1', '1', 'default', 2, '0', ''),
    (2785090, 'bb_knj1', 'bb_knj1', 's', 2, 1, 1, '0', '0', '0', 3627, '1', '1', '1', '1', '1', 'default', 3, '0', ''),
    (2785091, 'bb_gate_r', 'bb_gate_r', 's', 1, 1, 0, '0', '0', '1', 3628, '1', '1', '1', '1', '1', 'default', 2, '0', ''),
    (2785092, 'bb_tddhnd', 'bb_tddhnd', 's', 1, 1, 1, '1', '0', '0', 3629, '1', '1', '1', '1', '1', 'default', 1, '0', ''),
    (2785093, 'bb_lightdiv', 'bb_lightdiv', 's', 1, 1, 1, '1', '0', '0', 3630, '1', '1', '1', '1', '1', 'default', 8, '0', ''),
    (2785094, 'bb_tddhead', 'bb_tddhead', 's', 2, 2, 2, '0', '0', '0', 3631, '1', '1', '1', '1', '1', 'default', 3, '0', ''),
    (2785095, 'bb_pyramid', 'bb_pyramid', 's', 1, 1, 1, '1', '0', '0', 3632, '1', '1', '1', '1', '1', 'default', 3, '0', ''),
    (2785096, 'bb_patch1', 'bb_patch1', 's', 1, 1, 0.1, '1', '0', '1', 3633, '1', '1', '1', '1', '1', 'default', 4, '0', ''),
    (2785097, 'bb_fnc3', 'bb_fnc3', 's', 1, 3, 1, '0', '0', '0', 3634, '1', '1', '1', '1', '1', 'default', 2, '0', ''),
    (2785098, 'bb_gate_y', 'bb_gate_y', 's', 1, 1, 0, '0', '0', '1', 3635, '1', '1', '1', '1', '1', 'default', 1, '0', ''),
    (2785099, 'bb_apparatus', 'bb_apparatus', 's', 2, 2, 0, '1', '0', '1', 3637, '1', '1', '1', '1', '1', 'default', 8, '0', ''),
    (2785100, 'bb_caterbody', 'bb_caterbody', 's', 1, 1, 1.7, '1', '1', '0', 3638, '1', '1', '1', '1', '1', 'default', 3, '0', ''),
    (2785101, 'bb_knj2', 'bb_knj2', 's', 1, 1, 2, '1', '0', '0', 3639, '1', '1', '1', '1', '1', 'default', 4, '0', ''),
    (2785102, 'bb_fnc1', 'bb_fnc1', 's', 1, 1, 1, '0', '0', '0', 3640, '1', '1', '1', '1', '1', 'default', 2, '0', ''),
    (2785103, 'bb_puck', 'bb_puck', 's', 1, 1, 0.6, '1', '0', '0', 3641, '1', '1', '1', '1', '1', 'ball', 3, '0', ''),
    (2785104, 'bb_rnd_tele', 'bb_rnd_tele', 's', 1, 1, 0.3, '0', '0', '1', 3642, '1', '1', '1', '1', '1', 'teleport', 1, '0', ''),
    (2785105, 'bb_gate_b', 'bb_gate_b', 's', 1, 1, 0, '0', '0', '1', 3643, '1', '1', '1', '1', '1', 'default', 1, '0', ''),
    (2785106, 'bb_score_r', 'bb_score_r', 'i', 1, 1, 1, '0', '1', '0', 3644, '1', '1', '1', '1', '1', 'default', 2, '0', ''),
    (2785107, 'bb_painimies1', 'bb_painimies1', 'i', 1, 1, 1, '0', '0', '1', 4341, '1', '1', '1', '1', '1', 'default', 3, '0', ''),
    (2785077, 'bb_crnr', 'bb_crnr', 's', 1, 1, 1, '0', '0', '0', 3614, '1', '1', '1', '1', '1', 'default', 1, '0', '');
    cata 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
    (120, 3, 'Battle Banzai', 1, 78, '1', '1', 1, '0', '0', 1, 'default_3x3', 'Los nuevos furnis de Battle Banzai por fin en catalogo', '', '', 'Los nuevos furnis de Battle Ball por fin en catalogo', '', '', '');
    image http://img831.imageshack.us/img831/1423/dibujope.png

    credits Kekomundo, a spanish forum

    productdata http://hotel-us.habbo.com/gamedata/productdata Just copy everything in there and replace ur productdata with that

    furnidata http://hotel-us.habbo.com/gamedata/furnidata Just copy everything in there and replace ur furnidata with that


    Thank me if your gonna use these. Thanks :P


  2. #2
    I'm back! iJay is offline
    MemberRank
    Nov 2008 Join Date
    Down Under ;)Location
    602Posts

    Re: [SQL] Battle Banzai (80%)

    Nice release mate!

    Do you have the SWF's by any chance?

    Because I'm not using SWF's straight from Habbo :/

    Cheers.

  3. #3
    Banned PEjump2 is offline
    BannedRank
    Jan 2010 Join Date
    The NetherlandsLocation
    2,838Posts

    Re: [SQL] Battle Banzai (80%)

    Jay, will be included in my v2 pack that i'll release today! :P

  4. #4
    Account Upgraded | Title Enabled! No0b is offline
    MemberRank
    Jul 2010 Join Date
    Michigan, USLocation
    1,426Posts

    Re: [SQL] Battle Banzai (80%)

    wow nice release adde :D

  5. #5
    Enthusiast 0cean is offline
    MemberRank
    Sep 2010 Join Date
    35Posts

    Re: [SQL] Battle Banzai (80%)

    FINALLY!been waitig for these.

  6. #6
    Account Upgraded | Title Enabled! GrandCoder is offline
    MemberRank
    Jul 2010 Join Date
    BramptonLocation
    413Posts

    Re: [SQL] Battle Banzai (80%)

    got a prob when i click battlebonzi in catalouge D/C

  7. #7
    Account Upgraded | Title Enabled! FreeZa™ is offline
    MemberRank
    Jun 2008 Join Date
    In the JungleLocation
    274Posts

    Re: [SQL] Battle Banzai (80%)

    Quote Originally Posted by GrandCoder View Post
    got a prob when i click battlebonzi in catalouge D/C
    Update ur Furnidata to the latest and make sure u properly added the SQL. Restart server or update_defs and update_catalog .

  8. #8
    Novice HoloBooY is offline
    MemberRank
    May 2010 Join Date
    4Posts

    Re: [SQL] Battle Banzai (80%)

    I got This Error

    I Need Help...

  9. #9
    Member Swifty91 is offline
    MemberRank
    Jun 2009 Join Date
    89Posts

    Re: [SQL] Battle Banzai (80%)

    #1054 - Unknown column 'foot_figure' in 'field list' i keep getting that when i insert the Furniture code

  10. #10
    Im Back! PythoneX12 is offline
    MemberRank
    Sep 2010 Join Date
    634Posts

    Re: [SQL] Battle Banzai (80%)

    Thanks for this man.

  11. #11
    Valued Member DiNoMyTe is offline
    MemberRank
    Sep 2009 Join Date
    112Posts

    Re: [SQL] Battle Banzai (80%)

    I Got the counter now :D

    DiNoMyTe

    EDIT:

    Here it is for you all :D

    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`, `foot_figure`) VALUES
    (2785109, 'bb_counter', 'bb_counter', 's', 1, 4, 0, '0', '0', '0', 3375, '1', '1', '1', '1', '1', 'default', 1, '0', '');

    cata_pages:
    Code:
    INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES
    (600033, 120, '2785109', 'bb_counter', 20, 0, 1);


    Wait a sec. just going to upload the swf :D


    EDIT2:

    Here it is SWF

    WARNING To Download it right right mouse click and then save as..
    Last edited by DiNoMyTe; 24-09-10 at 11:31 PM.

  12. #12
    Member TakeDown is offline
    MemberRank
    Feb 2010 Join Date
    the nederlandsLocation
    68Posts

    Re: [SQL] Battle Banzai (80%)

    its coming never for R36 for sure...

  13. #13
    Valued Member DiNoMyTe is offline
    MemberRank
    Sep 2009 Join Date
    112Posts

    Re: [SQL] Battle Banzai (80%)

    Quote Originally Posted by TakeDown View Post
    its coming never for R36 for sure...
    R36 swf or dcr?

  14. #14
    Account Upgraded | Title Enabled! Mikehunt is offline
    MemberRank
    Jun 2010 Join Date
    Look behind YouLocation
    332Posts

    Re: [SQL] Battle Banzai (80%)

    Unknown column "Foot_figure"

  15. #15
    Account Upgraded | Title Enabled! SpazzEmu is offline
    MemberRank
    Jun 2010 Join Date
    Warwick, UKLocation
    444Posts

    Re: [SQL] Battle Banzai (80%)

    Idiots who dont know Mysql (Who should not own a Mysql retro) here is the db with out foot figure

    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
    (2785108, 'bb_painimies2', 'bb_painimies2', 'i', 1, 1, 1, '0', '0', '1', 4342, '1', '1', '1', '1', '1', 'default', 3, '0'),
    (2785078, 'bb_score_b', 'bb_score_b', 'i', 1, 1, 1, '0', '1', '0', 3615, '1', '1', '1', '1', '1', 'default', 2, '0'),
    (2785079, 'bb_robo', 'bb_robo', 's', 2, 2, 2, '0', '0', '0', 3616, '1', '1', '1', '1', '1', 'default', 3, '0'),
    (2785080, 'bb_dragon', 'bb_dragon', 's', 3, 1, 2.5, '0', '0', '0', 3617, '1', '1', '1', '1', '1', 'default', 3, '0'),
    (2785081, 'bb_ducklight', 'bb_ducklight', 's', 1, 1, 3, '0', '0', '0', 3618, '1', '1', '1', '1', '1', 'default', 8, '0'),
    (2785082, 'bb_caterhead', 'bb_caterhead', 's', 1, 1, 1, '0', '0', '0', 3619, '1', '1', '1', '1', '1', 'default', 3, '0'),
    (2785083, 'bb_cargobox', 'bb_cargobox', 's', 2, 1, 1, '0', '0', '0', 3620, '1', '1', '1', '1', '1', 'default', 3, '0'),
    (2785084, 'bb_gate_g', 'bb_gate_g', 's', 1, 1, 0, '0', '0', '1', 3621, '1', '1', '1', '1', '1', 'default', 2, '0'),
    (2785085, 'bb_crchair3', 'bb_crchair3', 's', 1, 1, 1, '0', '1', '0', 3622, '1', '1', '1', '1', '1', 'default', 3, '0'),
    (2785086, 'bb_score_g', 'bb_score_g', 'i', 1, 1, 1, '0', '1', '0', 3623, '1', '1', '1', '1', '1', 'default', 1, '0'),
    (2785087, 'bb_crchair', 'bb_crchair', 's', 1, 1, 1, '0', '1', '0', 3624, '1', '1', '1', '1', '1', 'default', 3, '0'),
    (2785088, 'bb_crchair2', 'bb_crchair2', 's', 1, 1, 1, '0', '1', '0', 3625, '1', '1', '1', '1', '1', 'default', 3, '0'),
    (2785089, 'bb_score_y', 'bb_score_y', 'i', 1, 1, 1, '1', '0', '0', 3626, '1', '1', '1', '1', '1', 'default', 2, '0'),
    (2785090, 'bb_knj1', 'bb_knj1', 's', 2, 1, 1, '0', '0', '0', 3627, '1', '1', '1', '1', '1', 'default', 3, '0'),
    (2785091, 'bb_gate_r', 'bb_gate_r', 's', 1, 1, 0, '0', '0', '1', 3628, '1', '1', '1', '1', '1', 'default', 2, '0'),
    (2785092, 'bb_tddhnd', 'bb_tddhnd', 's', 1, 1, 1, '1', '0', '0', 3629, '1', '1', '1', '1', '1', 'default', 1, '0'),
    (2785093, 'bb_lightdiv', 'bb_lightdiv', 's', 1, 1, 1, '1', '0', '0', 3630, '1', '1', '1', '1', '1', 'default', 8, '0'),
    (2785094, 'bb_tddhead', 'bb_tddhead', 's', 2, 2, 2, '0', '0', '0', 3631, '1', '1', '1', '1', '1', 'default', 3, '0'),
    (2785095, 'bb_pyramid', 'bb_pyramid', 's', 1, 1, 1, '1', '0', '0', 3632, '1', '1', '1', '1', '1', 'default', 3, '0'),
    (2785096, 'bb_patch1', 'bb_patch1', 's', 1, 1, 0.1, '1', '0', '1', 3633, '1', '1', '1', '1', '1', 'default', 4, '0'),
    (2785097, 'bb_fnc3', 'bb_fnc3', 's', 1, 3, 1, '0', '0', '0', 3634, '1', '1', '1', '1', '1', 'default', 2, '0'),
    (2785098, 'bb_gate_y', 'bb_gate_y', 's', 1, 1, 0, '0', '0', '1', 3635, '1', '1', '1', '1', '1', 'default', 1, '0'),
    (2785099, 'bb_apparatus', 'bb_apparatus', 's', 2, 2, 0, '1', '0', '1', 3637, '1', '1', '1', '1', '1', 'default', 8, '0'),
    (2785100, 'bb_caterbody', 'bb_caterbody', 's', 1, 1, 1.7, '1', '1', '0', 3638, '1', '1', '1', '1', '1', 'default', 3, '0'),
    (2785101, 'bb_knj2', 'bb_knj2', 's', 1, 1, 2, '1', '0', '0', 3639, '1', '1', '1', '1', '1', 'default', 4, '0'),
    (2785102, 'bb_fnc1', 'bb_fnc1', 's', 1, 1, 1, '0', '0', '0', 3640, '1', '1', '1', '1', '1', 'default', 2, '0'),
    (2785103, 'bb_puck', 'bb_puck', 's', 1, 1, 0.6, '1', '0', '0', 3641, '1', '1', '1', '1', '1', 'ball', 3, '0'),
    (2785104, 'bb_rnd_tele', 'bb_rnd_tele', 's', 1, 1, 0.3, '0', '0', '1', 3642, '1', '1', '1', '1', '1', 'teleport', 1, '0'),
    (2785105, 'bb_gate_b', 'bb_gate_b', 's', 1, 1, 0, '0', '0', '1', 3643, '1', '1', '1', '1', '1', 'default', 1, '0'),
    (2785106, 'bb_score_r', 'bb_score_r', 'i', 1, 1, 1, '0', '1', '0', 3644, '1', '1', '1', '1', '1', 'default', 2, '0'),
    (2785107, 'bb_painimies1', 'bb_painimies1', 'i', 1, 1, 1, '0', '0', '1', 4341, '1', '1', '1', '1', '1', 'default', 3, '0'),
    (2785077, 'bb_crnr', 'bb_crnr', 's', 1, 1, 1, '0', '0', '0', 3614, '1', '1', '1', '1', '1', 'default', 1, '0');



Page 1 of 2 12 LastLast

Advertisement