Players House Data

[alfa]

Well, regarding Jab is near to done with instance, if I correctly remember times ago L.E. have find way to move object in game, so I prevent a great idea of John about housing, maybe it will be done in years, but data are here anyway :p

For now, all Qeynos, Maj Dul, Gorowyn, New Halas and Kelethin data are here, I have do all check on live (like zone in, for check zone file, check zone back to world point and a lot of other things).

What is missing ? All items ID for MajDul and some other house. Faction needed field.

Code: Select all

base_zone_id = ID of base house zone
zone_name = name for house that display in char info or broker
buy_price = price at buy
buy_status = status point needed at buy
upkeep_price = rent price
upkeep_status = rent status price
requied_gl = requied guild level for buying
requied_item = requied item for buying
requied_faction = requied faction for buying
max_items = base max items can be in house (can be extenced by some items in house)
vault_slots = avariable vault slot in house
vender_slots = avariable vender slot on broker
parent_zone_id = parent zone of house
parent_zone_x = respawn loc X at zone out of house
parent_zone_y = respawn loc Y at zone out of house
parent_zone_z = respawn loc Z at zone out of house
parent_zone_heading = respawn heading at zone out of house

Note all data are from live so there is no more house in qeynos village (plus village zones are no longer avariable on live) AND I assume loc for Qeynos doesn't change, cause on live no more Qeynos North, South and Qeynos Harbor, Elddar Grove zones have been merged at GU 64.

Just need to finish Freeport and Neriak house, and some Prestige houses. So I post data here if it can help a day

Code: Select all

-- ----------------------------
-- Table structure for `zones_house`
-- ----------------------------
DROP TABLE IF EXISTS `zones_house`;
CREATE TABLE `zones_house` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `base_zone_id` int(11) NOT NULL,
  `zone_name` varchar(64) NOT NULL,
  `buy_price` float NOT NULL,
  `buy_status` float NOT NULL,
  `upkeep_price` float NOT NULL,
  `upkeep_status` float NOT NULL,
  `requied_gl` int(11) NOT NULL,
  `requied_item` int(11) NOT NULL,
  `requied_faction` int(11) NOT NULL,
  `max_items` int(11) NOT NULL,
  `vault_slots` smallint(6) NOT NULL,
  `vender_slots` smallint(6) NOT NULL,
  `parent_zone_id` int(11) NOT NULL,
  `parent_zone_x` float NOT NULL,
  `parent_zone_y` float NOT NULL,
  `parent_zone_z` float NOT NULL,
  `parent_heading` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of zones_house
-- ----------------------------
INSERT INTO `zones_house` VALUES ('1', '225', 'Fish\'s Alehouse Luxury Apartment', '483000', '0', '19320', '0', '0', '0', '0', '300', '6', '6', '221', '804.01', '-17.27', '58.82', '238.06');
INSERT INTO `zones_house` VALUES ('2', '225', 'Fish\'s Alehouse Luxury Apartment', '483000', '0', '19320', '0', '0', '0', '0', '300', '6', '6', '221', '807.13', '-17.27', '52.5', '214.47');
INSERT INTO `zones_house` VALUES ('3', '226', 'Fish\'s Alehouse Luxury Apartment', '289800', '64000', '11592', '6500', '10', '0', '0', '300', '6', '6', '221', '803.42', '-11.27', '52.47', '242.8');
INSERT INTO `zones_house` VALUES ('4', '226', 'Fish\'s Alehouse Luxury Apartment', '289800', '64000', '11592', '6500', '10', '0', '0', '300', '6', '6', '221', '808.58', '-11.27', '58.11', '243.95');
INSERT INTO `zones_house` VALUES ('5', '226', 'Fish\'s Alehouse Luxury Apartment', '289800', '64000', '11592', '6500', '10', '0', '0', '300', '6', '6', '221', '797.43', '-11.27', '62.43', '312.58');
INSERT INTO `zones_house` VALUES ('6', '225', 'Fish\'s Alehouse Luxury Apartment', '483000', '0', '19320', '0', '0', '0', '0', '300', '6', '6', '221', '799.34', '-11.27', '63.35', '61.64');
INSERT INTO `zones_house` VALUES ('7', '110', 'Aerie Ilka', '212100', '0', '8233', '0', '0', '0', '0', '200', '6', '6', '114', '400.12', '94.42', '198.59', '341.69');
INSERT INTO `zones_house` VALUES ('8', '112', 'Aerie Khollo', '500000', '80000', '20000', '8000', '30', '0', '0', '400', '6', '6', '114', '423.15', '128.24', '392.52', '173.22');
INSERT INTO `zones_house` VALUES ('9', '113', 'Aerie Amree', '1000000', '200000', '30000', '50000', '30', '0', '0', '700', '6', '6', '114', '403.55', '128.24', '394.26', '178.84');
INSERT INTO `zones_house` VALUES ('10', '111', 'Aerie Sajlen', '243600', '0', '9744', '0', '0', '0', '0', '300', '6', '6', '114', '439.57', '111.05', '506.44', '58.27');
INSERT INTO `zones_house` VALUES ('11', '113', 'Aerie Kolmas', '1688400', '0', '6753600', '0', '0', '0', '0', '700', '6', '6', '114', '387.85', '105.83', '505.52', '281.94');
INSERT INTO `zones_house` VALUES ('12', '112', 'Aerie Kaksi', '966000', '0', '38640', '0', '0', '0', '0', '400', '6', '6', '114', '381.9', '105.83', '488.59', '278.19');
INSERT INTO `zones_house` VALUES ('13', '110', 'Silver Leaf Inn ', '0', '0', '500', '0', '0', '0', '0', '200', '6', '6', '114', '434.46', '93.86', '318.22', '355.89');
INSERT INTO `zones_house` VALUES ('14', '377', 'Kelethin Guild House', '50000000', '0', '500000', '50000', '30', '0', '0', '0', '6', '6', '114', '360.65', '130.98', '412.03', '252.22');
INSERT INTO `zones_house` VALUES ('15', '230', '4 Bayle Court', '4838400', '300000', '193536', '60000', '30', '0', '0', '700', '6', '6', '231', '744.06', '-19.48', '197.05', '17.81');
INSERT INTO `zones_house` VALUES ('16', '230', '2 Bayle Court', '4838400', '300000', '193536', '60000', '30', '0', '0', '700', '6', '6', '231', '722.41', '-19.41', '199.34', '355.48');
INSERT INTO `zones_house` VALUES ('17', '230', '5 Erollisi Lane', '3872400', '250000', '154896', '50000', '30', '0', '0', '700', '6', '6', '231', '611.31', '-10.71', '139.03', '190.39');
INSERT INTO `zones_house` VALUES ('18', '230', '8 Erollisi Lane', '3872400', '250000', '154896', '50000', '30', '0', '0', '700', '6', '6', '231', '587.1', '-10.26', '148.87', '4.91');
INSERT INTO `zones_house` VALUES ('19', '226', 'Lion\'s Mane Suite Room', '146160', '22000', '5846', '3000', '10', '0', '0', '300', '6', '6', '231', '562.52', '-3.5', '136.65', '11.05');
INSERT INTO `zones_house` VALUES ('20', '226', 'Lion\'s Mane Suite Room', '146160', '22000', '5846', '3000', '10', '0', '0', '300', '6', '6', '231', '583.55', '-3.48', '132.6', '62.6');
INSERT INTO `zones_house` VALUES ('21', '223', 'Lion\'s Mane Vestige Room - The Baubbleshire ', '0', '0', '500', '0', '0', '0', '0', '200', '6', '6', '231', '583.75', '-3.48', '127.4', '98.45');
INSERT INTO `zones_house` VALUES ('22', '223', 'Lion\'s Mane Vestige Room - The Willow Wood ', '0', '0', '500', '0', '0', '0', '0', '200', '6', '6', '231', '579.95', '-3.49', '126.09', '185.72');
INSERT INTO `zones_house` VALUES ('23', '226', 'Lion\'s Mane Suite Room', '146160', '22000', '5846', '3000', '10', '0', '0', '300', '6', '6', '231', '571.92', '-3.5', '127.69', '162.09');
INSERT INTO `zones_house` VALUES ('24', '223', 'Lion\'s Mane Vestige Room - Castleview Hamlet ', '0', '0', '500', '0', '0', '0', '0', '200', '6', '6', '231', '563.39', '-3.5', '127.91', '200.12');
INSERT INTO `zones_house` VALUES ('25', '226', 'Lion\'s Mane Suite Room', '146160', '22000', '5846', '3000', '10', '0', '0', '300', '6', '6', '231', '556.71', '-3.5', '128.28', '170.3');
INSERT INTO `zones_house` VALUES ('26', '223', 'Lion\'s Mane Vestige Room - Nettleville ', '0', '0', '500', '0', '0', '0', '0', '200', '6', '6', '231', '537.64', '-3.5', '128.37', '184.06');
INSERT INTO `zones_house` VALUES ('27', '223', 'Lion\'s Mane Vestige Room - Starcrest Commune', '0', '0', '500', '0', '0', '0', '0', '200', '6', '6', '231', '532.01', '-3.5', '128.05', '184.61');
INSERT INTO `zones_house` VALUES ('28', '225', 'Lion\'s Mane Suite Room', '243600', '0', '9744', '0', '0', '0', '0', '300', '6', '6', '231', '521.21', '-3.5', '127.43', '160.48');
INSERT INTO `zones_house` VALUES ('29', '223', 'Lion\'s Mane Vestige Room - Graystone Yard', '0', '0', '500', '0', '0', '0', '0', '200', '6', '6', '231', '514.46', '-3.49', '124.91', '171');
INSERT INTO `zones_house` VALUES ('30', '225', 'Lion\'s Mane Suite Room', '243600', '0', '9744', '0', '0', '0', '0', '300', '6', '6', '231', '511.24', '-3.48', '127.14', '269.28');
INSERT INTO `zones_house` VALUES ('31', '225', 'Lion\'s Mane Suite Room', '243600', '0', '9744', '0', '0', '0', '0', '300', '6', '6', '231', '513.29', '-3.5', '134.88', '351.5');
INSERT INTO `zones_house` VALUES ('32', '225', 'Lion\'s Mane Suite Room', '243600', '0', '9744', '0', '0', '0', '0', '300', '6', '6', '231', '530.95', '-3.5', '137.05', '2.84');
INSERT INTO `zones_house` VALUES ('33', '230', '5 Karana Court', '3872400', '250000', '154896', '50000', '30', '0', '0', '700', '6', '6', '231', '606.8', '-15.04', '201.03', '196.77');
INSERT INTO `zones_house` VALUES ('34', '227', '6 Karana Court', '579600', '86000', '23184', '9000', '20', '0', '0', '400', '6', '6', '231', '542.82', '-16.7', '219.52', '355.58');
INSERT INTO `zones_house` VALUES ('35', '227', '12 Karana Court', '579600', '86000', '23184', '9000', '20', '0', '0', '400', '6', '6', '231', '590.95', '-16.57', '215.2', '16.61');
INSERT INTO `zones_house` VALUES ('36', '227', '14 Karana Court', '579600', '86000', '23184', '9000', '20', '0', '0', '400', '6', '6', '231', '629.96', '-17.14', '207.65', '8.56');
INSERT INTO `zones_house` VALUES ('37', '228', '18 Karana Court', '1161720', '120000', '46468', '24000', '20', '0', '0', '400', '6', '6', '231', '655.94', '-17.95', '200.05', '25.64');
INSERT INTO `zones_house` VALUES ('38', '229', '20 Karana Court', '1161720', '120000', '46468', '24000', '20', '0', '0', '400', '6', '6', '231', '655.67', '-17.95', '196.17', '24.92');
INSERT INTO `zones_house` VALUES ('39', '229', '21 Lucie Street', '1161720', '120000', '46468', '24000', '20', '0', '0', '400', '6', '6', '231', '671.15', '-17.95', '213.75', '197.12');
INSERT INTO `zones_house` VALUES ('40', '228', '17 Lucie Street', '1161720', '120000', '46468', '24000', '20', '0', '0', '400', '6', '6', '231', '650.4', '-17.95', '218.72', '202.09');
INSERT INTO `zones_house` VALUES ('41', '227', '15 Lucie Street', '579600', '86000', '23184', '9000', '20', '0', '0', '400', '6', '6', '231', '635.28', '-17.14', '224.71', '194.14');
INSERT INTO `zones_house` VALUES ('42', '227', '9 Lucie Street', '579600', '86000', '23184', '9000', '20', '0', '0', '400', '6', '6', '231', '573.34', '-16.55', '235.73', '179.22');
INSERT INTO `zones_house` VALUES ('43', '227', '5 Lucie Street', '579600', '86000', '23184', '9000', '20', '0', '0', '400', '6', '6', '231', '528.1', '-16.7', '236.43', '178.14');
INSERT INTO `zones_house` VALUES ('44', '228', '20 Lucie Street', '1161720', '120000', '46468', '24000', '0', '0', '0', '400', '6', '6', '231', '623.11', '-18.46', '236.43', '6.28');
INSERT INTO `zones_house` VALUES ('45', '227', '18 Lucie Street', '966000', '0', '38640', '0', '0', '0', '0', '400', '6', '6', '231', '600.62', '-17.82', '241.41', '11.24');
INSERT INTO `zones_house` VALUES ('46', '227', '12 Lucie Street', '966000', '0', '38640', '0', '0', '0', '0', '400', '6', '6', '231', '536.16', '-17.82', '246.11', '3.67');
INSERT INTO `zones_house` VALUES ('47', '227', '8 Lucie Street', '966000', '0', '38640', '0', '0', '0', '0', '400', '6', '6', '231', '511.44', '-19.1', '246.74', '350.81');
INSERT INTO `zones_house` VALUES ('48', '227', '2 Lucie Street', '966000', '0', '38640', '0', '0', '0', '0', '400', '6', '6', '231', '479.77', '-20.07', '244.8', '344.89');
INSERT INTO `zones_house` VALUES ('49', '227', '3 Tranquil Way', '966000', '0', '38640', '0', '0', '0', '0', '400', '6', '6', '231', '484.39', '-19.51', '267.73', '159.42');
INSERT INTO `zones_house` VALUES ('50', '227', '7 Tranquil Way', '966000', '0', '38640', '0', '0', '0', '0', '400', '6', '6', '231', '511.36', '-18.26', '268.89', '179.87');
INSERT INTO `zones_house` VALUES ('51', '227', '13 Tranquil Way', '966000', '0', '38640', '0', '0', '0', '0', '400', '6', '6', '231', '594.68', '-17.24', '265.91', '191.36');
INSERT INTO `zones_house` VALUES ('52', '228', '15 Tranquil Way', '966000', '0', '38640', '0', '0', '0', '0', '400', '6', '6', '231', '605.99', '-17.2', '263.34', '179');
INSERT INTO `zones_house` VALUES ('53', '229', '17 Tranquil Way', '1936200', '0', '77448', '0', '0', '0', '0', '400', '6', '6', '231', '628.3', '-17.93', '257.95', '205.42');
INSERT INTO `zones_house` VALUES ('54', '225', 'Irontoes East Large Inn Room', '243600', '0', '9744', '0', '0', '0', '0', '300', '6', '6', '222', '344.57', '-14.49', '151.05', '227.5');
INSERT INTO `zones_house` VALUES ('55', '226', 'Irontoes East Large Inn Room', '146160', '22000', '5846', '3000', '10', '0', '0', '300', '6', '6', '222', '351.11', '-14.49', '149.08', '44.3');
INSERT INTO `zones_house` VALUES ('56', '225', 'Irontoes East Large Inn Room', '243600', '0', '9744', '0', '0', '0', '0', '300', '6', '6', '222', '351.11', '-14.49', '149.08', '220.72');
INSERT INTO `zones_house` VALUES ('57', '226', 'Irontoes East Large Inn Room', '146160', '22000', '5846', '3000', '10', '0', '0', '300', '6', '6', '222', '355.52', '-14.49', '145.05', '67.17');
INSERT INTO `zones_house` VALUES ('58', '225', 'Irontoes East Large Inn Room', '243600', '0', '9744', '0', '0', '0', '0', '300', '6', '6', '222', '355.18', '-14.49', '144.24', '214.97');
INSERT INTO `zones_house` VALUES ('59', '226', 'Irontoes East Large Inn Room', '146160', '22000', '5846', '3000', '10', '0', '0', '300', '6', '6', '222', '359.18', '-14.49', '140.31', '38.47');
INSERT INTO `zones_house` VALUES ('60', '225', 'Irontoes East Large Inn Room', '243600', '0', '9744', '0', '0', '0', '0', '300', '6', '6', '222', '359.18', '-14.49', '140.31', '218.47');
INSERT INTO `zones_house` VALUES ('61', '49', 'A Maj\'Dul merchant apartment', '579600', '86000', '23184', '9000', '0', '1', '0', '300', '6', '6', '46', '-37.36', '149.93', '-198.22', '9.08');
INSERT INTO `zones_house` VALUES ('62', '49', 'A Maj\'Dul mercenary residence ', '966000', '0', '38640', '0', '0', '1', '0', '300', '6', '6', '46', '-13.67', '158.5', '-205.75', '175.72');
INSERT INTO `zones_house` VALUES ('63', '51', 'An affluent Maj\'Dul residence', '1161720', '120000', '46468', '24000', '0', '1', '0', '700', '6', '6', '46', '130.46', '143.53', '121.36', '55.66');
INSERT INTO `zones_house` VALUES ('64', '48', 'A simple Maj\'Dul apartment', '146160', '22000', '5846', '3000', '0', '1', '0', '200', '6', '6', '46', '-132.63', '137.72', '117.48', '80.85');
INSERT INTO `zones_house` VALUES ('65', '49', 'A Maj\'Dul merchant apartment', '579600', '86000', '23184', '9000', '0', '1', '0', '300', '6', '6', '46', '-180.12', '148.06', '64.42', '128.53');
INSERT INTO `zones_house` VALUES ('66', '52', 'A large Maj\'Dul residence', '1936200', '0', '77448', '0', '0', '1', '0', '700', '6', '6', '46', '-233.95', '137.64', '70.57', '91.89');
INSERT INTO `zones_house` VALUES ('67', '501', 'Valor Homesteads', '0', '0', '500', '0', '0', '0', '0', '200', '6', '6', '470', '-292.2', '175.78', '-94.73', '351.35');
INSERT INTO `zones_house` VALUES ('68', '501', 'Honor Homesteads', '212100', '0', '8233', '0', '0', '0', '0', '200', '6', '6', '470', '-274.52', '172.65', '-151.77', '134.57');
INSERT INTO `zones_house` VALUES ('69', '502', 'Tundra Villa', '500000', '80000', '20000', '8000', '30', '0', '0', '400', '6', '6', '470', '-292.01', '173.36', '-155.8', '223.47');
INSERT INTO `zones_house` VALUES ('70', '503', 'Manors of Mithaniel', '1000000', '200000', '30000', '50000', '30', '0', '0', '700', '6', '6', '470', '-318.06', '180.2', '202', '148.29');
INSERT INTO `zones_house` VALUES ('71', '502', 'Glacial Villa', '966000', '0', '38640', '0', '0', '0', '0', '400', '6', '6', '470', '-403.99', '170.58', '-133.76', '260.86');
INSERT INTO `zones_house` VALUES ('72', '503', 'Manors of Erollisi', '1700000', '0', '70000', '0', '0', '0', '0', '700', '6', '6', '470', '-384.78', '171.78', '-102.56', '328.46');
INSERT INTO `zones_house` VALUES ('73', '503', 'New Halas Mystical Manor', '0', '0', '0', '0', '0', '1', '0', '700', '6', '6', '470', '-362.74', '173.29', '-75.63', '228.2');
INSERT INTO `zones_house` VALUES ('74', '275', 'Gorowyn Heights Magical Manor', '0', '0', '0', '0', '0', '1', '0', '700', '6', '6', '263', '2699.71', '123.4', '1126.13', '130.53');
INSERT INTO `zones_house` VALUES ('75', '260', 'Lower Tenements', '0', '0', '500', '0', '0', '0', '0', '200', '6', '6', '263', '2768.2', '127.48', '1134.57', '97.65');
INSERT INTO `zones_house` VALUES ('76', '274', 'Gorowyn Standards', '500000', '80000', '20000', '8000', '30', '0', '0', '400', '6', '6', '263', '2805.27', '135.53', '1124.12', '206.74');
INSERT INTO `zones_house` VALUES ('77', '275', 'Gorowyn Heights', '1000000', '200000', '30000', '50000', '30', '0', '0', '700', '6', '6', '263', '2828.77', '135.75', '1137.9', '106.22');
INSERT INTO `zones_house` VALUES ('78', '275', 'Timorous Heights', '1700000', '0', '70000', '0', '0', '0', '0', '700', '6', '6', '263', '2826.04', '128.81', '1191.44', '57.06');
INSERT INTO `zones_house` VALUES ('79', '274', 'Terrace Standards', '966000', '0', '38640', '0', '0', '0', '0', '400', '6', '6', '263', '2754.36', '133.98', '1240.74', '350.28');
INSERT INTO `zones_house` VALUES ('80', '260', 'Upper Tenements', '212100', '0', '8233', '0', '0', '0', '0', '200', '6', '6', '263', '2725.01', '130.04', '1194.16', '307.31');
INSERT INTO `zones_house` VALUES ('81', '381', 'Gorowyn Guild Hall', '50000000', '0', '500000', '50000', '30', '0', '0', '0', '6', '6', '263', '2828.95', '122.45', '1234.84', '42.45');

[John Adams]

Good work, alfa. Here's a few things to keep in mind;

If we are not able to move beyond DoV box, the merging of zones is irrelevant. We'll work with whatever DoV box supports until there is hope of moving forward.

For the foreseeable future, I would like all zone data to remain in `zones`, so anything we add will be to that table. Yes, I hate redundant data, but until we address the growing `zones` table data issues fully, I do not want to start adding new tables til a complete overhaul design can be done.

But as you say, this is "some day", and the info is solid. Keep remembering EQ2Emulator = DoV, only, and we'll be able to work with your input.

[alfa]

Tested and should work for DoV too they already set all Qeynos in a single file (for location), just have to modify few names, and add village house (it would be easy).
And table is not for the emu, it's for me, more easier as an xml or txt file :p

[John Adams]

Tested and should work for DoV too they already set all Qeynos in a single file (for location)

You are saying in Destiny of Velious client, 7628L, Qeynos is all 1 file already? I do not see this. What is the new filename?

[Jabantiz]

In AoD clients freeport was revamped, however the old version is still on the clients, the revamp seems to have been a new file and didn't replace the old ones. I was able to get an AoD client into the old freeport on the emu one of the times I was lucky enough to get AoD connected. I do not know if they did the same thing for qeynos but the qeynos revamp was way after DoV.

[alfa]

Tested and should work for DoV too they already set all Qeynos in a single file (for location)

You are saying in Destiny of Velious client, 7628L, Qeynos is all 1 file already? I do not see this. What is the new filename?

Just mean in location, it same if all zone file are joins, locations in Qeynos are like all city was a single file. So not take care about zone file clusturing, zone location still the same. I think they have do it for prevent city revamp without modify all location
It's not in a single file I suppose as Jab say new version of city are in new file. Never been abled to get new Qeynos zone by replacing files in DoV client (files from my live client) I have replace all file qey_*.* but still get old map. More strange, I replace Antonica.vkp too, should seen new Qeynos wall, but no, still in old style, start to think they have implement different layers in same vkp maybe

Edit: Search in live client folder not really helpfull, check map, not find, file, not find, but in .\cache\ioplans\*.* I found file like qeynos_combined01+qeynos_combined02.iop, qeynos_combined01.iop,...