Main public logs

Jump to navigation Jump to search

Combined display of all available logs of PSwiki. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

Logs
(newest | oldest) View ( | older 50) (20 | 50 | 100 | 250 | 500)
  • 13:46, 11 January 2022 Grimston talk contribs created page 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...")
  • 13:45, 11 January 2022 Grimston talk contribs created page 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) | | | | |}")
  • 13:44, 11 January 2022 Grimston talk contribs created page 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:43, 11 January 2022 Grimston talk contribs created page 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:41, 11 January 2022 Grimston talk contribs created page 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 |}")
  • 13:39, 11 January 2022 Grimston talk contribs created page 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:39, 11 January 2022 Grimston talk contribs created page 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:36, 11 January 2022 Grimston talk contribs created page 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 | | | | |}")
  • 13:36, 11 January 2022 Grimston talk contribs created page 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 | | | | |}")
  • 13:35, 11 January 2022 Grimston talk contribs created page 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) | | | | |}")
  • 13:32, 11 January 2022 Grimston talk contribs created page 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 | | | | |}")
  • 13:30, 11 January 2022 Grimston talk contribs created page 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 | | |- |...")
  • 13:28, 11 January 2022 Grimston talk contribs created page 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:27, 11 January 2022 Grimston talk contribs created page 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) | | | | |}")
  • 13:26, 11 January 2022 Grimston talk contribs created page 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 | | |}")
  • 13:21, 11 January 2022 Grimston talk contribs created page 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) | | | | |}")
  • 13:19, 11 January 2022 Grimston talk contribs created page TipsTable (Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) unsigned |PRI | |auto_increment | |- | |tip |text | | | | |}")
  • 13:19, 11 January 2022 Grimston talk contribs created page 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_...")
  • 13:13, 11 January 2022 Grimston talk contribs created page 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:11, 11 January 2022 Grimston talk contribs created page Server optionsTable (Created page with "{| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |option_name |varchar(50) |PRI | | | |- | |option_value |varchar(90) | | | | |}")
  • 13:10, 11 January 2022 Grimston talk contribs created page 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 | | |}")
  • 13:05, 11 January 2022 Grimston talk contribs created page 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:01, 11 January 2022 Grimston talk contribs created page 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 | | |}")
  • 12:56, 11 January 2022 Grimston talk contribs created page 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...")
  • 12:55, 11 January 2022 Grimston talk contribs created page 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:53, 11 January 2022 Grimston talk contribs created page ProgressionEventsTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |name |varchar(40) |PRI | | | |- | |event_script |text | | | | |}")
  • 12:51, 11 January 2022 Grimston talk contribs created page 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:43, 11 January 2022 Grimston talk contribs created page Movement typesTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(11) |PRI | | | |- | |name |varchar(100) | | | | |- | |base_move_x |float | |0 | |x-direction motion |- | |base_move_y |float | |0 | |y-direction motion |- | |base_move_z |float | |0 | |z-direction motion |- | |base_rotate_x |float | |0 | |x-axis rotation |- | |base_rotate_y |float | |0 | |y-axis rotation |- | |base_rotate_z |float | |0 | |z-axis rotation |}")
  • 12:42, 11 January 2022 Grimston talk contribs created page Movement modesTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(11) |PRI | | | |- | |name |varchar(100) | | | | |- | |move_mod_x |float | |1 | |x-direction motion multiplier |- | |move_mod_y |float | |1 | |y-direction motion multiplier |- | |move_mod_z |float | |1 | |z-direction motion multiplier |- | |rotate_mod_x |float | |1 | |x-axis rotation multiplier |- | |rotate_mod_y |float | |1 | |y-axis rotation multiplier |- | |rotate_mod...")
  • 12:41, 11 January 2022 Grimston talk contribs created page Money eventsTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(8) unsigned |PRI | | | |- | |taxid |int(8) unsigned | | | | |- | |guild |tinyint(1) | | | | |- | |nextEvent |mediumint(6) unsigned | | | | |- | |inter |int(3) | | | | |- | |totaltrias |int(10) | | | | |- | |prg_evt_paid |text | | | | |- | |prg_evt_npaid |text | | | | |- | |prg_evn_fnpaid |text | | | | |- | |latePayment |tinyint(1) | | | | |- | |lateBy |int(3) | | | |...")
  • 12:39, 11 January 2022 Grimston talk contribs created page MigrationTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(8) unsigned |PRI | |auto_increment | |- | |username |varchar(50) |UNI |0 | | |- | |script |text | | | | |- | |email |varchar(64) | | | | |- | |time |int(12) | | | | |- | |done |char(1) | |N | | |}")
  • 12:38, 11 January 2022 Grimston talk contribs created page Merchant item categoriesTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |player_id |int(8) unsigned |PRI |0 | | |- | |category_id |int(8) unsigned |PRI |0 | | |}")
  • 12:35, 11 January 2022 Grimston talk contribs created page MathscriptTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |name |varchar(40) |PRI | | | |- | |math_script |text | | | | |}")
  • 12:34, 11 January 2022 Grimston talk contribs created page Loot rulesTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) unsigned |PRI | |auto_increment | |- | |name |varchar(30) |UNI | | | |}")
  • 12:34, 11 January 2022 Grimston talk contribs created page Loot rule detailsTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- |DIF |id |int(11) |PRI | |auto_increment | Type used to be 'int(10) unsigned' in PSLegacy. |- | |loot_rule_id |int(10) unsigned | |0 | | |- | |item_stat_id |int(10) unsigned | |0 | | |- | |probability |float(5,4) | |0.0000 | | |- | |min_money |int(10) unsigned | |0 | | |- | |max_money |int(10) unsigned | |0 | | |- | |randomize |tinyint(1) | |0 | | |- |ADD |min_item |int(10) unsign...")
  • 12:33, 11 January 2022 Grimston talk contribs created page Loot modifiersTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) unsigned |PRI | |auto_increment | |- | |modifier_type |varchar(20) | | | | |- | |name |varchar(255) | | | | |- | |effect |text | | | | |- | |probability |float | | | | |- | |stat_req_modifier |text | | | | |- | |cost_modifier |float | | | | |- | |mesh |varchar(255) | | | |Defines a mesh to be placed as a replacement in case this modifier is selected. (priority rule:...")
  • 12:21, 11 January 2022 Grimston talk contribs created page IntroductionsTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |charid |int(10) unsigned |PRI | | | |- | |introcharid |int(10) unsigned |PRI | | | |}")
  • 12:10, 11 January 2022 Grimston talk contribs created page Gm eventsTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) |PRI |0 | | |- | |name |varchar(40) | | | | |- | |description |blob | | | | |- | |status |int(11) | |0 | | |- | |gm_id |int(10) | |0 | | |- |ADD |date_created |timestamp | |CURRENT_TIMESTAMP | | |}")
  • 12:10, 11 January 2022 Grimston talk contribs created page Gm command logTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) unsigned |PRI | |auto_increment | |- | |account_id |int(10) unsigned | |0 | | |- | |gm |int(10) | |0 | | |- | |command |varchar(200) | |/none | | |- | |player |int(10) | |0 | | |- | |ex_time |datetime | | | | |}")
  • 12:07, 11 January 2022 Grimston talk contribs created page Familiar typesTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(10) unsigned |PRI | | | |- | |name |varchar(30) | | | | |- | |type |varchar(30) | | | | |- | |lifecycle |varchar(30) | | | | |- | |attacktool |varchar(30) | | | | |- | |attacktype |varchar(30) | | | | |- | |magicalaffinity |varchar(30) | | | | |- | |vision |int(11) | | | | |- | |speed |int(11) | | | | |- | |hearing |int(11) | | | | |}")
  • 12:06, 11 January 2022 Grimston talk contribs created page FactionsTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(8) unsigned |PRI | |auto_increment | |- | |faction_name |varchar(40) | | | | |- | |faction_description |text | | | | |- | |faction_character |text | | | | |- | |faction_weight |float(6,3) | |1.000 | | |}")
  • 12:04, 11 January 2022 Grimston talk contribs created page Command groupsTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(8) unsigned |PRI | | | |- | |group_name |varchar(40) | | | | |}")
  • 12:04, 11 January 2022 Grimston talk contribs created page Command group assignmentTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |command_name |varchar(40) |PRI | | | |- | |group_member |int(8) |PRI | | | |}")
  • 11:47, 11 January 2022 Grimston talk contribs created page Char create life relationsTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |choice |int(8) | | | | |- | |adds_choice |int(8) | |0 | | |- | |removes_choice |int(8) | |0 | | |}")
  • 11:46, 11 January 2022 Grimston talk contribs created page Char create lifeTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(8) unsigned |PRI | |auto_increment | |- | |name |varchar(80) | |0 | | |- | |description |text | | | | |- | |cp_cost |int(8) | |0 | | |- | |scriptname |varchar(255) | | | | |- | |is_base |char(1) | | | | |}")
  • 11:45, 11 January 2022 Grimston talk contribs created page Char create affinityTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |attribute |varchar(20) | | | | |- | |category |varchar(20) |PRI | | | |}")
  • 11:44, 11 January 2022 Grimston talk contribs created page BansTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |account |int(10) unsigned |PRI |0 | | |- |DIF |ip_range |char(15) | | | | Type used to be 'char(1)' in PSLegacy. |- | |start |int(20) unsigned | |0 | | |- | |end |int(20) unsigned | |0 | | |- | |reason |text | | | | |- | |ban_ip |tinyint(1) | |0 | |Account banned by IP as well |}")
  • 11:42, 11 January 2022 Grimston talk contribs created page Bad namesTable (Created page with "Names that should be disallowed {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(8) |PRI | |auto_increment | |- | |name |text | | | | |}")
  • 11:38, 11 January 2022 Grimston talk contribs created page Armor vs weaponTable (Created page with " {| class="wikitable" |+ !UE !Field !Type !Key Type !Default !Extra !Description |- | |id |int(5) |PRI | |auto_increment | |- | |1a |float | |0 | | |- | |1b |float | |0 | | |- | |1c |float | |0 | | |- | |1d |float | |0 | | |- | |2a |float | |0 | | |- | |2b |float | |0 | | |- | |2c |float | |0 | | |- | |3a |float | |0 | | |- | |3b |float | |0 | | |- | |3c |float | |0 | | |- | |weapon_type |varchar(20) | | | | |}")
  • 14:15, 6 February 2020 User account Grimston talk contribs was created
(newest | oldest) View ( | older 50) (20 | 50 | 100 | 250 | 500)
Retrieved from "https://planeshift.top-ix.org//pswiki/index.php/Special:Log/Grimston"