|
|
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/q1.jpg) |
|
![](/forums/images/Darkness/misc/q1-1.jpg) |
![](/forums/images/Darkness/misc/q4.jpg) |
|
![](/forums/images/Darkness/misc/q4-1.jpg) |
![](/forums/images/Darkness/misc/a1.jpg) |
|
![](/forums/images/Darkness/misc/a1-1.jpg) |
|
Development::GeorgeS's Tools A forum just for GeorgeS's tools |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-02-2013, 08:52 PM
|
Hill Giant
|
|
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
|
|
D2 Loot Issue
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?
__________________
U.S. Navy - Retired
17 Year EQ Veteran
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-03-2013, 01:45 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Ok try this
DELETE FROM lootdrop WHERE lootdrop.name like "lvl_%"
this will wipe all custom stuff
GeorgeS
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-03-2013, 02:29 PM
|
Hill Giant
|
|
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
|
|
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?
__________________
U.S. Navy - Retired
17 Year EQ Veteran
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-03-2013, 02:41 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
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
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-03-2013, 07:03 PM
|
Hill Giant
|
|
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
|
|
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.
__________________
U.S. Navy - Retired
17 Year EQ Veteran
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-03-2013, 07:05 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Yes, somewhere rev2214+ big changes were made to loottables
GeorgeS
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-03-2013, 07:20 PM
|
Hill Giant
|
|
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
|
|
Ditched the bots, got the 2214 and it works like a charm, thanks ![Smile](http://www.eqemulator.net/forums/images/smilies/icon_smile.gif)
__________________
U.S. Navy - Retired
17 Year EQ Veteran
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-03-2013, 09:27 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
I think I have the 2214 + bot binaries on my site - if you want.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-04-2013, 09:03 AM
|
Hill Giant
|
|
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
|
|
oh snap, you're the man
__________________
U.S. Navy - Retired
17 Year EQ Veteran
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-10-2013, 06:53 PM
|
Sarnak
|
|
Join Date: Oct 2007
Posts: 78
|
|
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
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-11-2013, 05:27 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
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
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-17-2013, 09:25 PM
|
Sarnak
|
|
Join Date: Oct 2007
Posts: 78
|
|
Any news on the diablo loot issue?
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-20-2013, 11:56 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
I looked.
Does it at least load up to where you can see the interface?
GeorgeS
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-24-2013, 07:54 PM
|
Sarnak
|
|
Join Date: Oct 2007
Posts: 78
|
|
yes you can see the interface but it fails to connect to the db
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-26-2013, 11:38 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
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
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 04:12 PM.
|
|
![](/forums/images/Darkness/misc/s1.jpg) |
|
![](/forums/images/Darkness/misc/s1-1.jpg) |
|
|
|
![](/forums/images/Darkness/misc/z1.jpg) |
|
![](/forums/images/Darkness/misc/z1-1.jpg) |
|
![](/forums/images/Darkness/misc/side3.jpg) |