EQ2 Emulator?

[saweb]

I found this while checking out EQ2's data structure:

// Database classes/fields for editable data entities in EQ2

 RuntimeVdl/Customizations
 RuntimeVdl/OptionInfoManager
 RuntimeVdl/IconColorScheme
 RuntimeVdl/Base
 RuntimeVdl/Shaders
 RuntimeVdl/Models
 RuntimeVdl/Nodes
 RuntimeVdl/TextureDef
 RuntimeVdl/FractalDef
 RuntimeVdl/TerrainSkirt
 RuntimeVdl/Appearance
 RuntimeVdl/Environment
 RuntimeVdl/SpellCast
 RuntimeVdl/ZoneSettings
 RuntimeVdl/KeywordList
 RuntimeVdl/Date
 RuntimeVdl/Position
 RuntimeVdl/CharacterCreationZone
 RuntimeVdl/GlobalSound
 RuntimeVdl/HelpTopicStructure
 RuntimeVdl/Mounts
 RuntimeVdl/BugTypes
 RuntimeVdl/Slideshow
 RuntimeVdl/World
 RuntimeVdl/QAMarker
 RuntimeVdl/HeroicOpportunity
 RuntimeVdl/GameCmd
 RuntimeVdl/PromoFlags
 RuntimeVdl/TitleList
 RuntimeVdl/RecipeFilter

Now upon further inspection, I found that each one of these configuration files contain some form of client side database structure, complete with field list, default field values, data input type and a discription of the data it contains.

Examples of the data contained within these files can be found here:

- [CharacterCreationZone]
- [Mounts]

Im not exactly the expert, but this seems to resemble a database that (atleast some part of it) should be in sync with the server.

Could be useless, but I thought its worth a post.

[LethalEncounter]

Interesting. The structs dont seem to be complete, but they may prove useful in the future. How exactly are you getting these files?

[saweb]

Originally Posted by LethalEncounter

Interesting. The structs dont seem to be complete, but they may prove useful in the future. How exactly are you getting these files?

Checkout the repository on my other thread, it has a tool to extract these files. . . Hope you have vs2005 though.

Otherwise I could just send you the executables, but im too tired now :P

Good night.

[saweb]

I quickly made a DB, that looks alot like the structure found in the EQ2 config files.

-MYsql queries.

/*
MySQL Data Transfer
Source Host: 127.0.0.1
Source Database: runtimevdl
Target Host: 127.0.0.1
Target Database: runtimevdl
Date: 7/25/2007 4:44:20 PM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for bugtype
-- ----------------------------
CREATE TABLE `bugtype` (
  `name` varchar(128) NOT NULL,
  `display_name` text NOT NULL,
  `description` text NOT NULL,
  `aSubTypes` float(44,0) NOT NULL,
  `aBugTypes` float(44,0) NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for collision_data
-- ----------------------------
CREATE TABLE `collision_data` (
  `Entry` int(11) NOT NULL,
  `scriptName` varchar(11) NOT NULL,
  `sourceName` varchar(11) NOT NULL,
  `meshName` varchar(11) NOT NULL,
  `fRadius` float(11,0) NOT NULL,
  `minBBox` float(11,0) NOT NULL,
  `maxBBox` float(11,0) NOT NULL,
  `initialOffset` float(11,0) NOT NULL,
  `aMaterialDefs` float(11,0) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for continent_definitions
-- ----------------------------
CREATE TABLE `continent_definitions` (
  `Entry` int(11) NOT NULL,
  `directory` int(11) NOT NULL,
  `bBoxMin` float(11,0) NOT NULL,
  `bBoxMax` float(11,0) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for event_date
-- ----------------------------
CREATE TABLE `event_date` (
  `Event` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `month` int(11) NOT NULL,
  `day` int(11) NOT NULL,
  `hour` int(11) NOT NULL,
  `minute` int(11) NOT NULL,
  `second` int(11) NOT NULL,
  PRIMARY KEY  (`Event`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for helptopicstructure
-- ----------------------------
CREATE TABLE `helptopicstructure` (
  `Entry` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `topic_name` text NOT NULL,
  `topic_file` text NOT NULL,
  `aSubTopics` float(44,0) NOT NULL,
  `aTopics` float(44,0) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for keywordlist
-- ----------------------------
CREATE TABLE `keywordlist` (
  `Entry` tinyint(11) NOT NULL,
  `aKeywords` varchar(255) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for mount
-- ----------------------------
CREATE TABLE `mount` (
  `Entry` int(11) NOT NULL,
  `sDDFieldExclusions` text NOT NULL,
  `bAdjustPitch` enum('false','true') NOT NULL,
  `bAdjustHeading` enum('false','true') NOT NULL,
  `fSpeed` float NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for position
-- ----------------------------
CREATE TABLE `position` (
  `Entry` int(11) NOT NULL,
  `loc` varchar(16) NOT NULL,
  `heading` float(6,0) NOT NULL,
  `pitch` float(6,0) NOT NULL,
  `roll` float(6,0) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for recipefilter
-- ----------------------------
CREATE TABLE `recipefilter` (
  `name` varchar(255) NOT NULL,
  `filterItems` float NOT NULL,
  `selected` float NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for spellcast
-- ----------------------------
CREATE TABLE `spellcast` (
  `Entry` int(11) NOT NULL,
  `Event` varchar(125) NOT NULL,
  `fEventTime` float NOT NULL,
  `state` varchar(255) NOT NULL,
  `iRepeatCount` int(125) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for world_definitions
-- ----------------------------
CREATE TABLE `world_definitions` (
  `Entry` int(11) NOT NULL,
  `WorldDef` varchar(11) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for zonesettingsboatfields
-- ----------------------------
CREATE TABLE `zonesettingsboatfields` (
  `Entry` int(11) NOT NULL,
  `bLoadOcean` enum('false','true') NOT NULL,
  `bRockBoat` enum('false','true') NOT NULL,
  `sOceanName` varchar(255) NOT NULL,
  `fBoatSpeed` float(11,0) default '-1',
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for zonesettingssoundfields
-- ----------------------------
CREATE TABLE `zonesettingssoundfields` (
  `Entry` tinyint(11) NOT NULL,
  `soundRoom` varchar(255) NOT NULL default 'generic',
  `music` varchar(255) NOT NULL,
  `ambientSoundData` varchar(255) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------

[LethalEncounter]

That looks pretty interesting. Thanks for the work on that!


BTW the new dedicated server is setup and running:

http://eq2emulator.net/forums/index.php


Please post over there now so we can stop leaching DM's bandwidth

[saweb]

Great work, lets hope it doesnt bankrupt you over time :P

[link2009]

Nice to see you're back on track LE. I've been vacationing for the past few months .