Query Help? xD

01/14/2009 22:20 Diablo69r#1
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 [Only registered and activated users can see links. Click Here To Register...]
01/15/2009 09:39 cruey#2
Quote:
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:
Quote:
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', '');
01/23/2009 16:16 Diablo69r#3
Na, It doesnt delete the old ones.. :S
01/24/2009 01:22 Necron33#4
Sql Query example should look like this :
Code:
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');
Code:
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?');
.