User contributions for Grimston
Jump to navigation
Jump to search
11 January 2022
- 13:4613:46, 11 January 2022 diff hist +838 N Codex natureTable 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 basic creatures, 2 sentient creatures, 3 plants, 4 minerals |- |ADD |ref_id |int(11) | | | |points to race_info or item_stats table based on the item_type value |- |ADD |item_name |varchar(100) | | | |ex.: Habitat, Ecology, ... |- |ADD |item_desc |text | | | |the knowledge we provide to the player |- |ADD..." current
- 13:4613:46, 11 January 2022 diff hist +794 N Codex locationsTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(11) |PRI | |auto_increment | |- |ADD |item_type |varchar(100) | | | |1 = location on main map, 2 = submap owned, 3 = NPC |- |ADD |item_name |varchar(100) | | | |ex.: Stone Labirynths, Hydlaa City, Ojaveda, ... |- |ADD |item_desc |text | | | |the knowledge we provide to the player |- |ADD |item_icon |varchar(100) | | | | |- |ADD |mainmap_id |int(11) | | | |if item_type is..." current
- 13:4513:45, 11 January 2022 diff hist +393 N Codex factionsTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(11) |PRI | |auto_increment | |- |ADD |ref_id |int(11) | | | |points to factions table id |- |ADD |item_name |varchar(100) | | | |ex.: Purpose, Organization, Notable people, ... |- |ADD |item_desc |text | | | |the knowledge we provide to the player |- |ADD |item_icon |varchar(100) | | | | |}" current
- 13:4413:44, 11 January 2022 diff hist +345 N Character variablesTable Created page with "Used to store variables for a character {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |character_id |int(10) unsigned |PRI |0 | |The character this variable is assigned to |- |ADD |name |varchar(255) |PRI | | |The name of the variable |- |ADD |value |varchar(255) | | | |The value of the variable |}"
- 13:4313:43, 11 January 2022 diff hist +386 N Character factionsTable Created page with "Stores the faction of the characters {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |character_id |int(10) unsigned |PRI |0 | |The PID of the character this faction is assigned to |- |ADD |faction_id |int(10) unsigned |PRI |0 | |The id of the faction the points are for |- |ADD |value |int(10) | |0 | |The number of points in this faction |}"
- 13:4113:41, 11 January 2022 diff hist +467 N Character discoveriesTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(11) |PRI | |auto_increment | |- |ADD |character_id |int(11) | | | |the player who discovered this item |- |ADD |knowledge_type |tinyint(4) | | | |1 = codexCreatures, 2 = codexPlantMinerals, 3 = codexLocationsLoc, 4 = codexLocationsNPC, 5= codexStory, 6= codexFactions |- |ADD |childtable_id |int(11) | | | |Points to the ID of the specific table based on the type |}" current
- 13:3913:39, 11 January 2022 diff hist +786 N Attack typesTable Created page with "Holds attack types to be used in the updated combat system {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(11) |PRI | |auto_increment |holds the attack type unique id number |- |ADD |name |varchar(40) |UNI | | |is the attack type name, each name must be unique. |- |ADD |weaponID |int(11) | | | |item_stats.id if a specific weapon is required for the special attack. Otherwise, weaponTypeID should be filled in. |- |ADD |w..."
- 13:3913:39, 11 January 2022 diff hist +1,567 N AttacksTable Created page with "Holds attacks {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(11) |PRI | |auto_increment |holds the attacks unique id number |- |ADD |name |varchar(40) |UNI |default | |is the attacks name, each name must be unique. |- |ADD |image_name |varchar(200) | | | |the icon image |- |ADD |attack_anim |varchar(40) | | | |The visual effect of the attack |- |ADD |attack_description |text | | | |a short description of the attack..."
- 13:3613:36, 11 January 2022 diff hist +280 N Wc statisticsTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) |PRI | |auto_increment | |- | |groupid |tinyint(3) | | | | |- | |periodname |varchar(50) | | | | |- | |result |int(10) unsigned | | | | |- | |param1 |int(10) unsigned | | | | |}" current
- 13:3613:36, 11 January 2022 diff hist +221 N Wc cmdlogTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) |PRI | |auto_increment | |- | |username |varchar(100) | | | | |- | |query |text | | | | |- | |date |datetime | | | | |}" current
- 13:3513:35, 11 January 2022 diff hist +241 N Wc accessrulesTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) |PRI | |auto_increment | |- | |security_level |tinyint(3) | | | | |- | |objecttype |varchar(50) | | | | |- | |access |tinyint(3) | | | | |}" current
- 13:3313:33, 11 January 2022 diff hist +183 WaysTable No edit summary current
- 13:3213:32, 11 January 2022 diff hist +241 N WarningsTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |accountid |int(10) unsigned |PRI | | | |- | |warningGM |varchar(45) |PRI | | | |- | |timeOfWarn |datetime |PRI | | | |- | |warnMessage |text | | | | |}" current
- 13:3113:31, 11 January 2022 diff hist −1,217 TribesTable No edit summary
- 13:3013:30, 11 January 2022 diff hist +511 N Tribe needsTable Created page with "This table is no longer used within PSUnreal. {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |tribe_id |int(10) |PRI | | | |- | |need_set |int(10) | |0 | | |- | |need_id |int(10) |PRI | | | |- | |type |varchar(30) | | | | |- | |name |varchar(30) | | | | |- | |perception |varchar(30) | | | | |- | |depend |varchar(30) | | | | |- | |need_start_value |float(10,2) | |0.00 | | |- | |need_growth_value |float(10,2) | |0.00 | | |- |..." current
- 13:2813:28, 11 January 2022 diff hist +352 N Tribe membersTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |tribe_id |int(10) |PRI | | | |- | |member_id |int(10) unsigned |PRI | | | |- |DIF |member_type |varchar(30) | |0 | | Type used to be 'int(10)' in PSLegacy. Default used to be '' in PSLegacy. |- |ADD |flags |varchar(200) | | | |Various flags like: DYNAMIC, ... |}"
- 13:2713:27, 11 January 2022 diff hist +466 N TraitsTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) unsigned |PRI | |auto_increment | |- | |next_trait |int(10) | | -1 | | |- | |race_id |int(30) | | | | |- | |only_npc |int(1) | | | | |- | |location |varchar(30) | | | | |- | |name |varchar(30) | | | | |- | |cstr_mesh |varchar(200) | | | | |- | |cstr_material |varchar(200) | | | | |- | |cstr_texture |varchar(200) | | | | |- | |shader |varchar(32) | | | | |}" current
- 13:2613:26, 11 January 2022 diff hist +306 N Trainer skillsTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |player_id |int(10) unsigned |PRI |0 | | |- | |skill_id |int(10) unsigned |PRI |0 | | |- | |min_rank |int(8) unsigned |PRI |0 | | |- | |max_rank |int(8) unsigned | |0 | | |- | |min_faction |float(10,2) | |0.00 | | |}" current
- 13:2513:25, 11 January 2022 diff hist +491 Trade transformationsTable No edit summary current
- 13:2413:24, 11 January 2022 diff hist +1,362 Trade processesTable No edit summary
- 13:2313:23, 11 January 2022 diff hist +100 Trade patternsTable No edit summary current
- 13:2113:21, 11 January 2022 diff hist +250 N Trade constraintsTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) unsigned |PRI | |auto_increment | |- | |constrnt |varchar(64) | | | | |- | |message |varchar(128) | | | | |- | |description |varchar(255) | | | | |}" current
- 13:2113:21, 11 January 2022 diff hist +131 Trade combinationsTable No edit summary current
- 13:2013:20, 11 January 2022 diff hist +115 Trade autocontainersTable No edit summary current
- 13:1913:19, 11 January 2022 diff hist +160 N TipsTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) unsigned |PRI | |auto_increment | |- | |tip |text | | | | |}" current
- 13:1913:19, 11 January 2022 diff hist +515 N StancesTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(8) unsigned |PRI | |auto_increment | |- | |name |varchar(30) |UNI |0 | | |- | |stamina_drain_P |float(3,2) unsigned | |0.00 | | |- | |stamina_drain_M |float(3,2) unsigned | |0.00 | | |- | |attack_speed_mod |float(3,2) unsigned | |0.00 | | |- | |attack_damage_mod |float(3,2) unsigned | |0.00 | | |- | |defense_avoid_mod |float(3,2) unsigned | |0.00 | | |- | |defense_absorb_..." current
- 13:1713:17, 11 January 2022 diff hist +37 SpellsTable No edit summary
- 13:1413:14, 11 January 2022 diff hist +45 Spell glyphsTable No edit summary current
- 13:1313:13, 11 January 2022 diff hist +523 N SkillsTable Created page with "{| 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 | | |- |ADD |cost_script |varchar(255) | |CalculateSkillCosts | |Stores the script to be r..."
- 13:1113:11, 11 January 2022 diff hist +166 N Server optionsTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |option_name |varchar(50) |PRI | | | |- | |option_value |varchar(90) | | | | |}" current
- 13:1013:10, 11 January 2022 diff hist +163 N Security levelsTable Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |level |tinyint(3) unsigned |PRI |0 | | |- | |title |varchar(30) | |0 | | |}" current
- 13:0913:09, 11 January 2022 diff hist +5,599 SectorsTable No edit summary
- 13:0713:07, 11 January 2022 diff hist +388 Sc waypointsTable No edit summary
- 13:0613:06, 11 January 2022 diff hist +92 Sc waypoint linksTable No edit summary current
- 13:0513:05, 11 January 2022 diff hist +301 N Sc waypoint aliasesTable Created page with "{| 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) | | | | |- |ADD |rotation_angle |float | |0 | |The direction in degrees to face when stopping at WP. |}"
- 13:0413:04, 11 January 2022 diff hist +90 Sc tribe resourcesTable No edit summary
- 13:0413:04, 11 January 2022 diff hist +118 Sc tribe memoriesTable No edit summary current
- 13:0313:03, 11 January 2022 diff hist +341 Sc path pointsTable No edit summary
- 13:0313:03, 11 January 2022 diff hist +81 Sc npc definitionsTable No edit summary current
- 13:0213:02, 11 January 2022 diff hist +439 Sc locationsTable No edit summary
- 13:0113:01, 11 January 2022 diff hist +56 Sc location typeTable No edit summary current
- 13:0113:01, 11 January 2022 diff hist +313 N Race spawnsTable Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |raceid |int(11) |PRI |0 | | |- | |x |float |PRI |0 | | |- | |y |float |PRI |0 | | |- | |z |float |PRI |0 | | |- | |yrot |float |PRI |0 | | |- | |range |float unsigned |PRI |0 | | |- | |sector_id |int(11) |PRI |3 | | |}" current
- 12:5912:59, 11 January 2022 diff hist +540 Race infoTable No edit summary current
- 12:5612:56, 11 January 2022 diff hist +561 N QuestsTable Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) unsigned |PRI | |auto_increment | |- | |name |varchar(40) |UNI | | | |- | |task |varchar(250) | | | | |- | |cstr_icon |varchar(200) | | | | |- | |flags |tinyint(3) unsigned | |0 | | |- | |master_quest_id |int(10) unsigned | | | | |- | |minor_step_number |tinyint(3) unsigned | |0 | | |- | |player_lockout_time |int(10) | |0 | | |- | |quest_lockout_time |int(10) | |0..." current
- 12:5512:55, 11 January 2022 diff hist +331 N Quest scriptsTable Created page with " {| 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. |- |DIF |script |text | | | |The script for the quest, parsed by questmanager.cpp Type used to be 'blob' in PSLegacy. |}"
- 12:5312:53, 11 January 2022 diff hist +154 N ProgressionEventsTable Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |name |varchar(40) |PRI | | | |- | |event_script |text | | | | |}"
- 12:5212:52, 11 January 2022 diff hist +30 Player spellsTable No edit summary current
- 12:5112:51, 11 January 2022 diff hist +512 N PetitionsTable Created page with " {| 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_le..."
- 12:5012:50, 11 January 2022 diff hist +78 Npc triggersTable No edit summary current
- 12:5012:50, 11 January 2022 diff hist +72 Npc trigger groupsTable No edit summary current