Hello everyone, I'm sharing this program with you, which appeared like a hero during the times when we constantly messed up the database by trying to add items to NPCs manually when I first started in this field. May the creator's hands be blessed.
Tables that need to be edited in the SHARD database before using the program.
_RefObjChar,
_RefObjCommon,
_RefPackageItem,
_RefShop,
_RefShopGroup,
_RefShopItemGroup,
_RefShopTab,
Tab_RefHive,
Tab_RefNest,
Tab_RefTactics ve
_RefShopTabGroup
The Primary Key and Identity Specification fields of the IDs in the tables above must be set to 'yes'.
_RefScrapOfPackageItem
In the table, the index section should have both Primary Key and Identity Specification set to 'yes'.
If the index section described in the tables below does not exist, configure its settings.
_RefPricePolicyOfItem
_RefShopGoods
After creating a column with type `int` at the end of the tables, set the `index Primary Key` and `Identity Specification` to `yes`. This should be done to avoid errors during SQL updates.
Items above level 12 or 13, or specially added items like avatar scrolls, may appear as "noimage," but if there's an icon in the client media section, it won't show as "noname" in-game.
*** Hidden text: cannot be quoted. ***
