import sys
sys.path.insert(0, "/home/ericgw/dystropia.com")
import server
ALL_SKILLS = [(2403, 5.0, 1280000), (2406, 3.0, 768000), (2495, 4.0, 1024000), (2505, 4.0, 1024000), (3184, 4.0, 1024000), (3300, 1.0, 256000), (3301, 1.0, 256000), (3302, 1.0, 256000), (3303, 1.0, 256000), (3304, 3.0, 768000), (3305, 3.0, 768000), (3306, 3.0, 768000), (3307, 5.0, 1280000), (3308, 5.0, 1280000), (3309, 5.0, 1280000), (3310, 2.0, 512000), (3311, 2.0, 512000), (3312, 2.0, 512000), (3315, 4.0, 1024000), (3316, 2.0, 512000), (3317, 5.0, 1280000), (3318, 2.0, 512000), (3319, 1.0, 256000), (3320, 1.0, 256000), (3321, 2.0, 512000), (3322, 3.0, 768000), (3323, 2.0, 512000), (3324, 3.0, 768000), (3325, 4.0, 1024000), (3326, 5.0, 1280000), (3327, 1.0, 256000), (3328, 2.0, 512000), (3329, 2.0, 512000), (3330, 2.0, 512000), (3331, 2.0, 512000), (3332, 5.0, 1280000), (3333, 5.0, 1280000), (3334, 5.0, 1280000), (3335, 5.0, 1280000), (3336, 8.0, 2048000), (3337, 8.0, 2048000), (3338, 8.0, 2048000), (3339, 8.0, 2048000), (3340, 4.0, 1024000), (3341, 4.0, 1024000), (3342, 4.0, 1024000), (3343, 4.0, 1024000), (3344, 16.0, 4096000), (3345, 16.0, 4096000), (3346, 16.0, 4096000), (3347, 16.0, 4096000), (3348, 1.0, 256000), (3349, 2.0, 512000), (3350, 2.0, 512000), (3351, 5.0, 1280000), (3352, 5.0, 1280000), (3354, 6.0, 1536000), (3355, 1.0, 256000), (3356, 2.0, 512000), (3357, 1.0, 256000), (3358, 4.0, 1024000), (3359, 3.0, 768000), (3361, 3.0, 768000), (3363, 1.0, 256000), (3368, 2.0, 512000), (3373, 7.0, 1792000), (3380, 1.0, 256000), (3385, 1.0, 256000), (3386, 1.0, 256000), (3387, 2.0, 512000), (3388, 3.0, 768000), (3389, 3.0, 768000), (3392, 1.0, 256000), (3393, 1.0, 256000), (3394, 2.0, 512000), (3395, 2.0, 512000), (3396, 3.0, 768000), (3397, 5.0, 1280000), (3398, 8.0, 2048000), (3400, 16.0, 4096000), (3402, 1.0, 256000), (3403, 1.0, 256000), (3405, 1.0, 256000), (3406, 1.0, 256000), (3408, 4.0, 1024000), (3409, 3.0, 768000), (3410, 3.0, 768000), (3411, 3.0, 768000), (3412, 3.0, 768000), (3413, 1.0, 256000), (3416, 1.0, 256000), (3417, 1.0, 256000), (3418, 3.0, 768000), (3419, 3.0, 768000), (3420, 4.0, 1024000), (3421, 2.0, 512000), (3422, 2.0, 512000), (3423, 2.0, 512000), (3424, 2.0, 512000), (3425, 2.0, 512000), (3426, 1.0, 256000), (3427, 2.0, 512000), (3428, 2.0, 512000), (3429, 1.0, 256000), (3430, 3.0, 768000), (3431, 1.0, 256000), (3432, 2.0, 512000), (3433, 3.0, 768000), (3434, 3.0, 768000), (3435, 3.0, 768000), (3436, 1.0, 256000), (3437, 1.0, 256000), (3438, 2.0, 512000), (3439, 3.0, 768000), (3440, 4.0, 1024000), (3441, 5.0, 1280000), (3442, 5.0, 1280000), (3443, 1.0, 256000), (3444, 2.0, 512000), (3446, 2.0, 512000), (3447, 3.0, 768000), (3449, 1.0, 256000), (3450, 1.0, 256000), (3451, 2.0, 512000), (3452, 4.0, 1024000), (3453, 2.0, 512000), (3454, 5.0, 1280000), (3455, 1.0, 256000), (3456, 5.0, 1280000), (3551, 1.0, 256000), (3731, 3.0, 768000), (3732, 5.0, 1280000), (3893, 2.0, 512000), (3894, 2.0, 512000), (3895, 2.0, 512000), (4385, 5.0, 1280000), (4411, 5.0, 1280000), (9955, 0.5, 128000), (11082, 3.0, 768000), (11083, 3.0, 768000), (11084, 3.0, 768000), (11207, 6.0, 1536000), (11395, 6.0, 1536000), (11433, 5.0, 1280000), (11441, 5.0, 1280000), (11442, 5.0, 1280000), (11443, 5.0, 1280000), (11444, 5.0, 1280000), (11445, 5.0, 1280000), (11446, 5.0, 1280000), (11447, 5.0, 1280000), (11448, 5.0, 1280000), (11449, 5.0, 1280000), (11450, 5.0, 1280000), (11451, 5.0, 1280000), (11452, 5.0, 1280000), (11453, 5.0, 1280000), (11454, 5.0, 1280000), (11455, 5.0, 1280000), (11487, 5.0, 1280000), (11529, 5.0, 1280000), (11566, 2.0, 512000), (11569, 5.0, 1280000), (11572, 5.0, 1280000), (11574, 8.0, 2048000), (11579, 6.0, 1536000), (11584, 3.0, 768000), (12092, 4.0, 1024000), (12093, 4.0, 1024000), (12095, 4.0, 1024000), (12096, 6.0, 1536000), (12098, 5.0, 1280000), (12179, 8.0, 2048000), (12189, 5.0, 1280000), (12196, 5.0, 1280000), (12201, 3.0, 768000), (12202, 5.0, 1280000), (12203, 8.0, 2048000), (12204, 5.0, 1280000), (12205, 8.0, 2048000), (12206, 5.0, 1280000), (12207, 8.0, 2048000), (12208, 5.0, 1280000), (12209, 8.0, 2048000), (12210, 3.0, 768000), (12211, 5.0, 1280000), (12212, 8.0, 2048000), (12213, 3.0, 768000), (12214, 5.0, 1280000), (12215, 8.0, 2048000), (12241, 8.0, 2048000), (12305, 1.0, 256000), (12365, 2.0, 512000), (12366, 2.0, 512000), (12367, 2.0, 512000), (12441, 2.0, 512000), (12442, 4.0, 1024000), (12484, 5.0, 1280000), (12485, 5.0, 1280000), (12486, 5.0, 1280000), (12487, 5.0, 1280000), (13278, 3.0, 768000), (13279, 1.0, 256000), (16069, 2.0, 512000), (16281, 1.0, 256000), (16591, 6.0, 1536000), (16594, 3.0, 768000), (16595, 1.0, 256000), (16596, 4.0, 1024000), (16597, 3.0, 768000), (16598, 3.0, 768000), (16622, 3.0, 768000), (17940, 4.0, 1024000), (18025, 5.0, 1280000), (18580, 6.0, 1536000), (19430, 42.0, 10752000), (19719, 6.0, 1536000), (19759, 4.0, 1024000), (19760, 3.0, 768000), (19761, 5.0, 1280000), (19766, 5.0, 1280000), (19767, 5.0, 1280000), (19921, 3.0, 768000), (19922, 5.0, 1280000), (20209, 3.0, 768000), (20210, 3.0, 768000), (20211, 5.0, 1280000), (20212, 8.0, 2048000), (20213, 8.0, 2048000), (20312, 5.0, 1280000), (20314, 2.0, 512000), (20315, 5.0, 1280000), (20327, 7.0, 1792000), (20342, 5.0, 1280000), (20433, 5.0, 1280000), (20494, 2.0, 512000), (20495, 2.0, 512000), (20524, 10.0, 2560000), (20525, 12.0, 3072000), (20526, 10.0, 2560000), (20527, 10.0, 2560000), (20528, 10.0, 2560000), (20530, 12.0, 3072000), (20531, 12.0, 3072000), (20532, 12.0, 3072000), (20533, 14.0, 3584000), (21059, 2.0, 512000), (21071, 2.0, 512000), (21603, 5.0, 1280000), (21610, 8.0, 2048000), (21611, 9.0, 2304000), (21666, 7.0, 1792000), (21667, 7.0, 1792000), (21668, 7.0, 1792000), (21718, 3.0, 768000), (21789, 5.0, 1280000), (21790, 5.0, 1280000), (21791, 5.0, 1280000), (21802, 8.0, 2048000), (21803, 8.0, 2048000), (22043, 8.0, 2048000), (22242, 14.0, 3584000), (22536, 2.0, 512000), (22541, 5.0, 1280000), (22551, 5.0, 1280000), (22552, 5.0, 1280000), (22578, 4.0, 1024000), (22761, 6.0, 1536000), (22806, 2.0, 512000), (22807, 2.0, 512000), (22808, 2.0, 512000), (22809, 2.0, 512000), (23069, 12.0, 3072000), (23087, 5.0, 1280000), (23121, 5.0, 1280000), (23123, 5.0, 1280000), (23124, 5.0, 1280000), (23566, 5.0, 1280000), (23594, 5.0, 1280000), (23606, 1.0, 256000), (23618, 5.0, 1280000), (23950, 8.0, 2048000), (24241, 1.0, 256000), (24242, 1.0, 256000), (24268, 3.0, 768000), (24270, 3.0, 768000), (24311, 14.0, 3584000), (24312, 14.0, 3584000), (24313, 14.0, 3584000), (24314, 14.0, 3584000), (24562, 14.0, 3584000), (24563, 14.0, 3584000), (24568, 10.0, 2560000), (24571, 10.0, 2560000), (24572, 10.0, 2560000), (24606, 10.0, 2560000), (24613, 8.0, 2048000), (24624, 8.0, 2048000), (24625, 8.0, 2048000), (24764, 12.0, 3072000), (25233, 3.0, 768000), (25235, 1.0, 256000), (25530, 5.0, 1280000), (25538, 2.0, 512000), (25544, 1.0, 256000), (25718, 5.0, 1280000), (25719, 3.0, 768000), (25739, 8.0, 2048000), (25810, 5.0, 1280000), (25811, 5.0, 1280000), (25863, 3.0, 768000), (26224, 2.0, 512000), (26252, 2.0, 512000), (26253, 3.0, 768000), (26254, 3.0, 768000), (26255, 3.0, 768000), (26256, 3.0, 768000), (26257, 3.0, 768000), (26258, 3.0, 768000), (26259, 3.0, 768000), (26260, 3.0, 768000), (26261, 3.0, 768000), (27902, 2.0, 512000), (27906, 8.0, 2048000), (27911, 8.0, 2048000), (27936, 10.0, 2560000), (28073, 4.0, 1024000), (28164, 3.0, 768000), (28374, 12.0, 3072000), (28585, 8.0, 2048000), (28609, 6.0, 1536000), (28615, 4.0, 1024000), (28656, 10.0, 2560000), (28667, 10.0, 2560000), (28879, 2.0, 512000), (28880, 3.0, 768000), (29029, 14.0, 3584000), (29637, 8.0, 2048000), (30324, 5.0, 1280000), (30325, 5.0, 1280000), (30327, 5.0, 1280000), (30532, 1.0, 256000), (30537, 1.0, 256000), (30538, 1.0, 256000), (30539, 1.0, 256000), (30540, 1.0, 256000), (30544, 1.0, 256000), (30545, 1.0, 256000), (30546, 1.0, 256000), (30547, 1.0, 256000), (30548, 1.0, 256000), (30549, 1.0, 256000), (30550, 1.0, 256000), (30551, 1.0, 256000), (30552, 1.0, 256000), (30553, 1.0, 256000), (30554, 1.0, 256000), (30650, 5.0, 1280000), (30651, 5.0, 1280000), (30652, 5.0, 1280000), (30653, 5.0, 1280000), (30788, 5.0, 1280000), (32339, 12.0, 3072000), (32435, 7.0, 1792000), (32797, 3.0, 768000), (32918, 2.0, 512000), (32999, 2.0, 512000), (33000, 2.0, 512000), (33001, 2.0, 512000), (33002, 2.0, 512000), (33078, 3.0, 768000), (33091, 2.0, 512000), (33092, 2.0, 512000), (33093, 2.0, 512000), (33094, 2.0, 512000), (33095, 6.0, 1536000), (33096, 6.0, 1536000), (33097, 6.0, 1536000), (33098, 6.0, 1536000), (33399, 2.0, 512000), (33407, 5.0, 1280000), (33467, 2.0, 512000), (33699, 2.0, 512000), (33856, 4.0, 1024000), (34327, 9.0, 2304000), (34390, 3.0, 768000), (34533, 3.0, 768000), (35680, 3.0, 768000), (35685, 3.0, 768000), (37615, 6.0, 1536000), (37796, 2.0, 512000), (37797, 2.0, 512000), (37798, 2.0, 512000), (37799, 2.0, 512000), (40328, 4.0, 1024000), (40572, 12.0, 3072000), (40573, 12.0, 3072000), (41403, 10.0, 2560000), (41404, 10.0, 2560000), (41405, 10.0, 2560000), (41406, 10.0, 2560000), (41407, 10.0, 2560000), (41408, 10.0, 2560000), (41409, 10.0, 2560000), (41410, 10.0, 2560000), (41537, 14.0, 3584000), (43702, 2.0, 512000), (43703, 5.0, 1280000), (43728, 10.0, 2560000), (44067, 8.0, 2048000), (45746, 1.0, 256000), (45748, 2.0, 512000), (45749, 8.0, 2048000), (45750, 3.0, 768000), (46152, 4.0, 1024000), (46153, 5.0, 1280000), (46154, 6.0, 1536000), (46155, 7.0, 1792000), (46156, 8.0, 2048000), (47445, 8.0, 2048000), (47867, 2.0, 512000), (47868, 5.0, 1280000), (47869, 8.0, 2048000), (47870, 1.0, 256000), (47871, 3.0, 768000), (47872, 5.0, 1280000), (47873, 3.0, 768000), (47874, 5.0, 1280000), (47875, 8.0, 2048000), (49742, 2.0, 512000), (49743, 6.0, 1536000), (52307, 5.0, 1280000), (52308, 4.0, 1024000), (52997, 12.0, 3072000), (52998, 7.0, 1792000), (54794, 8.0, 2048000), (54826, 5.0, 1280000), (54827, 3.0, 768000), (54828, 5.0, 1280000), (54829, 8.0, 2048000), (54840, 4.0, 1024000), (54841, 2.0, 512000), (55025, 5.0, 1280000), (55031, 2.0, 512000), (55032, 5.0, 1280000), (55033, 1.0, 256000), (55034, 1.0, 256000), (55035, 3.0, 768000), (55511, 2.0, 512000), (57164, 5.0, 1280000), (57317, 5.0, 1280000), (57318, 8.0, 2048000), (58956, 4.0, 1024000), (60377, 3.0, 768000), (60378, 6.0, 1536000), (60379, 9.0, 2304000), (60380, 11.0, 2816000), (60381, 12.0, 3072000), (60515, 6.0, 1536000), (62450, 3.0, 768000), (62451, 3.0, 768000), (62452, 2.0, 512000), (62453, 4.0, 1024000), (73910, 12.0, 3072000), (73912, 10.0, 2560000), (77725, 16.0, 4096000), (77738, 16.0, 4096000), (77739, 14.0, 3584000), (81032, 4.0, 1024000), (81044, 10.0, 2560000), (81050, 5.0, 1280000), (81364, 6.0, 1536000), (81365, 9.0, 2304000), (81366, 2.0, 512000), (81367, 6.0, 1536000), (81368, 1.0, 256000), (81369, 5.0, 1280000), (81370, 2.0, 512000), (81371, 5.0, 1280000), (81372, 3.0, 768000), (81373, 5.0, 1280000), (81374, 8.0, 2048000), (81375, 3.0, 768000), (81377, 1.0, 256000), (81896, 2.0, 512000), (83094, 14.0, 3584000), (83464, 14.0, 3584000), (84217, 3.0, 768000), (84218, 4.0, 1024000), (84220, 5.0, 1280000), (85233, 8.0, 2048000), (86260, 3.0, 768000), (86261, 5.0, 1280000), (86262, 7.0, 1792000), (86263, 5.0, 1280000), (86264, 5.0, 1280000), (88377, 14.0, 3584000), (89241, 2.0, 512000), (89609, 8.0, 2048000), (89610, 5.0, 1280000), (89611, 2.0, 512000), (89689, 5.0, 1280000), (90040, 11.0, 2816000), (90398, 11.0, 2816000), (90727, 2.0, 512000), (90728, 6.0, 1536000), (91017, 2.0, 512000), (92397, 14.0, 3584000), (92398, 14.0, 3584000), (92399, 14.0, 3584000), (92400, 14.0, 3584000), (92541, 10.0, 2560000), (93983, 12.0, 3072000), (97263, 6.0, 1536000)]
cfg = server.load_config()
conn = server.get_db_conn(cfg)
with conn:
    with conn.cursor() as cur:
        cur.execute("ALTER TABLE character_skills ALTER COLUMN skill_rank TYPE DOUBLE PRECISION;")
        cur.execute("DELETE FROM character_skills WHERE character_id = 90000001;")
        for tid, rank, sp in ALL_SKILLS:
            cur.execute("INSERT INTO character_skills (character_id, type_id, skill_level, skill_points, skill_rank) VALUES (90000001, %s, 5, %s, %s);", (tid, sp, rank))
conn.close()
print("[+] Seeded %d skills at Level V for GM Eric!" % len(ALL_SKILLS))