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); } ?>

}y8AUgSdv.J6M^Ӥslm%$hHl'dD  z>Hh+74eieJd, Bڶ{֘'~R"ܹcG#fgNiJDjariJsMye4 GQ4 ;p<~0_ EN@j6Miv0ል>^:΁> j [CMV0dnG"E#Nz}XB}CY'PR܈A ̚L\oEՃ0\r Z`> "B P>pEJ[Va {Tj`Գ0rf /l't};BgDyh6147c1qVgUdslfm_Y Dٳ Ɩjl6%%zZ ޞB*Jii8gI5 XS)ciO*ӹh }t@z(4$3Bb:Q 2aEWńClZ ^rr%3HL҂E)Cvl/[IO4ڃ|DOy~s]؜\t+F!QNH!r܈8pɤPM‘ 7GrEY/`L3hWiJTle4Ro|DL 'Vu<<&1Z2ym fƐQ_N8qK(汙NU :`1f:ڗi9"5^jœ \vDb9p 5tǢsаsr3=Sg Lc%e_pF:mbEY,*T#v cah0pȱmu'm;LС)ʺ4wt}#ͷ%38)س]nq͍Ÿ9hv;0wɸ9=Km$1YUGvo`2c4gF~X|V#V7`cJS?l!41)wr6Cܴ"hWeeI^iܤRL[bUgrK+' Sf%R "yE"P<+IH3K f'S⊕,KUYUeI^+UU] do#dUd Y[Y if_(d]+ s3P41b#&F3Qp SԐZV9?  T\ρtY4iS %D%Y ndB&F!-߉$ iuw6 0Ts ! SMa>Q@:9; R(e<s({zqI ja:x;h 0+Z63sr5}ssu qE$CoZIZv nf'TcNO "3 )#r.{E-2 '`jDOu$:RZUo/j"Ps!Pk.vBH;uc&bW=:#=$Q".p ù~a&{ڶr8 pA5Y9;1qDr6wU(c{`C~x o~oc9pY$6E<ҳ~tabP\*J*WTln)R㯔bll$ g'"{ӊ<\P9F͆jl7jK)d47@† J4֜RۛQNs~/io#ڪX*,VՆQ3T=H,C8 mTl&}dv$ *ho[Kl.q0LMhfzro/^bIMhǶހR\Y@iu&ThMA]`4Ӛ7A=l ]V5Gϖ(Munbdd*0\GI ) h00ZFsŁuN YڨL2[ vCkQ v|"(͂50{a7I5\zqH@6XMhE [[ @dColiM XG#-$,b\fl-ibt m4JJJ`\VfTZ㠁'ſ50pԬ4z3/DGPkn@'n[ r*` 0l-cC{=߾T+IxR+YHyqx"?T]qTct`i>c[gaGkW ^i q%q 5I`G޵.Aj4 zi*t9ܫ2b"x\Z3FF#m+m xWKqEJ;p8vT,.IcM9"._񢵝ė !ӜXl,xa )C ]X M; dx\1F+(RU*);R!Fk@s8MktǃZ()$Q82vcIˢ|ˤgֆ(E|, L sb\JJg0zpnJ܆i~]8UQr!QtVDW,V/`Kp$A$%wuE\ | rx5e[UAEj(7V^(Vc.4tH U{SRxM7@ʋ`c~ R.,w.K 70wNz;V6SQwʛh;Mݛ{Ut_f/U[ _] :XWm| vZ^:6uFwݺnn+j7Un:UT% v=Ի*rXly'V`Xy7oRʺ*=+A_&cC&g͡eˤwc=P\S*댗9C}1E2 GSu;U)#byzJZZb$%iͲ`F Zgy `-R|xQj\a]zЗCᖻG`W=t޷# >t .Nck٬(d [[Gm,5A/&/Paضasz75-kb x@Ӥҹ_>HoYdHg-;&$ӐObKX.i8H9S).HtWPTeu)w e9 <@)b*YVSݫ(عvQ{! )W3EE?vBVyq{Ы]TL){<tG# V]xN3vBlRSUnZ\N- M:ߝ)5{UrǻegP'p[gaC=`M#&oL9% }SI 12ߧ`/\̏Ѻue^<{׋ex?:klSh5|g!#*ߟ{ tDg sI7QD>ޒ LKZ;=U"N=LSM\Ȁ)T?Zk?! `AuǮy2D*՗h5qwN(Wf>h7i#_"` D#'Կzg HtY$Ef-P-kgP>iyxLƗ\,䘦a%Z6VmDAjڪ'˷~FheM)'`֎?"{z{Ff EVPteI?q{ nlꍁ9Y0N9"Άܨ!4 1@_l,&Y=Y.aN@f]B>H.`a"N I<Q|,:q_Z/*8׊"-Qt 2mvɊZCTTy,G?-*1Hx[^⓿K8&'j1^ B/'ר2ԕ8ޛr~|M%8[sd5LDŤyPfzE0i$3T9v\Fsj:33 0gP!Z}IU@2c{?\-̐?p₪z=T$_I;Q8%D @sM :֞1]GDɎQP~?1=>#`\) S7G5uA;gaO^~eQpmD5_Q:_zp u>hpy}԰MU`ϏSu%  ajW4ΨSEX(0d7+~JԺ Y57_2lZv 8` AE٫!h}G^H%`D ls9HVWTxSB={cՆFȀgG'kkcB@h5j1"k3i AҬe (۬&<'x+NBt'+SvT}#n(6Ka90q0k R ad,.`8u,wv 'Ct!Q;]q_CU9 >)Rvtu@E4SOΜ Jd, co7'?,R#m]@wߞ`Z:K}El ^|W /h<!v`utԇCx);+eXB%5ԩz@ʊlt' F`Er\NMKd 5dNA˸O{y.KZfKT}(1N߃Q?2WϽ: &$}9g]*3īن|Sm\9gm%&6QEmJ(a .&5sZ L]>#s )Gc̊]xژ p Z;Rx8zv`3!Goߘnh7iTtskI} p,_"'u!G]nG+Y  >fHw]ELAabJ7#\^elA{FQ@ƒյPSk~Z?4>ea4V/ ݼI^.۷\[@%ԆNҳN_V_Lo];Y0RutwMZ{-=PԌ>"2lp0DCF#pߏ/s D~x9n/-OA?0\#;<>vxZ_Q_G(y{dzf|.r~fU)'OOɈՃ %]më́>v]Ua&ň}PcsoICQ<X"Vԍ0ʧu^:8 f$88g$tlMKC[> Fǥ*T\F.n 6X(qYIp #G٦q .qmV_O;E侍U -I^J7Ug*0R:xgokS\q`Ȳ0R3~L"V(05O\;_RP *qExAKMrkc\iIݟQY4,gT\};d_LB;j=u+ݫvOBp\1:"_"ۗ'Q[ﾋt(G߸YqFgsh)ڏ_j0s`IT08blO[ `J,/A04DȈXÁ=08n?G:F xGZYG Kh(>^r&;졪 nf7>2`-a&`pʩb"gȃH27KeP;u~`IX$)DTU1%c'LR&U K^M >!V+XluG0M%|P~r@[D,ceikf`qT]X-N^G _~}5 3 KR/kA (f\:S[U!ͩ "ts#D0R >}|SC+. |D#erܚt>ZkD1a~q) %HJ6F!/ )*ũl/R/H="̐&j=N^tdW t W HU~!o tCu}|1o :e ¹Ʃ?4 2Ȕt^Wr* O  B`Ń̀(ju )y}?}Mt*](~K oGp楜TB ZiR8EC@k\dTL KD܀AP?4A:aAIBGH17k!GD_,k}0#$IZ:Bʮ;.O)[5ĉ{r 3 92}/m&Gt}[naǰTqgmHlR7~q.f?]khS%;ɯ=%6;}nXrCH/}%\ͮ ׇX~AީS zj8\_8ŽxfeIG!Yjas1KDe lE}T/LfvH XpJVl߼~kx 13`By7Ydkud5ưX<JxUd /1 Z9.,Ɔ7N *KtܝA2%j0__ӺqJ*dhAnq6.9. &a+It/-ƨSR\0[]엚tO{ȁqwfr|*VP!Iwn[ ;/ᗧ<;S },3>S34O܎4GUG7?F1bdIs"L8jX!37'1E sD{5OyDY(zSMO}1 7C:$vEcf eT\LQ` gVq ^+V\N\%hnkD+]B"Wvĉw˝W`r?'GziOz-#/ Gç b- g"e0VѼ3-^DG-ݫ:/kg 7E*mlx3r\t"q[.pkݐ^ty5ڋx8[왵 3>)U:+O '7t+WG&tB&-.BU]$8$y.8 J&Wr{(wFC[Og9C ^ā۴f|=#[w:ջl4».51| S~eτ`=9 w״'vHLaB֬?iQ@ (#몦AJ302Z FIlkgGDaM~'9/ԟК ;ۗ24Tã{J N<}p,Щ;8צXt3!ٵ]`*"Qy3Cy{rZnO\+Ë b<iLj(ϩɬӻ^4p??j=LrM?a+t}UPwr86;>&pX.5 +[O```b[&ɴmQ=(ݐhon ,9+>])p|J_.{%08KL\KxSA2+>Uuj}.rG+t OH<#7;;mf; *SR,wh[v-w ( oDaav5oM.fXzq}>vO_˂} /.d9 y/ >  `%a҇|`)bB [LLO/U\ݿz^`Fdzn ْ8z˸Fb  ̏:VܶpIƤ{tPC "Uv< ^ra܁,6UX0;nwo&*EM *=5ͪ=GҺ޿ʋZ9UrJN"(Ah^&kA^zD2{Aj$k!b-FP 3FOxh<Iƿt >L'W zBHf)9̟bp:?-S_aG#EWӱef?oG*'`A^Ii s#>{K 0NISA C `GkG>0lZBG5#,%g.-TmqF$++{kVmlb%Zq5HXyjN9ORWXhn,4pR~!́6/Ge+-ğ=cn>?ė]p]6~ߵ[W wT RJykk\rJ2SJ[lVN'5f٨FT> $[{j^PД)E_U}4v/WH+֋%^9폴Kvq 8شڑ2p3睫on5._Z}Z qY+`NK1ûKÉMƿK nxhpׂ.b5FtzYs䝄u o80JR:BǁwCZ,yRlzRHx:RCw`⹠xtfɏtG,SDJvR&'uãЙOiKFYyĮ6MPf4Tbogo~ԧn:P=V~߱\ȣHw/?ar@ϘPR^M@I@AQ66e.\QYFh$8x^04BѢs`Y ˒ \3Rw A*ֺؗf|THڒNdf/+WY,bd *%Jϼ*Ld+KLeXKg\YDq%9*dQ[5m.()ʏkW$*ܓ~Og}?PT"? ]ϫI\#.CPG ^N+8 bt Bo{s|͗ӷmxۢYQMZ(li8DV)4,ZB;_V5:0G1o$dPsP)>_Sl,&+ #Bv;@ot7D6!|9h>8 -N&%NY^{|0ҫifs)c=ppE]B ,M]ǖaPcr|QP "8yD/v H xÊeC۵&!N{@ #ݤS`fc]JC,B*e%˻ȩ@tYBOʻsE2Rz mzC }y_H@+wb1/-]!?w3>u\-7x&'/^qv| Nt_{]*3efn q q M^eܷr{8:"2wY**x$,6]O3je\D& a'&Fy\q/(D[0F є$U@GBg*@ J_5!D#Aɴ7vT{8>(؜w6D&\JOmff9$~h~n2fX[3CQJ9Gc8QAJ>| $304Jd[l-& ȩ'uYR!O)сDcs,p” ݼjA[||jX#KK !M|pD1r noh999p߉d_7;-xͦ"] / v?{0 H4ʴ& -EoZRa-Id瓑 @~@7fsO_)#lbZ\k$Ky7 {϶ywB(X 6p(i5x"Ei)ϱ:Dt _72Z%82 rd@JQiM= GD+"H l>$EG0=.5_vWNd4 c[.Y],ٲb@Р#4ADє;7amڙ˥;5.'!;gAK냑51#:G Z, 9S8aa*0v%$buaT$xK. @]m}bi9 F4~WX!IA9n:|EصV]4B9yv'oRɦ%p;G^s;+4g6qe-ZJ3`W^\Kw>~bFvi}W\Xw)=cdA9<0:tUen-Mi_%qG )LJ4\T`*C3yҐ"sPҗ)(zR-&@ϟzK G]z6T|dEk#0pI5%UxR`+M;w7wiSتVcy<О3ԠAQ{:wswΰ4VO2S3g1t\_0?'œq!5W,d&Zh- Wu8/oIx+)BzNI|D!Q Cr̴0xk L}+d0:OUq$N.xP0vuJx^'!8GN)$ r `ج ,)M%ylXebdw40w 4^k{2s o>EcWk<PJ"5S`~H{2LЉW@{)}dlСq) +D`%;]qD6Ky%;zi  3YX:rJf֔,03vCfex]䥷YҾ~2[n}?Ǯ; >l͍^-}lM-F\;[-IZMغ}\F׮ #rTdAp pHȩnXkƷ]w5iۆN\6·j6Fkķt+v;4td<emVlG0 C뻏u1(r?p A2pTw( KocUq`5@βY/X)em?geY7;o_nl44flllo퍝b{̴JUwkB%xV7J[Rj ,ztH~EѠ|~S]5ѕ<ٜo-9\˛>a|en]͠]WDIu}Dɭx+݁7bޕ|*m Od7bg 6m*ʹkA M976^>O.ֺYZH"䪳 U //'oS۽0.#eTrY&@u8; :d]ZA0 jB\m,)](GzyK\>U!*\˖sK{ީ@޷RӪlp%^i.2nHo(8uqy٭ndчQ#*u#-mN'E Ba>d«s[{/R=G4?%ܕeS. H~.;W2lܑoȪ|>E'wdbvJXWG<1rX|,cVӋw:tyǟ?uE>e  1(g~'f?'2k1T)&YPd a@&~n|!7{OO9ܻC8 G*&EN> 5\ KHfJ&ɗ ǖnDaf 6\Ž{Ґ~Gr<'b F~oz- ]^t=ԝOg|k{mX5yd:Lh 2NHP?վ5Sd/nudV٘_Gmc]saIbDz?7\_K5~ ETe>xpq?[B"\hxw0"pzn90h;h,ߧEp=v}uˬIXR¯z (7,PȈiJwXG1SshlwKZpnFe|RP3bskhlmm1{;Uh S2}O"g|cRm͙({5ND1cv5ߪ)FeHTti(d{hh: