Query the new flying mounts?

murillo123 · 07/31/2010, 19:57

I need the Query to put that mounts on my server ....
who can help me I would appreciate!!

~~AziQ~~ · 08/01/2010, 06:18

Code:

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,amount_limit,gem1,hitrate,monster_type,able_mask,exp_type,emoney,official1,official2,official3,official4,official5) 
values
('729442',  'NagaMerah',   '28', '3000000', '729542', '0000', '1', '1', '00', '00000', '1081690', '0', '0', '30000', '00', '00', '00', '00', '00'),
('1081110', 'NagaMerah',   '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071110', 'NagaMerah',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071690', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071111', 'NagaMerah',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071691', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071112', 'NagaMerah',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071692', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079110', 'NagaMerah',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079690', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079111', 'NagaMerah',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079691', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079112', 'NagaMerah',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079692', '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, 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, 'NagaMerah', 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, 'NagaMerah', 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, 'NagaMerah', 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, 'NagaMerah', 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, 'NagaMerah', 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, 'NagaMerah', 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);

Those for red dragon .u need change id for green dragon .try to do it yourself .

P/s :
- no query for cq_action there .
- sorry .dont know how to make it in spoiler .

zspider · 08/01/2010, 07:39

can both of u guys put the photos and the query on Spoiler to be more easy to browse??
on topic Hio when he released this mounts he said try to make the query your self and there's new guide here show you that just don't be lazy plz

seraf2 · 08/01/2010, 09:13

guys if u need help make query's for pet adding look at my signature, or hit search button im sure there are alot of useful guides