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_H8w{P4 lƀ/!5̱eem+%k[w7~_Gw/_ɵ)3Ox S"l;a% VȔ?>׶4ݳ&̔Ov6H1;6;uLUr<'r,W LE k:.q,rBC#̚:>'F,]LϬuV^= YH) ߓ3f;(EUׇU:,\ϓFٱG#͊#_ ,p<,g u-9*Tˬx8^ mh4璱 ~ U?]Es~X~ti)Tx ]?i57'_ӂQk4jCm6[̏=[s,VPAeDn`yVQh?ضA,{͍`XB\9[s9m hUc3ʶ/,Ќ-c)`DPoX[KۀU@HFiC&@YR An3kl7\w.CD:p"h8|r!tNe5!1 )6r8Fu0ޢrB lZ ^r SHfpah"nPoi `7b-%_4.DۢoYf_aY̻m=CX[e7ؠ;v w[wZPlZMߊ Aɭ涅Ѷ6 =dplٷjlwoZ '% {+i6Z[-ͭ0v>QiIIhFgzޛ 4GFiB$lYA\O]M80MH8pRO‘ 7G }H@^f(..Oa9nx;NDgc'bZ8g5}L42| f %S׺b֩ јuA,'9#gT Mݡε0hY."zih,<5] $LBHtG;Ԙ匒u_kn7p6q,@*1CJ̇ u5|A= ];vlyeێ7,S?tHZ}ҮG0} UTwIVh64q2jqd{"n'۩WIs,wAȸ9=Km$6UGv`2k4٘F- n]72@i](qD0PG˧ sӊ]s+K*+妕bڊ[u.B~Z=O] 2RϮ$ W$s. Yf%zJ\rz)Js&WY7ʕޘU]dod(g/b2 `y$d\B&hZay0^CgL*!5$ r@ |P\ρ!h,崩鹒\QIg(!F{ z!VA A>w)=,9Hc'0z'_ @1i''JpثpJ f`G ?@>WGYkM4r5di]c\([VWjlɉ!Ad!UCN3SrHc2r>Q+k)idAVWj[ ZZ+%@Mj.jbu%mԷm`Wڮ]]Y\j$p[֠L'`S 3#mmV`Hl ɪď 74t5Tƚ""§N5ٷEyXfAb1,摞E< ۘ fBPiT*A0'lj7fsSccC2 H78߇ *qPFZ}Cm6TXZ{? sxk͍&fD4܈^Y4֜֓TY('9;URſl;mXV] Cēn6w ho+R38 $ m9Wt12ﶁ4 *hoK z @ :9 MxmdX ,cǶހRK \A8B[a4&no,0Y[8IUM%BmSY[(@.q;Ʋ6 $MFh.e$pzo36^.ZN,(R;NfcfY=O0[ؤ\I dH@: @b,|}cD zs&- 5ͳ8` J(&mƦВ&FFt{^iLέُ#JX\kq4䗢@\ yR.;M%v& Ԛ0@>0`0l.sKx}߾PKIxR'%YHyqx"?TQ Tct`i1c[wa ƎkA8\sg*ĥ-MiB9u\aлLe5qd^Vʚ770 ,wm[mXZ+,e6sGcqbH%L⒄o0KٴC./ZJ|ihv휦/lS$1 0a1KKiEU\b+hRJ85BETМd/NyhMxPb=$ Gx1MtYaԚ\znm(M,EHTS~]sr\Jg0{pnJ†iv]8UQr!QvVDW.V/`+pARwuE\)|jx5e[UAEj(7V^*6o\lGdqEZh.7E[*5oHy |/4 $]*YY>ܥR.W%w.I|ÊWFw2Cyugּ<{Vrwj텹̿|w ˺[ _A늲o!nQd+\]ݦȮ[ՍdmYFMY]Fݺi] V,[މU*Xu>[м7ieY_Uwth2Xi8T,u&˜ߠ"ąoniu;Ubyz*ZZ$iͲ`FZgy `-R |x^nގ/3=-wϦ nC , wɋ$03ۍͭvYcQLn76667%Xj>Q.M^Bxðm6f(6 )nk(XְMM#gfKgN4~}/a!nlKgWMC:>ua0D]Ҵ pd[|s4E5 *ptP]Teu!w e'9 }KR" Tby΄ټ4I;2o 0:x#??͎'l>^;Qpq3MQ! cN]ՔkEE?qBVy q{ȫ]^h){<tGc _h0 6@ iȪcX\בTG`ZhwT\]|S:y7ɻbKA$aΩk fy*˭%jM_F UG{JMGG:CDl) #-x@&)+gEO"О8bڔB0-K3eP)x@?u[yo Ju!ֈsޖ'4k֚FT;,.11X]ExK~5wr"xEzwo0z ӑ)CS~&#@aRT_0s'o%oe:aߘݤ|IZjq,/^F>SvX7yJ,3)xVB^V=>$:'J$ H&PTV/ji'E*~z<SU,: (K*Kq{hco_`>(Z툘dvֳ-:7۹!42q}ML:N}in>dTd< P|]$\1D: _x*Q|,0*qJ/ 8W"ȭt)*ivR}Ty$G~<􂘒g$[<,o@_P =&j ^ BcKTYM8ޙrQ_| M%-sd5LD$x(Y{u~ 5UNAʨ= ܇.' #L(cwL$*/f?pꂨ} z=Tz $_G%+R" \U$kkOxR`_w VT&Bt0)_G saO_M~ˬ!Yy76jtD3 Gڻu>h@-yupMU`ή)SuT0[){4b-2 Ep%j= p z Y54]0lZ~@q@$[+Bлsvy)p( v+sYO}f5՞/^dc|CE#M`f0uxm-}L ͝A-P$}us&+ApX4kBGNJ>t6+4 H0ފh>t 2ʓ ;z oWM|e0t\ڄH˵s7=o)H{=]HT5eE>kjHOMSZژ)3REl! |cEcppk/(w]]5T 藴-&(`KhLKk-^ޓ .!Hb(f88ީ: "R ұ`C?؛Ej$-㺋Hc\K=sio#1v>śjAP`qRV}u 9WW>Pcu 7=}]#X7AMhGd\C~5l e'>>_%^-%y=V)ʢCg{0'?+:SNihXs.Bس]*ugW`J|*km%!)6QEmJ)iϧ5SZ L]I)J9fE®qz(^=4+oWVP}oʟSQU膝3OZ+v|gW~c-za Y=IB7W,-` !Pƾ3՗&(ScF[@nWV- TgEY.TJ{ 2Ax#";C;d0<"5H5"'JS4qTs5Z 7b>Nrg;z9>k9̆+t9)<dSDG'q=۱,2ݣhELXp^sGH]tكZ<#W PVb"Gg!zL2@Q H SLL0/FRsL}9 3/c@ pd0R1x#elhD![Ur$,0>u~V%d0<ښLІW7a#8`b}f^L|@RB蹵KԐW͎ul̠/Gq.EL(FQ L nej!& F9 X~'g.Oh.0员ZGtfDw-TR ;xD @P) ^ \LBWMI.!\UD);V]fxqkhj3E%FrBɓ Dr,pvc`C.03AW[DtY.dB依'FWUj,c`?n(ʥSCĊz#PZӁ@#YGq,:`ґu7/?Nob^Sv:`q3cBÊZf` ӣ$f&a245f-zOoC j lMnZDh}]0etXuvO3/ጀw.@׊, ,_0yE i|jP̓cn0Ζ9+yqJ\QbH%Rr|9zաQ`Kq,ۋ<V3* D>+VJC8~Qx{IIp>u\5$Ferkc$r+ｷ(+7+.;{ŴPQgx9YFK$L&xuKT{cĐOg/pTExw_4NfB:H =st4xEMw;0 NL\|S R/9]a 寜J*&z?pFCyqJp nW[zk %уK @ځ$CW`ׁ?bp2'ᓵHX!8>Z2Li!ȯ0k)n% kaꝅ4y?hF/xG1bN4" A*=њRHX uwvj2xѫ|4#A"&ReD5 ]V#K/lUf"j1Y0=keXGBov1rᏉϩ5 F{ZdRKVd4C сٜ8͌$*O#%1 L ϱ{¨Q sz^wk7h* WG]ҹ]H{y@%23?"s %<[j`RSzKW j$Y8nHźHNWT;X[!L/'mdw>H:J%,H]bzg [)ʮKL8F mQ67ei\D׽MVȚZH{)^H/AԗR43+h,Xnkh[PTabbn@PZV 7=]!'6kk_WA6"&\43^"Iy/fu{|ls" <<QnCʄz{Qqy|1{bD٦Bv ^[{S_y0Jm :s0W6;a_,J,_9郢Sp>n1T,p90*nqn {=x-%cT<u1KD lE}V/Lf-&rm_zkx 53`By7Yd#kud5QhcXo,]nى%E*2ф{@WX'Se :F|I9ʈd\/`ݯh8@<~ wxqS VuY|cT쌩(Y/KM~a}_pwfmʇEn;0sqOCa>Svb_/Ox[}%N"w$b41Yȳg|6h0}Y5"n@ q@z՞c'MJajr Q >i<},`8y RJn#ŀ>$ !+j 5k(bc/%%^8[_jU,3+]cZq:N[Ŀ\fK!w??"ЧH{]t׻/ox \T>Ω08( ܪi9p:'`pQ?,*Wy~ǐ1(%{UPGEL$H]D,H߰f( >Z/W)1[^DC~2_~WLHx~Irɷb٥ 0@kݽ1hD|tmNK:V|o6?- 2ć,S?RTZ>A*zBU,6jcbd䬯 q4rrxnuw}lUz,e'4Ơ;{'vsal4;{ӧfgtG/UI_8-~kbnn/_J_B`%*g~??c$Y -X[os/JAªDTsBQL[\M 'U,ڜp}iSrM{v_vcs>*u}תnE^DD+S%H+͍?VseO_Ĭ5f٨FD>L$[{jHД)E.^Um4PH+׋%^ڷaq8 %slZqy977/q\ cЉ~)fgxwi8=w A W)|-(Yq4˚'$vNINy] UejZV>GBWQ3rDnAE0< ƿdEj[렴5YpOy\2u[]r%""ߐ{\)P+GC=c@4h,O 0ǭtRm$B#چ\&(U]#-zP, jMuP r+}uޜ76H$^mIi'^27j+\,f|12W tpgVZ&hx<-% fXK5,"Ld.9wVU+&o@]QQׄHT+?TP"? ]8ΫqL -,CG ^NcBny6\}! @k^ޟX(]QMZli8DV)o7,ZB;_Vؖ%::7G1o]I6/= R (|& Y4O-V@ PGtvg4 Tn-Mdz9h>8 -A#M*40`$WgRx3W̦.2yJPQbV J$排tT Q yUt%jJG?q;G S)YYG:*d4O%: F֪ԩ3:-Iϲq.|8 HH2.`HJd[l- /ɩء뮳B )S*12ifYNpŒ UüjA[||jD"K !M}pD1r noh|W$wEsJ_7oS;+u ;ɚ͜U|YoȵA<Ä \.Rr(š(\ 2jhkMZ' |<6x(wyAlRl(\9ÌZMKNbo<xgܛC3bжYBY m:|>u>xʕec9hh90$|hi3 J|PRHrX< 4N8P,ZwAV`K-A,=Zܡ5aE"1poɜM8Q'\Ɣ[[eN١`C42AݙDPa;w&e$Rth$I{5?.W!ɇţE)gX0vs,]%RIO$Y 3v_5wGR" "p9%V̓E? PPVŸ4fع# \+KHz*~jrqztV]WI RM v+zY46URq3E`.cLܽH{\)fZ[ \qa`yޅd]2VΘK;VGjw`%0JF;q05Ny?SU5Ѯ OX{9O%R[(}|a3M#T1V+{o_JYL{Yl%sXJ'Dڵӹvtky65ftVkc45-NLW8ZѮ2OFz0Sf'l뻖]eMisCzLbl&R0Q.@,dϐ6㝤_xQ|J} N̈ZB  gExx!ihlEǖ{a+I?K/"ffzW׵'j5q-k삐AӓF@csn4`7qAW/8k ߭hS̔!ڃZ8Ru-YA(M̉\2ru|Ҹz =舎G⮍σ3)0aEWI.p{KOIE3ޟ[mK)r%]s[W6%+c|m>77TItZ 0і0.@ \T0;|%lDɟN}SД{JHRر/<3p~ dM\]NAQ*\Y zq'E'^M0O>0~ f6HN“ÄJ9)"09Uof3©8M7mooޡ K=C`AXo7Tرt *)(י9vq .{߷[[?]9;K6~ǛM}MavS1?ދۛ&Vmn״h'HJW\\$Qv|s$no6V̛|hor΍FsPq5s[J-QƞtAK6 [l0 gC:Y*D>H\_/L&8FILXTgȻ/)!98ZhyTuN#5z~Q>l?q|dDzJFw ,f* ռ47)bЂy\أO+%Ѭ:Tpn5ope5$VuoXzY>d11Wq[= 1.)?w(X 6.W,Fѩ[-?١Fyl;7ܤwI풽O/bX_:pr=#-+BHvd_]fojoY6 >^o*n_7jk=ñ̺Me}7Wo^ll46qֆllYA zp!v/]-jaܡĢYKoT 7օ ,rrHqEA|JR QvxKD׬nսgH]#<\* -X9eʥ̍ʥt X0_y35Fʽjm6_& v[X"]eMv;ubƞ:76pS[=GX8p=~TPY8j kn4jH̋d]!πWפg&n eeܼs'W-TWTaiStU (r|^ʞ!P1H#[9[N/OxxpEyG>}ڭ||#/dr[G ? ;O򱼤Zq,({| aVp 3d)ݯ(CnC'NwOqqTN89 >3g.q%NK)b6Y0sǝ$?&u޽,ߕxƉzq]Y#٧.Y./SUU|+{mmw(fgįE*34tøިf(?h_v&ÏG!v+ΌWt  m9Ǥ"=S ljF* kr>pv?˻B~&\hxcw 1prf90iepS $j c{6E0EK]fL’%`~]`4&Q:y`Zb3uQΝI<.Xށq!LH,P K=Y$ _Q?+ʹ UUFc53\gEv6-?{т濾#:Fcss#긷_<M0%hkn{4r&xSTmՙ*{5v` N_5Jo;C;P8}VdVCNýnC!0f