[SWF] 2011 SWF Furnis!

[Kado]

nice release!
here complet SQL (category > furniture & trophies) made by me:

Catalog_pages SQL

INSERT INTO `catalog_pages` VALUES ('600', '601', 'Furniture', '2', '1', '91', '1', '1', '1', '0', '0', 'default_3x3', 'catalog_frontpage_headline2_en', 'catalog_limited_teaser_en', '', 'YEAH! Year 2011 arrive! A new year, MORE PARTY&FUN.', '', 'Click for more information about an item. ;)', '');
INSERT INTO `catalog_pages` VALUES ('601', '-1', 'Year 2011!', '2', '1', '91', '1', '1', '1', '0', '0', 'default_3x3', 'catalog_frontpage_headline2_en', '', '', 'YEAR 2011 ARRIVE!', '', '', '');
INSERT INTO `catalog_pages` VALUES ('602', '601', 'Trophies new year', '1', '2', '60', '1', '1', '1', '0', '0', 'trophies', 'catalog_trophies_headline1', '', '', 'YEAHH! W00T! Send a trophie to your friend, 2011 IS SOON! PARTY!', '', '', '');

catalogue_items SQL

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

Furniture SQL [ - Note: Many database with Uber have 'foot_figure', i've remove it from my SQL, but if u need it you can simply add >,'' after > '1' at the end, so the end is like this> '1', ''); ]

INSERT INTO `furniture` VALUES ('', '99904', 'year2011_waver_b', 'year2011_waver_b', 's', '1', '1', '0', '3', '0', '0', '3781', '1', '1', '1', '1', 'default', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99905', 'year2011_waver_g', 'year2011_waver_g', 's', '1', '1', '0', '3', '0', '0', '3780', '1', '1', '1', '1', 'default', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99906', 'year2011_waver_r', 'year2011_waver_r', 's', '1', '1', '0', '3', '0', '0', '3777', '1', '1', '1', '1', 'default', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99907', 'year2011_waver_y', 'year2011_waver_y', 's', '1', '1', '0', '3', '0', '0', '3768', '1', '1', '1', '1', 'default', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99908', 'prizetrophy_2011_y', 'prizetrophy_2011_y', 's', '1', '1', '0', '3', '0', '0', '3771', '1', '1', '1', '1', 'trophy', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99909', 'prizetrophy_2011_b', 'prizetrophy_2011_b', 's', '1', '1', '0', '3', '0', '0', '3773', '1', '1', '1', '1', 'trophy', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99910', 'prizetrophy_2011_r', 'prizetrophy_2011_r', 's', '1', '1', '0', '3', '0', '0', '3770', '1', '1', '1', '1', 'trophy', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99911', 'prizetrophy_2011_p', 'prizetrophy_2011_p', 's', '1', '1', '0', '3', '0', '0', '3775', '1', '1', '1', '1', 'trophy', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99912', 'prizetrophy_2011_g', 'prizetrophy_2011_g', 's', '1', '1', '0', '3', '0', '0', '3778', '1', '1', '1', '1', 'trophy', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99913', 'prizetrophy_2011_w', 'prizetrophy_2011_w', 's', '1', '1', '0', '3', '0', '0', '3769', '1', '1', '1', '1', 'trophy', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99914', 'year2011', 'year2011', 'i', '1', '1', '0', '1', '0', '0', '4373', '1', '1', '1', '1', 'default', '2', '0', '1', '1');

have a nice new year 2011 guys.

[tweeney]

Make sure you add your furnidata and product datas ;D

Thanks Kado

[Twan]

they using the emulator en cms from h4bbo what was released on kekomundo ;)

[robertm3363]

nice release!
here complet SQL (category > furniture & trophies) made by me:

Catalog_pages SQL

INSERT INTO `catalog_pages` VALUES ('600', '601', 'Furniture', '2', '1', '91', '1', '1', '1', '0', '0', 'default_3x3', 'catalog_frontpage_headline2_en', 'catalog_limited_teaser_en', '', 'YEAH! Year 2011 arrive! A new year, MORE PARTY&FUN.', '', 'Click for more information about an item. ;)', '');
INSERT INTO `catalog_pages` VALUES ('601', '-1', 'Year 2011!', '2', '1', '91', '1', '1', '1', '0', '0', 'default_3x3', 'catalog_frontpage_headline2_en', '', '', 'YEAR 2011 ARRIVE!', '', '', '');
INSERT INTO `catalog_pages` VALUES ('602', '601', 'Trophies new year', '1', '2', '60', '1', '1', '1', '0', '0', 'trophies', 'catalog_trophies_headline1', '', '', 'YEAHH! W00T! Send a trophie to your friend, 2011 IS SOON! PARTY!', '', '', '');

catalogue_items SQL

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

Furniture SQL [ - Note: Many database with Uber avec 'foot_figure', i've remove it from my SQL, but if u need it you can simply add >,'' after > '1' at the end, so the end is like this> '1', ''); ]

INSERT INTO `furniture` VALUES ('', '99904', 'year2011_waver_b', 'year2011_waver_b', 's', '1', '1', '0', '3', '0', '0', '3781', '1', '1', '1', '1', 'default', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99905', 'year2011_waver_g', 'year2011_waver_g', 's', '1', '1', '0', '3', '0', '0', '3780', '1', '1', '1', '1', 'default', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99906', 'year2011_waver_r', 'year2011_waver_r', 's', '1', '1', '0', '3', '0', '0', '3777', '1', '1', '1', '1', 'default', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99907', 'year2011_waver_y', 'year2011_waver_y', 's', '1', '1', '0', '3', '0', '0', '3768', '1', '1', '1', '1', 'default', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99908', 'prizetrophy_2011_y', 'prizetrophy_2011_y', 's', '1', '1', '0', '3', '0', '0', '3771', '1', '1', '1', '1', 'trophy', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99909', 'prizetrophy_2011_b', 'prizetrophy_2011_b', 's', '1', '1', '0', '3', '0', '0', '3773', '1', '1', '1', '1', 'trophy', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99910', 'prizetrophy_2011_r', 'prizetrophy_2011_r', 's', '1', '1', '0', '3', '0', '0', '3770', '1', '1', '1', '1', 'trophy', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99911', 'prizetrophy_2011_p', 'prizetrophy_2011_p', 's', '1', '1', '0', '3', '0', '0', '3775', '1', '1', '1', '1', 'trophy', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99912', 'prizetrophy_2011_g', 'prizetrophy_2011_g', 's', '1', '1', '0', '3', '0', '0', '3778', '1', '1', '1', '1', 'trophy', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99913', 'prizetrophy_2011_w', 'prizetrophy_2011_w', 's', '1', '1', '0', '3', '0', '0', '3769', '1', '1', '1', '1', 'trophy', '2', '0', '1', '1');
INSERT INTO `furniture` VALUES ('', '99914', 'year2011', 'year2011', 'i', '1', '1', '0', '1', '0', '0', '4373', '1', '1', '1', '1', 'default', '2', '0', '1', '1');

have a nice new year 2011 guys.

Hey, thanks for the sql but the furni dose not work for me, heres a pic of the problem:

[Kado]

Hey, thanks for the sql but the furni dose not work for me, heres a pic of the problem:

Hey,
see my table (furniture):


if u does'nt have 'data' in your furniture table, u can simply remove > INSERT INTO `furniture` VALUES ('', '99904' [...] < on each line. (what's in red)

[albertwitwerts]

Thanks.