User contributions for Grimston
Jump to navigation
Jump to search
11 January 2022
- 15:3315:33, 11 January 2022 diff hist −41 m DatabaseDesign →Unsorted Tables
- 15:3015:30, 11 January 2022 diff hist +1,957 DatabaseDesign No edit summary Tag: Visual edit
- 15:3015: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
- 15:2915: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
- 15:2815: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
- 15:2715: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
- 15:2615: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
- 15:2515: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..."
- 15:2215: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
- 15:1915:19, 11 January 2022 diff hist −4 m TribesTable No edit summary current
- 15:1815: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
- 15:1715:17, 11 January 2022 diff hist −81 m Tribe membersTable No edit summary current
- 15:1515:15, 11 January 2022 diff hist −45 m Trade processesTable No edit summary current
- 15:1215:12, 11 January 2022 diff hist −112 m SpellsTable No edit summary current
- 15:1115:11, 11 January 2022 diff hist −3 m SkillsTable No edit summary current
- 15:1015:10, 11 January 2022 diff hist −153 m SectorsTable No edit summary
- 15:0815:08, 11 January 2022 diff hist −9 m Sc waypointsTable No edit summary current
- 15:0815:08, 11 January 2022 diff hist −222 m Sc waypointsTable No edit summary
- 15:0715:07, 11 January 2022 diff hist −3 m Sc waypoint aliasesTable No edit summary current
- 15:0615:06, 11 January 2022 diff hist −4 m Sc tribe resourcesTable No edit summary current
- 15:0515: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
- 15:0415: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
- 15:0315:03, 11 January 2022 diff hist −219 m Sc path pointsTable No edit summary current
- 15:0015: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
- 14:5814:58, 11 January 2022 diff hist −295 m Sc locationsTable No edit summary current
- 14:5514:55, 11 January 2022 diff hist −41 m Quest scriptsTable No edit summary current
- 14:5114:51, 11 January 2022 diff hist −15 m Npc hired npcsTable No edit summary current
- 14:5014:50, 11 January 2022 diff hist −42 m Natural resourcesTable No edit summary
- 14:4714:47, 11 January 2022 diff hist −62 m Loot rule detailsTable No edit summary current
- 14:4614:46, 11 January 2022 diff hist −9 m Loot modifiers restrainsTable No edit summary current
- 14:4414:44, 11 January 2022 diff hist −83 m Item instancesTable No edit summary
- 14:4114:41, 11 January 2022 diff hist −345 m Hunt locationsTable No edit summary current
- 14:3814:38, 11 January 2022 diff hist −45 m GuildsTable No edit summary current
- 14:3614:36, 11 January 2022 diff hist +37 m Gm eventsTable No edit summary current
- 14:3314:33, 11 January 2022 diff hist −311 m CharactersTable No edit summary current
- 14:2614:26, 11 January 2022 diff hist −9 m Character variablesTable No edit summary current
- 14:2514:25, 11 January 2022 diff hist +80 m Character questsTable No edit summary
- 14:2314:23, 11 January 2022 diff hist −9 m Character factionsTable No edit summary current
- 14:2114:21, 11 January 2022 diff hist −39 m AttacksTable No edit summary current
- 14:2014:20, 11 January 2022 diff hist −18 m Attack typesTable No edit summary current
- 14:1914:19, 11 January 2022 diff hist +37 m AlliancesTable No edit summary current
- 14:1614:16, 11 January 2022 diff hist −18 m AccountsTable No edit summary current
- 14:1214:12, 11 January 2022 diff hist +46 m PetitionsTable No edit summary current
- 14:1114:11, 11 January 2022 diff hist −44 m BansTable No edit summary current
- 13:5213: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
- 13:5113: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
- 13:5013: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. |}"
- 13:4913: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 |}"
- 13:4813: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
- 13:4713: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