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

}y8AUgSdv.J6M^Ӥslm%$hHl'd&D  z>Hh+74eieJd, Bڶ{֘'~R"ܹcG#fgNiJDjariJsMye4 GQ4 ;p<~0_ ENwX 5ͦpi]pƀ^zH/{RY~ϏG օ挭!&t\+GR}7C# `'Q>,>ˬ}\()[nϊ}xfM&ӷ"A_]BRMi-~]cvA!(V]T]Cc`X"%}%).cLC͚F:XaX9δ~ʻㄵc1ZrNTh$2$)Wi(pNhL.$c?B٧oU?\Us^`y;GW@^ـ-Ѱ݊|M l l 0c9ZaYֳ_z=`F7dǹwzշՇe7X?;)ounͦ5>ܲ6~+Ǡ4ƷFo[;FɡP‘eߚV i}?!; 쭤hm[[Av>qGpIBr":XMSˋfb` tW 0ͱs%)fʘؔt9!snZ$LnR)X1 ʪ3yN)lv) y"($d)qIK*Em$RȊXȪ.b* ًH-4ZȊ/2ȏ(UFי(8pӀ)Wb jH -^us^*YG.PKf,崩Ʌ|,72!wЖD4f A:rS~aXf|Oܩ0?~ P)2dوXO==ŸT$nSlm0k< y~|b-m㙹oҺƸ"QZ$-;7ewφPR 9Naidd= tFb0q5"HߧV:]Z]o-jiԪ55Tglj;@f}g!vY ؑ(c\m p:f@?0 \ =mmV9ɚΝ8 9 ;U*0zE"§5ճEyXfSo3BH"hНކmLBs!$*#^mS5[jHRnV$zM+pA!n6HoƶjKk/Bh jJDx`4(FDR>HXXsRO\scKmoj.F9ֶ*~ӮFUcgcY}ws+3 UX0/p u3fF{|GY` qnsL ITV\[a`G5Ђ @P^*&62Œ ,cs##m+ʁK u MlLi5ozAjҏ~-QToNFzTa,(`@R.$1a`R1P͝4Q{he8\֢H-8EPkfa"o o`jr%5v;`*ln-i ԛ@lȆ,!+]<+t~#-$,b\fl-ibt hnW$le4BŵAOQ„ s?pyRTmg̼An%j- ni|R$iKg!!Pv dRq l9]x p*ʧ*ĕyBΖ&`$&]ey׺0]8Rrʈ]qiԂ^M,^-*Ja9@RS$B6Ъvt$44W愵Ǫd;gI TIL)2LXJR0lAUWx 34ZAFRyH_ݑ 1"^libXcDž;DXO!‘ssL]Es_&=6$FQF.UcY`Eh8˰RR8?tUU6tH٨"e 9C"b|w5t[# ʬ'/+JKpī--ߪ *ZVC1"BJ^sXDqERޛ-nR^#7}MpJVwdָ t]jKmw;߱╵ѝ꼅{WDsY4o޴ݫZ2{a/EWqn[[r7]v Wa6]u#u[QuSVQR7-Y\빤ޕ?WÒe;JǪͻxVUUI^ 2[z79[l-[&K睪GWYgQ-A\>↘8w":3e˶Π7NnY6X1Ô,zٛFLVߘrK$E3 @&cdʿO^<?u;y>1J~u!ֈpٖէ4kCFT?@&,.3璮|%AV_wz*xEzo2zÑ)S~.C@"]d?WT/7 ~kⒷ20Pگ|PnF+$>E@FNs<>HTO ZZΠ+[[ }୭=D/G X4 <1M3J:ImڈN@UOؗoWYʬROT*4Dr?xމ4Ekk$7͌K"ÙhU0.9X%lFD,@5сzVKT<( |8)3:~ʒ ~(C)s 48IV;&a8!rSE Q%sCiLc6#!&4B7X$Mz&H]œ< P|]\1E: y*L ׃YBu<0^Tpz2kE[we?1XiD[T@ blط>'e@5pL>ɕO(Dc <_NԯQi5e+q7| ZJp$j $I>a:Q{Hfr A .>vu8/fg `:D3S3C>Xd$?[!UY?CztAI>ՏwpJqKrU-t=cI񻂙| )2)#@~bz|FR4|o(>gk"vȟˬ!]e/6jtFs@ >#ʏ?D'B}-;awC1Ыȟ]3r0JLlR&hQ#P`,oW.u}3Ñ3fuj3nX9dش0q@8WC0]9~7J  s)/ʩ2z"='ƪ 63M]78N֒DŽ kbE28f7Y:>Q􁃷YMxNJVB+2(OV 9RG\Q6mPs`sa&@DY]pYIdkO@ۇB*w.+Y.ׇ r@}RxnH 9W.`58`fF[+sQ{t _puCuA++~E2I$Ľ -r%}>> R&h9*XX & 9oO$YFA?xﺿ=1̵t3$$"-oP_<yC,0xSvV}˰kGKjSuO@7F]}]cD:0AIɘA GkPɜqb]x̖ LQ9c蹿:PJes{uT5L>2w!`HsfHw]ELAabJ7#\^elA{FQ@ƒյPSk~Z?4>ea4V/ ݼI^.۷\[@%ԆNҳN_V_Lo];Y0RutwMZ{-=PԌ>"2lp0DCF#pߏ/s \ݣH%&+1hEg!8\`H& v(؄H S{L L0/FRcL~=@2/@ pd0R1x#eljD5![Ur,cV:zM^?/grAfmCk#tb&Ohëɛ0C5>3h/B|HZBskk!G8oA-_a="]PEHO/|35P:!R\Mf1 30)O\L)`P"1)f,&gbGB,fBR@+ YAIAL0)0A>h(PTJ7!qwCxi٘|  ]iTLe:2F$U4 ^FsG63_XOO)>yzz HFΎxl(ĥFF>j.ˤl&ɔܷ 3A(FK{Orn숀1T>EIY0#YOFI<#Yuc$6n^:,r2)ĸL0:8.Է U.0:70% pq'?G[ͽ%:L…dh9j<6-[pozm7-"mbhqHRA:{Pqጀw6U\7֊, ,y=t_(B!l5R Ss̵%E E^ޠWPT]n->v-1tTqrN3Nԏ5ӌ&x}sT{cĐϊpTExu߰$NfB:H L%hpv`6 ML|#S R8a &ᯜJ*&z?p:ה}]1Z‚wx3CEy GD-,kh-dōW"셴iT}Qz5~Na_:d78ˬ=ub -R3 j*p&v+f6eqsS+؆u`m+5F܁CDŽ~UFFKibbߋ}]_[1U/rR,=|A>-#}W(_kkokkz DNjf'V}\8!y_ ea4ֿp?}wG-8A3>maq^Y`Cw6~jšr\v6Qi[Q$ >ppYD28RC>ǵE7(Z!"H dMVp+|9YZvY (`17,7D"^h‹d =k 2MEwga@?yФ eD jZ&ė}״nR ?Z[ܻ @@J:,] d1*vƔ,̖A&t?0]rgܝY\0_m'f.imҝۧyƖ`NKcx)`qE7B=# y~ # FQ `{*g X2hR:ŜSs@(eoq+yMIL;` iA-d^k*E,y4QhᆞTqS@1D_ C͐t| ]QchYCG{.)™U܂0Wbɷ>[Jyխx7qr' E=X\Eړx졻yul`<00B0pg8YEx ~biU4L&!pa1cQ"zw+ߙ**MJ;D,H߰f( >Z7W!1]^D"nd&N+{f-0BxJqN CM6]-&< D%P0Bן+ d1AFvfP<<5YgµW1q6뫙_>N.[0MKx4_(9gq}%_v3!Xjm5m=R01pDp5kx+e`Ti|5ʈqi`/Lf',Q.?QXgINE 'N{9M}=S0O& h1tN.V=oLHFvo?J"~T@fPޞۓq8+J7býsZ0?k/@f6s2k/.x+2 ϵxO\n`O ]p_jmU3}݅'NM /* >e:V6X&hǖI2mb[@}c4Jtp}7"?[zCo7K|l,-_ | 5 ,y>>FLJOUZ_ܑ]矷2d4)j5F3lwT\GX{qv5D0l~ԾT@ix6xp%S_om2F$wM$[G?^\g@Ϡ:ײ`of_s= YNB˫erXgIÃ!5.dʿtCo26%K`<+W:#zsmlI ge\#[{GJSc nShjf$Bc=:!zICg*dxOTI܁Cp/0a@b* ,@޻7DÚf#i]QIEʜ*^a%'TܠyhtW4/J /v="c5sd֐a-FP 3FOxh<Iƿt >L'W zBHf)9̟bp:?-S_aG#EWӱef?oG*'`A^Ii s#>{K 0NISA C `GkG>0lZBG5#,%g.-TmqF0\KfM^\*cqPXB$&`Cz(Y%76U$$/ˊy|l`CJy A83-e4<ʒS-W&\yA} {<ʤ>Y{d h[?J  |Y4HzjR0Wj~Ȼ Dт %.{u/ȷHM~ۛ/?o͗7_N\:jʧ= 91#y~q׀"pCLzSi4fZ#_V50H7>AKO20R*+dd*.KKyF>,{.eLj+ϙO]4!da0ΜTn^JB h5 *CkD"g5+ qzX5(/ftagBPGioD %:wdq|Q9ss3l"R j% l6EW'uYR!N)юDcs,p4” qݼ1؞A+4{o,t4Ԛd6FAXia\!ū!;Ёw`:P!]/8iaM. Woϊ@Ѥz8. W^{22bx(u}IF##'wrt3rI- >;Lxs.®)myw^C/5!JVBM> Z HeFX FW "/Bm{!;r.@iM= GK+nC lEHGn0.51% 1pjɈJM%FǶ\fYYc\!mScm )ݥ "&ݹ$nH\Xk.>KV/+:]łiֈſ>k,gG\" "p%vDd$?1P=oy1jͥ$vi`uIG$=#V]LN]=h7bT2.7&!?,9WΏgl\Ji_KfF~F`VFb}W\~Xw)=VA9<0lUcܮnIh } k$aGuƦ*g,U.oZ-!a~$^gI;ş'CX}H_=Ϗ2K\A6ؙtqy\-4lռds-Dخ-xV.`?y+~zeðt;X%U&WߞYooLZ%@Ys]2n7 #FNֲ;(?V7,˦IJ%4qj=.1wGUXqBFރ inġ̮0IL_@2.YқO&%pRa@'ώ4 ,*L%yXebd83 4^ωk;2 o>EcWk<PJ"5Sa~H5{2LЉW@{)}dlУq* +D`19R=g~U:fmRIm}[Uj2-ٲtah\/YNkV c )YZSγ( (h8gI~`=+2nE 9o{*|{M_[F.Z`;鋸9wZ|#0v3'NF]AjGŭ..Iq%d;o:W["Yhm&x= M h4 W޾0Z['U!$=:+NGab gyv"Do/~~ƃx4qL"?/軯йկKt} 3N4Ek d'.G+ Bv®XʨX;ax"[ v!u,fJ ռBr(Ub#Ů'bV4U4ʨ)r_W6OߔLae!=چQz`.1utjāioG~/0VX!2Icb p/x;@N'3,mr(X 6,Z,FYxRs"žHyw.+]P@wAZ=]AZQK;\kž"f7˲7d?5ƟװZIfX`8Y)3#4e9#o_}yҘa7v;TP_.P>-w*O Ko*֥X=~GD/޿?:(=xtUaJ23@4->]Ab9SKB --^hTQ4[ka(poy7F;.ll4~5Ȳkߓ]<7_>]܉U9ual3XS 3|߱S?eUVq7hKU1bD;ޟͮa/Үq^My@ו8븪fW,RוgꮴW43Wѭ1ky77,9ѭ+1/s%5n{~[̻{P-b၌;7Wզ-v-ha4wK7GTTKW9+TK#`\\uLjOuq|%Rjfޥ~u@@3 ȿGxAglB+ 07XM+-T>p 0@r:J^(WiU}@ 璡.&ş,йm[Դ*w(<ɼO|k+R{0 .q]\]vwkqȇ' 4suIlK[ ~ՃBP`O');ucItT!I>$.zԥ+H): ?6`Q$wd,#U|N\`6>(:r=_J7ɂ'3Uf0 f2t{ Ϗ{=ZDYe;R1;tz![9uRXG5sP,Iijm4._kk_̨#+şLtߘTfB;hGz8#ҭj'?]ѷ#@?j{ 5]t/aFޠ-s #^z+f(j(3#>v307FsˁA+HQ#\)ob; >=ԺeVr@u]1 O`˜DP!XIԍzuጧcɛ!MQ6Sq?i' Ҕoαa'Dho_BQ0^7gFe1;;i S2}O"g|cRm͙(z5ND1cvuV6%ؒ&chP:?