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^Ӥ3;fEjeՑI uZ>t}LAAʔ,NXdI,2OG/m9M 3SM E3ǎƦNEω2 ,}4di)hvd:`T?zue@=&c6pi]'H{ODGQJu9kĴiI FTBh0~ĉ}TK|2kJʖ"hct1Yө zTS.AZ oߕ^0f$8lP>O&pEJ$iVъE֨גybtl)HB; 54ǃ&1m}8aG &BKα_ -U$2+:Bi5dlЏ 'u"܀jHw'RR0~ye5;'_ӂQc4jCm6[̏=[s,VPAeDn`yVQh:m =FW,!9ٜj4۪9ʶ,Ќ[RqcK56ƒMBamo-LPVol! Av &g,PiSGu\4uq B`Ie5!1t)1r8Fu0ޢrB!cl{e-[D/R} Ωc$qpaAo"nRRsTwpYA UHImb-%_4.DۢoYV_ՇV߰P8n[вֶжpqߎa|szk6 斵e[?955zڱ7N-ִZMM؃aıD`o%=Fkj XkV Mlcszޝ 4GFmB$l A\OM8I0M}q*Ia> G*>bf1P]f)2e(s@<,%v @/Nf3A[ t4nA1d엶N]yZ*Dc`0o:ڗ8C_/4av.; g 8oueКYxjghؙrk=Sg Lc%c_pFw:SmjEY,*Tcv ah0tرmum;LС)ʺ4wt}!ͷ38س]nI-Ť9hv;0wɸ9=Km$1dz#Jhx; w0mv1sMclV#V7.`cJ(fʘؔt9!snZknei^eܴRL[bsVV^O+:̹+I(4@KBYI@>;Wd^JRFUr7yUrY< ًL-l Y|!+WP# \+ sHP41$&FעS.ԐZV?  |P\ρ!tY4 iSs%D%Y ndJ&F!-?$ i\/55o6 0T $! SMa1Q@:;F R(e<s({rI j a:x;h 0+Z5&3r5}ssMu qE$CoZiZ~ nfTcNN"s "r.* `jDb+`.jkԮvGjK\K36{l;N,U߅HjT$ .e8y3j.ᶶmkCf`dMV &~DT@޼asg^JeIy(2/"|$^[}{XD}e0% 6`<4,o4T0JR 9a`ԯmF{Km6WJ166mڊ22{<\P9F͆jl7j+)#[ hn4 5# <0r#"xeh$,9'7e5P_Tuk[Yo#ڪX*,' +jC]mQf!v\*6>2w;@vխ68V&Q&`3G=PԷ +>_R4elnı7"T9pn6WP;Ėjͬ;; fV&m˪&%@mT \ߛ[ Ʋ6 $MF:h.$pIA Ksz/ 'ZE_b`, '`-a lR Wnl2E [ @b,|}c&@4"-i 76+@J4ϊn/t$כ^LJیM%M?yo0j*;f?P*bqq50ជy8,UYTmg¼A\P" 0:4к E-5R'CEڕJ5Fǁl s8VKuNF`K5|V=B\J'lifdMXΑw  eZ/)]##إWL-Q`ሸkʨnR\aQ. 8 C*aJ$|]ʦZu._񢵝ėf !ӜXl4xa V@ ]X M; dx\F+(RU);R)Fk@s8MCktǃZ()%Q8vciˢ|˥ֆ((D| L sr\Jg0zpnJ†iv]8UQr!QvVDW.V/`+pARwuE\)|jx5e[UAEj(7V^*67\.6O"8 "-4ޛ-7tHF>o.Rrq钻ps sw~`+k;y u溳hDݽi+kWL\_~λu-nuEv ̷innSmt׭F:붢v#]u리n]\ݴdrٮzW^\E+-D*:-hލԴʯzH*WлrUsh2Xi8T,u&˜?"ą#niu;Ubyz*ZZ$iͲ`FZgy `-R |x^nގT23=-wΦ nC ,V wɋ$32Ƣ0T3f#DKGsK(6=o4-رf(6 )n{(ask34Mz? -9XE@tۺ#iRB"]A1 ԍGXuIvFmE5<՘2LILvAGZ`*^w Pe-;ɁWJ,I,P9Zg$Tȼe2T$\H\<_B\b^FťΤqDu,36=:uUS.A> Y)} B#vybbXA =3Xz`Ee9m'ē_!bq}~>^GQS}jq`] u:~Xd45c/P$aΩk fy*˭%jM_F UGJMGGCDl) #-x@&)+gEO#=qd)aZ4o0 >F-{bPd~姮+^^,OPF˶>Yw2B7eAtq`=twF ݔON\O_ɉ%Iaj߿ G MF Z#w Zj_/nF>S Thic%h@jinDV-9D& "bҼx(EK~ A4UNA*]! ܇.' #L癨cL($*Q jOb| 3_z8uAU{8^J~cS[Bj>פcmOJ|Nx Jvd!DJQМuN 8 E k_#zBkD,F7Ttk ԃST(}k9 [(iu;awC 1Ыȟ]Sr0JLlR/hR#P`,oW.u}3ñ3fuj3iX]0lZ~ 8` AE٫!h}X"/nEB9œq $ r )|艱FȀbM2zZa̓Z@ H LVpX4kBcE:x~`^҄to w,AGy=a7|qķYC/K|υY #evaf޻ ־?ӅDUXC \Vt᳦}]TpHYonH8.`C58`fF[+s^{t pUCuAL+~Eri$Խ -fr%{>> B&'h:*XX & 9oO$YFA?xﺿ?1̵t3&IDZ9߿ӧxU_-y&YaR`c 9WW>PcuO@7]}]za?>V.L|Pcw隌kȏy_0}_Խīe$30EYtLp@% IP0܅u 9$Evf9 !NsT:2趕g D) G6:8}h:Q.0uNJUP1+vi6N hghm p#gB޾1=A"0 /kTtskI}$C p,_"'u~.7M@L, PVB3$C Kx;ڮ"05YN/̎)7? 9Qr&đ`EJ"JYqsUB_zOQ?#l,3kO5[ѵ@=pPaF`伃idu-T>UD3g,fcѰ_igA7ɌњOɤiɭLWm*e}. x`hWdo"qgkG:#Vc :x_5n93>.mzo %|SQO"lDQ(t&zmlr]\nBP"4gM21D3:^Y.w:ja:,8ji[&\Q{|Ddcp0DCF#pL{uEy)]5>QI1jn!L0s8sp)A-wFFzcZ}Ao#,e?Itq{;VG{fo\YDIQ5WL~ ߕ}cn(quɀJ $!QYN|$I( 60Hk>S) cu1_{H|L6 \`;AziI#Ci`9RvF\]U,Gʂ8aӿG.{< 0kk[ c3}B^M߄ݏࠀqA{D%Cb[[D yլgCexh~č{DL2112(_ fjtB,{V 7Qh0a<9syBs!GOA-ĤDu3$e*K ZY J j-dHI ACR^ ^L+&SO$.aOr.3b<6Pב4J^YfY228B_2?9I;(+)X=P2@-b]K1ٵ'1o牡UfP5 04҃!!bEczZӎ`F{q2#Yuu7/?ob\Pv:`[1 aE-3\@ mQVso p0FOM\AuAM}ZnPΞ)T`tG8#* &Zea 3/PH#_ T<8slIR7%T-5/7̗S]]}&W'Ӓ?-Łl?2hXϨ$ w o8ao;j}u+ݫvNOBp9\1:""ۗ'Q[辋t(G߹YqFg3j)j0s`WWIT;08flRO[ `J,/A04XȈDÁ=0$nWWF:F xGZyG Kh(>^r&}c{j}ہ/:1rL5XKvI?0>Gd`r*q5 RΒ*oDݺXF/IKDU%"(+MCXQE u}]CyqJp nW[~k %уK @ہ&CWׁ?bp2'@HD!8>ZMi!ȯ0k3)n% kaꝅ0ir>hF7xboN4@" A*=њRHD uwd Wi1ibG@!2.1ELJD5 ]V#K/lUf"j1Y]keXA7;LhFuKԚ#K-X2M͂J@-%~b+2u!FPLamlukfzC` ǎzՒi&PȞ01GDdÂF⒞8懽( qJp2tnGҤ^3?"s %<[j`RSzKW j$ZE8,BB⒄"/)a_P? #d:ngHsD]H&dE+LtrmOЊ+lhCph&ϹCCrdn zw Gҍjˁ¨mJhq*ۋ, RIt}9>3 hOׇUU1R!|da$#Pyl߄7`2B_YdJ6+9F \V!竫ϒNbfYBT:^xݔ[𾟽&z6'y#oRN ƐV}jAaקkk9}y5G=F08}Q27`Ы3 MP~N|P~@̡tMhH$!KC\$ 3-k|@ŎSmm ql000{>l0;eX#VW͇8quڥLWbuWm|,Wn-\eb˯)ljd6ٝF)KLl1V?G'b[MY}k[*YSi/E i>\Akþru"oqf ' [A{Zmaq^YdCw6~jǡr\v>Qi9[Qߤ >ppYDr$RC>'E7,'Z!"H dMVp+|9YZ~Y ~0KgvCIL4E2DA5y.IpTe٢QXkZ7(P--^\ e? {i_;c*ʀkˠkRq_yi9+ά]0_m'f.i(lҝ٧yʖ`NKcx)`ID7B&=# yv R# FQ `{*g X2hR:Ss@(eoq+yMIL;` 8 `Rrt5U"Oؼ(4KpCO^)/!fHU:>[® 4x׬c |zL*nK|KW U[ϬtiKHN:nj}^.qP@"i0pQh4R0p8需E" ²Hh^/KX[C"bLDUAW@ݗ0UT"6wkr\t"q[.pkݐ^ly5ڋd8[왵 3>)U:+/ '7t+WG&tB.-.WBU]8$y8 J&뛗r{$wFC[O׽g:# ^ā۴. zJ1TuԌLU#xW2OeѺ-A͡m|?@ ` F@ηf p%L*/2bj< S,I0oĆ6|vqO}@}t,o_|q:%Xã{B N<}p.Щ;8b]q{:gZ/+ ~?0ODPў^*?Xp(ƃKgZcFyN/f텞ݥwP>\ 06 v!V5Cw]y$nOw@MxQe])k W&Ÿ:6)D3=Li۲{QB!7zzYqW|bSfo$p]K``ɻqɗħ0dJ2}b9Ouy+,OS< !||Ύj7l{Sv=ʌ+hc/nݮh7Ɩݢk ?J۽0-џ*F~FVnZUHH뷦~F3,΀>[Cea=aRD.p5Ȃ۹mu,z5giYn4JuNJ^?)1/ =(/5]ACFۀ7[ҡ5s}YoWH쐁8baRa҉U| MD8N3Ҳ0iJ`.DU8=sȑK/i9ǦJC fD]KbrPSЄJ`Ͳj|.$¤VN2ܰe**@n<44/J /v="={K4NeSAC `GkG' >0ZJGe#%g.-Tm rFGB`3rDnAE0<ƿEj[ę֌fJnR>} I=vԁI2JDEV }SW9z&#i\4 DjjQNZhF-hfp}tU8G(Zxc,@yY3}T[ꎡ A=HZWܜ'76H$YmI)^27j\,|12W tpgVZ-hx2-%fnXKgcYD\,s J%ݫU%+&o\]FRQGHT'0>DлWR`G]&tƮ+8: bt? Bo3mrp~ޟD(ዺ|w-HhH"w h-i/Gp˵xbQԌ.+'TӤ!i ꈮ4-&ۙ* noks|{Y87F Bue'&NU^|0ҫhs)g41ʓ~AE%2]P|( Β 1xBO$ʤ!g95Vߏ#za 3R0TT!f+wJ& x_m%1,M.& i#Qep-xC[ωωωN$+MUAZY-\$k6sWAe!DsѺHɡ kpՂL4v%"e4i"T,B'|NHđ5ѱ,Ia:pl$N{~x廁ׯXj,y/0Y9*m[ޝ(OxMeFomRO岌X @*r# "/B)8 b@z8Ԧqu±jъ4yۆX4\{N  i;fࢸn\,^9 #XXAฮ/R+d%k;[ P\.\2>vf C[X-a,hV}s0H.ra4jJq3z Y9Iʠy9ĥ&.hic?{'\/Ӓ i=G)XЏs:i]%XiITLWIJ$Ya]Du.4Be4q*#q'^ʽ m5/4n!1~v?fLƿn7[n~yx;Cy^⶙,-<)wsgm *!T#" I+nY 5 53M= w(A}ZpENjZi+tlVbG[D 9* QILH?q-)R5M4&A8>v2&.UyB7(DjOx2LщW@ o2 t3sbQF& .Y;#K$gWwm}{K K֫x|ۍ9]Ėk26ўqE9fn̷ y˳}?gl"*~]9%Ăsc3eۅ n\قYi.aVF]AjG ]b8+m@9rMڼ& 0ƀ[#2s&Tv{\F{hmmXR Α} eJmъ3TH;a Ox?B (1u2L_fj%w/E1a:uͮ& b$'99њNbnAk8|SKH%ڤz y4%J)q㓛4Ɠ7nJSmƹH*7!@l֍f*8iIDZ[7՟X!U2[#E)@\^o2@-G~/?7H~#z?$ܨ76+#O[jnbQ (nwi5{ !tNjF/j IG{(!hvcO;,O~#A6{GcPS`xm ߉U9unl3\S sg{Ωܡ*8j Nhn4jJ̫d]πWפgnu:n^IxkՒ7ue1j9,y]\+͹ˊVX_STu% %D嫆Șί/wi5;hfoZ̻{QMo_aŭl+{jӦ\|(7˹ҍT4zNu 6ҘE&$;0oWuy|t4ԇm|3ٝU |M ,p'7;dӉN t0`D; fZ,I?p 0@r:J^ PdnӪe$C]x7,й\tiUPEpܔk+R%..l5Z^:iNli$<«3'['DZgtT/!I?R"O vuS%~f];KE-*AɝK¦{EG?K#*fd>ߛ>EXcԍG7 Ww罚9B{| G2vgcyIq,({| a@&~GŐ!7{O˰ӡEtE\# NN"NO^3g.K q%NK)b6Y0sǛI.^~޽,ߑdƉq]Y#KY./SU|k{mmηEfeߐ/D*3^PjΉvX }m42٘_gmc]qa+W唟Dz?ؠ\]K5~7 Eo9;_/?xpq? NB~ \hxVwprf90hepS 4j˷㱿[0Np.}p2 KJt6v@u]O0 O`ҘDP!XiIFE=:w&DI?Ԍ )`B`Rx͉8$i kq*w}JTaWEKU c ~FlnmmQň:D0L(Z[A{?IwgHZz)b$ځ5:}\79& akl:֦d4:4HOGB(6