EQ2 Emulator?

[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