[Release] Flying mount Query

[dominicsott2003]

Well here is something that will help with the people that are wanting to add the flying dragons to there servers. So i am giving my query to them just please replace the names of them.

 Spoiler

delete from cq_action where id >= 20000500 and id <= 20000505;

INSERT INTO `cq_action` VALUES (20000500, 20000501, 20000504, 0508, 0, '1 0 52');
INSERT INTO `cq_action` VALUES (20000501, 20000502, 0000, 0502, 729443, '');
INSERT INTO `cq_action` VALUES (20000502, 20000503, 0000, 0501, 1081120, '');
INSERT INTO `cq_action` VALUES (20000503, 20000505, 0000, 1085, 0, 'gmlog/action_log 380,%user_name[%user_id],0,0,1081120,0,0,729443,0,0');
INSERT INTO `cq_action` VALUES (20000504, 0000, 0000, 0126, 0, 'Please~make~a~space~in~your~eudemon~bags!');
INSERT INTO `cq_action` VALUES (20000505, 0000, 0000, 0126, 0, 'Congratz!~You!~got~your~eudemon~egg!');

delete from cq_itemtype where id >= 729442 and id <= 729442;
delete from cq_itemtype where id >= 1081110 and id <= 1081110;
delete from cq_itemtype where id >= 1071110 and id <= 1071112;
delete from cq_itemtype where id >= 1079110 and id <= 1079112;

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
('729442', 'DeathDragon', '28', '0000000', '20000500', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00000', '00', '00', '00', '00', '00'),
('1081110', 'DeathDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071110', 'DeathDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0071690', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071111', 'DeathDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0071691', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071112', 'DeathDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0071692', '0', '0', '00', '00', '00', '00', '00', '00'),
('1079110', 'DeathDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0079690', '0', '0', '00', '00', '00', '00', '00', '00'),
('1079111', 'DeathDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0079691', '0', '0', '00', '00', '00', '00', '00', '00'),
('1079112', 'DeathDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0079692', '0', '0', '00', '00', '00', '00', '00', '00');


delete from cq_eudemon_rbn_type where id >= 1071110 and id <= 1071112;
delete from cq_eudemon_rbn_type where id >= 1079110 and id <= 1079112;


insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`)
values
('1071110', '0', '1', '1', '0', '0'),
('1071111', '0', '1', '1', '0', '0'),
('1071112', '0', '1', '1', '0', '0'),
('1079110', '0', '1', '1', '0', '0'),
('1079111', '0', '1', '1', '0', '0'),
('1079112', '0', '1', '1', '0', '0');


delete from cq_grade where id >= 1071110 and id <=1071112;
delete from cq_grade where id >= 1079110 and id <=1079112;

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
(1071110, 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),
(1071111, 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),
(1071112, 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),
(1079110, 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),
(1079111, 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),
(1079112, 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 >= 71110 and id <= 71112;
delete from cq_monstertype where id >= 79110 and id <= 79112;

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
(71110, 'DeathDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71111, 'DeathDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71112, 'DeathDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79110, 'DeathDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79111, 'DeathDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79112, 'DeathDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

delete from cq_action where id >= 20000505 and id <= 20000510;

INSERT INTO `cq_action` VALUES (20000505, 20000506, 20000509, 0508, 0, '1 0 52');
INSERT INTO `cq_action` VALUES (20000506, 20000507, 0000, 0502, 729443, '');
INSERT INTO `cq_action` VALUES (20000507, 20000508, 0000, 0501, 1081120, '');
INSERT INTO `cq_action` VALUES (20000508, 20000510, 0000, 1085, 0, 'gmlog/action_log 380,%user_name[%user_id],0,0,1081120,0,0,729443,0,0');
INSERT INTO `cq_action` VALUES (20000509, 0000, 0000, 0126, 0, 'Please~make~a~space~in~your~eudemon~bags!');
INSERT INTO `cq_action` VALUES (20000510, 0000, 0000, 0126, 0, 'Congratz!~You!~got~your~eudemon~egg!');

delete from cq_itemtype where id >= 729443 and id <= 729443;
delete from cq_itemtype where id >= 1081120 and id <= 1081120;
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
('729443', 'SatansDragon', '28', '0000000', '20000505', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00000', '00', '00', '00', '00', '00'),
('1081120', 'SatansDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071120', 'SatansDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0071690', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071121', 'SatansDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0071691', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071122', 'SatansDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0071692', '0', '0', '00', '00', '00', '00', '00', '00'),
('1079120', 'SatansDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0079690', '0', '0', '00', '00', '00', '00', '00', '00'),
('1079121', 'SatansDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0079691', '0', '0', '00', '00', '00', '00', '00', '00'),
('1079122', 'SatansDragon', '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0079692', '0', '0', '00', '00', '00', '00', '00', '00');


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 >= 71110 and id <= 71112;
delete from cq_monstertype where id >= 79110 and id <= 79112;

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
(71110, 'SatansDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71111, 'SatansDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71112, 'SatansDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79110, 'SatansDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79111, 'SatansDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79112, 'SatansDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Sorry you will have to change the id of the lookface

[zspider]

this is abug not release the query is 60% wronge here is afix for the first query try to find where your mistakes and fix them on the other
note: I'M NOT SURE ABOUT LOOKFACES SO CHECK THEM ON YOUR FILES

 Spoiler

delete from cq_action where id >= 20000500 and id <= 20000505;

insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(20000500,20000501,20000504,508,0,'1 0 52'),
(20000501,20000502,0,502,729442,''),
(20000502,20000503,0,501,1081110,''),
(20000503,20000505,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081110,0,0,729442,0,0'),
(20000504,0,0,126,0,'Please~make~one~space~in~your ~eudemon~bag~free!'),
(20000505,0,0,126,0,'Congratulations!~You~have~obt ained~a~DeathDragon~egg!');


delete from cq_itemtype where id >= 729442 and id <= 729442;
delete from cq_itemtype where id >= 1081110 and id <= 1081110;
delete from cq_itemtype where id >= 1071110 and id <= 1071112;
delete from cq_itemtype where id >= 1079110 and id <= 1079112;

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
('729442', 'DeathDragon', '28', '3000000', '20000500', '0000', '1', '1', '00', '00000', '1081110', '0', '0', '250000', '00', '00', '00', '00', '00'),
('1081110', 'DeathDragon', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071110', 'DeathDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071110', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071111', 'DeathDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071111', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071112', 'DeathDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071112', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079110', 'DeathDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079110', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079111', 'DeathDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079111', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079112', 'DeathDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079112', '7', '1', '00', '11', '21', '31', '41', '51');


delete from cq_eudemon_rbn_type where id >= 1071110 and id <= 1071112;
delete from cq_eudemon_rbn_type where id >= 1079110 and id <= 1079112;


insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`)
values
('1071110', '0', '1', '1', '0', '0'),
('1071111', '0', '1', '1', '0', '0'),
('1071112', '0', '1', '1', '0', '0'),
('1079110', '0', '1', '1', '0', '0'),
('1079111', '0', '1', '1', '0', '0'),
('1079112', '0', '1', '1', '0', '0');


delete from cq_grade where id >= 1071110 and id <=1071112;
delete from cq_grade where id >= 1079110 and id <=1079112;

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
(1071110, 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, 150, 0, 2320, 0, 0),
(1071111, 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, 150, 0, 2320, 0, 0),
(1071112, 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, 150, 0, 2320, 0, 0),
(1079110, 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, 150, 0, 2320, 0, 0),
(1079111, 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, 150, 0, 2320, 0, 0),
(1079112, 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, 150, 0, 2320, 0, 0);

delete from cq_monstertype where id >= 71110 and id <= 71112;
delete from cq_monstertype where id >= 79110 and id <= 79112;

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
(71110, 'DeathDragon', 1, 491, 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, 576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71111, 'DeathDragon', 1, 491, 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, 582, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71112, 'DeathDragon', 1, 491, 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, 583, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79110, 'DeathDragon', 1, 491, 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, 576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79111, 'DeathDragon', 1, 491, 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, 582, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79112, 'DeathDragon', 1, 491, 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, 583, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

[PraDevil[ELITE]]

hehe..i can said this is not a release or bug..all eudemons query depends on their id and their lookface..so even you got query but the id and lookface are wrong u cant make it work

[Andrew1991]

is this for a flying mount that is already released ?

[dominicsott2003]

Thanks but i was just trying to help out. An if it will work for your server i was for the fyling dragon mounts. That was released on here. An sorry for trying to help newier people out. An i am fixing my own problems just was trying to give some a query to look off of. But all well I guess me releasing stuff isnt any help to anyone.

[zspider]

no not like that it's just this query won't make it it will just bug the mount it's great to release your thing but just make sure it's fully working first

[DEADP00L]

wow you guys love to make work for yourselves dont you. Forget sing querys. use freaking excel. Unless of course you love making 5x the work

[dominicsott2003]

Originally Posted by DEADP00L

wow you guys love to make work for yourselves dont you. Forget sing querys. use freaking excel. Unless of course you love making 5x the work

Well I usually do it in excell. But i just posted it on here as a query. Some people dont no how to use excell. So i thaught i do it this way.

[zspider]

Originally Posted by DEADP00L

wow you guys love to make work for yourselves dont you. Forget sing querys. use freaking excel. Unless of course you love making 5x the work

it's the same excel for me excel help me when i want cut from the DB and edit on it but if i want make querys make it on notepad

[DEADP00L]

i dont bother i just cut and paste directly into the database. Querys are just so messy if you know what i mean

[dominicsott2003]

Yeah kinda. I wish i could get some help on my post about special exp ball stacks. but i guess no one can get them to work
I would have placed my data base files for it but they didnt work so i delete them like i do most that dont work and just start from scratch but i just cant figure it out. So if one of you can help me out i really appreciate it

[wumega]

FireRajantayu

811112=FireRanjantayu

1082680=FireRajantayu

1072680=FireRajantayu

1072681=FireRajantayu

1072682=FireRajantayu

1076680=FireRajantayu

1076681=FireRajantayu

1076682=FireRajantayu





LightRajantayu

811110=LightRajantayu

1082670=LightRajantayu

1072670=LightRajantayu

1072671=LightRajantayu

1072671=LightRajantayu

1076670=LightRajantayu

1076671=LightRajantayu

1076671=LightRajantayu



DarkRajantayu

811109=DarkRajantayu

1082660=DarkRajantayu

1072660=DarkRajantayu

1072661=DarkRajantayu

1072662=DarkRajantayu

1076660=DarkRajantayu

1076661=DarkRajantayu

1076662=DarkRajantayu
can do to me query this pet