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