Starcraft 2 Preparing Game Data Link Page

You cannot fix a problem you do not understand. Here are the three primary reasons the link fails.

SC2 uses 2D grid (approx -200..+200). Link to:

Precompute:

CREATE TABLE games (
    game_id TEXT PRIMARY KEY,
    map_name TEXT,
    duration_sec INTEGER,
    patch TEXT,
    replay_date DATE
);

CREATE TABLE players (
player_id TEXT,
game_id TEXT REFERENCES games,
race TEXT,
mmr INTEGER,
result TEXT, -- win/loss
PRIMARY KEY (player_id, game_id)
);


CREATE TABLE unit_events (
event_id BIGSERIAL,
game_id TEXT REFERENCES games,
timestamp_sec FLOAT,
player_id TEXT,
unit_type TEXT,
event_type TEXT, -- born, died, upgraded
x REAL, y REAL,
parent_unit_id TEXT, -- linked to other event
FOREIGN KEY (game_id, player_id) REFERENCES players
); starcraft 2 preparing game data link


CREATE TABLE kill_matrix (
killer_event_id BIGINT REFERENCES unit_events,
victim_event_id BIGINT REFERENCES unit_events,
game_id TEXT
);

Since patch 4.0, StarCraft 2 has suffered from a memory allocation bug. When the game asks the OS for permission to write data to the cache folder, Windows sometimes says "busy." The game then waits forever. This is not a connection issue; it is a handshake issue between the .exe and your file system.

Sometimes Windows network protocols prevent the app from linking data. You cannot fix a problem you do not understand

Example time-linked table: | time | player | minerals | supply_used | last_action | |------|--------|----------|-------------|--------------| | 60.0 | A | 250 | 22 | train_marine |

starcraft 2 preparing game data link