Starting Zones.

[Kingly_Krab]

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.

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?

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]

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

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]

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

[HnathBST]

Yeah just do:

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