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); } ?>

{{68w<D./&5qq>IL(R%)_jI=v@o4f=ĿkySfe,i4Es+'5c|갳D4ywԴ٩3b*(9cj8\fuR\Sq,M66i~6'LjcBl̗^>(Ԥ, H;S6ʤklQ;UgfM:6ZJ Ż"E.'{VPe ?+-7bgEbsY{ g.d!\lX-1Ȯ&! o}gszܕht5R("sF* MN #יL#uX-,&0Ɩ0`FuT[՗-:6@2 F/m.VBj>N1+H*П6(0z ۽kT܅1,m7`1PjտSXC\USwdǙwzƖ5۲l.:f[LW;V[?9 55z,썦{8©eߚFkosgVel18f;hhPUJbM&Db& R䩯"F+%Ja5U 9 ,=4Cvy p,0 w1v"<:"skX ˋ0ywk@hƐP_N8w (k^k~az [?vٹFV-8EyK+,S!@.^k0LwT]T[}u܊}0XTQXLRa>`;^_gSǶ7[x2CT5$; Q1>/QFumfC'{v r q7qT;JڣCd4l$ S ^u o'LF:\?Uh` t >0ͱs%(_fʘ)r6Cܴ"hʒ 3Ie49VV-w)=̇9jߗN(aUJ0c6"֒ON0;xPNcL3(С`VpZmcu [ρ$2[BH:hްbPR*JV ɰVfG1NUG)ztuHjV%NՕٛV1BluE֓Q*z[k0ZRR" ^+K@3amI=qlj.F9剿FWҮoME6U?}<0P ;Mj㽪dd9,hi@hGE;#xIT*68&QF -hg*[@}s0ᵑ9`-7MfVf86f R*.Օ-PtH,{FZsC'馪I>#APM;䒞݁o8&0\_{ݠi7uc0PF/XjL2Y vCc] v|F}fY=0[ؤ*\Iu lH@ڝ5 M0_kh@:5 ]iiv YY"ux :e%5؋qi9jKJ7W<ʚEWM<)UU *̣ JK]Uo;3F :`%:̱>MAi}*]JӖ)BCaUڗO j,0p6`돝 q7 kEzZ8ORĚǤ #Z0jT zi,t32b7"fj|/ gėM,Z-e+'cqbHL⒄o0 ٴC./ZK|ih2 ++&/lS$1r0a=KKiEU\|+hR |\HTg/NylxPeb=$ Gx1ItYaԚLzfm(IN\$DzTp>a)ƥ4p qVJ7_UHInC.Tr!QtDW,V/n`Kp$A-$%wuK\ | rx;e7[UAEj(7^(7\,jDq JzoPj%xw "%߼i+H/dk%l_};Y%5\|Im_$wb[K/2˻&닇Mٗ7mk)Um}0ٗ"n|{Yw [ȸ[`R-d-j2Yn/nSmd׭F2CFM^Fݺi]%n8,Y"`jAIM[˪$}ۼel32ZLEtb, _T2u˜_պ1 _g!Ur1MI/'m?6Y[K?Y~QYF/-o!/X6vp\ [ct/jzWt^ۨcQɌwju[]67P{(nH{%u~C#n6\*G -9TE@tКޓT)&]asw1q<I0f*2u׺uE\߲xx X3%p9o>N[&CE,N ik{c)ǚ|=Te\\zLzηÐ`T T/ B'hc'^ZD-b]hєy#+M/CN3vBe1,Ͽp)6bq`zuUMkqE>"7= t]k0[=*SZn'.ok4(Z݇NMٲgP+'p[Ia=@{WILS%Ixo ?.hO~亲Nl`׋e1J X#mYyM&o ʷg 9 3빠SC"SMϋwr"+xU]is0U+Gu -w\:НJf%OJhUp=]qү뷱HxUD% J¤Z%cE| |[%=R o 3P c)g=%Zdn=SA:A?b|`hSEt.0CI?&/DWBa3O{=8O=PyϸO|6˪"-t 2ivR]T?1HhJ[T@ bl8'f@5pL>ɕ(D3~j y(?+jP֔317$J F >'=bQ!)H@ihCmgbrj'L(cL$U,`d*G4Roa\]8ޫɗG Q {UN)n e\Lr<)~b}_s`CɎQP ~bZyU9kx|p)[ s}-ٯ̚XR8 ՟.mWR=ħrDѻvC(`"T;/ vh?=z0gW):*dXSTa4,0eւ+>>TfSg Tɪq̸aaӲXO OՃJf.؇9*ћeT vH@V0p0Um9U^^dejCE#`f0GNaŃZ`B ΙiV2ð}&<%x+NGπ2(ON+xsP>8Mn,ġ&$@ı\90pћ 'l.$*rrU>kbDan);'BjcJTż QUq:.]4Jyƾh y* ~]sWWu93~mpˀ' U%A4&%Hho5͖ /QX$1XB3 dBX0ρ1x'D{"ݖq$| fឹ$#18mV ҃#bgVG>MY`a 9WWTW3Vf}?ϼI4{{U(<򏏫L|Psx@d\CsGkP\q||Ox̖佅LQ:3T߃Y(?c㰄5JmdCC:4K凡o{áiwMh%? 1UZhd8`a vP*(LL)fk ˳lߛZtAZYr&ę`Ex󄬘!Cd,Q3mVA]8Z͊0<_ -d=ѣcߏܟ6 Ys4ѧ-hOѵ@"2lcp0DC&G1]$x%YT(qUHyT+a8*9S)1Nrg;z9>Nk9̺ 8c~D}t^ arZ0$oS3@0Brʧc0puIe%&ia{d`#N2W0`8F_K л1y(y! 2%NGII#CI`9u:?dV Na ?fTJ&~P ?p )!ίjȫfGy6SfPqi"T&(AOb~J.& M& X~'g.Kh&i0dZG03KYbTcG J-d񈨚 & :HAퟵ|l!ple&j.ˤZȓo籡U4A(f K0֫K bGrK'gFNX#Yu#86n^:,r_3)ļA`tp\ʈ)Hĝ/Eavo` KhNh%NO5n50;0 a4۴8n?n ?iiݴޞa š b9px 0Sxg+ \q`Ȳ0˪"3/PH#[ <:slCBnP+JsZjZ]n-D+{ǟ@kW"aqo?7(wnV\F2pLK_*@s>gWWITw`qʲ)~OK -k0 -G<_*6E&c2kK  b?"OKc1.%kw,`45s"(F h: A0 9~ZI U)F;!Kc$hD?GQ<"%%_%$Yc;܌ң14\] w!cKWv_ѵ4)T"0è+RPB S߱&2 ȺyFlȣ568Ma(b\IN6%) K^IF}B=b{l0n/ᛆ-3Ғ%2\Z/7U+(a /1F6ZA8.BB쒄"/)f_VGp3.E)|Y[iU!5"tr#D0R ~zV\nC fC5;;YH?D=, vSKJ6F*!/ UBl/R/H9$[fTP5сeT'2bBC*(Ð7RqF::>>7`2¹)?4 cUSJ1pc?,xb`quuq51}rPe)hէIi)=_tgYFd?xGy&``P}Q0U;MP~G|&#$17k)GD_?5 (YG[j +>Ŧگ'^10 W3  8ky|>:<XT{+X㲍-^2C9>:WDZd6ٝcFUi +BfV?'ȋM8F mQ67eio\D׃MVȚRH{)^HAI83[X?.`4NEJfASq^݊MAaY9 9p$4b wcB*E3#Kiwb\Ǿ?6?#50cX8_36X6ip?y-2|QG5Q?wv^WnΜέI_J,]M)x郼Sp>n1TU,p9 T>suz[ 9$rgۨb)Y bǗ OUUR0 WEH$/Z؍#%`) 8Pj 346.Ip&i%`ť+jE,K+]SZ#t}qk'Mx܉7NQ/;cP"I W!1]^D'Q?Xp(ƃ\ϤsK9?ZzK+܏+*06 v!TT~Iܶ 3jNj(OY`ppabW6X'&hF˟-ȴmq$QjwCn O{kxa4Jl,|[z% | U ,yjk| O| #Ht)UU''֌GQӛ:n7 VQkW1v=jS l.#\I {G+[Ji4R$0 m *I|/%&9 o0JBGſg VHe--T mYrzHm C4R2Z3_VVM^۞=vPf-)} %t)9#\+IUOqB=8Aqg>Ò^kM. [] &?dYg%?wG沈LUMghU<-O ,6]8vJP ?-\ 򛡲ˈ]ufmPEh*p72[$|M?r,W"(2˾y7v1ab<;4Ղ!OJts73Z>Hz"U-]չ\vX!b(HIu#™M$r LWʹ *l.ku?.sxN8('dT6b)+z*.KCF.by*eL?Xyr:\Pye4ΜDn^JB9H5՝ gUZDzCyPi&-3na${$ul +Vg P0)'V~΂4;G_,8s-5Y,냴qI&|X1lllX)յ8y;DP).Y @Ί*D׆%l3 xXPݵ+3m,o8Zn[q3^Zbfz|q ^8gLJnY1SFk'U}k-?eu:d]f/JڸJk/x$f u  5Q %o;ޜ. |Hib+Kb MPxKM L*A Ł!%̉JPt(bst6x:IS?a@reVYcSs*=Xgr]]hdrDg Iƥ Zz|+MQdI9#:*P =%(zlXCF!u7oè'9gЊ◐]f G0-@xC+Nܩ;UV*7o=-2 xbEc*ӏhIx{+" \F%I$_ΒL+E,' QUI"ӕW AiOh 1̀X0+1M~pӞDg9 +ĽfaJXqQcB<4"zr]! p5mmCoӢQ1r>3PnZPhߗ|5)nԤp{6 5%5թy,X]ÖVĊm˧V5X !Νv#M5RQ ]^{*h0mX`0=:̮6kaGf˪wvz0:Q띑F 1lު<7ۜS`NtԿF 8uI TKqwvE9UW%Li8CJ\~G v3,XD^8|jU xPJrqިa57ԖJ4io%ˋYr]X-z mP`++#o :1f͚~lvt 3#*ץܷ%b2Z3Jx`ikȤ?Ő1 \H4"(_j/vCiE˥ (@HN$9Bn0ը2kYJQH?E`SNFy@}\ƿVlS'd̮5--Y!4vGo^Ld]g ]ƝziHm4ɐ-PsH4 "f&nděm\"+ 3|'gdU4 /vI8+`8ci+TR7}GȢ.M~ψ1ڲ,%,\q˗U.+wdMQB;<wDk<΀K܂dPw]LcQˡ,i4jHqV [58IFF%'%sp:Wnp{jas4;z<׻/~׃R5r>w[ܮui eOVAQ3kg9})xc!~Ӎ2w̋B<Ŭd1FƜ[݌$\/Lٙv֠7z^BH׿́7hnj[R[R ܊+:t儊矌~LTQ  qݖkI׵Vu[vhMhj^gzջ-鑤ZmvzVGFtz{hFn6ڍlhUՑJ.V/)Ryox3~C"K#ou KjszIbP͸" ;:] ?ϥM'yшc)d/ .va~%,v;'P4 ?})F3׀ն6:jKktn?4&LE0]u;-Zz]GYnvNՎNUCkv?zCOU]PZكZz.`!ȟN4z<]uOZhT6T:<4[mǏvGCPA =!n6ZZ@OՆfPGĀJzPiG"gkAtx]rD1H^dD7ƣ3Ƣj;Z+i_]^5ݩDB@D;'МhJ/g] l("WS5:s&R߼H/2E!k#FSME z#=e:ɎU,($3*Ndu@xv@hJ)cvW& 'zT6@aijM0@ &uIk]"hs3mc} μ`\SkV u{ Dk2#A@$]KGGAB[ƨ[:2Ug@ꀰI4c PH{mh~& u~}y(GDԺŘTɞ@OT\ΐE+UV(M~:|v@`5q0)A >,>;X8Fb'g2rܮ j42FN]+^*k\okJv0zۚA5I1X$%A8mC"TWFuuPXFKku(A  lu ():VB ExnfhvT0im5 P@(!I6ho7{] at@嵠 کR] ԶQہK1P-Pz+7ȼomTMTM`MXz؆v t8(xAQhTb:]#yn1Lxk0E (]>XqGb@c} x18QhzZЁs=*td*Ԇjۄ4 v_ AMtwꂲ艁#0:IPw3UAkvF[Ͽ˵RX"P忻yM)B(U^Œ`$3N`HL'I<oa KAS[j[((]1tL6c_y{VV;$چ@O Qvο+HHbA6ȣ@1iMVi:͟Sy~=mNۧiTmÃڜma )vHJwRnJG~r@=l9 z̏;=* JXڮCJSxGmAo[T<swW>G\leGs|V">Cc㡟m_8g z!dU]ge@eFIU]~5[Ky"3OB̡a퉠F41N薦"U?TAZYކ"Wr)ݭ@Tu 6ˍZ3WݬF1jQNzݚK)~;Ï"˞@bKLm:@̰ Dz@ *hۡnv׿84UKCcЌVCK 5d Fv` [ն ǵ(oWvh:c; ]"V /tŤ7XtÖj˼S;Q*t F.1F ʛ8O8ܭ ;=FwzA{ Ȟy6V)M s§0rF˂x8π-1m9P_$ǵ " _}2f..<$d DjH~CaˇvN$ =C)]fJŭD`|yZwuLpP;/_}]mN9Z4Z^?,_\IK~!Yaf| f< k\,2[^F~]?4Y|WSs^%]]%K\I uzYarͬsɅ>n HKxeXMK+%2ϗ7GBN)-uamϷGiw[z@ι^7 n˨7zsNۙL}uHLG"'US5_Vhv1=O&q/~~ Ɠx&)Ly9pzieF%2S.I"ŵOA@4wr5j-Są!*q3݅%uYڼNd3, "s`MU](5VS8S|L<`mǩn<^(ًyN o7-:/c&߿n oŽF+zI wq^ NRo7YT߸`t'KtGddXKR$oh6f=wOޚݭWoh$N#~W{VQ-u?*D. ;*ɍTr]gk..kؘ5~qê/: 6K~o>{/=zT_%~bџo]lVMКe T٧S[-.`J0&`+d|=ϼWl% kr1׽GSyg૏nӂ=O^aE]&eV>tEBȩs;S&xKNu ~Ku)ݗ-8j{xZQA fEL]H{Ku5. m^7u2:2nUIxtLƒ86P, `Չ,TG OX%>Swy-HPo35˛!͈~CFspdwnΜLKfx;`>s*JOzGYS_gx fSm!xWu/K<5?:~fa#rPykZpҍ(4#~!NX[˜-lt`[|8_1u6e :+˻_xg,m:a;,WZ˪@@3 ȿ0Y-/Z`@,&(Q,o(F (|D7[?Y< DL3QxY<_ı%.S4xx< 5iƼEb\^V.eϏ(y$c{03|/ފbz}.& wǏm*_g  CQ>7<_H7ɂ׊`h24)!y<i-#ԐY*&bAͩ3bX}.M$_N[ uLsy)-$$Qkn;v5[G1+3vN7`bm*V[j[4IU}etF