This shows you the differences between two versions of the page.
— |
american_dad:combo_cards:opera_francine [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 | ||