Login to ZARP
|
CREATE TABLE surfmap_info (
map varchar(255) PRIMARY KEY,
tier INT NOT NULL,
style BIT NOT NULL,
stages INT NOT NULL,
bonus INT NOT NULL
);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_4head', 2, 0, 0, 4);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_8bit', 2, 1, 3, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_ace_fix', 1, 1, 8, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_aircontrol_fixed', 1, 0, 0, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_aqua', 2, 0, 0, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_aquaflow', 2, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_arcade', 2, 1, 6, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_ardon_fix', 2, 0, 0, 6);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_aser', 1, 1, 6, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_atriumyes', 2, 1, 6, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_beginner', 1, 1, 7, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_beginner2', 2, 1, 7, 4);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_beginner_hell', 4, 1, 7, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_believe', 2, 1, 4, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_blue', 2, 0, 0, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_bonkers_v2', 1, 1, 7, 4);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_calzone', 1, 1, 4, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_classics', 2, 1, 10, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_classics2', 2, 1, 9, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_crackdesert_evo2', 3, 1, 3, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_cyberwave', 2, 1, 2, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_delight', 2, 0, 0, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_disneyland', 5, 1, 7, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_dragonyes', 2, 0, 0, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_dusk', 3, 1, 6, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_ebony', 2, 0, 0, 4);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_enlightened', 1, 0, 0, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_ethereal', 2, 1, 3, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_forbidden_ways_ksf', 1, 0, 0, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_fornax', 1, 0, 0, 7);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_friday', 3, 1, 6, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_garden', 1, 1, 10, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_gleam', 2, 0, 0, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_gleam2', 2, 1, 4, 4);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_greensway', 2, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_guitar_hi', 2, 0, 0, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_halloween_tf2', 2, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_happyhands', 2, 0, 0, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_harmony', 2, 1, 5, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_holiday', 2, 1, 4, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_hourglass', 1, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_how2surfyes', 1, 1, 21, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_interference', 2, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_island', 2, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_ivory', 2, 0, 0, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_kitsune', 1, 1, 9, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_kitsune2', 3, 1, 12, 4);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_lab', 4, 0, 0, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_lavaflow', 1, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_leet_xl_beta7z', 1, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_lost2', 3, 1, 4, 4);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_lt_omnific_fix', 6, 1, 18, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_luxyes', 1, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_meme', 3, 1, 9, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_mesa_aether', 3, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_mesa_mine', 2, 0, 0, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_mesa_tf2', 1, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_meyes', 1, 1, 5, 4);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_mom_fix', 1, 1, 6, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_monotony', 4, 1, 5, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_nesquik', 5, 1, 6, 6);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_nova', 2, 0, 0, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_nyx', 1, 0, 0, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_oasis', 3, 1, 10, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_paddy', 2, 1, 4, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_palm', 2, 0, 0, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_pantheon', 1, 0, 0, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_progress_fix', 2, 1, 5, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_psychedelia', 3, 0, 0, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_quickie', 4, 0, 0, 5);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_ravine', 2, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_rebel_resistance', 1, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_reprise_fix', 2, 0, 0, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_rocco_v2', 2, 0, 0, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_rooftopsv3', 1, 1, 8, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_rookie', 2, 1, 18, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_sancturay', 2, 1, 5, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_sandtrap2', 2, 0, 0, 4);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_satellite_fix', 1, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_saturday_fix', 2, 0, 0, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_school_fix', 1, 1, 10, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_simpsons_source', 2, 1, 10, 4);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_skipalot', 2, 0, 0, 4);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_spacejam', 2, 1, 6, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_squirrelsonvacation', 2, 0, 0, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_stargaze_css', 3, 0, 0, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_stonks', 2, 1, 2, 2);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_summer', 2, 1, 11, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_summit', 1, 0, 0, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_technique', 5, 1, 7, 5);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_tendies', 1, 0, 0, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_tomb_redone', 2, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_tranquil', 2, 0, 0, 3);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_utopia_njv', 1, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_water-run_banjo_skill', 1, 1, 4, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_whiteout', 1, 1, 6, 1);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_year300', 1, 1, 2, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_zoomathon', 1, 0, 0, 0);
INSERT INTO surfmap_info (map, tier, style, stages, bonus)
VALUES ('surf_zoomboys', 3, 0, 0, 2);