[DiscordArchive] Wanna try reading into SQL first to learn it? Or do you want the answer right away?
[DiscordArchive] Wanna try reading into SQL first to learn it? Or do you want the answer right away?
Original source
Wanna try reading into SQL first to learn it? Or do you want the answer right away?
rektbyfaith
02-18-2024, 07:58 PM #1Archived author: Srzm • Posted: 2024-02-18T19:58:30.176000+00:00
Original source
Wanna try reading into SQL first to learn it? Or do you want the answer right away?
Original source
good point
rektbyfaith
02-18-2024, 08:01 PM #2Archived author: Lukè • Posted: 2024-02-18T20:01:11.501000+00:00
Original source
good point
Original source
would it be something like this? <@240223878146686976> SELECT * FROM creature.world WHERE map = 000, zoneid = 0000 areaid = 0000? because i want just the specific trash npcs/bosses in specific dungeons so i can customize then (increase health, damage, armor etc)
rektbyfaith
02-18-2024, 08:17 PM #3Archived author: Lukè • Posted: 2024-02-18T20:17:17.582000+00:00
Original source
would it be something like this? <@240223878146686976> SELECT * FROM creature.world WHERE map = 000, zoneid = 0000 areaid = 0000? because i want just the specific trash npcs/bosses in specific dungeons so i can customize then (increase health, damage, armor etc)
Original source
`world.creature`, like this.
The IDs have to be replaced by the map IDs of your dungeons.
rektbyfaith
02-18-2024, 08:21 PM #4Archived author: Srzm • Posted: 2024-02-18T20:21:35.684000+00:00
Original source
`world.creature`, like this.
The IDs have to be replaced by the map IDs of your dungeons.
Original source
Oh, and also:
Combining multiple conditions after `WHERE` does not work with `,` . Instead, you need another keyword.
rektbyfaith
02-18-2024, 08:22 PM #5Archived author: Srzm • Posted: 2024-02-18T20:22:52.966000+00:00
Original source
Oh, and also:
Combining multiple conditions after `WHERE` does not work with `,` . Instead, you need another keyword.
1 Guest(s)
1 Guest(s)