View Single Post
  #4  
Old 02-07-2015, 08:16 PM
Zodl
Fire Beetle
 
Join Date: Sep 2008
Location: Madison
Posts: 26
Default

Sort of. Standard - "I'm not responsible for any errors this may cause / back your database up" disclaimer applies.

Edit - I recommend following Trevius's advice in his reply, his understanding is deeper than mine. My server is private, and does not use the public EQ Emu logon.

If you open up your MySQL editing tool (Hiede SQL/MySQL workbench, even the command prompt will work), I can get the NPC loot editor to work by running the following commands:

login using -u root -p
*password*
use peq; (Or your database name)

alter table npc_types add column d_meele_texture1 integer;
alter table npc_types add column d_meele_texture2 integer;

I'm not sure what these values function is in the EQ database, and the tool will be referencing a shell column. You're just creating an empty column, so the tool has a place to look.

If you try to update these values using the tool, it will place them into the these shell columns that aren't used.

But I have been able to modify spawn groups this way, I plan on doing some loot editing later. Basically I expect the tool to allow you to modify anything except these two fields that have been renamed.
Reply With Quote