Thanks for working on this tool!
Unfortunately, I've run into a problem. Whenever I work on a new instance, I wipe spawn2, spawnentry, spawngroup, and npc_types so the only data in those tables are the zone I am currently working on. In this case, I have 30 npc_types (all set to version 1), 30 spawngroup entries, 30 spawnentries, and 120 spawn2 entries (all version 1.) The version populates fine in-game, and I am seeing 120 spawnpoints all properly placed.
Identify reports:
Code:
Version -- 1 exists with 30 NPC'S
Next, How Many Spawngroups (SPAWN2--ref, duplicates exist) Exists PER Version?
Version# -- SpawnGroup Count
1 120
Anyway, I change the New Version # to 2, and hit Start Process. I get "Error in Spawngroup Table. Looks like a reference lookup error." and then "Error in Spawn2 Table. Looks like a reference lookup error." Here is the output:
Code:
Copied NPCid: 248006 To New id: 248112
Copied NPCid: 248009 To New id: 248113
Copied NPCid: 248028 To New id: 248114
Copied NPCid: 248035 To New id: 248115
Copied NPCid: 248050 To New id: 248116
Copied NPCid: 248056 To New id: 248117
Copied NPCid: 248078 To New id: 248118
Copied NPCid: 248080 To New id: 248119
Copied NPCid: 248083 To New id: 248120
Copied NPCid: 248087 To New id: 248121
Copied NPCid: 248092 To New id: 248122
Copied NPCid: 248093 To New id: 248123
Copied NPCid: 248094 To New id: 248124
Copied NPCid: 248095 To New id: 248125
Copied NPCid: 248096 To New id: 248126
Copied NPCid: 248097 To New id: 248127
Copied NPCid: 248098 To New id: 248128
Copied NPCid: 248099 To New id: 248129
Copied NPCid: 248100 To New id: 248130
Copied NPCid: 248101 To New id: 248131
Copied NPCid: 248102 To New id: 248132
Copied NPCid: 248103 To New id: 248133
Copied NPCid: 248104 To New id: 248134
Copied NPCid: 248105 To New id: 248135
Copied NPCid: 248106 To New id: 248136
Copied NPCid: 248107 To New id: 248137
Copied NPCid: 248108 To New id: 248138
Copied NPCid: 248109 To New id: 248139
Copied NPCid: 248110 To New id: 248140
Copied NPCid: 248111 To New id: 248141
CREATING SPAWNGROUPS..
CREATING SPAWN2 entries..
CREATING SPAWNENTRY..
Spawnentry table: field spawngroupID: 51902: -- Previous NPCid: 51902 now becomes NPCid: 248122
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248121
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248123
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248124
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248125
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248126
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248141
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248127
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248117
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248128
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248129
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248130
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248114
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248120
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248131
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248115
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248119
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248132
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248133
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248134
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248135
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248113
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248136
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248112
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248137
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248118
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248138
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248116
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248140
Spawnentry table: field spawngroupID: 0: -- Previous NPCid: 0 now becomes NPCid: 248139
ALL COMPLETED!
The NPCs all copy beautifully. I see 30 new spawnentry entries, 1 for each NPC created. Only the first gets assigned a spawngroupid, which is correctly the next available spawngroup id. The rest are left at 0. No spawngroups or spawn2 entries are created/copied. I'm not sure what could be wrong as the DB is as basic as we can get. If you want, I can post my DB tables to help troubleshoot.