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