public void INFORETRIEVE() { string username = NewSocket.split[2]; string password = NewSocket.split[3]; using (DatabaseClient dbClient = Program.Manager.GetClient()) { dbClient.AddParamWithValue("username", username); dbClient.AddParamWithValue("password", password); try { string checkdata = dbClient.ReadString("SELECT * FROM users WHERE username = @username AND password = @password"); if (checkdata != null) { DataRow dbRow = dbClient.ReadDataRow("SELECT * FROM users WHERE username = @username;"); Username = (String)dbRow["username"]; ServerMessage fuseMessage = new ServerMessage(); fuseMessage.Init("USEROBJECT"); fuseMessage.AppendString("name=" + (String)dbRow["username"]); fuseMessage.AppendString("figure=" + (String)dbRow["figure"]); fuseMessage.AppendString("birthday=" + (String)dbRow["dob"]); fuseMessage.AppendString("phonenumber="); fuseMessage.AppendString("customData=" + (String)dbRow["motto"]); fuseMessage.AppendString("had_read_agreement=1"); fuseMessage.AppendString("sex=" + (String)dbRow["gender"]); fuseMessage.AppendString("country=nl"); fuseMessage.AppendString("has_special_rights=0"); fuseMessage.AppendString("badge_type=1"); NewSocket.SendData(clientStream, fuseMessage); } else { } } catch { } } }
internal void Send(NetworkStream clientStream) { NewSocket.SendData(clientStream, this); }
public void SEARCHBUSYFLATS() { NewSocket.SendData(clientStream, "BUSY_FLAT_RESULTS 1" + (char)13 + "1/Test/JoshZ/0//0.0/127.0.0.1/127.0.0.1/30000/0/null/ForMeOnly"); }