EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Starting Zones. (https://www.eqemulator.org/forums/showthread.php?t=37290)

Kingly_Krab 09-15-2013 03:34 PM

Starting Zones.
 
Okay, so in starting_items you can put Race 0 for all Races, can you do the same in start_zones and make everyone go to the same place rather than updating multiple fields, just have one entry rather than 411?

Starting items for all Races, Classes, and Deities.
Code:

mysql> SELECT * FROM starting_items;
+----+------+-------+---------+--------+--------+--------------+----+------+
| id | race | class | deityid | zoneid | itemid | item_charges | gm | slot |
+----+------+-------+---------+--------+--------+--------------+----+------+
|  1 |    0 |    0 |      0 |      0 |  17403 |            1 |  0 |  -1 |
|  2 |    0 |    0 |      0 |      0 |  17403 |            1 |  0 |  -1 |
|  3 |    0 |    0 |      0 |      0 |  17403 |            1 |  0 |  -1 |
|  4 |    0 |    0 |      0 |      0 |  17403 |            1 |  0 |  -1 |
|  5 |    0 |    0 |      0 |      0 |  17403 |            1 |  0 |  -1 |
|  6 |    0 |    0 |      0 |      0 |  17403 |            1 |  0 |  -1 |
|  7 |    0 |    0 |      0 |      0 |  17403 |            1 |  0 |  -1 |
|  8 |    0 |    0 |      0 |      0 |  17403 |            1 |  0 |  -1 |
+----+------+-------+---------+--------+--------+--------------+----+------+
8 rows in set (0.00 sec)

Could I not do this?
Code:

mysql> SELECT * FROM start_zones;
+---+---+---+---------+---------+---------+---------------+--------------+------
--------+-------------+------------+--------+--------+--------+-------------+
| x | y | z | heading | zone_id | bind_id | player_choice | player_class | playe
r_deity | player_race | start_zone | bind_x | bind_y | bind_z | select_rank |
+---+---+---+---------+---------+---------+---------------+--------------+------
--------+-------------+------------+--------+--------+--------+-------------+
| 0 | 0 | 0 |      0 |      0 |      0 |            0 |            0 |
      0 |          0 |          1 |      0 |      0 |      0 |          50 |
+---+---+---+---------+---------+---------+---------------+--------------+------
--------+-------------+------------+--------+--------+--------+-------------+
1 row in set (0.00 sec)


rencro 09-15-2013 04:41 PM

You cold use this route instead, not sure if its the "efficient" answer you're looking for..

Code:

INSERT INTO `variables` (`varname`,`value`,`information`) VALUES
('startzone','tutorialb','Setting default Startzone for all clients and races to TutorialB');

If you just want to send everybody...

Kingly_Krab 09-15-2013 04:54 PM

Not exactly what I was looking for, however I'll just do an UPDATE query to do it almost instantaneously, thanks anyway.

HnathBST 09-15-2013 07:56 PM

Yeah just do:
Code:

UPDATE start_zones SET ZONE_id = 202, x=1, y = 1, z=1 WHERE 1
Just set the zone and cords correctly... The where 1 will update all.

If you do try setting all races/deities to 0 post your results. I'm curious.

Setting the tutorial zone keeps the 'Entering glooming deep...'


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

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