[DiscordArchive] The mounts itself or the skill?
[DiscordArchive] The mounts itself or the skill?
Archived author: Ryan Turner • Posted: 2025-04-20T12:58:47.692000+00:00
Original source
The mounts itself or the skill?
Archived author: Illu • Posted: 2025-04-20T12:59:22.156000+00:00
Original source
skill too, seems like the mount level was changed, but don't see it changed on rams for some reasons
Archived author: Ryan Turner • Posted: 2025-04-20T13:00:01.030000+00:00
Original source
```sql
SET
@RidingLevel := 5,
@RidingCost := 95,
@ApprenticeOrc := 5668,
@ApprenticeUndead := 13331,
@ApprenticeTauren := 15277,
@ApprenticeTroll := 8592,
@ApprenticeBloodElf := 29222,
@ApprenticeHuman := 2411,
@ApprenticeDwarf := 5873,
@ApprenticeNightElf := 8631,
@ApprenticeGnome := 13324,
@ApprenticeDraenei := 29743;
UPDATE `item_template` SET `RequiredLevel`=@RidingLevel WHERE `entry` IN (@ApprenticeOrc, @ApprenticeUndead, @ApprenticeTauren, @ApprenticeTroll, @ApprenticeBloodElf, @ApprenticeHuman, @ApprenticeDwarf, @ApprenticeNightElf, @ApprenticeGnome, @ApprenticeDraenei);
UPDATE npc_trainer SET MoneyCost=@RidingCost, ReqLevel=@RidingLevel WHERE ID=202010 AND SpellID=33388;
```
Archived author: Ryan Turner • Posted: 2025-04-20T13:01:08.845000+00:00
Original source
ApprenticeX is what i wanted to give early on. you can changed that to all mounts.
The last part where npc_trainer is the one you want to change
Archived author: Illu • Posted: 2025-04-20T13:05:22.660000+00:00
Original source
Wait I must've skipped a memo or something, I was updating mysql tables by hand
Archived author: Ryan Turner • Posted: 2025-04-20T13:05:43.568000+00:00
Original source
Learning the basics of sql can be handy.
Archived author: Illu • Posted: 2025-04-20T13:06:11.899000+00:00
Original source
I know the basics of sql
Archived author: Illu • Posted: 2025-04-20T13:06:14.922000+00:00
Original source
not this to
Archived author: Illu • Posted: 2025-04-20T13:06:28.791000+00:00
Original source
^^'
Archived author: Ryan Turner • Posted: 2025-04-20T13:06:29.853000+00:00
Original source
That's just variables