Page 2 of 3
Re: Continuing the "Spells" effort
Posted: Tue Jul 07, 2009 3:49 pm
by Faraden
Its ONLY placed in the world when something needs to be tested, currently its not there, usually only in BETA.
Re: Continuing the "Spells" effort
Posted: Tue Jul 07, 2009 3:57 pm
by Zcoretri
Faraden wrote: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
Re: Continuing the "Spells" effort
Posted: Tue Jul 07, 2009 4:24 pm
by 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.
Re: Continuing the "Spells" effort
Posted: Wed Jul 08, 2009 3:15 am
by Faraden
Calm down John

Re: Continuing the "Spells" effort
Posted: Wed Jul 08, 2009 9:35 am
by ZexisStryfe
I think i was the Z in question

Re: Continuing the "Spells" effort
Posted: Sat Jul 11, 2009 1:19 pm
by Zcoretri
Found something interesting examaning a spell
spell.JPG
Notice the 'Critical Multiplier 1.45' attribute
Re: Continuing the "Spells" effort
Posted: Sat Jul 11, 2009 4:19 pm
by LethalEncounter
Hmm, interesting. You got the packet log for that spell?
Re: Continuing the "Spells" effort
Posted: Tue Jul 14, 2009 4:00 pm
by Zcoretri
LethalEncounter wrote:Hmm, interesting. You got the packet log for that spell?
As a matter of fact I do

Re: Continuing the "Spells" effort
Posted: Tue Jul 14, 2009 4:50 pm
by LethalEncounter
Got it. Thanks!
Re: Continuing the "Spells" effort
Posted: Wed Aug 05, 2009 6:55 pm
by Zcoretri
Thought I would dredge this up because I have started in on spells once again
John Adams wrote: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
Re: Continuing the "Spells" effort
Posted: Mon Sep 14, 2009 12:04 pm
by 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?
Re: Continuing the "Spells" effort
Posted: Mon Sep 14, 2009 12:51 pm
by 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?
Re: Continuing the "Spells" effort
Posted: Mon Sep 14, 2009 5:45 pm
by 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 :/
Re: Continuing the "Spells" effort
Posted: Tue Sep 15, 2009 7:07 am
by 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.
Re: Continuing the "Spells" effort
Posted: Tue Sep 15, 2009 1:04 pm
by Zcoretri
John Adams wrote: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