static public int Main()
{
if (!initialized)
{
Console.WriteLine("Not initialized yet, adding MainLoopTick callback..");
Events.MainLoopTick += CheckQueryResult;
Thread query_thread = new Thread(PollQueries);
query_thread.IsBackground = true;
query_thread.Start();
initialized = true;
// Read database variables from env
db_name = Environment.GetEnvironmentVariable("NWNX_CSHARP_DB");
db_user = Environment.GetEnvironmentVariable("NWNX_CSHARP_DB_USER");
db_pass = Environment.GetEnvironmentVariable("NWNX_CSHARP_DB_PASS");
Console.WriteLine("db_name: " + db_name);
}
QueryThreadParams t_params = new QueryThreadParams();
t_params.db_object = Object.OBJECT_SELF;
t_params.query = NWScript.GetLocalString(t_params.db_object, "sql_query") as string;
try
{
t_params.values = (NWScript.GetLocalString(t_params.db_object, "sql_values") as string);
}
catch
{
t_params.values = "";
}
try
{
t_params.callback_script = (NWScript.GetLocalString(t_params.db_object, "sql_callback_script") as string);
t_params.callback_object = (NWScript.GetLocalObject(t_params.db_object, "sql_callback_object"));
}
catch
{
t_params.callback_script = "";
t_params.callback_object = null;
}
try
{
t_params.metadata = (NWScript.GetLocalString(t_params.db_object, "sql_metadata") as string);
}
catch
{
t_params.metadata = "";
}
query_stack.Push(t_params);
return(1);
}
static public void RunQuery(QueryThreadParams t_params)
{
string connectionString =
"database=" + db_name + ";" +
"user="******";" +
"password="******";";
MySqlConnection dbcon;
MySqlCommand dbcmd;
Console.WriteLine(connectionString);
try
{
dbcon = new MySqlConnection(connectionString);
dbcon.Open();
dbcmd = dbcon.CreateCommand();
dbcmd.CommandText = t_params.query;
dbcmd.Prepare();
}
catch (Exception e)
{
Console.WriteLine(e);
Console.WriteLine("Error: Could not create DB connection; Returning.");
Console.Out.Flush();
return;
}
// Read the values for our query for prepared statement parts
int value_i = 1;
while (t_params.values.Length > 0)
{
string param_value = "";
if (t_params.values.IndexOf('¦') >= 0)
{
param_value = t_params.values.Substring(0, t_params.values.IndexOf('¦'));
// Remove the value from the values string
t_params.values = t_params.values.Substring(t_params.values.IndexOf('¦') + 1);
}
else
{
param_value = t_params.values;
t_params.values = "";
}
dbcmd.Parameters.AddWithValue("@" + value_i.ToString(), param_value);
value_i++;
}
List <string> result_list = new List <string>();
try
{
IDataReader reader = dbcmd.ExecuteReader();
while (reader.Read())
{
string column_result = "";
for (int i = 0; i < reader.FieldCount; i++)
{
column_result += reader[i];
if (i + 1 < reader.FieldCount)
{
column_result += "¦";
}
}
result_list.Add(column_result);
}
}
catch (Exception e)
{
Console.WriteLine(e);
Console.WriteLine("Error: Could not execute reader! Cleaning up..");
try
{
dbcmd.Dispose();
dbcmd = null;
dbcon.Close();
dbcon = null;
}
catch (Exception ee)
{
Console.WriteLine(ee);
Console.WriteLine("Error: We could not clean up!");
}
Console.Out.Flush();
return;
}
QueryResult query_result = new QueryResult();
query_result.db_object = t_params.db_object;
query_result.results = result_list.ToArray();
query_result.callback_script = t_params.callback_script;
query_result.callback_object = t_params.callback_object;
query_result.metadata = t_params.metadata;
result_stack.Push(query_result);
dbcmd.Dispose();
dbcmd = null;
dbcon.Close();
dbcon = null;
}
