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

[MdaizatZ]

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

 Spoiler

Gamabunta In Composing Situation

 Spoiler

IcyDino Can't Seen

 Spoiler

Please Help Me

[dark2141]

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:

My Guides:

[MdaizatZ]

Originally Posted by dark2141

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:

My Guides:

Not Work

[dark2141]

Originally Posted by MdaizatZ

Not Work

Well, Send me your query and i will check what is wrong !

[MdaizatZ]

Ok2 ... , Wait2 ... ,

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);

[dark2141]

Originally Posted by MdaizatZ

Ok2 ... , Wait2 ... ,

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

[MdaizatZ]

Ouh ... , I'm Sorry2 ... , Thanks For The Help Dark2141