D2 Loot Issue

Furinex · #1 02-02-2013, 08:52 PM

So D2 was working great from the last update. I had the whole server's spawns changed up. One day I boot the server and I notice all the drops are pretty much back to normal, or maybe just not what it used to be after I ran the tool. So I open D2 and show the stats. it shows a massive amount of changes across the board, pretty much telling me its working (But its not). Now, When I delete all the entries, says its deleting them, until I get to 59-99 and 65-99 and that doesnt work at all. It comes back with a runtime error 9 saying Script out of Range . Is there a way to delete all the entries (from some other way than within the tool) and start fresh?

**GeorgeS** · #2 02-03-2013, 01:45 PM

Ok try this

DELETE FROM lootdrop WHERE lootdrop.name like "lvl_%"

this will wipe all custom stuff

GeorgeS

Furinex · #3 02-03-2013, 02:29 PM

ok tried this... It seemed to do the trick... I opened back up D2 loot and showed stats. 0's across the board. So I tried this. 01-10, 100, 100, 5, 100 Armor. Hit Execute and I get this:

Run-time error '-2147217900 (80040e14)':

[MySQL][ODBC 3.51 Driver][mysqld-5.1.54-community]Duplicate entry '86729-292432 for key 'PRIMARY'

Any advice?

**GeorgeS** · #4 02-03-2013, 02:41 PM

Ok, I tried this with my version 1.8.5 and database rev2294

This is definitely a schema issue.Were any changes made to the loot tables since?

I can always upload a 2294 database is you need

GeogeS

Furinex · #5 02-03-2013, 07:03 PM

Im also using 2098w/bots for my servers rev. Is me being behind a few revisions a problem too? I tried compiling it myself but ran into some issues I couldnt solve so I said screw it. I tried it on a fresh database @ 2294, same issue.

**GeorgeS** · #6 02-03-2013, 07:05 PM

Yes, somewhere rev2214+ big changes were made to loottables

GeorgeS

Furinex · #7 02-03-2013, 07:20 PM

Ditched the bots, got the 2214 and it works like a charm, thanks

**GeorgeS** · #8 02-03-2013, 09:27 PM

I think I have the 2214 + bot binaries on my site - if you want.

Furinex · #9 02-04-2013, 09:03 AM

oh snap, you're the man

Dabloon · #10 02-10-2013, 06:53 PM

Diablo loot wont connect to the db for me even though the info is correct. Its the only tool so far i cant get to work on rev 2214

**GeorgeS** · #11 02-11-2013, 05:27 PM

I'm not sure why either as the connection specified in the db.ini is same as other tools. I'll have to check when I get time.

George

Dabloon · #12 02-17-2013, 09:25 PM

Any news on the diablo loot issue?

**GeorgeS** · #13 02-20-2013, 11:56 PM

I looked.

Does it at least load up to where you can see the interface?

GeorgeS

Dabloon · #14 02-24-2013, 07:54 PM

yes you can see the interface but it fails to connect to the db

**GeorgeS** · #15 02-26-2013, 11:38 PM

Not sure I understand. Once the interface is loaded, the connection inthe db.ini is good. A crash before the interface loads means db.ini is bad.

Once the interface loads, what do you press that causes this problem?

also when you say "but it fails to connect to the db" what causes you to think that?

GeorgeS