Dawn of Light

Dawn of Light - Your Portal to DAoC Emulation
http://dolserver.sourceforge.net/

Housing Data (hookpoints, menu, and shop items)

http://dolserver.sourceforge.net/viewtopic.php?t=17652

Page 1 of 1

Housing Data (hookpoints, menu, and shop items)

PostPosted: Fri Nov 26, 2010 5:00 pm
by Tolakram
Here are all the hookpoint locations. Add these to the new hookpoints table.

hookpointoffset table:
Code: Select all
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (1, 4, 16, -106, 42, -344, 248);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (2, 4, 21, -598, 322, -345, 2799);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (3, 4, 9, -584, 804, -76, 2808);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (4, 4, 18, -236, -90, -74, 11);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (5, 4, 10, -618, 109, 198, 2809);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (6, 4, 19, -88, 572, 199, 1376);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (7, 4, 8, -30, 964, 750, 771);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (8, 4, 20, -38, 379, 749, 602);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (9, 4, 26, 244, 192, -680, 1782);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (10, 4, 27, 391, 188, -679, 1774);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (11, 4, 25, 388, -223, -679, -270);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (12, 4, 24, 244, -236, -680, -270);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (13, 4, 28, -390, 189, -679, 1776);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (14, 4, 29, -542, 191, -679, 1772);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (15, 4, 30, -544, -227, -679, 3821);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (16, 4, 31, -393, -230, -679, 3821);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (17, 4, 17, -195, -483, -679, 3616);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (18, 4, 0, -58, -870, -1065, -269);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (21, 1, 16, -162, 167, 30, 3387);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (22, 10, 8, 618, 64, 62, 240);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (23, 10, 19, 138, 363, 64, 2859);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (26, 10, 17, -223, 62, -372, 2416);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (25, 10, 16, 146, 514, 62, 2355);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (27, 10, 25, 402, -430, -370, 1431);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (28, 10, 24, 156, -636, -370, 3446);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (29, 10, 0, -531, -447, -370, 3399);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (30, 1, 18, -220, 297, 30, 2846);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (31, 1, 8, 344, 434, 30, 780);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (36, 1, 0, -196, -852, -305, -261);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (35, 1, 24, 368, -41, -306, 782);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (34, 1, 17, 305, 249, -307, 1236);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (37, 2, 16, -26, 166, -95, 245);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (38, 2, 19, 19, 318, -90, 749);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (39, 2, 8, -543, 438, -95, 2823);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (40, 2, 18, -18, 686, 173, 1289);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (41, 2, 9, -515, 177, 175, 3356);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (42, 2, 17, -495, 248, -432, 2802);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (43, 2, 25, 470, -104, -431, -235);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (44, 2, 24, 326, -104, -430, -255);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (45, 2, 0, 6, -855, -429, 3814);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (46, 3, 16, -463, 144, -208, 3338);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (47, 3, 8, 88, 687, -209, 1413);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (48, 3, 20, -492, 958, -206, 2080);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (49, 3, 9, 86, 835, 60, 1763);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (50, 3, 18, -622, 982, 60, 2286);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (51, 3, 10, -429, 921, 318, 2802);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (52, 3, 19, -479, 129, 320, 3099);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (53, 3, 17, -491, -92, -542, 3134);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (54, 3, 27, 378, 317, -540, 1796);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (55, 3, 26, 557, 319, -540, 1804);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (56, 3, 25, 574, 123, -541, 766);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (57, 3, 24, 378, -98, -541, 3821);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (58, 3, 0, 68, -849, -542, -267);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (59, 5, 8, -118, 225, 101, 2787);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (60, 5, 16, 605, 155, 99, 776);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (61, 5, 18, 587, 322, 99, 800);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (62, 5, 24, -103, -425, -319, 725);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (63, 5, 17, -146, 289, -315, 1506);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (64, 5, 0, -303, -514, -279, 3815);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (65, 6, 19, -468, -472, -307, 3007);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (66, 6, 16, -542, -355, -295, 2756);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (67, 6, 8, 286, 688, -297, 1537);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (68, 6, 18, -312, -604, -31, 3238);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (69, 6, 9, -533, 297, -34, 2101);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (70, 6, 17, 298, -215, -708, -258);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (71, 6, 24, -468, 651, -720, 1797);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (72, 6, 25, -667, 647, -720, 2199);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (73, 6, 0, -525, -818, -680, -240);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (74, 7, 16, 304, -464, -290, 723);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (75, 7, 20, 403, -231, -294, 730);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (76, 7, 8, -440, 363, -288, 2417);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (77, 7, 17, -411, 474, -34, 1777);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (78, 7, 9, -77, -609, -30, -276);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (79, 7, 18, 121, -441, 205, 3451);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (80, 7, 10, -420, 447, 204, 1781);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (81, 7, 19, -267, -411, -708, 2803);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (82, 7, 26, 518, 299, -720, 650);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (83, 7, 27, 633, 379, -720, 813);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (84, 7, 24, 519, 416, -720, 940);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (85, 7, 25, 436, 536, -720, 1326);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (86, 7, 0, -929, 401, -681, 2807);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (87, 8, 16, 359, -493, -318, 750);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (88, 8, 21, -589, 109, -319, 2816);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (89, 8, 9, 412, 402, -47, 753);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (90, 8, 17, 380, -319, -48, 162);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (91, 8, 10, -577, 434, 224, 2245);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (92, 8, 18, -535, -305, 227, 3401);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (93, 8, 19, 161, -157, 459, 18);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (94, 8, 8, -584, -237, 461, 3223);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (95, 8, 20, 522, 44, -731, 911);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (96, 8, 0, 791, 616, -641, 1357);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (97, 8, 26, 141, -1037, -1077, -55);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (98, 8, 27, 357, -960, -1077, 36);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (99, 8, 24, 475, -914, -1076, 332);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (100, 8, 25, 568, -825, -1077, 186);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (101, 8, 30, -536, -777, -1077, 3340);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (102, 8, 31, -647, -585, -1078, 3197);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (103, 8, 28, -709, -493, -1078, 2854);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (104, 8, 29, -706, -335, -1078, 3077);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (105, 9, 8, 692, 253, 155, 701);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (106, 9, 18, 204, 525, 155, 2164);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (107, 9, 16, 145, 449, 156, 2373);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (108, 9, 17, -225, -1, -278, 2245);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (109, 9, 24, 87, -352, -277, 172);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (110, 9, 0, -534, -515, -272, 3203);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (111, 10, 9, 549, 520, 242, 1360);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (112, 10, 18, 185, 89, 243, 3348);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (113, 11, 8, 651, -31, -98, 235);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (114, 11, 16, 645, 727, -97, 1591);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (115, 11, 20, 576, 756, -95, 1782);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (116, 11, 9, 149, 351, 127, 2805);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (117, 11, 18, 417, -53, 128, -265);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (118, 11, 19, 226, 712, 290, 2129);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (119, 11, 10, 644, 375, 291, 747);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (120, 11, 17, -216, 15, -532, 2231);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (121, 11, 24, 161, -681, -531, 3315);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (122, 11, 26, 392, -695, -531, 202);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (123, 11, 25, 409, -475, -531, 1195);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (124, 11, 27, 292, -575, -531, 183);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (125, 11, 0, -528, -508, -531, 3226);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (126, 12, 19, -244, -616, -403, 3041);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (127, 12, 21, 288, 203, -404, 775);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (128, 12, 10, -235, 41, -137, 2602);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (129, 12, 18, 240, -495, -136, 3812);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (130, 12, 9, -251, -114, 45, 3240);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (131, 12, 17, 237, -493, 44, -271);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (132, 12, 8, 125, -19, 549, 1478);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (133, 12, 16, -69, -518, 549, 3732);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (134, 12, 24, 356, 593, -642, -258);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (135, 12, 31, 535, 596, -643, 3815);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (136, 12, 25, 697, 594, -644, -265);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (137, 12, 30, 854, 704, -644, 784);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (138, 12, 29, 854, 827, -644, 772);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (139, 12, 27, 678, 938, -644, 1790);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (140, 12, 28, 533, 930, -644, 1777);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (141, 12, 26, 346, 940, -643, 1788);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (142, 12, 20, 426, -445, -852, 490);
INSERT INTO `househookpointoffset` (`ID`, `HouseModel`, `HookpointID`, `X`, `Y`, `Z`, `Heading`) VALUES (143, 12, 0, -909, -1300, -593, 2790);

Re: Housing Data (hookpoints and menu items)

PostPosted: Fri Nov 26, 2010 5:01 pm
by Tolakram
As mentioned in the commit thread, the housing menu items and merchant lists are included in the housing code as a comment. You can find it all here:

http://dolserver.svn.sourceforge.net/vi ... threv=2682

Re: Housing Data (hookpoints and menu items)

PostPosted: Mon Nov 29, 2010 3:31 pm
by bedrock1977
Great work man!

Re: Housing Data (hookpoints, menu, and shop items)

PostPosted: Tue Nov 30, 2010 11:29 pm
by Tolakram
Here is a zip file of every housing item Storm has as of 30-NOV-2010. Garden and Indoor items are hibernia centric because that's what was in our DB. You may already have some of these items in your DB so it's best to ignore errors. I recommend using HeidiSQL, best too out there right now, and free.
HousingMenuAndShopItems.zip
(17.95 KiB) Downloaded 327 times

Re: Housing Data (hookpoints, menu, and shop items)

PostPosted: Wed Dec 01, 2010 6:39 pm
by bedrock1977
Here is a zip file of every housing item Storm has as of 30-NOV-2010. Garden and Indoor items are hibernia centric because that's what was in our DB. You may already have some of these items in your DB so it's best to ignore errors. I recommend using HeidiSQL, best too out there right now, and free.
HousingMenuAndShopItems.zip

Nice... I was using that Navicat tool the last time I ran a server in 2006 and I must say after using HeidiSQL I'll never go back now. Great app... thanks again.

Re: Housing Data (hookpoints, menu, and shop items)

PostPosted: Wed Dec 01, 2010 7:37 pm
by Argo
Great job Mark, RESPECT

kind regards
Argo
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/