how to remove the drop of a certain ID and then add a new id?:confused:
remove the drop
11/06/2011 12:28
rastamannns#1
11/06/2011 15:43
ismokedrow#2
DropGroupResource ^^
11/06/2011 16:18
rastamannns#3
Well, this is understandable but as I say that is necessary to remove 305 501 id like to do it I can not understand
11/07/2011 00:51
Raskim2000#4
Than u shouldŽnt run a Pserver.Quote:
Well, this is understandable but as I say that is necessary to remove 305 501 id like to do it I can not understand
11/07/2011 05:00
rastamannns#5
-------------------------------------------------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
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