Database:Starting
Setting Start zones
- Note* As of 23/09/09 - Racial and Class ID of 255 will match all (not 0/0)
You will need to update the starting_zones table to do what you are trying to do. All the starting tables allow you to set defaults for class_id and race_id. Here is how it works:
- 1. Starts off trying to match the exact class_id and race_id of a character.
- 2. If no match, then it tries to match the class of the character.
- 3. If no match, then it tries to match the race of the character.
- 4. If no match, then it uses the default (race of 255 and class of 255).
If you want everyone to start in antonica, then you would set the zone_id to 12 (antonica's zone id) and race_id and class_id to 255. If you want only Fae to start in gfaydark you would set the zone_id to 114 and the race_id to 16 and leave class_id as 255.
This is similar to the other starting tables except all starting tables except starting_zones are inclusive (more than one condition can match like both class/race specific starting items and default starting items given to all characters).
Setting Start Skills
To allow players to fish and such they will need to the starting skill in starting_skills table
Example
This adds fishing to new players (all races (255) all classes (255))
SELECT id,name FROM skills WHERE name LIKE '%Fishing%';
For example: may return ID: 2319450178
INSERT INTO starting_skills (skill_id,class_id,race_id,current_val,max_val,progress) VALUES (2319450178,255,255,5,5,0);