Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Development

Development::Development Forum for development topics and for those interested in EQEMu development. (Not a support forum)

Reply
 
Thread Tools Display Modes
  #1  
Old 02-13-2009, 01:37 AM
KLS
Administrator
 
Join Date: Sep 2006
Posts: 1,348
Default

The size of the item packet is not the same as the live from june sadly. I don't know if it's too long or too short just that it doesn't align. I also have a feeling there's an option somewhere that dictates how data is displayed cause my first thought was to look at the stats in the item window and see if I could find where they were in relation but it's not making sense compared to the packet im making. =(

Hooray spending hours adjusting the size up and down by bits at a time ><
Reply With Quote
  #2  
Old 02-13-2009, 03:30 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Here is the SQL to get all of the new zones (after Titanium) working with SoF. This is just a basic setup to give a usable safe point and have the zone display correctly. I am sure that each one could use tweaking (fog, min/max clips, etc), but this is definitely better than what I started with :P

Code:
INSERT INTO `zone` VALUES ('arcstone', null, 'Arcstone', '0', '0', '550', '0', '0', '80', '369', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('ashengate', null, 'Ashengate, Reliquary of the Scale', '0', '26', '3.1', '0', '0', '80', '406', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('atiiki', null, 'Jewel of Atiiki', '0', '0', '-76', '0', '0', '80', '418', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('barren', null, 'Barren Coast', '800', '335', '33', '0', '0', '80', '422', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('befallenb', null, 'Befallen', '0', '0', '0', '0', '0', '80', '411', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('blacksail', null, 'Blacksail Folly', '4500', '1600', '309', '0', '0', '80', '428', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('bloodmoon', '', 'Bloodmoon Keep', '100', '100', '4', '0', '0', '0', '445', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('buriedsea', null, 'The Buried Sea', '1225', '0', '310', '0', '0', '80', '423', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('commonlands', null, 'Commonlands', '0', '0', '24.2', '0', '0', '80', '408', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('crescent', null, 'Crescent Reach', '-550', '-430', '80', '0', '0', '80', '394', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('cryptofshade', '', 'Crypt of Shade', '985', '-445', '-39', '0', '0', '0', '449', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('crystallos', '', 'Crystallos, Lair of the Awakened', '0', '0', '0', '0', '0', '0', '446', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('deadbone', null, 'Deadbone Reef', '2500', '-3500', '544', '0', '0', '80', '427', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('devastationa', null, 'The Seething Wall', '200', '250', '4', '0', '0', '80', '373', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('devastion', null, 'The Devastation', '650', '800', '100', '0', '0', '80', '372', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('direwind', null, 'Direwind Cliffs', '0', '0', '-16', '0', '0', '80', '405', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('dragonscale', '', 'Dragonscale Hills', '0', '0', '58', '0', '0', '0', '442', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('elddar', null, 'The Elddar Forest', '0', '0', '220', '0', '0', '80', '378', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('elddara', null, 'Tunare/s Shrine', '-30', '30', '-5', '0', '0', '80', '379', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('freeportacademy', null, 'Academy of Arcane Science', '0', '200', '0', '0', '0', '80', '385', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('freeportarena', null, 'Arena', '0', '0', '3', '0', '0', '80', '388', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('freeportcityhall', null, 'City Hall', '0', '150', '-11', '0', '0', '80', '389', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('freeporteast', null, 'East Freeport', '0', '0', '10', '0', '0', '80', '382', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('freeporthall', null, 'Hall of Truth', '-500', '1000', '-177', '0', '0', '80', '391', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('freeportmilitia', null, 'Freeport Militia House', '-50', '-150', '-25', '0', '0', '80', '387', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('freeportsewers', null, 'Freeport Sewers', '-150', '-50', '-95', '0', '0', '80', '384', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('freeporttemple', null, 'Temple of Marr', '0', '0', '10', '0', '0', '80', '386', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('freeporttheater', null, 'Theater', '0', '-150', '-27', '0', '0', '80', '390', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('freeportwest', null, 'West Freeport', '-240', '0', '-83', '0', '0', '80', '383', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('frostcrypt', null, 'Frostrypt, Throne of the Shade King', '0', '0', '0', '0', '0', '80', '402', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('guardian', '', 'The Mechamatic Guardian', '-115', '60', '4', '0', '0', '0', '447', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('gyrospireb', '', 'Gyrospire Beza', '500', '-200', '6', '0', '0', '0', '440', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('gyrospirez', '', 'Gyrospire Zeka', '500', '-200', '6', '0', '0', '0', '441', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('highpasshold', null, 'Highpass Hold', '-90', '-80', '-20', '0', '0', '80', '407', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('highpasskeep', null, 'HighKeep', '0', '0', '0', '0', '0', '80', '412', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('hillsofshade', '', 'Hills of Shade', '100', '100', '33', '0', '0', '0', '444', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('icefall', null, 'Icefall Glacier', '300', '50', '80', '0', '0', '80', '400', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('innothuleb', null, 'Innothule Swamp', '0', '0', '0', '0', '0', '80', '413', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('jardelshook', null, 'Jardels Hook', '2815', '-1077', '318.1', '0', '0', '80', '424', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('kattacastrum', null, 'Katta Castrum', '0', '0', '0', '0', '0', '80', '416', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('kithforest', null, 'Kithicor Forest', '0', '0', '0', '0', '0', '80', '410', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('lopingplains', '', 'Loping Plains', '0', '0', '93', '0', '0', '0', '443', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('maidensgrave', null, 'Maidens Grave', '-3615', '3335', '400', '0', '0', '80', '429', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('mansion', '', 'Meldrath\'s Majestic Mansion', '0', '0', '0', '0', '0', '0', '437', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('mechanotus', '', 'Fortress Mechanotus', '0', '0', '478', '0', '0', '0', '436', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('mesa', null, 'Goru`Kar Mesa', '-1155', '7', '47', '0', '0', '80', '397', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('mistythicket', null, 'Misty Thicket', '0', '0', '0', '0', '0', '80', '415', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('monkeyrock', null, 'Monkey Rock', '0', '0', '0', '0', '0', '0', '425', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('moors', null, 'Blightfire Moors', '-200', '-10', '80', '0', '0', '0', '395', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('northro', null, 'North Ro', '-1027', '6354', '23.2', '0', '0', '80', '392', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('oceanoftears', null, 'Ocean Of Tears', '0', '0', '0', '0', '0', '80', '409', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('rage', null, 'Sverag, Stronghold of Rage', '500', '120', '0', '0', '0', '80', '374', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('ragea', null, 'Razorthorn, Tower of Sullon Zek', '0', '0', '0', '0', '0', '80', '375', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('redfeather', null, 'Redfeather Isle', '-3100', '1400', '310', '0', '0', '80', '430', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('relic', null, 'Relic', '200', '385', '420', '0', '0', '80', '370', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('roost', null, 'Blackfeather Roost', '-700', '3000', '-191', '0', '0', '80', '398', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('shipmvm', null, 'The Open Sea', '-200', '-200', '33', '0', '0', '80', '435', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('shipmvp', null, 'The Open Sea', '-80', '-120', '46', '0', '0', '80', '431', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('shipmvu', null, 'The Open Sea', '-75', '-75', '46', '0', '0', '80', '432', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('shippvu', null, 'The Open Sea', '-75', '-75', '46', '0', '0', '80', '433', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('shipuvu', null, 'The Open Sea', '-75', '-75', '46', '0', '0', '80', '434', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('shipworkshop', '', 'S.H.I.P. Workshop', '300', '400', '113', '0', '0', '0', '439', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('silyssar', null, 'Silyssar, New Chelsith', '-175', '-185', '-59', '0', '0', '80', '420', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('skylance', null, 'Skylance', '0', '0', '251.1', '0', '0', '80', '371', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('solteris', null, 'Solteris, the Throne of Ro', '0', '0', '-20', '0', '0', '80', '421', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('southro', null, 'South Ro', '-1000', '1000', '42', '0', '0', '80', '393', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('steamfactory', '', 'The Steam Factory', '0', '100', '90', '0', '0', '0', '438', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('steamfontmts', '', 'Steamfont Mountains', '-500', '-100', '3', '0', '0', '0', '448', '0', '0', '1', '', '-2030', '450', '3000', '10', '3000', '210', '200', '200', '1', '0', '1.00', '0.4', '2', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '200', '200', '210', '10', '3000', '200', '200', '210', '10', '450', '', '2', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('steppes', null, 'The Steppes', '300', '0', '130', '0', '0', '80', '399', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('stonehive', null, 'Stone Hive', '400', '0', '58', '0', '0', '80', '396', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('suncrest', null, 'Suncrest Isle', '-2125', '-178', '406', '0', '0', '80', '426', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('sunderock', null, 'Sunderock Springs', '165', '325', '211', '0', '0', '80', '403', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('takishruins', null, 'Ruins of Takish-Hiz', '-460', '-200', '50', '0', '0', '80', '376', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('takishruinsa', null, 'The Root of Ro', '800', '-190', '-90', '0', '0', '80', '377', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('thalassius', null, 'Thalassius, the Coral Keep', '0', '0', '0', '0', '0', '80', '417', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('theater', null, 'Theater of Blood', '2933', '715', '380', '0', '0', '80', '380', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('theatera', null, 'Deathknell, Tower of Dissonance', '100', '0', '3.2', '0', '0', '80', '381', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('toxxulia', null, 'Toxxulia Forest', '0', '0', '66.6', '0', '0', '80', '414', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('valdeholm', null, 'Valdeholm', '300', '50', '0', '0', '0', '80', '401', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('vergalid', null, 'Vergalid Mines', '0', '0', '0', '0', '0', '80', '404', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
INSERT INTO `zone` VALUES ('zhisza', null, 'Zhisza, the Shissar Sanctuary', '0', '850', '305', '0', '0', '80', '419', '0', '0', '1', null, '-2030', '450', '3000', '10', '3000', '0', '0', '0', '1', '1', '0.00', '0.4', '2', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '0', '0', '0', '10', '3000', '0', '0', '0', '450', '450', '', '1', '1', '1', '1', '0', '5000');
To add this in, you will need to open your zones table and do a sort by zoneidnumber, and then delete all lines from zoneidnumber 369 up to 449. Then, the SQL above should be able to be sourced in the table ok, as long as your table is setup the same way mine is. I got mine from PEQ, but it was a year ago, and there have been a couple of additions to that table from source revision updates since then. So, it might be good to check if it lines up with this setup I have for my zone table:

Code:
CREATE TABLE `zone` (
  `short_name` varchar(16) NOT NULL default '',
  `file_name` varchar(16) default NULL,
  `long_name` text NOT NULL,
  `safe_x` float NOT NULL default '0',
  `safe_y` float NOT NULL default '0',
  `safe_z` float NOT NULL default '0',
  `graveyard_id` float NOT NULL default '0',
  `min_level` tinyint(3) unsigned NOT NULL default '0',
  `min_status` tinyint(3) unsigned NOT NULL default '0',
  `zoneidnumber` int(4) NOT NULL default '0',
  `timezone` int(5) NOT NULL default '0',
  `maxclients` int(5) NOT NULL default '0',
  `weather` smallint(6) NOT NULL default '1',
  `note` varchar(80) default NULL,
  `underworld` float NOT NULL default '0',
  `minclip` float NOT NULL default '450',
  `maxclip` float NOT NULL default '450',
  `fog_minclip` float NOT NULL default '450',
  `fog_maxclip` float NOT NULL default '450',
  `fog_blue` tinyint(3) unsigned NOT NULL default '0',
  `fog_red` tinyint(3) unsigned NOT NULL default '0',
  `fog_green` tinyint(3) unsigned NOT NULL default '0',
  `sky` tinyint(3) unsigned NOT NULL default '1',
  `ztype` tinyint(3) unsigned NOT NULL default '1',
  `zone_exp_multiplier` decimal(6,2) NOT NULL default '0.00',
  `walkspeed` float NOT NULL default '0.4',
  `time_type` tinyint(3) unsigned NOT NULL default '2',
  `fog_red1` tinyint(3) unsigned NOT NULL default '0',
  `fog_green1` tinyint(3) unsigned NOT NULL default '0',
  `fog_blue1` tinyint(3) unsigned NOT NULL default '0',
  `fog_minclip1` float NOT NULL default '450',
  `fog_maxclip1` float NOT NULL default '450',
  `fog_red2` tinyint(3) unsigned NOT NULL default '0',
  `fog_green2` tinyint(3) unsigned NOT NULL default '0',
  `fog_blue2` tinyint(3) unsigned NOT NULL default '0',
  `fog_minclip2` float NOT NULL default '450',
  `fog_maxclip2` float NOT NULL default '450',
  `fog_red3` tinyint(3) unsigned NOT NULL default '0',
  `fog_green3` tinyint(3) unsigned NOT NULL default '0',
  `fog_blue3` tinyint(3) unsigned NOT NULL default '0',
  `fog_minclip3` float NOT NULL default '450',
  `fog_maxclip3` float NOT NULL default '450',
  `fog_red4` tinyint(3) unsigned NOT NULL default '0',
  `fog_green4` tinyint(3) unsigned NOT NULL default '0',
  `fog_blue4` tinyint(3) unsigned NOT NULL default '0',
  `fog_minclip4` float NOT NULL default '450',
  `fog_maxclip4` float NOT NULL default '450',
  `flag_needed` varchar(128) NOT NULL default '',
  `canbind` tinyint(4) NOT NULL default '1',
  `cancombat` tinyint(4) NOT NULL default '1',
  `canlevitate` tinyint(4) NOT NULL default '1',
  `castoutdoor` tinyint(4) NOT NULL default '1',
  `insttype` tinyint(1) unsigned zerofill NOT NULL default '0',
  `shutdowndelay` bigint(16) unsigned NOT NULL default '5000',
  PRIMARY KEY  (`short_name`),
  UNIQUE KEY `zoneidnumber` (`zoneidnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
For working out the item structure size and field locations, I am always willing to give it a shot. If we can find the Heroic stats section of the struct, it shouldn't be much after that. If you stick something up on the SVN for items, I will definitely give it a shot

Also, I think I may know why AAs aren't loading, and I am guessing it may be due to an issue with the player profile struct. I think I have verified that many fields are in the correct locations, but some of them are a bit more complicated. And, I am not quite sure which things in game for the client come from the player profile or the spawn struct, since they are both redundant in alot of things.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #3  
Old 02-13-2009, 03:46 AM
OscarGrouch05
Sarnak
 
Join Date: Apr 2008
Posts: 71
Default

I use this site the help me or i read the eqnews.txt file in client
http://eqplayers.station.sony.com/game_updates.vm

to help me out with what was changed or fixed

the newest client i have found to be open and say i have all expanshions
is 04/11/08 update, i'm waiting for the next one to be soon i hope and keep my fingers crossed

as i have noticed the opcodes for login have changed after May of 08.
i'll keep working on the login opcodes if i find more info i'll be sure to let
you known.
Reply With Quote
  #4  
Old 02-13-2009, 04:13 AM
KLS
Administrator
 
Join Date: Sep 2006
Posts: 1,348
Default

Took a couple hours but:


Hopefully can get items basically loading soonish, I have a decent idea on augments but I'm gonna probably hold off at first. There's a lot of other packets to do with items that will need to be covered, item links, moving items, using clicky items etc. Every item packet with a slot ref will have to be encoded/decoded even if it hasn't changed because of the 22-39 getting bumped up a slot.

...but ima go lie down now I think.
Reply With Quote
  #5  
Old 02-13-2009, 05:12 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

That is great news KLS! Considering that most other item related packets shouldn't be all too big, I think getting items working in the first place will be the hardest part. After that, it should just be adjusting a few small structs slightly and then finding a few opcodes.

Also, I didn't really think about it until now, but I am betting my issues with AAs displaying is also related to the expansion field issue that Derision mentioned that is causing the Power Source slot to not show up. I will mess with it a bit more. Right now, I am reworking a bit of the player profile struct to be more in line and accurate to what Derision's packet log shows. It seems to be helping so far, at least for displaying armor materials. I know that alot of that struct is already lined up properly, so it is mostly just adjusting the sections in between the parts that already line up. I am not sure why, but my AA window shows that I have 917 unspent AAs (which is accurate to what Titanium shows), but only 62 spent AAs even though Titanium shows 260 spent. Maybe that too is expansion field related, but it makes me think that maybe that field is just in the wrong place. Though, it looks like it should be in the right place from everything I have referenced so far (packet collects, showeq structs and Titanium structs).

And, OscarGrouch, I am not sure what you are trying to accomplish with the different clients you are trying. We will not be using any client after SoF, so any after that is nearly pointless. Yeah, you can find opcodes to log in to character select pretty easily, but that is very easy compared to filling in all of the packet structures properly and the rest of the missing opcodes. Plus, it is unlikely that we would ever want to use a client that isn't legally attainable. The expansion information you are talking about, I am guessing is the list of expansions that show up at the server select screen. That doesn't matter to the development of SoF at all. So, you shouldn't use any more time on that unless you have something else you are working on that isn't related to this development. Maybe I am just not clear on what it is that you are trying to accomplish.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #6  
Old 02-13-2009, 06:22 PM
KLS
Administrator
 
Join Date: Sep 2006
Posts: 1,348
Default

That field is probably in the wrong place. Speaking of wrong placed fields the pop combat ratings seem to of moved... along with faction mods, and I'm still trying to plot out the entire rest of the packet but it's slow goin, hopefully I'll have enough done to start loading inventory soon though.

Ima revise that I don't think they moved but something is definitely keeping them from displaying, there must be some bit that controls that column's vis.

Last edited by KLS; 02-14-2009 at 03:29 AM..
Reply With Quote
  #7  
Old 02-13-2009, 08:44 PM
KLS
Administrator
 
Join Date: Sep 2006
Posts: 1,348
Default

If you get a chance could you go collect a book type item from live? I'm not sure how they're doing filename now... it does seem to be an int size but I'd like an item to study before moving on.
Reply With Quote
  #8  
Old 02-13-2009, 08:44 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

I wouldn't be too surprised if they weren't showing up because we weren't sending the correct expansion packet like Derision said. It is keeping the Power Source slot from showing up, so maybe it also keeps PoP stats from showing up. I am interested to see how much that expansion packet corrects. I have a feeling it will help my AA window issues and probably the max level of 75 issue too.

I am mostly trying to clean up the spawn struct, illusion struct and player profile some while I wait for Derisions next update. There is still plenty I can work on, so no rush

And yeah, I will try to get a book now.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #9  
Old 02-13-2009, 09:07 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Here is a noobie note that should work just as well as anything. The 02 I bolded is itemtype 2 for book:

Code:
Feb 13 2009 18:46:22:638 [Decoded] [Server->Client] [Size: 11915]
[OPCode: 0x709d]
000 | 0a 00 00 00 01 00 00 00 00 00 00 00 1d 00 00 00  | ................ 
016 | 00 00 00 00 01 00 00 00 00 00 00 00 8a 4a 02 00  | .............J.. 
032 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
048 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
064 | 00 00 00 02 43 72 65 73 63 65 6e 74 20 52 65 61  | ....Crescent Rea 
080 | 63 68 20 47 75 69 6c 64 20 53 75 6d 6d 6f 6e 73  | ch Guild Summons 
096 | 00 4c 6f 6f 6b 73 20 6c 69 6b 65 20 69 74 27 73  | .Looks like it's 
112 | 20 77 6f 72 74 68 20 72 65 61 64 69 6e 67 00 49  |  worth reading.I 
128 | 54 36 33 00 21 e5 00 00 00 01 00 00 00 00 00 00  | T63.!........... 
144 | 00 00 00 00 00 f8 01 00 00 01 00 00 00 00 00 00  | ................ 
160 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
176 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
192 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 80 00  | ................ 
208 | 00 00 00 00 00 00 00 00 00 00 00 00 00 ff ff ff  | ................ 
224 | ff 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
240 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
256 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
272 | 00 00 00 00 00 00 ff 00 00 00 00 00 00 00 00 00  | ................ 
288 | 00 00 00 00 00 00 80 3f 00 00 00 00 00 00 00 00  | .......?........ 
304 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
320 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
336 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
352 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
368 | 00 00 00 00 00 00 00 00 00 00 00 00 00 01 00 00  | ................ 
384 | 00 00 00 01 00 00 00 00 00 01 00 00 00 00 00 01  | ................ 
400 | 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 00  | ................ 
416 | 00 00 00 46 00 00 00 00 00 00 00 00 00 00 00 00  | ...F............ 
432 | ff 43 52 45 57 69 7a 61 72 64 4e 6f 74 65 00 00  | .CREWizardNote.. 
448 | 00 00 00 00 00 00 00 00 00 01 00 00 00 00 00 00  | ................ 
464 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
480 | 00 00 ff ff ff ff 00 00 00 00 00 00 00 00 00 00  | ................ 
496 | 00 01 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
512 | 00 00 00 00 00 00 00 00 00 00 00 ff ff ff ff 00  | ................ 
528 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
544 | 00 00 00 00 00 00 00 00 00 00 ff ff ff ff ff ff  | ................ 
560 | ff ff 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
576 | 00 00 00 00 00 00 00 00 00 00 00 00 00 ff ff ff  | ................ 
592 | ff ff ff ff ff 00 00 00 00 00 00 00 00 00 00 00  | ................ 
608 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
624 | ff ff ff ff ff ff ff ff 00 00 00 00 00 00 00 00  | ................ 
640 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
656 | 00 00 00 ff ff ff ff ff ff ff ff 00 00 00 00 00  | ................ 
672 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
688 | 00 00 00 00 00 00 ff ff ff ff ff ff ff ff 00 00  | ................ 
704 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
720 | 00 00 00 00 00 00 00 00 00 ff ff ff ff 00 00 00  | ................ 
736 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
752 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
768 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
784 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
800 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  | ................ 
816 | 00 00 00 00 00 00 00 00 00 00 00
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 12:44 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3