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

}z8c%yB&LgDHbBj.oU\E-s̉cK@P(j>yQ4vwr \2O22ƿcYRd!L m[N=kLa?d{ܱi34JDjariJsMye4 GQ4 ;p<~0_ ENݿY^lShMJ#6@zޓ:({~>J}4.4gl 6 Z=9^G8` ]fMPRKr#xVË`5Nߊ߫a~1v I5# 2B P>pEJ,gZ? q1-9'*O2)Y(pNhL.$c\߯?~(~٧oU?\Us^X~ti)T8tnY=Ω״`ͦP͖c˙`Pxf;[ޙj=u C۶9eaKk4=kN5Ͷjlo΃+ 46{0ER͆EPoX[K;U@HEi&,  }7ƕ1vQ.s;okge^Ewُ G*>bf5P]f%^2e(8yX*8^i곎3F t f@>jK '5f֩ 1>uA<ѵǡ%#gRSM.0hYn"4G]fXtv]Za 3!:\P2u4}יh+ubQ T1cz;^G>wFm3;leTG֕uvt}! ˆ.NF-lWԴn2;u k1].9wӕǀzB7 $69ؼȟ>NB \F]t\S9HWK0ͱ -f:Xؔr9_!knkngi]eڴS,[cZsVv^O+:L\ Օ$RDDx%!$ _vO+vN\/Wv)jn#d:K Y ټs mlEBVB6r_(d]+ 341c# Fkp )5UA:8S%%8j?ܢYPNژ\(I dy6)|'0q}Ԩ#׼,ð.r= R4 bt4rB wTʐy l&(x{zy$H ݊je:D;{qܰVY2-_77XZW$*2VͿnp7;Gvz*b| EH)VNI~N,jdTE-V8W#4-#֑"Hzk!PKkwV@ͅ@M쮹;cS7; v#ԍ]\ϭ0TaA<^Vj|DP&"5 2 RΑA2蠽n-e 2j66a9 TLxoXŒ`0,cs#'m+΁K uqu!ThfCA]`47A=l"]5Gϖ(M}gnbd:0\GI( h20Z4Fs%}N Yژ3{le8\֢L-:EPofa"o ojs%5v;`y -ZcA 67lHKom/ YB^yVL/DZ`$,bfl#ibv m4*Z絆$빪ܞ8B͵A OJ~)j ĭ0ជ8,UYrTmg̼A\P" :кI"]J"Җ])BC"JSd@6&K5 %:'#?r\{% >v!.% 43& ,ȻFäwjJȽ"v)Ǖ=n{aX":2{wXl.J% .U~Hwho#񭡙F4'=V%9K3^82HbF~+ Â.E.ӦTUIr'2Ex.iUƊKƘIDX{SVs&n7CcAܥ]:Y5}5]rna۝wxemt>o>7\w͛賻me-wYn|u]w +[`]Q-t-z.{uu멺κHWz([w1W7-٠\v깢ߕ7?WÊm;Jyw#&=ߓ U2|?nr &+睺E7d;Z$} 1yn24}w,OUE_>lI~ڳ|0cy^޼BްJvp][cY:q7\]/1=#w')8yxxA9iilm7w6u1ʤ|$Rr%7ަaloPlRPin٭<~iIAl܉Fo,2֍IӐZcXKآ.i8H5Sdi$_:MKyV2uךʝ*CoI |xĒX3-pn2IG&CG,N2>ϳ3%u[)eL/=v.#}/dASW5ZQCj(t<;j*~?Fu=>4գ󊍯V]6giȪcX\?>fIa] uzn&Ɋij^(Mg|:'gXR:v[lS7}&T^+5{Urǧeg'Xg\aC=zS ipߔ >FG !bPd~姮+_,OP>.۲f Yc@~Ȉ݄9~tE- ͔OO]O^马IaVj߿ ,G LV ZCw 讋(Z_ T[sX\w3 @ž===^wMZ-*'%Z*)9WWOJDjbHe2)VAIcdLVa/ @YOe^D{{cA @`4kcg=5Zen3i\_@_,&Y=UZߚ f]BH!`Xa _y)ɕO(Dc>j s (_nPޔ3$j $IvPezI0hTPBAd]Něꙅ0WV3C>Dd$~[!É ~9<'P邒|} wpJHrU-t=cIw+16#@~bzu(N:P}V"~ε?y=&5"YCC*G^m|E|fA@ >#ʏ?D'B}/y}paLU`ϮSw L0[ :{g4bH,X2 Ep -j] p Y]Lu _&b1.(|~QjEZ:fJ 7PL![Ca8U9U^P^dgNaz&Z1% 4wÚBirO}mViza|0` :ʓ);~T}Y#n(6`h0q` )02Qk:;~wR;!FPkˊ.bԹ*n);da15R.Gg}Nǥ.@B쫑֊F\^2L!Pj.Xw*_xZ/ 1 /AGxK_j%|}T&'̓9*XX  so7'?tЏ.^ OLps-̥El ^|W h.!{Xp17孂 [%_]9LQCRV4f?g0uu;:jl:']&c>/LA3u/9?yEź,n- \Q9c4<ރUd2WϽ: 0$}9g]*3īن` 1}GVn[IzMTјRpdÃIM܃ѬW[D R 2hYkOuA;hc M-Gl > !xxqOs~f{K'X0ci2m>;1>r8zB )ep!9xX":<vaԕhFf90&EW!ͯ6!+R9y5$)=d,RG6o.}+BZ8_9~zpMX`5A}ق(%ꁣH7+յP"rl0DCF !"pLOSw "RÍ{DL2aE(O_"fjtB,~o0aÀi{ RN ZI`u3$e*K ZY J j-dHI ACR^LN= mvp3)?⹃ ,]iT.eO:2F鷗iY|{ErZ!ۯ|aQşR~(+)\=P2K_-b]+1ٵ'1oU,A(VGOrn3Tmyt,H֓qpX$Xtl$M[K[1X Nǥ*TLV0b. 1X"(ɨyIpX @٦q .mV_&`E侍UL-I^F7Ug*R:Dgok !¼ VTYXe)k~M"w(`'a/ir^jŀZv곫?jc\iIߟUy40g\}}j!V ǬTZO rj=|%28jiΫD%IԿ^?"oQ7V\>xF:ٌ8ZJ3p!X 'G,_ƒbYHThDӌ##W%i&w Z5=1csWE*#<oXE7@ p|$>px9v& +TKN`a>";+!OX[C Ѡ͉F!S)VO#Q$G=n̠#>bZL`=@8PȌ`HLugm,AՈ[զdgLqWZga#qRLjVu[ϩ7 Nz䚚ZKWdtCPсۜ<$.H#%9 L$/=aTcbH(}w%=q{Qz<@C2t`FҤ^0L,BC a 20|ǖ*^#BS} a)c\KNv>%_ULO^MH >!V+XluGM%bP~r@[T,xeh਻B7ZL0r1)k U J2 $!IHy.v!5:Bq)LHlQIdS >D"$, qSxJ^1TC~^FcSTB|/(H='1euP7ўut':2b@.I?ÐJIE;>>2_YdJfW+F \ɄV!竫ϒNbf@+W!Z:ɾtS݂W$4R{{x;6o夠j %gEYOίq}vSʞWspk@ +ۀIP?4A:abSl@K">X2b,#ό4ϥ]*N\tjSNhffs%Ef )úᵊ*>sԬ.eSm{cswn.#(GǰrOk aB[XP^09T=Qpt@4ǢlY?&Շr5|R_1>큪/UƯi:+W[,R?젡`4~NEjnCSs^ӊCAi[g88bwũO@&`@taxlvb 8'% !"Xp[6+\FcKyŠ>A}$b9Ys8T<>suF%GK9`㧨fy*b<Ƿ*/9؊&^?;"%m&rk7߼~kAf!*oK_'pjX y5@@&MJ\aiJ[܁1G brs|ӿx$>8'p!48:ݫybOU̓%& R3<Гן*b| (}H֡p*j =khfc $^[_pl*|Kࣙt 8 {_:w ޭ_2ԃ% Q=PW 'ՉAOsz/%  *apVILˀ,a 2bxϴxY?f%o^t}YSEI)R`{ǻ6;, 7  x< )U*̶QH̍ AřYK0pcUCss?S>+$jW8$ B—Z[ e}w!牓xl"Nj(BLY@N2 {S`R4ǖI2mc[@}c4Jtp7"^7nV<+^]q(o$p]K``ɻJL\KxSA2K^Uuj}. ytVF&4@=9;`l!_㸋Ceƕ6[qN ڍ\[ #Pޯ DaavڨbDzDڿ5qsauۉ>}|- 5׃^PD.}<|hL({^+'u <|^L7??Җn-ކbf`~vg=Ѓ^g}77?Ϻ6fK:V|o>- 0XG,3?RI<O$z\*r@JaS_þGff>oG `>򃼢'5?L.$sj"$,6:}AP&5/% ea&N=cK]R:*Gq)I]]-Ę =wQGhW蘎d5 LrSrׅ$%9a Ș$Ps2 fȓBml>I+]AvH5s?p{m *E?,(.Kpyiwj{K1Tz b_`f$-^[@-e+"oFR^b̪Yd O&̝kŕEł?>^BӽjXUR_,h_QJDM }YjJg y5)i5v݅`"{h IB- xP@NȷHTL~ۛ/ÿ/o<Ӝ(<5|ՔO{– 3JNâ-DC۲F\Z<(3F 't 徏Ix ꈮ,&sU"m~ooksb{48h148zЕ0/]{l*'wU P0)CLp@_`4''VlCpޮ5 YR,tl~J8劣LN1[<$3"V*uZ#> WT-2ʓ~AG%:1]P|( Qt x6*D&?ױjPҕ)!B J؉RJPu.(spfl6T.\FOcff9$l?Ydg_0f:%=+ƹ R"q@@qc>CU">Al$j: }Rw%bJ>:flX=?`鉀-HTQ<+,Q~M'J44jM iC c-<8xC_!aH~kHV2U~].[Il$BxCq}R@5D lvKgEZh&D8؄O瓑 @,/l4[ih82 bz=NYI6ӒK'y/p~&Y83*l[ޝU(0Ix'd}S&_9 eF_*r# "B /JTa}"aa8&qu‘Zъ4 Ҷ[W bhb6%`U?jԄ<7EbMߒ%Mgp4̢mb)7ڻʻ߾<0ZZ؇6ƌFi[6)ݥ "lUsܹۧgg=i-V{0vZYhQ+ T $~لKd ~)L/HjsILzHZ$Ua]un$!yJ킝'^m5/FdYa VZ6Ϝ C_{l5m'Ty#+sVXI <R\ ~+caԫbb@hyr_ˤ'Q0 =3Z (ކJ<;<p9eT­lZћv&]3ƜM߄ w4vinQQ.=|۠փ io7+9#T (llŶhHƖ;F40_ ^T4ZK(cJ?<R 5Ѣ&B_Xl]:[MHT=5tǮ^"iǒ럱?O-st0_0'WܿϒiN}SJ%´:6+-a!n_% ~L$(ہtPI7q*gxAg@(Z)=MWI,&I2gOF):Q h#ź$rcѩ8M&G j/9Lj,0φm}{z>lv-9Wah\?,nfr@ң#riMȢ3s`7d[HHC|Nz[%(r2wGͳUX6lņA3|aHgHK1C"0up" \}5=;ϕS~#kȪܽl m4HS5{)\1g c!] T5_ԛtV)6W[),N|hj: guqM#UԔYy̌;v$퓷p C r|.fh֡ӝvE.EUbQH/k5=A0YB,U"e0"#FZ Vc0f?%QolV3 (g2#"M]]QtIZ}O[zqPc҉믠>f k4C/o7go,Qj ?/\'bOqXߦaU7;tecGw67VcJ8@[?IPKqZ.J ߥ7*[k*5DK/< RJO?<]vQv~9CKDU7 at!.,GXk5l`#hѥoUnenTnegM[{{o JM v;oswav7KN^ٵ.knoUƛ/.*Č06ȩPNwns*O*Z˄jZ*FlYW3]E5ip٫)j_sw7%|ċFW+g+Wts|kg7,>19kʗ1_=kzJwޗwU5+2?J$NjOgTS6*͍kTd57v^>OKoy]]S-YdqJ杪./޸ߝRCǶ;`M{S){SIU/R,d * *]Y t `{~5!PY[(,)](Gz+ BsVt2o[}}xg]}nK]",F;˅$ UF/T|R@sה$uOM(<ҫ3ف ^\P2zi%}MeK1_tGʝKnLɻOdU>GcΥ ^ Nr#+e>o<^X|+t7:,\QQϟj"\ 1(k~?,K螯%S7ɂ'ת`X2MtS W{=FDur)]mset͏4j$uزvV#\fRŸw^H2D]Ƈ] KY0./SWnU6Zs+j GL7']{y"0Zd~ƽP?վ5Sd'0zud!^ǺxE:] 7)?%􈿦H/JS35QXSk燋#~3!(ao_x*" V0%@F1'P c'gxZ> -%K:9 ' ' qkLr(8v#g}k]8x,y `{zƍp!a@+T<h} kA:wQtaV|dH/|] c7_ ~Fln5&bDv+Ԣ18c/<,DƤ3Q$-})b8؁5:}\79ƾ \m6hkS2VCڧNC!5}s