Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::GeorgeS's Tools

Development::GeorgeS's Tools A forum just for GeorgeS's tools

Reply
 
Thread Tools Display Modes
  #1  
Old 12-24-2014, 02:06 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default npc_types Table Field Name Change

GeorgeS,

FYI, the following fields had their names changed to correct a spelling error:

d_meele_texture1
d_meele_texture2

They were renamed to the following (the "L" in melee was moved):

d_melee_texture1
d_melee_texture2

Your NPC Tools will need to be updated to support the change. Hopefully this type of thing doesn't get changed too often, but it is nice to get some spelling corrections in (especially for people who are anal about that).

Thanks for all you do!
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #2  
Old 01-06-2015, 03:49 AM
Bohbo
Hill Giant
 
Join Date: Dec 2012
Posts: 116
Default

Quote:
Originally Posted by trevius View Post
GeorgeS,

FYI, the following fields had their names changed to correct a spelling error:

d_meele_texture1
d_meele_texture2

They were renamed to the following (the "L" in melee was moved):

d_melee_texture1
d_melee_texture2

Your NPC Tools will need to be updated to support the change. Hopefully this type of thing doesn't get changed too often, but it is nice to get some spelling corrections in (especially for people who are anal about that).

Thanks for all you do!
I have grown very dependent on this tool. I came to post this and thankfully Trev beat me to it. Thanks for the tool George it is a lifesaver.
Reply With Quote
  #3  
Old 02-05-2015, 11:15 PM
Cassieze
Sarnak
 
Join Date: Aug 2005
Posts: 34
Default

are there any workarounds currently for this?
Reply With Quote
  #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
  #5  
Old 02-07-2015, 10:10 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Quote:
Originally Posted by Zodl View Post
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.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #6  
Old 03-11-2015, 01:31 AM
Tanyard
Fire Beetle
 
Join Date: Aug 2006
Posts: 22
Default

So what can I do to be able to open the npc_loot_edit.exe without corrupting the DB? Wait for a fix?
Reply With Quote
  #7  
Old 03-11-2015, 01:35 AM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by Tanyard View Post
So what can I do to be able to open the npc_loot_edit.exe without corrupting the DB? Wait for a fix?
Wait for a fix or use: http://www.eqemulator.org/forums/showthread.php?t=37343
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 03:12 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3