Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[RELEASE] .!New pets and mounts .! in 1 file = 1 query

Newbie Spellweaver
Joined
Oct 21, 2010
Messages
10
Reaction score
3
well i thought it will be nice so i added :-
-------------------
AriesCardy
...
AriesMuba
...
Tiger

...
Fish

...
Elephant

...
CapricornDina

...
CapricornDonna

...
& Dracus
-----------------------------------------------

into one file ..
what u will make is just adding them to ur client as if ur adding just 1 pet and ull have all of them ..

recently i thought of adding pets by patches to Mann, Candy , REvo, Bugless Revo. everytime but i thought it wont be nice cuz i wont work and u just add :p

Query:-

Code:
delete from cq_action where id >= 8150500 and id <= 8150505;

insert into cq_action (id,id_next,id_nextfail,type,data,param) 
values 
(8150500,8150501,8150504,508,0,'1 0 52'),
(8150501,8150502,0,502,815057,''),
(8150502,8150503,0,501,1082850,''),
(8150503,8150505,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1082850,0,0,815057,0,0'),
(8150504,0,0,126,0,'Please~make~a~space~in~your~eudemon~bags!'),
(8150505,0,0,126,0,'Congratz!~You!~got~your~eudemon~egg!');


delete from cq_itemtype where id >= 815057 and id <= 815057;
delete from cq_itemtype where id >= 1082850 and id <= 1082850;
delete from cq_itemtype where id >= 1072850 and id <= 1072852;
delete from cq_itemtype where id >= 1076850 and id <= 1076852;

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
('815057',  'Fish1',   '28', '3000000', '8150500', '0000', '1', '1', '00', '00000', '1082850', '0', '0', '30000', '00', '00', '00', '00', '00'),
('1082850', 'Fish1',   '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1072850', 'Fish1',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072850', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072851', 'Fish1',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072851', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072852', 'Fish1',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072852', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076850', 'Fish1',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076850', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076851', 'Fish1',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076851', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076852', 'Fish1',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076852', '7', '1', '00', '11', '21', '31', '41', '51');


delete from cq_eudemon_rbn_type where id >= 1072850 and id <= 1072852;
delete from cq_eudemon_rbn_type where id >= 1076850 and id <= 1076852;


insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`) 
values 
('1072850', '0', '1', '1', '0', '0'),
('1072851', '0', '1', '1', '0', '0'),
('1072852', '0', '1', '1', '0', '0'),
('1076850', '0', '1', '1', '0', '0'),
('1076851', '0', '1', '1', '0', '0'),
('1076852', '0', '1', '1', '0', '0');


delete from cq_grade where id >= 1072850 and id <=1072852;
delete from cq_grade where id >= 1076850 and id <=1076852;

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
(1072850, 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),
(1072851, 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),
(1072852, 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),
(1076850, 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),
(1076851, 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),
(1076852, 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 >= 72850 and id <= 72852;
delete from cq_monstertype where id >= 76850 and id <= 76852;

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 
(72850, 'Fish1', 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),
(72851, 'Fish1', 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),
(72852, 'Fish1', 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),
(76850, 'Fish1', 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),
(76851, 'Fish1', 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),
(76852, 'Fish1', 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);



delete from cq_action where id >= 8150510 and id <= 8150515;

insert into cq_action (id,id_next,id_nextfail,type,data,param) 
values 
(8150510,8150511,8150514,508,0,'1 0 52'),
(8150511,8150512,0,502,815058,''),
(8150512,8150513,0,501,1082860,''),
(8150513,8150515,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1082860,0,0,815058,0,0'),
(8150514,0,0,126,0,'Please~make~a~space~in~your~eudemon~bags!'),
(8150515,0,0,126,0,'Congratz!~You!~got~your~eudemon~egg!');


delete from cq_itemtype where id >= 815058 and id <= 815058;
delete from cq_itemtype where id >= 1082860 and id <= 1082860;
delete from cq_itemtype where id >= 1072860 and id <= 1072862;
delete from cq_itemtype where id >= 1076860 and id <= 1076862;

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
('815058',  'Fish2',   '28', '3000000', '8150510', '0000', '1', '1', '00', '00000', '1082860', '0', '0', '30000', '00', '00', '00', '00', '00'),
('1082860', 'Fish2',   '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1072860', 'Fish2',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072860', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072861', 'Fish2',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072861', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072862', 'Fish2',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072862', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076860', 'Fish2',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076860', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076861', 'Fish2',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076861', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076862', 'Fish2',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076862', '7', '1', '00', '11', '21', '31', '41', '51');


delete from cq_eudemon_rbn_type where id >= 1072860 and id <= 1072862;
delete from cq_eudemon_rbn_type where id >= 1076860 and id <= 1076862;


insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`) 
values 
('1072860', '0', '1', '1', '0', '0'),
('1072861', '0', '1', '1', '0', '0'),
('1072862', '0', '1', '1', '0', '0'),
('1076860', '0', '1', '1', '0', '0'),
('1076861', '0', '1', '1', '0', '0'),
('1076862', '0', '1', '1', '0', '0');


delete from cq_grade where id >= 1072860 and id <=1072862;
delete from cq_grade where id >= 1076860 and id <=1076862;

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
(1072860, 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),
(1072861, 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),
(1072862, 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),
(1076860, 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),
(1076861, 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),
(1076862, 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 >= 72860 and id <= 72862;
delete from cq_monstertype where id >= 76860 and id <= 76862;

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 
(72860, 'Fish2', 1, 570, 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, 570, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(72861, 'Fish2', 1, 570, 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, 570, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(72862, 'Fish2', 1, 570, 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, 570, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(76860, 'Fish2', 1, 570, 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, 570, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(76861, 'Fish2', 1, 570, 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, 570, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(76862, 'Fish2', 1, 570, 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, 570, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);



delete from cq_action where id >= 8150520 and id <= 8150525;

insert into cq_action (id,id_next,id_nextfail,type,data,param) 
values 
(8150520,8150521,8150524,508,0,'1 0 52'),
(8150521,8150522,0,502,815059,''),
(8150522,8150523,0,501,1082870,''),
(8150523,8150525,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1082870,0,0,815059,0,0'),
(8150524,0,0,126,0,'Please~make~a~space~in~your~eudemon~bags!'),
(8150525,0,0,126,0,'Congratz!~You!~got~your~eudemon~egg!');


delete from cq_itemtype where id >= 815059 and id <= 815059;
delete from cq_itemtype where id >= 1082870 and id <= 1082870;
delete from cq_itemtype where id >= 1072870 and id <= 1072872;
delete from cq_itemtype where id >= 1076870 and id <= 1076872;

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
('815059',  'Tiger1',   '28', '3000000', '8150520', '0000', '1', '1', '00', '00000', '1082870', '0', '0', '30000', '00', '00', '00', '00', '00'),
('1082870', 'Tiger1',   '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1072870', 'Tiger1',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072870', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072871', 'Tiger1',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072871', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072872', 'Tiger1',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072872', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076870', 'Tiger1',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076870', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076871', 'Tiger1',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076871', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076872', 'Tiger1',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076872', '7', '1', '00', '11', '21', '31', '41', '51');


delete from cq_eudemon_rbn_type where id >= 1072870 and id <= 1072872;
delete from cq_eudemon_rbn_type where id >= 1076870 and id <= 1076872;


insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`) 
values 
('1072870', '0', '1', '1', '0', '0'),
('1072871', '0', '1', '1', '0', '0'),
('1072872', '0', '1', '1', '0', '0'),
('1076870', '0', '1', '1', '0', '0'),
('1076871', '0', '1', '1', '0', '0'),
('1076872', '0', '1', '1', '0', '0');


delete from cq_grade where id >= 1072870 and id <=1072872;
delete from cq_grade where id >= 1076870 and id <=1076872;

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
(1072870, 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),
(1072871, 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),
(1072872, 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),
(1076870, 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),
(1076871, 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),
(1076872, 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 >= 72870 and id <= 72872;
delete from cq_monstertype where id >= 76870 and id <= 76872;

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 
(72870, 'Tiger1', 1, 573, 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, 573, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(72871, 'Tiger1', 1, 573, 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, 573, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(72872, 'Tiger1', 1, 573, 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, 573, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(76870, 'Tiger1', 1, 573, 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, 573, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(76871, 'Tiger1', 1, 573, 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, 573, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(76872, 'Tiger1', 1, 573, 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, 573, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);


delete from cq_action where id >= 8150530 and id <= 8150535;

insert into cq_action (id,id_next,id_nextfail,type,data,param) 
values 
(8150530,8150531,8150534,508,0,'1 0 52'),
(8150531,8150532,0,502,815060,''),
(8150532,8150533,0,501,1082880,''),
(8150533,8150535,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1082880,0,0,815060,0,0'),
(8150534,0,0,126,0,'Please~make~a~space~in~your~eudemon~bags!'),
(8150535,0,0,126,0,'Congratz!~You!~got~your~eudemon~egg!');


delete from cq_itemtype where id >= 815060 and id <= 815060;
delete from cq_itemtype where id >= 1082880 and id <= 1082880;
delete from cq_itemtype where id >= 1072880 and id <= 1072882;
delete from cq_itemtype where id >= 1076880 and id <= 1076882;

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
('815060',  'Tiger2',   '28', '3000000', '8150530', '0000', '1', '1', '00', '00000', '1082880', '0', '0', '30000', '00', '00', '00', '00', '00'),
('1082880', 'Tiger2',   '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1072880', 'Tiger2',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072880', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072881', 'Tiger2',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072881', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072882', 'Tiger2',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072882', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076880', 'Tiger2',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076880', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076881', 'Tiger2',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076881', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076882', 'Tiger2',   '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076882', '7', '1', '00', '11', '21', '31', '41', '51');


delete from cq_eudemon_rbn_type where id >= 1072880 and id <= 1072882;
delete from cq_eudemon_rbn_type where id >= 1076880 and id <= 1076882;


insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`) 
values 
('1072880', '0', '1', '1', '0', '0'),
('1072881', '0', '1', '1', '0', '0'),
('1072882', '0', '1', '1', '0', '0'),
('1076880', '0', '1', '1', '0', '0'),
('1076881', '0', '1', '1', '0', '0'),
('1076882', '0', '1', '1', '0', '0');


delete from cq_grade where id >= 1072880 and id <=1072882;
delete from cq_grade where id >= 1076880 and id <=1076882;

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
(1072880, 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),
(1072881, 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),
(1072882, 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),
(1076880, 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),
(1076881, 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),
(1076882, 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 >= 72880 and id <= 72882;
delete from cq_monstertype where id >= 76880 and id <= 76882;

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 
(72880, 'Tiger2', 1, 673, 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, 673, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(72881, 'Tiger2', 1, 673, 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, 673, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(72882, 'Tiger2', 1, 673, 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, 673, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(76880, 'Tiger2', 1, 673, 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, 673, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(76881, 'Tiger2', 1, 673, 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, 673, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(76882, 'Tiger2', 1, 673, 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, 673, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
others u need to add them ;) use search button :)
eggs:-
Code:
[B][B]/awarditem 815057 /awarditem 815058 /awarditem 815059 /awarditem 815060[/B][/B]
To Download the file :-




BestRegards.
 
Back
Top