ToOoOoT
14-05-2014, 10:56 PM
عايز اخلي الموبس ال 109 اللي شكل البينون تنزل ارينا يعني احطلها دروب جديد اعمل اية ؟
pop2009
15-05-2014, 12:50 AM
Query add new Drop to mobs
GO
DECLARE @Mob VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT
--------------------------------------------------------------------------
SET @Mob = 'MOB_SD_ISIS'/*Monster Code*/
SET @Item = 'ITEM_ETC_SD_TOKEN_04'/*Item Code*/
SET @DropAmountMin = 3 /*Drop Min*/
SET @DropAmountMax = 3 /*Drop Max*/
SET @DropRatio = 1 /*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,Dro pAmountMin,DropAmountMax,DropRatio,RefMagicOptionI D1,CustomValue1,RefMagicOptionID2,CustomValue2,Ref MagicOptionID3,CustomValue3,RefMagicOptionID4,Cust omValue4,RefMagicOptionID5,CustomValue5,RefMagicOp tionID6,CustomValue6,RefMagicOptionID7,CustomValue 7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9 ,CustomValue9,RentCodeName)/**/
VALUES(@MonsterID,@ItemID,0,0,@DropAmountMin,@Drop AmountMax,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,'xxx')/**/
To Get ID Mobs: use this Query
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC
to Get ID of Item From this Query:
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'ITEM_CH_TBLADE_11_SET_A_RARE
pop2009
15-05-2014, 12:55 AM
بس انصحك تضيف دول فى _RefMonster_AssignedItemDrop
ده متظبطين دروب ارينا من كل الموبس الى فى اليكس
43994 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38197 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38198 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38199 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38200 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38201 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38202 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38203 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38204 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38205 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38206 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38207 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38208 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38209 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38210 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38211 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38212 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38213 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38214 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38215 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38216 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38217 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38218 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38219 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38220 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38221 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38222 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38223 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38224 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38225 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38226 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38227 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38228 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38229 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38230 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38231 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38232 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38233 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38234 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38235 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38236 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38237 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38238 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38239 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38240 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38241 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38242 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38243 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38244 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38245 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38246 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38247 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38248 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38249 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38250 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38251 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38252 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38253 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38254 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38255 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38256 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38257 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38258 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38259 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38260 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38261 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38262 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
24285 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
26667 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
7557 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
3810 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
7559 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
7562 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
7560 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
7558 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
23308 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38196 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
7564 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
7562 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38148 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
41417 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38149 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38150 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
24157 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38151 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38152 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38153 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38154 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38155 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38156 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38157 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38158 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38159 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38160 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38161 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38162 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38163 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38164 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38165 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38166 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38167 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38168 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38169 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38170 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38171 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38172 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38173 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38174 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38175 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38176 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38177 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38178 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38179 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38180 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38181 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38182 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38183 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38184 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38185 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38186 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38187 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38188 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38189 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38190 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38191 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38192 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38193 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38194 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38195 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
38196 25834 0 0 1 1 0.15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx
pop2009
15-05-2014, 12:56 AM
شايف 0.15 ده نسبه ال Drop شوف انت عايز النسبه قد ايه و شايف
1 وى 1 الى قبل 0.15 ده minimam and maxmam بتاع Drop شوف انت عايز تعملو كام :)
ToOoOoT
15-05-2014, 01:07 AM
طيب ياباشا الاكواد التانية دي فيها الموبس ال109 بتاعت desert of alex?
ToOoOoT
15-05-2014, 01:10 AM
طيب ياباشا تسلم ايديك و 0.15 النسبة دي حلوة؟
pop2009
15-05-2014, 01:11 AM
هى كويسه مش صعبه اوى ولا سهله اوى
بس اتعامل بة Query و اعمل كل حاجة بنفسك عشان لو فى مشكلة تعرف من اية
pop2009
15-05-2014, 01:26 AM
بس اتعامل بة Query و اعمل كل حاجة بنفسك عشان لو فى مشكلة تعرف من اية
طريقه الاكواد ده احسن و اسهل من الكويرى !!
ToOoOoT
15-05-2014, 01:38 AM
ياباشا شوف بيجيبلي اية لما باجي احطهم!
http://im76.gulfup.com/zKV10r.jpg
ToOoOoT
15-05-2014, 01:41 AM
لو ممكن بس ياباشا تجيبلي ايدي الموبس ال109 اللي شبة البينون يبقى شكرا
انا عايز الموبس دي بس!
ToOoOoT
15-05-2014, 01:46 AM
طيب عايز بس Code Mobs Akeru 109 وانا هستعمل الكويري وهجيب الايدي!
che_9299
15-05-2014, 09:52 AM
ياباشا كل الاكواد اللى بتطلبها دى هتلاقياه فى ملف اسمه Textdata_Object
دور على الاسم اللى عايزو وهتلاقى قدامو الكود
وبالنسبه لل ID
بعد ما بتجيب ال Code بتروح ضارب الكويرى ده وبس
Select ID From _RefObjCommon Where Codename128 Like 'Here'
##