User Tools

Site Tools



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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
klaus [2017/02/01 22:20]
klaus [2017/02/13 23:21] (current)
Line 1: Line 1:
-<​html><​div style="​floatright;"></​html>​ +[[american_dad:character_cards:​klaus]]
-~~socialite~~ +
-<​sql>​ +
-<​0>​MainHead</​0>​ +
-<​sqlstart>​ +
-C.Name +
-,​concat(C.Name,'​ ',​CLC.DisplayLevel) AS '​Picture'​ +
-,CS.Name +
-,CR.Name +
-,case when C.Trait =''​ then '​None'​ else C.Trait end as '​Trait'​ +
-FROM Cards C +
-inner join CardLevels CL on CL.CardID = C.ID +
-inner join CardLevelConvert CLC on CL.level = CLC.Level and CLC.Rarity = C.Rarity +
-inner join CardsShow CS on CS.ID = C.Type +
-inner join CardRarity CR on CR.ID = C.Rarity +
-where +
-C.Name = '​Klaus'​ +
-and Commander <> 1 +
-order by CL.Level DESC +
-limit 1 +
-</​sqlstart>​ +
-</​sql>​ +
-====== Klaus ====== 
-Klaus Heissler is the family'​s attention-starved,​ hapless, saturnine pet goldfish. He is consultative and full of sage advice, sometimes even taking on a scholarly appearance and wearing reading glasses. Klaus is actually a man in a fish body. He was once an East German Olympic ski-jumper until his brain and presumably vocal cords were transferred into the body of a goldfish. The CIA did this to Klaus at the 1986 Winter Olympics to prevent him from winning the gold medal. This has resulted in Klaus becoming permanently trapped in the body of a goldfish, leaving him at times discontented and gloomy. Not confined to his fishbowl, he is often seen scooting himself about the Smith residence, reclined in a glass of water. In these moments, it is only his very lower back that is actually in the water. In the early part of the series, Klaus had an obsessive crush on Francine and often made sexual advances towards her.[1] The Smith family and particularly Roger have been shown to treat Klaus with disdain. Ironically, Klaus started out in the series as a bully, known for his ridicule and cruel teasing of all the show's main characters, particularly Roger. As Roger took on more cruel and brazen behaviours, however, this became lessened. 
-<​html><​div style="​float:​ none;"></​html>​ 
-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'​ 
-, (Select COALESCE(MAX(S.x),​0) from CardSkillLevels S where S.CardID = CL.CardID and S.Level <= CL.Level and S.SkillID = '​armored'​) AS '​Sturdy'​ 
-FROM CardLevels CL 
-inner join Cards C on C.ID = CL.CardID 
-inner join CardLevelConvert CLC on CLC.Level = CL.Level and CLC.Rarity = C.Rarity 
-where C.Name = '​Klaus'​ and C.Commander <> 1 
-group by C.Name, CL.Level 
-Order by C.Name, CL.Level 
-**Combos with:** 
-select c1.Name as 'Combo Card', c3.Name as 'Item Card' 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 = '​Klaus'​ 
-order by c1.Name, c3.Name 
klaus.txt · Last modified: 2017/02/13 23:21 (external edit)