Housing Data (hookpoints, menu, and shop items)

A forum for releases and discussions on database releases by the community

Moderators: Project Admin, Support Team, Database Team

Topic locked

Housing Data (hookpoints, menu, and shop items)

Postby Tolakram » Fri Nov 26, 2010 5:00 pm

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);
- Mark
User avatar
Tolakram
Storm / Storm-D2 Admin
 
Posts: 9189
Joined: Tue Jun 13, 2006 1:49 am
Location: Kentucky, USA
Top

Re: Housing Data (hookpoints and menu items)

Postby Tolakram » Fri Nov 26, 2010 5:01 pm

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
- Mark
User avatar
Tolakram
Storm / Storm-D2 Admin
 
Posts: 9189
Joined: Tue Jun 13, 2006 1:49 am
Location: Kentucky, USA
Top

Re: Housing Data (hookpoints and menu items)

Postby bedrock1977 » Mon Nov 29, 2010 3:31 pm

Great work man!
User avatar
bedrock1977
DOL Novice
 
Posts: 90
Joined: Sun Dec 18, 2005 12:53 am
Website: http://percival.dyndns-ip.com:8080
Location: California
Top

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

Postby Tolakram » Tue Nov 30, 2010 11:29 pm

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
- Mark
User avatar
Tolakram
Storm / Storm-D2 Admin
 
Posts: 9189
Joined: Tue Jun 13, 2006 1:49 am
Location: Kentucky, USA
Top

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

Postby bedrock1977 » Wed Dec 01, 2010 6:39 pm

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.
User avatar
bedrock1977
DOL Novice
 
Posts: 90
Joined: Sun Dec 18, 2005 12:53 am
Website: http://percival.dyndns-ip.com:8080
Location: California
Top

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

Postby Argo » Wed Dec 01, 2010 7:37 pm

Great job Mark, RESPECT

kind regards
Argo
Möge Gott sein zwischen Dir und dem Leid, an allen dunklen und verlassenen Orten, die Du erreichen wirst.
Argo
Server Team
 
Posts: 1760
Joined: Thu Sep 18, 2008 6:21 pm
Location: Berlin, Germany
Top
Topic locked

Return to “%s” Database Releases

Who is online

Users browsing this forum: No registered users and 1 guest

Website by Etaew - © 2012 Dawn of Light - Powered by phpBB © 2011 phpBB Group

Artwork and screen shots Copyright © 2001-2004 Mythic Entertainment, Inc. All rights reserved. Used with permission of Mythic Entertainment. Mythic Entertainment, the Mythic Entertainment logo, "Dark Age of Camelot," "Shrouded Isles," "Foundations," "New Frontiers," "Trials of Atlantis," "Catacombs," "Darkness Rising," the Dark Age of Camelot and subsequent logos, and the stylized Celtic knot are trademarks of Mythic Entertainment, Inc.