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

}zFHF&-$(j# ڲLK2>F$$l`%gUՍ"ə:Rb 襺^?9dp wJ䦅G<4Yoh 'ڎʩ'cܐPnb[аv6-7tsPƾ׷2 qЮY߭Rh{7#^;lǝws'ϼŅ=^B>zx϶u5۱{^ҭ{#LG_vL^/,7}D}7p9Zj*r5CC8mر{fh{nYR7{¹U$d )(6]C pF@`ELzx d^_yx. ε^({wL*GT>V*T=Ov7N,"?}a_N;uͱOx} 5-)LFwk?fSm,E% (_*p\tO@뚽/,K1t71rvk5TRy,}Mo /-nlVF@o;K ƠwFn-(BL{(h7M(g y9Δ۴v<3sMtYQp8N"?2=T_0Vr`# Cm̀?rg `W5Wj/W}j[PBMM-O[׉8±lVj6N1OJU`<->PN nnjq ? M[Me?]\SC+c^iG˴D]+97&ͭm= ͞ѵ[27ws]d`hZ}c{V>-7fkqOdil1GF'%i烮k[Bh-&i䩭(DvGyfmK|ī"xuX+G 4GvEʜ>-K };瓡r-=vo#4aM7̃_.HC~n1P5jBvfqxY@ݷa*RTd3-M? aH*.mz3[uy8 ;S/{Y z$a5!ڂQRuk7:=kc3aDa3i[0ݶMC۲e2T%;; a̠QumfC'G#sZV'q:wqTy;#JC>knقĦx>آOLF\֞ +Ҫݹ|# D\#27N6]f|U~m,+m04i+6LcnәsI"uE@&ʜA6|"ȞsQH3Kf'S⊍/KMʜ0ټƒLVlL6L&+6&A6{qC!͜d2xG= ? T eHhRVۃsвU{eZ:r?ZZAӥflQUcQ(*f [|#0qyԨ#ܞY<.b-q(O jJaFPʀtp- PR;%Nisc{L3ޅP]+#Lƚg:Jmkk:c(Imll$iY_Ӆ`=;9{6"t biftrDJ$;&bd0ʼ3B>o3TKhV}ca f֒BM,\X54oiV}wa](fu}PLƮ `HWLE` nwWDP'駼c lw,s܂r~7yy9'68[Uc`C^w~S(ݵzE犋$(-[;[ZDz(yI`&Dbs[RֶlnWY㟔on;:$ SunE giq7 Ui$7fcG7K[/`o-@6&@oPʕt夝ƶڂ\rBQ;.껛˚ymNL0a~4Zv jxgXMW&n54@\Nw4hn/% $4j6[MMDkdْ -}k3Î- W)rKVse ]PuvqweL[񰃓tY$_"䒞i{kC_2w& XzI73@ߠ֛K(.nC6w-x:D+8`7l,ԢXTb`, 0[(7I5\bZѼ"Tdk{Aob~msA-(Ѭ5ن"EvfURtMs0M 3@,b\| =ibt m6JjՆ8mܖ(Dյ &Uդ{oX.NSwt& ?;s _` l/sM{]ϚV96ktX'*cJ5Fm s88VKZoh;K5~,YJ4|y3ʲ*-+_cCogвeQ (.pިYpsی9A{1E< ߆<9O7j&SF~FAa@JӚeŵ2|iyE25kz%ή faݼs-vA_Qryxݛ܂9X9><wɋz 9$x0ݟNswYaɌo677m,5(&/X`[31nw0fYlbC;ݨj.X"]A6 t؉ \ui{oCf |-r4d3*+l8se6f uǜ*톪@{gZqM\bq\dFL@07iJ[=S!'@ّ}xr٩TyO]>a/| f@tR=Xr^w?C/j=vV/UL^{<4C+_̰7< ex6('NאT6jqbzqQ ~EWeg됿 ;fcJX=ZiZU/iVeRAG:߉C@bZ)B֭xG)/fʀCО(P\B?I<0Pt2ކCQWt{w\/V !XC~(x[QB+sqs?>0Δ=%AQɉy_SZ;9QT#N}/0zӑ*}C~7QuƎ1&j/J)7zMv 4psx PڿqAŒxd&qt|wu@C_5q~|m͇k}wm_;I$>#ea>6ҮN+#BpJOUKU>c}Q0tbVZ9Ul[LhגyLA[Ttm䦙qMhx){_vĐX$YFD@9z VI^xPP<.VTa ʗ6 P]OEn*{#!@4+#bc)e]5\D%n#_^cOnL&E=Y$ꦠ5p9J@Lea2N I" >yP}ϸx^+ Z2+ϫ*!D%^I)/J7aQ ~ƑzQoH[T@ Bm3|S(Lprc5 |/Gm!Ctu3`MU`0jGu4m4ox$D&ʘK51@$[8S="7s9r`쀨} z=v@H>?яJ= LqKA II<qf,~b]fXɊAP ~?Z|FVќjxCP1@9^-ٯ!R՟}!mU/L;G7q(m QF}txܡk2.!?cT1" S+L4-G#0Eyj_%O։Q ؃u!ĞyrDf)`Zҷ趕Gڄ) [>8<WO]:^` NJU13vj#>0OHgm:t#e߿|a{4 /j&44{ƅ=}MM\"u!{aG+YD # C Kz`tTAAbJ7#]\ecB7/ҬL-`ISƚ)3C1S[@וv[QM gM4ށJ|wPtN"]aA킠"as! rd~4M%KRIX((q@Gb 2R<0ōv.CeR1:g_$_mY~o aI}r沈fBn,AHbfQ4Tx/Rr He+)((.#jL UC念@Һ19 1L]aXLcO\zUyh< ISUߥY448ʵ\_4?9W"&PR]zjnf䃮L/<}; 9cVxШV].X2Vԉ0UԺ |0C>+#^H]:~JW= |l=|l)X$1BBۧ&aJXyĢ%fGm Ͱc"*?~_\ Q@@v ML|-Wu äo8(P--^8AULoD: RW&qg/d۵ZmŒ 0zJR#,Bp^ 肘c>!^}aan=uk %-ͩAI"/Ǯ=o4eOk*M"-p Cx4ӄ?/"53^X ,)XhZ= I(f)D)P{g_&oڌO H;rt)bJZ"0Xba4ېQtɂ1(_k/@,5D<b>̈́&aǸ  |NI0Ă%ȉnlǶ"]V&hTt^if$EahL4QXr= D .—bHӳx_G}Ti>n`O_х8C*KEa4kȰ xƩg[I .v^)h5aG@@`6E+I7$iɫI1#at'*I5f滁oHπHKeo9<ͥڟ5k#@0ϡ1F6REP_, KPO|sA ,f\:S[p$?ҩ Ct #D00R>}QA+. |H3erܚt>Z Ԑb~Pp) %H"J6F/ UUl/R/H}OOr] ͐iƧf}EhNYWk&ș $= AH $ Dc}9.;uʁsSixWSJqpcc@/.>';](ju )y7 }MTǮy胏mK[U#HA>MJgPE0MӵÌ>[=BeP@p5X7`Ы"27MPN||&#DC-Д#Br(}xI>HJQgzs!zeUݧZSn  ,A0@0+O0k>,I0+!XGTV͇b8qۥDV"mm|,6nM\ea|WeYdwލ U%,Hcz[dK YT2/6h EY”8ֿ I^v7Ye"kjq# {!Q_.H_p!PxYACe3+hbO\C ̂J$3²ϸ9! %p_[kbd#@ρCB*E3#*ji@7r\ƾ? 6[1,E'r RF~z?©[ M=qQ\\x8Žxx- g㧰bY(ŸN,mgU1ꋤyib0ːH^GJdq+bW?+1f3&(tYd|S8b9YZvY nsOgvCM 4e2DAk; 2UEN|rKdLI,`i8@<~Anq6.9.;_:X%[Q3fA8.U*wQvܕ)ؚe= M34O"8~y(sw;ͬ0qBǽ3*I'3'.x+ΧJv DzMܿ`+p}TM,'TՉ<stJ筰Nm<isNswgr{)Ud)V^] j4mk-Rޯ Ԑ7?enǻeHH7vmB3,x΀>[uhᇷI̾Xg#Ё/o*2>W 0ICj]P~| ^1kzmCķ|+&ػ^z~~`7>jzK[7}S}scSmC@d&{/=V"dZm!L蠆 [jQjC{ ŒPj-sQGpVfMX&uɁFNc5,ۭ3.muLTObYv }m*:<|unnl57n>m8zJbFMnŏ:~b \|J9GrU~~Ljɇ -X[osg/f׊A;DX G|Bji%/bC}N_.4}u7Z?{g|~:/19we[-kYKB"?ʘ㟔-lP)+oYkFQ:|HCmyѬ}XB)Joۦ<VeZ]4.Ψ7Ծ-;3'p(X cjm?o|sq[Pj,e`_20W oN~,fx}i0\@h}+t U͌!d<ǰ=>%;=y I{Ѹȋ|}LGsʳЋIn#Ss+Չ+3B{{ꌒii n Ma8ebK:mg4UlY6-ж7Fl'pʕC/YK4h ,O B %q/ítR uC#=ƃڦB>T;HA{ 1W,[ +3}p]]o x`VWd ԜW6P$^`'Q33UlB,fl52 @h{ry I83+fe8<dsUd 4ע߉ϞBr"el_oN֜4 3/L0 _`}k=РwH "g1pWベZS`W[XLA -{Yv9t+nq^o B_&ً-xPF,I1]lأ#Pv -(U/o2`OqI?'+@JIAbx 60ao8m7\2MTv3@%x;&I*d=6(T8 A#NJ̝4I҇,c>?sfS=(p1(x+- j-Ttl Csqd<Ϙ]Voq!"rJz% /$huEC ;`e,`:aaQS%oH7(sB 1/^Fe墄(C1L1q9I#1%9bbv*:fU{$M,3gJ d3` FA6гZA0%%ZXh4lwLDt>49czACUmzDCy'K4 Dl*@&g?Ӱb?0~)$&Qwd &(:dq~Y;3wU }E.EU>R ei3"tYg㩟Sfl6uR鍬USguZeLL1q(` .gʐBedl-&ȫHu^ O)D4b3,zQSO:lA Jla^dKl$>E>vX"Tk/l(Ƒ/6qm[ErHn(U$+)2 {OXi,Bī6sBy9AHD0*=l Uc/25dްW[U~^P/s3Gl|,,Wo.#*)^i5#HB@k@y@났d5,R*&4b{{@#NsɆ)(}\dj^gB ͍[Q@e*{PR|/ v ۸` 9 i-m;70Tpx,`}I="m ZLnZPwG^;C*!p-SQtx[y 0f f\lʁq"z~4겸-'ޛxWSߛ˯d(ͮ({Cڀ97ɘ(mK`=/Ef,OJ?*ۚo6\|D|*Y\Ebhbl>~C`@zxZ4Ed dEa%U mpsd)%;B2[YVhF ֮5{ҕBVD̎x\CH_*Gکm^ 5!xz%jlVJ_kޒ④MO `Tq3!P&C#1gVA;뺂]q%N~ٯJ{]oeaRQ¤v.-s T2' "aK2!ʰTqԲnJծݷ 63]aZ{@{t)8R)" Tgw~ IX8l0"2#ts\Oq`<t#܄d` {UcЖ m)?хH] l.|(n;)k8gGxvhֲعe-Ŏ@Nl/lHVAIlx#2X=-U. a. sClW۷sbx::`8;fJ;̐Nccн~` U6"X-wRx%}3(n5}YR݆C3suk놺u+r犵YvCVcnm47J I(>?i 89:h\bUt-ڮI* ˲X< nAoY B^ɞq6à}jI3})|M 8}o4LN9)#9Mn W0Ay6bh*ArFk7c~\uDby/c`pz[8] Hs__;R&S~5F!UWlm8*} 5)GkۂP ^y47A |uѯ#)%O28aly3glf*d%0#?-Hª?E7o?>t^כҹj;[a똧kxp}]٥cB`5B_+|؝[XnMtdr-0_T"tJ&yXh쀦xUv$Bi6[M#Lty3g3}.M\l;E~G]j4K*Y ?gf7Қ[[YeFaοzVa0 #^zC@S޺K#;BQGŋЯ4㤽>#T8DXDt?{Ü 65O`KH354mH\Y2:¥Żo5]>QYV; a4@ٺUKg 0/6 u<=(ģ(} q-ޏ$NI8pDG5f&PK*qXyn3Tܸܸ՞'_X{~o5@6ﰔoI7nE3] f(Pw+]./Wp).j*f  C|0UPjP;Fݵ7[իOOݿn͋Ued=۵ouwStQa]ٷVy6WR&Bi2}A 2L&WGciWK=ҟR=i[@ /)8ˤ:0GAm0֓R2ݟ$;?kL[븹!ݻQ=w?3눗WCxjğE vSE7`9cim3HdںR3ʞ.4jkvKodD|WTJE|xQ?oe/]$w+)['UNI6?+Z á0z_%205w a8M(85x9R$ =|$n JT:-ރNZ&Op u+*y EX=p2L[SpK@6,iH*h~ϞֺkYu/oó_6^>MEt@Lo4w]V97uA)x(4TV $Rr|V=6+~V53 -.G`e/f8T </'0rVsyݗd͚~#GqʅRIq&1Q] α=3 ճ)љdn%[RCVSk_KR y5;([^IY$~"I- Zf2mVZiBPa D lThYh*ks_|arym.wz[~Xq|x]m6l4/c%_\,?݈T)uon_R;QJwKJ*]ܷ(%"1+bu|3S4BW8tՄd]z!̍eܼh<:,yd5~kE94Ka-j vIW3p+G Zvxux~{LSƯƹUfi *. X7_ztjʣ,6%vHxMd7bx=ۜwRcjjL0rҕU(4=o<QW<2X`S-Yq0eykAP)V.o|/)6NqC땶2/>/b7{=v>ɄA`a%jfe =XS$A;^Bw sxZUT&nߓu6$C[h@'#56n$ry?:<#Iv% z|oLWV}LҚeFw(LV)*svcԴ*g(]ɼWsBe^"7$;k=?.|11C$Fa3ՙ#xI4.)b9<جǝB W2cދ:4G97TGJE~+mznVTe+s*];ݍ+z!g)_ Ep|+t lw\^QO+r|A/ป3G r,Ss=-&ʲōǗax 4Ow@ qh7}UL89sSv=C˩3 RHI& fZ)$)ͨ(C3*j3ΨJ܀~$aZu@Tj׆{Trsl̯6/3^8 /~mO1Zh^^\Kk3CӫjXCCAZTJb|;7 XL ؄lh a;H1Lp@|6N"߁p%Ha)^iäU>5A`tOmwt9ǎ}quqp5&CVObt(rB<$ ^g(1qto%vmF`BdZxD\JzOS.;w޾06#\,V_PI  ЪۻVzA&3nrco667z5H}ƳZ nXdOe) څ|0E=?eh 7wQǽt|Ò{ "ܲ7qh쯜U_qihlf?d:{cYv)JlUbzlU>?h7d{? \GO