[i need Help] some one who can teach me how to make new cq_action db..

[linja12]

hi everyone..i need help to make new..cq_action db..when i download mannequin svr files..it not fixed yet...who can release a fresh db or cq_action not be change yet.....i also need a translate db..and who can teach me how to add npc into cq_action??i hope this forum can help many person..thanks

[ProSkyZ]

fresh db or cq_action not be change yet

That should mean chinese db that no one touched it??

So take that chinese cq_action file(i hope it will be compatible with your files):

.i also need a translate db

1. Go to navicat
2. Select Your Connection
3. Select your my db
4. Select your cq_npc
5. Select the npc you want to translate and move along its row
6. Copy its task0 column number
7. Open cq_action
8. Search in it for the number you just copied
9. It should find the number you entered next to it will be the id_nextaction of something like this (Sorry but i dont have mysql right now)
10. Copy it and search for it in the cq_action and keep moving like this till you find the begining of the chinese text that appears the same on your client screen when you click on that NPC
11. THE MOST IMPORTANT PART IS HERE:

• When you have text like this (ChineseChineseChinese)
• You should translate it as this English~English~English (The Symbol ~ = Space in the client view mode)
• Also Check and see well if it was like this (ChineseChineseChinese 35332)
• If there was any numbers like this after the text and separated from the text by SPACE NOT ~ then that means that is action id and you should never remove it so to translate it just type in the same text Box (English~English~English 35332)
• So you must keep the Action id followed by the text by a Space so no bugs or sudden death to the NPC happen

who can teach me how to add npc into cq_action??

You may learn from this NPC Script [Pally Gear Selling Npc]

delete from cq_action where id >= 50000200 and id <= 50000219;
delete from cq_npc where id = 1552 ;
delete from cq_task where id = 50000200;
delete from cq_task where id = 50000203;
delete from cq_task where id = 50000205;
INSERT INTO `cq_npc` VALUES ('1552', '0', '0', 'MagePeppy', '0002', '15500', '0', '0', '-1', '1000', '0287', '0468', '50000200', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?T', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000200, 50000201, 0000, 0101, 0, 'My~name~is~MagePeppy.~Would~you~buy~Elite~Paladin ~gear?');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000201, 50000202, 0000, 0102, 0, 'I~would~like~one~Elite~Paladin~gear~for~10k~EPs. 50000203');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000202, 4000033, 0000, 0102, 0, 'Sorry~i~want~to~think~first. 0');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000203, 50000205, 50000204, 0508, 0, '15 0 50');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000204, 0000, 0000, 0126, 0, 'You~do~not~have~one~space~in~your~package!');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000205, 50000206, 50000208, 1001, 0, 'e_money < 10000');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000206, 50000207, 0000, 0101, 0, 'You~do~not~have~enough~EP~to~buy~a~Elite~Paladin~ gear.~Come~back~when~you~do.');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000207, 4000033, 0000, 0102, 0, 'Sorry,~I~go~and~hunt~some. 0');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000209, 50000210, 0000, 1085, 0, 'gmlog/action_log 330,%user_name[%user_id],0,1059,724041,0,0,0,50000200,0');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000210, 50000211, 0000, 1001, 0, 'e_money += -10000');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000211, 50000212, 0000, 0101, 0, 'Thank~You~for~buying~an~Elite~Paladin~gear.~Hope~ to~see~you~again.');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000212, 4000033, 0000, 0102, 0, 'Thanks 0');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000208, 50000214, 0000, 0501, 113003, '');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000214, 50000215, 0000, 0501, 123003, '');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000215, 50000216, 0000, 0501, 133003, '');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000216, 50000217, 0000, 0501, 143003, '');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000217, 50000218, 0000, 0501, 163003, '');
INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000218, 50000209, 0000, 0501, 490003, '');
INSERT INTO `cq_task` VALUES ('50000205', '50000205', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('50000200', '50000200', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('50000203', '50000203', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');

[ProSkyZ]

Originally Posted by xXBlackMasterXx

Post Reported
Reason:

• Off Topic
• Non English Video
• Spamming and Maybe kind of Advertising

[linja12]

this is use full for all user... thanks...you also show how to make own cq_action???

[linja12]

1.you also can teach me..how to delete npc..i dont understand about

delete from cq_action where id >= 50000200 and id <= 50000219;
delete from cq_npc where id = 1552 ;
delete from cq_task where id = 50000200;
delete from cq_task where id = 50000203;
delete from cq_task where id = 50000205;

where can i found id >= 50000200 and id <= 50000219
in cq_action??? sorry im still newby....i hope you can solve this problem.

[Eurion]

Originally Posted by linja12

1.you also can teach me..how to delete npc..i dont understand about

delete from cq_action where id >= 50000200 and id <= 50000219;
delete from cq_npc where id = 1552 ;
delete from cq_task where id = 50000200;
delete from cq_task where id = 50000203;
delete from cq_task where id = 50000205;

where can i found id >= 50000200 and id <= 50000219
in cq_action??? sorry im still newby....i hope you can solve this problem.

Hopefully this helps you some.

The "id >= 50000200 just means that the id in your cq_action is greater then or equal to 50000200.

The i"d <= 50000219" just means that the id in cq_action will be smaller then or equal to 50000219.


So the entire query is looking for your cq_action ids that are Greater then or equal to 50000200 and Lesser then or equal to 50000219.

[linja12]

how about mannequin teleport..and where can i fix it???

[ProSkyZ]

Originally Posted by linja12

this is use full for all user... thanks...you also show how to make own cq_action???

Its impossible to make your complete your own cq_action! you are gonna die before you finish it !! lol

[ProSkyZ]

Originally Posted by linja12

how about mannequin teleport..and where can i fix it???

Mannequin Teleport?? what is that?

[linja12]

i know its to hard to translate cq_action.mannequin teleport at gobidesert,when i click go to market,it go to loterry inn.i dont know how to fix. 1 more,sky do you have software translator??.i want translate and release without bug.

2.you give me candy server file/chinese not translate..i have problem....
sorry no pic. some npc i cant click. can you teach me how to fix??

3.in my pic,the system below,can help to fix npc translate

4.can you give data type.
that i know 125 is for announce.another i dont know...
i hope you can help..thanks for sky that many help me and other person.

[linja12]

the system below give param,type,data.that system can help to fix translate to english in cq_action??

[ProSkyZ]

[COLOR="black"][B]<<<@!1!@>>>

1.I dont recommend any translating program because it must cause bugs
I may use my hand better as its easier and faster but takes more power and energy

Just click on the npc you want to translate in the client
It should appear as chinese
But the action ids appear in the chat menu
Just extend the chat menu as show here in the picture
[img]http://img444.imageshack.us/img444/1319/help1.png[/img]

[img]http://img141.imageshack.us/img141/6301/help2.png[/img]
-----Move to Step 3

2.As i stated before my cq_action maynot be compatible with you so i recommend you use the new db released by Candy

3.Actually translation using Hand isnot easy but i will do my best to teach you

In the Picture below you will find all the action ids for the chinese things said by this butterfly
[img]http://img143.imageshack.us/img143/1933/help3.png[/img]
1st we will take the 1st Action that it talks in it which is 4003876
Go to Navicat --> my ---> cq_action and search for it as show in the picture below
[img]http://i.imagehost.org/0023/Help4.png[/img]

Just edit the selected part which is the chinese text like the picture below in which the You have to use ~ instead of Space
[img]http://i.imagehost.org/0163/Help5.png[/img]

to translate the line after this we will select the id_next and move to it
as shown and highlighted in the image below
[img]http://i.imagehost.org/0970/Help6.png[/img]

then we will do the same way to translate its text we will go to the param and type w/e we want and dont forget you have to replace the Space with ~

then we will reach to id 4003879
Now you have to pay attention
Why should you?? check the id param you will find after the text a number
Never remove this number so how to translate it
see the example in the picture below
[img]http://i.imagehost.org/0063/Help7.png[/img]
You will see that there is a space between the translation and the numbers
As you must keep a space between them and not ~
After you do this just restart your server and translation will apply
Hope you understand me :)

4.
Use this thread
Credits goes 100% to Forcer (owner of Acme eo)
[url]http://www.elitepvpers.com/forum/eo-pserver-hosting/210007-release-cq_action-help-types-params-description-translated-chinese.html[/url]
[/B][/COLOR]

Regards
ProSkyZ

[ProSkyZ]

Images reuploaded sorry for the dead links.

[rexes13]

Well,nobody can teach you anything about the db...you learn all the stuff u can through the time and the experience you get...