Archery skill problem

[whria78]

SVN3375 , Dolpubdb 3.1alpha , Client 1.109

Archery class of all three realms have the same problem.


When I click archery Spell ( Long Shot 3 ), but

the display say,

"Yoy cast a Fortification of Will spell!"
You feel stronger.

No shot, but it casts a buff (Fortification of Will)


Mismatch between the icon and actual spell ??

Not only " Long shot 3 " but all shot skills ( acid shot ..... ) are also changed to buff skill.

What DB should I check ?

[Leodagan]

Did you test if this happen on Storm Too ?

[whria78]

Same problem on Storm. Is it client side problem?

But, all other classes work fine. only scout class have the problem. Three realms's scout classese

Spells -> Archery

<level 1>
blunt arrows
standard shot 1 --> blunt arrows
fire shot 1 --> blunt arrows
<level 2>
determination
slashing arrows --> determination
cold shot 1 --> determination
long shot 1 --> determination
....
....
...

all shot spells are converted to buff spell of the same level.

Info, animation, combat message too.

[Leodagan]

The trouble must be that client send "spell id" of the buff instead of the "spell id" of the archery shot...

This can only happen in a "List Caster" Specialization with overriding Spell Level

And indeed I'm looking in Storm Database, this spec line was not set to "DOL.GS.LiveSpellHybridSpecialization"

Archery needs to be Hybrid to be able to handle skills given at a same level !

[whria78]

1)
Can I solve this problem by changing SQL Database ? or dolserver C# sourcecode ?

2)
Archery spells exist only up to 16 level.

Specializations : Archery 50+1

but, it has,

Archery Spells : 1~16

[Leodagan]

1)
Can I solve this problem by changing SQL Database ? or dolserver C# sourcecode ?

Sure : in the database you're running you must edit the "Archery" Record in the "Specialization" Table

Code: Select all

UPDATE `Specialization` SET `Implementation` = 'DOL.GS.LiveSpellHybridSpecialization' WHERE `KeyName` LIKE 'Archery';

for the 2) Check your "lineXSpells" Table :

Code: Select all

SELECT * FROM `linexspell` LEFT JOIN `spell` ON `linexspell`.`SpellID` = `spell`.`SpellID` WHERE `linexspell`.`LineName` LIKE 'Archery' ORDER BY `linexspell`.`Level`

Make sure all Spell Line Levels are existing, and that all Spell Records are "joined" correctly (no NULL value in join fields...)

[whria78]

Thanks a lot. It solved.

Both problems are solved after updating DB.

Code: Select all

UPDATE `Specialization` SET `Implementation` = 'DOL.GS.LiveSpellHybridSpecialization' WHERE `KeyName` LIKE 'Archery';