/// <summary>
/// Delete all of a player's quest variables for a certain quest so that it is a fresh start when they attempt to do the quest
/// again, or else the quest is complete and there's no more point storing this data in the database
/// </summary>
/// <param name="playerId">Id of player</param>
/// <param name="questId">Id of the quest</param>
public static void ClearQuestPlayerVariables(int playerId, int questId)
{
IQuestRepository repo = new EFQuestRepository();
foreach (var q in repo.QuestPlayerVariablees.Where(v => v.PlayerId == playerId && v.QuestId == questId).ToList())
{
repo.DeleteQuestPlayerVariable(q.Id);
}
}
public static string PlayerEndQuest(Player player, int endType)
{
var message = "";
IPlayerRepository playerRepo = new EFPlayerRepository();
var dbPlayer = playerRepo.Players.FirstOrDefault(p => p.Id == player.Id);
dbPlayer.InQuest = 0;
dbPlayer.InQuestState = 0;
playerRepo.SavePlayer(dbPlayer);
IQuestRepository questRepo = new EFQuestRepository();
var questPlayerStatus = questRepo.QuestPlayerStatuses.FirstOrDefault(q => q.PlayerId == player.Id && q.QuestId == player.InQuest);
if (questPlayerStatus == null)
{
questPlayerStatus = new QuestPlayerStatus
{
PlayerId = player.Id,
QuestId = player.InQuest,
};
}
questPlayerStatus.LastEndedTurn = PvPWorldStatProcedures.GetWorldTurnNumber();
questPlayerStatus.Outcome = endType;
questRepo.SaveQuestPlayerStatus(questPlayerStatus);
// assing completion bonuses
if (endType == (int)QuestStatics.QuestOutcomes.Completed)
{
var questState = GetQuestState(player.InQuestState);
decimal xpGain = 0;
foreach (var q in questState.QuestEnds)
{
// experience gain
if (q.RewardType == (int)QuestStatics.RewardType.Experience)
{
xpGain += Int32.Parse(q.RewardAmount);
}
// item gain
else if (q.RewardType == (int)QuestStatics.RewardType.Item)
{
var item = ItemStatics.GetStaticItem(System.Convert.ToInt32(q.RewardAmount));
ItemProcedures.GiveNewItemToPlayer(player, item);
message += " <br>You received a <b>" + item.FriendlyName + "</b>.";
}
// effect gain
else if (q.RewardType == (int)QuestStatics.RewardType.Effect)
{
var effect = EffectStatics.GetDbStaticEffect(System.Convert.ToInt32(q.RewardAmount));
EffectProcedures.GivePerkToPlayer(effect.Id, player.Id);
message += "<br>You received the effect <b>" + effect.FriendlyName + "</b>.";
}
// spell gain
else if (q.RewardType == (int)QuestStatics.RewardType.Spell)
{
var spell = SkillStatics.GetStaticSkill(System.Convert.ToInt32(q.RewardAmount));
SkillProcedures.GiveSkillToPlayer(player.Id, spell.Id);
message += "<br>You learned the spell <b>" + spell.FriendlyName + "</b>.";
}
}
if (xpGain > 0)
{
message += "<br>You earned <b>" + xpGain + "</b> XP.";
}
PlayerProcedures.GiveXP(player, xpGain);
}
// delete all of the player's quest variables
var vars = QuestProcedures.GetAllQuestPlayerVariablesFromQuest(player.InQuest, player.Id).ToList();
foreach (var v in vars)
{
questRepo.DeleteQuestPlayerVariable(v.Id);
}
return(message);
}