Help for Rpg Database Strategy

Unity Engine
1

I’m working on an MRPG with facebook support , this is my config :

  • Wepplayer version for Facebook Page ( with facebook api support)

  • Standalone version with network function without facebook support ( internal network function based on last Facebook info)

  • Server Php + Mysql for facebook query and database transaction like score,savegame,thropy,inventory.

My problem is that i want to create an updatable structure of quest and a multilinguage support but i don’t find a
good way to store my data.i want to have a local data structure compatible with webplayer and standalone to store
quest + game message text ( in more then one lang ) , with “query like” support .
I try to use for this php+mysql but is not fast enough.

Anyone have an idea ?

Thanks

2

In C#
In your code, at the top, include:

using System.Globalization;

In your class, somewhere include:

  CultureInfo info = CultureInfo.CurrentCulture;

Now to use, simply pull and use the string:

switch (info.NativeName)
        {
            case "English (United States)":
                break;
            default:
                break;
        }

I do not know if this will work for all platforms when deployed though, but simply make a case statement per NativeName type that you have handled to switch your languages in your game.