Update [Arcadia].[dbo].[MonsterResource]
Set [drop_item_id_00] = id вещи
,[drop_percentage_00] = 1.0000000
,[drop_min_count_00] = 1
,[drop_max_count_00] = 1
,[drop_min_level_00] = 1
,[drop_max_level_00] = 1
,[drop_item_id_01] = id вещи
,[drop_percentage_01] = 1.0000000
,[drop_min_count_01] = 1
,[drop_max_count_01] = 1
,[drop_min_level_01] = 1
,[drop_max_level_01] = 1
,[drop_item_id_02] = id вещи
,[drop_percentage_02] = 1.0000000
,[drop_min_count_02] = 1
,[drop_max_count_02] = 1
,[drop_min_level_02] = 1
,[drop_max_level_02] = 1
,[drop_item_id_03] = id вещи
,[drop_percentage_03] = 1.0000000
,[drop_min_count_03] = 1
,[drop_max_count_03] = 1
,[drop_min_level_03] = 1
,[drop_max_level_03] = 1
,[drop_item_id_04] = id вещи
,[drop_percentage_04] = 1.0000000
,[drop_min_count_04] = 1
,[drop_max_count_04] = 1
,[drop_min_level_04] = 1
,[drop_max_level_04] = 1
,[drop_item_id_05] = id вещи
,[drop_percentage_05] = 1.0000000
,[drop_min_count_05] = 1
,[drop_max_count_05] = 1
,[drop_min_level_05] = 1
,[drop_max_level_05] = 1
,[drop_item_id_06] = id вещи
,[drop_percentage_06] = 1.0000000
,[drop_min_count_06] = 1
,[drop_max_count_06] = 1
,[drop_min_level_06] = 1
,[drop_max_level_06] = 1
,[drop_item_id_07] = id вещи
,[drop_percentage_07] = 1.0000000
,[drop_min_count_07] = 1
,[drop_max_count_07] = 1
,[drop_min_level_07] = 1
,[drop_max_level_07] = 1
,[drop_item_id_08] = id вещи
,[drop_percentage_08] = 1.0000000
,[drop_min_count_08] = 1
,[drop_max_count_08] = 1
,[drop_min_level_08] = 1
,[drop_max_level_08] = 1
,[drop_item_id_09] = id вещи
,[drop_percentage_09] = 1.0000000
,[drop_min_count_09] = 1
,[drop_max_count_09] = 1
,[drop_min_level_09] = 1
,[drop_max_level_09] = 1
Where id = тут ид моба в которого хотите добавить
Go

Учтите с помощью этого запроса можно добавить только 9 вещей в монстра. Если вам необходимо добавить больше 9 вещей, то для начала нужно создать групу вещей в таблице DropGroupResourse. Id всех груп начинаються с знака "-". В каждую групу можно добавить по 9 вещей. Добавление вещей в групу происходит по такому же принципу как и в монстра.
Запрос на создание групы

Insert Into [Arcadia].[dbo].[DropGroupResource]
([id]
,[drop_item_id_00]
,[drop_percentage_00]
,[drop_min_count_00]
,[drop_max_count_00]
,[drop_item_id_01]
,[drop_percentage_01]
,[drop_min_count_01]
,[drop_max_count_01]
,[drop_item_id_02]
,[drop_percentage_02]
,[drop_min_count_02]
,[drop_max_count_02]
,[drop_item_id_03]
,[drop_percentage_03]
,[drop_min_count_03]
,[drop_max_count_03]
,[drop_item_id_04]
,[drop_percentage_04]
,[drop_min_count_04]
,[drop_max_count_04]
,[drop_item_id_05]
,[drop_percentage_05]
,[drop_min_count_05]
,[drop_max_count_05]
,[drop_item_id_06]
,[drop_percentage_06]
,[drop_min_count_06]
,[drop_max_count_06]
,[drop_item_id_07]
,[drop_percentage_07]
,[drop_min_count_07]
,[drop_max_count_07]
,[drop_item_id_08]
,[drop_percentage_08]
,[drop_min_count_08]
,[drop_max_count_08]
,[drop_item_id_09]
,[drop_percentage_09]
,[drop_min_count_09]
,[drop_max_count_09] )
Values
(ид групы
,ид вещи
,1.00000000
,1
,1
,ид вещи
,1.00000000
,1
,1
,ид вещи
,1.00000000
,1
,1
,ид вещи
,1.00000000
,1
,1
,ид вещи
,1.00000000
,1
,1
,ид вещи
,1.00000000
,1
,1
,ид вещи
,1.00000000
,1
,1
,ид вещи
,1.00000000
,1
,1
,ид вещи
,1.00000000
,1
,1)
Go

Подставте только свои значения

Если вы создали групу и хотите добавить ее в дроп к монстру то вместо ид вещи нужно написать ид нужной вам групы незабыв про знак "-".