|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Development::GeorgeS's Tools A forum just for GeorgeS's tools |
06-15-2009, 03:52 PM
|
|
Administrator
|
|
Join Date: Sep 2006
Posts: 1,348
|
|
And I even said traps would follow the versioning concept, but hadn't tested it.
|
 |
|
 |
06-17-2009, 02:55 AM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Here's my progress on this beta version -
NPC and Loot Editor
08.22.04 - Incorporated a Zone & Adventure Editor - under special window menu. This is used for Adventure zone copying and also for normal zones
SO, I tested the tool under the PEQ mirc and mmca zones - and it appears to work fine. NPC's are copied as well as spawngroups. There's a function to delete 'old' versions - this will wipe the relevant version NPC, spawngroup,spawn2 and spawnentries. I also tested it for copying a 'normal' zone - such as oasis version '0', and it does it fine.
There's no "special" editing of npc stats yet, and as Trevius mentioned, the version# will be included for editing. version # now appears in the last field in the main window. You can filter out the unwanted versions if you want.
btw - it's a beta still, and things will break if your there's a missmatch between spawnentry,spawn2 and related NPC's. The program has error checking built in, and whenever an error occurs, I found the best thing to do is delete that version, and figure out why it happened.
GeorgeS
Last edited by GeorgeS; 06-17-2009 at 11:00 AM..
|
 |
|
 |
|
|
|
06-17-2009, 08:22 PM
|
 |
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
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.
|
|
|
|
06-17-2009, 09:49 PM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Hi Cavedude, please send me a link to download those related tables that are causing the problem. I'll source these in and take a look.
npc_types
spawngroup
spawnentry
spawn2
I'll know the problem once I take a look at this - and code in fixes.
Thanks
GeorgeS
|
06-17-2009, 10:12 PM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
|
|
|
|
06-18-2009, 12:44 AM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
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 |
|
|
|
06-18-2009, 03:22 AM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Rats, still getting the same exact errors as before. I do however get all OKs on the identify screen. It looks exactly like yours except for the single version. Would you mind sending me your table schema for those 4 tables? That's about the only thing it could be at this point. I reset my auto_increment on spawn2 and spawngroup to no avail, not sure what else it could be.
|
|
|
|
06-18-2009, 10:32 AM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
I exported the schema with drop tables before inserts so you can get an exact copy
cavedude_schema.zip
Since you report the program reported all 30 spawngroups -were linked ok, it most likely must mean an index problem - as in auto-increment is on.
My program looks at the last index then adds 1. Everything created after that uses this index reference, till it's done.
If this method does not work, then a last index method needs to be called each time it tries to write data.
If it still fails using this exact schema, then I think I will have to rewrite the way I query and write indices.
you can quickly check if this works -
Code:
SELECT max(id)+1 as nextrecord FROM spawngroup
use the number from the previous query into the next one - replace the 51963-51965 with the your value, and increment+1
Code:
INSERT INTO spawngroup (id,name) VALUES (51963,"TEST1200");
INSERT INTO spawngroup (id,name) VALUES (51964,"TEST1201");
INSERT INTO spawngroup (id,name) VALUES (51965,"TEST1202");
if it works, then the problem is something else
Thanks for helping,
George
Last edited by GeorgeS; 06-18-2009 at 07:06 PM..
|
|
|
|
06-18-2009, 11:26 AM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Thank you! I've found my problem, but I am not certain why it's an issue. Before, I was connecting to my MySQL 5.0 database that was being served from a Linux box. It didn't work with my schema or yours despite everything being OK. However, once I moved the database to the same box as the editor, it worked perfectly. I'm not certain if it's a Linux/Windows difference, or the editor just doesn't like connecting to a database on a different host. Either way, it's working great now and I can get back to the grind! Thank you very much for this tool, even in its current state it will save me a TON of time!
|
06-18-2009, 09:37 PM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
That's great it works in Windows - I spent a better part of the day working on this and think that differences are capitalization of specific tables. For example "SELECT * FROM Spawnentry" will fail, where "SELECT * FROM spawnentry" should work in Linux. It's fixed in the recent revision.
Anyway - version .07 is the recent one which has more optimisation done.
GeorgeS
|
06-18-2009, 09:58 PM
|
 |
Discordant
|
|
Join Date: Mar 2009
Location: Ottawa
Posts: 495
|
|
Yeah, in linux, everything is case sensitive.
|
06-22-2009, 01:04 PM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Got a chance to try this, it now works perfectly when the DB is hosted on Linux!
|
07-09-2009, 06:15 PM
|
|
Sarnak
|
|
Join Date: Oct 2008
Location: USA
Posts: 92
|
|
When trying to copy I'm getting runtime error 3265 "item cannot be found in the collection corresponding to the requested name or ordinal"
Tried several zones, and getting that everytime.
Any ideas?
|
07-09-2009, 06:27 PM
|
|
Sarnak
|
|
Join Date: Oct 2008
Location: USA
Posts: 92
|
|
Bah sorry can't edit...I just realized I'm getting this error with the latest version of the tool trying to pull up any zones. I'm not completely sure what version I had before(think it was .03) but it was working fine.
|
07-09-2009, 09:50 PM
|
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Sorry, which tool is this for and what part of the tool crashes?
GeorgeS
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 06:14 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Linear Mode
