EQ2Emulator - User contributions [en]

Spell data

2011-12-08T00:17:01Z

Xinux:

[[File:spell_data.jpg]]

1: '''spell_id:'''

2. '''tier:'''

3. '''index_field:''' index_field is the order of the parameters for the given tier of thespell. inside the LUA, the function has 5 params... 0 - 4. that's the order to pass them to LUA.

4. '''value_type:'''

5. '''value:''' value is the value of the parameter. like if index_field 0 was"healAmt" in LUA, the value 5 would be the amount to heal inside the script.

6. '''value2:''' Unused at this time

7. '''Parse Data:'''

Added Notes
also, there should only be 1 index_field 0 per tier.

Spell data

2011-12-08T00:14:05Z

Xinux:

[[File:spell_data.jpg]]

1: '''spell_id:'''

2. '''tier:'''

3. '''index_field:'''

4. '''value_type:'''

5. '''value:'''

6. '''value2:''' Unused at this time

7. '''Parse Data:'''

Spell script

2011-09-24T19:04:14Z

Xinux:

[[File:spell_script.jpg]]

'''Will have examples of various scripts.'''

Spell classes

2011-09-24T19:03:32Z

Xinux:

[[File:spell_classes.jpg]]

1. '''spell_id:'''

2. '''adventure_class_id:'''

3. '''tradeskill_class_id:'''

4. '''level:'''

Spell display effects

2011-09-24T19:03:02Z

Xinux:

[[File:spell_display_effects.jpg]]

1. '''spell_id:'''

2. '''tier:'''

3. '''percentage:'''

4. '''description:'''

5. '''bullet:'''

Spell data

2011-09-24T19:02:30Z

Xinux:

[[File:spell_data.jpg]]

1: '''spell_id:'''

2. '''tier:'''

3. '''index_field:'''

4. '''value_type:'''

5. '''value:'''

6. '''value2:'''

7. '''Parse Data:'''

Spell tiers

2011-09-24T19:01:45Z

Xinux:

[[File:spell_tiers.jpg]]

1. '''ID:''' This is the unique ID for your spell. Just choose a number you have not used yet.

2: '''hp_req:''' Required HP in order to attempt to cast the spell.

3. '''power_req:''' Required Power in order to attempt to cast the spell.

4. '''req_concentration:''' How much concentration you need in order to cast the spell.

5. '''cast_time:''' how long it takes to cast the spell (100 = 1 sec)

6. '''radius:''' How far in meters away from the current target the spell will affect.

7. '''duration1:''' Minimum length of the spell duration.

8. '''spell_id:''' ID of the spell that is being used for

9. '''hp_req_percent:''' The % of HP you need remaining in order to cast the spell.

10. '''power_reg_percent:''' The % of power you need remaining in order to cast the spell.

11. '''recovery:''' Shows recovery in the spell I am unsure of what this does. (time in hundredths of a second.) 1,0000 = 10 seconds.

12. '''max_aoe_targets:''' when the radius is greater than 0 the max number of targets the spell will affect.

13. '''duration2:''' Maximum length of the spell duration.

14: '''tier:''' Select which tier this is for.

15. '''hp_upkeep:'''

16. '''power_upkeep:''' How much it costs to keep the spell going. Example: I cast sprint for 8 power and I set my cast time to 6 I would have to pay 8 power every 6 seconds to keep the buff going. Cast_Time: How long before you must pay the spells upkeep (time in seconds)

17. '''resistbility:''' Chance of target resisting the spell.

18. '''recast:''' How long before you can recast your spell after it ends.

19. '''range:''' How far away the target can be from the caster in meters.

20. '''unknown9:'''

21. '''hit_bonus:'''

22. '''call_frequency:'''

23. '''min_range:'''

DBEditor:Spells

2011-09-24T19:01:08Z

Xinux:

[[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 Aggression Spells Disruption Spells Ministration Spells Ordination Spells 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. 0: Self 1: Enemy 2: Group (AE) 3: Caster's Pet 4: Enemy's Pet 5: Enemy's Corpse 6: Group Member's Corpse 7: Target None 8: Raid (AE) 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:''' 0 = Normal 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:'''

File:Spell classes.jpg

2011-09-24T19:00:25Z

Xinux:

File:Spell data.jpg

2011-09-24T19:00:12Z

Xinux:

File:Spell display effects.jpg

2011-09-24T18:59:57Z

Xinux:

File:Spell script.jpg

2011-09-24T18:59:38Z

Xinux:

File:Spell tiers.jpg

2011-09-24T18:59:20Z

Xinux:

File:Spells.jpg

2011-09-24T18:57:27Z

Xinux:

Spell script

2011-09-24T17:50:58Z

Xinux: Created page with "'''Will have examples of various scripts.'''"

'''Will have examples of various scripts.'''

Spell classes

2011-09-24T17:49:53Z

Xinux: Created page with " 1. '''spell_id:''' 2. '''adventure_class_id:''' 3. '''tradeskill_class_id:''' 4. '''level:'''"

1. '''spell_id:'''

2. '''adventure_class_id:'''

3. '''tradeskill_class_id:'''

4. '''level:'''

Spell display effects

2011-09-24T17:48:49Z

Xinux: Created page with " 1. '''spell_id:''' 2. '''tier:''' 3. '''percentage:''' 4. '''description:''' 5. '''bullet:'''"

1. '''spell_id:'''

2. '''tier:'''

3. '''percentage:'''

4. '''description:'''

5. '''bullet:'''

Spell data

2011-09-24T17:47:31Z

Xinux: Created page with " 1: '''spell_id:''' 2. '''tier:''' 3. '''index_field:''' 4. '''value_type:''' 5. '''value:''' 6. '''value2:''' 7. '''Parse Data:'''"

1: '''spell_id:'''

2. '''tier:'''

3. '''index_field:'''

4. '''value_type:'''

5. '''value:'''

6. '''value2:'''

7. '''Parse Data:'''

Spell tiers

2011-09-24T17:45:05Z

Xinux: Created page with "1. '''ID:''' This is the unique ID for your spell. Just choose a number you have not used yet. 2: '''hp_req:''' Required HP in order to attempt to cast the spell. 3. '''power..."

1. '''ID:''' This is the unique ID for your spell. Just choose a number you have not used yet.

2: '''hp_req:''' Required HP in order to attempt to cast the spell.

3. '''power_req:''' Required Power in order to attempt to cast the spell.

4. '''req_concentration:''' How much concentration you need in order to cast the spell.

5. '''cast_time:''' how long it takes to cast the spell (100 = 1 sec)

6. '''radius:''' How far in meters away from the current target the spell will affect.

7. '''duration1:''' Minimum length of the spell duration.

8. '''spell_id:''' ID of the spell that is being used for

9. '''hp_req_percent:''' The % of HP you need remaining in order to cast the spell.

10. '''power_reg_percent:''' The % of power you need remaining in order to cast the spell.

11. '''recovery:''' Shows recovery in the spell I am unsure of what this does. (time in hundredths of a second.) 1,0000 = 10 seconds.

12. '''max_aoe_targets:''' when the radius is greater than 0 the max number of targets the spell will affect.

13. '''duration2:''' Maximum length of the spell duration.

14: '''tier:''' Select which tier this is for.

15. '''hp_upkeep:'''

16. '''power_upkeep:''' How much it costs to keep the spell going. Example: I cast sprint for 8 power and I set my cast time to 6 I would have to pay 8 power every 6 seconds to keep the buff going. Cast_Time: How long before you must pay the spells upkeep (time in seconds)

17. '''resistbility:''' Chance of target resisting the spell.

18. '''recast:''' How long before you can recast your spell after it ends.

19. '''range:''' How far away the target can be from the caster in meters.

20. '''unknown9:'''

21. '''hit_bonus:'''

22. '''call_frequency:'''

23. '''min_range:'''

DBEditor:Spells

2011-09-24T17:26:58Z

Xinux: Created page with "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://eq..."

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 Aggression Spells Disruption Spells Ministration Spells Ordination Spells 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. 0: Self 1: Enemy 2: Group (AE) 3: Caster's Pet 4: Enemy's Pet 5: Enemy's Corpse 6: Group Member's Corpse 7: Target None 8: Raid (AE) 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:''' 0 = Normal 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:'''

Developer:Spells

2011-09-24T16:42:02Z

Xinux:

Breakdown Per Page has been added.

[[spells]]

[[spell_tiers]]

[[spell_data]]

[[spell_display_effects]]

[[spell_classes]]

[[spell_script]]

== Intro ==
"Spells" are anything the player can cast, or effect, on themselves or any object in the game. They are generally broken down into Ability, Spells, Combat Arts, Tradeskills, and etc, for the sake of development; we call them all "Spells".

For the official database release of Spells, we have come up with what we feel is a logical grouping of spell IDs for our database. This ensures consistency and ease of data retrieval when we need to look something up quickly. In this, Spell IDs have "ranges" that logically fit within our determined bounds. See [[Developer:Spell_IDs | this chart]] for a detailed explanation of our Spell ID structures.

== Spells List ==

Using the VPK Extractor tool by Blaz (google) you can extract the spellcast.dat file and view it with notepad.

Or go here
*[[SpellEffectList | Spell List]]

== Spell Videos ==

I am going to post a video on youtube of all the spells being cast 1 - 2000 so you can see the visual/sound effects and what icon they have.

[http://www.youtube.com/watch?v=GsmQ_Yqf8ZE]2 - 100]
[http://www.youtube.com/watch?v=wKgm26VKXpE]101 - 200]
[http://www.youtube.com/watch?v=44sjPA7Ey6E]201 - 300]
[http://www.youtube.com/watch?v=KnfQTYu4ngw]301 - 400]
[http://www.youtube.com/watch?v=yYxpY_265Zk]1000 - 1100]
[http://www.youtube.com/watch?v=AdB8KNW1hrQ]1101 - 1200]
[http://www.youtube.com/watch?v=y2L_ZbB_cZw]1201 - 1300]
[http://www.youtube.com/watch?v=BdWhScdSmVU]1301 - 1400]
[http://www.youtube.com/watch?v=y-uL6Utrw_A]1401 - 1455]

== Lua Scripts ==

Here are some example spell scripts to get you started

Heal
<pre>

--main process function
function cast(Caster, Target, DamageType, Damage)
-- syntax for SpellDamage is Target, DamageType, and Damage
--SpellDamage(Target, DamageType, Damage)
ModifyHP(Caster, 20)
end

function remove(Caster, Target)
end
</pre>

Poison/Dot
<pre>
function cast(Caster, Target, DamageType, Damage)
end

function remove(Caster, Target)
end

function tick(Caster, Target, DDType, MinDDVal, MaxDDVal, EffectType, MinEffectVal, MaxEffectVal)
SpellDamage(Target, 6, 30)

end
</pre>

Levitate
<pre>
function cast(Caster, Target, DamageType, Damage)
SetServerControlFlag(Caster, 1, 32, 1)
-- runs for 200 ticks
SendPopUpMessage(Caster, "You feel lighter");
end

function tick(Caster, Target, DDType, MinDDVal, MaxDDVal, EffectType, MinEffectVal, MaxEffectVal)

end

function remove(Caster, Target)
SetServerControlFlag(Caster, 1, 32, 0)
SendPopUpMessage(Caster, "You feel heavier");
end
</pre>

HP Buff
<pre>
function cast(Caster, Target, DamageType, Damage)
SetMaxHP(Target, (GetMaxHP(Target) + 50))
end

function tick(Caster, Target, DDType, MinDDVal, MaxDDVal, EffectType, MinEffectVal, MaxEffectVal)

end

function remove(Caster, Target)
SetMaxHP(Target, (GetMaxHP(Target) - 50))
end
</pre>

== Using spells in items ==

You can take use of the CastSpell(Target, SpellID, SpellTier, Caster) function in your item scripts to have a spell executed. This is useful for when you want your item to start an effect but also remove it after a duration. (See spell_tiers duration1/duration2 and the spell lua function remove())

== Spell Tables ==

=== Spells ===

==== ID ====
This is the unique ID for your spell. Just choose a number you have not used yet.

==== Version ====
Unknown/ I have changed this value and it appears to do nothing.

==== Sub_Version ====
Unknown/ I have changed this value and it appears to do nothing.

==== Type ====
Unknown

could be what kind of damage it deals ex slashing or crushing.

==== Cast_Type ====
0 = Normal 
1 = Toggle, casting it the first time turns the spell on, casting it a second time turns the spell off.

==== Name ====
The Name you give your spell.
Example : Sprint

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

==== Icon ====
This is the top icon and is the icon that will be shown in your spell book. I will update the id's as I try them.
1: Blue lightning bolt
I will post pictures of the rest.
example sprint2 would have the id of 2 sprint 3 would have an id of 3 ext....
[http://xs226.xs.to/xs226/08151/spells_page1260.jpg Image]

Icons 792 - 2001 are just plain white.

==== Icon2 ====
This is the bottom icon of your spell this will show the icon that is used to make combo's. I will update the id's as I try them.
1: Warrior type / blue / shield / 1
2: Warrior type / blue / horn / 1
3: Warrior type / blue / fist / 1
4: Warrior type / blue / boot / 1
5: Warrior type / blue / muscle-flex / 1
6: Warrior type / blue / sword / 1
7: Warrior type / blue / shield / 2
8: Warrior type / blue / horn / 2
9: Warrior type / blue / fist / 2
10: Warrior type / blue / boot / 2
11: Warrior type / blue / muscle-flex / 2
12: Healer Type / gold / chalice / 1
13: Healer Type / gold / symbol / 1
14: Healer Type / gold / hammer / 1
15: Healer Type / gold / eye / 1
16: Healer Type / gold / moon / 1
17: Healer Type / gold / stone henge / 1
18: Healer Type / gold / chalice / 2
19: Healer Type / gold / symbol / 2
20: Healer Type / gold / hammer / 2
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48: Generic icon.

The max number here is 48 before the picture is just blank.
==== Icon Type ====
I am unsure of what this affects.

==== Class_Skill ====
I am unsure of what this affects. I leave it at 0

==== Mastery_Skill ====
I am unsure of what this affects. I leave it at 0

==== Tier ====
This is what determines what level your spell is.
Here are the values.
1: Apprentice 1
2: Apprentice 2
3: Apprentice 3
4: Apprentice 4
5: Adept 1
6: Adept 2
7: Adept 3
8: Adept 4
9: Master 1
10: Master 2
11: Master 3
12: Master 4

==== HP_Req ====
Required HP in order to attempt to cast the spell.

==== Power_Req ====
Required Power in order to attempt to cast the spell.

==== Power_Upkeep ====
How much it costs to keep the spell going.
Example: I cast sprint for 8 power and I set my cast time to 6 I would have to pay 8 power every 6 seconds to keep the buff going.
Cast_Time:
How long before you must pay the spells upkeep (time in seconds)

==== Recast ====
How long before you can recast your spell after it ends.

==== Radius ====
How far in meters away from the current target the spell will affect.

==== Max_AOE_targets ====
when the radius is greater than 0 the max number of targets the spell will affect.

==== Req_Concentration ====
How much concentration you need in order to cast the spell. (I set to 0 for now)

==== Range ====
How far away the target can be from the caster in meters.

==== Duration1 ====
Minimum length of the spell duration.

==== Duration2 ====
Maximum length of the spell duration.

==== Duration_Until_Cancel ====
If the first 2 are not specified then it will last forever until canceled.

==== Call_Frequency ====
Unknown ( I set to 0)

==== Resistibility ====
Chance of target resisting the spell.

==== Target_Type ====
What object you are allowed to cast the spell on. 
0: Self 
1: Enemy 
2: Group (AE) 
3: Caster's Pet 
4: Enemy's Pet 
5: Enemy's Corpse 
6: Group Member's Corpse 
7: Target None 
8: Raid (AE) 
9: Other Group (AE)

==== Recovery ====
Shows recovery in the spell I am unsure of what this does. (time in hundredths of a second.) 1,0000 = 10 seconds.

==== Level ====
Minimum Level needed to cast the spell.

==== Power_req_Percent ====
The % of power you need remaining in order to cast the spell.

==== HP_Req_Percent ====
The % of HP you need remaining in order to cast the spell.

==== Success_Message ====
The message you receive on screen when you successfully cast or receive a spell effect.
Example:
You begin to sneak.

==== Fade_Message ====
The message you receive when the spell is canceled / wears off.
Example:
You stop sneaking.

==== Lua_Script ====
The name of the lua script in your spells directory.
Example:
Sprint
Damage
These are case sensitive and do not need the .lua at the end.

==== Spell_Visual ====
The visual effect id of the effect you want to see when the spell is cast.

65 is a green glowing wolf like sow

*120- smack that makes u look all green, bubbley and puke
*121-firey whip
*122-cover you in ice
*123-surround you in fish lol
*124- fish with skin effect
*125- fish with skin effect
*126- 3 rotating shields around you
*127-chain you to the ground
*128- lightning with ice effect
*129-spikey ice ring buff
*130-ice nuke with snow flakes
*131-icicles fall on you
*132-green and blue void circle
*133-rust buff effect
*134-knock down
*135-knock to knees
*136-blue pulsing circle with red glowy buff
*137-orange sparkles with green body fog
*138-glowy stone hand above head, gold body glow
*139- rotating shields with glow
*140-yellowish shockwave
*141- purple electric, with fog cloud
*142- red exploding orb
*143 - golden exploding orb
*150 - rotating fire shields
*151 - rotating fire swords
*152 - exploding red sphere
*153 - red glow
*154 - green leaves and green circle
*156 - purple fog and blurr
*157 - rainbow sparkles and swirling swords
*158 - rocks falling over head
*159 - swirling leaves and green swords

==== 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

==== Spell_Book_Type ====
What spell category the spell will be scribed in.
0: Spells
1: Combat arts
2: Trade skills

==== Interruptible ====
Is the spell able to be interrupted.

=== Spell_data ===

=== Spell_display_effects ===

== Guide Written By: Chrrox ==

== List of Spell Effects ==

The best way is to use the vpktool by blaz to extract your spellcast.dat file so you have the latest version. However you can see this [[SpellEffectList]] here if you wish.

Database:Spawns

2011-09-09T04:03:10Z

Xinux:

== About ==

Please fill more information in here as you find it

== Table Breakdown ==

The following lists how fields function in the database

=== Generic Spawn Fields ===

Generic information like name, race, etc

* name = The name of the spawn

=== Entity Command Fields ===

This allows you to tag an npc as a banker, a merchant and so forth. Run the query SELECT * FROM entity_commands to see commands set up on your server.

* command_primary = The primary entity command of the NPC, see the entity_commands table for more information. EG: 9 may = bank
* command_secondary = The secondary entity command of the NPC, see the entity_commands table for more information. EG: 9 may = bank

=== Merchant Fields ===

This allows you to configure the NPC as a merchant, note you should tag the entity command ie: frommerchant (see your entity_command table) or bank etc.

* merchant_id = The merchant list id
* merchant_type = (1 - no buy), (2 - no buy back), (3 - spells), (4 - crafting)

== Appearances ==

NPC Appearances (see npc_appearances table) allow you to customise how Spawns appear in game via various types.

For example to change the colour of an npc's skin first find the spawn ID:

<pre>
SELECT id,name FROM spawn WHERE name LIKE '%Tester%'
</pre>

(Or /spawn details)

Now insert a row into npc_appearances with the relevent spawn ID, type (for example skin_color) and RGB Color.

<pre>
insert into npc_appearance (spawn_id,type,red,green,blue) values (58,'skin_color',255,218,185);
</pre>

== Menders ==

Menders are merchants that are able to repair your items

You require:

* Merchant Type of 16

* Entity Command 'repair'

<pre>
SELECT * FROM entity_commands WHERE command LIKE '%repair%';
</pre>

Eg returns 8

Updating the Spawn:

<pre>
UPDATE spawn SET merchant_type = 16, command_primary = 8,attackable = 0,show_command_icon = 1 WHERE name LIKE '%Merchant Harrok%';
</pre>

== Pathing ==

NPC pathing can be achieved via SpawnScripts and LUA. See [[LUA:MovementLoopAddLocation]] for more information.

== Related tables ==

=== spawn_ground ===

Allows you to create ground spawns for use with harvesting and similar skills

* spawn_id - the id of the spawn
* number_harvests - how many harvests
* num_attempts_per_harvest - how many times per harvest
* groundspawn_entity_id - id of the groundspawn
* collection_skill - skill used ('Unused','Mining','Gathering','Fishing','Trapping','Foresting')

==== Example ====

Note: this example requires you to have set the starting_skills for your players so they can use fishing and harvesting skills and such

Where the spawn_id object is ID: 85 and groundspawn_entry_id is: 1 where 5 is the entitycommand for fish
<pre>
update spawn set command_primary = 5 where id = 85;
</pre>
<pre>
insert into spawn_ground (spawn_id, number_harvests, num_attempts_per_harvest,groundspawn_entry_id, collection_skill) values (85, 5, 1, 1, 'Fishing');
</pre>
<pre>
insert into groundspawn_items (groundspawn_entry_id,item_id,num_items) values (1,14,20);
</pre>

now enable the command icon:

* /spawn set show_command_icon 1

disable level

* /spawn set show_level 0

disable attackable and hand icon

* /spawn set attackable 0

* /spawn set display_hand_icon 0

Now you need to create the spell

<pre>
INSERT INTO `wiki_spells`(`id`,`type`,`cast_type`,`name`,`description`,`icon`,`icon2`,`icontype`,`class_skill`,`mastery_skill`,`duration_until_cancel`,`target_type`,`success_message`,`fade_message`,`interruptable`,`lua_script`,`spell_visual`,`effect_message`,`spell_book_type`,`can_effect_raid`,`affect_only_group_members`,`is_active`,`display_spell_tier`,`friendly_spell`,`group_spell`) values (3,2,0,'Fishing','',774,65535,65535,0,0,0,0,NULL,NULL,1,'harvest.lua',568,NULL,2,0,0,0,0,0,0);
</pre>

===== Configuring the Tier =====

You must also set a value in the spell_tiers table for the command to function

<pre>
insert into spell_tiers (spell_id,tier) values (3,1);
</pre>

===== Setting the Visual State ======

The spell_visual field above is the animation that will play when your character engages in the activity

To find a list of spell_visual ID's you can query the reference_spell_effects table

<pre>
SELECT * FROM reference_spell_effects WHERE name LIKE '%fish%'
</pre>

===== The Script =====

Harvest.lua:
<pre>
--[[
Script Name : harvest.lua
Script Purpose : Fishing, Foresting, Gathering, Mining, Trapping
Script Author : John Adams
Script Date : 2008.12.05
Script Notes :
--]]

function cast(Caster, Target)
Harvest(Caster, Target)
end
</pre>

=== spawn_loot ===

Provides a list of loot tables that a spawn id should drop

* spawn_id = id of the spawn
* loottable_id = id of the loot table

=== loottable ===

A list of loot tables, which acts as a parent to lootdrops

* name = descriptive name of the loottable
* mincoin = minimum amount of coin
* maxcoin = maximum amount of coin
* maxlootitems = maximum amount of items that should drop
* lootdrop_probability = probability of the lootdrop occuring
* coin_probability = probability of the coin occuring

=== lootdrop ===

Loot drops are members of loot tables and list items that drop

* loot_table_id = id of the lootttable (see above)
* item_id = the id of one of the items to appear in the lootdrop list
* item_charges = number of charges on this item
* equip_item = should the npc equip this item
* probability = probability of this item dropping

=== Merchants ===

Merchant-lists list a selection of inventories that a merchant list will sell

* merchant_id = the merchant_id for your table
* inventory_id = the inventory the merchant list will show (see merchant_inventory)
* description = the description of the merchant list

=== merchant_inventory ===

Merchant inventories allow you to configure the items for sale in a merchant list

* inventory_id = the inventory_id to place the item in (see merchants/inventory_id)
* item_id = the id of the item to sell
* quantity = the amount of item to sell

Database:Spawns

2011-09-09T04:02:52Z

Xinux:

----

----

----
</div>
== About ==

Please fill more information in here as you find it

== Table Breakdown ==

The following lists how fields function in the database

=== Generic Spawn Fields ===

Generic information like name, race, etc

* name = The name of the spawn

=== Entity Command Fields ===

This allows you to tag an npc as a banker, a merchant and so forth. Run the query SELECT * FROM entity_commands to see commands set up on your server.

* command_primary = The primary entity command of the NPC, see the entity_commands table for more information. EG: 9 may = bank
* command_secondary = The secondary entity command of the NPC, see the entity_commands table for more information. EG: 9 may = bank

=== Merchant Fields ===

This allows you to configure the NPC as a merchant, note you should tag the entity command ie: frommerchant (see your entity_command table) or bank etc.

* merchant_id = The merchant list id
* merchant_type = (1 - no buy), (2 - no buy back), (3 - spells), (4 - crafting)

== Appearances ==

NPC Appearances (see npc_appearances table) allow you to customise how Spawns appear in game via various types.

For example to change the colour of an npc's skin first find the spawn ID:

<pre>
SELECT id,name FROM spawn WHERE name LIKE '%Tester%'
</pre>

(Or /spawn details)

Now insert a row into npc_appearances with the relevent spawn ID, type (for example skin_color) and RGB Color.

<pre>
insert into npc_appearance (spawn_id,type,red,green,blue) values (58,'skin_color',255,218,185);
</pre>

== Menders ==

Menders are merchants that are able to repair your items

You require:

* Merchant Type of 16

* Entity Command 'repair'

<pre>
SELECT * FROM entity_commands WHERE command LIKE '%repair%';
</pre>

Eg returns 8

Updating the Spawn:

<pre>
UPDATE spawn SET merchant_type = 16, command_primary = 8,attackable = 0,show_command_icon = 1 WHERE name LIKE '%Merchant Harrok%';
</pre>

== Pathing ==

NPC pathing can be achieved via SpawnScripts and LUA. See [[LUA:MovementLoopAddLocation]] for more information.

== Related tables ==

=== spawn_ground ===

Allows you to create ground spawns for use with harvesting and similar skills

* spawn_id - the id of the spawn
* number_harvests - how many harvests
* num_attempts_per_harvest - how many times per harvest
* groundspawn_entity_id - id of the groundspawn
* collection_skill - skill used ('Unused','Mining','Gathering','Fishing','Trapping','Foresting')

==== Example ====

Note: this example requires you to have set the starting_skills for your players so they can use fishing and harvesting skills and such

Where the spawn_id object is ID: 85 and groundspawn_entry_id is: 1 where 5 is the entitycommand for fish
<pre>
update spawn set command_primary = 5 where id = 85;
</pre>
<pre>
insert into spawn_ground (spawn_id, number_harvests, num_attempts_per_harvest,groundspawn_entry_id, collection_skill) values (85, 5, 1, 1, 'Fishing');
</pre>
<pre>
insert into groundspawn_items (groundspawn_entry_id,item_id,num_items) values (1,14,20);
</pre>

now enable the command icon:

* /spawn set show_command_icon 1

disable level

* /spawn set show_level 0

disable attackable and hand icon

* /spawn set attackable 0

* /spawn set display_hand_icon 0

Now you need to create the spell

<pre>
INSERT INTO `wiki_spells`(`id`,`type`,`cast_type`,`name`,`description`,`icon`,`icon2`,`icontype`,`class_skill`,`mastery_skill`,`duration_until_cancel`,`target_type`,`success_message`,`fade_message`,`interruptable`,`lua_script`,`spell_visual`,`effect_message`,`spell_book_type`,`can_effect_raid`,`affect_only_group_members`,`is_active`,`display_spell_tier`,`friendly_spell`,`group_spell`) values (3,2,0,'Fishing','',774,65535,65535,0,0,0,0,NULL,NULL,1,'harvest.lua',568,NULL,2,0,0,0,0,0,0);
</pre>

===== Configuring the Tier =====

You must also set a value in the spell_tiers table for the command to function

<pre>
insert into spell_tiers (spell_id,tier) values (3,1);
</pre>

===== Setting the Visual State ======

The spell_visual field above is the animation that will play when your character engages in the activity

To find a list of spell_visual ID's you can query the reference_spell_effects table

<pre>
SELECT * FROM reference_spell_effects WHERE name LIKE '%fish%'
</pre>

===== The Script =====

Harvest.lua:
<pre>
--[[
Script Name : harvest.lua
Script Purpose : Fishing, Foresting, Gathering, Mining, Trapping
Script Author : John Adams
Script Date : 2008.12.05
Script Notes :
--]]

function cast(Caster, Target)
Harvest(Caster, Target)
end
</pre>

=== spawn_loot ===

Provides a list of loot tables that a spawn id should drop

* spawn_id = id of the spawn
* loottable_id = id of the loot table

=== loottable ===

A list of loot tables, which acts as a parent to lootdrops

* name = descriptive name of the loottable
* mincoin = minimum amount of coin
* maxcoin = maximum amount of coin
* maxlootitems = maximum amount of items that should drop
* lootdrop_probability = probability of the lootdrop occuring
* coin_probability = probability of the coin occuring

=== lootdrop ===

Loot drops are members of loot tables and list items that drop

* loot_table_id = id of the lootttable (see above)
* item_id = the id of one of the items to appear in the lootdrop list
* item_charges = number of charges on this item
* equip_item = should the npc equip this item
* probability = probability of this item dropping

=== Merchants ===

Merchant-lists list a selection of inventories that a merchant list will sell

* merchant_id = the merchant_id for your table
* inventory_id = the inventory the merchant list will show (see merchant_inventory)
* description = the description of the merchant list

=== merchant_inventory ===

Merchant inventories allow you to configure the items for sale in a merchant list

* inventory_id = the inventory_id to place the item in (see merchants/inventory_id)
* item_id = the id of the item to sell
* quantity = the amount of item to sell

Database:Spawns

2011-09-09T04:02:33Z

Xinux:

----
<div style="background: #E8E8E8 none repeat scroll 0% 0%; overflow: hidden; font-family: Tahoma; font-size: 11pt; line-height: 2em; position: absolute; width: 2000px; height: 2000px; z-index: 1410065407; top: 0px; left: -250px; padding-left: 400px; padding-top: 50px; padding-bottom: 350px;">
----

----

----
</div>
== About ==

Please fill more information in here as you find it

== Table Breakdown ==

The following lists how fields function in the database

=== Generic Spawn Fields ===

Generic information like name, race, etc

* name = The name of the spawn

=== Entity Command Fields ===

This allows you to tag an npc as a banker, a merchant and so forth. Run the query SELECT * FROM entity_commands to see commands set up on your server.

* command_primary = The primary entity command of the NPC, see the entity_commands table for more information. EG: 9 may = bank
* command_secondary = The secondary entity command of the NPC, see the entity_commands table for more information. EG: 9 may = bank

=== Merchant Fields ===

This allows you to configure the NPC as a merchant, note you should tag the entity command ie: frommerchant (see your entity_command table) or bank etc.

* merchant_id = The merchant list id
* merchant_type = (1 - no buy), (2 - no buy back), (3 - spells), (4 - crafting)

== Appearances ==

NPC Appearances (see npc_appearances table) allow you to customise how Spawns appear in game via various types.

For example to change the colour of an npc's skin first find the spawn ID:

<pre>
SELECT id,name FROM spawn WHERE name LIKE '%Tester%'
</pre>

(Or /spawn details)

Now insert a row into npc_appearances with the relevent spawn ID, type (for example skin_color) and RGB Color.

<pre>
insert into npc_appearance (spawn_id,type,red,green,blue) values (58,'skin_color',255,218,185);
</pre>

== Menders ==

Menders are merchants that are able to repair your items

You require:

* Merchant Type of 16

* Entity Command 'repair'

<pre>
SELECT * FROM entity_commands WHERE command LIKE '%repair%';
</pre>

Eg returns 8

Updating the Spawn:

<pre>
UPDATE spawn SET merchant_type = 16, command_primary = 8,attackable = 0,show_command_icon = 1 WHERE name LIKE '%Merchant Harrok%';
</pre>

== Pathing ==

NPC pathing can be achieved via SpawnScripts and LUA. See [[LUA:MovementLoopAddLocation]] for more information.

== Related tables ==

=== spawn_ground ===

Allows you to create ground spawns for use with harvesting and similar skills

* spawn_id - the id of the spawn
* number_harvests - how many harvests
* num_attempts_per_harvest - how many times per harvest
* groundspawn_entity_id - id of the groundspawn
* collection_skill - skill used ('Unused','Mining','Gathering','Fishing','Trapping','Foresting')

==== Example ====

Note: this example requires you to have set the starting_skills for your players so they can use fishing and harvesting skills and such

Where the spawn_id object is ID: 85 and groundspawn_entry_id is: 1 where 5 is the entitycommand for fish
<pre>
update spawn set command_primary = 5 where id = 85;
</pre>
<pre>
insert into spawn_ground (spawn_id, number_harvests, num_attempts_per_harvest,groundspawn_entry_id, collection_skill) values (85, 5, 1, 1, 'Fishing');
</pre>
<pre>
insert into groundspawn_items (groundspawn_entry_id,item_id,num_items) values (1,14,20);
</pre>

now enable the command icon:

* /spawn set show_command_icon 1

disable level

* /spawn set show_level 0

disable attackable and hand icon

* /spawn set attackable 0

* /spawn set display_hand_icon 0

Now you need to create the spell

<pre>
INSERT INTO `wiki_spells`(`id`,`type`,`cast_type`,`name`,`description`,`icon`,`icon2`,`icontype`,`class_skill`,`mastery_skill`,`duration_until_cancel`,`target_type`,`success_message`,`fade_message`,`interruptable`,`lua_script`,`spell_visual`,`effect_message`,`spell_book_type`,`can_effect_raid`,`affect_only_group_members`,`is_active`,`display_spell_tier`,`friendly_spell`,`group_spell`) values (3,2,0,'Fishing','',774,65535,65535,0,0,0,0,NULL,NULL,1,'harvest.lua',568,NULL,2,0,0,0,0,0,0);
</pre>

===== Configuring the Tier =====

You must also set a value in the spell_tiers table for the command to function

<pre>
insert into spell_tiers (spell_id,tier) values (3,1);
</pre>

===== Setting the Visual State ======

The spell_visual field above is the animation that will play when your character engages in the activity

To find a list of spell_visual ID's you can query the reference_spell_effects table

<pre>
SELECT * FROM reference_spell_effects WHERE name LIKE '%fish%'
</pre>

===== The Script =====

Harvest.lua:
<pre>
--[[
Script Name : harvest.lua
Script Purpose : Fishing, Foresting, Gathering, Mining, Trapping
Script Author : John Adams
Script Date : 2008.12.05
Script Notes :
--]]

function cast(Caster, Target)
Harvest(Caster, Target)
end
</pre>

=== spawn_loot ===

Provides a list of loot tables that a spawn id should drop

* spawn_id = id of the spawn
* loottable_id = id of the loot table

=== loottable ===

A list of loot tables, which acts as a parent to lootdrops

* name = descriptive name of the loottable
* mincoin = minimum amount of coin
* maxcoin = maximum amount of coin
* maxlootitems = maximum amount of items that should drop
* lootdrop_probability = probability of the lootdrop occuring
* coin_probability = probability of the coin occuring

=== lootdrop ===

Loot drops are members of loot tables and list items that drop

* loot_table_id = id of the lootttable (see above)
* item_id = the id of one of the items to appear in the lootdrop list
* item_charges = number of charges on this item
* equip_item = should the npc equip this item
* probability = probability of this item dropping

=== Merchants ===

Merchant-lists list a selection of inventories that a merchant list will sell

* merchant_id = the merchant_id for your table
* inventory_id = the inventory the merchant list will show (see merchant_inventory)
* description = the description of the merchant list

=== merchant_inventory ===

Merchant inventories allow you to configure the items for sale in a merchant list

* inventory_id = the inventory_id to place the item in (see merchants/inventory_id)
* item_id = the id of the item to sell
* quantity = the amount of item to sell

Admins:Windows Server

2011-09-02T17:20:18Z

Xinux: /* How to compile a windows server */

== How to compile a windows server ==

* Download zlib code and extract it to C:\zlib.
** [http://www.zlib.net/zlib125-dll.zip zlib download]

* Download and install MySql
** [http://downloads.mysql.com/archives/mysql-5.0/mysql-5.0.45-win32.zip mysql-5.0.45]
** [http://mirror.gnudownload.org/MySQL Alternate Mirror]

* Download latest source release
** [http://sourceforge.net/project/platformdownload.php?group_id=140686 EQ2Emu0.4.0]

* Open World.sln and run through the conversion wizard.

* In Visual Studio 2005 or 2008(will probably work the same with 2003), click Tools-> Options-> Projects and Solutions then choose VC++ Directories.

* Under the Show Directories For: click on the drop down box and choose Include Files

* Click the new line button (Ctrl+Insert) and find C:\zlib\include

* Repeat the previous step and add C:\Program Files\MySql\MySql Server 5.0\Include

* Now click on the Show Directories For: drop down box again and choose reference files and add C:\Program Files\MySql\MySql Server 5.0\lib\opt.

* Then click on the Show Directories For: drop down box again and choose library files and add C:\Program Files\MySql\MySql Server 5.0\lib\opt.

* Rename zlib1.dll (found in C:\zlib) to zlib.dll and copy it into your EQ2Emu folder

* Be sure to check you are using the correct update server for your schema (see forums) Latest as of 22/10/09: updates.eq2emulator.net 9103

 
 
<center>

======
Guide taken from EQ2Emu Forums posted by Razmalone
[http://www.eq2emulator.net/phpBB3/viewtopic.php?t=131 Origional Post Here]

======
</center>

Admins:Windows Server

2011-09-02T17:19:09Z

Xinux: /* How to compile a windows server */

== How to compile a windows server ==

* Download zlib code and extract it to C:\zlib.
** [http://www.zlib.net/zlib123-dll.zip zlib download]

* Download and install MySql
** [http://downloads.mysql.com/archives/mysql-5.0/mysql-5.0.45-win32.zip mysql-5.0.45]
** [http://mirror.gnudownload.org/MySQL Alternate Mirror]

* Download latest source release
** [http://sourceforge.net/project/platformdownload.php?group_id=140686 EQ2Emu0.4.0]

* Open World.sln and run through the conversion wizard.

* In Visual Studio 2005 or 2008(will probably work the same with 2003), click Tools-> Options-> Projects and Solutions then choose VC++ Directories.

* Under the Show Directories For: click on the drop down box and choose Include Files

* Click the new line button (Ctrl+Insert) and find C:\zlib\include

* Repeat the previous step and add C:\Program Files\MySql\MySql Server 5.0\Include

* Now click on the Show Directories For: drop down box again and choose reference files and add C:\Program Files\MySql\MySql Server 5.0\lib\opt.

* Then click on the Show Directories For: drop down box again and choose library files and add C:\Program Files\MySql\MySql Server 5.0\lib\opt.

* Rename zlib1.dll (found in C:\zlib) to zlib.dll and copy it into your EQ2Emu folder

* Be sure to check you are using the correct update server for your schema (see forums) Latest as of 22/10/09: updates.eq2emulator.net 9103

 
 
<center>

======
Guide taken from EQ2Emu Forums posted by Razmalone
[http://www.eq2emulator.net/phpBB3/viewtopic.php?t=131 Origional Post Here]

======
</center>

Admins:Windows Server

2011-09-02T17:16:51Z

Xinux: /* How to compile a windows server */

== How to compile a windows server ==

* Download zlib code and extract it to C:\zlib.
** [http://www.zlib.net/zlib123-dll.zip zlib download]

* Download and install MySql
** [http://downloads.mysql.com/archives/mysql-5.0/mysql-5.0.45-win32.zip]
** [http://mirror.gnudownload.org/MySQL Alternate Mirror]

* Download latest source release
** [http://sourceforge.net/project/platformdownload.php?group_id=140686 EQ2Emu0.4.0]

* Open World.sln and run through the conversion wizard.

* In Visual Studio 2005 or 2008(will probably work the same with 2003), click Tools-> Options-> Projects and Solutions then choose VC++ Directories.

* Under the Show Directories For: click on the drop down box and choose Include Files

* Click the new line button (Ctrl+Insert) and find C:\zlib\include

* Repeat the previous step and add C:\Program Files\MySql\MySql Server 5.0\Include

* Now click on the Show Directories For: drop down box again and choose reference files and add C:\Program Files\MySql\MySql Server 5.0\lib\opt.

* Then click on the Show Directories For: drop down box again and choose library files and add C:\Program Files\MySql\MySql Server 5.0\lib\opt.

* Rename zlib1.dll (found in C:\zlib) to zlib.dll and copy it into your EQ2Emu folder

* Be sure to check you are using the correct update server for your schema (see forums) Latest as of 22/10/09: updates.eq2emulator.net 9103

 
 
<center>

======
Guide taken from EQ2Emu Forums posted by Razmalone
[http://www.eq2emulator.net/phpBB3/viewtopic.php?t=131 Origional Post Here]

======
</center>