Re: how to add drop items
Quote:
Originally Posted by
Rapidx3
hello guys, i liked this forum so i will put a lot of the releases soon
GO SRO_VT_SHARD and open _RefMonster_AssignedItemDrop
[RefMonsterID] here you will put the id of monster
[RefItemID] here you will put the id of item
[DropGroupType] here you have to put 0
[OptLevel] you have to put 0 here also
[DropAmountMin] here you will put the drop rate of item
[DropAmountMax] here you will put maximum number of drop item from one mob
[DropRatio] his means drop rate ex: x1 or x2
HOW TO GET MONSTER ID?
you've to run this query
Code:
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC'
you've to change the green code to your own mob or unique code
HOW TO GET ITEM ID?
you've to run this query
Code:
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'ITEM_CH_TBLADE_11_SET_A_RARE'
you've to change the green code to your item code
thank you guys and have a great fun.
thank you
Re: how to add drop items
Re: how to add drop items
good jop ..... keep working
Re: how to add drop items
Re: how to add drop items
Good Job Our Hero :P:
but really really thank you , My thank has been added :wink:
Re: how to add drop items
thank you guys for likes, and soon i will put a lot of releases later.
Re: how to add drop items
do you like to put a release about add full new maps ? pvp area and event area etc ?
Re: how to add drop items
Really Thanks Man
You are My Salvation (:love:sz)
Re: how to add drop items
Re: how to add drop items
are you kidding me ? its a query but my thread is full tut how to add a new items to drop not just add it by query. really facepalm is not enough i dont like the ppl like you haters -.-.
Re: how to add drop items
Re: how to add drop items
OLD
Copy and Past ???
Here My Query Edited
PHP Code:
USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By nukertube*/
GO
DECLARE @Mob VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT
--------------------------------------------------------------------------
SET @Mob = 'MOB_TQ_WHITESNAKE'/*Monster Code*/
SET @Item = 'ITEM_MALL_GLOBAL_CHATTING'/*Item Code*/
SET @DropAmountMin = 10 /*Drop Min*/
SET @DropAmountMax = 50 /*Drop Max*/
SET @DropRatio = 0.9 /*0.5 = '50%' */
--------------------------------------------------------------------------
SET @MonsterID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Mob)/**/
SET @ItemID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Item)/**/
INSERT [dbo].[_RefMonster_AssignedItemDrop]/**/
(RefMonsterID,RefItemID,DropGroupType,OptLevel,DropAmountMin,DropAmountMax,DropRatio,RefMagicOptionID1,CustomValue1,RefMagicOptionID2,CustomValue2,RefMagicOptionID3,CustomValue3,RefMagicOptionID4,CustomValue4,RefMagicOptionID5,CustomValue5,RefMagicOptionID6,CustomValue6,RefMagicOptionID7,CustomValue7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9,CustomValue9,RentCodeName)/**/
VALUES(@MonsterID,@ItemID,0,0,@DropAmountMin,@DropAmountMax,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')/**/
CREDITS TO Hean and me For Big Edit
Re: how to add drop items
Quote:
Originally Posted by
K4bo
oh really?
yeah really.
Quote:
Originally Posted by
xxNukertube
PHP Code:
/**/USE/**/[SRO_VT_SHARD]/**/
GO
/**/DECLARE @Mob VarChar(MAX)/**/
/**/DECLARE @Item VarChar(MAX)/**/
/**/DECLARE @MonsterID iNt/**/
/**/DECLARE @ItemID iNt/**/
/**/DECLARE @DropRatio ReaL/**/
--------------------------------------------------------------------------
/**/SET @Mob = 'MOB_CH_TIGERWOMAN'/*Monster Code*//**/
/**/SET @Item = 'ITEM_MALL_GLOBAL_CHATTING'/*Item Code*//**/
/**/SET @DropRatio = 0.5 /*IDK Value*/
--------------------------------------------------------------------------
/**/SET @MonsterID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Mob)/**/
/**/SET @ItemID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Item)/**/
/**/INSERT [dbo].[_RefMonster_AssignedItemDrop]/**/
/**Colums**/ (RefMonsterID,RefItemID,DropGroupType,OptLevel,DropAmountMin,DropAmountMax,DropRatio,RefMagicOptionID1,CustomValue1,RefMagicOptionID2,CustomValue2,RefMagicOptionID3,CustomValue3,RefMagicOptionID4,CustomValue4,RefMagicOptionID5,CustomValue5,RefMagicOptionID6,CustomValue6,RefMagicOptionID7,CustomValue7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9,CustomValue9,RentCodeName)/**/
/**/VALUES/**/ (@MonsterID,@ItemID,0,0,1,1,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')/**/
Dont Give me Like
sure i will not give you a like
stupid, you've copied it from other thread its already released.
Re: how to add drop items
Re: how to add drop items
yeah are you mad? okeeeey menz plzzzzz try to mke a one tut like thiiiiiiiiiiis
Re: how to add drop items
Re: how to add drop items
Rapidx3 Don't Bother ur self :) and Jiust Ignore the ppl Like Him
U give the ppl other way to do it :)
So this will help some one can't use Query :)
waiting ur next release
Quote:
do you like to put a release about add full new maps ? pvp area and event area etc ?
Re: how to add drop items
ok, now i Hate you
- 1 Like
Unliked
#Report to Close this Stupid Thread
Re: how to add drop items
i do not care of your stupid like, i don't like to get a thanks from ppl like you kid 0.0
report to close thread? wow and do you think when a kid guy report a useful thread to close it the mod will close it ? dafuq ! and go learn english please then try to talk with me and go try to say please to mods to back your account and i hope you got a bann again.
1 Attachment(s)
Re: how to add drop items
Rapidx3 ! Thx dude , u give another way to do this without query , so congratz! , btw i get this error :(
Attachment 109504
Re: how to add drop items
not bad !
keep going that cool buddy !
Re: how to add drop items
Rapidx3 Get The FUCK OUT ; ')
Re: how to add drop items
Quote:
Originally Posted by
xxNukertube
Rapidx3 GO TO FUCK OUT ; ')
english please?
Re: how to add drop items
i also
get the fuck out
Quote:
Originally Posted by
xxNukertube
This is OLD
HERE QUERY OLD
PHP Code:
/**/USE/**/[SRO_VT_SHARD]/**/
GO
/**/DECLARE @Mob VarChar(MAX)/**/
/**/DECLARE @Item VarChar(MAX)/**/
/**/DECLARE @MonsterID iNt/**/
/**/DECLARE @ItemID iNt/**/
/**/DECLARE @DropRatio ReaL/**/
--------------------------------------------------------------------------
/**/SET @Mob = 'MOB_CH_TIGERWOMAN'/*Monster Code*//**/
/**/SET @Item = 'ITEM_MALL_GLOBAL_CHATTING'/*Item Code*//**/
/**/SET @DropRatio = 0.5 /*IDK Value*/
--------------------------------------------------------------------------
/**/SET @MonsterID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Mob)/**/
/**/SET @ItemID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Item)/**/
/**/INSERT [dbo].[_RefMonster_AssignedItemDrop]/**/
/**Colums**/ (RefMonsterID,RefItemID,DropGroupType,OptLevel,DropAmountMin,DropAmountMax,DropRatio,RefMagicOptionID1,CustomValue1,RefMagicOptionID2,CustomValue2,RefMagicOptionID3,CustomValue3,RefMagicOptionID4,CustomValue4,RefMagicOptionID5,CustomValue5,RefMagicOptionID6,CustomValue6,RefMagicOptionID7,CustomValue7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9,CustomValue9,RentCodeName)/**/
/**/VALUES/**/ (@MonsterID,@ItemID,0,0,1,1,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')/**/
CREDITS TO
Hean and me For Edit
Nice Query
