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)