public static void Begin()
{
if (m_Command != null && !m_Command.HasCompleted)
return;
DateTime start = DateTime.Now;
Console.WriteLine("MyRunUO: Updating status database");
try
{
m_Command = new DatabaseCommandQueue("MyRunUO: Status database updated in {0:F1} seconds", "MyRunUO Status Database Thread");
m_Command.Enqueue("DELETE FROM myrunuo_status");
List<NetState> online = NetState.Instances;
for (int i = 0; i < online.Count; ++i)
{
NetState ns = online[i];
Mobile mob = ns.Mobile;
if (mob != null)
m_Command.Enqueue(String.Format("INSERT INTO myrunuo_status (char_id) VALUES ({0})", mob.Serial.Value.ToString()));
}
}
catch (Exception e)
{
Console.WriteLine("MyRunUO: Error updating status database");
Console.WriteLine(e);
}
if (m_Command != null)
m_Command.Enqueue(null);
}
public static void Begin()
{
if (m_Command != null && !m_Command.HasCompleted)
{
return;
}
Console.WriteLine("MyRunUO: Updating status database");
try
{
m_Command = new DatabaseCommandQueue(
"MyRunUO: Status database updated in {0:F1} seconds", "MyRunUO Status Database Thread");
m_Command.Enqueue("DELETE FROM myrunuo_status");
List <NetState> online = NetState.Instances;
foreach (Mobile mob in online.Select(ns => ns.Mobile).Where(mob => mob != null))
{
m_Command.Enqueue(String.Format("INSERT INTO myrunuo_status (char_id) VALUES ({0})", mob.Serial.Value));
}
}
catch (Exception e)
{
Console.WriteLine("MyRunUO: Error updating status database");
Console.WriteLine(e);
}
if (m_Command != null)
{
m_Command.Enqueue(null);
}
}
public static void Begin()
{
if ( m_Command != null && !m_Command.HasCompleted )
return;
DateTime start = DateTime.Now;
Console.WriteLine( "MyRunUO: Updating status database" );
try
{
m_Command = new DatabaseCommandQueue( "MyRunUO: Status database updated in {0:F1} seconds", "MyRunUO Status Database Thread" );
m_Command.Enqueue( "DELETE FROM myrunuo_status" );
ArrayList online = NetState.Instances;
for ( int i = 0; i < online.Count; ++i )
{
NetState ns = (NetState)online[i];
Mobile mob = ns.Mobile;
if ( mob != null )
m_Command.Enqueue( String.Format( "INSERT INTO myrunuo_status (char_id, char_location, char_map, char_Karma, char_fame) VALUES ({0},'{1},{2},{3}','{4}',{5},{6})", mob.Serial.Value.ToString(), mob.X.ToString(),mob.Y.ToString(),mob.Z.ToString(), mob.Map, mob.Karma, mob.Fame ));
}
}
catch ( Exception e )
{
Console.WriteLine( "MyRunUO: Error updating status database" );
Console.WriteLine( e );
}
if ( m_Command != null )
m_Command.Enqueue( null );
}
public static void Begin()
{
if ( m_Command != null && !m_Command.HasCompleted )
return;
log.Info("MyRunUO: Updating status database");
try
{
m_Command = new DatabaseCommandQueue( "MyRunUO: Status database updated in {0:F1} seconds", "MyRunUO Status Database Thread" );
m_Command.Enqueue( "DELETE FROM myrunuo_status" );
ArrayList online = NetState.Instances;
for ( int i = 0; i < online.Count; ++i )
{
NetState ns = (NetState)online[i];
Mobile mob = ns.Mobile;
if ( mob != null )
m_Command.Enqueue( String.Format( "INSERT INTO myrunuo_status VALUES ({0})", mob.Serial.Value.ToString() ) );
}
}
catch ( Exception e )
{
log.Error("MyRunUO: Error updating status database",
e);
}
if ( m_Command != null )
m_Command.Enqueue( null );
}
public static void TableCreation()
{
if (m_Command != null && !m_Command.HasCompleted)
{
return;
}
DateTime start = DateTime.Now;
Console.WriteLine("MyRunUO: Creating tables");
try
{
m_Command = new DatabaseCommandQueue("MyRunUO: Tables created in {0:F1} seconds", "MyRunUO Status Database Thread");
m_Command.Enqueue("CREATE TABLE IF NOT EXISTS `myrunuo_characters` ( `char_id` int(10) unsigned NOT NULL, `char_name` varchar(255) NOT NULL, `char_str` smallint(3) unsigned NOT NULL, `char_dex` smallint(3) unsigned NOT NULL, `char_int` smallint(3) unsigned NOT NULL, `char_female` tinyint(1) NOT NULL, `char_counts` smallint(6) NOT NULL, `char_guild` varchar(255) DEFAULT NULL, `char_guildtitle` varchar(255) DEFAULT NULL, `char_nototitle` varchar(255) DEFAULT NULL, `char_bodyhue` smallint(5) unsigned DEFAULT NULL, `char_public` tinyint(1) NOT NULL, PRIMARY KEY (`char_id`))");
m_Command.Enqueue("CREATE TABLE IF NOT EXISTS `myrunuo_characters_layers` ( `char_id` int(10) unsigned NOT NULL, `layer_id` tinyint(3) unsigned NOT NULL, `item_id` smallint(5) unsigned NOT NULL, `item_hue` smallint(5) unsigned NOT NULL, PRIMARY KEY (`char_id`,`layer_id`))");
m_Command.Enqueue("CREATE TABLE IF NOT EXISTS `myrunuo_characters_skills` ( `char_id` int(10) unsigned NOT NULL, `skill_id` tinyint(3) NOT NULL, `skill_value` smallint(5) unsigned NOT NULL, PRIMARY KEY (`char_id`,`skill_id`), KEY `skill_id` (`skill_id`))");
m_Command.Enqueue("CREATE TABLE IF NOT EXISTS `myrunuo_guilds` ( `guild_id` smallint(5) unsigned NOT NULL, `guild_name` varchar(255) NOT NULL, `guild_abbreviation` varchar(8) DEFAULT NULL, `guild_website` varchar(255) DEFAULT NULL, `guild_charter` varchar(255) DEFAULT NULL, `guild_type` varchar(8) NOT NULL, `guild_wars` smallint(5) unsigned NOT NULL, `guild_members` smallint(5) unsigned NOT NULL, `guild_master` int(10) unsigned NOT NULL, PRIMARY KEY (`guild_id`))");
m_Command.Enqueue("CREATE TABLE IF NOT EXISTS `myrunuo_guilds_wars` ( `guild_1` smallint(5) unsigned NOT NULL DEFAULT '0', `guild_2` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guild_1`,`guild_2`), KEY `guild1` (`guild_1`), KEY `guild2` (`guild_2`))");
m_Command.Enqueue("CREATE TABLE IF NOT EXISTS `myrunuo_status` ( `char_id` int(10) NOT NULL, PRIMARY KEY (`char_id`))");
}
catch (Exception e)
{
Console.WriteLine("MyRunUO: Error creating tables.");
Console.WriteLine(e);
}
if (m_Command != null)
{
m_Command.Enqueue(null);
}
}
public void CheckConnection()
{
if (m_Command == null)
{
m_Command = new DatabaseCommandQueue("MyRunUO: Characeter database updated in {0:F1} seconds", "MyRunUO Character Database Thread");
m_Command.Enqueue(String.Format("DELETE FROM {0}", Config.GuildsTable));
m_Command.Enqueue(String.Format("DELETE FROM {0}", Config.GuildWarsTable));
}
}
public static void Begin()
{
if ( m_Command != null && m_Command.HasCompleted )
m_Command = null;
if ( m_Timer != null || m_Command != null )
return;
m_Timer = new MyRunUO();
m_Timer.Start();
}
public static void Begin()
{
if (m_Command != null && m_Command.HasCompleted)
{
m_Command = null;
}
if (m_Timer != null || m_Command != null)
{
return;
}
m_Timer = new MyRunUO();
m_Timer.Start();
}
public static void UpdateMyRunUO_OnCommand(CommandEventArgs e)
{
if (m_Command != null && m_Command.HasCompleted)
{
m_Command = null;
}
if (m_Timer == null && m_Command == null)
{
Begin();
e.Mobile.SendMessage("MyRunUO update process has been started.");
}
else
{
e.Mobile.SendMessage("MyRunUO database is already being updated.");
}
}
public static void Begin()
{
if (m_Command != null && !m_Command.HasCompleted)
{
return;
}
DateTime start = DateTime.Now;
Console.WriteLine("MyRunUO: Updating status database");
try
{
m_Command = new DatabaseCommandQueue("MyRunUO: Status database updated in {0:F1} seconds", "MyRunUO Status Database Thread");
m_Command.Enqueue("DELETE FROM myrunuo_status");
//ArrayList online = NetState.Instances;
List <NetState> online = NetState.Instances;
for (int i = 0; i < online.Count; ++i)
{
NetState ns = online[i];
Mobile mob = ns.Mobile;
if (mob != null)
{
m_Command.Enqueue(String.Format("INSERT INTO myrunuo_status VALUES ({0})", mob.Serial.Value.ToString()));
}
}
}
catch (Exception e)
{
LogHelper.LogException(e);
Console.WriteLine("MyRunUO: Error updating status database");
Console.WriteLine(e);
}
if (m_Command != null)
{
m_Command.Enqueue(null);
}
}
public void CheckConnection()
{
if (m_Command == null)
{
m_Command = new DatabaseCommandQueue("MyRunUO: Characeter database updated in {0:F1} seconds", "MyRunUO Character Database Thread");
if (Config.LoadDataInFile)
{
m_OpSkills = GetUniqueWriter("skills", out m_SkillsPath);
m_OpLayers = GetUniqueWriter("layers", out m_LayersPath);
m_OpMobiles = GetUniqueWriter("mobiles", out m_MobilesPath);
m_Command.Enqueue("TRUNCATE TABLE myrunuo_characters");
m_Command.Enqueue("TRUNCATE TABLE myrunuo_characters_layers");
m_Command.Enqueue("TRUNCATE TABLE myrunuo_characters_skills");
}
m_Command.Enqueue("TRUNCATE TABLE myrunuo_guilds");
m_Command.Enqueue("TRUNCATE TABLE myrunuo_guilds_wars");
}
}
public void CheckConnection()
{
if ( m_Command == null )
{
m_Command = new DatabaseCommandQueue( "MyRunUO: Characeter database updated in {0:F1} seconds", "MyRunUO Character Database Thread" );
m_Command.Enqueue( String.Format( "DELETE FROM {0}", Config.GuildsTable ) );
m_Command.Enqueue( String.Format( "DELETE FROM {0}", Config.GuildWarsTable ) );
}
}
public static void UpdateMyRunUO_OnCommand( Server.Commands.CommandEventArgs e )
{
if ( m_Command != null && m_Command.HasCompleted )
m_Command = null;
if ( m_Timer == null && m_Command == null )
{
Begin();
e.Mobile.SendAsciiMessage( "MyRunUO update process has been started." );
}
else
{
e.Mobile.SendAsciiMessage( "MyRunUO database is already being updated." );
}
}
public void CheckConnection()
{
if ( m_Command == null )
{
m_Command = new DatabaseCommandQueue( "MyRunUO: Characeter database updated in {0:F1} seconds", "MyRunUO Character Database Thread" );
if ( Config.LoadDataInFile )
{
m_OpSkills = GetUniqueWriter( "skills", out m_SkillsPath );
m_OpLayers = GetUniqueWriter( "layers", out m_LayersPath );
m_OpMobiles = GetUniqueWriter( "mobiles", out m_MobilesPath );
m_Command.Enqueue( "TRUNCATE TABLE myrunuo_characters" );
m_Command.Enqueue( "TRUNCATE TABLE myrunuo_characters_layers" );
m_Command.Enqueue( "TRUNCATE TABLE myrunuo_characters_skills" );
}
m_Command.Enqueue( "TRUNCATE TABLE myrunuo_guilds" );
m_Command.Enqueue( "TRUNCATE TABLE myrunuo_guilds_wars" );
}
}
