[Help]Can any one tell me what the problem here

08/07/2011 11:21 wolfvb#1

hi all i have problem here can any one tell me why it make this
it tack item and don't gave me any thing
can any one say what is the problem here in this sql
or what the fix

PHP Code:

delete from cq_action where id >= 990000000 and id <= 990000042; INSERT INTO `cq_action` VALUES ('990000000', '990000001', '0000', '0101', '0', 'Hi~%user_name,~Im~your~event~items~exchanger.~You~can~choose~your~reward~below.'); INSERT INTO `cq_action` VALUES ('990000001', '990000002', '0000', '0101', '0', 'You~need~event~items~each~to~claim~your~reward.'); INSERT INTO `cq_action` VALUES ('990000002', '990000003', '0000', '0102', '0', 'Exchange~800~JinCrysta~to~4SummonStone. 990000009'); INSERT INTO `cq_action` VALUES ('990000003', '990000004', '0000', '0102', '0', 'Exchange~190~SunCrysta~to~VampClaw. 990000015'); INSERT INTO `cq_action` VALUES ('990000004', '990000005', '0000', '0102', '0', 'Exchange~170~SunCrysta~to~2,000,000~Eps. 990000019'); INSERT INTO `cq_action` VALUES ('990000005', '990000006', '0000', '0102', '0', 'Exchange~200~SunCrysta~to~4,000,000~Eps. 990000022'); INSERT INTO `cq_action` VALUES ('990000006', '990000007', '0000', '0102', '0', 'Exchange~400~SunCrysta~to~8,000,000~Eps. 990000025'); INSERT INTO `cq_action` VALUES ('990000007', '990000008', '0000', '0102', '0', 'Exchange~100~IceCrysta~to~1,000,000~Pps. 990000028'); INSERT INTO `cq_action` VALUES ('990000008', '4000026', '0000', '0102', '0', 'No~Thanks!. 0'); INSERT INTO `cq_action` VALUES ('990000009', '990000010', '990000014', '0502', '1037200', '800'); INSERT INTO `cq_action` VALUES ('990000010', '990000012', '990000011', '0508', '0', '1 0 50'); INSERT INTO `cq_action` VALUES ('990000011', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!'); INSERT INTO `cq_action` VALUES ('990000012', '990000013', '0000', '0501', '724025'); INSERT INTO `cq_action` VALUES ('990000013', '0000', '0000', '0126', '0', 'Congratulations!~You~received~4SummonStone'); INSERT INTO `cq_action` VALUES ('990000014', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items'); INSERT INTO `cq_action` VALUES ('990000015', '990000016', '990000014', '0502', '1037210', '190'); INSERT INTO `cq_action` VALUES ('990000016', '990000017', '990000011', '0508', '0', '1 0 50'); INSERT INTO `cq_action` VALUES ('990000017', '990000018', '0000', '0501', '450064'); INSERT INTO `cq_action` VALUES ('990000018', '0000', '0000', '0126', '0', 'Congratulations!~You~received~VampClaw~work~with~all~class'); INSERT INTO `cq_action` VALUES ('990000019', '990000020', '990000014', '0502', '1037210', '170'); INSERT INTO `cq_action` VALUES ('990000020', '990000021', '0000', '1001', '0', 'e_money += 2000000'); INSERT INTO `cq_action` VALUES ('990000021', '0000', '0000', '0126', '0', 'Congratulations!~You~received~2,000,000 Eps!'); INSERT INTO `cq_action` VALUES ('990000022', '990000023', '990000014', '0502', '1037210', '200'); INSERT INTO `cq_action` VALUES ('990000023', '990000024', '0000', '1001', '0', 'e_money += 4000000'); INSERT INTO `cq_action` VALUES ('990000024', '0000', '0000', '0126', '0', 'Congratulations!~You~received~4,000,000 Eps!'); INSERT INTO `cq_action` VALUES ('990000025', '990000026', '990000014', '0502', '1037210', '400'); INSERT INTO `cq_action` VALUES ('990000026', '990000027', '0000', '1001', '0', 'e_money += 8000000'); INSERT INTO `cq_action` VALUES ('990000027', '0000', '0000', '0126', '0', 'Congratulations!~You~received~8,000,000 Eps!'); INSERT INTO `cq_action` VALUES ('990000028', '990000029', '990000014', '0502', '1037220', '100'); INSERT INTO `cq_action` VALUES ('990000029', '990000030', '0000', '1001', '0', 'e_money2 += 1000000'); INSERT INTO `cq_action` VALUES ('990000030', '0000', '0000', '0126', '0', 'Congratulations!~You~received~1,000,000 Pps!'); /* adding task to cq_task */ delete from cq_task where id >= 990000000 and id <= 990000042; INSERT INTO `cq_task` VALUES ('990000000', '990000000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('990000008', '990000008', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('990000009', '990000009', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('990000015', '990000015', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('990000019', '990000019', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('990000022', '990000022', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('990000025', '990000025', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('990000028', '990000028', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('980000000', '980000000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('980000003', '980000003', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('970000000', '970000000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('970000003', '970000003', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');

thanks for who will help me :handsdown::handsdown:

08/07/2011 11:29 Marcus*#2

this guide might help you if you look at the query in it

[Only registered and activated users can see links. Click Here To Register...]

08/07/2011 11:35 wolfvb#3

its event exchanger
and he tack event item and don't gave any thing

Quote:

Originally Posted by Marcus*

this guide might help you if you look at the query in it

[Only registered and activated users can see links. Click Here To Register...]

thanks for attention ,hope any one help me in it

08/07/2011 12:11 alaaemad#4

Ur cq-Action Not right for example :

PHP Code:


			
INSERT INTO `cq_action` VALUES ('990000009', '990000010', '990000014', '0502', '1037200', '800'); 

INSERT INTO `cq_action` VALUES ('990000010', '990000012', '990000011', '0508', '0', '1 0 50'); 
INSERT INTO `cq_action` VALUES ('990000011', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!'); 
INSERT INTO `cq_action` VALUES ('990000012', '990000013', '0000', '0501', '724025'); 
INSERT INTO `cq_action` VALUES ('990000013', '0000', '0000', '0126', '0', 'Congratulations!~You~received~4SummonStone'); 
INSERT INTO `cq_action` VALUES ('990000014', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');

Change to be :

PHP Code:


			
INSERT INTO `cq_action` VALUES ('990000009', '990000012', '990000014', '0502', '1037200', '800');
INSERT INTO `cq_action` VALUES ('990000010', '990000012', '990000011', '0508', '0', '1 0 50');
INSERT INTO `cq_action` VALUES ('990000011', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!');
INSERT INTO `cq_action` VALUES ('990000012', '990000013', '0000', '0501', '724025', '1 1');
INSERT INTO `cq_action` VALUES ('990000013', '0000', '0000', '0126', '0', 'Congratulations!~You~received~4SummonStone');
INSERT INTO `cq_action` VALUES ('990000014', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');

i hope i helped u

08/07/2011 23:36 wolfvb#5

are this right
i do the fix u say

PHP Code:

delete from cq_action where id >= 990000000 and id <= 990000042; INSERT INTO `cq_action` VALUES ('990000000', '990000001', '0000', '0101', '0', 'Hi~%user_name,~Im~your~event~items~exchanger.~You~can~choose~your~reward~below.'); INSERT INTO `cq_action` VALUES ('990000001', '990000002', '0000', '0101', '0', 'You~need~event~items~each~to~claim~your~reward.'); INSERT INTO `cq_action` VALUES ('990000002', '990000003', '0000', '0102', '0', 'Exchange~800~JinCrysta~to~4SummonStone. 990000009'); INSERT INTO `cq_action` VALUES ('990000003', '990000004', '0000', '0102', '0', 'Exchange~190~SunCrysta~to~VampClaw. 990000015'); INSERT INTO `cq_action` VALUES ('990000004', '990000005', '0000', '0102', '0', 'Exchange~170~SunCrysta~to~2,000,000~Eps. 990000019'); INSERT INTO `cq_action` VALUES ('990000005', '990000006', '0000', '0102', '0', 'Exchange~200~SunCrysta~to~4,000,000~Eps. 990000023'); INSERT INTO `cq_action` VALUES ('990000006', '990000007', '0000', '0102', '0', 'Exchange~400~SunCrysta~to~8,000,000~Eps. 990000027'); INSERT INTO `cq_action` VALUES ('990000007', '990000008', '0000', '0102', '0', 'Exchange~100~IceCrysta~to~1,000,000~Pps. 990000030'); INSERT INTO `cq_action` VALUES ('990000008', '4000026', '0000', '0102', '0', 'No~Thanks!. 0'); INSERT INTO `cq_action` VALUES ('990000009', '990000012', '990000014', '0502', '1037200', '800'); INSERT INTO `cq_action` VALUES ('990000010', '990000012', '990000011', '0508', '0', '1 0 50'); INSERT INTO `cq_action` VALUES ('990000011', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!'); INSERT INTO `cq_action` VALUES ('990000012', '990000013', '0000', '0501', '724025', '1 1'); INSERT INTO `cq_action` VALUES ('990000013', '0000', '0000', '0126', '0', 'Congratulations!~You~received~4SummonStone'); INSERT INTO `cq_action` VALUES ('990000014', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items'); INSERT INTO `cq_action` VALUES ('990000015', '990000017', '990000014', '0502', '1037210', '190'); INSERT INTO `cq_action` VALUES ('990000016', '990000017', '990000011', '0508', '0', '1 0 50'); INSERT INTO `cq_action` VALUES ('990000017', '990000018', '0000', '0501', '450064', '1 1'); INSERT INTO `cq_action` VALUES ('990000018', '0000', '0000', '0126', '0', 'Congratulations!~You~received~VampClaw~work~with~all~class'); INSERT INTO `cq_action` VALUES ('990000019', '990000020', '990000014', '0502', '1037210', '170'); INSERT INTO `cq_action` VALUES ('990000020', '990000021', '0000', '1001', '0', 'e_money += 2000000'); INSERT INTO `cq_action` VALUES ('990000021', '0000', '0000', '0126', '0', 'Congratulations!~You~received~2,000,000 Eps!'); INSERT INTO `cq_action` VALUES ('990000022', '990000023', '990000014', '0502', '1037210', '200'); INSERT INTO `cq_action` VALUES ('990000023', '990000024', '0000', '1001', '0', 'e_money += 4000000'); INSERT INTO `cq_action` VALUES ('990000024', '0000', '0000', '0126', '0', 'Congratulations!~You~received~4,000,000 Eps!'); INSERT INTO `cq_action` VALUES ('990000025', '990000026', '990000014', '0502', '1037210', '400'); INSERT INTO `cq_action` VALUES ('990000026', '990000027', '0000', '1001', '0', 'e_money += 8000000'); INSERT INTO `cq_action` VALUES ('990000027', '0000', '0000', '0126', '0', 'Congratulations!~You~received~8,000,000 Eps!'); INSERT INTO `cq_action` VALUES ('990000028', '990000029', '990000014', '0502', '1037220', '100'); INSERT INTO `cq_action` VALUES ('990000029', '990000030', '0000', '1001', '0', 'e_money2 += 1000000'); INSERT INTO `cq_action` VALUES ('990000030', '0000', '0000', '0126', '0', 'Congratulations!~You~received~1,000,000 Pps!');

08/08/2011 01:10 alaaemad#6

PHP Code:


			
delete from cq_action where id >= 990000000 and id <= 990000042; 



INSERT INTO `cq_action` VALUES ('990000000', '990000001', '0000', '0101', '0', 'Hi~%user_name,~Im~your~event~items~exchanger.~You~can~choose~your~reward~below.'); 

INSERT INTO `cq_action` VALUES ('990000001', '990000002', '0000', '0101', '0', 'You~need~event~items~each~to~claim~your~reward.'); 

INSERT INTO `cq_action` VALUES ('990000002', '990000003', '0000', '0102', '0', 'Exchange~800~JinCrysta~to~4SummonStone. 990000009'); 

INSERT INTO `cq_action` VALUES ('990000003', '990000004', '0000', '0102', '0', 'Exchange~190~SunCrysta~to~VampClaw. 990000015'); 

INSERT INTO `cq_action` VALUES ('990000004', '990000005', '0000', '0102', '0', 'Exchange~170~SunCrysta~to~2,000,000~Eps. 990000019'); 

INSERT INTO `cq_action` VALUES ('990000005', '990000006', '0000', '0102', '0', 'Exchange~200~SunCrysta~to~4,000,000~Eps. 990000022'); 

INSERT INTO `cq_action` VALUES ('990000006', '990000007', '0000', '0102', '0', 'Exchange~400~SunCrysta~to~8,000,000~Eps. 990000025'); 

INSERT INTO `cq_action` VALUES ('990000007', '990000008', '0000', '0102', '0', 'Exchange~100~IceCrysta~to~1,000,000~Pps. 990000028'); 

INSERT INTO `cq_action` VALUES ('990000008', '4000026', '0000', '0102', '0', 'No~Thanks!. 0'); 



INSERT INTO `cq_action` VALUES ('990000009', '990000012', '990000014', '0502', '1037200', '800'); 

INSERT INTO `cq_action` VALUES ('990000010', '990000012', '990000011', '0508', '0', '1 0 50'); 

INSERT INTO `cq_action` VALUES ('990000011', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!'); 

INSERT INTO `cq_action` VALUES ('990000012', '990000013', '0000', '0501', '724025', '1 1'); 

INSERT INTO `cq_action` VALUES ('990000013', '0000', '0000', '0126', '0', 'Congratulations!~You~received~4SummonStone'); 

INSERT INTO `cq_action` VALUES ('990000014', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');  





INSERT INTO `cq_action` VALUES ('990000015', '990000017', '990000014', '0502', '1037210', '190'); 

INSERT INTO `cq_action` VALUES ('990000016', '990000017', '990000011', '0508', '0', '1 0 50'); 

INSERT INTO `cq_action` VALUES ('990000017', '990000018', '0000', '0501', '450064', '1 1'); 

INSERT INTO `cq_action` VALUES ('990000018', '0000', '0000', '0126', '0', 'Congratulations!~You~received~VampClaw~work~with~all~class'); 



INSERT INTO `cq_action` VALUES ('990000019', '990000020', '990000014', '0502', '1037210', '170'); 

INSERT INTO `cq_action` VALUES ('990000020', '990000021', '0000', '1001', '0', 'e_money += 2000000'); 

INSERT INTO `cq_action` VALUES ('990000021', '0000', '0000', '0126', '0', 'Congratulations!~You~received~2,000,000 Eps!'); 





INSERT INTO `cq_action` VALUES ('990000022', '990000023', '990000014', '0502', '1037210', '200'); 

INSERT INTO `cq_action` VALUES ('990000023', '990000024', '0000', '1001', '0', 'e_money += 4000000'); 

INSERT INTO `cq_action` VALUES ('990000024', '0000', '0000', '0126', '0', 'Congratulations!~You~received~4,000,000 Eps!'); 





INSERT INTO `cq_action` VALUES ('990000025', '990000026', '990000014', '0502', '1037210', '400'); 

INSERT INTO `cq_action` VALUES ('990000026', '990000027', '0000', '1001', '0', 'e_money += 8000000'); 

INSERT INTO `cq_action` VALUES ('990000027', '0000', '0000', '0126', '0', 'Congratulations!~You~received~8,000,000 Eps!'); 





INSERT INTO `cq_action` VALUES ('990000028', '990000029', '990000014', '0502', '1037220', '100'); 

INSERT INTO `cq_action` VALUES ('990000029', '990000030', '0000', '1001', '0', 'e_money2 += 1000000'); 

INSERT INTO `cq_action` VALUES ('990000030', '0000', '0000', '0126', '0', 'Congratulations!~You~received~1,000,000 Pps!');

Try this