Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

NexusServer v2 (C++/Qt)

Experienced Elementalist
Joined
Jul 5, 2006
Messages
262
Reaction score
193
Actually no, quite the opposite. (IMO) One of the main reasons for making this is to use C++. It's more efficient, native, and multiplatform. C# on the other hand runs on top of a virtual layer (.NET, not native) and only supports Windows (with the exclusion of mono.) It is a powerful language, but it's definitely not better than native.

.NET and Qt are both frameworks... C# can be compiled for other platforms using Mono, of course C++ can be compiled for other platforms easier because it has more support than C# does for being compiled on other platforms like linux etc.. You can write plain C# without .NET but then you loose a lot of things you probably use from .NET.
 
Junior Spellweaver
Joined
Nov 28, 2011
Messages
111
Reaction score
17
Project dead? Damn, was checking everyday since the first version :(
 
Newbie Spellweaver
Joined
May 25, 2011
Messages
77
Reaction score
58
Project dead? Damn, was checking everyday since the first version :(
Actually this isn't dead, I've just been busy lately with IRL stuff and other projects. I've still been writing little bits of code though, and hopefully development will speed up again in the future, I don't plan on dropping this.

The next update will hopefully be to the console, to properly implement friend requests. I've also found a problem with the packet IO system, sometimes the reader can be broken if you send too many packets at once, though this isn't hard to fix.

.NET and Qt are both frameworks... C# can be compiled for other platforms using Mono, of course C++ can be compiled for other platforms easier because it has more support than C# does for being compiled on other platforms like linux etc.. You can write plain C# without .NET but then you loose a lot of things you probably use from .NET.
Yes, C# and Qt are both development frameworks, but there is nothing inherently negative about frameworks. However, C# (.NET) runs on top of a similar to . Where as Qt is directly on top of C++, so it compiles to native code using whatever C++ compiler its set up for.

Both languages have their advantages, but as almost all other servers for this game seem to be written using either C# or java (or something similar,) I would assume the community would benefit more from new code rather then rehashed code.
 
Last edited:
Newbie Spellweaver
Joined
May 25, 2011
Messages
77
Reaction score
58
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:
Code:
# NexusServer2 LANG File

# errors
error.unknown_space=Error! Unknown spaces type!
error.invalid_item=Invalid item!
error.own_room_load=Error loading own rooms!
error.room_create=Error creating room!
error.room_not_found=Room doesnt exist!
error.not_in_room=You arent in a room!
error.invalid_location=Invalid location!
error.settings_change=Error updating account settings!
error.invalid_dopcode=Unknown debugging opcode!
error.database_error=Internal database error!
error.furni_load_error=Error loading furniture from DB!
error.server_error=Internal server error!


# registration
registration.account_exists=Account already exists!
registration.success=Account successfully created!
registration.error=Registration error.


# ui
ui.guestrooms=Guest Rooms


and here is the config file, both are incomplete:
Code:
# NexusServer2 INI-style configuration
# Comments must be on their own line (for now)
# and start at the beginning of the line
# but can contain anything, they are comments.


# Database configuration (NYI)
nyi.fish=green
nyi.yellow = from the past


# Login settings
#  login.enablenonsso: Allow users to use the in-client login boxes
#  login.enablesso: Allow users to login using an SSO ticket (NYI)
#  login.enablemus: Aloow cameras to take pictures (NYI)
login.enablenonsso  = true
login.enablesso     = true
login.enablemus     = false


# Language settings
#  lang.langstr: String representing the language of the server
#  lang.langfile: File containing lingual strings
lang.langstr        = English
lang.langfile       = ./lang_english.ini


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.
 
Last edited:
Newbie Spellweaver
Joined
Jun 23, 2007
Messages
22
Reaction score
0
Great work so far. Just stay dedicated & don't give up like the rest of them. Keep it up.
 
Newbie Spellweaver
Joined
May 25, 2011
Messages
77
Reaction score
58
Great work so far. Just stay dedicated & don't give up like the rest of them. Keep it up.
:eek: 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:
- added to lang: error.friend_request_dberr=DB Error while processing friend request!
- added to lang: error.friend_not_found=User not found in DB!
- added to lang: new #debugging section
- added to lang: debugging.friend_request_ok=New friend request added.

- added to config: database.verifytables: Verify the database tables on init, if they dont exist (or are damaged), create them.
- added to config: database.verifycells: verify the database cells on init, if they dont exist (or are damaged), create them.
(You'll need to set database.verifycells=false if you wish to modify the db outside the user data sections)
As usual its all on the .
 
Last edited:
Custom Title Activated
Loyal Member
Joined
Oct 21, 2007
Messages
2,098
Reaction score
464
Try out Github it's better than Svn ^_^
 
Newbie Spellweaver
Joined
May 25, 2011
Messages
77
Reaction score
58
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.
 
Newbie Spellweaver
Joined
Jun 23, 2007
Messages
22
Reaction score
0
Do you reckon you'll be able to put up a 24/7 test hotel?
 
Newbie Spellweaver
Joined
May 25, 2011
Messages
77
Reaction score
58
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.
 
Last edited:
Newbie Spellweaver
Joined
May 25, 2011
Messages
77
Reaction score
58
Thanks for re-opening the thread :)

@Aerospark

My condolences. Good luck with development, I'm looking forward to seeing a C++ server.
:eek: 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 :eek:


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 .

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.
 
Last edited:
Newbie Spellweaver
Joined
May 25, 2011
Messages
77
Reaction score
58
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):
Code:
CREATE TABLE IF NOT EXISTS publicrooms (id INTEGER PRIMARY KEY, title VARCHAR(150), model VARCHAR(150), dstr VARCHAR(150))


INSERT INTO publicrooms (id, title, model, dstr) VALUES(4201,'Welcome! Lounge', 'welcome_lounge', 'hh_room_nlobby');
INSERT INTO publicrooms (id, title, model, dstr) VALUES(4202,'Theatredrome', 'theatredrome', 'hh_room_theater');
INSERT INTO publicrooms (id, title, model, dstr) VALUES(4203,'Axe Theatredrome', 'theatredrome_axe', 'hh_room_theater_axe');
INSERT INTO publicrooms (id, title, model, dstr) VALUES(4204,'Easter Theatredrome', 'theatredrome_easter', 'hh_room_theater_easter');
INSERT INTO publicrooms (id, title, model, dstr) VALUES(4205,'Park', 'park', 'hh_room_park_de,hh_room_park');
INSERT INTO publicrooms (id, title, model, dstr) VALUES(4206,'House of flying carrots', 'orient', 'hh_room_orient');
INSERT INTO publicrooms (id, title, model, dstr) VALUES(4207,'Habburgers', 'habburger's', 'hh_room_habburger');
INSERT INTO publicrooms (id, title, model, dstr) VALUES(4208,'Hotel Kitchen', 'hotel_kitchen', 'hh_room_kitchen');
INSERT INTO publicrooms (id, title, model, dstr) VALUES(4209,'Habbo Cinema', 'habbo_cinema', 'hh_room_cinema');
INSERT INTO publicrooms (id, title, model, dstr) VALUES(4210,'Main Lobby', 'main_lobby', 'hh_room_lobby');
INSERT INTO publicrooms (id, title, model, dstr) VALUES(4211,'Lido', 'habbo_lido', 'hh_room_pool,hh_people_pool');
INSERT INTO publicrooms (id, title, model, dstr) VALUES(4212,'Rooftop', 'rooftop', 'hh_room_rooftop');
INSERT INTO publicrooms (id, title, model, dstr) VALUES(4213,'Football Room', 'ballroom', 'hh_room_ballroom');
INSERT INTO publicrooms (id, title, model, dstr) VALUES(4214,'Tearoom', 'tearoom', 'hh_room_tearoom');


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
 
Zephyr Studios
Loyal Member
Joined
Feb 18, 2012
Messages
1,877
Reaction score
724
Cool, i am looking forward to see that. Oldschool is different to see in 2012, but some peoples is still using it. Good luck.
 
Newbie Spellweaver
Joined
May 25, 2011
Messages
77
Reaction score
58
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):
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)
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.
 
Last edited:
Joined
Jan 27, 2007
Messages
1,201
Reaction score
1,066
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 =]
 
Newbie Spellweaver
Joined
May 25, 2011
Messages
77
Reaction score
58
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:
Aerospark - NexusServer v2 (C++/Qt) - RaGEZONE Forums


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 , and I hope to work more on this soon.
 
Back
Top