This shows you the differences between two versions of the page.
— |
king_of_the_hill:item_cards:million_dollar_beer_can [2017/02/13 23:20] (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> | ||
+ | |||
+ | ====== Million Dollar Beer Can ====== | ||
+ | <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 | ||
+ | |||
+ | where C.Name = 'THISCARD' and C.Commander <> 1 group by C.Name, CL.Level Order by C.Name, CL.Level </sqlstart></sql> <html></div></html> | ||
+ | |||
+ | ** Combos ** | ||
+ | <sql> | ||
+ | <0>ComboList</0> | ||
+ | <sqlstart> | ||
+ | select c1.Name as 'Combo Card' | ||
+ | , case when c3.Name = 'THISCARD' then c2.Name else c3.Name end as 'Combos With' | ||
+ | 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 = 'THISCARD' or c3.Name = 'THISCARD' and c2.Name is not null order by c1.Name, c3.Name | ||
+ | |||
+ | </sqlstart> | ||
+ | </sql> | ||