Regarding items drop - removed but still dropping

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?

Quote:

---

Originally Posted by serend

_RefObjCommon set their service to 0 and did you restart game server after removing them ?

---

I don't want to disable it completely, only the drops

Quote:

---

Originally Posted by lemoniscool

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?

---

yes I restarted it and I rechecked again, example for the tablets, _RefDropClassSel_Alchemy_Tablet, ProbGroup1 till ProbGroup12 is set to 0 but tablets still drop

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:

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') 


---

after that restart the gameserver and shardmanager, that should do the trick at least for monsters level 1~120 dropping tablets ^^

_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 ..