[DiscordArchive] Adding new items via SQL, using existing game assets. Do I need to worry when selecting a value for
[DiscordArchive] Adding new items via SQL, using existing game assets. Do I need to worry when selecting a value for
Original source
Adding new items via SQL, using existing game assets. Do I need to worry when selecting a value for 'entry'? I see the max 'entry' in acore_world.item_template is 56806, so I was going to start my customs at 56807, but I also notice that these entry ID's in item_template are not perfectly sequential. Do I need to worry about conflicting with other tables if I go with my max+1 strategy?
rektbyfaith
03-27-2024, 07:34 PM #1Archived author: Cilo • Posted: 2024-03-27T19:34:05.515000+00:00
Original source
Adding new items via SQL, using existing game assets. Do I need to worry when selecting a value for 'entry'? I see the max 'entry' in acore_world.item_template is 56806, so I was going to start my customs at 56807, but I also notice that these entry ID's in item_template are not perfectly sequential. Do I need to worry about conflicting with other tables if I go with my max+1 strategy?
Original source
no
rektbyfaith
03-27-2024, 07:51 PM #2Archived author: Rymercyble • Posted: 2024-03-27T19:51:00.850000+00:00
Original source
no
Original source
although i would start at some more reasonable number
rektbyfaith
03-27-2024, 07:51 PM #3Archived author: Rymercyble • Posted: 2024-03-27T19:51:15.896000+00:00
Original source
although i would start at some more reasonable number
Original source
its just preference though
rektbyfaith
03-27-2024, 07:51 PM #4Archived author: Rymercyble • Posted: 2024-03-27T19:51:45.029000+00:00
Original source
its just preference though
Original source
and u have to worry about patching client since those items wont work properly otherwise
rektbyfaith
03-27-2024, 07:52 PM #5Archived author: Rymercyble • Posted: 2024-03-27T19:52:06.221000+00:00
Original source
and u have to worry about patching client since those items wont work properly otherwise
Original source
Right on, thanks! Yeah, might make more sense to start at 60000 so it's easy to tell it's my custom
rektbyfaith
03-27-2024, 07:52 PM #6Archived author: Cilo • Posted: 2024-03-27T19:52:51.991000+00:00
Original source
Right on, thanks! Yeah, might make more sense to start at 60000 so it's easy to tell it's my custom
Original source
For posterity, I got an error when running worldserver - Item (Entry: 60000) does not exist in item.dbc.
This seems like just a warning. I'm able to equip the item and see the stat changes just fine. Two bag-related bugs though: I can't right-click to equip it (it's a hat), and the icon is a question mark. Just in the backpack though. Will update if I find a fix for those
rektbyfaith
03-27-2024, 08:13 PM #7Archived author: Cilo • Posted: 2024-03-27T20:13:13.746000+00:00
Original source
For posterity, I got an error when running worldserver - Item (Entry: 60000) does not exist in item.dbc.
This seems like just a warning. I'm able to equip the item and see the stat changes just fine. Two bag-related bugs though: I can't right-click to equip it (it's a hat), and the icon is a question mark. Just in the backpack though. Will update if I find a fix for those
Original source
Requires a client side patch
rektbyfaith
03-27-2024, 08:14 PM #8Archived author: Foe • Posted: 2024-03-27T20:14:28.573000+00:00
Original source
Requires a client side patch
Original source
Would that be an MPQ edit linking the new entry ID to an existing icon?
rektbyfaith
03-27-2024, 08:16 PM #9Archived author: Cilo • Posted: 2024-03-27T20:16:26.074000+00:00
Original source
Would that be an MPQ edit linking the new entry ID to an existing icon?
Original source
Add another entry in item.dbc and use it, server needs it and the client needs it in a MPQ archive yes.
rektbyfaith
03-27-2024, 08:17 PM #10Archived author: Revision • Posted: 2024-03-27T20:17:01.191000+00:00
Original source
Add another entry in item.dbc and use it, server needs it and the client needs it in a MPQ archive yes.