DBEditor:Spells - Revision history

John adams at 00:21, 23 November 2013

2013-11-23T00:21:16Z

John adams: /* Parse Data */

2013-11-20T17:18:01Z

‎Parse Data

John adams at 17:13, 20 November 2013

2013-11-20T17:13:34Z

John adams at 16:56, 20 November 2013

2013-11-20T16:56:53Z

John adams: /* New Spell Editor Layout */

2013-11-20T16:25:33Z

‎New Spell Editor Layout

John adams: /* Spell Selection Grid */

2013-11-20T16:19:33Z

‎Spell Selection Grid

John adams at 16:04, 20 November 2013

2013-11-20T16:04:52Z

Show changes

John adams at 19:59, 12 February 2012

2012-02-12T19:59:14Z

John adams: Replaced content with "(to be continued)"

2012-02-12T19:58:34Z

Replaced content with "(to be continued)"

John adams: moved Spells to DBEditor:Spells

2012-02-09T01:06:07Z

moved Spells to DBEditor:Spells

@@ Line 171: / Line 171: @@
-=== Re-Link Spell ===
+=== Re-Link ===
 This button shows up if the LUA script exists on the drive, but is not linked to the spell in the database. Re-linking merely writes the path to the lua_script field in the spells table.
 == AA Spell Tab ==
 The AA Spell tab is new, and merely a quick lookup of the SOE API data for the AA. Currently it is read-only, but if it is determined we have to change this data, I will add updaters.
 == Conclusion ==
 I'm hoping to make the editor handle more tasks automatically in the future, so we're not doing so much work manually. This is the first step. Also, at the time of this writing, the Spells tab is the only one re-designed - the other tabs still function as they did before.
 Happy Spell Writing :)

@@ Line 138: / Line 138: @@
 === Parse Data ===
 Clicking the Parse Data button will launch a new UI window, and a quick attempt to parse the Spell Display Effects text is displayed in Tier-by-tier format. An example of how parsing works, say the Tier 1 Effect is:
@@ Line 150: / Line 152: @@
 [[File:SpellData2.jpg]]
 == Effects Tab ==

← Older revision		Revision as of 17:13, 20 November 2013
Line 150:		Line 150:

	[[File:SpellData2.jpg]]		[[File:SpellData2.jpg]]
		+
		+
		+	== Effects Tab ==
		+	You generally do not have to do anything with this tab, except maybe fix the values displayed if they are not correct for any reason. This data comes directly from SOE API, and should reflect accurate game data.
		+
		+
		+	== Classes Tab ==
		+	Classes are also derived from the SOE API - though in rare cases they are not very accurate (like all Fighter classes getting Summon Tamed Gator). The SOE API parser attempts to identify spells that ALL archetypes can use, and assign them to the archetype spell_id range (ie., if all 6 fighter classes can use Fighting Chance, it is not set with 6 classes, but 1 Fighter (base) class).
		+
		+	This is not critical, and only necessary to reduce the data redundancy in the database. The spells will work just fine if all 6 classes per archetype are configured.
		+
		+
		+	== Script Tab ==
		+	This is the in-place, live LUA script editor. When you save changes here, they are written directly to the folders of the EQ2 DB Project server for immediate [reload and] testing. They are also marked for submission to the eq2content SVN in the weekly update.
		+
		+	You may use external LUA editors and paste the final script into this dialog, or if you are scripting your own server you can simply drop the LUA file into the proper folder for your world.
		+
		+	'''HOWEVER:''' In order for the LUA script to be attached to the Spell, you need to save/relink it on this dialog.
		+
		+
		+	=== Re-Link Spell ===
		+	This button shows up if the LUA script exists on the drive, but is not linked to the spell in the database. Re-linking merely writes the path to the lua_script field in the spells table.
		+
		+
		+	== AA Spell Tab ==
		+	The AA Spell tab is new, and merely a quick lookup of the SOE API data for the AA. Currently it is read-only, but if it is determined we have to change this data, I will add updaters.

@@ Line 1: / Line 1: @@
 The Spells Editor needed to be redesigned due to the 48,000 or so spells+tiers we're trying to manage, the old filters weren't displaying enough data, and were confusing. In this revamp, I've basically broken down the spells into "filters" based on SOE's '''types and classifications''' system.
-=== Filter: Lookup ===
+== Filter: Lookup ==
 There are two ways to get at the spell data now... one is the Filters listed below, the other is a direct query of the Spell Names via a "Google-like" search suggestion script.
@@ Line 12: / Line 12: @@
-=== Filter: Type ===
+== Filter: Type ==
 The second option is to Filter the data using Type, Classification and Class. When you first select '''Spells''' from the menu, you now must pick a "'''Type'''" - that being Spell, Art, Ability, Tradeskill or PC Innate --
@@ Line 20: / Line 20: @@
-=== Spell Selection Grid ===
+== Spell Selection Grid ==
 [[File:SpellEditor2.jpg|800px]]
@@ Line 40: / Line 40: @@
 You can begin to edit the spell data by clicking the Spell ID value on the left-most column.
-=== Filter: Classification ===
+== Filter: Classification ==
 [[File:SpellEditor3.jpg|800px]]
@@ Line 63: / Line 63: @@
-=== Filter: Class ===
+== Filter: Class ==
 Not to be confused with '''classification''', Class is the actual player class itself -- Guardian, Templar, etc.
@@ Line 78: / Line 78: @@
 There is one ''special'' Class: All. This is a filter to show you all the spells/arts that ALL classes can utilize - and in our EQ2Emulator database, that is signified by the `spell_classes`.`adventure_class_id` = 255, for all classes. This is not a list of ALL spells, so do not be alarmed when you do not see many records. Another term for these might be "Commoner" abilities.
-=== New Spell Editor Layout ===
 I have cleaned up the layout of the Spells Editor tabs, making them actual tabs finally (after 5 years :)). To enter the Spell Editor screen, click the link on the left-most column which is the EQ2Emulator Spell ID column - in the above example, that would be the number '''8018'''.
@@ Line 123: / Line 124: @@
 You then click the "Re-Index" button and the script moves the spell, cleaning up the player and other associated tables to the new ID, then drops you in the editor at the new spell_id.
-=== Conclusion ===
 I'm hoping to make the editor handle more tasks automatically in the future, so we're not doing so much work manually. This is the first step. Also, at the time of this writing, the Spells tab is the only one re-designed - the other tabs still function as they did before.
 Happy Spell Writing :)

@@ Line 91: / Line 91: @@
 . The same old Toggles section, only with added options - is_aa, is_deity, and moved is_active into the toggles
 . Save button
-. If the SOE data has changed, we can re-sync the spell/tier data directly with their list
+. Resync items on this tab with SOE API data
 . '''NEW''' Re-Indexing (see below)
 . '''NEW''' Insert a spell or make a clone of an existing one (currently disabled)
 . '''NEW''' Delete a spell record that is no longer needed
 === Spell Re-Indexing ===

@@ Line 25: / Line 25: @@
 Take note of the information on the Spell Selection Grid:
    Spell ID - this is EQ2Emulator's internal ID for the spell
-   The [S] and [W] icons are shortcuts to SOE Data and Wikia for the given data row
+   The [S], [W] and [Z] icons are shortcuts to SOE Data, Wikia and Zam for the given data row
    Name - the name of the dataset
    Description - I thought it might be helpful to see the full description of the spell, since many are named the same
@@ Line 34: / Line 34: @@
    Active - is the spell available to players? Note: Inactive spells will not load at world start time!
    Last Auto Update - This is the last time we sync'd the entry with soe.data.com
 You can begin to edit the spell data by clicking the Spell ID value on the left-most column.
 === Filter: Classification ===

← Older revision		Revision as of 19:59, 12 February 2012
Line 1:		Line 1:
−	(to be ~~continued~~)	+	[[File:spells.jpg]]
		+
		+
		+
		+
		+	1. '''ID:''' This is the unique ID for your spell. Just choose a number you have not used yet.
		+
		+	2. '''mastery_skill:''' If the spell uses one of the following mastery. [http://eq2.wikia.com/wiki/Category:Spells_by_Mastery] Spell by Mastery Link<br/>Aggression Spells <br/>Disruption Spells <br/>Ministration Spells <br/>Ordination Spells <br/>Subjugation Spells
		+
		+	3. '''interruptable:''' Is the spell able to be interrupted.
		+
		+	4. '''description:''' Gives the player a short description of the spell when the put their mouse over it appears in the upper right corner under spell name.
		+
		+	5. '''name:''' The Name you give your spell. Example : Sprint
		+
		+	6. '''class_skill:'''
		+
		+	7. '''target_type:''' What object you are allowed to cast the spell on.<br/> 0: Self<br/> 1: Enemy<br/> 2: Group (AE)<br/> 3: Caster's Pet<br/> 4: Enemy's Pet<br/> 5: Enemy's Corpse<br/> 6: Group Member's Corpse<br/> 7: Target None<br/> 8: Raid (AE)<br/> 9: Other Group (AE)
		+
		+	8. '''type:''' What type of spell it is. 0: Spells 1: Combat arts 2: Ability 3: Crafting 4: Passive
		+
		+	9. '''Active:''' Shows if there has been a lua script assigned or not
		+
		+	10. '''cast_type:''' <br/>0 = Normal<br/> 1 = Toggle, casting it the first time turns the spell on, casting it a second time turns the spell off.
		+
		+	11. '''spell_book_type:''' What spell category the spell will be scribed in. 0: Spells 1: Combat arts 2: Ability 3: Trade skills 4: Not Shown
		+
		+	12. '''icon:''' This is the top icon and is the icon that will be shown in your spell book
		+
		+	13. '''icon2:''' This is the bottom icon of your spell this will show the icon that is used to make combo's.
		+
		+	14. '''icontype:'''
		+
		+	15. '''spell_visual:''' The visual effect id of the effect you want to see when the spell is cast.
		+
		+	16. '''Lookup Effect:''' This will bring up a list of all the effects
		+
		+	17. '''effect_message:''' This is at the bottom of the spell it say something like. increase speed bye 15% "for every effect listed you must add 1 number to the number of bullets in spell_display_effects
		+
		+	18. '''success_message:''' The message you receive on screen when you successfully cast or receive a spell effect. Example: You begin to sneak.
		+
		+	19. '''fade_message:''' The message you receive when the spell is canceled / wears off. Example: You stop sneaking.
		+
		+	20. '''is_active:''' Set to true when the spell has been tested and ready for live
		+
		+	21. '''duration_until_canceled:''' If set to true spell will last forever till canceled
		+
		+	22. '''can_effect_raid:''' If set to true will effect raid members
		+
		+	23. '''affect_only_group_members:''' If set to true will only effect group members
		+
		+	24. '''display_spell_tier:'''
		+
		+	25. '''friendly_spell:'''
		+
		+	26. '''group_spell:'''

← Older revision		Revision as of 19:58, 12 February 2012
Line 1:		Line 1:
−	~~[[File:spells.jpg]]~~	+	(to be continued)
−
−
−
−
−	~~1. '''ID:''' This is the unique ID for your spell. Just choose a number you have not used yet.~~
−
−	2. '''mastery_skill:''' If the spell uses one of the following mastery. [http://eq2.wikia.com/wiki/Category:Spells_by_Mastery] Spell by Mastery Link<br/>Aggression Spells <br/>Disruption Spells <br/>Ministration Spells <br/>Ordination Spells <br/>Subjugation Spells
−
−	~~3. '''interruptable:''' Is the spell able~~ to be ~~interrupted.~~
−
−	~~4. '''description:''' Gives the player a short description of the spell when the put their mouse over it appears in the upper right corner under spell name.~~
−
−	~~5. '''name:''' The Name you give your spell. Example : Sprint~~
−
−	~~6. '''class_skill:'''~~
−
−	~~7. '''target_type:''' What object you are allowed to cast the spell on.<br/> 0: Self<br/> 1: Enemy<br/> 2: Group (AE~~)~~<br/> 3: Caster's Pet<br/> 4: Enemy's Pet<br/> 5: Enemy's Corpse<br/> 6: Group Member's Corpse<br/> 7: Target None<br/> 8: Raid (AE)<br/> 9: Other Group (AE)~~
−
−	~~8. '''type:''' What type of spell it is. 0: Spells 1: Combat arts 2: Ability 3: Crafting 4: Passive~~
−
−	~~9. '''Active:''' Shows if there has been a lua script assigned or not~~
−
−	~~10. '''cast_type:''' <br/>0 = Normal<br/> 1 = Toggle, casting it the first time turns the spell on, casting it a second time turns the spell off.~~
−
−	~~11. '''spell_book_type:''' What spell category the spell will be scribed in. 0: Spells 1: Combat arts 2: Ability 3: Trade skills 4: Not Shown~~
−
−	~~12. '''icon:''' This is the top icon and is the icon that will be shown in your spell book~~
−
−	~~13. '''icon2:''' This is the bottom icon of your spell this will show the icon that is used to make combo's.~~
−
−	~~14. '''icontype:'''~~
−
−	~~15. '''spell_visual:''' The visual effect id of the effect you want to see when the spell is cast.~~
−
−	~~16. '''Lookup Effect:''' This will bring up a list of all the effects~~
−
−	17. '''effect_message:''' This is at the bottom of the spell it say something like. increase speed bye 15% "for every effect listed you must add 1 number to the number of bullets in spell_display_effects
−
−	~~18. '''success_message:''' The message you receive on screen when you successfully cast or receive a spell effect. Example: You begin to sneak.~~
−
−	~~19. '''fade_message:''' The message you receive when the spell is canceled / wears off. Example: You stop sneaking.~~
−
−	~~20. '''is_active:''' Set to true when the spell has been tested and ready for live~~
−
−	~~21. '''duration_until_canceled:''' If set to true spell will last forever till canceled~~
−
−	~~22. '''can_effect_raid:''' If set to true will effect raid members~~
−
−	~~23. '''affect_only_group_members:''' If set to true will only effect group members~~
−
−	~~24. '''display_spell_tier:'''~~
−
−	~~25. '''friendly_spell:'''~~
−
−	~~26. '''group_spell:'''~~

← Older revision	Revision as of 01:06, 9 February 2012
(No difference)