NSLバージョンの OpenSim Currencyサーバについて

2010-09-09 14:03:13,664 INFO  - OpenSim.Data.MySQL.MySQLMoneyDataWrapper.MySQLMoneyManager [MYSQL]: Connection established
2010-09-09 14:03:13,741 INFO  - OpenSim.Framework.Servers.BaseOpenSimServer [STARTUP]: Startup took 0m 0s
2010-09-09 14:03:36,850 INFO  - OpenSim.Grid.MoneyServer.MoneyXmlRpcModule [Money] User: 3fc93602-b2d3-4c46-80ac-36fff2523e8c@202.26.159.196 has logged in,getting balance...
2010-09-09 14:03:36,853 INFO  - OpenSim.Grid.MoneyServer.MoneyDBService [MYSQL] Found user "Test User",now update information
2010-09-09 14:03:37,023 INFO  - OpenSim.Grid.MoneyServer.MoneyXmlRpcModule [Money] Getting balance for user: 3fc93602-b2d3-4c46-80ac-36fff2523e8c@202.26.159.196

# /usr/local/mysql/bin/mysql -u root -p    or  mysql -u root -p
Enter Passwaord
mysql> use "db name of OpenSim";
mysql> select * from balances;

        public bool addUserInfo(UserInfo userInfo)
        {
            bool bRet = false;
            string sql = string.Empty;

            if (userInfo.Avatar==null) return false;

            sql += "INSERT INTO userinfo(`user`,`simip`,`avatar`,`pass`) VALUES";
            sql += "(?user,?simip,?avatar,?password);";

            MySqlCommand cmd = new MySqlCommand(sql, dbcon);
            cmd.Parameters.AddWithValue("?user", userInfo.UserID);
            cmd.Parameters.AddWithValue("?simip", userInfo.SimIP);
            cmd.Parameters.AddWithValue("?avatar", userInfo.Avatar);
            cmd.Parameters.AddWithValue("?password", userInfo.PswHash);

            try
            {
                if (cmd.ExecuteNonQuery() > 0) bRet = true;
                cmd.Dispose();
            }
            catch (Exception e)
            {
                m_log.Error("Unable to add user information to database: " + e.ToString());
                bRet = false;
            }

            return bRet;
        }