GeorgeS - Loottable editor ommision

[GeorgeS]

The tool is pretty much done - and I'm out of ideas for now.
Perhaps it's time to 'play' EQ and level up my toons

GeorgeS

[EliteSting]

If you don't mind me asking GeorgeS , what is the proper procedure for copying items. Every time I try to do it , it freezes on me then shuts down.
I'll post exactly what the error message says when I get home.
Thanks for all the tools !!

[GeorgeS]

Let me know which item your'e copying and what your work flow was.

I simply search or select an item, then click on edit then click on 'copy item'
The new item will appear with a new item_id ready for editing.

Any crashes are most likely differences in table schema, or a field entry I never anticipated.

GeorgeS

[sfisque]

except, the loot editor doesnt work against a mysql running on linux. hitting the Save buttons gives it an error dialog stating very plainly:

Run-time error '-2147217865':
Table 'eqemu.Lootdrop_entries' doesn't exist.

which is very true, the table is lootdrop_entries, not Lootdrop_entries. any chance of fixing the query so that it either goes against 'lootdrop_entries' or making the target tables configurable in the .ini file?

== sfisque

[John Adams]

Table references should all be lower-case anyway, since that's what they are in the MySQL - Windows or not. Not sure you can even make upper-case table names in MySQL 4?

[GeorgeS]

Thanks John - you sent me off in the right direction so I finally fixed the bug. It works on windows and linux systems running MySQL!

New version is online - 12.05.00
-Fixed table references so this can be used to query a MySQL db on Linux.

GeorgeS

[sfisque]

very cool. i'll download it tonight and give it a whirl.

thx for the fast turnaround man!

== sfisque