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{`֖j[ _&ۤIݮ! E$壶 Sa'vw66 0@o4f=ĿkySf{e,i4Es+'5c|갳D4ywԴ٩3b*(9cj8\fuOR\Sq,M66i~6'LjcBl?.Fo"w΃ѨS6 $?s@ ]O3ވ5(ۖQdwf̚0u0liߵ ەjwm/D1F]ކZm XBmYs'FPR܈Aӣ9Ӛ]gdEՂ0;r N`s"B P6ğ̀aᖔfxِRP-#c{{>C͵Uqkt\}x_* it! =U~"lߢ~4(bQ j΃z;̊L ذ0A00=&|5t~gSr q}gszܕht5R("sF* MN #יL#uX-,&0Ɩ0`FuT[՗-:6@20F/m.VBj>N1+H*П6(0z ۽kTD(Xۢo4}cԪ<=fȎ3-kdue(;\ ouNoͦ5:VU&#%j5烕@ń(MĀM`S_g3D&b9V (Kj« xsX*{=T i2M.GY`|_`fa)cDzy6u"skX  ˋ0ywk@hƐP_N8w (k^k~az ˿?vٹFV-8EyK+,S!@.^k0LwT]T[}u܊}0XTQXLRa>`;^_gSǶ7[ &#`C*veҝ](ODR=;9fs8N\f|@Ɲt%!_2hf6F~@.:焆P&zɝMY*4U KFhعG/3[ eL֔t9!snZkeeI^iܤRL۲b+VO[2TJ ٥$DD\IBYJ@6;rI^Zȹ [UYr+ [Uu&w +VAlAVl iAV~ hZa-1EBkBa\cgXRTвU{g颚ub Aӥf2(Mϫdy6 mB@[IҸWj`pFfam5PuQ-0iX[^;ՔoKS'0+_ L@1kI''݊x<(qJF1JXQ 0+b-ӶfY6$0ƫ%ZHҲ_ӹP-;9{6"4biwrLK$'b03ʼ+A֗:KZc-PCmF@ c-jnzkzؗz5] ؗU/c\5vGE8y3r9F0ӵN9`+s0LEQM8 ުfX!Pd4\]Dq;C{4l>2k~l}V!.%rT31,ȻEZ/)݌#%؍-Zp#|# m+m xTKqzvJI9@RS$B6Ъ|ŋv_Z*Lsʷd;I TIL)2LXRR0lGQWx 34ZAF(Ry#bD<4苓b[3Dž;DXO!‘3sL]E/YJs|S=*,0U:4eXq)) BܥWU)R!- g*U)\q-`Kۡ#IPfK< | ]W_'oiupVUPѲ-1i")ޛ-Z7tH F>7os*Z>|N%`N|N 70Sgɝ/X꼅yyMZ}~Ud_f/eȼ[ ^2Xm| vZ>O}~˰uu뮺̺PuSQblڰ@isI[/~n3K-?m*v>Z<oRֲ*%+A_66~8یL-~KgUne2/Fn niuϪ&ESRG~ɣ*kۏM#)Okf`,uK˛@ \B*Wpvܭ1Wb~!Enl)蠎o~b+єA9㋚;]6j0Xf2jj ]6ů7P{(n%u~Cţ56:jWUDtjʖm?;^9aۺe?e SQs200Nf2(L»Ȕ[t6E{#וOpXVϠ5bؖG4k5Q̃A7gAtq`=tH )i1VNNdO.Sߧ'\Ȁ)T~&+@ ] ƀQ|̑fk}iu&m$K dLh'?̣kPPE^㸿.E{f܀<Y`8&rSu J80kS/6&Y9Y$.ԑ5 P|S\1ÞtJ(L橠pGgq`*//ӆYyYUX%.L]|O<#1g$[<,o@ɟP prc% |/B^ʏʧ2+q1弾| M%-9D&D$x(Q#b#3p :|D@6PYDZIx&ʘk 1Dc$a? {[!sDeCx%jauB~TqS[Bb>cg1O߫yל0XPcT&eߟ#`^UhN&}A k_ #rFkD,&7dǃK jSTQ~6::0lˣ츂xO*U9e Df+r9Gc:Ut *L<8UhUj3n9`ش4q@8c as2B*;P$N d+s8SN**/pJg/20zbl!f03@cu㌣xg'yLA-0 H LZx\4+BGUmXizqa'ЊgBd'W'9(RG47mPs`sAks adXtiY 'l~.$*rrU>kbDan);'BjcJTż QUq:.]4Jyƾh y;* ~]sWWu93~mpˀ' U%A4&%Hho5͖ /QX$1X_C3 dBX0ρ1x'D;"ݖq$| fឹ$#18mV ҃#bgVG>MY`a 9WWTW3Vf}?ϼI4{{U(<򏏫L|Psx@d\CsGkP\q||Ox̖佅LQ:3T߃Y(?cð5JMdCC:74K凡o{áiwMh%? 1UZhd8`a =vP*(LL)fk ˳lߛZtAZYr&ę`Ex󄬘!Cd,Q3mVA]8Z͊0<_ -d=ѣcߏܟ6 Ys4ѧ-hOѵ@U-ESg,fcѰaH2q&><>&LG?$۪*+i(t*zi庸,!6d75sFebhx`ˊa(wHi[&\P{ |Ddy`p#;Lc2~?H%KRͳ:Q<ϫSV$qTs5R 7c>4^1wDs|szu`9)<8LqNJ=:ߏB.`& d.J0Г F*rT7 ttuEVb91 +Ou=&p 398 i!:6'MG(", ~ORB蹝_ ԐW͎=l̠OGAq.EL(FQ L )K߯\Md1L2$)O\L(`P"1)`fDLa1C1,H, ZQ5L Uu?iwCxi٘\}Lry(*&ٱ2ki22EwI[UާY]d>qkhb3E 'ON~!Ύxl(H͌|]I1ٵ' rcC hP`?WLQ,+ĎC*jN:d=DZFIGqltX8fSy 2;ดS^3忑;_X42 Kxjj-ava.&CQiiq܂ ~|C057=hi=@@C#/ĪsVa%^W &ZeaUE^_ f:/_FQ yt ن"g"ݠWSԴ8[Ny|u[h)Ce$06Y$2hXϨ$;Dw &X!7*C Ww/9? :+E"B9%¾$V??D_߹Yqy1FK1R/STރ|ή<^eS$xR*7,/A0TXyLjX78nWW?GF x\cgW,ӢPdl*'!h lT^;謡\r äo(w篜J &z?p&-k0 -G<_*6E&c2kK  b?"OKc1.%k,`45s"(F h: A0 9~ZI U)F;!Kc$hD?GQ<"%%_%$Yc=܌ң14\] w!cKWv?ѵ4)T"0è+RPB S߱&2 ȺyFlȣ568Ma)b\IN6%) K^IF}B=b{l0n/ᛆ-3Ғ%2\Z/7U+(a /1F6ZA8.BB쒄"/)f_ #d4*ϐtDgOLHtW" udB?{UA+. |D3erܚ }Ν,"ֈb~q) %H7E%#DžQ۪ EUYVdr\3d @}UU1S!|da8#Pyl wLpDN \㔟Y1Ȫ^Wr 1ßs Q<} dSnՇW4SUQ~M oGp楜TY@ ZiR8DC@r׸HJZBʮ;.O)k5ĉ{r 3 9< aZA^6OB*Gj72ފ6lcrWn*#P·`zq>MvQUZ‚%yЀIz bb[MY}|U&7^3Cq5s{)K+h,XfkhYPabbf@PXV7=]!6;;WA6;yLWŸhfUy8 8V̖xfyDWWFy +@ y܆& q'>Ef/y?&6'҃^mљ3ٹx>^8!y_ eµI4>p?}wG-8g|>@^p s2Cl|U,%CY]v6QiJ&|w dE q,8%[\ǵEW/^B 13`By7SʗXˮ#+b6 Β楝PRī"MxQz0|15y]E wga@>yФ eD JJ&ė}nR1~&wxqs}0:(It/-ƨSR\0[]엊t(OȁqwfeʇXvBa➆&ݥ}l#ľ4<l;߉fVظgd!/o٠QvֈD9'"[HӃ'T$0Ca]! "J籺Z 3k f|ǫW!~d8 Qɦ \%<!2 hq$Fj3YLs=^2X߼"7 OG:u& Ł۴.lcܩe %u2W8JxY_>]F{X+m7m-R01pDPߚ+e`T:|y =EU %_z2ZLFIlеCEaE6Or!ełu…]O````-L#+D }\ ?Z(W ^)o$n.{1T0{%}1<) ҥLWUX'+>' hHx>g_uq`ݶ|ὂʔ+hco Ѭݠc ?J۽0-џ2F~FFӴ YI`,2<ΠgPYpO9 d6޾yԨ&ѰftZNӻew>sr޽V(G8L]@Y U͇cʿ:5qȂ 4+9'<:t*@T.TGL/b< 'w]^Լؿ3"zy+P Af?hw!V|ZCBNȵCF}Uk<b dA?DH"Z(]]TM("ixt TIo09WKhf) 櫯%SӡKXӬʮJ{RJBx+Ԫ̇[7"% 7h!+ڦyBviBӗF=tt b-'O=@WɟKpKb.ܔAO)[J>O18}R.vϻnUef?Ư;<+7r*l>^C09ߪIH4}E![ t7r z `C&v}@OUT:J ]TBU0.6@HU-svIh}hd! xS8#XI'; r|-g,;q3IyiΓ^Yn٩7=m?Kjˌ,\?ޕ1Q|)\Q|}x}$Y`Aburcq5HXyjN9[:bRܒflne ?ً.hsq qLE@L"N6?sG\v_FVj7۲nE^DD>(R%H\HyؚrdzKM/g[ڋ9ά@DG?'TL)Es֩sUEO2]ꗥ[?9< 3z踌q9KnAE@|ALWYy7 0f HLq fjxۋ[kxfCÆsc"0_챳L>[6kMp%vNIf9g79ZI'gR3 ;|RǬ~XhPu1WBe<^c\p6!7&;~n:<,߼?z'ejZ>CBle`x±S`y(_^F3[mƀU(BSpO <-"5K cG/H_=~sC٩| y PJX0F<@mJu[ ੒9,0Ȓ \^2jņ4;JOWZFR-}yen76Hڐ,^237j\bdNo;KЕLeQlll~9 E!R޵(X*<zZ0q|B0 p1׽GSߢ bj?RhPjy& 57Tw'WkU? DTQBZoD!8vpfOc lSױ%xb0ﲝyBv*7BȟV2P 9zc~2aR!ZB=HKnR\ߋ 0fR]kC,dI5e%˻YQ%<fkʻsE2C%u\5WS~xfV8y|x)5sPZSH+㾵Wsg &.%m\e`DH(X4m:3g $DK%kmݥff·&fy\q/(D;[ є H Q فX1(8"đd19QB =Ybe|nlΒV&>E.%U6R e?G2x甙J: ơUS>봬<3DY@@qAD6=Aͦh@lC9u:*Đ =%2(zlXC[au7oeG)ZVw]Kdiv 2u( n1oh);ErH8_Wl85|}Cb}Rp٬hsLe+#} bXށoʲ|1{8.Fw*~JJf=$umVb?Bxsca {ub<\PZC |cZ,#Jup\t$-Y (q>Q" k"0Ҫc V.K?1PS\1y>PX!PZ/߇alK޻hAhِ.Ř7th kS}Z*-[aj2#L ;--[k$g1Mt"`$N4xazu]m֮v͖UZV atڣ.d;#ٍfFc8MUyPot9Azq+S?w.$X3NݭKkG؍ǒukNy((;M|G6Fa`yޅ x6S[&0qGȑ3ibWj[6m1Q2w[X7 rsvĚV$9f=>C+0J"tƻ\Do.x['NHq~Ǣ#e22ˁ 1LHJݜnBWzU^$ȉ3[zCJd4DpGx /R->=jO}c%-Vas iMmA#V*7xy18+_? E/߶ R/.B?ܠc֬G؇|p|lO^| -, ?$QhпPŐy?h""#:B lIS?dC<k YiH >!Zp'uC_HS܋d:0sEgQY` z!w2'kZ6fgtJĠ̆ ҸXZ(1ĄeH[TKF7xtMh\fq cK4Ԋ {;l)g{a}ۘ@DN0< _p8R6wqc]>I @6~_ҨuIp?][EcKbvQXY7sc;GM g^"3#}cK4 x op~xoϗi pMC<0% .] dyJqvf?P!k2R)ޕ2\U6-9QӉr݃V M|2Nm~{ϭ]sovKm(~:фҦ2 ؜?i@YM - s.9c^lRD!.f]L-'14ˡskڹ녉=;;1Qk[B67?^>MYmKjKjc@k?[tE矀?{|x)*7A$n>x-:n4 )MkQt[z%=:_[ֻNЈNhuF6:<#=ɕT]jh^*7DSVߤ%4fDt?]FR _6/?Š,TqD@RvtvSGAT>FlJXqw@c} 81j:QhZЁ=ttd*Ԇڻۄ4 v_ JAMtwꂲ蠁Z0:IPѥ3jWAlvF[Ͽ˵RX"f~Pv5_V9KYZ8Al#2n"$!(]~ c]f؟2 B3TaBGRLǤZ8T՛a&/}j%Jm %D sW2W;S5ȑ iUZv Da`E @& Hݩ)7BEʍhfb%?aA[Qiq#}x{r%Ҕ')oiN7,)pp:׌c`L~u,N <#fI3.ãzƆ9)W|ק]X[-ˬ_Hrrrrȝ4zzzzzǝZ+_[X]+VtVt?sE/z{m,OffC_ 'AgcYl3WBcP6gYC0s {ʀ띒2 Oǖ D$%LcTr~CemkAg-׍hbнUE$~(̴DMExSmPElFg.YcꕟbtT Gl޹ X\i{`-1Ͷ9k}tJ,|LXL[WC݁r ՇT mFVoжdx6yvMYx:r29-XBGmq6ە g 4t1B[֪,ݰ%;Z9;PS`r@ס޹Y bh tK #đx' nm5zĸ#?UBW@̳ 䕕B-:шohJW73TDk Im1fO@T*=-wH*EyA4qLD-͊?p I<]x\<'SrҞ̌Kdm\}QEkDu/ԋ w]OiRkx曤 CTfܻ iKx?Yk)%-GylfXOucE,&E6/&ǫy WK!w5QjF-ŭp3=:RގSkxQR :loZt*__ǢM߿n oUK+nzI Wq^ NRo7YT߸`t'KtGdBw,%)wϷov~՞;Q_?o+rby-I_^ժwT{nKozz ѣ nGB=N-ǨmnEpJr1\KJkB26Ĭxo 4NĮ\?_ƭ* JxFƳe:Ag4o[ *? &67}y{U:1Oxy,Oѭ`?7?=Qd~5Vqn?Lov?Ewe9[#ynv#?r,w~\8 {_X.HQRA3 5=¦Hy(+ŇS_g~`6!b ^|Ц fr |́ *-pɎ0Bq8` J0 0 bUBa9؈S a(}H"+( t* / g|GZJL!ЀnG5פ)H$$9u6T8&섞`QeF9[Cr7G|ˉp% {3~nK+RDS\; x 1SQ໮tRϧY'9[P`/j68g-<2$D 9:e {Hk2s6Ztwh4Gr/r|شgStrR+i'@h (r[Z=?B|摌o<8x+t82\^Q>T||!/d2[G ?CrPXPF|5f"e$ _+2ixijҀL{ c( iRCfprBljC65\ 45rP+| :ylFi3aJHWiHoɂ1D̸Ə\ji#!)dzzN:] SZ% ]^t5 V9Z¨"O c|&PIO)/^;;gSl #