EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Dynamic zone query (https://www.eqemulator.org/forums/showthread.php?t=30917)

Drahkon 03-28-2010 10:55 PM

Dynamic zone query
 
How do you run more than 5 dynamic zones? I'm running into the issue where zones are unavailable because there is no server to run them on.

I know it's a general question, but my knowledge is limited.

Thanks in advance.

nilbog 03-28-2010 11:57 PM

In your database, check the launcher table. If there is an entry for dynamics, update it from 5 to how many you wanted.

jsr 03-21-2012 08:43 AM

Seems if I set this 25 or higher, people can't connect and I can only connect from the same box. Other users get to char select and then error when logging in.

Something I'm missing?

chrsschb 03-21-2012 10:46 AM

I don't have that issue but if a dynamic zone crashes on my server it will never reboot.

Maceblade 08-05-2012 10:03 PM

Im sorry for the newb question, but im trying to figure out how to open up more than 5 dynamic zones. IDK how to show a list of variable or tables inside mysql bc im very new at this stuff... I was curious if anyone knew of the exact command to punch in or the 'xxxxx:xxxxx'; portion of it. Thanks

Akkadius 08-05-2012 10:05 PM

Quote:

Originally Posted by Maceblade (Post 211504)
Im sorry for the newb question, but im trying to figure out how to open up more than 5 dynamic zones. IDK how to show a list of variable or tables inside mysql bc im very new at this stuff... I was curious if anyone knew of the exact command to punch in or the 'xxxxx:xxxxx'; portion of it. Thanks

Code:

mysql> describe launcher;
+----------+---------------------+------+-----+---------+-------+
| Field    | Type                | Null | Key | Default | Extra |
+----------+---------------------+------+-----+---------+-------+
| name    | varchar(64)        | NO  | PRI |        |      |
| dynamics | tinyint(3) unsigned | NO  |    | 0      |      |
+----------+---------------------+------+-----+---------+-------+
2 rows in set

mysql> select * from launcher;
+------+----------+
| name | dynamics |
+------+----------+
| zone |        5 |
+------+----------+
1 row in set

That is where you set your dynamics.

Maceblade 08-06-2012 03:59 PM

ah very nice now I can see the variables... now with some research I will soon be able to find out how to change it lol... Thanks alot Akk :)

jdoran 08-06-2012 04:32 PM

Writing SQL is needed for changing values from within code. But for stuff like this, the easiest way is to use some sort of SQL front-end, like Navicat.


All times are GMT -4. The time now is 03:45 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.