best bet would be to download the latest db and extract peqdb_rev2022.sql from peqdb_rev2022.sql.gz
next edit the sql file and delete everything except the parts about the npc_types table and save it. delete everything before
CREATE TABLE `npc_types` (
and delete everything after the line that starts:
INSERT INTO `npc_types` VALUES (424028,
also delete this line that's between the table create and the first INSERT
/*!40101 SET character_set_client = @saved_cs_client */;
save the edited file as npcs.sql
now open a command prompt window where you saved that file. Assuming your database is named peq, run these commands
mysql -u root -p
\u peq
drop table npc_types;
source npcs.sql;
You now have a fresh npc_types table.
|