Pets born without Loyalty

[Kirsten.Jr]

What wrong below? This pet is being born without loyalty

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
(811613, 'TEST',28,5000000,0,0,0,0,0,0,0,0,0,0,1083500,0,0, 100000),
(1082330,'TEST',4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
(1072330,'TEST',0,250,0,0,0,0,0,0,32,0,1,9000,7202 0,2,1,0),
(1072331,'TEST',0,250,0,0,0,0,0,0,32,0,1,9000,7202 1,2,1,0),
(1072332,'TEST',0,250,0,0,0,0,0,0,32,0,1,9000,7202 2,2,1,0),
(1076330,'TEST',0,250,0,0,0,0,0,0,32,0,1,9000,7602 0,2,1,0),
(1076331,'TEST',0,250,0,0,0,0,0,0,32,0,1,9000,7602 1,2,1,0),
(1076332,'TEST',0,250,0,0,0,0,0,0,32,0,1,9000,7602 2,2,1,0);



INSERT INTO CQ_EUDEMON_RBN_TYPE (ID,PHY_ATK,PHY_DEF)
VALUES
(1072330,1,1),
(1072331,1,1),
(1072332,1,1),
(1076330,1,1),
(1076331,1,1),
(1076332,1,1);



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
(1072330,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,1000,9999),
(1072331,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,1000,9999),
(1072332,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,1000,9999),
(1076330,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,1000,9999),
(1076331,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,1000,9999),
(1076332,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,1000,9999);




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
(72330,'TEST',1,635,100,7,15,1000,1,32775,3,99,99, 99,99,99,99,99,0,0,75,1,10000,900),
(72331,'TEST',1,636,100,7,15,1000,1,32775,3,99,99, 99,99,99,99,99,0,0,75,1,10000,900),
(72332,'TEST',1,637,100,7,15,1000,1,32775,3,99,99, 99,99,99,99,99,0,0,75,1,10000,900),
(76330,'TEST',1,635,100,7,15,1000,1,32775,3,99,99, 99,99,99,99,99,0,0,75,1,10000,900),
(76331,'TEST',1,636,100,7,15,1000,1,32775,3,99,99, 99,99,99,99,99,0,0,75,1,10000,900),
(76332,'TEST',1,637,100,7,15,1000,1,32775,3,99,99, 99,99,99,99,99,0,0,75,1,10000,900);

[georgeion92]

That is coz the ids of the pet are not the good ones,look at the sql and find which ids are wrong.

[pretzel666]

Compare your ID's , with a TQ made pets ID , only change the last couple digits for your Pets ID , or , check cq_grade , see if theres a 0 in loyalty

[georgeion92]

I already know which part of sql is wrong but i just want him/her to find it out so he/she can understand something!