Help needed for dropcalc testing.

[nineveh]

green i believe are for common crafts

[Hexa]

dwarven;mk_war_pick;195;2302;4;[2064(8)],...
dwarven;mk_skull_graver;196;2303;4;[2065(8)],...

War pick is recipe, item number 2279, and Skull graver is recipe, item number 2303. Give one of each to the character in-game and Skull Graver shows as a yellow icon, while War Pick shows as a blue icon in the characters inventory. (item 2302 in the dropcalc is recipe: silver axe)
dwarven;mk_hammer_in_flames;172;2279;3;[2041(7)],

ah... I know whats causing the confusion... its where the item's name doesn't match the client name used. Official server makes use of field values like [rp_war_pick] and that often doesn't match the english description.

Code: Select all

 (2279, 'Recipe: War Pick', 'false', 'recipe', 30, 'stackable', 'liquid', 'none', 0, 28000, 0, 'true', 'rp_hammer_in_flames', 'recipe', '2'),
 (2302, 'Recipe: Silver Axe', 'false', 'recipe', 30, 'stackable', 'liquid', 'none', 0, 45800, 0, 'true', 'rp_war_pick', 'recipe', '2'),
 (2303, 'Recipe: Skull Graver', 'false', 'recipe', 30, 'stackable', 'liquid', 'none', 0, 45800, 0, 'true', 'rp_skull_graver', 'recipe', '2'),

Code: Select all

dwarven;mk_hammer_in_flames;172;2279;3;[2041(7)],[1880(180)],[1879(90)],[1885(45)],[1458(430)],[2130(139)];294;1;[2279(1)],[57(5400000)];120;100;
dwarven;mk_war_pick;195;2302;4;[2064(8)],[1890(30)],[1888(30)],[1885(15)],[5220(60)],[1458(700)],[2131(81)];161;1;[2302(1)],[57(5400000)];138;100;
dwarven;mk_skull_graver;196;2303;4;[2065(8)],[1890(30)],[1888(30)],[1885(15)],[5220(60)],[1458(700)],[2131(81)];173;1;[2303(1)],[57(5400000)];138;100;

so from that.... mk_hammer_in_flames (seen as "Recipe: War Pick") is actually lvl 3 and is a different item to the mk_war_pick item known as "Recipe: Silver Axe"

Isn't official data fun I've gotten used to using the offical server naming conventions as that is more consistent across languages L2 is available in... I tend to forget to check what the English descriptions/names actually are.

Also, how do I determine the starting level for giving a pet? They start at level 1 in the db, but if I do the quests, I get pets that are somewhere around level 30ish.

starting level can be whatever you want to make it.... official chose a set starting lvl for wolves, hatchlings and striders based on the approx lvl the char obtaining the pet would be.

[msknight]

green i believe are for common crafts

Thanks for that. It adds another bit of complexity, but I can handle it somehow.

Isn't official data fun I've gotten used to using the offical server naming conventions as that is more consistent across languages L2 is available in... I tend to forget to check what the English descriptions/names actually are.

O.K. - so that still leaves me in the same position - with no way to find out for sure what colours are officially for what levels!

starting level can be whatever you want to make it.... official chose a set starting lvl for wolves, hatchlings and striders based on the approx lvl the char obtaining the pet would be.

That's cool. I'll build that in to the next version.

For now, however, the recipe calculator is finished!!!!! New code uploaded just this second.

Two new tables are needed, they are contained in the knightdrop.sql which I've also updated. If you've already got the drop calc installed, just run the code to create knightrecipe and knightrecch.

With the tables created, then go to the server tools and push the import recipe button ... that will import your servers recipe file in to the database.

The character view has been expanded ... it not only allows item and skill view, but also recipe view, where you can view the registered recipes. You can either run the calculator for the characters in your own account, or if the character you are looking at belongs to a clan, you can run the calculator for the clan.

Simple recipes look easy, but looking up a recipe for something like the sword of valhalla shows how complex this thing can get.

It doesn't do crystalisable items, though ... I'm going to have to think about that one. For the moment, however, my one remaining brain cell is hurting.

[msknight]

O.K.

The latest version is up ... which is nearly complete for version 3, and I've hammered it as much as I can.

It includes a re-worked version of the recipe calculator, to make it take less screen space, and also a basic pet management system that lets you reunite lost pets with their owners, and delete pets, or clear their names so the player can re-name them.

Time for a bug test. Updated source and SQL are still at http://www.msknight.com/comps/lineage2/ ... opcalc.htm for those brave enough to test it on a test server that has a reasonable population.

HeXa, sorry, but when I ran a database clean, it deleted your account because there weren't any characters on it. If you want, create the account again and PM me, and I'll set it to admin again.

Only issues I'm aware of now are ...

1) Recipes aren't showing under the right colours.
2) Database clean deletes acounts that don't have any characters on them ... need to expand that to not include accounts less than 24 horus old.
3) Database clean reports sql errors on early versions that don't have heroes or the olympiad.
4) Infinity Blade keeps disarming when the character relogs, no matter whether given by a table addition, or given via telnet.

And if anyone wants to see the recipe calculator result for Sword of Valhalla, a snapshot is at http://www.msknight.com/valhala/reccalc.php.htm ... the recipes for recipes go four deep, and that is where I called a halt because I ran out of screen.

[msknight]

I've added the ability to adjust the order of items in a shop (will happen on the next upload in a day or two - assuming no one finds any bugs in what is currently uploaded, I'll call it version 3)

I'm also working on changing mobs drops/spoils via the drop calc and that should be ready in a day or two.

Unless anyone puts forward anything else which is practical, that will probably mark the end of what the drop calc does with the database ... next I will be learning about the xml files.

[msknight]

Coming tonight ... (will be uploaded in about 12 hours time)

The item graphics are now GIF, halving the server space and bandwidth/download time for the items.

Ability for multiple copies of the drop calc to use the item and skill graphics from one location, saving server space for those with multiple dropcalc for multipe servers.

Low res mode - for GM's watching the chat screens, a low res mode lowers the refresh time of each page.

C5 map ready to rock. When/if you upgrade to C5, the maps can just be dropped in to place. Also, SQL to update the location finder in the drop calc to C5.

Change drops/spoils either grouped by an item or a mob, and you can give the drop percentages in either 1x values, or the values you've specified for your server.

... all to be updated tonight Stay tuned.

[msknight]

O.K. - latest version is up. If anyone wants to try it and let me know, that would be great. Still at the same URL at the start of the thread.

[ThePhoenixBird]

Just wondering, for example:

http://www.mywebsite.com/knightdrop/w-o ... ]blablabla[/b]&token=8368058776

If someone click on this link it can have access to my account, admin access in this case (just copy it from your browser address bar)

There is a way to avoid this, using cookies instead of links with personal info?

Another thing.

There shoul be a more especific config file for the actions performed by users (like view other chars inventary, view other chars warehouses, skills, etc)

I was using the L2jz control panel made by Zahar some time ago:

http://forum.l2jserver.com/thread.php?threadid=11161

Great tool with great addons, but it have many bugs, you can try to add some of the fuctions of his panel to yours, a new control panel made from scratch (yours in this case) should be great.

PD: Excelent work keep going.

[msknight]

Just wondering, for example:
http://www.mywebsite.com/knightdrop/w-o ... ]blablabla[/b]&token=8368058776
If someone click on this link it can have access to my account, admin access in this case (just copy it from your browser address bar)
There is a way to avoid this, using cookies instead of links with personal info?

Yes, they would have access to your account ... but where would they get the link from? Also, the token is only valid for a certain time beyond your last action ... how long that is, can be set in the config file. Also, when you re-log, the token changes.

Cookies, I'm not sure how to use. I didn't think it would become this powerful when I started writing it, so I didn't think that much security would be needed; although every time an action is performed, the user token and permission levels are checked. There are problems with so many people shutting off cookies in their browsers these days. It is something that I keep thinking about, though, like changing the token on every action; but that throws people who need more than one session open at a time, like when watching multiple servers. If I take it too tight, people complain.

Users, at the moment, can view the inventories for their own characters, and also the characters that are in the same clans as their own characters. They can't look in to just any characters inventory. I made it like this so that the recipe calculator could be used more easily by clan members, so they can see what the clan still needs to fulfill some recipes.

Just wondering, for example:
Great tool with great addons, but it have many bugs,

More stuff is coming in version 3 when I get it up in a few days. I have recently added the ability to wipe a characters inventory and/or warehouse/freight, the ability to make custom NPC's from existing templates and a few other bits and pieces. It also shows the maps for various zones. What stuff would you like to see added?

PD: Excelent work Wink keep going.

Thanks for the encouragement! It's always nice to hear that people like what I'm doing

[ThePhoenixBird]

I'll start to make my list of wishes for msknight christmas panel

[msknight]

I'll start to make my list of wishes for msknight christmas panel

Christmas? CHRISTMAS!!!! I wanted this thing done by May 1906 ... and now look at me!

Tonight I'm tightening up the token system a little, and then version 3 will go up. I'll let you know when it is up ... then download that and see what you think is missing.

Someone already requested the ability to create new shops, but I'm not so sure ... it can already edit shops, but there is a line between maintenance and foundation work ... and also some times where editing the tables directly is actually the faster way to do some things, as HTML coding is usually involved as well. I'm still thinking on that one.

Did creation work on a new server last night (also working on some new underground zones for contribution later) and there were times where using the drop calc for some stuff would have been way too slow. Creating the shops in SQLyog was favourite, and then using the drop calc to add the items in.

We'll see what list you come up with and take it from there

[msknight]

O.K. - version 3 is up there and is ready for download.

Added in this version ...

single button wipe of a characters inventory (excluding adena) and single button wipe of warehouse/freight.

Zone display - see the various server zones on maps.

Single button promote character to GM - promotes access level to entry level GM, gives newbie buffs and programs quick bar 10 with them, also defines some basic macros and populates the last few slots of quick bar 1 with them. The character concerned has to re-log before seeing the changes.

NPC clone, to help create custom NPC's from existing game NPC's.

Safe mode, stops the regular database clean up from deleting accounts which don't have characters attached; useful when running multiple servers (and dropcalcs) off one logon server.

It has c5 maps ready to drop in to place. C5 item and skill icons won't be done until the full client has been out for a while, as the test client changed a lot of ID's and I'm not sure if they will be changing back again. Time will tell. The drop calc will function, it just won't report the right icons.

That's about it for version 3. UPGRADERS PLEASE NOTE - the knightdrop table had to be moved from the gameserver database to the logonserver database, so if you are running the system on separate gameservers, please move this table.

Good luck!

[ThePhoenixBird]

Nice one

[msknight]

I'm working on the documentation - the updated version, which is updated live as I work on it, is at http://195.7.255.202/documentation/index.htm - later it will be bundled with the dropcalc itself when it is finished.

[Fulminus]

I said this in private, but I'd like to shout it out in public:
GREAT JOB msknight! When you started with this project, I expected it would just be another l2jz, with little to offer. Now, you've really shaped it up to a really amazing tool! I love your zones map, too! Really nicely done
I love it when people prove me wrong with things like that