NexusServer v2 (C++/Qt)

**Aerospark** · 28-02-12

New updates!

I've implemented ConfigurationCore and LanguageCore. The server is now configurable, and language bindings can now be programmed. Also, I've implemented console missions, the accounts database has been modified to accommodate. I've also added a small tutorial to the first post explaining how to compile the server on either Windows, Linux, or Mac.

Here is the current english lang file, for anyone interested:

Spoiler:

and here is the config file, both are incomplete:

Spoiler:

Also, here is a specific list of the changes:
-Started implementing LanguageCore.
-Started coding ConfigurationCore.
-Fixed Opcode::RequestInitializeMessenger to work with console missions.
-Implemented Opcode::RequestSetConsoleMission.
-Added consolemission to the accounts table in the DB.
-Cleaned up the startup debugging.
-Switched the hardcoded strings in Protocol to the new language system.

Again sorry for the development slowness, I've been busy lately.

**Ayres** · 25-03-12

Great work so far. Just stay dedicated & don't give up like the rest of them. Keep it up.

**Aerospark** · 27-03-12

Originally Posted by Ayres

Great work so far. Just stay dedicated & don't give up like the rest of them. Keep it up.

:o thanks, yeah I definitely plan on finishing this (or at least coming close)

New revisions!

I've been working on the friend list/console/messenger/whatever on and off lately. I've implemented friend requests, but not accepting them, and started implementing the friend list packet. I've also created a new db for friends.

Specific changes:
-Continued work on the friends list
-Fixed friend request DB error
-Continued implementing friends
-Continued implementing friend requests
-Implemented ConfigurationCore::getBool(key) and implemented some db options
-The config, db, and lang file are now loaded from the run directory not the static path they were using before.
-Fixed a few things, implemented Opcode::requestStop stub

lang/config updates:

Spoiler:

As usual its all on the SVN.

**Zak©** · 27-03-12

Try out Github it's better than Svn ^_^

**Aerospark** · 27-03-12

Originally Posted by Zak©

Try out Github it's better than Svn ^_^

Actually we're planning on eventually putting a git server up on the nexustools server and eventually tying it together with the svn server, but that's a future project.

Hopefully I can get a preview compile out within the next few versions too.

**Ayres** · 01-04-12

Do you reckon you'll be able to put up a 24/7 test hotel?

**Aerospark** · 03-04-12

Originally Posted by Ayres

Do you reckon you'll be able to put up a 24/7 test hotel?

Yes actually, it wont be up forever, but I plan on having the testing server 24/7 once development gets a little farther (and I fix the compile issue im having with the nexustools server)

Again sorry for the slowed development, I've had a lot to deal with lately IRL. (funerals aren't fun)

However, I do plan on hopefully finishing the friend system soon, along with accepting/rejecting/viewing friend requests, and then I can move onto the message system

Pathfinding would have also been implemented quite a while ago. I have the logic written, but I still need to get a proper periodic/timed task execution system in place that makes use of the thread pool. I've also planned out (what I think) will be an efficient system for finding the walk height/status/sit height information of a tile as the pathfinder processes. I plan on using a similar system to how rooms handle their heightmaps for item placement now. Using something along the lines of float** heightmap, I can easily pull the data directly from its location in memory instead of processing additional logic like NexusServer did.

**Donkjam** · 17-04-12

thread re-opened due to owners request

**Shredinator** · 17-04-12

@Aerospark

My condolences. Good luck with development, I'm looking forward to seeing a C++ server.

**Aerospark** · 17-04-12

Thanks for re-opening the thread :)

Originally Posted by Shredinator

@Aerospark

My condolences. Good luck with development, I'm looking forward to seeing a C++ server.

:o thanks, yeah, the private server community, especially pertaining to this game is seriously lacking in C++ development.

I'll have updates in this post in a few minutes, we've been having some pretty intense wind tonight and there was just a 2 hour power outage :o

EDIT:
Updates:
I've coded a bit more of the messaging system, and I've also implemented parts of room info modification (name, desc)

specific changes:
-Partially implemented sending messsages in the console, added a DB table for messages
-Added a few new packet stubs
-Implemented room info modification, currently only name and desc are changeable.
-Cleaned up protocol.cpp a bit
-Implemented opcodes:
Opcode::RequestUpdateRoomInfo
Opcode::RequestUpdateRoomName
Opcode::RequestRollDie
Opcode::RequestSendMessage

As always its all available on the SVN.

EDIT: There are a few more revisions, and a new screenshot spoiler added to the first post

Again, I'd like to apologize to everyone for the slowed development lately, I definitely don't plan on stopping, hopefully things will speed up again at some point. Along with IRL events I've been dealing with, I've also had to put a good portion of my time to more critical projects. However, as I've said all along, I have no intention of stopping.

**Aerospark** · 20-04-12

New updates!

I've still been having issues with the NexusTools server, the testing sandbox would have been up long ago.

I've started work on some of the public room implementations. I've scrapped the old public rooms stub, and wrote out a proper packet for it. I've also just written a packet parser that dumps a public room navigator packet into SQL so I can get the data I needed. (though from the looks of it the packet I parsed was missing some of the public rooms data)

Here is the resulting SQL if anyone is interested in that (I'm still pretty new to SQL):

Spoiler:

Specific list of changes:
-Started properly implementing public rooms
-added DB table public rooms
-Updated public rooms db table, continued implementing public rooms in the navigator
-Implemented the public rooms navigator packet
-Imported some of the public room data

As usual its all on the SVN

**PRIZM** · 20-04-12

Cool, i am looking forward to see that. Oldschool is different to see in 2012, but some peoples is still using it. Good luck.

**Aerospark** · 30-04-12

I've finally got my computer working fully again, I wasn't able to do any development over the past few days because I needed to get a new graphics card. It's all up and running now though, and I plan on doing some coding today, expect updates in this post shortly.

I'll be doing some more tests with public rooms, and possibly finish up the console. I'm also going to take another look at the NexusTools server to see if I cant get the testing sandbox up again.

EDIT 1: I'm currently doing some work with public rooms, and if anyone has access to the old v9-v18 public room data (height maps, furniture locations, etc) that would be really helpful. -- I've found an old text database, and I'm having some luck writing a -> sql parser so this should be covered. (thanks "Bloodline v3")

EDIT 2: I've finished the parser, so now I can move on and hopefully get public rooms somewhat working today.

Here is the resulting SQL of the heightmaps for anyone interested (added door locations):

Spoiler:

Code:

INSERT INTO publicheights (id, model, pubmodel, map, doorx, doory, doorh) VALUES(0, 'hh_room_cinema', 'cinema_a', 'xxxxxxxxx77777777777xxxxx\rxxxxxxxxx777777777777xxxx\rxxxxxxxxx777777777766xxxx\rxxxxxxxxx777777777755xxxx\rxx333333333333333334433xx\rxx333333333333333333333xx\rxx333333333333333333333xx\r33333333333333333333333xx\r333333xxxxxxx3333333333xx\r333333xxxxxxx2222222222xx\r333333xxxxxxx2222222222xx\rxx3333xxxxxxx2222222222xx\rxx3333xxxxxxx222222221111\rxx3333xxxxxxx111111111111\r333333xxxxxxx111111111111\r3333333222211111111111111\r3333333222211111111111111\r3333333222211111111111111\rxx33333222211111111111111\rxx33333222211111111111111\rxx3333322221111111xxxxxxx\rxxxxxxx22221111111xxxxxxx\rxxxxxxx22221111111xxxxxxx\rxxxxxxx22221111111xxxxxxx\rxxxxxxx22221111111xxxxxxx\rxxxxxxx222x1111111xxxxxxx\rxxxxxxx222x1111111xxxxxxx\rxxxxxxxxxxxx11xxxxxxxxxxx\rxxxxxxxxxxxx11xxxxxxxxxxx\rxxxxxxxxxxxx11xxxxxxxxxxx\rxxxxxxxxxxxx11xxxxxxxxxxx\r', 12, 27, 1);
INSERT INTO publicheights (id, model, pubmodel, map, doorx, doory, doorh) VALUES(1, 'hh_room_lobby', 'lobby_a', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx7xxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx777xxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx7777777xxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx77777777xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx77777777xxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx777777777xxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx7xxx777777xxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx7x777777777xxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx7xxx77777777xxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx7x777777777x7xxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx7xxx7777777777xxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx777777777777xxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx77777777777x2111xxxxxxxxxxxx\rxxxxxxxxxxxxxxx7777777777x221111xxxxxxxxxxx\rxxxxxxxxx7777777777777777x2211111xxxxxxxxxx\rxxxxxxxxx7777777777777777x22211111xxxxxxxxx\rxxxxxxxxx7777777777777777x222211111xxxxxxxx\rxxxxxx77777777777777777777x222211111xxxxxxx\rxxxxxx7777777xx777777777777x222211111xxxxxx\rxxxxxx7777777xx77777777777772222111111xxxxx\rxxxxxx777777777777777777777x22221111111xxxx\rxx7777777777777777777777x322222211111111xxx\r77777777777777777777777x33222222111111111xx\r7777777777777777777777x333222222211111111xx\rxx7777777777777777777x333322222222111111xxx\rxx7777777777777777777333332222222221111xxxx\rxx777xxx777777777777733333222222222211xxxxx\rxx777x7x77777777777773333322222222222xxxxxx\rxx777x7x7777777777777x33332222222222xxxxxxx\rxxx77x7x7777777777777xx333222222222xxxxxxxx\rxxxx77777777777777777xxx3222222222xxxxxxxxx\rxxxxx777777777777777777xx22222222xxxxxxxxxx\rxxxxxx777777777777777777x2222222xxxxxxxxxxx\rxxxxxxx777777777777777777222222xxxxxxxxxxxx\rxxxxxxxx7777777777777777722222xxxxxxxxxxxxx\rxxxxxxxxx77777777777777772222xxxxxxxxxxxxxx\rxxxxxxxxxx777777777777777222xxxxxxxxxxxxxxx\rxxxxxxxxxxx77777777777777x2xxxxxxxxxxxxxxxx\rxxxxxxxxxxxx77777777777777xxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxx777777777777xxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx7777777777xxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx77777777xxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxx777777xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx7777xxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxx77xxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r', 1, 25, 7);
INSERT INTO publicheights (id, model, pubmodel, map, doorx, doory, doorh) VALUES(2, 'hh_room_pool,hh_people_pool', 'pool_a', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx7xxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx777xxxxxxxxxxx\rxxxxxxxxxxxxxxxxxx8888888x7xxx77777xxxxxxxxxx\rxxxxxxxxxxxxxxxxxx8888888x7xxx777777xxxxxxxxx\rxxxxxxxxxxxxxxxx88xxxxx77x7x777777777xxxxxxxx\rxxxxxxxxxxxxxxxx88x7777777777777777777xxxxxxx\rxxxxxxxxxxxxxxxx88x77777777777777777777xxxxxx\rxxxxxxxxxxxxxx9988x77777777777777777777xxxxxx\rxxxxxxxxxxxxxx9988x7777777777777777777x00xxxx\rxxxxxxxxxxxxxx9988x777777777777777777x0000xxx\rxxxxxxxxxxxxxx9988x7777777x0000000000000000xx\rxxxxxxxxxxxxxx9988x777777x000000000000000000x\r7777777777xxxx9988777777x0x0000000000000000xx\rx7777777777xxx998877777x000x00000000000000xxx\rxx7777777777xx99887777x00000x000000000000xxxx\rxxx7777777777x9988777x0000000x0000000000xxxxx\rxxxx777777777x777777x00000000x000000000xxxxxx\rxxxxx777777777777777000000000x00000000xxxxxxx\rxxxxxx77777777777777000000000x0000000xxxxxxxx\rxxxxxxx777777x7777770000000000xxxx00xxxxxxxxx\rxxxxxxxx77777777777xx0000000000000xxxxxxxxxxx\rxxxxxxxxx777777110000x000000000000xxxxxxxxxxx\rxxxxxxxxxx7x77x1100000x0000000000xxxxxxxxxxxx\rxxxxxxxxxxx777x11000000x00000000xxxxxxxxxxxxx\rxxxxxxxxxxxx771110000000x000000xxxxxxxxxxxxxx\rxxxxxxxxxxxxx111100000000x0000xxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx11100000000x000xxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxx1100000000x00xxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxx110000000x0xxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx110000000xxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxx1100000xxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxx11000xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxx110xxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxx1xxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r', 2, 15, 0);
INSERT INTO publicheights (id, model, pubmodel, map, doorx, doory, doorh) VALUES(3, 'hh_room_rooftop', 'rooftop', 'x0000x000\rxxxxxx000\r000000000\r000000000\r000000000\r000000000\r000000000\r000000000\r000000000\r000000000\rxxx000xxx\rxxx000xxx\r', 4, 9, 0);
INSERT INTO publicheights (id, model, pubmodel, map, doorx, doory, doorh) VALUES(4, 'hh_room_ballroom', 'ballroom', 'xxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxx3333x33333333x\r333333xx3333x33333333x\r3333333x3333x33333333x\r3333333x3333x33333333x\r3333333xxxxxx33333333x\r333333333333333333333x\r333333333333333333333x\r333333333333333333333x\r333333333333333333333x\r33333333222x333333333x\r33333333222x333333333x\r33333333222x333333333x\r33333333222x333333333x\r33333333111x333333333x\r33333333111x333333333x\r33333333111x333333333x\rxxxxxxxx111xxxxxxxxxxx\r11111111111111111111xx\r1111111111111111111111\r1111111111111111111111\r11111111111111111111xx\r', 19, 20, 0);
INSERT INTO publicheights (id, model, pubmodel, map, doorx, doory, doorh) VALUES(5, 'hh_room_theater', 'theater', 'xxxxxxxxxxxxxxxx000000\rxxxxx0xxxxxxxxxx000000\rxxxxx00000000xxx000000\rxxxxx000000000xx000000\r0000000000000000000000\r0000000000000000000000\r0000000000000000000000\r0000000000000000000000\r0000000000000000000000\rxxxxx000000000000000xx\rxxxxx000000000000000xx\rx0000000000000000000xx\rx0000000000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxxx0000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxx000000000000xxxxx\rxxxxx000000000000xxxxx\r', 2, 11, 0);
INSERT INTO publicheights (id, model, pubmodel, map, doorx, doory, doorh) VALUES(6, 'hh_room_theater_axe', 'theater', 'xxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxx111111111xxxxxxx\rxxxxxxx11111111100000xx\rxxxx00x11111111100000xx\rxxxx00x11111111100000xx\r4xxx00x11111111100000xx\r4440000xxxxxxxxx00000xx\r444000000000000000000xx\r4xx000000000000000000xx\r4xx0000000000000000000x\r44400000000000000000000\r44400000000000000000000\r44x0000000000000000o000\r44x11111111111111111000\r44x11111111111111111000\r33x11111111111111111000\r22x11111111111111111000\r22x11111111111111111000\r22x11111111111111111000\r22x11111111111111111000\r22x11111111111111111000\r22211111111111111111000\r22211111111111111111000\rxxxxxxxxxxxxxxxxxxxx00x\rxxxxxxxxxxxxxxxxxxxx00x\r', 20, 27, 0);
INSERT INTO publicheights (id, model, pubmodel, map, doorx, doory, doorh) VALUES(7, 'hh_room_theater_easter', 'theater', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0xxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx00xxxxxxxxxxxx\rxxxxxxxxxxxxx0x00xxxxxxxxxxx0x000xxxxxxxxxxx\rxxxxxxxxxxxx0000000000000000000000xxxxxxxxxx\rxxxxxxxxxxx000000000000000000000000xxxxxxxxx\rxxxxxxxxxxx0000000000000000000000000xxxxxxxx\rxxxxxxxxxxx00000000000000000000000000xxxxxxx\rxxxxxxxx000000000000000000000000000000xxxxxx\rxxxxxxx00000000000000000000000000000000xxxxx\rxxxxxxx000000000000000000000000000000000xxxx\rxxxxxxx0000000000000000000000000000000000xxx\rxxxxxxxxx000000000000000000000000000000000xx\r00000000000000000000xx00000000000000000000xx\r0000000000000000000xxxx00000000000xxxxxxx0xx\r0000000000000000000xxxx00000000000x00000xxxx\rxxxxx00x0000000000xxxxx0xxxxxx0000x0000000xx\rxxxxx0000000000000xxxxx0xx000x0000x000000xxx\rxxxxx0000000000000xxxxx0x000000000x00000xxxx\rxxxxx00000000000000xxxx0x000000000xxx00xxxxx\rxxxxxxxx00000000000xxx00xxx000000x0000xxxxxx\rxxxxxxxx0000000000xxxx0x0000000000000xxxxxxx\rxxxxxxxx0000000000011100000000000000xxxxxxxx\rxxxxxxxx000000000001110000000000000xxxxxxxxx\rxxxxxxxxx00x0000000111000000000x00xxxxxxxxxx\rxxxxxxxxxx0x0000000xxx0000000xxxxxxxxxxxxxxx\rxxxxxxxxxxxx000000xxxx0000000xxxxxxxxxxxxxxx\rxxxxxxxxxxxx000000xxx00xxxxx00xxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx0xxx0xx000x00xxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx0xxx0x000000xxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx0xxx0x00000xxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx0xxxxx00xxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx0xxxxx0xxxxxxxxxxxxxxxxxxxx\r', 2, 15, 0);
INSERT INTO publicheights (id, model, pubmodel, map, doorx, doory, doorh) VALUES(8, 'hh_room_park_de,hh_room_park', 'hh_room_park_de,hh_room_park', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxx00000000xxxxxxxxxxxx\rxxxxxxxxxxxxxx1000000000xxxxxxxxxxxx\rxxxxxxxxxxxxxx1xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx1xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx1xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx1xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx1xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx1xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx1xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxx1xx000x000xx111x111xxx\rxxxxxxxxxxxxxx1xx000x000xxxxxx1111xx\rxxxxxxxxxxxxxx1xx000x000x111111111xx\rxxxxxxxxxxxxxx1xx000x000x111111111xx\rxxx111111111111xx000x000x111111111xx\rxxx1xxxxxxxxxxxxx000x000x111111111xx\rxxx1x1111111111000000000x111111111xx\rxxx1x1111111111000000000xx1111111xxx\rxxx1x11xxxxxx11000000000xx1111111100\rxxx111xxxxxxx11000000000011111111100\rxxx111xxxxxxx11000000000011111111100\rxxxxx1xxxxxxx11000000000011111111100\rxxxxx11xxxxxx11000000000xx1111111100\rxxxxx1111111111000000000xx1111111xxx\rxxxxx1111111111xx000x000x111111111xx\rxxxxxxxxxxxxxxxxx000x000x111111111xx\rxxxxxxxxxxxxxxxxx000x000x111111111xx\rxxxxxxxxxxxxxxxxx000x000x111111111xx\rxxxxxxxxxxxxxxxxx000x000x111111111xx\rxxxxxxxxxxxxxxxxx000x00xx11xxxx111xx\rxxxxxxxxxxxxxxxxxxxxxxxxxx11111111xx\r', 35, 22, 0);
INSERT INTO publicheights (id, model, pubmodel, map, doorx, doory, doorh) VALUES(9, 'hh_room_orient', 'hh_room_orient', '22222222222222222222xxx\r22222222222222222222xxx\r22222222222222222222xxx\r22222222222222222222xxx\rxxxxxxxxxxxxxxxx1111xxx\rxxxxxxxxxxxxxxxx0000xxx\rxxx00000000000000000xxx\r00000000000000000000xxx\r00000000000000000000xxx\r00000000000000000000000\r00000000000000000000000\r00000000000000000000xxx\r00000000000000000000xxx\r00000000000000000000xxx\rxxx00000000000000000xxx\r', 21, 10, 0);
INSERT INTO publicheights (id, model, pubmodel, map, doorx, doory, doorh) VALUES(10, 'hh_room_habburger', 'habburger', 'x0xxxx000xxxx000x0x\rx000000000000000000\rx000000000000000000\rx000000000000000xxx\rx00xxxx00xxxx000xxx\rx00xxxx00xxxx00xxxx\rx00000000000000xxxx\rx00000000000000xxxx\rx00000000000000xxxx\rx00xxxxxxxxxx00xxxx\rx00xxxxxxxxxx00xxxx\rx00xxxxxxxxxx000xxx\r0000000000000000xxx\r000000000000000xxxx\r000000000000000xxxx\r000xxx0000xxx00xxxx\r000xxx0000xxx00xxxx\r000000000000000xxxx\r000000000000000xxxx\r000000000000000xxxx\rxxxxxxx00xxxxxxxxxx\rxxxxxxx00xxxxxxxxxx\rxxxxxxx00xxxxxxxxxx', 7, 21, 0);
INSERT INTO publicheights (id, model, pubmodel, map, doorx, doory, doorh) VALUES(11, 'hh_room_kitchen', 'hh_room_kitchen', 'xxxxxxx1xx11111111xxxxxx\rxxx1111111111111111xxxxx\rxxx111xxxx1111111111xxxx\rxxxx2xxxxxxxxxxxxxxxxxxx\rxx3x3x333311xxxxxxxxxx11\rxx3333333311111111111111\rxx3333333311111111111111\rxx3333333311111111122111\rxx3333333311x22222222111\rxx3333333311x22222222111\rxx3333333311x22222222111\rxx3333333311111111111111\rxx3333333311111111111111\rxx3333333311111111111111\rxx3333333311111xxxx11111\rxx3333333311111xxxx11111\rxx3333333311111xxxx11111\rxx3333333311111xxxx11111\rxx3333333311111xxxx11111\rxx3333333311111xxxx11111\rxx3333333311111xxxx11111\r333333332111111xxxx11111\r333333332111111111111111\r333333332111111111111111\r333333332111111111111111\rxx3333332111111111111111\rxxxxxxxxxxxxxxxxxxx11111\rxxxxxxxxxxxxxxxxxxx11111\rxxxxxxxxxxxxxxxxxxx11111\r', 20, 27, 0);
INSERT INTO publicheights (id, model, pubmodel, map, doorx, doory, doorh) VALUES(12, 'hh_room_nlobby', 'newbie_lobby', 'xxxxxxxxxxxxxxxx000000\rxxxxx0xxxxxxxxxx000000\rxxxxx00000000xxx000000\rxxxxx000000000xx000000\r0000000000000000000000\r0000000000000000000000\r0000000000000000000000\r0000000000000000000000\r0000000000000000000000\rxxxxx000000000000000xx\rxxxxx000000000000000xx\rx0000000000000000000xx\rx0000000000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxxx0000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxx000000000000xxxxx\rxxxxx000000000000xxxxx\r', 2, 11, 2);

EDIT 3:
And here is the furniture SQL for anyone who might need it: (column names may be incorrect)

Spoiler:

Code:

   -- hh_room_theater

INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(1, 'hh_room_theater', 'mic', 11, 10, 1, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(2, 'hh_room_theater', 'thchair2', 2, 11, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(3, 'hh_room_theater', 'thchair2', 2, 12, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(4, 'hh_room_theater', 'thchair2', 2, 15, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(5, 'hh_room_theater', 'thchair1', 6, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(6, 'hh_room_theater', 'thchair1', 7, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(7, 'hh_room_theater', 'thchair1', 8, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(8, 'hh_room_theater', 'thchair1', 9, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(9, 'hh_room_theater', 'thchair1', 10, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(10, 'hh_room_theater', 'thchair1', 12, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(11, 'hh_room_theater', 'thchair1', 13, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(12, 'hh_room_theater', 'thchair1', 14, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(13, 'hh_room_theater', 'thchair1', 15, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(14, 'hh_room_theater', 'thchair1', 16, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(15, 'hh_room_theater', 'thchair2', 2, 16, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(16, 'hh_room_theater', 'thchair1', 6, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(17, 'hh_room_theater', 'thchair1', 7, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(18, 'hh_room_theater', 'thchair1', 8, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(19, 'hh_room_theater', 'thchair1', 9, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(20, 'hh_room_theater', 'thchair1', 10, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(21, 'hh_room_theater', 'thchair1', 12, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(22, 'hh_room_theater', 'thchair1', 13, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(23, 'hh_room_theater', 'thchair1', 14, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(24, 'hh_room_theater', 'thchair1', 15, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(25, 'hh_room_theater', 'thchair1', 16, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(26, 'hh_room_theater', 'thchair1', 6, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(27, 'hh_room_theater', 'thchair1', 7, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(28, 'hh_room_theater', 'thchair1', 8, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(29, 'hh_room_theater', 'thchair1', 9, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(30, 'hh_room_theater', 'thchair1', 10, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(31, 'hh_room_theater', 'thchair1', 12, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(32, 'hh_room_theater', 'thchair1', 13, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(33, 'hh_room_theater', 'thchair1', 14, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(34, 'hh_room_theater', 'thchair1', 15, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(35, 'hh_room_theater', 'thchair1', 16, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(36, 'hh_room_theater', 'thchair1', 6, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(37, 'hh_room_theater', 'thchair1', 7, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(38, 'hh_room_theater', 'thchair1', 8, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(39, 'hh_room_theater', 'thchair1', 9, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(40, 'hh_room_theater', 'thchair1', 10, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(41, 'hh_room_theater', 'thchair1', 12, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(42, 'hh_room_theater', 'thchair1', 13, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(43, 'hh_room_theater', 'thchair1', 14, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(44, 'hh_room_theater', 'thchair1', 15, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(45, 'hh_room_theater', 'thchair1', 16, 26, 1, 0, 'sit');


   -- hh_room_lobby

INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(46, 'hh_room_lobby', 'flower1', 9, 0, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(47, 'hh_room_lobby', 'chairf2b', 11, 0, 7, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(48, 'hh_room_lobby', 'chairf2', 12, 0, 7, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(49, 'hh_room_lobby', 'table1', 13, 0, 7, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(50, 'hh_room_lobby', 'chairf2b', 14, 0, 7, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(51, 'hh_room_lobby', 'chairf2', 15, 0, 7, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(52, 'hh_room_lobby', 'watermatic', 16, 0, 7, 4, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(53, 'hh_room_lobby', 'telkka', 9, 2, 7, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(54, 'hh_room_lobby', 'flower1', 9, 3, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(55, 'hh_room_lobby', 'chairf2d', 11, 3, 7, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(56, 'hh_room_lobby', 'chairf2', 12, 3, 7, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(57, 'hh_room_lobby', 'table1', 13, 3, 7, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(58, 'hh_room_lobby', 'chairf2d', 14, 3, 7, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(59, 'hh_room_lobby', 'chairf2', 15, 3, 7, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(60, 'hh_room_lobby', 'flower1', 12, 4, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(61, 'hh_room_lobby', 'flower1', 16, 4, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(62, 'hh_room_lobby', 'chairf2b', 0, 7, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(63, 'hh_room_lobby', 'chairf2', 1, 7, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(64, 'hh_room_lobby', 'chairf2d', 0, 10, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(65, 'hh_room_lobby', 'chairf2', 1, 10, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(66, 'hh_room_lobby', 'roommatic', 21, 12, 1, 4, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(67, 'hh_room_lobby', 'roommatic', 22, 12, 1, 4, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(68, 'hh_room_lobby', 'roommatic', 23, 12, 1, 4, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(69, 'hh_room_lobby', 'roommatic', 24, 12, 1, 4, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(70, 'hh_room_lobby', 'chairf2b', 0, 14, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(71, 'hh_room_lobby', 'chairf2', 1, 14, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(72, 'hh_room_lobby', 'watermatic', 13, 14, 1, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(73, 'hh_room_lobby', 'watermatic', 12, 15, 1, 4, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(74, 'hh_room_lobby', 'chairf1', 19, 16, 1, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(75, 'hh_room_lobby', 'table2c', 21, 16, 1, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(76, 'hh_room_lobby', 'chairf1', 23, 16, 1, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(77, 'hh_room_lobby', 'chairf2d', 0, 17, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(78, 'hh_room_lobby', 'chairf2', 1, 17, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(79, 'hh_room_lobby', 'table2b', 21, 17, 1, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(80, 'hh_room_lobby', 'chairf1', 19, 18, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(81, 'hh_room_lobby', 'table2', 21, 18, 1, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(82, 'hh_room_lobby', 'chairf1', 23, 18, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(83, 'hh_room_lobby', 'chairf2b', 7, 21, 2, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(84, 'hh_room_lobby', 'chairf2c', 7, 22, 2, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(85, 'hh_room_lobby', 'chairf2c', 7, 23, 2, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(86, 'hh_room_lobby', 'chairf2c', 7, 24, 2, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(87, 'hh_room_lobby', 'chairf2', 7, 25, 2, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(88, 'hh_room_lobby', 'table1', 7, 26, 2, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(89, 'hh_room_lobby', 'flower2', 10, 26, 1, 2, '');


   -- hh_room_pool,hh_people_pool

INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(90, 'hh_room_pool,hh_people_pool', 'flower2b', 2, 28, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(91, 'hh_room_pool,hh_people_pool', 'flower2a', 2, 29, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(92, 'hh_room_pool,hh_people_pool', 'flower2b', 19, 30, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(93, 'hh_room_pool,hh_people_pool', 'flower2a', 19, 31, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(94, 'hh_room_pool,hh_people_pool', 'box', 6, 32, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(95, 'hh_room_pool,hh_people_pool', 'flower1', 13, 33, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(96, 'hh_room_pool,hh_people_pool', 'pool_chairy', 10, 34, 7, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(97, 'hh_room_pool,hh_people_pool', 'umbrellay', 8, 35, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(98, 'hh_room_pool,hh_people_pool', 'pool_chairy', 9, 35, 7, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(99, 'hh_room_pool,hh_people_pool', 'pool_tabley', 10, 35, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(100, 'hh_room_pool,hh_people_pool', 'pool_chairy', 11, 35, 7, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(101, 'hh_room_pool,hh_people_pool', 'umbrellap', 15, 35, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(102, 'hh_room_pool,hh_people_pool', 'pool_chairy', 10, 36, 7, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(103, 'hh_room_pool,hh_people_pool', 'pool_chairp', 15, 36, 7, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(104, 'hh_room_pool,hh_people_pool', 'pool_chairo', 22, 36, 7, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(105, 'hh_room_pool,hh_people_pool', 'pool_chairp', 14, 37, 7, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(106, 'hh_room_pool,hh_people_pool', 'pool_tablep', 15, 37, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(107, 'hh_room_pool,hh_people_pool', 'pool_chairp', 16, 37, 7, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(108, 'hh_room_pool,hh_people_pool', 'umbrellao', 20, 37, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(109, 'hh_room_pool,hh_people_pool', 'pool_chairo', 21, 37, 7, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(110, 'hh_room_pool,hh_people_pool', 'pool_tabo', 22, 37, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(111, 'hh_room_pool,hh_people_pool', 'pool_chairo', 22, 38, 7, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(112, 'hh_room_pool,hh_people_pool', 'pool_chairg', 18, 42, 7, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(113, 'hh_room_pool,hh_people_pool', 'umbrellag', 16, 43, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(114, 'hh_room_pool,hh_people_pool', 'pool_chairg', 17, 43, 7, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(115, 'hh_room_pool,hh_people_pool', 'pool_tablg', 18, 43, 7, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(116, 'hh_room_pool,hh_people_pool', 'pool_chairg', 19, 43, 7, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(117, 'hh_room_pool,hh_people_pool', 'pool_chairg', 18, 44, 7, 0, 'sit');


   -- hh_room_rooftop

INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(118, 'hh_room_rooftop', 'rooftop_minichair', 0, 1, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(119, 'hh_room_rooftop', 'rooftop_flatcurb', 16, 1, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(120, 'hh_room_rooftop', 'rooftop_flatcurb2', 17, 1, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(121, 'hh_room_rooftop', 'rooftop_rodtable', 0, 2, 4, 0, 'solid');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(122, 'hh_room_rooftop', 'rooftop_minichair', 1, 2, 4, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(123, 'hh_room_rooftop', 'rooftop_minichair', 0, 3, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(124, 'hh_room_rooftop', 'rooftop_flatcurb', 16, 4, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(125, 'hh_room_rooftop', 'rooftop_flatcurb2', 17, 4, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(126, 'hh_room_rooftop', 'rooftop_minichair', 2, 6, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(127, 'hh_room_rooftop', 'rooftop_minichair', 1, 7, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(128, 'hh_room_rooftop', 'rooftop_rodtable', 2, 7, 4, 0, 'solid');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(129, 'hh_room_rooftop', 'rooftop_minichair', 3, 7, 4, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(130, 'hh_room_rooftop', 'rooftop_minichair', 2, 8, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(131, 'hh_room_rooftop', 'rooftop_minichair', 0, 9, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(132, 'hh_room_rooftop', 'rooftop_emptytable', 0, 10, 4, 0, 'solid');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(133, 'hh_room_rooftop', 'rooftop_minichair', 0, 11, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(134, 'hh_room_rooftop', 'rooftop_flatcurb', 1, 13, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(135, 'hh_room_rooftop', 'rooftop_flatcurb', 6, 13, 4, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(136, 'hh_room_rooftop', 'rooftop_flatcurb', 8, 13, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(137, 'hh_room_rooftop', 'rooftop_flatcurb', 13, 13, 4, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(138, 'hh_room_rooftop', 'rooftop_flatcurb3', 1, 14, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(139, 'hh_room_rooftop', 'rooftop_flatcurb3', 6, 14, 4, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(140, 'hh_room_rooftop', 'rooftop_flatcurb3', 8, 14, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(141, 'hh_room_rooftop', 'rooftop_flatcurb3', 13, 14, 4, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(142, 'hh_room_rooftop', 'rooftop_flatcurb3', 1, 15, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(143, 'hh_room_rooftop', 'rooftop_flatcurb3', 6, 15, 4, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(144, 'hh_room_rooftop', 'rooftop_flatcurb3', 8, 15, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(145, 'hh_room_rooftop', 'rooftop_flatcurb3', 13, 15, 4, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(146, 'hh_room_rooftop', 'rooftop_flatcurb3', 1, 16, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(147, 'hh_room_rooftop', 'rooftop_flatcurb3', 6, 16, 4, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(148, 'hh_room_rooftop', 'rooftop_flatcurb3', 8, 16, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(149, 'hh_room_rooftop', 'rooftop_flatcurb3', 13, 16, 4, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(150, 'hh_room_rooftop', 'rooftop_flatcurb4', 1, 17, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(151, 'hh_room_rooftop', 'rooftop_flatcurb3', 2, 17, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(152, 'hh_room_rooftop', 'rooftop_flatcurb3', 3, 17, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(153, 'hh_room_rooftop', 'rooftop_flatcurb3', 4, 17, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(154, 'hh_room_rooftop', 'rooftop_flatcurb3', 5, 17, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(155, 'hh_room_rooftop', 'rooftop_flatcurb5', 6, 17, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(156, 'hh_room_rooftop', 'rooftop_flatcurb4', 8, 17, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(157, 'hh_room_rooftop', 'rooftop_flatcurb3', 9, 17, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(158, 'hh_room_rooftop', 'rooftop_flatcurb3', 10, 17, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(159, 'hh_room_rooftop', 'rooftop_flatcurb3', 11, 17, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(160, 'hh_room_rooftop', 'rooftop_flatcurb3', 12, 17, 4, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(161, 'hh_room_rooftop', 'rooftop_flatcurb5', 13, 17, 4, 0, 'sit');


   -- hh_room_ballroom

INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(162, 'hh_room_ballroom', 'broom_bench1', 4, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(163, 'hh_room_ballroom', 'broom_bench2', 5, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(164, 'hh_room_ballroom', 'broom_bench3', 6, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(165, 'hh_room_ballroom', 'broom_bench1', 7, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(166, 'hh_room_ballroom', 'broom_bench2', 8, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(167, 'hh_room_ballroom', 'broom_bench2', 9, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(168, 'hh_room_ballroom', 'broom_bench3', 10, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(169, 'hh_room_ballroom', 'broom_bench1', 11, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(170, 'hh_room_ballroom', 'broom_bench2', 12, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(171, 'hh_room_ballroom', 'broom_bench2', 13, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(172, 'hh_room_ballroom', 'broom_bench2', 14, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(173, 'hh_room_ballroom', 'broom_bench3', 15, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(174, 'hh_room_ballroom', 'broom_bench1', 16, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(175, 'hh_room_ballroom', 'broom_bench2', 17, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(176, 'hh_room_ballroom', 'broom_bench2', 18, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(177, 'hh_room_ballroom', 'broom_bench3', 19, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(178, 'hh_room_ballroom', 'broom_bench1', 20, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(179, 'hh_room_ballroom', 'broom_bench2', 21, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(180, 'hh_room_ballroom', 'broom_bench3', 22, 0, 4, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(181, 'hh_room_ballroom', 'broom_seatb1', 7, 3, 2, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(182, 'hh_room_ballroom', 'broom_seatb2', 8, 3, 2, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(183, 'hh_room_ballroom', 'broom_seatb3', 9, 3, 2, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(184, 'hh_room_ballroom', 'broom_seatb4', 10, 3, 2, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(185, 'hh_room_ballroom', 'broom_seat1', 16, 3, 2, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(186, 'hh_room_ballroom', 'broom_seat2', 17, 3, 2, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(187, 'hh_room_ballroom', 'broom_seat3', 18, 3, 2, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(188, 'hh_room_ballroom', 'broom_seat4', 19, 3, 2, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(189, 'hh_room_ballroom', 'broom_seatb1', 7, 6, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(190, 'hh_room_ballroom', 'broom_seatb2', 8, 6, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(191, 'hh_room_ballroom', 'broom_seatb3', 9, 6, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(192, 'hh_room_ballroom', 'broom_seatb4', 10, 6, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(193, 'hh_room_ballroom', 'broom_seat1', 16, 6, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(194, 'hh_room_ballroom', 'broom_seat2', 17, 6, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(195, 'hh_room_ballroom', 'broom_seat3', 18, 6, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(196, 'hh_room_ballroom', 'broom_seat4', 19, 6, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(197, 'hh_room_ballroom', 'broom_chair', 19, 10, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(198, 'hh_room_ballroom', 'broom_chair', 20, 10, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(199, 'hh_room_ballroom', 'broom_chair', 21, 10, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(200, 'hh_room_ballroom', 'broom_table1', 19, 11, 0, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(201, 'hh_room_ballroom', 'broom_table2', 20, 11, 0, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(202, 'hh_room_ballroom', 'broom_table3', 21, 11, 0, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(203, 'hh_room_ballroom', 'broom_chair', 19, 12, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(204, 'hh_room_ballroom', 'broom_chair', 20, 12, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(205, 'hh_room_ballroom', 'broom_chair', 21, 12, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(206, 'hh_room_ballroom', 'broom_chair', 19, 15, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(207, 'hh_room_ballroom', 'broom_chair', 20, 15, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(208, 'hh_room_ballroom', 'broom_chair', 21, 15, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(209, 'hh_room_ballroom', 'broom_table1', 19, 16, 0, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(210, 'hh_room_ballroom', 'broom_table2', 20, 16, 0, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(211, 'hh_room_ballroom', 'broom_table3', 21, 16, 0, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(212, 'hh_room_ballroom', 'broom_chair', 19, 17, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(213, 'hh_room_ballroom', 'broom_chair', 20, 17, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(214, 'hh_room_ballroom', 'broom_chair', 21, 17, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(215, 'hh_room_ballroom', 'broom_stool', 9, 20, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(216, 'hh_room_ballroom', 'broom_stool', 9, 21, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(217, 'hh_room_ballroom', 'broom_stool', 9, 22, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(218, 'hh_room_ballroom', 'broom_stool', 9, 23, 1, 2, 'sit');


   -- hh_room_tearoom

INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(219, 'hh_room_tearoom', 'hardwoodsofa1', 13, 1, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(220, 'hh_room_tearoom', 'hardwoodsofa2', 14, 1, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(221, 'hh_room_tearoom', 'hardwoodsofa3', 15, 1, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(222, 'hh_room_tearoom', 'teabamboo', 16, 1, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(223, 'hh_room_tearoom', 'hardwoodsofa1', 18, 1, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(224, 'hh_room_tearoom', 'hardwoodsofa2', 19, 1, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(225, 'hh_room_tearoom', 'hardwoodsofa3', 20, 1, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(226, 'hh_room_tearoom', 'teasmalltable1', 13, 3, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(227, 'hh_room_tearoom', 'teasmalltable2', 15, 3, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(228, 'hh_room_tearoom', 'teasmalltable1', 18, 3, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(229, 'hh_room_tearoom', 'teasmalltable2', 20, 3, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(230, 'hh_room_tearoom', 'teastool', 2, 6, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(231, 'hh_room_tearoom', 'teastool', 3, 6, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(232, 'hh_room_tearoom', 'chinastoolred', 8, 6, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(233, 'hh_room_tearoom', 'chinastoolred', 9, 6, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(234, 'hh_room_tearoom', 'chinastoolred', 10, 6, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(235, 'hh_room_tearoom', 'chinastoolred', 11, 6, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(236, 'hh_room_tearoom', 'teatable1', 2, 8, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(237, 'hh_room_tearoom', 'teatable2', 3, 8, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(238, 'hh_room_tearoom', 'teastool2', 2, 9, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(239, 'hh_room_tearoom', 'teastool2', 3, 9, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(240, 'hh_room_tearoom', 'teastool', 16, 9, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(241, 'hh_room_tearoom', 'teastool', 17, 9, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(242, 'hh_room_tearoom', 'teatable1', 16, 11, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(243, 'hh_room_tearoom', 'teatable2', 17, 11, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(244, 'hh_room_tearoom', 'teastool', 2, 12, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(245, 'hh_room_tearoom', 'teastool', 3, 12, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(246, 'hh_room_tearoom', 'teastool2', 16, 12, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(247, 'hh_room_tearoom', 'teastool2', 17, 12, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(248, 'hh_room_tearoom', 'teatable1', 2, 14, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(249, 'hh_room_tearoom', 'teatable2', 3, 14, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(250, 'hh_room_tearoom', 'teastool2', 2, 15, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(251, 'hh_room_tearoom', 'teastool2', 3, 15, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(252, 'hh_room_tearoom', 'teavase', 0, 18, 1, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(253, 'hh_room_tearoom', 'chinastoolgreen', 0, 19, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(254, 'hh_room_tearoom', 'chinastoolgreen', 0, 20, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(255, 'hh_room_tearoom', 'teavase', 0, 21, 1, 0, '');


   -- hh_room_theater_axe

INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(256, 'hh_room_theater_axe', 'mic', 11, 10, 1, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(257, 'hh_room_theater_axe', 'thchair2', 2, 11, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(258, 'hh_room_theater_axe', 'thchair2', 2, 12, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(259, 'hh_room_theater_axe', 'thchair2', 2, 15, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(260, 'hh_room_theater_axe', 'thchair1', 6, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(261, 'hh_room_theater_axe', 'thchair1', 7, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(262, 'hh_room_theater_axe', 'thchair1', 8, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(263, 'hh_room_theater_axe', 'thchair1', 9, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(264, 'hh_room_theater_axe', 'thchair1', 10, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(265, 'hh_room_theater_axe', 'thchair1', 12, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(266, 'hh_room_theater_axe', 'thchair1', 13, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(267, 'hh_room_theater_axe', 'thchair1', 14, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(268, 'hh_room_theater_axe', 'thchair1', 15, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(269, 'hh_room_theater_axe', 'thchair1', 16, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(270, 'hh_room_theater_axe', 'thchair2', 2, 16, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(271, 'hh_room_theater_axe', 'thchair1', 6, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(272, 'hh_room_theater_axe', 'thchair1', 7, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(273, 'hh_room_theater_axe', 'thchair1', 8, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(274, 'hh_room_theater_axe', 'thchair1', 9, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(275, 'hh_room_theater_axe', 'thchair1', 10, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(276, 'hh_room_theater_axe', 'thchair1', 12, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(277, 'hh_room_theater_axe', 'thchair1', 13, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(278, 'hh_room_theater_axe', 'thchair1', 14, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(279, 'hh_room_theater_axe', 'thchair1', 15, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(280, 'hh_room_theater_axe', 'thchair1', 16, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(281, 'hh_room_theater_axe', 'thchair1', 6, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(282, 'hh_room_theater_axe', 'thchair1', 7, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(283, 'hh_room_theater_axe', 'thchair1', 8, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(284, 'hh_room_theater_axe', 'thchair1', 9, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(285, 'hh_room_theater_axe', 'thchair1', 10, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(286, 'hh_room_theater_axe', 'thchair1', 12, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(287, 'hh_room_theater_axe', 'thchair1', 13, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(288, 'hh_room_theater_axe', 'thchair1', 14, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(289, 'hh_room_theater_axe', 'thchair1', 15, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(290, 'hh_room_theater_axe', 'thchair1', 16, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(291, 'hh_room_theater_axe', 'thchair1', 6, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(292, 'hh_room_theater_axe', 'thchair1', 7, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(293, 'hh_room_theater_axe', 'thchair1', 8, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(294, 'hh_room_theater_axe', 'thchair1', 9, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(295, 'hh_room_theater_axe', 'thchair1', 10, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(296, 'hh_room_theater_axe', 'thchair1', 12, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(297, 'hh_room_theater_axe', 'thchair1', 13, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(298, 'hh_room_theater_axe', 'thchair1', 14, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(299, 'hh_room_theater_axe', 'thchair1', 15, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(300, 'hh_room_theater_axe', 'thchair1', 16, 26, 1, 0, 'sit');


   -- hh_room_theater_easter

INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(301, 'hh_room_theater_easter', 'mic', 11, 10, 1, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(302, 'hh_room_theater_easter', 'thchair2', 2, 11, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(303, 'hh_room_theater_easter', 'thchair2', 2, 12, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(304, 'hh_room_theater_easter', 'thchair2', 2, 15, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(305, 'hh_room_theater_easter', 'thchair1', 6, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(306, 'hh_room_theater_easter', 'thchair1', 7, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(307, 'hh_room_theater_easter', 'thchair1', 8, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(308, 'hh_room_theater_easter', 'thchair1', 9, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(309, 'hh_room_theater_easter', 'thchair1', 10, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(310, 'hh_room_theater_easter', 'thchair1', 12, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(311, 'hh_room_theater_easter', 'thchair1', 13, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(312, 'hh_room_theater_easter', 'thchair1', 14, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(313, 'hh_room_theater_easter', 'thchair1', 15, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(314, 'hh_room_theater_easter', 'thchair1', 16, 15, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(315, 'hh_room_theater_easter', 'thchair2', 2, 16, 4, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(316, 'hh_room_theater_easter', 'thchair1', 6, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(317, 'hh_room_theater_easter', 'thchair1', 7, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(318, 'hh_room_theater_easter', 'thchair1', 8, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(319, 'hh_room_theater_easter', 'thchair1', 9, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(320, 'hh_room_theater_easter', 'thchair1', 10, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(321, 'hh_room_theater_easter', 'thchair1', 12, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(322, 'hh_room_theater_easter', 'thchair1', 13, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(323, 'hh_room_theater_easter', 'thchair1', 14, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(324, 'hh_room_theater_easter', 'thchair1', 15, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(325, 'hh_room_theater_easter', 'thchair1', 16, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(326, 'hh_room_theater_easter', 'thchair1', 6, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(327, 'hh_room_theater_easter', 'thchair1', 7, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(328, 'hh_room_theater_easter', 'thchair1', 8, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(329, 'hh_room_theater_easter', 'thchair1', 9, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(330, 'hh_room_theater_easter', 'thchair1', 10, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(331, 'hh_room_theater_easter', 'thchair1', 12, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(332, 'hh_room_theater_easter', 'thchair1', 13, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(333, 'hh_room_theater_easter', 'thchair1', 14, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(334, 'hh_room_theater_easter', 'thchair1', 15, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(335, 'hh_room_theater_easter', 'thchair1', 16, 23, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(336, 'hh_room_theater_easter', 'thchair1', 6, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(337, 'hh_room_theater_easter', 'thchair1', 7, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(338, 'hh_room_theater_easter', 'thchair1', 8, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(339, 'hh_room_theater_easter', 'thchair1', 9, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(340, 'hh_room_theater_easter', 'thchair1', 10, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(341, 'hh_room_theater_easter', 'thchair1', 12, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(342, 'hh_room_theater_easter', 'thchair1', 13, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(343, 'hh_room_theater_easter', 'thchair1', 14, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(344, 'hh_room_theater_easter', 'thchair1', 15, 26, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(345, 'hh_room_theater_easter', 'thchair1', 16, 26, 1, 0, 'sit');


   -- hh_room_park_de,hh_room_park

INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(346, 'hh_room_park_de,hh_room_park', 'bench2', 8, 9, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(347, 'hh_room_park_de,hh_room_park', 'bench', 9, 9, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(348, 'hh_room_park_de,hh_room_park', 'bench2', 7, 11, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(349, 'hh_room_park_de,hh_room_park', 'bench', 7, 12, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(350, 'hh_room_park_de,hh_room_park', 'bench2', 35, 16, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(351, 'hh_room_park_de,hh_room_park', 'bench2', 37, 16, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(352, 'hh_room_park_de,hh_room_park', 'bench', 38, 16, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(353, 'hh_room_park_de,hh_room_park', 'bench', 35, 17, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(354, 'hh_room_park_de,hh_room_park', 'bench2', 27, 18, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(355, 'hh_room_park_de,hh_room_park', 'bench', 28, 18, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(356, 'hh_room_park_de,hh_room_park', 'bench2', 35, 18, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(357, 'hh_room_park_de,hh_room_park', 'bench2', 25, 19, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(358, 'hh_room_park_de,hh_room_park', 'bench', 35, 19, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(359, 'hh_room_park_de,hh_room_park', 'bench', 25, 20, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(360, 'hh_room_park_de,hh_room_park', 'bench2', 25, 29, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(361, 'hh_room_park_de,hh_room_park', 'bench', 26, 29, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(362, 'hh_room_park_de,hh_room_park', 'bench2', 23, 30, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(363, 'hh_room_park_de,hh_room_park', 'bench', 23, 31, 0, 2, 'sit');


   -- hh_room_orient

INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(364, 'hh_room_orient', 'sitench', 17, 10, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(365, 'hh_room_orient', 'sitench', 19, 10, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(366, 'hh_room_orient', 'sitench', 21, 10, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(367, 'hh_room_orient', 'sitench', 23, 10, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(368, 'hh_room_orient', 'sitench', 17, 11, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(369, 'hh_room_orient', 'sitench', 19, 11, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(370, 'hh_room_orient', 'sitench', 21, 11, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(371, 'hh_room_orient', 'sitench', 23, 11, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(372, 'hh_room_orient', 'koc_chair', 32, 11, 1, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(373, 'hh_room_orient', 'sitench', 17, 12, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(374, 'hh_room_orient', 'sitench', 19, 12, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(375, 'hh_room_orient', 'sitench', 21, 12, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(376, 'hh_room_orient', 'sitench', 23, 12, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(377, 'hh_room_orient', 'koc_chair', 31, 12, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(378, 'hh_room_orient', 'koc_table', 32, 12, 1, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(379, 'hh_room_orient', 'koc_chair', 33, 12, 1, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(380, 'hh_room_orient', 'sitench', 17, 13, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(381, 'hh_room_orient', 'sitench', 19, 13, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(382, 'hh_room_orient', 'sitench', 21, 13, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(383, 'hh_room_orient', 'sitench', 23, 13, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(384, 'hh_room_orient', 'koc_chair', 25, 13, 1, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(385, 'hh_room_orient', 'koc_chair', 32, 13, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(386, 'hh_room_orient', 'sitench', 17, 14, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(387, 'hh_room_orient', 'sitench', 19, 14, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(388, 'hh_room_orient', 'sitench', 21, 14, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(389, 'hh_room_orient', 'sitench', 23, 14, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(390, 'hh_room_orient', 'koc_table', 25, 14, 1, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(391, 'hh_room_orient', 'koc_chair', 26, 14, 1, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(392, 'hh_room_orient', 'sitench', 17, 15, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(393, 'hh_room_orient', 'sitench', 19, 15, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(394, 'hh_room_orient', 'sitench', 21, 15, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(395, 'hh_room_orient', 'sitench', 23, 15, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(396, 'hh_room_orient', 'koc_chair', 25, 15, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(397, 'hh_room_orient', 'koc_chair', 29, 15, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(398, 'hh_room_orient', 'koc_table', 30, 15, 1, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(399, 'hh_room_orient', 'koc_chair', 31, 15, 1, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(400, 'hh_room_orient', 'koc_chair', 30, 16, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(401, 'hh_room_orient', 'chairf1', 25, 24, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(402, 'hh_room_orient', 'chairf1', 33, 24, 1, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(403, 'hh_room_orient', 'sitench', 17, 25, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(404, 'hh_room_orient', 'sitench', 19, 25, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(405, 'hh_room_orient', 'sitench', 21, 25, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(406, 'hh_room_orient', 'sitench', 23, 25, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(407, 'hh_room_orient', 'chairf1', 25, 25, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(408, 'hh_room_orient', 'chairf1', 33, 25, 1, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(409, 'hh_room_orient', 'sitench', 17, 26, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(410, 'hh_room_orient', 'sitench', 19, 26, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(411, 'hh_room_orient', 'sitench', 21, 26, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(412, 'hh_room_orient', 'sitench', 23, 26, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(413, 'hh_room_orient', 'chairf1', 25, 26, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(414, 'hh_room_orient', 'chairf1', 33, 26, 1, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(415, 'hh_room_orient', 'sitench', 17, 27, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(416, 'hh_room_orient', 'sitench', 19, 27, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(417, 'hh_room_orient', 'sitench', 21, 27, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(418, 'hh_room_orient', 'sitench', 23, 27, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(419, 'hh_room_orient', 'sitench', 17, 28, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(420, 'hh_room_orient', 'sitench', 19, 28, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(421, 'hh_room_orient', 'sitench', 21, 28, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(422, 'hh_room_orient', 'sitench', 23, 28, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(423, 'hh_room_orient', 'sitench', 17, 29, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(424, 'hh_room_orient', 'sitench', 19, 29, 0, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(425, 'hh_room_orient', 'sitench', 21, 29, 0, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(426, 'hh_room_orient', 'sitench', 23, 29, 9, 6, 'sit');


   -- hh_room_habburger

INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(427, 'hh_room_habburger', 'sofa', 0, 0, 2, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(428, 'hh_room_habburger', 'table', 1, 0, 2, 4, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(429, 'hh_room_habburger', 'sofa', 2, 0, 2, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(430, 'hh_room_habburger', 'sofa', 6, 0, 2, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(431, 'hh_room_habburger', 'tablesp', 7, 0, 2, 4, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(432, 'hh_room_habburger', 'sofa', 8, 0, 2, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(433, 'hh_room_habburger', 'sofa', 12, 0, 2, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(434, 'hh_room_habburger', 'table', 13, 0, 2, 4, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(435, 'hh_room_habburger', 'sofa', 14, 0, 2, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(436, 'hh_room_habburger', 'trashcan', 15, 0, 2, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(437, 'hh_room_habburger', 'sofa2', 0, 1, 2, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(438, 'hh_room_habburger', 'table2', 1, 1, 2, 4, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(439, 'hh_room_habburger', 'sofa2', 2, 1, 2, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(440, 'hh_room_habburger', 'sofa2', 6, 1, 2, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(441, 'hh_room_habburger', 'table2', 7, 1, 2, 4, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(442, 'hh_room_habburger', 'sofa2', 8, 1, 2, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(443, 'hh_room_habburger', 'sofa2', 12, 1, 2, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(444, 'hh_room_habburger', 'table2', 13, 1, 2, 4, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(445, 'hh_room_habburger', 'sofa2', 14, 1, 2, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(446, 'hh_room_habburger', 'bardesk3', 2, 7, 0, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(447, 'hh_room_habburger', 'sofa', 7, 7, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(448, 'hh_room_habburger', 'sofa2', 8, 7, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(449, 'hh_room_habburger', 'sofa', 12, 7, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(450, 'hh_room_habburger', 'sofa2', 13, 7, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(451, 'hh_room_habburger', 'bardesk4', 2, 8, 0, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(452, 'hh_room_habburger', 'tablesp', 7, 8, 0, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(453, 'hh_room_habburger', 'table2', 8, 8, 0, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(454, 'hh_room_habburger', 'table', 12, 8, 0, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(455, 'hh_room_habburger', 'table2', 13, 8, 0, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(456, 'hh_room_habburger', 'bardesk', 2, 9, 0, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(457, 'hh_room_habburger', 'sofa', 7, 9, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(458, 'hh_room_habburger', 'sofa2', 8, 9, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(459, 'hh_room_habburger', 'sofa', 12, 9, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(460, 'hh_room_habburger', 'sofa2', 13, 9, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(461, 'hh_room_habburger', 'bardesk2', 2, 10, 0, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(462, 'hh_room_habburger', 'bardesk', 2, 11, 0, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(463, 'hh_room_habburger', 'bardesk', 2, 12, 0, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(464, 'hh_room_habburger', 'sofa', 7, 12, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(465, 'hh_room_habburger', 'sofa2', 8, 12, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(466, 'hh_room_habburger', 'sofa', 12, 12, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(467, 'hh_room_habburger', 'sofa2', 13, 12, 0, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(468, 'hh_room_habburger', 'bardesk', 2, 13, 0, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(469, 'hh_room_habburger', 'table', 7, 13, 0, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(470, 'hh_room_habburger', 'table2', 8, 13, 0, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(471, 'hh_room_habburger', 'tablesp', 12, 13, 0, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(472, 'hh_room_habburger', 'table2', 13, 13, 0, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(473, 'hh_room_habburger', 'sofa', 7, 14, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(474, 'hh_room_habburger', 'sofa2', 8, 14, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(475, 'hh_room_habburger', 'sofa', 12, 14, 0, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(476, 'hh_room_habburger', 'sofa2', 13, 14, 0, 0, 'sit');


   -- hh_room_kitchen



   -- hh_room_cinema

INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(477, 'hh_room_cinema', 'orange', 2, 4, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(478, 'hh_room_cinema', 'loungey_chair', 7, 4, 3, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(479, 'hh_room_cinema', 'loungey_tablebigb', 8, 4, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(480, 'hh_room_cinema', 'loungey_chair', 9, 4, 3, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(481, 'hh_room_cinema', 'loungey_chair', 2, 5, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(482, 'hh_room_cinema', 'loungey_chair', 7, 5, 3, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(483, 'hh_room_cinema', 'loungey_tablebiga', 8, 5, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(484, 'hh_room_cinema', 'loungey_chair', 9, 5, 3, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(485, 'hh_room_cinema', 'loungey_table', 2, 6, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(486, 'hh_room_cinema', 'loungey_chair', 2, 7, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(487, 'hh_room_cinema', 'theater_chair', 13, 7, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(488, 'hh_room_cinema', 'theater_chair', 14, 7, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(489, 'hh_room_cinema', 'theater_chair', 15, 7, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(490, 'hh_room_cinema', 'theater_chair', 16, 7, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(491, 'hh_room_cinema', 'theater_chair', 17, 7, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(492, 'hh_room_cinema', 'theater_chair', 18, 7, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(493, 'hh_room_cinema', 'stair', 21, 7, 1, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(494, 'hh_room_cinema', 'lightpole', 9, 8, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(495, 'hh_room_cinema', 'pomomaski', 13, 8, 2, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(496, 'hh_room_cinema', 'pomomaski', 14, 8, 2, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(497, 'hh_room_cinema', 'pomomaski', 15, 8, 2, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(498, 'hh_room_cinema', 'pomomaski', 16, 8, 2, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(499, 'hh_room_cinema', 'pomomaski', 17, 8, 2, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(500, 'hh_room_cinema', 'pomomaski', 18, 8, 2, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(501, 'hh_room_cinema', 'pomomaski', 19, 8, 2, 1, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(502, 'hh_room_cinema', 'stair', 21, 8, 1, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(503, 'hh_room_cinema', 'orange', 2, 9, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(504, 'hh_room_cinema', 'theater_chair', 13, 9, 2, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(505, 'hh_room_cinema', 'theater_chair', 14, 9, 2, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(506, 'hh_room_cinema', 'theater_chair', 15, 9, 2, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(507, 'hh_room_cinema', 'theater_chair', 16, 9, 2, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(508, 'hh_room_cinema', 'theater_chair', 17, 9, 2, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(509, 'hh_room_cinema', 'theater_chair', 18, 9, 2, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(510, 'hh_room_cinema', 'theater_chair', 19, 9, 2, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(511, 'hh_room_cinema', 'theater_chair', 20, 9, 2, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(512, 'hh_room_cinema', 'stair', 21, 9, 1, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(513, 'hh_room_cinema', 'loungey_chair', 2, 10, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(514, 'hh_room_cinema', 'loungey_chair', 9, 10, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(515, 'hh_room_cinema', 'loungey_table', 2, 11, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(516, 'hh_room_cinema', 'loungey_table', 9, 11, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(517, 'hh_room_cinema', 'loungey_chair', 2, 12, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(518, 'hh_room_cinema', 'loungey_chair', 9, 12, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(519, 'hh_room_cinema', 'cubicb_chair', 17, 12, 1, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(520, 'hh_room_cinema', 'cubico_chair', 19, 12, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(521, 'hh_room_cinema', 'cubicb_chair', 15, 13, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(522, 'hh_room_cinema', 'lightpole', 19, 13, 1, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(523, 'hh_room_cinema', 'cubicb_chair', 20, 13, 1, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(524, 'hh_room_cinema', 'lightpole', 9, 14, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(525, 'hh_room_cinema', 'loungey_chair', 2, 15, 3, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(526, 'hh_room_cinema', 'cubicb_chair', 14, 15, 1, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(527, 'hh_room_cinema', 'cubico_chair', 19, 15, 1, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(528, 'hh_room_cinema', 'loungey_table', 2, 16, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(529, 'hh_room_cinema', 'loungey_chair', 7, 16, 3, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(530, 'hh_room_cinema', 'loungey_table', 8, 16, 3, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(531, 'hh_room_cinema', 'loungey_chair', 9, 16, 3, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(532, 'hh_room_cinema', 'cubicb_chair', 13, 16, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(533, 'hh_room_cinema', 'cubicb_chair', 14, 16, 1, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(534, 'hh_room_cinema', 'orange', 19, 16, 1, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(535, 'hh_room_cinema', 'loungey_chair', 2, 17, 3, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(536, 'hh_room_cinema', 'loungey_chair', 7, 17, 3, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(537, 'hh_room_cinema', 'loungey_table', 8, 17, 3, 2, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(538, 'hh_room_cinema', 'loungey_chair', 9, 17, 3, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(539, 'hh_room_cinema', 'cubicb_chair', 19, 17, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(540, 'hh_room_cinema', 'orange', 2, 18, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(541, 'hh_room_cinema', 'cubicb_chair', 14, 18, 1, 4, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(542, 'hh_room_cinema', 'bardesque', 2, 19, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(543, 'hh_room_cinema', 'bardesque', 2, 20, 3, 1, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(544, 'hh_room_cinema', 'bar_chair', 3, 20, 3, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(545, 'hh_room_cinema', 'lightpole', 9, 20, 3, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(546, 'hh_room_cinema', 'cubicb_chair', 14, 20, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(547, 'hh_room_cinema', 'cubicb_chair', 19, 20, 1, 2, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(548, 'hh_room_cinema', 'cubico_chair', 20, 20, 1, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(549, 'hh_room_cinema', 'bardesque', 2, 21, 3, 1, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(550, 'hh_room_cinema', 'bar_chair', 3, 21, 3, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(551, 'hh_room_cinema', 'cubicb_chair', 19, 21, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(552, 'hh_room_cinema', 'bardesque', 2, 22, 3, 1, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(553, 'hh_room_cinema', 'bar_chair', 3, 22, 3, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(554, 'hh_room_cinema', 'lightpole', 16, 22, 1, 0, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(555, 'hh_room_cinema', 'cubico_chair', 18, 22, 1, 0, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(556, 'hh_room_cinema', 'bardesque', 2, 23, 3, 1, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(557, 'hh_room_cinema', 'bar_chair', 3, 23, 3, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(558, 'hh_room_cinema', 'bardesque', 2, 24, 3, 1, '');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(559, 'hh_room_cinema', 'bar_chair', 3, 24, 3, 6, 'sit');
INSERT INTO publicfurniture (id, pubmodel, sprite, x, y, length, width, type) VALUES(560, 'hh_room_cinema', 'bardesque', 2, 25, 3, 2, '');

EDIT 4: I've updated the heightmaps, they were broken and missing a column.

**James** · 30-04-12

Originally Posted by Aerospark

I've finally got my computer working fully again, I wasn't able to do any development over the past few days because I needed to get a new graphics card. It's all up and running now though, and I plan on doing some coding today, expect updates in this post shortly.

I'll be doing some more tests with public rooms, and possibly finish up the console. I'm also going to take another look at the NexusTools server to see if I cant get the testing sandbox up again.

EDIT 1: I'm currently doing some work with public rooms, and if anyone has access to the old v9-v18 public room data (height maps, furniture locations, etc) that would be really helpful.

Check out usa111 or debbo, should have most of them =]

**Aerospark** · 04-05-12

Updates!

I've been doing work with the public rooms lately, and I finally got past the elusive error that was stopping me from releasing this update sooner.

I've imported a lot of the public room data, finished implementing the navigator public room handling, and started with public room entering.

Here is a screenshot of the result:

Spoiler:

And here is a specific list of the changes:
-Cleaned up room.cpp
-Fixed public room entering
-repaired the heightmap db
-Fixed a few things in the db, fixed the public rooms heightmap parser
-Added db table publicheights, imported public room heightmap and door location data
-Added new debugging string to lang file
-Started adding public room implementations into room.

It's all available on the SVN, and I hope to work more on this soon.

NexusServer v2 (C++/Qt)

Thread Tools

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Re: NexusServer v2 (C++/Qt)

Advertisement