Пример #1
0
        private void ProcessArmorLevelStarUpCmd(GameServerClient client, int nID, byte[] cmdParams, int count)
        {
            int ret = 0;
            RoleDataCmdT <RoleArmorData> data = DataHelper.BytesToObject <RoleDataCmdT <RoleArmorData> >(cmdParams, 0, count);

            if (data != null && data.RoleID > 0)
            {
                DBManager  dbMgr      = DBManager.getInstance();
                DBRoleInfo dbRoleInfo = dbMgr.GetDBRoleInfo(ref data.RoleID);
                if (null != dbRoleInfo)
                {
                    if (dbRoleInfo.ArmorData.Armor != data.Value.Armor || dbRoleInfo.ArmorData.Exp != data.Value.Exp)
                    {
                        dbRoleInfo.ArmorData.Armor = data.Value.Armor;
                        dbRoleInfo.ArmorData.Exp   = data.Value.Exp;
                        using (MyDbConnection3 conn = new MyDbConnection3(false))
                        {
                            string cmdText = string.Format("update t_roles set armor={1},armorexp={2} where rid={0}", data.RoleID, data.Value.Armor, data.Value.Exp);
                            ret = conn.ExecuteSql(cmdText, new MySQLParameter[0]);
                        }
                    }
                }
            }
            client.sendCmd(nID, string.Format("{0}", ret));
        }
        private void ProcessArmorLevelStarUpCmd(GameServerClient client, int nID, byte[] cmdParams, int count)
        {
            int ret = 0;
            RoleDataCmdT <JingLingYuanSuJueXingData> data = DataHelper.BytesToObject <RoleDataCmdT <JingLingYuanSuJueXingData> >(cmdParams, 0, count);

            if (data != null && data.RoleID > 0)
            {
                DBManager  dbMgr      = DBManager.getInstance();
                DBRoleInfo dbRoleInfo = dbMgr.GetDBRoleInfo(ref data.RoleID);
                if (null != dbRoleInfo)
                {
                    dbRoleInfo.JingLingYuanSuJueXingData = data.Value;
                    using (MyDbConnection3 conn = new MyDbConnection3(false))
                    {
                        string cmdText = string.Format("insert into t_juexing_jlys(rid,activetype,activeids) values({0},{1},'{2}') on duplicate key update activetype={1},activeids='{2}'", data.RoleID, data.Value.ActiveType, string.Join <int>(",", data.Value.ActiveIDs));
                        ret = conn.ExecuteSql(cmdText, new MySQLParameter[0]);
                    }
                }
            }
            client.sendCmd <int>(nID, ret);
        }