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)
then you can use my other 2 apps to translate the needed cq_map and cq_npc, or you can just do the same as above