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'd&D  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~/ߴ7wmXV}] CL +jC]mQf!v\*6>2w;@vխ68V&Q&`3C=PԷ kz&h4Ȉc[mo EnrRCl,4B[a4&.0vi͛q.gKۦzQ1^22con`jf.#$ko4Ibff-lT:Tjs'g,mT^&Z-(R;fcfY0[ؤ\I ظ E [ @b,|}c&@4"-i 76K@J4ϊ_0%H &+I7@K]6%Uo0Ik.+[Y?P*|qq50pԬ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"]Ek;/ B9a*Y6)@S - # vPU'b>VP(ǹT,RWwB׀8}qq:Q&SHpd>DEFܗIϬ %9QԩDX*u2,Ÿ`x)|U"% p6HBPX3_] H2+IKp%ꊸ\>jxK.;P nP7\,V%ibh *ƻn)McAܥ]*Y5}5]rnaR۝wxemt:oޕ7\w͛賻7me-w^wy@t-n:Mݽum꺍uWHgVnnݔuԭMK(z.wUdN$RjAnޤuUv{WLƖMΖ/C˖IDG)R{yjU/s~bTd6!*=Ow&ESRG~NQԵaHJӚeŵ2ziyy25[ r%.n ga]Վ/1=-w')nC ,>zEoG |v\֍vsgYcQɌlF#DKGţK(65ov0vZsz75-{z<~iIAl܉F/,2֍Ib iH'txX1%,Q4mII$Vd\}Q)Ôdi$_:+yf2u׺; U\߲xxX3%p>o2[&CE,N i{3K{[)U\^y\z;`SN]Ք"ȇ;!+}V=vծf*&~=ԣg}+ꏮB<h;!2 YuS:c,Vﭝ ֕oP\s;5yOVLS32IEo:됿v 蜸VaJة*VZn-.o &TΔҽ*mu݇Lٲ3F[V3V0!F0{7IL)$ISi.h]~꺲n/`ŲkR@x5b\e)4ƀ= 3빤("oIo|z%*^y}pd@id5} c<~"KfM4ߚL' +34Կ/Om0_=3Ofx$,"SC3_xkk4V-9D& "bҼx(E{u޴hDPBˇAd]NċꙅG3QL($*V 1fz8qAU֏?Pd*]PA$(R"\U&kkϘxR`_w£` d(LPBt0)_30'dF2khqsH(@W (\=8OI:P4` E8>~Nj&{*0GW팩:S0[ԫ {gԩH,2 yp %j] p Y]nju/6-;Ld0 N4r>qWu#/nEB9œr $ r )|艱jCE#adazS׍31! 4wÚB 5i2O}mVizqaЊ` :ʓ);~o7}0t\ )02Qk0:n;~wR;!zkˊ.|ĸ*n);$d15R0/Cg}NǕ&@8B8쫑֊F\^2B5w}P]0:wJ_ x- 1q/AGB{ i\xIOOxgN耊V%2Iǂql7atЏ.^ oOL0s-%>H"6w/4D; ::L!<ޔlp2,!T= eEo6x Q__W?9QL|Ps|pҥk2f?}T2e'X%^-%y}>SEG'zԟR+a^U ]hXs>B3.lCgp >ة}Gݶ D6%0ȆY? .IɹJ1fE®qqb}8/CiQ&J&b(HA+Oi!%C`mWSPR,GϛYtAQr&đ`EJ,JY1S9*hW/OOP?#l,3&iO5[ѵ@=pPaF`伃idu-T>UESg ,fcѰ3M݃#nkk5IYǿ/;[Ey5ipx9:wv& c+T+N`a #}Dv+!X[C Q,AM#$x&p0%ӭxa-L&M P85AG?N/gL5U\@u#j[J F*4? y!8g#-1ѸS"k3K LIUz%Ljk84` Vx}Y: X]T{%XIbUFQ·ax5$vls&A( v-fPQD^l6Q@l)K{= u7Ye"kjq#{!?U_hpWY?έd2+h|OXĈ $݊MAaYGܜz 9p$X[tb wЀ1_㢑Gqp-xfyD׿Fy +@ }܆1&up'>ifOq&6Wۚڃ^mѹӇى<`(W=tbWep}/=O;pf#@Pqc[X{kna.Xtĝfq6;>8MTyZV7I„.\a! ha7 >d%q-|w?1V3(4g~ _NV?]GVi/ m %s;ѡWE&"@|jlx|$`tQAY(O4)CQ #e5BƏn/.2`Ky/`1%e5 e5~8̗bu {rti ~ykwC;ͬЧqB<35AHxTxtkā (V{LN1'J[\6E |2sxӿX$0>?g@a0x )qWĚJ'KlMb'?UP p3$*CBnWp&i%bť+ժX-VF%$l}uk'Mx܉>HQV/;D(G$@9{w^222, r4|08, ܲY1pV0,^Xi+= kkaH\X qݽ* w pS73:,E'7  x< )UHLQ AŞYK80m]FLփCpwM[~b?<@&',ocU_̀2bj< S,I0nĆ6|vyO}SQB 驰^})q~jN)!__Ou0'q?Xp(ƃϤ ٹ =K5ʯLss?S>+$*$ BܗZ[ en}w!牓m<jNj(OY@N2 )vI!eLx#*\ ȏ͒33%2 W$½_B K޽ĵO>$SSU"wd>A筰>M4@=9;öZMb ۝w)Wl)^] n4-_-Pޯ )o13[`]Ibg3l',؛\B{bBj@0AyY )}H >/~`+&-ۼ ${ R{뵽fD7>Fۀ7[ҡ5s}YoH >baR!ꘂ.И4j^ҐYJ`4.ޓDU8#=wK.L;ŦJ f'Э$1Q)A簦YGHZrT@yQ2WnXI"% 7hd< ]Hf/Xd\:~-ف5g(|7EکODǟ/]ӉDǕ)R|YJ5OK#qHtlyپI2G~WtRcCZ\0Bcl-G)ER3TPZ`b [Qj>BHKz $<虋:jD UDt х?OHd.$0#(s&ݓq >VTyNݑi` lVxqi`svkLI_8f-~kbnn/_I%_B`%*g~??}$Yɇ -X[osg/f׊ADTsBsdtBOi9}8z( &_i'd\t9#ǀ+>*me5݊[JzW[[ ʔT-RV2br:A97F0a wOVԿLTL)r[Ӽ\"X/xm?Ҿ/ ۍ 4,qi#ef;Wj\oZ}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+xF@p1׽#"qP4woot7_.|y:}߆ru:)\* o0]j$%2Myi}L|Y=[T׀_c#^t#D-=ɠàRJ, /= zpt1meuф\8sRhPy+ %.&4w'O #"*(GP7}d {r: ,'ױ%xa? :إߐS&7BAH=Ti|9s-5 Y,ô>&N':a8v#x3"VJu#" ?ʆKw)SQ%ڰ*2y'ww}id#,ƻx%zZϿ&Vn[qc^ZB~cw3_\-7xb$/^qv|Id:/e.2Z3M882[Vo9P0Suݻ,ic_<JcκMr (oB|Bib+KA`仠MP@Fzx$M ~b Ԡ`х !B J%]ܓ!FQ#ͽΰ'u6BCSl3#6 kʬhBnXsFQJg۹!F&- x&|8HIH2.(g`h:'ȷZK_3"C]gI ;D;beR͑O#SR0Q"+wJ xB_c{( Rk?ِ&>8Pp ???8Ŭ4xٻ]bRqBThBjCvQ5Q,?_]:>+5F$^MxEȈ[t#g}?{ HF##'w2vrH-<<Ưxsž)myw^C'-! VBM> }Z eFX FW "Bޒs 9TbHqyz uAqs4&Ӟ# ixmDâڣe7@\J}p, &cdx2n6 @$'#84BkQn( }|8}eN{6sL% 9bvp#Wp#`'{@`[! q?~­Z&^tѤq+WT$ǣ]J< IrrJ!Ufv%Le`@eH^*ɣ"0&.%GOČ)L\xA|(ZP)U"0@ؓfN$K#>lf݌NLXTE&M9 vUC'Bܖ'[6>-Kl?6n4.MgL+t,)Yaf| dKoq1³}?el"֊~]ӷ =w >[͍-}\M-E\;[-IZKغ#F׮ #BUO }ԫK -!݉|s$Թ*6Fk0mmn_lmBϷGd9FM28<9y!'t_t: ؎`>O텴{u'FJ/~~ƃx4{,s ksn%+GxŒSF4qт0<ŀ 2A=N+%*"N2;^M*H]#p KRi5I.oVXH`+mռcM2j,qOƕMi2œ!o;SmF`HTKHf*8iq2p?Uw( KocUq`5@4Y/X)em?geY7;o_nl44flllo퍝b{̴JUwkB%xV7J[Rj ,ztH~EѠ|~_J?X#ĝo.({5}]OfB;| Cu dy򉼤Z8UʾI=2ax0+8_d|Jޓ":".Α tuQӣBͩ35>ҨgI%H䱥PG4G£8?p޽4ߑdƉ1ã.cR^h]C)uSPkk%yv^[SeFMY(fE+^L2A {>i/5nOo mT;YA|B6QX\¦k~5m9凘({_T45CQ+e>xpq?vB\hxswpzn90h;h,ߧEp5v}{uˬIXR¯z (7,y8iT~pw 3>'lFG~*1hZU=#66-u/B`Qp~9cjoDSĬtb pޠ3ppoV6%ؒ&chPl