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

[moltke24]

I've been looking around and found tons posts that are 4 years old and such, so I was just wondering if someone could link me a place where I can read up on 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?

[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

[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 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

[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.

[moltke24]

Originally Posted by 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.

when you are refering to database, the data base contains
information_chema
mysql
peq
test

So i select the tab that contains all of those and then hit run for the query i just pasted in?

and if that's the case do i need to save it or anything or will it automatically save the changes once i exit heidisql

[moltke24]

i think its working!!! thank you so much in guiding me through all that!

(you're awsome )