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[ _nnKĄ"Ukf)갓vq pWPF3w/w_ɵ)3O}VDfw"KM d)DIg͘):l,|/b9v45mvꌘJ/xNX,:aq0ה?v\&KӀMyE_MfثPD. ųOvuF} @  3t=x%28l+vGn҆ݙu:3ky} &lWgߵ,Mw9'.NYl <+FGs`5Ȋ߫aw>s! I5bm'EXum P5w!?-) $zِRo_1=!*8|M5z:XI~h\[ѴF* )CJ:̇ azY6s˶oX~J]ـt'a *@ק%2ʨ-lhbDN=N 7Y8>*q'r8]I{tȗMaj9$ԟdy_5) X*Aw);W2ef ? .g3|M+v,+0Ti[VLceՙsI]T\ρ1h,Z)y5,72!QhW" Cw A 8],°.b= kkB p|] %JB)1}FZ b'q<JRii:x=:? X˴mG;hvͤ= DIh4tnf'TcNN "3 )#rZ..2 `D-%}6RX P}Qkn2X d`uƆ۵Z^MoDjB{dqaXn Q@N^fn1apmux0$`63X9a/ 7oihV5Pƚ ""§5ڣak9pYÔ$]f:YhY?tVlc*X A%QA0Vڊ(ѩJ(EoIͪک"{ӊ<\S9F zR}]1]Eo7^2ck FZJJ2eP7){-bPo++/$ُpXVP~C>e4͚f-#*_y0,.3|<;AV>ɉhDV8mjʏ_xąs H2L=& 3YPyg03eJ'fM4_L# fޭ+4i#%__ `"DS'>yg_i(HO JXθٹh'|3_N2`"$4+WFGǕb#:m2RVǾ|>U]is0U+Gu -w\:НJf%OJhUp=]qүHxUD% J¤Z%cE| |_%=R o !(J1씳l̍V27ĞƁ__  }iN>h4ʩ"Qw:yMt $ b=P$SA-^#~ T3#3iE !򬪰rK]L]|{fɑMi HvzAL3-G7b Og`8EhOm!?/cSTZM8^r^_pf>VԖY ""bG " },p"^LWN-$i<e̵ 1İL分_-̐¹ v!<{:!D?*a)-!RULKR_бI'U̼kN.XPcT&eLBt0U4| >fck vε?6#5"YC GAmUj)ZUT(?zW^qn PjCv\~mg@of쪜2[Q"@e KwJ*:EZzzӇ* pꌁY*Y57l]0lZv 8a nzPC0]9zJ S0>- ًW[mHhD p8(:IBs?xP C(9 y8 JqU;xk^܄$to X(=7E_fRj~L:{.hmN$L˕s# 7<@z B"1.W5&}MMIyB ,t;6DUUEld! a+ŠW~bB5wuUW\0;wJ xP[Dc^^l>uAE=4SKN JX co7yD$-R!mi \<@w_`ZKq?")~xa% =<!v`u4P <ޔ 6o~uhKIue7> xM۫bEG|\<4AYɸ'֠ws^}~=Y2[C0EYΙ@{:&? KaX _E>49zyN3.lg|>ةvuXq*k:m%&! mڔP +!fT.0uFD'%*AS X' 3vt#gb{ܽEibZP3έ%y-T~w4V20CA Z\fHBkUĔoFf?V2Gg^Z w%D؂,ĂI@i3e,-` !+Qƾ3&(cFãW~_V, gEi.DJ{ 2Ax#";C;da2x.Eb.G]jEՁ(~^U$G2&q0s9R-wF#篜ԼVȬ+I8a]ac?VItwzqkhb3E 'ON> jgGj.ˤZȓo籡U4A(f K0׫K bGrK'gFOX#Yu#86n^:,rw_0)ļA`tp\ʈ)/Hĝ/Eavo` KhNh%NO5n50;0 a4۴8n?n ?iiݴޞa š b9px 0Sxg/* \q`Ȳ0˪"3/PH#[ <:slCBnP+JZjZ]n-_!,5D<|>-&a[Ǹ L|NI0^Ă%̉^lǶ"]V&hV&t^i'90T xY(P,y>adF&—|lH|g%r3Jƨpu}.܅-]a{wGҤZPL(H]C a30O}ǖ ʜ^( b畂! \S6} 濥q%;fؔ~V08 ,y%#H' r滉o @HK rYښke8.Wͯ'c Ϣ / hv\لk KROkA MX!͸ueFleVIS >F">7`2¹)?4 cUSJ1pcsŦگ'^10 W3  8ky|>:<XT{+X㲍-^2C9>:WDZd6ٝwcFUi +BfV?'ȋM8F mQ67eio\D׃MVȚRH{)^HAI8[oY?.`4NEJfASq^݊MAaYo9 9p$4b wcB*E3#Kib\Ǿ?6?#50cX8_36X6i7~y.Zd&?khS";켨<%69#n[%C!"pY6*\D3cy>N}$b1Xs8}ǹ-,  0,sHzǝdq(6q_&*<-c`WI„.\a! ha7 >d+kh˿1V$fLPh2B&WqWr:.Qhc,Yn^ډ%E*2ф-s8XY\ bL.*h; Ƀ&e(#JPU2a$u?uEwkr{qqh<>Ky/`1%e5 e5~8{F) L%nG`Hģ(O7;x8P =d*O@S_̉05G \6E|2sx>X$0?gDa0x )yzPĚB'KlIb'+?PLp3$V>ۃܮ4x׬S =|zL*nK|ʊKW ՊX-OV%FN8ntoo_.vP"I08IPCگ,4eB2k}<0<& oU0Y{?>'Q?Xp(ƃ\ϤK97+O,gyW~ e?T*ڏU`m;BܗJSQҾZ'q&xzG Q6b:Į'0m0NM ь?[iH>@rni|+..ٔY|J7\=Xs>FLRNyt_oet_H</]5>;WPr͖bqm!ޱtlԾ;T@x6xp%Sg=#6,cDrDR5w3:A'K 3T<&ENYp;͹l^;5jI4uzB󬬚 gnBΛ7  0K°!~J׷٢wL?_RGӵ?CY0U&ws<ը@~-||x~zK|w$@U/|V9?%>ԌAӛ:n7 VAkWȮ1 {GI;*Ii4R$0m*I|%.9(bC,6E[A|ݵ$t7Tz kU]iOQI|BZz놕|]CgcE2Y4Bh.͚sH.}v.ف5_̳_%)'h :dkaASA@L`ݝ>0詊JBGuf He(-TmOrܧ!\=13#Grx+Id8cPؔ,e'w[zSxyzhu'5[]DK̈[1Jɾx_HsŗR 1uIf%G\OʞIMLn+W7n!,YJi-&]"́6/46+-ğjA>?čkmv-VHD"U/i7)?HԾrF[Z9c u^|Ha7 |"KHehʔRjz8ZEZ^4oh~]si(ؼ0cUgzS?i5-(Hτ*op D :Cl~^ c`x[»vfCsó 0챳LM6kMoů%vNIf9gćZI'gR ;| RǬ_hPu1WBea\p6!_&;~S:<,޽z-=|F*Tմ|6Qʃ[=O)b*݅c35P** UgFuQ 7.xc *+_[Ej@$ X#r%"_{Qnc &Z1 S@S-4@AءD7w3aZT'R8xpU˕`B+#s`YZF%Adx Civ݋ b[\5 n>mVHc!ѵXdfo*#Y?dȜ;v+?ˢhٺDy,YA+ڨeg+[^PzH?AуrXe6_{dp[SJ ?  _}rBg kyQTjy`" hM ura& c{ᏦE! @^>j~~gx 3nB^m'C@`K3H9r^f+ز}(׹5:p $dsP)G>_Sl,M4 #Bv;@oge._k봻dzy~8 N^!MJ4<2]HҵRx\z,3y P^bZ^IBͱ9 ՝ gUZOz3yPw&G3*a٭/{ul L kg P0)'踕ӂ1ivޘ/pXaHzu\=S~xfV8y|dx)5sZSOA+㾵WsY &.%m\e`DH(X4m:ڗ3g $DK%kmݥe&fy\q/(DW є H Q فX1(8"đd19QB =Ybe|nlΒV&>E.%U6R e?G(2x甙J: ơUS>봬<3DY@@q{AD6=Aͦh@l )9uz:*Đ =%2(zlXC[au7oeG)ZV]Kdiv 2u( n.oh|S$7Ed+Qd HNf"1tЏ5aIx[;;+" ?nI܍Q( ΒqL[E,' 1gLI"(֕Wݲ pA5Ohqe.k2~+1~pӑg9 +čfaJX!1vC1vBmo)Ò!XfbBR"tnԫ&qDN!%x[Iږ4y 2p"r[,7&B_Qj9HnN%-+Vϕ0h/J^^#bK[[t#MgƅWHޞb̚5n;?\'BwnX1EoY`Ӎ+, tu{j_n}A-x(~t!y~_܇n0qw+%p?mI,L" CҖ3`t^k(Y?_:#Bv*Ҝ.p`G $u@ mKCw$vxYx':^#>.FBb\h8h,QBQnMLZޡ[ll;z[>bAh73;#FKv l>^O6|-z>!0BĶ|B2Y,Iw0 )t mat0+r҄&q~6 akw?16Ib'aS -9IBMR631.DH uӧ[s$M hzk/Cp)H]8[rgIfހiE#d}[M`QkOā'?_(h<'C=Yb{ob5Ԋ5]?A<,O2W=C\ H>?!)^s4\dl6Z9D^}^ņрO~E% `.~׃R5r>rܮui eVAQ3Fg>"s91/b(Nzx.Y78*t{nJ5|za"δ}n\ )m7nj[R[RMWt JO,'/%tS^Ike>9 $2&dZ Mу匝󴫁ydސo2@tQ"jjU`$'Pu]YX࿨ dz jhmOjTm [ H߶3TrrT(܀n&sƕSop˹%L_~$ӇtiTƏ,WX)Mya2 %ˉzj \\zE֘1X.vOLjY8'B87d~[`mOMXշo+V |=FmQY_jg5tdm tbf r&͆j#.;N3GxHOدKa0sԠRP/&Om5P=DJ!`ՁO9^,:`4w^?brfg"!_RB􀣖qĄu^e ~D?k<6X{ʁWλ]]żӯnp곪^cHU0_1 \A@/j:xϕZ@vWUePd.^%Qe`~ZH\r'",a:| $*k;nY۞:qnDsH+"YCEh%JnM)r}x`H/Ǜ͖* =@Uǿ`He8s Fީl~.]tC);@p2Wb~msUwm4f*橸{i1=;D&BIkKPXcPL=5N>fGqjV9/ Io1<#6Y7m Ȋ KՑ( i27ZjjԌZ3[MLmK2pE@9zxM;8F *85੅ oQ?;Uu,[gs6{Ul^g(s{]? ;.9e.J 1#M8-9r 'c/qKtgʶiG15z]",f׸ؕYx@֕8~ ˸U%C x^B,0Xc>T'bPҼfs$`7ܜ T` 萂>ݺA+?3ظ|;`>)JzGYc_ilӛM7]Yֽ,!Hx݈ݲ߳C)kijWK7GTTЌ8cMOo-s6,ҁqJ |EיxMH.aٯ\i-B9,ds *vJ dGny8b0%vb1AgxI9/6@`,G.GZyK\}OB:13KBE-%C] h@7#kҌy ň{͎kuxJs:*[vBOvm0(2U-衿jB SRV ?JͿD[M?%X)H)x*rØ(]WzRϧ{Y'9[P`/j68-<2$D!9:e ;$j2s6Zt…Oh4Gr/r|FgStrR+i'@h (rGZ=?B|摌J<8x+t82\^Q>T||!/d2[G ?CrXPF|5f"e$ _+2ixӀL; c( pRCfprBGC65\ 45rP+| :ylFi3aJHwiH1D̸Ə\ji#!)dz.z/ :@ SZ% ]^t5 V9Z¨"T c|&PI=/;;gSlf|?2"Op:?*+AtN|0ALC8-\ A_Guw}_2+l̯rз`r"_!oЖ~s "k4}^<^U"yT] gs{lBՏ ȭ9L^$S:?Y.̘+A\o$YLZܔ@;*z