-- phpMyAdmin SQL Dump -- version 2.6.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generatie Tijd: 07 Nov 2009 om 23:38 -- Server versie: 4.1.9 -- PHP Versie: 4.3.10 -- -- Database: `habbo` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `catalogue` -- CREATE TABLE `catalogue` ( `id` bigint(20) NOT NULL auto_increment, `sprite` varchar(100) NOT NULL default '', `name` varchar(100) NOT NULL default '', `details` tinytext NOT NULL, `color` varchar(20) NOT NULL default '', `call_id` varchar(20) NOT NULL default '', `price` bigint(20) NOT NULL default '0', `cat` char(3) NOT NULL default '', `walk` char(2) NOT NULL default '', `weight` varchar(20) NOT NULL default '', `otype` varchar(20) NOT NULL default '', `ovalue` varchar(20) NOT NULL default '', KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=106 ; -- -- Gegevens worden uitgevoerd voor tabel `catalogue` -- INSERT INTO `catalogue` VALUES (1, 'chair_plasto', 'Chair', 'Hip plastic furniture', '0,0,0', 'EHP', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (2, 'table_plasto_square', 'Square Dining Table', 'Hip plastic furniture', '0,0,0', 'BHP', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (3, 'table_plasto_bigsquare', 'Plaso big square table', 'Need a bigger table then this plasto table is perfect for you.', '0,0,0', 'DHP', 2, 'A1', '1', '2 2', '', ''); INSERT INTO `catalogue` VALUES (4, 'door', 'Telephone Box', 'Move to another room in traditional English style', '0,0,0', 'ovi', 5, 'a2', '0', '1 1', 'DOOROPEN', 'FALSE'); INSERT INTO `catalogue` VALUES (5, 'doorB', 'Wardrobe', 'Narnia has nothing on this teleport device!', '0,0,0', 'ovi2', 3, 'a2', '0', '1 1', 'DOOROPEN', 'FALSE'); INSERT INTO `catalogue` VALUES (6, 'doorC', 'Portaloo', 'Festival-chic inter-room transport', '0,0,0', 'ovi3', 4, 'a2', '0', '1 1', 'DOOROPEN', 'FALSE'); INSERT INTO `catalogue` VALUES (8, 'pizza', 'Pizza Box', 'You dirty Habbo', '0,0,0', 'PIZ', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (9, 'drinks', 'Empty Cans', 'Are you a slob too?', '0,0,0', 'DRK', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (10, 'bottle', 'Empty Spinning Bottl', 'For interesting games!', '0,0,0', 'PUL', 1, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (92, 'tree5', 'Christmas Tree 3', 'Any presents under yet?', '0,0,0', 'tree5', 5, 'a2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (90, 'tree4', 'Christmas Tree 2', 'Any presents under yet?', '0,0,0', 'tree4', 5, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (14, 'sink', 'Sink', 'Hot and cold thrown in for no charge', '0,0,0', 'LAVUAARI', 3, 'A1', '1', '1 1', 'DOOROPEN', 'FALSE'); INSERT INTO `catalogue` VALUES (15, 'toilet', 'Loo Seat', 'Loo Seat', '0,0,0', 'PYTTYSIN', 2, 'A2', '1', '1 1', 'SWITCHON', 'OFF'); INSERT INTO `catalogue` VALUES (16, 'toilet_red', 'Loo Seat', 'Loo Seat', '0,0,0', 'PYTTYPUN', 2, 'A2', '1', '1 1', 'SWITCHON', 'OFF'); INSERT INTO `catalogue` VALUES (17, 'toilet_yell', 'Loo Seat', 'Loo Seat', '0,0,0', 'PYTTYKELT', 2, 'A2', '1', '1 1', 'SWITCHON', 'OFF'); INSERT INTO `catalogue` VALUES (18, 'bath', 'Bubble Bath', 'The ultimate in pampering', '0,0,0', 'AMME', 6, 'A2', '1', '1 2', 'SWITCHON', 'OFF'); INSERT INTO `catalogue` VALUES (19, 'tile', 'Floor Tiles', 'In Variety of Colors', '0,0,0', 'KAAKELISIN', 2, 'A2', '0', '2 2', '', ''); INSERT INTO `catalogue` VALUES (20, 'tile_red', 'Floor Tiles', 'In a choice of colors', '0,0,0', 'KAAKELIPUN', 2, 'A2', '0', '2 2', '', ''); INSERT INTO `catalogue` VALUES (21, 'tile_yell', 'Floor Tiles', 'In a choice of colors', '0,0,0', 'KAAKELIKELT', 2, 'A2', '0', '2 2', '', ''); INSERT INTO `catalogue` VALUES (22, 'sofachair_polyfon_girl', 'Armchair', 'Think pink', '0,0,0', 'GIRLSTP', 3, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (23, 'bed_polyfon_girl_one', 'Single Bed', 'Snuggle down in princess pink', '0,0,0', 'GIRLS1P', 3, 'A1', '1', '1 3', '', ''); INSERT INTO `catalogue` VALUES (24, 'bed_polyfon_girl', 'Double Bed', 'Snuggle down in princess pink', '0,0,0', 'GIRLS2P', 4, 'A2', '1', '2 2', '', ''); INSERT INTO `catalogue` VALUES (25, 'sofa_polyfon_girl', 'Two-seater Sofa', 'Romantic pink for two', '0,0,0', 'GIRLSHP', 4, 'A2', '1', '2 1', '', ''); INSERT INTO `catalogue` VALUES (26, 'carpet_polar', 'Pink Faux-Fur Bear Rug', 'Soft and cute', '5,5,5', 'MURLOVE', 4, 'A2', '0', '', '', ''); INSERT INTO `catalogue` VALUES (27, 'sofachair_polyfon', 'Armchair', 'Loft-style comfort\r\n', '0,0,0', 'STP', 3, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (28, 'table_plasto_square', 'Square Dining Table', 'Hip plastic furniture', '0,0,0', 'B9P', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (29, 'duck', 'Rubber Duck', 'Every bather needs one', '0,0,0', 'KUMIANKKA', 1, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (30, 'carpet_armas', 'Hand-Woven Rug', 'Adds instant warmth', '0,0,0', 'RMA', 2, 'A1', '1', '2 2', '', ''); INSERT INTO `catalogue` VALUES (31, 'bar_chair_armas', 'Barrel Stool', 'The ultimate recycled furniture', '0,0,0', 'BJA', 1, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (32, 'bar_armas', 'Barrel Minibar', 'It''s a barrel of laughs and a great talking point', '0,0,0', 'BAA', 4, 'A2', '1', '1 1', 'DOOROPEN', 'FALSE'); INSERT INTO `catalogue` VALUES (33, 'lamp_armas', 'Floor Lamp', 'Ambient lightung is essential', '0,0,0', 'JLA', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (34, 'small_chair_armas', 'Stool', 'Rustic charm at it''s best', '0,0,0', 'JAA', 1, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (35, 'small_table_armas', 'Occacional Table', 'Practical and beautiful', '0,0,0', 'PPA', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (36, 'bed_armas_one', 'Single Bed', 'Rustic charm for one', '0,0,0', 'S1A', 2, 'A1', '1', '1 3', '', ''); INSERT INTO `catalogue` VALUES (37, 'bed_armas_two', 'Double Bed', 'King-sized pine comfort', '0,0,0', 'S2A', 3, 'A2', '1', '2 3', '', ''); INSERT INTO `catalogue` VALUES (91, 'tree3', 'Christmas Tree 1', 'Any presents under yet?', '0,0,0', 'tree3', 4, 'a2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (39, 'shelves_armas', 'Bookcase', 'For all those fire-side stories', '0,0,0', 'KHA', 3, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (40, 'lamp2_armas', 'Church Candle', 'Wax lyrical with some old-world charm', '0,0,0', 'KYA', 2, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (41, 'soft_sofachair_norja', 'Armchair', 'A soft iced sofa chair', '0,0,0', 'STN', 3, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (42, 'chair_norja', 'Chair', 'Sleek and chico for each cheek', '0,0,0', 'TUN', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (43, 'couch_norja', 'Bench', 'Two can perch comfortablt', '0,0,0', 'PEN', 2, 'A1', '1', '2 1', '', ''); INSERT INTO `catalogue` VALUES (44, 'table_norja_med', 'Coffee Table', 'Elegance embodied', '0,0,0', 'PYN', 2, 'A1', '1', '2 2', '', ''); INSERT INTO `catalogue` VALUES (45, 'shelves_norja', 'Bookcase', 'For nic naks and art deco books', '0,0,0', 'HYN', 3, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (46, 'soft_sofa_norja', 'Sofa', 'A soft iced sofa', '0,0,0', 'PSN', 4, 'A2', '1', '2 1', '', ''); INSERT INTO `catalogue` VALUES (48, 'bed_silo_one', 'Simgle Bed', 'Plain and simple', '0,0,0', 'S1S', 3, 'A1', '1', '1 3', '', ''); INSERT INTO `catalogue` VALUES (49, 'bed_silo_two', 'Souble Bed', 'Plan and simple X2', '0,0,0', 'S2S', 3, 'A1', '1', '2 3', '', ''); INSERT INTO `catalogue` VALUES (50, 'shelves_silo', 'Bookcase', 'For nic and art deco books', '0,0,0', 'KHS', 3, 'A1', '1', '2 1', '', ''); INSERT INTO `catalogue` VALUES (51, 'table_silo_med', 'Coffee Table', 'Wipe cleas and unobtrusive', '0,0,0', 'PYS', 2, 'A1', '1', '2 2', '', ''); INSERT INTO `catalogue` VALUES (52, 'sofa_silo', 'Two-Seater Sofa', 'Cushioned, understarted comfort', '0,0,0', 'SHS', 3, 'A1', '1', '2 1', '', ''); INSERT INTO `catalogue` VALUES (53, 'sofachair_silo', 'Armchair', 'Large, but worth it', '0,0,0', 'STS', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (95, 'tree4', 'Christmas Tree 2', 'Any presents under yet?', '0,0,0', 'EHP', 5, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (55, 'chair_silo', 'Dining Chair', 'Keep it simple', '0,0,0', 'TUS', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (56, 'table_silo_small', 'Occacional Table', 'For those random moments', '0,0,0', 'PPS', 1, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (57, 'table_plasto_round', 'Round DinningTable', 'Hip plastic furniture', '0,0,0', 'CHP', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (58, 'table_plasto_4leg', 'Ocassional Table', 'Hipplastic furniture', '0,0,0', 'AHP', 0, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (59, 'chair_plasty', 'Plastic Pod Chair', 'Hip plastic furniture', '0,0,0', 'PL1', 2, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (60, 'table_armas', 'Dining Table', 'For informal dining', '0,0,0', 'PIA', 3, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (61, 'bench_armas', 'Bench', 'To complete the dining set', '0,0,0', 'PEA', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (62, 'bartable_armas', 'Bar-Style Table', 'Essential for extra guests', '0,0,0', 'BTA', 3, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (63, 'bed_budgetb_one', 'Plain Single Bed', 'All you need for a good night', '0,0,0', 'S1BVALKO', 2, 'A1', '1', '2 3', '', ''); INSERT INTO `catalogue` VALUES (64, 'bed_budgetb', 'Plain Double Bed', 'Sweet dreams for two', '0,0,0', 'S2BVALKO', 3, 'A1', '1', '2 3', '', ''); INSERT INTO `catalogue` VALUES (65, 'bed_budget_one', 'Single Bed (Aqua)', 'All you need for a good night Blue', '0,0,0', 'S1B', 2, 'A1', '1', '2 3', '', ''); INSERT INTO `catalogue` VALUES (66, 'bed_budget', 'Double Bed (Aqua)', 'Sweet dreams for two', '0,0,0', 'S2B', 3, 'A1', '2', '2 3', '', ''); INSERT INTO `catalogue` VALUES (67, 'bar_basic', 'Pura Mini-bar', 'A pura series 300 minibar', '0,0,0', 'BABA', 4, 'A2', '1', '1 1', 'DOOROPEN', 'FALSE'); INSERT INTO `catalogue` VALUES (68, 'fridge', 'Pura Fridge', 'Keep cool with a chilled snack or drink', '0,0,0', 'FDG', 6, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (69, 'lamp_basic', 'Pura Lamp', 'Switch on the atmosphere with this sophisticated light', '0,0,0', 'BLMP', 3, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (70, 'bed_polyfon_one', 'Single Bed', 'Cot of the artistic', '0,0,0', 'S1P', 3, 'A1', '1', '1 3', '', ''); INSERT INTO `catalogue` VALUES (71, 'table_polyfon_small', 'Small Coffee Table', 'For serving a stylish latte', '0,0,0', 'PPP', 1, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (72, 'chair_polyfon', 'Dining Chair', 'Metallic seating experience', '0,0,0', 'TUP', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (73, 'sofa_polyfon', 'Two-Seater Sofa', 'Comfort for stylish couples', '0,0,0', 'SHP', 4, 'A2', '1', '2 1', '', ''); INSERT INTO `catalogue` VALUES (74, 'bed_polyfon', 'Double Bed', 'Give youtself space to stretch out', '0,0,0', 'S2P', 3, 'A2', '1', '2 3', '', ''); INSERT INTO `catalogue` VALUES (75, 'table_polyfon_med', 'Large Coffee Table', 'For larger gatherings', '0,0,0', 'PMP', 3, 'A1', '1', '2 2', '', ''); INSERT INTO `catalogue` VALUES (76, 'stand_polyfon_z', 'Shelf', 'Tidy up', '0,0,0', 'LTP', 1, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (77, 'bardesk_polyfon', 'Bar/desk', 'Perfect for work or play', '0,0,0', 'BTP', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (78, 'bardeskcorner_polyfon', 'Corner Cabinet/Desk', 'Tuck it away', '0,0,0', 'BKP', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (79, 'bar_polyfon', 'Mini-Bar', 'You naughty Habbo!', '0,0,0', 'BAP', 5, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (80, 'shelves_polyfon', 'Bookcase', 'For the arty pad', '0,0,0', 'KHP', 4, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (81, 'doormat_love', 'Doormat', 'Welcome Habbos in style', '0,0,0', 'OSB', 1, 'A1', '0', '1 1', '', ''); INSERT INTO `catalogue` VALUES (82, 'plant_pineapple', 'Pineapple Plant', 'Needs loving glances', '0,0,0', 'ANANAS', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (83, 'plant_small_cactus', 'Small Cactus', 'Even less watering than the real world', '0,0,0', 'PIKKUKAKTUS', 1, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (84, 'plant_fruittree', 'Fruit Tree', 'Great yield and sweet fruit', '0,0,0', 'PUU', 2, 'A1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (85, 'plant_bonsai', 'Bonsai Tree', 'You can be sure it lives', '0,0,0', 'BONSAI', 3, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (86, 'plant_yukka', 'Yukka Plant', 'Easy to care for', '0,0,0', 'JUKKA', 3, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (87, 'plant_big_cactus', 'Mature Cactus', 'Habbo Dreams monster in hiding! Shhhh', '0,0,0', 'ISOKAKTUS', 2, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (88, 'plant_rose', 'Cut Roses', 'Sleek and chic', '0,0,0', 'RUUSU', 3, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (89, 'plant_sunflower', 'Cut Sunflower', 'For happy Habbos', '0,0,0', 'AURINKO', 3, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (93, 'poster 20', 'Santa Poster', 'Santa Claus', '', 'poster 20', 3, 'a1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (96, 'turkey', 'Roast Turkey', 'Roasted Turkey', '0,0,0', 'turkey', 5, 'a1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (97, 'ham', 'Joint of Ham', 'Keep it Christmas style with ham', '0,0,0', 'ham', 3, 'a1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (98, 'pudding', 'Christmas Pudding', 'Keep a piece over for me', '0,0,0', 'pudding', 3, 'a1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (99, 'oslo', 'Deals test', 'test', '0,0,0', 'oslo', 5, 'A2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (100, 'house', 'Gingerbread House', 'House made out of chocolate', '0,0,0', 'house', 3, 'a1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (101, '301', 'Spaces', 'test', '0,0,0', '301', 2, 'a2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (104, 'xmasduck', 'Christmas Rubber Duck', 'Every Habbo has a Christmas duck', '0,0,0', 'xmasduck', 1, 'a1', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (105, 'triplecandle', 'Electric Candles', 'Santa presents electric Candles', '', 'triplecandle', 3, 'a2', '1', '1 1', '', ''); INSERT INTO `catalogue` VALUES (105, 'menorah', 'Menorah', 'Great for Christmas dinner', '0,0,0', 'menorah', 3, 'a2', '1', '1 1', '', '');