public int getIdByUsername(string _username) { this.clearCmd(); cmd.CommandText = "Select id from client where username='******';"; reader = cmd.ExecuteReader(); reader.Read(); return reader.GetInt16(0); }
protected void Button3_Click(object sender, EventArgs e) { con = new SQLiteConnection("Data Source=e:\\db\\project.s3db"); con.Open(); SQLiteCommand command= new SQLiteCommand("Select * from train where trainno="+trainno_list.SelectedValue,con); reader=command.ExecuteReader(); String str; if(reader.Read()) if (Int32.Parse(TextBox1.Text) <= reader.GetInt16(3)) { str = "tickets.aspx?trainno=" + trainno_list.SelectedValue + "&type=" + type.SelectedValue + "&ticketno=" + TextBox1.Text; con.Close(); Response.Redirect(str); } else err.InnerText = TextBox1.Text+" Tickets not avaliable. Please check and enter again"; con.Close(); }
public int getLoggedUserCount() { this.clearCmd(); cmd.CommandText = "select count(id) from client where isLogged=1;"; reader = cmd.ExecuteReader(); reader.Read(); return reader.GetInt16(0); }
public string[] getLatestMsgLog() { this.clearCmd(); List<string> msgLogList=new List<string>(); int AllowedMsgAmount = (int)ServerConfigManager.MyConfigs["MaxPullMsgLogAmount"]; cmd.CommandText = "Select * from msgLog ORDER BY sendTimestamp ASC LIMIT "+AllowedMsgAmount.ToString()+";"; reader = cmd.ExecuteReader(); while (reader.Read()) { msgLogList.Add( System.Uri.EscapeDataString(this.getUsernameById(reader.GetInt16(1)))+","+System.Uri.EscapeDataString(Convert.ToString(reader.GetDateTime(3)))+","+System.Uri.EscapeDataString(reader.GetString(2))); } return msgLogList.ToArray(); }
public ServerCommand Login(string _username,string _password) { this.clearCmd(); cmd.CommandText = "select count(id) as myCount,id from client where username='******';"; SQLiteDataReader reader = cmd.ExecuteReader(); reader.Read(); //User existiert nicht if (reader.GetInt16(0) == 0) { if ((bool)ServerConfigManager.MyConfigs["isServerPrivate"]) return ServerCommand.ServerIsPrivate; reader.Close(); cmd.CommandText = "insert into client values(null,'" + _username + "','" + _password + "',0,CURRENT_DATE,1,'abwesend');"; cmd.ExecuteNonQuery(); Console.WriteLine("add new User: "******"Username vorhanden"); cmd.CommandText = "select count(id) as myCount,id from client where password='******';"; reader = cmd.ExecuteReader(); reader.Read(); //Passwort ist richtig if (reader.GetInt16(0) != 0) { Console.WriteLine("Richtiges PW"); this.setUserLogged(_username); return ServerCommand.isLogged; } else { return ServerCommand.WrongPwd; Console.WriteLine("Falsches PW"); } } return 0; }
private RelationMember ReadRelationMember(SQLiteDataReader reader) { var relation_member = new RelationMember(); relation_member.MemberType = SchemaTools.ConvertMemberType(reader.GetInt16(0)); relation_member.MemberId = reader.GetInt64(1); relation_member.MemberRole = reader.GetString(2); return relation_member; }
private Tuple<long, RelationMember> ReadRelationIdAndMember(SQLiteDataReader reader) { var relation_member = new RelationMember(); relation_member.MemberType = SchemaTools.ConvertMemberType(reader.GetInt16(1)); relation_member.MemberId = reader.GetInt64(2); relation_member.MemberRole = reader.GetString(3); return new Tuple<long, RelationMember>(reader.GetInt64(0), relation_member); }
private static void ReadPlayerInfo(SQLiteDataReader reader, Player player) { player.Id = (uint)reader.GetInt32(0); player.Name = reader.GetString(1); player.Gender = (Gender)reader.GetByte(2); player.Vocation = (Vocation)reader.GetByte(3); player.Level = (ushort)reader.GetInt16(4); player.MagicLevel = reader.GetByte(5); player.Experience = (uint)reader.GetInt32(6); player.MaxHealth = (ushort)reader.GetInt16(7); player.MaxMana = (ushort)reader.GetInt16(8); player.Capacity = (uint)reader.GetInt32(9); player.Outfit.LookType = (ushort)reader.GetInt16(10); player.Outfit.Head = reader.GetByte(11); player.Outfit.Body = reader.GetByte(12); player.Outfit.Legs = reader.GetByte(13); player.Outfit.Feet = reader.GetByte(14); player.Outfit.Addons = reader.GetByte(15); if (reader.GetInt64(20) > 0) { int x = reader.GetInt32(16); int y = reader.GetInt32(17); int z = reader.GetInt32(18); player.SavedLocation = new Location(x, y, z); player.Direction = (Direction)reader.GetByte(19); player.LastLogin = new DateTime(reader.GetInt64(20)); } player.Speed = (ushort)(220 + (2 * (player.Level - 1))); }
public static void Read(this Beatmap beatmap, SQLiteDataReader reader) { int i = 1; beatmap.TitleRoman = reader.GetString(i); i++; beatmap.ArtistRoman = reader.GetString(i); i++; beatmap.TitleUnicode = reader.GetString(i); i++; beatmap.ArtistUnicode = reader.GetString(i); i++; beatmap.Creator = reader.GetString(i); i++; beatmap.DiffName = reader.GetString(i); i++; beatmap.Mp3Name = reader.GetString(i); i++; beatmap.Md5 = reader.GetString(i); i++; beatmap.OsuFileName = reader.GetString(i); i++; beatmap.MaxBpm = reader.GetDouble(i); i++; beatmap.MinBpm = reader.GetDouble(i); i++; beatmap.Tags = reader.GetString(i); i++; beatmap.State = reader.GetByte(i); i++; beatmap.Circles = (short)reader.GetInt32(i); i++; beatmap.Sliders = (short)reader.GetInt32(i); i++; beatmap.Spinners = (short)reader.GetInt32(i); i++; beatmap.EditDate = reader.GetDateTime(i); i++; beatmap.ApproachRate = (float)reader.GetDouble(i); i++; beatmap.CircleSize = (float)reader.GetDouble(i); i++; beatmap.HpDrainRate = (float)reader.GetDouble(i); i++; beatmap.OverallDifficulty = (float)reader.GetDouble(i); i++; beatmap.SliderVelocity = reader.GetDouble(i); i++; beatmap.DrainingTime = reader.GetInt32(i); i++; beatmap.TotalTime = reader.GetInt32(i); i++; beatmap.PreviewTime = reader.GetInt32(i); i++; beatmap.MapId = reader.GetInt32(i); i++; beatmap.MapSetId = reader.GetInt32(i); i++; beatmap.ThreadId = reader.GetInt32(i); i++; beatmap.MapRating = reader.GetInt32(i); i++; beatmap.Offset = (short)reader.GetInt32(i); i++; beatmap.StackLeniency = (float)reader.GetDouble(i); i++; beatmap.Mode = reader.GetByte(i); i++; beatmap.Source = reader.GetString(i); i++; beatmap.AudioOffset = (short)reader.GetInt32(i); i++; beatmap.LetterBox = reader.GetString(i); i++; beatmap.Played = reader.GetBoolean(i); i++; beatmap.LastPlayed = reader.GetDateTime(i); i++; beatmap.IsOsz2 = reader.GetBoolean(i); i++; beatmap.Dir = reader.GetString(i); i++; beatmap.LastSync = reader.GetDateTime(i); i++; beatmap.DisableHitsounds = reader.GetBoolean(i); i++; beatmap.DisableSkin = reader.GetBoolean(i); i++; beatmap.DisableSb = reader.GetBoolean(i); i++; beatmap.BgDim = reader.GetInt16(i); i++; beatmap.Somestuff = reader.GetInt16(i); i++; beatmap.VideoDir = reader.GetString(i); }