Jump to content
  • 0

Language Items & Mob


Haikenz

Question


  • Group:  Members
  • Topic Count:  84
  • Topics Per Day:  0.02
  • Content Count:  309
  • Reputation:   82
  • Joined:  11/15/11
  • Last Seen:  

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"

image.png

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

PS: Likewise for the mobs

Link to comment
Share on other sites

12 answers to this question

Recommended Posts

  • 1

  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  

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

 

  • Like 1
Link to comment
Share on other sites

  • 1

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   3
  • Joined:  11/07/17
  • Last Seen:  

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 by Psychonaut
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  84
  • Topics Per Day:  0.02
  • Content Count:  309
  • Reputation:   82
  • Joined:  11/15/11
  • Last Seen:  

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

image.png

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   3
  • Joined:  11/07/17
  • Last Seen:  

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

 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  84
  • Topics Per Day:  0.02
  • Content Count:  309
  • Reputation:   82
  • Joined:  11/15/11
  • Last Seen:  

3 hours ago, Psychonaut said:

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

 

does not exist
image.png
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  50
  • Reputation:   9
  • Joined:  01/09/12
  • Last Seen:  

use item_db_re instead ragnarok.item_db_re

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  84
  • Topics Per Day:  0.02
  • Content Count:  309
  • Reputation:   82
  • Joined:  11/15/11
  • Last Seen:  

4 hours ago, Dometh said:

use item_db_re instead ragnarok.item_db_re

does not exist

image.png

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  50
  • Reputation:   9
  • Joined:  01/09/12
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  84
  • Topics Per Day:  0.02
  • Content Count:  309
  • Reputation:   82
  • Joined:  11/15/11
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  

@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.

 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  84
  • Topics Per Day:  0.02
  • Content Count:  309
  • Reputation:   82
  • Joined:  11/15/11
  • Last Seen:  

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  84
  • Topics Per Day:  0.02
  • Content Count:  309
  • Reputation:   82
  • Joined:  11/15/11
  • Last Seen:  

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!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...