How to add a thing to the monster?

[Dadada23da]

I would add a monster drop, but do not know how to find the monster, how to add, there is a demand, but through an error in SQL. help)
I know my English is at the level of "OK Google"

Запрос

 Spoiler

Update [Arcadia].[dbo].[MonsterResource]
Set [drop_item_id_00] = 700401
,[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] = 700401
,[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] = 700401
,[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] = 700401
,[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] = 700401
,[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] = 700401
,[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] = 700401
,[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] = 700401
,[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] = 700401
,[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] = 700401
,[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 = 801
Go

Ошибка

 Spoiler

Post 207, Level 16, State 1, Line 1
Invalid column name "drop_item_id_00".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_percentage_00".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_count_00".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_count_00".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_level_00".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_level_00".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_item_id_01".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_percentage_01".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_count_01".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_count_01".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_level_01".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_level_01".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_item_id_02".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_percentage_02".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_count_02".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_count_02".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_level_02".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_level_02".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_item_id_03".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_percentage_03".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_count_03".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_count_03".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_level_03".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_level_03".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_item_id_04".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_percentage_04".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_count_04".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_count_04".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_level_04".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_level_04".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_item_id_05".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_percentage_05".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_count_05".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_count_05".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_level_05".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_level_05".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_item_id_06".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_percentage_06".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_count_06".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_count_06".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_level_06".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_level_06".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_item_id_07".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_percentage_07".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_count_07".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_count_07".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_level_07".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_level_07".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_item_id_08".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_percentage_08".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_min_count_08".
Post 207, Level 16, State 1, Line 1
Invalid column name "drop_max_count_08".
Post 207, Level 16, State 1, Line 1
Invalid name a hundred

If there is a theme, I'm sorry, I have not found.
If there is a base of 7.3 share please, at me from the Infiniti 7.3, it is a problem with errors.

[ThunderNikk]

None of those table columns are in monster resource

That is your issue, you are attempting to edit a drop group resource in the wrong table.

[Dadada23da]

Originally Posted by thndr

None of those table columns are in monster resource

That is your issue, you are attempting to edit a drop group resource in the wrong table.

And where to? =) I'm not good at this. In MonsterDropTableResource? help))

[ThunderNikk]

There is no 801 ID in dbo.MonsterDropTableResource so you can not update it until it is created.

You can not create it with that script because not all of the columns are named

If it does not exist now then no monster will be linked to drop the items anyway because they will need to be attached to that table entry in order for it to work.

Maybe if you are not good at editing the server then it is possible that you just should not edit it.

Besides skill cubes already drop from monsters.

[Dadada23da]

Originally Posted by thndr

There is no 801 ID in dbo.MonsterDropTableResource so you can not update it until it is created.

You can not create it with that script because not all of the columns are named

If it does not exist now then no monster will be linked to drop the items anyway because they will need to be attached to that table entry in order for it to work.

Maybe if you are not good at editing the server then it is possible that you just should not edit it.

Besides skill cubes already drop from monsters.

Thank you understand. Yes you are right, it is not present in the database, this mannequin ID =)
801 - this Eid maniikena 190 lvl, but in the database drop it no)
But with everything else already knew, thanks.

[fumble2010]

okay let me try help u and try to explain it a bit so i hope u can do it on ur own.

First: This "MonsterDropTableResource" is for creating the "droplist" for ur monster .... like this

INSERT INTO Arcadia.dbo.MonsterDropTableResource VALUES ('99600','1','99700','1.00000000','1','1','1','1', '0','0.00000000','0','0','0','0','0','0.00000000', '0','0','0','0','0','0.00000000','0','0','0','0',' 0','0.00000000','0','0','0','0','0','0.00000000',' 0','0','0','0','0','0.00000000','0','0','0','0','0 ','0.00000000','0','0','0','0','0','0.00000000','0 ','0','0','0','0','0.00000000','0','0','0','0')

Legend:
99600 = number u want for ur "droplist" and 99700 = Item that should drop .... 1.00000000 = drop chance 100% ... 1 1 1 1 = Count of that item that should drop

IMPORTANT NOTE all the 0.0000000 numbers, if u add them together u need to get at the end 1.00000000 number !

Second: you need to ad that "droplist" to ur monster by this command

UPDATE Arcadia.dbo.MonsterResource set
drop_table_link_id = 99600
where id IN (insert monster id here)

i hope it helps you out and u get an idea of how it works.

[Dadada23da]

Originally Posted by fumble2010

okay let me try help u and try to explain it a bit so i hope u can do it on ur own.

First: This "MonsterDropTableResource" is for creating the "droplist" for ur monster .... like this

INSERT INTO Arcadia.dbo.MonsterDropTableResource VALUES ('99600','1','99700','1.00000000','1','1','1','1', '0','0.00000000','0','0','0','0','0','0.00000000', '0','0','0','0','0','0.00000000','0','0','0','0',' 0','0.00000000','0','0','0','0','0','0.00000000',' 0','0','0','0','0','0.00000000','0','0','0','0','0 ','0.00000000','0','0','0','0','0','0.00000000','0 ','0','0','0','0','0.00000000','0','0','0','0')

Legend:
99600 = number u want for ur "droplist" and 99700 = Item that should drop .... 1.00000000 = drop chance 100% ... 1 1 1 1 = Count of that item that should drop

IMPORTANT NOTE all the 0.0000000 numbers, if u add them together u need to get at the end 1.00000000 number !

Second: you need to ad that "droplist" to ur monster by this command

UPDATE Arcadia.dbo.MonsterResource set
drop_table_link_id = 99600
where id IN (insert monster id here)

i hope it helps you out and u get an idea of how it works.

I myself have already figured out a little bit, and even added a few things. But your explanation has helped me more, thank you for your help.=) I hope you understand me. (Due to my bad english)

[TheOnlyOneRaskim]

Originally Posted by fumble2010

okay let me try help u and try to explain it a bit so i hope u can do it on ur own.

First: This "MonsterDropTableResource" is for creating the "droplist" for ur monster .... like this

INSERT INTO Arcadia.dbo.MonsterDropTableResource VALUES ('99600','1','99700','1.00000000','1','1','1','1', '0','0.00000000','0','0','0','0','0','0.00000000', '0','0','0','0','0','0.00000000','0','0','0','0',' 0','0.00000000','0','0','0','0','0','0.00000000',' 0','0','0','0','0','0.00000000','0','0','0','0','0 ','0.00000000','0','0','0','0','0','0.00000000','0 ','0','0','0','0','0.00000000','0','0','0','0')

Legend:
99600 = number u want for ur "droplist" and 99700 = Item that should drop .... 1.00000000 = drop chance 100% ... 1 1 1 1 = Count of that item that should drop

IMPORTANT NOTE all the 0.0000000 numbers, if u add them together u need to get at the end 1.00000000 number !

Second: you need to ad that "droplist" to ur monster by this command

UPDATE Arcadia.dbo.MonsterResource set
drop_table_link_id = 99600
where id IN (insert monster id here)

i hope it helps you out and u get an idea of how it works.

Just a Lil correction Here.

In MonsterDropTableResource every drop_percentage can go up to 1 (100%)

In DropGroupResource the ADDITION of each drop_percentage has to be 1. Allways.

[fumble2010]

oh right Raskim i messed it up a bit ^^ just learning here too , thanks.