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[ _nhxDHbB*I?3uIwv ׏PF3w/_ɵ)3ONDfw"KM d)xTIg͘):l,|/b9v45mvꌘJ/xNX,:aq0ה?v\&KӀMyE_MfثPD.ͤ_JʷP,Wqݶemu6C{w[il-+߶;V[?9 55z,썦{8©eߚFkosgVel18f;hͪhPUJbM&Db& R䩯"ðF+%Ja5U 9 ,=4Cvy p,0 w1v"<:Sù5b}? }gE2ywk@hƐP_N8w (k^k~az {?vٹFV-8EyK+,S!@.^k0LwT]T[}u܊}0XTQXLRa>`;^_gSǶ7[x2CT5$; Q1>/QFumfC'{v r q7qT;JڣCd4l$ S ^u o'LF:\?Uh` t >0ͱs%(fʘ)r6Cܴ"hʒ 3Ie49VV-w)=̇9j?ܗOP )2alD% ``+v)5(f`G݃PC+#LƚydnwLړJkF#I˪MfvB5D 2Ӑ2R!19,lL\(Zp&Jj X_렚j/5k@ ٗ @VglNo=]`_vLĮ.t`_,z9Lpx;*(116:apmux0$`63X9a/ 7oihV5Pƚ ""§5ڣak9pYÔ$]f:YhY?tVlc*X A%QA0Vڊ(ѩJ)EoIͪک"{ӊ<\S9F zR}]1]Eo7^2ck FZJJ<s1V(u픖ۉ)~M8?V{(hm?x!SSljzn|]WV^ѩ ̳z=F)5b|lCh5ye;FT>`Y]ZA*Kp{wh  @CP c)g=%Zdn=SA:A?b|`hSEt.0CIp {,+0IZ'ŁA׊NBfyUaU4`E)&*<#1g$[<,o@ɟP prc% |/B^O稴2+q6弾|M%-9D&D$x(Ib#3p :|D@6PYDZIx&ʘk51Dc$a? {[!sDecx%jauB~TqS[Bb>cgO߫yל}d(L#`^UhN!}A k_ #|FkD,&7dK jsTQ~&::0lG츂xO*U9e Df+r9Gc:Ut *L<8UhUj3n9`ش4q@8S asjy!p(E'9)`}b[N8%ij=1ڐpш`31LoqQt<&~XP$}us&-A|p<.@L6v8,}4 OH0ފh!P ;zo'|08t\ڄH8+0Fn;zu\9؟AӅDE[c \jgM\(2 eGYv@mL3*#Nǥ&X8B8W"M94P@/kꪮ `v@? n$ $Ľ -r%}>< B$;h:"X@( 9oH~ ZB@>xﺿ>0̵43$ADR9&J@}AzyC,h'x)lp2,!іB9$aEơDӁWŊ#zyh⃲0q OMA's^}~=Y2[#0EYޙ@)%8@U„#sց@"4 o1T-֒AX*? ExjCLnG+Y  B3$C KxwPAabJ7#\\XesԢ#β6!+'dT5|"c П!Uh bEhV\W9 Nh!ίf_~\pI̚#L>lA{⁣ cO73 5P02/c@ ( =`b8 ,G}AGWWl*#aAð_#lYG<Ì0;;[ c3yB^Iބݏ qAz"w$%@ y(9x J|7N{bڥ (@||}ᓘ)A"eB,I$ə 9z *Y$&%̒hr),F^ k1R@*#2xDTM䃄AU Z>Db68^Z6fWA1\j.ˤZȓo籡U4A(f K0ԫK bGrK'gFLX#Yu#86n^:,r_2)ļA`tp\ʈ)/Hĝ/Eavo` KhNh%NO5n50;0 a4۴8n?n ?iiݴܗޞa š b9px 0Sxg/+ \q`Ȳ0˪"3/PH#[ <:slCBoP+JSZjZ]n-L6a#e#3JB!+POt7`R߻2Txql/Xp}U2HbE('Dط?rD+nec*%͊0@?ZR~ 8KhΧ ;5NY6;ۏi-RArNՏ%}ӌ&xusTyaĐO'Ur&; ~Aձ镉oe%'0L{ po}ʩ `"gƒovvH07Ke\9[}!4 0zHR"*+AhU hoc)CY~_>8`8cEE-za~k %-тAI"/7\Gl!pПE*4)hS-ݤ& 0%Ӭxa-L&烪B҃PUQxLEX|M+L \hM)GC uwj2x/>-8&0 MEF%TZѧe4@ [٦ڤ{L@Z a!Q쇠Pi)4q :ƥdcsbM%,fN$bc?2MD#2At`6:ߵOK=ɁJ0bG9by $Ȟ00GDdD#=+q7Qz4Fp.dl{=&bJdB~uEJy;TWT|BY;Ԉ yf3` 6E+I7$a+I@8OgxXl 0M%|P~r@ZdX\+Quj~e8cxe0 ~a@%5&\+<E@H]\%~X bonƥ3/+0b+# Jb3$0B 7 qJS,p[rPG4Z&ǭIsd!FMAN.A*|8.VU-"ȲJ =y>߉N/5Cd. :yoܗ_%,\%3WIF 3I Ց~qL4.5NNUz%Lj<0AGdc1@2E-^A6%?N_}xE=Uk%vm^I@U&J8<tۿaFdV X!T8n_D zUxFI ?$P:q 4%∐ }͡@=RK\^p`ev)6~M8zOava6g]`ga`0l^+ȫCi8AHHF[1ƺm|,Vn-\eL/R='ܷ3JKX^>09VD^l6Q@l)K{= oD֔FKBZFt8 5~Naz"qi ˬ=ub -R2 j"ZVl jͩGAWȱ &gk=NU1.ytU^"Nμ:޷AկQ PB(!eƲI{w"3qļ]E3xgeE~A/ᶁ\ p `<`T/zż˲U$i>;w#CUOXG@3WW>maq^X`C{l|U,%CY]v6QiH&|w dE q,8%[\ǵE_MB 13`By7Sʗ`eבp1FerNt()U&Hƀ(H=jlx.IpTa颂Q XsZ7N)P&wxqs]0:(It/-ƨSR\0[]엊t(Oȁqwfeʇ#XvBa➆&ݥ}l#ľ4<l;߉fVظgd!/o٠QvֈDUtՁk?1Ld\I!2 hq$Fj3YLs=^2X߼"7 OG:u& Ł۴.lcܩe %u?0W8JxY_>]F{X+m7m-R01pDPߚ+e`T:|y =EU %_z2ZLFIlеᣋŠCvB@ni|+/ٔY|J7\=X=s>FLRNOyt_oet_H</=i`5; *SR,_v4D^;6?hjZ*T<_ S)cg=ѸWƈ䬉~khgt0OXOgPk3, y'Lw vfs Ko_ټvjphXkvB}x gnBwO6  0K°!~J׷٢wL?RGӵ?CY0U&ws0AY@GcU0R0&O yQ sgg|)/=b[7j)ch5vCzgXk5:~L3iYG~Tzj-}]S"@t}lE|M 6 F&⩁@P%/Ɨ>$G,}ŦHc t5hoNQS8J/aM*+I9* o@S2XoݰﲋTܠy肬h^&kA^ڥtNIХ%;&y ?ef['./8DoS=!n)ʛ?5Ŀ>JUAO-f훥8`o P+ne CZ\h'! l-ʙzx*$H ݶ}cf>UQI(wQV AV̱%AMKU4d'F`fDHc%g,]KsTܞŲĝ 'a74?l<|z|h{jx%y"~˿ܓGk20/{!c0׳oO$+ =C,<+=l, +oQ)~AIC:[L[KML!'{EmN_8!iWZĉ?S|~;{nJ&v[Vӭ+E_Jy)o[SґLo匶1c#{1BX3F50l᫇j8oڧDД)h}:qrbh!T4tPgaV;.#?cqF~k[Pj,-Vd ^.t0(:"@V, k7̆ τ 羇'D`cg!} am"ઋ2JH휒̞sΈϡK2̵\)܇w淂cXKA͢ @\z` ;qلb(H#Iu#™M$r LWʹ *l.ku?.sx8('dT6b)+z*.Kcf=],z"eL?Xyr:\Pye4ΜDn^JB9H5՝ gUZDzCyPi&-3na${(ul KVg3 P0)'V΂4;G_,8s-5Y,i;M*ycC&;lRk qڿavvw\2Z3'x882[Vo99[0!2{xQU]{#A4ct-g@Hk-%teHDJ<8TO^Y-Sh$}Z[BToqvg*VA J/|$q$(Y gNPs}O燘E{հɸOIB4(es,+ :  VX:#8JҔ@#cx&|8 HHH2.g`HJd[lBm &5P!N)DcKl&p4” q y+c<ϱ=V|o,d4P u >:5qmZAw*NܩbR)e>AXia\ ū+BSY~Do@@K£]М[Y/af2-I"IȬppfҼm\Q,g9]znbtuOaR Q J{BM(al NJ[ nC􃋜%8a^%n7ոD Sš0yѓn;%S=n'_Z[&oXAs&#Z'|η]QdÒ'[`@ׄ#!T*ݴ6Nk=bQXkpHh `& لF.l6 S^kfvtqeջVkjte HgvvƆ6BSow7ۜS`N$F 8uI TKqtvE4?lcvھvx,\[tD p8y0]H is=e7-1e~^G|n-[ŨZS+4]+,5BIXgz-0|aV9`~$K ;4Do.x\gNHq~~Me{ 2ˁ 2LHJ}nMzU^$:ȉ3cJCKdeD[۹ŋֈEd}#<K_P1~bk3F 01d[eD O{+y|/_څڢQoۅ˟^y{nЉ1kQC{?wF) - oĖ%@+k 8+(sije3=衄 (%E^o:Nj;FCoJ vhNիw[C?m[6;VC#:=nNi7FK7JaDC$WRu zM[}хt]I-|K]RĿHPmuI$10>6yd$8 H,Յ_Jwڭw?Npi,2ӵ=mmtԖ4TkJ=L0R `RCvZ0ߵF Ү윪ם4􆦟 ӵn:]b?k6ih-xh׻6mZu:-xhmێ{T;zB42mh=U6@ fҎ(D4IockQ K%_;b<$nGgE7vVҜ?k4>Z''_cၠfw"?NġYє=_%0}RVO &[ CHk_uf~Me[y9g aze BV@YG83ZAXF({ t;*RPoYPI1fX(H`]3ФRVRM4@ZVGm@ka-(U:`A-MhГлD·gty-@tO7' z$yG8;IT QOPKud^XpahfC5R9BEj~+ MF<K|t0sK7Y=NN07 !!ƇKWv1,P9exT햁k-a SX|vY} sw/wr=S$ fFGXav *vu8+hd4ޝSX :UVZ `5mOkjh'^INxۆ,.(z z5꠲4Q,*1@7@ , QVvubTTB쨠cj* Pt7=bl4n@vkAtdS ;jm+mCc:Z,nW NU4hqPG]کۃ,6tF$-b63`EP-:*==}r^ϯꁊ6c)c:-TrУR4t{Ta( <;%T w h Vу浡'.e# atsFAgT0$@16 (vWjΟkJDKJB+$q(F*eD>IB@Q`5~ c]f_ 2B)TWB=GiAc*xRn%L(Ŷ:?ze zs)@FA.Ub7P@THt>hJmܝis>mOjTm 3] HN߶3T:̓rcW(E8n&GSjoqx˹j~чaRi`Ǐ,WX)MyQ2mӒUx7.] p,ɏrNc, |px#q]36|ɶڼ2*ȟa$>B2999Ӗ9dؿOݭcܭcܭcܭcܭci?F[[YXgX'n?RZyw>{>{?ZV 9 >I F\|G)Dgo͇Gy7<ɡK˗L#`A'y|_LFP攏3Q*"y(GDzUO\)kD>]ӵ$زEs:P'F p=~BϤJ?~"=ze ~Z?ұ< 71ESTCw}僇m.^\vQ1D78^hA.S;? fƠ m5t<t- B()Jʨ20?s$nZ0XQ} emO\79tB0xF%W2 O?iF#ql-)M?EM0pbeT(Ioy[|+%;Rt4HNy4WfO;ͰϠ +WTB6}gAz17q _-n^o4Kyฒ~:PV!O_! -|e@ Q4(=Oxh+-N(3 m Dj1{I:7" 7qmN)3:nLK*Op _%)_ qHIπ&,RmuK`Dܯ!xOD0<<'sr.͌Kdm\}^[Ek߾;j͗KE̸CҲwRJZ92hڒͰƊr7X&Ll\{AQWnw>jjԌZ[MLmK2pE@9zx8F *85੅ osЁ ;Vjr:m-~,V;}1.r gS̙HeÕ[-Wyq!ӊ4>w{L$;en8JA][' Kc?HǡPAx'cƎ[ WXl`FwS;d7?f~4 iW-8#΂7r8zcub;46j_xj;mVSfݭ:@ۑS ?vM߭PInܯF<[w ;O`cא 0,~C J43Ţ? zEـ}ѩtYi5@ϪZ4*]l.`&;LV{y/8J 8oc{ᏦWnaW{FFw}~,:NvY3?pˬ_|pEBȩs;S&xKNu ~Ku)ݗ-8j{xZQA fEL]H{Ku5. m^7u2\2nUIxtLƒ;6P, Չ,TG OX%>Swy-HPo55˛!~DFspdwnΜLMlZΝR0_]Z%[=󣬩 @6BV,g^y|k$<unGnYs ǡִp~5c+˥#*P*hFBﱦ9[T#8%y`cl<&vV 7 Xtx7XUg9;A|de#LPx1LC; DճPX>q  0@pz# %|rQ>m!Je~_ı%.S4xxx 5iƼEb)>f59<#Iv έ ;';6{DQFN_DD))+ vk_r&<Ō[,QY'vb!^3ˁI+H Q#\~[~'@2\jMz2+d,l4-x ,>Y cS @` &%f 7r.їֹ3[$o1X᧚(jL(N qr=W}+q s%k3b"Y I!W%Z5ӫwFm 2qk['<_R_RÆGT@]&hߏ^S_ψvUw:V#j>-$$Qknv5[G1 3vNW`bm*V[.gRzl9c F