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

wolfvb · 08/07/2011, 11:21

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

Marcus* · 08/07/2011, 11:29

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

wolfvb · 08/07/2011, 11:35

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

thanks for attention ,hope any one help me in it

alaaemad · 08/07/2011, 12:11

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

wolfvb · 08/07/2011, 23:36

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

alaaemad · 08/08/2011, 01:10

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