ptarp
02-23-2010, 03:09 AM
I think I found my problem. After importing the spells_us.txt with import_spells.pl, I ended up with duplicate spells in the database. Here's an example (deleted the SQL insert stuff for clarity..)
10659, 'Hastening of Ellowind', 'PLAYER_1', '0', '0', '0', 'Your body begins to move faster.', '\'s body begins to move faster.', 'Your speed fades.', 100, 100, 0, 0, 9000, 2250, 2250, 11, 420, 0, 1512, 0, 72, 60, 64, 168, 24, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 64, 168, 0, 0, 0, 0, 0, 0, 0, 2501, 2054, -1, -1, -1, -1, 1, 1, 1, 1, -1, -1, -1, -1, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 0, 1, 0, 0, 10, 6, 5, 2, 11, 169, 10, 330, 254, 254, 254, 254, 41, 95, 5, -1, 0, 0, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 75, 255, 255, 61, 27, 0, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 134, 211, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10659, 125, 41, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 202, 11, 420, 0, 0, 1, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, -1, 10027, 1, 0, 1, 0, 0, 1, 1);Second spell with the same name..
14512, 'Hastening of Ellowind', 'PLAYER_1', '0', '0', '0', '0', '0', '0', 100, 100, 0, 0, 9000, 2250, 2250, 11, 420, 0, 1890, 0, 90, 76, 79, 168, 27, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 79, 168, 0, 0, 0, 0, 0, 0, 0, 2501, 2054, -1, -1, -1, -1, 1, 1, 1, 1, -1, -1, -1, -1, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 0, 1, 0, 0, 10, 6, 5, 2, 11, 169, 10, 330, 254, 254, 254, 254, 41, 95, 5, -1, 0, 0, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 80, 255, 255, 61, 27, 0, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 134, 211, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14512, 125, 41, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 202, 11, 420, 0, 0, 1, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, -1, 10122, 1, 0, 1, 0, 0, 1, 1);
After deleting the second entry, I was able to place the spell in the toon's book with GeorgeS's item editor, but the spell scroll was still level 255, and maybe it is somehow linked to the second listed spell. Before importing, the only spell available was the second ID though. Very easy to tell them appart since they have no cast_on_you or cast_on_other field.
Maybe I missed a step somewhere, not sure. Trying to learn all this though.
I'm thinking maybe when the SoF disk was released, the first spell was to be used, but they changed when they went live (I know I still had to download crap even with the disk).
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.