[Release]FlyingDragon Query

12/10/2010 13:38 Ct42#1
I made this Query using these files: [Only registered and activated users can see links. Click Here To Register...]

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

(P.S. RedDragon soon to come)
12/10/2010 17:20 ~Sword~Stalker~.#2
Quote:
Originally Posted by Ct42 View Post
I made this Query using these files: [Only registered and activated users can see links. Click Here To Register...]

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
12/10/2010 17:41 Ct42#3
really? Cuz I can't find a working one using search, people really like to slam on others...
02/26/2011 06:48 mohamed.lord15#4
i want add the maount in databace plz me maile : [Only registered and activated users can see links. Click Here To Register...]
02/26/2011 19:40 joker709#5
did anyone try it i want to know if it work
02/26/2011 20:09 ~Sword~Stalker~.#6
i believe it would be better if u test it . no need to ask others .. try it out . :)
02/28/2011 09:53 magewarior2#7
Quote:
Originally Posted by joker709 View Post
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)