Commits

Carey Tilden committed 476d296

Created queries used for generating maps

Comments (0)

Files changed (1)

share/SuperHostile07-mapping.sql

+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 = 'SuperHostile07' and world_name = 'world' and log_entry_type_name = 'Player died' \g | vim -
+
+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 = 'SuperHostile07' and world_name = 'world' and log_entry_type_name = 'Player moved' \g | vim -
+
+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 = 'SuperHostile07' and world_name = 'world_nether' and log_entry_type_name = 'Player died' \g | vim -
+
+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 = 'SuperHostile07' and world_name = 'world_nether' and log_entry_type_name = 'Player moved' \g | vim -