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);
}
