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[ _6i$mxDHbB*I?3uI]M`xx'}s(M{ZĔNDfw"KM d)ڕtϚ1S>u"Y^<;shj1^ȱ\5Y.3u:')`)L4aV&Wyȉ\(t,OzGvtF}  @  3t=x-28l;vGnҊݙu:3ky} &lWgHߵ,Mw9'.NYl <+fGs`5Ȋ߫aw>s! I5bmgE8Xum P5!?-) $zِR^P-#c{{>C͵Uqkt\}x _* i;uJN۷^&yTVE~0"F6*.fD,TqX:40L +Gb"+_HPdH^ţBgDhz>?W`~z܆ڽ5"؀>3 "Ow?RU1~бu{Y,( )0f0agc-v `C*veҝ](ODR=;9fs8N\f|@Ɲt%!_2hf6F~@:焆P&zɅMY*4U KFhعG/3[ eL֔t9!snZkeeI^iܤRL۲b+VO[2TJ ٥$DD\IBYJ@6;rI^Zȹ [UYr+ [Uu&w +VAlAVl iAV~ hZa-1vEBjBa\cgXRTвU{g颚ub Aӥf2(Mϫdy6 mB@[IҸWj``Ffam5PuQ-iX[^;ՔoKN(aUJ0c6"֒ON0;xPNcL3(С`VpZmc*IĻMҠfWld 42mhA;C=P kq&h4Ko2ñ4["T9p?mĆF^e3Қ 8I7UM BmRi] L }S6 $LAQ]_\5z &H<RkEer]"h3(6 ڠy &UqJkff@i&Zk D XHKK@JWUϊ`KБ(+I^Kی͡%FW^R4 ieeW/"v8hI񯪒q-LWaNLUZ4zۙ1/DGP5ZЉo+pX  u`i bO{URTHqRbҾmTct`i>c[ak@8\+ʧ*ĥyBΖ*`&<&]ey׺QbлHe9q^5S no{aX8#>mETmbϗj)T/ӎ^ 8 ;C*`J$|]ȦZuxN_KCKiNXVl4xa )C ]X M( dx\1F+(RE*UWwB׀8}qRcktǃZ()$Q82vcIˢ\e3kCIbou"QE>|] K1.%3=^R*EJr:ulT*e 9C%b|w;t[# l'/[JKp--ߪ *ZVC1%B1bU#"`X$V{SR+ƻn)Mc_@|N%[ˇϩdɒϩsj,+Z}VQߕ7\=4o">i[Kϯj셹̾|w ˺[ B떲o!nQɲϯp{vn#nU7Yj7Un2UM(7z.wmaɲgMU GMjZVeW=$y%gвeϢc=P\jѭ3^Ũ֍A\2 1YդhJȯX~V=yT%umZb$%iͲÌŵ2ziyyk@HJyŽU; [o9䔱h܂9Աpkŗ52H=g|Q;zkF Lf\x<[a;+Rsz-DoHx4Fg[*G -9TE@tКޓT)&]aysw1q<I0f*2u׺uE\߲xx X3%p9o>N[&CE,N ij{C5|=Te\\zLzÐ`T T/ BGhc'^ZD-b]hєy#+M/CN3vBe1,Ͽp)6bq`zuUMkqE>"7= t]k0[=*SZn'.ok4(Z݇NMٲSF[V𰁀SV0 E=KSs h&)$L؋Hkm'?r]Ym`׋e1J~uG;c[VAӬ cD3ݜS\!"G*|r;Z;9<$N}ׯpa#RƦL3S ZwL n>TfSg Tɪq̸aaӲXO ԏՃJf.؇9* @(:``N9##r )!|艱ՆFaz ׍3㝝1! 4Ê0"+3i qҬd WaMxJBV@+2(ONKxsP>8\n,ġ&$@ı\90pǕ?[O=]HT5&|ĸɵ"8 > Rv4OhnƔy:2t\h#!}%2_YwLU殮 rfg^Y sO`KhLKk-^ .1Hb(fji?8ީ: "U ұ`c&O䷠E*$- 㞋HC\K=sI?F$ecIq,AG=J}2ǛZ-rدm),CVf}?ϼI4{{U(<򏏫&>( 9:<1א}T~4 e'C-MCCՂqn-`lAP?Ĵ; pɟ R*-4C2wzX; &x35ȅY6O-:B -, mLjC<0zh+24 Cp=7eed+R[f8,TޘGq~a̬Cm%sn;~W~ Zo9I-mQ,(yf]r]\nBEh Ϛ9#Yynb21f4"2lcp0DC&G1]$x%YT(qUHyT+a8*9S)1N/rg;z9>Nk̺ ;8c~D}t^ arZ0$oS3@0Br ߕO'PH%H!QYN%I( ; :eȔ_d m]/%@:;F|L6 \`;a %'T 9'娺oA4"Zr$,cV:zM;+grqfgB+Stl&Oh+ɛ0C1>3H/PDXAs;;!E{8OA)ށ;xOL2EH/|3%C,}Vr7Qh0`<9sYB3!GOA%ĤD:YM2ދaq-F He1VpBx`|P Iˇ]̆K*kf.a*b+.3f<6*/"Q}dU]oESG+63K,PğP|w"!_Ma]me] y <640&Ō_azzA숀1Tx,HQpk$tdMKS+>0(K1CQ1̎ aI-3\@ mƭfg&a245f-ͷ?Z#-|Ӄ*S0 84RA:OafJ߁_Ue 0nYfYU5X`sE id|ՠG`m(rV( *qE1xFKMˍWWUfʙ2TOOi#eO"3JB!+QOt7`R߻2Txq|/Xwp}U2HbG('DطqDHr;7+.?h#xi8&RJ=p;Мvkl wO[ @F%<>f+o^=K8MsTÈ!OQyỬ%qZ4쑍T}8<Mv;>@Q> c+x5KN`a "STD@΄ (0`nʸr7Rԭi%`bDTV"Ѫ>ߒ<3>a^}qqnW{[װKZ /^i E^nC?>^Th8$R0[VI1>M#$x&pͿ0%Ӭxa-L&烪B҃PUQxLEX|M+L \hM)GC uwj2x/>-8&0 MEF%TZѧe4@ [٦ڤ{L@Z a!Q쇠Pi)4q :ƥdcsbM%,fN$bc?2MD#2At`6:ߵOK=ɁJ0bG9by $Ȟ00GDdD#=+q7Qz4Fp.dl{=&bJdB~uEJy;TWT|BY;Ԉ yf3` 6E+I7$a+I@8OgxXl 0M%|P~r@ZdX\+Quj~e8cxe0 ~a@%5&\+<E@H]\%~X b{au 7Rԙ—[%1N]p ԸHw%p_NNZ-ۗrPG4Z&ǭIsd!FMAN.A*|8.VU-"ȲJ =y>_N/5Cd. :yoܗ_%,\%3WIF 3I Ց~qL4.5NNUz%Ljg+Xdc1@2E-^A6%?I_}xE=Uk%vm^I@U&J8<tۿaFdV X!T8n_D zUxFI ?$P:q 4%∐ }͡@=RK\^p`ev)6~M8zOava6g]`ga`0l^+ȫCi8AHHF[1ƺm|,Vn-\eL/R='ܷ3JKX^>09VD^l6Q@l)K{= oD֔FKBZFt8 5~Naz"qi ˬ=ub -R2 j"ZVl jԣG+؆u`g5F܁Cc' ͌<*/gވr^|L (a(|!@ې2c٤{ϻhb8bĮM@"p@t`mvn0O=tbWepmʹO;pb#`+綰/W,\!=w6*špج.}p|i;𴌁]U^& >ppYD28RCZ?|/Z!~D0A< \ũ_O`eבp1FgrNt()U&Hƀ(H=jlx.IpTa颂Q X Z7N)P&wxqs]0:(It/-ƨSR\0[]엊t(OȁqwfeʇXvBa➆&ݥ}l#ľ4<l;߉fVظgd!/o٠QvֈD9'"[HӃ'T$0Ca]! "JgZ 3k f|ǫW!~d8 Qɦ \%<+B&dA rI(TggDu !#r{p- dmy)7'r_7ZuEnɅPyBi/^}'y~b.'BZ j# Ȯ|uI5q@W@^dPޞ\ۓGq8+J7býsQ0?+`.mhViY /"p?~To$*$ #BܗJSQҾZ'q&xzG Q6b:Į'0m0NM ь?[iH>@ni|+/ٔY|J7\=X=s>FLRNyt_oet_H</en[v^Aeʕ{4[ű׷hznбPR^O#?#XiچUƈ䬉~khgt0OXOgPk3, y'Lw vfs Ko_ټvjphX3zCۉ~z gnBwO7  0K°!~J׷٢wL?RGӵ?CY0U&wsVX0f@};L* cB~0||S;.._jNKϘVZd P3MoݐYc+p>Z_! d{F|Uk<a bADH"R(][SM#(" ixl TI/9WKgf)e 櫯%SϡKXӬʮJ{RJBx+ԪG[7"% 7h +ڦyBvi2WF=tkt b-'O=@WɟKkpK'b.۔AO)[J>O18}N.vŷϻnU狙ef?/[<+7r*l>\C09۪IH4}E![ t7r : `C&v}@OUT:J]T@U0,6@ HU-snIhuhגd! xC8#XI'; r|-g,;q31GfiiޣOO[3DCK̈[Ȓ_=J!܁xI=sŗR1uKiݧG܋"\UML.͞6W7.!-YJi-Υ&]"́6/4]B+-ğ̱kA>?EUnv-VHD"Uϥi7)?HrF[cl̺Qz D>L$[}#a7 |"KHehʔR4hz8ZEZ^zh~Ysi(³0clß1?zS?i5-(H+op7 D : Dl~c`xӋw[+xfC†s#"0_챳L>Y6kMpŏ%vNIf9g)ZI'gR ;|RǬ~XhPu1WBe<c\p6!&;~j:<,޿~#=~V*Tմ|6Qc[=O)b+p݅cP** UgFuQ 7.xcn*+yX[Ej@$ X#r%"_{Qqc &Z1 S@S-4@AءD7w3ΰaZT'R8xU˕`B+%s`YZ]%Adxѵ CivЕ b[\5 n>mVHc!mYdfo*#Y?dȜ;v+?ˢhٺDy,YA+ڨeg+;^PzHAуrXe6_{dp[TJ ?  _}rBg kyQTjy`" hM usa c{ᏦE! @~xˏ4Qf(5|]ڔO g6s0^͢UYee xQsq).ǣktXIv3= Rя|['Y4]k@ PGtv&l4 ]iwϻ-g<(p ZᥝB;eix\ۮJqY\)@yuJ>RhPjy& 57Tw'WkU?- DTQBZoD!8vpfOc lSױ%xb0ﱝyBu*7BȟV2KP 9zc~*aR!ZB=HInRɻ\ߊ 0fR]k=oXSjʦKwJyd [B+2x'wwmcdF9)HK 2=ΥyOVt\񌗖f?w3 }+/3ͬp$1SFk搴'V}kٯ(?ʌL:d]f/Jڸʀ Pht/g@HJںK Ǜӭ")M_PQc6"#iA/rW@H3.g5uafwi1ăc+ ٥z(֩Z.q<P(Ty KpK"Fm#< Υ&;7RٞM H&j)X>ζʌ,t0oﮑDMhRD4Fi: av]oYnۍNw87[Vk[&fO[i]tf7ngla 4V}AlƟs?MT4eTH.KTZOߍCɻ+b9 Rw/a7K*n@BĭE:mq0xmE%ۼ2TQ.T´2A=ō)·RPZ-hQnʔS6Md芄99bMXr뙳d YDX#:zzP-xi"ѷ҈s,Sm'k?^Q Il^&$%~NwȫJ*/aEHKR& !|$PċEdm#KQ14VF 0ǹad{[eD O{+y|/ݟۅڢQoۅ_^y{nЉ1k^C{~¨⟊H?f~wz̖|$ϫx5;r\ G˫/j>ɼ5|p aJcT 7HѸv5#*޷[窳ilqa+}r%yOi uG}i!_$ Ópj'*eslq~7sZniS% QFMڃψ7ڲ,E,\( LeΒ̼ID4*`sӎ p"s{iSdpBhܧE9emyYS,c,}zw'|za"Yδ}djGzMnk}sSVےڒP(?Mx)!*a@V0 LWkNNЛvhNիw[#I nZG:Vl-lSM :ޓ\Iե6B4E*oMZXBooHDj$.!uIm`nBo# ^ "@A$u`Gg7|D3kĆ$3/"q,y\D fC./'R_n=;qKÀc闙e4y Q]mkmF]SaLVZӕZӂ 5ZuwfThT5f~74TQM Eu=6Y봁NCw MoCՌ^5HՌnCiChvkw:T16iC% $Tmh u4[O v4@9 AOz[ˢgZ_*IH&Yp<:c,ٶ/(V^-PV>9a#D5rqB-r. zZOoH7[ (*@5^0m (:ˁDk{M,c_TZJ;i4o:P 7BQPQA-z˂bMB܌1Bt@ZhV%:jw%;n򲭷O: o ^ kAThiB^%6= 6k 56`{Z9)m@O; = N2ݵt pd(EozZzȭ#Zx pD36/* V[oh°0Z')g{2Q{K7V=U07!a!ŇlWv1,Q9- dCZjǰ 3+H^o{:Hki kiE믿ʌk42FNci,_*\ok wۚA 5I7$(A>mCRWuuYFKku(A  ou (,:Vr:ExnrhvTP2i m5 <A(9I 6hz7{] at@뵠 J ҵ] ԶQw׶1-Жz+7omMԟX`Mp^z؆v:8裮xAQhT> b:]#yn1Lxk0E >Xqx@c} 81j9QhZЁ~=ttd*Ԇۄ4 v_ AMtwꂲ蔁O0:IPэ3jVA4lvF[Ͽ˵RX"f~P_V9KYZ8Al#2n"$!(u.3fmn,o 1w| n'K^Mۻ VPd[(2@K9̟*"D$`aH hU z(`Z4Y@6Niy9mS js $o}R*n`I+m$Rn$K7%IN 8J 5?O{X4G+au,\M8zthf׮x-8fy ZS1b~8bfGa3Zz/<&mDcߏ_1s[,Af@3v\~ZLIZTX*xje%VfE/D`6.<h/o woׂ=^aE]&eV/?z-YSz LE9tȱtgʶiG15z]"-f׸ؕYx@֕8~R˸U%m`OH(KtDl#tҼnfs$`7ܛ To?!98 @/p{˕ֲ*B6b7{Lvc-Qiha8 z (F ('B+ox ߷܁+i[y@R@qqtId &~$PzM1orqXqMIo.]gCskN %Qj=Q-Q(aJJ!wþ|Zh Ww1ָ˸"E):ŵTr35J}^*@ 1#d1}+Q <^'DŜG&?$Gv!b RfF Nsp\!OcrRE0br_l N_`6ME_}+_+G<1r-^ goŘn1>w[;ÇW3 A~g~H( hƌSdAkEf0 xbpɐ{FJ|E/AR'-݈:m9<\i* X0fhK-md<$ŘLT0Hg8\u}UDˋfê5GXU!j~a;;ɉ@8 {g@pjm/0*WfTNGSGe%=cfB;hia1:{]흨{_8 D !k+>oW_ȚzuE/MU*FVk>G|BC=6!P]U&\R{)h,fڕ .C跊exAN,& nJ DrmPrp=v#5ˬIXR_Ӵ)x d6>.IN-A5-ș(G_Yl1lcyjƅ0!a@p꟝X'ӔZOo_+Y.t_oI (Ъ^5zmC\ɌlXj4H>Qu}\6?J/"6@~ҟ2F~F;eÒFeoș932ݙW%5)bl1kt`/Qr|;8E_髷h-~!gRO*_?=JG