How to remove 10 DG İtems drop ??

10/26/2011 21:16 buriko_0007#1

How can I change and what tables.

10/28/2011 14:52 buriko_0007#2

Please help ;

Please help i need disable 10 dg all items...

I make _RefObjCommon in Service 1 to 0 => Game Server Error ;

this item is to drop but can`t find in _RefObjCommon,check it out its existance or service on/off [RefID:xxx]

09/18/2014 01:35 asanoftw#3

1- Search for Dg10 items

Code:

select * from _RefObjCommon where CodeName128 like 'ITEM_%_10_%_RARE'

Copy ID for using "BETWEEN"

2 - Delete Items D10 for Drops

Code:

delete from _RefMonster_AssignedItemDrop where RefItemID between 4041 and 5735

09/18/2014 05:07 Exo#4

Ofc it gave an error you cant just set service to 0 when its used somewhere else

Quote:
Originally Posted by asanoftw
1- Search for Dg10 items
Code:
select * from _RefObjCommon where CodeName128 like 'ITEM_%_10_%_RARE'
Copy ID for using "BETWEEN"

2 - Delete Items D10 for Drops
Code:
delete from _RefMonster_AssignedItemDrop where RefItemID between 4041 and 5735

This will disable too much shit

09/24/2014 02:10 ipause#5

_RefObjCommon set service to 0

09/28/2014 06:33 spinal2#6

To Simple .

Execute Querys in ordem ..

In my case, iam Disable Novas EU D11 and automatic drops Chance for Star D10 on mobs 104++

Code:

FIRST DISABLE IN DB

Use SRO_VT_SHARD
UPDATE _RefObjCommon
Set Service = 0
WHERE CodeName128 like '%ITEM_%_%_10_%'  


THEN DISABLE FROM NPCs

Use SRO_VT_SHARD
UPDATE _RefPackageItem
Set Service = 0
WHERE CodeName128 like '%ITEM_%_%_10_%'  




Use SRO_VT_SHARD
UPDATE _RefPricePolicyOfItem
Set Service = 0
WHERE RefPackageitemCodeName like '%ITEM_%_%_10_%'  




Use SRO_VT_SHARD
UPDATE _RefScrapOfPackageItem
Set Service = 0
WHERE RefPackageitemCodeName like '%ITEM_%_%_10_%' 


Use SRO_VT_SHARD
UPDATE _RefShopGoods
Set Service = 0
WHERE CodeName128 like '%ITEM_%_%_10_%'

09/29/2014 21:13 Zodiao#7

PHP Code:


			
Update _RefDropItemAssign
set service='0'
where RefItemID in(Select ID From _RefobjCommon where codename128 like 'ITEM_%10%')

Or you know, you can always disable it from _RefDropClassSel_Equip?
Set ProbX
where MonLevel > 100?