[DiscordArchive] wait so i need to look up the ID +200003 in the creature table?
[DiscordArchive] wait so i need to look up the ID +200003 in the creature table?
Archived author: DrNefarius • Posted: 2023-11-01T18:34:58.347000+00:00
Original source
wait so i need to look up the ID +200003 in the creature table?
Archived author: Bench • Posted: 2023-11-01T18:36:55.494000+00:00
Original source
If the spell ID in the trainer table is -200003, then you'd look for the ID (same one with creature IDs) also in the trainer table with a value of 200003
Archived author: wakemeup • Posted: 2023-11-01T18:37:20.146000+00:00
Original source
math people would say the absolute value
Archived author: Abillister • Posted: 2023-11-01T18:40:08.016000+00:00
Original source
Aye, sorry if I didn't answer that clearly when I said to remove the negative sign. Use the ABS(value) when looking it up.
![[Image: image.png?ex=690c42e4&is=690af164&hm=282...699482743&]](https://cdn.discordapp.com/attachments/284406375495368704/1169345264365096960/image.png?ex=690c42e4&is=690af164&hm=28291f887f6832cd0584872314bb35aeac7549d8adc44453207df96699482743&)
Archived author: DrNefarius • Posted: 2023-11-01T18:40:36.455000+00:00
Original source
![[Image: image.png?ex=690c42e4&is=690af164&hm=282...699482743&]](https://cdn.discordapp.com/attachments/284406375495368704/1169345264365096960/image.png?ex=690c42e4&is=690af164&hm=28291f887f6832cd0584872314bb35aeac7549d8adc44453207df96699482743&)
Archived author: DrNefarius • Posted: 2023-11-01T18:40:41.572000+00:00
Original source
this is what ive been searching for
Archived author: wakemeup • Posted: 2023-11-01T18:41:25.717000+00:00
Original source
Not your fault mate, that one's on me because I did not want to believe that someone would abuse a single innocent column like that
Archived author: DrNefarius • Posted: 2023-11-01T18:41:53.087000+00:00
Original source
i just thought the whole time i could do this in the pre-made menus of keira but i needed to write the sql myself
Archived author: Bench • Posted: 2023-11-01T18:41:54.878000+00:00
Original source
Hey, it's worked up to this point
Archived author: DrNefarius • Posted: 2023-11-01T18:41:57.281000+00:00
Original source
anyway, thanks