private void mysql_test_background_worker_DoWork(object sender, DoWorkEventArgs e)
{
var dbConfig = new DbConfig();
dbConfig.SetOption("Server", mysql_host_textbox.Text);
dbConfig.SetOption("Port", Convert.ToUInt32(mysql_port_textbox.Text).ToString());
dbConfig.SetOption("Database", mysql_database_name_textbox.Text);
dbConfig.SetOption("UserID", mysql_username_textbox.Text);
dbConfig.SetOption("Password", mysql_password_textbox.Text);
var database = new MySQLObjectDatabase(dbConfig.ConnectionString);
var con = database.CreateConnection();
try
{
con.Open();
e.Result = "Congratulations! I am connected!";;
}
catch (Exception ex)
{
e.Result = ex;
}
finally
{
con.Close();
}
}
public static void SetDatabaseConnection(string host, uint port, string database, string user, string password)
{
string connectionString;
//Create a connection string using the string builder
MySqlConnectionStringBuilder sb = new MySqlConnectionStringBuilder();
sb.Server = host;
sb.Port = port;
sb.Database = database;
sb.UserID = user;
sb.Password = password;
sb.ConnectionTimeout = 2;
connectionString = sb.ConnectionString;
//Set the data connection object
DataConnection = new DataConnection(ConnectionType.DATABASE_MYSQL, connectionString);
//Set the Database object
Database = new MySQLObjectDatabase(m_dataConnection);
Database.RegisterDataObject(typeof(DBDataQuest));
Database.RegisterDataObject(typeof(CharacterXDataQuest));
Database.RegisterDataObject(typeof(Mob));
Database.RegisterDataObject(typeof(DBNpcTemplate));
Database.RegisterDataObject(typeof(DBSpell));
TestConnection = new MySqlConnection(sb.ConnectionString);
try { TestConnection.Open(); }
catch { }
if (TestConnection.State == System.Data.ConnectionState.Open)
{
// MessageBox.Show("Connection to the database was successful!");
TestConnection.Close();
}
else
{
// MessageBox.Show("Could not connect to the database! Check your credentials!");
}
}
static void Main(string[] args)
{
Log.Texte("", "-------------------------------", ConsoleColor.DarkBlue);
Log.Texte("", " _____ _____ ", ConsoleColor.Cyan);
Log.Texte("", " /\\ | __ \\ / ____|", ConsoleColor.Cyan);
Log.Texte("", " / \\ | |__) | (___ ", ConsoleColor.Cyan);
Log.Texte("", " / /\\ \\ | ___/ \\___ \\ ", ConsoleColor.Cyan);
Log.Texte("", " / ____ \\| | ____) |", ConsoleColor.Cyan);
Log.Texte("", "/_/ \\_\\_| |_____/ Rift", ConsoleColor.Cyan);
Log.Texte("", "http://AllPrivateServer.com", ConsoleColor.DarkCyan);
Log.Texte("", "-------------------------------", ConsoleColor.DarkBlue);
// Loading all configs files
ConfigMgr.LoadConfigs();
Config = ConfigMgr.GetConfig <ExtractorConfig>();
// Loading log level from file
if (!Log.InitLog(Config.LogLevel, "Cache"))
{
ConsoleMgr.WaitAndExit(2000);
}
WorldDB = DBManager.Start(Config.WorldDB.Total(), ConnectionType.DATABASE_MYSQL, "World");
if (WorldDB == null)
{
ConsoleMgr.WaitAndExit(2000);
}
PacketProcessor.RegisterDefinitions();
int Count = 0;
foreach (string FileDir in Directory.EnumerateFiles(Config.CacheFolder))
{
Log.Success("Extractor", "Opening Cache : " + FileDir);
FileStream Str = File.Open(FileDir, FileMode.Open);
byte[] Buff = new byte[Str.Length];
Str.Read(Buff, 0, Buff.Length);
PacketInStream Pack = new PacketInStream(Buff, Buff.Length);
ISerializablePacket Packet = PacketProcessor.ReadPacket(ref Pack);
if (Packet != null && Packet is CacheUpdate)
{
CacheUpdate Cache = Packet as CacheUpdate;
CacheTemplate Template = Cache.CacheDatas.Find(info => info.Opcode == (long)Opcodes.CacheTemplate) as CacheTemplate;
CacheData Data = Cache.CacheDatas.Find(info => info.Opcode == (long)Opcodes.CacheData) as CacheData;
if (Template != null)
{
Template.CacheID = Cache.CacheID;
Template.CacheType = Cache.CacheType;
WorldDB.AddObject(Template);
}
if (Data != null)
{
Data.CacheID = Cache.CacheID;
Data.CacheType = Cache.CacheType;
WorldDB.AddObject(Data);
}
++Count;
}
Str.Dispose();
}
Log.Success("Extractor", "" + Count + " Caches extracted");
ConsoleMgr.Start();
}
static void Main(string[] args)
{
Log.Texte("", "-------------------------------", ConsoleColor.DarkBlue);
Log.Texte("", " _____ _____ ", ConsoleColor.Cyan);
Log.Texte("", " /\\ | __ \\ / ____|", ConsoleColor.Cyan);
Log.Texte("", " / \\ | |__) | (___ ", ConsoleColor.Cyan);
Log.Texte("", " / /\\ \\ | ___/ \\___ \\ ", ConsoleColor.Cyan);
Log.Texte("", " / ____ \\| | ____) |", ConsoleColor.Cyan);
Log.Texte("", "/_/ \\_\\_| |_____/ Rift", ConsoleColor.Cyan);
Log.Texte("", "http://AllPrivateServer.com", ConsoleColor.DarkCyan);
Log.Texte("", "-------------------------------", ConsoleColor.DarkBlue);
// Loading all configs files
ConfigMgr.LoadConfigs();
Config = ConfigMgr.GetConfig<ExtractorConfig>();
// Loading log level from file
if (!Log.InitLog(Config.LogLevel, "Cache"))
ConsoleMgr.WaitAndExit(2000);
WorldDB = DBManager.Start(Config.WorldDB.Total(), ConnectionType.DATABASE_MYSQL, "World");
if (WorldDB == null)
ConsoleMgr.WaitAndExit(2000);
PacketProcessor.RegisterDefinitions();
int Count = 0;
foreach (string FileDir in Directory.EnumerateFiles(Config.CacheFolder))
{
Log.Success("Extractor", "Opening Cache : " + FileDir);
FileStream Str = File.Open(FileDir, FileMode.Open);
byte[] Buff = new byte[Str.Length];
Str.Read(Buff,0,Buff.Length);
PacketInStream Pack = new PacketInStream(Buff, Buff.Length);
ISerializablePacket Packet = PacketProcessor.ReadPacket(ref Pack);
if (Packet != null && Packet is CacheUpdate)
{
CacheUpdate Cache = Packet as CacheUpdate;
CacheTemplate Template = Cache.CacheDatas.Find(info => info.Opcode == (long)Opcodes.CacheTemplate) as CacheTemplate;
CacheData Data = Cache.CacheDatas.Find(info => info.Opcode == (long)Opcodes.CacheData) as CacheData;
if (Template != null)
{
Template.CacheID = Cache.CacheID;
Template.CacheType = Cache.CacheType;
WorldDB.AddObject(Template);
}
if (Data != null)
{
Data.CacheID = Cache.CacheID;
Data.CacheType = Cache.CacheType;
WorldDB.AddObject(Data);
}
++Count;
}
Str.Dispose();
}
Log.Success("Extractor", "" + Count + " Caches extracted");
ConsoleMgr.Start();
}
