since no one wants to comment on my cq problem maybe you can point out whats wrong in my sql ty i know the inimatk isn't there its a petmaker sql
DELETE FROM CQ_ACTION WHERE ID >= 815153 AND ID <= 1076400;
INSERT INTO CQ_ACTION (ID,ID_NEXT,ID_NEXTFAIL,TYPE,DATA,PARAM)
VALUES
(815153,1082400,1072401,508,0,'1 0 52'),
(1082400,1072400,0,502,815153,''),
(1072400,1072401,0,501,1082400,''),
(1072401,1072402,0,1085,0,'GMLOG/ACTION_LOG 380,%USER_NAME[%USER_ID],0,0,1082400,0,0,815153,0,0'),
(1072402,0,0,126,0,'PLEASE~MAKE~ONE~SPACE~IN~YOUR~ EUDEMON~BAG~FREE!'),
(1076400,0,0,126,0,'CONGRATULATIONS!~YOU~HAVE~OBTA INED~A~OCTOPUSPRINCESS~EGG!');
DELETE FROM CQ_ITEMTYPE WHERE ID = 815153;
DELETE FROM CQ_ITEMTYPE WHERE ID = 1082400;
DELETE FROM CQ_ITEMTYPE WHERE ID >= 1072400 AND ID <= 1072402;
DELETE FROM CQ_ITEMTYPE WHERE ID >= 1076400 AND ID <= 1076402;
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
(815153, 'OCTOPUSPRINCESS',28,0,815153,0,0,0,0,0,0,0,0,0,10 82400,0,0,380),
(1082400,'OCTOPUSPRINCESS',4,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0),
(1072400,'OCTOPUSPRINCESS',0,250,0,0,0,0,0,0,32,0, 1,9000,72400,2,1,0),
(1072401,'OCTOPUSPRINCESS',0,250,0,0,0,0,0,0,32,0, 1,9000,72401,2,1,0),
(1072402,'OCTOPUSPRINCESS',0,250,0,0,0,0,0,0,32,0, 1,9000,72402,2,1,0),
(1076400,'OCTOPUSPRINCESS',0,250,0,0,0,0,0,0,32,0, 1,9000,76400,2,1,0),
(1076401,'OCTOPUSPRINCESS',0,250,0,0,0,0,0,0,32,0, 1,9000,76401,2,1,0),
(1076402,'OCTOPUSPRINCESS',0,250,0,0,0,0,0,0,32,0, 1,9000,76402,2,1,0);
DELETE FROM CQ_EUDEMON_RBN_TYPE WHERE ID >= 1072400 AND ID <= 1072402;
DELETE FROM CQ_EUDEMON_RBN_TYPE WHERE ID >= 1076400 AND ID <= 1076402;
INSERT INTO CQ_EUDEMON_RBN_TYPE (ID,LIFE,PHY_ATK,PHY_DEF,MGC_ATK,MGC_DEF)
VALUES
(1072400,0,1,1,0,0),
(1072401,0,1,1,0,0),
(1072402,0,1,1,0,0),
(1076400,0,1,1,0,0),
(1076401,0,1,1,0,0),
(1076402,0,1,1,0,0);
DELETE FROM CQ_GRADE WHERE ID >= 1072400 AND ID <= 1072402;
DELETE FROM CQ_GRADE WHERE ID >= 1076400 AND ID <= 1076402;
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
(1072400,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),
(1072401,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),
(1072402,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),
(1076400,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),
(1076401,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),
(1076402,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 >= 72400 AND ID <= 72402;
DELETE FROM CQ_MONSTERTYPE WHERE ID >= 76400 AND ID <= 76402;
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
(72400,'OCTOPUSPRINCESS',1,677,100,7,15,1000,1,327 75,3,99,99,99,99,99,99,99,0,0,75,1,10000, 677),
(72401,'OCTOPUSPRINCESS',1,677,100,7,15,1000,1,327 75,3,99,99,99,99,99,99,99,0,0,75,1,10000, 677),
(72402,'OCTOPUSPRINCESS',1,677,100,7,15,1000,1,327 75,3,99,99,99,99,99,99,99,0,0,75,1,10000, 677),
(76400,'OCTOPUSPRINCESS',1,677,100,7,15,1000,1,327 75,3,99,99,99,99,99,99,99,0,0,75,1,10000, 677),
(76401,'OCTOPUSPRINCESS',1,677,100,7,15,1000,1,327 75,3,99,99,99,99,99,99,99,0,0,75,1,10000, 677),
(76402,'OCTOPUSPRINCESS',1,677,100,7,15,1000,1,327 75,3,99,99,99,99,99,99,99,0,0,75,1,10000, 677);
DELETE FROM CQ_GOODS WHERE ITEMTYPE = 815153;
INSERT INTO CQ_GOODS (ID,OWNERID,ITEMTYPE)
VALUES
(815153,1207,815153);
 |
