protected void Page_Load(object sender, EventArgs e)
{
fonksiyonlar fonk = new fonksiyonlar();
baglanti = new MySqlConnection(bag);
baglanti.Open();
Response.Clear();
Response.ContentType = "text/xml";
XmlTextWriter objX = new XmlTextWriter(Response.OutputStream, Encoding.UTF8);
objX.WriteStartDocument();
objX.WriteStartElement("rss");
objX.WriteAttributeString("version", "2.0");
objX.WriteStartElement("channel");
objX.WriteElementString("title", "Oyun De | Ücretsiz Flash Oyun Oyna | En Hit Oyunları Oyna");
objX.WriteElementString("link", "http://www.oyunde.com");
objX.WriteElementString("description", "Oyun De | Ücretsiz Flash Oyun Oyna | En Hit Oyunları Oyna");
MySqlCommand a = new MySqlCommand("select isapi,tanitim,adi,tarih from oyunlar where onay='1' order by id desc limit 20", baglanti);
MySqlDataReader b = a.ExecuteReader();
while (b.Read())
{
objX.WriteStartElement("item");
objX.WriteElementString("title", b["adi"].ToString());
objX.WriteElementString("description", fonk.htmlencode(b["tanitim"].ToString()));
objX.WriteElementString("link", "http://www.oyunde.com/oyun_oyna/" + b["isapi"].ToString());
objX.WriteElementString("pubDate", b["tarih"].ToString());
objX.WriteEndElement();
}
b.Close();
b.Dispose();
baglanti.Close();
baglanti.Dispose();
objX.WriteEndElement();
objX.WriteEndElement();
objX.WriteEndDocument();
objX.Flush();
objX.Close();
Response.End();
}
