Quote:
Originally Posted by Zodl
Sort of. Standard - "I'm not responsible for any errors this may cause / back your database up" disclaimer applies.
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.
|
I would not recommend anyone run this change unless they plan on only doing it while their server is offline and they plan on reversing the change before starting their server up again. If not, NPCs will fail to load due to mysql errors.