[Help] Add mount

Page 1 of 2 1 2
04/16/2010 14:00 KikkenF#1
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.
04/16/2010 14:44 cyberghoser1#2
for the shopping mall you have to add it to cq_goods as owner id 1207 also.
04/16/2010 17:53 gege2900#3
i think he need sql code
i have alot of new pets too
but i need to know how to add sql codes only
04/16/2010 18:24 KikkenF#4
@cyberghoser1

Yeah its on the code i attached. Nothing hapenning from right click, means cq_action, no?
04/16/2010 18:40 cyberghoser1#5
Yess i guess, did you adapt the code correctly and made sure cq-action ids are not already used? check again your code.
04/16/2010 19:01 KikkenF#6
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.
04/16/2010 19:15 cyberghoser1#7
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.
04/16/2010 19:25 KikkenF#8
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.
04/16/2010 19:33 cyberghoser1#9
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.
04/16/2010 20:01 KikkenF#10
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).
04/16/2010 21:53 Knight^Hawk#11
need to add the same number u have in the itemtype.dat in the emoney column to the cq_itemtype emoney column
04/16/2010 23:20 KikkenF#12
Wich is the emoney?


[Only registered and activated users can see links. Click Here To Register...]
04/17/2010 03:48 evilminded1981#13
If i am not mistaken the emoney is the EPcost
04/17/2010 12:27 KikkenF#14
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.
04/18/2010 22:13 KikkenF#15
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.

Code:
-----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);
Page 1 of 2 1 2