[RELEASE] Lama Mounts - Virgo and Virgin

hirosu · 09/11/2009, 05:33

in my server this mount appear in this mode: without his body only appear the armor.

ProSkyZ · 09/12/2009, 15:13

Thanks alot

KiiDxLaggy · 10/02/2009, 21:28

hmm when i add this, the appear dead and with no loyalty or anything then i fixed that in DB i made loyalty 150 and star like 60 and now the appear dead( when i revive them it looks invisible and i cant do anything to it like mount/compose it says Please revive this eudemon first)

PraDevil[ELITE] · 12/03/2009, 00:01

help me your eudemon cannot compose =.=

Crazy123456 · 01/19/2010, 05:59

i encountered a problem i couldnt see anything in my shopping mall ...

if you know the cause can you tell me cause id really like the mount

Quote:

Originally Posted by hirosu

in my server this mount appear in this mode: without his body only appear the armor.

there could be a problem in the edit in the c3 / texture file

Knight^Hawk · 01/19/2010, 07:22

Quote:

Originally Posted by Crazy123456

i encountered a problem i couldnt see anything in my shopping mall ... if you know the cause can you tell me cause id really like the mount

you need to edit your shop.dat and your cq_goods table

gege2900 · 03/16/2010, 18:28

i made lama in my server but whe open shopping mall
dont work say id 190770 error

can ny1 help me plzzzzzzzzzzz

gege2900 · 03/17/2010, 15:48

plz any1 help me t get this 2 mounts in my server

PraDevil[ELITE] · 03/17/2010, 17:19

stop your double post..this is the edit button

on topic : edit your itemtype and shop.dat by funhacker tool or winhex or your hex edit tools..

Code:

try to learn from your result.. = ="

gege2900 · 03/17/2010, 17:26

edite what in them plzzzzzzzzzzzzz

King_Arthur · 03/17/2010, 17:44

@gege2900 This guide is for adding the mounts to your server, not adding the mounts to your shopping mall. Please keep your shopping mall questions in the shopping mall thread you already made.

gege2900 · 03/18/2010, 15:24

plz when put this mounts in my server
cant see shoppingmall
can u help me to get them in my server plz
with simply guide

SoulNecturn · 03/18/2010, 15:44

thanks arthur since you are right.

this release is about mount - how to put it inside DB + inside client and obtain for example via awarditem action.

about getting it from shopping mall - gege this you must do by yourself. We all are aware that shps and even itemtype.dat files are so different in these times by each pserver that we cant prepare certain ready for use thing (at least without bigger afford + resource and best knowledge about others files "for example to not add or replace same pets/mounts with same ids etc".

So please take this guide as a base to put this mount into server. About shop available just pick one of existing topic about this (there are for sure few pretty good guides how to along with tools using which you wont even need bigger wisdom :/)...

just remember (cq_goods record must be added along with edition of shop.dat. Then ensure your IDs are fitting DB <=> client side) then you wont have any error and you will achieve what you wish to achieve

Best regards

gege2900 · 03/18/2010, 15:50

Quote:

delete from cq_action where id >= 7295390 and id <= 7295395;

insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(7295390,7295391,7295394,508,0,'1 0 52'),
(7295391,7295392,0,502,729434,''),
(7295392,7295393,0,501,1081600,''),
(7295393,7295395,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081600,0,0,729434,0,0'),
(7295394,0,0,126,0,'Please~make~one~space~in~your~ eudemon~bag~free!'),
(7295395,0,0,126,0,'Congratulations!~You~have~obta ined~an~Virgo~egg!');

delete from cq_action where id >= 7295490 and id <= 7295495;

insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(7295490,7295491,7295494,508,0,'1 0 52'),
(7295491,7295492,0,502,729435,''),
(7295492,7295493,0,501,1081610,''),
(7295493,7295495,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081610,0,0,729435,0,0'),
(7295494,0,0,126,0,'Please~make~one~space~in~your~ eudemon~bag~free!'),
(7295495,0,0,126,0,'Congratulations!~You~have~obta ined~an~Virgin~egg!');

delete from cq_eudemon_rbn_type where id >= 1071600 and id <= 1071612;
delete from cq_eudemon_rbn_type where id >= 1079600 and id <= 1079612;

INSERT INTO `cq_eudemon_rbn_type` (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`) VALUES
(1071600, 1, 1, 1, 1, 1),
(1071601, 1, 1, 1, 1, 1),
(1071602, 1, 1, 1, 1, 1),
(1079600, 1, 1, 1, 1, 1),
(1079601, 1, 1, 1, 1, 1),
(1079602, 1, 1, 1, 1, 1);

INSERT INTO `cq_eudemon_rbn_type` (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`) VALUES
(1071610, 1, 1, 1, 1, 1),
(1071611, 1, 1, 1, 1, 1),
(1071612, 1, 1, 1, 1, 1),
(1079610, 1, 1, 1, 1, 1),
(1079611, 1, 1, 1, 1, 1),
(1079612, 1, 1, 1, 1, 1);

delete from cq_itemtype where id >= 729434 and id <= 729434;
delete from cq_itemtype where id >= 1081600 and id <= 1081600;
delete from cq_itemtype where id >= 1071600 and id <= 1071602;
delete from cq_itemtype where id >= 1079600 and id <= 1079602;

insert into cq_itemtype (id,name,monopoly,price,id_action,attack_max,attac k_min,defense,dodge,life,gem1,magic_def,atk_range, hitrate,monster_type,able_mask,exp_type, emoney,official2)
values
(729434,'VirgoBeastBag',28,0,7295390,0,0,0,0,0,0,0 ,0,0,1081600,0,0,22000000,0),
(1081600,'VirgoBeastEgg',4,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0),
(1071600,'VirgoBeast',0,250,0,0,0,0,0,0,32,0,1,900 0,71600,7,1,0,21),
(1071601,'VirgoBeast',0,250,0,0,0,0,0,0,32,0,1,900 0,71601,7,1,0,21),
(1071602,'VirgoBeast',0,250,0,0,0,0,0,0,32,0,1,900 0,71602,7,1,0,21),
(1079600,'VirgoBeast',0,250,0,0,0,0,0,0,32,0,1,900 0,79600,7,1,0,21),
(1079601,'VirgoBeast',0,250,0,0,0,0,0,0,32,0,1,900 0,79601,7,1,0,21),
(1079602,'VirgoBeast',0,250,0,0,0,0,0,0,32,0,1,900 0,79602,7,1,0,21);

delete from cq_itemtype where id >= 729435 and id <= 729435;
delete from cq_itemtype where id >= 1081610 and id <= 1081610;
delete from cq_itemtype where id >= 1071610 and id <= 1071612;
delete from cq_itemtype where id >= 1079610 and id <= 1079612;

insert into cq_itemtype (id,name,monopoly,price,id_action,attack_max,attac k_min,defense,dodge,life,gem1,magic_def,atk_range, hitrate,monster_type,able_mask,exp_type, emoney,official2)
values
(729435,'VirginBeastBag',28,0,7295490,0,0,0,0,0,0, 0,0,0,1081610,0,0,22000000,0),
(1081610,'VirginBeastEgg',4,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0),
(1071610,'VirginBeast',0,250,0,0,0,0,0,0,32,0,1,90 00,71610,7,1,0,21),
(1071611,'VirginBeast',0,250,0,0,0,0,0,0,32,0,1,90 00,71611,7,1,0,21),
(1071612,'VirginBeast',0,250,0,0,0,0,0,0,32,0,1,90 00,71612,7,1,0,21),
(1079610,'VirginBeast',0,250,0,0,0,0,0,0,32,0,1,90 00,79610,7,1,0,21),
(1079611,'VirginBeast',0,250,0,0,0,0,0,0,32,0,1,90 00,79611,7,1,0,21),
(1079612,'VirginBeast',0,250,0,0,0,0,0,0,32,0,1,90 00,79612,7,1,0,21);

delete from cq_monstertype where id >= 71600 and id <= 71602;
delete from cq_monstertype where id >= 79600 and id <= 79602;

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, 'VirgoBeast', 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, 'VirgoBeast', 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, 'VirgoBeast', 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, 'VirgoBeast', 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, 'VirgoBeast', 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, 'VirgoBeast', 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);

delete from cq_monstertype where id >= 71610 and id <= 71612;
delete from cq_monstertype where id >= 79610 and id <= 79612;

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
(71610, 'VirginBeast', 0001, 0945, 0, 0, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0007, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0001, 10000, 0000, 0000, 0000, 0000, 945, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71611, 'VirginBeast', 0001, 0946, 0, 0, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0007, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0001, 10000, 0000, 0000, 0000, 0000, 946, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71612, 'VirginBeast', 0001, 0947, 0, 0, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0007, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0001, 10000, 0000, 0000, 0000, 0000, 947, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79610, 'VirginBeast', 0001, 0945, 0, 0, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0007, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0001, 10000, 0000, 0000, 0000, 0000, 945, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79611, 'VirginBeast', 0001, 0946, 0, 0, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0007, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0001, 10000, 0000, 0000, 0000, 0000, 946, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79612, 'VirginBeast', 0001, 0947, 0, 0, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0007, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0001, 10000, 0000, 0000, 0000, 0000, 947, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

delete from cq_grade where id >= 1071600 and id <=1071602;
delete from cq_grade where id >= 1079600 and id <=1079602;

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
(1071600, 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),
(1071601, 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),
(1071602, 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),

(1079600, 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),
(1079601, 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),
(1079602, 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);

delete from cq_grade where id >= 1071610 and id <=1071612;
delete from cq_grade where id >= 1079610 and id <=1079612;

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
(1071610, 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),
(1071611, 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),
(1071612, 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),

(1079610, 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),
(1079611, 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),
(1079612, 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);

delete from cq_dyna_rank_type where id >= 1160010 and id <=1160040;
delete from cq_dyna_rank_type where id >= 2160010 and id <=2160040;

insert into cq_dyna_rank_type (type,rank_number)
values
(1160010,120),
(1160011,120),
(1160012,120),
(1160013,120),
(1160014,120),
(1160015,120),
(1160016,120),
(1160020,120),
(1160021,120),
(1160022,120),
(1160023,120),
(1160024,120),
(1160025,120),
(1160026,120),
(1160040,120),
(2160010,120),
(2160011,120),
(2160012,120),
(2160013,120),
(2160014,120),
(2160015,120),
(2160016,120),
(2160020,120),
(2160021,120),
(2160022,120),
(2160023,120),
(2160024,120),
(2160025,120),
(2160026,120),
(2160040,120);

delete from cq_dyna_rank_type where id >= 1161010 and id <=1161040;
delete from cq_dyna_rank_type where id >= 2161010 and id <=2161040;

insert into cq_dyna_rank_type (type,rank_number)
values
(1161010,120),
(1161011,120),
(1161012,120),
(1161013,120),
(1161014,120),
(1161015,120),
(1161016,120),
(1161020,120),
(1161021,120),
(1161022,120),
(1161023,120),
(1161024,120),
(1161025,120),
(1161026,120),
(1161040,120),
(2161010,120),
(2161011,120),
(2161012,120),
(2161013,120),
(2161014,120),
(2161015,120),
(2161016,120),
(2161020,120),
(2161021,120),
(2161022,120),
(2161023,120),
(2161024,120),
(2161025,120),
(2161026,120),
(2161040,120);

this codes when put them in navicat
1- cant see shoppingmall
2- menstor and guards remove
iam use Shop Editor and ItemtypeEditor to try to fix this

iam use candy db

~~matrix89~~ · 03/18/2010, 16:53

if you want put in shoppingmall..
1. in db your must add item id in cq_goods and shoppingmall id is 1207.
2. just edit your client only..if you don't see it...
Edit your itemtype.dat and your shop.dat

Add in Itemtype.dat

Code:

729434 VirgoBeastBag
1081600 VirgoBeastEgg
1071600 VirgoBeast
1071601 VirgoBeast
1071602 VirgoBeast
1079600 VirgoBeast
1079601 VirgoBeast
1079602 VirgoBeast

Code:

729434 VirgoBeastBag 
1081600 VirgoBeastEgg 
1071600 VirgoBeast 
1071601 VirgoBeast
1071602 VirgoBeast
1079600 VirgoBeast
1079601 VirgoBeast
1079602 VirgoBeast

and last...cheak your ItemMinIcon.ANI And MapItemIcon.ANI
in ani Client folder