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[ _nҤ9:^)PJR>jyj:/9g3ՋvtF} @  3t=x-28l3vGn҈ݙu:3ky} &lWg(ߵ,Mw9'.NYl <+VGs5Ȋ߫aw>s! I5bmgEXum P5!?-) $zِR^X-#S{{>C͵Uqkt\}x _* iCuqǪW@Eݾ12iKΣpцFw0ئ0wlsZD:P c9xrP޿0}'Вsg A!z 7\[^R/ {kDxgu\]j^x#f~:Vn+U5 a(u0_xXNCaZ:F'?mX Az3Z+9muE7m3 TCK w]ZJeu;c= ZԱ?Z},  }w {T/3ѵ2TpEw9Z!yHe5!)t)a:iN"aEńl: ^rr%SH‚E CGc{1@Y[n9'8d`*Zb$TC|h~ 2ylƁ0,1ъ8pRXMx#AoKxfj9P])}e( +@,,%v@/ϦNpnXk~ߙGay2n AJK uk B"S_/Ta.;W g8ouiКexj:dHإrk-鎪3Ԙ|󁒲o5\>\[ѴF* )CJ:̇ azY6s˶oX~J]ـt'a *@%2ʨ-lhbDN=N 7Y8>*q'r8]I{tȗMajc9$Կh^ǟkgS laUpR9veBCS7A6]fHVZYYWZa&7Ӷ&ʪ3yLlv) y%8Ý摞u<aKg6&Ta͎bTRVKԬJ+-785c0ޭ'UF}c%)X1֐a DN)7"Wfښzن7\rB]Ս"]#km~.yf` vPW;3tE7{Ur;XЌӀfvG:w4U:l.qm1MzZPTak#sZo ۭpl*_-U\+mcj/[4躑6CY6.NMU|GlzTwZo%=S1wCT3sq8$W̧ 5BʃE#59F_ؚ9.4V'z I̧c(¨5}PEHTe"_ס|.RKIi f.nJ܆iy]8UJBPmX3_H2[IKp%ꖸ\>vxKn;P nlPl%oXlՈH@7ImJ EJ09yW_RK*,5vKjھH|ŊF_T-dԗwM$͛ȳ/oR˫$2{a./_Eȷql[ȴ[e+^ݦȮ[wՍdmڍdխu+eӆMKzsqXlE$mSqՂxUUϯI^ 1y=fe:l(Xj8et+댗9B}1uc6pCLDtjʖmBM/0mݲg l柲b)OX(9\DLV^rK'E3OL@&mdʿ-^|Gߚo=ʏtj'^,+QC?b!۲fM~f#*_y0,.2N|U]is0U+Gu -w\:НJf%OJhUp=]qү뷱HxUD% J¤Z%cE| |[%=R o !(J1씳l̍V27ĞƁ__  }iN>h4ʩ"Qw:yMt $ b=P$SA-^~ T^33_hE !򢪰rK]c4`E)&*<#1g$[<,o@ɟP prc% |/B^O稴2+q6弾| M%-9D&D$x(Ib#3p :|D@6PYDZIx&ʘk51Dc$a? {[!sDecx%jauB~TqS[Bb>cg1O߫yל}d(L#`^UhN!}A k_ #bFkD,&7dK jsTQ~&::0l΋츂xO*U9e Df+r9Gc:Ut *L<8UhUj3n9`ش4q@8S as2B*;P$N d+s8SN**/pJg/2_3zbl!f03@cu㌣xg'yLA-0 H LZx\4+BGUmqXizqa'ЊC` 2ʓv}#N6Ka90q﹠ 9 02q,Wa:4,wq6ioCOop 51krm0OZ`d1%b^Ψ8.`c%<`fc_WV4@ஹWV6e*ؒ d$f˅x( m ,oZwH`U2t,{s"-h nK3p\IYxN6 +AP`RLV}˰+G[J+ 各uYa3oM^+: 塉ttL5/x_?3}{dWlI[(e{g{0tL~0FU }hXs:Bg] 3ģ&|ST;2 tJLcD) [69H 7;Bnۄ8sS8q%\0j@T*KGYq]+88}9zts1&23k0&T0*=̜A-Tb硪h:vL]l,8I!gA{n;;5& d.J0Г F*rT7 ttuEVb91 +Ou=&p 398 i!:6'MG(", ~GRB蹝_ ԐW͎=l̠G@q']PP $>T!R_+(4bd0`IR,QEbR"h,&gbŰ#+8RPj!SH(TA lC.fC ecvp-3c0uGQ1qΎ2OU(J~Hܪ.͂"\E?X(ON(>yrr;̐&pvc`C0\FJnf䃮LɮjPͣcn0W69+ĘJ51}rPe)hէIi)qysه(`Vۗ/ź^'{!j:B9Ni\M8"$pC_skA"P@<Wv/(q}M1_ӭ!Nޓcaffff-f' p *}t0xR>RVL'e[r Wy?dr>|t˯Tc6m;njW.1ϳ̬~Np@ۢln^߸$囬25R֟?/!Hpg.ޱH+\ZACe2+h|OXĈ$3²ps#rlCIi|d#@ϡDŽ~UfF]Ӏ3ol}/m&Gtuknaǰqg mHl=n]LE1bDѦLv yU_xKm :sF0W6;'KB:D|1+lvU6fڧN}HPSVp0PqՕs[X+na.X;FKP8lV>8MTxZ*/ ]8,B"~n)A| NV!q-|&Z!~D0A< \ũ_0ֲJFadyi':D^$c@ wt`M^fq56<~$`tQAY(O4)CQ #e(b_[ܻ @@.Y|cT))Y-KE~a}Cϸ;rEf;0sqOCn>Svb_Ï_BEDNq3+il37Ll`(q;kD"E1~ ā1(VyLbNw@8^ ,󐙛ēw"I>9'"[HӃ'TOr!?T)?5vڋW?|D%>08IPCگ,4eB2k~!_]y`#yRMAߪ` /~f}(oO.ɣ8 rxQ(Ig0f6s2+ϴ,yW~ e?V*ՏU`m CX Kzui`-牓m}QVM{37!k|tt%a?_|l;o` ZC!,@r,#ݱ*rU)_L`( v3]]֔ؿ1ҭzy Af?jw!V|ZCB&,^c?x=>.)DP }"aPN#Ev@ K_ro#>bS47\KBm)CY]ە7 ʩUonXwE*J@n13$tv`W^]mD Zؒ BU Ѧ%ȪC2~V#03q$GαtOvm3[*nbYvNM}g =}wfFqxZY{/Q_[-37R2w/^q{hxMFTr/c F_zA mx)d%b3g%7g{e a "9/;iHgKRici`I)dHs 11MwP1J8's|aq-~[njyH K)otZ ckO:-і6fld/CkFݨt"&>0i>%24eJ)Zz_Ngÿ\"X/xb4U. 94,Y_\ѩÿZ$ t7Yvn"a6 ?/бU0d«n`Z- CBle`xx±S`qyr( ^F3[mƀU(BSpO <-"5k cGH_=~ǵsC٩| y PJGX0F<@mJu[ 9,-.Ȓ \^2Vņ4;JOWFFR-}yen76Hڐ,^237j\bdNo;KЕLeQlll~9 E!R޵(X*<zZ0q|Bӹ0 p1׽GSߢ bj?>iOgxGWO(3nB^,m'C@`K3H9r^fѢ,ز} (׹5:q $dsP)G>_Sl,M5 #Bv;@oge._k봻dzy~8 N^!MJ4PX4Z"/=ҫ/< ĥ&x;7R 2&VgW> 'to鮑MhR4ݿFi:; av]oYnۍNw87[Vk[&(fO[i]tf7ngla 4V}AlƟsG~/"v#3<_Z.}_DX8[.S5F@Қڒmy F:>UobqV\wi;k^D}m ,^\x~A'ƬYӏFhIC z>ʹ$?\W&bN;ec0%֬gH/eKIΌvȣ+ki.yO/xk4;VЏRȘ۫y&=& ܀6_@Etppu93s\=שEPO(}ɥEx?/Ǹin#v\]!M5KbYy5^~UJr 6Be`QY,}Eva*jp?~%. 缻Fbs(bCI'NwU悽9n RH9ԺvKړ#nܹ|F-K %3J LT+;K2}'u!ܜd1QQi< O~P}xOƣ x{3H[5M&Vګcu3 ҥp"FYNp`Cx2N exrUchpN'zZ-6l|4p/=y_^iDskD}}G=n۹]2zʤ_`4᭴L6g8w39g}6E6/}SyIu12 sK㹫녉8;;9F%*r o|쟛ږԖƀIpnEV儋矌*L?"TQ=,$x:n4 )ln=m;VmI@ nZ:Vl-l+M :ޓ\Iե6B4E*oMZXBooHDui$.!uIm`nBo# ^ "@A$u`Gg3k\q8<. A@}W)iމ8¥aL2LQ[ZPu)0*H-J i|-:Jvsv^wZYo?~$O׺tAu@;]jF{FkjFjun;~;R* R t@ȴ WВy64:'T҃J;Ѡ'E3/D|$AH$(rY1fY[IsR+(+~݉8fESj9cj`KY=7$l-] ŚZ?6mFW@5@&1/*Y^e47lj(a @AZv J KHBeA&!nƘA`Dlv: u"b@HXK7iۧZE2KPExTmi 4 FCOZCF ߞхnkpZ=kߜ6'ZrL'Z:R82ڢ7F=B-֑yzG<b8UMnZvKmh E,74aXz=:-k?(gJ :WpXG,z]뮲tfD hW?G3[#Ȯ㉴5Oa fVe)<ݽ9Ou4s"ki=? k42FNa),]_*\okv0~ۚA5I5X$'AXq}@c} x1*9QhZЁ{=td*Ԇۄ4 v_ AMtwꂲ葁C 0:IPч3*VAlvF[Ͽ˵RX"f~P_VKYZ8Al#2n"$!(ux.3/U^mn+o 1zw|i nK]E[{ &b[hf2@J9j!Ćp8tKk T*Շ)N70ؕ6J)7ɑ&[rn}EG={V#˕:CJS?yLxsôdU3^M kWo<eӥaq)1K@n\׆G ?;$rG6oL| gXs̻eeee;awwwwwwO**k*6c*7I9_snϾTVݭޭj}O{m.bfC_o gG?癃X~C1#`t,MlyLQrC_!qLCTz Z}h=)~+F~ᤡ1he[ ]OC0n ;ʀ[2 Ɩ D$%LeT~CemskAG-׍hbuUE$~(ѴDEϝxSdPE,lAgYcB[|l~.ݹsӰ;2Wb~msU/S}X#kMg5e)=,_ڵ_dl`PB=ΗN>fl3ZzWօ6gҙ:ƶMYx:r09MXBgmqr6ە_IGO'Ozvhu\i`z7n4{wdϟA@& kmgrg.U#?r[^' FlNT!; R  bjz{'zN3l3hbBpFcg:9`s iRh8ߩ"ԿUuBW@v~ _Yi+E"x,7 ~ zc^,ΟMr{\[S6 N'h~\kBWIfH8d|8m'DsɽfxaȇvɊV,*W#{~١3j5HKf__2Eۜ@}N.^ڥ~#-@ okHq6~{1PA)]Sa |maJ\t;t!- 'k-e{(s6- .n(we¤Ƶ4 6GMmQwq)mipC~0ǶZol'ܨA'fc<ѣS-v:2ztJM.__ǢMӏjg?t;?_7_no791lr P ݣ=/.dZqanc_ޗЀp̍U k$uYv@u I8"Xq#[#ط$Nm:fG BU /@Dz\?IpdߦF04¦;pxڋW?Zmku[zԷrw=v/BϿ]-lw+;T뿑]<ؘ5~qê: 6K~g_?|+=z{H*ȯ}?~o͌_۵.r6'_oqjf3&mVZhBPa êJ0[Ka:gK6{Ul^3gGkA՞QQ]߰"ˮΟ]2>3r\oޔ3ޒS?)@x9~]LٖU]2[^( D XLPY(,~?q  0@pz# %|rR>m!Je~_%.S4x| 5iƼb9>f5:<'Iv έ ;';6{DQFn_DD))+ vk_r&\Ō[,QtZV):)C@ش |4}|\ʞ!P>HxM `g^c]Lo./(*^U>ΐ2#n19|,o(y3Noe4 < dajS&C=1xx ZD8!UL89!Sg.\9(IIR I!.aVϣGuw}[2+l̯rз`r"_!oЖ~s "k#h _x6;7UD[V@>+, ؄BtU[spKIu~\1kW *I892)5nwB T:!y֤7.B&aIɒΦ ~Mbh4&Q:y`Rbp#g}e;L!L ~dR?;߱@!=N)׃{ o_+Y.t_oI (Ъ^5zmC\ɌlXj4H>)u}\6?J/"6@~ҟ2FzF;-tQýq %!'X wި3s~gRe3JjSĬbn8p ^3vpӗoUnKo|&U>үWRFKG