I noticed that I get the runtime error 9 subscript out of range if I put over 5 items per loot drop. I saw someone else had that problem awhile ago and am wondering if it was fixed

GeorgeS, great tool and thank you. I played with it over the weekend and it works very well especially the ability to import custom lists. As usual the compliment is followed by a question ... LOL. Is there a way to limit the tool to specific zones? The reason I ask is this would be a quick way of adding new content to unused zones.

Thanks, Wil

DiabloII*
ver 1.7.2 (Sep-10th-09) - added support for >5 items per lootdrop - to a max of 32

Sorry for the delay in fixing this

GeorgeS

runtime error with last update to source
 

after the latest update, now i get a runtime error saying that column doesnt match the fields in row 1 or something very similar...any suggestions GeorgeS?

Holy necro,

What version of DB are you using?

GeorgeS

I'm using the latest db, i think 2133? I am not at home to check :-(

Ok, I'll take a look when I'm at the PC

GeorgeS

Also experiencing this with rev2197 - the problem is the tables have been slightly changed, and lootdrop_entries now has two added columns: minlevel and maxlevel.

Edit: Also, this was solved in the thread three below this post. Further reading fail. My bad.

Getting an error for this D2 loot maker tool, talking about your Connector to Mysql. Runtime error.

NPC editor is the only one that works with current DB ATM.

I'm working on these now

GeorgeS

Thanks George, I appreciate the work you do. been using your tools for a long time now. Had to rebuild my Database the other day and the only thing I have left to do is run this D2 tool. By the way. Is there an easier way make all mobs have a chance to drop every item? On my server, I've removed the level req. for the items and the no drop is also removed. I would like to make it so anything can drop off of any mob.

Also George, is there a way to run levels 1-60 (or max) with all the armor/weapons/items in one shot instead of going through each one and executing them?

No that is not possible, but a tool like this is easy to write.
What I may imagine you want is to import a custom item id list and have that added to all npc's say 10 items at a time per lootdrop and 10 lootdrops per npc?

I can whip this up pretty fast if you want

GeorgeS

Well I removed the level requirements on all items, and the no drop / lore flags. what im trying to do is fill ALL mob loot tables with completely randomized drops to make it feel like you could get something different from every kill. I would want the chance of drops to be high. Similar to what your D2 loot tool does, but instead of clicking 1-10, armor execute, 1-10 weapons exectute etc, i could do 1-60 all execute. If you could just add that into the Current D2 Loot (after it works again of course) i think that would be awesome. it would save a lot of time if you wanted to do it all in a batch like myself.

I really hope this D2Loot tool works again soon. Im finding it very tedious to do this all by hand :( Im terrible with SQL as well.. probably gonna jack something up.

Any update on this?

Give George some time dude. Instead of bumping the post every day why not learn some simple sql commands rather than just saying that it's too hard?

If it was so simple, why not post the solution instead of belittling someone? Im working on my own solution but its very tedious. Time isnt something I like to waste.

no offense, but i've already gone out of my way to attempt to assist you with an alternate solution in one of your posts on the subject.

http://www.eqemulator.org/forums/showthread.php?t=35923

you didn't indicate you had any interest in tailoring it to better suit your needs, that you had any questions, or even that you read it.

Hrm, my subscription didnt notify me about your response. I am going to try that now.

Is this tool working with DB Version 2214 yet?

No, tool will be finished by this friday. I'll commit time this week.

GeorgeS

I redownloaded the tool and tried it again with the same issue. Runtime error :(

When it's done the update will be posted here. RL is been busy

GeorgeS

as of today we are on 2260 ;)

Tool is now compatible with current schema. This takes into consideration the loot changes that broke the tool.

GeorgeS

Just a heads up.. downloaded the new version, server revision at 2243. My fields are set as follows.. 100% NPCs, 100% Chance to drop, 15 items.
In game, the drops are far rarer.. one in 10 mobs MIGHT have one of the new drops.

Browsing some droplists with the PHP Editor, I see that all the new loot has a very low chance to drop, and each table's droprate is only 15% or so.
Even with a 100 probability I'm still not getting results like I did before the lootdrop revision. Is it the cause of these problems?

Also, I notice this program is quite faster than it used to be, but I'm assuming that's because even if you set Chance for NPC to get loot to 100%, it's not really selecting them all - I've never see it working on more than ~5000 npcs each pass now.

Disregard the last line of my statement. It does modify more than 5k npcs at a time, but drops still are anything but consistent.

I see.
I looked at the source and added lootdrop_entries chance and loottable_entries probability to the code and main form so you can enter these now. Drops as a result should be vastly better.
These are in the newest binary

GeorgeS

George you are the MAN! Thank you very much for the quick response and updates, I'll give the new features a spin tonight!

Update: Works AWESOME George, thanks again!