lots of questions

[TheDarkKnight]

hello,

maybe you saw my previews posts.. i got many answers from you guys so far, thanks for that.

now i nearly implemented all features to my free drop calc.. but still i have a lot of questions.. i hope some people can answer them. thank you.

1) where can i find the armorset bonus information related to the armorset table?
2) where can i find out how much AA it takes to unseal a certain item? (i hoped for merchant_buylists.sql but no mammons there)
3) where can i find quest list (name/lvl/loc/descriptions/reward/..) ?
4) where can i find descriptions for items? (example: weapons, misc items, ..)
5) where can i find NPC skill information? (like HP 4x / undead / full reisist anti magic etc..)
6) where can i find fish information example: http://l2jdb.l2jdp.com/db_fish.php?id=6411

thats it so far, i hope not all answers are "its inside the client".. if that is the case then my question:

1) can someone fetch these information and send them to me in SQL format OR XML?
2) if not, can someone explain me how to fetch it from the client with l2encdec or in another way

thanks a lot! looking forward for many answers. thanks.

[Zoey76]

1) sql/server/armorsets.sql
2) data/multisell/

• 311262504.xml
• 311262505.xml
• 311262506.xml
• 311262507.xml
• 311262508.xml

3)This information is in client, we cannot discuss this here.
4)This information is in client, we cannot discuss this here.
5) sql/server/npcskills.sql
6) sql/server/fish.sql

1*) Depends on what you need I could help you.
2*) No, no-one here can help you with that stuff.

[TheDarkKnight]

thank you zoey! very very helpful!

1) are you sure? i cant find the info there can you tell me which column it is?
2) PERFECT!!! thanks a lot.
3 + 4) okay i understand, but why no one want to talk about that? is it illegal? i mean if its illegal then i dont want this.. but can someone tell me what is the big secret about it?
5) OHHHHH THANKS!! how could i miss that.. i was browsing through the sql files a thousand times
6) are you sure? i cant find the info about the resulting "drop/item" there, can you tell me which column it is?

====

1*) what i need hmm..
a) a sql file with 4 colums (id (unique) / type (npc or item) / item/npc ID / description text
b) 2 sql files:
- quest.sql: with 6 colums (questid / quest name / start npc ID / restriction / level range / repeatable)
- quest_step.sql: with 4 colums ( questid / stepnumber / step name / step description)

2*) ok i understand

[Zoey76]

1) Yes I'm sure, check the column skill, you will see there a skill-level list, then you need to get the stats from the skill.
6) You need to check:

• Items from 6411 to 6518 and items from 8403 to 8483 has the skills.
• Skills from 2190 to 2207 and skills from 2261 to 2269 has the rewards.

3/4) This data is inside the game client files, and it's encrypted, talking about how to read this data is illegal and not allowed in this forum boards nor IRC Channels.

1*) You need to specify what chronicle are you working with, I only work with High Five at this point, but I could make it for Freya anyway, just let me know. About the Ids I think best way is to use item id, since it's unique for each item, same for npc Ids and quest Ids.

Moved to viewforum.php?f=94

By the way would be nice if you share it, at least a feature-limited version for people that can make its own.

[TheDarkKnight]

yes, i will share it ofc.. parts of my code i putted into another topic already.
i will put the link once its done and if someone need PHP information or SQL infos everyone can feel free to ask me via the portal link then. NP. but i wont put everything here coz its no use for other ppl since it is implemented in a CMS (eZ Publish) and im sure no one uses that. so its kinda speficic.

well

1) alright, i see for example: "3006-1;3516-1" but where can i find the skill for the ID (its not in npcskills) and what does the -1 stand for?

6) phew.. will take me a while i guess.. i must consider first if its worth it to fetch all these infos xD

Im working with a cronjob which reads l2j SVN so that means every night i update the database, that means i need the information from High Five i guess, thanks. about the ids you are right, but for the description i would want to make one seperate "description table".. in that will be description from items AND npcs mixed.. to avoid having problems with dublicate public keys i'd like to use a index (autoinc) which has no sense but counting higher.

so again, for the description.sql:
ID (unique)
Type (NPC / ITEM / SKILL)
L2 ID (ID of the Item oder NPC)
Description Text (the description text xD)

quest.sql:
questid (unique l2 ID)
quest name
start npc ID
restriction
level range
repeatable (true / false)

quest_step.sql:
questid (unique l2 ID)
stepnumber
step name
step description

[Zoey76]

1) Yes I'm sure, check the column skill, you will see there a skill-level list, then you need to get the stats from the skill.

This means xxxx-y equals skill Id xxxx and level y.

[TheDarkKnight]

i understood now.. you were talking about the skill xml's i got it now.. starting to fetch infos from xml to sql now, thanks! (i just edited the info for description.sql, i need the type "skill" too)

[TheDarkKnight]

another question.. the multisell XML files include information about items but where is the connection to the shop/NPC where that "trade" is possible?

[Zoey76]

another question.. the multisell XML files include information about items but where is the connection to the shop/NPC where that "trade" is possible?

Done in html bypasses, you can get more information about where is used in data/multisell/readme.txt

[TheDarkKnight]

alright,

i saw these information already. but unfortunatly there is no use for them in my case.
i might check out the HTML files but i doubt that i will be able to read out the information so that i could connect the multisell information with NPC Ids.. (would have been nice tho^^)

thanks for that so far.

[TheDarkKnight]

hi all,

i implemented 4 of the 6 things so far.. thanks for the feedback again.
waiting status for the other 2 points.

now i have a couple of questions again. would be nice if someone can answer them.

1) where can i find which mob drops which questitem?
2) where can i find the information for normal blacksmith weapon SA enhancement? a grade and higher is in blacksmith of mammon list, i found that and implemented it. but where can i find it for c/b grade?

3) this will be a a bit more complex im afraid. i wanted to make user able to enter their specific server rates as well, but im not sure if i understood the logic proper. i mean lets say we have a drop with a chance of 50% (on server 1x default) what happends when the drop rate is 4x? it would be 200%.. does that mean it drops 100% and the amount is 2x then? because its 2x 100% ? is there any formula?

for exp/sp i guess its easy.. just default value * serverrate X.

thanks already.

[jurchiks]

1) l2jserver is not constructed the way you think it is, quest drops are not placed like normal drops, each drop is specified in its own script. You can only find that info out if you know the quest from which that item drops. If you do, just read that quest script and (most probably) you'll find what you're looking for.
2) you didn't look in the multisells hard enough.
3) just find where the drops are calculated in core... first try searching for something like "FROM droplist WHERE", i.e. the sql query that reads the drops from the database. Then just follow the trail.

[TheDarkKnight]

1) okay.. i hope i have the information soon where i can obtain which item. could you tell me where i can find that "script" which i need then? so i can look already now if i would be able to read that proper.. or if i can drop the idea in general?

2) ups. you are right, its 1005.xml if i didnt watch wrong. thats nice coz i have that info already prepared in sql for me hihi thank you.

3) hmm.. okay. i will try. i hoped for an easier answer but anyway thanks.

[Stake]

1) l2jserver is not constructed the way you think it is, quest drops are not placed like normal drops, each drop is specified in its own script. You can only find that info out if you know the quest from which that item drops. If you do, just read that quest script and (most probably) you'll find what you're looking for.

This is why I thought of the implementation of a quest_droplist table.

[TheDarkKnight]

1) l2jserver is not constructed the way you think it is, quest drops are not placed like normal drops, each drop is specified in its own script. You can only find that info out if you know the quest from which that item drops. If you do, just read that quest script and (most probably) you'll find what you're looking for.

This is why I thought of the implementation of a quest_droplist table.

yeah gogo! do it do it xD i need it too xDDD

stake, are you able to provide me such a thing as .sql file?

im so greedy