Differences

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

@@ 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