View Single Post
  #21  
Old 06-18-2009, 12:44 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Ok, I wiped
npc_types
spawngroup
spawnentry
spawn2

then sourced in your 4 tables in the zip - that went fine.
With the most recent version of the tool, there's a great deal of debugging built in - Your mmcd zone version 1 will show the following -
(I made the version 2 with the tool)

Code:
Version -- 1 exists with 30 NPC'S 
Version -- 2 exists with 30 NPC'S 

Next, How Many Spawngroups (SPAWN2--ref, duplicates exist) Exists PER Version?
Version# -- SpawnGroup Count
1	120
2	120

-------------------------------------------------------------------
Next, Showing Link Integrity for Spawngroups in Spawngroup and Spawnentry
Anytime you see MISSING! anywhere means a spawngroup is missing for that table
Ultimately the ideal scenerio is to see all OK
Tool will not work right when missing links exist!
-------------------------------------------------------------------
Spawn2 Spawngroup ok:51872	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51873	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51874	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51875	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51876	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51877	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51878	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51879	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51880	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51881	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51882	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51883	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51884	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51885	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51886	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51887	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51888	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51889	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51890	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51891	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51892	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51893	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51894	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51895	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51896	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51897	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51898	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51899	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51900	 -- Spawngroup: OK 	 Spawnentry: OK 
Spawn2 Spawngroup ok:51901	 -- Spawngroup: OK 	 Spawnentry: OK 
-------------------------------------------------------------------
It Appears With this [ZONE and Version#], the tool should work fine
End of Report

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..
Copied SpawngroupID: 51872 To New id: 51902
Copied SpawngroupID: 51873 To New id: 51903
Copied SpawngroupID: 51874 To New id: 51904
Copied SpawngroupID: 51875 To New id: 51905
Copied SpawngroupID: 51876 To New id: 51906
Copied SpawngroupID: 51877 To New id: 51907
Copied SpawngroupID: 51878 To New id: 51908
Copied SpawngroupID: 51879 To New id: 51909
Copied SpawngroupID: 51880 To New id: 51910
Copied SpawngroupID: 51881 To New id: 51911
Copied SpawngroupID: 51882 To New id: 51912
Copied SpawngroupID: 51883 To New id: 51913
Copied SpawngroupID: 51884 To New id: 51914
Copied SpawngroupID: 51885 To New id: 51915
Copied SpawngroupID: 51886 To New id: 51916
Copied SpawngroupID: 51887 To New id: 51917
Copied SpawngroupID: 51888 To New id: 51918
Copied SpawngroupID: 51889 To New id: 51919
Copied SpawngroupID: 51890 To New id: 51920
Copied SpawngroupID: 51891 To New id: 51921
Copied SpawngroupID: 51892 To New id: 51922
Copied SpawngroupID: 51893 To New id: 51923
Copied SpawngroupID: 51894 To New id: 51924
Copied SpawngroupID: 51895 To New id: 51925
Copied SpawngroupID: 51896 To New id: 51926
Copied SpawngroupID: 51897 To New id: 51927
Copied SpawngroupID: 51898 To New id: 51928
Copied SpawngroupID: 51899 To New id: 51929
Copied SpawngroupID: 51900 To New id: 51930
Copied SpawngroupID: 51901 To New id: 51931
CREATING SPAWN2 entries..
Spawn2.id: 65926--added spawngroupID: 51902
Spawn2.id: 65927--added spawngroupID: 51902
Spawn2.id: 65928--added spawngroupID: 51902
Spawn2.id: 65929--added spawngroupID: 51902
Spawn2.id: 65930--added spawngroupID: 51903
Spawn2.id: 65931--added spawngroupID: 51903
Spawn2.id: 65932--added spawngroupID: 51903
Spawn2.id: 65933--added spawngroupID: 51903
Spawn2.id: 65934--added spawngroupID: 51903
Spawn2.id: 65935--added spawngroupID: 51903
Spawn2.id: 65936--added spawngroupID: 51903
Spawn2.id: 65937--added spawngroupID: 51903
Spawn2.id: 65938--added spawngroupID: 51903
Spawn2.id: 65939--added spawngroupID: 51903
Spawn2.id: 65940--added spawngroupID: 51903
Spawn2.id: 65941--added spawngroupID: 51903
Spawn2.id: 65942--added spawngroupID: 51903
Spawn2.id: 65943--added spawngroupID: 51903
Spawn2.id: 65944--added spawngroupID: 51903
Spawn2.id: 65945--added spawngroupID: 51903
Spawn2.id: 65946--added spawngroupID: 51903
Spawn2.id: 65947--added spawngroupID: 51904
Spawn2.id: 65948--added spawngroupID: 51904
Spawn2.id: 65949--added spawngroupID: 51904
Spawn2.id: 65950--added spawngroupID: 51904
Spawn2.id: 65951--added spawngroupID: 51904
Spawn2.id: 65952--added spawngroupID: 51905
Spawn2.id: 65953--added spawngroupID: 51905
Spawn2.id: 65954--added spawngroupID: 51906
Spawn2.id: 65955--added spawngroupID: 51906
Spawn2.id: 65956--added spawngroupID: 51906
Spawn2.id: 65957--added spawngroupID: 51906
Spawn2.id: 65958--added spawngroupID: 51906
Spawn2.id: 65959--added spawngroupID: 51906
Spawn2.id: 65960--added spawngroupID: 51907
Spawn2.id: 65961--added spawngroupID: 51907
Spawn2.id: 65962--added spawngroupID: 51907
Spawn2.id: 65963--added spawngroupID: 51907
Spawn2.id: 65964--added spawngroupID: 51908
Spawn2.id: 65965--added spawngroupID: 51909
Spawn2.id: 65966--added spawngroupID: 51909
Spawn2.id: 65967--added spawngroupID: 51909
Spawn2.id: 65968--added spawngroupID: 51909
Spawn2.id: 65969--added spawngroupID: 51910
Spawn2.id: 65970--added spawngroupID: 51910
Spawn2.id: 65971--added spawngroupID: 51910
Spawn2.id: 65972--added spawngroupID: 51910
Spawn2.id: 65973--added spawngroupID: 51910
Spawn2.id: 65974--added spawngroupID: 51910
Spawn2.id: 65975--added spawngroupID: 51910
Spawn2.id: 65976--added spawngroupID: 51910
Spawn2.id: 65977--added spawngroupID: 51911
Spawn2.id: 65978--added spawngroupID: 51911
Spawn2.id: 65979--added spawngroupID: 51911
Spawn2.id: 65980--added spawngroupID: 51911
Spawn2.id: 65981--added spawngroupID: 51911
Spawn2.id: 65982--added spawngroupID: 51911
Spawn2.id: 65983--added spawngroupID: 51912
Spawn2.id: 65984--added spawngroupID: 51912
Spawn2.id: 65985--added spawngroupID: 51913
Spawn2.id: 65986--added spawngroupID: 51913
Spawn2.id: 65987--added spawngroupID: 51913
Spawn2.id: 65988--added spawngroupID: 51914
Spawn2.id: 65989--added spawngroupID: 51914
Spawn2.id: 65990--added spawngroupID: 51914
Spawn2.id: 65991--added spawngroupID: 51915
Spawn2.id: 65992--added spawngroupID: 51915
Spawn2.id: 65993--added spawngroupID: 51915
Spawn2.id: 65994--added spawngroupID: 51915
Spawn2.id: 65995--added spawngroupID: 51915
Spawn2.id: 65996--added spawngroupID: 51915
Spawn2.id: 65997--added spawngroupID: 51916
Spawn2.id: 65998--added spawngroupID: 51916
Spawn2.id: 65999--added spawngroupID: 51916
Spawn2.id: 66000--added spawngroupID: 51916
Spawn2.id: 66001--added spawngroupID: 51916
Spawn2.id: 66002--added spawngroupID: 51916
Spawn2.id: 66003--added spawngroupID: 51917
Spawn2.id: 66004--added spawngroupID: 51917
Spawn2.id: 66005--added spawngroupID: 51917
Spawn2.id: 66006--added spawngroupID: 51917
Spawn2.id: 66007--added spawngroupID: 51918
Spawn2.id: 66008--added spawngroupID: 51918
Spawn2.id: 66009--added spawngroupID: 51919
Spawn2.id: 66010--added spawngroupID: 51919
Spawn2.id: 66011--added spawngroupID: 51919
Spawn2.id: 66012--added spawngroupID: 51919
Spawn2.id: 66013--added spawngroupID: 51919
Spawn2.id: 66014--added spawngroupID: 51919
Spawn2.id: 66015--added spawngroupID: 51920
Spawn2.id: 66016--added spawngroupID: 51921
Spawn2.id: 66017--added spawngroupID: 51922
Spawn2.id: 66018--added spawngroupID: 51922
Spawn2.id: 66019--added spawngroupID: 51922
Spawn2.id: 66020--added spawngroupID: 51922
Spawn2.id: 66021--added spawngroupID: 51922
Spawn2.id: 66022--added spawngroupID: 51923
Spawn2.id: 66023--added spawngroupID: 51923
Spawn2.id: 66024--added spawngroupID: 51923
Spawn2.id: 66025--added spawngroupID: 51923
Spawn2.id: 66026--added spawngroupID: 51924
Spawn2.id: 66027--added spawngroupID: 51924
Spawn2.id: 66028--added spawngroupID: 51924
Spawn2.id: 66029--added spawngroupID: 51924
Spawn2.id: 66030--added spawngroupID: 51924
Spawn2.id: 66031--added spawngroupID: 51924
Spawn2.id: 66032--added spawngroupID: 51924
Spawn2.id: 66033--added spawngroupID: 51924
Spawn2.id: 66034--added spawngroupID: 51925
Spawn2.id: 66035--added spawngroupID: 51925
Spawn2.id: 66036--added spawngroupID: 51925
Spawn2.id: 66037--added spawngroupID: 51926
Spawn2.id: 66038--added spawngroupID: 51927
Spawn2.id: 66039--added spawngroupID: 51927
Spawn2.id: 66040--added spawngroupID: 51927
Spawn2.id: 66041--added spawngroupID: 51928
Spawn2.id: 66042--added spawngroupID: 51929
Spawn2.id: 66043--added spawngroupID: 51929
Spawn2.id: 66044--added spawngroupID: 51930
Spawn2.id: 66045--added spawngroupID: 51931
CREATING SPAWNENTRY..
Spawnentry table: field spawngroupID: 51902:  -- Previous NPCid: 248092 now becomes NPCid: 248122
Spawnentry table: field spawngroupID: 51903:  -- Previous NPCid: 248087 now becomes NPCid: 248121
Spawnentry table: field spawngroupID: 51904:  -- Previous NPCid: 248093 now becomes NPCid: 248123
Spawnentry table: field spawngroupID: 51905:  -- Previous NPCid: 248094 now becomes NPCid: 248124
Spawnentry table: field spawngroupID: 51906:  -- Previous NPCid: 248095 now becomes NPCid: 248125
Spawnentry table: field spawngroupID: 51907:  -- Previous NPCid: 248096 now becomes NPCid: 248126
Spawnentry table: field spawngroupID: 51908:  -- Previous NPCid: 248111 now becomes NPCid: 248141
Spawnentry table: field spawngroupID: 51909:  -- Previous NPCid: 248097 now becomes NPCid: 248127
Spawnentry table: field spawngroupID: 51910:  -- Previous NPCid: 248056 now becomes NPCid: 248117
Spawnentry table: field spawngroupID: 51911:  -- Previous NPCid: 248098 now becomes NPCid: 248128
Spawnentry table: field spawngroupID: 51912:  -- Previous NPCid: 248099 now becomes NPCid: 248129
Spawnentry table: field spawngroupID: 51913:  -- Previous NPCid: 248100 now becomes NPCid: 248130
Spawnentry table: field spawngroupID: 51914:  -- Previous NPCid: 248028 now becomes NPCid: 248114
Spawnentry table: field spawngroupID: 51915:  -- Previous NPCid: 248083 now becomes NPCid: 248120
Spawnentry table: field spawngroupID: 51916:  -- Previous NPCid: 248101 now becomes NPCid: 248131
Spawnentry table: field spawngroupID: 51917:  -- Previous NPCid: 248035 now becomes NPCid: 248115
Spawnentry table: field spawngroupID: 51918:  -- Previous NPCid: 248080 now becomes NPCid: 248119
Spawnentry table: field spawngroupID: 51919:  -- Previous NPCid: 248102 now becomes NPCid: 248132
Spawnentry table: field spawngroupID: 51920:  -- Previous NPCid: 248103 now becomes NPCid: 248133
Spawnentry table: field spawngroupID: 51921:  -- Previous NPCid: 248104 now becomes NPCid: 248134
Spawnentry table: field spawngroupID: 51922:  -- Previous NPCid: 248105 now becomes NPCid: 248135
Spawnentry table: field spawngroupID: 51923:  -- Previous NPCid: 248009 now becomes NPCid: 248113
Spawnentry table: field spawngroupID: 51924:  -- Previous NPCid: 248106 now becomes NPCid: 248136
Spawnentry table: field spawngroupID: 51925:  -- Previous NPCid: 248006 now becomes NPCid: 248112
Spawnentry table: field spawngroupID: 51926:  -- Previous NPCid: 248107 now becomes NPCid: 248137
Spawnentry table: field spawngroupID: 51927:  -- Previous NPCid: 248078 now becomes NPCid: 248118
Spawnentry table: field spawngroupID: 51928:  -- Previous NPCid: 248108 now becomes NPCid: 248138
Spawnentry table: field spawngroupID: 51929:  -- Previous NPCid: 248050 now becomes NPCid: 248116
Spawnentry table: field spawngroupID: 51930:  -- Previous NPCid: 248110 now becomes NPCid: 248140
Spawnentry table: field spawngroupID: 51931:  -- Previous NPCid: 248109 now becomes NPCid: 248139
ALL COMPLETED!
Let me know if this version helps, or if you get different debug data

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote