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%/slnKĄ"Ykf%QGtml `.|pLJgh wJ䦅<2Yd! Sm[I]s gD {n];hdXs^TfvdM:aql c(~ l+l;pk^0ܺ. Evt {t.{c9L_ߍjcuQ8OyQx/<1`c: =V͑|rC?'WKXzo7*N׌ć.4}߱fd{n=YHLeO9+cUUW{1tX"%} g ބc58yAݴƶ'2&Pm_C =-?PC1mW]h aV@hf_2HPH^dţvCOh;F3}\ݩ^*D;Dtz9v/0INyхPs ;^ql4AwN^Go6Նl$XN͠2CU鞚3hY!"Ahl{lA[C՛mUޜe'hzmL})`ꛍƒMBano-LPVo ,! ~v&o =g <NGiZ] \4zm]pUQ8}8WF0@ȱH$7`E 93+#h"*Dɕ+`Om 9(Ąd#˦JIQ)f)TC8jlNZ8 GEj&>豍͞n x̽n=ꏖi5x;{V skw\W27~3 47FoY[;&F)w‘i]V }VP@>-7akqOچninoI v l) Ms]GϻsFw(MĀc}2"Yln$pRT)'* _K>f9Q]d)2(s@<,%v @/Fvĵ7zgߵhNnt#ͱ?=R3²C1'PW5B6gvtUP=a*RD6ogs- - qN4.Z]Zfxtv\!ItG%:Ԙu_WhNwl_h#G#Xv;>{wٖݮoZ6TGڕwIwt}!͆&NF-lWn2d;u s1i].w2GЕG|lHbSLnQuFP?W]gbΗV[YWZa.7V&ܪsEL9|v) E"ȞsI2K gS⊕/KUʜ0ټҼL6]3ټs l0< ًlk0<L6]B&ax_=ya%0_ɂ{z!UP5ZVj? u`?MyG.P4]f͂ Ԇ^M|GZFnbH՝F{;z? z!VA$ϭڂ©߿Gv0/RkiB''J`-qJV?f`G?@{WGY!kM4stuxQ^kZiZ^tafTcNNH"s )#e:43:NK$?&Cad0ʼ3Ո M ̀w]Z֮v%@Mj.jbu%нYYS7dv؏dq5aX-7{4O9o#ֶenÉ`H-ċ ;4lkTs{{H:V6Q_a~x[wZDzA6t>4T0JR 9a`ثlz{Km6wJ76mUک:*1Bl6T}VPmUo5^HZ@Fs $lMA)_D, kNIjnlMYQNsv/o@GU}gcY}s333 EXVՆ89VU#Se|@4 \N}oiPA{[Z}MKV&8P&`3G=PԷ3>_R4onر7*Enr襆\A8B[7&,wY͛ q.KۦzQ0\sxoncj#$ko4cfn-l:TN O^ژ3zhe86֢H-8EPkfa<&p5jv@Z ̯m,fd @Zm٨56K@J4׌a`3Hךӣ8%MᯍFI7έً#JX\k 4X򫪦@B yRvzs7DGPkn n;D|-̱MniqA%)r*1]{LKl'iJG-S"F'q@hّmzrխTEL.\~^̀ vUzqUUMO}Vp{Э\\hy) Ф[,|7"sڢ-;ē_bqa(C=@{+ꁡAZ4P@ FG ;x+GQ_}ܵz3A)<}ۊf_c@\`: L{8)ɉ=I,P~XH L=5 3EP]1΀3rZ&A/ \^# OnmgF $cDFvXzgqt|@#@5qA|m-kwmnP;I%(eaVҩN+cBt>J_ TKU>cR0z(`VZ<"{tl?LOr~K3ߵw@T֏>GPxV $_G%W% \U$$kk8]W1W VT&y-9#`^UhNy5F z @9W^-<Ř׈R !mUOL=ģrDћz]@w` Ev^=&o,{Vaή)WuT0K5 ST9`U2 Ep %*]j@gudFҰ}4ش4.(&㄁ĻI^A3BѫYS@([Cfz 8#xTTOIFkNO7$4"fh Í'8ǔ +.lErЗ8go.SF%WZxkn҄'$th hP* ?:7E_kƞ3j~L^:hmN$ 9L~ 7:o=>H{z*s+՚YS㾮ԇ|@=OiBjjTżQU :.4jyx_f4@᮹ˆٙWV6ӄ*ؒ Sd$w5V^ 0'Hb(fֲqS;ADBW<Hc&߂6k @s`53&ADR?޽~UJ@cAzyC,j@xS^+X庄K6Pcu z;F]o}Gqb56.]q맆֠Wpt]aZn1e=V)ʣC{^{0'?J:CNi]hX>zyNY.3īن`>ةV| lEhm%!6QEmJ)iY?U L]I)J9fFҮ]ṁI8 T'N4yS\2-!XxqO33g\XK;0mj2m>1 8ZD %)he!6XX;|]ۭJx35ɅYyS~`emB fTM\$T5 |a.П!Uh Cn1#4+Ҝr~'U/G. ˌMarMfS  0t#x0s^ZY]ź'BU3,tx̙[X4WFq/:qB0}ٚwoRHG$/;jUV@^y{1$#\SԞy$o_9T}ַ/Ͱy1)(tιQׇ~%w%n;~g~c-za y=LӀB7Y M-`IPƚ+sC1SëJוNGQM gEY.TJ 2AE#"=C;0<hKQgQy :JW )Q#i<< jN1b跍z#J}J/#]Nky?Q{Itqq> ;߄S k+A9=.;èK:(+9HCij=\`H& v,؄a$V@Щ=&Sh#r~z9t?l@0(v#'T 9娺k4@4"hZr$,0>uq ~6K#)`y5[Ic#}B^Mߤݏ 9qAz" I ~j~exh|:z'o:Bʤbe Q9˿Iՠ J-Dda0 ͅ *y$%֑']d+) % Nq1USf|P S"7<'/-tPA?q\C;UFӉ>?VnE<_U_D(}{f9U]o" \+DU2,1O}!cj gE"V6W 3tdDR ~%ILybh`tUM{3Fzu򐱢n∀1TEtLHQph$Std'M J⏉SK>F(DLf.n 6TV o t0FH S%ͷl nDh}]0betXlOafJdž_e%V\7Y&fU+~L+E(A5\9[Rlȳ/đ%T)-5/7ȗS]^Q9gjO%K~βǑG cF%Xqާ|0q̧R߻Sx{IIr> 9uV5$Fyr[cL$_ +X¬dvL[g*@s>嗗8HT3tq)~\LK R*7,/A04X}˩剄?kI$9//*Oj1kU:*"|wxE3J:HUPчKG=5cہ[_Pubzoz!p [xTU1{=7kk$ t2%Ⱥk`bDTV"Ѽ1?"S>]$(!3([ܢװKZS b7Yi E^]eO'k*M"-p Cd4D?B_ag S,wXjZ= I(fG)D)%P{gO&#ڜO H; t)bJ;^EYY) Хho9"Vi!6cU0Y@Xfy!(f| M,7q)Z`dKQ (%OlEN1L@9) ټ.-H `L4QXr= D'*\.)/*٠ %fe P\-;`oх4OD.aPd!C S϶XCR .q^)h5æټw1s'LRگ*%u$qrϪ ۘ|wG0 %}P~r@Z-Ykl㨺B5J=`x0t@S5|kTtӀ$!ŹKJi`/៥r܌KQg _Vc+ngH:u"]'HNȌlW" wutEBTЊ+lhC i&ϹBCn rw wҍj(ˁ©mUТ*ۋ, RI+|9rTMY)냎"AU9S!bxa(IF6:>~ h :…Ʃ, <ȫ^Wr8 1σf!tϗw%ɀZTBglJMxz&zKgHEhMӵޯ[B0pܾb(  pi ߧΡtMhJ$!9KZ@_z<*b@ŁS-m BYDYSf;̚a0+@xb_66B*AjvRZX㲍ӕrW8X>:UljdٝwW.0#̭~=p@ۢ,a^?$囬r5uz# {!Q?W=OBl8ʂVĞ:5WIx%w+6Sj?ԣ+Ću`mkx ͌"(Aϼ*1nQ PyR( eIC)'(Mxz|l9rĴM@pap@tfam7!2XpY6*\FN} HP^1p}ù--=+&na!P8?ESPl^>8OTEZi҄.\a!\n)A| NJI-būX3C,P)UUc-q/ 8m 3;ѡWE2 }5y,IpT٢B wga@>ФeD JJ.$}nQJ?\;wxq.ux#|cT))Y/KE~a]=_qwfeʇ ElͲCi➆&ݙ}|)4_BGPNq3+ibsg7x\m~vdֈDKWU;>YJYx'ur' C=X\^Ex졻y~|``Rhx?送S08 L'YEZeJϴY?F%dw >WeI)Ric{ǽ2:LA'7쉹 J" )5-/D{ AYS:0m'.TՉ7[90C}/q>j]3K!45ӟpgAeaHe`YDUL˞9(~H/i9Ǧ ?\1343X=ϽYJBxԪIVry/hsZyBϞQf:ͬ/Z/czOkK׺C3:"M=c,=K-p:I{=v*wxl{`82njtꇴ =1 )֩yz/m `ð[ >:Q1MUTR:J-{(Uz\~AVkA*D U9A6Ÿ2ɮQfKq4rrxdnu(wu{ez,e'FvwӇ;O6NQVk{ӧ8zdKH}OnI~.`%__-@+g~?0cM][Wz% a "#>A_~!L4Ӓtc$@ϻ4L .ո`Qv0'C/aqq0kq&^Qq__LJmxoX5c$c5a`8 #`(;L `qiq u'DtbQ@?LO 0R*z*.KۃNp_=a9f|+ϙM]sQ`LtN "(}9$̟gh-TLWot(DΖ?a/ZUg`ۥcO*2NZ '<Ru>`sd-@Ⱥ!~ȓd9]GCxNZɻx &[lRcpvȸ:LR6]}׋9U O[.|KǻP$~3^Vj=VnܛӥǢ4;csr_R%; 1vBOt$ʤ!g95fϋ#3R0Q€+J xB{(uoXj6hM {@aĝy_hݪ[sbYIxٻUjg)Y%:rZLbE)'4+e!2P7)K {0x :bN#H/9ÜuZ J^grQM3>±S2j8Ga Cd셶4kbBL|-kXJ0  aHZ 6vG&C#>,)O$p(CC͏{K3F ,F_âڥ7@LXzDJ(,y$Y-RYݴERJMr=}6, h@ s8v>CW. jwgTU#n]<;IY5<-n  @r2h\WJtd#Cƚ/ǟ #9gţ m &;)$a\+NIJ$Ya]w9V9!ނ.eOT8Է}1j'ͥ#wH-2=BPHl5Z'ĭs0O8U*S5Wd !x'AI/cPܤ?I\j!fŸ YAߑWt9"ej/tȂ{Uc/}Y*gૃ-ȵ]Ȍ vŎ"o[݈ 3 0&(bwmkҦ`$b. fk#m|F2gf^DnPnjyZV=̵fּUߓ]i%@Ϫj]Z-fygj.(̀LBo2px߄VH y^6/!`iWM&mEֳ 5jGRC6?6j* ۪ UkVuh=WVKQ@RjIN!JkIVK.s@[ fy(.ϻK9̜ /-M %2PˆJ \Ҽ/`º,¥,ng"[n7U[7S[ʱ\9ah϶;t&ȋ4~oh=w!+ h&y}@8m*Ֆ/is. )ml,dž̴Бa< V Eq[~ Z&[GA 2Fw j5pyTcT!G{VoЩܼu*f֎H,ʞ% t} v[=2Y~I3l½<ӷIuGVu`[BwP3v^ SIIR!'J~i}r1KBr*{O(rtBu`ZE5ZA4Y$z}Sy3yCuh峓m}֠nUJW9 pœh٤|ݏx!3cuCz1PYC}à ujT W+V(;E57ݞEMDBWwK [+sww~tjZ!EuY&qg؟z o`*F= K<}o%[7<[\E +nICzcܺߵ۹dOK孲\,7P*ZY\YN<"S=9]) Ҝz2vv )bLVC[ 6f2I~S'uC''8߇ܬcBhvW:#x&'5)p<|[yÃO.]+9巑X 8'9yф"tړC}1> .8{:q}cza 8ݐRХr<OyїyCwyѧ0]/MXBd[{V+XdZn٥;aͭ[ջXnKǤLEڗ*QC.G %E ޾է+SpQwsWNt6#ZpQAjc5f(oqݑ"ߙLo4\P.p=|I?QL 7ժ 귇E˴j 7_[J Љa #ou[W{ZA{ZoW^К[+ &);μTņch%xʡIe7&9PU"';nBUɳK]\w2?C עŋof7T[5;O´qB􍀹sxo%ls2|RŪ*֥y+q_ZçuVWp^Mygn8DxngzcqK{-Bq1x& ?Fa߸þ\6vg,_XwaB>W {V0C;GfV.d2U/"-&f]]- OjDc&6'8xQ;OTL\/6K޹َ_(Pv5 T:I|:{֩ c#vV}d7] y  D ꐻ"I`,Fv_ЭG" 9 8(GщTм4}dBȦz9>N^&x|)#>(ьR~ ˃IҏszDeW͡튏$P.w?<5a?t)e`6X-ɷoüP~*>hd_X?Y >\y'WTvuYsEȌghnhA +tIewӄqs>5.pYlk.ӌA~tb]L4j}Wӯe1 }=rU1i_fQ&7A?MJ7P"JO||m yL60C+sCϤ6yOdtOFSUL8u$K}0Lɤ@3aoc 9LXTԦ"iʰngэKp ^?|m|??So&2PXo7N\+cܲYR\g3_r6yR5c/زފ±(3ݵ|>EUhd(͍MpUGP-\K]҅Y M-EzA)ы;[`QdG ??szA8sHƯ$̖8 Y;0}!A'Ԗ}03]6Fk0mmnomBG9zMEOۙBc*luOe@bOUSSsLmق#.F1#?M׷p$^LQϸ8?wI1N-~LU\ ;`?)Ws>a*Wvr+xEP4K Cύe7FJ"-6_Naq(Cڻ'Z8?t6&V5] E ?Ӿ/ 4] &E"=DͺެC';Vz,[9Wk-7.47< '3:N#,p? P 6-.H&#ɀ&HR%;i,ճUu7[_#֗\\϶Hb 3]ߺ˲n% [?f^ԧ[&\Q,S`g8Y)aY֭F[Chli\;[?+D'+lU ?\-2vs;TrYܟQ;(aO_> EoϏB}fǜEf@ ~RLZ 4U"W[4*](]Lw;sLlpLțFkUȇqAصfF}kv97U7*Č=uo=X=4|߶fz]?eծ#>8WKb^xg4H&]k5\G2n^IxLC-uEYYreܕ<5W X? K7}vsU)ɝ9uú93(e71-_`,d\?3Uq{ 7X7!_zvtjʣ,IxpSax=oniKi] Z;_r(4}ϟȭX,sVF,282ϼ ,?aX)V.o/u W.ro\i-,>8Aa>,nh$Qiha0 8WC'`NrNi>7WT(2wiUy@2`O-?b2 uqBԋؘx*DbimMcIo!{Iu-0ALҚeD7yB 3R /۹nRӪlߡ$>i˭ sze,2syo0\pu欪8y=Tz6vtCǗXIGJB 8sX^?-ۊ2sC@ش ?~_R/׋y`~ Eh|NONUjU*G^q7@@wzgceIiIǩ,L({|*aVp 3))W y+,|{bB6x .<.3I80c B5,# prf0ipS57O q5>=5fd&^] _S$X&tj8v"wP4q4d{ ]V