Translating useing Navicat

[joey123321]

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

[sawickas]

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

[dani-filth0]

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

[CynicalLord]

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

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;

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;

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;

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

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)

[connorbacon99]

Originally Posted by CynicalLord

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

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;

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;

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;

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

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

[funhacker]

Originally Posted by connorbacon99

those dont work for all database

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