How to add a thing to the monster?

01/19/2017 21:24 Dadada23da#1
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"

Запрос

Ошибка


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.
01/19/2017 22:05 ThunderNikk#2
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.
01/19/2017 22:11 Dadada23da#3
Quote:
Originally Posted by thndr View Post
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:)))
01/19/2017 23:37 ThunderNikk#4
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.
01/20/2017 00:13 Dadada23da#5
Quote:
Originally Posted by thndr View Post
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.
01/20/2017 01:32 fumble2010#6
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.
01/20/2017 02:49 Dadada23da#7
Quote:
Originally Posted by fumble2010 View Post
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):D
01/20/2017 14:03 TheOnlyOneRaskim#8
Quote:
Originally Posted by fumble2010 View Post
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.
01/21/2017 16:01 fumble2010#9
oh right Raskim i messed it up a bit ^^ just learning here too , thanks.