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

y{۶8w<; l#Ť$J&/qlM:>IL(RbY~wfinjI`0ٰG±s_PP"7-;#xh(hJcn(6NhY114711qNg.5TVEP⾦7vW&;ݨm($[J`o<GA ls& ωpt5]Fmqj( =tN%!c )6r(Ԇ9 hy1#|{m-[F(V}9m$u؟0ZLqc[ ;8L?xZ|'X6kV5[$'oyNSVfOnD;vHӑr-}qoNnc4M7̃؟HG~n1gP5B6VvtY@=a*RLng3-M?/ q^.Z3OMz<+˽}0Qu5au{Mp##Xv;>{7lnwbZ lRf+$ DE4GFҷ% MZٮixvb4 8P]2d+iB3 Ħ{>ۢЛNBLFu\ؙ+Ҫݹ|#f[G#[ eLk(l`/ڵ$LnR)Y1MUgrK+'Ջ5 *s!R 2yM"=fN5+'^.K9WaE%y X3٢3KXUleLV L4s1_d3 FP4+1$FKYp`#Wϥ jC*'WmY5j)7K͢yPAژUcQ(*f |%0qyԨc}'xPAT]X*(t5@\[Q@8ՔPʐtq- PcT8 %Ni' uh 0+b-ӶfNRc2JkV+I˪.jlɉݳ!Id!eCNstHc2t{Kk1 iӻˠZRV@ͥ@M:}[{KvLƮz `HW&E"\0p ù~a&&`{ٵ̝r8 pA7y9xQQ~sE*1=Hx ~ok9pY)IwpgEg^oK6&T,^e[;jSeRԮ2NՅ78ۇK*qPFR}Cm6vUXY{ ?  xk ͭ&D4|h&,9'U5P_VukWҡރh֪`S3 EVӆ8VU#Wel@4 \N}&iPA{WY}MK֘&8P6`;C=PԷW3:[Q4ooeر*Enr襆\A(F[7&,i vq+ۦzwQ0\3xocj#$ko4cff-l:T^ O^Z0zhe06ֲH-8ePkfi,o o`jrvE -Y}I׶@lD\ Zkw .l% dkko0@?0 ʊk(ƥ-'В&FVt{QiOҚ.ًBJ+_\k 4X&@B ES,:M޲ Ԛ[0[.@>`0,sC{=ϚU96ktY'*&J5Fǁl s88V+uZd;+õ|Z=B3'lifhNb%XƑwpA"售Ƒ{^FJwKk|o⌸nۊR\apV'+`J.dz0+^abihvT̲OHRo9dٹ`ش*@f>IiB)~`Qu~ubD"4苓bcہ.jXO!‘9&CZ ݗIϬ %~S#*cY`دЈ~.RK4p ?N)m`٨Je C&bbw=t[# ʬ'/kJKp--_ *ZVC1&B}ŘqDH -KJ-nH F1Wo :-Sjqɒ:]K|ŊזFת 2C%ڬ%M[[]U/`?\v+q0TfN@(]1IG9d: _E*!P|,60|3zL(j1^BxcSXZM8^J^_|M%-s D x(Q=kx kQ˧AdO};t#&2Q\Z}&*?-͐DeCp%7A B~TqUP[BU5 OHROұ3e{3o{5;8#`%+FAeҎ3BUW G9 sՂЛ<RCSC@/Vj)UxT(?zW^o v:l}mbG@of쪜rUXa"@e TS=wJ*آ Sf)x#NuD~-nۈֵf&d0x;NXݯ!h}]>z5Jr9d洧>nOzJg74^sz|!03@cn8qQx<&B-P$}qs&-A`P4*BGƛmp&<"E+NG QRfK}yسx CρK<MH\9ЯfWǕ?o<ioCOUcpZ>kbוPUGMZڸV1/CgXUsMqpp#WC9<5P@ok⢡: `v@? n$ $Ľ -J%}>>}sV$'hf-=D$tUcT:&s{HDY~3׬ឹ$B64A=v p>7e[KaksI 5R7]0?6A qɸHCkPň@+Oy0Q-=FE/=վKʓz%W'FU_}hX>zyN.3ن`>ةV| lEhm%&!6QEmJ(iM*ʇfT.0uFD'%*ASJv1'36Rx:rIJOas/_wla4 ‹z MŞqa-)11mSHo ;]aG+Y$ # C Kz`tkUĔoFf0?&xԤ+XdgY lgVc> Y1UC(zر g@!ڬ:[͊˪4\_ -e=yуckM ˌ dQ&Z  0tCx0s^ZY]ź'BUs,txԙ:[X4DFQXt ه$76ּ{B<7iiVkʣM%ܻ蒀V/pOQ{2A.>s9^=4Jo7^a@}c(SSQU膝qJ v\PO/@F Z?m$ | '>n^Y-- [bCQ5sͱWg(cn*f)Ϛi.DJ {2AE#$=C;0<hKQӰUPUHyT a8*9S-L0bm)鷍z#R}B/C]Nky?VIxqu> } c&A}5_1rz!{(}W1];ðK:(+9HCس=\`H& v,؄A(V@Щ=&Sh#r~>z9t?3l@0(v#%'T 9'zhhD![HXPaX|6esZ%e0,Ɔ[ $б< &oGp8 @yLs!8oA)ށ=N;2eHT/bsկv,}Ts7Yh0`ä<9sYB3!GFJAudgfI4D'$YoxbijDJ 76c[S.+t@4` *CDfs:C 47S<,vC(\O0H2G? xDJHKJ6I$Ycٯ|GTi>n`K_ѥ4T"0h(Rא! xƩg[IN .v^)h5æټw1$s'LRگ*%&uČqr՘mLɻ#i R ?9 -y–5`qT]y%1<3qkd.Ut " $.I@q.~C bgiu7Rԙ—J[%1N]q.#a$@'E+L: r"lo_TЊmhC i&=Fsc# 5A?(/!%#@DžS۪*EUYVdWrB3dp_S6EUrBC*I@4RtCu}%Dc}8.uʁsSixWSJqpc'?_\~Ov$jQ1 Q$}dSnA+*]0'-{T 4) UB!ǹkBnl<Έ}b */_"u*"C}凛LJj:BSP:q 4%∐+Z@?$$% (s-*b@ŁS-n \YDYf-0KvtXW Trاq@ +;ZS-lcrSTn* +GG0J8v,EvsLl3ju_&m#(K! n&LdM-n=a/WO{ |k$;s+h,xfM쩓khYPsUirbf_XV7=]6xMXl94;yLWŸhfUE8 z捜-%w..~-"Γ D)cMO1=1DQfG]ExceEy(ᶁpjamvb8&sB:d|1+lvU> ǵ}Oz_8tGb#.QqŅs[Z+&na.Xt(Šfq6qX&"-c`WI҄.\a!Ln)A| NZq-bW?+1f3&(4Yd|S8b9Y}ZvY ^sOvCI 4e2DAkK2YEF|rIʈdLI,`i8@<~$wxq/ItG,-ƨSR\ []*t(O{•)ؚe= Ms4OJ }i<l;ߡfVظd!o٠kH!xxt:CP;hv9!瀐^ ,g󐙛ēxgE ms"'[H+TUƝ]`]~kJQsJ2.%cݮش a| s0#@ A Q3\qF@uj$< SQAk:vO1O(Q ~"='`>I bmT&W=z/i&$8rqjH"~ePޞɣ8 rD1QϤٹ_ʓZzs<ޕ_C|CpCR_PNrMVRi^w]ԓm< QbsabUX'8hǖ3-b[d@>I@hov䌯wɦ+&p]co*o8ģ03عB:1?g# t]| & H >gGi6v\)7Pʭ?[qzWC }jѵP?J۝f#~GXF署HH7'vmJ3΀>[Aeb=a,Cz5(3ۜXzjizmۅ[v<; Eo=Z]1'}qP^.`LCDF)X|v%S N8nvG2T%7|M7;6s1`o.P@tr.T#&!GZwR f ! &0 ۝ c> XTE%ԼNLld!BPU`3dY.G,oe G#'G O r|S&,;qF1ݫ<;ǻ{ޣ6(8z.d? HO ůI~b\|J>9GrV\} (3/P뷲u%&&pW7}t#3LKӍDmN_4}WZĉ? &g|~;OߕemlYMW"@""^֟Hy6'dzK/9۳l4u]ȇdi^=ZͳVq2TR (;Ҿn^ jizѸBH46`qM':c^N Q"Y ~d* ,&MYaAfqŪsL_Sv4`4ึJAfF\kdHe.GI'{@+ |'ԉGGUXЋ^$Χ$JSKY o3J~7ჷ,Sd3qZ;K)bCQ=;mwLRz-mUԭ"4x&Eht)THoh~iRb씥e͇>'Jf_=bqY\3)@yuQJ[)4(~cR  "Svꧾz3(GT_%DxtpzjJlSǶ<0|7' PvR 7J8h>7ū.Vaގ9 x,eڏkp8|I*yM0-yK6A=؇r/).پE@΂*D'WZq.|+;W$X>zZdKEi6v$H /0qٗ ^I<{af0&$ghCDzߜ+{L&I&eY[YI0%ZG@6ȳR]a"!&Z#YjE4lwB>Dtޣ49ɫ082NB 4 D(+@&g?Sb?0~"ׄ)$%Qol %(:/(scst6&\JOmf><$KtYg㩟Sfl6uR鍬USuZϞgLD)q(` g`H2 l6EVG`go{u^Q!O)D4bs䬦yQSO:lAJ Jla^dSl$>>qV,x5d6G mErHnvZ_7Ⱦ/_%wZ !v5ū IJkh܃ Al]P5YlAd.}ՒlқK! yo@uOA-9מ<'dqNԲO iWL.Bj⊖,}z}γY:*JkW?/a*}}ڶ \ 0dF{[CDBPr9TY\H P<$9v0b(Pë+-ӷ}#`h(RrIw/9paoLJ+};OǖRY[Cki0Po- &T+DsJ7gĞظ +\i졆j@|R0^$|}&O&3;a tQ:P9$g}f=)뫻".Q'Ϋ`6;<+B \& 8aSwf#% Z+=d=$wF7D \Q{\4`ea&@\zOs@ȲI܈2*NKn)ޔ5?"NvQ3d܅m}ug!)Ib}/K&X=GwNYT2v(y^8c1n湜}`OO-V+ZMH55d>YOh]F 2w~kc=f9Qo,X;)Ԏ N}zSߺѝE٬7Hn׷Dg ּQ߃]5W41˦;> qϚ{FQZ! "[#"Q'}(qes59+u$S &A݇q|CWt ӤGelmFFWɄV=aN=m kq``h6sϡmy̲uC2~=z%wWcO1aal-pgL߹M~}]` >D3BYRw L# !_! !/ 2Q5g9I3fEdQPxK_jZ3ZTmg }$,?ruoߣ+r_>wP|bټќ5{{c1GF3D}˜1a%qhς}P1nMb k)8 }B7Q_2[;RPFeL=߰ OEZd4eɠ$lRwR/ӍL2\hnbxzP_h׼x&oFRW`;xCႁ (nGM}+6kD&>xGJYU](s ,)qvݐ A@R0ɿV'ԉN\6E"0٣hd8Q{5 e!,G /Q_no݌PjSn6": c Kg w:f#$jw=5jpi$wRc[Hc N|U>foo|ݕms8rMNSLv_㌇*؀j+u{k[z#6j<-{xLf;>LSo3%0㱔g2 3UgN3rG"ͩFsb'#Њ-'sMITL3IYTqg]y:qz%sul#<cq>iؐ 50h IbD<;@k5v-ծBp<)oV7Wgպz_#JUQS=!?tm3hYF-3.[8|git:'@'d9@z6{bQŲ{/գh}GKhnNCvi[ͭoX\mѦv8҆1^ n4wY`_(.2eO/1mf;DSl>8h]b q j&piOB+het+nbt"t}p_ӍSb{,]݄w.}a4 9T`Wڽٻ93i`{juBhO`<)~Teu?Byo8@7S]U H pMݷ(Ӵ<9r/'ų46}nd5)}%Z#ƛ` c9*BK+y%*zGhnNД^֘xCҧknTw2Cдgdt~worͶ2ZS\3e~xȖېbdTt9j GL`~RZ}SIGWEg̰?+浴vFkj^ +ew(@aǕkhʽEʽܕ7Wtz ,DX8fc~̱Cd &=/Ƹ9>s(:lj*5\ }A͈,5Ԗ,_^=Xc,ү1N澚O&~7j(fO_nԐ.~ L&˴%nΌeܷ-_A8|_zb&AS?/e.Yr_\m~0c 4w If_smf%(%eP%8!5,|/cI|!2> d-A)x7>cGk=jQн-:~/ȥہnB/W ݂ص"$6%|X5~G =y[ Ztoy'\~S;,miO 2*ViBK kP%bxeҥ̭ҥd X0x,Ϋlp̼țH5:䃫 ^fo}΋lw|e=wkubƞ:ӷpShO߷=zePYjmwl5ʹjH̊d]"ófW׸cZOx}+q=/đ[Tm0"5zS]^VX$>SHѕoi6@Ƣ)M@JriFNrpdya]ϠU^G&6._綣Og4 n2Ks=g^5VU\paz)gJ&=b1mgKDNv#׷E'f 6m*ʹkI #站{_Y.}<MfbꚧX˜5l11,:h{q~M=ߚ<j0 E3xsn`ZrY'@E8;dnLD XLP(_QЂU8% Q8&V~_sR1u!JeWjU2C^qg7@@wzʱLT}c&=TwA+8pz+{ < 8A8p\ń:9Ԝ:s),'lA$$uҍv#LvΑҐ~.v1F,)yyj:QYfhjɘ 42Sz%]nx1l^۵aE t ,<=66 fZSH|aS_QQFf0ULgQ)orAp @;n?G mD;.@]%4٘_Oec^fI^" ?=Bs 4}^z]^U* *zH#Pb:N`&dChoaoM`/ yv̘+ABo H$LM&n@`Эt@hq\^.{p3 K>G60V1 O`w5@N-A5GNhO/3{8O߆vEQa@`MOy(I4{^  caf˟=' I!%Zu}gnM7W[V6ƫ4VC4z-l^ȇ3`3S~Gll鍝ݲ:Ԃax"ܲ7IhϜUIiɱ'C4|stz`/Pr=8EVmVMƬӨV