User Tools

Site Tools


american_dad:combo_cards:squirrel_suit_hayley

Differences

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

Link to this comparison view

american_dad:combo_cards:squirrel_suit_hayley [2017/02/13 23:18] (current)
Line 1: Line 1:
 +<​html><​div style="​float:​ right;"></​html>​ ~~socialite~~ <sql> <​0>​MainHead</​0>​ <​sqlstart>​ SELECT C.Name ,​concat(C.Name,'​ ',​CLC.DisplayLevel) AS '​Picture'​
 +,case when CS.Name is null then '​None'​ else CS.Name end as '​Name'​
 +,CR.Name
 +,case when C.Trait =''​ then '​None'​ else C.Trait end as '​Trait'​
 +FROM Cards C
 +left join CardLevels CL on CL.CardID = C.ID left join CardLevelConvert CLC on CL.level = CLC.Level and CLC.Rarity = C.Rarity left join CardsShow CS on CS.ID = C.Type left join CardRarity CR on CR.ID = C.Rarity where C.Name = '​THISCARD'​
 +and Commander <> 1
 +order by CL.Level DESC
 +limit 1
 +</​sqlstart>​
 +</​sql>​
 +<​html></​div></​html>​
 +
 +====== Hank Hell's Haunted House ======
 +<​sql><​0>​Description</​0><​sqlstart>​Select D.Description from CardDescs D left join Cards C on C.ID = D.CardID where C.Name = '​THISCARD'​ and C.Commander <> 1</​sqlstart></​sql>​
 +
 +<​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'​
 +MYSKILLZ
 +FROM CardLevels CL
 +
 +inner join Cards C on C.ID = CL.CardID
 +inner join CardLevelConvert CLC on CLC.Level = CL.Level
  
american_dad/combo_cards/squirrel_suit_hayley.txt · Last modified: 2017/02/13 23:18 (external edit)