Sandy's Loot Editor

[greenguy14]

is there a reason i cant do potimea or potimeb zone. maybe not have races or sumthing but i cant load it i get the fatal error?

[sandy]

I really don't know, maybe it's a pb of races, try to redownload the loot editor, i added the latest races.sql in it

[sandy]

links restored =)

[blinkish]

Whenever i try to start it up , it never starts up, nothing happens :(

[sandy]

you have to check if you have correctly sourced the races.sql file into your database and if you have correctly filled the db.ini file with your database info

[Jezebell]

Hey Sandy

I am getting an error when I try to go to Plane of Time, closes the program. Any idea why?

I do have latest races.sql in db, I checked.

[KhaN]

I would like info on the variables about drop system using your loot editor.
Exemple :

Orc centurion: [Chance:15, Multiplier:35]
Cloth Cap [Chance:2]
Cloth Veil [Chance:2]
... TOTAL 35 DROP ...

What's the effect of variables in Bold, with this config, my orc cent will always drop like 4/7 items.
[Chance:2] : Droprate of the item
Chance:15 : !?
Multiplier:35 : !?

Merci d'avance et beau travail

[sandy]

there is 3 things :
loot table
loot drop
items

each npc have 1 loot table
a loot table have one or several loot drops
a loot table have also platinums and other coins
each loot drop can have one or several items in it
loot drops can be shared between npcs but not loot tables whom are unique to each npc

loot drops are what i called "sets" in looteditor

sets have 2 attributes :
- chance :
it's the chance that something drops from this set
- multiplier :
it's the maximum number of items that the set can drop

example : 100% chance, 2 multiplier
the set have 100 % chance to drop 2 items from the set
which items depends of the chance associated with each item

example 2 : 50% chance, 3 multiplier
the set have 50% chance to drop 3 items from the set
it means it can drop 0, 1, 2, or 3 items, but the most often you will have 1 or 2 items

items have 1 attribute :
- chance :
it's the chance that this specific item drops compared to other items of the same set
total cumulated chance of all the items of a set must be equal to 100% else some items won't never drop

example :
here is a set where there are 3 items :
bone chips 30%
cloth veil 50%
blade of carnage 20%
total 100 %
cloth veil will drop the most often
bone chips in second
and blade of carnage will be rarer

example 2 :
here is a set with 2 items :
bone chips 100%
cloth veil 50%
total 150%
here's bone chips will always drop because they are the 1rst in the list and have 100% chance to drop
cloth veil won't never drop

so you should always do the total
if the total is >100% something won't never drop =)
if it is <100% it might works but the result is uncertain

so if you are in the case you want that your npc drops always 2 bone chips, sometimes he drops a cloth veil and always a blade of carnage or a fine steel long sword, blade of carnage rare drop, but you want that it's possible that the npcs drops 2 bone chips the cloth veil and the blade of carnage at the same time :
you should make 3 sets :
one for the bone chips :
bone chips set : chance 100% multiplier 2
1 item :
bone chips : chance 100

one for the cloth veil :
cloth veil set : chance 30% mutliplier 1
1 item :
cloth veil : chance 100

1 for the blade of carnage and fine steel long sword :
weapons set : chance 100% multiplier 1
2 items :
blade of carnage : 20%
fine steel long sword : 80%

well =) you see it's easy =)
good luck =)

[KhaN]

wow thanks, now its VERY clear

[xtestx]

Would it be possible to have more than 1 item have a 100% chance at dropping?

like:

Glyphed Rune Word 100%
Timeless Breastplate Mold 100%
Fiery Staff of Zha 20%
Cap of Flowing Time 40%

Instead of having it all equal up to 100%

like:

Glyphed Rune Word 50%
Timeless Breastplate Mold 25%
Fiery Staff of Zha 10%
Cap of Flowing Time 15%


Yes/No/Mehbe so?

[sandy]

I answered already =)
if you put an item at 100% chance all items below it will never drop =)
and in general if the cumulated chance of items reach 100% all items below the one that make it reach 100% will never drop if there is some
because it's the chance compared to other items, it's not the chance compared to the set
if you want that 2 items always drop you have to create 2 sets 100% chance and put each item at 100% chance in each one

[Jezebell]

Sandy, have you figured out why it crashes when you go to PoTime?

[sandy]

no sorry =)
not worked on a new version yet =(

[ruwatchinme]

can anyone help me here? i am trying to get a new server up and running and having compications with some of the commands in mysql.exe (sp) I try putting in this command,

 grant all privileges on *.* to username@localhost identified by 'password' with grant option;

I get some error about it being an incorrect command. I used this post to walk me through it, and i am getting no where. http://www.eqemulator.net/forums/viewtopic.php?t=13403 Please can someone give me a hand