Query Help? xD

[Diablo69r]

Hey lol Can anyone show me how to make this Query replace the old Legion Admin.. Check out this wordpad please and if you Know how to make these Translations replace the old ones Please email me at

[cruey]

INSERT INTO `cq_action` VALUES ('40000', '40001', '0000', '0101', '0', 'I~am~RoyKenna,~the~LegionAdmin,~what~can~I~do~for ~you?');
INSERT INTO `cq_action` VALUES ('40001', '40002', '0000', '0102', '0', 'I~am~want~to~make~my~own~Legion! 40004');
INSERT INTO `cq_action` VALUES ('40002', '4600100', '0000', '0102', '0', 'I~must~Dismiss~my~Legion.. 40050');
INSERT INTO `cq_action` VALUES ('40003', '4600100', '0000', '0102', '0', 'What~is~the~EudemonTotem? 40080');
INSERT INTO `cq_action` VALUES ('40030', '40031', '0000', '0101', '0', 'You~cannot~Create~a~Legion~because~either~your~in ~one~already~or~you~dont~meet~the~Requirements!');
INSERT INTO `cq_action` VALUES ('40031', '10045', '0000', '0102', '0', 'Oh 0');
INSERT INTO `cq_action` VALUES ('40020', '40021', '0000', '0101', '0', 'Its~very~good~that~you~want~to~Create~a~Legion!~P lease~tell~me~what~you~want~to~call~it~and~I'll~se e~if~its~available!');
INSERT INTO `cq_action` VALUES ('40021', '10045', '0000', '0103', '0', '15 40022 Legion~Name:');
INSERT INTO `cq_action` VALUES ('40023', '10045', '0000', '0102', '0', 'Oh 0');
INSERT INTO `cq_action` VALUES ('40029', '40031', '0000', '0101', '0', 'You~need~to~be~level~50~and~have~500k~Gold~to~Cre ate~a~Legion!');
INSERT INTO `cq_action` VALUES ('40060', '40061', '0000', '0101', '0', 'Are~you~sure~you~want~to~Dismiss~your~Legion?~It~ will~let~down~those~who~Depend~on~you!');
INSERT INTO `cq_action` VALUES ('40061', '10045', '0000', '0102', '0', 'I~have~Decided!~Dismiss~it~now! 40065');
INSERT INTO `cq_action` VALUES ('3909860', '3909861', '0000', '0101', '0', 'Enjoy~your~Legion!~And~may~you~win~LegionWar~some day!');
INSERT INTO `cq_action` VALUES ('3909861', '10045', '0000', '0102', '0', 'Thanks! 0');
INSERT INTO `cq_action` VALUES ('4600100', '10045', '0000', '0102', '0', 'What~is~the~EudemonTotem? 4600110');
INSERT INTO `cq_action` VALUES ('4600110', '4600111', '0000', '0101', '0', 'Each~Eudemon~Totem~records~the~top~50~Eudemons~in ~a~Legion~Registerd~by~its~members.~And~the');
INSERT INTO `cq_action` VALUES ('4600111', '4600112', '0000', '0101', '0', 'top~8~Totems~and~the~first~five~Eudemons~in~each~ of~the~8~Totems~will~decide~the~legions~total~BP!' );
INSERT INTO `cq_action` VALUES ('4600112', '4600113', '0000', '0101', '0', '');
INSERT INTO `cq_action` VALUES ('4600113', '4600114', '0000', '0101', '0', '');
INSERT INTO `cq_action` VALUES ('4600114', '4600115', '0000', '0101', '0', '');
INSERT INTO `cq_action` VALUES ('4600115', '10045', '0000', '0102', '0', 'Anything~else? 4600120');
INSERT INTO `cq_action` VALUES ('4600120', '4600121', '0000', '0101', '0', 'The~Legion~level~is~determined~by~the~starred~Tot ems,~which~means~the~total~stars~of~the');
INSERT INTO `cq_action` VALUES ('4600121', '4600122', '0000', '0101', '0', 'Eudemons~registerd~in~it~exceed~100.~A~level~2~Le gion~needs~3~starred~Totems,~while~6');
INSERT INTO `cq_action` VALUES ('4600122', '4600123', '0000', '0101', '0', '');
INSERT INTO `cq_action` VALUES ('4600123', '4600124', '0000', '0101', '0', '');
INSERT INTO `cq_action` VALUES ('4600124', '4600125', '0000', '0101', '0', '');
INSERT INTO `cq_action` VALUES ('4600125', '10045', '0000', '0102', '0', 'Is~that~all? 4600130');
INSERT INTO `cq_action` VALUES ('4600130', '4600131', '0000', '0101', '0', 'In~this~way.~A~level~6~Legion~needs~15~starred~To tems,~while~18~for~a~level~7~Legion,~21~for');
INSERT INTO `cq_action` VALUES ('4600131', '4600132', '0000', '0101', '0', 'level~8,~24~for~level~9~and~30~for~level~10!');
INSERT INTO `cq_action` VALUES ('4600132', '4600133', '0000', '0101', '0', '');
INSERT INTO `cq_action` VALUES ('4600133', '4600134', '0000', '0101', '0', '');

I think you just have t change all the INSERTs into UPDATEs, try this:

UPDATE INTO `cq_action` VALUES ('40000', '40001', '0000', '0101', '0', 'I~am~RoyKenna,~the~LegionAdmin,~what~can~I~do~for ~you?');
UPDATE INTO `cq_action` VALUES ('40001', '40002', '0000', '0102', '0', 'I~am~want~to~make~my~own~Legion! 40004');
UPDATE INTO `cq_action` VALUES ('40002', '4600100', '0000', '0102', '0', 'I~must~Dismiss~my~Legion.. 40050');
UPDATE INTO `cq_action` VALUES ('40003', '4600100', '0000', '0102', '0', 'What~is~the~EudemonTotem? 40080');
UPDATE INTO `cq_action` VALUES ('40030', '40031', '0000', '0101', '0', 'You~cannot~Create~a~Legion~because~either~your~in ~one~already~or~you~dont~meet~the~Requirements!');
UPDATE INTO `cq_action` VALUES ('40031', '10045', '0000', '0102', '0', 'Oh 0');
UPDATE INTO `cq_action` VALUES ('40020', '40021', '0000', '0101', '0', 'Its~very~good~that~you~want~to~Create~a~Legion!~P lease~tell~me~what~you~want~to~call~it~and~I'll~se e~if~its~available!');
UPDATE INTO `cq_action` VALUES ('40021', '10045', '0000', '0103', '0', '15 40022 Legion~Name:');
UPDATE INTO `cq_action` VALUES ('40023', '10045', '0000', '0102', '0', 'Oh 0');
UPDATE INTO `cq_action` VALUES ('40029', '40031', '0000', '0101', '0', 'You~need~to~be~level~50~and~have~500k~Gold~to~Cre ate~a~Legion!');
UPDATE INTO `cq_action` VALUES ('40060', '40061', '0000', '0101', '0', 'Are~you~sure~you~want~to~Dismiss~your~Legion?~It~ will~let~down~those~who~Depend~on~you!');
UPDATE INTO `cq_action` VALUES ('40061', '10045', '0000', '0102', '0', 'I~have~Decided!~Dismiss~it~now! 40065');
UPDATE INTO `cq_action` VALUES ('3909860', '3909861', '0000', '0101', '0', 'Enjoy~your~Legion!~And~may~you~win~LegionWar~some day!');
UPDATE INTO `cq_action` VALUES ('3909861', '10045', '0000', '0102', '0', 'Thanks! 0');
UPDATE INTO `cq_action` VALUES ('4600100', '10045', '0000', '0102', '0', 'What~is~the~EudemonTotem? 4600110');
UPDATE INTO `cq_action` VALUES ('4600110', '4600111', '0000', '0101', '0', 'Each~Eudemon~Totem~records~the~top~50~Eudemons~in ~a~Legion~Registerd~by~its~members.~And~the');
UPDATE INTO `cq_action` VALUES ('4600111', '4600112', '0000', '0101', '0', 'top~8~Totems~and~the~first~five~Eudemons~in~each~ of~the~8~Totems~will~decide~the~legions~total~BP!' );
UPDATE INTO `cq_action` VALUES ('4600112', '4600113', '0000', '0101', '0', '');
UPDATE INTO `cq_action` VALUES ('4600113', '4600114', '0000', '0101', '0', '');
UPDATE INTO `cq_action` VALUES ('4600114', '4600115', '0000', '0101', '0', '');
UPDATE INTO `cq_action` VALUES ('4600115', '10045', '0000', '0102', '0', 'Anything~else? 4600120');
UPDATE INTO `cq_action` VALUES ('4600120', '4600121', '0000', '0101', '0', 'The~Legion~level~is~determined~by~the~starred~Tot ems,~which~means~the~total~stars~of~the');
UPDATE INTO `cq_action` VALUES ('4600121', '4600122', '0000', '0101', '0', 'Eudemons~registerd~in~it~exceed~100.~A~level~2~Le gion~needs~3~starred~Totems,~while~6');
UPDATE INTO `cq_action` VALUES ('4600122', '4600123', '0000', '0101', '0', '');
UPDATE INTO `cq_action` VALUES ('4600123', '4600124', '0000', '0101', '0', '');
UPDATE INTO `cq_action` VALUES ('4600124', '4600125', '0000', '0101', '0', '');
UPDATE INTO `cq_action` VALUES ('4600125', '10045', '0000', '0102', '0', 'Is~that~all? 4600130');
UPDATE INTO `cq_action` VALUES ('4600130', '4600131', '0000', '0101', '0', 'In~this~way.~A~level~6~Legion~needs~15~starred~To tems,~while~18~for~a~level~7~Legion,~21~for');
UPDATE INTO `cq_action` VALUES ('4600131', '4600132', '0000', '0101', '0', 'level~8,~24~for~level~9~and~30~for~level~10!');
UPDATE INTO `cq_action` VALUES ('4600132', '4600133', '0000', '0101', '0', '');
UPDATE INTO `cq_action` VALUES ('4600133', '4600134', '0000', '0101', '0', '');

[Diablo69r]

Na, It doesnt delete the old ones.. :S

[Necron33]

Sql Query example should look like this :

if just want to update the stuff then:
UPDATE`cq_action`SET`param`='I~am~RoyKenna,~the~LegionAdmin,~what~can~I~do~for ~you?' WHERE (`id`='40000');

if you want to delete the old ones then add new ones then:
delete from cq_action where id=40000;
INSERT INTO `cq_action` VALUES ('40000', '40001', '0000', '0101', '0', 'I~am~RoyKenna,~the~LegionAdmin,~what~can~I~do~for ~you?');

.