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<;0L#$%&/q4[c=/%BdXVm%vzml  `6l?{wpCi{%t\L̴EA"Cx\ݑt3C>H1& }E];MG 8E c~ l(`CEvj^0l\ ܆ Ev䰽'~`;RjJkvZޕFl w a(|pl^2={9ZnG9` fvql: \3ES:} /d!\n^WzΘUC(VTC]8cpEJI*̞n XvĽi=;˴_=+9i`L+ͭmߌ1~[67w ]dpdZ7}c}|l[n°7Vsc$'8||T=) Uut]G/sFu(MĀ c0+2SGgcDvG5LKjm&pJT)'Α _K>bj9P]f)2a(8yXJ^NFv7zcKM7~@AsHCG~i١S(kYtb]k~06LEj:U98B #3f "fy++S& agrOr;.ށTg\uݾcoFY,(wG )0¶Qaxȶ,v}ӲlwX|/I=ҮK0= UTwHVh64q2jqd"nw'۩[Is,w@wɸ9=:K 43Iljͫ"@JH^dϹ$d)qʉ+*EMl^ei\&+WL6\&+W&GA>{i#!˜d2x'} G?  elZ8`KRSB˪ Wmi=%j7̢YPN/d)[|#0q}h`}'XaT](*(6 8h'N50G}xd$K!s>f!b- Pp R8 Nikc{N3ޅP=+#J&o:Һx]$]H_ӹR-;;{>"5rift VI~Lj`Ty-f胉AHzwT[HB ݑ6%@-j-jau%[.н] ioDvdq5aXS7{~@N^ 7n{2x0$`-bpN lIDrv5T""§N5ݳEyXfAa>/摞E<Mۘ fBPiT*A0'l {-Eoo+v]jRMeGv]BT[o{}rZMEi7VsG7Kk`o- 6ޤ"Ẅ́5$57rꜝQĿlv#ڊ9X Cn6wtEo֥Vp@ InsJHw4l/>&%+LVs ZKلF_, ҷ6sVڛ"T9RSj̠V~Y&,w[Y[ vp.gKۦzwP0\sxomcjf#$kocVn4zk)%u(Ы$9grpl: "hk5AQlAߋ %0Mʕ퀍l6 71_\-d@6 ;5*@JWU׌a`K0&(+Iʣ%-fE7𳚫έً#JX\8hIɯq-Lav8KUV4z37DGPmm n;D|m̱MniV!.%'lfh ,;FŠwjJȽ"v)G5S _s(0qFܶmeT7mb Ϸj)/ 8 lC*aJ$sM9"._񢵝ėf aa"Yy6)@3 [&,Fv)b)6J+#bD<4'苓bcہ.jGXO)‘Ŵ 9"ZsݗKϭ ~S*cU`ܯ~RKIY f`WU)RR!ͮ *u)\qѕU`K# iPfE<)|]]W _'^ oeupFUPѪ\.6#8WEZh._Tj.dwW E*09|7depJK`_Mܦ0VrV4U7Qʯ\fͯgoRU-}0/DWq7lȴr;Yv Wa7&CU2리UMY]Fݸi] V,[ފU*Xu>[м_Sʲ*-ɫ@_cCogWЪe[Q(/pުYtsL9A} E< ߆<9O똷&CSQGqVQUԵa$H*Ӛe *ziyy*5 r.n giݼs-vA_9b,z[N| `&N?:t7#  k }{j5X2jdGC6aGPw(-Kwu;Msf JYĎF7,2 黒*%$dӐN<]hH8I 3;=$o|vxޗA+gg^$GY!?{ 020dG@kAyYP]1&D\`F_Kf=i͌M H~ɗc6/7qkI*Q _kk,$'J|>I0PM h\N<( !xVV` ʗP_Ren帿D{cC Aij' $uhQφй q1kb0Ħ$nsEn :ه P|I 8bt:%?TP ׃Yl`BU2>3VpZ2k BХoٔ,?2D?-* bJ>#ct Mj1y#*Q{1v9 ӕs0gV1!C>`Dg*'~)0CW }DeSx%Na B ~TiS[Bbcm)lWJ1q+Y *uߏLK!:W:S7A>c3v@;_~̡!Yy?6j^ԃ*@<*GNk9r  PjSvZ>6yc>#3vvΙ­(@2@Y\hӠ#ÔY,Өx](QzF#{խUcIúɔa'"\ 'ogR 7؁"Q a9̜pgVV*RO F;FoH8hD1 ;NqSBc/P !A_]JP8 Zi]xon҄g$toP;y l}#'{`0q:  02k0n;y{Z;:>H{=]HT9&|Ըoȍ"n);SZژ1/GgTWKMsp0#W"`Bg5wuT0;U@ n94$Խ -}ͲҗiISm,Z6{n6H誔tLO1f"hnS3p\IYf:zVڻZ@cAzyC,jkԇCx),pr]BՕ$5X9$aEo4c`xQ[_cE'wzZ<4iɸsCkPшA˸Oy.KZfIz<SE=`VʏO~Ut^U {$]9gfڃ)`Z3 T2 tJBS`mڔR^5SZD\#Rp )Gš]c ͳp ZN2h9b0`7QH4 ‹{ Mqn-{``Pa?ĴMh%? 1UZhd`a F[*(LM)fk &]! N~ܶ q&Q=sS$Kk@T+KŌЬ sBW9yrp/f8$XflkG5Оz cx(Ӎ@y jduMUD2g,faѰ_#i!Cͅcnkk5GI'&/;ۺ*ki宛mO o %|}V"l1 '|Pur؁8,!6dWXS}Yyi`25f4t]td0Ku$twER)> .j6')8"!#G8`L&OuE1]%(~_UZD57q0s9J8|t?^3&;6z~s&2LlGȦbwN΢ӎsSYd8'09+6 )ӋcrG.頬D" ыBr!d0؁` ~@ZA LaG_ோ]rgNS@ pd0R1xш+Cjˑð_%lKay5W Щ~B^I A33E $d#BϭRjvgexh|99ō{Lv)BeB12(I̔ RB.R8"#ƌJB+/QOu7?c☕RQT) ^^s@k5G"yؾ8Hr7+.?h#tS)\zh k| wi-RArNO,pG # $OQ홆C>1)?Յ-£qZ4Tz>^r&; nfAAՉ镋o|`6KN`a=>`vWN%NPC<@@9!X*$il[Ӵ `bDTU"Ѽ>N_ӏE e}{zYT(!>f8Pt;ܢoS\WH.ien$!pПO"bD Zj0:Ƨ~/"d,wXj= OIhQma"U)%P{g&#2z9&v"#SDFge,@Ո [نd{LqWZga!I⇠PLhfyKϩ5 F{ZdRMVd4C сٜ8͌$*O#%1 L /{¨Q sz^k_GUҹFt!M/!Ȅ"05<ܳ-I|BY8H yBaЁlEk64$a+i #at'I=a滁o @HKeo9,k͵2mUWV '  hvt/||µS pP% )E^RsA f\:S[kU!#tq#:!3.]`*aӥn }V\aC fM5}ε<"ֈ>$]A 'p =0nTB_Fm+U^dYe^rLb]q͐&j}N^tdW 4W LU~!o B'$` ~'qL4. IJ' gzcP5Oa~}!?\]Lv$jQ> QW?WMwd_=&zKgHy谰ӵÜ>5[9F0pܾb(  =p?~HC&5ДH"Bb5>&$% 3-s)zeݧXS%b'=rfJf;̚a0+.Gx`_66C*AjvRZXir&UF>9V.N`zyi>YƞEv괄KLlsz}_%&m#Ķ(W. n&\dM)oa/'O{ |S3+h,Xnkh[Psabbn@PZV7<]!'6kk_WA6"&\43D=^̖EDWWFy +@ y܂1'uq'87bwŮM@&rap@40W6Ia_,J,_n 9郢Sp>n1TLp90*npn {=x-%}T3<u1KD :^߅+"$/ZM"%`)Y 8(b5{ tgi ~y+wC;ͬ0qB<1%Aixxt:WSP;hw9&瀐 ,󐙛Ɠٳ"I~>9qA-~k ELy$QhᆞTp@1D_ C:$vEcf e\LQ`% gVqK^KV^]%hfkD+]#gޗ7vԉw `r?GGziOz #/iu``PKr s24 ȲHh^7KX[C"bHD-ݫ:/jQAnq "vЉ |nH`º.uC {Ehu#3qZ 3k f|ǭW]!~dȐLt\I㚐 lH\ U# Ld\a.l~ /d[g\[MEހO>ħ듚kC^mZWu lSܩje %uꏘ)t%|೸}/ֽkXk6m3,-m1`&b0BB}k W?Q@5PF筯+ ) mvka0%B׆ODaM~'ʏhMN{*!_]3:`pt-NF_5{Mr!1WW.hSDC 8oևd\mO$B+Ë b<ϸd~5֞lhԞk] xWq %OOhD Dw!VT>ﾻ'q&xz' Qfsqab'0-0p g-gZ|Ŷ̀}(a!7FCךZUqW<])tzJ/\==c}< #Ht)SUggpd|}n筰|< !q=|Ύi춙ޓ7Pʽ߻[qvWCM}ڠk ߡJ۝OUGz^zU5o6?^/3gs-;,7؁,;r ѳ@#Cy3% ARzH̓nd?{5]e-&m&ߊ e*|_`9FdOZ󓦷u!3?567?i;`0Yܧ^Toqfu=F`K"4&]j ^yH`4YޓDU8#=s|^0s 1M&h'}w- EezCi]*PI}‹Z;Ur*N"=yUy!!Cǯ%+0􋹖@O3GԀO/X/qeʠORrYJ5O 8Ca]x×tc33k*pwU0 `_Iii'9|M,96حy0Hj B`ð=\ >:aKUR:*܇(qZ>AֵE5[Ym:6Ÿ2N^_h>Uɳ8PVD$egFv[Vpp|`ɓÍT%IHq̉[|I1 ?I>pTc eVI={ |H2Ӈ -X[ҷK뵒j՜rOR+,%S̴E,0ݤ :d9 CWbeg̿ Gǀ<*m}תnD^DD-S%H-ۛ#)?'ӷAd%fe6ZV 0,'Fb}TL)ro[ۺZEZ^4.θ?R- ; i(Y0gӪǶٟݼY -(Hfh Nqݥxw A W)|-(q4˪'$òIU.{\3Mb*8p?XKq$J!W{߁w?'LUhU<*#EFQO.ĶTãйTQz-u =ԭ248IAs]9sIS*=,}&?gqul"d-9oeРԊMj]7Tg$LyBO}g"*QBZJ 4<{=pP.!}K&ئmIaP|tu첩AT7BI7ިΒ1i|ޘ,pX aHz;$Yȴ p8I+9} N1Kl`|v+:f51oX+UKz13g*ydidIc^Z;  }LN.3=?k+y܍^!N$N!ɫY[p`2u՛Vqo>Jc<3jeLDv}zB؋S,O*N *J&,@4#IG(Ѩ՛@g\*A KWq$({c;J)Aѹx$C̢ύ͙ѽjؔS~.p*?^(K[śxJgM~AIY"͐IodJ:hӒ,"*HIƅ )Tlf>y˃Kr7vc/Cg)D4b3,yqSO8laF *la^dKbu#xd6%G#q+m;ErH *G {OM@-\$k6sWAe!!XsѺHɡ pՂL4f%"h"W,B'|NHOtc؎a1&ߞ~N{gݨG%N^fyoV`#ፐ!UT[|2Ft>xʒe*~c9Ph0$|ʨ;r#?Uh~I$P9$CՏ{$f%X="%0K /J}ܚSuK8"ˋ/JhZ1FOL6\[22hsձ%W=V{Ԭ.l83 ֻKcDň[sP}RUO-5X s8 bTz UC-Bϓ>h>g) &* /K 3 uR"IŒӽIJ4I"pϡ⽜#Wx3?{ ԥ]0j'$veת#"q^>%;f7E+cQ{D7|enfER'F@;V }LԪ)TBjd(rC39~%Gw&fuЭ;ݺXn钮oK?{t乤Q: i+ y!iq̡'Gd#6T0vL{ hmHnNB}B|Ysc'V#ԞٻSitP| QR7wr/ܖ}%,=Y`,р#ҀvM}ڡ&[n_3Gї:$ofU;Gp8;T;T'STXgbC >zwz/7WqԷޒ:厼HBBިdJ_\$ytUHI^ɸtN.֤)GM%:#a+ Q) =*,hj(]񜌦Y7Ia)^ޤ^ x K?vW-w%|sj&9R+\ӿklaOOiN.qLAnZ2ϱǠE vF~qiĉqU;O[ MA/4P'mJ7HTںN_(S-?>QV qk y1}. Gv)|Ŕ6Wi9yHL{Su=|OI&.߿:]er~{1n-ubm$w ?J@ L42)5TFpDa^дR{ނ_ۃ1=eVv S*ł/y-џ5;;b ì /7IXz4+ ikSz"9 c&LQ\{~p,*>gHWrM[1z0f,[=9LXTz6woo>|Go-yg"vy#{Jʵ;>#Hm.uf+; Cszxo0t3[[~7G 7I$kmn۷yݯ} QK̼w7$i,=l7 R;ѭx /#aOuۧ[N1"ȹЛ-2%vs\f{BO'mB(77*ӷv7w6vs YީV9*ʋY%7+s*ޛͯb/ICZMx}q=/‘W>`()Djrk?O|fK{XZlO_kyg7P=+,S,yúA+Ks$Žg~}LqUTq~Eyc~} b0 ]SVeG] O+N~#׷yg 6m*͵kA c盙{X.}<SIue 6ҘE$;d0oWuy~MLvyxLioĬXyo2ȿJܠ0YgM74 (40 JT][!Z @d9 4Qh w s< DL݁'VsIL!ЀNG95iܘ*b 4$9۱TCvF-0(2V9+xL*0#eʱ.5v W`9W"e1 LXSZ?G:R&AjGY샾(y«3'[ o:Y { e|֏~2H#sr)^ܑ-mYM4s)C@ش3 ?HV.e׋y"c|ypV}',\QQOkz]>Α29n @Н|*/)t"I&=Vd0pA+8zɐ{< ޽SHyh":΢ W91{tzl jΜ 4jib :ElFQ;ah+ɕ.ﲐ~G];b5vidLXRg) fdN1@,e|#wZ@jڬްQ D=4a4=@}m-ai ?qN_Ykkux/ f#GeegT~y)̀v$N ^dÚ^6sD78 E!w+ΌWU/Ͻ¾A[}÷WWʵ؅u%PQXׯ@Ύ,&w=1!P@<{{ˇ ֛dH `>gqYeV/HĴaGkqc^.jMz03m+p2+5MK0 O`೓N-A5Nd7=ǒ{0佉dRț,PHOYu^@ܮ {,W?O7ABJ0ns{jdQLe͍Ծioކ{T@x/b)0%S~Glmo흪h:Ԃa=~<kn{c 6뒚{9}+0QB'%س쁍S|2^%,>tuǘ\I=