Titan Bug

[Yousef Ayyoub]

try to restore u database .. ... remove everything u have done ..


-- incase u want to add the drop again

the query to get the item id

Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

the query to add the drop

USE SRO_VT_SHARD -----> By-Flowushy <----- GO DECLARE @MonsterID int DECLARE @ItemID int DECLARE @DropRatio real SET @MonsterID = 23308 -------- Mob,Unique ID you want Add Drop in SET @DropRatio = 1 -------- Item drop rate 1=100% , 0.3 = 30%  SET @ItemID = 24668 -------- 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')

make sure do not add the drop twice .. and everything is gonna work fine