EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   Mass adding lootIDs to a single loottable.. (https://www.eqemulator.org/forums/showthread.php?t=33907)

Burningsoul 07-22-2011 11:34 PM

Mass adding lootIDs to a single loottable..
 
On my server, I have a silver chest with a loottable ID of 106876. I want to add a chunk of Stalwart armor to its' loottable, and I need help making a sql file for it.. the range of item IDs I need added to the loottable starts at 49201 and ends at 49536. I'm not concerned about % chance to drop or mulitplier as that can be changed with the PEQ database editor.

Is the following correct or am I missing something? Very much learning as I go here so any help would be awesome.

"insert into lootdrop_entries select 106876 from items where id>=49201 AND id<=49536"


All times are GMT -4. The time now is 10:32 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.