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ݮ! E$壶 Sa;vw66 0@o|3i{%&<2%2ƿ3Yhj!Lծ{֌N~"ܩcGSf'ΈHDr>KsMyce4 ؔQ4d6h~0 ENWVx8Xx,΃ѨS6H9{ aoDǓmn(M;TgfM:6ZJ "E.on6,6ˬj#V()[nϊi3^-ý YH) o  =g..<ŪkcO nIHo&? -U2B?3\\EZFO57GSbFb=;jN;vfVd8v9 dži>1QE䫡; U8㩎g( {w!-9G pi(p~^$վ} "޽2!Bva/6`Ϫ +8|?P*OD`647c1qzg4Vdsn4^e[gzѵ0A\(z60uv6ƨ{;@Hͨc 7YRA%E_ܩ^d:w%]k+ {e("|bB`܇ʂ+B&iSu&Hyx. % 4toV@K0;' lѹ4z xlS  & mvlE04 Mf0@x((nY;Իi=cY]mu6C{wil-+sȟ̚mwzFjr=PԲoL{Q﵁7 }d93{cNsOp~UUHIZ`%t1a&J"1`)EٌXchmqJ*G^MysDHS()\냑չM`d:2|v>m3o0l&eTkHڕ Hwbt}^">͆&NJ-@4Ad; rs1n>w"ӕG|hH69ȟNB;6;u"_:eV7.}`cJRƿl!41[SdlϹnEЮ%yfrJ1mˊir:[Zy.?nIP+)fHh[s% if)zJܲr%Rzi"&lUeIAVڃlUՙ5XM* Y U$Y <Ñk? e Qs% "` R]B*'Wj֑90R8<MEˠ6>?ƾ#WTF&1 mB$aH^! Q@E\hbmMz|TSzsԾ/}:X R(e<وXK=>V$ASj4:Q2Z?@>WGYk5rG'1^(IFUjlݳ!Ad!eCNKcrX%>#%QXL\RA5F_jkj/5j @k PV{@w[ ԫ] ],z9Lpx;*(116:apmux0$`63X9a/ 7oihV5Pƚ ""§5ڣak9pYÔ$]f:YhY?tVlc*X A%QA0Vڊ(ѩJo(EoIͪک"{ӊ<\S9F zR}]1]Eo7^2ck FZJJVP(ǥT,.Hq6⤘q:Q&SHpd>D7;ˤgֆ(TE|, L sb\JJg0{witUU6tH٨JU,rEjKtb%RvGO_+qWĕ*[ZvsQTbpcKb+y}mbFDưH h Vw7])/R͛ƾ$M%[ˇTYjv65\_ܦ[ɝ/XVu@Fݾ+#n=4#nߴ$2{a./_Dȷq7lȴr;Yv a7&]u-uӡv-Yul/n\JٴarӮz^f,[ފm*v>ZмשikY]䕠/cCo76/ӡeˤc=P\UV/s~bT .l~ᆘVyZǼU5):+'m?6Y[K?Y~QYF/-o!/X6vp\ c<+Yqj\a]E62▻ӹ[0:^6FS >tkzWt^ۨcQɌz5l;w%XjB/!@e޳(ֵ5)6={y|_U7șpS'J^ȐNZS{*$+8LC:x`.&\5IUGmEkz/1ePILaK1y!OLEZrP[vX"Ysf.qډܗyd"p!7crO|?(XJܿ Jf̀xWWUUA?sBVy3p{ī\\)hRCs-2/_jdEEisN_~8f)5fXR;<9*U//+)Cqy3r4U @${aιkf+UvJrMz&T\U+=q4޶wщ)[jzn|ɏ\WV~g?bYGR?:#ֈ=c[VAӬ gDSݜSi"*||;Z;><$N}7pa #RƦL3S ZwL nɕ(D3~j y(?)jPƔ317$J F >'@bQ!)H@ihCmbrb'L(c7L$U,`d*4Boa\]Ï!8ګɗ Q {GUN)n e\Lr<)~b}_s2)#@Ĵ!DZEs()S6.a\Z3_#b59p ?\QůVzPO÷QPׁ` Ev^>fG'&{ Va/Ϯ Su%T0[9{'ԩhXTaʬW|<}2@ 5Uq9æe ǩ<\sUR 7؁"Qt![r F'VTxSB<{c 6gFG;;cB@hjaE2З8g7Y: <:8fAї<┹o Z #r Hr?U`l=gs{t!QY&& p$H<FPS*e茪ʈq 6V2f0|mESpp*1 T!P +.;xe%/h[ZʏĽ{īe$-`3CE=Ձc:&?KqX D>49|yN3.lg|>ةvuTq*k:m%&1 mڔP<;WCh]`rNJU1+v36HghHuDG9eD,PSg[KC'[c0m?91idga"2J ͐ ,,B)ތp2ray{C>H 7;Bnۄ8sS8q%\0j@T* GYqU+88}9|ts1&23k0&T0*=̜@-Tb硪h:vL]l,W8I3gI<y2I qG㶪 s+6wҁ}. x`hWdeh3"q{ɻo?dɾW>ַ +pX5O։(tΘYJKv\XK/A.@~]s[ۂѣXP>(t*zi庸,!6d75sFebhx\ˊa(wHi[&\P{ |DdzG`p#;Lc2~?4^1NwD3|Wszu`9)<8LqNJ=<ߏB.`uwZ%d!0,ΎVLІW7a#8`b}f^=I vv~-PC^5;pγ12R<4?ōwv!BeB12(d_$fJPHY~o$a'Iyr沄fBFJIu3$e |JbHAL0U @PU)? }7U$UE9;R\f~x D2CՃ %p)"2)&dAYlh`tUM{̽jƒ)!bEc\EIY(Hw0: | 1aP&v2bk7qgKcBÒZf` S[ͽ%:L…dh9j<6-[poFZm7-"u`hqhtXu>*̔3BpaX+,̲+~L"V8A5\9PPkTc*񜖚Vg)//ΔSe6F8˞Df bCW^~yn+&Qe< ^b;'1ZLJdp迈PNo8(wnV\F2pLK{/9K$*;08el?ɧ%ƷJ:Ky|:U?R1b;z,pGM3$Q婆C>1*?W-YGKhT)6# px9:7vt&|w;0UǦW&):k(>0[ C+' A Q`,q4nl[ӴSK2"ID%U% | U%y e}}4* )ݮ=9as+$4G ^$p9-C|pHNawwc|GH"+LaJYZxg!(MU0VԋF'V&0" A$ =њR"`pd}/`H}ZpL`>@KL*O˚9Li.A%JMIがRC,A7;RhfuKĚ#-K,X2M͜H@)~l+2ee!FLaelNukzC` ŎrŒI& ϐ=aTabH(|W9GzVo*ףp* W'ҕzt-Mʯ.Ȅ"L05<wlI.v^)h5ag@l{Wn&MI g’W:⁄qr+OLaKpK1 䀴dɰ-Rˍr*!p22`€ hG?k̅MRy*$!ŹK<&nƥ3/+0b+# Jb3$Y.Sn$R"ݕ}:9YjO^UЊmhC ph&=Csg' 釈5dn rw 5QH%qaԶBhQEU)Zt}92TMt sY{*f*J2 0 TpNbO;&8cqX pq, pdT+9F \O9 X!//?';((ju )yI+*](&#oRN, 4) U"!gk\<ˈg( */_"u*Ef/y?&6g҃^mѩ3ٹx>^8!y_ eµI4>p?}wG-8g./}>@^p s2:XJal2vUyT/LfvH XpJ6kƯ^kAbf&,or~/'+?]GV0 m %K;ѡWE&" `ck2X'S F|IʈdL/`/i8@cÚm\r\$uK8bgLIplt _*"N3U<"~ݙ+w(b5 {rti ~,'"vYOc㞑ygJfFۑX#( `/ X92h9({+p_CfnOb'&9,< o!%3O*XSU(d; BP 7d姂 b@njg{55Qp1yJO/IZ-x/Xq 8ZKJהVĈ8Yv{_؉w'-w_S;??"0H{t/n.8/ s4B}1` Nq"y0VѼoZ4agW 3[WYu )8)]hE u<X*$ˋ(ўFfk bϬ%Fh6Z\XDe&.p劖H~D%P0BןVb5fܜ}hOOx:x։3pU(ܦuyqUx'd NUg.[0M/KUBQsJ)?2_qhikO9# ֬7\1,SJՁ+) ) $`e7JbÅ _Vo$gsGN{;cs`ty`?N bT&V=LHFvK ~fWD} EϬE=yrAt/0;`0?3FyNf幖?ʯ,cJE LrM?b+t}4U.{¤ȉ\~ ng9װ՜k'F 7NP3ۉ~z fnBͻO7W g /K¨!~JעsL?RGӵ?CY0S&ws.Y0Xx* T,SLa4c;.._jRKVZd X3GMoݐ[c+p>ZG_" F}Uk\SMC('"ixn TI09WKhf)m 櫯$SСKXӬʮJ{RJBx+ԪW[7"% h:!+ڦyBvi:gF=tst b-'pO=@;WɟKspKGb.۔AO)[JO18}O.vϻnUef?Nǯ;<+7r*l \C09ܪIH4}E![ t7r J `C&v}@OUT:J]@U,//7@HU-spIhwhےd! xG8CHI'; r|W-,;v305{cQQEz}?{hoq7YG);/= ~4(cB*1o^q= > H1`SĒʳͲj՜rWtЭ4%K)ʹ40ݤ\9☦[(|E9wm~6㏸?^qݭn}e5݈|PJz[HyؚrdzK /gً9FšQ75]ȇd~x6}Od MRSg/WH+֋v/cM/KC~8 cxfm237:3V_C݂Rd|& o`@t@$̆U:ũxӋw[+xfC†s#"0_,>Yz2kMpŏ%$vNHd9c)ZIggRw`|Rǜ~XhSu1SBc<c\p6!:~jO:<,>y+=~N*Tմ|6Qc[=K)b+p݅cP** UgFuQ 7.xcn*+yX[Ej@$ X#r%"_{Qqc &Z1 S@S-4@A֡@7w3ΰ]ZP'B8xU`B)%s`YZ]%Adwѵ CivЕ b[\5 ?mVHc!mYdfo*#Y?dȚ3v+?ˢhٸDy,A+ڨeg+{^PzHAуrXe6_{dmp[TJ p _}prBg kyQTjy`" hM usa c{E! @~xէOӳW-^?iP) y5k)]-4l"`ʽzE`AD\g:R\1fzAA8MNh4ր ,i*]iwϺ-u<(pᥝB;eix􇀑\ۮg?<2ճ$t?Yg㩟Sf*mKX3VN]hӪ0DTgImRV6yodÚlC@LL%r6Sc ESO8laJ JݼjA[>wF,ٹj/Ȭc ס3żsHɝ"`]E( HNf"1tЏ-aIx{i{+" ?nI܍ ) ΒqL[E4' 1gLI"(֕Wݲ pA5Ohme.k2~+1]~pӑg9 +Efš:0 A˄O kT-@L|A(*VleTKW'Qz,$< ѥ 6`M4woSKO;`RXah۪+3ҹ3"XɻFr}6Kqt;'-M Zufz=l7:hlYn=]oF=Bv3ҙha4[Fw` n7QѨQ!g.Qji>#7(BҮ4$ԻKھv]{, a A鴙lj" 㱴qlPaD},;7Tzj%nH8rM =@>skܢ-F]Zy,H2`99#bMhnYd , ",d=a4[iŹ 󙩶_9|H٦ r`6O q/PxU^0"%r )q~Y h,s%VuD"2T˥OV@SG9}Åzhs6HS[22"_@Yr}.,v.HJ țsN9[>5=YAaKT0NsvO_}z}%׏}:uagSҒjJdulWj4VU7;˽UY4'ep0WC}ߣkI',z#şl-sF SS1 .a]oJ33^悀R! kï s $!'cJD&P!*lP Xw Lˆ:~E2w|_;a=ЙQ_li;8ZxqJ\0g1Ǎwt@*>~]~IrđMO}זe[f˙]ejEV.+wd;yynH2ƨdzB4xS~7G|w{1Bb}OXt,K,Gi7|A0ϠB<68VFR?sluD^WAņрoh6z`g.RT~{ϭqtovKm(~|фҦ2 ؜?|Z?QN;&ebr2# #-yf&NOO}j@v^?3e-- pn/c|d?;M2~?z@0 ̌גkNNЛh^gzջ-n _[ֻNЈNhuF6zM#=ɕT]jh^*5DSV_%4fDt?]FR _6/?Š,TqD@Rvtv_HAP>FlK)T06J)7ɔTa';rnEG={"W#˕:CJS>B2AAASAdٟ'99999_H+-d-d,dmoȿq_nI?aIw̻[ǽ[ǽ:_bzۜs$͆j#.{_򍏎o3&x﫯NЦ+=0sԠRԾP/&qE(os( Gχ p+￧3$>Gʛ1e U$Bt5Aۜv2cH/ۚ$-,q=bJGgIZrnQv8m#rӹ#[pT<勜Ytwd>Hcme'`tV7<>Ccm_8h zVCCxZln2 ~.3@G%< ` Ӂ'_PYD)}u#CtUɪ*;,QrFsA9ޔ+CU1sӵAk ^nԀ^A=>EzCw,L S%6g `)=3c)jÛxCݡt ]h)oFVow=%g<'6W׶k Ȋ-[Ց( i2<n͏[Q߬vh:c; >\m^@1nuV+s Pwᯣ T:4;?KA?Mb)ab o#$N@nM5zĸ#?UBW@̳ 䕕B-[шhJ?3\Dŋ m1fo`7@^T*>-w@*EyAHi4sqU?W1.-!S$R3E 2[>t"K ~!eXT*n'+sS4vLpP㉺Kwu_{i9yh kz tn~q&a,ÏIۣcQk25c8 M^㲡gIOVe܊r,0Kzxy|m&vݎ޼廆ݽK\bӐ +s,.M} \ȸRr {͑S7`נz[mo5ޖL1"9FPqfLot^H kzwne[l`>C 0]W\6+N_/'tMbsYXȻ=K43/qhr!Uz)}Օ/*hUEWP='. Qq./dlseu%a?Ս宱ٸW!D_^5#R3j/n53-n$vZ򟽘Zԩ@f+ӢS:mGu/Xx-U=/kZq_XKRh@npڎdԵudBM;^?z:xcQ.I~UH܉ҟ?]ykv7^kIʝFmzwǭV2ku[z{TP\N-mnEpJO]U*_[q lra՗TbP%?7o><{'=zT_%~b7kmNfMڬКTS[-.aJ0=&`-t|=OWl%*7t1=GSy돏nׂ=^aE]&eV>tv+V!fԙ½)g%QN?r%n)ݙ-8jxZQA$fEL^{Ku5. vm^אu2h~{$<:`(J(KtDl#vҼnfs$`ܛ Tu?!98^-w 劬sxVT&Щ('0ly]*j)b0@gԠ^f[\,F#mv\ KoPܚcznGIelFETKJR]o7Vj-'j•,]5.2nHENq4LG#TAbGbV y& ND9L, ~(HiYC%<̜.3'pᄹ,M`;-+ܿ! l1>\VR.dϏ(y(c[903|+ފ1bz}.& wǏm*]e  !ZQ>7<_H7ɂGW`h24 !y< Bq-CԐY*&bAͩ3b`}.M$_N[uLsy)R I!.aVGuw}]2+l̯rз.`t"_"oЖ~s "kh% _z6;3UD [V@> ,N1؄BtU[sp+Iuv\1kW *I8>2)5nwB T:!y֤.B&aIɒN ~Mb'h4&Q:y`Rbp#g}m9L!L R©z,cBz4NSj?{edmF}Y,wD# $)$*CwzN qkB&3cz1 Y[Z[jq}ذȖ (1Kat:1{; KBEOU#gΤwg^sYq B1mg}ޢuz]ϤOU2ѧ}G