PSwiki - User contributions [en]

DatabaseDesign

2022-01-11T15:33:02Z

Grimston: /* Unsorted Tables */

== Administration ==

* [[BansTable|bans]]
*[[PetitionsTable|petitions]]
*[[Security levelsTable|security_levels]]
*[[Server optionsTable|server_options]]
*[[WarningsTable|warnings]]

== Sectors ==

* [[SectorsTable|sectors]]

== Codex ==

* [[Codex factionsTable|codex_factions]]
* [[Codex locationsTable|codex_locations]]
* [[Codex natureTable|codex_nature]]
* [[Codex storyTable|codex_story]]

== Character Tables ==
*[[AccountsTable|accounts]]
*[[Character advantagesTable|character_advantages]]
*[[Character eventsTable|character_events]]
*[[Character limitationsTable|character_limitations]]
*[[Character questsTable|character_quests]]
*[[Character relationshipsTable|character_relationships]]
*[[Character skillsTable|character_skills]]
*[[Character traitsTable|character_traits]]
*[[CharactersTable|characters]]
*[[Player spellsTable|player_spells]]
*[[Race infoTable|race_info]]
*[[Familiar typesTable|familiar_types]]
*[[IntroductionsTable|introductions]]
*[[Character discoveriesTable|character_discoveries]]
*[[Character factionsTable|character_factions]]
*[[Character variablesTable|character_variables]]

== Character Creation ==
*[[CharacterCreationTable]]
*[[Bad namesTable|bad_names]]
*[[Char create affinityTable|char_create_affinity]]
*[[Char create lifeTable|char_create_life]]
*[[Char create life relationsTable|char_create_life_relations]]

== Commands ==

* [[Command group assignmentTable|command_group_assignment]]
* [[Command groupsTable|command_groups]]

== Combat ==

* [[Armor vs weaponTable|armor_vs_weapon]]
*[[AttacksTable|attacks]]
*[[Attack typesTable|attack_types]]

== Game Master ==

* [[Gm command logTable|gm_command_log]]
* [[Gm eventsTable|gm_events]]

== Guild Tables ==

*[[AlliancesTable|alliances]]
*[[Guild_warsTable|guild_wars]]
*[[GuildlevelsTable|guildlevels]]
*[[GuildsTable|guilds]]

== Loot ==

* [[Loot modifiersTable|loot_modifiers]]
* [[Loot rule detailsTable|loot_rule_details]]
* [[Loot rulesTable|loot_rules]]
*[[Loot modifiers restrainsTable|loot_modifiers_restrains]]

== NPC Movement Tables ==
* [[sc_location_typeTable|sc_location_type]]
* [[sc_locationsTable|sc_locations]]
* [[sc_npc_definitionsTable|sc_npc_definitions]]
* [[sc_path_pointsTable|sc_path_points]]
* [[sc_tribe_memoriesTable|sc_tribe_memories]]
* [[sc_tribe_resourcesTable|sc_tribe_resources]]
*[[Sc waypoint aliasesTable|sc_waypoint_aliases]]
* [[sc_waypoint_linksTable|sc_waypoint_links]]
* [[sc_waypointsTable|sc_waypoints]]
* [[npc_spawn_rangesTable|npc_spawn_ranges]]
* [[npc_spawn_rulesTable|npc_spawn_rules]]
* [[tribesTable|tribes]]

== NPC Dialog Tables ==
* [[npc_bad_textTable|npc_bad_text]]
* [[npc_disallowed_wordsTable|npc_disallowed_words]]
* [[npc_knowledge_areasTable|npc_knowledge_areas]]
* [[npc_responsesTable|npc_responses]]
* [[npc_synonymsTable|npc_synonyms]]
* [[npc_trigger_groupsTable|npc_trigger_groups]]
* [[npc_triggersTable|npc_triggers]]

== Factions ==

* [[FactionsTable|factions]]
*[[Faction ranksTable|faction_ranks]]

== Crafting Tables ==
* [[trade_autocontainersTable|trade_autocontainers]]
* [[trade_combinationsTable|trade_combinations]]
*[[Trade constraintsTable|trade_contraints]]
* [[trade_patternsTable|trade_patterns]]
* [[trade_processesTable|trade_processes]]
* [[trade_transformationsTable|trade_transformations]]

== Spells Tables ==
* [[spell_glyphsTable|spell_glyphs]]
* [[spellsTable|spells]]
* [[waysTable|ways]]

== Pet ==

* [[Pet abilitiesTable|pet_abilities]]
* pet_evolution

== Items Tables ==
*[[Item_animationsTable|item_animations]]
*[[Item_categoriesTable|item_categories]]
*[[Item_instancesTable|item_instances]]
*[[ItemStatsTable|item_stats]]

== Mini-game Tables ==
* [[gameboardsTable|gameboards]]
* [[action_locationsTable|action_locations]]

== Hunt Locations and Natural Resources ==
* [[hunt_locationsTable|hunt_locations]]
* [[natural_resourcesTable|natural_resources]]

== Scripting tables ==
* [[mathscriptTable|math_scripts]]
* [[ProgressionEventsTable|progression_events]]

== Web Client ==

* [[Wc accessrulesTable|wc_accessrules]]
* [[Wc cmdlogTable|wc_cmdlog]]
* [[Wc statisticsTable|wc_statistics]]
* [[Wc servernewsTable|wc_servernews]]

== Unsorted Tables ==

* [[Merchant item categoriesTable|merchant_item_categories]]
* [[MigrationTable|migration]]
* [[Money eventsTable|money_events]]
* [[Movement modesTable|movement_modes]]
* [[Movement typesTable|movement_types]]
* [[Quest scriptsTable|quest_scripts]]
* [[QuestsTable|quests]]
* [[Race spawnsTable|race_spawns]]
* [[SkillsTable|skills]]
* [[StancesTable|stances]]
* [[TipsTable|tips]]
* [[Trainer skillsTable|trainer_skills]]
* [[TraitsTable|traits]]
* [[Tribe membersTable|tribe_members]]
* [[Npc hired npcsTable|npc_hired_npcs]]
* [[Sc npctypesTable|sc_npctypes]]
* [[Sc tribe assetsTable|sc_tribe_assets]]
* [[Sc tribe knowledgeTable|sc_tribe_knowledge]]
* [[Tribe recipesTable|tribe_recipes]]
* [[Weapon typesTable|weapon_types]]
* [[Random eventsTable|random_events]]
* [[Skills abilitiesTable|skills_abilities]]
* [[Traps propertiesTable|traps_properties]]
* [[Voice oversTable|voice_overs]]
* [[Voice overs npcTable|voice_overs_npc]]

[[Category:Engine documents]]

DatabaseDesign

2022-01-11T15:30:28Z

Grimston:

== Administration ==

* [[BansTable|bans]]
*[[PetitionsTable|petitions]]
*[[Security levelsTable|security_levels]]
*[[Server optionsTable|server_options]]
*[[WarningsTable|warnings]]

== Sectors ==

* [[SectorsTable|sectors]]

== Codex ==

* [[Codex factionsTable|codex_factions]]
* [[Codex locationsTable|codex_locations]]
* [[Codex natureTable|codex_nature]]
* [[Codex storyTable|codex_story]]

== Character Tables ==
*[[AccountsTable|accounts]]
*[[Character advantagesTable|character_advantages]]
*[[Character eventsTable|character_events]]
*[[Character limitationsTable|character_limitations]]
*[[Character questsTable|character_quests]]
*[[Character relationshipsTable|character_relationships]]
*[[Character skillsTable|character_skills]]
*[[Character traitsTable|character_traits]]
*[[CharactersTable|characters]]
*[[Player spellsTable|player_spells]]
*[[Race infoTable|race_info]]
*[[Familiar typesTable|familiar_types]]
*[[IntroductionsTable|introductions]]
*[[Character discoveriesTable|character_discoveries]]
*[[Character factionsTable|character_factions]]
*[[Character variablesTable|character_variables]]

== Character Creation ==
*[[CharacterCreationTable]]
*[[Bad namesTable|bad_names]]
*[[Char create affinityTable|char_create_affinity]]
*[[Char create lifeTable|char_create_life]]
*[[Char create life relationsTable|char_create_life_relations]]

== Commands ==

* [[Command group assignmentTable|command_group_assignment]]
* [[Command groupsTable|command_groups]]

== Combat ==

* [[Armor vs weaponTable|armor_vs_weapon]]
*[[AttacksTable|attacks]]
*[[Attack typesTable|attack_types]]

== Game Master ==

* [[Gm command logTable|gm_command_log]]
* [[Gm eventsTable|gm_events]]

== Guild Tables ==

*[[AlliancesTable|alliances]]
*[[Guild_warsTable|guild_wars]]
*[[GuildlevelsTable|guildlevels]]
*[[GuildsTable|guilds]]

== Loot ==

* [[Loot modifiersTable|loot_modifiers]]
* [[Loot rule detailsTable|loot_rule_details]]
* [[Loot rulesTable|loot_rules]]
*[[Loot modifiers restrainsTable|loot_modifiers_restrains]]

== NPC Movement Tables ==
* [[sc_location_typeTable|sc_location_type]]
* [[sc_locationsTable|sc_locations]]
* [[sc_npc_definitionsTable|sc_npc_definitions]]
* [[sc_path_pointsTable|sc_path_points]]
* [[sc_tribe_memoriesTable|sc_tribe_memories]]
* [[sc_tribe_resourcesTable|sc_tribe_resources]]
*[[Sc waypoint aliasesTable|sc_waypoint_aliases]]
* [[sc_waypoint_linksTable|sc_waypoint_links]]
* [[sc_waypointsTable|sc_waypoints]]
* [[npc_spawn_rangesTable|npc_spawn_ranges]]
* [[npc_spawn_rulesTable|npc_spawn_rules]]
* [[tribesTable|tribes]]

== NPC Dialog Tables ==
* [[npc_bad_textTable|npc_bad_text]]
* [[npc_disallowed_wordsTable|npc_disallowed_words]]
* [[npc_knowledge_areasTable|npc_knowledge_areas]]
* [[npc_responsesTable|npc_responses]]
* [[npc_synonymsTable|npc_synonyms]]
* [[npc_trigger_groupsTable|npc_trigger_groups]]
* [[npc_triggersTable|npc_triggers]]

== Factions ==

* [[FactionsTable|factions]]
*[[Faction ranksTable|faction_ranks]]

== Crafting Tables ==
* [[trade_autocontainersTable|trade_autocontainers]]
* [[trade_combinationsTable|trade_combinations]]
*[[Trade constraintsTable|trade_contraints]]
* [[trade_patternsTable|trade_patterns]]
* [[trade_processesTable|trade_processes]]
* [[trade_transformationsTable|trade_transformations]]

== Spells Tables ==
* [[spell_glyphsTable|spell_glyphs]]
* [[spellsTable|spells]]
* [[waysTable|ways]]

== Pet ==

* [[Pet abilitiesTable|pet_abilities]]
* pet_evolution

== Items Tables ==
*[[Item_animationsTable|item_animations]]
*[[Item_categoriesTable|item_categories]]
*[[Item_instancesTable|item_instances]]
*[[ItemStatsTable|item_stats]]

== Mini-game Tables ==
* [[gameboardsTable|gameboards]]
* [[action_locationsTable|action_locations]]

== Hunt Locations and Natural Resources ==
* [[hunt_locationsTable|hunt_locations]]
* [[natural_resourcesTable|natural_resources]]

== Scripting tables ==
* [[mathscriptTable|math_scripts]]
* [[ProgressionEventsTable|progression_events]]

== Web Client ==

* [[Wc accessrulesTable|wc_accessrules]]
* [[Wc cmdlogTable|wc_cmdlog]]
* [[Wc statisticsTable|wc_statistics]]
* [[Wc servernewsTable|wc_servernews]]

== Unsorted Tables ==

* [[Merchant item categoriesTable|merchant_item_categories]]
* [[MigrationTable|migration]]
* [[Money eventsTable|money_events]]
* [[Movement modesTable|movement_modes]]
* [[Movement typesTable|movement_types]]
* [[Quest scriptsTable|quest_scripts]]
* [[QuestsTable|quests]]
* [[Race spawnsTable|race_spawns]]
* [[SkillsTable|skills]]
* [[StancesTable|stances]]
* [[TipsTable|tips]]
* [[Trainer skillsTable|trainer_skills]]
* [[TraitsTable|traits]]
* [[Tribe membersTable|tribe_members]]
* [[Tribe needsTable|[OBS] tribe_needs]]
* [[Npc hired npcsTable|npc_hired_npcs]]
* [[Sc npctypesTable|sc_npctypes]]
* [[Sc tribe assetsTable|sc_tribe_assets]]
* [[Sc tribe knowledgeTable|sc_tribe_knowledge]]
* [[Tribe recipesTable|tribe_recipes]]
* [[Weapon typesTable|weapon_types]]
* [[Random eventsTable|random_events]]
* [[Skills abilitiesTable|skills_abilities]]
* [[Traps propertiesTable|traps_properties]]
* [[Voice oversTable|voice_overs]]
* [[Voice overs npcTable|voice_overs_npc]]

[[Category:Engine documents]]

Wc servernewsTable

2022-01-11T15:30:15Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(10) |PRI | |auto_increment | |- |ADD |news |text | | | | |}"

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|ADD
|id
|int(10)
|PRI
|
|auto_increment
|
|-
|ADD
|news
|text
|
|
|
|
|}

Voice overs npcTable

2022-01-11T15:29:14Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(20) | | | | |- |ADD |fullname |varchar(100) | | | | |- |ADD |race |varchar(40) | | | | |- |ADD |gender |varchar(10) | | | | |}"

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|ADD
|id
|int(20)
|
|
|
|
|-
|ADD
|fullname
|varchar(100)
|
|
|
|
|-
|ADD
|race
|varchar(40)
|
|
|
|
|-
|ADD
|gender
|varchar(10)
|
|
|
|
|}

Voice oversTable

2022-01-11T15:28:44Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(10) unsigned |PRI | |auto_increment | |- |ADD |audio_path1 |varchar(100) | | | |This holds an optional VFS path to a speech file to be sent to the client and played on demand for response1. |- |ADD |audio_path2 |varchar(100) | | | |This holds an optional VFS path to a speech file to be sent to the client and played on demand for response2. |- |ADD |audio_path3 |varchar(100..."

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|ADD
|id
|int(10) unsigned
|PRI
|
|auto_increment
|
|-
|ADD
|audio_path1
|varchar(100)
|
|
|
|This holds an optional VFS path to a speech file to be sent to the client and played on demand for response1.
|-
|ADD
|audio_path2
|varchar(100)
|
|
|
|This holds an optional VFS path to a speech file to be sent to the client and played on demand for response2.
|-
|ADD
|audio_path3
|varchar(100)
|
|
|
|This holds an optional VFS path to a speech file to be sent to the client and played on demand for response3.
|-
|ADD
|audio_path4
|varchar(100)
|
|
|
|This holds an optional VFS path to a speech file to be sent to the client and played on demand for response4.
|-
|ADD
|audio_path5
|varchar(100)
|
|
|
|This holds an optional VFS path to a speech file to be sent to the client and played on demand for response5.
|-
|ADD
|response_id
|int(11)
|
|
|
|
|-
|ADD
|user_id
|int(11)
|
|
|
|
|}

Traps propertiesTable

2022-01-11T15:27:59Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(10) |PRI | |auto_increment | |- |ADD |item_instances_id |int(10) | | | |pointer to item_instances in case the trap on an item |- |ADD |action_locations_id |int(10) | | | |pointer to action_locations in case the trap is on a proximity trigger |- |ADD |trap_script |varchar(100) | | | |name of the progression script to run when the trap triggers |- |ADD |is_trap_blocking_use..."

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|ADD
|id
|int(10)
|PRI
|
|auto_increment
|
|-
|ADD
|item_instances_id
|int(10)
|
|
|
|pointer to item_instances in case the trap on an item
|-
|ADD
|action_locations_id
|int(10)
|
|
|
|pointer to action_locations in case the trap is on a proximity trigger
|-
|ADD
|trap_script
|varchar(100)
|
|
|
|name of the progression script to run when the trap triggers
|-
|ADD
|is_trap_blocking_use
|tinyint(4)
|
|0
|
|0 = doesnt block use, 1 = blocks use
|-
|ADD
|trap_strength
|tinyint(4)
|
|50
|
|strength of the trap
|-
|ADD
|trap_reset_time
|tinyint(4)
|
|60
|
|How much time before the trap is enabled again
|}

Skills abilitiesTable

2022-01-11T15:26:23Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(10) |PRI | | | |- |ADD |name |varchar(45) | | | | |- |ADD |skill_id |int(10) | | | | |- |ADD |skill_rank |int(10) | | | | |- |ADD |description |text | | | | |- |ADD |rank_icon |varchar(200) | | | | |- |ADD |skill_icon |varchar(200) | | | | |- |ADD |type |tinyint(4) | |0 | |0 = passive ability, 1 = attack ability, 2 = talent ability |- |ADD |is_special |tinyint(4) | |0..."

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|ADD
|id
|int(10)
|PRI
|
|
|
|-
|ADD
|name
|varchar(45)
|
|
|
|
|-
|ADD
|skill_id
|int(10)
|
|
|
|
|-
|ADD
|skill_rank
|int(10)
|
|
|
|
|-
|ADD
|description
|text
|
|
|
|
|-
|ADD
|rank_icon
|varchar(200)
|
|
|
|
|-
|ADD
|skill_icon
|varchar(200)
|
|
|
|
|-
|ADD
|type
|tinyint(4)
|
|0
|
|0 = passive ability, 1 = attack ability, 2 = talent ability
|-
|ADD
|is_special
|tinyint(4)
|
|0
|
|A special ability is not along with the progression of a skill, but can be discovered separately. 0 = normal , 1 = special
|-
|ADD
|attack_id
|int(11)
|
|
|
|foreign key to attacks table
|}

Random eventsTable

2022-01-11T15:25:25Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(11) |PRI | |auto_increment | |- |ADD |area |varchar(100) | | | |tavern, outdoor, temple, ... |- |ADD |hour_start |varchar(100) | | | |Time of day START, expressed in hours, in-game time |- |ADD |hour_end |int(11) | | | |Time of day END, expressed in hours, in-game time |- |ADD |probability |float | | | |random chance of this event to happen expressed in % |- |ADD |nextev..."

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|ADD
|id
|int(11)
|PRI
|
|auto_increment
|
|-
|ADD
|area
|varchar(100)
|
|
|
|tavern, outdoor, temple, ...
|-
|ADD
|hour_start
|varchar(100)
|
|
|
|Time of day START, expressed in hours, in-game time
|-
|ADD
|hour_end
|int(11)
|
|
|
|Time of day END, expressed in hours, in-game time
|-
|ADD
|probability
|float
|
|
|
|random chance of this event to happen expressed in %
|-
|ADD
|nextevent_min
|int(11)
|
|10
|
|Minimum pause before starting the next event. In real-life minutes.
|-
|ADD
|nextevent_max
|int(11)
|
|60
|
|Maximum pause before starting the next event. In real-life minutes.
|-
|ADD
|player_proximity
|int(11)
|
|10
|
|distance from the player to trigger the event in meters.
|-
|ADD
|min_players
|int(11)
|
|1
|
|minimum number of players in range to trigger the event
|-
|ADD
|max_players
|int(11)
|
| -1
|
|Maximum number of players in range to trigger the event
|-
|ADD
|prerequisite
|varchar(100)
|
|
|
|example: total ranks or specific skill with minimum value required. Use the same syntax as quest prereq.
|-
|ADD
|script
|text
|
|
|
|the script to run when the event starts
|}

Weapon typesTable

2022-01-11T15:22:21Z

Grimston: Created page with "Holds different types of weapons and their associations {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(11) |PRI | |auto_increment | holds the type unique id number |- | |name |varchar(40) |UNI | | |is the types name, each name must be unique. |- | |skill |int(11) | | | |The skill related to this type |}"

Holds different types of weapons and their associations

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(11)
|PRI
|
|auto_increment
| holds the type unique id number
|-
|
|name
|varchar(40)
|UNI
|
|
|is the types name, each name must be unique.
|-
|
|skill
|int(11)
|
|
|
|The skill related to this type
|}

TribesTable

2022-01-11T15:19:51Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(10)
|PRI
|
|auto_increment
|The ID of the tribe.
|-
|
|name
|varchar(30)
|
|
|
|
|-
|
|home_sector_id
|int(10) unsigned
|
|0
|
|
|-
|
|home_x
|float(10,2)
|
|0.00
|
|
|-
|
|home_y
|float(10,2)
|
|0.00
|
|
|-
|
|home_z
|float(10,2)
|
|0.00
|
|
|-
|
|home_radius
|float(10,2)
|
|0.00
|
|
|-
|
|max_size
|int(10)
|
|0
|
|
|-
|
|wealth_resource_name
|varchar(30)
|
|
|
|
|-
|
|wealth_resource_nick
|varchar(30)
|
|
|
|
|-
|
|wealth_resource_area
|varchar(30)
|
|
|
|
|-
|
|wealth_gather_need
|varchar(30)
|
|
|
|The need used to gather resources
|-
|
|wealth_resource_growth
|float(10,2)
|
|0.00
|
|
|-
|
|wealth_resource_growth_active
|float(10,2)
|
|0.00
|
|
|-
|
|wealth_resource_growth_active_limit
|int(10)
|
|0
|
|
|-
|
|reproduction_cost
|int(10)
|
|0
|
|
|-
|
|npc_idle_behavior
|varchar(30)
|
|do nothing
|
|
|-
|
|tribal_recipe
|int(5)
|
|
|
|
|-
|ADD
|enabled
|tinyint(4)
|
|1
|
|Is this tribe enabled or not
|}

Tribe recipesTable

2022-01-11T15:18:43Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) |PRI | |auto_increment | |- | |name |varchar(30) | | | | |- | |requirements |varchar(1000) | | | | |- | |algorithm |varchar(1000) | | | | |- | |persistent |int(1) | |0 | | |- | |uniqueness |int(1) | |0 | | |}"

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(10)
|PRI
|
|auto_increment
|
|-
|
|name
|varchar(30)
|
|
|
|
|-
|
|requirements
|varchar(1000)
|
|
|
|
|-
|
|algorithm
|varchar(1000)
|
|
|
|
|-
|
|persistent
|int(1)
|
|0
|
|
|-
|
|uniqueness
|int(1)
|
|0
|
|
|}

Tribe membersTable

2022-01-11T15:17:30Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|tribe_id
|int(10)
|PRI
|
|
|
|-
|
|member_id
|int(10) unsigned
|PRI
|
|
|
|-
|
|member_type
|varchar(30)
|
|
|
|
|-
|
|flags
|varchar(200)
|
|
|
|Various flags like: DYNAMIC, ...
|}

Trade processesTable

2022-01-11T15:15:37Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|process_id
|int(10) unsigned
|PRI
|
|
|
|-
|
|subprocess_number
|int(4) unsigned
|PRI
|
|
|subprocess number
|-
|
|name
|varchar(40)
|
|
|
|process name
|-
|
|animation
|varchar(30)
|
|
|
|transformation animation
|-
|
|render_effect
|char(32)
|
|
|
|transformation render effect
|-
|
|workitem_id
|int(10) unsigned
|
|
|
|target item to complete transformation
|-
|
|equipment_id
|int(10) unsigned
|
|
|
|required equipped item
|-
|
|constraints
|varchar(64)
|
|
|
|constraints that apply to the transformation
|-
|
|garbage_id
|int(10) unsigned
|
|
|
|garbage item for flubbed transformations
|-
|
|garbage_qty
|int(8) unsigned
|
|
|
|garbage quantity for flubbed transformations
|-
|
|primary_skill_id
|int(10)
|
|
|
|primary skill for transformation
|-
|
|primary_min_skill
|int(8) unsigned
|
|
|
|minimum primary skill level required to perform the transformation, 0 is no minimum
|-
|
|primary_max_skill
|int(8) unsigned
|
|
|
|maximum primary skill level at which practice and quality are affected, 0 is no maximum
|-
|
|primary_practice_points
|int(4)
|
|
|
|number of practice primary skill points gained for performing transformation
|-
|
|primary_quality_factor
|int(3) unsigned
|
|0
|
|percentage of the primary skill range that applies to quality
|-
|
|secondary_skill_id
|int(10)
|
|
|
|secondary skill foreign key
|-
|
|secondary_min_skill
|int(8) unsigned
|
|
|
|minimum secondary skill level required to perform the transformation, 0 is no minimum
|-
|
|secondary_max_skill
|int(8) unsigned
|
|
|
|maximum secondary skill level at which practice and quality are affected, 0 is no maximum
|-
|
|secondary_practice_points
|int(4)
|
|
|
|number of practice secondary skill points gained for performing transformation
|-
|
|secondary_quality_factor
|int(3) unsigned
|
|
|
|percentage of the secondary skill range that applies to quality
|-
|
|script
|varchar(255)
|
|Apply Post Trade Process
|
|A script to run after a process has been completed. In order to apply custom effects to the result.
|-
|
|description
|varchar(255)
|
|
|
|
|}

[[Category:Engine documents]]

SpellsTable

2022-01-11T15:12:50Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(8) unsigned
|PRI
|
|auto_increment
|The unique ID for this spell.
|-
|
|name
|varchar(30)
|UNI
|
|
|The name of the spell.
|-
|
|way_id
|int(8) unsigned
|
|0
|
|The ID of the way of magic
|-
|
|realm
|tinyint(3) unsigned
|
|0
|
|The level in the way the spell is.
|-
|
|casting_effect
|varchar(255)
|
|
|
|Name of visual/sound effect on the caster for casting spell.
|-
|
|image_name
|varchar(100)
|
|
|
|
|-
|
|spell_description
|text
|
|
|
|The description of the spell.
|-
|
|offensive
|tinyint(1)
|
|1
|
|Flag (0/1) if this is an offensive spell.
|-
|
|max_power
|float(4,2)
|
|1
|
|
|-
|
|target_type
|int(4)
|
|32
|
|Bitmask of valid target types.
|-
|
|cast_duration
|text
|
|
|
|
|-
|
|range
|text
|
|
|
|
|-
|
|aoe_radius
|text
|
|
|
|
|-
|
|aoe_angle
|text
|
|
|
|
|-
|
|outcome
|text
|
|
|
|
|-
|
|cstr_npc_spell_category
|varchar(200)
|
|
|
|Name of spell category which is sent to npc perception system.
|-
|
|npc_spell_power
|float(10,3)
|
|0.000
|
|Relative power of spell as hint for the npc perception system.
|}

== Additional Notes ==

=== target_type ===

The target-type values for the bitmask are defined in '''src/server/client.h'''. At the time of writing these are:
* TARGET_NONE = 0x01
* TARGET_ITEM = 0x04
* TARGET_SELF = 0x08
* TARGET_FRIEND = 0x10
* TARGET_FOE = 0x20
* TARGET_DEAD = 0x40
* TARGET_GM = 0x80
* TARGET_PVP = 0x100

[[Category:Engine documents]]

SkillsTable

2022-01-11T15:11:42Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|skill_id
|int(10) unsigned
|PRI
|0
|
|
|-
|
|name
|varchar(35)
|
|
|
|
|-
|
|description
|text
|
|
|
|
|-
|
|practice_factor
|int(8)
|
|100
|
|
|-
|
|mental_factor
|tinyint(4)
|
|
|
|
|-
|
|price
|int(8)
|
|0
|
|
|-
|
|base_rank_cost
|int(2)
|
|0
|
|
|-
|
|category
|varchar(255)
|
|VARIOUS
|
|
|-
|
|cost_script
|varchar(255)
|
|CalculateSkillCosts
|
|Stores the script to be run when calculating the costs of this skill.
|}

SectorsTable

2022-01-11T15:10:28Z

Grimston:

Stores data about sectors available in-game.

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|smallint(3) unsigned
|PRI
|
|auto_increment
|unique sector id
|-
|
|name
|varchar(30)
|UNI
|
|
|The name of the sector (as defined in map files)
|-
|
|rain_enabled
|char(1)
|
|N
|
|Sets if automatic rain should trigger. Put Y to enable it, N to disable it.
|-
|
|snow_enabled
|char(1)
|
|N
|
|Sets if automatic snow should trigger. Put Y to enable it, N to disable it.
|-
|
|fog_enabled
|char(1)
|
|N
|
|Sets if automatic fog should trigger. Put Y to enable it, N to disable it.
|-
|
|rain_min_gap
|int(10) unsigned
|
|0
|
|Sets the minimum time between two automatically triggered rain events.
|-
|
|rain_max_gap
|int(10) unsigned
|
|0
|
|Sets the maximum time between two automatically triggered rain events.
|-
|
|rain_min_duration
|int(10) unsigned
|
|0
|
|Sets the minimum duration of an automatically triggered rain event.
|-
|
|rain_max_duration
|int(10) unsigned
|
|0
|
|Sets the maximum duration of an automatically triggered snow event.
|-
|
|rain_min_drops
|int(10) unsigned
|
|0
|
|Sets the minimum amount of drops in an automatically triggered rain events.
|-
|
|rain_max_drops
|int(10) unsigned
|
|0
|
|Sets the maximum amount of drops in an automatically triggered rain events.
|-
|
|rain_min_fade_in
|int(10) unsigned
|
|0
|
|Sets the minimum time the automatically triggered rain event will take to reach the drops amount.
|-
|
|rain_max_fade_in
|int(10) unsigned
|
|0
|
|Sets the maximum time the automatically triggered rain event will take to reach the drops amount.
|-
|
|rain_min_fade_out
|int(10) unsigned
|
|0
|
|Sets the minimum time the automatically triggered event will take to disappear at its end.
|-
|
|rain_max_fade_out
|int(10) unsigned
|
|0
|
|Sets the maximum time the automatically triggered event will take to disappear at its end.
|-
|
|lightning_min_gap
|int(10) unsigned
|
|0
|
|Sets the minimum time between two automatic lightnings during a rain event.
|-
|
|lightning_max_gap
|int(10) unsigned
|
|0
|
|Sets the maximum time between two automatic lightnings during a rain event.
|-
|
|snow_min_gap
|int(10) unsigned
|
|0
|
|Sets the minimum time between two automatically triggered snow events.
|-
|
|snow_max_gap
|int(10) unsigned
|
|0
|
|Sets the maximum time between two automatically triggered snow events.
|-
|
|snow_min_duration
|int(10) unsigned
|
|0
|
|Sets the minimum duration of an automatically triggered snow event.
|-
|
|snow_max_duration
|int(10) unsigned
|
|0
|
|Sets the maximum duration of an automatically triggered snow event.
|-
|
|snow_min_flakes
|int(10) unsigned
|
|0
|
|Sets the minimum amount of flakes in an automatically triggered snow event.
|-
|
|snow_max_flakes
|int(10) unsigned
|
|0
|
|Sets the maximum amount of flakes in an automatically triggered snow event.
|-
|
|snow_min_fade_in
|int(10) unsigned
|
|0
|
|Sets the minimum time the automatically triggered snow event will take to reach the flakes amount.
|-
|
|snow_max_fade_in
|int(10) unsigned
|
|0
|
|Sets the maximum time the automatically triggered snow event will take to reach the flakes amount.
|-
|
|snow_min_fade_out
|int(10) unsigned
|
|0
|
|Sets the minimum time the automatically triggered snow event will take to disappear at its end.
|-
|
|snow_max_fade_out
|int(10) unsigned
|
|0
|
|Sets the maximum time that the automatically triggered snow event will take to disappear at its end.
|-
|
|fog_min_gap
|int(10) unsigned
|
|0
|
|Sets the minimum time between two automatically triggered fog events.
|-
|
|fog_max_gap
|int(10) unsigned
|
|0
|
|Sets the maximum time between two automatically triggered fog events.
|-
|
|fog_min_duration
|int(10) unsigned
|
|0
|
|Sets the minimum duration of an automatically triggered fog event.
|-
|
|fog_max_duration
|int(10) unsigned
|
|0
|
|Sets the maximum duration of an automatically triggered fog event.
|-
|
|fog_min_density
|int(10) unsigned
|
|0
|
|Sets the minimum density of the fog in an automatically triggered fog event.
|-
|
|fog_max_density
|int(10) unsigned
|
|0
|
|Sets the maximum density of the fog in an automatically triggered fog event.
|-
|
|fog_min_fade_in
|int(10) unsigned
|
|0
|
|Sets the minimum time that the automatically triggered fog event will take to reach its density.
|-
|
|fog_max_fade_in
|int(10) unsigned
|
|0
|
|Sets the maximum time that the automatically triggered fog event will take to reach its density.
|-
|
|fog_min_fade_out
|int(10) unsigned
|
|0
|
|Sets the minimum time that the automatically triggered fog event will take to disappear at its end.
|-
|
|fog_max_fade_out
|int(10) unsigned
|
|0
|
|Sets the maximum time that the automatically triggered fog event will take to disappear at its end.
|-
|
|collide_objects
|tinyint(1)
|
|0
|
|Determines if the items dropped in this sector should have collision detection always enabled.
|-
|
|non_transient_objects
|tinyint(4)
|
|0
|
|Determines if the items dropped in this sector should be transient.
|-
|
|say_range
|float(5,2) unsigned
|
|0.00
|
|Determines the range of say in the specific sector. Set 0.0 to use default.
|-
|
|TeleportingSector
|varchar(30)
|
|
|
|Sector where the player will be teleported automatically when entering this sector
|-
|
|TeleportingCords
|varchar(30)
|
|
|
|Cordinates where the player will be teleported automatically when entering this sector
|-
|
|DeathSector
|varchar(30)
|
|
|
|Sector where the player will be teleported automatically when dieing in this sector
|-
|
|DeathCords
|varchar(30)
|
|
|
|Cordinates where the player will be teleported automatically when dieing in this sector
|-
|
|TeleportingSectorEnable
|char(1)
|
|N
|
|When not N the sector will teleport when accessing it according to teleportingsector and teleportingcords
|-
|
|TeleportingPenaltyEnable
|char(1)
|
|N
|
|When not N when teleported when entering this sector it will apply the death penalty
|-
|
|DeathRestoreMana
|char(1)
|
|Y
|
|When not N the sector will restore mana when the player dies in it, else nothing is done.
|-
|
|DeathRestoreHP
|char(1)
|
|Y
|
|When not N the sector will restore HP when the player dies in it, else it just sets the minimum to keep him alive and not death loop.
|-
|
|god_name
|varchar(45)
|
|Laanx
|
|Sets a name of an entity associated to the sector as overseer.
|-
|ADD
|sect_coords
|varchar(45)
|
|127000,-381000,254000,-254000
|
|Defines boundaries of the sector in XY coordinates. 1 point Top left, 1 point bottom right
|-
|ADD
|safe_location
|varchar(45)
|
|
|
|Place to teleport the player if its stuck in the geometry
|-
|ADD
|priority
|int(11)
|
|0
|
|Used to sort the priority of the sectors when one sector is inside another sector
|-
|ADD
|event_probability
|int(11)
|
|0
|
|If > 0 modifies the probability in %. 100% is a 100x100 meters square.
|-
|ADD
|event_areatype
|varchar(100)
|
|
|
|Area Type, example: tavern, outdoors, temple, ...
|}

[[Category:Engine documents]]

Sc waypointsTable

2022-01-11T15:08:43Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(8) unsigned
|PRI
|
|auto_increment
|
|-
|
|name
|varchar(30)
|UNI
|
|
|
|-
|DIF
|wp_group
|varchar(30)
|
|
|
| Nullable used to be 'NO' in PSLegacy.
|-
|
|x
|double(10,2)
|
|0
|
|
|-
|
|y
|double(10,2)
|
|0
|
|
|-
|
|z
|double(10,2)
|
|0
|
|
|-
|
|radius
|int(10)
|
|0
|
|
|-
|
|flags
|varchar(100)
|
|
|
|
|-
|
|loc_sector_id
|int(8) unsigned
|
|0
|
|
|}

[[Category:Engine documents]]

Sc waypointsTable

2022-01-11T15:08:27Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(8) unsigned
|PRI
|
|auto_increment
|
|-
|
|name
|varchar(30)
|UNI
|
|
|
|-
|DIF
|wp_group
|varchar(30)
|
|
|
| Nullable used to be 'NO' in PSLegacy.
|-
|DIF
|x
|double(10,2)
|
|0
|
|
|-
|DIF
|y
|double(10,2)
|
|0
|
|
|-
|DIF
|z
|double(10,2)
|
|0
|
|
|-
|
|radius
|int(10)
|
|0
|
|
|-
|
|flags
|varchar(100)
|
|
|
|
|-
|
|loc_sector_id
|int(8) unsigned
|
|0
|
|
|}

[[Category:Engine documents]]

Sc waypoint aliasesTable

2022-01-11T15:07:35Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(8) unsigned
|PRI
|
|auto_increment
|
|-
|
|wp_id
|int(8) unsigned
|
|0
|
|
|-
|
|alias
|varchar(30)
|
|
|
|
|-
|
|rotation_angle
|float
|
|0
|
|The direction in degrees to face when stopping at WP.
|}

Sc tribe resourcesTable

2022-01-11T15:06:45Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(10)
|PRI
|
|auto_increment
|
|-
|
|tribe_id
|int(10)
|
|
|
|
|-
|
|name
|varchar(30)
|
|
|
|
|-
|
|nick
|varchar(30)
|
|
|
|
|-
|
|amount
|int(10)
|
|0
|
|
|}

[[Category:Engine documents]]

Sc tribe knowledgeTable

2022-01-11T15:05:32Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) |PRI | |auto_increment | |- | |tribe_id |int(10) | | | | |- | |knowledge |varchar(1000) | | | | |}"

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(10)
|PRI
|
|auto_increment
|
|-
|
|tribe_id
|int(10)
|
|
|
|
|-
|
|knowledge
|varchar(1000)
|
|
|
|
|}

Sc tribe assetsTable

2022-01-11T15:04:29Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) |PRI | |auto_increment |IDs for assets |- | |tribe_id |int(10) | |0 | | |- | |name |varchar(30) | | | | |- | |type |int(2) | |0 | | |- | |coordX |float | |0 | | |- | |coordY |float | |0 | | |- | |coordZ |float | |0 | | |- | |sector_id |int(10) | |3 | | |- | |itemID |int(10) | |0 | | |- | |quantity |int(10) | |0 | | -1 if its a building |- | |status |int(1) | |0 | |..."

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(10)
|PRI
|
|auto_increment
|IDs for assets
|-
|
|tribe_id
|int(10)
|
|0
|
|
|-
|
|name
|varchar(30)
|
|
|
|
|-
|
|type
|int(2)
|
|0
|
|
|-
|
|coordX
|float
|
|0
|
|
|-
|
|coordY
|float
|
|0
|
|
|-
|
|coordZ
|float
|
|0
|
|
|-
|
|sector_id
|int(10)
|
|3
|
|
|-
|
|itemID
|int(10)
|
|0
|
|
|-
|
|quantity
|int(10)
|
|0
|
| -1 if its a building
|-
|
|status
|int(1)
|
|0
|
|
|}

Sc path pointsTable

2022-01-11T15:03:15Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(8) unsigned
|PRI
|
|auto_increment
|
|-
|
|path_id
|int(8) unsigned
|
|0
|
|
|-
|
|prev_point
|int(8) unsigned
|
|0
|
|
|-
|
|x
|double(10,2)
|
|0.00
|
|
|-
|
|y
|double(10,2)
|
|0.00
|
|
|-
|
|z
|double(10,2)
|
|0.00
|
|
|-
|
|loc_sector_id
|int(8) unsigned
|
|0
|
|
|}

[[Category:Engine documents]]

Sc npctypesTable

2022-01-11T15:00:58Z

Grimston: Created page with "Stores the list of NPC types {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) unsigned |PRI | |auto_increment |An unique id for this row |- | |name |varchar(200) | | | |The name of this NPC type |- | |parents |varchar(200) | | | |The parents of this NPC type for inheritance |- | |ang_vel |float | |999 | |Angular speed of the NPC type |- | |vel |varchar(200) | |999 | |Speed of the NPC type |- | |collision |varchar(200..."

Stores the list of NPC types

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(10) unsigned
|PRI
|
|auto_increment
|An unique id for this row
|-
|
|name
|varchar(200)
|
|
|
|The name of this NPC type
|-
|
|parents
|varchar(200)
|
|
|
|The parents of this NPC type for inheritance
|-
|
|ang_vel
|float
|
|999
|
|Angular speed of the NPC type
|-
|
|vel
|varchar(200)
|
|999
|
|Speed of the NPC type
|-
|
|collision
|varchar(200)
|
|
|
|Perception when colliding
|-
|
|out_of_bounds
|varchar(200)
|
|
|
|Perception when out of bounds
|-
|
|in_bounds
|varchar(200)
|
|
|
|Perception when in bounds
|-
|
|falling
|varchar(200)
|
|
|
|Perception when falling
|-
|
|template
|int(1) unsigned
|
|0
|
|true if this is a base behaviour for other behaviours. Used by WC.
|-
|
|script
|text
|
|
|
|The script of this NPC type
|}

Sc locationsTable

2022-01-11T14:58:05Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(8) unsigned
|PRI
|
|auto_increment
|
|-
|
|type_id
|int(8) unsigned
|
|0
|
|
|-
|
|id_prev_loc_in_region
|int(8)
|
|0
|
|
|-
|
|name
|varchar(30)
|
|
|
|
|-
|
|x
|double(10,2)
|
|0.00
|
|
|-
|
|y
|double(10,2)
|
|0.00
|
|
|-
|
|z
|double(10,2)
|
|0.00
|
|
|-
|
|radius
|int(10)
|
|0
|
|
|-
|
|angle
|double(10,2)
|
|0.00
|
|
|-
|
|flags
|varchar(30)
|
|
|
|
|-
|
|loc_sector_id
|int(8) unsigned
|
|0
|
|
|}

[[Category:Engine documents]]

Quest scriptsTable

2022-01-11T14:55:22Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(10) unsigned
|PRI
|
|auto_increment
|
|-
|
|quest_id
|int(10)
|
|0
|
|FK to quests table, or -1 for KA scripts.
|-
|
|script
|text
|
|
|
|The script for the quest, parsed by questmanager.cpp
|}

Npc hired npcsTable

2022-01-11T14:51:51Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|owner_id
|int(8) unsigned
|PRI
|0
|
|
|-
|
|hired_npc_id
|int(8) unsigned
|PRI
|0
|
|
|-
|
|guild
|char(1)
|
|N
|
|
|-
|
|work_location_id
|int(8) unsigned
|
|0
|
|
|-
|
|script
|text
|
|
|
|The script for the hired NPC dialog.
|}

Natural resourcesTable

2022-01-11T14:50:32Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(10) unsigned
|PRI
|
|auto_increment
|
|-
|
|loc_sector_id
|int(10) unsigned
|
|0
|
|
|-
|
|loc_x
|float(10,2)
|
|0.00
|
|x coord of center
|-
|
|loc_y
|float(10,2)
|
|0.00
|
|y coord of center
|-
|
|loc_z
|float(10,2)
|
|0.00
|
|z coord of center
|-
|
|radius
|float(10,2)
|
|0.00
|
|radius of the resource
|-
|
|visible_radius
|float(10,2)
|
|0.00
|
|allow harvesting but with no result
|-
|
|probability
|float(10,6)
|
|0.000000
|
|chance of finding an item by harvesting
|-
|
|skill
|smallint(4) unsigned
|
|0
|
|skill ID used to harvest
|-
|
|skill_level
|int(3) unsigned
|
|0
|
|skill rank required to harvest
|-
|
|item_cat_id
|int(8) unsigned
|
|0
|
|item category required for harvesting
|-
|
|item_quality
|float(10,6)
|
|0.000000
|
|???
|-
|
|animation
|varchar(30)
|
|
|
|animation played while harvesting
|-
|
|anim_duration_seconds
|int(10) unsigned
|
|0
|
|animation duration
|-
|
|item_id_reward
|int(10) unsigned
|
|0
|
|item given to player when successful
|-
|
|reward_nickname
|varchar(30)
|
|0
|
|name of the item given as used in commands and maps
|-
|
|action
|varchar(45)
|
|
|
|command needed to harvest: dig/harvest/fish
|-
|
|amount
|int(10) unsigned
|
|
|
|if not null, items will be spawned as hunt_location
|-
|
|interval
|int(11)
|
|0
|
|if amount not null, msec interval for spawning item when picked up
|-
|
|max_random
|int(11)
|
|0
|
|Maximum random interval modifier in msecs
|}

[[Category:Engine documents]]

Loot rule detailsTable

2022-01-11T14:47:17Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(11)
|PRI
|
|auto_increment
|
|-
|
|loot_rule_id
|int(10) unsigned
|
|0
|
|
|-
|
|item_stat_id
|int(10) unsigned
|
|0
|
|
|-
|
|min_item
|int(10) unsigned
|
|1
|
|The minimum amount of these items which could be created
|-
|
|max_item
|int(10) unsigned
|
|1
|
|The maximum amount of these items which could be created
|-
|
|probability
|float(5,4)
|
|0.0000
|
|
|-
|
|min_money
|int(10) unsigned
|
|0
|
|
|-
|
|max_money
|int(10) unsigned
|
|0
|
|
|-
|
|randomize
|tinyint(1)
|
|0
|
|
|-
|
|randomize_probability
|float(5,4)
|
|1.0000
|
|The probability these items will be randomized if chosen
|}

Loot modifiers restrainsTable

2022-01-11T14:46:18Z

Grimston:

Allows to define some restrain to the loot_modifiers

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|loot_modifier_id
|int(11)
|PRI
|
|
|The id of the loot modifier rule
|-
|
|item_id
|int(11)
|PRI
|
|
|The id of the item included in the loot modifier rule
|-
|
|allowed
|char(1)
|
|Y
|
|Determines if the modifier is allowed or not
|}

Item instancesTable

2022-01-11T14:44:07Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(10) unsigned
|PRI
|
|auto_increment
|
|-
|
|char_id_owner
|int(10) unsigned
|MUL
|0
|
|Key into the CharactersTable for the owner of this item.
|-
|
|char_id_guardian
|int(10) unsigned
|
|0
|
|Key into the CharactersTable for the guardian of this item.
|-
|
|parent_item_id
|int(10) unsigned
|
|0
|
|
|-
|
|location_in_parent
|smallint(4)
|MUL
|0
|
|
|-
|
|stack_count
|int(10) unsigned
|
|0
|
|
|-
|
|creator_mark_id
|int(10) unsigned
|
|0
|
|Key into the CharactersTable for the creator of this item if crafted.
|-
|
|guild_mark_id
|int(10) unsigned
|
|0
|
|
|-
|
|loc_instance
|int(11) unsigned
|
|0
|
|
|-
|
|loc_sector_id
|smallint(4) unsigned
|
|0
|
|
|-
|
|loc_x
|float(14,6)
|
|0.000000
|
|
|-
|
|loc_y
|float(14,6)
|
|0.000000
|
|
|-
|
|loc_z
|float(14,6)
|
|0.000000
|
|
|-
|
|loc_xrot
|float(14,6)
|
|0.000000
|
|
|-
|
|loc_yrot
|float(14,6)
|
|0.000000
|
|
|-
|
|loc_zrot
|float(14,6)
|
|0.000000
|
|
|-
|
|decay_resistance
|float(3,2)
|
|0.00
|
|
|-
|
|item_quality
|float(5,2)
|
|50.00
|
|
|-
|
|crafted_quality
|float(5,2)
|
|50.00
|
|
|-
|
|item_stats_id_standard
|int(10) unsigned
|
|0
|
|Key into the ItemStatsTable for the standard version of this item.
|-
|
|item_stats_id_unique
|int(10) unsigned
|
|0
|
|Key into the ItemStatsTable for unique versions of this item.
|-
|
|flags
|varchar(200)
|MUL
|0
|
|
|-
|
|lock_str
|int(5)
|
|0
|
|
|-
|
|lock_skill
|int(2)
|
| -1
|
|
|-
|
|openable_locks
|varchar(100)
|
|0
|
|
|-
|
|item_name
|varchar(100)
|
|
|
|
|-
|
|item_description
|text
|
|
|
|
|-
|
|creative_definition
|text
|
|
|
|This is used for books/sketch.
|-
|
|charges
|int(3)
|
|0
|
|
|-
|
|prefix
|int(10) unsigned
|
|0
|
|Determines the prefix to be used from the loot modifiers table
|-
|
|suffix
|int(10) unsigned
|
|0
|
|Determines the suffix to be used from the loot modifiers table
|-
|
|adjective
|int(10) unsigned
|
|0
|
|Determines the adjective to be used from the loot modifiers table
|}

[[Category:Engine documents]]

Hunt locationsTable

2022-01-11T14:41:53Z

Grimston:

This table is loaded by SpawnManager::LoadHuntLocations()

At server startup we spawn into the world an "amount" of "itemid" for each line in the given "range".

When one of these items is picked up, we generate a UpsItemSpawnEvent() which will create a new item after "interval"+random("max_random")

Today only X and Y coordinates are randomized, the vertical coordinate stays as specified in the database entry. (this should be CHANGED to collide on the ground)

Areas to spawn items, like apples or mushrooms

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(8) unsigned
|PRI
|
|auto_increment
|
|-
|
|x
|double(10,2)
|
|0.00
|
|coordinate on the map
|-
|
|y
|double(10,2)
|
|0.00
|
|coordinate on the map
|-
|
|z
|double(10,2)
|
|0.00
|
|coordinate on the map
|-
|
|itemid
|int(10)
|
|0
|
|item to spawn taken from item_stats table
|-
|
|interval
|int(11)
|
|0
|
|time to respawn a new item in seconds
|-
|
|max_random
|int(11)
|
|0
|
|random time between 0 and given value added to interval value above
|-
|
|sector
|int(10) unsigned
|
|0
|
|
|-
|
|amount
|int(10) unsigned
|
|1
|
|Number of items to spawn in the area
|-
|
|range
|double(10,2) unsigned
|
|0.00
|
|radius in centimetres
|-
|
|lock_str
|int(5)
|
|0
|
|The lock strength of the generated item.
|-
|
|lock_skill
|int(2)
|
| -1
|
|The lock skill used to open the item.
|-
|
|flags
|varchar(200)
|
|
|
|The flags to apply to the item.
|}

[[Category:Engine documents]]

GuildsTable

2022-01-11T14:38:56Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(11)
|PRI
|
|auto_increment
|
|-
|
|name
|varchar(25)
|UNI
|
|
|
|-
|
|char_id_founder
|int(10)
|
|0
|
|
|-
|
|web_page
|varchar(255)
|
|
|
|
|-
|
|date_created
|datetime
|
|0000-00-00 00:00:00
|
|
|-
|
|karma_points
|int(10)
|
|0
|
|
|-
|
|secret_ind
|char(1)
|
|
|
|
|-
|
|max_guild_points
|int(10)
|
|100
|
|Stores the maximum amount of gp allowed for assignment in this guild
|-
|
|motd
|char(200)
|
|
|
|
|-
|
|alliance
|int(11)
|
|
|
|
|-
|
|bank_money_circles
|int(10) unsigned
|
|0
|
|
|-
|
|bank_money_octas
|int(10) unsigned
|
|0
|
|
|-
|
|bank_money_hexas
|int(10) unsigned
|
|0
|
|
|-
|
|bank_money_trias
|int(10) unsigned
|
|0
|
|
|-
|ADD
|housetype
|varchar(100)
|
|
|
|Describes the type of guildhouse, example gugguild, ojaguild, ... If empty this guild has no guildhouse
|-
|ADD
|houseid
|int(11)
|
| -1
|
|Incremental instance guildhouse number
|-
|ADD
|house_dev_owned
|int(11)
|
|0
|
|If 1, then points to a guildhouse managed by devs and not players (example Hydlaa Museum)
|-
|ADD
|housedoorid
|int(11)
|
| -1
|
|The actionlocation id representing the entrance to the guildhouse
|-
|ADD
|housemasterkeyid
|int(11)
|
| -1
|
|The psitem ID representing the master key for this guildhouse
|-
|ADD
|houselockid
|int(11)
|
| -1
|
|The psitem ID representing the lock for the guildhouse door
|-
|ADD
|houseflags
|varchar(100)
|
|
|
|Unlocked features for the guildhouse (HEAL, MUSICHALL, FEASTHALL,...)
|}

[[Category:Engine documents]]

Gm eventsTable

2022-01-11T14:36:57Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(10)
|PRI
|0
|
|
|-
|DIF
|date_created
|timestamp
|
|CURRENT_TIMESTAMP
|
| Nullable used to be 'YES' in PSLegacy.
|-
|
|name
|varchar(40)
|
|
|
|
|-
|
|description
|blob
|
|
|
|
|-
|
|status
|int(11)
|
|0
|
|
|-
|
|gm_id
|int(10)
|
|0
|
|
|}

CharactersTable

2022-01-11T14:33:40Z

Grimston:

This table holds all the characters in the game. This includes players, monsters, bosses. Anything that can be thought of as an 'alive' object.

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(10) unsigned
|PRI
|
|auto_increment
|unique character id
|-
|
|name
|varchar(30)
|MUL
|
|
|Character's first name in the game.
|-
|
|lastname
|varchar(30)
|MUL
|
|
|The last name of the character.
|-
|
|old_lastname
|varchar(30)
|
|
|
|The old last name ( used in termination of a marriage )
|-
|
|racegender_id
|smallint(5) unsigned
|
|0
|
|Key into the Race_infoTable for the race and gender of this character.
|-
|
|character_type
|int(10) unsigned
|
|0
|
|PLAYER = 0,NPC = 1, PET = 2, MOUNT = 3, MOUNTPET = 4
|-
|
|base_strength
|float(10,2)
|
|0.00
|
|Character strength (no buffs, but base strength value)
|-
|
|base_agility
|float(10,2)
|
|0.00
|
|Character agility (no buffs, but base value)
|-
|
|base_endurance
|float(10,2)
|
|0.00
|
|Character endurance (no buffs, but base value)
|-
|
|base_intelligence
|float(10,2)
|
|0.00
|
|Character intelligence (no buffs, but base value)
|-
|
|base_will
|float(10,2)
|
|0.00
|
|Character will (no buffs, but base value)
|-
|
|base_charisma
|float(10,2)
|
|0.00
|
|Character charisma (no buffs, but base value)
|-
|
|base_hitpoints_max
|float(10,2)
|
|0.00
|
|The max character hitpoints. If set to 0 it will use an equation to determine the max hitpoints from character skills.
|-
|
|mod_hitpoints
|float(10,2)
|
|0.00
|
|The character's current hitpoint value.
|-
|
|base_mana_max
|float(10,2)
|
|0.00
|
|The character's base mana. If set to 0 will use skills to determine max mana.
|-
|
|mod_mana
|float(10,2)
|
|0.00
|
|The character's current mana value.
|-
|
|stamina_physical
|float(10,2)
|
|0.00
|
|The character's physical stamina
|-
|
|stamina_mental
|float(10,2)
|
|0.00
|
|The character's mental stamina.
|-
|
|money_circles
|int(10) unsigned
|
|0
|
|The number of circles the character has.
|-
|
|money_octas
|int(10) unsigned
|
|0
|
|The number of octas the character has.
|-
|
|money_hexas
|int(10) unsigned
|
|0
|
|The number of hexas the character has.
|-
|
|money_trias
|int(10) unsigned
|
|0
|
|The number of trias the character has.
|-
|
|bank_money_circles
|int(10) unsigned
|
|0
|
|The number of circles the character has (banked).
|-
|
|bank_money_octas
|int(10) unsigned
|
|0
|
|The number of octas the character has (banked).
|-
|
|bank_money_hexas
|int(10) unsigned
|
|0
|
|The number of hexas the character has (banked).
|-
|
|bank_money_trias
|int(10) unsigned
|
|0
|
|The number of trias the character has (banked).
|-
|
|loc_instance
|int(11) unsigned
|
|0
|
|Instance number the character is in.
|-
|
|loc_sector_id
|int(10) unsigned
|
|0
|
|The ID of the sector the character is in.
|-
|
|loc_x
|float(10,2)
|
|0.00
|
|X location of character in world.
|-
|
|loc_y
|float(10,2)
|
|0.00
|
|Y location of character in world.
|-
|
|loc_z
|float(10,2)
|
|0.00
|
|Z location of character in world.
|-
|
|loc_yrot
|float(10,2)
|
|0.00
|
|The direction the character is facing.
|-
|
|guild_member_of
|int(10) unsigned
|
|0
|
|The ID key of the guild this character is a member of.
|-
|
|guild_level
|tinyint(1) unsigned
|
|0
|
|The rank this character is in their guild.
|-
|
|guild_additional_privileges
|smallint(3) unsigned
|
|0
|
|Contains a bitfield with the additional priviledges assigned to this char (additional to the guild level it's in)
|-
|
|guild_denied_privileges
|smallint(3) unsigned
|
|0
|
|Contains a bitfield with the removed priviledges from this char (removed from the guild level it's in)
|-
|
|guild_points
|int(10) unsigned
|
|0
|
|Number of points character has in the guild.
|-
|
|guild_public_notes
|varchar(255)
|
|
|
|Character's public guild note.
|-
|
|guild_private_notes
|varchar(255)
|
|0
|
|Character's private guild note.
|-
|
|join_notifications
|tinyint(1) unsigned
|
|0
|
|Contains a bitfield with the notifications being issued to this client about players login/logoff
|-
|
|last_login
|datetime
|
|
|
|The time this character last logged in.
|-
|
|pet_elapsed_time
|float(10,2)
|
|0.00
|
|
|-
|
|progression_script
|blob
|
|
|
|Script that needs to run on the player when they log back in.
|-
|
|npc_spawn_rule
|int(10) unsigned
|
|0
|
|Key into spawn rules table for the rule to use.
|-
|
|npc_master_id
|int(10) unsigned
|
|0
|
|Key into characters_table to use as the base stats for this character.
|-
|
|npc_impervious_ind
|char(1)
|
|N
|
|Y/N if this character is allowed to be attacked.
|-
|
|account_id
|int(10) unsigned
|MUL
|0
|
|Key into accounts table for the owner of this character ( or npcclient owner )
|-
|
|time_connected_sec
|int(10) unsigned
|
|0
|
|Total time this character has played.
|-
|
|npc_addl_loot_category_id
|int(10) unsigned
|
|0
|
|Used to add additional looting category for this character.
|-
|
|experience_points
|int(10) unsigned
|
|0
|
|The amount of experience points this character has
|-
|
|progression_points
|int(10) unsigned
|
|0
|
|The current number of progression_points this character has.
|-
|
|description
|text
|
|
|
|The characters description (bio)
|-
|
|description_ooc
|text
|
|
|
|The characters out of character description
|-
|
|creation_info
|text
|
|
|
|
|-
|
|description_life
|text
|
|
|
|
|-
|
|kill_exp
|int(5)
|
|10
|
|The amount of experience this character will give when killed.
|-
|
|animal_affinity
|text
|
|
|
|???
|-
|
|help_event_flags
|int(11) unsigned
|
|0
|
|Bit field of which instruction events have played for him.
|-
|DIF
|creation_time
|timestamp
|
|CURRENT_TIMESTAMP
|
| Nullable used to be 'YES' in PSLegacy.
|-
|
|banker
|tinyint(1) unsigned
|
|0
|
|Flag if this is a banker character.
|-
|
|statue
|tinyint(1) unsigned
|
|0
|
|Determines if the character is a statue so will be put in STATUE mode
|}

[[Category:Engine documents]]

Character variablesTable

2022-01-11T14:26:51Z

Grimston:

Used to store variables for a character

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|character_id
|int(10) unsigned
|PRI
|0
|
|The character this variable is assigned to
|-
|
|name
|varchar(255)
|PRI
|
|
|The name of the variable
|-
|
|value
|varchar(255)
|
|
|
|The value of the variable
|}

Character questsTable

2022-01-11T14:25:35Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|player_id
|int(10) unsigned
|PRI
|0
|
|
|-
|
|quest_id
|int(10) unsigned
|PRI
|0
|
|
|-
|
|status
|char(1)
|
|O
|
|
|-
|
|assigner_id
|int(10) unsigned
|
|0
|
|
|-
|
|remaininglockout
|int(10)
|
|0
|
|
|-
|
|last_response
|int(10)
|
| -1
|
|
|-
|
|last_response_npc_id
|int(10) unsigned
|
|
|
|This field stores the NPC PID who gave the last response. Required for menu filtering.
|-
|
|completionOrder
|int(10) unsigned
|
|0
|
|This field stores the ordering in which this quest was completed from 0 to n.
|}

[[Category:Engine documents]]

Character factionsTable

2022-01-11T14:23:57Z

Grimston:

Stores the faction of the characters

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|character_id
|int(10) unsigned
|PRI
|0
|
|The PID of the character this faction is assigned to
|-
|
|faction_id
|int(10) unsigned
|PRI
|0
|
|The id of the faction the points are for
|-
|
|value
|int(10)
|
|0
|
|The number of points in this faction
|}

AttacksTable

2022-01-11T14:21:50Z

Grimston:

Holds attacks

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(11)
|PRI
|
|auto_increment
|holds the attacks unique id number
|-
|
|name
|varchar(40)
|UNI
|default
|
|is the attacks name, each name must be unique.
|-
|
|image_name
|varchar(200)
|
|
|
|the icon image
|-
|
|attack_anim
|varchar(40)
|
|
|
|The visual effect of the attack
|-
|
|attack_description
|text
|
|
|
|a short description of the attack
|-
|
|damage
|varchar(40)
|
|
|
|A math script to compute the chance of success and final damage. Variables defined here can be used in the range, aoe_radius, and aoe_angle MathExpressions.
|-
|
|attackType
|int(11)
|
|
|
|the ID of the type of attack, found in the attack_types table
|-
|
|delay
|text
|
|
|
|A MathExpression to compute the time before the attack starts (based on the latency of weapon, range, attack speed, ...)
|-
|
|range
|text
|
|
|
|Mostly for range attacks, melee is confined based on weapon range
|-
|
|aoe_radius
|text
|
|
|
|This is the radius of the AOE attack. It can be a formula or a number; 0 for no AOE
|-
|
|aoe_angle
|text
|
|
|
|The angle in front of the player the AOE attack will affect, 1-360 degrees and can also be a formula
|-
|
|outcome
|varchar(40)
|
|
|
|The effect, a progression script, of the attack
|-
|
|requirements
|varchar(250)
|
|<pre></pre>
|
|is an XML script of requirements, these requirements will be checked before a character can use the attack. schema to be added soon, but will be very flexible.
|}

Attack typesTable

2022-01-11T14:20:59Z

Grimston:

Holds attack types to be used in the updated combat system

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(11)
|PRI
|
|auto_increment
|holds the attack type unique id number
|-
|
|name
|varchar(40)
|UNI
|
|
|is the attack type name, each name must be unique.
|-
|
|weaponID
|int(11)
|
|
|
|item_stats.id if a specific weapon is required for the special attack. Otherwise, weaponTypeID should be filled in.
|-
|
|weaponType
|varchar(100)
|
|
|
|More than one required weapon type may be listed (see weapon_types.id). Separate each weapon type ID with a space.
|-
|
|onehand
|tinyint(1)
|
|
|
|attack designed for a 1 hand weapon (true) or 2 handed (false)
|-
|
|stat
|int(11)
|
|
|
|The skill related to this type
|}

AlliancesTable

2022-01-11T14:19:45Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(11)
|PRI
|
|auto_increment
|
|-
|DIF
|date_created
|timestamp
|
|CURRENT_TIMESTAMP
|
| Nullable used to be 'YES' in PSLegacy.
|-
|
|name
|varchar(25)
|UNI
|
|
|
|-
|
|leading_guild
|int(11)
|
|
|
|The leading guild of the alliance
|}

[[Category:Engine documents]]

AccountsTable

2022-01-11T14:16:21Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(10) unsigned
|PRI
|
|auto_increment
|Unique account id
|-
|
|username
|varchar(50)
|UNI
|0
|
|Login name for the account
|-
|
|password
|varchar(64)
|
|0
|
|The encrypted password.
|-
|
|password256
|varchar(64)
|
|0
|
|
|-
|
|last_login
|datetime
|
|
|
|The last login time this account was used.
|-
|
|created_date
|datetime
|
|
|
|The date this account was created
|-
|
|last_login_ip
|varchar(16)
|MUL
|
|
|The IP address last used to login with this account.
|-
|
|security_level
|tinyint(3)
|
|0
|
|The Security Level of this account.
|-
|
|verificationid
|varchar(32)
|
|
|
|The verification id used in the URL to activate/reset account.
|-
|
|country
|varchar(64)
|
|
|
|The country this user is from.
|-
|
|gender
|varchar(1)
|
|N
|
|The gender of the player.
|-
|
|birth
|int(4)
|
|0
|
|The year this player was born.
|-
|
|status
|char(1)
|
|
|
|The status of this account. (A)ctive (U)nactive.
|-
|
|spam_points
|tinyint(1)
|
|0
|
|The amount of spam points this account has accumulated.
|-
|
|advisor_points
|int(10)
|
|0
|
|The number of advisor points this account has accumulated.
|-
|
|comments
|text
|
|
|
|Additional comments about account.
|-
|
|realname
|varchar(64)
|
|
|
|The real name of the person using account.
|-
|
|advisor_ban
|tinyint(1)
|
|0
|
|If the account is banned from being an advisor
|-
|
|operating_system
|varchar(32)
|
|
|
|
|-
|
|OS
|char(1)
|
|
|
|
|-
|
|OS_ver_major
|int(2)
|
|0
|
|
|-
|
|OS_ver_minor
|int(2)
|
|0
|
|
|-
|
|OS_platform
|char(14)
|
|
|
|
|-
|DIF
|Machine_type
|varchar(64)
|
|
|
| Type used to be 'char(6)' in PSLegacy.
|-
|
|graphics_card
|varchar(64)
|
|
|
|
|-
|
|graphics_version
|varchar(32)
|
|
|
|
|}

PetitionsTable

2022-01-11T14:12:48Z

Grimston:

Requests from players to GMs (petition window)

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|id
|int(10) unsigned
|PRI
|
|auto_increment
|
|-
|
|player
|int(10)
|MUL
|0
|
|
|-
|
|petition
|blob
|
|
|
|
|-
|
|status
|varchar(20)
|MUL
|Open
|
|
|-
|
|category
|varchar(30)
|
|Not Assigned
|
|
|-
|
|created_date
|datetime
|
|
|
|
|-
|
|closed_date
|datetime
|
|0000-00-00 00:00:00
|
|
|-
|
|assigned_gm
|int(10)
|
| -1
|
|
|-
|
|resolution
|blob
|
|
|
|
|-
|
|escalation_level
|int(10) unsigned
|MUL
|1
|
|
|}

BansTable

2022-01-11T14:11:28Z

Grimston:

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|
|account
|int(10) unsigned
|PRI
|0
|
|
|-
|
|ip_range
|char(15)
|
|
|
|
|-
|
|start
|int(20) unsigned
|
|0
|
|
|-
|
|end
|int(20) unsigned
|
|0
|
|
|-
|
|reason
|text
|
|
|
|
|-
|
|ban_ip
|tinyint(1)
|
|0
|
|Account banned by IP as well
|}

Pet evolutionTable

2022-01-11T13:52:24Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(11) |PRI | |auto_increment | |- |ADD |name |varchar(100) | | | | |- |ADD |scale |float(10,2) | | | |The scale of the 3d model |- |ADD |mesh_name |varchar(100) | | | |should we use a different mesh? |- |ADD |exp_required |varchar(100) | | | |Experience to reach this evolution stage |}"

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|ADD
|id
|int(11)
|PRI
|
|auto_increment
|
|-
|ADD
|name
|varchar(100)
|
|
|
|
|-
|ADD
|scale
|float(10,2)
|
|
|
|The scale of the 3d model
|-
|ADD
|mesh_name
|varchar(100)
|
|
|
|should we use a different mesh?
|-
|ADD
|exp_required
|varchar(100)
|
|
|
|Experience to reach this evolution stage
|}

Pet abilitiesTable

2022-01-11T13:51:54Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(11) |PRI | |auto_increment | |- |ADD |evo_stage_id |int(11) | | | |Reference to pet_evolution.id |- |ADD |name |varchar(100) | | | |name of the ability |- |ADD |description |varchar(200) | | | |description of the ability |- |ADD |pet_command |varchar(100) | | | |/pet command to enable |- |ADD |storage |tinyint(4) | |0 | |Is this ability allowing the pet to store items |}"

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|ADD
|id
|int(11)
|PRI
|
|auto_increment
|
|-
|ADD
|evo_stage_id
|int(11)
|
|
|
|Reference to pet_evolution.id
|-
|ADD
|name
|varchar(100)
|
|
|
|name of the ability
|-
|ADD
|description
|varchar(200)
|
|
|
|description of the ability
|-
|ADD
|pet_command
|varchar(100)
|
|
|
|/pet command to enable
|-
|ADD
|storage
|tinyint(4)
|
|0
|
|Is this ability allowing the pet to store items
|}

Npc hired npcsTable

2022-01-11T13:50:55Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |owner_id |int(8) unsigned |PRI |0 | | |- |ADD |hired_npc_id |int(8) unsigned |PRI |0 | | |- |ADD |guild |char(1) | |N | | |- |ADD |work_location_id |int(8) unsigned | |0 | | |- |ADD |script |text | | | |The script for the hired NPC dialog. |}"

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|ADD
|owner_id
|int(8) unsigned
|PRI
|0
|
|
|-
|ADD
|hired_npc_id
|int(8) unsigned
|PRI
|0
|
|
|-
|ADD
|guild
|char(1)
|
|N
|
|
|-
|ADD
|work_location_id
|int(8) unsigned
|
|0
|
|
|-
|ADD
|script
|text
|
|
|
|The script for the hired NPC dialog.
|}

Loot modifiers restrainsTable

2022-01-11T13:49:16Z

Grimston: Created page with "Allows to define some restrain to the loot_modifiers {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |loot_modifier_id |int(11) |PRI | | |The id of the loot modifier rule |- |ADD |item_id |int(11) |PRI | | |The id of the item included in the loot modifier rule |- |ADD |allowed |char(1) | |Y | |Determines if the modifier is allowed or not |}"

Allows to define some restrain to the loot_modifiers

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|ADD
|loot_modifier_id
|int(11)
|PRI
|
|
|The id of the loot modifier rule
|-
|ADD
|item_id
|int(11)
|PRI
|
|
|The id of the item included in the loot modifier rule
|-
|ADD
|allowed
|char(1)
|
|Y
|
|Determines if the modifier is allowed or not
|}

Faction ranksTable

2022-01-11T13:48:28Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(11) |PRI | |auto_increment | |- |ADD |faction_id |int(11) | | | |faction to which this rank belongs to |- |ADD |rank_number |int(11) | | | |Rank number can be negative or positive |- |ADD |name |varchar(100) | | | |Name of the rank |- |ADD |description |text | | | |Description of the rank |- |ADD |faction_points |int(11) | |0 | |Points needed to obtain this rank |- |ADD..."

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|ADD
|id
|int(11)
|PRI
|
|auto_increment
|
|-
|ADD
|faction_id
|int(11)
|
|
|
|faction to which this rank belongs to
|-
|ADD
|rank_number
|int(11)
|
|
|
|Rank number can be negative or positive
|-
|ADD
|name
|varchar(100)
|
|
|
|Name of the rank
|-
|ADD
|description
|text
|
|
|
|Description of the rank
|-
|ADD
|faction_points
|int(11)
|
|0
|
|Points needed to obtain this rank
|-
|ADD
|benefits
|text
|
|
|
|List of benefits or disadvantages when reaching this rank
|-
|ADD
|player_title
|varchar(100)
|
|
|
|Optional title the player gets when reaching this rank
|-
|ADD
|decals_list
|varchar(100)
|
|
|
|Optional list of IDS, separate by | corresponding to the material data table
|-
|ADD
|affect_prices
|tinyint(4)
|
|0
|
|percentage of change in price, can be positive or negative
|-
|ADD
|prevents_trading
|tinyint(4)
|
|0
|
|0=does not prevent trades, 1=prevent trades
|}

Codex storyTable

2022-01-11T13:47:12Z

Grimston: Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(11) |PRI | |auto_increment | |- |ADD |item_type |int(11) | | | |1 = homeworld story, 2 = chapter1, 3 = chapter2 |- |ADD |item_name |varchar(100) | | | |ex.: Homeworld Story, Race, ... |- |ADD |item_icon |varchar(100) | | | | |- |ADD |item_creative |text | | | |creative definition like for books, which may contain images/text |}"

{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|ADD
|id
|int(11)
|PRI
|
|auto_increment
|
|-
|ADD
|item_type
|int(11)
|
|
|
|1 = homeworld story, 2 = chapter1, 3 = chapter2
|-
|ADD
|item_name
|varchar(100)
|
|
|
|ex.: Homeworld Story, Race, ...
|-
|ADD
|item_icon
|varchar(100)
|
|
|
|
|-
|ADD
|item_creative
|text
|
|
|
|creative definition like for books, which may contain images/text
|}