public GetUserItemCollectionPointInfo(string UserName, UserItemCollectionInfo info, byte last) { //20 00 00 00 00 04 00 00 00 B9 DC AB D3 01 64 0F 01 00 00 00 00 00 01 00 00 00 08 ns.Write((byte)0x20); ns.Write(0); ns.WriteBIG5Fixed_intSize(UserName); ns.Write(info.noticedLevel); ns.Write(info.point); ns.Write(0); ns.Write(info.rank); ns.Write(last); }
private static bool itemCollection_GetUserInfo(string UserName, short bOtherUser, short reqType, out UserItemCollectionInfo info, out List <int> itemnums) { info = new UserItemCollectionInfo(); itemnums = new List <int>(); using (var con = new MySqlConnection(Conf.Connstr)) { con.Open(); using (var cmd = new MySqlCommand(string.Empty, con)) { cmd.Parameters.Clear(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_itemCollection_GetUserInfo"; cmd.Parameters.Add("nickName", MySqlDbType.VarString).Value = UserName; cmd.Parameters.Add("bOtherUser", MySqlDbType.Int16).Value = bOtherUser; cmd.Parameters.Add("reqType", MySqlDbType.Int16).Value = reqType; using (MySqlDataReader reader = cmd.ExecuteReader()) { if (reqType == 1) { if (reader.HasRows) { reader.Read(); info.point = Convert.ToInt32(reader["point"]); info.rank = Convert.ToInt32(reader["rank"]); info.noticedLevel = Convert.ToByte(reader["noticedLevel"]); return(true); } else { info.point = 0; info.rank = 0; info.noticedLevel = 0; return(true); } } else if (reqType == 2 && reader.HasRows) { while (reader.Read()) { itemnums.Add(Convert.ToInt32(reader["itemNum"])); } return(true); } } } } return(false); }