Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Release SQL Query Add Item To Character

Newbie Spellweaver
Joined
Aug 17, 2019
Messages
41
Reaction score
7
Hi Everyone..

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:
Newbie Spellweaver
Joined
Jul 9, 2019
Messages
35
Reaction score
3
bang mau tanya
tutor install awalnya gimana yak bang
 
Junior Spellweaver
Joined
Mar 19, 2017
Messages
150
Reaction score
20
Good for share, but why you not use Proc for mail or locker item, i think its very simple and have good view for player :)
Hi Everyone..

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.
 
Elite Diviner
Joined
Jul 31, 2019
Messages
430
Reaction score
62
Hi Everyone..

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.
Bang..
Increase ftg or ftg limit..?

 
Newbie Spellweaver
Joined
Aug 17, 2019
Messages
41
Reaction score
7
Good for share, but why you not use Proc for mail or locker item, i think its very simple and have good view for player :)

why you not release that? before im share :)
 
Back
Top