[ღ♥Alexandria♥ღ]

الان عله سيلك رود [VSRO] Coin Drop Amount & Rate [QUERY] مجرب 100%

ده كيور جديد و انا اشتغل بي 100%

-- Coin DropAmount Query mneam001 -- 

-- Copper Coin--
UPDATE dbo._RefMonster_AssignedItemRndDrop 
Set DropAmountMin='1', DropAmountMax='5' 
WHERE ItemGroupCodeName128 like '%SD_TOKEN1%'

-- Gold Coin --
UPDATE dbo._RefMonster_AssignedItemRndDrop 
Set DropAmountMin='1', DropAmountMax='5' 
WHERE ItemGroupCodeName128 like '%SD_TOKEN4%'

-- Silver Coin --
UPDATE dbo._RefMonster_AssignedItemRndDrop 
Set DropAmountMin='1', DropAmountMax='5' 
WHERE ItemGroupCodeName128 like '%SD_TOKEN3%'

-- Iron Coin --
UPDATE dbo._RefMonster_AssignedItemRndDrop 
Set DropAmountMin='1', DropAmountMax='5' 
WHERE ItemGroupCodeName128 like '%SD_TOKEN2%'

DropAmountMin=ده اد ايه حينزل دروب
DropAmountMax=و ده الكميه


Other New Query.

Coin Drop Rate.

-- Coin DropRate Query By mneam001 -- 

-- Copper Coin--
UPDATE dbo._RefMonster_AssignedItemRndDrop 
Set DropRatio='1' -- 1= %100, 0,1 = %10, 0,5 = %50
WHERE ItemGroupCodeName128 like '%SD_TOKEN1%'

-- Gold Coin --
UPDATE dbo._RefMonster_AssignedItemRndDrop 
Set DropRatio='1' -- 1= %100, 0,1 = %10, 0,5 = %50
WHERE ItemGroupCodeName128 like '%SD_TOKEN4%'

-- Silver Coin --
UPDATE dbo._RefMonster_AssignedItemRndDrop 
Set DropRatio='1' -- 1= %100, 0,1 = %10, 0,5 = %50
WHERE ItemGroupCodeName128 like '%SD_TOKEN3%'

-- Iron Coin --
UPDATE dbo._RefMonster_AssignedItemRndDrop 
Set DropRatio='1' -- 1= %100, 0,1 = %10, 0,5 = %50
WHERE ItemGroupCodeName128 like '%SD_TOKEN2%'  

مع تحياتي mneam001 :)