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{`֖b[ _&ݮ! E$# Sa'=v7nc`0s~__?ۭ{Wr-obS߿)Y6ȒFS+Yd=QrY3f';A$K#ߋpMM8#ҋ"99#eNX\$5y4`cSF*q'r8]I{tȗMaj9$ԟdY_) X*Aw!;W2mf wMyMR>AVVVM*Ŵ-+ɱLniz% @e ]JB A$oIϕ$d)qi,KU U%y+YkUUgr b7d(fdEn0Vfd2Gw5(t ^J;EBեUN:8Oլ#s`px .5A9mJ}~V}G$˳LmcHխBP=7r6 k0jX|Oښܩ0ݽ-:qZ R(e<وXK=>HW$ASj4:Q2Z?@>WGYk5rG'1^(IFUjlݳ!Ad!eCNKcrX%>%QXL\RA5F_jkj/5j @k PV{@w[ ԫ] ]t,z9Lpx;*(116:apmux0$`63X9a/ 7oihV5Pƚ ""§5ڣak9pYÔ$]f:YhY?tVlc*X A%QA0Vڊ(ѩJ(EoIͪک"{ӊ<\S9F zR}]1]Eo7^2ck FZJJa)ƥ4p qVJ7_UHInC.Tr!QtDW,V/n`Kp$A-$%wuK\ | rx;e7UAEj(7^(\,jDqk JzPj%xw5"%߼i+H/dk%l_};Y%5\_|Im_$wb[K/2˻:닇uٗ7mk)Um}0ٗ"n|{Yw[ȸ`R d j2Yn/nRMd׍Z2CZM^Fݸi]%n8,Y"`jANM[˪$}ۼel32ZLEtb, _T2u˜_պ1 _g!Ur1MI/'m?6Y[K?Y~QYF/-o!/X6vp\ c<+Yqj\a]62▻ӹ[0:^6FS >tkzWt^ۨcQɌwVӉwJ܅^.~]b۶%u~M?e[۪*G -:TE@tКޓT)&]asw1q<I/f*2u:uE\߲xx X3%p9o>N[&CE, ij{Cu|5TE_xTzWÐ`T T/ BΫGhc'^JD-bkєyW#+M/BN3vBe1,p)6bQ`zyYMkΫqE>;"7= t]k0[=*SZn'.o+4(Zn݇NLٲ'Ps'p['aݏ@{ILCS%Ixo ߒ.hOﺲu`׋e1JX#mYM&/ ˈW 9 G39CG"XϦ||GZ;><$N}W/ra#RƦL3Syh ;TV&T7@)T%R#-~ &.y.ʿLH~6 OꙇGWx $,"SB(36vvnq"yxLSX<1M38JQe؈N@Oؗ/' W2mj0Pn>#{%q@_SIr̸$I[ < K4Nx>I6@RYVI])$12Cx VR/} q_j̀4x JR9pD2;嬧D8s q`WW4H0s_l,Mr"HԝNCf(]B>I%`aE:}%&?TP ׃߳80ggZQiCȬ<*,A,f(_GE1r/FSڢ^SdǑ>;c)N|D S[ @HVSz%W%1GVd0HeV>*t42\ ad04NA2Pb\OFsj8 ӕ ? `DsbB h}$1b#S9aob~ 3p~^-@H>;яJ;rJqKpU,t<`I{3o 0I=o̫j)_CZ skaϟ~eQxpiDZA@ >#_GGW{B]-yvUB)[<*'La P lR.hPaQ)^7-:c`֠JVc 8 &|2NH~T4s>qWq_.#/nEB99o˩2x"'V.l34-\78vvDŽ+d//qΤ%oH)txTEo7 [q 8| ,AFyrupÛ/yat3f) 5?&=6?#F&L_U`l=gs[t!QY&& p$H<FPS*e茪ʈq 6V2f0|aESpp*?2 T!P +.;xe%Oi[ZOĽ''{īe$-`3CE=ՁS:&? KaX _E>49|yN3.lg|>ةvuHq*k:m%& mڔP <>WCh]`rNJU1+v36HghHuDG9⹹{eD,PSg[K='[c0m߫91idga"2J ͐ ,,B)ތp2ray{C>H 7;Bnۄ8sS8a%\0j@T* GYqU+88}9>s1&23k0&T0*=̜*@BPR4 ^;u.a6 +F$1gc̓w$wvּ}}L:'iaѸj>ʣMݻt`Kb0GS\)Xĭ@]<{NV&K,_XiB)N,GG vڿ?w+8/qqC-( |PyvCuqd 9XBlo=kd婉!Ę =ߗ ,YQ@ ;(:7HiL@P3Ȱ9Gv  d~xKQQu y:W#ɧQ#I<< jNn>|t?h8=gh˝~;+g85/'"2/rR&xXoq؏{xÿ)"=|f/\ixh+NϘ9}'|W>]B-s" WtPVb"Fg!8\`H& v(h0H+ !S~) Fcu1ـ` sQ턁pd0R1xYшKCjˑ aX|6yﴀKCaYO LБ< $oGp 8 @c [BZjvgc:ȾI̔JEDI$Oe ̈́=,AffI49#x'ŕ) XR a<"& ABR`'-"{>n/-I.;;8?܏svxڨ*̔3ًBpaX+,̲+~L"V8A5\9PPkTc*񄖚Vg)./ΔSe u߈g̢a>PlS8 /8c߄6 ^a=Kl8$F>#2\xWq .ʉ/'Q[4(GɟYqqFK1R/~]^b'Q<^eS0xR*7,/A0THyÈX68n?GGF x\f,ӢPdl*ׇ!h!lT^謡\p ä(7篜J &z?p&-k0 -G<_*6E&c2kK  c?"OK#.%k,`45s"(F h: A0 9~ZI U)F;!Kc$hD?CQ<"%%_%$Yc>\14\] w.cKWv?ѵ4)T"0è+RPB ߱&2 ȺyFlȣ568Mao)b\IN6%) K^IF}B=b{l0n/ᛆ-3Ғ%2\J/7U+ó(a /1F6JA8.BB쒄"/)f_VGp3.E)|Y[iU!5#tq#D0nR ޿y^A+. |D3erܚ}Ν,"ֈb~q) %HI%#DžQ۪ EUYV#{fTP5сeT'2bBC*(Ð7RqF::>>7`2¹)?4 cUSJ1p#sTC5Д#Bok|,#-tυ]  v\fwbSLtkfgfsy٫f ᕂm>}TndSmQbUF+գ}}1 Ll3j@&m#Ķ(7. A&LdM)na/gO jR$,RVPY S'"%)8 n&ܜzxtPn|b_و;sh`1_㢙GW%4k1[bߋ}]^[1E/rRf,4x?y-2|QG5Q?wv^TgnNέI_J,]M1p郼Sp>n1TU,p9 T>syz[ 9$QR8Ÿ/mg1za|0H_GJSpȵy\ _4~?X+ď3&(4g|8|9YyZvY (`1lw,7/D"^h‹d ԃ9,ƆgN K4ܝA2%(*0_ѺqJ"5Ž۸ 4oAIZ<|lq0FΘ22`TDgFy:D3++W>Qj 346.`+YND7B=# yyϔ # F$QIp&i%>eť+jE,K+]SZ#d}zc'Mx܉7NQ/;cD(`H$@902c60p^hxBm1` Nq"y0VѼoZ4agW 3[WYu ~)8)]hE u<X*$ˋ(ўFfk bϬ%Fh6Z\XDe&.p劖HD%P0BןVb5fܜ}hOOx:x։3pU(ܦuyqUx'd NUg.[0M/KUT_(9gq|%vWb`ݮ8 wߴ'v=HLaBB}kV?Q@PFUg~a!lvka0Ͳ%B׆/ +>ɅD 酰ӞQ\$*!]^.40<15~e?nOGs4]|yj"Qy3Cy{rQnO\+Ë b<ELj<1QSYyg)<ϻk(Phw$*$ BܗJSQҾZ'q&xz / l>ełu̅]O```c-L#+D }\ ?Z(W^)o$n.{1T0[%}1<) ҅LWU['+>' hHx>g_6Fk2}(_awx2ʭߛ-eGC4uc7}whR|mvM~K{X6GlXƈ䬉~kht0OXOgPk3, y'Lw vfs Ko_vbphXӍzPcۉ޿yVVO{g37G|t%a_|m=دd ZCΟ!,@QuOtƵ5dWa`\<7dx+ç͇Md%?ǃf xՋ[߁U`25A 5C|%u@ʽcaQcY>tJ~$bխK%4r)X Q@$>"_"|(f"-Pߠ|J.RQrWymy!kf}w$CO//zru զO\߇_:s zBH7R7s+ޕv~ן<],/7Kq:~.]] `oW)ꇴɹhWeOB;%Z)3TRmw'0,QJڭyyAVI&gB}LU{4d-'F`fDH#%g,]sTޞƲ؝lz~k?굌nf4].TWspԀI2GJDŋ"}98L bkZ0iCnfF+kG˴rRO#?p:,n3[L Kpy(=][ARhPjy& 57Tw'WkU? DTQBZD!xvpfQPc lSױ%xb4y\Oz*7BȟV2{Q zc~NaZ!ZBISnR#\ 0fR]koXkʦKwJyd [B+2x'wwmcdF9)gJK 2?ΤyOVt\񌗖f?w3 } ˧άpp1SFkܴ'V}kٯ(?݌L:d]fKڸʀ Pht0g@HJںK ǛE"(M_PQ )Tlz|+MѼ͑dSr72^u6T!czJd &Q&9"'0%CE%lndSlįxj#\5d1Pb g^H)ouV_7/;-xfE@c*[QkÒ|9oV)Dؽ|&v1-UCS2A%4oiN.bě ܓDP+eAj\b eV">c9<#iA/rW@I-6qVXQavC<{0Vr]7rm7/BŊ ,z0٤(=lRp߹5A6K ]ش5qީy-ʎ B0V5X'Νf5 ]=h0mX'`20=:̮6kaGf˪wvz0:Q띑F 1lުܩ7ۜS`NvDE^Fd $Gԏ8Լ I"͟ .wkvD;zkNy(;epG6FԻsqބ\lL-$]ș:1+ϭesuUkeJ IHÛ3.քV>6+"kF֘Hm}Zv84NVt*do(EC$,Jݲdzj߆U۾lV\?׃l ܳ3YD^{j oMVT /¯T?lMR`9?ύ I}?@}4._%B(kM k!}4eÍqK8%8Ida£i)("3:R'wo!Fv3]l4C/D}](_8 pj?NB?R631.H uDžqw9JI_&NiЏ,\d-rY$3?KYG g?3?WR4x~0_!:Dצ #t컮*%Cui$gM_aGyTUq m N 4}3Ƕ0)\WLfZl N~E ^^iDskD}} ۹]2zʤ@5᭴LZ:?@i{O F }S|Ƽ=]̺ZNfcd3`ӝﹽ)פɎSA߈zF%$^ox̔ն&0l{s ?F$ܫL?TQ= I`t]kuz^nwޔ{Fۨw^ےKz_ufjuthD'uhuF6#=ɕT]jh^*QDSV_%4fDt?]FR _6/?Š,TqD@RvtvsVA>FlJ OYt?>eA]eou'j $ F]'i $̬"cx{bOu49;Y~Il%|/2#i44Fk)V=XmMӚ+Z L^ /!) ڬlk:0:M[  :H~]9Y"y1CR 78z5f>?p#{ܽ4 pC\y١hg]㬳'=8~cgab=f^u9M<븀춪 i |$)ᑸ(q "ODXt`FI(9Tv:=t$r݈&1ݳWDꇊq+K\S*٢_7QU({bw殲5VT :Lla*tSص0QTlixCpoWzg"=R_r*v\n'XW y*GW׶k Ȋ-KՑ( i27w[< ~Sem7+?xzf Rհ?oM98UM9)rj^xj;*۽V7[NM_G鋭<+VxaK7QS V=}d={]Yi+¥8Rx\9OeAӿ(EW m $h1{& :w" _١ ASU*q- _%)_q޴IO&\z$rth`ŢR^JM|ЙpPY//\zIC bXkgϠs+3 c)}̏/6<2̀]/yOpG3&KtQe70C#oF=Q(z7P󧫅?f5wbmI_V78rJjGzջooߗDccX̀f/~Zl/8B5b6+-f!UVFK%d X0yS9Gʽ*M6]xu_@)3 jϨӨoqeW.kpUϾU9upooɩ_S 6Ĭxk 4NĮ\Կ\ƭ* Jx|e:*(~L5v4C Aǿ/ooJx$}8)u;Ve0g7q*w|u}6Gc:'jlKԏ*"@6nCV,g^y|s$< unGnY ǡִp~5s+˥k#*P*hF\ܱ9[Tc8 %yxocl<&tV ׁsOYtxXUo9A|de#LPc1LC; DճPX?q  0@pz# %|rR>m!Je~%.S4x, 5iƼb9=f5:<%Iv έ ;';6{DQFn_DD))+5vkr&\Ō[,QN<9av+yӝHDA(0Lx5csX"Ҳۭ{\Kx&6H9-\:X s;Y4 9}9>ZV):!C@شc |4}vWR.dϏ(y(c.RgbL^|-ᠢU士 y!ý~: ?G21)&YPJL@&?a29OBQH>РEt(2+\ńc:O09uRX ϥ_KcK7Ni038W@ڿKCxI'`~RKI1&kD=~u|&W8ΝF*QYj"Fq~h?Nr;/p9u<eۏNi+3* )YO'G 3440 Š^}x_\W{5N/*@ڿ+}KǛ/K~%m1"-&/AW//e̳ٙU%Jzx_(`q:a&d]ܚÄ uO2%0EŒYeV/HM $X.-p{JA\p&v2 KJt:u`kc<,FSǥ1ҩ C9s ̙-f ac,@͸&$L(Nc qr5Uݑ~湹{e,ી ;]6] ̸FHd#rT[jq}ذϖ (1KahwZz1{; KBEV_#g|fReٙW%5)bl1kt`Qr|;8E_˷*%7|&U޿{دW.L