[DiscordArchive] From my understanding, all items are now in db2 - is it possible to extract them to DB and change th
[DiscordArchive] From my understanding, all items are now in db2 - is it possible to extract them to DB and change th
Original source
From my understanding, all items are now in db2 - is it possible to extract them to DB and change their values? Names, stats, prices etc?
rektbyfaith
06-22-2025, 04:49 PM #1Archived author: Vel • Posted: 2025-06-22T16:49:58.600000+00:00
Original source
From my understanding, all items are now in db2 - is it possible to extract them to DB and change their values? Names, stats, prices etc?
Original source
yes. via hotfixes (the hotfix db)
rektbyfaith
06-22-2025, 04:52 PM #2Archived author: Northstrider • Posted: 2025-06-22T16:52:59.134000+00:00
Original source
yes. via hotfixes (the hotfix db)
Original source
that's how blizz makes changes without having to ship a new patch
rektbyfaith
06-22-2025, 04:53 PM #3Archived author: Northstrider • Posted: 2025-06-22T16:53:12.224000+00:00
Original source
that's how blizz makes changes without having to ship a new patch
Original source
I see, I found item_sparse and I am going to test it. Is it wise to import all item_sparse table from wago tools or is it better to just let it be "empty" and modify only desired items? I mean, in case of client update, it could wreck a lot of things I guess.
rektbyfaith
06-22-2025, 05:03 PM #4Archived author: Vel • Posted: 2025-06-22T17:03:47.622000+00:00
Original source
I see, I found item_sparse and I am going to test it. Is it wise to import all item_sparse table from wago tools or is it better to just let it be "empty" and modify only desired items? I mean, in case of client update, it could wreck a lot of things I guess.
Original source
Well, I renamed an item in item_sparse. It now shows the new name in .look item. But when added and (or) howered it shows the old name. I cleaned cache and I have DBC overriding disabled in config.
```conf
DBC.EnforceItemAttributes = 0
```
Is there something more I should do?
rektbyfaith
06-22-2025, 05:09 PM #5Archived author: Vel • Posted: 2025-06-22T17:09:21.396000+00:00
Original source
Well, I renamed an item in item_sparse. It now shows the new name in .look item. But when added and (or) howered it shows the old name. I cleaned cache and I have DBC overriding disabled in config.
```conf
DBC.EnforceItemAttributes = 0
```
Is there something more I should do?
Original source
DBC.EnforceItemAttributes does nothing in master
rektbyfaith
06-22-2025, 05:10 PM #6Archived author: Tea • Posted: 2025-06-22T17:10:53.955000+00:00
Original source
DBC.EnforceItemAttributes does nothing in master
Original source
you need to add hotfix_data (the purpose of this table is to inform the client that a hotfix exists and it needs to request it)
rektbyfaith
06-22-2025, 05:12 PM #7Archived author: Tea • Posted: 2025-06-22T17:12:05.504000+00:00
Original source
you need to add hotfix_data (the purpose of this table is to inform the client that a hotfix exists and it needs to request it)
Original source
Thank you very much! I understood that Tablehash should be `0x6A7C6E76` for item_sparse. What's the difference between UniqueId and RecordId tho? Also should ID be just autoincrement or should I make my own increment like 20000 to avoid future overrides by SQL updates of the TC?
rektbyfaith
06-22-2025, 05:19 PM #8Archived author: Vel • Posted: 2025-06-22T17:19:27.218000+00:00
Original source
Thank you very much! I understood that Tablehash should be `0x6A7C6E76` for item_sparse. What's the difference between UniqueId and RecordId tho? Also should ID be just autoincrement or should I make my own increment like 20000 to avoid future overrides by SQL updates of the TC?
Original source
I am making a mistake somewhere.
```json
[ // hotfix_data
{
"Id": 2000000,
"UniqueId": 4289663027,
"TableHash": 1786539638,
"RecordId": 157674,
"Status": 1,
"VerifiedBuild": 200000
}
]
```
Renamed the item to "Test 2" inside `item_sparse`.
Server restarted. ✅
Cache deleted. ✅
Item still with original name. :/
![[Image: image.png?ex=690c379b&is=690ae61b&hm=d48...5e971e88e&]](https://cdn.discordapp.com/attachments/376457124726702080/1386403477021921361/image.png?ex=690c379b&is=690ae61b&hm=d4856cc9562c36e12579fca7099bdb3476259289f4d4d5303671d545e971e88e&)
![[Image: image.png?ex=690c379b&is=690ae61b&hm=f10...b7390cad3&]](https://cdn.discordapp.com/attachments/376457124726702080/1386403477546336256/image.png?ex=690c379b&is=690ae61b&hm=f10e3312a0f728bda0791d02d21caacb06d838d56f556b899cc961fb7390cad3&)
rektbyfaith
06-22-2025, 05:52 PM #9Archived author: Vel • Posted: 2025-06-22T17:52:27.108000+00:00
Original source
I am making a mistake somewhere.
```json
[ // hotfix_data
{
"Id": 2000000,
"UniqueId": 4289663027,
"TableHash": 1786539638,
"RecordId": 157674,
"Status": 1,
"VerifiedBuild": 200000
}
]
```
Renamed the item to "Test 2" inside `item_sparse`.
Server restarted. ✅
Cache deleted. ✅
Item still with original name. :/
Original source
your table hash is wrong
rektbyfaith
06-22-2025, 05:57 PM #10Archived author: Tea • Posted: 2025-06-22T17:57:20.300000+00:00
Original source
your table hash is wrong
1 Guest(s)
1 Guest(s)