Continuing the "Spells" effort

[Faraden]

Its ONLY placed in the world when something needs to be tested, currently its not there, usually only in BETA.

[Zcoretri]

Its ONLY placed in the world when something needs to be tested, currently its not there, usually only in BETA.

Exactly, hence why I asked the question, because I have been on test lately and haven't seen those type of NPC's

[John Adams]

You mean this guy?

mike.jpg

Contrary to the nubs coming here thinking we don't know what we're doing... When TSO was in beta, one of our wonderful team members (Zcoretri? Zexis? One of those "Z" names...) logged into Beta, buffed up to level whatever, and collected race/class spells and traits.

Yes, we've done this before. How the hell do you think we got a table full of 4000 spells/abilities? Zams? lolz...


...just sayin... before you assume we're idiots, think.

[Faraden]

Calm down John

[ZexisStryfe]

I think i was the Z in question

[Zcoretri]

Found something interesting examaning a spell

spell.JPG

Notice the 'Critical Multiplier 1.45' attribute

[LethalEncounter]

Hmm, interesting. You got the packet log for that spell?

[Zcoretri]

Hmm, interesting. You got the packet log for that spell?

As a matter of fact I do

[LethalEncounter]

Got it. Thanks!

[Zcoretri]

Thought I would dredge this up because I have started in on spells once again

While we have a decent size list of spells by their class/name, we're still lacking some details as to what the spells, ability, or arts do. How you can help is to log in your character running the EQ2PacketCollector.exe, and simply mouse-over all the icons on your spell book - starting with Abilities, Spells, Combat Arts, and Tradeskills pages. Lots of this data will be redundant, but in this case it's better to have too much than too little. Each class has their own unique abilities, but some also share common abilities. By overly collecting this data, we can match up those classes that use the same ability and reduce redundancies in our database.
While the Traits, Traditions and Achievements are a long way off in terms of server functionality, we would benefit by having this data up front as long as we're collecting spell info as well. In this, open your characters "L" page (achievements), and again mouse-over each of the icons on:
Character Development tab:
{Race} Innate Abilities
Racial Traditions
(I think you can skip the Character Traits, since I think they are the same for all characters)
{Class} Training
{Archetype} Achievements tab:
Mouse-over each one of the achievement circles.
{Class} Achievements tab:
Mouse-over each one of the achievement circles.
As long as you can see the tooltip text on your client screen, the collector will have the data in the EQ2PacketLog.log file. Please accurately name the log to something like {race}-{class}-spells.log (we call all of these "spells" for simplicity heh) and upload to the FTP site listed in the first Sticky post in this forum.
Example naming:
darkelf-wizard-spells.log or
def-wiz-spells.log etc.
As always, your help in this is greatly appreciated. Please post a followup reply here with the race/class you have completed, so others know what not to collect again. I'll go first.

Just want to reiterate stuff for collection

[John Adams]

le Bump!

I too am looking at some of the new raw data for GU52+ spells, and have a question. There is a field in the raw_spells table `min_class_skill_req` which is not currently in our EQ2 DB. This data exists in new (GU52) packets, so I am assuming it is still used.

Should we add this field to `spells` table and Spells processing? I know LE is dabbling with Spells now, and it is the next item on the JA Request List, so what's the consensus?



Part II: Zcoretri, did we do away with `spell_text_color` in our DB? I see it still in Raw, but seem to have a memory about it. If we need it, we should add that too?

[John Adams]

Hunting down what raw_spell_details `unknown10` might be, I am seeing the values are ONLY:

64
65
66 or
65535 (which is probably a bad value?)

Examples:

• spell_id, name, unknown10
  2735715423, Insidious Whisper II, 65
  3789080130, Unholy Hunger, 66
  4164339485, Word of Redemption VI, 65535
  655817029, Repent, 65535
  3501158034, Divine Strike VII, 65535
  2683367038, Divine Smite VII, 65535
  3792707422, Warring Deities V, 65535
  2717321990, Smite Corruption III, 65535
  2008130855, Meliorate VIII, 65535
  843369761, Shield of Faith IV, 65535
  2030047551, Blaze of Faith IV, 65535
  3043579880, Divine Castigation, 65535
  4258801484, Harmony VI, 65535
  2193586092, Hammer Divine Smite, 65535
  3553854409, Restoration VII, 65535
  2580065918, Frozen Palm, 64
  3242124289, Mend, 64
  2063842153, Rescue, 65
  1039089518, Waking Dragon, 64
  509525629, Silent Threat, 65
  2226637742, Roundhouse Kick, 64
  3758047881, Flow Like Wind, 66
  3033583038, Intercept, 64
  2146076321, Divine Smite, 65
  1406390405, Divine Smite II, 65
  2833079751, Earthen Avatar II, 64
  2593365529, Conjuror's Pact, 65
  1831519543, Earthen Avatar III, 64
  866424813, Rising Phoenix II, 64
  1171837214, Knee Break, 64
  2207368889, Enrage, 65
  3487052871, Bloodlust, 66
  2777877104, Maul, 64
  2969700284, Rising Phoenix, 64
  3557357230, Siphon Strike, 64
  2428519641, Chaos, 66
  2131326284, Raging Blow, 64
  2191923327, Berserk Rage II, 66
  581314294, Innoruuk's Caress III, 66
  2504110877, Devious Evasion II, 65
  3051114935, Unholy Strength II, 66
  2368986017, Mutilate, 64
  4172509347, Rupture II, 64
  2229994418, Reckless Aide, 65
  2908491422, Mock III, 65
  2638497050, Knee Break II, 64
  14664364, Rob, 64

Do these values mean anything to anyone?

[LethalEncounter]

Not sure, but I don't think the 65535 values are bad. The display values of the spell doesnt seem to change if this field is set :/

[John Adams]

Yeah Scatman and I were talking in IRC about doing the LE magic, modifying the packet to see what happens when we change that value - but that is light-years beyond my savvy Hopefully that's what you just tried and noticed it does nothing.

If so, maybe the data is totally wrong and the packet re-evaluated.

[Zcoretri]

Yeah Scatman and I were talking in IRC about doing the LE magic, modifying the packet to see what happens when we change that value - but that is light-years beyond my savvy Hopefully that's what you just tried and noticed it does nothing.

If so, maybe the data is totally wrong and the packet re-evaluated.

Yeah I would like to learn how LE does this packet sending magic for testing purposes

I can re-evaluate this packet for the unknown just to make sure