Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var quests =
- from quest in db.QuestTemplates
- where q.MinLevel <= wowMain.Me.Level + 2
- where (q.SpecialFlags == 0 || q.SpecialFlags == 4)
- where q.SuggestedPlayers <= 1
- where q.RequiredMaxRepFaction == 0
- where q.RequiredMinRepFaction == 0
- where q.RepObjectiveFaction == 0
- where q.LimitTime == 0
- where q.ReqSourceID1 == 0
- where q.ReqSpellCast1 == 0
- let startEntry = db.CreatureQuestRelations.FirstOrDefault(a => a.Quest == quest.Entry)
- let endEntry = db.CreatureQuestRelations.FirstOrDefault(a => a.Quest == quest.Entry)
- if (startEntry != null || endEntry != null)
- {
- let start = db.CreatureTemplates.FirstOrDefault(x => x.Entry == startEntry.ID)
- let end = db.CreatureTemplates.FirstOrDefault(x => x.Entry == endEntry.ID)
- if (start != null || end != null)
- {
- let creatureStart = db.Creatures.FirstOrDefault(x => x.ID == start.Entry)
- let creatureEnd = db.Creatures.FirstOrDefault(x => x.ID == end.Entry)
- if (creatureStart != null &&
- creatureEnd != null &&
- creatureStart.Map == wowMain.Me.MapId &&
- creatureEnd.Map == wowMain.Me.MapId)
- {
- select new DBQuest(quest, creatureStart, creatureEnd);
- }
- }
- }
Add Comment
Please, Sign In to add comment