|
You last visited: Today at 22:58
Advertisement
[Help] SQL for Elephant .
Discussion on [Help] SQL for Elephant . within the EO PServer Hosting forum part of the Eudemons Online category.
05/04/2010, 22:05
|
#1
|
elite*gold: 0
Join Date: Mar 2010
Posts: 475
Received Thanks: 14
|
[Help] SQL for Elephant .
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 ?
|
|
|
05/04/2010, 22:29
|
#2
|
elite*gold: 0
Join Date: Nov 2007
Posts: 190
Received Thanks: 112
|
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
|
#3
|
elite*gold: 0
Join Date: Mar 2010
Posts: 475
Received Thanks: 14
|
Quote:
Originally Posted by KikkenF
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
|
#4
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,490
Received Thanks: 909
|
totally wrong on your cq_itemtype and cq_monstertype
|
|
|
05/05/2010, 00:01
|
#5
|
elite*gold: 0
Join Date: Nov 2007
Posts: 190
Received Thanks: 112
|
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
|
#6
|
elite*gold: 0
Join Date: Mar 2010
Posts: 475
Received Thanks: 14
|
Quote:
Originally Posted by PraDevil
totally wrong on your cq_itemtype and cq_monstertype
|
okay , could you tell me the correct ?
|
|
|
05/05/2010, 00:04
|
#7
|
elite*gold: 0
Join Date: Mar 2010
Posts: 475
Received Thanks: 14
|
Quote:
Originally Posted by KikkenF
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
|
#8
|
elite*gold: 0
Join Date: Jan 2009
Posts: 51
Received Thanks: 1
|
its still wrong
|
|
|
05/05/2010, 07:39
|
#9
|
elite*gold: 0
Join Date: Mar 2010
Posts: 378
Received Thanks: 132
|
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
|
#10
|
elite*gold: 0
Join Date: Nov 2007
Posts: 190
Received Thanks: 112
|
Quote:
Originally Posted by medoimedoi123
its still wrong
|
As i said, i didnt corrected everything.
|
|
|
Similar Threads
|
[RE-RELEASE] Elephant mount
04/07/2011 - EO PServer Guides & Releases - 14 Replies
i tut many of people here having a problem with this mount..
so here is it..
add this id in itemtype.dat
815115
1081690
1071690
1071691
1071692
|
[request]Elephant hill generator Sql
08/22/2010 - EO PServer Hosting - 3 Replies
Hello all , i have seen the elephant hill map in many dbs full of monsters but when i checked it in the revo db itis empty , can some one give me cq_generator of this map please ?
|
lol elephant
05/03/2010 - EO PServer Hosting - 30 Replies
lol im was really like the elephant..and i will put it in my server.. XD
here link:
如风网络魔域v0320新宝宝新地图仿官方免费版 >>魔域版本>>下载中心>>私服站长站 免费私服下载 传奇服务端 登陆器 网站模板 4fcom.net
http://www.4fcom.net/soft/UploadSoftPic/201003/20 10032112474074.jpg
|
code for blue elephant?
05/02/2010 - CO2 Private Server - 1 Replies
what is the code for the little blue elephant / has?
|
All times are GMT +1. The time now is 22:58.
|
|