User Tools

Site Tools


francine

Differences

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
francine [2017/02/01 06:57]
mikepardon
francine [2017/02/13 23:21] (current)
Line 1: Line 1:
-<​html><​div style="​floatright;"></​html>​ +[[american_dad:character_cards:​francine]]
-~~socialite~~ +
-<​sql>​ +
-<​0>​MainHead</​0>​ +
-<​sqlstart>​ +
-SELECT  +
-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 = '​Francine'​ +
-and Commander <> 1 +
-order by CL.Level DESC +
-limit 1 +
-</​sqlstart>​ +
-</​sql>​ +
-<​html></​div></​html>​+
  
-====== Francine ====== 
-Francine is often seen indignant, nagging and scolding her family (mostly [[:Stan]]) over wrongdoings,​ sometimes even becoming berserk in these moments. Seemingly a voice of reason, Francine also nags at her family to uphold certain virtues as well as over anything they engage in that is unwholesome or reprehensible;​ paradoxical in character however, it is right in the midst of her moralistic nagging that Francine displays total inelegance, inappropriateness,​ and impropriety. Sporadically,​ while engaged in moralising others or just in general, she will randomly throw in remarks and behaviours that are in bad taste and lack all sense of propriety. In the episode Virtual In-Stanity for example, Francine calls up Stan nagging and lecturing him about his neglect of [[:Steve]] to which [[:Stan]] responds by hanging up on her. Francine then calls back, shrieking "​Bitch,​ did you just hang up on me?!" Adding to her paradoxical nature, Francine'​s behaviors have been known to become downright fiendish, all the while trying to get her family to live more wholesomely and do what is right. Very random, Francine is also given to making wacky and peculiar asides out of nowhere. For example, in the episode "The Scarlett Getter",​ while Francine was engaged in an angry rant about Stan, she stated "Those two are stuck on each other like gum on a hot summer sidewalk on a summer afternoon. I'm sorry, I'm taking a creative writing class."​ 
- 
-<​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'​ 
-, (Select COALESCE(MAX(S.x),​0) from CardSkillLevels S where S.CardID = CL.CardID and S.Level <= CL.Level and S.SkillID = '​barrierall'​) AS '​Shield All' 
-, (Select COALESCE(MAX(S.x),​0) from CardSkillLevels S where S.CardID = CL.CardID and S.Level <= CL.Level and S.SkillID = '​heal'​) AS '​Heal'​ 
-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 = '​Francine'​ and C.Commander <> 1 
-group by C.Name, CL.Level 
-Order by C.Name, CL.Level 
-</​sqlstart></​sql>​ 
-<​html></​div></​html>​ 
- 
-**Combos with:** 
-<sql> 
-<​0>​links,​LeftImage</​0>​ 
-<​1>​links,​LeftImage</​1>​ 
-<​sqlstart>​ 
-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 = '​Francine'​ 
-order by c1.Name, c3.Name 
-</​sqlstart>​ 
-</​sql>​ 
- 
-See: [[:​character_cards]] | [[:American Dad]] 
francine.txt · Last modified: 2017/02/13 23:21 (external edit)