Main public logs

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).

• 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