EQ2 Emulator?

[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 .

[John Adams]

I am normally not one to necro a year old thread... but re-reading this post brought back a lot of great memories of the revitalization of the Everquest 2 Emulator project. Since the eqemulator.net community forums get so many hits a day, I just wanted to remind anyone interested here that there is an eq2emulator.net community as well, since the games are fairly related in concept at least.

The EQ2Emu server core has made amazing progress in very little time. Lethalencounter has turned out to be everything everyone said he was. Excellent dev, patient guy, and has nearly single-handedly built us a working emulator that works with current live EQ2 clients. I got involved in the data side of things back in Nov '07, and at that time v0.1 you could create a character and log in. That's it.

I am proud to say that in less than 6 mos, nearly all the chat, combat, xp, skills/abilities, spawns and object interaction systems are in place. There is still lots to do, but the amazing speed at which things have been developed - by one guy - is impressive. Next up, the quest system!

I hope no one thinks this is out of line, posting here. I'd love to sticky this particular post in your Off-Topic for those who come here asking about an EQ2Emulator, but I would not dare be so presumptuous We (the eq2emu community) have not really advertised our existence outside of this thread, so maybe it is about time.

http://eq2emulator.net

John Adams
Database Designer - EQ2Emu Project

[deez225]

i've been over to the eq2emulator site. im new to all of this. im looking to make my own private classic eq2 server. before any expansions or AA were invented. any word on an original classic server in development or the files already made for the entire thing and are able to download? many thanks to anyone who replies with some useful info.