EQ2 Emulator?

[LethalEncounter]

Yah I found that shortly after my last post. Guess I will continue looking :P

[techguy84]

LE, dont forget to get a donation system up and going. You'll get a great deal of revenue from all of us poking in on this thread beacause it would be well deserved.

Get us our own home, a base, then you could have more developers come in and possible take interest in this project and that will take a great load of work off of you. The name of the game is advertising and getting the word out that theres a new hotness in the world of MMORPG Emulators. I have a feeling that once its there, it will take off with lightning speed. Maybe not as good as this project did in its hay-day, but still enough to make us all go wtf?

Geeze all these LE sightings and the post has got me all tore up. I'm going to go launch off some fireworks and wake up the neighbors now.

Them - "What the hell's going on out here"
Me - "IT"S EQ2 EMU BABY WOOT WOOT!!"

[LethalEncounter]

I dont like donation systems for a variety of reasons. Either people donate too much or too little for the hosting but no matter how much they donated some people feel that you owe them something. I would much rather work on a project that I enjoy and put in enough money to cover the server cost myself (if google ads arent enough) than to have some teenage kids telling me that I NEED to fix something for them because "they donated $5". If you dont enjoy your hobbies, you might as well get a second job because thats what it turns into. :P

Hehe, I'm really not that cynical, just trying to explain why I dont like donations

[Secrets]

Originally Posted by LethalEncounter

I dont like donation systems for a variety of reasons. Either people donate too much or too little for the hosting but no matter how much they donated some people feel that you owe them something. I would much rather work on a project that I enjoy and put in enough money to cover the server cost myself (if google ads arent enough) than to have some teenage kids telling me that I NEED to fix something for them because "they donated $5". If you dont enjoy your hobbies, you might as well get a second job because thats what it turns into. :P

Hehe, I'm really not that cynical, just trying to explain why I dont like donations :)

Exactly. Some people don't know the difference between donations and subscriptions.

Less stress = more work done, and more motivation. I'd rather have a developer working on something that he enjoys; especially if he's not getting paid for it.

Our networking instructor told us, "If you don't like your job, get out while it's early enough to do so, otherwise you'd be doing something you don't like the rest of your life. If that's not the field you like, change it before it's too late."

So yeah, gonna have to agree with Lethal here and hope that google ads pay for it.

[John Adams]

Originally Posted by LethalEncounter

Nah, it is a dedicated server meaning you have root access and full control over the server. This is necessary to easily set up a login server on it. Also the bandwidth is 2,000GB (or 2 TB/month). Most places give you between 750GB-1TB for that price.

oh my, i am so retarded. 2,000GB <-- didn't see that. Then yes, that does sound like a smokin deal. Maybe you get blessed with 1,400 popup ads on your site for that low low price

And...

Originally Posted by LethalEncounter

Hehe, I'm really not that cynical, just trying to explain why I dont like donations

I couldn't agree more. Somewhere around this forum is my mostly offensive post that if you cannot afford to host your own server, you shouldn't be hosting one. I despise donations for private servers.Communities are a different story, and I think that might be what Techguy was getting at.

[techguy84]

I could quote, but thats alot of post.

As far as what people may say, make it upfront and visable that things are done when there done and no one is owed anything just becaue they contibuted some legal tender. I personaly will donate for just what you have accomplished to date. If someone donated me some money because of my guide, I would be grateful, but at the same time, said person would not get specail rights that could be abused like "I gave you ONE FREAKIN DOLLAR, WHERES MY PVP." Even if Joe there gave you $100 its still no grounds for control over what you work on.

Donations are simply what the word implies, a dontation. I could pull a dictionary defintion here, but you guys know what it means. If I donate to the American Cancer Society, I dont go knocking on their door asking for reason why I have lost a family member to cancer. You donate to help cost of what has happend, and what can happen.

I can go on and on about kids that abuse what they do not understand but I'll stop here becuase you LE sumed it up in your post.

Still though. You deserve some financial compensation for your efforts and if Google doesnt pay your bills, give me a paypal link and I will help you out also, as will several several several others here, without all the hassle you speak of. Heck, do the souceforge thing as it dont stick out like a big "DONATE" button on the front page. We'll know where to go.

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

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