public void AddUpdateVictimAccount(CSteamID id, decimal bounty, string lastDisplayName) { try { MySqlConnection connection = CreateConnection(); MySqlCommand command = connection.CreateCommand(); if (CheckExists(id)) { command.CommandText = "UPDATE `" + FeexHitman.Instance.Configuration.Instance.FeexHitmanDatabase.DatabaseTableName + "` SET `bounty` = bounty + (" + bounty + "), `lastDisplayName` = @lastDisplayName, `lastUpdated` = NOW() WHERE `steamId` = '" + id.ToString() + "';"; } else { command.CommandText = "INSERT IGNORE INTO `" + FeexHitman.Instance.Configuration.Instance.FeexHitmanDatabase.DatabaseTableName + "` (steamId,bounty,lastDisplayName,lastUpdated) VALUES('" + id.ToString() + "','" + bounty + "',@lastDisplayName,NOW());"; } command.Parameters.AddWithValue("@lastDisplayName", lastDisplayName); connection.Open(); IAsyncResult result = command.BeginExecuteNonQuery(); command.EndExecuteNonQuery(result); connection.Close(); } catch (Exception ex) { Logger.LogException(ex); } }
protected override async void execute(CSteamID executor, string parameter) { Player ply = PlayerTool.getPlayer(executor); if (Main.Config.safeZoneOnly && !ply.movement.isSafe) { UnityThread.executeInUpdate(() => { ChatManager.say(executor, $"Stash can only be accessed inside a safezone", Color.cyan); }); return; } Items stash = new Items(7); stash.resize((byte)Main.Config.width, (byte)Main.Config.height); //List<ItemJar> items = AsyncContext.Run(async () => await Task.Run(() => StashDB.GetItemsAsync(executor.ToString()))); List <ItemJar> items = await Task.Run(() => StashDB.GetItemsAsync(executor.ToString())); foreach (ItemJar item in items) { ItemAsset itemAsset = (ItemAsset)Assets.find(EAssetType.ITEM, item.item.id); try { stash.addItem(item.x, item.y, item.rot, new Item(item.item.id, item.item.amount, item.item.quality, item.item.metadata)); } catch (Exception ex) { UnityThread.executeInUpdate(() => { ChatManager.say(executor, $"Failed to get {itemAsset.itemName}, not enough free space", Color.cyan); }); } } stash.onItemAdded = async(byte page, byte index, ItemJar item) => { await Task.Run(() => StashDB.AddItemAsync(executor.ToString(), item)); //AsyncContext.Run(async () => await Task.Run(() => StashDB.AddItemAsync(executor.ToString(), item))); }; stash.onItemRemoved = async(byte page, byte index, ItemJar item) => { await Task.Run(() => StashDB.DeleteItemAsync(executor.ToString(), item)); //AsyncContext.Run(async () => await Task.Run(() => StashDB.DeleteItemAsync(executor.ToString(), item))); }; stash.onItemUpdated = async(byte page, byte index, ItemJar item) => { await Task.Run(() => StashDB.DeleteItemAsync(executor.ToString(), item)); //AsyncContext.Run(async () => await Task.Run(() => StashDB.UpdateItemAsync(executor.ToString(), item))); }; ply.inventory.updateItems(7, stash); ply.inventory.sendStorage(); }
public static UnturnedPlayer FromCSteamID(CSteamID cSteamID) { if (string.IsNullOrEmpty(cSteamID.ToString()) || cSteamID.ToString() == "0") { return(null); } else { return(new UnturnedPlayer(cSteamID)); } }
private UnturnedPlayer(CSteamID cSteamID) { if (string.IsNullOrEmpty(cSteamID.ToString()) || cSteamID.ToString() == "0") { throw new PlayerIsConsoleException(); } else { player = PlayerTool.getPlayer(cSteamID); } }
public static void TellInfo(IRocketPlayer caller, CSteamID ownerid, CSteamID group) { string charname = null; UnturnedPlayer owner = UnturnedPlayer.FromCSteamID(ownerid); bool isOnline = owner.Player != null ? owner.Player.channel != null ? true : false : false; if (!isOnline) { charname = GetCharName(ownerid); } if (Init.Instance.Configuration.Instance.SayPlayerID) { UnturnedChat.Say(caller, "Owner ID: " + ownerid.ToString()); } if (Init.Instance.Configuration.Instance.SayPlayerCharacterName) { if (isOnline) { UnturnedChat.Say(caller, "Character Name: " + owner.CharacterName); } else if (charname != null) { UnturnedChat.Say(caller, "Character Name: " + charname); } else { UnturnedChat.Say(caller, "Could not get character name."); } } if (Init.Instance.Configuration.Instance.SayPlayerSteamName) { UnturnedChat.Say(caller, "Steam Name: " + SteamRequest(ownerid.ToString())); } if (group != CSteamID.Nil) { string GroupName = SteamGroupRequest(group.ToString()); if (Init.Instance.Configuration.Instance.SayGroupID) { UnturnedChat.Say(caller, "Group ID: " + group.ToString()); } if (Init.Instance.Configuration.Instance.SayGroupName) { UnturnedChat.Say(caller, "Group Name: " + GroupName); } } }
public void TellInfo(IUser caller, CSteamID ownerid, CSteamID group) { if (!(_playerManager.GetPlayer(ownerid.ToString()) is UnturnedPlayer owner)) { return; } if (ConfigurationInstance.SayPlayerID) { caller.SendMessage($"Owner ID: {ownerid}"); } if (ConfigurationInstance.SayPlayerCharacterName) { caller.SendMessage($"Character Name: {owner.CharacterName}"); } if (ConfigurationInstance.SayPlayerSteamName) { caller.SendMessage($"Steam Name: {owner.SteamName}"); } if (group != CSteamID.Nil) { if (ConfigurationInstance.SayGroupID) { caller.SendMessage($"Group ID: {owner.SteamGroupID}"); } if (ConfigurationInstance.SayGroupName) { caller.SendMessage($"Group Name: {owner.SteamGroupName}"); } } }
private void OnPlayerDisconnected(CSteamID steamid) { var player = playerManager.GetPlayerByIdAsync(steamid.ToString()).GetAwaiter().GetResult(); PlayerDisconnectedEvent @event = new PlayerDisconnectedEvent(player, null); eventManager.Emit(this, @event); }
private void Events_OnJoinRequested(CSteamID player, ref ESteamRejection?rejection) { Profile SteamProfile = new Profile(ulong.Parse(player.ToString())); bool? vacStatus = SteamProfile.IsVacBanned; string name = SteamProfile.SteamID; if (Instance.Configuration.Instance.Errorkick && (!(vacStatus.HasValue))) { rejection = ESteamRejection.PLUGIN; Logger.LogError(Translate("vacStatus_null", name, player)); } else if (!(vacStatus.HasValue)) { Logger.LogError(Translate("vacStatus_null", name, player)); } else { if ((bool)vacStatus) { rejection = ESteamRejection.AUTH_VAC_BAN; } Logger.Log(Translate((bool)vacStatus ? "vacStatus_true" : "vacStatus_false", name, player)); } }
public byte GetWarnings(CSteamID id) { byte num = 0; try { MySqlConnection mySqlConnection = this.createConnection(); MySqlCommand mySqlCommand = mySqlConnection.CreateCommand(); mySqlCommand.CommandText = string.Concat(new string[] { "select `warninglevel` from `", Zaup_Warning.Instance.Configuration.Instance.TableName, "` where `steamId` = '", id.ToString(), "';" }); mySqlConnection.Open(); object obj = mySqlCommand.ExecuteScalar(); if (obj != null) { byte.TryParse(obj.ToString(), out num); } mySqlConnection.Close(); } catch (Exception exception) { Rocket.Core.Logging.Logger.LogException(exception); } return(num); }
public byte GetWarnings(CSteamID id) { byte num = 0; try { MySqlConnection mySqlConnection = this.createConnection(); MySqlCommand mySqlCommand = mySqlConnection.CreateCommand(); mySqlCommand.CommandText = string.Concat(new string[] { "select `warninglevel` from `", Zaup_Warning.Instance.Configuration.Instance.TableName, "` where `steamId` = '", id.ToString(), "';" }); mySqlConnection.Open(); object obj = mySqlCommand.ExecuteScalar(); if (obj != null) { byte.TryParse(obj.ToString(), out num); } mySqlConnection.Close(); } catch (Exception exception) { Logger.LogException(exception); } return num; }
public ushort GetWarningsTime(CSteamID id) { ushort num = 0; try { MySqlConnection mySqlConnection = this.createConnection(); MySqlCommand mySqlCommand = mySqlConnection.CreateCommand(); mySqlCommand.CommandText = string.Concat(new string[] { "select timestampdiff(day, now(), 'select `lastwarningdate` from `", Zaup_Warning.Instance.Configuration.Instance.TableName, "` where `steamId` = '", id.ToString(), "' ');" }); mySqlConnection.Open(); object obj = mySqlCommand.ExecuteScalar(); if (obj != null) { ushort.TryParse(obj.ToString(), out num); } mySqlConnection.Close(); } catch (Exception exception) { Rocket.Core.Logging.Logger.LogException(exception); } return(num); }
private void OnPlayerConnected(CSteamID steamid) { var player = playerManager.GetPlayerById(steamid.ToString()); PlayerConnectedEvent @event = new PlayerConnectedEvent(player); eventManager.Emit(this, @event); }
public UnturnedUser(IDependencyContainer container, CSteamID id) { Id = id.ToString(); CSteamID = id; Container = container; UserManager = playerManager = container.Resolve <IPlayerManager>(); }
public override void OnEnter() { CSteamID ID = SteamUser.GetSteamID(); steamID.Value = ID.ToString(); Finish(); }
void InitLobby(CSteamID id) { lobby.LobbyID = id; if (Users == null) { lobby.Users = new List <User>(); } else { Users.Clear(); } int num = SteamMatchmaking.GetNumLobbyMembers(lobby.LobbyID); for (int i = 0; i < num; i++) { CSteamID userID = SteamMatchmaking.GetLobbyMemberByIndex(lobby.LobbyID, i); lobby.Users.Add(new User(userID)); } SendPacketToLobby(new byte[] { }, PacketType.Test, EP2PSend.k_EP2PSendReliable, false); #if UNITY_EDITOR Debug.Log("Num members in the lobby: " + num); Debug.Log("My steam ID: " + MyID.ToString()); #endif if (OnLobbyInitializationEvent != null) { OnLobbyInitializationEvent.Invoke(); } }
// Gets player profile picture private async Task <string> GetProfilePictureHashAsync(CSteamID user) { // Gets the Steam API Key from the configuration. var apiKey = m_Configuration["steamWebApiKey"]; // Check if its empty and if so return if (string.IsNullOrEmpty(apiKey)) { return(""); } // Creates new web client. using var web = new WebClient(); // Gets the string using the steam API where the id is the users steam api aswell as using the key var result = await web.DownloadStringTaskAsync( $"http://api.steampowered.com/ISteamUser/GetPlayerSummaries/v2/?key={apiKey}&steamids={user.m_SteamID}"); // Deserializes the json return. var deserialized = JsonConvert.DeserializeObject <PlayerSummaries>(result); // Return the response making it into a avatar hash, which is a industry standard way of storing photo ids stored remoteley by steam. return(deserialized.response.players .FirstOrDefault(k => k.steamid.Equals(user.ToString(), StringComparison.Ordinal))?.avatarhash ?? ""); }
public bool CheckExists(CSteamID id) { try { var connection = CreateConnection(); var command = connection.CreateCommand(); var exists = 0; command.CommandText = "SELECT COUNT(1) FROM `" + FeexHitman.Instance.Configuration.Instance.FeexHitmanDatabase.DatabaseTableName + "` WHERE `steamId` = '" + id.ToString() + "';"; connection.Open(); var result = command.ExecuteScalar(); if (result != null) { int.TryParse(result.ToString(), out exists); } connection.Close(); if (exists == 0) { return(false); } else { return(true); } } catch (Exception ex) { Logger.LogException(ex); return(false); } }
private static async Task <KeyValuePair <string, string> > CheckPair(CSteamID steamP, CSteamID steamG) { var isOnline = PlayerTool.tryGetSteamPlayer(steamP.ToString(), out var player); var nameAndGroup = await RequestUtil.GetNameAndGroup(steamP, steamG); return(new KeyValuePair <string, string>(isOnline ? player.playerID.characterName : nameAndGroup.Key, nameAndGroup.Value)); }
public void AddUpdateVictimAccount(CSteamID id, decimal bounty, string lastDisplayName) { try { var connection = CreateConnection(); var command = connection.CreateCommand(); if (CheckExists(id)) { command.CommandText = "UPDATE `" + FeexHitman.Instance.Configuration.Instance.FeexHitmanDatabase .DatabaseTableName + "` SET `bounty` = bounty + (" + bounty + "), `lastDisplayName` = @lastDisplayName, `lastUpdated` = NOW() WHERE `steamId` = '" + id.ToString() + "';"; } else { command.CommandText = "INSERT IGNORE INTO `" + FeexHitman.Instance.Configuration.Instance.FeexHitmanDatabase .DatabaseTableName + "` (steamId,bounty,lastDisplayName,lastUpdated) VALUES('" + id.ToString() + "','" + bounty + "',@lastDisplayName,NOW());"; } command.Parameters.AddWithValue("@lastDisplayName", lastDisplayName); connection.Open(); var result = command.BeginExecuteNonQuery(); command.EndExecuteNonQuery(result); connection.Close(); } catch (Exception ex) { Logger.LogException(ex); } }
public decimal GetBounty(CSteamID id) { decimal output = 0; try { var connection = CreateConnection(); var command = connection.CreateCommand(); command.CommandText = "SELECT `bounty` FROM `" + FeexHitman.Instance.Configuration.Instance.FeexHitmanDatabase.DatabaseTableName + "` WHERE `steamId` = '" + id.ToString() + "';"; connection.Open(); var result = command.ExecuteScalar(); if (result != null) { decimal.TryParse(result.ToString(), out output); } connection.Close(); } catch (Exception ex) { Logger.LogException(ex); } return(output); }
public override void GetAvatarForPlayerId(GameServiceUserInfo user) { AccountID_t accountId = new AccountID_t(Convert.ToUInt32(user.PlayerId)); CSteamID steamId = new CSteamID(accountId, EUniverse.k_EUniversePublic, EAccountType.k_EAccountTypeIndividual); SteamWebApi.GetSteamUserAvatar(steamId.ToString(), user.SetAvatarFromSprite); }
public void Execute(IRocketPlayer caller, string[] command) { RocketPermissionsManager Permissions = R.Instance.GetComponent<RocketPermissionsManager>(); if (caller != null) { if (command.Length != 1) { UnturnedChat.Say(caller, RocketJobs.Instance.Translate("kick_usage")); return; } else if (command.Length == 1) { UnturnedPlayer Player = (UnturnedPlayer)caller; CSteamID ID = Player.CSteamID; UnturnedPlayer Target = UnturnedPlayer.FromName(command[0].ToLower()); CSteamID TargetID = Target.CSteamID; foreach (PrivateJobs Jobs in RocketJobs.Instance.ConfigPrivJobs) { RocketPermissionsGroup g = Permissions.GetGroup(Jobs.LeaderPermissionGroup); if (g.Members.Exists(k => k == ID.ToString())) { RocketPermissionsGroup Group = Permissions.GetGroup(Jobs.PermissionGroup); if (Group != null && Group.Members.Exists(k => k == TargetID.ToString())) { Permissions.RemovePlayerFromGroup(Group.Id, Target); UnturnedChat.Say(Target, RocketJobs.Instance.Translate("notification_left_job", Jobs.JobName)); UnturnedChat.Say(caller, RocketJobs.Instance.Translate("notification_kicked", Target.DisplayName)); } } } } } }
public bool EditWarning(CSteamID id, short amt = 1) { bool success = false; try { MySqlConnection mySqlConnection = this.createConnection(); MySqlCommand mySqlCommand = mySqlConnection.CreateCommand(); mySqlCommand.CommandText = string.Concat(new string[] { "insert into `" + Zaup_Warning.Instance.Configuration.Instance.TableName + "` (steamId, warninglevel) VALUES ('" + id.ToString() + "', 1) on duplicate key update `warninglevel`=`warninglevel`+ " + amt.ToString() }); mySqlConnection.Open(); int affected = mySqlCommand.ExecuteNonQuery(); mySqlConnection.Close(); if (affected > 0) { success = true; } } catch (Exception exception) { Rocket.Core.Logging.Logger.LogException(exception); } return(success); }
public static bool AskClaimBed_Prefix(BarricadeManager __instance, CSteamID steamID, byte x, byte y, ushort plant, ushort index) { BarricadeRegion barricadeRegion; if (Provider.isServer && BarricadeManager.tryGetRegion(x, y, plant, out barricadeRegion)) { Player player = PlayerTool.getPlayer(steamID); if (player == null) { return(false); } if (player.life.isDead) { return(false); } if (index >= barricadeRegion.drops.Count) { return(false); } if ((barricadeRegion.drops[index].model.transform.position - player.transform.position).sqrMagnitude > 400f) { return(false); } InteractableBed interactableBed = barricadeRegion.drops[index].interactable as InteractableBed; if (interactableBed != null && interactableBed.isClaimable && interactableBed.checkClaim(player.channel.owner.playerID.steamID)) { if (interactableBed.isClaimed) { var home = HomesHelper.GetPlayerHome(steamID, interactableBed); HomesHelper.RemoveHome(steamID, home); home.Unclaim(); } else { var playerData = HomesHelper.GetOrCreatePlayer(steamID); int maxHomes = VipHelper.GetPlayerMaxHomes(steamID.ToString()); if (maxHomes == 1 && playerData.Homes.Count == 1) { foreach (var home in playerData.Homes.ToArray()) { HomesHelper.RemoveHome(steamID, home); home.Unclaim(); } } else if (maxHomes <= playerData.Homes.Count) { UnturnedChat.Say(steamID, MoreHomesPlugin.Instance.Translate("MaxHomesWarn"), MoreHomesPlugin.Instance.MessageColor); return(false); } var playerHome = new PlayerHome(playerData.GetUniqueHomeName(), interactableBed); playerData.Homes.Add(playerHome); playerHome.Claim(steamID); UnturnedChat.Say(steamID, MoreHomesPlugin.Instance.Translate("HomeClaimed", playerHome.Name), MoreHomesPlugin.Instance.MessageColor); } } } return(false); }
public void CheckSetupAccount(CSteamID id) { PlayerBalance bal = GetPlayerBalance(id.ToString()); if (bal == null) { bal = new PlayerBalance() { SteamID = id.ToString(), Balance = pluginInstance.Configuration.Instance.InitialBalance, LastUpdate = DateTime.Now }; data.Add(bal); } bal.SetExperience(id); }
public bool Equals(UnturnedPlayer p) { if (p == null) { return(false); } return(CSteamID.ToString() == p.CSteamID.ToString()); }
public void SteamRequest() { new LogEventRequest() .SetEventKey("steamInitTxn") .SetEventAttribute("steamID", steamID.ToString()) .Send((response) => { GSData scriptData = response.ScriptData; }); }
public void Execute(IRocketPlayer caller, string[] command) { RocketPermissionsManager Permissions = R.Instance.GetComponent <RocketPermissionsManager>(); if (caller != null) { UnturnedPlayer Player = (UnturnedPlayer)caller; CSteamID ID = Player.CSteamID; foreach (PublicJobs Job in RocketJobs.Instance.ConfigPubJobs) { RocketPermissionsGroup Group = Permissions.GetGroup(Job.PermissionGroup); if (Group != null) { foreach (string IDS in Group.Members) { if (IDS == ID.ToString()) { Permissions.RemovePlayerFromGroup(Job.PermissionGroup, caller); UnturnedChat.Say(caller, RocketJobs.Instance.Translate("notification_left_job", Job.JobName)); return; } } } } foreach (PrivateJobs Job in RocketJobs.Instance.ConfigPrivJobs) { RocketPermissionsGroup Group = Permissions.GetGroup(Job.PermissionGroup); if (Group != null) { foreach (string IDS in Group.Members) { if (IDS == ID.ToString()) { Permissions.RemovePlayerFromGroup(Job.PermissionGroup, caller); UnturnedChat.Say(caller, RocketJobs.Instance.Translate("notification_left_job", Job.JobName)); return; } } } } UnturnedChat.Say(caller, RocketJobs.Instance.Translate("error_not_in_a_job")); } }
private void OnLobbyEntered(LobbyEnter_t result) { _steamLobbyID = (CSteamID)result.m_ulSteamIDLobby; Debug.LogFormat("[STEAM] Entered lobby with SteamID {0}", _steamLobbyID.ToString()); if (!BoltNetwork.IsServer && !BoltNetwork.IsClient) { Debug.Log("[BOLT] Starting client ..."); BoltLauncher.StartClient(); } }
public async void Events_OnResourceKill(CSteamID player, ResourceAsset asset) { var instigatorplayer = await m_UnturnedLogRepository.FindPlayerAsync(player.ToString(), UserSearchMode.FindById); var server = await m_UnturnedLogRepository.GetCurrentServerAsync() ?? await m_UnturnedLogRepository.CheckAndRegisterCurrentServerAsync(); var EventTreeCut = EventDatabase.BuildEventData(instigatorplayer, "Resource harvested", " ", server); await m_UnturnedLogRepository.AddPlayerEventAsync(EventTreeCut); }
protected internal UnturnedPlayer(Player player) { Asset = UnturnedPlayerAsset.Instance; State = NullEntityState.Instance; Inventory = new UnturnedPlayerInventory(Player); Transform = new UnityTransform(player.transform); Player = player; SteamPlayer = Player.channel.owner; SteamId = SteamPlayer.playerID.steamID; EntityInstanceId = SteamId.ToString(); }
public void Execute(IRocketPlayer caller, string[] command) { RocketPermissionsManager Permissions = R.Instance.GetComponent <RocketPermissionsManager>(); if (caller != null) { UnturnedPlayer Player = (UnturnedPlayer)caller; CSteamID ID = Player.CSteamID; if (command.Length != 1) { UnturnedChat.Say(caller, RocketJobs.Instance.Translate("accept_usage")); return; } else if (command.Length == 1) { UnturnedPlayer Target = UnturnedPlayer.FromName(command[0].ToLower()); if (RocketJobs.Instance.Applications.ContainsKey(Target.CSteamID)) { string JobName = RocketJobs.Instance.Applications[Target.CSteamID]; foreach (PrivateJobs Job in RocketJobs.Instance.ConfigPrivJobs) { if (Job.JobName.ToLower() == JobName.ToLower()) { RocketPermissionsGroup Group = Permissions.GetGroup(Job.LeaderPermissionGroup); if (Group != null) { foreach (string IDS in Group.Members) { if (IDS == ID.ToString()) { Permissions.AddPlayerToGroup(Job.PermissionGroup, Target); UnturnedChat.Say(caller, RocketJobs.Instance.Translate("notification_accepted_application", Target.CharacterName)); UnturnedChat.Say(Target, RocketJobs.Instance.Translate("notification_quiet_joined_job", Job.JobName)); if (RocketJobs.Instance.Configuration.Instance.AnnounceJobJoin) { UnturnedChat.Say(RocketJobs.Instance.Translate("notification_global_joined_job", Target.CharacterName, Job.JobName)); } return; } } UnturnedChat.Say(caller, RocketJobs.Instance.Translate("error_not_leader_of_job", Job.JobName)); return; } } } UnturnedChat.Say(caller, RocketJobs.Instance.Translate("error_invalid_job_in_storage")); return; } UnturnedChat.Say(caller, RocketJobs.Instance.Translate("error_player_not_applying")); return; } } }
public decimal GetBounty(CSteamID id) { decimal output = 0; try { MySqlConnection connection = CreateConnection(); MySqlCommand command = connection.CreateCommand(); command.CommandText = "SELECT `bounty` FROM `" + FeexHitman.Instance.Configuration.Instance.FeexHitmanDatabase.DatabaseTableName + "` WHERE `steamId` = '" + id.ToString() + "';"; connection.Open(); object result = command.ExecuteScalar(); if (result != null) Decimal.TryParse(result.ToString(), out output); connection.Close(); } catch (Exception ex) { Logger.LogException(ex); } return output; }
public bool CheckAccount(CSteamID id) { try { MySqlConnection connection = CreateConnection(); MySqlCommand command = connection.CreateCommand(); int exists = 0; connection.Open(); command.CommandText = "SELECT COUNT(1) FROM `" + FeexRanks.Instance.Configuration.Instance.FeexRanksDatabase.DatabaseTableName + "` WHERE `steamId` = '" + id.ToString() + "'"; object result = command.ExecuteScalar(); if (result != null) Int32.TryParse(result.ToString(), out exists); connection.Close(); if (exists == 0) { return false; } else { return true; } } catch (Exception ex) { Logger.LogException(ex); return false; } }
public bool RemoveVictimAccount(CSteamID id) { try { MySqlConnection connection = CreateConnection(); MySqlCommand command = connection.CreateCommand(); command.CommandText = "DELETE FROM `" + FeexHitman.Instance.Configuration.Instance.FeexHitmanDatabase.DatabaseTableName + "` WHERE `steamId`='" + id.ToString() + "';"; connection.Open(); IAsyncResult result = command.BeginExecuteNonQuery(); command.EndExecuteNonQuery(result); connection.Close(); return true; } catch (Exception ex) { Logger.LogException(ex); return false; } }
public bool EditWarning(CSteamID id, short amt = 1) { bool success = false; try { MySqlConnection mySqlConnection = this.createConnection(); MySqlCommand mySqlCommand = mySqlConnection.CreateCommand(); mySqlCommand.CommandText = string.Concat(new string[] { "insert into `" + Zaup_Warning.Instance.Configuration.Instance.TableName + "` (steamId, warninglevel) VALUES ('" + id.ToString() + "', 1) on duplicate key update `warninglevel`=`warninglevel`+ " + amt.ToString() }); mySqlConnection.Open(); int affected = mySqlCommand.ExecuteNonQuery(); mySqlConnection.Close(); if (affected > 0) success = true; } catch (Exception exception) { Logger.LogException(exception); } return success; }
public ushort GetWarningsTime(CSteamID id) { ushort num = 0; try { MySqlConnection mySqlConnection = this.createConnection(); MySqlCommand mySqlCommand = mySqlConnection.CreateCommand(); mySqlCommand.CommandText = string.Concat(new string[] { "select timestampdiff(day, now(), 'select `lastwarningdate` from `", Zaup_Warning.Instance.Configuration.Instance.TableName, "` where `steamId` = '", id.ToString(), "' ');" }); mySqlConnection.Open(); object obj = mySqlCommand.ExecuteScalar(); if (obj != null) { ushort.TryParse(obj.ToString(), out num); } mySqlConnection.Close(); } catch (Exception exception) { Logger.LogException(exception); } return num; }
public static void Say(CSteamID CSteamID, string message, Color color) { if (CSteamID == null || CSteamID.ToString() == "0") { System.Console.ForegroundColor = ConsoleColor.Gray; System.Console.WriteLine(message); Logger.Log(message,false); } else { foreach (string m in wrapMessage(message)) { ChatManager.Instance.SteamChannel.send("tellChat", CSteamID, ESteamPacket.UPDATE_UNRELIABLE_BUFFER, new object[] { CSteamID.Nil, (byte)EChatMode.SAY,color, m }); } } }
public void UpdateVictimDisplayName(CSteamID id, string lastDisplayName) { try { MySqlConnection connection = CreateConnection(); MySqlCommand command = connection.CreateCommand(); command.CommandText = "UPDATE `" + FeexHitman.Instance.Configuration.Instance.FeexHitmanDatabase.DatabaseTableName + "` SET `lastDisplayName` = @lastDisplayName WHERE `steamId` = '" + id.ToString() + "';"; command.Parameters.AddWithValue("@lastDisplayName", lastDisplayName); connection.Open(); IAsyncResult result = command.BeginExecuteNonQuery(); command.EndExecuteNonQuery(result); connection.Close(); } catch (Exception ex) { Logger.LogException(ex); } }
public void UpdateDisplayName(CSteamID id, string lastDisplayName) { try { MySqlConnection connection = CreateConnection(); MySqlCommand command = connection.CreateCommand(); command.CommandText = "UPDATE `" + FeexRanks.Instance.Configuration.Instance.FeexRanksDatabase.DatabaseTableName + "` SET `lastDisplayName` = '" + lastDisplayName + "' WHERE `steamId` = '" + id.ToString() + "'"; connection.Open(); command.ExecuteNonQuery(); connection.Close(); } catch (Exception ex) { Logger.LogException(ex); } }
public void UpdateAccount(CSteamID id, int points) { try { MySqlConnection connection = CreateConnection(); MySqlCommand command = connection.CreateCommand(); connection.Open(); command.CommandText = "UPDATE `" + FeexRanks.Instance.Configuration.Instance.FeexRanksDatabase.DatabaseTableName + "` SET `points`=`points`+" + points + " WHERE `steamId`='" + id.ToString() + "'"; command.ExecuteNonQuery(); connection.Close(); } catch (Exception ex) { Logger.LogException(ex); } }
public string[] GetAccountBySteamID(CSteamID id) { string[] output = new string[3]; try { MySqlConnection connection = CreateConnection(); MySqlCommand command = new MySqlCommand("SELECT * FROM `" + FeexRanks.Instance.Configuration.Instance.FeexRanksDatabase.DatabaseViewName + "` WHERE `steamId` = '" + id.ToString() + "'", connection); connection.Open(); MySqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { output[0] = Convert.ToString(dataReader["points"]); output[1] = Convert.ToString(dataReader["currentRank"]); output[2] = Convert.ToString(dataReader["lastDisplayName"]); } dataReader.Close(); connection.Close(); } catch (Exception ex) { Logger.LogException(ex); } return output; }
public static void Say(CSteamID CSteamID, string message, Color color) { if (CSteamID == null || CSteamID.ToString() == "0") { Core.Logging.Logger.Log(message, ConsoleColor.Gray); } else { foreach (string m in wrapMessage(message)) { ChatManager.instance.channel.send("tellChat", CSteamID, ESteamPacket.UPDATE_UNRELIABLE_BUFFER, new object[] { CSteamID.Nil, (byte)EChatMode.SAY,color, m }); } } }