hel please on npc types

[nilbog]

https://github.com/EQEmu/Server/wiki/Class-List

[Dryamzord01]

What is the normal merchant?

[nilbog]

It's on the list.

41 Shopkeeper

[Dryamzord01]

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?

[Dryamzord01]

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

[nilbog]

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

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.