[che_9299]

ا - روح على
SRO_VT_SHARD
Tables
_RefRegionBindAssocServer

CHINA	= Jangan
TQ	= Qin-Shi Tomb (Jangan Cave)
West_China	= Downhang
Oasis_Kingdom	= Hotan
Thief Village	= Thief town
Roc	= Roc Mountain
Eu	= Constantinople
Am	= Asia Minor (Captain Ivy)
Ca	= Central Asia (Samarkand)
SD	= DESERT OF ALEX
KingsValley	= ALEX DOWN
Pharaoh= HOLY TEMPLE
DELTA	= ALEXANDRIA TOWN
TEMPLE	= JOB CAVE ALEXANDRIA
FORT_JA_AREA	= Jangan FW
FORT_DW_AREA	= Donwhang FW
FORT_HT_AREA	= Hotan FW
FORT_CT_AREA = Constantiple FW
FORT_SK_AREA = Samarkand FW 
FORT_BJ_AREA	= Bandit FW
FORT_HM_AREA	= -
FORT_ER_AREA	= -
ARENA_OCCUPY	= -
ARENA_FLAG	= Arena Flag
ARENA_SCORE	= Arena Score
SIEGE_DUNGEON	= Capture the Flag
ARENA_GNGWC	= Arena GNGWC
GOD_TOGUI	= Forgotten World
GOD_WRECK_IN	= Forgotten World
GOD_FLAME	= Forgotten World
GOD_WRECK_OUT	= Forgotten World
EVENT_GHOST	= Forgotten World
JUPITER	= Jupiter Temple 120 mob
PRISON = Prison
GM_EVENT = GM Map

المنطقه اللى عايز تفتحها اكتب قدامها 1 واللى عايز تقفلها اكتب قدامها 0


2 - ده كويرى يحطلك Drop ليونيك او موبس معين

 USE SRO_VT_SHARD 
GO

DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real



SET @MonsterID = 47618 -------- Mob,Unique ID you want Add Drop in
SET @DropRatio = 0.7 -------- Item drop rate 1=100% , 0.3 = 30% 
SET @ItemID = 24667 -------- ITEM ID You want Add in Drops


INSERT _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, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')