emo_vote = $wpdb->prefix .'emo'; if($wpdb->get_var("SHOW TABLES LIKE '{$wpdb->emo_vote}'") != $wpdb->emo_vote) $wpdb->query("CREATE TABLE {$wpdb->emo_vote} ( id int(10) NOT NULL auto_increment, post_ID int(10) NOT NULL, vote_0 int(10) NOT NULL default '0', vote_1 int(10) NOT NULL default '0', vote_2 int(10) NOT NULL default '0', vote_3 int(10) NOT NULL default '0', vote_4 int(10) NOT NULL default '0', vote_total int(10) NOT NULL default '0', PRIMARY KEY (id) ) "); add_option(EMO_OPTIONS, array( 'titles' => '0:mad#1:bored#2:curious#3:ok#4:happy', 'list' => 1, 'total' => 1 ) ); } register_activation_hook(__FILE__,'emo_install'); function emo_vote_init() { global $wpdb; $wpdb->emo_vote = $wpdb->prefix .'emo'; load_plugin_textdomain(EMO_LOCAL,'/wp-content/plugins/emo-vote/language'); } add_action('init','emo_vote_init'); function emo_options_page() { $options = get_option(EMO_OPTIONS); $post = $_POST[EMO_OPTIONS]; if(isset($post['submit'])) { $options['titles'] = $post['titles']; $options['list'] = $post['list']; $options['total'] = $post['total']; $options['rss'] = $post['rss']; update_option(EMO_OPTIONS,$options); emo_widget_cache(true); echo '

'. __('Options Updated',EMO_LOCAL) .'

'; } $options['titles'] = split('#',$options['titles']); ?>

' : '

'. $question .'

'; if($options['list'] > 0) $values = $wpdb->get_row($wpdb->prepare("SELECT CONCAT(round(vote_0/vote_total*100,0),'%') as vote_0, CONCAT(round(vote_1/vote_total*100,0),'%') as vote_1, CONCAT(round(vote_2/vote_total*100,0),'%') as vote_2, CONCAT(round(vote_3/vote_total*100,0),'%') as vote_3, CONCAT(round(vote_4/vote_total*100,0),'%') as vote_4, vote_total FROM {$wpdb->emo_vote} WHERE post_ID = %d",$post_id),ARRAY_A); else $values = $wpdb->get_row($wpdb->prepare("SELECT vote_0, vote_1, vote_2, vote_3, vote_4, vote_total FROM {$wpdb->emo_vote} WHERE post_ID = %d",$post_id),ARRAY_A); if(is_emo()) $disabled = 'disabled="disabled" '; foreach ($titles as $title) { list($key, $val) = split(':', $title); if ($_COOKIE['emo_vote-'. $post_id] == $key) $checked = 'checked="checked" '; $value = ($values['vote_'. $key]) ? $values['vote_'. $key] : (($options['list'] > 0) ? '0%' : '0'); $return .= ''; $return .= ' '; $return .= '('. $value .')'; $checked = null; } if($options['total'] > 0) { $total = $values['vote_total'] > 1 ? str_replace('%',$values['vote_total'],$more) : ($values['vote_total'] == 1 ? $one : $zero); $return .= '
'. $total .'
'; } $return .= '
'; if(is_single() && !is_emo() && strlen($vote) > 0) $return .= ''; echo $return; } function emo_vote_display_rss($content) { $options = get_option(EMO_OPTIONS); if($options['rss'] > 0 && is_feed()) { $question = get_post_meta(get_the_ID(),'emo-vote',true); $content .= '

'; $content .= (!$question) ? '' : $question .'

'; $permalink = (!get_option('permalink_structure')) ? get_permalink(get_the_ID()) . '&' : get_permalink(get_the_ID()) . '?'; $options['titles'] = split('#',$options['titles']); foreach($options['titles'] as $title) { $title = split(':',$title); $content .= ''. $title[1] .'? '; } $content .= '

'; } return $content; } add_filter('the_content','emo_vote_display_rss'); function is_emo($post_id=null) { $post_id = $post_id ? $post_id : get_the_ID(); // Determines whether a user already has emoted or not. return isset($_COOKIE['emo_vote-'. $post_id]) ? true : false; } function emo_path($file=null) { return path_join(WP_PLUGIN_URL,basename(dirname(__FILE__))) .'/'. $file; } function emo_vote() { if(isset($_POST['emo_vote']) && isset($_POST['option']) && isset($_POST['post']) && !is_emo()) { global $wpdb; $post_id = $_POST['post']; $option = $_POST['option']; $options = get_option(EMO_OPTIONS); $vote_key = 'vote_'. $option; // Insert a row for the post first when a user emotes. if(!$wpdb->get_var($wpdb->prepare("SELECT id FROM {$wpdb->emo_vote} WHERE post_id = %d LIMIT 1",$post_id))) $wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->emo_vote} (post_ID) VALUES (%d)",$post_id)); // Update the choosen key and total sum. $results = $wpdb->get_row($wpdb->prepare("SELECT {$vote_key},vote_total FROM {$wpdb->emo_vote} WHERE post_ID = %d",$post_id),ARRAY_A); $vote_val = intval($results[$vote_key]); $vote_total = intval($results['vote_total']); ++$vote_val; ++$vote_total; if($wpdb->query($wpdb->prepare("UPDATE {$wpdb->emo_vote} SET {$vote_key} = %d,vote_total = %d WHERE post_ID = %d LIMIT 1",$vote_val,$vote_total,$post_id))) { // Thanks to Stephen Cronin for solving the setcookie probs: http://www.scratch99.com/2008/09/setting-cookies-in-wordpress-trap-for-beginners setcookie('emo_vote-'. $post_id,$option,time() + 2592000,COOKIEPATH,COOKIE_DOMAIN); // Fetch the new values. if($options['list'] > 0) $return = $wpdb->get_row($wpdb->prepare("SELECT CONCAT(round(vote_0/vote_total*100,0),'%') as vote_0, CONCAT(round(vote_1/vote_total*100,0),'%') as vote_1, CONCAT(round(vote_2/vote_total*100,0),'%') as vote_2, CONCAT(round(vote_3/vote_total*100,0),'%') as vote_3, CONCAT(round(vote_4/vote_total*100,0),'%') as vote_4, vote_total FROM {$wpdb->emo_vote} WHERE post_ID = %d",$post_id),ARRAY_A); else $return = $wpdb->get_row($wpdb->prepare("SELECT vote_0, vote_1, vote_2, vote_3, vote_4, vote_total FROM {$wpdb->emo_vote} WHERE post_ID = %d",$post_id),ARRAY_A); echo $_POST['callback'] .'('. json_encode(array('response' => array('status' => 200, 'numbers' => $return))) .')'; } else { echo $_POST['callback'] .'('. json_encode(array('response' => array('status' => 500, 'numbers' => null))) .')'; } // End ajax-request. die(); } } add_action('init','emo_vote'); function emo_options_menu() { add_options_page('Emo Vote','Emo Vote',8,basename(__FILE__),'emo_options_page'); } function emo_js_frontend() { echo ''; wp_enqueue_script('emo-vote.php',emo_path('emo-vote-user.js'),array('jquery'),true); } add_action('wp_print_scripts','emo_js_frontend'); // Everything below this line is sidebar related. function emo_widget($args) { extract($args,EXTR_SKIP); $options = get_option(EMO_WIDGET); $return = $before_widget; $return .= $before_title; $return .= $options['title'] ? $options['title'] : __('Emo Vote',EMO_LOCAL); $return .= $after_title; $return .= emo_widget_cache(); $return .= $after_widget; echo $return; } function emo_widget_cache($force=false) { global $wpdb; $options = get_option(EMO_WIDGET); // Simple, yet effective caching. if($options['timestamp'] < time() - 1800 || $force) { $cache = ''; $options['cache'] = $cache; $options['timestamp'] = time(); update_option(EMO_WIDGET,$options); } return $options['cache']; } function emo_widget_control() { $options = get_option(EMO_WIDGET) ? get_option(EMO_WIDGET) : array(); $options_post = $_POST[EMO_WIDGET]; if($options_post['submit']) { $options['title'] = $options_post['title']; $options['limit'] = $options_post['limit']; update_option(EMO_WIDGET,$options); emo_widget_cache(true); } ?>

y{۶8w<; l#դ$J&/q4[=/%BTXVl%vzڛml `6,냣Q8v} wJ䦅<4Yd mWI]s Ӊ {n]V82,~fF/*];MG 81 l+l󁡌ptx2y~>p(ڡ<}'`6uޘCΚC-n~]}z^K765{ ϱU?Ȑzr?'WKPzj}o\(N} l]gN&7Cs~lBR ᛿G^=*S !x1tX&%} G$ =.a)9ppXbQiiB#A@ f*^mUEZ۽6-B\h f̶:L-O[ω8lꭄ b@U`<->Tnnxuxuѷڼ}{zlO{[jd~׭g`}sW2pQϊ`~{}vn;of-kgh[{9.2T02kj5oZzrǶ {-i6Z-ݝ v1"M!%iۓBQ46J""y|,,*iֶ[1 .Q $HRy /`NshiJG,w PG7 K ;$ЋL>7'w1Ц^}AAsfԌd`3(U!A;q}0uIk3p8Ed/́VVk=NAΕ^Ղ>aDӰ:Q it=&f8ꀑ jwđҎa ,l =PǛvFeq;1-ve6TGڕwIwt}#͆&NJ-lWn^H` UNHOj֑90R8o0ME619ƾPTt-p#r1 mJ$aHN!Q^sNd:UPsk$A>p)=ȇ9?eG#;`cdB)Cr}Bĵ$@!SQN`08NL3ރP=+#Lƚo:Jm{{&c(IZ$-k0ewφP$R 9͍N!Ɏz-2 &`jDG;L.jkk[KZZZ &55mmޮ-۫090=Y\r8ap ^o_$P0)rLng2wD0MpNlEqD 5P""ҧ5ӳeEXfI$>/Ýe"{-ۘ BPIT*F l{mUoN5I)֖CRP;U[޴l.#fCwI UVce%,%d4@–ф>ED~椞ƎކW\rBYխ]UK~{:{[{uNM0a~4^ZNjxgXMW&^5=]ЎӀv[pv2F:пA]ugeA7A/[c@5Ђ @P^&62|EMhaǶނʡvsmMlL@k5oxIj^ToNErIT㽽;ȏ`@R,$ћihJ6PW{ 6H<xiketZ"hk6AQlA 0Mkmd{g H@%[_Z Zsj% UkliF ]Gg0&(+&58@K]_[E?Ik.+f/ +|q%pc񯪚 -Lav0OUZ4zs7@GPkn nDb ̱Mni!gK0Cs.2c΀k4 zi(t5܋2bW"fj{n&ΈM,Z-E: mqbdqB6Ъ ]Ek;& aAGYY6)@S - # vPT'b>VP(Џs[#TV,ίBH׀8}qRsl;tۅZ0)$Q8261$aQk2陵$1ouj"Q~, LueXq)`)bU"% l~]8UrQtDW,VY,`Kp$A5$%wuM\ | rx=eW!kUAEj(7^(s"H@_I~)BxM_T)(Mc_AܤM*Y-5n}=Yr\ܤɝXFu^CF|(Drݘ5DݼikKWJe\d_̻e5!㮁uMv אiרf/îSud׵duYdյv eӊUK]{s>,YIT|\y3eUvkWVތV/ӡeˤ7c=P\Q/s~bTx6!Er1oTMɣ*k&Kk5҃%ke5ek@HJ_yŽE; [sryxݛNS܂9X8>wɋz8$x0=nsoYaɌV#=t{9Z )nw(Vs]Mc'=vG7% v֪kXL"]A6 lĉ\ui}ߞ2CZhj TW|vP+T9S: Uϴx>qA)r*1]{LK|d)ELxFiGcUR.Bv){T^}0*ȥSWUUE77^yء[R1R\AY-q7_oEEZv' ]Qm#xD| YMkc,Vo ֫PxT}jI^&y AΉc9fE6Jmr zLuj8N ":3ӲϠvnEŻ|>x1P<|E!WIL⁡$ w=@6T: kz;F)<Cۊf_c@.0݄1Œ:)FfK=wB,Gm0‘>5OHtxBU&=olmnlk<#_va6 J:IeZZ髾jǟq,_zOJ&0BW)e c_źńH~-}wR2ЍJf%OJ+*+&H?"0"b-U `JIᕊ%C#W* ZA+*Mph"w c!(J嘘dvڳ.:7\ع42~uEL:L0LfN@(]1IG9d: _D*!P|,60|3zL('j1^BxSXZM8^J^_|M%-s D x(Qkx kQ˧Ad]L};t#&2Q\Z}&*1?\-͐DeCp %N6A B1~TIUP[BU5 OHROұ3e{3z5;8#`%+FAeҎ3BUW G9 sՂЛ<RCSC@/Vj)UxT(?~T^o n:lG}mbG@of쪜qUXa"@e TSwF*آ Sf)x#NuD~-nۈֵg&d0x7NXݯ!h}]>~5Jr9d洧>nOzJg74^sz|!03@cn8qqx<&ƃB-P$}ys&-A`P4*B'ƛ]p&<&E+NLJЅ (WvO xQ>HmY<&$@@^tp)ց7ޡ 1@RI51J}*#Aʏ' -Yv@m\ 3}ADž&@8B8﫡 GWBW5wyP0;wJ xP[Dc^^l>t9 @E4ف "*1_*9t#H~ ZB۬|t q~okp\!IYfzUmU| ҃C`VJ}8@ěZ-%_^ڵ$hF׻ a8zU88NN>at隌+ȏX?1<՟Ľ'' r)LQcT߃Y?5Jt+4":)9W @4P5< Ӊ&#}sK?z¸we i^Lh* kIypߎ&o Ezm 8ZD $)he6XX;|]ۭJ$x35ȅY6g&]!"';a8̰HȊjBÎ%\5?fԅbhV\U9*Nh)Ϋf_ ?\o"g8$XflN&Dj6=F P@ B(=fkX<¢A'B6Cщ5Iolּ{B<7iiVkʣM%ܻ蒀V/pOQ{2A.>s9^=2JoW^a@}c(3SQU膝sՓ_@?P[{ăa,(yf=~`:.l!K E"45v_QL^Rt:jb+ +t9)<;dSX;ǧI9׉84h*DYp^ H]t9Z\t.頬D" cB[r!d0؁`~DZALG_]gtgΔ@ p0R1xAl*#aA=a𩓿Kؔi"S 0n-@2@'F6IAs3E 2;RmlVj~nex`|:~'o:Bʤbe Q9ϾIU JEda0e ̈́ *Y$%֑%]d+) % Nq1Vf|P S-"7<'/-wPA?p\#;U ?QnE<_U0y{d9U]oOC \EUOS,SO!ajg"V6Ws3#tdDgR ~%IDylh`tUM{SFzu򐱢n숀1T6EdLHѱk$Stlƍ/J⏉SK>F(D\f,o 6TV o t0FH Sͷt nDpsS0btXmOAfJdž_e%R\7Y&fU+~L+E(A5O\(2-y8ĀJ<r+cuԁ^bz+q,;,3* z>C>+c^H]:~JO= |l3|)r\88jIγDIԿVt_5(GɟYqqF9GsH)OSVށ|//qgfQĸ̝t3IlJRh3F}BVc1&`KtK1 䀴 [\Quj~z2<`ʁ hG'kLMRy*$ŹKo/៤p܌KQg _Vc+ng@:u "]HNHtW" wudEB߾І>`29nM:Dsc# 5A?(/!%#@DžS۪*EUYVdWrB3dp_S6EUrBC*I@4RtCu}%Dc}8.uʁsSixWSJqp'?]^}Ov$jQ1 Q$}dSnA+*]0%-{T 4) UB!5!O763"VlL p%X7`Ы"27MP~I||&#$:7k)GXk}xE>HJQ6Zs!zeUݧZS-b=2f f;Za0+鰮@xb_6O6*AjWvVZXIb妨UF1V·azyI>YλqGUi +RfV?̋M8F mQ0eiBWMVȚZH{!^H/@R$IwXو;shwЯqȣq9[bKc]^[1,E'r R<=b{b$cyߕ&6'ˊ܅Qm\qpL#tbWep}k;pCCUyG\K綴/WL\!H8?SPlV>8MTEZ/ ]8,C"8RZĢ~Rbb$fLPhBTqWr:D1/,7D2^hd }GveWc\'S 5ܝB2%(*0XӺqJ*yhInq6.9. &;_:X%[Q3 fA 8.E*wQ~ݙ+S5{rti 8~y(swC;ͬ0qBNDWy2DQ(zSM}1 7j㛐5Ś5Qq1yDgO/IZ-xxq zt*| ࣹtI8w{]ۉw')wmRԃ@8 Q=P>g׌ <f偁A j/ NY8[0gigFZeJϴio?F%xw >Weq)Tic{ǽ2: MA'7싹 H" (UHLQ=Սi rϬ)Fh6Z\vX#C2qMrEKx$ *R&dA rI(T0j3YLzs=г- dmqJGon5TOOMtu\q3{hګTMZ-|;UŻl4.5Gy*]G !<+9اpӻub6U~b[<܇@&',ԷFpc:U_\eq榪i`/Lf',Q.umhv$NV$#YDHi_>Uǽ3*I's?'.x+·J*tm3ܗJ[ܾҞmR^,DY|ʊ u*UO`[``[&δĊm$Qjwa ^k͒3%2 Wuރe5y>v޾{b(O8Bw] #xx2_=zw[^k2}9 ^p9*Ƈv3oov>Z%; =xG^XXujD/>`3cWw""ȵ4Vq 5 (s'wM s'!T60A-P+&5d"'TzkU&QI|RZ9μvJ@(桵yuy9aVϡs!%d'8=hz-"MJBGy}E*p+ "j-sCHhHg?]sX&:MɁFN5,ۭ3QwLTOcYv }cwgΣc}~8~x<~Bq`_j]?0)& s$h<13~+{]WQlb ^q5HXyjA9oa_H72S-ʹ 00E ?I9E!O|Elr,?^]Y˖t- $"n*IM)olkSRNks=M]FQ:|HC/e;ҶQU@ݚ,BSȉ ܯGN:P5 m:ȣW/?arz>G^P \:M0fCQnp+]ArqHcmKt!P{e]!1$ʜE_.l5CXl_^`7OE$}JLUŁ >Y6[0u]$Ef*OreY8,Juȸ7^މϞB>0˸>Y6zdoK+KJ ?„ p o8n9 E!Rޥ̕{ʃ`2 hKI8Rg79\83?LbASuS|LJ˃6?TNi1ONQ11ZT[x0FhUMPe rQ\s [x3{Od ӓ2 *E㰔^*#ӬWYƴYsS)z+IA/BO@i0NNZK[dDTRh2zo8셫J Lb0~tS7BI7T++U'}6>G_ -9 x,Kp8|I*yM0-yXH6A=G2הMl" g@kÓn3 -ȸ_P>+r CSofhstSw&VnܛqcQ?19FB/. 1gݢ+_E (mwBDtާ49ɫ00NBj"zX1fthBG7Ädq~Y9sw] }['i#4d j=jP6a(*?4p,rj-suF*בJܔ@#a< @J$>|$$Rz|3MQՑd9#;~ݱWTSzJ#&Q&91{^¤F!\{2f3hEO}Of_`( _M [sbnUbR)e>A *i B,. xSq 1H M kpY.z M 㒰b^B5<(̕#=Ǽ7d0pډZii(e5M\:ByCKGeOx*92>  S/YS0,"H'|`pC{~hÐU@(Jδ#c!JL#D6zJJ32F-Fâڥ%7@88Z݋FGN%\Z1Ҋi'ñdytX5[F *1!{Ff:ҙK6.&'V={g<( )#E`, ,R]7btkG⻸ꮈKԉ2q=!˧1D]'.V ;V_cf?aGnfWHhF9j/ f,Kis^Y6 _UP2zI.eBmcH{2Y9j暌yo=ƒ^~9"0IW TcRۃkN<ĩ9 @Jc<~c= gLp\F-<<3jeB 0Ƽ' =1~@f78.Pm']\+g2-~qyݩoLw[;-r++Q5o跠DW #U(M̲)OBܺfqxnը(0y;BmHŸ3>$7H|bټ՜5{{c1GF3D}˜1a%qhς}P1dMb k)8 }BwQΟ2[;7RPVeL=a5v[M hʒA}I=oZ;_ d[*d#!(I"(.. v!y).Wx{1 ^KjśŕV,Պ abDS#6n-(;g^wV[Uz5 AߥD/r0Z,*,&Wp`B̤J fB^Is͢PVN/сAo7 ,n=BIp;o[Ÿ\1Ys$ 0+ M<8RBF!@`Mܜ LLPSܰ놴_En .M:QNou⢰)_\/=ߊ6Lu G`]C]Հ_r:{b_U()Fz˘ 6&a3/00ɰ49A{pدv8N⟪{7SVooL1NX=Ubr bߨϸ*çW65Urmq=tNGisJwY.k<~PeAwovuu]7vFg/S4<9ooLI5x,LD b|fiHs1՜It4g/DK 7GqLҰtUgYGNAEAɜaXO`6C ZC0;P\}C}]Kk4A6O&~/]f+߲j]=/őo *U)JtBPx4FU> S u{g= Od(bvl}LܽVfzվգ%zYikwq}j4vڭ_X\mѦv8҆yY n57Y`_(.2eO/1mfDSl>8h]b^?Ab&piOB+het+nbt"t}p_ӍSb{,]݄w.}a4 9T`gڽٻ=3ica{ Z 3&զߞ6]=ƿ!;xR4%~ᕅFqn(*ԧo{Qiysv_; \ ,m yg}a<&CO" 4 qmi(%k N0u(;ZP)4xe25S*/$vN&={ M`zl_`Še6I ѳݚW/>^|<<eߢ鋏qހ D Fѥ&Rs6OɊ՚J2|ɹ8A6Z;|َ-0}?]ws]D]% G/c8;:pϊ.,5֛njA-Ը+ J^i1C?BӓWblkDj?/ewfbL`ѻc~Q[ð*&]൭6a#=ۄHrFsPq5sBc*L;p+ĞWq@ϠN_2G 6l9P``s f͂_=/'(r >')Kd=S.K?[MZ̾OT̰\b2f;`g?VU >(vp+uE7KMOC/nדWz6z~8; ,bhp."K}mE4ɦʨ)v3 6DNg AxxEuZ6w5=(qj6z[8Ė5O]b#Xyh]ߓWA@}`ҨBV*}óסsۏ[Zylu4iEJͭzc{z&nnی(@_Ap]& |뒽\ɍV+\?bWXl`_o#n%[E6{lV{G~OcOn-SF\$8ZOqSaU֭F[WVcmnԡ{aG.t?ZXgwĮ'-ʬ! 8J]%?Go÷Y@npkOܹ-QȲw}ǜnޅO ~RJZ TX*-.dn.d&;MVCA/ Lu^ggG6)V!^oa7+]dk]|W/>?QW!fs} w =)5[E)v@^F9WY#K928tȺrB˸E%3 !Ree)E3uWڋ\ZFs$h`xk,Z Ti ܧ$f$GvYualbun3dq}LSߞ6 Y+4q~YS_ 7X7"_ytjڣ,6IxKdax}\ttbhjӖL0r#*P*hd&yeYæZH<`ʢ!σS]^d93?Л&1 +eQ |_NPi#3Ov>ɄA`a %jxY -XS"Q(j /5,sxZWT&e"%C]h@'"P56n$ryfv[3[Ho^Q!n?'&t!$YFNtϋ{q&%e±]薮4JO2fܺ`W"E>$_1Kk}svRϧ#=4O [q h b@IH V5?~!?ݝ <2at/>W:#ܲoP: X1M;!\@Q?*Wz!3X& EhGVӋ'<\^Q>WjU*C^qg7A@wzʉLT}c&=RwA+8p z+{< 8A0p\ńS:9Ԝ:s),'lAɳ$$umv#Lv.Ҁ~.v1 F,)yyf:QYfhjɘ 42+ +rq`jݮ<+0pՍk@8hؘ.ΚiYg0`?8*Ջ3P&Y jA LwXѫjީvC]ˁJh, 1~Ǽxi(E7hU{ h%?74TT+.$G#>t|MȆ1gޚ ^  G41Kׁ I86LZD r;q;>=5fo}l`Zc<"#oK Z<k0)1О8(G_83q? >bdRț,PHiUN=®?z,?M7ABJ0^cgݬto&3Ƿ[~mYJK~K>hZR ghg#j4vv̲:҂ap"ܲ7IhϜUIiɡ'C4|stz`/Pr=8E_IEXL 6NJF#T