[Help] SQL for Elephant .

05/04/2010 22:05 abdeen#1
Does its right sql for elephant ?

Code:
insert into cq_action (id,id_next,id_nextfail,type,data,param)
values 
(7295290,7295291,7295294,508,0,'1 0 52'),
(7295291,7295292,0,502,815115,''),
(7295292,7295293,0,501,1082160,''),
(7295293,7295295,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1082160,0,0,815115,0,0'),
(7295294,0,0,126,0,'Please~make~one~space~in~your~eudemon~bag~free!'),
(7295295,0,0,126,0,'Congratulations!~You~have~obtained~an~elephant~egg!');




=======================================================

INSERT INTO `cq_eudemon_rbn_type` (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`) VALUES
(1072160, 1, 1, 1, 1, 1),
(1072161, 1, 1, 1, 1, 1),
(1072162, 1, 1, 1, 1, 1),
(1076160, 1, 1, 1, 1, 1),
(1076161, 1, 1, 1, 1, 1),
(1076162, 1, 1, 1, 1, 1);


==============================================================

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,official2) 
values 
(815115,'ElephantBag',28,0,7295290,0,0,0,0,0,0,0,0,0,1082160,0,0,22000000,0),
(1082160,'ElephantEgg',4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
(1072160,'Elephant',0,250,0,0,0,0,0,0,32,0,1,9000,71600,7,1,0,21),
(1072161,'Elephant',0,250,0,0,0,0,0,0,32,0,1,9000,71601,7,1,0,21),
(1072162,'Elephant',0,250,0,0,0,0,0,0,32,0,1,9000,71602,7,1,0,21),
(1076160,'Elephant',0,250,0,0,0,0,0,0,32,0,1,9000,79600,7,1,0,21),
(1076161,'Elephant',0,250,0,0,0,0,0,0,32,0,1,9000,79601,7,1,0,21),
(1076162,'Elephant',0,250,0,0,0,0,0,0,32,0,1,9000,79602,7,1,0,21);
=================================================


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

(71600, 'Elephant', 0001, 0940, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 940, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71601, 'Elephant', 0001, 0941, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 941, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71602, 'Elephant', 0001, 0942, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 942, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79600, 'Elephant', 0001, 0940, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 940, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79601, 'Elephant', 0001, 0941, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 941, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79602, 'Elephant', 0001, 0942, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 942, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);


===========================================================================



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
(1072160, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1072161, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1072162, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),

(1076160, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1076161, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1076162, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0);

and this patch ?

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
05/04/2010 22:29 KikkenF#2
Seems right, all but cq_monstertype.

If ID=1072160, then cq_monstertype ID=2160,

and for thunder if ID=1076160, cq_monstertype ID=6160.
05/04/2010 23:16 abdeen#3
Quote:
Originally Posted by KikkenF View Post
Seems right, all but cq_monstertype.

If ID=1072160, then cq_monstertype ID=2160,

and for thunder if ID=1076160, cq_monstertype ID=6160.

i thanked you , and what is about this SQL ? if its wrong , plz fix it .

PHP Code:
replace into cq_action (id,id_next,id_nextfail,type,data,param)
values 
(7295290,7295291,7295294,508,0,'1 0 52'),
(7295291,7295292,0,502,815115,''),
(7295292,7295293,0,501,1082160,''),
(7295293,7295295,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1082160,0,0,815115,0,0'),
(7295294,0,0,126,0,'Please~make~one~space~in~your~eudemon~bag~free!'),
(7295295,0,0,126,0,'Congratulations!~You~have~obtained~an~elephant~egg!');






replace INTO `cq_eudemon_rbn_type` (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`) VALUES
(1072160, 1, 1, 1, 1, 1),
(1072161, 1, 1, 1, 1, 1),
(1072162, 1, 1, 1, 1, 1),
(1076160, 1, 1, 1, 1, 1),
(1076161, 1, 1, 1, 1, 1),
(1076162, 1, 1, 1, 1, 1);




replace 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,official2) 
values 
(815115,'ElephantBag',28,0,7295290,0,0,0,0,0,0,0,0,0,1082160,0,0,22000000,0),
(1082160,'ElephantEgg',4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
(1072160,'Elephant',0,250,0,0,0,0,0,0,32,0,1,9000,1072160,7,1,0,21),
(1072161,'Elephant',0,250,0,0,0,0,0,0,32,0,1,9000,1072161,7,1,0,21),
(1072162,'Elephant',0,250,0,0,0,0,0,0,32,0,1,9000,1072162,7,1,0,21),
(1076160,'Elephant',0,250,0,0,0,0,0,0,32,0,1,9000,1076160,7,1,0,21),
(1076161,'Elephant',0,250,0,0,0,0,0,0,32,0,1,9000,1076161,7,1,0,21),
(1076162,'Elephant',0,250,0,0,0,0,0,0,32,0,1,9000,1076162,7,1,0,21);



replace 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

(1072160, 'Elephant', 0001, 0940, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 940, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(1072161, 'Elephant', 0001, 0941, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 941, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(1072162, 'Elephant', 0001, 0942, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 942, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(1076160, 'Elephant', 0001, 0940, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 940, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(1076161, 'Elephant', 0001, 0941, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 941, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(1076162, 'Elephant', 0001, 0942, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 942, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);






replace 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
(1072160, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1072161, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1072162, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),

(1076160, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1076161, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1076162, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0); 
05/04/2010 23:54 PraDevil[ELITE]#4
totally wrong on your cq_itemtype and cq_monstertype
05/05/2010 00:01 KikkenF#5
Code:
replace 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

([COLOR="Red"]2160[/COLOR], 'Elephant', 0001, 0940, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 940, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
([COLOR="Red"]2161[/COLOR], 'Elephant', 0001, 0941, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 941, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
([COLOR="Red"]2162[/COLOR], 'Elephant', 0001, 0942, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 942, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
([COLOR="Red"]6160[/COLOR], 'Elephant', 0001, 0940, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 940, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
([COLOR="Red"]6161[/COLOR], 'Elephant', 0001, 0941, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 941, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
([COLOR="Red"]6162[/COLOR], 'Elephant', 0001, 0942, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 942, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Also, dont forget,

Code:
insert into cq_goods (id,ownerid,itemtype,name) 
values 
(815115,1207,815115,0);

For ranks, you need to get values from DynamicRank.ini and insert,
Code:
insert into cq_dyna_rank_type (type) 
values 
(2111010),
(2111011),
...
...
[COLOR="Red"]DONT USE THESE VALUES[/COLOR]

I didnt corrected everything. What you SHOULD do, is pick a release of a pet and see how the query is done.
When i was asking people didnt answered (im not whining), so i learned by studying the files.
05/05/2010 00:03 abdeen#6
Quote:
Originally Posted by PraDevil View Post
totally wrong on your cq_itemtype and cq_monstertype
okay , could you tell me the correct ?
05/05/2010 00:04 abdeen#7
Quote:
Originally Posted by KikkenF View Post
Code:
replace 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

([COLOR="Red"]2160[/COLOR], 'Elephant', 0001, 0940, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 940, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
([COLOR="Red"]2161[/COLOR], 'Elephant', 0001, 0941, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 941, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
([COLOR="Red"]2162[/COLOR], 'Elephant', 0001, 0942, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 942, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
([COLOR="Red"]6160[/COLOR], 'Elephant', 0001, 0940, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 940, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
([COLOR="Red"]6161[/COLOR], 'Elephant', 0001, 0941, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 941, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
([COLOR="Red"]6162[/COLOR], 'Elephant', 0001, 0942, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 942, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Also, dont forget,

Code:
insert into cq_goods (id,ownerid,itemtype,name) 
values 
(815115,1207,815115,0);

For ranks, you need to get values from DynamicRank.ini and insert,
Code:
insert into cq_dyna_rank_type (type) 
values 
(2111010),
(2111011),
...
...
[COLOR="Red"]DONT USE THESE VALUES[/COLOR]


thanx mate , this working with first SQL i posted or second ?
05/05/2010 07:37 medoimedoi123#8
its still wrong
05/05/2010 07:39 T.h.u.n.d.e.r#9
i think this Elephant is just apetface i mean maby its exist in any db like rhino maby ! but he changed his petface id like every pet in this db he take this faces from crazytao so maby all this monster is just reblaced by another pet face !!
05/05/2010 12:04 KikkenF#10
Quote:
Originally Posted by medoimedoi123 View Post
its still wrong
As i said, i didnt corrected everything.