Newbie Spellweaver
- Joined
- Aug 17, 2019
- Messages
- 41
- Reaction score
- 7
Hi Everyone..
Maybe someone need this for inserting items to characters.
Hope this help you.
Maybe someone need this for inserting items to characters.
Code:
INSERT INTO MaterializedItems (ItemSerial, ItemID, ItemRemainCount, PayMethodCode, SenderCharacterID, ItemMaterializeCode, ItemMaterializeFKey, ItemDurability, RandomSeed, CoolTime, ItemLevel, ItemPotential, SoulBoundFlag, SealCount, ItemOption, ItemMaterializeDate, ItemLifespan, EternityFlag, ItemExpireDate, OwnerCharacterID, OwnershipStartDate, ExpireCompleteFlag, TradeItemFlag, AdditiveItemID, ItemLocationCode, ItemLocationIndex, ItemPotentialMoveCount, ItemCount, ItemPrice, DragonJewelType) VALUES ((CAST(RAND() * 280000000 AS bigint)), 'ITEM CODE HERE WITHOUT QUOTE','TOTAL ITEM',NULL,NULL,1,NULL,0,341544762,0,0,0,1,0,0,GETDATE(),2628000,1,'ITEM DURATION','CHARACTER ID',GETDATE(),0,NULL,NULL,2,120,0,1,0,0)
Hope this help you.
Last edited: