Zones, Mobs, and Database editing.

[rameho2433]

Hi there.

I've just started working on a new server, as a bit of a side project for now. I'm learning as i go along, so I'm a noob or whatever.

My question is this.

I am running the most current PEQ database. There are zones that I want to customize, I have a Mysql frontend, and I understand most of the table editing to an extent, but this one's got me a little stumped.

Most of the zones are populated in some way. I'm looking to wipe these spawn groups and spawn the zone from scratch.

I understand how to spawn NPC's..... but how do I effectively wipe the current spawns from a zone permanently?

Thanks in advance.

[Dr Zauis]

I dont think I would dare to do that..
I would just use #npcedit and edit the existing spawns..I was planning on using ax_peq for my database but I decided to hand spawn many zones so I went with the old 6.6 database from the last server pack. It has no spawns above pok..But if anyone has done it and thinks its safe to delete spawns please reply..

EDIT>>>Thats the peq6.6 version Im using..Not cavedudes.

[rameho2433]

yeah. i could do that I suppose. but one of the zones in question is stillmoona


and for some reason, its......overspawned. its crawling with mobs. I'd have to make some of them go away somehow for it to be effective. i've been to stillmoona on live, and its not spawned like that, so i need to find a way to tone it down a little bit.

[cavedude]

Run the following queries, replace 279 with the proper zone ID, and abysmal with the proper zone name. This applies to the larger IDs... In this example Abysmal is ID 279, so the ranges are 278999-280000. If you wanted to delete Misty which is ID 33, the range would be 32999-34000, and so forth.

delete from grid where zoneid='279';
delete from grid_entries where zoneid='279';
delete from spawn2 where zone='abysmal';
delete from spawngroup where id >'278999' and id <'280000';
delete from spawnentry where npcid >'278999' and npcid <'280000';
delete from npc_types where id >'278999' and id <'280000';
delete from merchantlist where merchantid >'278999' and merchantid <'280000';

If you want to keep the NPCs, obviously you'd omit npc_types and ideally, merchantlist.

[Dr Zauis]

OK..So if thats all there is to it. Then Im going to try to learn some more mysql and try to figure how to transfer spawns from one DB to a DB without spawns in that zone.
Thanks Cavedude!

EDIT>>> BTW..Here is where Im learning SQL from:
http://www.w3schools.com/sql/

[rameho2433]

Thanks guys, you've been a great help!

[GeorgeS]

...and there are tools developed by several people that do these exact things.


GeorgeS

[Dr Zauis]

OK GeorgeS..Ill check the tools out that you made. I just totally forgot..I remember when Angelox was making his DB some-one made a tool to merge peq and Cavedudes so I guess it was you..I didnt have time then to check it out but I will...Thanks!