private Utils.DBCon initDatabase()
{
Utils.DBCon dbcon = new Utils.DBConComSqlite(_databaseFile);
object o = dbcon.ExecuteScalar("SELECT name FROM sqlite_master WHERE type='table' AND name='scripts'");
if (o == null || o.GetType() == typeof(DBNull))
{
dbcon.ExecuteNonQuery("create table 'scripts' (id text, name text, scripttype text, content text)");
}
o = dbcon.ExecuteScalar("SELECT name FROM sqlite_master WHERE type='table' AND name='settings'");
if (o == null || o.GetType() == typeof(DBNull))
{
dbcon.ExecuteNonQuery("create table 'settings' (scriptid text, enable integer, pos integer)");
}
return(dbcon);
}
private void PreLoadAreaInfo()
{
if (_cachedAreaInfo == null)
{
_cachedAreaInfo = new List <Framework.Data.AreaInfo>();
try
{
using (Utils.DBCon dbcon = new Utils.DBConComSqlite(_databaseFilename))
{
if (InitDatabase(dbcon))
{
DbDataReader dr = dbcon.ExecuteReader("select * from areainfo");
while (dr.Read())
{
Framework.Data.AreaInfo ai = new Framework.Data.AreaInfo();
ai.ID = (int)dr["id"];
ai.ParentID = dr["parentid"] == DBNull.Value ? null : dr["parentid"];
ai.Level = (Framework.Data.AreaType)(short)(int) dr["level"];
ai.Name = (string)dr["name"];
ai.MinLat = (double)dr["minlat"];
ai.MinLon = (double)dr["minlon"];
ai.MaxLat = (double)dr["maxlat"];
ai.MaxLon = (double)dr["maxlon"];
_cachedAreaInfo.Add(ai);
}
}
object o = dbcon.ExecuteScalar("select Max(id) from areainfo");
if (o != null)
{
_maxAreaInfoId = (int)(long)o;
}
o = dbcon.ExecuteScalar("select Max(id) from poly");
if (o != null)
{
_maxPolyId = (int)(long)o;
}
}
}
catch
{
//corrupt file
_cachedAreaInfo.Clear();
}
}
}
private Utils.DBCon initDatabase()
{
Utils.DBCon dbcon;
try
{
dbcon = new Utils.DBConComSqlite(_databaseFile);
object o = dbcon.ExecuteScalar("SELECT name FROM sqlite_master WHERE type='table' AND name='gallery'");
if (o == null || o.GetType() == typeof(DBNull))
{
dbcon.ExecuteNonQuery("create table 'gallery' (ImageGuid text, ThumbUrl text, Description text, Name text, MobileUrl text, Url text, LogCacheCode text, LogCode text, LogUrl text, LogVisitDate text, ThumbFile text, ImgFile text)");
}
}
catch
{
dbcon = null;
}
return(dbcon);
}
private Utils.DBCon initDatabase()
{
Utils.DBCon result = null;
try
{
string fn = System.IO.Path.Combine(_core.PluginDataPath, "coordsav.db3");
if (!System.IO.Directory.Exists(System.IO.Path.GetDirectoryName(fn)))
{
System.IO.Directory.CreateDirectory(System.IO.Path.GetDirectoryName(fn));
}
result = new Utils.DBConComSqlite(fn);
object o = result.ExecuteScalar("SELECT name FROM sqlite_master WHERE type='table' AND name='coord'");
if (o == null || o.GetType() == typeof(DBNull))
{
result.ExecuteNonQuery("create table 'coord' (code text, lat real, lon real)");
result.ExecuteNonQuery("create unique index idx_coord on coord (code)");
}
}
catch
{
}
return(result);
}
private Utils.DBCon initDatabase()
{
Utils.DBCon result = null;
try
{
string fn = System.IO.Path.Combine(_core.PluginDataPath, "coordsav.db3" );
if (!System.IO.Directory.Exists(System.IO.Path.GetDirectoryName(fn)))
{
System.IO.Directory.CreateDirectory(System.IO.Path.GetDirectoryName(fn));
}
result = new Utils.DBConComSqlite(fn);
object o = result.ExecuteScalar("SELECT name FROM sqlite_master WHERE type='table' AND name='coord'");
if (o == null || o.GetType() == typeof(DBNull))
{
result.ExecuteNonQuery("create table 'coord' (code text, lat real, lon real)");
result.ExecuteNonQuery("create unique index idx_coord on coord (code)");
}
}
catch
{
}
return result;
}
private void initDatabase()
{
string xmlFileContents;
Assembly assembly = Assembly.GetExecutingAssembly();
using (StreamReader textStreamReader = new StreamReader(assembly.GetManifestResourceStream("GlobalcachingApplication.Plugins.LanguageEng.LookupDictionary.xml")))
{
xmlFileContents = textStreamReader.ReadToEnd();
}
XmlDocument doc = new XmlDocument();
doc.LoadXml(xmlFileContents);
XmlElement root = doc.DocumentElement;
XmlNodeList strngs = root.SelectNodes("string");
if (strngs != null)
{
foreach (XmlNode sn in strngs)
{
if (!string.IsNullOrEmpty(sn.Attributes["value"].InnerText))
{
_fixedLookupTable[sn.Attributes["name"].InnerText.ToLower()] = sn.Attributes["value"].InnerText;
}
}
}
try
{
using (Utils.DBCon dbcon = new Utils.DBConComSqlite(_customDictionaryDatabaseFile))
{
object o = dbcon.ExecuteScalar("SELECT name FROM sqlite_master WHERE type='table' AND name='translation'");
if (o == null || o.GetType() == typeof(DBNull))
{
dbcon.ExecuteNonQuery("create table 'translation' (item_name text, item_value text)");
}
DbDataReader dr = dbcon.ExecuteReader("select * from translation");
while (dr.Read())
{
_customLookupTable[dr["item_name"].ToString().ToLower()] = dr["item_value"].ToString();
}
}
}
catch
{
}
}
private void PreLoadAreaInfo()
{
if (_cachedAreaInfo == null)
{
_cachedAreaInfo = new List<Framework.Data.AreaInfo>();
try
{
using (Utils.DBCon dbcon = new Utils.DBConComSqlite(_databaseFilename))
{
if (InitDatabase(dbcon))
{
DbDataReader dr = dbcon.ExecuteReader("select * from areainfo");
while (dr.Read())
{
Framework.Data.AreaInfo ai = new Framework.Data.AreaInfo();
ai.ID = (int)dr["id"];
ai.ParentID = dr["parentid"] == DBNull.Value ? null : dr["parentid"];
ai.Level = (Framework.Data.AreaType)(short)(int)dr["level"];
ai.Name = (string)dr["name"];
ai.MinLat = (double)dr["minlat"];
ai.MinLon = (double)dr["minlon"];
ai.MaxLat = (double)dr["maxlat"];
ai.MaxLon = (double)dr["maxlon"];
_cachedAreaInfo.Add(ai);
}
}
object o = dbcon.ExecuteScalar("select Max(id) from areainfo");
if (o != null)
{
_maxAreaInfoId = (int)(long)o;
}
o = dbcon.ExecuteScalar("select Max(id) from poly");
if (o != null)
{
_maxPolyId = (int)(long)o;
}
}
}
catch
{
//corrupt file
_cachedAreaInfo.Clear();
}
}
}
private void InitDatabase()
{
try
{
if (!string.IsNullOrEmpty(_databaseFile))
{
Utils.DBCon dbcon = new Utils.DBConComSqlite(_databaseFile);
object o = dbcon.ExecuteScalar("SELECT name FROM sqlite_master WHERE type='table' AND name='filterfields'");
if (o == null || o.GetType() == typeof(DBNull))
{
dbcon.ExecuteNonQuery("create table 'filterfields' (field text, filter text)");
}
}
}
catch
{
}
}
private Utils.DBCon initDatabase()
{
Utils.DBCon dbcon;
try
{
dbcon = new Utils.DBConComSqlite(_databaseFile);
object o = dbcon.ExecuteScalar("SELECT name FROM sqlite_master WHERE type='table' AND name='gallery'");
if (o == null || o.GetType() == typeof(DBNull))
{
dbcon.ExecuteNonQuery("create table 'gallery' (ImageGuid text, ThumbUrl text, Description text, Name text, MobileUrl text, Url text, LogCacheCode text, LogCode text, LogUrl text, LogVisitDate text, ThumbFile text, ImgFile text)");
}
}
catch
{
dbcon = null;
}
return dbcon;
}
private Utils.DBCon initDatabase()
{
Utils.DBCon dbcon = new Utils.DBConComSqlite(_databaseFile);
object o = dbcon.ExecuteScalar("SELECT name FROM sqlite_master WHERE type='table' AND name='scripts'");
if (o == null || o.GetType() == typeof(DBNull))
{
dbcon.ExecuteNonQuery("create table 'scripts' (id text, name text, scripttype text, content text)");
}
o = dbcon.ExecuteScalar("SELECT name FROM sqlite_master WHERE type='table' AND name='settings'");
if (o == null || o.GetType() == typeof(DBNull))
{
dbcon.ExecuteNonQuery("create table 'settings' (scriptid text, enable integer, pos integer)");
}
return dbcon;
}
