10-10-2017, 11:05 AM
|
#3
|
|
|
• الانـتـسـاب » Mar 2015
|
|
• رقـم العـضـويـة » 121247
|
|
• المشـــاركـات » 3,301
|
|
• الـدولـة » مصر
|
|
• الـهـوايـة » ذكر الله ~ لا اله الا الله ~
|
|
• اسـم الـسـيـرفـر » No Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 98
|
|
|
|
.gif)
رد: طلب بخصوص الدروب وال rate
DropAmountMin=ده اد ايه حينزل دروب
DropAmountMax=و ده الكميه
|
|
|
-- 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%'
|
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%'
|
|
|
|
|