king_of_the_hill:item_cards:million_dollar_beer_can
Differences
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> | ||
king_of_the_hill/item_cards/million_dollar_beer_can.txt · Last modified: 2017/02/13 23:20 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
