remove the drop

[rastamannns]

how to remove the drop of a certain ID and then add a new id?

[ismokedrow]

DropGroupResource ^^

[rastamannns]

Well, this is understandable but as I say that is necessary to remove 305 501 id like to do it I can not understand

[Raskim2000]

Originally Posted by rastamannns

Well, this is understandable but as I say that is necessary to remove 305 501 id like to do it I can not understand

Than u should´nt run a Pserver.

[rastamannns]

-------------------------------------------------1
update Arcadia_1 . dbo . DropGroupResource
set [drop_percentage_00] = 0
where[drop_item_id_00] = 305501
----------------------------------------------2

update Arcadia_1 . dbo . DropGroupResource
set [drop_percentage_01] = 0
where [drop_item_id_01] = 305501
---------------------------------------------3
update Arcadia_1 . dbo . DropGroupResource
set [drop_percentage_02] = 0
where [drop_item_id_02] = 305501
---------------------------------------------4
update Arcadia_1 . dbo . DropGroupResource
set
[drop_percentage_03] = 0
where [drop_item_id_03] = 305501
-------------------------------------------5
update Arcadia_1 . dbo . DropGroupResource
set [drop_percentage_04] = 0
where [drop_item_id_04] = 305501
-----------------------------------------6
update Arcadia_1 . dbo . DropGroupResource
set [drop_percentage_05] = 0
where [drop_item_id_05] = 305501
-----------------------------------------7
update Arcadia_1 . dbo . DropGroupResource
set [drop_percentage_06] = 0
where [drop_item_id_06] = 305501
-----------------------------------------8
update Arcadia_1 . dbo . DropGroupResource
set [drop_percentage_07] = 0
where [drop_item_id_07] = 305501

-----------------------------------------9
update Arcadia_1 . dbo . DropGroupResource
set [drop_percentage_08] = 0
where [drop_item_id_08] = 305501
-----------------------------------------------10
update Arcadia_1 . dbo . DropGroupResource
set
[drop_percentage_09] = 0
where [drop_item_id_09] = 305501