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

~60w=0LkK5IY 7&ۜq~(PJR>{-|W tݵ$0 >~ooHh}+71e?)Y6ȒFS+Yd?v$ݳf̔Ov:HF1N;6;qFLEr<'r,W GLI k;.iƦ^Z댬Z{g3TS.A @zʘ]d\ȁuUU0,ܒL22[W2B?3\\EZFO5wOqiܩD`勤9;jL3vfVd(f9 dž)>1QE䫡*NTǃ3u;a@L# IՋx8^mQg?WwjߓBo_!}_sF0t'u y~х&P7b6wcx"_UɰRW !g ` *+0Tyf;YމCki =۶9eϠ;"VWt*( >@눮= zGuA[V0FޡB*FE7`pΒ*w('zϰN"ӹ+Z ]i .CyQ{E>T\2IB0F3F$3[tQLc-avo%/Z9qld`'--_]0c;ĭ }bV@U?m6Q`$n{ ֨fk/9Q7Eh2fCUNg u{rUMȎS-kdu{e(;\ ouNn̦5kwvG"Bs0kvcYMˡp@S˾1F4=ۋF bt;qv>2UU#%j5g@ń(MĀM`S_g3Da9V (Kj« x}X*{Y,( )0f0ac-v `C*veҝ](ODR=;9fs8N\f|@Ɲt%!_2hf6F~@:焆Pfg}?WGO,`ª݅x#Ls\C-2~oʃl͐9׭ڵ$LnR)mY1MUgrK+'- *s%R "yK"px$!,% TO[VNc^J/Rd,[9Ȋ^{:f [EA6{ +pA4s +VvG~8r0?Y50D3Yz!TP]KhY=@3t^:r?Z ǠRhӦgwJ<Ȅ6F!-_$ i\)50x#wa6 UP4@ qP/OjJawS'0*_ L@1kIۊx<(qJF1JXQ 0+b-ӶfY6$0ƫ%ZHҲ_ӹP-;>{6"4biwrLK$'b3ʼ+A֗:KZc-PCmF@ c-jnzkzؗz5] ؗU/c5vGE8y3r9F0ӵN9`+s0LEQM8 ުfX!Pd4\]Dq;C{4l>2k~l}W1:dc4ڀ?v0RGSǵW ހiB^5zmcEa&3feFm;w%XjB/ @#]5(ֵ5)65,etp5着z93ntDS7KICkjzORDviHbKX&p8HȂqsTE5 *>|80/ ]\s}ˎsxS" TbyΌ~tES _h4;m@ /SL>?@á8 Uj;Ge7e(w;@d$t /9wlRNiRNWpЄj:"w":1e˶@M/0mݲ l柰b)OX 9\DLV^rK'E3L@&mdʿ/^|Gߚo=+:y#\/(?b>e4͚f#*_z0,3N|hXVȒ8]jʏ_|ą H2Lg@kM@2,5Oa (ih4qwF(̼[WǤ|I|lMPyxtG@")R<%4+ba_;?Nkcogn'd~9ՋE4_UfH [?}}0z5H)`V?"Z<祥4u;;$7͌K"+ѪjD_^ocd1- `IѕJ#3`+:>ZA*Kp{h  @'4+C G$SzJ!07Z{~uEt ~<Ŧ:$+'"D994 \`%L_3H$ jzp{EՔ^)gCh%n*AmȊ 2 .&}C4 C! MS ԁ ܇.N'tO3Q\)!Z#I XTi؛텘 _- *kC(qW AR" \$;;xR^̻ %;FAeRFi7BU支ARll-\ι0gdF2kbqsH(@V< _?EK o=ܭP' $ލS?V*y`渫8R 7؁"Qt![r FGVTxSB<{c 6gFG;;cB@hjaE2З8g7Y: <:8f/Aї<ℹo Z #r Hr*09H{z}k UMq_kEq@}p# )Q2tFUep+G3CJd)88g(w]^g-$Tј #4[.GA`kc`Q~ ~p't@D1c<?؛MoATHt[=]&{܏H"69\X /H"{X d>7e [%_^:RR]Y(OHXQ<&tU?:^<1AYᓣq OMA's^}~=Y2[C0EYޙ@)%0@U„#sցT:x8ǎ̵6QEmJ(iM+!fT.0uFD'%*AS X 3vt#gbܽEibZP)3έ%y-T~w4V20CA Z\fHAkUĔoFf8p``5GL}قT ] Gƞnf+P  k`Xyj):S`0E3A{n;;ODk޽yJ& d0hV5WYuN{Ѧ]:O% ^6ʟ My\$nu=z{Y,{V~e 7:x5n3k~_yێj)%okra ~_0z ʧn^Ym=\[@%ĆNܳfHVL kݓ}Y0RuTໃs)큔s˄ j5く C qD``L特uIyU2JGyU1|jpuIe%&ia{od`#N270`8F_K л1y0y. 2%NII#CGI`9u:?dV NaN ?fTJ&~P ?p#)!ojȫfy6SfPwq.DL(FQ壃 L )K߯\Md1L2$)O\L(`P"1)`fDLa1bX\RY)()#j2 $ !w糡Ҳ1; 籃#ʃ8gGo|%o?$YnUyfXQR, <>> B$3 X=P2 -",b+!O依ņFWw+,ۿ_V/<X"V40U/tɺ?= bdqظ xp}ebwq)#d('w=ٱ!40,ie8 9=ո[$\8Ll6`Pkozv"r_F{{ F^J7U)L;K8#,pAM",t_(B!l5T̕ EN E~F%(1OiiuqL9UXY`yC?oāQdfѰ\QI(6pw_WLB{U#0%s#uJIDŭ4(GɟYqq!FK1RʯSVށ|./g`qʲ)~OK @KL*O˚9Li.A%JMIがRC,A7;RhfuKĚ# K,X2M͜H@)~l+2ee!FLaelNukzC` ŎrŒI& ϐ=aTabH(|W9GzVo*ףp* W'ҕwzt-Mo.Ȅ"L05<wlI.v^)h5ag@l;Wn&MI ’W:⁄qr+OLaKpK1 䀴dɰ-Rˍr*!p2<`ʀ hG?k̅MRy*$!ŹK4&nƥ3/+0b+# Jb3$I.cn$R"ݕ]:9Yjo_TЊmhC ph&=Asg' 釈5dn rw QH%qaԶBhQEU)Vt}92TMt sY{*f*J2 0 TpNbO;&8cqX pq/, pdT+9F \9 Y!//>';((ju )yQ+*](%#oRN, 4) U"!'k\<Ɉ'(O */_"u*Ef/y?&6'ˊ܃^mѩ3ٹx>^8!y_ eµI4>p?}wG-8g./}>@^p s26XJal2vUyT/LfvH XpJ6k/QB 13`By7SʗXˮ#+b6 Β楝PRī"MxQz0|15y,IpTa颂Q XsZ7N)P&wxqs]0:(It/-ƨSR\0[]엊t(Oȁ_pwfeʇXvBa➆&ݥ}'l#ľ4<l;߉fVظgd!/o٠QvֈD&p(X 1&v?aoulRf2L ~@%q}7"vkM_q+xɦWpPا0dJ2]Uul}rtkz+,ͧs E}YN`;WPr͖bqm!ޱA PR힛O#=#mƽ2F$gM$[sG;d~z8^[Aea=aRD.pk3ۜkXzjNDÚ7 >˪ B{l&}xsP p@y$ t}-zǔ l!u4]k<Shr7W9: ώ  A!S?k>m> `nXx5+蠟L^Cr4}Z7unHבּ8jF/cR= Џ5COͰ"K$+|C_*Aަ1H]<8$/4ile7W)jP%iVev=)G%! HsjU3Vivk4dm< ]4;#=dք~1A'lz+%=83ga1mʠ'-%z>(gp]i*wɳ}-ѕߔ6 yE~HKnUv$$!XyBPh9SOi0vw>w ҧ** f.* $Ȫ9BPUx@mg C8R2Z3_VV^{4!"ZDS$\usF 鴝sE4~LVəԟDq8μ'8%1,T]PMȉɎ[dz3K~H2U5-MThĿVR2D {w)Ay0T < Pv(hShVn"UTyhtUr:-cqP LXdI./^tbP+t)#Xþ27W OU$XmHt_/ěC.|l12'%J&ϲ(Zn6p+KVn6jmYJ,^PV٨^5Y#VD(!fg+vCŵ!t?3 #ݤw9_-e`v+{fSTʦKwJѵa [B+2x'wwmcdF9F)Kh<'ΤyVt\񌗖f?1_\%N~x[<>t̔њ9+ĉ)wqZz9ƏyY6R  gݦi9xBBM_k-ێ7[E":Sq1x.DS~' j<z?S bPq#!D#Ab8s{8?,x؜%ݻM}2NF80A)k䏙f!P|\UiX(ԜJr<\AWm<3DY@BBq<CV"뀞 fSjs1YWFFޯΆ 1vLOt$ʤ["g35_D0)`dn[3 }Ms|c!ٹj/Ȭcѡ)k w^ U1*VpGJ) bO )^Xb#}Zoʲ|y?DnII~Gf$u6mb?IBss@; {tȆ(1<įMNiTiF-Ga&j2cK ;-L0囖k$g+L'"`$N\xazu]m֮v͖UZV atڣ.d;#ٍfFc8MU߹Wot9 !zq+S?w.$*$Ž[}iXRqQ} !鴙lj e㱷qlmjGaD,;7A zjD%`H93'ZPZ;hQZ][ %HC '7AE[A9,}(,5ޱ7w&"}+8ws>1vB! o(c!XfaBR"tCeqԫ&qDN!%P}"s-%=*^DF," IxH\9 t(llu&=G[L fR]Kx!.Y@:.ci&cf q;xH }탏+\xA''7' K@:7Dz.ksM蓄Ձ<$Oγĥ1 ;cB掅ʵ|>:"/IVo1c[.M5W2]o4mCzmLC|j4ӕvK%,KtǏbޅ#tw3I9Q_axN-<8el.?gqc]. @ꦯ6|W_Ҥm+Ip)q?][%rKivש6Rik5G gvSwFOMY/<BwO%Az@2`v0w]TI,3i3{gP!ǝ5v|CrU[ch'Ds'N&MjZ-6l|w79~XEzVJ?FNt|A۵.-LAJ>4*`s3 p s{MSdP)!~՛23Ŷ(nbr2#sUέ8f&T;mgF^Qo v?3e-- +X O,'b|C:?OߣL~"bVd^S% G%HxfȢYԕ]*K'&@xq?v@`5q>p1A >,>;e\F'^d2w,u;+uhd4ޭY =UZ `5FnOkvh'aITۆ,.z Lz5꠵4Q261@7@ / Q\vu$cTB쨠f)j*9 Pz7="l4n@vkAdUT ;mmAmCc:!Z/nW;(~hd;U'gݓ}Ҟ6O6<ͩ,;mgI'冯QH,]Og981sט):Yձp5Rdӭ% p \\T|e1X.4OLjY8RK0Q=eOx+Kۮ߮EEn].$vvvpVybveveveveveV)uhpe['*}aoo o׊EEۛ.%h͉Nl6+M)j=sl>TwHnZb3'ޯM *? b2J_6L0]f'g6:IoD- H#YqAp/ m DjlGlps5\uOP/ :zqCE)X.=jwZT1.A.~w>2-qT?:WJ#*v _s/+`{!Jܸ uN`Dܯ!xO$65E |*-3#Gx_)rߤb'm|/Q]b]uT|i}*pBZOZJI:Q,m^'[SXQKI9hx&&GMmQq)mi,d?cqjEb^jSMNKX/͗b5tWi]?c]/Iᒚk;ΫAPI: q7nzϟ.蕾WHE$V6Vn"ݯs+KtQxEC#G,%)O?Z^qku[z{TPs;R|ruM6}"C%q?[?KJK\2n=Y_C78JjGz'oo<DclcXg{!;|Cp:/08:5b.+-fUVF d ؊0{SG½M\xu_>)3/5raW{FF}~,:MvY3?pˬ_|XSgz wLE94ȱS/e[Vqjj@̊_.w@k\@I,!e?eܪ耙zlb Qٝ[3gQS}3%^վ>#0J'zGYS_gx fwSm!xWu/K<5?:~fa#rPykZpҵ(4#~.NX[˜-lt`[?_1u6)<+˛_9x,m:2[^( D XLPY(,^Qy8 Q8OVo(WdeӶ2De?aؒPQKP)MH<4cނ?"1|iۚ$\zΆ քӓs=JL(#g 'z/ZP”B}Ro9Vdab˭q qzE(Rtk0fj|7 |וT^bGbVy& M)E9K, ~$HiY}%<̜.HGuᄹ,M`J-+ܿ! l1>\^R.dϏ(y(c{P03|/ފbz}.& wm*]e  !k~H6 hƌSdA٣+Ef0 xpɐ{FJ|C/AR'-݆:m9<\i& Z0fhWK-md<$ŘLOb0J8\vYBdJ@r:ZsQEFL?wvNf<FxʌP?ޱzmˀJd 1Aߺ蒟A[ḿH+Kz>lvfzU4: