-- http://www.phpmyadmin.net
-- 


-- 
-- Database: `v1`
-- 

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

-- 
-- Table structure for table `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,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=90 ;

-- 
-- Dumping data for table `catalogue`
-- 

INSERT INTO `catalogue` (`id`, `sprite`, `name`, `details`, `color`, `call_id`, `price`, `cat`, `walk`, `weight`, `otype`, `ovalue`) VALUES 
(1, 'chair_plasto', 'Chair', 'Hip plastic furniture', '0,0,0', 'EHP', 2, 'A1', '1', '1 1', '', ''),
(2, 'table_plasto_square', 'Square Dining Table', 'Hip plastic furniture', '0,0,0', 'BHP', 2, 'A1', '1', '1 1', '', ''),
(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', '', ''),
(4, 'door', 'Telephone Box', 'Move to another room in traditional English style', '0,0,0', 'ovi', 5, 'a2', '0', '1 1', 'DOOROPEN', 'FALSE'),
(5, 'doorB', 'Wardrobe', 'Narnia has nothing on this teleport device!', '0,0,0', 'ovi2', 3, 'a2', '0', '1 1', 'DOOROPEN', 'FALSE'),
(6, 'doorC', 'Portaloo', 'Festival-chic inter-room transport', '0,0,0', 'ovi3', 4, 'a2', '0', '1 1', 'DOOROPEN', 'FALSE'),
(8, 'pizza', 'Pizza Box', 'You dirty Habbo', '0,0,0', 'PIZ', 2, 'A1', '1', '1 1', '', ''),
(9, 'drinks', 'Empty Cans', 'Are you a slob too?', '0,0,0', 'DRK', 2, 'A1', '1', '1 1', '', ''),
(10, 'bottle', 'Empty Spinning Bottl', 'For interesting games!', '0,0,0', 'PUL', 1, 'A2', '1', '1 1', '', ''),
(11, 'red_tv', 'Portable TV', 'Don\\''t miss those soaps', '0,0,0', 'RTV', 3, 'A2', '1', '1 1', '', ''),
(12, 'wood_tv', 'Large TV', 'For family viewing', '0,0,0', 'WTV', 4, 'A2', '1', '2 1', '', ''),
(13, 'tv_luxus', 'Digital TV', 'Bang up to date', '0,0,0', 'DIGITV', 6, 'A2', '1', '2 1', '', ''),
(14, 'sink', 'Sink', 'Hot and cold thrown in for no charge', '0,0,0', 'LAVUAARI', 3, 'A1', '1', '1 1', 'DOOROPEN', 'FALSE'),
(15, 'toilet', 'Loo Seat', 'Loo Seat', '0,0,0', 'PYTTYSIN', 2, 'A2', '1', '1 1', 'SWITCHON', 'OFF'),
(16, 'toilet_red', 'Loo Seat', 'Loo Seat', '0,0,0', 'PYTTYPUN', 2, 'A2', '1', '1 1', 'SWITCHON', 'OFF'),
(17, 'toilet_yell', 'Loo Seat', 'Loo Seat', '0,0,0', 'PYTTYKELT', 2, 'A2', '1', '1 1', 'SWITCHON', 'OFF'),
(18, 'bath', 'Bubble Bath', 'The ultimate in pampering', '0,0,0', 'AMME', 6, 'A2', '1', '1 2', 'SWITCHON', 'OFF'),
(19, 'tile', 'Floor Tiles', 'In Variety of Colors', '0,0,0', 'KAAKELISIN', 2, 'A2', '0', '2 2', '', ''),
(20, 'tile_red', 'Floor Tiles', 'In a choice of colors', '0,0,0', 'KAAKELIPUN', 2, 'A2', '0', '2 2', '', ''),
(21, 'tile_yell', 'Floor Tiles', 'In a choice of colors', '0,0,0', 'KAAKELIKELT', 2, 'A2', '0', '2 2', '', ''),
(22, 'sofachair_polyfon_girl', 'Armchair', 'Think pink', '0,0,0', 'GIRLSTP', 3, 'A1', '1', '1 1', '', ''),
(23, 'bed_polyfon_girl_one', 'Single Bed', 'Snuggle down in princess pink', '0,0,0', 'GIRLS1P', 3, 'A1', '1', '1 3', '', ''),
(24, 'bed_polyfon_girl', 'Double Bed', 'Snuggle down in princess pink', '0,0,0', 'GIRLS2P', 4, 'A2', '1', '2 2', '', ''),
(25, 'sofa_polyfon_girl', 'Two-seater Sofa', 'Romantic pink for two', '0,0,0', 'GIRLSHP', 4, 'A2', '1', '2 1', '', ''),
(26, 'carpet_polar', 'Pink Faux-Fur Bear Rug', 'Soft and cute', '5,5,5', 'MURLOVE', 4, 'A2', '0', '', '', ''),
(27, 'sofachair_polyfon', 'Armchair', 'Loft-style comfort\r\n', '0,0,0', 'STP', 3, 'A1', '1', '1 1', '', ''),
(28, 'table_plasto_square', 'Square Dining Table', 'Hip plastic furniture', '0,0,0', 'B9P', 2, 'A1', '1', '1 1', '', ''),
(29, 'duck', 'Rubber Duck', 'Every bather needs one', '0,0,0', 'KUMIANKKA', 1, 'A1', '1', '1 1', '', ''),
(30, 'carpet_armas', 'Hand-Woven Rug', 'Adds instant warmth', '0,0,0', 'RMA', 2, 'A1', '1', '2 2', '', ''),
(31, 'bar_chair_armas', 'Barrel Stool', 'The ultimate recycled furniture', '0,0,0', 'BJA', 1, 'A1', '1', '1 1', '', ''),
(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'),
(33, 'lamp_armas', 'Floor Lamp', 'Ambient lightung is essential', '0,0,0', 'JLA', 2, 'A1', '1', '1 1', '', ''),
(34, 'small_chair_armas', 'Stool', 'Rustic charm at it''s best', '0,0,0', 'JAA', 1, 'A1', '1', '1 1', '', ''),
(35, 'small_table_armas', 'Occacional Table', 'Practical and beautiful', '0,0,0', 'PPA', 2, 'A1', '1', '1 1', '', ''),
(36, 'bed_armas_one', 'Single Bed', 'Rustic charm for one', '0,0,0', 'S1A', 2, 'A1', '1', '1 3', '', ''),
(37, 'bed_armas_two', 'Double  Bed', 'King-sized pine comfort', '0,0,0', 'S2A', 3, 'A2', '1', '2 3', '', ''),
(38, 'fireplace_armas', 'Fireplace', 'Authentic, real flame fire', '0,0,0', 'TAA', 4, 'A2', '1', '1 1', '', ''),
(39, 'shelves_armas', 'Bookcase', 'For all those fire-side stories', '0,0,0', 'KHA', 3, 'A1', '1', '1 1', '', ''),
(40, 'lamp2_armas', 'Church Candle', 'Wax lyrical with some old-world charm', '0,0,0', 'KYA', 2, 'A2', '1', '1 1', '', ''),
(41, 'soft_sofachair_norja', 'Armchair', 'A soft iced sofa chair', '0,0,0', 'STN', 3, 'A2', '1', '1 1', '', ''),
(42, 'chair_norja', 'Chair', 'Sleek and chico for each cheek', '0,0,0', 'TUN', 2, 'A1', '1', '1 1', '', ''),
(43, 'couch_norja', 'Bench', 'Two can perch comfortablt', '0,0,0', 'PEN', 2, 'A1', '1', '2 1', '', ''),
(44, 'table_norja_med', 'Coffee Table', 'Elegance embodied', '0,0,0', 'PYN', 2, 'A1', '1', '2 2', '', ''),
(45, 'shelves_norja', 'Bookcase', 'For nic naks and art deco books', '0,0,0', 'HYN', 3, 'A1', '1', '1 1', '', ''),
(46, 'soft_sofa_norja', 'Sofa', 'A soft iced sofa', '0,0,0', 'PSN', 4, 'A2', '1', '2 1', '', ''),
(48, 'bed_silo_one', 'Simgle Bed', 'Plain and simple', '0,0,0', 'S1S', 3, 'A1', '1', '1 3', '', ''),
(49, 'bed_silo_two', 'Souble Bed', 'Plan and simple X2', '0,0,0', 'S2S', 3, 'A1', '1', '2 3', '', ''),
(50, 'shelves_silo', 'Bookcase', 'For nic and art deco books', '0,0,0', 'KHS', 3, 'A1', '1', '2 1', '', ''),
(51, 'table_silo_med', 'Coffee Table', 'Wipe cleas and unobtrusive', '0,0,0', 'PYS', 2, 'A1', '1', '2 2', '', ''),
(52, 'sofa_silo', 'Two-Seater Sofa', 'Cushioned, understarted comfort', '0,0,0', 'SHS', 3, 'A1', '1', '2 1', '', ''),
(53, 'sofachair_silo', 'Armchair', 'Large, but worth it', '0,0,0', 'STS', 2, 'A1', '1', '1 1', '', ''),
(54, 'chesstable_silo', 'Cheese Table', 'The catalogue Secret Furni!', '0,0,0', 'TLP', 20, 'A2', '1', '1 1', '', ''),
(55, 'chair_silo', 'Dining Chair', 'Keep it simple', '0,0,0', 'TUS', 2, 'A1', '1', '1 1', '', ''),
(56, 'table_silo_small', 'Occacional Table', 'For those random moments', '0,0,0', 'PPS', 1, 'A1', '1', '1 1', '', ''),
(57, 'table_plasto_round', 'Round DinningTable', 'Hip plastic furniture', '0,0,0', 'CHP', 2, 'A1', '1', '1 1', '', ''),
(58, 'table_plasto_4leg', 'Ocassional Table', 'Hipplastic furniture', '0,0,0', 'AHP', 0, 'A1', '1', '1 1', '', ''),
(59, 'chair_plasty', 'Plastic Pod Chair', 'Hip plastic furniture', '0,0,0', 'PL1', 2, 'A2', '1', '1 1', '', ''),
(60, 'table_armas', 'Dining Table', 'For informal dining', '0,0,0', 'PIA', 3, 'A2', '1', '1 1', '', ''),
(61, 'bench_armas', 'Bench', 'To complete the dining set', '0,0,0', 'PEA', 2, 'A1', '1', '1 1', '', ''),
(62, 'bartable_armas', 'Bar-Style Table', 'Essential for extra  guests', '0,0,0', 'BTA', 3, 'A1', '1', '1 1', '', ''),
(63, 'bed_budgetb_one', 'Plain Single Bed', 'All you need for a good night', '0,0,0', 'S1BVALKO', 2, 'A1', '1', '2 3', '', ''),
(64, 'bed_budgetb', 'Plain Double Bed', 'Sweet dreams for two', '0,0,0', 'S2BVALKO', 3, 'A1', '1', '2 3', '', ''),
(65, 'bed_budget_one', 'Single Bed (Aqua)', 'All you need for a good night Blue', '0,0,0', 'S1B', 2, 'A1', '1', '2 3', '', ''),
(66, 'bed_budget', 'Double Bed (Aqua)', 'Sweet dreams for two', '0,0,0', 'S2B', 3, 'A1', '2', '2 3', '', ''),
(67, 'bar_basic', 'Pura Mini-bar', 'A pura series 300 minibar', '0,0,0', 'BABA', 4, 'A2', '1', '1 1', 'DOOROPEN', 'FALSE'),
(68, 'fridge', 'Pura Fridge', 'Keep cool with a chilled snack or drink', '0,0,0', 'FDG', 6, 'A2', '1', '1 1', '', ''),
(69, 'lamp_basic', 'Pura Lamp', 'Switch on the atmosphere with this sophisticated light', '0,0,0', 'BLMP', 3, 'A1', '1', '1 1', '', ''),
(70, 'bed_polyfon_one', 'Single Bed', 'Cot of the artistic', '0,0,0', 'S1P', 3, 'A1', '1', '1 3', '', ''),
(71, 'table_polyfon_small', 'Small Coffee Table', 'For serving a stylish latte', '0,0,0', 'PPP', 1, 'A1', '1', '1 1', '', ''),
(72, 'chair_polyfon', 'Dining Chair', 'Metallic seating experience', '0,0,0', 'TUP', 2, 'A1', '1', '1 1', '', ''),
(73, 'sofa_polyfon', 'Two-Seater Sofa', 'Comfort for stylish couples', '0,0,0', 'SHP', 4, 'A2', '1', '2 1', '', ''),
(74, 'bed_polyfon', 'Double  Bed', 'Give youtself space to stretch out', '0,0,0', 'S2P', 3, 'A2', '1', '2 3', '', ''),
(75, 'table_polyfon_med', 'Large Coffee Table', 'For larger gatherings', '0,0,0', 'PMP', 3, 'A1', '1', '2 2', '', ''),
(76, 'stand_polyfon_z', 'Shelf', 'Tidy up', '0,0,0', 'LTP', 1, 'A1', '1', '1 1', '', ''),
(77, 'bardesk_polyfon', 'Bar/desk', 'Perfect for work or play', '0,0,0', 'BTP', 2, 'A1', '1', '1 1', '', ''),
(78, 'bardeskcorner_polyfon', 'Corner Cabinet/Desk', 'Tuck it away', '0,0,0', 'BKP', 2, 'A1', '1', '1 1', '', ''),
(79, 'bar_polyfon', 'Mini-Bar', 'You naughty Habbo!', '0,0,0', 'BAP', 5, 'A2', '1', '1 1', '', ''),
(80, 'shelves_polyfon', 'Bookcase', 'For the arty pad', '0,0,0', 'KHP', 4, 'A2', '1', '1 1', '', ''),
(81, 'doormat_love', 'Doormat', 'Welcome Habbos in style', '0,0,0', 'OSB', 1, 'A1', '0', '1 1', '', ''),
(82, 'plant_pineapple', 'Pineapple Plant', 'Needs loving glances', '0,0,0', 'ANANAS', 2, 'A1', '1', '1 1', '', ''),
(83, 'plant_small_cactus', 'Small Cactus', 'Even less watering than the real world', '0,0,0', 'PIKKUKAKTUS', 1, 'A1', '1', '1 1', '', ''),
(84, 'plant_fruittree', 'Fruit Tree', 'Great yield and sweet fruit', '0,0,0', 'PUU', 2, 'A1', '1', '1 1', '', ''),
(85, 'plant_bonsai', 'Bonsai Tree', 'You can be sure it lives', '0,0,0', 'BONSAI', 3, 'A2', '1', '1 1', '', ''),
(86, 'plant_yukka', 'Yukka Plant', 'Easy to care for', '0,0,0', 'JUKKA', 3, 'A2', '1', '1 1', '', ''),
(87, 'plant_big_cactus', 'Mature Cactus', 'Habbo Dreams monster in hiding! Shhhh', '0,0,0', 'ISOKAKTUS', 2, 'A2', '1', '1 1', '', ''),
(88, 'plant_rose', 'Cut Roses', 'Sleek and chic', '0,0,0', 'RUUSU', 3, 'A2', '1', '1 1', '', ''),
(89, 'plant_sunflower', 'Cut Sunflower', 'For happy Habbos', '0,0,0', 'AURINKO', 3, 'A2', '1', '1 1', '', '');

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

-- 
-- Table structure for table `priv_rooms`
-- 

CREATE TABLE `priv_rooms` (
  `RoomID` bigint(255) NOT NULL auto_increment,
  `RoomName` text NOT NULL,
  `RoomOwner` text NOT NULL,
  `InRoom` text NOT NULL,
  `MaxInRoom` text NOT NULL,
  `Heightmap` text NOT NULL,
  `Model` text NOT NULL,
  `Furniture` text NOT NULL,
  `RoomStatus` text NOT NULL,
  `RoomDesc` text NOT NULL,
  `Wallpaper` text NOT NULL,
  `Floor` text NOT NULL,
  `RoomPass` text NOT NULL,
  PRIMARY KEY  (`RoomID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- 
-- Dumping data for table `priv_rooms`
-- 

INSERT INTO `priv_rooms` (`RoomID`, `RoomName`, `RoomOwner`, `InRoom`, `MaxInRoom`, `Heightmap`, `Model`, `Furniture`, `RoomStatus`, `RoomDesc`, `Wallpaper`, `Floor`, `RoomPass`) VALUES 
(1, 'woop?', 'Myrax', '0', '25', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx', 'model_a', '', 'open', 'Noob', '400', '400', 'Nabb'),
(2, 'test2', 'Myrax', '0', '25', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx', 'model_d', '', 'open', 'Noob', '400', '400', ''),
(3, 'test3', 'Myrax', '0', '25', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx', 'model_c', '', 'open', 'Noob', '400', '400', ''),
(4, 'sds d', 'Myrax', '0', '25', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx', 'model_b', '', 'open', 'Noob', '400', '400', ''),
(5, 'lui', 'Myrax', '0', '25', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx', 'model_f', '', 'open', 'Noob', '400', '400', ''),
(6, 'test', 'test', '0', '25', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx', 'model_d', '', 'open', 'Noob', '400', '400', ''),
(7, '11 room test', 'Myrax', '0', '25', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx', 'model_f', '', 'open', 'Noob', '400', '400', ''),
(8, 'aaaate', 'Myrax', '0', '25', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx', 'model_f', '', 'open', 'Noob', '400', '400', ''),
(9, 'tawt awrawawr', 'Myrax', '0', '25', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx', 'model_f', '', 'open', 'Noob', '400', '400', ''),
(10, 'asdsadwtae', 'Myrax', '0', '25', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx', 'model_f', '', 'open', 'Noob', '400', '400', ''),
(11, 'name much', 'Myrax', '0', '25', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx', 'model_f', '', 'open', 'Noob', '400', '400', ''),
(12, 'testz', 'Stephaani', '0', '25', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx', 'model_a', '', 'open', 'Noob', '400', '400', ''),
(13, 'OMG-ROOM-O-Matic!', 'Myrax', '0', '25', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx', 'model_a', '', 'open', 'Noob', '400', '400', '');

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

-- 
-- Table structure for table `pub_rooms`
-- 

CREATE TABLE `pub_rooms` (
  `RoomID` int(50) NOT NULL auto_increment,
  `RoomName` text NOT NULL,
  `AmountIn` int(3) NOT NULL,
  `MaxIn` int(3) NOT NULL,
  `DontKnow` text NOT NULL,
  `Heightmap` text NOT NULL,
  `RoomPart` text NOT NULL,
  `AHeightmap` text NOT NULL,
  `PStartingPos` text NOT NULL,
  PRIMARY KEY  (`RoomID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `pub_rooms`
-- 

INSERT INTO `pub_rooms` (`RoomID`, `RoomName`, `AmountIn`, `MaxIn`, `DontKnow`, `Heightmap`, `RoomPart`, `AHeightmap`, `PStartingPos`) VALUES 
(1, 'Main Lobby', 0, 25, '22009', 'lobby', 'lobby_a', '', ''),
(2, 'Club Massiva', 0, 25, '', 'bar', 'bar_a', '', ''),
(3, 'Cafe Ole', 0, 25, '', 'cafe', 'taivas_cafe', 'XXXXXXXXXXXXX111111X XXXXXXXXXXXXX1111111 XXXXXXXXXXXXX1111111 XXXXXXXXXXXXX1111111 XXXXXXXXXXXXX1111111 XXX11111111111111111 XXX11111111111111111 XX111111111111111111 XX111111111111111111 XX111111111111111111 XXX11111111111111111 111111111XXXXXXX1111 111111111X0000000000 111111111X0000000000 111111111X0000000000 111111111X0000000000 111111111X0000000000 111111111X0000000000 111111111X0000000000 111111111X0000000000 111111111X0000000000 X11111111X0000000000 XX1111111X0000000000 XXX111111X0000000000 XXXX11111X0000000000 XXXXX111110000000000 XXXXXX11110000000000 XXXXXXX1110000000000 XXXXXXXX11000000000X XXXXXXXXXX00000000XX XXXXXXXXXXXXXX00XXXX XXXXXXXXXXXXXX00XXXX', ' 14 30 '),
(4, 'Hotel Kitchen', 0, 25, '', 'kitchen', 'cr_kitchen', '', ''),
(5, 'The Dirty Duck Pub', 0, 25, '', 'pub', 'pub_a', '', '');

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

-- 
-- Table structure for table `system`
-- 

CREATE TABLE `system` (
  `IPAddress` text NOT NULL,
  `AmountOfPubRooms` int(50) NOT NULL,
  `Port` text NOT NULL,
  `AmountOfPrivRooms` bigint(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `system`
-- 

INSERT INTO `system` (`IPAddress`, `AmountOfPubRooms`, `Port`, `AmountOfPrivRooms`) VALUES 
('80.0.230.184', 5, '1337', 13);

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

-- 
-- Table structure for table `users`
-- 

CREATE TABLE `users` (
  `ID` int(26) NOT NULL auto_increment,
  `Username` varchar(24) NOT NULL,
  `Password` text NOT NULL,
  `Email` text NOT NULL,
  `Figure` text NOT NULL,
  `DirectMail` text NOT NULL,
  `DateOfBirth` text NOT NULL,
  `PhoneNumber` text NOT NULL,
  `Mission` text NOT NULL,
  `HasReadAgreement` text NOT NULL,
  `Sex` text NOT NULL,
  `Country` text NOT NULL,
  `Credits` int(11) NOT NULL,
  `Messenger` text NOT NULL,
  `Strip` text NOT NULL,
  `HasSpecialRights` int(10) NOT NULL default '0',
  `BadgeType` text NOT NULL,
  `LastOnline` text NOT NULL,
  `InRoom` text NOT NULL,
  `RoomCount` mediumint(5) NOT NULL,
  `OwnedRoomIDs` varchar(50) NOT NULL default ';',
  `Status` text NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- 
-- Dumping data for table `users`
-- 

INSERT INTO `users` (`ID`, `Username`, `Password`, `Email`, `Figure`, `DirectMail`, `DateOfBirth`, `PhoneNumber`, `Mission`, `HasReadAgreement`, `Sex`, `Country`, `Credits`, `Messenger`, `Strip`, `HasSpecialRights`, `BadgeType`, `LastOnline`, `InRoom`, `RoomCount`, `OwnedRoomIDs`, `Status`) VALUES 
(1, 'Myrax', 'lol123', 'iMyrax@googlemail.com', 'sd=001/0&hr=001/255,255,255&hd=002/255,204,153&ey=001/0&fc=001/255,204,153&bd=001/255,204,153&lh=001/255,204,153&rh=001/255,204,153&ch=001/232,177,55&ls=001/232,177,55&rs=001/232,177,55&lg=001/119,159,187&sh=001/175,220,223', '1', '18.12.1992', '+44', 'Myrax is kl mkay?', '1', 'Male', '', 999, 'Welcome to Nubz Hotel', '', 1, 'A', '4/11/2008 1:22:49 PM', '', 11, ';1;2;3;4;5;7;8;9;10;11;13;', 'online'),
(2, 'Test', 'lol123', 'lol@1.com', 'sd=001/0&hr=001/255,255,255&hd=002/255,204,153&ey=001/0&fc=001/255,204,153&bd=001/255,204,153&lh=001/255,204,153&rh=001/255,204,153&ch=001/232,177,55&ls=001/232,177,55&rs=001/232,177,55&lg=001/119,159,187&sh=001/175,220,223', '1', '18.12.1992', '+44', 'sds', '1', 'Male', '', 0, 'Welcome to Nubz Hotel', '0', 0, '', '08/04/2008 22:35:10', '', 1, ';6;', ''),
(3, 'test2', 'lol123', '1@2.com', 'sd=001/0&hr=001/255,255,255&hd=002/255,204,153&ey=001/0&fc=001/255,204,153&bd=001/255,204,153&lh=001/255,204,153&rh=001/255,204,153&ch=001/232,177,55&ls=001/232,177,55&rs=001/232,177,55&lg=001/119,159,187&sh=001/175,220,223', '1', '18.12.1992', '+44', '', '1', 'Male', '', 0, 'Welcome to Nubz Hotel', '0', 0, '', '01/04/2008 19:18:49', '', 0, ';', ''),
(6, 'Stephaani', 'lol123', 'stephaani@live.co.uk', 'sd=001/0&hr=015/50,50,53&hd=001/237,215,187&ey=002/0&fc=001/237,215,187&bd=001/237,215,187&lh=001/237,215,187&rh=001/237,215,187&ch=002/101,106,64&ls=001/101,106,64&rs=001/101,106,64&lg=006/255,255,255&sh=001/255,255,255', '1', '22.08.1992', '+44', 'I love dominic', '1', 'Female', '', 0, 'Welcome to Nubz Hotel', '0', 0, '', '09/04/2008 15:25:44', '', 1, ';12;', ''),
(7, 'Dominic', 'hello1', 'blah@blah.blah', 'sd=001/0&hr=024/200,210,230&hd=002/255,204,153&ey=001/0&fc=001/255,204,153&bd=001/255,204,153&lh=001/255,204,153&rh=001/255,204,153&ch=010/51,51,51&ls=001/51,51,51&rs=001/51,51,51&lg=004/102,102,102&sh=003/121,94,83', '1', '21.12.1991', '+44', '', '1', 'Male', '', 0, 'Welcome to Nubz Hotel', '0', 0, '', '09/04/2008 22:11:32', '', 0, ';', '');
