[che_9299]

-- 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%'