[DiscordArchive] Hey, i changed something in the DB for Testing and try out the functionality.
[DiscordArchive] Hey, i changed something in the DB for Testing and try out the functionality.
Original source
Hey, i changed something in the DB for Testing and try out the functionality.
I changed the Quality of an Item, that my character is currently wearing from Quality 1 to Quality 3 and the Sell Price from 1 to 50, executed it in the SQL DB.
It was changed.
restarted the Server but then, after that. Ingame nothing changed. It has already Quality 1 and Sell Price 1.
Does anyone know, how can this occur ?
rektbyfaith
04-30-2024, 07:26 PM #1Archived author: DevSoon • Posted: 2024-04-30T19:26:51.651000+00:00
Original source
Hey, i changed something in the DB for Testing and try out the functionality.
I changed the Quality of an Item, that my character is currently wearing from Quality 1 to Quality 3 and the Sell Price from 1 to 50, executed it in the SQL DB.
It was changed.
restarted the Server but then, after that. Ingame nothing changed. It has already Quality 1 and Sell Price 1.
Does anyone know, how can this occur ?
Original source
u didnt delete cache in client
rektbyfaith
04-30-2024, 07:28 PM #2Archived author: Rymercyble • Posted: 2024-04-30T19:28:20.183000+00:00
Original source
u didnt delete cache in client
Original source
everytime when i make changes in the db i need to delete the clients cache ?
rektbyfaith
04-30-2024, 07:28 PM #3Archived author: DevSoon • Posted: 2024-04-30T19:28:57.854000+00:00
Original source
everytime when i make changes in the db i need to delete the clients cache ?
Original source
if its this kind of change yes
rektbyfaith
04-30-2024, 07:29 PM #4Archived author: Rymercyble • Posted: 2024-04-30T19:29:31.102000+00:00
Original source
if its this kind of change yes
Original source
ah, sounds a bit uncomfortable but thats good to know.
thanks a lot.
rektbyfaith
04-30-2024, 07:31 PM #5Archived author: DevSoon • Posted: 2024-04-30T19:31:39.119000+00:00
Original source
ah, sounds a bit uncomfortable but thats good to know.
thanks a lot.
Original source
There is a world server config change to force it to use DB value; which I think helps with needing to delete the cache every time.
rektbyfaith
04-30-2024, 07:32 PM #6Archived author: Abillister • Posted: 2024-04-30T19:32:08.290000+00:00
Original source
There is a world server config change to force it to use DB value; which I think helps with needing to delete the cache every time.
Original source
I think it is EnforceDatabase or EnforceDB something like that.
rektbyfaith
04-30-2024, 07:32 PM #7Archived author: Abillister • Posted: 2024-04-30T19:32:24.052000+00:00
Original source
I think it is EnforceDatabase or EnforceDB something like that.
Original source
EnforceItemAttributes but i dont see how that could work
rektbyfaith
04-30-2024, 07:33 PM #8Archived author: Rymercyble • Posted: 2024-04-30T19:33:49.315000+00:00
Original source
EnforceItemAttributes but i dont see how that could work
Original source
Ah okay, i will try it.
Thanks for your fast response.
rektbyfaith
04-30-2024, 07:39 PM #9Archived author: DevSoon • Posted: 2024-04-30T19:39:46.293000+00:00
Original source
Ah okay, i will try it.
Thanks for your fast response.
Original source
```# ITEM
#
# DBC.EnforceItemAttributes
# Disallow overriding item attributes stored in DBC files with values from the database
# Default: 0 - Off, Use DB values
# 1 - On, Enforce DBC Values (default)
DBC.EnforceItemAttributes = 0
```
I guess, you mean that.
When i set it on zero, it changed nothing.
rektbyfaith
04-30-2024, 07:45 PM #10Archived author: DevSoon • Posted: 2024-04-30T19:45:09.159000+00:00
Original source
```# ITEM
#
# DBC.EnforceItemAttributes
# Disallow overriding item attributes stored in DBC files with values from the database
# Default: 0 - Off, Use DB values
# 1 - On, Enforce DBC Values (default)
DBC.EnforceItemAttributes = 0
```
I guess, you mean that.
When i set it on zero, it changed nothing.