Go Back   EQEmulator Home > EQEmulator Forums > Development > EQEmu Operations Center

EQEmu Operations Center Web development tools

Reply
 
Thread Tools Display Modes
  #1  
Old 05-26-2019, 12:33 AM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Smile Classic Skeleton Models

I want the classic skeleton models instead of the Luclin skeleton models. I have read a ton of forum posts and have had no luck from any of them yet.

The classic skeleton model race ID is 60. The "New Skeleton" model race ID is 367. Whenever I update an NPC in the EOC NPC Editor, it does not update the model to the classic skeleton after restarting my server. In fact, the model just looks the same as before.

As a test, I targeted one of the skeletons in East Commonlands and did the GM command #race 60 and it successfully turned into a classic skeleton. So, it is possible to load a classic skeleton, but only as an illusion.

When I click on the skeleton with the illusion, I typed in the GM command #showstats and was able to see the RaceID changed to 60 but the BaseRaceID is still referencing the old skeleton race ID 367. This indicates that in order to change the new skeleton to the classic skeleton globally, I'll need to find out where the BaseRaceID data is stored and update it to 60.

Most of the forum posts indicate that it's a server side issue with the GlobalLoad file, but I've tried everything all of the forums posts have suggested and had no luck.

Does anyone know where I can access the BaseRaceID in the database? I cannot find it anywhere. Thank you!
Reply With Quote
  #2  
Old 05-26-2019, 01:34 AM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,332
Default

I can't help you with the functionality of the EOC editor, I have never used it, but in-game, simply typing #race is only a temporary change, same would apply to a player if a GM did that. To change an NPC's race permanently, (example), target the NPC and type #npcedit race 60 Then type #repop. I just posted about in-game editing a few hours ago on these forums. http://www.eqemulator.org/forums/showthread.php?t=42465
There is a table in the database, called npc_types. It has every NPC on the server in there. It contains all the data for names, race, gender, class, stats, factionID's and a whole lot more.
__________________
Hanging out at Antonica.World
Reply With Quote
  #3  
Old 05-26-2019, 06:55 AM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Talking Unbelievable!

You did it! You figured out what I could not all of yesterday =) I read your post just now, and wish I had read it sooner but I didn't see it since it was so new and I was scavenging far and wide on the forums for older answers.

Your method of typing #npcedit race 60 and then repopping the zone with #repop worked. I still had to manually find multiple skeletons and perform the commands on each, since some zones have 2 or 3 skeleton ID's, but this method did create permanent changes to my server, even after I restarted the server.

I did check the npc_types section of the database last night, but only found 1 entry for skeleton and since I had already changed it to 60 and didn't see the skeletons in the game update, I thought it didn't work. However, now that you pointed me back in that direction (since I don't want to manually go zone by zone typing #npcedit race 60 on every skeleton in the entire game) I decided to take another look at the npc_types section and I noticed it was only displaying 18,000 results, so I clicked the ShowAll GUI button in HeidiSQL and it displayed all 64,000 results. Then I sorted by race column and did a find and replace of the number 367 to 60 and that updated every old world skeleton with the new world skeletons in game within seconds.

You are a life saver and I truly appreciate you taking the time to post the solution. Thank you!!!
Reply With Quote
  #4  
Old 05-26-2019, 07:39 AM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,332
Default

Great, glad you were able to get something done for it. If you can learn about running SQL queries, that also helps with mass editing. Using your scenario as example, running this query takes a few seconds and changes all mobs with race 367 to 60. I don't use Heidi, but if you have a feature in there to run a query, it comes in handy.
Code:
UPDATE npc_types SET race = 60 WHERE race = 367;
__________________
Hanging out at Antonica.World
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 11:56 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