[SQL] Year 2011 Furni [No Fireworks]

[Leixx]

Catalogue_pages:

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
(600, 3, '¡Año 2011!', 1, 91, '1', '1', 1, '0', '0', 5, 'default_3x3', 'catalog_limited_headline1_en', 'catalog_limited_teaser_en', '', '¡Festeja el Año nuevo con los nuevos Furni!', '', 'Click en un ITEM para más información.', '');

Catalogue_Items:

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES
(99904, 600, '99904', 'year2011_waver_b', 25, 0, 1),
(99905, 600, '99905', 'year2011_waver_g', 25, 0, 1),
(99906, 600, '99906', 'year2011_waver_r', 25, 0, 1),
(99907, 600, '99907', 'year2011_waver_y', 25, 0, 1),
(99908, 600, '99908', 'prizetrophy_2011_y', 25, 0, 1),
(99909, 600, '99909', 'prizetrophy_2011_b', 25, 0, 1),
(99910, 600, '99910', 'prizetrophy_2011_r', 25, 0, 1),
(99911, 600, '99911', 'prizetrophy_2011_p', 25, 0, 1),
(99912, 600, '99912', 'prizetrophy_2011_g', 25, 0, 1),
(99913, 600, '99913', 'prizetrophy_2011_w', 25, 0, 1),
(99914, 600, '99914', 'year2011', 25, 0, 1);

Furniture:

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
(99904, 'year2011_waver_b', 'year2011_waver_b', 's', 1, 1, 3, '0', '0', '0', 3781, '1', '1', '1', '1', '1', 'default', 2, '0', ''),
(99905, 'year2011_waver_g', 'year2011_waver_g', 's', 1, 1, 3, '0', '0', '0', 3780, '1', '1', '1', '1', '1', 'default', 2, '0', ''),
(99906, 'year2011_waver_r', 'year2011_waver_r', 's', 1, 1, 3, '0', '0', '0', 3777, '1', '1', '1', '1', '1', 'default', 2, '0', ''),
(99907, 'year2011_waver_y', 'year2011_waver_y', 's', 1, 1, 3, '0', '0', '0', 3768, '1', '1', '1', '1', '1', 'default', 2, '0', ''),
(99908, 'prizetrophy_2011_y', 'prizetrophy_2011_y', 's', 1, 1, 3, '0', '0', '0', 3771, '1', '1', '1', '1', '1', 'trophy', 2, '0', ''),
(99909, 'prizetrophy_2011_b', 'prizetrophy_2011_b', 's', 1, 1, 3, '0', '0', '0', 3773, '1', '1', '1', '1', '1', 'trophy', 2, '0', ''),
(99910, 'prizetrophy_2011_r', 'prizetrophy_2011_r', 's', 1, 1, 3, '0', '0', '0', 3770, '1', '1', '1', '1', '1', 'trophy', 2, '0', ''),
(99911, 'prizetrophy_2011_p', 'prizetrophy_2011_p', 's', 1, 1, 3, '0', '0', '0', 3775, '1', '1', '1', '1', '1', 'trophy', 2, '0', ''),
(99912, 'prizetrophy_2011_g', 'prizetrophy_2011_g', 's', 1, 1, 3, '0', '0', '0', 3778, '1', '1', '1', '1', '1', 'trophy', 2, '0', ''),
(99913, 'prizetrophy_2011_w', 'prizetrophy_2011_w', 's', 1, 1, 3, '0', '0', '0', 3769, '1', '1', '1', '1', '1', 'trophy', 2, '0', ''),
(99914, 'year2011', 'year2011', 'i', 1, 1, 1, '0', '0', '0', 4373, '1', '1', '1', '1', '1', 'default', 2, '0', '');

Furnidata:

["s","3781","year2011_waver_b","30750","0","1","1","","Blue Waver","Be hypnotized!","","-1","-1"],["s","3780","year2011_waver_g","30750","0","1","1","","Green Waver","Be hypnotized!","","-1","-1"],["s","3777","year2011_waver_r","30750","0","1","1","","Red Waver","Be hypnotized!","","-1","-1"],["s","3768","year2011_waver_y","30750","0","1","1","","Yellow Waver","Be hypnotized!","","-1","-1"],["s","3771","prizetrophy_2011_y","30750","0","1","1","","Best Friend of 2010","Show your BFF you care!","","-1","-1"],["s","3773","prizetrophy_2011_b","30750","0","1","1","","Hottest Guy","His pixels make you melt.","","-1","-1"],["s","3770","prizetrophy_2011_r","30750","0","1","1","","Hottest Girl","Has one lucky lady caught your eye?","","-1","-1"],["s","3775","prizetrophy_2011_p","30750","0","1","1","","Most Fashionable Habbo","Who's on your best dressed list?","","-1","-1"],["s","3778","prizetrophy_2011_g","30750","0","1","1","","Best Room Builder","Whose rooms do you admire most?","","-1","-1"],["s","3769","prizetrophy_2011_w","30750","0","1","1","","Habbo Award Trophy","Congratulations for being nominated in the 2010 Habbo Awards!","","-1","-1"],["i","4373","year2011","30750","","","","","Countdown Building","Bring in 2011!","","-1","-1"]

Images of my hotel tester:

Spoiler:

Download SWF:
MediaFire

Catalog Icon:
http://images.habbo.com/c_images/catalogue/icon_91.png

Credits:

Me (I make this Sql Codes)
Sulake (For make the furniture SWF)

[MentaL]

[Arnii]

Nice job ;)

Grr..
Arnii

[PEjump2]

Thanks for releasing :)

[seanrom]

Thanks for releasing :)

OMG!!?!? you maked say something positive -clap hands-

[Zak©]

lol oleaa calm down.
nice SQL

[adminF]

Nice release thanks

[salah-salah]

Ohh :$ Like this Ty for releasing :)

[xnicnicx]

Very good release!
Appreciate it

[Donkjam]

Nice release

@PE well done haha

[Davidaap]

OMG!!?!? you maked say something positive -clap hands-

lol and now you are offtopic :D

------------------------------

Nice release!

[mikederoobs]

how to add these in your hotel im new in Habbo retros :P

[chillhabbo]

Nice job man.
I did'nt download it, but I am sure it would be great!

9/10

[easystuart]

They Dont Load

[GrandCoder]

I Get A Error With The SQL The Furniture : "#1054 - Unknown column 'foot_figure' in 'field list'"

[Tookey]

they look fantastic... very nice!!!


if only i understood UberCMS :P looks like im gonna have to come away from old skool.

[apfelman]

Already released on Kekomundo.. nothing new.

[DiNoMyTe]

Already released on Kekomundo.. nothing new.

Have you looked at the date of the first post? "1 week ago" -.-

[ZoneOut]

They don't load - I also don't have foot_figure, so I took it out of my SQL.

[Fluxhotel1]

Nice.... thanks for releasing this!

[RageROCKER]

Guy's, when i Insert the ' furniture.sql ', in my database i get this error [ SEE ATTACHMENT ], does anyone have a FIX ?

[Sean]

Already released on Kekomundo.. nothing new.

This person is from Kekomundo.

Have you looked at the date of the first post? "1 week ago" -.-

It's not considered a bump unless the first post said something like 27-04-08 or 06-07-10.

I Get A Error With The SQL The Furniture : "#1054 - Unknown column 'foot_figure' in 'field list'"

Guy's, when i Insert the ' furniture.sql ', in my database i get this error [ SEE ATTACHMENT ], does anyone have a FIX ?

It means that the SWF isn't included, just edit the .sql and remove it from the code and save it and try and do it again.

On Topic: Great release, thanks for sharing :)

[mickyc94]

I get an error about the foot_figure, what do i need to take out the .sql to make this work?

[scription]

Make a column called 'foot_figure' varchar 100

[Alpha Ducky]

Make a column called 'foot_figure' varchar 100

or remove the 'foot_figure' from the query

[mickyc94]

If i remove the foot_figure i get a different error.

Can someone help?