public GuildMember(Guild Guild, MySqlDataReader reader) { this.Guild = Guild; CharacterID = reader.GetInt32(1); Rank = (GuildRank)reader.GetByte(2); Corp = (ushort)reader.GetInt16(3); }
public static Vehicle Spawn(MySqlDataReader r) { string numberPlate = "TEST"; byte alpha = 255; bool engine = r.GetBoolean("engine"); int c = r.GetInt32("c"); int s = r.GetInt32("s"); Vehicle veh = NAPI.Vehicle.CreateVehicle( r.GetUInt32("hash"), new Vector3(r.GetFloat("p_x"), r.GetFloat("p_y"), r.GetFloat("p_z")), r.GetFloat("r"), c, s, numberPlate, alpha, r.GetBoolean("locked"), engine, r.GetUInt32("dim") ); if (c == 0 && s == 0) { veh.CustomPrimaryColor = new Color(r.GetByte("c_r"), r.GetByte("c_g"), r.GetByte("c_b")); veh.CustomSecondaryColor = new Color(r.GetByte("s_r"), r.GetByte("s_g"), r.GetByte("s_b")); } veh.SetData("id", r.GetInt32("id")); veh.SetData("hp", r.GetFloat("hp")); veh.SetData("owner", r.GetInt32("character_id")); veh.SetData("multi", r.GetInt32("multi")); veh.SetData("km", r.GetFloat("km")); veh.SetData("fuel", r.GetFloat("fuel")); veh.SetData("fuelTank", r.GetFloat("fuel_tank")); veh.SetData("fuelConsumption", r.GetFloat("fuel_consumption")); veh.SetData("engine", engine); veh.SetData("lastUsed", r.GetDateTime("last_used")); veh.SetData("lastDriver", -1); return(veh); }
public override byte GetByte(int ordinal) { if (types[ordinal].ClrEquivalentType != reader.GetFieldType(ordinal)) { return((byte)GetValue(ordinal)); } return(reader.GetByte(ordinal)); }
public Car(MySqlDataReader reader) { // `Id`, `model`, `number`, `color`, `type` ID = reader.GetUInt32(0); Model = reader.GetString(1); Number = reader.GetString(2); Type = (TaxiType)reader.GetByte(3); }
private bool ReadCharacter(MySqlDataReader reader, out PlayerCharacterData result) { if (reader.Read()) { result = new PlayerCharacterData(); result.Id = reader.GetString(0); result.DataId = reader.GetInt32(1); result.EntityId = reader.GetInt32(2); result.FactionId = reader.GetInt32(3); result.CharacterName = reader.GetString(4); result.Level = reader.GetInt16(5); result.Exp = reader.GetInt32(6); result.CurrentHp = reader.GetInt32(7); result.CurrentMp = reader.GetInt32(8); result.CurrentStamina = reader.GetInt32(9); result.CurrentFood = reader.GetInt32(10); result.CurrentWater = reader.GetInt32(11); result.EquipWeaponSet = reader.GetByte(12); result.StatPoint = reader.GetInt16(13); result.SkillPoint = reader.GetInt16(14); result.Gold = reader.GetInt32(15); result.PartyId = reader.GetInt32(16); result.GuildId = reader.GetInt32(17); result.GuildRole = reader.GetByte(18); result.SharedGuildExp = reader.GetInt32(19); result.CurrentMapName = reader.GetString(20); result.CurrentPosition = new Vector3( reader.GetFloat(21), reader.GetFloat(22), reader.GetFloat(23)); result.CurrentRotation = new Vector3( reader.GetFloat(24), reader.GetFloat(25), reader.GetFloat(26)); result.RespawnMapName = reader.GetString(27); result.RespawnPosition = new Vector3( reader.GetFloat(28), reader.GetFloat(29), reader.GetFloat(30)); result.MountDataId = reader.GetInt32(31); result.LastUpdate = (int)(reader.GetDateTime(32).Ticks / System.TimeSpan.TicksPerMillisecond); return(true); } result = null; return(false); }
public override void Load() { DatabaseQuery query = new DatabaseQuery(Database.Tables.WORKING_DAYS); query.Add(Database.Tables.WorkingDays.StaffId); query.Add(Database.Tables.WorkingDays.Sunday); query.Add(Database.Tables.WorkingDays.Monday); query.Add(Database.Tables.WorkingDays.Tuesday); query.Add(Database.Tables.WorkingDays.Wednesday); query.Add(Database.Tables.WorkingDays.Thursday); query.Add(Database.Tables.WorkingDays.Friday); query.Add(Database.Tables.WorkingDays.Saturday); MySqlDataReader reader = DoLoad(query); if (Loaded) { Owner = StaffsManager.GetMedicalStaff(reader.GetInt32(0)); Sunday = reader.GetByte(1) > 0 ? true : false; Monday = reader.GetByte(2) > 0 ? true : false; Tuesday = reader.GetByte(3) > 0 ? true : false; Wednesday = reader.GetByte(4) > 0 ? true : false; Thursday = reader.GetByte(5) > 0 ? true : false; Friday = reader.GetByte(6) > 0 ? true : false; Saturday = reader.GetByte(7) > 0 ? true : false; StaffsManager.Add(this); } reader.Close(); }
public bool Load() { try { MySqlCommand cmd = new MySqlCommand("SELECT id, code, uses, dinarreward FROM coupons", Databases.Game.connection); MySqlDataReader Reader = cmd.ExecuteReader(); if (Reader.HasRows) { while (Reader.Read()) { byte _index = Reader.GetByte("id"); string _code = Reader.GetString("code"); byte _uses = Reader.GetByte("uses"); uint _dinarReward = Reader.GetUInt32("dinarreward"); Objects.Coupon Coupon = new Objects.Coupon(_index, _code, _uses, _dinarReward); UpdateCouponList(Coupon); } } Reader.Close(); if (CouponList.Count > 0) { byte _activeCoupons = 0; foreach (var Coupon in CouponList) { if (Coupon.Uses > 0) { _activeCoupons++; } } Log.Instance.WriteLine("Coupon manager found " + _activeCoupons.ToString() + " useable coupons"); } else { Log.Instance.WriteError("Coupon list is empty"); } return(true); } catch { } return(false); }
/// <summary> /// Read a byte value in the specified field. Field index starts with 0. /// </summary> /// <param name="i"></param> /// <returns></returns> public byte GetByte(int i) { lastUpdate = MySQL.MSTime; if (r.FieldCount > i && !r.IsDBNull(i)) { return(r.GetByte(i)); } return(0); }
/// <Sql> /// SELECT /// * /// FROM /// list_maildata /// WHERE /// Sender=?Sender /// AND /// IsOutbox=1; /// </Sql> public IEnumerable <Mail> GetOutboxMail(Character target) { MySqlConnection connection = ConnectionPool.Request(); MySqlCommand command = new MySqlCommand(_query_37, connection); command.Parameters.AddWithValue("Sender", target.Name); MySqlDataReader reader = null; try { reader = command.ExecuteReader(); while (reader.Read()) { // 0 - MailId // 1 - Sender // 2 - Receiptent // 3 - Date // 4 - IsRead // 5 - IsChecked // 6 - Topic // 7 - Message // 8 - Attachment // 9 - Zeny Mail mailsubject = new Mail(); mailsubject.MailId = reader.GetUInt32(0); mailsubject.Sender = reader.GetString(1); mailsubject.Time = reader.GetDateTime(3); mailsubject.IsRead = reader.GetByte(4); mailsubject.Topic = reader.GetString(6); mailsubject.Message = reader.GetString(7); mailsubject.Zeny = (int)reader.GetUInt32(9); if (reader.IsDBNull(8) == false) { byte[] buffer = new byte[67]; reader.GetBytes(8, 0, buffer, 0, 67); Rag2Item.Deserialize(out mailsubject.Attachment, buffer, 0); } if (mailsubject.IsRead == 0) { mailsubject.Valid = (byte)(30 - Math.Min(30, (int)((DateTime.Now - mailsubject.Time).TotalDays))); } yield return(mailsubject); } } finally { if (reader != null) { reader.Close(); } ConnectionPool.Release(connection); } }
/// <summary> /// get list with preview result data /// </summary> /// <returns>IEnumerable</returns> public IEnumerable <ResultView> GetResultView() { _resultView = new ObservableCollection <ResultView>(); ResultViews.Clear(); try { _connection.Open(); MySqlCommand command = _connection.CreateCommand(); command.CommandText = "SELECT * FROM result_table;"; EncodingProvider ppp = CodePagesEncodingProvider.Instance; Encoding.RegisterProvider(ppp); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { ResultView tt = new ResultView { Price = reader.GetDecimal("Price"), Duration = reader.GetInt32("Duration"), OperateCarrierNumber = reader.GetInt32("OC_Number"), ValidateCarrierNumber = reader.GetInt16("VC_Number"), ValidateCarrierName = reader.GetString("ValidateCarrier"), RoundtripTime = reader.GetDateTime("ReturnTime"), RoundtripDate = reader.GetDateTime("ReturnDate"), Roundtrip = reader.GetByte("RT"), ArrivalPoint = reader.GetString("Arrival"), DeparturePoint = reader.GetString("Departure"), DepartureTime = reader.GetDateTime("DepartureTime"), DepartureDate = reader.GetDateTime("DepartureDate").Date }; try { tt.OperateCarrierName = reader.GetString("OperateCarrier"); } catch (Exception) { tt.OperateCarrierName = "n/a"; } if (_templates._resultView.Contains(tt)) { continue; } _templates._resultView.Add(tt); } } _connection.Close(); } catch (MySqlException e) { _connection.Close(); Debug.Assert(true, e.Message); } _connection.Close(); return(_templates.ResultViews); }
public static void Initialize() { if (a) { Global.Channels.Clear(); } using (MySqlDataReader r = Database.RunQuery("SELECT * FROM channels;")) { while (r.Read()) { Channel c = new Channel(r.GetString("name"), r.GetString("topic")); c.Write = r.GetByte("public_write") == 1; c.Read = r.GetByte("public_read") == 1; Global.Channels.Add(c.Name, c); } } a = true; }
public static bool SelectAllNPCs(out Dictionary <int, DB_NPC> data) { var locked = false; data = new Dictionary <int, DB_NPC>(); if (!IsConnected) { return(false); } try { using (MySqlCommand _cmd = _connection.CreateCommand()) { _cmd.CommandText = $"SELECT a.*, b.item, c.* FROM {tb_05} a LEFT JOIN {tb_05_02} b ON a.id = b.id LEFT JOIN {tb_05_01} c ON a.id = c.id;"; Monitor.Enter(s_lock, ref locked); using (MySqlDataReader _result = _cmd.ExecuteReader()) { DB_NPC entry; int id; if (_result.HasRows) { while (_result.Read()) { id = _result.GetInt32(0); if (data.ContainsKey(id)) { data[id].Items.Add(_result.GetInt32(24)); } else { entry = new DB_NPC(id, _result.GetByte(1), _result.GetInt16(2), _result.GetUInt16(3), _result.GetByte(4), _result.GetUInt16(5), _result.GetPonyOld(6)); if ((entry.Flags & NPCFlags.Trader) > 0) { entry.Items.Add(_result.GetInt32(24)); } if ((entry.Flags & NPCFlags.Wears) > 0) { for (int i = 26; i <= 33; i++) { entry.Wears.Add(_result.GetInt32(i)); } } data[id] = entry; } } } } } return(true); } catch { return(false); } finally { if (locked) { Monitor.Exit(s_lock); } } }
private void InternalBytesAndBooleans(bool prepare) { execSQL("DROP TABLE IF EXISTS Test"); execSQL("CREATE TABLE Test (id TINYINT, idu TINYINT UNSIGNED, i INT UNSIGNED)"); execSQL("INSERT INTO Test VALUES (-98, 140, 20)"); execSQL("INSERT INTO Test VALUES (0, 0, 0)"); MySqlCommand cmd = new MySqlCommand("SELECT * FROM Test", conn); if (prepare) { cmd.Prepare(); } MySqlDataReader reader = null; try { reader = cmd.ExecuteReader(); Assert.IsTrue(reader.Read()); Assert.AreEqual(-98, (sbyte)reader.GetByte(0)); Assert.AreEqual(140, reader.GetByte(1)); Assert.IsTrue(reader.GetBoolean(1)); Assert.AreEqual(20, reader.GetUInt32(2)); Assert.AreEqual(20, reader.GetInt32(2)); Assert.IsTrue(reader.Read()); Assert.AreEqual(0, reader.GetByte(0)); Assert.AreEqual(0, reader.GetByte(1)); Assert.IsFalse(reader.GetBoolean(1)); Assert.IsFalse(reader.Read()); } catch (Exception ex) { Assert.Fail(ex.Message); } finally { if (reader != null) { reader.Close(); } } }
private bool LoadGuilds() { try { if (conn.State == ConnectionState.Closed) { return(false); } MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = "select * from u_guild;"; MySqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { reader.Close(); return(false); } while (reader.Read()) { GameData.XGuild Temp = new GameData.XGuild(); Temp.GuildIdx = reader.GetUInt16(0); Temp.Name = reader.GetString(1); Temp.Info = reader.GetString(2); Temp.Cert = reader.GetString(3); Temp.EstablishDate = reader.GetDateTime(4); Temp.LimitCount = reader.GetUInt16(5); Temp.Status = reader.GetByte(6); Temp.MarkRegDate = reader.GetDateTime(7); Temp.MarkRegCnt = reader.GetByte(8); Temp.gold = reader.GetUInt32(10); Temp.HiringIdx = reader.GetUInt16(11); Temp.CertDate = reader.GetDateTime(12); Temp.InfoDate = reader.GetDateTime(13); Init.game.gamedata.guild.Add(Temp); } reader.Close(); return(true); } catch { return(false); } }
//从数据库载入军团配置 public void DB_Load() { LegionInfo info = null; String sql = string.Format("select * from cq_legion"); MySqlCommand command = new MySqlCommand(sql, MysqlConn.GetConn()); MysqlConn.Conn_Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (!reader.HasRows) { break; } info = new LegionInfo(); info.id = reader.GetUInt32("id"); info.name = reader.GetString("name"); info.name = Coding.Latin1ToGB2312(info.name); info.title = reader.GetByte("member_title"); info.leader_id = reader.GetInt32("leader_id"); info.leader_name = reader.GetString("leader_name"); info.leader_name = Coding.Latin1ToGB2312(info.leader_name); info.money = reader.GetInt64("money"); info.notice = reader.GetString("notice"); info.notice = Coding.Latin1ToGB2312(info.notice); mDicInfo[info.id] = info; } MysqlConn.Conn_Close(); command.Dispose(); //载入行会成员信息 foreach (LegionInfo obj in mDicInfo.Values) { sql = string.Format("select * from cq_legion_members where legion_id={0}", obj.id); command = new MySqlCommand(sql, MysqlConn.GetConn()); MysqlConn.Conn_Open(); reader = command.ExecuteReader(); while (reader.Read()) { if (!reader.HasRows) { break; } LegionMember member = new LegionMember(); member.rank = reader.GetInt16("rank"); member.members_name = reader.GetString("members_name"); member.members_name = Coding.Latin1ToGB2312(member.members_name); member.money = reader.GetInt64("money"); obj.list_member.Add(member); } MysqlConn.Conn_Close(); command.Dispose(); } }
// Data Gathering Section // Grabs the stored data for the Container. internal object[] GetContainerData(CSteamID steamID, string containerName) { object[] tmp = null; MySqlDataReader reader = null; try { if (!Initialized) { Logger.LogError("Error: Cant load player info from DB, plugin hasn't initialized properly."); return(tmp); } MySqlCommand command = Connection.CreateCommand(); command.Parameters.AddWithValue("@steamid", steamID); command.Parameters.AddWithValue("@cname", containerName); command.CommandText = "SELECT * FROM `" + TableData + "` WHERE SteamID = @steamid AND ContainerName = @cname"; reader = command.ExecuteReader(); if (reader.Read()) { tmp = new object[] { reader.GetUInt16("AssetID"), reader.GetValue(reader.GetOrdinal("ContainerData")) as byte[], reader.GetString("ContainerName"), reader.GetByte("ItemCount"), reader.GetByte("ContainerVersion"), }; } } catch (MySqlException ex) { HandleException(ex); } finally { if (reader != null) { reader.Close(); reader.Dispose(); } } return(tmp); }
public static PonyData GetPony(this MySqlDataReader reader, int i) { var ret = new PonyData(); ret.Race = reader.GetByte(i); ret.Gender = reader.GetByte(++i); ret.Name = reader.GetString(++i); if (reader.IsDBNull(++i)) { return(ret); } using (var mem = new MemoryStream()) { var data = (byte[])reader.GetValue(i); mem.Write(data, 0, data.Length); mem.Position = 0; using (var zip = new DeflateStream(mem, CompressionMode.Decompress)) return(ProtoBuf.Serializer.Merge(zip, ret)); } }
public static bool SelectAllSpells(out Dictionary <int, DB_Spell> data) { var locked = false; data = new Dictionary <int, DB_Spell>(); if (!IsConnected) { return(false); } try { using (MySqlCommand _cmd = _connection.CreateCommand()) { _cmd.CommandText = $"SELECT * FROM {tb_11};"; Monitor.Enter(_connection, ref locked); using (MySqlDataReader _result = _cmd.ExecuteReader()) { int id; byte index; DB_Spell spell; if (_result.HasRows) { while (_result.Read()) { id = _result.GetInt32(0); index = _result.GetByte(1); if (!data.TryGetValue(id, out spell)) { data[id] = spell = new DB_Spell(id); } spell.Effects.Add(index, new DB_SpellEffect(_result.GetByte(2), _result.GetByte(3), _result.GetFloat(4), _result.GetFloat(5), _result.GetFloat(6), _result.GetFloat(7), _result.GetFloat(8), _result.GetFloat(9))); } } } } return(true); } catch { return(false); } finally { if (locked) { Monitor.Exit(_connection); } } }
private ActionItem ReadItem(MySqlDataReader reader) { return(new ActionItem { Id = reader.GetGuid(0), Content = reader.GetString(1), Completed = Convert.ToBoolean(reader.GetByte(2)), CreatedAt = reader.GetDateTime(3) }); }
public static Watch FromReader(MySqlDataReader reader) => new Watch() { WatchId = reader.GetInt32("watchId"), MetricId = reader.GetInt32("metricId"), Name = reader.GetString("name"), Expression = reader.GetString("expression"), Message = reader.GetString("message"), Sent = reader.GetByte("sent") };
public List <Usuario> ListaColaborador() { string sql = "SELECT * FROM Usuario WHERE tipoUsuario=1"; conexao.Open(); MySqlCommand command = new MySqlCommand(sql, conexao); MySqlDataReader reader = command.ExecuteReader(); List <Usuario> listaUsuarios = new List <Usuario>(); while (reader.Read()) { Usuario usuario = new Usuario(); usuario.id = reader.GetInt32("idUsuario"); if (!reader.IsDBNull(reader.GetOrdinal("nome"))) { usuario.nome = reader.GetString("nome"); } if (!reader.IsDBNull(reader.GetOrdinal("nomeUsuario"))) { usuario.nomeUsuario = reader.GetString("nomeUsuario"); } if (!reader.IsDBNull(reader.GetOrdinal("cpf"))) { usuario.cpf = reader.GetString("cpf"); } if (!reader.IsDBNull(reader.GetOrdinal("email"))) { usuario.email = reader.GetString("email"); } if (!reader.IsDBNull(reader.GetOrdinal("telefone"))) { usuario.telefone = reader.GetString("telefone"); } if (!reader.IsDBNull(reader.GetOrdinal("cep"))) { usuario.cep = reader.GetString("cep"); } if (!reader.IsDBNull(reader.GetOrdinal("tipoUsuario"))) { usuario.tipoUsuario = reader.GetByte("tipoUsuario"); } if (!reader.IsDBNull(reader.GetOrdinal("dataCriacao"))) { usuario.criacaoConta = reader.GetDateTime("dataCriacao"); } if (!reader.IsDBNull(reader.GetOrdinal("dataUltimoAcesso"))) { usuario.ultimoAcesso = reader.GetDateTime("dataUltimoAcesso"); } listaUsuarios.Add(usuario); } reader.Close(); conexao.Close(); return(listaUsuarios); }
// 往 dr 填充 r 于 i 索引的值 public static void FillValue(DbRow dr, MySqlDataReader r, int i) { switch (dr.parent.columns[i].dataType) { case DbDataTypes.Boolean: dr[i].Assign(r.GetBoolean(i)); break; case DbDataTypes.Int8: dr[i].Assign(r.GetSByte(i)); break; case DbDataTypes.Int16: dr[i].Assign(r.GetInt16(i)); break; case DbDataTypes.Int32: dr[i].Assign(r.GetInt32(i)); break; case DbDataTypes.Int64: dr[i].Assign(r.GetInt64(i)); break; case DbDataTypes.UInt8: dr[i].Assign(r.GetByte(i)); break; case DbDataTypes.UInt16: dr[i].Assign(r.GetUInt16(i)); break; case DbDataTypes.UInt32: dr[i].Assign(r.GetUInt32(i)); break; case DbDataTypes.UInt64: dr[i].Assign(r.GetUInt64(i)); break; case DbDataTypes.Float: dr[i].Assign(r.GetFloat(i)); break; case DbDataTypes.Double: dr[i].Assign(r.GetDouble(i)); break; case DbDataTypes.DateTime: dr[i].Assign(r.GetDateTime(i)); break; case DbDataTypes.String: dr[i].Assign(r.GetString(i)); break; case DbDataTypes.Bytes: var len = (int)r.GetBytes(i, 0, null, 0, 0); var buf = new byte[len]; r.GetBytes(i, 0, buf, 0, len); dr[i].Assign(buf); break; default: break; } }
public static AccountEntry Read(MySqlDataReader reader) { if (!reader.Read()) { return(null); } return(new AccountEntry { Id = reader.GetUInt32("id"), //Email = reader.GetString("email"), // Not needed by the server currently Username = reader.GetString("username"), Password = reader.GetString("password"), Salt = reader.GetString("salt"), Level = reader.GetByte("level"), LastServerId = reader.GetByte("last_server_id"), Locked = reader.GetBoolean("locked"), Validated = reader.GetBoolean("validated") }); }
private bool LoadNPC() { try { if (conn.State == ConnectionState.Closed) { return(false); } MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = "select * from s_npc;"; MySqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { reader.Close(); return(false); } while (reader.Read()) { SData.Npc Temp = new SData.Npc(); Temp.idx = reader.GetInt16(0); Temp.name = reader.GetString(1); Temp.type = reader.GetByte(2); Temp.birth_zone_idx = reader.GetInt16(3); Temp.birth_zone_x = reader.GetByte(4); Temp.birth_zone_y = reader.GetByte(5); Temp.move_zone_layernum = reader.GetInt16(6); Temp.sell_type = reader.GetByte(7); Temp.sell_ratio = reader.GetByte(8); Temp.barter_item_idx = reader.GetInt16(9); Init.game.sdata.npc.Add(Temp); } reader.Close(); return(true); } catch { return(false); } }
public Account LoadAccount(string name) { Account account = null; MySqlConnection connection = DAO.GetConnection(); try { connection.Open(); string cmdText = "SELECT * FROM account_data WHERE name = ?name"; MySqlCommand mySqlCommand = new MySqlCommand(cmdText, connection); mySqlCommand.Parameters.AddWithValue("?name", name); MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); if (mySqlDataReader.Read()) { int @int = mySqlDataReader.GetInt32("id"); account = new Account(@int, name); account.Password = mySqlDataReader.GetString("password"); account.Activated = mySqlDataReader.GetByte("activated"); account.AccessLevel = mySqlDataReader.GetByte("access_level"); account.MemberShipExp = mySqlDataReader.GetInt64("membership_exp"); account.LastServer = mySqlDataReader.GetByte("last_server"); account.LastIp = mySqlDataReader.GetString("last_ip"); account.Toll = mySqlDataReader.GetInt64("toll"); } mySqlDataReader.Close(); return(account); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; log.Error((object)ex2); Account result = null; ProjectData.ClearProjectError(); return(result); } finally { connection.Close(); } }
// 取 dr 中某字段的数据并返回 public static object GetValue(DbColumn col, MySqlDataReader r, int idx) { switch (col.dataType) { case DbDataTypes.Boolean: return(r.GetBoolean(idx)); case DbDataTypes.Int8: return(r.GetSByte(idx)); case DbDataTypes.Int16: return(r.GetInt16(idx)); case DbDataTypes.Int32: return(r.GetInt32(idx)); case DbDataTypes.Int64: return(r.GetInt64(idx)); case DbDataTypes.UInt8: return(r.GetByte(idx)); case DbDataTypes.UInt16: return(r.GetUInt16(idx)); case DbDataTypes.UInt32: return(r.GetUInt32(idx)); case DbDataTypes.UInt64: return(r.GetUInt64(idx)); case DbDataTypes.Float: return(r.GetFloat(idx)); case DbDataTypes.Double: return(r.GetDouble(idx)); case DbDataTypes.DateTime: return(r.GetDateTime(idx)); case DbDataTypes.String: return(r.GetString(idx)); case DbDataTypes.Bytes: var len = (int)r.GetBytes(idx, 0, null, 0, 0); var buf = new byte[len]; r.GetBytes(idx, 0, buf, 0, len); return(buf); default: throw new Exception("unsupported DbType"); } }
private bool ReadCharacterSkillUsage(MySqlDataReader reader, out CharacterSkillUsage result) { if (reader.Read()) { result = new CharacterSkillUsage(); result.type = (SkillUsageType)reader.GetByte(0); result.dataId = reader.GetInt32(1); result.coolDownRemainsDuration = reader.GetFloat(2); return(true); } result = CharacterSkillUsage.Empty; return(false); }
private bool ReadCharacterHotkey(MySqlDataReader reader, out CharacterHotkey result) { if (reader.Read()) { result = new CharacterHotkey(); result.hotkeyId = reader.GetString(0); result.type = (HotkeyType)reader.GetByte(1); result.relateId = reader.GetString(2); return(true); } result = CharacterHotkey.Empty; return(false); }
private bool LoadMixSkill() { try { if (conn.State == ConnectionState.Closed) { return(false); } MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = "select * from s_mixskill;"; MySqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { reader.Close(); return(false); } while (reader.Read()) { SData.MixSkill Temp = new SData.MixSkill(); Temp.MixSkillLelvel = reader.GetByte(0); Temp.StartHenchLevel = reader.GetInt16(1); Temp.EndHenchLevel = reader.GetInt16(2); Temp.MixSkillBasis = reader.GetInt16(3); Temp.MixSkillStart = reader.GetInt16(4); Temp.MixSkillMaster = reader.GetInt16(5); Temp.MixSkillBonus = reader.GetInt16(6); Temp.MixSkillMaxRate = reader.GetByte(7); Init.game.sdata.mixSkill.Add(Temp); } reader.Close(); return(true); } catch { return(false); } }
private bool LoadSkillData() { try { if (conn.State == ConnectionState.Closed) { return(false); } MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = "select * from s_skilldata;"; MySqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { reader.Close(); return(false); } while (reader.Read()) { SData.SkillData Temp = new SData.SkillData(); Temp.skill_index = reader.GetByte(0); Temp.level = reader.GetByte(1); Temp.consumedMp = reader.GetByte(2); Temp.maxTargetDistance = reader.GetByte(3); Temp.targetRange = reader.GetByte(4); Temp.requireSP = reader.GetInt16(5); Temp.continuityTime = reader.GetInt32(6); Temp.coolTime = reader.GetInt32(7); Init.game.sdata.skillData.Add(Temp); } reader.Close(); return(true); } catch { return(false); } }