public SQLResult Select(string sql, params object[] args)
{
SQLResult retData = new SQLResult();
StringBuilder sqlString = new StringBuilder();
sqlString.AppendFormat(CultureInfo.GetCultureInfo("en-US").NumberFormat, sql);
MySqlCommand sqlCommand = new MySqlCommand(sqlString.ToString(), Connection);
try
{
List <MySqlParameter> mParams = new List <MySqlParameter>(args.Length);
foreach (var a in args)
{
mParams.Add(new MySqlParameter("", a));
}
sqlCommand.Parameters.AddRange(mParams.ToArray());
SqlData = sqlCommand.ExecuteReader(CommandBehavior.Default);
retData.Load(SqlData);
retData.Count = retData.Rows.Count;
SqlData.Close();
}
catch (MySqlException ex)
{
LogConsole.Show("{0}", ex.Message);
}
return(retData);
}
public bool Execute(string sql, params object[] args)
{
StringBuilder sqlString = new StringBuilder();
sqlString.AppendFormat(CultureInfo.GetCultureInfo("en-US").NumberFormat, sql);
MySqlCommand sqlCommand = new MySqlCommand(sqlString.ToString(), Connection);
try
{
List <MySqlParameter> mParams = new List <MySqlParameter>(args.Length);
foreach (var a in args)
{
mParams.Add(new MySqlParameter("", a));
}
sqlCommand.Parameters.AddRange(mParams.ToArray());
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (MySqlException ex)
{
LogConsole.Show("{0}", ex.Message);
return(false);
}
}
public void CommandSQL(string _comm)
{
using (MySqlCommand sqlCommand = new MySqlCommand(_comm, Connection))
{
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.ExecuteNonQuery();
LogConsole.Show(_comm + " Complete!");
}
}
public void Init(string host, string user, string password, string database, int port)
{
Connection = new MySqlConnection("Server=" + host + ";User Id=" + user + ";Port=" + port + ";" +
"Password="******";Database=" + database + ";Allow Zero Datetime=True");
try
{
Connection.Open();
LogConsole.Show("Successfully connected to {0}:{1}:{2} ", host, port, database);
}
catch (MySqlException ex)
{
LogConsole.Show("{0}", ex.Message);
LogConsole.Show("Try reconnect in 5 seconds...");
Thread.Sleep(5000);
Init(host, user, password, database, port);
}
}
static void Main(string[] args)
{
#region Load Settings
_dir = Environment.CurrentDirectory;
LogConsole._Load();
try
{
if (File.Exists(_dir + _file_config))
{
ini = new Systems.Ini(_dir + _file_config);
s_timer = ini.GetValue("Timer", "minutes", 10);
max_count = ini.GetValue("Timer", "max", 100);
delay = ini.GetValue("Timer", "delay", 10000);
infi = ini.GetValue("Timer", "infi", false);
_db_user = ini.GetValue("MYSQL", "user", "root");
_db_pass = ini.GetValue("MYSQL", "pass", "123456");
_db_ipsv = ini.GetValue("MYSQL", "ipsv", "127.0.0.1");
_db_name = ini.GetValue("MYSQL", "data", "rakion");
_db_port = ini.GetValue("MYSQL", "port", 3306);
debug = ini.GetValue("CONSOLE", "debug", false);
ini = null;
LogConsole.Show("Has loaded your settings successfully");
}
else
{
LogConsole.Show("Settings.ini could not be found, using default setting");
}
}
catch (Exception)
{
return;
}
#endregion
_SQL.Init(_db_ipsv, _db_user, _db_pass, _db_name, _db_port);
TimerX _t = new TimerX(s_timer, max_count, infi, delay);
}
