public void StoreAgentLoginData(UserLogAgentData AgentData) { try { UpdateAgentTable(AgentData); } catch (Exception ex) { m_log.ErrorFormat("[UserLogModule]: MySQL Exception: {0}", ex); } }
private void UpdateAgentTable(UserLogAgentData agentData) { lock (this) { using (MySqlConnection connection = new MySqlConnection(m_connectionString)) { connection.Open(); using (MySqlCommand cmd = connection.CreateCommand()) { cmd.CommandText = "REPLACE INTO userlog_agent (region_id, agent_id, agent_name, " + "agent_pos, agent_ip, agent_country, agent_viewer,agent_grid, agent_time) " + "VALUES (" + "?region_id, ?agent_id, ?agent_name, ?agent_pos, ?agent_ip, ?agent_country, " + "?agent_viewer, ?agent_grid, ?agent_time)"; cmd.Parameters.AddWithValue("region_id", agentData.RegionID.ToString()); cmd.Parameters.AddWithValue("region_name", agentData.RegionName); cmd.Parameters.AddWithValue("agent_id", agentData.ID.ToString()); cmd.Parameters.AddWithValue("agent_name", agentData.Name); cmd.Parameters.AddWithValue("agent_pos", agentData.Position); cmd.Parameters.AddWithValue("agent_ip", agentData.IP); cmd.Parameters.AddWithValue("agent_country", agentData.CountryCode); cmd.Parameters.AddWithValue("country_name", agentData.CountryName); cmd.Parameters.AddWithValue("agent_viewer", agentData.Viewer); cmd.Parameters.AddWithValue("agent_grid", agentData.Grid); cmd.Parameters.AddWithValue("agent_time", Util.UnixTimeSinceEpoch().ToString()); cmd.ExecuteNonQuery(); cmd.CommandText = "REPLACE INTO userlog_country (country_code, country_name) " + "VALUES (" + "?agent_country, ?country_name)"; cmd.ExecuteNonQuery(); cmd.CommandText = "REPLACE INTO userlog_region (region_id, region_name) " + "VALUES (" + "?region_id, ?region_name)"; cmd.ExecuteNonQuery(); cmd.CommandText = "REPLACE INTO userlog_viewer (viewer) " + "VALUES (" + "?agent_viewer)"; cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } } } }
public void StoreAgentLoginData(UserLogAgentData AgentData) { Hashtable ReqHash = new Hashtable(); ReqHash["region_id"] = AgentData.RegionID.ToString(); ReqHash["region_name"] = AgentData.RegionName; ReqHash["agent_position"] = AgentData.Position; ReqHash["agent_id"] = AgentData.ID.ToString(); ReqHash["agent_name"] = AgentData.Name; ReqHash["agent_ip"] = AgentData.IP; ReqHash["agent_country_code"] = AgentData.CountryCode; ReqHash["agent_country_name"] = AgentData.CountryName; ReqHash["agent_viewer"] = AgentData.Viewer; ReqHash["agent_grid"] = AgentData.Grid; XMLRPCRequest(ReqHash, "userlog_update"); }
public void StoreAgentLoginData(UserLogAgentData AgentData) { m_log.WarnFormat("[UserLogModule]: Sqlite Data-Storage not supported."); }
private void UpdateAgentTable(UserLogAgentData agentData) { lock (this) { using (SqliteConnection connection = new SqliteConnection(m_connectionString)) { connection.Open(); using (SqliteCommand cmd = new SqliteCommand( "REPLACE INTO userlog_agent (region_id, agent_id, agent_name, " + "agent_pos, agent_ip, agent_country, agent_viewer,agent_grid, agent_time) " + "VALUES (" + ":region_id, :agent_id, :agent_name, :agent_pos, :agent_ip, :agent_country, " + ":agent_viewer, :agent_grid, :agent_time)", connection)) { cmd.Parameters.Add(":region_id", agentData.RegionID.ToString()); cmd.Parameters.Add(":region_name", agentData.RegionName); cmd.Parameters.Add(":agent_id", agentData.ID.ToString()); cmd.Parameters.Add(":agent_name", agentData.Name); cmd.Parameters.Add(":agent_pos", agentData.Position); cmd.Parameters.Add(":agent_ip", agentData.IP); cmd.Parameters.Add(":agent_country", agentData.CountryCode); cmd.Parameters.Add(":country_name", agentData.CountryName); cmd.Parameters.Add(":agent_viewer", agentData.Viewer); cmd.Parameters.Add(":agent_grid", agentData.Grid); cmd.Parameters.Add(":agent_time", Util.UnixTimeSinceEpoch().ToString()); cmd.ExecuteNonQuery(); cmd.CommandText = "REPLACE INTO userlog_country (country_code, country_name) " + "VALUES (" + ":agent_country, :country_name)"; cmd.ExecuteNonQuery(); cmd.CommandText = "REPLACE INTO userlog_region (region_id, region_name) " + "VALUES (" + ":region_id, :region_name)"; cmd.ExecuteNonQuery(); cmd.CommandText = "REPLACE INTO userlog_viewer (viewer) " + "VALUES (" + ":agent_viewer)"; cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } } } }
public void StoreAgentLoginData(UserLogAgentData AgentData) { try { UpdateAgentTable(AgentData); } catch (Exception ex) { m_log.ErrorFormat("[UserLogModule]: SQLite Exception: {0}", ex); } }
public void StoreAgentLoginData(UserLogAgentData AgentData) { m_log.WarnFormat("[UserLogModule]: Mssql Data-Storage not supported."); }