Forums WoW Modding Support Archives Azerothcore Discord Archives [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?

[DiscordArchive] I need to select all items such as waist, wrist and feet itemlevel 219, how can I do this in SQL?

Pages (4): 1 2 3 4 Next
rektbyfaith
Administrator
0
01-06-2024, 02:16 AM
#1
Archived 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?
rektbyfaith
01-06-2024, 02:16 AM #1

Archived 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?

rektbyfaith
Administrator
0
01-06-2024, 02:18 AM
#2
Archived author: Revision • Posted: 2024-01-06T02:18:41.737000+00:00
Original source

Look up select queries, this isn't really SQL 101
rektbyfaith
01-06-2024, 02:18 AM #2

Archived author: Revision • Posted: 2024-01-06T02:18:41.737000+00:00
Original source

Look up select queries, this isn't really SQL 101

rektbyfaith
Administrator
0
01-07-2024, 02:26 AM
#3
Archived 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
rektbyfaith
01-07-2024, 02:26 AM #3

Archived 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

rektbyfaith
Administrator
0
01-07-2024, 02:27 AM
#4
Archived author: Bench • Posted: 2024-01-07T02:27:10.901000+00:00
Original source

Export with packet parser from sniff
rektbyfaith
01-07-2024, 02:27 AM #4

Archived author: Bench • Posted: 2024-01-07T02:27:10.901000+00:00
Original source

Export with packet parser from sniff

rektbyfaith
Administrator
0
01-07-2024, 02:27 AM
#5
Archived author: Kitzunu • Posted: 2024-01-07T02:27:20.085000+00:00
Original source

Module DB never coming
rektbyfaith
01-07-2024, 02:27 AM #5

Archived author: Kitzunu • Posted: 2024-01-07T02:27:20.085000+00:00
Original source

Module DB never coming

rektbyfaith
Administrator
0
01-07-2024, 02:27 AM
#6
Archived author: Kitzunu • Posted: 2024-01-07T02:27:27.108000+00:00
Original source

Sadge
rektbyfaith
01-07-2024, 02:27 AM #6

Archived author: Kitzunu • Posted: 2024-01-07T02:27:27.108000+00:00
Original source

Sadge

rektbyfaith
Administrator
0
01-07-2024, 02:31 AM
#7
Archived 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);```
[Image: image.png?ex=690c0876&is=690ab6f6&hm=7d6...33bd27da2&]

[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 #7

Archived 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);```
[Image: image.png?ex=690c0876&is=690ab6f6&hm=7d6...33bd27da2&]

[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
Administrator
0
01-07-2024, 02:32 AM
#8
Archived author: Rymercyble • Posted: 2024-01-07T02:32:02.196000+00:00
Original source

u didnt change stat count
rektbyfaith
01-07-2024, 02:32 AM #8

Archived author: Rymercyble • Posted: 2024-01-07T02:32:02.196000+00:00
Original source

u didnt change stat count

rektbyfaith
Administrator
0
01-07-2024, 02:33 AM
#9
Archived author: Cyanide • Posted: 2024-01-07T02:33:37.718000+00:00
Original source

ah so it is a keira issue then
[Image: image.png?ex=690c0901&is=690ab781&hm=2b9...ed599d871&]
rektbyfaith
01-07-2024, 02:33 AM #9

Archived author: Cyanide • Posted: 2024-01-07T02:33:37.718000+00:00
Original source

ah so it is a keira issue then
[Image: image.png?ex=690c0901&is=690ab781&hm=2b9...ed599d871&]

rektbyfaith
Administrator
0
01-07-2024, 02:33 AM
#10
Archived author: Cyanide • Posted: 2024-01-07T02:33:41.512000+00:00
Original source

tysm
rektbyfaith
01-07-2024, 02:33 AM #10

Archived author: Cyanide • Posted: 2024-01-07T02:33:41.512000+00:00
Original source

tysm

Pages (4): 1 2 3 4 Next
Recently Browsing
 1 Guest(s)
Recently Browsing
 1 Guest(s)