Release SQL Query Add Item To Character

[andreycl]

Hi Everyone..

Maybe someone need this for inserting items to characters.

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]

bang mau tanya
tutor install awalnya gimana yak bang

 

[AsliJowo]

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.

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]

Hi Everyone..

Maybe someone need this for inserting items to characters.

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]

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]

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

why you not release that? before im share

 

[dhenmas210]

Tutorial sending item with mail..?

 

[dhenmas210]

why you not release that? before im share

Then, share please..Hehehe