The return of the msknight dropcalc

[msknight]

Hi Folks,

After a long time of having issues, I'm back in the driving seat of the msknight dropcalc.

It has been adjusted to take account of the moving of the items from SQL to XML; there is a new import function available.

SVN checkout is http://l2jdropcalc.svn.sourceforge.net/ ... 2jdropcalc

Support is here - http://www.msknight.com/dropcalc - but after registering, don't forget to e-mail me to activate the account otherwise it just sits in the spam account folder.

Some features still aren't working due to datapack changes in the mean time.

Items can be changed, added and removed for off line characters, but I have had reports that items, once given via the dropcalc, vanish once the character logs on; I'm still investigating. Only one person has reported this so far.

Characters, races, classes and other things can also be changed as long as the character is off-line.

When custom items are added, I'll add those to the import routine.

Please post support queries to the dropcalc web address and don't clog up the L2J board. Also, note that I work for a living and don't answer queries very quickly.

To see the dropcalc in action (in guest mode, so you won't see the administration options) you can go to this page - http://195.7.255.202/ - but be aware that it is a home connection. Also, only the Lithra database is converted to current, so don't change the database or you'll get errors.

At some point I'll work on a video on how to install and use the dropcalc.

[Gnacik]

vanish once the character logs on; I'm still investigating.

Mana left and Time must be -1, you dont use that fields in INSERT statement, but they have 0 as a default in mysql table structure.

[jurchiks]

Then they should be changed to -1 by default...
You can commit to the svn, you can do it.

[msknight]

Wow. Thanks.

I noticed that time defaulted to 0, so I've done the mana_left to -1 ... but the statements I've used didn't actually write out mana-left, so surely that should have defaulted to -1 anyway?

[shinomidefuego]

wow i like this

[msknight]

Have you taken a look at the recipe calculator? I really love that piece of coding.

[ThePhoenixBird]

I like this topic

[msknight]

Yeh, it just give you that sort of warm, fluffy feeling inside, doesn't it?

[msknight]

At about 45:50 in to this video http://www.youtube.com/watch?v=GO8JJz6Nwcg you can see the recipe calculator.