--------------------------------------------------
first of all here's how u can make a query :-
READ THE SECOND BEFORE THIS ONE
first
Code:
delete from cq_action where id >= 727440 and id <= 728445; insert into cq_action (id,id_next,id_nextfail,type,data,param) values (728440,728441,728444,508,0,'1 0 52'), (728441,728442,0,502,(Egg ID),''), >>>> Egg's id (728442,728443,0,501,(Bag ID),''), (728443,728445,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,(Bag ID),0,0,(Egg ID),0,0'), (728444,0,0,126,0,'Please~make~a~space~in~your~eud emon~bags!'), >>never change user_id
Code:
[B][%user_id] ! [/B] [B](728445,0,0,126,0,'Congratz!~You!~got~your~eudemon ~egg!'); >>Your Words , Example you got a devilish egg :p delete from cq_itemtype where id >= (Egg ID) and id <= (Egg ID); delete from cq_itemtype where id >= (bag ID) and id <= (Bag ID); delete from cq_itemtype where id >= 1071120 and id <= 1071122; delete from cq_itemtype where id >= 1079120 and id <= 1079122;[/B]
Here's The Second part take care that im explaining staff in it Read Carefully
Code:
insert into cq_itemtype (id,name,monopoly,price,id_action,dodge,amount,amo unt_limit,gem1,hitrate,monster_type,able_mask,exp_ type,emoney,official1,official2,official3,official 4,official5)
values
('(Egg ID)', '(pet name)', '28', '3000000', '(Action ID)', '0000', '1', '1', '00', '00000', '(Bag ID)', '0', '0', '30000', '00', '00', '00', '00', '00'),
('(Bag ID)', '(pet name)', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071120', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071120', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071121', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071121', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071122', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071122', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079120', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079120', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079121', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079121', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079122', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079122', '7', '1', '00', '11', '21', '31', '41', '51');
Code:
delete from cq_eudemon_rbn_type where id >= 1071120 and id <= 1071122; >> id's
delete from cq_eudemon_rbn_type where id >= 1079120 and id <= 1079122; >>id's
insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`)
values
('1071120', '0', '1', '1', '0', '0'),
('1071121', '0', '1', '1', '0', '0'),
('1071122', '0', '1', '1', '0', '0'),
('1079120', '0', '1', '1', '0', '0'),
('1079121', '0', '1', '1', '0', '0'),
('1079122', '0', '1', '1', '0', '0');
delete from cq_grade where id >= 1071120 and id <=1071122; >>id's
delete from cq_grade where id >= 1079120 and id <=1079122; >>id's
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
(1071120, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1071121, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1071122, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1079120, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0),
(1079121, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0),
(1079122, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0);
delete from cq_monstertype where id >= 71120 and id <= 71122;
delete from cq_monstertype where id >= 79120 and id <= 79122;
Last Part Is Unchangable [Dont Change ]
Code:
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 (71120, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (71121, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (71122, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (79120, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (79121, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (79122, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
READ THIS ONE FIRST
delete from cq_action where id >= 727440 and id <= 728445;
insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(728440,728441,728444,508,0,'1 0 52'),
(728441,728442,0,502,(Egg ID),''),
(728442,728443,0,501,(Bag ID),''),
(728443,728445,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,(Bag ID),0,0,(Egg ID),0,0'),
(728444,0,0,126,0,'Please~make~a~space~in~your~eud emon~bags!'),
(728445,0,0,126,0,'Congratz!~You!~got~your~eudemon ~egg!');
delete from cq_itemtype where id >= (Egg ID) and id <= (Egg ID);
delete from cq_itemtype where id >= (bag ID) and id <= (Bag ID);
delete from cq_itemtype where id >= 1071120 and id <= 1071122;
delete from cq_itemtype where id >= 1079120 and id <= 1079122;
insert into cq_itemtype (id,name,monopoly,price,id_action,dodge,amount,amo unt_limit,gem1,hitrate,monster_type,able_mask,exp_ type,emoney,official1,official2,official3,official 4,official5)
values
('(Egg ID)', '(pet name)', '28', '3000000', '(Action ID)', '0000', '1', '1', '00', '00000', '(Bag ID)', '0', '0', '30000', '00', '00', '00', '00', '00'),
('(Bag ID)', '(pet name)', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071120', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071120', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071121', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071121', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071122', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071122', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079120', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079120', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079121', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079121', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079122', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079122', '7', '1', '00', '11', '21', '31', '41', '51');
delete from cq_eudemon_rbn_type where id >= 1071120 and id <= 1071122;
delete from cq_eudemon_rbn_type where id >= 1079120 and id <= 1079122;
insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`)
values
('1071120', '0', '1', '1', '0', '0'),
('1071121', '0', '1', '1', '0', '0'),
('1071122', '0', '1', '1', '0', '0'),
('1079120', '0', '1', '1', '0', '0'),
('1079121', '0', '1', '1', '0', '0'),
('1079122', '0', '1', '1', '0', '0');
delete from cq_grade where id >= 1071120 and id <=1071122;
delete from cq_grade where id >= 1079120 and id <=1079122;
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
(1071120, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1071121, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1071122, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1079120, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0),
(1079121, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0),
(1079122, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0);
delete from cq_monstertype where id >= 71120 and id <= 71122;
delete from cq_monstertype where id >= 79120 and id <= 79122;
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
(71120, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71121, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71122, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79120, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79121, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79122, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(728440,728441,728444,508,0,'1 0 52'),
(728441,728442,0,502,(Egg ID),''),
(728442,728443,0,501,(Bag ID),''),
(728443,728445,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,(Bag ID),0,0,(Egg ID),0,0'),
(728444,0,0,126,0,'Please~make~a~space~in~your~eud emon~bags!'),
(728445,0,0,126,0,'Congratz!~You!~got~your~eudemon ~egg!');
delete from cq_itemtype where id >= (Egg ID) and id <= (Egg ID);
delete from cq_itemtype where id >= (bag ID) and id <= (Bag ID);
delete from cq_itemtype where id >= 1071120 and id <= 1071122;
delete from cq_itemtype where id >= 1079120 and id <= 1079122;
insert into cq_itemtype (id,name,monopoly,price,id_action,dodge,amount,amo unt_limit,gem1,hitrate,monster_type,able_mask,exp_ type,emoney,official1,official2,official3,official 4,official5)
values
('(Egg ID)', '(pet name)', '28', '3000000', '(Action ID)', '0000', '1', '1', '00', '00000', '(Bag ID)', '0', '0', '30000', '00', '00', '00', '00', '00'),
('(Bag ID)', '(pet name)', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071120', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071120', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071121', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071121', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071122', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071122', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079120', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079120', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079121', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079121', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079122', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079122', '7', '1', '00', '11', '21', '31', '41', '51');
delete from cq_eudemon_rbn_type where id >= 1071120 and id <= 1071122;
delete from cq_eudemon_rbn_type where id >= 1079120 and id <= 1079122;
insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`)
values
('1071120', '0', '1', '1', '0', '0'),
('1071121', '0', '1', '1', '0', '0'),
('1071122', '0', '1', '1', '0', '0'),
('1079120', '0', '1', '1', '0', '0'),
('1079121', '0', '1', '1', '0', '0'),
('1079122', '0', '1', '1', '0', '0');
delete from cq_grade where id >= 1071120 and id <=1071122;
delete from cq_grade where id >= 1079120 and id <=1079122;
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
(1071120, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1071121, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1071122, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1079120, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0),
(1079121, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0),
(1079122, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0);
delete from cq_monstertype where id >= 71120 and id <= 71122;
delete from cq_monstertype where id >= 79120 and id <= 79122;
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
(71120, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71121, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71122, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79120, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79121, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79122, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
--------------------------------------------------------------







