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 :(

What is the normal merchant?

It's on the list.

41 Shopkeeper

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?

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

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...

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.

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" ? ;)