Hollowshade Moore watch

Angelox · #1 10-21-2007, 08:18 AM

PART ONE

With my last ax_classic update (2j), i have a working Hollowshade Moore zone, not just "working", but actually has part of the on-going tribal wars active, and not all the three tribes are spawned at the same time. I might finish it up one day, but for now, this is what I got.
First thing I had to do, was form the three spawn groups: grimlins, wolves, owlbears. Hollowshade zone id is 166, so NPCs there start with 166 (an_owlbear_bonegrinder is 166039). I wanted the spawngroup, spawnentry spawn2, id's to also fall under 166xxxx -since 1660000-1669999 in all these tables were not used, i set myself to move them there, and further group the numbers into owlbears, grimlins, and wolves. The in-game #spawn commands and the PEQ editor, or any other editor for that matter, always pick up id numbers from the highest number in the table, the 166xxx numbers are probably still available in all the databases, PEQ included - so you can do this with whatever database you have too. I did this, so I could have an organized picture of what i was going to do, and it will also be much easier for anyone else who wants to work on this zone (just have to look for the 166xxxx spawns and npcs).

Code:

UPDATE spawn2 SET id=id+1291864 WHERE (id>=368136 AND id<=368404);
UPDATE spawn2 SET id=id+1282531 WHERE (id>=377738 AND id<=377729);
UPDATE spawn2 SET id=id+1281768 WHERE (id>=378503 AND id<=378549);

UPDATE spawn2 SET spawngroupID=spawngroupID+331999 WHERE (spawngroupID>=1328001 AND spawngroupID<=1328268);
UPDATE spawn2 SET spawngroupID=spawngroupID+226970 WHERE (spawngroupID>=1433299 AND spawngroupID<=1433300);
UPDATE spawn2 SET spawngroupID=spawngroupID-31929767 WHERE (spawngroupID>=33590038 AND spawngroupID<=33590071);

UPDATE spawngroup SET ID=ID+331999 WHERE (ID>=1328001 AND ID<=1328268);
UPDATE spawngroup SET ID=ID+226970 WHERE (ID>=1433299 AND ID<=1433300);
UPDATE spawngroup SET ID=ID-31929767 WHERE (ID>=33590038 AND ID<=33590071);

UPDATE spawnentry SET spawngroupID=spawngroupID+331999 WHERE (spawngroupID>=1328001 AND spawngroupID<=1328268);
UPDATE spawnentry SET spawngroupID=spawngroupID+226970 WHERE (spawngroupID>=1433299 AND spawngroupID<=1433300);
UPDATE spawnentry SET spawngroupID=spawngroupID-31929767 WHERE (spawngroupID>=33590038 AND spawngroupID<=33590071);

This will re-number them to the 166xxxx area
Only thing is, these npc's 33590038-33590071 (the last line), do not exist in the PEQ database, these are named and extras that I added.

You could also just dump/make an SQL of what I did, then source it into the PEQ database, but you'd still have to delete the old spawns if you don't re-number.
But you won't need to, because I'll post an SQL that will update any database, when I'm done with this explanation.

EDIT: there was one spawngroup with all of the NPCs combined - I basically made three copys (two additional) of these spawn groups, then removed the other NPC tribes leaving one outstanding tribe. After that, I renumbered the extra copies with the new spawngroups and and set them to spawn with assigned _condition values, so they would spawn when needed.
MORE TO COME