Can anyone point me to where I can find out how to set up static zones?

[provocating]

Things have not changed on how to do them. Beware though, static zones can actually be a problem I have found, some zones not as much as other. After days of a running a static zone I have noticed NPC's run out of unique names and quest issues like uninitialized values. It might be better to just set the shutdown delay of the zone to a high value, like an hour or two.

[moltke24]

Originally Posted by provocating

Things have not changed on how to do them. Beware though, static zones can actually be a problem I have found, some zones not as much as other. After days of a running a static zone I have noticed NPC's run out of unique names and quest issues like uninitialized values. It might be better to just set the shutdown delay of the zone to a high value, like an hour or two.

is there a formal instruction post on how to set up static zones or setting up shutdown delays or do i just have to read through all the posts until i can put all the pieces together to get a general understanding of what im doing

[provocating]

If you look at the zone table, notice a shutdowndelay column.

[moltke24]

Originally Posted by provocating

If you look at the zone table, notice a shutdowndelay column.

ya i think that's where im running into trouble, everyone keeps referencing this table and I'm not sure where that is at.

[provocating]

In your database?

[moltke24]

Originally Posted by provocating

In your database?

to access my database do i need to go to cmd prompt and type in peq something?

I remember my password and such but don't remember the log in command... I don't really know how to get to the database...

Nvm found the command: mysql -uroot -p peq, now once i have access to mysql is this where i get into the database?

[vithmiris]

Use HeidiSQL (http://www.heidisql.com/) or get the PEQDB editor setup on your box; this will make your life a lot easier.

[provocating]

Originally Posted by moltke24

ya i think that's where im running into trouble, everyone keeps referencing this table and I'm not sure where that is at.

Using HeidiSQL you could run this query and it will set the zones for hybrid static with a 30 minute timer. Double it for an hour....

-- Hybrid static zones
UPDATE `zone` SET `shutdowndelay` = '1800000'; -- 30 minutes

[moltke24]

Originally Posted by provocating

Using HeidiSQL you could run this query and it will set the zones for hybrid static with a 30 minute timer. Double it for an hour....

-- Hybrid static zones
UPDATE `zone` SET `shutdowndelay` = '1800000'; -- 30 minutes

So when i get on heidisql

i go to querey paste in
UPDATE `zone` SET `shutdowndelay` = '1800000';

and type each zone for the word "zone"
if this is the case is there a way to do all zones at once?

[provocating]

No, that query will get every single zone.

Yes, paste that in the query, make sure you have your database selected before you run it.

[demonstar55]

Originally Posted by provocating

Things have not changed on how to do them. Beware though, static zones can actually be a problem I have found, some zones not as much as other. After days of a running a static zone I have noticed NPC's run out of unique names and quest issues like uninitialized values. It might be better to just set the shutdown delay of the zone to a high value, like an hour or two.

All zones should be able to be run as static (except for instances, which are by definition, not static) and if they can't, they should be considered broken and reported :P

[provocating]

Originally Posted by demonstar55

All zones should be able to be run as static (except for instances, which are by definition, not static) and if they can't, they should be considered broken and reported :P

I did, here.

http://www.eqemulator.org/forums/showthread.php?t=37379