/// <summary> /// Queries the database and finds bans associated with accounts, IPs and UIDs /// </summary> public static Ban checkBan(CS_PlayerLogin <Zone> pkt, InfantryDataContext db, Data.DB.account account, long zoneid) { Ban.BanType type = Ban.BanType.None; DateTime expires = DateTime.Now; //Find all associated bans foreach (Data.DB.ban b in db.bans.Where(b => b.account == account.id || b.IPAddress == pkt.ipaddress || b.uid1 == pkt.UID1 && pkt.UID1 != 0 || b.uid2 == pkt.UID2 && pkt.UID2 != 0 || b.uid3 == pkt.UID3 && pkt.UID3 != 0 || b.name == pkt.alias)) { //Is it the correct zone? if (b.zone != null && (b.type == (int)Ban.BanType.ZoneBan && b.zone != zoneid)) { continue; } //Find the highest level ban that hasn't expired yet if (b.type > (int)type && b.expires > expires) { //Set it as our current ban type expires = b.expires; type = (Ban.BanType)b.type; } } return(new Ban(type, expires)); }
/// <summary> /// Handles the zone login request packet /// </summary> static public void Handle_CS_PlayerLogin(CS_PlayerLogin <Zone> pkt, Zone zone) { //Make a note Log.write(TLog.Inane, "Player login request for '{0}' on '{1}'", pkt.alias, zone); SC_PlayerLogin <Zone> plog = new SC_PlayerLogin <Zone>(); plog.player = pkt.player; if (String.IsNullOrWhiteSpace(pkt.alias)) { plog.bSuccess = false; plog.loginMessage = "Please enter an alias."; zone._client.send(plog); return; } //Are they using the launcher? if (String.IsNullOrWhiteSpace(pkt.ticketid)) { //They're trying to trick us, jim! plog.bSuccess = false; plog.loginMessage = "Please use the Infantry launcher to run the game."; zone._client.send(plog); return; } if (pkt.ticketid.Contains(':')) { //They're using the old, outdated launcher plog.bSuccess = false; plog.loginMessage = "Please use the updated launcher from the website."; zone._client.send(plog); return; } using (InfantryDataContext db = zone._server.getContext()) { Data.DB.player player = null; Data.DB.account account = db.accounts.SingleOrDefault(acct => acct.ticket.Equals(pkt.ticketid)); if (account == null) { //They're trying to trick us, jim! plog.bSuccess = false; plog.loginMessage = "Your session id has expired. Please re-login."; zone._client.send(plog); return; } //Is there already a player online under this account? if (!DBServer.bAllowMulticlienting && zone._server._zones.Any(z => z.hasAccountPlayer(account.id))) { plog.bSuccess = false; plog.loginMessage = "Account is currently in use."; zone._client.send(plog); return; } //Check for IP and UID bans Logic_Bans.Ban banned = Logic_Bans.checkBan(pkt, db, account, zone._zone.id); if (banned.type == Logic_Bans.Ban.BanType.GlobalBan) { //We don't respond to globally banned player requests plog.bSuccess = false; plog.loginMessage = "Banned."; Log.write(TLog.Warning, "Failed login: "******" Alias: " + pkt.alias + " Reason: " + banned.type.ToString()); zone._client.send(plog); return; } if (banned.type == Logic_Bans.Ban.BanType.IPBan) { //Their IP has been banned, make something up! plog.bSuccess = false; plog.loginMessage = "You have been temporarily suspended until " + banned.expiration.ToString("f", CultureInfo.CreateSpecificCulture("en-US")); Log.write(TLog.Warning, "Failed login: "******" Alias: " + pkt.alias + " Reason: " + banned.type.ToString()); zone._client.send(plog); return; } if (banned.type == Logic.Logic_Bans.Ban.BanType.ZoneBan) { //They've been blocked from entering the zone, tell them how long they've got left on their ban plog.bSuccess = false; plog.loginMessage = "You have been temporarily suspended from this zone until " + banned.expiration.ToString("f", CultureInfo.CreateSpecificCulture("en-US")); Log.write(TLog.Warning, "Failed login: "******" Alias: " + pkt.alias + " Reason: " + banned.type.ToString()); zone._client.send(plog); return; } if (banned.type == Logic.Logic_Bans.Ban.BanType.AccountBan) { //They've been blocked from entering any zone, tell them when to come back plog.bSuccess = false; plog.loginMessage = "Your account has been temporarily suspended until " + banned.expiration.ToString("f", CultureInfo.CreateSpecificCulture("en-US")); Log.write(TLog.Warning, "Failed login: "******" Alias: " + pkt.alias + " Reason: " + banned.type.ToString()); zone._client.send(plog); return; } //They made it! //We have the account associated! plog.permission = (PlayerPermission)account.permission; if (account.permission > (int)PlayerPermission.Sysop) { plog.permission = PlayerPermission.Sysop; } //Attempt to find the related alias Data.DB.alias alias = db.alias.SingleOrDefault(a => a.name.Equals(pkt.alias)); Data.DB.stats stats = null; //Is there already a player online under this alias? if (alias != null && zone._server._zones.Any(z => z.hasAliasPlayer(alias.id))) { plog.bSuccess = false; plog.loginMessage = "Alias is currently in use."; zone._client.send(plog); return; } if (alias == null && !pkt.bCreateAlias) { //Prompt him to create a new alias if he has room if (account.alias.Count < 30) { //He has space! Prompt him to make a new alias plog.bSuccess = false; plog.bNewAlias = true; zone._client.send(plog); return; } else { plog.bSuccess = false; plog.loginMessage = "Your account has reached the maximum number of aliases allowed."; zone._client.send(plog); return; } } else if (alias == null && pkt.bCreateAlias) { //We want to create a new alias! alias = new InfServer.Data.DB.alias(); alias.name = pkt.alias; alias.creation = DateTime.Now; alias.account1 = account; alias.IPAddress = pkt.ipaddress; alias.lastAccess = DateTime.Now; alias.timeplayed = 0; db.alias.InsertOnSubmit(alias); Log.write(TLog.Normal, "Creating new alias '{0}' on account '{1}'", pkt.alias, account.name); } else if (alias != null) { //We can't recreate an existing alias or login to one that isn't ours.. if (pkt.bCreateAlias || alias.account1 != account) { plog.bSuccess = false; plog.loginMessage = "The specified alias already exists."; zone._client.send(plog); return; } } //Do we have a player row for this zone? player = db.players.SingleOrDefault( plyr => plyr.alias1 == alias && plyr.zone1 == zone._zone); if (player == null) { //We need to create another! Log.write(TLog.Normal, "Player doesn't exist, creating another structure"); player = new InfServer.Data.DB.player(); player.squad1 = null; player.zone = zone._zone.id; player.alias1 = alias; player.lastAccess = DateTime.Now; player.permission = 0; //Create a blank stats row stats = new InfServer.Data.DB.stats(); stats.zone = zone._zone.id; player.stats1 = stats; db.stats.InsertOnSubmit(stats); db.players.InsertOnSubmit(player); //It's a first-time login, so no need to load stats plog.bFirstTimeSetup = true; } else { //Load the player details and stats! plog.banner = player.banner; if (account.id == 17 && alias.name.ToLower().Contains("hoto")) { plog.permission = 0; } else { plog.permission = (PlayerPermission)Math.Max(player.permission, (int)plog.permission); } if (player.permission > account.permission) { //He's a dev here, set the bool plog.developer = true; } //Check for admin if (Logic_Admins.checkAdmin(alias.name)) { plog.admin = true; } plog.squad = (player.squad1 == null) ? "" : player.squad1.name; if (player.squad1 != null) { plog.squadID = player.squad1.id; } stats = player.stats1; plog.stats.zonestat1 = stats.zonestat1; plog.stats.zonestat2 = stats.zonestat2; plog.stats.zonestat3 = stats.zonestat3; plog.stats.zonestat4 = stats.zonestat4; plog.stats.zonestat5 = stats.zonestat5; plog.stats.zonestat6 = stats.zonestat6; plog.stats.zonestat7 = stats.zonestat7; plog.stats.zonestat8 = stats.zonestat8; plog.stats.zonestat9 = stats.zonestat9; plog.stats.zonestat10 = stats.zonestat10; plog.stats.zonestat11 = stats.zonestat11; plog.stats.zonestat12 = stats.zonestat12; plog.stats.kills = stats.kills; plog.stats.deaths = stats.deaths; plog.stats.killPoints = stats.killPoints; plog.stats.deathPoints = stats.deathPoints; plog.stats.assistPoints = stats.assistPoints; plog.stats.bonusPoints = stats.bonusPoints; plog.stats.vehicleKills = stats.vehicleKills; plog.stats.vehicleDeaths = stats.vehicleDeaths; plog.stats.playSeconds = stats.playSeconds; plog.stats.cash = stats.cash; plog.stats.inventory = new List <PlayerStats.InventoryStat>(); plog.stats.experience = stats.experience; plog.stats.experienceTotal = stats.experienceTotal; plog.stats.skills = new List <PlayerStats.SkillStat>(); //Convert the binary inventory/skill data if (player.inventory != null) { DBHelpers.binToInventory(plog.stats.inventory, player.inventory); } if (player.skills != null) { DBHelpers.binToSkills(plog.stats.skills, player.skills); } } //Rename him plog.alias = alias.name; //Try and submit any new rows before we try and use them try { db.SubmitChanges(); } catch (Exception e) { plog.bSuccess = false; plog.loginMessage = "Unable to create new player / alias, please try again."; Log.write(TLog.Exception, "Exception adding player or alias to DB: {0}", e); zone._client.send(plog); return; } //Add them if (zone.newPlayer(pkt.player.id, alias.name, player)) { plog.bSuccess = true; Log.write("Player '{0}' logged into zone '{1}'", alias.name, zone._zone.name); //Modify his alias IP address and access times alias.IPAddress = pkt.ipaddress.Trim(); alias.lastAccess = DateTime.Now; //Change it db.SubmitChanges(); } else { plog.bSuccess = false; plog.loginMessage = "Unknown login failure."; Log.write("Failed adding player '{0}' from '{1}'", alias.name, zone._zone.name); } //Give them an answer zone._client.sendReliable(plog); } }
/// <summary> /// Handles a query packet /// </summary> static public void Handle_CS_ModQuery(CS_ModQuery <Zone> pkt, Zone zone) { using (InfantryDataContext db = zone._server.getContext()) { switch (pkt.queryType) { case CS_ModQuery <Zone> .QueryType.aliastransfer: { if (string.IsNullOrEmpty(pkt.query) || string.IsNullOrEmpty(pkt.aliasTo)) { zone._server.sendMessage(zone, pkt.sender, "Wrong format typed."); return; } //Who the alias is going to Data.DB.alias paliasTo = db.alias.FirstOrDefault(aTo => string.Compare(aTo.name, pkt.aliasTo, true) == 0); if (paliasTo == null) { zone._server.sendMessage(zone, pkt.sender, "Cant find the recipient's alias."); return; } //The alias in question Data.DB.alias alias = db.alias.FirstOrDefault(a => string.Compare(a.name, pkt.query, true) == 0); Data.DB.player playerA = db.players.FirstOrDefault(p => string.Compare(p.alias1.name, pkt.query, true) == 0); if (alias == null) { zone._server.sendMessage(zone, pkt.sender, "Can't find the alias in question, maybe its not created yet."); return; } if (playerA == null) { //Since structure doesn't exist, go ahead and transfer alias.IPAddress = paliasTo.IPAddress.Trim(); alias.timeplayed = 0; alias.account = paliasTo.account; alias.account1 = paliasTo.account1; db.SubmitChanges(); zone._server.sendMessage(zone, pkt.sender, "Alias transfer completed."); return; } //Check for a squad if (playerA.squad != null) { IQueryable <Data.DB.player> squadmates = db.players.Where(plyr => plyr.zone == playerA.zone && plyr.squad != null && plyr.squad == playerA.squad); if (playerA.squad1.owner == playerA.id) { if (squadmates.Count() > 1) { Data.DB.player temp = squadmates.FirstOrDefault(p => p.id != playerA.id); //Since the player is the owner, lets just give it to someone else temp.squad1.owner = temp.id; } else if (squadmates.Count() == 1) { //Lets delete the squad db.squads.DeleteOnSubmit(playerA.squad1); db.SubmitChanges(); } } playerA.squad1 = null; playerA.squad = null; } //Lets delete stats/player structures //Note: the server will treat this as a new alias and create structures db.stats.DeleteOnSubmit(playerA.stats1); db.players.DeleteOnSubmit(playerA); //Now lets transfer alias.IPAddress = paliasTo.IPAddress.Trim(); alias.timeplayed = 0; alias.account = paliasTo.account; alias.account1 = paliasTo.account1; db.SubmitChanges(); zone._server.sendMessage(zone, pkt.sender, "Alias transfer completed."); } break; case CS_ModQuery <Zone> .QueryType.aliasremove: { if (string.IsNullOrEmpty(pkt.query)) { zone._server.sendMessage(zone, pkt.sender, "Wrong format typed."); return; } //Lets get all account related info then delete it Data.DB.alias palias = db.alias.FirstOrDefault(a => string.Compare(a.name, pkt.query, true) == 0); Data.DB.player player = db.players.FirstOrDefault(p => string.Compare(p.alias1.name, pkt.query, true) == 0); if (palias == null) { zone._server.sendMessage(zone, pkt.sender, "Cannot find the specified alias."); return; } if (player == null) { zone._server.sendMessage(zone, pkt.sender, "Cannot find the specified player."); return; } //Check for a squad if (player.squad != null) { IQueryable <Data.DB.player> squadmates = db.players.Where(plyr => plyr.zone == player.zone && plyr.squad != null && plyr.squad == player.squad); if (player.squad1.owner == player.id) { if (squadmates.Count() > 1) { Data.DB.player temp = squadmates.FirstOrDefault(p => p.id != player.id); //Since the player is the owner, lets just give it to someone else temp.squad1.owner = temp.id; } else if (squadmates.Count() == 1) { //Lets delete the squad db.squads.DeleteOnSubmit(player.squad1); } db.SubmitChanges(); } player.squad1 = null; player.squad = null; } //Now lets remove stats db.stats.DeleteOnSubmit(player.stats1); //Next the player structure db.players.DeleteOnSubmit(player); //Finally the alias db.alias.DeleteOnSubmit(palias); db.SubmitChanges(); zone._server.sendMessage(zone, pkt.sender, "Alias has been deleted."); } break; case CS_ModQuery <Zone> .QueryType.aliasrename: { if (string.IsNullOrEmpty(pkt.query)) { zone._server.sendMessage(zone, pkt.sender, "Wrong format typed."); return; } //Get all account related info Data.DB.alias paliasTo = db.alias.FirstOrDefault(aTo => string.Compare(aTo.name, pkt.aliasTo, true) == 0); Data.DB.alias alias = db.alias.FirstOrDefault(a => string.Compare(a.name, pkt.query, true) == 0); //Player even alive? if (paliasTo == null) { zone._server.sendMessage(zone, pkt.sender, "Cannot find the specified alias."); return; } string name = paliasTo.name; //Does the payload already exist? if (alias == null) { paliasTo.name = pkt.query; db.SubmitChanges(); zone._server.sendMessage(zone, pkt.sender, "Renamed player " + name + " to " + pkt.query + " has been completed."); return; } if (alias.account1 != paliasTo.account1) { zone._server.sendMessage(zone, pkt.sender, "That alias is already being used."); return; } if (alias.id != paliasTo.id) { zone._server.sendMessage(zone, pkt.sender, "Cannot change an alias to one already existing on the account."); return; } paliasTo.name = pkt.query; db.SubmitChanges(); zone._server.sendMessage(zone, pkt.sender, "Renamed player " + name + " to " + pkt.query + " has been completed."); } break; case CS_ModQuery <Zone> .QueryType.mod: { if (string.IsNullOrEmpty(pkt.query)) { zone._server.sendMessage(zone, pkt.sender, "Wrong format typed."); return; } //Lets get all account related info Data.DB.alias palias = db.alias.FirstOrDefault(a => string.Compare(a.name, pkt.query, true) == 0); Data.DB.account account = db.accounts.FirstOrDefault(p => p.id == palias.account1.id); if (palias == null) { zone._server.sendMessage(zone, pkt.sender, "Cannot find the specified alias."); return; } if (account == null) { zone._server.sendMessage(zone, pkt.sender, "Cannot find the specified account."); return; } //Lets mod/de-mod them account.permission = pkt.level; db.SubmitChanges(); zone._server.sendMessage(zone, pkt.sender, "Changing player " + palias.name + "'s level to " + pkt.level + " has been completed."); } break; case CS_ModQuery <Zone> .QueryType.dev: { if (string.IsNullOrEmpty(pkt.query)) { zone._server.sendMessage(zone, pkt.sender, "Wrong format typed."); return; } //Lets get all account related info Data.DB.player player = (from plyr in db.players where string.Compare(plyr.alias1.name, pkt.query, true) == 0 && plyr.zone1 == zone._zone select plyr).FirstOrDefault(); if (player == null) { zone._server.sendMessage(zone, pkt.sender, "Cannot find the specified alias."); return; } //Lets mod/de-mod them player.permission = (short)pkt.level; db.SubmitChanges(); zone._server.sendMessage(zone, pkt.sender, "Changing player " + player.alias1.name + "'s dev level to " + pkt.level + " has been completed."); } break; case CS_ModQuery <Zone> .QueryType.squadtransfer: { if (string.IsNullOrEmpty(pkt.aliasTo) || string.IsNullOrEmpty(pkt.query)) { zone._server.sendMessage(zone, pkt.sender, "Wrong format typed."); return; } //Lets find the player first Data.DB.player dbplayer = db.zones.First(z => z.id == zone._zone.id).players.FirstOrDefault(p => string.Compare(p.alias1.name, pkt.aliasTo, true) == 0); if (dbplayer == null) { zone._server.sendMessage(zone, pkt.sender, "Cannot find the player."); return; } //Lets find the squad in question Data.DB.squad squad = db.squads.First(s => string.Compare(s.name, pkt.query, true) == 0 && s.zone == zone._zone.id); if (squad == null) { zone._server.sendMessage(zone, pkt.sender, "Cannot find the specified squad."); return; } //Are they in a squad? if (dbplayer.squad != null) { //Is it the same squad? if (dbplayer.squad != squad.id) { zone._server.sendMessage(zone, pkt.sender, "That player isn't on the same squad."); return; } //Transfer dbplayer.squad1.owner = dbplayer.id; } else { dbplayer.squad = squad.id; dbplayer.squad1.owner = dbplayer.id; } db.SubmitChanges(); zone._server.sendMessage(zone, dbplayer.alias1.name, "You have been promoted to squad captain of " + dbplayer.squad1.name); zone._server.sendMessage(zone, dbplayer.alias1.name, "Please relog to complete the process."); zone._server.sendMessage(zone, pkt.sender, "Squad transferring is complete."); } break; case CS_ModQuery <Zone> .QueryType.squadjoin: { if (string.IsNullOrWhiteSpace(pkt.aliasTo) || string.IsNullOrWhiteSpace(pkt.query)) { zone._server.sendMessage(zone, pkt.sender, "Wrong format typed."); return; } //Lets find the player first Data.DB.player dbplayer = db.zones.First(z => z.id == zone._zone.id).players.FirstOrDefault(p => string.Compare(p.alias1.name, pkt.aliasTo, true) == 0); if (dbplayer == null) { zone._server.sendMessage(zone, pkt.sender, "Cannot find the player."); return; } //Lets find the squad in question Data.DB.squad squad = db.squads.FirstOrDefault(s => string.Compare(s.name, pkt.query, true) == 0 && s.zone == zone._zone.id); if (squad == null) { zone._server.sendMessage(zone, pkt.sender, "Cannot find the specified squad."); return; } //Already squad joined somewhere? if (dbplayer.squad != null) { //Get his squad brothers! (if any...) IQueryable <Data.DB.player> squadmates = db.players.Where(p => p.zone == dbplayer.zone && p.squad != null && p.squad == dbplayer.squad); //Is he the captain? if (dbplayer.squad1.owner == dbplayer.id) { //We might need to dissolve the team! if (squadmates.Count() == 1) { //He's the only one left on the squad... dissolve it! db.squads.DeleteOnSubmit(dbplayer.squad1); db.SubmitChanges(); dbplayer.squad1 = null; dbplayer.squad = null; } else { //There are other people on the squad, transfer it to someone Data.DB.player transferPlayer = squadmates.FirstOrDefault(p => p.id != dbplayer.id); dbplayer.squad1.owner = transferPlayer.id; db.SubmitChanges(); zone._server.sendMessage(zone, transferPlayer.alias1.name, "You have been promoted to squad captain of " + transferPlayer.squad1.name); } } } dbplayer.squad = squad.id; db.SubmitChanges(); zone._server.sendMessage(zone, dbplayer.alias1.name, "You have joined " + squad.name); zone._server.sendMessage(zone, dbplayer.alias1.name, "Please relog to complete the process."); zone._server.sendMessage(zone, pkt.sender, "Squad joining completed."); } break; case CS_ModQuery <Zone> .QueryType.powered: { if (string.IsNullOrWhiteSpace(pkt.query)) { zone._server.sendMessage(zone, pkt.sender, "Payload cannot be empty."); return; } if (pkt.query.Equals("list")) { Data.DB.player sender = db.players.FirstOrDefault(p => string.Compare(p.alias1.name, pkt.sender, true) == 0 && p.zone == zone._zone.id); if (sender == null) { return; } SortedDictionary <string, string> powered = new SortedDictionary <string, string>(); string pAlias; foreach (Zone z in zone._server._zones) { foreach (KeyValuePair <int, Zone.Player> Player in z._players) { pAlias = Player.Value.alias; var alias = db.alias.SingleOrDefault(p => string.Compare(p.name, pAlias, true) == 0); if (alias == null) { continue; } if (alias.name == pkt.sender) { continue; } //Are they a global mod? if (alias.account1.permission > 0) { //Are they higher than us? if (alias.account1.permission > sender.alias1.account1.permission && alias.account1.permission > sender.permission) { continue; } powered.Add(pAlias, string.Format("*{0} - Lvl({1})", pAlias, alias.account1.permission.ToString())); } else { var player = db.zones.First(zones => zones.id == z._zone.id).players.First(p => p.alias1 == alias); if (player != null && player.permission > 0) { //Are they higher than us? if (player.permission > sender.permission && player.alias1.account1.permission > sender.alias1.account1.permission) { continue; } powered.Add(pAlias, string.Format("*{0} - Lvl({1})(dev)", pAlias, player.permission.ToString())); } } } } //Now send it! if (powered.Count > 0) { foreach (string str in powered.Values) { zone._server.sendMessage(zone, pkt.sender, str); } } else { zone._server.sendMessage(zone, pkt.sender, "Empty."); } } } break; case CS_ModQuery <Zone> .QueryType.find: { zone._server.sendMessage(zone, pkt.sender, "&Search Results:"); Data.DB.alias alias = db.alias.SingleOrDefault(ali => string.Compare(ali.name, pkt.query, true) == 0); if (alias == null) { zone._server.sendMessage(zone, pkt.sender, "Cannot find the specified alias."); return; } bool found = false; IQueryable <Data.DB.alias> foundAlias = db.alias.Where(d => (d.IPAddress.Equals(alias.IPAddress) || d.account == alias.account)); foreach (KeyValuePair <string, Zone.Player> player in zone._server._players) { foreach (Data.DB.alias p in foundAlias) { if (player.Value.alias.Equals(p.name)) { zone._server.sendMessage(zone, pkt.sender, string.Format("*Found: {0} Zone: {1} Arena: {2}", p.name, player.Value.zone._zone.name, !String.IsNullOrWhiteSpace(player.Value.arena) ? player.Value.arena : "Unknown Arena")); found = true; } } } if (!found) { zone._server.sendMessage(zone, pkt.sender, "Cannot find the specified alias."); } } break; } } }