Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Eudemons Online > EO PServer Hosting
You last visited: Today at 22:58

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Help] SQL for Elephant .

Discussion on [Help] SQL for Elephant . within the EO PServer Hosting forum part of the Eudemons Online category.

Reply
 
Old   #1
 
abdeen's Avatar
 
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 ?



abdeen is offline  
Old 05/04/2010, 22:29   #2
 
KikkenF's Avatar
 
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.
KikkenF is offline  
Thanks
2 Users
Old 05/04/2010, 23:16   #3
 
abdeen's Avatar
 
elite*gold: 0
Join Date: Mar 2010
Posts: 475
Received Thanks: 14
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
(107216011111),
(
107216111111),
(
107216211111),
(
107616011111),
(
107616111111),
(
107616211111);




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_typeemoney,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'000109400100000000000000000000000000000000000000000000070015000010000000000132775100000000003000000000990990990990990990990000000050000000007500750002100000000000000000000940000000000000000000000000000000000000000000000001000000000000000),
(
1072161'Elephant'000109410100000000000000000000000000000000000000000000070015000010000000000132775100000000003000000000990990990990990990990000000050000000007500750002100000000000000000000941000000000000000000000000000000000000000000000001000000000000000),
(
1072162'Elephant'000109420100000000000000000000000000000000000000000000070015000010000000000132775100000000003000000000990990990990990990990000000050000000007500750002100000000000000000000942000000000000000000000000000000000000000000000001000000000000000),
(
1076160'Elephant'000109400100000000000000000000000000000000000000000000070015000010000000000132775100000000003000000000990990990990990990990000000050000000007500750002100000000000000000000940000000000000000000000000000000000000000000000001000000000000000),
(
1076161'Elephant'000109410100000000000000000000000000000000000000000000070015000010000000000132775100000000003000000000990990990990990990990000000050000000007500750002100000000000000000000941000000000000000000000000000000000000000000000001000000000000000),
(
1076162'Elephant'000109420100000000000000000000000000000000000000000000070015000010000000000132775100000000003000000000990990990990990990990000000050000000007500750002100000000000000000000942000000000000000000000000000000000000000000000001000000000000000);






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
(10721602036712900725093220231400080008773301027000195002239996470001700035011861364001700042417991186002750015511563760001550019750131200050009999910),
(
10721612036712900725093220231400080008773301027000195002239996470001700035011861364001700042417991186002750015511563760001550019750131200050009999910),
(
10721622036712900725093220231400080008773301027000195002239996470001700035011861364001700042417991186002750015511563760001550019750131200050009999910),

(
10761602036712900725093220231400080008773301027000195002239996470001700035011861364001700042417991186002750015511563760001550019750131200050009999910),
(
10761612036712900725093220231400080008773301027000195002239996470001700035011861364001700042417991186002750015511563760001550019750131200050009999910),
(
10761622036712900725093220231400080008773301027000195002239996470001700035011861364001700042417991186002750015511563760001550019750131200050009999910); 
abdeen is offline  
Old 05/04/2010, 23:54   #4
 
PraDevil[ELITE]'s Avatar
 
elite*gold: 0
Join Date: Nov 2009
Posts: 1,490
Received Thanks: 909
totally wrong on your cq_itemtype and cq_monstertype
PraDevil[ELITE] is offline  
Old 05/05/2010, 00:01   #5
 
KikkenF's Avatar
 
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.
KikkenF is offline  
Thanks
1 User
Old 05/05/2010, 00:03   #6
 
abdeen's Avatar
 
elite*gold: 0
Join Date: Mar 2010
Posts: 475
Received Thanks: 14
Quote:
Originally Posted by PraDevil View Post
totally wrong on your cq_itemtype and cq_monstertype
okay , could you tell me the correct ?
abdeen is offline  
Old 05/05/2010, 00:04   #7
 
abdeen's Avatar
 
elite*gold: 0
Join Date: Mar 2010
Posts: 475
Received Thanks: 14
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 ?
abdeen is offline  
Old 05/05/2010, 07:37   #8
 
elite*gold: 0
Join Date: Jan 2009
Posts: 51
Received Thanks: 1
its still wrong
medoimedoi123 is offline  
Old 05/05/2010, 07:39   #9
 
T.h.u.n.d.e.r's Avatar
 
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 !!
T.h.u.n.d.e.r is offline  
Old 05/05/2010, 12:04   #10
 
KikkenF's Avatar
 
elite*gold: 0
Join Date: Nov 2007
Posts: 190
Received Thanks: 112
Quote:
Originally Posted by medoimedoi123 View Post
its still wrong
As i said, i didnt corrected everything.
KikkenF is offline  
Reply


Similar Threads 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.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.