[DiscordArchive] I need to select all items such as waist, wrist and feet itemlevel 219, how can I do this in SQL?
[DiscordArchive] I need to select all items such as waist, wrist and feet itemlevel 219, how can I do this in SQL?
Original source
I need to select all items such as waist, wrist and feet itemlevel 219, how can I do this in SQL?
rektbyfaith
01-06-2024, 02:16 AM #1Archived author: Marcelo • Posted: 2024-01-06T02:16:56.354000+00:00
Original source
I need to select all items such as waist, wrist and feet itemlevel 219, how can I do this in SQL?
Original source
Look up select queries, this isn't really SQL 101
rektbyfaith
01-06-2024, 02:18 AM #2Archived author: Revision • Posted: 2024-01-06T02:18:41.737000+00:00
Original source
Look up select queries, this isn't really SQL 101
Original source
Teach me how to make a new creature plss I need some sql 101
rektbyfaith
01-07-2024, 02:26 AM #3Archived author: Kitzunu • Posted: 2024-01-07T02:26:51.169000+00:00
Original source
Teach me how to make a new creature plss I need some sql 101
Original source
Export with packet parser from sniff
rektbyfaith
01-07-2024, 02:27 AM #4Archived author: Bench • Posted: 2024-01-07T02:27:10.901000+00:00
Original source
Export with packet parser from sniff
Original source
Module DB never coming
rektbyfaith
01-07-2024, 02:27 AM #5Archived author: Kitzunu • Posted: 2024-01-07T02:27:20.085000+00:00
Original source
Module DB never coming
Original source
Sadge
rektbyfaith
01-07-2024, 02:27 AM #6Archived author: Kitzunu • Posted: 2024-01-07T02:27:27.108000+00:00
Original source
Sadge
Original source
fascinating issue on my hands. i edited the sql of this item using heidi, executed the change, and can see the change in my database.
server has been restarted, client cache/wtf has been cleared, and yet the item still shows as this and has no change on the character sheet
there's no reason for this item to be blank when the base item gives 4 attack power: https://www.wowhead.com/wotlk/item=28145...lien-wraps
and my modified item should give 4 attack power and 4 spell power. this is the query: super simple
```UPDATE `item_template` SET `stat_type1` = 38, `stat_type2` = 45, `stat_value2` = 2, `armor` = 16 WHERE (`entry` = 28145);```
![[Image: image.png?ex=690c0876&is=690ab6f6&hm=7d6...33bd27da2&]](https://cdn.discordapp.com/attachments/369084351129845760/1193381320693399622/image.png?ex=690c0876&is=690ab6f6&hm=7d6942ab4f666a1b76f4a3923c502cc0f6f5e6da750ba20ae1e524f33bd27da2&)
[Embed: Tranquillien Wraps]
This green leather armor of item level 13 goes in the "Hands" slot. Added in World of Warcraft: The Burning Crusade. Always up to date with the latest patch.
https://www.wowhead.com/wotlk/item=28145...lien-wraps
rektbyfaith
01-07-2024, 02:31 AM #7Archived author: Cyanide • Posted: 2024-01-07T02:31:18.785000+00:00
Original source
fascinating issue on my hands. i edited the sql of this item using heidi, executed the change, and can see the change in my database.
server has been restarted, client cache/wtf has been cleared, and yet the item still shows as this and has no change on the character sheet
there's no reason for this item to be blank when the base item gives 4 attack power: https://www.wowhead.com/wotlk/item=28145...lien-wraps
and my modified item should give 4 attack power and 4 spell power. this is the query: super simple
```UPDATE `item_template` SET `stat_type1` = 38, `stat_type2` = 45, `stat_value2` = 2, `armor` = 16 WHERE (`entry` = 28145);```
[Embed: Tranquillien Wraps]
This green leather armor of item level 13 goes in the "Hands" slot. Added in World of Warcraft: The Burning Crusade. Always up to date with the latest patch.
https://www.wowhead.com/wotlk/item=28145...lien-wraps
Original source
u didnt change stat count
rektbyfaith
01-07-2024, 02:32 AM #8Archived author: Rymercyble • Posted: 2024-01-07T02:32:02.196000+00:00
Original source
u didnt change stat count
Original source
ah so it is a keira issue then
![[Image: image.png?ex=690c0901&is=690ab781&hm=2b9...ed599d871&]](https://cdn.discordapp.com/attachments/369084351129845760/1193381903089274970/image.png?ex=690c0901&is=690ab781&hm=2b959a251763985a2e6ecd233be7352299b67a3bd581f2b0e38c29eed599d871&)
rektbyfaith
01-07-2024, 02:33 AM #9Archived author: Cyanide • Posted: 2024-01-07T02:33:37.718000+00:00
Original source
ah so it is a keira issue then
Original source
tysm
rektbyfaith
01-07-2024, 02:33 AM #10Archived author: Cyanide • Posted: 2024-01-07T02:33:41.512000+00:00
Original source
tysm
1 Guest(s)
1 Guest(s)