[Help] Add mount

[KikkenF]

Decided to to make server for personal use and tests (learn basically). Im fresh new on this.

So, im trying to add a full mount (with lookface, egg, etc) and edited the ini files (3 textures, 3 stages). Everything should be fine.

Now, the sql part.
Iv got a sql script from funhacker unicorn release, and adapted it for my pet. Maybee some stuff wrong, but i want the basic for buy it from mall and sum/mount it.

Added it to itemtype.dat then to shop.dat, and its there with price and description. But when i right click to buy, it doesnt really buy. Im guessing its something on cq_action.

-EDIT- I used the awarditem command, but i get it dead, loyalty at 0, and no sum button.

Sql code attached.

[cyberghoser1]

for the shopping mall you have to add it to cq_goods as owner id 1207 also.

[gege2900]

i think he need sql code
i have alot of new pets too
but i need to know how to add sql codes only

[KikkenF]

@cyberghoser1

Yeah its on the code i attached. Nothing hapenning from right click, means cq_action, no?

[cyberghoser1]

Yess i guess, did you adapt the code correctly and made sure cq-action ids are not already used? check again your code.

[KikkenF]

Hm... So i run the code, and it says ID exist as i already ran the code before. But i go over cq_action, search the ID's, and nothing.

Still, i already deleted using "Delete from cq_action where id >= 7294990 and id <= 7294995;" and then ran code again, but cq_action doesnt show up the ID's.

[cyberghoser1]

you mean ingame? when u log as a PM you see the cq_action functions, check where it stops and why that should help you a lot to fix your issues.

[KikkenF]

Well, i cant even buy it, so none actions comes out.
And, when buying a eudemon egg from mall, you get no action. Only when right clicking it on bag.

I was talking about db. Action id is there, but i dont find it. Doesn show up.

[cyberghoser1]

if you cannot buy it from the shoppingmall and your cq_goods is correct then check your itemtype.dat that you did add all the 8 Ids and in cq_itemtype too and that there is a price for the egg bag, thats all i can think of now.

[KikkenF]

Isnt it 5 id's? 3 from each stage (so 3 stages), the egg id, and the egg bag id (only adding one mount). Wich are all added on itemtype.dat, as well as the egg bag is added to shop. With price (being same as price put on cq_itemtype).

[Knight^Hawk]

need to add the same number u have in the itemtype.dat in the emoney column to the cq_itemtype emoney column

[KikkenF]

Wich is the emoney?

[evilminded1981]

If i am not mistaken the emoney is the EPcost

[KikkenF]

Yeah it is, but the problem wasnt there. After reading funhacker guide to add multi stage mounts, i noticed the ID should be 1071 and not 1072. Will try later if all works after changing that.

-EDIT- So, i changed the id's, and can buy it from mall. Then right click and it goes to eudemon bag. Then i put on batch-hatcher. After hatching (batch-hatcher start blinking) and i try to right click on egg, but it says if i do so, time will recount. If i wait a bit, batch-hatcher start blinking again.
It keep hatching, without actually doing it.
Would apreciate some help plz.

[KikkenF]

Sorry for double posting, but im needing some help. Yes i know use search and looked into +10 threads, but still. My problem is that after putting the egg on batch hatcher, cant right click or time recount. It keep hatching.

-----delete from cq_action where id >= 7294990 and id <= 7294995;


insert into cq_action (id,id_next,id_nextfail,type,data,param) 
values 
(7294990,7294991,7294994,508,0,'1 0 52'),
(7294991,7294992,0,502,729434,''),
(7294992,7294993,0,501,1081600,''),
(7294993,7294995,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081600,0,0,729434,0,0'),
(7294994,0,0,126,0,'Please~make~one~space~in~your~eudemon~bag~free!'),
(7294995,0,0,126,0,'Congratulations!~You~have~obtained~a~Test1~egg!');


insert into cq_dyna_rank_type (type) 
values 
(2111010),
(2111011),
(2111012),
(2111013),
(2111014),
(2111015),
(2111016),
(2111020),
(2111021),
(2111022),
(2111023),
(2190024),
(2190025),
(2190026),
(2190040),
(1111010),
(1111011),
(1111012),
(1111013),
(1111014),
(1111015),
(1111016),
(1111020),
(1111021),
(1111022),
(1111023),
(1111024),
(1111025),
(1111026),
(1111040);





------------delete from cq_eudemon_rbn_type where id >= 1071900 and id <= 1071902;
------------delete from cq_eudemon_rbn_type where id >= 1079900 and id <= 1079902;

insert into cq_eudemon_rbn_type (id,phy_atk,phy_def) 
values 
(1071900,1,1),
(1071901,1,1),
(1071902,1,1),
(1079900,1,1),
(1079901,1,1),
(1079902,1,1);



insert into cq_goods (ownerid,itemtype) 
values 
(1207,729434);


------------delete from cq_itemtype where id >= 1071900 and id <= 1071902;
------------delete from cq_itemtype where id = 1081600 and id = 729434;


insert into cq_itemtype (id,name,monopoly,price,id_action,attack_max,attack_min,defense,dodge,life,gem1,magic_def,atk_range,hitrate,monster_type,able_mask,exp_type,emoney)
values 
(729434,'Test1',28,4321,7294990,0,0,0,0,0,0,0,0,0,1081600,0,0,4321),
(1081600,'Test1Egg',4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
(1071900,'Test1',0,250,0,0,0,0,0,0,32,0,1,9000,71900,7,1,0),
(1071901,'Test1',0,250,0,0,0,0,0,0,32,0,1,9000,71901,7,1,0),
(1071902,'Test1',0,250,0,0,0,0,0,0,32,0,1,9000,71902,7,1,0),
(1079900,'Test1',0,250,0,0,0,0,0,0,32,0,1,9000,79900,7,1,0),
(1079901,'Test1',0,250,0,0,0,0,0,0,32,0,1,9000,79901,7,1,0),
(1079902,'Test1',0,250,0,0,0,0,0,0,32,0,1,9000,79902,7,1,0);



------------delete from cq_monstertype where id >= 71900 and id <= 71902;
------------delete from cq_monstertype where id >= 79900 and id <= 79902;


insert into cq_monstertype (id,name,type,lookface,life,attack_range,view_range,attack_speed,level,attack_user,size_add,drop_armet,drop_necklace,drop_armor,drop_ring,drop_weapon,drop_shield,drop_shoes,magic_type,magic_hitrate,atk_hitrate,ai_type,defence,profession)  
values 
(71900,'Test1',1,900,100,7,15,1000,1,32775,3,99,99,99,99,99,99,99,0,0,75,1,10000,900),
(71901,'Test1',1,900,100,7,15,1000,1,32775,3,99,99,99,99,99,99,99,0,0,75,1,10000,900),
(71902,'Test1',1,900,100,7,15,1000,1,32775,3,99,99,99,99,99,99,99,0,0,75,1,10000,900),
(79900,'Test1',1,900,100,7,15,1000,1,32775,3,99,99,99,99,99,99,99,0,0,75,1,10000,900),
(79901,'Test1',1,900,100,7,15,1000,1,32775,3,99,99,99,99,99,99,99,0,0,75,1,10000,900),
(79902,'Test1',1,900,100,7,15,1000,1,32775,3,99,99,99,99,99,99,99,0,0,75,1,10000,900);


-------------delete from cq_grade where id >= 1071900 and id <= 1071902;
-------------delete from cq_grade where id >= 1079900 and id <= 1079902;

insert into cq_grade (id,life_a,life_b,life_c,life_grow_a,life_grow_b,life_grow_c,phy_min_a,phy_min_b,phy_min_c,phy_min_grow_a,phy_min_grow_b,phy_min_grow_c,phy_max_a,phy_max_b,phy_max_c,phy_max_grow_a,phy_max_grow_b,phy_max_grow_c,phy_def_a,phy_def_b,phy_def_c,phy_def_grow_a,phy_def_grow_b,phy_def_grow_c,mgc_min_a,mgc_min_b,mgc_min_c,mgc_min_grow_a,mgc_min_grow_b,mgc_min_grow_c,mgc_max_a,mgc_max_b,mgc_max_c,mgc_max_grow_a,mgc_max_grow_b,mgc_max_grow_c,mgc_def_a,mgc_def_b,mgc_def_c,mgc_def_grow_a,mgc_def_grow_b,mgc_def_grow_c,luck_a,luck_b,luck_c,dmg_type,rarity,reborn_limit) 
values 
(1071900,20,290,1,2500,6250,53,16,95,21,10000,22000,347,24,99,13,15000,33000,102,9,99,22,14000,27500,683,0,0,0,0,0,0,0,0,0,0,0,0,11,56,37,5000,12500,177,50,130,200,0,280,9999),
(1071901,20,290,1,2500,6250,53,16,95,21,10000,22000,347,24,99,13,15000,33000,102,9,99,22,14000,27500,683,0,0,0,0,0,0,0,0,0,0,0,0,11,56,37,5000,12500,177,50,130,200,0,280,9999),
(1071902,20,290,1,2500,6250,53,16,95,21,10000,22000,347,24,99,13,15000,33000,102,9,99,22,14000,27500,683,0,0,0,0,0,0,0,0,0,0,0,0,11,56,37,5000,12500,177,50,130,200,0,280,9999),
(1079900,20,290,1,2500,6250,53,16,95,21,10000,22000,347,24,99,13,15000,33000,102,9,99,22,14000,27500,683,0,0,0,0,0,0,0,0,0,0,0,0,11,56,37,5000,12500,177,50,130,200,0,280,9999),
(1079901,20,290,1,2500,6250,53,16,95,21,10000,22000,347,24,99,13,15000,33000,102,9,99,22,14000,27500,683,0,0,0,0,0,0,0,0,0,0,0,0,11,56,37,5000,12500,177,50,130,200,0,280,9999),
(1079902,20,290,1,2500,6250,53,16,95,21,10000,22000,347,24,99,13,15000,33000,102,9,99,22,14000,27500,683,0,0,0,0,0,0,0,0,0,0,0,0,11,56,37,5000,12500,177,50,130,200,0,280,9999);