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&i]/%BTIGm?vz&`0yᗷϤi4sv!\˛2˔,XdI,2?J7kcjj8nZزFVWy`[vr^]l[cʃvjw~+g 4Gf7Fo۝ѴZzT8h{mMC٣q̱xh-Fl50mUm4RVsz{~6X 4]LX҄H da qOYqnx;NDSM5b}? }gEW Np/ 43If#? WsBIfg}?WfO,`ª݅x#Ls\C-2~kʃl͐9׭ڵ$LnR)mY1MUgrK+'- *s%R "yK"px$!,% TO[VNc^J/Rd,[9Ȋ^{:f [EA6{ +pA4s +VvG~8r0SY60oD3Yz!TP]KhY=@3|^:r?Z ǠRhӦgwJ<Ȅ6F!-_$ i\+50x#wa6 UPX4@ qP/OjJaڷS'06+_ L@1kI劝x<(qJF1JXQ 0+b-ӶfY6$0ƫ%ZHҲ_ӹP-;>{6"4biwrLK$'b3ʼ+A֗:KZc-PCmF@ c-jnzkzؗz5] ؗU/c5vGE8y3r9F0ӵN9`+s0LEQM8 ުfX!Pd4\]Dq;C{4l>2k~l}8$W̧ 5BʃE#59F_ؚ9.4V'z I̧cf }PEHTe"_ס|.RKIi f.nJ܆iy]8UJBPmX3_H2[IKp%ꖸ\>vxKn;7P nlPl%XlՈH@I^mJk EJ09ydkpJ6K`NܦKv++ZݪȨwu$׭u훶}Ud_f/Eȼ ^2Xm7|vZn'n_2&uDvݸ%n:Ԯ%nܔeԍX)6,Pn\R֋یÒe[MU #:5m-_eclzfe:lVtb, v:e/P_ją/3*9O똷&ESRG~VQԵaHJӚeŵ2ziyyk7@HJYŽU; [3rX[vO1nCu,^{VєA9;]6j0Xf2j[ܕhc \'?AR5/cEDu,32^xtR*6gN 9onx+m@5~g:ע)FV4^xN3vB<s1V(u픖ۉ)~ M8?V{(hm?x!Sl #-+x@f +fE"ОEd)qR4ĔA dE}@.ړ|O90~Ųxu!ֈ=c[VAӬ gDSݜSE#+o||;Z;>$N}7pa #RƦL3SZwL nPPE^㸿.E{f܀<Y`8"rSu J80+S/6&Y9Y$Ց5 P|K\1Þt:%&?TP ׃Yx}bK(!dV^VAnK/f(FE1#3_E$; #1|gvTS0\H"@4ߋQ[ @HVSz%7%1GVd0HeV>)t%2\ ad04NA2Pb\OFsj8 ӕ 0gR0!C>FVҰ7 1rZ8wAT?PhV $_G%U9%D @*sI :vv3} ? Jvʤ#3BU支Rѧll-\ι0/gdF2kbqsH(@V: _?GK oʛ=ܯP<|̎*OM_]p0J ab)s4NSEѰ”Y ^σSxPeN10kP%1 sMN`A>' $ޏS?U*y`渫8/#/nEB99Oo˩2x" 'V.l34-\78vvDŽ+d//qΤ%oH)txTލE7) [q 8|,AFyrup_/yt3f) 5?&.=6?#F&L?Cz B"1.W5&}MMIyB ,t;6DUUEld! a+ڊUcBg5wyYW\0;wJ_ xP[Dc^^l> uAE54SKN JX co7yB$-R!mi \@w_`ZK0")oxa% =<!v`u4P <ޔ 6o~yhKIue<#aEoC̛DӁWŊCzea:ώtM/x_?7}{dWlI[(eg{0tL~0FU }hXs&Bg] 3ī&|ST;2 tJLcD) ;6yv6К=S% L?cV$Sglb3Ӊ&#ss+s!!XxjAE|8N 0Re(Xsbp8ZD )hep!XX;|T S e,yC>H 7;Bnۄ8sS8q%\0j@T* GYqU+88}9|ts1&23k0&T0*=̜A-Tb硪h:vL]l,W8I3gI<y2I qG㶪 s+6wҁ}. x`hWdeh3"qPדw/~ɒ}|0KogVPykʟQU膝1ᷕ_]h ( G|PUvuqd 9XBlʯ=kd光!Ę=ߗ ,YQ@ ;(:7Hi!L@P3Ȱ9Gv  d~xKQQu y:W#ɧQ#I<< jNn>|t?h8bh˝~;+g85/:2rR&xXq؏{xÿ)O#=|f\ixh+NO9 |W>]@-s" WtPVb"Fg!8\`H& v(h0H+ !S~) Fcu1ـ` sQ턁pd0R1xYшKCjˑ aX|6yﴀKCaYO LБ< $oGp 8 @c {BRjvgcexh~>|'1Bʄbe Q>:ȾI̔JEDI$Oe ̈́=,AffI49# ŕ) XR a<"& ABR`g-">n/-I.;8?+3VHU8~Py݋vObc õW"a~qs+_#/Qoܬ dH)?S?Wރ|./o<^eS$xR*7,/A0THyLjX78n?EF xTcgW,ӢPdl*'%h_ lT^;謡\p äo(w篜J &z?p& !=UG^4Ň?;Ѵ2a"U֔xD<P{瀫&3%ԧ1JZ"Ô4X|a4Qtɚ>_!,5D<|>-&`[G L|NI0޲Ă%̉^lǶ"]V&hV&t^i'90T xY(P,y>ad F&—|lH|g%r=JǨpu}.ܹ-]a{wGҤRPL(H]C a30O|ǖ ʜ^( b畂! \S6} 濧q%;fؔ~R08 ,y%#H' r滉o @HK rYښ+e8.W/'c / hv\ل+ KRkA CX!͸ueFleVIS >sE * YA{ZdEf/y?&6g҃^mѩ3ٹx>^8!y_ eµI4>p?}wG-8g./}>@^p s2:XJal2vUyT/LfvH XpJ6kƯ^~9& Abf&,or~/'+?]GV0 m %K;ѡWE&" `kk2X'S F|IʈdL/`/i8@cÚm\r\$uK8bgLIplt _*"NU<"~ݙ+w(b5 {rti ~yKw;ͬЧqB^<3%AiHxxtcP 4UŜSs@8^ ,󐙛ēw"I>9'"[HӃ'TϏEBcpL <,Я9+ Mq{:_Z˗<& U0Y{?>'a?Xp(ƃ\ϤsK9?ZzK<ޕ_CYۏAcDrVRi*^]w?Xy$nO5EB X00 { c`B4c42mb[Iݐho ߭53%2 W$½BK޿Zbǟc)]cu;2>A筰64@=9r7:^W7WPr͖bqmյf@CKk{n [?exFY2F$wM$[sG;d~z:~>{¤ȉ\k3ۜkXzjNDZ-v߽,&͵B`>ve:̒0lWm>tSxt!GLU\Y/\un: W krʐ>o`n /5?M^ TDr2c}Z7unHﭱ8kF/c ׾؏5MO x?"P$5}EgXJi4$R$'m*I_:JX:ŦHc 7OQSlJ/aM*+I9* Ὧ@S2nX!"% h#+ڦyBvibщ#t2]kBg ne 'Q䞯}i *d%e/K>[ML>2y, +oQ)@ )pRJ3mqG L7"/hsq qL)|Em~6-^[Oߖt# $"A*Am)otZ# ckO:-5іglq/PkFݨt"&>0i>%24eJ)}_Ng\"X/Zxb4U, 4Y1ɷ_Z} u J-$1}ʛ,\eq7Eb0_бU0dꋅ߽k ^}4g`"Dt|*pŃi;'$3l4+\+IUOqB:Aqg>Ò^kM. [{ &NdcWë̒ÛG爐LUMghU<-YJQ_7]8vJP OgEeVۨ1nU7TboW~nP%Vȱ\ȣ@/?ar9VT>T < Pv(hhVn"UTymtUr:-cqP vXVdI./^ņ4;JOW b[\5 ?mVHc!їx$TBGp~f9v(/AW2 EѲu\YVvQk"Vb&=Z~҄GtSj5jS>[Z7hD"{:4VhŗEtǥѝc`%$J1^?qb4fh:w1@$x;U!R#|/u[O#4yP*7K;y4)1vV#J_}TVu&Oʫ[ VBR7I9v68tʔ]Wp!"r z-.$hC36`e[`-MۙqC-L :n%#! j4;CȍW8X0$]k8Yȴi;M*ycܘllX)յ?v ldy7\9+:G,"awByw6wHfcBx #Ǚ4r*+G`xnf O} by8; |1o/3ef.L q"q Eieܷrk8:Ce𼤍   Mr hdp9}_$!YW *',@4NQ#Z!78;3 %B8,3'J(Aѹ'C̢ύYҽjd'h¥F u,5!W:=O2ViXZǚ!8JuGcq&|8 HH2@B'ȷMv* #C\gCR[lk:wN)U$[)2 {_Xi-\k6+SJj߂w 9=,_L!6hߖY,IǤy۸X4Osr#~X$b]y-+TP8H(q#9I zqÀJ|T߬=qVXQavVCt0Vr]7rm7BŊ ,z8ޞ(=c=qAh.Ś7tuawQT*;"h Z< D,[`eF@:wF[_˷H&4vw)RndEI`X0۬]oF;-޵ڭ^tW-G]ȮwF:^36ưqzls6O9ٍzq+S?w.$3NݭKkGصǒ}kNy(;]|G6Fԇ!-gHICnὒ&,-/"  yH\:FE T7\OhsdKZS[2.a_@ǧz1GZs~N,vv׶(qzfMO6NOlYJ?73"6]x[@2"xGk6xV|٩[_ri~wHAȑBx?u6b" 33F:>A(Y.ݣ>c p3" #Ǥ)ȇD|ΘܢhjEҜc+> =QEIoN̖Pm-C)6x6n`KHSkiDuC}SyDއu12'^lt6s0iNzF%or ??3e-- ܊+:_3I!?;2KTQ  yB lגkNNЛvhNիw[#P?m[6;VC#:=ɨkFn6ڍ^o10?X;gw?Ni, 33&s=mmtԖ4ToJ=L0R `RCvZ0F 율ם4/􆦟 ӵn:]2?k6ih-xh׻4mZu:-xhmێ{T;zB42mh=U6t fҎ(D4IokkԉpJQ N"Ý蔱v"p'4.>ZGKI1A;'hJ/g] .QB$\S5:R&тr߼Ⱥ72E!k$FSME z#=v:HҎU),($33Nu@v@h{)cvW& IzDX7@aijxﵰM0@ &uIk]"hs3mc} μ`\SkV u{ DkR#A@$]KGGAB[ƨ[A:2Ug@ꀰI4c PYj;{mi~& u`} |.1-m˽JuP\|*Kp~så5ރQ}..-*Kwה@=\햁k4-SX|vY} sw/wͷ=S$ %}5n!37rʌk42FN{i/f*]ok zۚA;5IO$4AV}mC4YVxu_FKku(#A  {u (8:V2ExnhvTP8iXqW@c} 1j_M{Gt5 )[49'fk$0'ŨR #=zr#&>-n9˃qӭ>[^Vavw) oH;\;Jhk/T{|"6|/6l=*s!yp}U}OŅ2 xIU] D$%LcT"CemkZkA7.׍hbHVPQne QvOo[ `cٯ΋wu|*B5*/jJEA)8x\\UyJ*LZÖHz4;3v V,*嵩D OOp jPA-~!맿$os+B֚ۊJMX ۝ 9Ϣ 33`dk=njp,ϒ,c˸3^`l}  >OZ;z67pv{ĕ^!IA.L̍ϸ*=%dSJ+%Hy9r7]~l7ou6!ҁ3nt QovFٍoQ9w_VocvCL +xa<%N䟓Kȗ6nf_" 8B~I?HTW31PAB^ٽ5zE̸wҗ~RJZ92gi:ْͰƊrX Ll\_AM\ZmZ/#>R3j j gj[/ܐI̱8֍Ǐb^jS[l&ܰTEQ|-^c)pK'|Uϋҭ_XKRh@nӵU k$uYv~H FwbOJu'$Ǣ\r'|Zh7[?n"+ג;zdQ-u+Dι)ݩM߭PInc`<[w VmKƝ'1KU': 6K~o|xNz# J4}:r\~#߮u϶99Yi5 A5S[-.aJ0=&`-t|=OWl%*7t1=GSy(~Z{-34v\dk˚;\fӏgbbFN-ܛ2q[rO#^/ҝ)۲V{U/UDbVu|]^'_bWfu YW.e鷗qJ£^bY`DNf:bx*:,kooi6@ ͽ M_@H ?2p#Stv`ϠobM.l/t|O**eU|E၄lӛO7]Yֽ,!Hx݈ݲ߳C)kibKגGTTЌcMOo-s6,ҁqJ |EשxMH.oao\i-B9,ds 2vJ |dGnyb0%vb1Agro)YC(}H"+( t+ / g|GZJL!ЀnGU5פ)7H$$9u6T8&옞`QeF9[CrW|ˉp% {3~nK+RDS\; V 1SQ໮4O#=sз0_3lp"L/&ZydbIKArtHor /M elp)| '4fh*/_#&jYO V aӎPڷr!{~@C#h>̷-bxpyyG~xPU^?op̏m#yC՘q},({t aVp MΟ0r ($N;4h]Ҥ W1nl jNsij)| :ylFi3aJHWiH?cƉq\ji#!)dz/{?t:1:+\Nqj(vy,tXh I4=@ug'v?>i:NͲgx+'.˕yjQYI/{#dibFx aEj>|VW{5N/*@ڿ+}KǛ/K~g%m1"-&߃^^g3SիJэjJ$PPt|MȺ)T0@W5 dJ `>YgNjv%b!^SˁI+H Q#\~]~'@2\.jMz2+d,t4-x,>YKcS @` &%f 7r.֙3[$o1Xށq!LH,P* qr5W=+s%k3b,ી ;]62qk['iǷԮa-P*1^Kahw i2Fpo.$$Qkn[*?~xүWWM