Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::GeorgeS's Tools

Development::GeorgeS's Tools A forum just for GeorgeS's tools

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 11:43 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3