Help Me Please ... Pet Problem :( :( :(

06/13/2013 17:45 MdaizatZ#1
Hello ... i already make a query for a pet ... but this is a problem ... i made two query for two pet ... but the problem is one pet doesn't show anything but when
want to compose ... i can see the pet ... and the other one can't see ... here's the image :( :( :(

Gamabunta Can't Seen

Gamabunta In Composing Situation

IcyDino Can't Seen

Please Help Me :( :( :( :handsdown::handsdown::handsdown:
06/14/2013 08:58 dark2141#2
Check lookface cq_monstertype and if all correct on cq_monster
then check Cq_Itemtype > monster_type column, There you have to put cq_monstertype ID ex: 76280 (Without 10)

Press thanks if helped please ! :)
__________________________________________________

My Release:
[Only registered and activated users can see links. Click Here To Register...]
My Guides:
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
06/14/2013 15:16 MdaizatZ#3
Quote:
Originally Posted by dark2141 View Post
Check lookface cq_monstertype and if all correct on cq_monster
then check Cq_Itemtype > monster_type column, There you have to put cq_monstertype ID ex: 76280 (Without 10)

Press thanks if helped please ! :)
__________________________________________________

My Release:
[Only registered and activated users can see links. Click Here To Register...]
My Guides:
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
Not Work :( :( :(
06/15/2013 11:47 dark2141#4
Quote:
Originally Posted by MdaizatZ View Post
Not Work :( :( :(
Well, Send me your query and i will check what is wrong !
06/15/2013 14:20 MdaizatZ#5
Ok2 ... , Wait2 ... ,
Quote:
DELETE FROM CQ_ACTION WHERE ID >= 815180 AND ID <= 76250;

INSERT INTO CQ_ACTION (ID,ID_NEXT,ID_NEXTFAIL,TYPE,DATA,PARAM)
VALUES
(815180,82250,72251,508,0,'1 0 52'),
(82250,72250,0,502,815180,''),
(72250,72251,0,501,1082250,''),
(72251,72252,0,1085,0,'GMLOG/ACTION_LOG 380,%USER_NAME[%USER_ID],0,0,1082250,0,0,815180,0,0'),
(72252,0,0,126,0,'PLEASE~MAKE~ONE~SPACE~IN~YOUR~EU DEMON~BAG~FREE!'),
(76250,0,0,126,0,'CONGRATULATIONS!~YOU~HAVE~OBTAIN ED~A~IcyDino~EGG!');

DELETE FROM CQ_ITEMTYPE WHERE ID = 815180;
DELETE FROM CQ_ITEMTYPE WHERE ID = 1082250;
DELETE FROM CQ_ITEMTYPE WHERE ID >= 1072250 AND ID <= 1072252;
DELETE FROM CQ_ITEMTYPE WHERE ID >= 1076250 AND ID <= 1076252;

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)
VALUES
(815180, 'IcyDino',28,0,815180,0,0,0,0,0,0,0,0,0,1082250,0, 0,10000),
(1082250,'IcyDino',4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ),
(1072250,'IcyDino',0,250,0,0,0,0,0,0,32,0,1,9000,7 2020,7,1,0),
(1072251,'IcyDino',0,250,0,0,0,0,0,0,32,0,1,9000,7 2021,7,1,0),
(1072252,'IcyDino',0,250,0,0,0,0,0,0,32,0,1,9000,7 2022,7,1,0),
(1076250,'IcyDino',0,250,0,0,0,0,0,0,32,0,1,9000,7 6020,7,1,0),
(1076251,'IcyDino',0,250,0,0,0,0,0,0,32,0,1,9000,7 6021,7,1,0),
(1076252,'IcyDino',0,250,0,0,0,0,0,0,32,0,1,9000,7 6022,7,1,0);


DELETE FROM CQ_EUDEMON_RBN_TYPE WHERE ID >= 1072250 AND ID <= 1072252;
DELETE FROM CQ_EUDEMON_RBN_TYPE WHERE ID >= 1076250 AND ID <= 1076252;

INSERT INTO CQ_EUDEMON_RBN_TYPE (ID,LIFE,PHY_ATK,PHY_DEF,MGC_ATK,MGC_DEF)
VALUES
(1072250,0,1,1,0,0),
(1072251,0,1,1,0,0),
(1072252,0,1,1,0,0),
(1076250,0,1,1,0,0),
(1076251,0,1,1,0,0),
(1076252,0,1,1,0,0);


DELETE FROM CQ_GRADE WHERE ID >= 1072250 AND ID <= 1072252;
DELETE FROM CQ_GRADE WHERE ID >= 1076250 AND ID <= 1076252;

INSERT INTO CQ_GRADE (ID,LIFE_A,LIFE_B,LIFE_C,LIFE_GROW_A,LIFE_GROW_B,L IFE_GROW_C,PHY_MIN_A,PHY_MIN_B,PHY_MIN_C,PHY_MIN_G ROW_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_G ROW_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_G ROW_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,RE BORN_LIMIT)
VALUES
(1072250,20,290,1,2500,6250,53,16,95,21,10000,2200 0,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,1 77,50,130,200,0,380,9999),
(1072251,20,290,1,2500,6250,53,16,95,21,10000,2200 0,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,1 77,50,130,200,0,380,9999),
(1072252,20,290,1,2500,6250,53,16,95,21,10000,2200 0,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,1 77,50,130,200,0,380,9999),
(1076250,20,290,1,2500,6250,53,16,95,21,10000,2200 0,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,1 77,50,130,200,0,380,9999),
(1076251,20,290,1,2500,6250,53,16,95,21,10000,2200 0,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,1 77,50,130,200,0,380,9999),
(1076252,20,290,1,2500,6250,53,16,95,21,10000,2200 0,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,1 77,50,130,200,0,380,9999);


DELETE FROM CQ_MONSTERTYPE WHERE ID >= 72250 AND ID <= 72252;
DELETE FROM CQ_MONSTERTYPE WHERE ID >= 76250 AND ID <= 76252;

INSERT INTO CQ_MONSTERTYPE (ID,NAME,TYPE,LOOKFACE,LIFE,ATTACK_RANGE,VIEW_RANG E,ATTACK_SPEED,LEVEL,ATTACK_USER,SIZE_ADD,DROP_ARM ET,DROP_NECKLACE,DROP_ARMOR,DROP_RING,DROP_WEAPON, DROP_SHIELD,DROP_SHOES,MAGIC_TYPE,MAGIC_HITRATE,AT K_HITRATE,AI_TYPE,DEFENCE,PROFESSION)
VALUES
(72250,'IcyDino',1,833000,100,7,15,1000,1,32775,3, 99,99,99,99,99,99,99,0,0,75,1,10000, 833000),
(72251,'IcyDino',1,833001,100,7,15,1000,1,32775,3, 99,99,99,99,99,99,99,0,0,75,1,10000, 833001),
(72252,'IcyDino',1,833002,100,7,15,1000,1,32775,3, 99,99,99,99,99,99,99,0,0,75,1,10000, 833002),
(76250,'IcyDino',1,833000,100,7,15,1000,1,32775,3, 99,99,99,99,99,99,99,0,0,75,1,10000, 833000),
(76251,'IcyDino',1,833001,100,7,15,1000,1,32775,3, 99,99,99,99,99,99,99,0,0,75,1,10000, 833001),
(76252,'IcyDino',1,833002,100,7,15,1000,1,32775,3, 99,99,99,99,99,99,99,0,0,75,1,10000, 833002);


DELETE FROM CQ_GOODS WHERE ITEMTYPE = 815180;

INSERT INTO CQ_GOODS (ID,OWNERID,ITEMTYPE)
VALUES
(815180,1207,815180);
06/15/2013 21:36 dark2141#6
Quote:
Originally Posted by MdaizatZ View Post
Ok2 ... , Wait2 ... ,
Code:
INSERT INTO CQ_MONSTERTYPE (ID,NAME,TYPE,LOOKFACE,LIFE,ATTACK_RANGE,VIEW_RANG E,ATTACK_SPEED,LEVEL,ATTACK_USER,SIZE_ADD,DROP_ARM ET,DROP_NECKLACE,DROP_ARMOR,DROP_RING,DROP_WEAPON, DROP_SHIELD,DROP_SHOES,MAGIC_TYPE,MAGIC_HITRATE,AT K_HITRATE,AI_TYPE,DEFENCE,PROFESSION) 
VALUES
(72250,'IcyDino',1,833000,100,7,15,1000,1,32775,3, 99,99,99,99,99,99,99,0,0,75,1,10000, 833000),
(72251,'IcyDino',1,833001,100,7,15,1000,1,32775,3, 99,99,99,99,99,99,99,0,0,75,1,10000, 833001),
(72252,'IcyDino',1,833002,100,7,15,1000,1,32775,3, 99,99,99,99,99,99,99,0,0,75,1,10000, 833002),
(76250,'IcyDino',1,833000,100,7,15,1000,1,32775,3, 99,99,99,99,99,99,99,0,0,75,1,10000, 833000),
(76251,'IcyDino',1,833001,100,7,15,1000,1,32775,3, 99,99,99,99,99,99,99,0,0,75,1,10000, 833001),
(76252,'IcyDino',1,833002,100,7,15,1000,1,32775,3, 99,99,99,99,99,99,99,0,0,75,1,10000, 833002);
You're Mistaken, (lookface) should be 833 not 833001 (WithOUT 001)

And same for your itemtype, Told you, yu should put cq_monstertype Id to monster_type column in cq_itemtype
06/16/2013 08:27 MdaizatZ#7
Ouh ... , I'm Sorry2 ... , Thanks For The Help Dark2141 ;) ;) ;) :) :) :) :D :D :D