Database:Starting - Revision history

Bolly: example fishing skill

2009-09-28T19:38:09Z

example fishing skill

Bolly at 13:09, 24 September 2009

2009-09-24T13:09:41Z

Bolly: changed to 255

2009-09-23T21:28:22Z

changed to 255

Bolly at 21:26, 23 September 2009

2009-09-23T21:26:52Z

Bolly: added some start_zones info from le's post

2009-09-23T00:41:47Z

added some start_zones info from le's post

New page

== Setting Start zones ==

[http://www.eq2emulator.net/phpBB3/viewtopic.php?f=3&t=10&p=772&hilit=starting+zones#p772 Read LethalEncounters Post]

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 0 and class of 0).

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

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

← Older revision		Revision as of 19:38, 28 September 2009
Line 15:		Line 15:

	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).		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))
		+
		+	<pre>
		+	SELECT id,name FROM skills WHERE name LIKE '%Fishing%';
		+	</pre>
		+	For example: may return ID: 2319450178
		+	<pre>
		+	INSERT INTO starting_skills (skill_id,class_id,race_id,current_val,max_val,progress) VALUES (2319450178,255,255,5,5,0);
		+	</pre>

@@ Line 1: / Line 1: @@
 == Setting Start zones ==
-[http://www.eq2emulator.net/phpBB3/viewtopic.php?f=3&t=10&p=772&hilit=starting+zones#p772 Read LethalEncounters Post]
+[http://www.eq2emulator.net/phpBB3/viewtopic.php?f=63&t=175&p=1692&hilit=starting+zones#p1692 Read LethalEncounters Post]
 *Note* As of 23/09/09 - Racial and Class ID of 255 will match all (not 0/0)

@@ Line 12: / Line 12: @@
 * 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 0. 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 0.
+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).

@@ Line 2: / Line 2: @@
 [http://www.eq2emulator.net/phpBB3/viewtopic.php?f=3&t=10&p=772&hilit=starting+zones#p772 Read LethalEncounters Post]
 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:
@@ Line 8: / Line 10: @@
 * 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 0 and class of 0).
+* 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 0. 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 0.
 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).