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"
|