Language Items & Mob

[Haikenz]

I am having a question, I would like to know if it is possible to export only the desired column, and how to import it into my table

Example: I want to use the translated texts from this column of the Items RE from "brAthena" to "rAthena"

Link SQL brAthena: https://github.com/brAthena/brAthena/blob/master/sql/renovacao/renovacao.sql

PS: Likewise for the mobs

[Emistry]

UPDATE `rAthena`.`item_db_re` t1 INNER JOIN `brAthena`.`item_db_re` t2 ON `t1`.`id` = `t2`.`id` SET `t1`.`name` = `t2`.`name_japanese`;

 

[Psychonaut]

UPDATE `rAthena.YourTable t1` inner join `brAthena.YourTable t2` on `t1`.`id` = `t2`.`id` set `t1`.`name`= `t2`.`name_japanese`;

 

Try this SQL command, with backups first.

Change YourTable in both to the table name, and that `name` is the name column in rAthena table, so change it if your column have another name.

For the mobs change the table again and change name_japanese(both) to the column name.

Edited November 7, 2017 by Psychonaut

[Haikenz]

53 minutes ago, Psychonaut said:

UPDATE `rAthena.YourTable t1` inner join `brAthena.YourTable t2` on `t1`.`id` = `t2`.`id` set `t1`.`name`= `t2`.`name_japanese`;

 

Try this SQL command, with backups first.

Change YourTable in both to the table name, and that `name` is the name column in rAthena table, so change it if your column have another name.

For the mobs change the table again and change name_japanese(both) to the column name.

# 1046 - No database was selected

[Psychonaut]

Try to click on "ragnarok" database, and execute the sql in that db.

 

[Haikenz]

3 hours ago, Psychonaut said:

Try to click on "ragnarok" database, and execute the sql in that db.

 

does not exist

[Ehwaz]

use item_db_re instead ragnarok.item_db_re

[Haikenz]

4 hours ago, Dometh said:

use item_db_re instead ragnarok.item_db_re

does not exist

[Ehwaz]

Do you see it say ragnarok.test.item_db_re not exist ?

[Haikenz]

2 hours ago, Dometh said:

Do you see it say ragnarok.test.item_db_re not exist ?

This I know ¬¬". the problem is this SQL command

[Emistry]

@Dream Catcher

Perhaps you should check which table store the item_db_re info of yours?

You didnt provide any info of which or whatever was the name of your item_db_re named.

@Psychonaut has provided a solution, but you havent able to test it out since you keep doing it the wrong way.

You didnt replace to the correct sql table based on your own database setting

 

Check your database settings and adjust the table name correctly.

 

[Haikenz]

@Emistry 

[Haikenz]

1 hour ago, Emistry said:

UPDATE `rAthena`.`item_db_re` t1 INNER JOIN `brAthena`.`item_db_re` t2 ON `t1`.`id` = `t2`.`id` SET `t1`.`name` = `t2`.`name_japanese`;

 

Thank You! work!