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

y68w{`֖b[ _&8vIL(R%)ˎ?3Nz&`0<_>۝Wr-odS?)Y6Ȓc+Ydm9I 3Sͧ~"ܱiSgTzQ$s"rp` x< 2Ylh(Je44?UΆ^E"'r#g$=\zvZ' T fzFdv"0Fրu=Xӻ ˋ1yi 4c(/l'9ؕFU `4@? O0rLEj=WL #+ Ey +,S> arp@r;.@Pc*Jʾpjo:SujE.Y,*(, )0&0aرmm;L!jIN@TKdQ%}[IŞ퉜zދ{l^n.A}U#Np/543If? 7WSBIh^ş+r1 X*Aw!;W2mf MMR>AVVVM*Ŵ-+ɱLnaz% @e ]HB A$oIϕ$d)qi,KU U%y+bddd n-pA4s [~ hZaxGY60D3|!TPUJhY=@3|^:r?Z RhӦTgwJ<Ȅ&F!-߈$ i\Yj`xfaePuQ%PiX[^;ՔwñJ/RFc$@ߓoNp88FU$ u; y~\iX3,wPҚH{etV%iYNƖ=BDfRDbiwrL $'#c@3+A6֕:ZJJm-PMwZ@ c-ӛjnV:k:ؕ:&bW}:+#Z ".8po u̐~a°GV۶Zp<0CΝ0gqDƛ744;Pƚ""§5ۃ~c9pYÔ$mf:YhY?7t$TJR1a`/5R U?Ph(me SyeM+pM!6IUŨVX{x@ V5d Hh()@Rʵ|椞jK7M5/F9剿Z[ҮovuE46U?}[a(‚dm:U 5] NY24 ^磢N$ *FK[L(ڄ43 qfgj&@f#3J)rKJzڳM)nMtP# ⡍tS$ :՝FrITl7\`@RjЈэ4kٺqŁu(U௃a,5V^&ZN,.R;N>b`ͬ `]ؤ*\IU^dH@5 u70_kh@ZRj5 mihfYY,ux :e%5c6cSh5ը* iZsQٕ5G/8xR$@\ U.SZtzۙ0/DGP5Љz+pX  u`uibOeBTIqRbҾt?W1:dc4ڀ;t0RcǵW ހiB.mP`QyyuGZg/NyhMxPeb= I̧y1ItYaԚLzfm(IN\$jEEC\e1.%3=^R*EJr:ulT,e 9EjKt 0l$(%Wn+/Uo:*hQ -/[kc^,jDqk JzvJk E 09y7_Sk*,5vkjھJ|ÊF_U dwu$WȳoR$2{a./Dȷq7lȴu+^ݤȮwյdMڵdՍq+eӆM zsqXlU$mSqՂxUUoI^1y=fE:h(Xh,.p~UV/s~bT .l~ᆘVyZjR4uW,|$0/ ]\Vs}ˎsxS" Tby΄4N;2o 0:.F~|\7+UT*Qp~ᱹjQo! ( g}uU*_\y'd 9ony+m0C5~N~tEc _ h0;m@ /SL>? @á8*G; +˒oP\v K\6MU?$IA^؅'sZ !`wUr;q9~/_ G{WRwE>Dtjʖm?=^:aۺe?e6ePw)6{=bPo䇮++ ُqXVO5bOؖ4kښ|3`MY?a1X9*x|1?Ϧ?ɉ%q4Քy 024e@k@sYP]ys\$R-~ W&.y.wʿLH~g6 Ϟ?̣+I%`aE:}%&?TP ׃߳80ڢYzQVX.x]$٢|-<#6g$[<,o@ɟ9P `8EhOm!?csTXM8ޘr^_pf>VԖY ""bG#ʏFǥ7{B[-yqC 1[qWq^/#_H%`D lss)aXߖSE ً7[mHhD 7s8(:IBs?,yP C(9 y8.@L6tT,}4 OH0ފhS` 2ʓ˽v}#6Ka90q﹠  02q,`: 4,wtc?ߣ ܵ@\քϚ2Rd'Aʎ -0ژ1/CgTV Mqp03D++sVi _peUqA++~N2IBlI{ 2ڻf /qaX$1XC3 dBX0ρ0xD;"%ݖq$| fឹ$"18mg ҃#bgVG>MY`a 9엗TUfSVf?ϼQ4{{e(<OM|PfsGd\A3GkPɜq|lOx̖余LQ:T߃Y(?ccJMdCC:742pRE6.|-VfUYSЯr1kO L)dSѵ@3H/PDPAs;;.PC^5;pγ!2R<4?ōwHL2EH/|3%(wC,}Rr7Qh0`<9sYB3!GOA)ĤD:YM2Ű#+8RPj!SH(T^ lC'} ecvp=3?䱃ch1qʎ3O0J~Lܲ>͂#\E?Xf(ON(>yrrHfȗ8;zd.%73AW[DtY&dWB}; * B1cX:Z._x0E=lF8Gf b}W~yn [HM8~R_y vObc? õÒdp>PNto8WuE9J͊0@?ZR~)8K=hg;,PQgx9Y;FlWiwt\9*=0b'pTE>hdÌ2EF{d#A>F9GGƎPԄnf71Eg5e&}@w.TU03;;$ 2,Ɩ_5MXF/IJDE%"(*MS\-y_!,5D<|>-&a[Ǹ L|NI0޲Ă%̉^lǶ"]V&hFt^i'90T xY(P,y>ad F%&—|lH|g%t=Jpu}.ܹ-]a{wGҤPF]€g`-U0))_P@+5bC 9lOR2w$)I`p@XJRG<0:Nb滉o @HK rYښ+e8.Wͯ'c / / hvtTل+" $.IHq.bv? 1au 7Rԙ—%[%1N]4B 7 qJS,p[û%rPG4Z&ǭIOB!b!f9]t[T1R ~9p\ZTE`{ezA!y>ߋN/5Cd. :yoؕ_%,\%3WI 3I Ց~qL4.5NNUz%Lj<0AGdc1@2E-N^A6%?N_}xE=Uk%vm^I@U&R8<4ӝ|)%A KDnWg(oa4Aa𡜄J'4D}tC_sWDdyo3x^^%p`ev)6~M8zOava6g0;0{5l0;aX#RW͇8quڍLbu?>.X+pCf(GG0R8vls&n̨2-aAzӻ<[h\>y GD-,KW*YS7^3}R$,RVPY S'"%)8 n&`aY9! 9p$4b wcB*E3#Kib\ž?6#50cX8_36LX6w?y2|?=kbѦLv yU_xKm ;nZC!"pY6*\ESy>N}$b +Ys8}ǹ-,Kna^!;G%KP8lV>8MTxZ.+/ ]8,B"~n)A| NV!q-|cb?"H dM./dkud%ưYܼJxUd /1 R{:氷&/_: .*,]Tpw6 MPF$+eH|~A)krn/.2pi]_;c ʀkfˠkRqyti93,\0DN(\ӐۤOmؗ㗇<';S },3>S246H܎4GQnqq@z!rw1'; epsyMIL;`$wYA]HӃ'TW=!~b8 Qɦ \%<%!2 hq Fy9,&Q]}\lv /x[o^ՍFUkdg:# ^mZWe zJ1TuVϺTL:#xW2Oaў%ݒCpM[ ~b?<@&',Էf c:U_\e8oOQU0HIxf',Q.tmQXgIDOgOhMτՏ2',Q r; N<{,Э8K3Mq{:_LHFv/??5Oʉ"G YϬY=yrAt/0;`0?g gRc٥3-=K~ޕ_CRIPX&Q&0ྔꊪr86;zJMxQe=)K .L2;ؤ`e6_]Iݐ ܭՍo|2>-^ | U ,yjk| O| #Ht!UU'',O ¯2t<ůR$ٕk ֨1 ۝{)WlY,_w4DZ[6?hjZ*T<_sS)b3X`)bDrDR5u9 %ST * Cv "'rs],\W3VN n +5PSۉ>{QTM{g7!'kttt%a?_|l;o` Z]!,@Y9 jC * RxX*ϛO9?~v?%>[͌;I wP)tL`+FVu~7k{khJK吁d;daQ)6_!D$՝Q%4r)XQ@$>_ |"f" -P٠pJ;EMQ*5*ޮ'$wN|ju >^COdE2Y4Bh.M3H.}.ف5_̳_4)'>h RBG鿋jh Ht eN/)-T8]rj?um;of/-F-{T RZ;R^3#RlijƶlbTjE+ a"՚qV3Oӑ,!)SʢM;*E2 귥]=xfLnq7Z3V_A݂Rd.F3op`M@tA$̆}:6tl'N^,F^33<6igC0"p*ڬY4U?iN9%=_Eek%)J)NU+3({cX=KAŢ @\z` qɈI~kus9>zhP "nEHx/\Pu>&g+vCŵ!t?7 #ݤ)_-g`v+V!oI*E%˻ YQڰf*sE2pC%@g4P{kt\񄗖&?1_\)N~x[4>pњ9+ĉ)xqZz9ƏyY6R   gݦSi9xBBM_k-ێ7Y":Pq1x.DS~/ j<z?S bPq#!D#Aɬ?q{rq~Y9Kw[ d X>w w̤s|(ȅ|NI/"V/|9ή3dIۇG;[ GgI#߷m~$P"Z|Z­Po2w㑆hL۸i6!Ş@3QhVJ:;`L I}ܚIw!@ICaR`mN5ŋ$:5 rC## W?_~z1{ \Z~^_CT0D]bh w뵸Z5=.]3#s"ӐB@R\Xn2حz>;"CJ玟ļTg 4X; $[xIJ\{/ƀ\. Mle~ArQ&ݺsPﻶ,/"43/c+rQy5G gܲ*9fi< O~PP{O x{AHCJq$Sϥ8{vA&FU1]H|L@[rUp݉ch0dtSNGk ֯z|w w)~[ZPtnӁB5pSOܮui eoV^Q2yo[-Ǻf mhlSZPuՃlZӢ'EqhC8qu XoNJZpU9|o-?m  mkVmrȼF%w :ьj@IKln&rjr#s-MF4&ǠaS.-uRh:upr,zW]ŨtB`#G. dW>Z!b§ +H^S% e) N/er]Z+3~V[ tALu5j("njF mގV' O`Ғ) t Y^aXzSUAs Ѫtb Af@lXH*hv!แ*RApQ3T@:iG'eX1^ﴁ׀*3:H3PD~ڄƴ@K4@gxF7 ۿ7QQ`:jjP栕TEYPx)XKmhN 2ig0at_:zbŝMmՀSNCǴG:(4j@Cw;ZPxuґPvP3}65kB7Om ʢ^eh:aCŪ2GNϨ_aHc^ LгͶjM?+@M`sW"2Y^, fiI2QTʔ|ʣ1ơ̰V#dXnʼXKi2s`}r^n~DO>J-Ttp` HNk&D$`gH jkY {&:Z4ZAniy>n6S j}6 3$oS~T(aI,m-RnTK. O w8*58?N{4G+au,\M>~Lx_us`Q4^2N׮-_{9fy GF S1b9͠C-nH~FIs?UL Ne`৅,Mly`y. #Hgs/w.:@ktG!{fl3W3mR:œI`. E(b/QJʨ20?ot Z0XQ}eAlO\79tBC-"YCE񴨕% X*_7;T({ni]Vt抝5^1FE7*@I^ۺv邛kOa1G &l3Ʉ>bVκC!HMP?ۡwvjѨT}1hqF#ωƥյd-ƫՁ ( i2C[Ƴ]YqjxŤC(&b_uV+un_G9u۷~4!Rȧ:Hz/} ~'&ostBV3ŕ ?rEffW Dc&pW W=Kz߷-V{c_b٫37|4+l[zk5pv [JzqU kb]0 =AjW«jZ:9^)qD~9rjH7DԆ֨5 <Q>kuB7G9gzh*|9.Zo鵖9os@_JDNNءP'MͿ`kނ#<>iuO`Do!xg(65E <@}N.^ڔ~#@ {Hq61Ђ]uT|Ճ ލv+p BZOZJI:Q,m^'[SXQKI9hBy&-GMQq)Mi:sC&Y~0ǶZ7/żGN(rѩx 6~[,RN?rw%)4 7\`smyU2:I]T]_g!&R}ѭX/wu ߱(J?f*MV{nE}ϟ.5oh$V#~SyǓFR4 贪+DιYZX󧫅mnEpJrҹ.5o Wֹdz_K*͂ٛ7OI=}(WbXg{!;|n:/08:5b.+,fhaө 0 a2s%F½M\xu_>|vZvcTiT7Ȳd5*g_*Č:3e T/)ĭ_r})۲V;Q-UbVTut]^']bOfu YW,_/VG$5 ml<9 @qsֲ*B6/c'!G]&;t šÀ(40 JT= k!@d9 $Qh /rEV9mMbIo.]gCSkN %QjgQ%Q(aJJ!w;|ZhOrab˭p qzE(W0fj|?|ו}Z(@t/1#d6}+Q 4\͆&(ٔ%?$Gvj Rf3£p\NC rBY0`rWϛy>A'w/dbvƀ+WWʅ3dc>}]L_|- y!Ý~:s ?21)&YPJL@&?e29OCQ@>РEtD2+\ ''tXgC?`Ps̥VJc#%!ɗ ǖnCaf qt,3NÌ+ĥ62bLgWz "t&%p ,!J) ]^t9 V8Z¨$M #|GPIPA_;;sYh|R2$p<?*+t|0ALC8-O,^G/Us}_2+l̯tе.`t,'_"oЖ+s "k4}^/<^V"΂-W] =6!P]U&\Rz)dfu .C跊exANV7%@F`6N(Jqg; =ԚeV$,)Y|4-x ,>Y ƾ cS @` &%&37r.W֙3M$o6XށqLH,P* arջSܓ{b"X I!W%ZթFi2qkT'<iǷԮjf-P*~w9C<1l5V*bDwvЧ%4c--{F¤3-KjSĬlj0p^3tpoVmt">>Vd{1(G