Release SQL Query Add Item To Character

andreycl · Aug 18, 2019

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.

aditya97 · Aug 18, 2019

bang mau tanya
tutor install awalnya gimana yak bang

AsliJowo · Aug 19, 2019

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

andreycl said:

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.

dhenmas210 · Aug 19, 2019

andreycl said:

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..?

andreycl · Aug 19, 2019

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

AsliJowo · Aug 19, 2019

haha i am not a good boy like you :w00t:

andreycl said:
why you not release that? before im share

dhenmas210 · Oct 6, 2019

Tutorial sending item with mail..?

dhenmas210 · Mar 25, 2020

andreycl said:
why you not release that? before im share

Then, share please..Hehehe

Release SQL Query Add Item To Character

andreycl

Newbie Spellweaver

aditya97

Newbie Spellweaver

AsliJowo

Junior Spellweaver

dhenmas210

Elite Diviner

andreycl

Newbie Spellweaver

AsliJowo

Junior Spellweaver

dhenmas210

Elite Diviner

dhenmas210

Elite Diviner