Sql spell data

[thunderdragon21]

I was looking and saw all the Job point spells where on the list but looked like not to be put in the data base are they unstable? I see they got scripts and all just wondering why the sql is set to not add them to the database. Again thank you all for your hard work.

[RAIST5150]

IIRC, there was a discussion a while back in a previous iteration of the project about managing the unlock/access conundrum.

For example, say BLM unlocks a spell naturally so it is in the spell list, then once obtaining level 99 RDM is able to use that spell before earning the job points that would unlock it.

Not sure it ever got fully flushed out.

[WinterSolstice8]

https://github.com/LandSandBoat/server/blob/base/scripts/globals/canusespell_override.lua

That part is implemented now, not sure if it's 100%.

[thunderdragon21]

Right but what im saying is when you update the spells list in your data base those spells are not put into the database so they may be on your list in game when you unlock them via job points but you cant use it since its not in the database. Just says you cannot cast this spell

[thunderdragon21]

Like refresh 3 and temper 2 and some other spells should be Between Drain 3 and shantoto. Not sure if i did something wrong or what but hear is a pic of my database.

[WinterSolstice8]

That's because they aren't implemented.

server/sql/spell_list.sql

Line 863 in a945600

-- INSERT INTO `spell_list` VALUES (895,'temper_ii',0x00000000000000000000000000000000000000000000,8,7,0,1,0,0,2000,48000,0,0,288,1000,0,0,1.00,0,0,0,0,NULL);

[thunderdragon21]

OK I was just making sure i dident mess something up or do something wrong lol.

[Xaver-DaRed]

Answered by Wnter. Closing.