Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 21:24

  • Please register to post and access all features, it's quick, easy and FREE!

 

How to add a thing to the monster?

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2017
Posts: 9
Received Thanks: 0
Exclamation How to add a thing to the monster?

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.



Dadada23da is offline  
Old   #2
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,042
Received Thanks: 977
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.


ThunderNikk is offline  
Old   #3
 
elite*gold: 0
Join Date: Jan 2017
Posts: 9
Received Thanks: 0
Exclamation

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))
Dadada23da is offline  
Old   #4
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,042
Received Thanks: 977
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.


ThunderNikk is offline  
Old   #5
 
elite*gold: 0
Join Date: Jan 2017
Posts: 9
Received Thanks: 0
Exclamation

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.
Dadada23da is offline  
Old   #6
 
elite*gold: 0
Join Date: Dec 2009
Posts: 62
Received Thanks: 8
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.
fumble2010 is offline  
Old   #7
 
elite*gold: 0
Join Date: Jan 2017
Posts: 9
Received Thanks: 0
Smile

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)
Dadada23da is offline  
Old   #8
 
elite*gold: 0
Join Date: Nov 2011
Posts: 980
Received Thanks: 1,007
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.
TheOnlyOneRaskim is offline  
Old   #9
 
elite*gold: 0
Join Date: Dec 2009
Posts: 62
Received Thanks: 8
oh right Raskim i messed it up a bit ^^ just learning here too , thanks.


fumble2010 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Is vouching a good thing or a bad thing ?
Hey guys, not sure If i'm in the right section, hope the mods will take care of that ;) I was just wondering, sure vouching is necessary to prove...
2 Replies - League of Legends Main - Discussions / Questions
[Buddy Thing] Bones thing
Uhm, ssry creating a thread only for that, but ma buddy is 80 and i really have to move ma balls and take the rewards. Uhmm i'm blocked at the...
17 Replies - Archlord



All times are GMT +2. The time now is 21:24.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.