internal static void Create(Player p) { p.prefix = ""; p.color = p.group.Color; p.FirstLogin = DateTime.Now; p.TimesVisited = 1; string now = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); Database.Backend.AddRow(DBTable, "Name, IP, FirstLogin, LastLogin, totalLogin, Title, " + "totalDeaths, Money, totalBlocks, totalKicked, Messages, TimeSpent", p.name, p.ip, now, now, 1, "", 0, 0, 0, 0, 0, (long)p.TotalTime.TotalSeconds); using (DataTable ids = Database.Backend.GetRows(DBTable, "ID", "WHERE Name = @0", p.name)) { if (ids.Rows.Count > 0) { string id = ids.Rows[0]["ID"].ToString(); p.DatabaseID = PlayerData.ParseInt(id); } else { p.DatabaseID = NameConverter.InvalidNameID(p.name); } } }
void UpdatePlayerID(IDataReader reader) { int id; string user = reader.GetString(0); if (!nameCache.TryGetValue(user, out id)) { id = NameConverter.FindIds(user)[0]; nameCache[user] = id; } entry.PlayerID = id; }
void UpdatePlayerID(IDataRecord record) { int id; string user = record.GetString(0); if (!nameCache.TryGetValue(user, out id)) { int[] ids = NameConverter.FindIds(user); if (ids.Length > 0) { nameCache[user] = ids[0]; } else { nameCache[user] = NameConverter.InvalidNameID(user); } } entry.PlayerID = id; }
internal static void Create(Player p) { p.prefix = ""; p.SetColor(p.group.Color); p.FirstLogin = DateTime.Now; p.TimesVisited = 1; string now = DateTime.Now.ToString(Database.DateFormat); Database.AddRow("Players", "Name, IP, FirstLogin, LastLogin, totalLogin, Title, " + "totalDeaths, Money, totalBlocks, totalKicked, Messages, TimeSpent", p.name, p.ip, now, now, 1, "", 0, 0, 0, 0, 0, (long)p.TotalTime.TotalSeconds); object id = Database.ReadRows("Players", "ID", null, ReadID, "WHERE Name=@0", p.name); if (id != null) { p.DatabaseID = (int)id; } else { p.DatabaseID = NameConverter.InvalidNameID(p.name); } }