public static void Init() { ConcurrentDictionary <uint, ushort[]> dimensions = new ConcurrentDictionary <uint, ushort[]>(); string[] dimensionData = System.IO.File.ReadAllLines("C:/db/mapdimensions.dat"); foreach (string md in dimensionData) { string[] mdd = md.Split(' '); ushort Width = ushort.Parse(mdd[1]); ushort Height = ushort.Parse(mdd[2]); ushort[] dim = new ushort[2] { Width, Height }; dimensions.TryAdd(uint.Parse(mdd[0]), dim); } Database.Database DB = new Database.Database("C:/db/maps.s3db"); System.Data.DataTable DT = DB.GetDataTable("SELECT `UniqueID`, `Type` FROM `maptypes`"); for (int i = 0; i < DT.Rows.Count; i++) { System.Data.DataRow dr = DT.Rows[i]; Mapping.Map M = new Map(); M.UniqueID = Convert.ToUInt32(dr.ItemArray[0]); M.Type = Convert.ToUInt32(dr.ItemArray[1]); if (!M.LoadDMap()) { ushort[] dims; if (dimensions.TryGetValue(M.Type, out dims)) { M.Width = dims[0]; M.Height = dims[1]; } else { M.Width = 1300; M.Height = 1300; } M.Coords = new byte[M.Height, M.Width]; for (short ix = 0; ix < M.Height; ix++) { for (short iy = 0; iy < M.Width; iy++) { M.Coords[ix, iy] = (byte)Enums.MapPointType.Empty; } } } Kernel.Maps.TryAdd(M.UniqueID, M); } DB.Dispose(); dimensions.Clear(); }
private void loadCategories(bool silent) { editCategoryId.Items.Clear(); Database.Database db = Provider.GetDb(Index); if (db == null) { if (!silent) { MessageBox.Show((Index + 1) + ". kutu için veritabanı ayarları geçersiz.", "Çınar CMS Desktop Editor"); } return; } foreach (DataRow dr in db.GetDataTable("select Id, Title from Content where ClassName='Category' order by Title").Rows) { editCategoryId.Items.Add(new Item(dr)); } }
private void loadAuthors(bool silent) { editAuthor.Items.Clear(); Database.Database db = Provider.GetDb(Index); if (db == null) { if (!silent) { MessageBox.Show((Index + 1) + ". kutu için veritabanı ayarları geçersiz.", "Çınar CMS Desktop Editor"); } return; } foreach (DataRow dr in db.GetDataTable("select Id, Name as Title from Author").Rows) { editAuthor.Items.Add(new Item(dr)); } }
public static void Run() { string arabicStart = @"<font size=""5"" face=""Arabic Typesetting"">"; string turkishStart = @"<font face=""Verdana"" size=""2"">"; Database.Database db = new Database.Database(DatabaseProvider.MySQL, "localhost", "quran", "root", "bk", 30); DataTable dt = db.GetDataTable("select sura, aya from quran_text order by 1,2"); foreach (DataRow dr in dt.Rows) { string url = string.Format("http://www.kuranmeali.com/mobil/m-kelime.asp?sure={0}&ayet={1}", dr["sura"], dr["aya"]); Encoding enc = Encoding.UTF8; string res = url.DownloadPage(ref enc); int index = 0, end = -1, orderNo = 0; while (true) { index = res.IndexOf(arabicStart, index); if (index == -1) break; end = res.IndexOf("</font>", index); var arabic = HttpUtility.HtmlDecode(res.Substring(index + arabicStart.Length, end - index - arabicStart.Length).Replace(" : ","")); index = res.IndexOf(turkishStart, end); end = res.IndexOf("</font>", index); var turkish = HttpUtility.HtmlDecode(res.Substring(index + turkishStart.Length, end - index - turkishStart.Length).Replace("\\","'")); turkish = turkish.Replace("ý", "ı").Replace("ð", "ğ").Replace("þ", "ş").Replace("Ý", "I").Replace("Ð", "Ğ").Replace("Þ", "Ş"); db.ExecuteNonQuery("insert into quran_kelime_meal(sura, aya, orderno, arabic, turkish) values({0}, {1}, {2}, {3}, {4})", dr["sura"], dr["aya"], orderNo, arabic, turkish); orderNo++; } Console.WriteLine("{0}, {1}", dr["sura"], dr["aya"]); } }
public static void Init() { ConcurrentDictionary<uint, ushort[]> dimensions = new ConcurrentDictionary<uint, ushort[]>(); string[] dimensionData = System.IO.File.ReadAllLines("C:/db/mapdimensions.dat"); foreach (string md in dimensionData) { string[] mdd = md.Split(' '); ushort Width = ushort.Parse(mdd[1]); ushort Height = ushort.Parse(mdd[2]); ushort[] dim = new ushort[2] { Width, Height }; dimensions.TryAdd(uint.Parse(mdd[0]), dim); } Database.Database DB = new Database.Database("C:/db/maps.s3db"); System.Data.DataTable DT = DB.GetDataTable("SELECT `UniqueID`, `Type` FROM `maptypes`"); for (int i = 0; i < DT.Rows.Count; i++) { System.Data.DataRow dr = DT.Rows[i]; Mapping.Map M = new Map(); M.UniqueID = Convert.ToUInt32(dr.ItemArray[0]); M.Type = Convert.ToUInt32(dr.ItemArray[1]); if (!M.LoadDMap()) { ushort[] dims; if (dimensions.TryGetValue(M.Type, out dims)) { M.Width = dims[0]; M.Height = dims[1]; } else { M.Width = 1300; M.Height = 1300; } M.Coords = new byte[M.Height, M.Width]; for (short ix = 0; ix < M.Height; ix++) for (short iy = 0; iy < M.Width; iy++) M.Coords[ix, iy] = (byte)Enums.MapPointType.Empty; } Kernel.Maps.TryAdd(M.UniqueID, M); } DB.Dispose(); dimensions.Clear(); }
public FormSettings(int index) { InitializeComponent(); var s = Settings.Load(); if (s.Providers.ContainsKey(index)) { try { editConnectionString.Text = s.ConnectionStrings[index]; editProvider.Text = s.Providers[index].ToString(); editSiteAddress.Text = s.SiteAddress[index]; editEmail.Text = s.Emails[index]; editPassword.Text = s.Passwords[index]; try { Database.Database db = Provider.GetDb(index); var dt = db.GetDataTable("select Id, Title from Content where ClassName='Category' order by Title"); loadCategories(editCategoryId0, dt); loadCategories(editCategoryId1, dt); loadCategories(editCategoryId2, dt); loadCategories(editCategoryId3, dt); loadCategories(editCategoryId4, dt); loadCategories(editCategoryId5, dt); loadCategories(editCategoryId6, dt); loadCategories(editCategoryId7, dt); loadCategories(editCategoryId8, dt); loadCategories(editCategoryId9, dt); } catch { } if (s.Feed == null || string.IsNullOrWhiteSpace(s.Feed[index])) { s.Feed[index] = "|\n|\n|\n|\n|\n|\n|\n|\n|\n|\n"; } var feeds = s.Feed[index].Replace("\r", "").Split('\n'); try { editRSS0.Text = feeds[0].Split('|')[0]; editCategoryId0.SelectedIndex = editCategoryId0.Items.Cast <Item>().IndexOf(i => i.Id == Convert.ToInt32(feeds[0].Split('|')[1])); } catch { } try { editRSS1.Text = feeds[1].Split('|')[0]; editCategoryId1.SelectedIndex = editCategoryId1.Items.Cast <Item>().IndexOf(i => i.Id == Convert.ToInt32(feeds[1].Split('|')[1])); } catch { } try { editRSS2.Text = feeds[2].Split('|')[0]; editCategoryId2.SelectedIndex = editCategoryId2.Items.Cast <Item>().IndexOf(i => i.Id == Convert.ToInt32(feeds[2].Split('|')[1])); } catch { } try { editRSS3.Text = feeds[3].Split('|')[0]; editCategoryId3.SelectedIndex = editCategoryId3.Items.Cast <Item>().IndexOf(i => i.Id == Convert.ToInt32(feeds[3].Split('|')[1])); } catch { } try { editRSS4.Text = feeds[4].Split('|')[0]; editCategoryId4.SelectedIndex = editCategoryId4.Items.Cast <Item>().IndexOf(i => i.Id == Convert.ToInt32(feeds[4].Split('|')[1])); } catch { } try { editRSS5.Text = feeds[5].Split('|')[0]; editCategoryId5.SelectedIndex = editCategoryId5.Items.Cast <Item>().IndexOf(i => i.Id == Convert.ToInt32(feeds[5].Split('|')[1])); } catch { } try { editRSS6.Text = feeds[6].Split('|')[0]; editCategoryId6.SelectedIndex = editCategoryId6.Items.Cast <Item>().IndexOf(i => i.Id == Convert.ToInt32(feeds[6].Split('|')[1])); } catch { } try { editRSS7.Text = feeds[7].Split('|')[0]; editCategoryId7.SelectedIndex = editCategoryId7.Items.Cast <Item>().IndexOf(i => i.Id == Convert.ToInt32(feeds[7].Split('|')[1])); } catch { } try { editRSS8.Text = feeds[8].Split('|')[0]; editCategoryId8.SelectedIndex = editCategoryId8.Items.Cast <Item>().IndexOf(i => i.Id == Convert.ToInt32(feeds[8].Split('|')[1])); } catch { } try { editRSS9.Text = feeds[9].Split('|')[0]; editCategoryId9.SelectedIndex = editCategoryId9.Items.Cast <Item>().IndexOf(i => i.Id == Convert.ToInt32(feeds[9].Split('|')[1])); } catch { } } catch { } } }