User Tools

Site Tools


hayley

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
hayley [2017/02/01 07:00]
mikepardon created
hayley [2017/02/13 23:21] (current)
Line 1: Line 1:
-<​html><​div style="​floatright;"></​html>​ +[[american_dad:character_cards:​hayley]]
-~~socialite~~ +
-<​sql>​ +
-<​0>​MainHead</​0>​ +
-<​sqlstart>​ +
-SELECT  +
-C.Name +
-,​concat(C.Name,'​ ',​CLC.DisplayLevel) AS '​Picture'​ +
-,CS.Name +
-,CR.Name +
-,case when C.Trait =''​ then '​None'​ else C.Trait end as '​Trait'​ +
-FROM Cards C +
-inner join CardLevels CL on CL.CardID = C.ID +
-inner join CardLevelConvert CLC on CL.level = CLC.Level and CLC.Rarity = C.Rarity +
-inner join CardsShow CS on CS.ID = C.Type +
-inner join CardRarity CR on CR.ID = C.Rarity +
-where +
-C.Name = '​Hayley'​ +
-and Commander <> 1 +
-order by CL.Level DESC +
-limit 1 +
-</​sqlstart>​ +
-</​sql>​ +
-<​html></​div></​html>​+
  
-====== Hayley ====== 
-Hayley, along with her father [[:Stan]], was one of the first two characters that were conceived and created for the series. Across the series, Hayley'​s storylines typically involve her liberal opinions clashing with her father'​s staunch conservative beliefs, and her on-again-off-again relationship with boyfriend Jeff Fischer, whom she later marries in the show's sixth season. 
- 
-<​html><​div style="​float:​ none;"></​html>​ 
-**Upgrades** 
-<sql> 
-<​1>​LeftImage</​1>​ 
-<​2>​LeftImage</​2>​ 
-<​3>​LeftImage</​3>​ 
-<​4>​LeftImage</​4>​ 
-<​5>​LeftImage</​5>​ 
-<​sqlstart>​ 
-SELECT CLC.DisplayLevel AS '​Level'​ 
-, (Select Max(CLA.Attack) from CardLevels CLA where CLA.CardID = CL.CardID and CLA.Level <= CL.Level) AS '​Attack'​ 
-, (Select Max(CLA.Health) from CardLevels CLA where CLA.CardID = CL.CardID and CLA.Level <= CL.Level) AS '​Health'​ 
-, (Select COALESCE(MAX(S.x),​0) from CardSkillLevels S where S.CardID = CL.CardID and S.Level <= CL.Level and S.SkillID = '​barrierall'​) AS '​Shield All' 
-, (Select COALESCE(MAX(S.x),​0) from CardSkillLevels S where S.CardID = CL.CardID and S.Level <= CL.Level and S.SkillID = '​heal'​) AS '​Heal'​ 
-FROM CardLevels CL 
- 
-inner join Cards C on C.ID = CL.CardID 
-inner join CardLevelConvert CLC on CLC.Level = CL.Level and CLC.Rarity = C.Rarity 
- 
-where C.Name = '​Hayley'​ and C.Commander <> 1 
-group by C.Name, CL.Level 
-Order by C.Name, CL.Level 
-</​sqlstart></​sql>​ 
-<​html></​div></​html>​ 
- 
-**Combos with:** 
-<sql> 
-<​0>​links,​LeftImage</​0>​ 
-<​1>​links,​LeftImage</​1>​ 
-<​sqlstart>​ 
-select c1.Name as 'Combo Card', c3.Name as 'Item Card' from Combos C 
-left join Cards c1 on c1.ID = C.EndCard 
-left join Cards c2 on c2.ID = C.Card1 
-left join Cards c3 on c3.ID = C.Card2 
-where c2.Name = '​Hayley'​ 
-order by c1.Name, c3.Name 
-</​sqlstart>​ 
-</​sql>​ 
- 
-See: [[:​character_cards]] | [[:American Dad]] 
hayley.txt · Last modified: 2017/02/13 23:21 (external edit)