private void SQLConnect(ReportingMessage reportMessage, TrackingObject trackingObject) { string initSqlQuery = "CALL gameserverinit(@serverhash, @namex, @descriptionx, @gameportx, @gameaddressx, @protocolx, @programversion, @maxplayersx, @modcontrolx, @modcontrolshax, @gamemodex, @cheatsx, @warpmodex, @universex, @bannerx, @homepagex, @httpportx, @adminx, @teamx, @locationx, @fixedipx);"; Dictionary <string, object> parameters = reportMessage.GetParameters(); try { databaseConnection.ExecuteNonReader(initSqlQuery, parameters); } catch (Exception e) { Console.WriteLine("WARNING: Ignoring error on connection (add server), error: " + e.Message); } string playerSqlQuery = "CALL gameserverplayer(@hash, @player, '1')"; foreach (string connectedPlayer in reportMessage.players) { Console.WriteLine("Player " + connectedPlayer + " joined " + reportMessage.serverHash); Dictionary <string, object> playerParams = new Dictionary <string, object>(); playerParams["@hash"] = reportMessage.serverHash; playerParams["@player"] = connectedPlayer; try { databaseConnection.ExecuteNonReader(playerSqlQuery, playerParams); } catch (Exception e) { Console.WriteLine("WARNING: Ignoring error on connection (add player), error: " + e.Message); } trackingObject.players = reportMessage.players; } }
private void SQLReport(int trackNumber, ReportingMessage reportMessage) { Dictionary <string, object> parameters = reportMessage.GetParameters(trackNumber); //Build SQL text string sqlText = "UPDATE DMPServerList SET "; sqlText += "`serverHash`=@serverHash, "; sqlText += "`serverName`=@serverName, "; sqlText += "`description`=@description, "; sqlText += "`gamePort`=@gamePort, "; sqlText += "`gameAddress`=@gameAddress, "; sqlText += "`protocolVersion`=@protocolVersion, "; sqlText += "`programVersion`=@programVersion, "; sqlText += "`maxPlayers`=@maxPlayers, "; sqlText += "`modControl`=@modControl, "; sqlText += "`modControlSha`=@modControlSha, "; sqlText += "`gameMode`=@gameMode, "; sqlText += "`cheats`=@cheats, "; sqlText += "`warpMode`=@warpMode, "; sqlText += "`universeSize`=@universeSize, "; sqlText += "`banner`=@banner, "; sqlText += "`homepage`=@homepage, "; sqlText += "`httpPort`=@httpPort, "; sqlText += "`admin`=@admin, "; sqlText += "`team`=@team, "; sqlText += "`location`=@location, "; sqlText += "`fixedIP`=@fixedIP, "; sqlText += "`players`=@players, "; sqlText += "`playerCount`=@playerCount "; sqlText += "WHERE `id`=@id"; //Run SQL try { databaseConnection.ExecuteNonReader(sqlText, parameters); } catch (Exception e) { Console.WriteLine("WARNING: Ignoring error on report, error: " + e); } }