[Guide]Changing the names of the songs from Chinese to English

First, open your MSSQL 2000/MSSQL 2005/MSSQL EXPRESS/MySQL console thingy.
Double-click Databases, then double-click "test2" or whatever you named it, expand tables.

Find "o2jam_music_data", right-click it and select Open table.
You will see lots of Chinese words, nicknames etc.
This is your SERVER MUSIC FILE LIST. NOT CLIENT MUSIC FILE LIST. YOU MUST CHANGE BOTH TO PLAY.

If you're bad in Chinese or you don't know you should change it to what, just download the OJNList Emulator and put it into your music folder and execute it.

Then, use the OJNList Editor(found in the server package) to open the emulated file and change the data in the table(SQL) sorted by ID.

e.g.
In OJNList Editor: ID 100 - Name: Bach Alive
In SQL Serve: ID 100 - Name: 存在-巴赫
Therefore, change 存在-巴赫 into Bach Alive.

moved out the original thread*

I get a ODBC error when tried to edit & save.

"Transaction cannot start when in firehose mode."

Quote:

---

Originally Posted by kennethng

I get a ODBC error when tried to edit & save.

"Transaction cannot start when in firehose mode."

---

Make sure everything is changed correctly , like on server and client music list and emulator stuffs.

Iv got a little problem here. The songs play fine BUT when another player tries to join the room he gets chinese error with the currently selected song name in it.

I used main.exe to make the .dat files and placed them to right places. Then i went to server music_data and changed the name of Bach Alive to english just like adviced above. Still (when Bach Alive is selected) joining players get the same error.
I haven't translated the whole list yet. Only few songs, but they still give the error.

Oh, and im using 2000 version of mssql.

Any advices would be greatly appreciated.

Hmm... Do they use the same OJNList.dat you are using too? More importantly, do they have the song? And did you replace the OJNList.dat in the server files(.../SERVER-COMMERCIAL/...)?