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 ( | ) (20 | 50 | 100 | 250 | 500)
  • 20:27, 28 March 2023 Talad talk contribs created page Useful queries (Created page with " ===Guildhouse containers=== Extracts all items inside guildhouse containers without a proper loc_instance . This is required by the code to properly load items in guildhouses. select parent_item_id, id,loc_instance ,loc_sector_id from item_instances where loc_instance =0 and parent_item_id in ( select ii.id from item_instances ii, item_stats s where ii.item_stats_id_standard = s.id and loc_sector_id in (11,73,81,82,204) and s.container_max_slots > 0);") Tag: Visual edit
  • 22:12, 1 February 2023 Talad talk contribs created page Reload - Reloading at runtime (Created page with " This is a list of all the tables in the game, and what we can or cannot reload. *accounts - Not needed. *action_location - YES Use /window gm show, then click on . *armor_vs_weapons - This table contains the rules related to the damages inflicted by a specific weapon against a specific armor, it's quite important to be able to reload this info *character_creation and char_create* - all these tables are very important, and should be reloadable with the live server to al...") Tag: Visual edit
  • 21:09, 18 January 2023 Talad talk contribs moved page Compiling Mumble Lib to Voice Chat without leaving a redirect
  • 19:58, 16 January 2023 Talad talk contribs created page Compiling Mumble Lib (Created page with " 1) Install CMake 2) Install vcpkg https://vcpkg.io/en/getting-started.html 3) vcpkg --triplet x64-windows-static-md install opus Opus_DIR My vcvars: E:\VisualStudio2022\VC\Auxiliary\Build\vcvars64.bat") Tag: Visual edit
  • 23:04, 5 January 2023 Talad talk contribs created page Build one Unreal Engine Plugin only (Created page with " Example building Unreal Midi on my machine: G:\5.0.3-release\Engine\Build\BatchFiles>RunUAT.bat BuildPlugin -plugin="G:\5.0.3-release\Engine\Plugins\Marketplace\MidiAsset\MidiAsset.uplugin" -package="F:\temp\UnrealMidi" -TargetPlatforms=Win64 Reference: https://dev.epicgames.com/community/learning/tutorials/0RG4/compiling-a-plugin-for-a-new-engine-version") Tag: Visual edit
  • 21:55, 21 December 2022 Talad talk contribs created page Minigames (Created page with "All minigames use GameboardsTable to define the basics of the game. Minigamemanager is called by the client to initiate a game with the following server-side methods MiniGameManager::HandleStartGameRequest() psMiniGameSession::AddPlayer() psMiniGameSession::SendInitialMGSetup() GetPSController()->ReceiveMGInitialBoardSetup() Then the client receives the request in PlayerController and displays the minigame window, and differs by game ty...") Tag: Visual edit: Switched
  • 18:12, 21 October 2022 Talad talk contribs created page Races and Traits IDs (Created page with "{| class="wikitable" |+Race IDs |0 |Stonehammer |M |- |1 |Enkidukai |M |- |2 |Ynnwn |M |- |3 |Ylian |M |- |4 |Xacha |M |- |5 |Nolthrir |M |- |6 |Dermorian |M |- |7 |Hammerwielder |M |- |8 |Diaboli |M |- |9 |Kran |N |- |10 |Lemur |M |- |11 |Klyros |M |- |12 |Enkidukai |F |- |13 |Stonehammer |F |- |14 |Ynnwn |F |- |15 |Ylian |F |- |16 |Xacha |F |- |17 |Nolthrir |F |- |18 |Dermorian |F |- |19 |Hammerwielder |F |- |20 |Diaboli |F |- |21 |Lemur |F |- |22 |Klyros |F |- |23 |Ro...") Tag: Visual edit
  • 17:56, 16 October 2022 Talad talk contribs created page Add Waypoints and paths (Created page with "Refer also to: NPC Behaviour page, where the waypoints data model is explained.") Tag: Visual edit
  • 23:37, 6 October 2022 Talad talk contribs created page Add new NPC (Created page with " Best method is through the webconsole. NPCs -> Create NPC") Tag: Visual edit
  • 20:37, 5 October 2022 Talad talk contribs created page Setting Items (Created page with " Developer or GMs can drop items in the game to populate an area, example tables, chairs, boxes, minigames. To do this: 1) spawn the item in your inventory 2) drop the item to the ground or in the location you want it 3) use the transform tool to position it / rotate it 4) target the item and <blockquote>/modify target transient false /modify target pickupable false /modify target pickupableweak false /modify target settingitem true</blockquote>") Tag: Visual edit
  • 21:02, 8 September 2022 Talad talk contribs created page File:Ka structure.jpg
  • 21:02, 8 September 2022 Talad talk contribs uploaded File:Ka structure.jpg
  • 21:38, 5 September 2022 Talad talk contribs created page KAs (Knowledge Areas) list and structure (Created page with "You can extract all the knowledge areas not specific to NPCs with this query: select distinct(nka.area) from npc_knowledge_areas nka left join `characters` c on nka.area=CONCAT(c.name, " ",c.lastname) where c.name is null; Pet KAs: * Pet Groffel 1 * Pet Yulbar 1 * Pet Rivnak 1 * Pet Drifter 1 * Pet Serpent Gobble 1 * Pet Eagle Gobble 1 * general * magic_basic * races_basic * Hydlaa_important_people * newbie * gods_basic_hydlaa * hydlaa_basic * goodbye01_hydlaa * Pro...") Tag: Visual edit
  • 17:28, 4 September 2022 Talad talk contribs created page Wordnet (Created page with "We are using Wordnet for the morphing of words , example plural form to singular form. Wordnet is a ThirdParty lib, we have in PSUnreal\ThirdParty\Wordnet, but be compiled separately and then its linked into our main executable. We are using version 2.1 of Wordnet Wordnet is initialized in NPCDialogDict::Initialize() DEFAULTPATH seems not to be properly working in Debug build, as the init fails to get the proper directory where the files are located. We downloaded t...") Tag: Visual edit
  • 16:49, 30 July 2022 Talad talk contribs created page Compendium Maps tokens (Created page with "# Take parchment piece and move it to a new picture # Smudge with large brush all the inside to give blur effect # Select Filter->Decor->Fuzzy Border #* use color: 62430a #* border size: 25 #* no blur, no shadow #* granularity 1.6 # Select GIMP Brush #31 #* Size 43 #* Spacing 1 #* Smudge tool # Rotate the brush angle for the borders to 90 degrees") Tag: Visual edit
  • 22:11, 2 July 2022 Talad talk contribs created page Errors in Database connection (Created page with " == Error: Can't initialize character set unknown (path: compiled_in) == LogSQL: Error: Failed to connect to database: Error: Can't initialize character set unknown (path: compiled_in) This happened after we upgraded on Windows the mysql DB from 5.5 to 8.0.29. This error was present when starting the PSUnreal server. We have seen the DB was using a character set utf8_mb4, collation: utf8mb4_0900_ai_ci , checking production db on linux MariaDB [planeshift_prod2]> SELE...") Tag: Visual edit
  • 18:54, 19 June 2022 Talad talk contribs created page Vision (Created page with "== Vision, nightvision, infravision == Vision, night-vision, and infra-vision are the three levels of vision to be found among the races. These three have different aspects to then when it comes to seeing in the dark or the depths of the labyrinths. Vision being blind in the dark. Night-vision being able to see well in the darkness but only where there is some light present. Infravision being able to see in the pitch black of darkness where no light at all is present. I...") Tag: Visual edit
  • 22:04, 24 May 2022 Talad talk contribs created page Maps editing workflow (Created page with " === Notes === * BuiltData files are storing: ** lightmap textures (created by Build Lighting only) ** volumetric light probes / samples (created by Build Lighting only) * umap files are storing: ** navigation paths (created by Build Paths) === Map creation flow === You should never upload BuiltData file in SVN. Those will be regenerated when we create the shipping release. If you want to test locally the full game including lights then you need to: * Load all the le...") Tag: Visual edit
  • 20:15, 24 May 2022 Talad talk contribs created page PSUnreal Navigation Meshes (Created page with " === Setup === 1 Persistent level (P-level) containing the lights and the skybox a number of sublevels , with geometry and landscape Project Settings -> Navmesh generation Static === General findings === The size of the navmesh is about 5Mb for a landscape level with 127x127 cell size, and cell number 10 = 127000 The navmesh is stored in the .umap file and not in the .BuiltData file. === Tests Performed === # One NavMeshBoundsVolume for each of the submap, stored i...") Tag: Visual edit
  • 10:46, 13 May 2022 Talad talk contribs created page PSUnreal Keyboard and mouse layout (Created page with "left") Tag: Visual edit
  • 10:43, 13 May 2022 Talad talk contribs created page File:PSUnreal Keyboard Layout b.jpg
  • 10:43, 13 May 2022 Talad talk contribs uploaded File:PSUnreal Keyboard Layout b.jpg
  • 17:00, 8 May 2022 Talad talk contribs created page PSUnreal Guildhouses (Created page with " To define a guild house entrance. We use actionlocations.triggertype == SELECT and actionlocations.responsetype == EXAMINE, then in the actionlocations.response we specify the entrance, example: <Examine><Entrance Type="ActionID" LockID="95" X="197765" Y="-314194" Z="10738.65" Rot="280" Sector="NPCroom" /><Return X="198233" Y="-314282" Z="10599.1" Rot="130" Sector="NPCroom" /><Description>...") Tag: Visual edit
  • 10:07, 1 May 2022 Talad talk contribs created page PSUnreal Foliage (Created page with " === Lights settings === Set all foliage to Moveable === Culling settings === Depending on the size of the foliage we have standard culling distances Flowers and small plants: 50 meters Bushes: 100 meters Trees: 500 meters (for now, let's see how much they pop)") Tag: Visual edit
  • 22:58, 20 April 2022 Talad talk contribs created page GIMP Custom brushes (Created page with "Enable Windows -> Doackable Dialogues -> Symmetry Painting , Horz + Vert + Center * Create a new image * Set it to Mode Grayscale * Paint your brush in black * If you go just by using the clipboard then when you select the brush select the clipboard mask * Otherwise if you save it , it will work directly. * To save it you need to put it in the brush folder. In my PC is here: F:\My Programs\Gfx\GIMP 2\share\gimp\2.0\brushes\") Tag: Visual edit
  • 19:51, 30 March 2022 Talad talk contribs created page Random event locsTable (Created page with "{| class="wikitable" !UE !Field !Type !Key Type !Default !Extra !Description |- |ADD |id |int(11) |PRI | |auto_increment | |- |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, ... |}") Tag: Visual edit: Switched
  • 16:07, 6 March 2022 Talad talk contribs created page TrapsPropertiesTable (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 |ti...") Tag: Visual edit
  • 15:55, 6 March 2022 Talad talk contribs created page Loot (Created page with "You can get loot through a number of methods: 1) Through quests, we have the possibility to reward players items or money. See [https://planeshift.top-ix.org/pswiki/index.php/Quest_scripts_syntax#Give Give] script directive. At the moment this cannot be randomized. 2) Harvesting loot items from Hunt Locations and Natural Resources, which spawn items on the ground or allow you to dig for items. At the moment this cannot be randomized. Only quality changes when harve...") Tag: Visual edit
  • 18:09, 27 February 2022 Talad talk contribs created page Crash fix on Linux (Created page with "If you experience a crash on Linux in 0.7.18 release when loading world, with the log saying VK_ERROR_DEVICE_LOST , try the following: Go in your config directory, check if there is a file called Engine.ini and then add this: [SystemSettings] r.AllowStaticLighting=0") Tag: Visual edit
  • 15:30, 11 January 2022 Grimston talk contribs created page 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 | | | | |}")
  • 15:29, 11 January 2022 Grimston talk contribs created page 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) | | | | |}")
  • 15:28, 11 January 2022 Grimston talk contribs created page 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...")
  • 15:27, 11 January 2022 Grimston talk contribs created page 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...")
  • 15:26, 11 January 2022 Grimston talk contribs created page 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...")
  • 15:25, 11 January 2022 Grimston talk contribs created page 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:22, 11 January 2022 Grimston talk contribs created page 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 |}")
  • 15:18, 11 January 2022 Grimston talk contribs created page 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 | | |}")
  • 15:05, 11 January 2022 Grimston talk contribs created page 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) | | | | |}")
  • 15:04, 11 January 2022 Grimston talk contribs created page 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 | |...")
  • 15:00, 11 January 2022 Grimston talk contribs created page 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...")
  • 13:52, 11 January 2022 Grimston talk contribs created page 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 |}")
  • 13:51, 11 January 2022 Grimston talk contribs created page 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 |}")
  • 13:50, 11 January 2022 Grimston talk contribs created page 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:49, 11 January 2022 Grimston talk contribs created page 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:48, 11 January 2022 Grimston talk contribs created page 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...")
  • 13:47, 11 January 2022 Grimston talk contribs created page 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 |}")
  • 13:46, 11 January 2022 Grimston talk contribs created page 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...")
  • 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 |}")
(newest | oldest) View ( | ) (20 | 50 | 100 | 250 | 500)
Retrieved from "https://planeshift.top-ix.org//pswiki/index.php/Special:Log"