Great work. Noobish question, though.

I'm confused as to how Chance and Multiplier work.

Ex:

LootTable (chance: 100, multiplier: 1)
item1 (chance: 50)
item2 (chance: 50)

Will this loot table drop one of the two items only? By the same token, if I bump the multiplier to 2, will it drop two items from the loot table, or what?

I'm trying to make some custom loot tables where a mob will drop 3 items from table X, 2 items from table Y, and 1 from table Z. Does the multiplier facilitate this? Please explain :)

Thanks in advance.

As far as I understand it, the loottable chance is the chance of anything dropping. The multiplier is how many things can drop max if the chance is 100%.

The item chance is the chance of that specific item dropping compared to the other items.

In response to the question about Vox's loot table, or any other loot table for that matter, where you have items that should drop all the time (IE 100%). Using our good friend Lady Vox as an example, her default loot table (from Myra's DB) looks something like this:

DragonVox (Chance: 100% Multiplier: 4)
Item 1 (Chance:30%)
Item 2 (Chance: 40%)
Item 3 (Chance:100%)
etc etc.

What would happen (at least on my server) was the 100% item would only drop almost all the time. Even if I changed the multiplier, only the 100% item would drop. Now, let me say that my loot table contained several 100% items, as Vox always drops certain items every time. And I had my Multiplier set to 6, but I would only get 1 item, the first 100% item. Not sure if thats a bug with the EMU or not, but anyway, my point is this. I was able to fix this pretty easily, I created several other loot tables DragonVoxScale, DragonVoxTome, ect.. Set them to (Chance 100% Multiplier: 1) and put one of the single drop items in each table. Then in the main table, I deleted the 100% drop items, and adjusted the % chance rate on the items to give an even disribution of the remaining items. I then repoped Lady Vox, and bam, loot that mirrored EQ Live.

Sandy, first off - WOW! :shock: Your editor has saved me a good amount of time updating the PoNightmare loottables. Using MW's db, I had to change all the loottable_id's in mysql, but that wasn't too difficult. So, thank you.

However, I noticed that there are several named mobs in the db that didn't show in your editor when I loaded the PoN zone - specifically the queen 'B' herself, Terris Thule, and Vakshiz. Now I understand that my problem could be my lack of knowledge about the db, and/or your editor. How could I change TT's and V's loot using your editor if they no show?

Also, with MW's db and going thru the PoN I gave each mob group (ie 'a_wraith%') a unique loottable_id = to the mob00's lowest npc_type id. Then I added a loot set named after the mob group and added appropiate loot. However, after going into the client and killing everything in zone no mobs dropped any loot... Suggestions anyone? I did notice that the 'Loot Table' field under NPC in EQAdmin is blank - whereas before it said like 'ultra high loot' or something like that.

'Things that make you go - hmmm...'

Edit for above post..
did you restart your comp i know u have to do it for item editor and some other 3rd party tools try restarting your entire comp.




i am a real noob in here i got my server and stuff so that works and have mangoos item editor.

but im kinda clueless what i have to do with the files i downloaded them all but what do i do with them. do i have to build anything or sumthing. and what files do i have to replace and/or does it have to be extraced to a certain place?

You dont need to download the source. Just download LootEditor1.1.zip or similar, not the Src one. Then copy everything into your EQEmu directory and double click LootEditor.exe

nevermind i got it working had in wrong directory hehe but do i need the races.txt?


p.s. what do i do with the races.txt?

bah i get the fatal error want to send.dont send error when ever i load a zone

You need to source races.txt into your database.

ok im having probloms sourcing again have not done in awhile
it inly has to be in mysql\bin folder right then its

use eq
mysql -u root mysql
Source races.txt

right but im gettin error 2 can not find file so i think im doing it wrong

source races.txt;

Make sure it's in your mysql\bin directory.

im getting same error


Mysql>use eq
database changed
mysql>Source races.txt;
Failed to open file 'races.txt', error: 2
Mysql>

Copy races.txt into the same directory as mysql.exe (Should be "C:\mysql\bin").

it is next to my mysql.exe in the bin folder
i dont know whats wrong

Are you sure it's not races.sql?

Go into Mysql Front and right click on eq. Choose Import --> sql and then open up your races.txt file. That will source it.

is mysql front the
street light thing running or sumthing else?

cause theres no right click options other then hide me and winnt->shutdownthistool,stopthisservice

No that's winmysqladmin. You need to download MysqFront from www.mysqlfront.de I believe.

Make sure you start mysql from the mysql/bin directory. You can start it from any directory since it is probably in your path, but it won't be able to find the races.txt unless you start mysql from mysql/bin.

Woot it woked yea mysql worked perfectly im gonna use that to source the all my stuff now thanks man

p.s. sandy awsome loot editor works awsomely thanks

Yes, I just made a .bat file since when I open cmd up it opens in documents and settings/<myname>...... something like this:
Just type that into notepad, save-as <easy name to type>.bat
EG... sql.bat
Then when you run the bat it will get mysql up and running for you....and in the correct directory, with minimal typing.

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?

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

links restored =)

yo
 

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

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

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.

I would like info on the variables about drop system using your loot editor.
Exemple :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 :D

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 =)

wow thanks, now its VERY clear :)

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?

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

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

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

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,

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