public void HandleRequest(HttpListenerContext context)
{
NameValueCollection query;
using (StreamReader rdr = new StreamReader(context.Request.InputStream))
{
query = HttpUtility.ParseQueryString(rdr.ReadToEnd());
}
int offset = int.Parse(query["offset"]);
using (Database dbx = new Database())
{
var cmd = dbx.CreateQuery();
cmd.CommandText = "SELECT * FROM info ORDER BY date DESC LIMIT 1 OFFSET @off;";
cmd.Parameters.AddWithValue("@off", offset);
using (var rdr = cmd.ExecuteReader())
{
rdr.Read();
var page = new PageItem()
{
};
page.Name = rdr.GetString("name");
List<string> contents = new List<string>();
if (rdr.GetInt32("newsType") == 0)
{
foreach (var i in rdr.GetString("contents").Split('&'))
{
contents.Add(i);
}
page.ContentType = 0;
page.ContentLines = contents.ToArray();
}
else
{
foreach (var i in rdr.GetString("contents").Split('&'))
contents.Add(i);
page.ContentType = rdr.GetInt32("newsType");
page.ContentLines = contents.ToArray();
}
DateTime time = rdr.GetDateTime("date");
page.Date = time.ToString("g");
if (!rdr.IsDBNull(rdr.GetOrdinal("link")) && rdr.GetString("link") != "")
{
page.Link = rdr.GetString("link");
}
byte[] fff = Encoding.ASCII.GetBytes(page.ToString());
context.Response.OutputStream.Write(fff, 0, fff.Length);
context.Response.Close();
}
dbx.Dispose();
}
}
public override void HandleRequest(HttpListenerContext context)
{
NameValueCollection query;
using (var rdr = new StreamReader(context.Request.InputStream))
query = HttpUtility.ParseQueryString(rdr.ReadToEnd());
if (query.AllKeys.Length == 0)
{
string queryString = string.Empty;
string currUrl = context.Request.RawUrl;
int iqs = currUrl.IndexOf('?');
if (iqs >= 0)
{
query =
HttpUtility.ParseQueryString((iqs < currUrl.Length - 1)
? currUrl.Substring(iqs + 1)
: String.Empty);
}
}
using (var db = new Database(Program.Settings.GetValue("conn")))
{
Account acc = db.GetAccount(int.Parse(query["accountId"]));
Char chr = db.LoadCharacter(acc, int.Parse(query["charId"]));
MySqlCommand cmd = db.CreateQuery();
cmd.CommandText = @"SELECT time, killer, firstBorn FROM death WHERE [email protected] AND [email protected];";
cmd.Parameters.AddWithValue("@accId", query["accountId"]);
cmd.Parameters.AddWithValue("@charId", query["charId"]);
int time;
string killer;
bool firstBorn;
using (MySqlDataReader rdr = cmd.ExecuteReader())
{
rdr.Read();
time = Database.DateTimeToUnixTimestamp(rdr.GetDateTime("time"));
killer = rdr.GetString("killer");
firstBorn = rdr.GetBoolean("firstBorn");
}
using (var wtr = new StreamWriter(context.Response.OutputStream))
wtr.Write(chr.FameStats.Serialize(Program.GameData, acc, chr, time, killer, firstBorn));
}
}
public void HandleRequest(HttpListenerContext context)
{
NameValueCollection query;
using (StreamReader rdr = new StreamReader(context.Request.InputStream))
query = HttpUtility.ParseQueryString(rdr.ReadToEnd());
using (var db = new Database())
{
var acc = db.GetAccount(int.Parse(query["accountId"]));
var chr = db.LoadCharacter(acc, int.Parse(query["charId"]));
var cmd = db.CreateQuery();
cmd.CommandText = @"SELECT time, killer, firstBorn FROM death WHERE [email protected] AND [email protected];";
cmd.Parameters.AddWithValue("@accId", query["accountId"]);
cmd.Parameters.AddWithValue("@charId", query["charId"]);
int time;
string killer;
bool firstBorn;
using (var rdr = cmd.ExecuteReader())
{
rdr.Read();
time = Database.DateTimeToUnixTimestamp(rdr.GetDateTime("time"));
killer = rdr.GetString("killer");
firstBorn = rdr.GetBoolean("firstBorn");
}
using (StreamWriter wtr = new StreamWriter(context.Response.OutputStream))
wtr.Write(chr.FameStats.Serialize(acc, chr, time, killer, firstBorn));
}
}
