Translating useing Navicat

07/02/2009 05:18 joey123321#1

ok so i know funhacker posted the query to translate the db cq files on here ive looked forr over a hour and cant seem to find them any1 post it again plz

07/02/2009 05:53 sawickas#2

Go to navica clic on cq_acion dump sql faile save it...done...now open and translaite it.

07/02/2009 14:50 dani-filth0#3

if u wanna translate an NPC , and that is the important , just get on ur PM char , go to the NPC , click on it , take the numbers appear Before Param and search for them incq_action IDs , and translate what it says

07/02/2009 15:49 CynicalLord#4

Umm. Look below, I think these are the ones that you're looking for lol.

Code:

update cq_action,cq_action2 set cq_action.param = cq_action2.param where cq_action.id = cq_action2.id and cq_action.type = cq_action2.type and cq_action.type = 126;

Code:

update cq_action,cq_action2 set cq_action.param = cq_action2.param where cq_action.id = cq_action2.id and cq_action.type = cq_action2.type and cq_action.type = 101;

Code:

update cq_action,cq_action2 set cq_action.param = cq_action2.param where cq_action.id = cq_action2.id and cq_action.type = cq_action2.type and cq_action.type = 102;

Code:

update cq_itemtype,cq_itemtype2 set cq_itemtype.name = cq_itemtype2.name where cq_itemtype.id = cq_itemtype2.id;

Code:

update cq_monstertype,cq_monstertype2 set cq_monstertype.name = cq_monstertype2.name where cq_monstertype.id = cq_monstertype2.id;

that will do most the translation for you

cq_[tablename]2 = english table (already translated one)
cq_[tablename] = chinese table (non-translated type)

07/03/2009 07:50 connorbacon99#5

Quote:

Originally Posted by CynicalLord

Umm. Look below, I think these are the ones that you're looking for lol.

Code:

update cq_action,cq_action2 set cq_action.param = cq_action2.param where cq_action.id = cq_action2.id and cq_action.type = cq_action2.type and cq_action.type = 126;

Code:

update cq_action,cq_action2 set cq_action.param = cq_action2.param where cq_action.id = cq_action2.id and cq_action.type = cq_action2.type and cq_action.type = 101;

Code:

update cq_action,cq_action2 set cq_action.param = cq_action2.param where cq_action.id = cq_action2.id and cq_action.type = cq_action2.type and cq_action.type = 102;

Code:

update cq_itemtype,cq_itemtype2 set cq_itemtype.name = cq_itemtype2.name where cq_itemtype.id = cq_itemtype2.id;

Code:

update cq_monstertype,cq_monstertype2 set cq_monstertype.name = cq_monstertype2.name where cq_monstertype.id = cq_monstertype2.id;

that will do most the translation for you

cq_[tablename]2 = english table (already translated one)
cq_[tablename] = chinese table (non-translated type)

those dont work for all database :rtfm:

07/03/2009 20:14 funhacker#6

Quote:

Originally Posted by connorbacon99

those dont work for all database :rtfm:

the query he stated in his post is exactly like that pretty much so it's correct