How to eliminate fabled spawns, and load certain zones at bootup?

[gnode]

1st issue: I am getting fabled mobs spawning among my regular mobs. I know how to take them out of spawntables one at a time, but does anyone have a query that will set their chance of spawning to 0 across the board so I don't have to do it one by one? I have PEQ.


2nd issue: Some of my zones are having trouble with people porting in and the zone not being ready so they are booted to login screen. Feerrott is the most recent example today. I have the server set to persistent, but that does not necessarily boot up all zones it seems. Is there a way I can flag certain zones to boot with the server and stay up forever?

[So_1337]

As noted in the other thread, I have a bunch of queries that take care of issues like fableds and other things, and I'm more than willing to share. In fact, I just finished sending you a PM with all the details. They should be in the first set I sent, "classic queries".

The second issue sounds two-fold -- In your database, go the launcher table. The second column should hold a number, which is how many dynamic zones. Depending how many people you have on your server, this may need to be adjusted. These are in addition to static zones, which I'll explain thusly:

In the launcher_zones table of your database, you can enter any zones you'd like to run static versions of. I use this typically for raid zones, where I worry about the zone's state being preserved. Let's say for example you wanted to run Lower Guk as a static zone on your progression server.

INSERT INTO launcher_zones VALUES ('zone','gukbottom',0);

Your server will know to do so now that it's in that table. However, there's a second part we must do. If you don't already, I recommend starting your server from a .bat file. This allows you to easily handle all the ways you may want to start your server. Here's mine:

@echo off
start world.exe
cls
Echo Wait for World to finish loading... Press Enter when done.
pause
start eqlaunch.exe zone
start zone.exe templeveeshan
start zone.exe kael
start zone.exe ssratemple
start zone.exe sleeper
start zone.exe akheva
exit
start perl.exe shifts.pl

When I start the server, I get two windows; one that actually boots world.exe and connects to login, and another that simply tells me to press a key once that has completed. When I hit a key, I get six new windows; one for each of the static zones listed there, and one generic one that manages the dynamic zones. (It's usually labled 'sleeping' if nothing is going on.)

So for your script, if you just wanted to run Lower Guk as a static zone, I'd run this as your batch file:

@echo off
start world.exe
cls
Echo Wait for World to finish loading... Press Enter when done.
pause
start eqlaunch.exe zone
start zone.exe gukbottom
exit
start perl.exe shifts.pl

Hope this helps get you going. Reply back with any questions, we're more than happy to help.

[gnode]

I look forward to trying it tonight. Thanks a bunch. You have been very helpful.

Your posts need to go into the wiki.

[gnode]

Ok it looks like my problem with Feerrott is something else. I set it to launch in the launcher along with a dozen other zones. All the other zones worked. I am getting a problem with feerrott still not working.

The only thing I can think of is that I removed the powerful undead from the spawntables in feerrott because they were a nuisance for newbs. Could that have screwed up a script or something that would cause the zone to crash?

Here is the last part of zone-feerrott.log:
[Debug] [RULES__CHANGE] Set rule Zone:EnableMQGateDetector to value true
[Debug] [RULES__CHANGE] Set rule Zone:EnableMQGhostDetector to value true
[Debug] [RULES__CHANGE] Set rule Zone:MQWarpDetectorDistance to value 4900.0000000000000
[Debug] [RULES__CHANGE] Set rule Zone:MQWarpLagThreshold to value 140.0000000000000
[Debug] [RULES__CHANGE] Set rule Zone:MQWarpThresholdTimer to value 90000.0000000000000
[Debug] [RULES__CHANGE] Set rule[Debug] [WORLD__CLIENT] New connection from 72.50.164.134:60852
[Debug] [NET__IDENT_TRACE] 72.50.164.134:60852: First opcode 0x7752 did not match expected 0x2792
[Debug] [NET__IDENT_TRACE] 72.50.164.134:60852: Tried patch 6.2_world, and it did not match.
[Debug] [NET__IDENT_TRACE] 72.50.164.134:60852: First opcode 0x7213 did not match expected 0x2ec9
[Debug] [NET__IDENT_TRACE] 72.50.164.134:60852: Tried patch 6.2_zone, and it did not match.
[Debug] [NET__IDENT_TRACE] 72.50.164.134:60852: First opcode 0x7752 did not match expected 0x4dd0
[Debug] [NET__IDENT_TRACE] 72.50.164.134:60852: Tried patch Titanium_world, and it did not match.
[Debug] [NET__IDENT_TRACE] 72.50.164.134:60852: First opcode matched 0x7213 and length matched 68
[Debug] [NET__IDENTIFY] Identified stream 72.50.164.134:60852 with signature Titanium_zone
[Debug] [WORLD__CLIENT] New client from 72.50.164.134:60852
[Debug] AIYellForHelp("Dar_Guard_Lraktol000","a_water_mocc asin006") #Shin_Master_Grubbus000 attacking a_water_moccasin006 Di

[gnode]

Ok I fixed it. Zone dump table was the problem. When I eliminated those spawns, they got screwed up on the checksum I guess.

[Joetuul]

I found this post while searching for static zones. this was very helpful. thanks So_1337...

[plurt00]

Sorry to drag this old thread up, but I am unable to find a eliminate fabled spawns. Any chance someone has something already put together?

[So_1337]

DELETE FROM npc_types WHERE id = 2148;
DELETE FROM npc_types WHERE id = 12169;
DELETE FROM npc_types WHERE id = 13118;
DELETE FROM npc_types WHERE id = 16034;
DELETE FROM npc_types WHERE id = 18105;
DELETE FROM npc_types WHERE id = 33157;
DELETE FROM npc_types WHERE id = 35163;
DELETE FROM npc_types WHERE id = 37147;
DELETE FROM npc_types WHERE id = 58057;
DELETE FROM npc_types WHERE id = 58058;
DELETE FROM npc_types WHERE id = 63091;
DELETE FROM npc_types WHERE id = 63095;
DELETE FROM npc_types WHERE id = 63096;
DELETE FROM npc_types WHERE id = 63110;
DELETE FROM npc_types WHERE id = 68246;
DELETE FROM npc_types WHERE id = 68249;
DELETE FROM npc_types WHERE id = 69135;
DELETE FROM npc_types WHERE id = 70053;
DELETE FROM npc_types WHERE id = 70069;
DELETE FROM npc_types WHERE id = 107156;
DELETE FROM npc_types WHERE id = 107157;
DELETE FROM npc_types WHERE id = 107158;
DELETE FROM npc_types WHERE id = 107160;
DELETE FROM npc_types WHERE id = 121091;
DELETE FROM npc_types WHERE id = 153148;
DELETE FROM npc_types WHERE id = 153149;
DELETE FROM npc_types WHERE id = 5134;
DELETE FROM npc_types WHERE id = 4199;
DELETE FROM npc_types WHERE id = 14166;
DELETE FROM npc_types WHERE id = 14167;
DELETE FROM npc_types WHERE id = 14168;
DELETE FROM npc_types WHERE id = 15189;
DELETE FROM npc_types WHERE id = 16039;
DELETE FROM npc_types WHERE id = 31140;
DELETE FROM npc_types WHERE id = 31141;
DELETE FROM npc_types WHERE id = 32074;
DELETE FROM npc_types WHERE id = 32075;
DELETE FROM npc_types WHERE id = 32076;
DELETE FROM npc_types WHERE id = 32077;
DELETE FROM npc_types WHERE id = 32078;
DELETE FROM npc_types WHERE id = 32079;
DELETE FROM npc_types WHERE id = 32080;
DELETE FROM npc_types WHERE id = 32081;
DELETE FROM npc_types WHERE id = 32082;
DELETE FROM npc_types WHERE id = 34145;
DELETE FROM npc_types WHERE id = 36099;
DELETE FROM npc_types WHERE id = 36100;
DELETE FROM npc_types WHERE id = 36101;
DELETE FROM npc_types WHERE id = 44105;
DELETE FROM npc_types WHERE id = 44106;
DELETE FROM npc_types WHERE id = 51170;
DELETE FROM npc_types WHERE id = 64098;
DELETE FROM npc_types WHERE id = 64099;
DELETE FROM npc_types WHERE id = 73111;
DELETE FROM npc_types WHERE id = 73112;
DELETE FROM npc_types WHERE id = 79150;
DELETE FROM npc_types WHERE id = 85230;
DELETE FROM npc_types WHERE id = 85231;
DELETE FROM npc_types WHERE id = 85232;
DELETE FROM npc_types WHERE id = 86170;
DELETE FROM npc_types WHERE id = 86171;
DELETE FROM npc_types WHERE id = 89190;
DELETE FROM npc_types WHERE id = 91190;
DELETE FROM npc_types WHERE id = 92189;
DELETE FROM npc_types WHERE id = 92190;
DELETE FROM npc_types WHERE id = 92191;
DELETE FROM npc_types WHERE id = 96350;
DELETE FROM npc_types WHERE id = 96351;
DELETE FROM npc_types WHERE id = 97080;
DELETE FROM npc_types WHERE id = 102127;
DELETE FROM npc_types WHERE id = 102128;
DELETE FROM npc_types WHERE id = 102129;
DELETE FROM npc_types WHERE id = 102130;
DELETE FROM npc_types WHERE id = 102131;
DELETE FROM npc_types WHERE id = 102132;
DELETE FROM npc_types WHERE id = 102133;
DELETE FROM npc_types WHERE id = 105282;
DELETE FROM npc_types WHERE id = 105283;
DELETE FROM npc_types WHERE id = 105284;
DELETE FROM npc_types WHERE id = 105285;
DELETE FROM npc_types WHERE id = 105286;
DELETE FROM npc_types WHERE id = 105287;
DELETE FROM npc_types WHERE id = 105288;
DELETE FROM npc_types WHERE id = 105289;
DELETE FROM npc_types WHERE id = 110116;
DELETE FROM npc_types WHERE id = 110117;
DELETE FROM npc_types WHERE id = 111178;
DELETE FROM npc_types WHERE id = 111179;
DELETE FROM npc_types WHERE id = 111180;
DELETE FROM npc_types WHERE id = 111181;
DELETE FROM npc_types WHERE id = 111182;
DELETE FROM npc_types WHERE id = 111183;
DELETE FROM npc_types WHERE id = 111184;
DELETE FROM npc_types WHERE id = 111185;
DELETE FROM npc_types WHERE id = 111186;
DELETE FROM npc_types WHERE id = 111188;
DELETE FROM npc_types WHERE id = 116600;
DELETE FROM npc_types WHERE id = 118200;
DELETE FROM npc_types WHERE id = 118201;
DELETE FROM npc_types WHERE id = 118202;
DELETE FROM npc_types WHERE id = 118203;
DELETE FROM npc_types WHERE id = 118204;
DELETE FROM npc_types WHERE id = 118205;
DELETE FROM npc_types WHERE id = 121093;
DELETE FROM npc_types WHERE id = 121095;
DELETE FROM npc_types WHERE id = 121096;
DELETE FROM npc_types WHERE id = 121097;
DELETE FROM npc_types WHERE id = 154161;
DELETE FROM npc_types WHERE id = 154162;
DELETE FROM npc_types WHERE id = 154163;
DELETE FROM npc_types WHERE id = 166293;
DELETE FROM npc_types WHERE id = 166294;

The above set of queries will do the trick for you, most definitely. This is written for the most recent PEQ database, revision 946.

Mind you that it's a quick and dirty fix, and that you may wind up with empty spawn points if a fabled mob was meant to spawn instead of the normal version.

[DavenTown]

Sorry to drag this old thread back up but I am having the opposite problem. The fabled mobs show up in my npc_types table but are not in my spawnentry table. Is there a query I can run to add them or do I need to add them manually?

Thanks in advance

[So_1337]

I'd just like to post and say that when I did a search on static zones, I found this thread, and I found my old posts very informative and helpful. Thank you, self. You were most resourceful when it came to re-learning this.