Sandy's Loot Editor
 

LootEditor-v1.1.zip (binaries)
LootEditor-v1.1-Source.zip (source files)

You need a working database for eqemu
If your npcs have spawn points, with this program you will be able to change the loot of each npc, it's sorted by zone/race of the npc/npc names and it shows then when you select a npc its loot table

you need to extract looteditor files in eqemu directory or to copy db.ini and spells_us.txt from eqemu directory to the directory where you extracted looteditor =)

next you need to add the 'races' table in your database from the 'races.sql' file

here is a preview :
http://alliancekfc.webdynamit.net/eqemu/looteditor.jpg

I hope it will help you =)

PS: thx to projecteq to host my tools ^^

Crashes for me (WinXP).

Gets the Fatal Error, must be shutdown, would you like to send error report etc.

Looks very good - but as soon as I try and load a zone it crashes.

The file is in the EQEMu directory so has the correct libmysql.dll and db.ini.

Looks very useful though, if you can get it working :P

Monrezz

You are a brave, brave man Monrezz !

can you send me your zone, spawn2, spawngroup, spawnentry, and npc_types tables and datas if possible plz so i can try it and see what's going wrong =)
thx

email me that at magic1612@wanadoo.fr

i need more people to try it to make it works =) thx for your help by advance

I've updated the version of looteditor to download, it's the last one, it needs spells_us.txt now if you want to see effects for items
re download it maybe =)

Brave, or stupid? :)

Tried it on a spare box, not that brave :wink:

Don't suppose you want to distribute the source for your proggie sandy, I'm sure if people knew it was 100% safe they would be more...willing... to download it. People are a little untrusting here, when closed-source programs attempt to connect to the web...

Monrezz

I don't understand ?
it doesn't connect to the web
it connects only to your database on your computer
explain to me what's wrong it's the 1rst time I program and distribute something

releasing the source makes sure there is no virus in it..granted the net calls could just be attempts to attach to the database, but without people being able to see the code, it could be a virus-trojan-wurm. a bunch of things..people are just security minded.

Why don't you all thank sandy for making this program? Looks great from the screenshot! Complaining that her program MIGHT be a virus won't encourage her to make any other programs for the community.

are you serious ? you really look at all the source files of all programs before to run them ? lol
and anyway, i think malicious people would be malicious enough to give cleaned source files and infected binaries ...
I think you should just use antivirus softwares like everyone =)

and yes i released this looteditor to help worldbuilders and i need help
I put the source files to download if you want, don't laugh at me, i just learnt visual c++ =)

Thank you for making it - not saying there was no point. Looks like a great program to me, very useful!

But not many people are going to download it unless you release the source so they can verify it's not a trojan/worm/virus.

The reason people want to check is you are quite new here, and so people won't trust a program built by someone who just joined when the proggie tries to connect to the web. If someone, say Trumpcard, released a proggie there would be no hesitation to download it. But people get a little anxious with new people and new programs.

Release the source, make it avaliable for download and I'm sure your program will help a lot of people. Thanks for putting the time and effort in to help to community already :)

Monrezz

Close source softwares are a trouble that i know well, everything i wrote for eqemu is closed, mainly because the mysql component i use isn't free and even the way it's used must be closed (developped at work, and is part of a bigger project). Anyway, i think the more boring thing isnt the fact that sources are closed, its the lack of feedback you get for your work. You know that people are downloading it because of the stats of your website, but you never know if they use it, don't use it, and even more why. Hard to keep your motivation.
Unless you're a 3rd party tool god (that i won't name since everybody recognized him yet) and release high quality stuff, it is, at least for me, hard to launch my RAD and start working on eqemu stuff :?
Of course, this is totally OOC, and i wish the best to Sandy. Btw, i tested your software, under w2000, it worked perfectly. thankees

LIke Monrezz and Muss mentioned , its just a matter of not knowing the person releaseing the program. I see your joined date is Oct. 2002, so Im not too concerned, but for all we know you could be a disgruntled eqemu'r that thought it would be funny to release a trojan horse program to format someones hard drive. Its one thing to write a program, have forums, support, etc, dedicated to a program as opposed to just posting a link on a website saying 'download this, it'll do wonderful things'. I have years and years of very important data stored on my machines, yes I could recover them, but that doesnt mean i want to find out...

Its nothing personal against you, but if I dont know someone, or I dont see something estabilished as a credible project, i wouldnt install it unless i knew it was what it was advertised to be. There are alot of malicious people out there, so you have to be careful sometimes (and I think it is a shame that we do have to be)

I don't think anyone complained that it might be a virus, I think everyone just commented on the fact that it is considered risky to download exectables from someone you dont know.

If you release the source code, most of us would compile it ourselves, so there would be less concern.

I definitely agree, thank you for the contribution. 3rd party programs are always greatly appreciated.[/quote]

Looks as if you've released the source but can't have a look at school. I'll have a look at it later tonight. Might be able to see why it doesn't work on WInXP either. It could just be my database...

Anyway great program very useful! Keep them coming!

Monrezz

Gave it a try, and got the same behaviour as moonrezz :

. it connects to the db, and retrieves the zone names. This fills up the drop down box on top. ok.

. when selecting a zone, it makes a second query. If the zone is empty (i.e. no spawn2 entry), just fine, doesnt have anythnig to show, so nothing happens.

. when selecting a populated zone, it make a second and a third query. On third query, it breaks and grindoze shows up a app killed message.

oki
i'm stupid =)
the queries you are talking about are those who display the npcs by their race
you don't have the race table because it's not in eqemu =)
download it and try again with it plz ^^

thanks for your help

Sourced it in, works like a charm!

very, very nice program. I know this will certainly help a lot of people, wouldn't be surprised if it was added to the release (like the item editor). Certainly makes it easier.

Don't suppose you could add s few new features, such as an export loottable perhaps - that will export all the data for a certain mob, spawn, type etc into an sql that can be sourced into another database? Also, perhaps make it so you can choose how the mobs are sorted. I see you have them sorted by race at the moment, perhaps make it so you can sort by name, level etc.

Great work,

Monrezz

item loot editor
 

very nice prog. !'ve used it for alot of Mob's already and i love it. thanx for the Prog its very nice

it's cool then =)
thx monrezz nice ideas I will certainly add them ^^

Excellent! It's very nice to see people contributing programs to the community, especially when they take the feedback of others and use it to improve what they already have.

Do you have any plans to make other useful programs? :P

Monrezz

I have to say it: This program is awesome!!

Its fast, smooth and intuitive. I am passing it on to Myra right after I finsh posting this.

Great job Sandy!!!!!!

one more add on?..a way to add coin to them as well.

I would recommend:

• Different options for sorting mobs in zone (race, level, class etc),
  
  Able to filter the list of mobs by race, level, class etc,
  
  Able to set money dropped,
  
  Able to copy loot tables across from one mob to another (drag and drop?),
  
  Able to export loot tables by mob or zone,
  
  Able to run your own SQL Query from within the program using listboxes and fields to set default loot for all mobs. (eg Give all goblins between level 10-20 MiscItems loot set and 20pp). Lets you select all avaliable races, or lets you do it for all mobs in a certain zone etc. This might be a little too much work for too little return, though.

Just a few suggestions, keep up the good work :)

Wow, looks like you're on for busy holidays :lol:

Yes, the program work great, and on linux-wine too.

Happy penguins unite !!! Sry that was off topic.

hey great program but let me throw a wish list out there of something that would be cool in the next version.

With boss mob loot table being not that acurate it would be great to be able to make new loot tables on the fly. Then be able to drag and drop stuff from the old loot table to the new one. That might be really tough or impossable but I was just brain storming one what would be even cooler.

I hav been playing around with this a bit and noticed a few issues/bugs

I was updating plane of innovation. I updated the metal dragon loot table from nothing to what it is supposed to be. I then noticed that it updated the boheamoth and the tin solders with out me doing anything.

lol Now we can't have that happening. Am I doing somethiing wrong? Or is there something I can do to change that.


Thanks

Oh, and perhaps add a small load bar (or text) so you know if the mob has loot. Atm mobs with a few loot tables take a while to get loaded in, but the screen stays as if it is a mob with no loot (while it loads). Makes it easy to skip over a mob...a simple little text bar that lets you know it's loading something, other then just sitting there doing nothing, would help.

Fantastic editor. Wish there were more editor types out there as easy to use as this one.
One problem i have noticed is if you add a new set to a mob it updates all the mobs of that type with that set even in other zones.
I created a new set for Gnasher Furgott in qeynos hills giving him the head and note to drop for the quest in surefall glade and it also added the same set to the elite and commander gnolls and all splitpaw gnolls in Blackburrow. When i tried to remove the set from the blackburrow gnolls it also removed the set from Gnasher in Qeynos hills. Other than this minor problem it is a great editor. Hope to see more like it in the future.

If you have problems like those of vaelene or jimmy, I think it's because 2 or more npc_type share the same loottable_id
Each npc_type must have a distinct loottable_id else when you update the loottable of one monster, the others that share the same loottable_id are updated too =(

So I recommend you this :
1) delete all the loottables of the npcs that are affected by this bug by removing all sets
2) and just recreate them by adding the good sets, I think it will work because the editor will recreate a new loottable for the npc if he haven't any set already

monrezz
you should not have any loading time because it's only sql queries it's really quick
how many sets and items does the npcs you are speaking about have ? i'm curious =)

The ones that took a while to load had between 30-40 items total, spread across 3 loottables.

I'm running a 2.2Ghz 512RAM, and LootEditor was the only thing open. So the queries do take a while when sorting through that much data :)

It would be nice if a small bar at the bottom showed when it was performing a query, or how long the query took once completed.

Monrezz

sorry it's almost instant for me for 50 items and 10 loot tables =)

I added some items to Lady Vox, they show up fine in MYSQL-Front and EqEmu admin and they seem to be in the Loot Editor but then when I go in the game and do a #npcstats on her she doesn't have any items. I tried killing her and sure enough, no items. Other mobs that already had loot work fine.

Lady_Vox: [chance: 100, multiplier: 5]
Tobrin's Mystical Eyepatch [chance: 100]
Runed Bolster Belt [chance: 100]
etc.
etc.

Try changing the multiplier and setting the chance to 50%, just fiddle with the values.

hiyas, Just wanted to shoot back at yeah that I tried to create a totally new loot table for the boss mobs in poinnovation..( the metal dragon and bohemoth) via the loot editor. I got the same result in that all boos mobs got the same loot even the tin solders.

Not sure whats going on I'll check into their loot table from eqadmin to see whats up and repost here if I find out.

Sandy you are correct about the mobs sharing the same lootable_id number. However if you just remove all the loot sets from all the mobs having this proble and then add back loot sets it does not solve the problem. I removed all loot sets from all the gnoll mobs in blackburrow and qeynos hills including all the coin drops using the lastest version of loot editor and then added the gnasher head to Furgott Gnasher in qeynos hill and gnoll fangs to the gnoll watchers in qeynos hills and when i then looked at the gnolls in blackburrow many of them had gnoll fangs to be droppped and a few had Gnasher's head to drop so just deleating all the sets does not remove the lootable_id number from the database. If you manually remove the lootable_id number from the database using EQadmin 5.1 and then try to use Loot Editor you will find that Loot Editor crashes when you select the zone the mobs were in that you removed the lootable_id number from. What number does the lootable_id need to be set to so Loot Editor will see it as having no loot and be able to set it to a unique number?

After playing with EQadmin and lootable_id field a bit i found that if you set it to 0 then use Loot Editor to add loot sets Loot Editor will then create a unique lootable_id by incrementing the highest number in the lottable_id field and using it. This may be a bit of a problem with some databases as i was using MW 053_alpha3 and the lootable_id field was allready up to 122366. Many numbers were skipped. Long term this may create numbers larger than the field is setup to use. It would be better to look for numbers not used 1st and use 1 of them if available and only add to the end if all other numbers are used. Just an idea. Also could you set Loot Editor to set the lottable_id to 0 when all loot sets are removed?

with the last version
you have to delete all sets and to set the monster to not drop any coins to make the looteditor delete completly the loottable
and then if you add a set or make him to drop coins the looteditor will create a new loottable with a new loottable_id
when it deletes completly a loottable it already changes the loottable_id of the npc to 0
if it doesn't work there is then really a bug =) can you give sql examples of when it appears ?

if you want to delete manually a loottable, don't forget to:
- set the loottable_id in npc_types table to 0
- delete the entry in loottable with the id equal to loottable_id in npc_types
- delete all entries in loottable_entries with the loottable_id

some database have loottable ids equal to npc ids
others have no id rules

the goal of this looteditor is really to make the sql loottable structures abstract for the user, so I won't implement any id management for now

but maybe if eqemu would decide to make some id rules to be standard it would be easier for us and I'll implement it in this looteditor =)

for drag and drop idea to make loottables on the fly and then to assign loottables on monsters already filled with items, I already thought about that, but i decided to make it this way so everything is centered on a little window
maybe if it was on a greater project like for example a complete editor where you have a 3D view of the zone, where you can put NPCs by the 3DView, it would be then better that you would be able to create the loottable before to assign it to the monsters, but for just a looteditor I think it's enough =)

Thank you for responding so quickly Sandy. You are correct about Loot Editor setting the loottable_id to 0 when you remove all loot sets and coin drops. Since i am using an existing database with multiple mobs sharing the same loottable_id number i ran into a unique visual problem. i would remove all the loot sets from 1 mob and all the loot sets from other mobs sharing that loottable_id would have all their loot sets removed making it appear as if they had no loot sets but they would still have the origonal loottable_id. So when i started to add loot back they were not being given a unique loottable_id making it appear as if Loot Editor was not working correctly. I was able to tell which mobs share a loottable_id by trying to add coin drops. When i try to add coin drops to the mobs that share a lottable_id Loot Editor will not alow coin drops to be added. I kinda like that feature as it alowes easy identification of which mobs share a loottable_id. I did have Loot Editor crash a few times when trying to add coins drops to mobs that shared a loottable_id with the error invalid page fault in module libmysql.dll. I have nad no other problems with Loot Editor so i believe that once the database is straightened out and all mobs have a unique loottable_id this crash will not happen again but i did want to let you know about it anyway. I am running on windows 98 2nd edition if that helps. Thanks again for the fast response. I can now start fixing all the loot drops.

After using Loot Editor to fix all the mobs in Blackburrow and give them all a unique loottable_id. I would like to recommend 2 minor changes to Loot Editor.

1st Adding a button on the main screen to remove all loot sets and coin drops from the selected mob and set the loottable_id to 0. As the only way to do it now if there are no loot sets on the mob with Loot Editor is to add a loot set and then remove it and remove the coin drops. This is a bit of a lengthy process when trying to fix every mob in a zone.

2nd Add a question box when you try to delete a set from the screen where you create and select sets asking if you are sure you want to delete the set. I deleted a couple of sets by accident and had to re-create them while i was fixing Blackburrow.

Other than those 2 minor points i love this editor and can see no other improvements needed.

ok bug fixed I hope =) Thx

wow seems to work awesome now... great work and thanks