Register for your free account! | Forgot your password?

You last visited: Today at 16:47

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



look at my sql plz

Discussion on look at my sql plz within the EO PServer Hosting forum part of the Eudemons Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Dec 2012
Posts: 18
Received Thanks: 0
look at my sql plz

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);
Senglade is offline  
Old 01/09/2013, 19:26   #2
 
elite*gold: 0
Join Date: Jul 2011
Posts: 226
Received Thanks: 55
What version did you use
Soul[PM] is offline  
Old 01/10/2013, 00:34   #3
 
elite*gold: 0
Join Date: Dec 2012
Posts: 18
Received Thanks: 0
version

wolvs pet maker v2 curently trying to learn to write my own
Senglade is offline  
Old 01/10/2013, 09:28   #4
 
elite*gold: 0
Join Date: May 2010
Posts: 101
Received Thanks: 17
Is much better if you can understand and build a query your own,i had many issues with that sql maker!
georgeion92 is offline  
Thanks
1 User
Old 01/10/2013, 19:42   #5
 
elite*gold: 0
Join Date: Dec 2012
Posts: 18
Received Thanks: 0
currently working on understanding sql's haveing trouble with CQ-Action can't figure out what id's to use an placement of pet id;s within the cq_Action protion any tips be much welcome
Senglade is offline  
Reply




All times are GMT +1. The time now is 16:48.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.