Code:
delete from cq_itemtype where id >= 729413 and id <= 729414; delete from cq_itemtype where id >= 1081880 and id <= 1081880; delete from cq_itemtype where id >= 1081890 and id <= 1081890; delete from cq_itemtype where id >= 1071880 and id <= 1071882; delete from cq_itemtype where id >= 1079880 and id <= 1079882; delete from cq_itemtype where id >= 1071890 and id <= 1071892; delete from cq_itemtype where id >= 1079890 and id <= 1079892; insert into cq_itemtype (id, name, req_profession, level, req_level, req_sex, req_force, req_dex, req_health, req_soul, monopoly, weight, price, id_action, attack_max, attack_min, defense, magic_atk_min, dodge, life, mana, amount, amount_limit, ident, gem1, gem2, magic1, magic2, magic3, magic_atk_max, magic_def, atk_range, atk_speed, hitrate, monster_type, target, able_mask, exp_type, emoney, official1, official2, official3, official4, official5, official6, official7, official8, official9, official10, official11, soul_value) values (729413, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 3000000, 4602580, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1081880, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (1081880, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (1071880, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71880, 0, 7, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0), (1071881, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71881, 0, 7, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0), (1071882, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71882, 0, 7, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0), (1079880, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 79880, 0, 7, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0), (1079881, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 79881, 0, 7, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0), (1079882, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 79882, 0, 7, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0), (729414, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 3000000, 4602590, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1081890, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (1081890, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (1071890, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71890, 0, 6, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0), (1071891, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71891, 0, 6, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0), (1071892, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71892, 0, 6, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0), (1079890, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 79890, 0, 6, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0), (1079891, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 79891, 0, 6, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0), (1079892, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 79892, 0, 6, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0); delete from cq_eudemon_rbn_type where id >= 1071880 and id <= 1071882; delete from cq_eudemon_rbn_type where id >= 1079880 and id <= 1079882; delete from cq_eudemon_rbn_type where id >= 1071890 and id <= 1071892; delete from cq_eudemon_rbn_type where id >= 1079890 and id <= 1079892; insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`) values (1071880,0,0,1,0,0), (1071881,0,0,1,0,0), (1071882,0,0,1,0,0), (1079880,0,0,1,0,0), (1079881,0,0,1,0,0), (1079882,0,0,1,0,0), (1071890,0,0,1,0,0), (1071891,0,0,1,0,0), (1071892,0,0,1,0,0), (1079890,0,0,1,0,0), (1079891,0,0,1,0,0), (1079892,0,0,1,0,0); delete from cq_grade where id >= 1071880 and id <=1071882; delete from cq_grade where id >= 1079880 and id <=1079882; delete from cq_grade where id >= 1071890 and id <=1071892; delete from cq_grade where id >= 1079890 and id <=1079892; insert into cq_grade (id, life_a, life_b, life_c, life_grow_a, life_grow_b, life_grow_c, phy_min_a, phy_min_b, phy_min_c, phy_min_grow_a, phy_min_grow_b, phy_min_grow_c, phy_max_a, phy_max_b, phy_max_c, phy_max_grow_a, phy_max_grow_b, phy_max_grow_c, phy_def_a, phy_def_b, phy_def_c, phy_def_grow_a, phy_def_grow_b, phy_def_grow_c, mgc_min_a, mgc_min_b, mgc_min_c, mgc_min_grow_a, mgc_min_grow_b, mgc_min_grow_c, mgc_max_a, mgc_max_b, mgc_max_c, mgc_max_grow_a, mgc_max_grow_b, mgc_max_grow_c, mgc_def_a, mgc_def_b, mgc_def_c, mgc_def_grow_a, mgc_def_grow_b, mgc_def_grow_c, luck_a, luck_b, luck_c, dmg_type, rarity, metempsychosis, reborn_limit, rbn_rqr_type, auto_trade_type) values (1071880, 20, 290, 1, 2500, 6250, 106, 16, 95, 12, 8800, 22000, 32, 24, 99, 13, 13200, 33000, 9, 15, 99, 21, 11000, 27500, 467, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 56, 37, 5000, 12500, 355, 50, 100, 200, 0, 150, 0, 2320, 0, 0), (1071881, 20, 290, 1, 2500, 6250, 106, 16, 95, 12, 8800, 22000, 32, 24, 99, 13, 13200, 33000, 9, 15, 99, 21, 11000, 27500, 467, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 56, 37, 5000, 12500, 355, 50, 100, 200, 0, 150, 0, 2320, 0, 0), (1071882, 20, 290, 1, 2500, 6250, 106, 16, 95, 12, 8800, 22000, 32, 24, 99, 13, 13200, 33000, 9, 15, 99, 21, 11000, 27500, 467, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 56, 37, 5000, 12500, 355, 50, 100, 200, 0, 150, 0, 2320, 0, 0), (1079880, 20, 290, 1, 2500, 6250, 106, 16, 95, 12, 8800, 22000, 32, 24, 99, 13, 13200, 33000, 9, 15, 99, 21, 11000, 27500, 467, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 56, 37, 5000, 12500, 355, 50, 100, 200, 100, 150, 0, 2320, 0, 0), (1079881, 20, 290, 1, 2500, 6250, 106, 16, 95, 12, 8800, 22000, 32, 24, 99, 13, 13200, 33000, 9, 15, 99, 21, 11000, 27500, 467, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 56, 37, 5000, 12500, 355, 50, 100, 200, 100, 150, 0, 2320, 0, 0), (1079882, 20, 290, 1, 2500, 6250, 106, 16, 95, 12, 8800, 22000, 32, 24, 99, 13, 13200, 33000, 9, 15, 99, 21, 11000, 27500, 467, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 56, 37, 5000, 12500, 355, 50, 100, 200, 100, 150, 0, 2320, 0, 0), (1071890, 20, 290, 1, 2500, 6250, 53, 1, 10, 925, 1000, 2500, 8888, 2, 20, 231, 2000, 5000, 1666, 15, 99, 10, 11000, 27500, 467, 9, 66, 23, 6400, 16000, 84, 13, 99, 10, 9600, 24000, 25, 11, 56, 37, 5000, 12500, 177, 50, 100, 200, 0, 150, 0, 2320, 0, 0), (1071891, 20, 290, 1, 2500, 6250, 53, 1, 10, 925, 1000, 2500, 8888, 2, 20, 231, 2000, 5000, 1666, 15, 99, 10, 11000, 27500, 467, 9, 66, 23, 6400, 16000, 84, 13, 99, 10, 9600, 24000, 25, 11, 56, 37, 5000, 12500, 177, 50, 100, 200, 0, 150, 0, 2320, 0, 0), (1071892, 20, 290, 1, 2500, 6250, 53, 1, 10, 925, 1000, 2500, 8888, 2, 20, 231, 2000, 5000, 1666, 15, 99, 10, 11000, 27500, 467, 9, 66, 23, 6400, 16000, 84, 13, 99, 10, 9600, 24000, 25, 11, 56, 37, 5000, 12500, 177, 50, 100, 200, 0, 150, 0, 2320, 0, 0), (1079890, 20, 290, 1, 2500, 6250, 53, 1, 10, 925, 1000, 2500, 8888, 2, 20, 231, 2000, 5000, 1666, 15, 99, 10, 11000, 27500, 467, 9, 66, 23, 6400, 16000, 84, 13, 99, 10, 9600, 24000, 25, 11, 56, 37, 5000, 12500, 177, 50, 100, 200, 100, 150, 0, 2320, 0, 0), (1079891, 20, 290, 1, 2500, 6250, 53, 1, 10, 925, 1000, 2500, 8888, 2, 20, 231, 2000, 5000, 1666, 15, 99, 10, 11000, 27500, 467, 9, 66, 23, 6400, 16000, 84, 13, 99, 10, 9600, 24000, 25, 11, 56, 37, 5000, 12500, 177, 50, 100, 200, 100, 150, 0, 2320, 0, 0), (1079892, 20, 290, 1, 2500, 6250, 53, 1, 10, 925, 1000, 2500, 8888, 2, 20, 231, 2000, 5000, 1666, 15, 99, 10, 11000, 27500, 467, 9, 66, 23, 6400, 16000, 84, 13, 99, 10, 9600, 24000, 25, 11, 56, 37, 5000, 12500, 177, 50, 100, 200, 100, 150, 0, 2320, 0, 0); delete from cq_monstertype where id >= 71880 and id <= 71882; delete from cq_monstertype where id >= 79880 and id <= 79882; delete from cq_monstertype where id >= 71890 and id <= 71892; delete from cq_monstertype where id >= 79890 and id <= 79892; insert into cq_monstertype (id, name, type, lookface, length, fat, life, mana, attack_max, attack_min, defence, dexterity, dodge, helmet_type, armor_type, weaponr_type, weaponl_type, attack_range, view_range, escape_life, attack_speed, move_speed, level, attack_user, drop_money_min, drop_money_max, size_add, action, run_speed, drop_armet, drop_necklace, drop_armor, drop_ring, drop_weapon, drop_shield, drop_shoes, drop_money_chance, drop_item_chance, magic_type, magic_def, magic_hitrate, atk_hitrate, ai_type, defence2, explode_item_chance1, explode_item_chance2, explode_item_chance3, drop_item_rule, profession, magic1, magic2, magic3, frequency, extra_battlelev, extra_exp, extra_damage, earth_def, water_def, fire_def, wind_def, drop_egg_coe, drop_weapon_coe, drop_armet_coe, drop_armor_coe, drop_necklace_coe, drop_bracelet_coe, drop_shoes_coe, drop_stone_coe, drop_gem_coe, drop_explode_coe, drop_special_coe, special_type, drop_deltalev_coe) values (71880,'BaneJabberwock',1,880,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,880,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0), (71881,'BaneJabberwock',1,881,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,881,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0), (71882,'BaneJabberwock',1,882,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,882,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0), (79880,'BaneJabberwock',1,880,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,880,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0), (79881,'BaneJabberwock',1,881,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,881,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0), (79882,'BaneJabberwock',1,882,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,882,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0), (71890,'DreadJabberwock',1,890,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,890,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0), (71891,'DreadJabberwock',1,891,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,891,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0), (71892,'DreadJabberwock',1,892,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,892,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0), (79890,'DreadJabberwock',1,890,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,890,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0), (79891,'DreadJabberwock',1,891,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,891,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0), (79892,'DreadJabberwock',1,892,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,892,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0);