You last visited: Today at 02:11
Advertisement
[Release]CancerQueen & CancerPrincess
Discussion on [Release]CancerQueen & CancerPrincess within the EO PServer Guides & Releases forum part of the EO PServer Hosting category.
06/17/2010, 00:33
#1
elite*gold: 0
Join Date: Aug 2009
Posts: 84
Received Thanks: 111
[Release]CancerQueen & CancerPrincess
Name : CancerQueen & CancerPrincess
Type : Pets
Screens :
Pet ID :
CancerQueen
1071150
1071151
1071152
1079150
1079151
1079152
1081150
729430
---------------
CancerPrincess
1071670
1071671
1071672
1079670
1079671
1079672
1081670
729431
lookfaces :
Attached Files
CancerQueen & CancerPrincess.rar
(1.72 MB, 504 views)
06/17/2010, 01:08
#2
elite*gold: 0
Join Date: Apr 2010
Posts: 12
Received Thanks: 0
Hello could put the query too? I do not know, hence complicating, sorry
06/17/2010, 04:48
#3
elite*gold: 0
Join Date: Mar 2010
Posts: 378
Received Thanks: 132
awesome keep it up !
06/17/2010, 05:57
#4
elite*gold: 0
Join Date: Sep 2009
Posts: 153
Received Thanks: 4
Thanks a lot...
06/17/2010, 13:57
#5
elite*gold: 0
Join Date: Aug 2009
Posts: 559
Received Thanks: 183
nice release.. ty..
06/18/2010, 01:11
#6
elite*gold: 0
Join Date: Aug 2009
Posts: 84
Received Thanks: 111
Quote:
Originally Posted by
moacirc
Hello could put the query too? I do not know, hence complicating, sorry
sorry you will have to make it by your self ...
06/18/2010, 10:48
#7
elite*gold: 0
Join Date: Dec 2009
Posts: 164
Received Thanks: 14
help!
how can you save the file Pets?
thanks
06/18/2010, 13:50
#8
elite*gold: 0
Join Date: Aug 2009
Posts: 84
Received Thanks: 111
Quote:
Originally Posted by
reloaded90
help!
how can you save the file Pets?
thanks
what do you mean ?
06/18/2010, 17:18
#9
elite*gold: 0
Join Date: Dec 2009
Posts: 164
Received Thanks: 14
add file CancerQueen & CancerPrincess.rar
be taught
06/18/2010, 18:01
#10
elite*gold: 0
Join Date: Aug 2009
Posts: 84
Received Thanks: 111
Quote:
Originally Posted by
reloaded90
add file CancerQueen & CancerPrincess.rar
be taught
just click the rar file in my first post .....
06/26/2010, 15:25
#11
elite*gold: 0
Join Date: May 2010
Posts: 194
Received Thanks: 59
can someone plz give me the sql for this i cant seem to make it
06/27/2010, 01:47
#12
elite*gold: 0
Join Date: Aug 2009
Posts: 84
Received Thanks: 111
Quote:
Originally Posted by
seraf2
can someone plz give me the sql for this i cant seem to make it
You will have to make it by yourself ..
06/27/2010, 12:27
#13
elite*gold: 0
Join Date: May 2010
Posts: 194
Received Thanks: 59
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,1081670,0,0,729431,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 >= 729431 and id <= 729431;
delete from cq_itemtype where id >= 1081670 and id <= 1081670;
delete from cq_itemtype where id >= 1071670 and id <= 1071672;
delete from cq_itemtype where id >= 1079670 and id <= 1079672;
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
('729431', 'CancerPrincess', '28', '3000000', '729431', '0000', '1', '1', '00', '00000', '1081670', '0', '0', '30000', '00', '00', '00', '00', '00'),
('1081670', 'CancerPrincess', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071670', 'CancerPrincess', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072850', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071671', 'CancerPrincess', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072851', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071672', 'CancerPrincess', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0072852', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079670', 'CancerPrincess', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076850', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079671', 'CancerPrincess', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0076851', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079672', 'CancerPrincess', '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 >= 1071670 and id <= 1071672;
delete from cq_eudemon_rbn_type where id >= 1079670 and id <= 1079672;
insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`)
values
('1071670', '0', '1', '1', '0', '0'),
('1071671', '0', '1', '1', '0', '0'),
('1071672', '0', '1', '1', '0', '0'),
('1079670', '0', '1', '1', '0', '0'),
('1079671', '0', '1', '1', '0', '0'),
('1079672', '0', '1', '1', '0', '0');
delete from cq_grade where id >= 1071670 and id <=1071672;
delete from cq_grade where id >= 1079670 and id <=1079672;
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
(1071670, 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),
(1071671, 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),
(1071672, 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),
(1079670, 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),
(1079671, 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),
(1079672, 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 >= 71670 and id <= 71672;
delete from cq_monstertype where id >= 79670 and id <= 79672;
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
(71670, 'CancerPrincess', 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),
(71671, 'CancerPrincess', 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),
(71672, 'CancerPrincess', 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),
(79670, 'CancerPrincess', 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),
(79671, 'CancerPrincess', 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),
(79672, 'CancerPrincess', 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,1081150,0,0,729430,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 >= 729430 and id <= 729430;
delete from cq_itemtype where id >= 1081150 and id <= 1081150;
delete from cq_itemtype where id >= 1071150 and id <= 1071152;
delete from cq_itemtype where id >= 1079150 and id <= 1079152;
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
('729430', 'CancerQueen', '28', '3000000', '8150510', '0000', '1', '1', '00', '00000', '1081150', '0', '0', '30000', '00', '00', '00', '00', '00'),
('1081150', 'CancerQueen', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071150', 'CancerQueen', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071150', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071151', 'CancerQueen', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071151', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071152', 'CancerQueen', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071152', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079150', 'CancerQueen', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079150', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079151', 'CancerQueen', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079151', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079152', 'CancerQueen', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079152', '7', '1', '00', '11', '21', '31', '41', '51');
delete from cq_eudemon_rbn_type where id >= 1071150 and id <= 1071152;
delete from cq_eudemon_rbn_type where id >= 1079150 and id <= 1079152;
insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`)
values
('1071150', '0', '1', '1', '0', '0'),
('1071151', '0', '1', '1', '0', '0'),
('1071152', '0', '1', '1', '0', '0'),
('1079150', '0', '1', '1', '0', '0'),
('1079151', '0', '1', '1', '0', '0'),
('1079152', '0', '1', '1', '0', '0');
delete from cq_grade where id >= 1071150 and id <=1071152;
delete from cq_grade where id >= 1079150 and id <=1079152;
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
(1071150, 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),
(1071151, 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),
(1071152, 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),
(1079150, 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),
(1079151, 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),
(1079152, 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 >= 71150 and id <= 71152;
delete from cq_monstertype where id >= 79150 and id <= 79152;
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
(71150, 'CancerQueen', 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),
(71151, 'CancerQueen', 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),
(71152, 'CancerQueen', 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),
(79150, 'CancerQueen', 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),
(79151, 'CancerQueen', 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),
(79152, 'CancerQueen', 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);
is this correct
07/08/2010, 03:50
#14
elite*gold: 0
Join Date: May 2008
Posts: 25
Received Thanks: 11
CancerQueen And Princess Sql
Code:
delete from cq_action where id >= 8150900 and id <= 8150905;
insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(8150900,8150901,8150904,508,0,'1 0 52'),
(8150901,8150902,0,502,729430,''),
(8150902,8150903,0,501,1081915,''),
(8150903,8150905,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081915,0,0,729430,0,0'),
(8150904,0,0,126,0,'Please~make~one~space~in~your~eudemon~bag~free!'),
(8150905,0,0,126,0,'Congratulations!~You~have~obtained~a~CancerPrincess~egg!');
delete from cq_itemtype where id >= 729430 and id <= 729430;
delete from cq_itemtype where id >= 1081915 and id <= 1081915;
delete from cq_itemtype where id >= 1071915 and id <= 1071917;
delete from cq_itemtype where id >= 1079915 and id <= 1079917;
INSERT INTO cq_itemtype (id,name,monopoly,price,id_action,attack_max,attack_min,defense,dodge,life,gem1,magic_def,atk_range,hitrate,monster_type,able_mask,exp_type,emoney)
VALUES
(729430, 'CancerPrincess',28,4321,8150900,0,0,0,0,0,0,0,0,0,1081670,0,0,30000),
(1081915,'CancerPrincess',4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
(1071915,'CancerPrincess',0,250,0,0,0,0,0,0,32,0,1,9000,71915,3,1,0),
(1071916,'CancerPrincess',0,250,0,0,0,0,0,0,32,0,1,9000,71916,3,1,0),
(1071917,'CancerPrincess',0,250,0,0,0,0,0,0,32,0,1,9000,71917,3,1,0),
(1079915,'CancerPrincess',0,250,0,0,0,0,0,0,32,0,1,9000,79915,3,1,0),
(1079916,'CancerPrincess',0,250,0,0,0,0,0,0,32,0,1,9000,79916,3,1,0),
(1079917,'CancerPrincess',0,250,0,0,0,0,0,0,32,0,1,9000,79917,3,1,0);
delete from cq_eudemon_rbn_type where id >= 1071915 and id <= 1071917;
delete from cq_eudemon_rbn_type where id >= 1079915 and id <= 1079917;
insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`)
values
('1071915', '0', '1', '1', '0', '0'),
('1071916', '0', '1', '1', '0', '0'),
('1071917', '0', '1', '1', '0', '0'),
('1079915', '0', '1', '1', '0', '0'),
('1079916', '0', '1', '1', '0', '0'),
('1079917', '0', '1', '1', '0', '0');
delete from cq_grade where id >= 1071915 and id <=1071917;
delete from cq_grade where id >= 1079915 and id <=1079917;
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
(1071915, 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),
(1071916, 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),
(1071917, 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),
(1079915, 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),
(1079916, 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),
(1079917, 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 >= 71915 and id <= 71917;
delete from cq_monstertype where id >= 79915 and id <= 79917;
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
(71915, 'CancerPrincess', 1, 375, 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),
(71916, 'CancerPrincess', 1, 375, 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),
(71917, 'CancerPrincess', 1, 375, 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),
(79915, 'CancerPrincess', 1, 375, 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),
(79916, 'CancerPrincess', 1, 375, 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),
(79917, 'CancerPrincess', 1, 375, 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 >= 8150800 and id <= 8150805;
insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(8150800,8150801,8150804,508,0,'1 0 52'),
(8150801,8150802,0,502,729431,''),
(8150802,8150803,0,501,1081900,''),
(8150803,8150805,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081900,0,0,729431,0,0'),
(8150804,0,0,126,0,'Please~make~one~space~in~your~eudemon~bag~free!'),
(8150805,0,0,126,0,'Congratulations!~You~have~obtained~a~CancerQueen~egg!');
delete from cq_itemtype where id >= 729431 and id <= 729431;
delete from cq_itemtype where id >= 1081900 and id <= 1081900;
delete from cq_itemtype where id >= 1071900 and id <= 1071902;
delete from cq_itemtype where id >= 1079900 and id <= 1079902;
INSERT INTO cq_itemtype (id,name,monopoly,price,id_action,attack_max,attack_min,defense,dodge,life,gem1,magic_def,atk_range,hitrate,monster_type,able_mask,exp_type,emoney)
VALUES
(729431, 'CancerQueen',28,4321,8150800,0,0,0,0,0,0,0,0,0,1081150,0,0,30000),
(1081900,'CancerQueen',4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
(1071900,'CancerQueen',0,250,0,0,0,0,0,0,32,0,1,9000,71900,3,1,0),
(1071901,'CancerQueen',0,250,0,0,0,0,0,0,32,0,1,9000,71901,3,1,0),
(1071902,'CancerQueen',0,250,0,0,0,0,0,0,32,0,1,9000,71902,3,1,0),
(1079900,'CancerQueen',0,250,0,0,0,0,0,0,32,0,1,9000,79900,3,1,0),
(1079901,'CancerQueen',0,250,0,0,0,0,0,0,32,0,1,9000,79901,3,1,0),
(1079902,'CancerQueen',0,250,0,0,0,0,0,0,32,0,1,9000,79902,3,1,0);
delete from cq_eudemon_rbn_type where id >= 1071900 and id <= 1071902;
delete from cq_eudemon_rbn_type where id >= 1079900 and id <= 1079902;
insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`)
values
('1071900', '0', '1', '1', '0', '0'),
('1071901', '0', '1', '1', '0', '0'),
('1071902', '0', '1', '1', '0', '0'),
('1079900', '0', '1', '1', '0', '0'),
('1079901', '0', '1', '1', '0', '0'),
('1079902', '0', '1', '1', '0', '0');
delete from cq_grade where id >= 1071900 and id <=1071902;
delete from cq_grade where id >= 1079900 and id <=1079902;
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
(1071900, 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),
(1071901, 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),
(1071902, 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),
(1079900, 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),
(1079901, 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),
(1079902, 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 >= 71900 and id <= 71902;
delete from cq_monstertype where id >= 79900 and id <= 79902;
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
(71900, 'CancerQueen', 1, 374, 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),
(71901, 'CancerQueen', 1, 374, 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),
(71902, 'CancerQueen', 1, 374, 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),
(79900, 'CancerQueen', 1, 374, 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),
(79901, 'CancerQueen', 1, 374, 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),
(79902, 'CancerQueen', 1, 374, 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);
this is a sql script that i edited from that 1 u made it works i have tested it on my server if u have mannequin database those ids i have chose wont conflict unless u have made another pet with those same ids just check first enjoy^^ btw this is 1 of my first ever scripts ive had to rewrite but it works but im always welcome to suggestions of cleaning it up aswell as that sql needs ranking script wasnt too sure on how to do that 1 i might figure it out and post it too
07/08/2010, 10:58
#15
elite*gold: 0
Join Date: May 2010
Posts: 194
Received Thanks: 59
i have revo and that was my first try at making a sql XD im happy it work
All times are GMT +2. The time now is 02:11 .