Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2019, 02:14 PM
Dryamzord01
Hill Giant
 
Join Date: Jul 2018
Posts: 161
Unhappy hel please on npc types

can anyone leave me here, all the class numbers of the npc types? please I had an error and I put them all with the same number :(
Reply With Quote
  #2  
Old 04-24-2019, 02:17 PM
nilbog
Hill Giant
 
Join Date: Nov 2007
Posts: 198
Default

https://github.com/EQEmu/Server/wiki/Class-List
__________________
https://www.project1999.com
Reply With Quote
  #3  
Old 04-24-2019, 02:18 PM
Dryamzord01
Hill Giant
 
Join Date: Jul 2018
Posts: 161
Default

What is the normal merchant?
Reply With Quote
  #4  
Old 04-24-2019, 02:21 PM
nilbog
Hill Giant
 
Join Date: Nov 2007
Posts: 198
Default

It's on the list.

41 Shopkeeper
__________________
https://www.project1999.com
Reply With Quote
  #5  
Old 04-24-2019, 02:27 PM
Dryamzord01
Hill Giant
 
Join Date: Jul 2018
Posts: 161
Red face but

yes, but what I want to say, unintentionally in the database, I put the whole list in a number, and now to know again which one I had ...

Could not you copy the list here?
Reply With Quote
  #6  
Old 04-24-2019, 02:34 PM
Dryamzord01
Hill Giant
 
Join Date: Jul 2018
Posts: 161
Unhappy

Is there any way to go back in heidisql when you make queries? unintentionally I put all class in 71 because I wanted to look at what to put the mercenaries
Reply With Quote
  #7  
Old 04-24-2019, 05:15 PM
nilbog
Hill Giant
 
Join Date: Nov 2007
Posts: 198
Default

Hmm... well, it's not as simple as an 'undo' button, no.

Assuming you don't have a backup of the npc_types table to restore from, you could create a new npc_types table with the correct npc_types.class values from a default peq install.

So, for example:

npc_types table. This is where all your classes are 71.
npc_types2 table. This is a new table you have sourced, where class values are correct.

Then, do something like...

Code:
update npc_types npt
join npc_types2 npt2 on (npt.id = npt2.id)
set npt.class = npt2.class
This is my first thought at least. Others may have different suggestions. Also, this wouldn't update any npc ids you have created which do not exist in the 'new' table.

Good luck.
__________________
https://www.project1999.com
Reply With Quote
  #8  
Old 04-25-2019, 08:25 AM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,332
Default

I dumped a default npc_types table and put it up for grabs if you can learn how to source it into your database with heidisql. I still use MySQL database and Navicat to piddle around with my own stuff. Keep in mind, this npc_types table is from a current, updated database (version 9139), and it will drop your old table and create a new default one. You can rename your current one to npc_types_old (or back it up). This has all merc merchants set to class 71. You can download the it here - https://tinyurl.com/y5mk2kpj

I'm not sure why the merc merchant class has never been set in the default peq install, since it does continue to be built on "current live" ?
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 07:58 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