[DiscordArchive] Armor?
[DiscordArchive] Armor?
Archived author: Srzm • Posted: 2024-02-18T20:25:17.887000+00:00
Original source
Armor?
Archived author: Lukè • Posted: 2024-02-18T20:25:37.022000+00:00
Original source
like damage modifier, mana modifier, armor modifier
Archived author: Srzm • Posted: 2024-02-18T20:26:21.946000+00:00
Original source
In that case, don't use `*` after `SELECT`. You can specify the columns you want to get your data from.
Archived author: Lukè • Posted: 2024-02-18T20:27:00.889000+00:00
Original source
how would i specify it?
Archived author: Srzm • Posted: 2024-02-18T20:27:42.898000+00:00
Original source
Do you want to look for yourself first, or the answer right away?
Archived author: Lukè • Posted: 2024-02-18T20:28:02.366000+00:00
Original source
that one i got no clue about xD
Archived author: Srzm • Posted: 2024-02-18T20:30:40.324000+00:00
Original source
Alright. `world.creature` does not hold data about modifiers. `world.creature_template` does.
So, what you want to do is get data from on table that matches data from another table. The keywords to look out for are `UNION` and `JOIN`.
Now, your turn again.