I removed all the drops from _RefMonsterAssignItemDrop and _RefDropClassSel_Equip/_RefDropClassSel_Alchemy_MagicStone/_RefDropClassSel_Alchemy_Tablet but mobs are still dropping items and tablets, is there other tables need to be modified?
Thanks
Printable View
I removed all the drops from _RefMonsterAssignItemDrop and _RefDropClassSel_Equip/_RefDropClassSel_Alchemy_MagicStone/_RefDropClassSel_Alchemy_Tablet but mobs are still dropping items and tablets, is there other tables need to be modified?
Thanks
_RefObjCommon set their service to 0 and did you restart game server after removing them ?
setting their service to 0 disables them completely, which means they cant be used at all ingame (even not by gm when spawned via console) normally what he did is enough to disable alchemy drops, tablets and magic stones
again the question, did you restart your server?
i did the same a long time ago, and on my server there are no tablet drops anymore since then.. setting all values to 0 disables the drop
maybe you changed it in a backup table or sth like that be sure to write "USE SRO_VT_SHARD" before your query, in case you used a query
if you dont, it might be possible that you change values in a backup table inside the master database, i had this problem when i started too
in case you didnt use a query, try using this one:
after that restart the gameserver and shardmanager, that should do the trick at least for monsters level 1~120 dropping tablets ^^PHP Code:USE SRO_VT_SHARD
UPDATE _RefDropClassSel_Alchemy_Tablet
SET ProbGroup1 = 0, ProbGroup2 = 0, ProbGroup3 = 0, ProbGroup4 = 0, ProbGroup5 = 0, ProbGroup6 = 0, ProbGroup7 = 0, ProbGroup8 = 0, ProbGroup9 = 0,
ProbGroup10 = 0, ProbGroup11 = 0, ProbGroup12 = 0
WHERE (MonLevel BETWEEN '1' AND '120')
_RefDropItemAssign
PHP Code:/* Query to disable/enable Item to drop */
declare @codename varchar (30)
set @codename = '%TABLET%12%'
update _REFDROPITEMASSIGN set Service = 0
where exists(select * from _REFOBJCOMMON where codename128 like @codename and id = _REFDROPITEMASSIGN.refitemid and service = 1)
select * from _REFDROPITEMASSIGN where exists(select * from _REFOBJCOMMON where codename128 like @codename and id = _REFDROPITEMASSIGN.refitemid)
sounds logic Statiic, but for me executing my query was enough to disable tablet drop ..