DB/spell questions

[shgall]

K here goes...

I'm working on something (really) ambitious here, and since I have hella free time it'll prolly get done

First, Kaiyodo's spell editor:

1) Does anyone have a list anywhere of the spell book icon/spell gem ID #s and corresponding graphics?

2) The following fields puzzle me:
a) Buff formula
b) Push up
c) Push

3) How does 'Restrictions' work?

4) I'm assuming here that it's not *quite* understood how the focus effects work? For example, this is what Spell Haste IV looks like:

Base      Max    Formula       Type
15         0       100        Unknown
65         0       100        Unknown
-13        0       100        Unknown
3000       0       100        Unknown
-147       0       100        Unknown

I'm *assuming* from this that the first field is the haste % and the second is the maximum level it will affect, the others i'm clueless.

Also with the Unknowns I guess we can't make our own focus effect as the proper type setting isn't known?

5) Is spell stacking controlled by the client?


Okie on to the db questions. I've been using windcatcher's tool, so i've grouped my questions by the tab names there.

Under 'Spawns':

1) Is respawn time in ticks or seconds?

2) What is the 'variance' field and how does it work?

Under 'Spawn Entries':

1) How does the 'Chance' field work?

Under 'NPC Types':

1) I'm assuming -1 in the size field spawns the mob at default size?

2) Does mindmg/maxdmg affect how hard the mob hits? I seem to recall the mob didn't hit for the numbers I chose the last time i messed with it.

Under 'Loot > Loot Drop Entries'

1) What is 'item_charges'?

2) How exactly does the 'chance' field work?

Under 'Loot > Loot Tables':

1) How does the 'avgcoin' field work?

2) I'm assuming base 'currency' is in copper pieces, so entering '1000' in min cash is equal to 1pp?

Under 'Loot > Loot Table Entries':

How does the probablity and multiplier fields work?

Under 'Factions':

1) I figured that the 'mod_c1...mod_c15' fields are modifiers for the different classes. In what order are these classes numbered? (ie alphabetical or the order they are shown on char create)

2) Same with the 'mod_r1...mod_r14' fields.

3) What are the 'mod_r60...mod_r161' fields?

4) I assume the 'mod_d201...mod_d216' fields are for the different deities. Again, what order are they listed?

Finally, that brings me to Quests.

I'm completely lost as to how to modify/create quests. Any help here would be appreciated

And now, in a shameless plug, I thought I might let everyone know what I'm going to be working on.

I've played eqlive since January 2000 on Lanys T'Vyl (2 weeks after the server went live I got my account, I did play before that on a friend's account and I remember Lanys crashing the day they brought it live hehe), and while I've always loved EQ, there are/were many things that I am not happy about.

With the introduction here of the emu and the ability to change/customize the world of Norrath, I'd like to fix a lot of the things that VI/sony should have done.

First, EQ is (although is not really played as such) a roleplaying game. While a big part of any roleplaying game is killing stuff and gaining greater equipment and magic power, a very important and engaging element (which is almost missing in eq) is story. I realize that some people enjoy that hack/slash/gain phat lewtz side of the game, but I know there are many who enjoy adventuring, questing, and plot.

My server (which will be running on a dedicated box), will be radically different from eqlive.

First, at least for a while, Velious/Kunark/Luclin/PoP zones will not exist. I'm going to start out with the original 3 EQ continents. I am, however, going to allow characters to level to 65.

Second, nearly *everything* will be reworked, from npcs, monsters, spawns, items, spells, quests. I want the recognizable feel of EQ, but with a fresh look at the world of Norrath.

Third, one thing I always felt was lacking in EQ was some kind of epic class armor. However, who wants all the a_lvl_65_warriors looking the same? I always thought it would be nice if, say, you could combine epic_breastplate with some_color_dye and have your own look...say a silver breastplate, arms, legs, and gold boots, bracers, and gloves?

Fourth, dynamic content. I was bored the other day and read an old old eq manual. The manual talked about 'frequent GM events and dynamic content and quests resulting in unique items.' Quite a hoot, isn't it? I think in my 3 years as an EQ player (with ~200+ days played across all my characters) I have personally witnessed 6 or 7 GM events. And what happened in each event? A bunch of high levels swarmed in and killed the GM/special mob before any sort of dynamic quest or event could happen. Why? for phat lewt.

Finally, quests. How disappointing is it to do some long involved quest to get your lvl_58_toon a nice uber_weapon_05 and getting the 'You gain experience!' message with not even a pixel increase even on your blue bar? Heck, to test the amount of xp you get from a quest, I ran the Haven Trader quest (for SH faction) a few times on my lvl 1 BST twink. I got 1y of xp at lvl 1 for running this quest. While this quest should not merit a huge gain in xp for a high level character, this basically is about the same amount of xp you get for virtually any quest in EQ. What's the point of the xp message if you really get jack?

Basically I'd like to rework quests to give an amount of xp that is not AMAZING, but is decent nonetheless for the level required to complete the task.

Anyway, I've rambled on long enough, if anyone has any of the information I've requested above, it would be greatly appreciated.

Thanks and have fun in the real world (tm) :p

[shgall]

If anyone is interested, I have a spells_en.txt file that's empty for anyone who wants to redo the spell list like me

edit - guess that not gonna work, seems a lot is hardcoded :(
was worth a shot though...

[Drawde]

Answers to some of your questions

- I'm fairly certain the respawn time is in ticks.
- The variance field affects the chance of one NPC type spawning instead of another, for spawn groups
that have multiple possible spawns, however I haven't done much with multiple spawns so don't know much about it.
- 0 is the default size, which is also 6 (1 is miniscule). Quite a few creature types (e.g pixies and giants)
aren't the right size by default, so need to be scaled up/down in the DB.
- The damage values do affect how hard the mob hits, but it is affected by many other things including the mob's level, your level, AC, skills etc.
- I think the chance value with loot is relative, not a % value. E.g if one item has a chance of 1, and another a chance
of 2, then the one with 2 is twice as likely to drop.
- I -think- the "avgcoin" value determines the type of coin (plat to copper) most likely to drop (CP=1,SP=2,GP=3,PP=4) but I'm not 100% certain.
- The min/max money value is in CP, you're right (this is annoying for high-level monsters that can drop far more than 32PP, since the limit is around 32,000 due to these values being integers)
- The mod_r#, mod_c# and mod_d# - race, class and deity - faction values are how much that faction is modified when your character is that particular race, class and deity. E.g city guards might have a large negative value for race 60 (skeleton) so they will attack people who use Skeleton Form.
Which numbers correspond to which class and race is fairly easy to remember once you've been doing world-building/DB editing for a while (I think it's in the EQEmu docs) but to find the deity numbers you probably need to look in the .hpp files in the EQEmu source code (that's how I did it).

[IAChains]

On Lucy they basically give us the full spell database from the test servers. Is there a way to write a dts to import the .csv they give us without screwing anything else up?

Chains

[Edgar1898]

Hehe actually the limit for pp on a mob is around 4 million although when you loot it, it only gives you 32000pp. Hehe I made a mistake once and put a 500 in the average coin spot :P