Useful queries: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

28 March 2023

  • curprev 20:3520:35, 28 March 2023 Talad talk contribs 906 bytes +448 No edit summary Tag: Visual edit
  • curprev 20:2720:27, 28 March 2023 Talad talk contribs 458 bytes +458 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
Retrieved from "https://planeshift.top-ix.org//pswiki/index.php/Useful_queries"