EQEmulator Forums - lootdrop mass update

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - lootdrop mass update (https://www.eqemulator.org/forums/showthread.php?t=40382)

lootdrop mass update

I would like to add lootdrop id 165862 to Every single loottable in the database.

I am having issues with the sql update for this as I would have to add rows for every loottableID in the loottable_entries table.

Try this:

Code:

INSERT INTO `loottable_entries` (`loottable_id`, `lootdrop_id`, `multiplier`, `droplimit`, `mindrop`, `probability`)

SELECT lt.c1, lt.c2, lt.c3, lt.c4, lt.c5, lt.c6

FROM (SELECT DISTINCT `loottable_id` c1, '165862' c2, '1' c3, '1' c4, '0' c5, '100' c6  FROM `loottable_entries`) lt

c1 = `loottable_id`
...
c6 = `probability`

You'll need to adjust the c3 through c6 values in the third line to whatever you want the 'default' to be.

EDIT: If you have already made any entries with that item id, the script will probably fail on duplicate key entry.

If that's the case, you can run:

Code:

DELETE FROM `loottable_entries` WHERE `lootdrop_id` = '165862'

to clear out any existing entries.

Getting a response with

Code:

ERROR 1062 (23000) at line 1 in file: 'Z:\EQProject\A1 - MAss DB Update Strings\

new.sql': Duplicate entry '81-165862' for key 'PRIMARY'

I didn't get my edit in fast enough :P

lol :) thanks. yep had to remove existing entries

Lol! Always 2 seconds too late!

Np :)