[DiscordArchive] Could add it to the reference, no?
[DiscordArchive] Could add it to the reference, no?
Original source
Could do a select of trainers that use a reference list and get their subname
rektbyfaith
12-01-2023, 01:40 AM #11Archived author: Bench • Posted: 2023-12-01T01:40:06.221000+00:00
Original source
Could do a select of trainers that use a reference list and get their subname
Original source
I think I will spawn/fly to known class trainer hubs, then check for their IDs in the ID column.
rektbyfaith
12-01-2023, 01:43 AM #12Archived author: Cyanide • Posted: 2023-12-01T01:43:20.295000+00:00
Original source
I think I will spawn/fly to known class trainer hubs, then check for their IDs in the ID column.
Original source
It would've been smart to set the ref list for classes equal to the class ID (how warriors are 1, their ref should've been 200001).
rektbyfaith
12-01-2023, 01:44 AM #13Archived author: Cyanide • Posted: 2023-12-01T01:44:49.178000+00:00
Original source
It would've been smart to set the ref list for classes equal to the class ID (how warriors are 1, their ref should've been 200001).
Original source
♀️ I don't think there are lots of people saying it's a great solution as it currently stands
rektbyfaith
12-01-2023, 01:45 AM #14Archived author: Bench • Posted: 2023-12-01T01:45:42.863000+00:00
Original source
♀️ I don't think there are lots of people saying it's a great solution as it currently stands
Original source
Once this is finished do you mind submitting it as a wiki change for me? (I don't know how wiki works)
![[Image: image.png?ex=690bff1d&is=690aad9d&hm=829...c8b56f4dd&]](https://cdn.discordapp.com/attachments/284406375495368704/1179962929374843040/image.png?ex=690bff1d&is=690aad9d&hm=8299e6ab2c4f2bc0e45966aad6228eb02627020b9df8c4cbd06623ec8b56f4dd&)
rektbyfaith
12-01-2023, 01:51 AM #15Archived author: Cyanide • Posted: 2023-12-01T01:51:25.054000+00:00
Original source
Once this is finished do you mind submitting it as a wiki change for me? (I don't know how wiki works)
Original source
I can submit, can't guarantee it'll be accepted
rektbyfaith
12-01-2023, 01:53 AM #16Archived author: Bench • Posted: 2023-12-01T01:53:05.597000+00:00
Original source
I can submit, can't guarantee it'll be accepted
Original source
I solved all the classes. I can't/won't do professions but it's better than nothing. Hopefully they accept the edit as it's free info that saves time.
I'd also pitch rewriting the spell id stuff to something like. "In this table there are two types of IDs used.
ID = If the ID is positive it refers to a creature. If it is negative, it refers to a spell-list.
Spell ID = If the above ID is above 200000, this is one spell in the spell-list. If the ID is below 200000 is references a creature.
For example:
3060 -200005 adds the Shaman trainer spell-list to NPC 3060.
but
-200005 403 adds Lightning Bolt to the shaman spell-list 200005.
IDs Categorised:
-200001 WARRIOR UP TO 6
-200002 WARRIOR UP TO 80
-200003 PALADIN UP TO 6
-200004 PALADIN UP TO 80
-200005 DRUID UP TO 6
-200006 DRUID UP TO 80
-200007 MAGE UP TO 6
-200008 MAGE UP TO 80
-200009 WARLOCK UP TO 6
-200010 WARLOCK UP TO 80
-200011 PRIEST UP TO 6
-200012 PRIEST UP TO 80
-200013 HUNTER UP TO 6
-200014 HUNTER UP TO 80
-200015 ROGUE UP TO 6
-200016 ROGUE UP TO 80
-200017 SHAMAN UP TO 6
-200018 SHAMAN UP TO 80
-200019 DK UP TO 80
rektbyfaith
12-01-2023, 02:04 AM #17Archived author: Cyanide • Posted: 2023-12-01T02:04:01.282000+00:00
Original source
I solved all the classes. I can't/won't do professions but it's better than nothing. Hopefully they accept the edit as it's free info that saves time.
I'd also pitch rewriting the spell id stuff to something like. "In this table there are two types of IDs used.
ID = If the ID is positive it refers to a creature. If it is negative, it refers to a spell-list.
Spell ID = If the above ID is above 200000, this is one spell in the spell-list. If the ID is below 200000 is references a creature.
For example:
3060 -200005 adds the Shaman trainer spell-list to NPC 3060.
but
-200005 403 adds Lightning Bolt to the shaman spell-list 200005.
IDs Categorised:
-200001 WARRIOR UP TO 6
-200002 WARRIOR UP TO 80
-200003 PALADIN UP TO 6
-200004 PALADIN UP TO 80
-200005 DRUID UP TO 6
-200006 DRUID UP TO 80
-200007 MAGE UP TO 6
-200008 MAGE UP TO 80
-200009 WARLOCK UP TO 6
-200010 WARLOCK UP TO 80
-200011 PRIEST UP TO 6
-200012 PRIEST UP TO 80
-200013 HUNTER UP TO 6
-200014 HUNTER UP TO 80
-200015 ROGUE UP TO 6
-200016 ROGUE UP TO 80
-200017 SHAMAN UP TO 6
-200018 SHAMAN UP TO 80
-200019 DK UP TO 80
Original source
For Future Control-F people: Npc trainer, add spell to trainer, trainer add spell, custom spell trainer, trainer spells, edit trainers, class spell lists, trainer classes, npc_trainer, spellID, spell id
rektbyfaith
12-01-2023, 02:04 AM #18Archived author: Cyanide • Posted: 2023-12-01T02:04:41.671000+00:00
Original source
For Future Control-F people: Npc trainer, add spell to trainer, trainer add spell, custom spell trainer, trainer spells, edit trainers, class spell lists, trainer classes, npc_trainer, spellID, spell id
Original source
ur a spell
rektbyfaith
12-01-2023, 02:09 AM #19Archived author: Anchy • Posted: 2023-12-01T02:09:14.079000+00:00
Original source
ur a spell
Original source
It doesn't even work lmao. 200005 is the lvl 1-6 druid reference, I refreshed the db and restarted the server. xd
![[Image: image.png?ex=690c09f6&is=690ab876&hm=67a...2b42d5584&]](https://cdn.discordapp.com/attachments/284406375495368704/1179974579649790083/image.png?ex=690c09f6&is=690ab876&hm=67a719859fa5dafc8a1a5c0e0807b2bdd5684056127fd8e65cbb0232b42d5584&)
![[Image: image.png?ex=690c09f6&is=690ab876&hm=9ee...eb4e144b8&]](https://cdn.discordapp.com/attachments/284406375495368704/1179974580027273328/image.png?ex=690c09f6&is=690ab876&hm=9eef541181fb8994858c81865c4e2083dfc914fd7b3c18ccc5d3f8ceb4e144b8&)
rektbyfaith
12-01-2023, 02:37 AM #20Archived author: Cyanide • Posted: 2023-12-01T02:37:42.791000+00:00
Original source
It doesn't even work lmao. 200005 is the lvl 1-6 druid reference, I refreshed the db and restarted the server. xd
1 Guest(s)
1 Guest(s)