[Release]FlyingDragon Query

Ct42 · 12/10/2010, 13:38

I made this Query using these files:

This is my very first query I made so let me know if it works!

(P.S. RedDragon soon to come)

~Sword~Stalker~. · 12/10/2010, 17:20

Quote:

Originally Posted by Ct42

I made this Query using these files:

This is my very first query I made so let me know if it works!

(P.S. RedDragon soon to come)

released billion of time be4

Ct42 · 12/10/2010, 17:41

really? Cuz I can't find a working one using search, people really like to slam on others...

mohamed.lord15 · 02/26/2011, 06:48

i want add the maount in databace plz me maile :

joker709 · 02/26/2011, 19:40

did anyone try it i want to know if it work

~Sword~Stalker~. · 02/26/2011, 20:09

i believe it would be better if u test it . no need to ask others .. try it out .

magewarior2 · 02/28/2011, 09:53

Quote:

Originally Posted by joker709

did anyone try it i want to know if it work

Look for yourself and to to point it out...
or try to run it but make a backup of your database 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,729442,''),
(728442,728443,0,501,1081110,''),
(728443,728445,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081110,0,0,729442,0,0'),
(728444,0,0,126,0,'Please~make~a~space~in~your~eu[COLOR="Red"]d e[/COLOR]mon~bags!'),
(728445,0,0,126,0,'Congratz!~You!~got~your~eudemo[COLOR="Red"]n ~[/COLOR]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,amount_limit,gem1,hitrate,monster_type,able_mask,exp_type,emoney,official1,official2,official3,official4,official5) 
values
('729442', 'GreenDragon', '28', '3000000', '20000500', '0000', '1', '1', '00', '00000', '1081110', '0', '0', '250000', '00', '00', '00', '00', '00'),
('1081110', 'GreenDragon', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071110', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071110', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071111', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071111', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071112', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071112', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079110', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079110', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079111', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079111', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079112', 'GreenDragon', '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, 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, 'GreenDragon', 1, 128, 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),
(71111, 'GreenDragon', 1, 128, 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),
(71112, 'GreenDragon', 1, 128, 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),
(79110, 'GreenDragon', 1, 128, 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),
(79111, 'GreenDragon', 1, 128, 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),
(79112, 'GreenDragon', 1, 128, 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);

But I think this script Might work just fine (I have not tested it)