User contributions for Grimston
Jump to navigation
Jump to search
- 17:33, 11 January 2022 diff hist −41 m DatabaseDesign →Unsorted Tables
- 17:30, 11 January 2022 diff hist +1,957 DatabaseDesign Tag: Visual edit
- 17:30, 11 January 2022 diff hist +158 N Wc servernewsTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(10) |PRI | |auto_increment | |- |ADD |news |text | | | | |}" current
- 17:29, 11 January 2022 diff hist +227 N Voice overs npcTable 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) | | | | |}" current
- 17:28, 11 January 2022 diff hist +977 N Voice oversTable 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..." current
- 17:27, 11 January 2022 diff hist +696 N Traps propertiesTable 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..." current
- 17:26, 11 January 2022 diff hist +670 N Skills abilitiesTable 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..." current
- 17:25, 11 January 2022 diff hist +1,195 N Random eventsTable 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..."
- 17:22, 11 January 2022 diff hist +355 N Weapon typesTable 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 |}" current
- 17:19, 11 January 2022 diff hist −4 m TribesTable current
- 17:18, 11 January 2022 diff hist +312 N Tribe recipesTable 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 | | |}" current
- 17:17, 11 January 2022 diff hist −81 m Tribe membersTable current
- 17:15, 11 January 2022 diff hist −45 m Trade processesTable current
- 17:12, 11 January 2022 diff hist −112 m SpellsTable current
- 17:11, 11 January 2022 diff hist −3 m SkillsTable current
- 17:10, 11 January 2022 diff hist −153 m SectorsTable
- 17:08, 11 January 2022 diff hist −9 m Sc waypointsTable current
- 17:08, 11 January 2022 diff hist −222 m Sc waypointsTable
- 17:07, 11 January 2022 diff hist −3 m Sc waypoint aliasesTable current
- 17:06, 11 January 2022 diff hist −4 m Sc tribe resourcesTable current
- 17:05, 11 January 2022 diff hist +199 N Sc tribe knowledgeTable 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) | | | | |}" current
- 17:04, 11 January 2022 diff hist +479 N Sc tribe assetsTable 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 | |..." current
- 17:03, 11 January 2022 diff hist −219 m Sc path pointsTable current
- 17:00, 11 January 2022 diff hist +872 N Sc npctypesTable 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..." current
- 16:58, 11 January 2022 diff hist −295 m Sc locationsTable current
- 16:55, 11 January 2022 diff hist −41 m Quest scriptsTable current
- 16:51, 11 January 2022 diff hist −15 m Npc hired npcsTable current
- 16:50, 11 January 2022 diff hist −42 m Natural resourcesTable current
- 16:47, 11 January 2022 diff hist −62 m Loot rule detailsTable current
- 16:46, 11 January 2022 diff hist −9 m Loot modifiers restrainsTable current
- 16:44, 11 January 2022 diff hist −83 m Item instancesTable
- 16:41, 11 January 2022 diff hist −345 m Hunt locationsTable current
- 16:38, 11 January 2022 diff hist −45 m GuildsTable current
- 16:36, 11 January 2022 diff hist +37 m Gm eventsTable current
- 16:33, 11 January 2022 diff hist −311 m CharactersTable current
- 16:26, 11 January 2022 diff hist −9 m Character variablesTable current
- 16:25, 11 January 2022 diff hist +80 m Character questsTable
- 16:23, 11 January 2022 diff hist −9 m Character factionsTable current
- 16:21, 11 January 2022 diff hist −39 m AttacksTable current
- 16:20, 11 January 2022 diff hist −18 m Attack typesTable current
- 16:19, 11 January 2022 diff hist +37 m AlliancesTable current
- 16:16, 11 January 2022 diff hist −18 m AccountsTable current
- 16:12, 11 January 2022 diff hist +46 m PetitionsTable current
- 16:11, 11 January 2022 diff hist −44 m BansTable current
- 15:52, 11 January 2022 diff hist +386 N Pet evolutionTable 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 |}" current
- 15:51, 11 January 2022 diff hist +476 N Pet abilitiesTable 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 |}" current
- 15:50, 11 January 2022 diff hist +336 N Npc hired npcsTable 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. |}"
- 15:49, 11 January 2022 diff hist +386 N Loot modifiers restrainsTable 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 |}"
- 15:48, 11 January 2022 diff hist +973 N Faction ranksTable 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..." current
- 15:47, 11 January 2022 diff hist +431 N Codex storyTable 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 |}" current