Commits

Carey Tilden committed a522766

Created queries for mapping spellbound caves

  • Participants
  • Parent commits df72e9f

Comments (0)

Files changed (1)

File share/SuperHostile10-mapping.sql

+\pset format unaligned
+
+select distinct st_x(player_location)::int || ',' || st_y(player_location)::int || ',' || st_z(player_location)::int as coords, log_entry_type_name, player_user_name, damage_type_name
+from log_entry_list where server_cwd_basename = 'SuperHostile10' and world_name = 'world' and log_entry_type_name = 'Player died' \g | gvim -
+
+select distinct st_x(player_location)::int || ',' || st_y(player_location)::int || ',' || st_z(player_location)::int as coords, log_entry_type_name, player_user_name, damage_type_name
+from log_entry_list where server_cwd_basename = 'SuperHostile10' and world_name = 'world' and log_entry_type_name = 'Player moved' \g | gvim -
+
+select distinct st_x(player_location)::int || ',' || st_y(player_location)::int || ',' || st_z(player_location)::int as coords, log_entry_type_name, player_user_name, damage_type_name
+from log_entry_list where server_cwd_basename = 'SuperHostile10' and world_name = 'world_nether' and log_entry_type_name = 'Player died' \g | gvim -
+
+select distinct st_x(player_location)::int || ',' || st_y(player_location)::int || ',' || st_z(player_location)::int as coords, log_entry_type_name, player_user_name, damage_type_name
+from log_entry_list where server_cwd_basename = 'SuperHostile10' and world_name = 'world_nether' and log_entry_type_name = 'Player moved' \g | gvim -