https://statbus.s3.us-east-1.amazonaws. ... -27.sql.gz
This is a copy of the Feedback (stats) and Round tables (The data you see at https://sb.atlantaned.space/rounds) as of around 00:00 this morning. This is raw SQL, which means you'll need a mariaDB (or MySQL(?)) server to import the data into. I cannot offer support on setting this up. Feedback stats are all json, and saved in the json column.
Code: Select all
CREATE TABLE `ss13feedback` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`datetime` datetime NOT NULL,
`round_id` int(11) unsigned NOT NULL,
`key_name` varchar(32) NOT NULL,
`key_type` enum('text','amount','tally','nested tally','associative') NOT NULL,
`version` tinyint(3) unsigned NOT NULL,
`json` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4398458 DEFAULT CHARSET=utf8;
Code: Select all
CREATE TABLE `ss13round` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`initialize_datetime` datetime NOT NULL,
`start_datetime` datetime DEFAULT NULL,
`shutdown_datetime` datetime DEFAULT NULL,
`end_datetime` datetime DEFAULT NULL,
`server_ip` int(10) unsigned NOT NULL,
`server_port` smallint(5) unsigned NOT NULL,
`commit_hash` char(40) DEFAULT NULL,
`game_mode` varchar(32) DEFAULT NULL,
`game_mode_result` varchar(64) DEFAULT NULL,
`end_state` varchar(64) DEFAULT NULL,
`shuttle_name` varchar(64) DEFAULT NULL,
`map_name` varchar(32) DEFAULT NULL,
`station_name` varchar(80) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `end_datetime` (`shutdown_datetime`)
) ENGINE=InnoDB AUTO_INCREMENT=135829 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
Code: Select all
admin_cookies_spawned
admin_secrets_fun_used
admin_toggle
admin_verb
ahelp_stats
ais_created
antagonists
arcade_results
assembly_made
barsign_picked
BEPIS_credits_spent
brother_success
byond_build
byond_version
cargo_imports
cell_used
changeling_objective
changeling_powers
changeling_power_purchase
changeling_success
chaplain_armor
chaplain_weapon
chemical_reaction
circuit_printed
client_byond_version
clockcult_scripture_recited
coins_minted
colonies_dropped
commendation
contaminated
credits_inserted
credits_removed
credits_transferred
cult_objective
cult_runes_scribed
cyborg_birth
cyborg_frames_built
cyborg_modules
dm_build
dm_version
engine_started
event_admin_cancelled
event_ran
explosion
export_sold_cost
fermi_chem
food_harvested
food_made
free_income
gorillas_created
gun_fired
handcuffs
high_research_level
hivelord_core
ic_blocked_words
immortality_talisman_uses
infernal contract
item_deconstructed
item_printed
item_used_for_combat
jaunter
job_preferences
keycard_auths
lazarus_injector
malfunction_modules_bought
mechas_created
megafauna_kills
megafauna_kills_crusher
mining_equipment_bought
mining_voucher_redeemed
mmis_filled
mobs_killed_mining
newscaster_channels
newscaster_stories
newspapers_printed
nuclear_challenge_mode
object_crafted
ore_mined
pick_used_mining
played_url
preferences_verb
radio_usage
random_seed
religion_book
religion_deity
religion_name
roundend_nukedisk
round_end_stats
science_techweb_unlock
science_techweb_unlock_first_thi
SDQL query
security_level_changes
server_tools
server_tools_api
shuttle_fasttravel
shuttle_gib
shuttle_manipulator
shuttle_purchase
shuttle_reason
slime_babies_born
slime_cores_used
slime_core_harvested
spacepod_created
station_mess_created
station_mess_destroyed
station_renames
surgeries_completed
teams
testmerged_prs
time_dilation_current
traitor_objective
traitor_random_uplink_items_gott
traitor_success
traitor_uplink_items_bought
traumas
vending_machine_usage
vending_spent
voice_of_god
warp_cube
wisp_lantern
wizard_objective
wizard_spell_improved
wizard_spell_learned
wizard_success
zone_targeted