/// <summary>
/// Gets an inventory for a specific player.
/// </summary>
/// <param name="playerId">The player id.</param>
/// <returns>A list of the inventory items.</returns>
public static List <DbOwnerItem> GetInventory(int playerId)
{
var pars = Sql.GetParsDict();
pars.Add("PlayerId", playerId);
return(SqlDalHelper.GetAll <DbOwnerItem>(ConnectionStrings.World,
string.Format("SELECT * FROM Inventories WHERE {0} AND [Deleted] = 'False'", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets a list of all guild warehouse items.
/// </summary>
/// <param name="guildId">The guild id.</param>
/// <returns>A list of all guild warehouse items.</returns>
public static List <DbOwnerItem> GetGuildWarehouseItems(int guildId)
{
var pars = Sql.GetParsDict();
pars.Add("PlayerId", guildId);
return(SqlDalHelper.GetAll <DbOwnerItem>(ConnectionStrings.World,
string.Format("SELECT * FROM GuildWarehouses WHERE {0} AND [Deleted] = 'False'", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets all monster spawns.
/// </summary>
/// <param name="server">The server associated with the spawns.</param>
/// <returns>A list of all spawns tied to the specific server.</returns>
public static List <Models.DbMonsterSpawn> GetAllSpawns(string server)
{
var pars = Sql.GetParsDict();
pars.Add("Server", server);
return(SqlDalHelper.GetAll <Models.DbMonsterSpawn>(ConnectionStrings.World,
string.Format("SELECT * FROM MonsterSpawns", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets all maps by a server.
/// </summary>
/// <param name="server">The server</param>
/// <returns>All maps associated with the server.</returns>
public static List <DbMap> GetAllByServer(string server)
{
var pars = Sql.GetParsDict();
pars.Add("Server", server);
return(SqlDalHelper.GetAll <DbMap>(ConnectionStrings.World,
string.Format("SELECT * FROM Maps WHERE {0} OR Server = 'All'", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets all arena qualifier informations.
/// </summary>
/// <param name="server">The server.</param>
/// <returns>A list of all arena qualifier informations.</returns>
public static List <Models.DbPlayerArenaQualifier> GetAll(string server)
{
var pars = Sql.GetParsDict();
pars.Add("Server", server);
return(SqlDalHelper.GetAll <Models.DbPlayerArenaQualifier>(ConnectionStrings.World,
string.Format("SELECT * FROM PlayerArenaQualifiers WHERE {0}", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets a list of all employees, tied to a specific organization.
/// </summary>
/// <param name="orgId">The org id.</param>
/// <returns>A list of all employees tied to the specific organization.</returns>
internal static List <Employee> GetAllEmployees(int orgId)
{
var pars = Sql.GetParsDict();
pars.Add("orgId", orgId);
return(SqlDalHelper.GetAll <Employee>(Helpers.SqlTests.ConnectionString,
string.Format("SELECT * FROM Employees WHERE {0}", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets all houses associated with a player.
/// </summary>
/// <param name="playerId">The player id.</param>
/// <returns>A list of all associated houses.</returns>
public static List <Models.DbPlayerHouse> GetAll(int playerId)
{
var pars = Sql.GetParsDict();
pars.Add("PlayerId", playerId);
return(SqlDalHelper.GetAll <Models.DbPlayerHouse>(ConnectionStrings.World,
string.Format("SELECT * FROM PlayerHouses WHERE {0}", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets an organization by id.
/// </summary>
/// <param name="orgId">The org id.</param>
/// <returns>The organization.</returns>
internal static Organization GetOrganizationById(int orgId)
{
var pars = Sql.GetParsDict();
pars.Add("Id", orgId);
return(SqlDalHelper.Get <Organization>(Helpers.SqlTests.ConnectionString,
string.Format("SELECT * FROM Organizations WHERE {0}", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets a list of all guilds.
/// </summary>
/// <param name="serverName">The server associated with the guilds.</param>
/// <returns>A list of the guilds.</returns>
public static List <DbGuild> GetAll(string serverName)
{
var pars = Sql.GetParsDict();
pars.Add("Server", serverName);
return(SqlDalHelper.GetAll <DbGuild>(ConnectionStrings.World,
string.Format("SELECT * FROM Guilds WHERE {0}", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets all spells for a player.
/// </summary>
/// <param name="playerId">The player id.</param>
/// <param name="type">The spell type (Skill or Proficiency)</param>
/// <returns>A list of all spells.</returns>
private static List <Models.DbSpell> GetAll(int playerId, string type)
{
var pars = Sql.GetParsDict();
pars.Add("PlayerId", playerId);
pars.Add("Type", type);
return(SqlDalHelper.GetAll <Models.DbSpell>(ConnectionStrings.World,
string.Format("SELECT * FROM Spells WHERE {0}", Sql.GetSel(pars)),
pars));
}
public static User GetUserByUserNameAndPassword(string userName, string password)
{
var pars = Sql.GetParsDict();
pars.Add("userName", userName);
pars.Add("password", password);
return(SqlDalHelper.Get <User>(Helpers.SqlHelper.ConnectionString,
string.Format("SELECT * FROM Users WHERE {0}", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets a list of all drops.
/// </summary>
/// <param name="mapId">The map id.</param>
/// <param name="server">The server.</param>
/// <returns>The list of drops.</returns>
public static List <Models.DbDrop> GetAll(int mapId, string server)
{
var pars = Sql.GetParsDict();
pars.Add("MapId", mapId);
pars.Add("Server", server);
return(SqlDalHelper.GetAll <Models.DbDrop>(ConnectionStrings.World,
string.Format("SELECT * FROM Drops WHERE {0}", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets an employee based on a social security number, tied to a specific organization.
/// </summary>
/// <param name="orgId">The org id of the employee.</param>
/// <param name="socialSecurityNumber">The social security number of the employee.</param>
/// <returns>The employee if existing, null otherwise.</returns>
internal static Employee GetEmployeeBySocialSecurityNumber(int orgId, string socialSecurityNumber)
{
var pars = Sql.GetParsDict();
pars.Add("OrgId", orgId);
pars.Add("SSN", socialSecurityNumber);
return(SqlDalHelper.Get <Employee>(Helpers.SqlTests.ConnectionString,
string.Format("SELECT * FROM Employees WHERE {0}", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets a list of all associations by a specific association type.
/// </summary>
/// <param name="guildId">The guild.</param>
/// <param name="associationType">The association type.</param>
/// <returns>A list of the associations.</returns>
public static List <DbGuildAssociation> GetAllAssociations(int guildId, string associationType)
{
var pars = Sql.GetParsDict();
pars.Add("GuildId", guildId);
pars.Add("AssociationType", associationType);
return(SqlDalHelper.GetAll <DbGuildAssociation>(ConnectionStrings.World,
string.Format("SELECT * FROM GuildAssociations WHERE {0}", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets all whispers by a recipent.
/// </summary>
/// <param name="to">The recipent.</param>
/// <param name="server">The server of the recipent.</param>
/// <returns>A list of all whispers.</returns>
public static List <Models.DbWhisper> GetAllByRecipent(string to, string server)
{
var pars = Sql.GetParsDict();
pars.Add("To", to);
pars.Add("Server", server);
return(SqlDalHelper.GetAll <Models.DbWhisper>(ConnectionStrings.World,
string.Format("SELECT * FROM WhisperCache WHERE {0}", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets all npcs tied to a server.
/// </summary>
/// <param name="server">The server.</param>
/// <returns>A list of all the npcs.</returns>
public static List <DbNpc> GetAll(string server)
{
var pars = Sql.GetParsDict();
pars.Add("Server", server);
pars.Add("AllServers", "All");
return(SqlDalHelper.GetAll <DbNpc>(ConnectionStrings.World,
"SELECT * FROM NPCs WHERE Server = @Server OR Server = @AllServers",
pars));
}
/// <summary>
/// Gets a specific user based on an organization, username and password.
/// </summary>
/// <param name="orgId">The org id.</param>
/// <param name="userName">The username.</param>
/// <param name="password">The password.</param>
/// <returns>The user if found, null otherwise.</returns>
internal static User GetByUserNameAndPassword(int orgId, string userName, string password)
{
var pars = Sql.GetParsDict();
pars.Add("OrgId", orgId);
pars.Add("UserName", userName);
pars.Add("Password", password);
return(SqlDalHelper.Get <User>(Helpers.SqlTests.ConnectionString,
string.Format("SELECT * FROM Users WHERE {0}", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Checks whether a player has a guild or not.
/// </summary>
/// <param name="playerId">The player id.</param>
/// <param name="guildId">The guild id.</param>
/// <returns>True if the player has a guild.</returns>
public static bool HasGuild(int playerId, out int guildId)
{
var pars = Sql.GetParsDict();
pars.Add("PlayerId", playerId);
var dbGuildRank = SqlDalHelper.Get <DbGuildRank>(ConnectionStrings.World,
string.Format("SELECT * FROM GuildRanks WHERE {0}", Sql.GetSel(pars)),
pars);
if (dbGuildRank == null)
{
guildId = 0;
return(false);
}
else
{
guildId = dbGuildRank.GuildId;
return(true);
}
}
/// <summary>
/// Gets a player by authentication.
/// </summary>
/// <param name="authKey">The auth key.</param>
/// <param name="ip">The ip from where the authentication is done.</param>
/// <returns>The player if existing, null otherwise.</returns>
public static DbPlayer GetPlayerByAuthentication(string authKey, string server, string ip)
{
var pars = Sql.GetParsDict();
pars.Add("Server", server);
return(SqlDalHelper.GetAll <DbPlayer>(ConnectionStrings.World,
string.Format("SELECT * FROM Players WHERE {0}", Sql.GetSel(pars)),
pars)
.Where(p => {
if (p == null || p.Account == null)
{
return false;
}
if (p.Account.LastIP != ip)
{
return false;
}
if (string.IsNullOrWhiteSpace(p.Account.LastAuthKey))
{
return false;
}
var lastAuthKey = p.Account.LastAuthKey.Split(';');
if (lastAuthKey.Length != 2)
{
return false;
}
if (lastAuthKey[0] != authKey)
{
return false;
}
if (DateTime.Now >= DateTime.FromBinary(long.Parse(lastAuthKey[1])).AddMinutes(10))
{
return false;
}
return true;
})
.FirstOrDefault());
}
/// <summary>
/// Gets a list of all members in a guild.
/// </summary>
/// <param name="guildId">The guild id.</param>
/// <returns>A list of the members.</returns>
public static List <DbGuildRank> GetAllMembers(int guildId)
{
var pars = Sql.GetParsDict();
pars.Add("GuildId", guildId);
return(SqlDalHelper.GetAll <DbGuildRank>(ConnectionStrings.World,
string.Format("SELECT * FROM GuildRanks WHERE {0}", Sql.GetSel(pars)),
pars)
.Where(member =>
{
var player = Players.GetPlayerById(member.PlayerId);
if (player != null && !string.IsNullOrWhiteSpace(player.Name) && player.Level.HasValue)
{
member.PlayerName = player.Name;
member.PlayerLevel = player.Level.Value;
return true;
}
return false;
}).ToList());
}
/// <summary>
/// Gets a list of all guards.
/// </summary>
/// <returns>Gets a list of all guard spawns.</returns>
public static List <Models.DbGuard> GetAllGuards()
{
return(SqlDalHelper.GetAll <Models.DbGuard>(ConnectionStrings.World,
"SELECT * FROM Guards",
null));
}
/// <summary>
/// Gets all default coordinates.
/// </summary>
/// <returns>A list of all the default coordinates.</returns>
internal static List <DbDefaultCoordinate> GetAll()
{
return(SqlDalHelper.GetAll <DbDefaultCoordinate>(ConnectionStrings.World,
"SELECT * FROM DefaultCoordinates",
null));
}
/// <summary>
/// Gets a list of all organization.
/// </summary>
/// <returns>The list of organizations.</returns>
internal static List <Organization> GetAllOrganizations()
{
return(SqlDalHelper.GetAll <Organization>(Helpers.SqlTests.ConnectionString,
"SELECT * FROM Organizations",
null));
}
/// <summary>
/// Gets an account.
/// </summary>
/// <param name="pars">The parameters.</param>
/// <returns>The account if found, null otherwise.</returns>
private static DbAccount Get(Dictionary <string, object> pars)
{
return(SqlDalHelper.Get <DbAccount>(ConnectionStrings.Auth,
string.Format("SELECT * FROM Accounts WHERE {0}", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets a list of all portals.
/// </summary>
/// <returns>A list of all portals.</returns>
public static List <Models.DbPortal> GetAll()
{
return(SqlDalHelper.GetAll <Models.DbPortal>(ConnectionStrings.World,
"SELECT * FROM Portals",
null));
}
/// <summary>
/// Gets a list of all spell infos.
/// </summary>
/// <returns>A list of all spell infos.</returns>
public static List <Models.DbSpellInfo> GetAllSpellInfos()
{
return(SqlDalHelper.GetAll <Models.DbSpellInfo>(ConnectionStrings.World,
"SELECT * FROM SpellInfos",
null));
}
/// <summary>
/// Gets a list of all items.
/// </summary>
/// <returns>A list of all items.</returns>
public static List <DbItem> GetAll()
{
return(SqlDalHelper.GetAll <DbItem>(ConnectionStrings.World,
"SELECT * FROM Items",
null));
}
/// <summary>
/// Gets a player.
/// </summary>
/// <param name="pars">The parameters.</param>
/// <returns>The player if found, null otherwise.</returns>
private static DbPlayer Get(Dictionary <string, object> pars)
{
return(SqlDalHelper.Get <DbPlayer>(ConnectionStrings.World,
string.Format("SELECT * FROM Players WHERE {0}", Sql.GetSel(pars)),
pars));
}
/// <summary>
/// Gets a list of all weathers.
/// </summary>
/// <returns>The list of weathers.</returns>
public static List <Models.DbWeather> GetAll()
{
return(SqlDalHelper.GetAll <Models.DbWeather>(ConnectionStrings.World,
"SELECT * FROM Weathers",
null));
}
/// <summary>
/// Gets a list of all something.
/// </summary>
/// <param name="count">The amount to get.</param>
/// <returns>A list of all something.</returns>
internal static List <Something> GetAll(int count)
{
return(SqlDalHelper.GetAll <Something>(Helpers.SqlTests.ConnectionString,
string.Format("SELECT TOP {0} * FROM SomeTable ", count),
null));
}
