player spells

[Ememjr]

what would be the best way to get the player spell tier for a particular spell(AA)
if all i know is the spell id ( i get the spell id and aa group from the client

( a regular spell send the spell id and tier)

i will then pull the info from masterspell list
if the player does not have that spell yet then ill just pull the master tier 0 ( or is the lowest 1)

[Ememjr]

i got tthat one figure out
now heres the delima
hovering over an AA the client send the CRC to the server for the handleexamine routines

when right clicking and examine the client sends for the spell id
the spell id comes from the adventurelist packet we create
the spell id in the advneture packet comes from the nodeid column in spell_aa_nodelist
i do not see (yet the nodeid used anywhere else, so i do believe the nodeid in spell_aa_nodelist should be changed to our EMu's spell id

then when right click examine the proper spell id is called up, since i do not believe we currenlty have a cross check i our db for that

since the CRC is in both spell_aa_nodelist and spells table i will do an update on mine (backup first) to replace all the nodeid in spell_aa_nodelist
with spell_id from spells (comparing the CRC)

does this sound logical

[Ememjr]

here is the sql script that needs to be run to fix the nodeid talked about in previous post

Code: Select all

UPDATE spell_aa_nodelist INNER JOIN spells ON spells.soe_spell_crc = spell_aa_nodelist.spellcrc SET spell_aa_nodelist.nodeid = spells.id